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.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.vo.SubOrder;
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 org.apache.ibatis.annotations.Param;

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,String> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 16:19
     *  @Description: 保费报表统计
     */
    List<PremiumReportDto> premiumReportMonth(HashMap<String,String> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/5 16:19
     *  @Description: 保费报表统计
     */
    List<PremiumReportDto> premiumReportDay(HashMap<String,String> map);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/6/7 15:21
     *  @Description: 查询总的签单数
     */
    AllpremiumDto getAllpremium(@Param("year") String year,@Param("userId") String userId);
}