From f2162e182405184e14bfa8d628150ccc49318fc3 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期一, 19 五月 2025 17:11:54 +0800
Subject: [PATCH] 总检页面增加体检类型搜索调整了存储过程

---
 ltkj-admin/src/main/resources/sql/职业病.sql |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git "a/ltkj-admin/src/main/resources/sql/\350\201\214\344\270\232\347\227\205.sql" "b/ltkj-admin/src/main/resources/sql/\350\201\214\344\270\232\347\227\205.sql"
index f526cda..7bbf4c6 100644
--- "a/ltkj-admin/src/main/resources/sql/\350\201\214\344\270\232\347\227\205.sql"
+++ "b/ltkj-admin/src/main/resources/sql/\350\201\214\344\270\232\347\227\205.sql"
@@ -20,4 +20,18 @@
 ALTER TABLE tj_order ADD COLUMN zhiye_jl VARCHAR(255) NULL COMMENT '鑱屼笟缁撹';
 ALTER TABLE tj_order ADD COLUMN zhiye_jg VARCHAR(255) NULL COMMENT '鑱屼笟缁撴灉';
 
+# 瀛樺偍杩囩▼淇敼
+# tj_check_list
+# 澧炲姞鍙傛暟浠ュ強鏈�缁堢粨鏋滈泦杩斿洖澧炲姞鏉′欢
+# 鍦∣UT鍙傛暟鍓嶅鍔狅細
+IN p_tjCategory VARCHAR(100)
+# 鏈�缁堣繑鍥炴潯浠舵煡璇�
+-- 璁＄畻鎬昏鏁�
+select count(tjNumber) into total from ls_check_list WHERE (p_tjCategory IS NULL OR tjCategory = p_tjCategory);
+-- 鎵ц鍒嗛〉鏌ヨ骞惰繑鍥炵粨鏋滈泦
+if checkStatus =0 THEN
+select * from ls_check_list WHERE (p_tjCategory IS NULL OR tjCategory = p_tjCategory) ORDER BY finishTime DESC LIMIT  page,pageSize;
+ELSE
+select * from ls_check_list WHERE (p_tjCategory IS NULL OR tjCategory = p_tjCategory) ORDER BY shsj DESC LIMIT  page,pageSize;
+END if;
 

--
Gitblit v1.8.0