| | |
| | | public TjPackage getTjPackageByPacId(String pacId); |
| | | |
| | | |
| | | @Select("SELECT * FROM tj_package WHERE !locate(\"女\",pac_name) and !locate(\"孕\",pac_name) and !locate(\"妇\",pac_name) and !locate(\"产\",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort DESC") |
| | | @Select("SELECT * FROM tj_package WHERE !locate(\"女\",pac_name) and !locate(\"孕\",pac_name) and !locate(\"妇\",pac_name) and !locate(\"产\",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort") |
| | | List<TjPackage> getTjPackageListByMan(); |
| | | |
| | | @Select("SELECT * FROM tj_package WHERE !locate(\"男\",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort DESC") |
| | | @Select("SELECT * FROM tj_package WHERE !locate(\"男\",pac_name) and pac_status=0 AND deleted =0 ORDER BY sort") |
| | | List<TjPackage> getTjPackageListByWoMan(); |
| | | |
| | | |
| | |
| | | "on b.pro_id=c.pro_id\n" + |
| | | "WHERE !locate(\"女\",a.pac_name) and !locate(\"孕\",a.pac_name) and !locate(\"妇\",a.pac_name) and !locate(\"产\",a.pac_name) and a.pac_status=0 AND a.deleted =0 and a.pac_name like concat('%',#{name},'%')\n" + |
| | | "GROUP BY a.pac_id\n" + |
| | | "ORDER BY a.sort DESC;\n") |
| | | "ORDER BY a.sort;\n") |
| | | List<TjPackage> getPacListBySqlAndMan(String pacName); |
| | | |
| | | @Select("SELECT a.pac_id,a.pac_name,a.price,GROUP_CONCAT(distinct c.pro_name SEPARATOR ',') AS allProName\n" + |
| | |
| | | "on b.pro_id=c.pro_id\n" + |
| | | "WHERE !locate(\"男\",a.pac_name) and a.pac_status=0 AND a.deleted =0 and a.pac_name like concat('%',#{name},'%')\n" + |
| | | "GROUP BY a.pac_id\n" + |
| | | "ORDER BY a.sort DESC;\n") |
| | | "ORDER BY a.sort;\n") |
| | | List<TjPackage> getPacListBySqlAndWomen(String pacName); |
| | | |
| | | |
| | |
| | | " on b.pro_id=c.pro_id\n" + |
| | | " WHERE a.pac_status=0 AND a.deleted =0 and a.pac_name like concat('%',#{name},'%')\n" + |
| | | " GROUP BY a.pac_id\n" + |
| | | " ORDER BY a.sort DESC;") |
| | | " ORDER BY a.sort;") |
| | | List<TjPackage> getPacListBySqlAndAll(String pacName); |
| | | |
| | | |