java-insagent-pc/src/main/java/com/ydtech/modules/order/dao/InsAreaCompanyMapper.java

package com.ydtech.modules.order.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ydtech.modules.admin.model.dto.AllpremiumDto;
import com.ydtech.modules.admin.model.dto.PremiumReportDto;
import com.ydtech.modules.admin.model.dto.QxFrontlineAgentDto;
import com.ydtech.modules.admin.model.dto.TaskStatisticsDto;
import com.ydtech.modules.admin.model.report.company.CompanyPremiumDataDto;
import com.ydtech.modules.admin.model.report.company.CompanyPremiumDataQueryDto;
import com.ydtech.modules.admin.model.report.company.CompanyQutationCountDataDto;
import com.ydtech.modules.admin.model.report.company.CompanyQutationCountDataQueryDto;
import com.ydtech.modules.admin.model.report.opetationData.BusinessDataDto;
import com.ydtech.modules.admin.model.report.opetationData.BusinessDataQueryDto;
import com.ydtech.modules.admin.model.report.opetationData.QuotationCountDataDto;
import com.ydtech.modules.admin.model.report.opetationData.QuotationCountQueryDto;
import com.ydtech.modules.admin.model.vo.SubOrder;
import com.ydtech.modules.admin.model.vo.TaskStatisticsVo;
import com.ydtech.modules.order.entity.InsAreaCompany;
import com.ydtech.modules.order.entity.InsOrders;
import com.ydtech.modules.order.entity.dto.InsAreaCompanyQueryDto;
import com.ydtech.modules.order.entity.vo.OrderQueryVo;
import com.ydtech.modules.order.entity.vo.RejectPageQueryVo;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.HashMap;
import java.util.List;

/**
 * @author Administrator
 * @description 针对表【ins_area_company(报价渠道)】的数据库操作Mapper
 * @createDate 2023-01-31 15:51:19
 * @Entity generator.domain.InsAreaCompany
 */
public interface InsAreaCompanyMapper extends BaseMapper<InsAreaCompany> {


    /**
     * 分组查询
     *
     * @param orderNo 订单号
     * @return
     */
    List<InsAreaCompanyQueryDto> selectByOrderNo(@Param("orderNo") String orderNo);

    /**
     * 查询承保的订单
     *
     * @param orderNo
     * @return
     */
    List<InsAreaCompanyQueryDto> selectAcceptInsurance(@Param("orderNo") String orderNo);

    /**
     * 查询最新订单的订单号
     *
     * @param orderNo 订单号
     * @return
     */
    String queryLatestStatus(@Param("orderNo") String orderNo);


    List<InsAreaCompany> getorDerIds();

    /**
     * 获取待审核的订单
     */
    Page<InsOrders> getAuditOrders(Page page, @Param("params") OrderQueryVo orderQueryVo);

    Page<InsOrders> getAlreadyAuditOrders(Page page, @Param("params") OrderQueryVo orderQueryVo);

    List<InsOrders> getByUserId(HashMap<String, Object> params);


    InsOrders selectFirstPromotionBy(HashMap<String, Object> params);

    InsOrders selectSecondPromotionBy(HashMap<String, Object> params);

    InsOrders selectThirdPromotionBy(HashMap<String, Object> params);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/5/14 11:50
     *  @Description:  更具日期查询数据
     */
    List<InsAreaCompany> selectListByDateStr(@Param("dateStr") String dateStr);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/5/14 19:13
     *  @Description: 通过子订单查询订单id
     */
    List<InsAreaCompany> selectListById(@Param("id") String id);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/3 11:44
     *  @Description:  通过状态查询预收和实收的金额
     */
    InsOrders selectSecondPromotionByNew(HashMap<String, Object> params);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/3 15:25
     *  @Description: 获取订单详情页面
     */
    SubOrder getSubOrderDetails(String subOrderId);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 16:19
     *  @Description: 保费报表统计
     */
    List<PremiumReportDto> premiumReportYear(HashMap<String,Object> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 16:19
     *  @Description: 保费报表统计
     */
    List<PremiumReportDto> premiumReportMonth(HashMap<String,Object> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 16:19
     *  @Description: 保费报表统计
     */
    List<PremiumReportDto> premiumReportDay(HashMap<String,Object> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/7 15:21
     *  @Description: 查询总的签单数
     */
    AllpremiumDto getAllpremium(@Param("year") String year,@Param("userId") String userId);

    /**
     * 获取审核驳回订单
     * @param page
     * @param userId
     * @return
     */
    Page<InsAreaCompany> getRejectOrder(Page page, @Param("userId") String userId, @Param("vo") RejectPageQueryVo rejectPageQueryVo);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/3 10:44
     *  @Description:  查询控制台页面业务数据
     */
    Page<BusinessDataDto> queryBusinessDataPage(@Param("vo") BusinessDataQueryDto businessDataQueryDto, @Param("page") Page<BusinessDataDto> page,@Param("userList") List<String> userList,@Param("flag") String flag);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/3 11:29
     *  @Description: 查询报价次数大订单的数据
     */
    Page<QuotationCountDataDto> queryQuotationOrderCountDataPage(@Param("vo") QuotationCountQueryDto quotationCountQueryDto, @Param("page") Page<QuotationCountDataDto> page, @Param("userList") List<String> userIds, @Param("flag") String flag);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/3 11:34
     *  @Description: 查询报价次数小订单的数据
     */
    Page<QuotationCountDataDto> queryQuotationSubOrderCountDataPage(@Param("vo") QuotationCountQueryDto quotationCountQueryDto, @Param("page") Page<QuotationCountDataDto> page, @Param("userList") List<String> userIds, @Param("flag") String flag);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/3 15:42
     *  @Description:  查询保险公司的签单保费
     */
    Page<CompanyPremiumDataDto> queryCompanyPremiumDataPage(@Param("vo") CompanyPremiumDataQueryDto companyPremiumDataQueryDto, @Param("page") Page<QuotationCountDataDto> page);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/3 16:04
     *  @Description:  查询保险公司的报价次数
     */
    Page<CompanyQutationCountDataDto> queryCompanyQutationCountDataPage(@Param("vo") CompanyQutationCountDataQueryDto companyQutationCountDataQueryDto, @Param("page") Page<QuotationCountDataDto> page);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/7/10 17:42
     *  @Description:  获取暂存订单的数据
     */
    Page<InsAreaCompany> getStageOrder(@Param("page") Page page, @Param("userId") String userId, @Param("vo") RejectPageQueryVo rejectPageQueryVo);

    IPage<TaskStatisticsDto> queryPageTaskStatistics(@Param("page") Page page, @Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     * @description:   保险公司统计查询
     * @author: whp
     * @date: 2024/7/25
     **/
    Page<TaskStatisticsDto> insuranceCompanyQueryPage(@Param("page") Page page,@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     * @description:   代理人统计查询
     * @author: whp
     * @date: 2024/7/26
     **/
    IPage<TaskStatisticsDto> agentStatisticsQueryPage(@Param("page") Page page, @Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     * @description:   财务中心-费用校验
     * @author: whp
     * @date: 2024/7/29
     **/
    IPage<TaskStatisticsDto> costCenter(@Param("page") Page page, @Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     *  @version
     *  @author: whp
     *  @Date: 2024/8/08
     *  @Description:  控制台出单人力
     */
    QxFrontlineAgentDto getOrderManpower(List<String> ids);

    QxFrontlineAgentDto getOrderManpowerByUserId(String id);

    /**
     *
     * @param userId
     * @return  查询用户报价次数
     */
    TaskStatisticsDto NumberQuotations(String userId);
    /**
     * @description:   保险公司统计总报价
     * @author: whp
     * @date: 2024/8/12
     **/
    IPage<TaskStatisticsDto> totalQuotation( @Param("page") Page page,@Param("vo") TaskStatisticsVo taskStatisticsVo);

}