package com.idea.oa.apply.mapper;

import com.idea.oa.apply.model.inout.ApplyPaymentIn;
import com.idea.oa.outsource.model.OutOrderPay;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

@Component
public interface ApplyPaymentExtendMapper {
    @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,apply_payment.*FROM flow_main_push LEFT JOIN apply_payment ON apply_payment.id=flow_main_push.form_id LEFT JOIN frame_user ON frame_user.id=apply_payment.created_by WHERE flow_main_push.id=#{flowMainPushId}")
    ApplyPaymentIn getInfoByFlowMainPushId(String flowMainPushId);
    @Select("SELECT flow_main.id AS flowMainId,frame_user.truename AS createdByString,flow_main_push.push_user_key,apply_payment.*FROM flow_main LEFT JOIN apply_payment ON apply_payment.id=flow_main.form_id LEFT JOIN frame_user ON frame_user.id=apply_payment.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")
    ApplyPaymentIn getInfoByFlowMainId(String flowMainId);
    @Select("SELECT IFNULL(SUM(receiveAmount),0) from acc_receivable where acc_receivable.proId=#{proId}")
    Double getTotalMoneyByProId(String proId);
    @Select("SELECT IFNULL(SUM(pid_amount),0) FROM out_order_main WHERE out_order_main.pro_id=#{proId}")
    Double getTotalPayMoneyByProId(String proId);



    @Select("SELECT IFNULL(SUM(pid_amount),0) FROM out_order_main WHERE out_order_main.order_no=#{orderNo}")
    Double getTotalPayMoneyByOrderNo(String orderNo);

    @Select("select a.order_id as outOrderMainId ," +
            "       a.pay_time as payAt ," +
            "       a.pay_name as payName ," +
            "       a.pay_money as payAmount," +
            "       a.bill_money as invoice_amount," +
            "       a.bill_rate as rate," +
            "       a.bill_number as invoiceNo," +
            "       a.created_at as applyTime," +
            "       a.created_by as applyBy," +
            "       b.group_id as groupId" +
            " from apply_payment a left join out_order_main b ON a.order_id=b.id WHERE a.id=#{flowMainId}")
    OutOrderPay getApplyPaymentByFlowMainId(String flowMainId);

}