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.SysUser;
import com.ydtech.modules.admin.model.dto.*;
import com.ydtech.modules.admin.model.report.company.*;
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.*;
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.dto.SubOrderCountDTO;
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);

    IPage<TaskStatisticsDto> getBusinessData( @Param("page") Page page,@Param("vo")  TaskStatisticsVo taskStatisticsVo);

    TaskStatisticsDto getDistribution(@Param("vo")  TaskStatisticsVo taskStatisticsVo);


    Long insuranceCompanyQueryTotal(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);

    Long queryPageTaskStatisticsTotal(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);

    QxFrontlineAgentDto getOrderManpowerNew( @Param("vo") QxFrontlineAgentDto qxFrontlineAgentDto);

    QxFrontlineAgentDto getChannelOrderManpowerNew(@Param("vo") QxFrontlineAgentDto qxFrontlineAgentDto);

    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/8/30 10:22
     *  @Description:  通过用户id查询金额数据
     */
    Double  getOrderPremiumByUserIds(@Param("vo") QxFrontlineAgentVo qxFrontlineAgentVo);
    /**
     *  @version
     *  @author: whp
     *  @Date: 2024/8/31 15:35
     *  @Description:   查询控制台大订单
     */
    Page<OrdersDataDto> querOrdersDataPage(@Param("vo") OrdersDataVo ordersDataVo,@Param("page") Page<OrdersDataDto> page);
    /**
     *  @version
     *  @author: whp
     *  @Date: 2024/8/31 15:35
     *  @Description:   查询控制台大订合计
     */
    OrdersDataDto querOrdersamountTo( @Param("vo") OrdersDataVo ordersDataVo);

    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/8/30 10:22
     *  @Description:  通过用户id查询金额数据
     */
    TaskStatisticsDto numberQuotationsByUserIds(@Param("ids") List<String>  ids,@Param("month") String month);

    OrdersDataDto querResultOrderNumber(@Param("vo") OrdersDataVo ordersDataVo);

    /**
     *   代理人统计查询
     * @param taskStatisticsVo
     * @return
     */
    Long agentStatisticsQueryPageTotal(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);

    Long queryCompanyQutationCountDataPageTotal(@Param("vo") CompanyQutationCountDataQueryDto companyQutationCountDataQueryDto);


    CompanyQutationCountDataDto getInsAreaCompanyError(@Param("vo") CompanyQutationCountDataQueryDto companyQutationCountDataQueryDto);


    List<OrdersDataDto> getOrdersGroupByLicenseno(@Param("vo") OrdersDataVo ordersDataVo);


    List<OrdersDataDto> selectByOrdersDataVo(@Param("vo") OrdersDataVo dtoParams);
        /**
     * @description:   任务统计-渠道导出
     * @author: whp
     * @date: 2024/09/09
     **/
    List<TaskStatisticsExcel> channelExcel(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     * @description:   任务统计-保险公司-导出
     * @author: whp
     * @date: 2024/9/9
     **/
    List<InsuranceCompanyExcel> insuranceCompanyExcel(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);

    IPage<AgencyUserInsAreaVo> queryAgencyUserInsAreaPage(Page page, @Param("dto")AgencyUserInsAreaDto agencyUserInsAreaDto);

    /** 通过 车牌号车架号获取小定单已承保数据
     *
     * @param ordersDataDto
     * @return
     */
    OrdersDataDto getSumBigOrderCount(@Param("vo") OrdersDataDto ordersDataDto);
    /**
     *  大订单导出查询
     * @param ordersDataDto
     * @return
     */
    List<OrdersDataExcel> querOrdersDataListExcel( @Param("vo") OrdersDataVo ordersDataVo);

    /***
     *
     * @param page
     * @param userId
     * @param rejectPageQueryVo
     * @return  查询已审核的外部订单
     */
    Page<InsAreaCompany> orderCheckPage(Page page, @Param("userId") String userId, @Param("vo") RejectPageQueryVo rejectPageQueryVo);

    /**
     * 获取子订单数量
     * @param orderNo 订单数量
     * @return 子订单数量
     */
    List<SubOrderCountDTO> getSubOrderCountDTO(List<String> orderNo);

    /**
     * @description:   财务中心-费用校验-合计
     * @author: whp
     * @date: 2024/9/28
     **/
    HashMap<String, Object> costCenterTotal(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/9/30 8:55
     *  @Description:  查询所有的驳回订单信息
     */
    Page<InsAreaCompany> getAllRejectOrders(@Param("page") Page page, @Param("vo") RejectPageQueryVo rejectPageQueryVo);
    /**
     * @description:   财务中心-费用校验-明细
     * @author: whp
     * @date: 2024/10/10
     **/
    IPage<TaskStatisticsDto> costCenterDetails(@Param("page") Page page,@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     * @description:   财务中心-费用校验-明细-查看
     * @author: whp
     * @date: 2024/10/10
     **/
    IPage<TaskStatisticsDto> costCenterDetailsLicense( @Param("page") Page page, @Param("taskStatisticsVo")  TaskStatisticsVo taskStatisticsVo);

    TaskStatisticsDtoNew costCenterSecond(@Param("taskStatisticsVo")TaskStatisticsVo taskStatisticsVo);

    List<TaskStatisticsDtoExcel> costCenterDetailsExcel(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     * @description:   电销任务统计查询
     * @author: whp
     * @date: 2024/10/11
     **/
    IPage<TaskStatisticsDto> queryPageElectric( @Param("page") Page page, @Param("taskStatisticsVo")  TaskStatisticsVo taskStatisticsVo);

    /**
     *
     * @param taskStatisticsVo
     * @return 电销合计
     */
    Long queryPageElectricTotal(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
    /**
     * @description:   控制台-业务数据-统计
     * @author: whp
     * @date: 2024/10/12
     **/
    TaskStatisticsDto getCountBusinessData(@Param("vo") TaskStatisticsVo taskStatisticsVo);

    /**
     * @param userId
     * @return  入口金额 出口金额  分销金额
     */
    InsAreaCompany getExpectNetProfit(@Param("vo") QxFrontlineAgentVo qxFrontlineAgentVo);

    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/10/17 10:57
     *  @Description: 查询已承保的保单数据
     */
    Page<InsOrders> queryPageOrderCB(@Param("page") Page<InsAreaCompany> page, @Param("params") OrderQueryVo orderQueryVo);

    /**
     *
     *
     * @param userId
     * @return  通过 用户id 获取1-3 级分销金额
     */
    HashMap<String, BigDecimal> getDistributionAllAmount(@Param("vo") QxFrontlineAgentVo qxFrontlineAgentVo);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/10/22 11:00
     *  @Description:  获取时间范围内的已承保的订单数据
     */
    List<InsAreaCompany> findListByDate(@Param("benginDate") String benginDate, @Param("endDate") String endDate);

    /**
     *
     * @param taskStatisticsVo
     * @return  出单人数
     */
    TaskStatisticsDto getUserNumber(@Param("vo") TaskStatisticsVo taskStatisticsVo);

    /**
     *
     * @param userId
     * @return  代课录单数
     */
    HashMap<String,Object> getSumEntryStatus(@Param("taskStatisticsVo") TaskStatisticsVo taskStatisticsVo);
}