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 |  325 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 325 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 7c6d971..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";
 
 
     /**
@@ -510,6 +577,18 @@
     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淇濆瓨
      */
@@ -564,4 +643,250 @@
     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