Strona główna Odkrywaj Pomoc
Zaloguj się
zhangtao
/
programs_info
Obserwuj 1
Polub 0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Drzewo: 099f5d4f5a
Gałęzie Tagi
programs_info
/
无锡市生命线项目
/
数据库备份
/
删除前备份
/
导出文件
/
work_order_admin.sql

work_order_admin.sql 12 KB
Historia Czysty

123456789101112131415 
  1. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1172195184205627392', '202311090004', '0', '新安家园202室燃气爆炸', '新安家园202室', '320211', '2023-11-10 00:00:00', '2023-11-10 00:00:00', '处理完毕', '管理', NULL, '2', NULL, NULL, 1, '2023-11-09 15:25:10.248', 'admin', '2023-11-13 11:44:16.819', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    2. 

  2. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1172195659340578816', '202311090005', '0', '仙河苑40号燃气爆炸', '仙河苑4', '320211', '2023-11-09 00:00:00', '2023-11-10 00:00:00', '处理完毕', '孙晓宇', NULL, '2', NULL, NULL, 1, '2023-11-09 15:27:03.529', 'admin', '2023-11-13 13:44:06.83', '孙晓宇', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    3. 

  3. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171857177975980032', '202311090001', '2', '东鼎家园小区内水管被破坏', '新吴区江溪街道行创四路', '320214', '2023-11-08 00:00:00', '2023-11-10 00:00:00', '处理完毕', '钱枫', '', '2', NULL, NULL, 1, '2023-11-08 17:02:03.283', 'admin', '2023-11-13 13:44:53.513', '钱枫', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    4. 

  4. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1173620219088732160', '202311090006', '2', '宝龙世家A区水管爆裂', '新吴区', '320214', '2023-11-13 00:00:00', '2023-11-15 00:00:00', NULL, NULL, NULL, '0', NULL, NULL, 1, '2023-11-13 13:47:45.041', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    5. 

  5. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171050526301749248', '202311060205', '0', '这是工单内容，这是工单内容', '无锡市XXX路XX号', '0', '2023-11-06 00:00:00', '2023-11-09 00:00:00', '这是一个反馈结果', '张三', '', '2', NULL, NULL, 1, '2023-11-06 11:36:42.537', 'admin', '2023-11-06 13:18:57.415', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    6. 

  6. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1173620796468232192', '202311090007', '4', '新安家园一期地下管线被破坏', '新安街道', '320214', '2023-11-13 00:00:00', '2023-11-16 00:00:00', NULL, '钱枫', NULL, '1', NULL, NULL, 1, '2023-11-13 13:50:02.698', 'admin', '2023-11-13 13:59:40.006', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    7. 

  7. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171810839125032960', '1', '1', '1', '11', '320211', '2023-11-08 00:00:00', '2023-11-08 00:00:00', NULL, NULL, NULL, '0', NULL, NULL, 0, '2023-11-08 13:57:55.24', 'admin', '2023-11-08 14:00:02.201', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    8. 

  8. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171810809169313792', '1', '1', '1', '11', '320211', '2023-11-08 00:00:00', '2023-11-08 00:00:00', NULL, NULL, NULL, '0', NULL, NULL, 0, '2023-11-08 13:57:48.098', 'admin', '2023-11-08 14:00:21.113', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    9. 

  9. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171804026430291968', '202311090001', '0', '新安家园201室燃气爆炸', '新安街道', '320214', '2023-11-08 00:00:00', '2023-11-09 00:00:00', '已处理完毕', '钱枫', '', '2', NULL, NULL, 1, '2023-11-08 13:30:50.967', 'admin', '2023-11-08 14:09:09.976', '钱枫', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    10. 

  10. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171814537364504576', '202311090002', '2', '春城家园小区内供水爆管', '江溪街道', '320214', '2023-11-08 00:00:00', '2023-11-10 00:00:00', '处理完毕', '钱枫', NULL, '2', NULL, NULL, 1, '2023-11-08 14:12:36.969', 'admin', '2023-11-08 14:13:58.237', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    11. 

  11. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171815802773438464', '202311090003', '2', '瑞成国际小区内供水爆管', '江溪街道', '320214', '2023-11-08 00:00:00', '2023-11-09 00:00:00', '处理完毕', '孙晓宇', NULL, '2', NULL, NULL, 1, '2023-11-08 14:17:38.666', 'admin', '2023-11-08 14:19:21.909', '钱枫', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    12. 

  12. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1171821906475614208', '00001', '0', '管道压力过高处理', '1', '320206', '2023-11-08 00:00:00', '2023-11-25 00:00:00', NULL, '王主任', NULL, '1', NULL, NULL, 1, '2023-11-08 14:41:53.903', 'admin', '2023-11-08 14:42:14.99', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    13. 

  13. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1201907468045647872', '007', '0', '测试短信发送功能', '江苏省无锡市新吴区梅村街道新韵路', '320214', '2024-02-23 14:06:24', '2024-02-23 00:00:00', NULL, NULL, NULL, '1', '01010000004831736D13558341AF83BFAFB1A24A41', NULL, 1, '2024-01-30 07:11:10.744', 'admin', '2024-02-23 06:00:18.796', 'admin', NULL, '3', '657B0062AFF7059DE9C043E916F00004', '[{"name":"4新冠疫苗接种授权委托书.doc","url":"http://2.21.138.148:9000/wx-zhjg-work/wx-zhjg-work_1706598668603.doc","uid":1706599022560,"status":"success"}]', NULL, '0', NULL, NULL, NULL, NULL, '0', '1', '15601521886', '测试短信发送功能');
    14. 

  14. INSERT INTO "work_order_admin" ("id", "work_order_code", "scene", "work_order_content", "place", "area", "dispatch_time", "process_limited", "feedback", "handler", "handler_id", "state", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "process_time", "work_order_type", "foreign_id", "attachments", "complete_time", "send_scene", "complete_attachments", "disposal_dept", "disposal_dept_id", "yjyabh", "order_source", "order_urgent", "sms_phone", "sms_content") VALUES ('1202996708275912704', '1753315062815191041', '桥梁专项测试', '测试工单', '测试', '测试', '2024-02-23 14:10:05', '2024-02-23 00:00:00', NULL, NULL, NULL, '1', NULL, NULL, 1, '2024-02-02 07:19:25.851', NULL, '2024-02-23 06:03:59.215', 'admin', NULL, '1', NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, '测试', NULL, '15601521886(小于),13921168677(test),15601521886(测试人员)', '工单管理，验证群发短信功能。');
    15. 

  15.