package com.ydtech.modules.fnc.dao;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ydtech.modules.fnc.entity.InsPlyIncome;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ydtech.modules.fnc.entity.InsPlySettleDetail;
import com.ydtech.modules.fnc.vo.InsPlyIncomeVo;
import com.ydtech.modules.fnc.vo.InsPlySettleVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.List;

/**
 * <p>
 * 保司结算手续费 Mapper 接口
 * </p>
 *
 * @author gws
 * @since 2024-01-05
 */
@Mapper
public interface InsPlyIncomeMapper extends BaseMapper<InsPlyIncome> {

    @Select({"<script>"," " +
            "select a.*,b.`name` dept_name ,c.`name` companyName " +
            "from ins_ply_income a " +
            "left join sys_dept b on a.dept_id=b.id " +
            "left join esm_ins_company c on a.company_id=c.id " +
            "where 1=1 " +
            "<if test='startDate!=null and endDate!=null'>" +
            "and DATE_FORMAT(pay_date, '%Y-%m-%d') " +
            "between DATE_FORMAT(#{startDate}, '%Y-%m-%d') and DATE_FORMAT(#{endDate}, '%Y-%m-%d')" +
            "</if> "+
            "<if test='companyId!=\"\" and companyId!=null '>" +
            "   and a.company_id=#{companyId} " +
            "</if> "+
            "<if test='deptId!=\"\" and deptId!=null '>" +
            "   and a.dept_id like  CONCAT(#{deptId}, '%') " +
            "</if> "+
            "<if test='agreementId!=\"\" and agreementId!=null '>" +
            "   and a.agreement_id=#{agreementId} " +
            "</if> "+
            //待结算清单
            "<if test='flag==\"0\" '>" +
            "   and a.all_fee_value!=IFNULL(a.final_fee_value,0)+IFNULL(a.doing_fee_value,0)" +
            "</if> "+
            "<if test='licenseno!=\"\" and licenseno!=null '>" +
            "   and a.licenseno=#{licenseno} " +
            "</if> "
            ,"</script>"}
    )
    List<InsPlyIncome> selectByCondition(InsPlyIncomeVo insPlyIncomeVo);

    @Select({
            "select a.*,b.`name` dept_name ,c.`name` companyName " +
            "from ins_ply_income a " +
            "left join sys_dept b on a.dept_id=b.id " +
            "left join esm_ins_company c on a.company_id=c.id " +
            "where a.policyno= #{policyno}"
            }
    )
    InsPlyIncome selectByPlyno(String policyno);

    @Select({"<script>"," " +
            "select a.settleno,i.*,b.`name` dept_name ,c.`name` companyName " +
            "from ins_ply_settle_detail a " +
            "inner join ins_ply_income i on a.policyno=i.policyno " +
            "left join sys_dept b on i.dept_id=b.id " +
            "left join esm_ins_company c on i.company_id=c.id " +
            "where a.settleno =#{settleno} "
            ,"</script>"}
    )
    List<InsPlyIncome> selectSettleByCondition(InsPlySettleVo insPlySettleVo);



    List<InsPlyIncome> queryNew(HashMap<String, Object> params);

    List<InsPlyIncome> totalQuery(HashMap<String, Object> params);

    void uopdateByOrderno(InsPlyIncome insPlyIncome);

    List<InsPlyIncome> NonSettlementQuery(HashMap<String, Object> params);

    InsPlyIncome totalAmount(HashMap<String, Object> params);

    List<InsPlyIncome> totalPinAmount(HashMap<String, Object> params);

    List<InsPlyIncome> totalBxAmount(HashMap<String, Object> params);

    InsPlyIncome queryInvoicing(HashMap<String, Object> params);

    List<InsPlyIncome> allOtherAmount(HashMap<String, Object> params);


    List<InsPlyIncome> findByLicenseno(HashMap<String, Object> params);

    InsPlyIncome bxTotalAmount(HashMap<String, Object> params);


}