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.dto.TelemarketingAuditOrderDTO;
import com.ydtech.modules.order.entity.vo.*;
import com.ydtech.modules.order.entity.vo.telemarketing.TelemarketingAuditOrderQueryVo;
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, @Param("deptId") String deptId, @Param("isDxFlag") Boolean isDxFlag);

    Page<InsOrders> queryPageOrder(@Param("page") Page page, @Param("orderQueryVo") OrderQueryVo orderQueryVo,
                                   @Param("isTeamLeader") Boolean isTeamLeader, @Param("isCdy") Boolean isCdy, @Param("deptId") String deptId, @Param("isDxFlag") Boolean isDxFlag);

    /**
     * @param insOrdersExcelVo 查询条件
     * @description: 查询承保导出数据
     * @author: wenks
     * @date: 2024/11/5 11:11
     * @return: List<InsOrdersExcel> 数据列表
     **/
    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, @Param("agentUserIds") List<String> agentUserIds, @Param("agreeIds") List<String> agreeIds, @Param("deptIds") List<String> deptIds, @Param("flag") Boolean flag, @Param("type") int type);

    /**
     * @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, @Param("deptIds") List<String> deptIds, @Param("flag") Boolean flag, @Param("type") int type);

    /**
     * @version
     * @author: hxl
     * @Date: 2024/4/18 10:51
     * @Description: 查询子订单的数据
     */
    Page<InsOrders> queryPageSubOrders(@Param("page") Page<InsOrders> page, @Param("orderQueryVo") OrderTaskPoolsVo orderTaskPoolsVo);

    /**
     * @version
     * @author: hxl
     * @Date: 2024/4/18 11:13
     * @Description: 查询子订单的数据条数
     */
    Long queryPageSubOrdersCount(@Param("orderQueryVo") OrderTaskPoolsVo orderTaskPoolsVo);

    /**
     * @version
     * @author: hxl
     * @Date: 2024/5/8 18:05
     * @Description: 通过年查询数据
     */
    OrderVo selectEntityByinsOrderNo(@Param("insOrderNo") String insOrderNo, @Param("timeFiltering") String timeFiltering);

    int getExpirationInsureCount(@Param("userId") String userId, @Param("startDate") String startTime, @Param("endDate") String endTime, @Param("isJq") Integer isJq, @Param("param") String param);

    Page<OrderExpirationVo> getExpirationInsure(@Param("page") Page page, @Param("order") OrderExpirationQueryVo orderExpirationQueryVo);


    /**
     * 获取车险业务明细表
     *
     * @return
     */
    List<CarBusinessDetailVo> getCarBusinessDetailList(@Param("userId") String userId, @Param("param") CarBusinessDetailQueryVo carBusinessDetailQueryVo);

    /**
     * 获取收支明细表
     *
     * @param userId
     * @param carBusinessDetailQueryVo
     * @return
     */
    List<RevenueExpenditureDetailVo> getRevenueExpenditureDetailList(@Param("userId") String userId, @Param("param") CarBusinessDetailQueryVo carBusinessDetailQueryVo);

    /**
     * 获取财务审核明细列表
     *
     * @param auditExportQueryVo
     * @return
     */
    List<AuditExportVo> getAuditExportList(@Param("param") AuditExportQueryVo auditExportQueryVo);


    /**
     * 查找未删除的外部订单
     *
     * @param insOrdersEditingVo
     * @return
     */
    InsOrders getExternalOrder(@Param("param") InsOrdersEditingVo insOrdersEditingVo);

    List<QueryHxOrdersCountExcel> queryHxOrdersCount(@Param("queryHxOrdersCountVo") QueryHxOrdersCountVo queryHxOrdersCountVo);

    /**
     * @param telemarketingAuditOrderQueryVo 电销审核状态查询实体
     * @param userId                         用户id
     * @return
     */
    List<TelemarketingAuditOrderDTO> getTelemarketingAudit(@Param("telemarketingAuditOrderQueryVo") TelemarketingAuditOrderQueryVo telemarketingAuditOrderQueryVo, @Param("userId") String userId);

    /**
     * 查询某个时间段的车牌号
     *
     * @param queryLicenseInOrderVo 查询车牌实体
     * @return 车牌号列表
     */
    List<String> queryLicense(@Param("queryLicenseInOrderVo") QueryLicenseInOrderVo queryLicenseInOrderVo, @Param("userId") String userId);

    /**
     * 查询某个时间段的被保人
     *
     * @param queryInsuredInOrderVo 查询被保人实体
     * @param userId                用户id
     * @return 被保人列表
     */
    List<String> queryInsured(@Param("queryInsuredInOrderVo") QueryLicenseInOrderVo queryInsuredInOrderVo, String userId);

    /**
     * 根据业务类型查询数据
     *
     * @param orderQueryVo 订单查询信息
     * @param agentUserIds 管理人员列表
     * @param agreeIds     管理区域
     * @param code         业务类型
     * @return
     */
    List<InsOrders> queryOrderByLinkType(
            @Param("orderQueryVo") OrderQueryVo orderQueryVo,
            @Param("agentUserIds") List<String> agentUserIds,
            @Param("agreeIds") List<String> agreeIds,
            @Param("type") Integer code,
            @Param("flag") Boolean flag
    );
}