package com.idea.oa.apply.mapper;

import com.idea.oa.apply.model.inout.ApplyUseMoneyIn;
import com.idea.oa.costManage.model.ExpenseLedger;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public interface ApplyUseMoneyExtendMapper {
    @Select("SELECT flow_main_push.push_user_key as pushUserKey,flow_main_push.id AS flowMainPushId,frame_user.truename AS createdByString,flow_main_push.flow_main_id AS flowMainId,pro_main.proName AS proMainName,apply_use_money.*FROM flow_main_push LEFT JOIN apply_use_money ON apply_use_money.id=flow_main_push.form_id LEFT JOIN pro_main ON pro_main.id=apply_use_money.pro_id LEFT JOIN frame_user ON frame_user.id=apply_use_money.created_by WHERE flow_main_push.id=#{flowMainPushId}")
    ApplyUseMoneyIn getInfoByFlowMainPushId(String flowMainPushId);
    @Select("SELECT flow_main.id AS flowMainId,frame_user.truename AS createdByString,pro_main.proName AS proMainName,flow_main_push.push_user_key,apply_use_money.*FROM flow_main LEFT JOIN apply_use_money ON apply_use_money.id=flow_main.form_id LEFT JOIN pro_main ON pro_main.id=apply_use_money.pro_id LEFT JOIN frame_user ON frame_user.id=apply_use_money.created_by LEFT JOIN flow_main_push ON flow_main_push.flow_main_id=flow_main.id AND flow_main_push.STATUS=0 WHERE flow_main.id=#{flowMainId} GROUP BY flow_main.id")
    ApplyUseMoneyIn getInfoByFlowMainId(String flowMainId);
    @Select("select aum.pro_id as  proId,b.proName as proName, a.fee_type as expenseType, a.fee_money as expenseAmount,a.created_at as happenDate, fu.truename as applyUser,fu.id as createUser, a.updated_by as updateUser,b.group_id as groupId" +
            " from apply_use_money_detail a LEFT JOIN apply_use_money aum on a.use_money_id = aum.id" +
            " LEFT JOIN pro_main b ON aum.pro_id = b.id" +
            " LEFT JOIN frame_user fu ON fu.id = a.created_by WHERE aum.id=#{flowMainId}")
    List<ExpenseLedger> getUserMoneyByMoneyId(String flowMainId);
}