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, @Param("agentUserIds") List<String> agentUserIds,  @Param("agreeIds") List<String> agreeIds,@Param("deptIds") List<String> deptIds,@Param("flag") Boolean flag);
    /**
     *  @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);
    /**
     *  @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("userId") String userId,@Param("startDate") String startTime,@Param("endDate") String endTime,@Param("isJq")Integer isJq,@Param("param") String param);


    /**
     * 获取车险业务明细表
     * @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);

}