| | |
| | | "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); |
| | |
| | | " LEFT JOIN sys_dept d ON p.dept_id = d.dept_id\n" + |
| | | " WHERE order_id = #{orderId} AND p.pro_parent_id <>0 AND o.is_return = #{type}") |
| | | List<ProFcListVo> getFcList(@Param("orderId") Long orderId, @Param("type") Integer type); |
| | | |
| | | |
| | | @Select("call newpacsJianChaData(#{tjnumber,mode=IN},1)") |
| | | List<TjOrderDetail> newgetDetailByOrderIdAndParId(String tjNumber); |
| | | } |