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 { OrderVo getOrderAndAreaCompany(String companyId); InsOrders getByUseridAndLicenseNo(VerifyOrdersVo verifyOrdersVo); Long queryPageOrderCount(@Param("orderQueryVo") OrderQueryVo orderQueryVo, @Param("isTeamLeader") Boolean isTeamLeader,@Param("isCdy")Boolean isCdy); Page queryPageOrder(@Param("page") Page page,@Param("orderQueryVo") OrderQueryVo orderQueryVo, @Param("isTeamLeader") Boolean isTeamLeader,@Param("isCdy")Boolean isCdy); List queryOrderList(InsOrdersExcelVo insOrdersExcelVo); Page getPolicyInsuranceReport(@Param("page") Page page,@Param("policyReqVo")PolicyInsuranceReportReqVo policyInsuranceReportReqVo); List 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 queryPageHospitalityOrder(@Param("page") Page 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 queryPageOrderByLinkType(@Param("page") Page page,@Param("orderQueryVo") OrderQueryVo orderQueryVo, @Param("agentUserIds") List agentUserIds, @Param("agreeIds") List agreeIds,@Param("deptIds") List 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 agentUserIds, @Param("agreeIds") List agreeIds,@Param("deptIds") List deptIds,@Param("flag") Boolean flag); /** * @version * @author: hxl * @Date: 2024/4/18 10:51 * @Description: 查询子订单的数据 */ Page queryPageSubOrders(@Param("page") Page 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); }