1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
| -- FAMS 第五阶段(到期提醒+统计分析):模块/视图/按钮/权限/提醒设置关键字/资产管理员群组/定时任务/菜单,2026-10-16 已在 fams 库执行
| insert into cnf_module (module_id,parent_id,module_name,module_identify,module_type,module_icon,main_table_id,main_table_name,main_table_key_name,main_form_id,main_form_name,enable_attach,enable_attach_template,upload_attach_other_name,enable_attach_body,enable_body_template,upload_body_other_name,attach_format_limit,attach_size_limit,enable_attach_origin,upload_origin_other_name,attach_origin_format_limit,attach_origin_size_limit,enable_define_attach_save,attach_upload_path,attach_view_path,enable_get_attach_md5_code,enable_attach_conversion,attach_conversion_rules,enable_attach_thumbnail,attach_thumbnail_width,attach_thumbnail_height,enable_attach_encrypted,enable_main_attach,enable_attach_sort,enable_catalog_fulltext,catalog_search_fields,catalog_search_result_group,catalog_search_result_title,catalog_search_result_detail,enable_attach_fulltext,enable_soft_delete,enable_data_authorize,enable_data_item_authorize,enable_attach_authorize,custom_data_item_authorize,custom_attach_authorize,custom_validation_fail_view,permission_name,create_user_id,create_user_name,create_time,last_modify_time,description,batch_download_folder,batch_download_max_count,sort_num,enable_flow,extend_string_field1,extend_string_field2,extend_string_field3,extend_string_field4,extend_string_field5,extend_int_field1,extend_int_field2,extend_long_field1,extend_long_field2,enable_data_secret,custom_water_mark,enable_file_permission,enable_app,enable_app_permission,app_permission_name,enable_list_show_history,get_old_data_for_after_save,save_modify_detail_log) values ('1800000000000003300','1800000000000001035','到期提醒','ASSET_REMIND','0','fa fa-bell',NULL,'BUS_ASSET_REMIND','ID',NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'0','0',NULL,NULL,NULL,NULL,NULL,NULL,'FAMS_ASSET.ASSET_REMIND','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00','资产到期提醒记录(定时任务生成)',NULL,NULL,'30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
| insert into cnf_table (table_id,module_id,module_name,table_name,display_name,primary_key,table_description,enable_set_main_table,not_created,create_user_id,create_user_name,create_time,modify_time,keyword) values ('1800000000000003301','1800000000000003300','到期提醒','BUS_ASSET_REMIND','到期提醒','ID','到期提醒','1','0','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00','');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003302','1800000000000003301','ID','主键ID','0','bigint','20','0','','1','0','2','0','0','0','','主键ID','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003303','1800000000000003301','ASSET_ID','资产ID','0','bigint','20','0','','0','0','0','0','0','0','','资产ID','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003304','1800000000000003301','ASSET_NO','资产编号','0','varchar','50','0','','0','0','0','0','0','0','','资产编号','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003305','1800000000000003301','ASSET_NAME','资产名称','0','varchar','200','0','','0','0','0','0','0','0','','资产名称','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003306','1800000000000003301','REMIND_TYPE','提醒类型','0','varchar','20','0','','0','0','0','0','0','0','','提醒类型','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003307','1800000000000003301','DUE_DATE','到期日','0','datetime','0','0','','0','0','0','0','0','0','','到期日','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003308','1800000000000003301','DAYS_LEFT','剩余天数','0','int','11','0','','0','0','0','0','0','0','','剩余天数','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003309','1800000000000003301','USER_ID','使用人ID','0','bigint','20','0','','0','0','0','0','0','0','','使用人ID','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003310','1800000000000003301','USER_NAME','使用人','0','varchar','100','0','','0','0','0','0','0','0','','使用人','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003311','1800000000000003301','USE_DEPT_NAME','使用部门','0','varchar','200','0','','0','0','0','0','0','0','','使用部门','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003312','1800000000000003301','LOCATION_NAME','存放位置','0','varchar','300','0','','0','0','0','0','0','0','','存放位置','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003313','1800000000000003301','REMIND_STATE','提醒状态','0','varchar','20','0','','0','0','0','0','0','0','','提醒状态','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003314','1800000000000003301','NOTIFY_TIME','提醒时间','0','datetime','0','0','','0','0','0','0','0','0','','提醒时间','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003315','1800000000000003301','HANDLE_TIME','处理时间','0','datetime','0','0','','0','0','0','0','0','0','','处理时间','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003316','1800000000000003301','HANDLE_USER_NAME','处理人','0','varchar','100','0','','0','0','0','0','0','0','','处理人','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003317','1800000000000003301','HANDLE_REMARK','处理说明','0','varchar','500','0','','0','0','0','0','0','0','','处理说明','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003318','1800000000000003301','CREATE_USER_ID','创建人id','1','bigint','20','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003319','1800000000000003301','CREATE_USER_NAME','创建人姓名','1','varchar','100','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003320','1800000000000003301','CREATE_TIME','创建时间','1','datetime','0','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003321','1800000000000003301','MODIFY_TIME','修改时间','1','datetime','0','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003322','1800000000000003301','CREATE_DEPT_ID','创建人部门id','1','bigint','20','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003323','1800000000000003301','CREATE_DEPT_NAME','创建人部门名称','1','varchar','200','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003324','1800000000000003301','SECURITY_CODE','密级代码','1','int','11','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003325','1800000000000003301','DELETE_STATE','软删除状态','1','tinyint','4','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003326','1800000000000003301','DELETE_TIME','软删除时间','1','datetime','0','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003327','1800000000000003301','FULLTEXT_STATE','全文索引状态','1','tinyint','4','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003328','1800000000000003301','FLOW_STATE','流程状态','1','tinyint','4','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003329','1800000000000003301','PROCESS_INSTANCE_ID','流程实例ID','1','bigint','20','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_table_column (column_id,table_id,column_name,display_name,column_type,data_type,data_size,decimal_point,default_value,is_primary,is_not_null,is_identity,is_unique,is_not_for_query,forbid_batch_update,custom_tag,column_description,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003330','1800000000000003301','FLOW_STEP','流程步骤信息','1','varchar','500','0','','0','0','0','0','0','0','','','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_permission (permission_id,permission_name,display_name,permission_type,parent_id,module_id,description,sort_num,create_user_id,create_user_name,create_time,last_modify_time) values ('1800000000000003331','FAMS_ASSET.ASSET_REMIND','到期提醒','MODULE','1800000000000001036','1800000000000003300','','30','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_permission (permission_id,permission_name,display_name,permission_type,parent_id,module_id,description,sort_num,create_user_id,create_user_name,create_time,last_modify_time) values ('1800000000000003332','FAMS_ASSET.ASSET_REMIND.Operation','操作','OPERATION','1800000000000003331','1800000000000003300','','1','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_operation (operation_id,operation_name,display_name,custom_identify,enable_system_operation,operation_icon,operation_css,operation_position,need_select_data,allow_select_multiple_data,operation_type,page_open_mode,page_width,page_height,page_url,affair_type,package_name,class_name,method_name,nashorn_expression,sql_statement,js_expression,enable_permission,permission_name,module_name,module_id,target_module_name,target_module_id,enable_custom_permission,verification_expression,operation_front_method,operation_after_method,create_user_id,create_user_name,create_time,modify_time,remark) values ('1800000000000003333','HandleRemind','标记已处理',NULL,'0','fa fa-check','pt-btn-success','0','1','1','1','0',NULL,NULL,NULL,'0','','','zbooksoft.fams.delegate.FamsPublicOperations.handleReminds',NULL,NULL,'','0','FAMS_ASSET.ASSET_REMIND.Operation.HandleRemind','到期提醒','1800000000000003300',NULL,NULL,NULL,NULL,NULL,NULL,'1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00',NULL);
| insert into cnf_permission (permission_id,permission_name,display_name,permission_type,parent_id,module_id,description,sort_num,create_user_id,create_user_name,create_time,last_modify_time) values ('1800000000000003334','FAMS_ASSET.ASSET_REMIND.Operation.HandleRemind','标记已处理','OPERATION','1800000000000003332','1800000000000003300','','1','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_operation (operation_id,operation_name,display_name,custom_identify,enable_system_operation,operation_icon,operation_css,operation_position,need_select_data,allow_select_multiple_data,operation_type,page_open_mode,page_width,page_height,page_url,affair_type,package_name,class_name,method_name,nashorn_expression,sql_statement,js_expression,enable_permission,permission_name,module_name,module_id,target_module_name,target_module_id,enable_custom_permission,verification_expression,operation_front_method,operation_after_method,create_user_id,create_user_name,create_time,modify_time,remark) values ('1800000000000003335','RunRemindScan','立即检查',NULL,'0','fa fa-refresh','pt-btn-primary','0','0','1','1','0',NULL,NULL,NULL,'0','','','zbooksoft.fams.delegate.FamsPublicOperations.runRemindScan',NULL,NULL,'','0','FAMS_ASSET.ASSET_REMIND.Operation.RunRemindScan','到期提醒','1800000000000003300',NULL,NULL,NULL,NULL,NULL,NULL,'1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00',NULL);
| insert into cnf_permission (permission_id,permission_name,display_name,permission_type,parent_id,module_id,description,sort_num,create_user_id,create_user_name,create_time,last_modify_time) values ('1800000000000003336','FAMS_ASSET.ASSET_REMIND.Operation.RunRemindScan','立即检查','OPERATION','1800000000000003332','1800000000000003300','','2','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into cnf_view (view_id,module_id,view_identify,view_name,enable_permission,permission_name,enable_module_data_authorize,data_source_type,main_table_id,main_table_name,relation_table_names,sql_select,sql_from,sql_where,sql_order,enable_pagination,enable_define_config,pagination_type,page_size,page_list,row_click_event_type,open_mode,open_window_title,custom_run_js,open_url_type,open_url_width,open_url_height,enable_custom_type,open_custom_url,open_form_name,open_form_id,default_form_params,default_search_fields,default_search_prompt,default_search_text_replace,id_field,enable_custom_style,enable_nav_classify,nav_classify_ids,nav_classify_names,def_expand_nav_classify_id,def_expand_nav_classify_name,def_select_nav_classify_item,enable_tooltip,tooltip_type,tooltip_class,tooltip_content,list_style_type,detail_type,detail_url,target_module_name,target_module_id,target_relation_column_name,local_relation_column_name,target_view_id,target_view_name,group_column_name,group_title_style,custom_style_js,enable_custom_property,custom_property_js,eanble_fit_columns,custom_event_js,tree_parent_column_name,tree_node_column_name,tree_node_icon_cls,front_view_type,front_view_name,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time,sql_group_columns,remark) values ('1800000000000003337','1800000000000003300','remind_pending','待处理提醒','0',NULL,'0','0','1800000000000003301','BUS_ASSET_REMIND','','*','BUS_ASSET_REMIND','REMIND_STATE = ''待处理''','DAYS_LEFT, ASSET_NO','1','0','bottom','20','','0','0','','','0','900','600','0','','',NULL,'','ASSET_NO,ASSET_NAME,USER_NAME,REMIND_TYPE','请输入资产编号、名称、使用人、提醒类型查询',NULL,'ID','0','0','','',NULL,'','','0','0','','','0','0','','',NULL,'','',NULL,'','','','','0','',NULL,'','','','','0','','1','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00','','');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003338','1800000000000003337','提醒类型','0',NULL,'REMIND_TYPE',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'1','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003339','1800000000000003337','资产编号','0',NULL,'ASSET_NO',NULL,'0','0','110','0',NULL,'left','center','0',NULL,'0',NULL,'2','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003340','1800000000000003337','资产名称','0',NULL,'ASSET_NAME',NULL,'0','0','150','0',NULL,'left','center','0',NULL,'0',NULL,'3','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003341','1800000000000003337','到期日','0',NULL,'DUE_DATE',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'4','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003342','1800000000000003337','剩余','0',NULL,'DAYS_LEFT',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'5','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003343','1800000000000003337','使用人','0',NULL,'USER_NAME',NULL,'0','0','80','0',NULL,'left','center','0',NULL,'0',NULL,'6','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003344','1800000000000003337','使用部门','0',NULL,'USE_DEPT_NAME',NULL,'0','0','110','0',NULL,'left','center','0',NULL,'0',NULL,'7','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003345','1800000000000003337','存放位置','0',NULL,'LOCATION_NAME',NULL,'0','0','160','0',NULL,'left','center','0',NULL,'0',NULL,'8','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003346','1800000000000003337','状态','0',NULL,'REMIND_STATE',NULL,'0','0','70','0',NULL,'left','center','0',NULL,'0',NULL,'9','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003347','1800000000000003337','提醒时间','0',NULL,'NOTIFY_TIME',NULL,'0','0','140','0',NULL,'left','center','0',NULL,'0',NULL,'10','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003348','1800000000000003337','处理人','0',NULL,'HANDLE_USER_NAME',NULL,'0','0','80','0',NULL,'left','center','0',NULL,'0',NULL,'11','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003349','1800000000000003337','处理时间','0',NULL,'HANDLE_TIME',NULL,'0','0','140','0',NULL,'left','center','0',NULL,'0',NULL,'12','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view (view_id,module_id,view_identify,view_name,enable_permission,permission_name,enable_module_data_authorize,data_source_type,main_table_id,main_table_name,relation_table_names,sql_select,sql_from,sql_where,sql_order,enable_pagination,enable_define_config,pagination_type,page_size,page_list,row_click_event_type,open_mode,open_window_title,custom_run_js,open_url_type,open_url_width,open_url_height,enable_custom_type,open_custom_url,open_form_name,open_form_id,default_form_params,default_search_fields,default_search_prompt,default_search_text_replace,id_field,enable_custom_style,enable_nav_classify,nav_classify_ids,nav_classify_names,def_expand_nav_classify_id,def_expand_nav_classify_name,def_select_nav_classify_item,enable_tooltip,tooltip_type,tooltip_class,tooltip_content,list_style_type,detail_type,detail_url,target_module_name,target_module_id,target_relation_column_name,local_relation_column_name,target_view_id,target_view_name,group_column_name,group_title_style,custom_style_js,enable_custom_property,custom_property_js,eanble_fit_columns,custom_event_js,tree_parent_column_name,tree_node_column_name,tree_node_icon_cls,front_view_type,front_view_name,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time,sql_group_columns,remark) values ('1800000000000003350','1800000000000003300','remind_mine','我的到期提醒','0',NULL,'0','0','1800000000000003301','BUS_ASSET_REMIND','','*','BUS_ASSET_REMIND','REMIND_STATE = ''待处理'' and USER_ID = ${CurUserId}','DAYS_LEFT, ASSET_NO','1','0','bottom','20','','0','0','','','0','900','600','0','','',NULL,'','ASSET_NO,ASSET_NAME,USER_NAME,REMIND_TYPE','请输入资产编号、名称、使用人、提醒类型查询',NULL,'ID','0','0','','',NULL,'','','0','0','','','0','0','','',NULL,'','',NULL,'','','','','0','',NULL,'','','','','0','','2','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00','','');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003351','1800000000000003350','提醒类型','0',NULL,'REMIND_TYPE',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'1','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003352','1800000000000003350','资产编号','0',NULL,'ASSET_NO',NULL,'0','0','110','0',NULL,'left','center','0',NULL,'0',NULL,'2','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003353','1800000000000003350','资产名称','0',NULL,'ASSET_NAME',NULL,'0','0','150','0',NULL,'left','center','0',NULL,'0',NULL,'3','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003354','1800000000000003350','到期日','0',NULL,'DUE_DATE',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'4','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003355','1800000000000003350','剩余','0',NULL,'DAYS_LEFT',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'5','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003356','1800000000000003350','使用人','0',NULL,'USER_NAME',NULL,'0','0','80','0',NULL,'left','center','0',NULL,'0',NULL,'6','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003357','1800000000000003350','使用部门','0',NULL,'USE_DEPT_NAME',NULL,'0','0','110','0',NULL,'left','center','0',NULL,'0',NULL,'7','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003358','1800000000000003350','存放位置','0',NULL,'LOCATION_NAME',NULL,'0','0','160','0',NULL,'left','center','0',NULL,'0',NULL,'8','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003359','1800000000000003350','状态','0',NULL,'REMIND_STATE',NULL,'0','0','70','0',NULL,'left','center','0',NULL,'0',NULL,'9','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003360','1800000000000003350','提醒时间','0',NULL,'NOTIFY_TIME',NULL,'0','0','140','0',NULL,'left','center','0',NULL,'0',NULL,'10','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003361','1800000000000003350','处理人','0',NULL,'HANDLE_USER_NAME',NULL,'0','0','80','0',NULL,'left','center','0',NULL,'0',NULL,'11','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003362','1800000000000003350','处理时间','0',NULL,'HANDLE_TIME',NULL,'0','0','140','0',NULL,'left','center','0',NULL,'0',NULL,'12','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view (view_id,module_id,view_identify,view_name,enable_permission,permission_name,enable_module_data_authorize,data_source_type,main_table_id,main_table_name,relation_table_names,sql_select,sql_from,sql_where,sql_order,enable_pagination,enable_define_config,pagination_type,page_size,page_list,row_click_event_type,open_mode,open_window_title,custom_run_js,open_url_type,open_url_width,open_url_height,enable_custom_type,open_custom_url,open_form_name,open_form_id,default_form_params,default_search_fields,default_search_prompt,default_search_text_replace,id_field,enable_custom_style,enable_nav_classify,nav_classify_ids,nav_classify_names,def_expand_nav_classify_id,def_expand_nav_classify_name,def_select_nav_classify_item,enable_tooltip,tooltip_type,tooltip_class,tooltip_content,list_style_type,detail_type,detail_url,target_module_name,target_module_id,target_relation_column_name,local_relation_column_name,target_view_id,target_view_name,group_column_name,group_title_style,custom_style_js,enable_custom_property,custom_property_js,eanble_fit_columns,custom_event_js,tree_parent_column_name,tree_node_column_name,tree_node_icon_cls,front_view_type,front_view_name,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time,sql_group_columns,remark) values ('1800000000000003363','1800000000000003300','remind_all','全部提醒记录','0',NULL,'0','0','1800000000000003301','BUS_ASSET_REMIND','','*','BUS_ASSET_REMIND','','NOTIFY_TIME DESC','1','0','bottom','20','','0','0','','','0','900','600','0','','',NULL,'','ASSET_NO,ASSET_NAME,USER_NAME,REMIND_TYPE','请输入资产编号、名称、使用人、提醒类型查询',NULL,'ID','0','0','','',NULL,'','','0','0','','','0','0','','',NULL,'','',NULL,'','','','','0','',NULL,'','','','','0','','3','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00','','');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003364','1800000000000003363','提醒类型','0',NULL,'REMIND_TYPE',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'1','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003365','1800000000000003363','资产编号','0',NULL,'ASSET_NO',NULL,'0','0','110','0',NULL,'left','center','0',NULL,'0',NULL,'2','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003366','1800000000000003363','资产名称','0',NULL,'ASSET_NAME',NULL,'0','0','150','0',NULL,'left','center','0',NULL,'0',NULL,'3','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003367','1800000000000003363','到期日','0',NULL,'DUE_DATE',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'4','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003368','1800000000000003363','剩余','0',NULL,'DAYS_LEFT',NULL,'0','0','100','0',NULL,'left','center','0',NULL,'0',NULL,'5','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003369','1800000000000003363','使用人','0',NULL,'USER_NAME',NULL,'0','0','80','0',NULL,'left','center','0',NULL,'0',NULL,'6','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003370','1800000000000003363','使用部门','0',NULL,'USE_DEPT_NAME',NULL,'0','0','110','0',NULL,'left','center','0',NULL,'0',NULL,'7','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003371','1800000000000003363','存放位置','0',NULL,'LOCATION_NAME',NULL,'0','0','160','0',NULL,'left','center','0',NULL,'0',NULL,'8','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003372','1800000000000003363','状态','0',NULL,'REMIND_STATE',NULL,'0','0','70','0',NULL,'left','center','0',NULL,'0',NULL,'9','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003373','1800000000000003363','提醒时间','0',NULL,'NOTIFY_TIME',NULL,'0','0','140','0',NULL,'left','center','0',NULL,'0',NULL,'10','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003374','1800000000000003363','处理人','0',NULL,'HANDLE_USER_NAME',NULL,'0','0','80','0',NULL,'left','center','0',NULL,'0',NULL,'11','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_column (column_id,view_id,column_title,content_type,table_name,field_name,expression,enable_frozen,enable_order,display_width,data_type,output_format,column_position,title_position,enable_custom_style,custom_style_js,enable_custom_formatter,custom_formatter_js,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003375','1800000000000003363','处理时间','0',NULL,'HANDLE_TIME',NULL,'0','0','140','0',NULL,'left','center','0',NULL,'0',NULL,'12','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_operation (id,view_id,operation_id,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003376','1800000000000003337','1800000000000003333','1','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_operation (id,view_id,operation_id,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003377','1800000000000003337','1800000000000003335','2','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| insert into cnf_view_operation (id,view_id,operation_id,sort_num,create_time,last_modify_user_id,last_modify_user_name,last_modify_time) values ('1800000000000003378','1800000000000003363','1800000000000003335','1','2026-10-16 16:00:00','1118460701772660737','管理员','2026-10-16 16:00:00');
| update cnf_view_column set enable_custom_formatter = 1, custom_formatter_js = 'formatter: function(value,row,index){ var v = parseInt(value, 10); if (isNaN(v)) { return ''''; } if (v < 0) { return ''<span style="color:#d03b3b;font-weight:600;">已过期 '' + (-v) + '' 天</span>''; } return v === 0 ? ''今天到期'' : v + '' 天后到期''; }' where field_name = 'DAYS_LEFT' and view_id in (1800000000000003337, 1800000000000003350, 1800000000000003363);
| update cnf_module set main_table_id=1800000000000003301 where module_id=1800000000000003300;
| insert into sys_keyword (keyword_id,keyword_name,keyword_type,separate,keyword_describe,sort_num,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003379','到期提醒设置','1','','到期提醒的参数,参数名「提前天数」的值为提前多少天开始提醒','11','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into sys_keyword_param (param_id,keyword_id,parent_id,param_name,param_value,param_describe,sort_num,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003380','1800000000000003379','0','提前天数','30','1~365,默认30','1','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into sys_group (group_id, group_dept_id, group_dept_name, group_name, group_code, group_description, group_type, sort_num, create_user_id, create_user_name, create_time, last_modify_time) values (1800000000000003381, null, '', '资产管理员', 'FAMS_ASSET_ADMIN', '接收资产到期提醒消息的人员,请在群组管理中添加成员', '0', 1, 1118460701772660737, '管理员', now(), now());
| insert into cnf_task (task_id,task_name,execution_frequency,task_state,task_assembly,class_name,date_for_once,time_for_once,execution_type,day,week,week_items,month,start_day,end_day,day_frequency_type,day_time,day_time_interval,interval_type,start_day_time,end_day_time,start_date,end_data_type,end_date,cron_expression,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003382','资产到期提醒','1','1','zbooksoft.fams.job','AssetRemindJob','',NULL,'0','1',NULL,NULL,NULL,'','','0','01:00:00',NULL,NULL,'','','2026-10-16','0','','0 0 1 * * ?','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into sys_menuitem (item_id,menu_id,item_name,parent_id,menuitem_type,module_id,module_name,view_id,url,icon,open_type,open_height,open_width,tips_information,default_opened,is_permission,permission_name,sort_num,item_code,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003383','1118451798911995906','到期提醒','1800000000000001417','0',NULL,'',NULL,'','fa fa-bell','0','','','','0','0',NULL,'6','0006.0006','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into sys_menuitem (item_id,menu_id,item_name,parent_id,menuitem_type,module_id,module_name,view_id,url,icon,open_type,open_height,open_width,tips_information,default_opened,is_permission,permission_name,sort_num,item_code,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003384','1118451798911995906','待处理提醒','1800000000000003383','1','1800000000000003300','到期提醒','1800000000000003337','','fa fa-exclamation-circle','0','','','','0','0',NULL,'1','0006.0006.0001','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into sys_menuitem (item_id,menu_id,item_name,parent_id,menuitem_type,module_id,module_name,view_id,url,icon,open_type,open_height,open_width,tips_information,default_opened,is_permission,permission_name,sort_num,item_code,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003385','1118451798911995906','我的到期提醒','1800000000000003383','1','1800000000000003300','到期提醒','1800000000000003350','','fa fa-user','0','','','','0','0',NULL,'2','0006.0006.0002','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into sys_menuitem (item_id,menu_id,item_name,parent_id,menuitem_type,module_id,module_name,view_id,url,icon,open_type,open_height,open_width,tips_information,default_opened,is_permission,permission_name,sort_num,item_code,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003386','1118451798911995906','全部提醒记录','1800000000000003383','1','1800000000000003300','到期提醒','1800000000000003363','','fa fa-history','0','','','','0','0',NULL,'3','0006.0006.0003','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
| insert into sys_menuitem (item_id,menu_id,item_name,parent_id,menuitem_type,module_id,module_name,view_id,url,icon,open_type,open_height,open_width,tips_information,default_opened,is_permission,permission_name,sort_num,item_code,create_user_id,create_user_name,create_time,modify_time) values ('1800000000000003387','1118451798911995906','统计分析','1800000000000001417','2',NULL,'',NULL,'fams/stat/index','fa fa-bar-chart','0','','','','0','0',NULL,'7','0006.0007','1118460701772660737','管理员','2026-10-16 16:00:00','2026-10-16 16:00:00');
|
|