| | |
|---|
| | | " SELECT a.pro_id FROM tj_order_detail a WHERE !ISNULL(flowing_water_id) AND order_id=#{orderId})") |
|---|
| | | public List<TjProject> selectTjOrderDetailListByFlowingWaterIdIsNotNull(String orderId); |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 查询未缴费项目 |
|---|
| | | */ |
|---|
| | |
|---|
| | | "SELECT #{tjNum},b.cus_id,b.cus_name,'1633660948860522619','纯音听阈'," + |
|---|
| | | "#{userName},SYSDATE(),#{userId} FROM tb_transition a LEFT JOIN tj_customer b " + |
|---|
| | | "ON a.cus_id=b.cus_idcard WHERE a.cus_id=#{cusId} AND a.parent_pro_id IN('1633660948860522619') GROUP BY a.cus_id") |
|---|
| | | boolean saveTjPureToneTesByCusId(String cusId,String tjNum,String userName, String userId); |
|---|
| | | boolean saveTjPureToneTesByCusId(@Param("cusId")String cusId,@Param("tjNum")String tjNum,@Param("userName")String userName,@Param("userId") String userId); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Update("UPDATE tj_order_detail a SET\n" + |
|---|
