update_sys_data.sql

INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '待开票', '0', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:43:26', '1', '2024-12-20 17:45:36', b'0', 'To be invoiced', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '已开票', '1', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:43:52', '1', '2024-12-20 17:43:52', b'0', 'Have been invoiced', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '已取消', '2', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:44:27', '1', '2024-12-20 17:44:27', b'0', 'canceled', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (3, '不开票', '3', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-20 17:45:21', '1', '2024-12-20 17:45:48', b'0', 'no invoicing', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '未录入', '0', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:07:00', '1', '2024-12-20 18:07:00', b'0', 'Not entered', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '未提交', '1', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:07:30', '1', '2024-12-20 18:07:30', b'0', 'unsubmitted', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '部分提交', '2', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:07:52', '1', '2024-12-20 18:07:52', b'0', 'Submitted in part', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (3, '未审批', '3', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:08:12', '1', '2024-12-20 18:08:12', b'0', 'Not approved', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (4, '部分审批', '4', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:08:38', '1', '2024-12-20 18:08:38', b'0', 'Partial approval', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (5, '全部审批', '5', 'receipt_detail_status', 0, 'default', '', NULL, '1', '2024-12-20 18:09:06', '1', '2024-12-20 18:09:06', b'0', 'All approved', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (4, '无申请记录', '4', 'invoicing_status', 0, 'default', '', NULL, '1', '2024-12-23 10:22:54', '1', '2024-12-23 10:23:09', b'0', 'no record', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '已提交', '0', 'invoice_data_status', 0, 'default', '', NULL, '1', '2024-12-23 10:23:55', '1', '2024-12-25 15:02:17', b'0', 'Submit', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '已驳回', '1', 'invoice_data_status', 0, 'default', '', NULL, '1', '2024-12-23 10:24:10', '1', '2024-12-25 15:02:27', b'0', 'Reject', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (0, '申请开票', '0', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:48:53', '1', '2024-12-26 13:48:53', b'0', 'Apply Invoice', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (1, '取消开票', '1', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:49:10', '1', '2024-12-26 13:49:10', b'0', 'Cancel Invoice', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (2, '修改开票信息', '2', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:49:29', '1', '2024-12-26 13:49:29', b'0', 'Modify Invoice Info', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (3, '删除开票信息', '3', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:49:51', '1', '2024-12-26 13:49:51', b'0', 'Delete Invoice Info', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (4, '驳回开票资料', '4', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:50:06', '1', '2024-12-26 13:50:06', b'0', 'Reject Invoice Data', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (5, '提交开票', '5', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:50:23', '1', '2024-12-26 13:50:23', b'0', 'Submit Invoice', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES (6, '修改开票资料', '6', 'invoicing_link', 0, 'default', '', NULL, '1', '2024-12-26 13:50:40', '1', '2024-12-26 13:50:40', b'0', 'Modify Invoice Data', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 0, '无需审核', '2', 'invoice_data_status', 0, 'default', '', NULL, '1', '2024-12-27 14:59:20', '1', '2024-12-27 14:59:20', b'0', 'No audit required', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 4, '审批拒绝', '4', 'receipt_item_state', 0, 'default', '', NULL, '1', '2024-12-30 13:46:20', '1', '2024-12-30 13:46:20', b'0', 'Approval rejected', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 0, '单个生成', '0', 'receipt_generate_path', 0, 'default', '', NULL, '1', '2024-12-31 16:32:58', '1', '2024-12-31 16:32:58', b'0', 'single', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 1, '批量生成', '1', 'receipt_generate_path', 0, 'default', '', NULL, '1', '2024-12-31 16:34:08', '1', '2024-12-31 16:34:08', b'0', 'batch', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 0, '创建收款单', '0', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:32:06', '1', '2025-01-02 17:32:06', b'0', 'Create Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 1, '编辑收款单', '1', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:32:20', '1', '2025-01-02 17:32:20', b'0', 'Edit Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 2, '提交收款单', '2', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:33:24', '1', '2025-01-02 17:33:24', b'0', 'Submit Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 3, '反审核收款单', '3', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:33:45', '1', '2025-01-02 17:33:45', b'0', 'Reject Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 4, '审核收款单', '4', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:34:08', '1', '2025-01-02 17:34:08', b'0', 'Approve Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 5, '提交银行收款明细', '5', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:34:34', '1', '2025-01-02 17:34:34', b'0', 'Submit Bank Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 6, '反审核银行收款明细', '6', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:34:56', '1', '2025-01-02 17:34:56', b'0', 'Reject Bank Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 7, '审批银行收款明细', '7', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:35:17', '1', '2025-01-02 17:35:17', b'0', 'Approve Bank Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 8, '核销收款单', '8', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:35:36', '1', '2025-01-02 17:35:36', b'0', 'Write Off Receipt', NULL);
INSERT INTO `system_dict_data` (`sort`, `label`, `value`, `dict_type`, `status`, `color_type`, `css_class`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `label_en`, `label_fr`) VALUES ( 9, '反核销收款单', '9', 'receipt_link', 0, 'default', '', NULL, '1', '2025-01-02 17:35:52', '1', '2025-01-02 17:35:52', b'0', 'Reject Write Off Receipt', NULL);


INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '开票状态', 'invoicing_status', 0, NULL, '1', '2024-12-20 17:42:06', '1', '2024-12-20 17:42:06', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '开票资料状态', 'invoice_data_status', 0, NULL, '1', '2024-12-20 18:05:13', '1', '2024-12-20 18:05:13', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '明细状态', 'receipt_detail_status', 0, NULL, '1', '2024-12-20 18:06:26', '1', '2024-12-20 18:06:26', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '开票环节', 'invoicing_link', 0, '用于日志记录', '1', '2024-12-26 13:48:05', '1', '2024-12-26 13:48:05', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '收款单生成路径', 'receipt_generate_path', 0, NULL, '1', '2024-12-31 16:31:49', '1', '2024-12-31 16:31:49', b'0');
INSERT INTO `system_dict_type` (`name`, `type`, `status`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) VALUES ( '收款单日志环节', 'receipt_link', 0, NULL, '1', '2025-01-02 17:31:39', '1', '2025-01-02 17:31:39', b'0');



INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('费用明细', '', 2, 1, 1624, 'chargeDetails', 'druid', 'ecw/financial/chargeDetails', 0, '1', '2024-12-20 13:56:04', '1', '2024-12-20 13:56:04', b'0', b'1', 'chargeDetails', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('自动审批规则', '', 2, 1, 1624, 'setAutoApprovalRules', 'checkbox', 'ecw/financial/setAutoApprovalRules', 0, '1', '2024-12-20 16:34:19', '1', '2024-12-20 16:34:19', b'0', b'1', 'Automatic approval rules', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('申请开票', 'ecw:voucher:applyInvoice', 3, 13, 1634, '', '', '', 0, '1', '2024-12-23 09:24:01', '1', '2024-12-23 09:24:01', b'0', b'1', 'Apply for Invoice', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('修改收款单', 'ecw:voucher:editReceipt', 3, 7, 1634, '', '', '', 0, '1', '2024-12-23 09:27:51', '1', '2024-12-23 09:27:51', b'0', b'1', 'Modify the receipt', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('修改开票申请', 'ecw:voucher:editInvoiceApplication', 3, 2, 1634, '', '', '', 0, '1', '2024-12-23 09:32:26', '1', '2024-12-23 09:32:26', b'0', b'1', 'Modify Invoice application', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('取消开票', 'ecw:voucher:cancalInvoicing', 3, 1, 1634, '', '', '', 0, '1', '2024-12-23 09:38:04', '1', '2024-12-23 09:38:04', b'0', b'1', 'Cancel invoicing', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('开票信息', 'ecw:voucher:invoiceInformation', 3, 4, 1634, '', '', '', 0, '1', '2024-12-23 09:46:53', '1', '2024-12-23 09:46:53', b'0', b'1', 'invoice information', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('导入银行收款信息', 'ecw:voucher:importBankCollectionInfo', 3, 2, 1634, '', '', '', 0, '1', '2024-12-23 10:23:51', '1', '2024-12-23 10:23:51', b'0', b'1', 'Import bank collection information', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('开票申请/修改', '', 2, 1, 1624, 'invoiceOperate', 'bug', 'ecw/financial/invoiceOperate', 0, '1', '2024-12-23 11:17:32', '1', '2024-12-23 11:17:32', b'0', b'0', 'invoice application/amendment', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('开票管理', '', 2, 2, 1624, 'invoiceManagement', 'order', 'ecw/financial/invoiceManagement', 0, '1', '2024-12-24 18:13:46', '1', '2024-12-24 18:13:46', b'0', b'1', 'invoiceManagement', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('收款数据审批列表', '', 2, 2, 1624, 'collectionApprovalList', 'clipboard', 'ecw/financial/collectionApprovalList', 0, '1', '2025-01-03 08:58:08', '1', '2025-01-03 08:58:08', b'0', b'1', 'collectionApprovalList', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('审批', 'ecw:collectionApprovalList:update', 3, 1, 2388, '', '', '', 0, '1', '2025-01-03 16:59:36', '1', '2025-01-03 16:59:36', b'0', b'1', 'approve', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('批量生成收款单', '', 2, 12, 1624, 'batchGenerateReceipt/:id', 'button', 'ecw/financial/batchGenerateReceipt', 0, '2696', '2025-01-08 09:57:18', '2696', '2025-01-09 10:53:46', b'0', b'0', 'batchGenerateReceipt', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('批量生成收款单列表', '', 2, 7, 1624, 'batchGenerateReceiptList', 'component', 'ecw/financial/batchGenerateReceiptList', 0, '2696', '2025-01-08 09:58:54', '2696', '2025-01-08 09:58:54', b'0', b'1', 'batchGenerateReceiptList', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('银行收支明细', '', 2, 1, 1624, 'bankBalanceDetails', 'dashboard', 'ecw/financial/bankBalanceDetails', 0, '2696', '2025-01-09 13:44:20', '2696', '2025-01-09 13:50:15', b'0', b'1', 'bank Balance Details', b'0', NULL, NULL);
INSERT INTO `system_menu` (`name`, `permission`, `menu_type`, `sort`, `parent_id`, `path`, `icon`, `component`, `status`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `is_show_in_menu_bar`, `name_en`, `keepalive`, `redirect`, `badge_field`) VALUES ('单个订单费用明细', '', 2, 4, 1624, 'orderItemCostDetails/:id/:drawee', 'theme', 'ecw/financial/orderItemCostDetails', 0, '2696', '2025-01-09 15:30:19', '2696', '2025-01-13 10:17:48', b'0', b'0', 'orderItemCostDetails', b'0', NULL, NULL);


UPDATE `system_menu` SET `name` = '银行账户', `permission` = '', `menu_type` = 2, `sort` = 9, `parent_id` = 1624, `path` = 'bank-account', `icon` = 'lock', `component` = 'ecw/bankAccount/index', `status` = 0, `creator` = '', `create_time` = '2022-05-09 11:40:51', `updater` = '1', `update_time` = '2024-12-20 13:36:45', `deleted` = b'0', `is_show_in_menu_bar` = b'1', `name_en` = 'Bank account management', `keepalive` = b'0', `redirect` = NULL, `badge_field` = NULL WHERE `id` = 1269;
UPDATE `system_dict_data` SET `status` = 1 WHERE `id` = 1784;
UPDATE `system_dict_data` SET `label` = '审批拒绝' WHERE `id` = 2096;