java-insagent-pc/src/main/java/com/ydtech/modules/fnc/dao/InsPlyIncomeMapper.java

package com.ydtech.modules.fnc.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ydtech.modules.admin.model.report.financialReceivables.FinancialReceivablesAllMonthVo;
import com.ydtech.modules.admin.model.report.financialReceivables.FinancialReceivablesQueryMonthVo;
import com.ydtech.modules.admin.model.report.financialReceivables.FinancialReceivablesQueryVo;
import com.ydtech.modules.admin.model.report.financialReceivables.FinancialReceivablesVo;
import com.ydtech.modules.admin.model.report.profitAnalysis.ProfitAnalysisDto;
import com.ydtech.modules.admin.model.report.profitAnalysis.ProfitAnalysisQueryDto;
import com.ydtech.modules.fnc.dto.PlatformSettlementRecordDto;
import com.ydtech.modules.fnc.entity.InsPlyIncome;
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.math.BigDecimal;
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);

    HashMap<String,Object> 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);


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

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


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

    InsPlyIncome getById (@Param("id") String id);

    /**
     *
     * @param idArr   开票的id
     * @return
     */
    List<HashMap<String,Object>> groupByInvoic(HashMap<String,Object> params);


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

    List<HashMap<String,Object>> getOtherIds(HashMap<String, Object> params);

    InsPlyIncome getEntityById(@Param("id") String id);

    void updateByIds(String[] split);

    List<HashMap<String,Object>> otherTimeDetail(HashMap<String, Object> params);

    InsPlyIncome ptTotalAmount(HashMap<String, Object> params);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/18 10:15
     *  @Description: 根据合作公司id和结算状态查询数据
     */
    List<PlatformSettlementRecordDto> platformSettlementRecord(@Param("partnerCompaniesId") String partnerCompaniesId, @Param("handlingFeesStatus") String handlingFeesStatus,@Param("dockingPerson") String dockingPerson);


    /***
     *
     * @param insPlyIncomeVo
     * @return  返回私有 平台  应收 已收  未收
     */
    InsPlyIncome getTotalPtReceivables(InsPlyIncomeVo insPlyIncomeVo);

    /**
     *  根据签单日期月份分组
     * @param insPlyIncomeVo
     * @return   平台 私有  应收   已收
     */

    List<HashMap<String, Object>> ptSumGroupByMonth(HashMap<String, Object> params);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/31 18:04
     *  @Description: 查询数据
     */
    List<ProfitAnalysisDto> queryPage( @Param("vo") ProfitAnalysisQueryDto profitAnalysisQueryDto);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/8/1 12:09
     *  @Description:  查询应收总数据
     */
    BigDecimal queryDateByTypeSumAmount(@Param("vo") FinancialReceivablesQueryVo financialReceivablesQueryVo);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/8/1 12:16
     *  @Description:  查询应收列表数据 1-12月
     */
    List<FinancialReceivablesVo> queryDateByType(@Param("vo") FinancialReceivablesQueryVo financialReceivablesQueryVo);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/8/5 10:06
     *  @Description:  查询月份的统计数据
     */
    FinancialReceivablesAllMonthVo queryDateByTypeByMonth(FinancialReceivablesQueryMonthVo financialReceivablesQueryVo);
}