| | |
| | | "FROM `tj_order_detail` \n" + |
| | | "where order_id=#{orderId}\n" + |
| | | "and pro_id IN\n" + |
| | | "(select pro_id from tj_project where pro_parent_id=#{proParentId})") |
| | | "(select pro_id from tj_project where pro_parent_id=#{proParentId} and deleted=0 and pro_status=0)") |
| | | public List<TjOrderDetail> getDetailByOrderIdAndParId(@Param("orderId")Long orderId,@Param("proParentId")Long proParentId); |
| | | |
| | | public List<TjOrderDetail> getDetailByOrderIdAndParIds(@Param("orderId")Long orderId,@Param("proParentIds")List<Long> proParentIds); |