From b2e1069da3667e1b72dee6dd14d736fc70f1b0ca Mon Sep 17 00:00:00 2001
From: mrzcc <121184950@qq.com>
Date: 星期二, 18 二月 2020 11:34:16 +0800
Subject: [PATCH] 优化巡检计划sql查询
---
java110-utils/src/main/java/com/java110/utils/constant/BusinessTypeConstant.java | 438 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 438 insertions(+), 0 deletions(-)
diff --git a/java110-utils/src/main/java/com/java110/utils/constant/BusinessTypeConstant.java b/java110-utils/src/main/java/com/java110/utils/constant/BusinessTypeConstant.java
index f208d5f..3618e51 100644
--- a/java110-utils/src/main/java/com/java110/utils/constant/BusinessTypeConstant.java
+++ b/java110-utils/src/main/java/com/java110/utils/constant/BusinessTypeConstant.java
@@ -108,6 +108,24 @@
public static final String BUSINESS_TYPE_DELETE_OWNER_CAR = "111200050001";
+ /**
+ * 淇濆瓨杞﹁締榛戠櫧鍚嶅崟
+ */
+ public static final String BUSINESS_TYPE_SAVE_CAR_BLACK_WHITE = "112200030001";
+
+ /**
+ * 淇敼杞﹁締榛戠櫧鍚嶅崟
+ */
+ public static final String BUSINESS_TYPE_UPDATE_CAR_BLACK_WHITE = "112200040001";
+
+
+ /**
+ * 鍒犻櫎杞﹁締榛戠櫧鍚嶅崟
+ */
+ public static final String BUSINESS_TYPE_DELETE_CAR_BLACK_WHITE = "112200050001";
+
+
+
@@ -280,6 +298,22 @@
public static final String BUSINESS_TYPE_DELETE_ROOM_INFO = "530100050001";
/**
+ * 澧炲姞鍋滆溅鍦�
+ */
+ public static final String BUSINESS_TYPE_SAVE_PARKING_AREA = "541100030001";
+
+ /**
+ * 淇敼杞︿綅
+ */
+ public static final String BUSINESS_TYPE_UPDATE_PARKING_AREA = "541100040001";
+
+
+ /**
+ * 鍒犻櫎杞︿綅
+ */
+ public static final String BUSINESS_TYPE_DELETE_PARKING_AREA = "541100050001";
+
+ /**
* 澧炲姞杞︿綅
*/
public static final String BUSINESS_TYPE_SAVE_PARKING_SPACE = "540100030001";
@@ -294,6 +328,39 @@
* 鍒犻櫎杞︿綅
*/
public static final String BUSINESS_TYPE_DELETE_PARKING_SPACE = "540100050001";
+
+ /**
+ * 娣诲姞杩涘満璁板綍
+ */
+ public static final String BUSINESS_TYPE_SAVE_CAR_INOUT = "541110030001";
+
+ /**
+ * 淇敼杞︿綅
+ */
+ public static final String BUSINESS_TYPE_UPDATE_CAR_INOUT = "541110040001";
+
+
+ /**
+ * 鍒犻櫎杞︿綅
+ */
+ public static final String BUSINESS_TYPE_DELETE_CAR_INOUT = "541110050001";
+
+
+ /**
+ * 娣诲姞杩涘満璁板綍璇︽儏
+ */
+ public static final String BUSINESS_TYPE_SAVE_CAR_INOUT_DETAIL = "541120030001";
+
+ /**
+ * 淇敼杩涘満璁板綍璇︽儏
+ */
+ public static final String BUSINESS_TYPE_UPDATE_CAR_INOUT_DETAIL = "541120040001";
+
+
+ /**
+ * 鍒犻櫎杩涘満璁板綍璇︽儏
+ */
+ public static final String BUSINESS_TYPE_DELETE_CAR_INOUT_DETAIL = "541120050001";
/**
@@ -451,4 +518,375 @@
*/
public static final String BUSINESS_TYPE_DELETE_VISIT ="120100050001";
+
+ /**
+ * 淇濆瓨鎶ヤ慨淇℃伅
+ * 11寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_REPAIR="130100030001";
+ /**
+ * 淇敼鎶ヤ慨淇℃伅 11寮�澶� 4淇敼
+ */
+ public static final String BUSINESS_TYPE_UPDATE_REPAIR="130100040001";
+ /**
+ * 鍒犻櫎鎶ヤ慨淇℃伅 11寮�澶� 5淇敼
+ */
+ public static final String BUSINESS_TYPE_DELETE_REPAIR ="130100050001";
+
+
+ /**
+ * 淇濅慨娲惧崟淇℃伅
+ * 11寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_REPAIR_USER="130200030001";
+ /**
+ * 淇濅慨娲惧崟鍙樻洿 11寮�澶� 4淇敼
+ */
+ public static final String BUSINESS_TYPE_UPDATE_REPAIR_USER="130200040001";
+ /**
+ * 浣滃簾淇濅慨娲惧崟淇℃伅 11寮�澶� 5淇敼
+ */
+ public static final String BUSINESS_TYPE_DELETE_REPAIR_USER ="130200050001";
+
+
+ /**
+ * 淇濆瓨缁勭粐
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_ORG="140100030001";
+ /**
+ * 淇敼缁勭粐
+ */
+ public static final String BUSINESS_TYPE_UPDATE_ORG="140100040001";
+ /**
+ * 鍒犻櫎缁勭粐
+ */
+ public static final String BUSINESS_TYPE_DELETE_ORG ="140100050001";
+
+
+ /**
+ * 淇濆瓨鍛樺伐缁勭粐鍏崇郴
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_ORG_STAFF_REL="140200030001";
+
+ public static final String BUSINESS_TYPE_UPDATE_ORG_STAFF_REL="140200040001";
+ /**
+ * 鍒犻櫎鍛樺伐缁勭粐鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_DELETE_ORG_STAFF_REL ="140200050001";
+
+ /**
+ * 淇濆瓨鍛樺伐缁勭粐鍏崇郴
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_ORG_COMMUNITY="140300030001";
+
+ public static final String BUSINESS_TYPE_UPDATE_ORG_COMMUNITY="140300040001";
+ /**
+ * 鍒犻櫎鍛樺伐缁勭粐鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_DELETE_ORG_COMMUNITY ="140300050001";
+
+ /**
+ * 淇濆瓨 璧勬簮
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_RESOURCE_STORE="150200030001";
+
+ /**
+ * 淇敼璧勬簮
+ */
+ public static final String BUSINESS_TYPE_UPDATE_RESOURCE_STORE="150200040001";
+ /**
+ * 鍒犻櫎璧勬簮
+ */
+ public static final String BUSINESS_TYPE_DELETE_RESOURCE_STORE ="150200050001";
+
+
+ /**
+ * 淇濆瓨 瀹℃牳鐢ㄦ埛
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_AUDIT_USER="160200030001";
+
+ /**
+ * 淇敼 瀹℃牳鐢ㄦ埛
+ */
+ public static final String BUSINESS_TYPE_UPDATE_AUDIT_USER="160200040001";
+ /**
+ * 鍒犻櫎 瀹℃牳鐢ㄦ埛
+ */
+ public static final String BUSINESS_TYPE_DELETE_AUDIT_USER ="160200050001";
+
+
+ /**
+ * 淇濆瓨 瀹℃牳鐢ㄦ埛
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_AUDIT_MESSAGE="170200030001";
+
+ /**
+ * 淇敼 瀹℃牳鐢ㄦ埛
+ */
+ public static final String BUSINESS_TYPE_UPDATE_AUDIT_MESSAGE="170200040001";
+ /**
+ * 鍒犻櫎 瀹℃牳鐢ㄦ埛
+ */
+ public static final String BUSINESS_TYPE_DELETE_AUDIT_MESSAGE ="170200050001";
+
+ /**
+ * 鍚姩宸ヤ綔娴佹祦绋�
+ */
+ public static final String BUSINESS_TYPE_START_PROCESS ="180200030001";
+ /* public static final String BUSINESS_TYPE_DELETE_AUDIT_MESSAGE ="170200050001";
+ public static final String BUSINESS_TYPE_DELETE_AUDIT_MESSAGE ="170200050001";
+*/
+
+ /**
+ * 淇濆瓨 鎶曡瘔鎰忚
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_COMPLAINT="190200030001";
+
+ /**
+ * 淇敼 鎶曡瘔鎰忚
+ */
+ public static final String BUSINESS_TYPE_UPDATE_COMPLAINT="190200040001";
+ /**
+ * 鍒犻櫎 鎶曡瘔鎰忚
+ */
+ public static final String BUSINESS_TYPE_DELETE_COMPLAINT ="190200050001";
+
+
+ /**
+ * 淇濆瓨 璁惧
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_MACHINE="200200030001";
+
+ /**
+ * 淇敼 璁惧
+ */
+ public static final String BUSINESS_TYPE_UPDATE_MACHINE="200200040001";
+ /**
+ * 鍒犻櫎 璁惧
+ */
+ public static final String BUSINESS_TYPE_DELETE_MACHINE ="200200050001";
+
+ /**
+ * 淇濆瓨 璁惧鍚屾
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_MACHINE_TRANSLATE="210200030001";
+
+ /**
+ * 淇敼 璁惧
+ */
+ public static final String BUSINESS_TYPE_UPDATE_MACHINE_TRANSLATE="210200040001";
+ /**
+ * 鍒犻櫎 璁惧
+ */
+ public static final String BUSINESS_TYPE_DELETE_MACHINE_TRANSLATE ="210200050001";
+
+
+ /**
+ * 淇濆瓨 鏂囦欢淇濆瓨鍏崇郴
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_FILE_REL="220200030001";
+
+ /**
+ * 淇敼 鏂囦欢淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_UPDATE_FILE_REL="220200040001";
+ /**
+ * 鍒犻櫎 鏂囦欢淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_DELETE_FILE_REL ="220200050001";
+
+ /**
+ * 淇濆瓨 鏂囦欢淇濆瓨鍏崇郴
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_MACHINE_RECORD="230200030001";
+
+ /**
+ * 淇敼 鏂囦欢淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_UPDATE_MACHINE_RECORD="230200040001";
+ /**
+ * 鍒犻櫎 鏂囦欢淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_DELETE_MACHINE_RECORD ="230200050001";
+
+ /**
+ * 淇濆瓨 鏂囦欢淇濆瓨鍏崇郴
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_APPLICATION_KEY="240200030001";
+
+ /**
+ * 淇敼 鏂囦欢淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_UPDATE_APPLICATION_KEY="240200040001";
+ /**
+ * 鍒犻櫎 鏂囦欢淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_DELETE_APPLICATION_KEY ="240200050001";
+
+ /**
+ * 淇濆瓨 娑堟伅淇濆瓨鍏崇郴
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_MSG="250200030001";
+
+ /**
+ * 淇敼 娑堟伅淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_UPDATE_MSG="250200040001";
+ /**
+ * 鍒犻櫎 娑堟伅_MSG_MSG淇濆瓨鍏崇郴
+ */
+ public static final String BUSINESS_TYPE_DELETE_MSG ="250200050001";
+
+ /**
+ * 淇濆瓨 娑堟伅闃呰
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_MSG_READ="260200030001";
+
+ /**
+ * 淇敼 娑堟伅闃呰
+ */
+ public static final String BUSINESS_TYPE_UPDATE_MSG_READ="260200040001";
+ /**
+ * 鍒犻櫎 娑堟伅闃呰
+ */
+ public static final String BUSINESS_TYPE_DELETE_MSG_READ ="260200050001";
+
+ /**
+ * 淇濆瓨骞垮憡
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_ADVERT="270200030001";
+
+ /**
+ * 淇敼骞垮憡
+ */
+ public static final String BUSINESS_TYPE_UPDATE_ADVERT="270200040001";
+ /**
+ * 鍒犻櫎骞垮憡
+ */
+ public static final String BUSINESS_TYPE_DELETE_ADVERT ="270200050001";
+
+ /**
+ * 淇濆瓨骞垮憡
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_ADVERT_ITEM="271200030001";
+
+ /**
+ * 淇敼骞垮憡
+ */
+ public static final String BUSINESS_TYPE_UPDATE_ADVERT_ITEM="271200040001";
+ /**
+ * 鍒犻櫎骞垮憡
+ */
+ public static final String BUSINESS_TYPE_DELETE_ADVERT_ITEM ="271200050001";
+
+
+ /**
+ * 淇濆瓨骞垮憡
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_OWNER_APP_USER="280200030001";
+
+ /**
+ * 淇敼骞垮憡
+ */
+ public static final String BUSINESS_TYPE_UPDATE_OWNER_APP_USER="280200040001";
+ /**
+ * 鍒犻櫎骞垮憡
+ */
+ public static final String BUSINESS_TYPE_DELETE_OWNER_APP_USER ="280200050001";
+
+
+ /**
+ * 淇濆瓨娲诲姩
+ * 14寮�澶� 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_ACTIVITIES="290200030001";
+
+ /**
+ * 淇敼娲诲姩
+ */
+ public static final String BUSINESS_TYPE_UPDATE_ACTIVITIES="290200040001";
+ /**
+ * 鍒犻櫎娲诲姩
+ */
+ public static final String BUSINESS_TYPE_DELETE_ACTIVITIES ="290200050001";
+
+
+ /**
+ * 淇濆瓨宸℃鐐�
+ */
+ public static final String BUSINESS_TYPE_SAVE_INSPECTION="510200030001";
+
+ /**
+ * 淇敼宸℃鐐�
+ */
+ public static final String BUSINESS_TYPE_UPDATE_INSPECTION="510200040001";
+ /**
+ * 鍒犻櫎宸℃鐐�
+ */
+ public static final String BUSINESS_TYPE_DELETE_INSPECTION ="510200050001";
+
+ /**
+ * 淇濆瓨宸℃璺嚎
+ * 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_INSPECTION_ROUTE="500200030001";
+
+ /**
+ * 淇敼宸℃璺嚎
+ * 4 淇敼
+ */
+ public static final String BUSINESS_TYPE_UPDATE_INSPECTION_ROUTE="500200040001";
+ /**
+ * 鍒犻櫎宸℃璺嚎
+ * 5 鍒犻櫎
+ */
+ public static final String BUSINESS_TYPE_DELETE_INSPECTION_ROUTE ="500200050001";
+ /**
+ * 淇濆瓨宸℃璺嚎璁惧鍏宠仈鍏崇郴
+ * 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_INSPECTION_ROUTE_MACHINE_REL="500200030002";
+
+ /**
+ * 鍒犻櫎宸℃璺嚎璁惧鍏宠仈鍏崇郴
+ * 5 鍒犻櫎
+ */
+ public static final String BUSINESS_TYPE_DELETE_INSPECTION_ROUTE_MACHINE_REL ="500200050002";
+
+
+ /**
+ * 淇濆瓨宸℃璁″垝
+ * 3淇濆瓨
+ */
+ public static final String BUSINESS_TYPE_SAVE_INSPECTION_PLAN="520200030001";
+
+ /**
+ * 淇敼宸℃璁″垝
+ * 4 淇敼
+ */
+ public static final String BUSINESS_TYPE_UPDATE_INSPECTION_PLAN="520200040001";
+ /**
+ * 鍒犻櫎宸¤鍒�
+ * 5 鍒犻櫎
+ */
+ public static final String BUSINESS_TYPE_DELETE_INSPECTION_PLAN ="520200050001";
+
+
}
--
Gitblit v1.8.0