java-insagent-pc/src/main/java/com/ydtech/modules/order/dao/InsOrdersMapper.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.ins.model.InsOrdersExcel;
import com.ydtech.modules.ins.model.InsOrdersExcelVo;
import com.ydtech.modules.order.entity.InsOrders;
import com.ydtech.modules.order.entity.vo.*;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @author Administrator
 * @description 针对表【ins_orders(保险订单表)】的数据库操作Mapper
 * @createDate 2023-01-31 15:44:29
 * @Entity generator.domain.InsOrders
 */
public interface InsOrdersMapper extends BaseMapper<InsOrders> {

    OrderVo getOrderAndAreaCompany(String companyId);

    InsOrders getByUseridAndLicenseNo(VerifyOrdersVo verifyOrdersVo);

    Long queryPageOrderCount(@Param("orderQueryVo") OrderQueryVo orderQueryVo,
                             @Param("isTeamLeader") Boolean isTeamLeader,@Param("isCdy")Boolean isCdy);
    Page<InsOrders> queryPageOrder(@Param("page") Page page,@Param("orderQueryVo") OrderQueryVo orderQueryVo,
                                   @Param("isTeamLeader") Boolean isTeamLeader,@Param("isCdy")Boolean isCdy);

    List<InsOrdersExcel> queryOrderList(InsOrdersExcelVo insOrdersExcelVo);

    Page<PolicyInsuranceReportResVo> getPolicyInsuranceReport(@Param("page") Page page,@Param("policyReqVo")PolicyInsuranceReportReqVo policyInsuranceReportReqVo);

    List<PolicyInsuranceReportResVo> getPolicyInsuranceReport(@Param("policyReqVo")PolicyInsuranceReportReqVo policyInsuranceReportReqVo);

    Long getPolicyInsuranceReportCount(@Param("policyReqVo") PolicyInsuranceReportReqVo policyInsuranceReportReqVo);

    boolean updateStatus(@Param("orderno") String orderno, @Param("status") String status);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/17 15:41
     *  @Description: 通过用户id和订单状态查询订单信息
     */
    Page<InsOrders> queryPageHospitalityOrder(@Param("page") Page<InsOrders> page, @Param("orderQueryVo") OrderQueryVo orderQueryVo);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/17 15:43
     *  @Description: 通过用户id和订单状态查询订单信息总条数
     */
    Long queryPageHospitalityOrderCount(@Param("orderQueryVo") OrderQueryVo orderQueryVo);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/17 18:01
     *  @Description:  通过用户id查询订单、渠道、代理人、保险公司
     */
    Page<InsOrders> queryPageOrderByLinkType(@Param("page") Page<InsOrders> page,@Param("orderQueryVo") OrderQueryVo orderQueryVo, List<String> agentUserIds, List<String> agreeIds);
    /**
     *  @version
     *  @author: hxl
     *  @Date: 2024/4/17 18:36
     *  @Description: 通过用户id查询订单、渠道、代理人、保险公司条数
     */
    Long queryPageOrderByLinkTypeCount(@Param("orderQueryVo") OrderQueryVo orderQueryVo, @Param("agentUserIds")  List<String> agentUserIds, @Param("agreeIds")  List<String> agreeIds);
}