kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/service/IProductOrderDetailService.java
@@ -136,5 +136,12 @@ * @return */ PageResult<ProductEndVo>productEndList(Map<String, Object> params); /** * 获取一个科室所有的有效套餐 * @param departmentId * hospitalId * @return */ int getUserdProduct(Long hospitalId,Long departmentId); } kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/java/com/kidgrow/oprationcenter/service/impl/ProductOrderDetailServiceImpl.java
@@ -201,6 +201,10 @@ public List<OrderChartVo> proCountChart() { return baseMapper.proCountChart(); } @Override public int getUserdProduct(Long hospitalId, Long departmentId) { return baseMapper.getUserdProduct(hospitalId,departmentId); } /** *获取该科室下的所有的套餐信息 * @param params kidgrow-business/kidgrow-opration-center/kidgrow-opration-center-biz/src/main/resources/mapper/ProductOrderDetailMapper.xml
@@ -264,7 +264,42 @@ ORDER BY create_time DESC </select> <select id="getUserdProduct" resultType="int"> SELECT sum(total) FROM ( SELECT count(*) total FROM `product_order` order_order LEFT JOIN product_order_record record ON order_order.id = record.order_id WHERE order_order.hospital_id = #{hospitalId} AND order_order.department_id = #{departmentId} and record.pro_id!=1000000000000000000 AND order_order.is_del = 0 AND order_order.enabled = 1 AND record.is_del = 0 AND record.enabled = 1 AND record.pro_endtime>now() UNION ALL SELECT count(*) total FROM `product_order` order_order LEFT JOIN product_order_record record ON order_order.id = record.order_id WHERE order_order.hospital_id = #{hospitalId} AND record.is_share = 1 and record.pro_id!=1000000000000000000 AND order_order.is_del = 0 AND order_order.enabled = 1 AND record.is_del = 0 AND record.enabled = 1 AND record.pro_endtime>now() ) cc </select> <select id="productEndList" resultType="com.kidgrow.oprationcenter.vo.ProductEndVo"> SELECT id,