| | |
| | | |
| | | @Select("SELECT count(*) FROM tj_order WHERE tj_number = #{tjNum}") |
| | | int getOrderCountByTjNum(String tjNum); |
| | | |
| | | |
| | | |
| | | //存储过程专用接口(总检) |
| | | List<List<?>> getEsjCunChuGuoChengCustomerList(Map<String,Object> map); |
| | | |
| | | |
| | | @Select("SELECT * FROM tj_order WHERE tj_number = card_id ") |
| | | List<TjOrder> getOrderListBypiliangqiandaofasong(); |
| | | |
| | | |
| | | @Select("SELECT COUNT(*) FROM tj_order a WHERE a.deleted=0 AND " + |
| | | "(a.firm_id=#{compId} OR a.team_no=#{teamNo}) AND a.pac_id=#{pacId}") |
| | | Integer getTjTeamSelectRecordCount(@Param("teamNo") String teamNo,@Param("compId") String compId,@Param("pacId") String pacId); |
| | | |
| | | @Select(" SELECT aa.pacname pacname FROM (\n" + |
| | | " SELECT TRIM(a.pac_name) pacname FROM tj_package a WHERE a.pac_id=#{pacId}\n" + |
| | | " \n" + |
| | | " UNION \n" + |
| | | " \n" + |
| | | " SELECT TRIM(b.dw_dept_name) pacname FROM tj_dw_grouping b WHERE b.id=#{pacId}) aa GROUP BY aa.pacname\n" + |
| | | " ") |
| | | String getpacName(String pacId); |
| | | |
| | | |
| | | @Select(" SELECT SUM(a.paid_in) FROM tj_flowing_water a WHERE a.deleted=0 AND a.pay_stasus=1 AND a.order_id=#{orderId} ") |
| | | String gettjzj(Long orderId); |
| | | } |