2024電力工業(yè)互聯(lián)網(wǎng)一體化管控平臺(tái)

一.系統(tǒng)概 二.規(guī)范性引用文 三.建設(shè)原 四.定義和術(shù) 五.應(yīng)用需 六.網(wǎng)絡(luò)拓 七.系統(tǒng)功 八.數(shù)據(jù)庫字段定 九.接口開 十.雙預(yù)防與省平臺(tái)數(shù)據(jù)對(duì)接規(guī) GB/T31496GB/T33000GB/T21028GB/T20273GB/T20272GB/T20271信息安全技術(shù)信息系統(tǒng)通用安全技術(shù)要求三.建設(shè)原則開放性：整個(gè)系統(tǒng)的軟硬件平臺(tái)和數(shù)據(jù)庫系統(tǒng)均具有相當(dāng)?shù)拈_放性；系統(tǒng)從設(shè)計(jì)向其電源64G內(nèi)存電源128G內(nèi)存電源64G內(nèi)存Googlechrome46及以上Safari7Iossafari:8及以上Android8.0/opt/minioBS模式的電腦應(yīng)用程序和數(shù)據(jù)可視化展示系統(tǒng)。此外，根據(jù)工業(yè)領(lǐng)域的特點(diǎn)，根據(jù)G30872022特殊作業(yè)安全規(guī)范，為了企業(yè)的安全生產(chǎn)，需建設(shè)危險(xiǎn)作業(yè)（特殊作業(yè)）（GB30871-2022）要求，安全管控措施應(yīng)全部顯示，作業(yè)申請(qǐng)人員自行選擇是否涉及，不APP7.13DROPTABLEIFEXISTS`DUTY_CHECK_ORDER_LOG`;CREATETABLE`DUTY_CHECK_ORDER_LOG`(`ID`bigint(20NOTNULLAUTO_INCREMENTCOMMENT主鍵`ORDER_NAME`varchar(100DEFAULTNULLCOMMENT排查清單名稱`DUTY_CHECK_ORDER_ID`bigint(20)DEFAULTNULLCOMMENT排查`DUTY_CHECK_ORDER_TYPE_ID`bigint(20)DEFAULTNULL '`DUTY_USER_ID`varchar(36DEFAULTNULLCOMMENT考核人`DUTY_USER_NAME`varchar(200DEFAULTNULLCOMMENT'`APPROVE_USER_ID`bigint(20)DEFAULTNULLCOMMENT'當(dāng)前需要處`APPROVE_USER_NAME`varchar(200)DEFAULTNULLCOMMENT'當(dāng)前`BEING_DUTY_USER_ID`varchar(36)DEFAULTNULLCOMMENT'被考核`BEING_DUTY_USER_NAME`varchar(200)DEFAULTNULLCOMMENT`DUTY_USER_SIGN`varchar(200DEFAULTNULLCOMMENT`BEING_DUTY_USER_SIGN`varchar(200)DEFAULTNULLCOMMENT'`CHECK_STATUS`int(11DEFAULTNULLCOMMENT當(dāng)前狀態(tài)`CHECK_TIME`datetimeDEFAULTNULLCOMMENT考核時(shí)間`CHECK_RESULT`varchar(200DEFAULTNULLCOMMENT考核結(jié)果`HANDLING_SUGGESTION`varchar(300)DEFAULTNULLCOMMENT`APPLY_DESC`varchar(300DEFAULTNULLCOMMENT申訴內(nèi)容`CREATED_AT`datetimeDEFAULTNULLCOMMENT創(chuàng)建時(shí)間`DATA_STATUS`int(11DEFAULT1COMMENT數(shù)據(jù)狀態(tài)`UPDATED_AT`datetimeDEFAULTNULLCOMMENT更新時(shí)間',PRIMARYKEY(`ID`)USINGBTREE)ENGINE=InnoDBAUTO_INCREMENT=41199DEFAULTLEC評(píng)估DROPTABLEIFEXISTS`BS_LEC_D`;CREATETABLE`BS_LEC_D`(`BS_LEC_D_ID`int(11NOTNULLCOMMENTLEC評(píng)估D表`BS_LEC_D_SCOPE_VALUE`varchar(50)DEFAULTNULLCOMMENT`BS_LEC_D_MIN_VALUE`decimal(6,0)DEFAULTNULLCOMMENT'風(fēng)險(xiǎn)`BS_LEC_D_MAX_VALUE`decimal(6,0DEFAULTNULLCOMMENT`BS_LEC_D_LEVEL`varchar(20DEFAULTNULLCOMMENT風(fēng)險(xiǎn)等級(jí)`BS_LEC_D_LEVEL_DESC`varchar(50)DEFAULTNULLCOMMENT'風(fēng)險(xiǎn)`BS_LEC_D_SPS`varchar(255)DEFAULTNULLCOMMENT'應(yīng)采取的行動(dòng)`BS_LEC_D_DEADLINE`varchar(255DEFAULTNULLCOMMENT'PRIMARYKEY(`BS_LEC_D_ID`)USING)ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COMMENT='LEC風(fēng)險(xiǎn)等級(jí)危險(xiǎn)化學(xué)DROPTABLEIFEXISTS`CHEMICAL_BOOK`;CREATETABLE`CHEMICAL_BOOK`(`ID`bigint(20NOTNULLAUTO_INCREMENTCOMMENT主鍵`DANGEROUS_CHEMICAL_LIB_ID`bigint(20)NOTNULLCOMMENT '`BOOK_DUTY_DEPT_ID`bigint(20NOTNULLCOMMENT管控部門`BOOK_DUTY_DEPT_IDS`varchar(30)DEFAULTNULLCOMMENT管控`BOOK_DUTY_DEPT_NAME`varchar(100)NOTNULLCOMMENT'管控部21點(diǎn)4221點(diǎn)42`BOOK_DUTY_USER_ID`bigint(20NOTNULLCOMMENT管控人`BOOK_DUTY_USER_IDS`varchar(30)DEFAULTNULLCOMMENT管控人ID`BOOK_DUTY_USER_NAME`varchar(30)DEFAULTNULLCOMMENT`GOODS_SITE`varchar(30DEFAULTNULLCOMMENT存放位置`GOODS_STORE`varchar(30DEFAULTNULLCOMMENT現(xiàn)在庫存`DATA_STATUS`int(11)DEFAULT`TENANT_ID`bigint(20DEFAULTNULLCOMMENT租戶`CREATED_AT`bigint(20DEFAULTNULLCOMMENT創(chuàng)建時(shí)間`UPDATED_AT`bigint(20DEFAULTNULLCOMMENT更新時(shí)間`STORE_FACILITY`varchar(50DEFAULTNULLCOMMENT儲(chǔ)存設(shè)施 '`CREATOR_ID`varchar(36DEFAULTNULLCOMMENT創(chuàng)建用戶`CREATOR_NAME`varchar(20DEFAULTNULLCOMMENTPRIMARYKEY(`ID`)USING)ENGINE=InnoDBAUTO_INCREMENT=5DEFAULTDROPTABLEIFEXISTS`EMERGENCY_AID_AGENCIES`;CREATETABLE`EMERGENCY_AID_AGENCIES`( AUTO_INCREMENTCOMMENT'應(yīng)急救援機(jī)構(gòu)ID', COMMENT'機(jī)構(gòu)名稱',`FOUND_DATE_AT`bigint(20DEFAULTNULLCOMMENT（時(shí)`BELONGS_DEPT_ID`bigint(20DEFAULTNULLCOMMENT所屬部門id`BELONGS_DEPT_IDS`varchar(20DEFAULTNULLCOMMENT'所屬部門 `BELONGS_DEPT_ANME`varchar(100)DEFAULTNULLCOMMENT'所屬`PRINCIPAL_USER_ID`varchar(36DEFAULTNULLCOMMENT負(fù)責(zé)人`PRINCIPAL_USER_NAME`varchar(100DEFAULTNULLCOMMENT負(fù)責(zé)`ORGANIZATIONAL_RESPONSIBILTIES_DESC`textCOMMENT`UPLOAD_ATTACHMENT_URL`varchar(255)DEFAULTNULL`DATA_STATUS`smallint(6)NOTNULLDEFAULT'1'COMMENT數(shù)據(jù)狀態(tài)15刪除`CREATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT創(chuàng)建人`CREATOR_USER_NAME`varchar(50DEFAULTNULLCOMMENT`UPDATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT修改人`UPDATOR_USER_NAME`varchar(50)DEFAULTNULLCOMMENT修改`CREATED_AT`datetimeDEFAULTNULLCOMMENT創(chuàng)建時(shí)間`UPDATED_AT`datetimeDEFAULTNULLCOMMENT修改時(shí)間`DEPT_ID`bigint(20DEFAULTNULLCOMMENT部門ID`TENANT_ID`bigint(13)unsignedzerofillDEFAULTNULLCOMMENT'租戶PRIMARYKEY(`EMERGENCY_AID_AGENCIES_ID`)USING COMMENT='--應(yīng)急救援機(jī)構(gòu)DROPTABLEIFEXISTS`EQUIPMENT_FACILITIES_ACCOUNT`;CREATETABLE`EQUIPMENT_FACILITIES_ACCOUNT`(`ID`bigint(20NOTNULLAUTO_INCREMENTCOMMENT序號(hào)`EQUIPMENT_NUMBER`varchar(100DEFAULTNULLCOMMENT`EQUIPMENT_NAME`varchar(100DEFAULTNULLCOMMENT設(shè)備名稱`EQUIPMENT_TYPE_ID`bigint(20)DEFAULTNULLCOMMENT'設(shè)備類型`EQUIPMENT_TYPE`varchar(100DEFAULTNULLCOMMENT設(shè)備類型 '`OPERATING_TEMPERATURE`varchar(100)DEFAULTNULLCOMMENT`OPERATING_PRESSURE`varchar(100)DEFAULTNULLCOMMENT'操作`MRDIUM`varchar(100DEFAULTNULLCOMMENT介質(zhì)`MEDIA_STATUS`varchar(100DEFAULTNULLCOMMENT介質(zhì)狀態(tài)`TEXTURE_OF_MATERIAL`varchar(100)DEFAULTNULLCOMMENT`INSTALLATION_POSITION`varchar(100DEFAULTNULLCOMMENT'`JURISDICTION_DEPT_ID`bigint(20)DEFAULTNULLCOMMENT'管轄部`JURISDICTION_DEPT_IDS`varchar(100)DEFAULTNULLCOMMENT`JURISDICTION_DEPT_NAME`varchar(100)DEFAULTNULLCOMMENT`MANUFACTURER`varchar(100DEFAULTNULLCOMMENT制造廠商`DELIVERY_DATE`datetimeDEFAULTNULLCOMMENT出廠時(shí)間`DELIVERY_NUMBER`varchar(100)DEFAULTNULLCOMMENT出廠編`EQUIPMENT_STATUS`smallint(6)DEFAULT'1'COMMENT'設(shè)備狀態(tài)：23報(bào)廢`IS_SPECIAL_EQUIPMENT`smallint(6DEFAULT'2COMMENT'是否特種設(shè)備：12否`COMMISSIONING_DATE`datetimeDEFAULTNULLCOMMENT`SPECIAL_EQUIPMENT_MANAGEMENT`varchar(100)DEFAULT'2未備案 '`LICENSE_NO`varchar(100DEFAULTNULLCOMMENT使用證編號(hào)`FILE_NUMBER`varchar(100DEFAULTNULLCOMMENT檔案號(hào)`FILING_ATTACHMENT`varchar(255DEFAULTNULLCOMMENT`CREATED_AT`datetimeDEFAULTNULLCOMMENT創(chuàng)建時(shí)間`UPDATED_AT`datetimeDEFAULTNULLCOMMENT更新時(shí)間`DATA_STATUS`smallint(6)NOTNULLDEFAULT'1'COMMENT數(shù)據(jù)狀態(tài)15刪除`CREATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT創(chuàng)建人`CREATED_BY`varchar(50DEFAULTNULLCOMMENT創(chuàng)建人`UPDATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT修改人`UPDATOR_BY`varchar(50DEFAULTNULLCOMMENT修改人',PRIMARYKEY(`ID`)USINGBTREE HiddenDangerReportedControllerPOST/cs/hidden-danger-reported/abarbeitung隱患--整改--提交GET/cs/hidden-danger-reported/delete/{id}隱患刪除GET/cs/hidden-danger-reported/getMyCreate隱患--我的整改任GET/cs/hidden-danger-reported/myProcessedTask隱患--我的整GET/cs/hidden-danger-reported/myTaskSum隱患--我的隱患排GET/cs/hidden-danger-reported/myWaitingTask隱患--我的整改HiddenDangerTaskLogControllerGET/cs/hidden-danger-task/clearData清理數(shù)據(jù)(之前變更產(chǎn)生垃GET/cs/hidden-danger-task/cLearLogData清理無效記錄數(shù)據(jù)(之GET/cs/hidden-danger-task/getTask隱患管理-一鍵生成任務(wù)GET/cs/hidden-danger-task/myProcessedTask我的隱患排查任GET/cs/hidden-danger-task/myWaitingTask我的隱患排查任務(wù)GET/cs/hidden-danger-task/pageRecord隱患排查記錄}HiddenCheckOrderLogControllerGET/newHiddenCheckLog/byAnaLyticId/{id}獲取單元數(shù)據(jù)統(tǒng)POST/newHiddenCheckLog/commit/task新版-提交隱患排查任GET/newHiddenCheckLog/deLayTask/{time}新版-任務(wù)漏查測(cè)GET/newHiddenCheckLog/detaiL/{id}新版-獲取隱患排查任務(wù)POST/newHiddenCheckLog/myDispose/pageList新版-已處理POST/newHiddenCheckLog/myPending/pageList新版-未處理GET/newHiddenCheckLog/notifyTask/{time}新版-任務(wù)到期測(cè)POST/newHiddenCheckLog/oneOrder/pageList新版-對(duì)應(yīng)的排POST/newHiddenCheckLog/pageAlLList新版-所有的排查清單GET/newHiddenCheckLog/scan/byOrderId/{id}獲取帶有圣緯GET/newHiddenCheckLog/setOrderAddDutyDeptId排查日志GET/newHiddenCheckLog/setOrderAddUnit清單添加風(fēng)險(xiǎn)分GET/newHiddenCheckLog/testTask/{time}新版-生成任務(wù)測(cè)試GET/newHiddenCheckLog/totalInfo/{id}新版-某個(gè)隱患排查清GET/hiddenCheckOrder/checkMethods/byOrderId/{id}獲取帶GET/hiddenCheckOrder/clear0LdRiskIdentificationData清理以GET/hiddenCheckOrder/delete/{id}GET/hiddenCheckOrder/detaiL/{id}隱患排查清單詳細(xì)信息GET/hiddenCheckOrder/disable/{id}禁用用隱患排查清單GET/hiddenCheckOrder/enable/{id}啟用隱患排查清單GET/hiddenCheck0rder/LatiAndLongi/orderList獲取帶有經(jīng)緯POST/hiddenCheck0rder/LatiAndLongi/orderList重置某個(gè)清POST/hiddenCheckOrder/listByType獲取相對(duì)應(yīng)的清單類型的POST/hiddenCheckOrderType/add新增數(shù)據(jù)GET/hiddenCheckOrderType/delete/{id}刪除數(shù)據(jù)GET/hiddenCheck0rderType/list列表下拉框查詢所有數(shù)據(jù)口AnalyticUnitGET/cs/analytic-unit/clearObject清理無效風(fēng)險(xiǎn)對(duì)象/cs/analytic-unit/deleteBatch根據(jù)list刪除POST/cs/analytic-unit/getAnalytic查看對(duì)象/單元詳情POST/cs/anaLytic-unit/getTreeList獲取樹狀數(shù)據(jù)GET/cs/analytic-unit/objectList分析對(duì)象列表/cs/analytic-unit/saveImg添加風(fēng)險(xiǎn)空間分布圖單元POST/cs/analytic-unit/saveObject新增對(duì)象POST/cs/analytic-unit/saveUnit新增單元GET/cs/analytic-unit/scanDetail/{id}移動(dòng)端分析單元掃碼獲取詳GET/cs/analytic-unit/unitList/{id}口RiskIdentificationGET/cs/risk-identification/contort/page風(fēng)險(xiǎn)辨識(shí)-管控措施分頁查DELETE/cs/risk-identification/deleteBatch根據(jù)list刪除GET/cs/risk-identification/getone詳情UserControllerPOST/sys_user/deleteHiddenUse刪除隱患分配人GET/sys_user/getSysUserByDeptId根據(jù)部門ID獲取人員信息GET/sys_user/hiddenUserPage隱患分配人分頁查詢PoitionContrlerDeptControllerGET/sys_dept/getSysDeptHiddenUserTreeList獲取隱患分配GET/sys_dept/getSysDeptTreeList獲取部門tree列表數(shù)據(jù)GET/sys_dept/getSysDeptTreeListById根據(jù)ID獲取部門tree列GET/sys_dept/getSysDeptUserTreeList獲取部門人員tree列表WorkDictDELETE/riskWork/de飛根據(jù)list刪除DELETE/riskWork/delete刪除GET/riskWork/getAllListsWithTree危險(xiǎn)作業(yè)-》危險(xiǎn)作業(yè)字典表GET/riskWork/getListsWithTree/{name}危險(xiǎn)作業(yè)-GET/riskWork/getOnt/{id}危險(xiǎn)作業(yè)-GET/specialwork/certificate/aLLList移動(dòng)端本地存儲(chǔ)用的DELETE/specialwork/certificate/deLeete/{id}刪除GET/speciaLwork/certificate/detait/{id}詳情POST/specialwork/certificate/pageList分頁列表GET/specialwork/certificate/typeList/{typeId}下拉列表POST/specialwork/certificate/update更新POST/specialWorkTicket/accept/pageList作業(yè)驗(yàn)收分頁列表POST/specialWorkTicket/acceptCLarificaiton接受交底POST/specialWorkTicket/acceptTicket作業(yè)驗(yàn)收POST/specialWorkTicket/add新增POST/specialWorkTicket/approveTicket作業(yè)審批