From d48cc95290c21992fb8aef4cd2a6f9171be79511 Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期二, 04 十一月 2025 14:26:48 +0800 Subject: [PATCH] 移除不必要文件 --- /dev/null | 50 -------------------------------------------------- version/bak/yhfzasrs.bak | 0 version/v1.0.0/truncate.sql | 5 ++++- 3 files changed, 4 insertions(+), 51 deletions(-) diff --git a/src/main/java/appVersion.sql b/src/main/java/appVersion.sql deleted file mode 100644 index 870e5e6..0000000 --- a/src/main/java/appVersion.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save appVersion record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'appVersion/appVersion.html', 'appVersion绠＄悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'appVersion#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'appVersion#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'appVersion#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'appVersion#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'appVersion#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'appVersion/appVersion.html', N'appVersion绠＄悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'appVersion#view', N'鏌ヨ', '', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'appVersion#btn-add', N'鏂板', '', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'appVersion#btn-edit', N'缂栬緫', '', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'appVersion#btn-delete', N'鍒犻櫎', '', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'appVersion#btn-export', N'瀵煎嚭', '', '3', '4', '1'); diff --git a/src/main/java/basContainer.sql b/src/main/java/basContainer.sql deleted file mode 100644 index e1cd330..0000000 --- a/src/main/java/basContainer.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save basContainer record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'basContainer/basContainer.html', 'basContainer绠＄悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'basContainer#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'basContainer#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'basContainer#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'basContainer#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'basContainer#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'basContainer/basContainer.html', N'basContainer绠＄悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'basContainer#view', N'鏌ヨ', '90623', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'basContainer#btn-add', N'鏂板', '90623', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'basContainer#btn-edit', N'缂栬緫', '90623', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'basContainer#btn-delete', N'鍒犻櫎', '90623', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'basContainer#btn-export', N'瀵煎嚭', '90623', '3', '4', '1'); diff --git a/version/bak/lfdasrs b/version/bak/lfdasrs deleted file mode 100644 index 1e823af..0000000 --- a/version/bak/lfdasrs +++ /dev/null Binary files differ diff --git a/src/main/resources/yhfzasrs.bak b/version/bak/yhfzasrs.bak similarity index 100% rename from src/main/resources/yhfzasrs.bak rename to version/bak/yhfzasrs.bak Binary files differ diff --git "a/version/doc/WCS\344\270\216PLC\351\200\232\350\256\257\346\216\245\345\217\243\345\215\217\350\256\256V1.docx" "b/version/doc/WCS\344\270\216PLC\351\200\232\350\256\257\346\216\245\345\217\243\345\215\217\350\256\256V1.docx" deleted file mode 100644 index 8a6c014..0000000 --- "a/version/doc/WCS\344\270\216PLC\351\200\232\350\256\257\346\216\245\345\217\243\345\215\217\350\256\256V1.docx" +++ /dev/null Binary files differ diff --git "a/version/doc/\344\270\255\346\211\254WCS\344\270\216\345\240\206\345\236\233\346\234\272\351\200\232\350\256\257\345\215\217\350\256\25620220114.docx" "b/version/doc/\344\270\255\346\211\254WCS\344\270\216\345\240\206\345\236\233\346\234\272\351\200\232\350\256\257\345\215\217\350\256\25620220114.docx" deleted file mode 100644 index 9eb9525..0000000 --- "a/version/doc/\344\270\255\346\211\254WCS\344\270\216\345\240\206\345\236\233\346\234\272\351\200\232\350\256\257\345\215\217\350\256\25620220114.docx" +++ /dev/null Binary files differ diff --git "a/version/doc/\345\225\206\345\223\201\346\241\243\346\241\210Excel\345\257\274\345\205\245\346\250\241\346\235\277.xlsx" "b/version/doc/\345\225\206\345\223\201\346\241\243\346\241\210Excel\345\257\274\345\205\245\346\250\241\346\235\277.xlsx" deleted file mode 100644 index 87db32a..0000000 --- "a/version/doc/\345\225\206\345\223\201\346\241\243\346\241\210Excel\345\257\274\345\205\245\346\250\241\346\235\277.xlsx" +++ /dev/null Binary files differ diff --git "a/version/doc/\350\207\252\345\212\250\345\214\226\347\253\213\344\275\223\344\273\223\345\272\223ASRS\344\270\216ERP\345\257\271\346\216\245\345\215\217\350\256\256_20220625A.docx" "b/version/doc/\350\207\252\345\212\250\345\214\226\347\253\213\344\275\223\344\273\223\345\272\223ASRS\344\270\216ERP\345\257\271\346\216\245\345\215\217\350\256\256_20220625A.docx" deleted file mode 100644 index cc991ee..0000000 --- "a/version/doc/\350\207\252\345\212\250\345\214\226\347\253\213\344\275\223\344\273\223\345\272\223ASRS\344\270\216ERP\345\257\271\346\216\245\345\215\217\350\256\256_20220625A.docx" +++ /dev/null Binary files differ diff --git a/version/v1.0.0/truncate.sql b/version/v1.0.0/truncate.sql index 0577a5a..4cfcb06 100644 --- a/version/v1.0.0/truncate.sql +++ b/version/v1.0.0/truncate.sql @@ -1,10 +1,13 @@ truncate table asr_adj_detl; truncate table asr_wrk_detl; truncate table asr_wrk_detl_log; +truncate table asr_wrk_mast; truncate table asr_wrk_mast_log; --- truncate table bas_mat_code; truncate table bas_mat_code_log; truncate table cust_wait_pakin; truncate table cust_wait_pakin_log; truncate table sys_operate_log; truncate table sys_user_login; +truncate table man_api_log; +truncate table asr_bas_err_log +truncate table asr_bas_devp_err_log \ No newline at end of file diff --git a/version/v1.0.1/asr_loc_use_view.sql b/version/v1.0.1/asr_loc_use_view.sql deleted file mode 100644 index b634f44..0000000 --- a/version/v1.0.1/asr_loc_use_view.sql +++ /dev/null @@ -1,31 +0,0 @@ -USE [cool] -GO - -/****** Object: View [dbo].[asr_loc_use_view] Script Date: 2020/6/15 9:45:48 ******/ -SET ANSI_NULLS ON -GO - -SET QUOTED_IDENTIFIER ON -GO - - -create view [dbo].[asr_loc_use_view] as -select SUM(fqty) fqty,SUM(oqty) oqty,SUM(uqty) uqty,SUM(xqty) xqty -from ( -select COUNT(*) fqty,0 oqty,0 uqty,0 xqty from asr_loc_mast -where loc_sts='F' or loc_sts='D' -union all -select 0,COUNT(*),0,0 from asr_loc_mast -where loc_sts='O' -union all -select 0,0,COUNT(*),0 from asr_loc_mast -where loc_sts='P' or loc_sts='Q' or loc_sts='R' or loc_sts='S' -union all -select 0,0,0,COUNT(*) from asr_loc_mast -where loc_sts='X' -) a - - -GO - - diff --git a/version/v1.0.1/asr_stk_use_view.sql b/version/v1.0.1/asr_stk_use_view.sql deleted file mode 100644 index d72b7e2..0000000 --- a/version/v1.0.1/asr_stk_use_view.sql +++ /dev/null @@ -1,50 +0,0 @@ -USE [cool] -GO - -/****** Object: View [dbo].[asr_stk_use_view] Script Date: 2020/6/15 9:50:53 ******/ -SET ANSI_NULLS ON -GO - -SET QUOTED_IDENTIFIER ON -GO - -create view [dbo].[asr_stk_use_view] as -SELECT row1, SUM(total_qty) AS total_qty, SUM(full_qty) AS full_qty, SUM(null_qty) AS null_qty, SUM(forbid_qty) AS forbid_qty, SUM(empty_qty) AS empty_qty, SUM(use_qty) AS use_qty, CONVERT(float, - SUM(CAST(full_qty AS DECIMAL(12, 2))) * 100 / SUM(total_qty)) AS full_rate, CONVERT(float, (SUM(CAST(full_qty AS DECIMAL(12, 2))) + SUM(forbid_qty) + SUM(empty_qty) + SUM(use_qty)) - * 100 / SUM(total_qty)) AS occ_rate -FROM (SELECT row1, COUNT(*) AS total_qty, 0 AS full_qty, 0 AS null_qty, 0 AS forbid_qty, 0 AS empty_qty, 0 AS use_qty - FROM dbo.asr_loc_mast - WHERE (whs_type = 1) - GROUP BY row1 - UNION ALL - SELECT row1, 0 AS Expr1, COUNT(*) AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS Expr5, 0 AS Expr6 - FROM dbo.asr_loc_mast AS asr_loc_mast_5 - WHERE (loc_sts = 'F') AND (whs_type = 1) - GROUP BY row1 - UNION ALL - SELECT row1, 0 AS Expr1, 0 AS Expr2, COUNT(*) AS Expr3, 0 AS Expr4, 0 AS Expr5, 0 AS Expr6 - FROM dbo.asr_loc_mast AS asr_loc_mast_4 - WHERE (loc_sts = 'O') AND (whs_type = 1) - GROUP BY row1 - UNION ALL - SELECT row1, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3, COUNT(*) AS Expr4, 0 AS Expr5, 0 AS Expr6 - FROM dbo.asr_loc_mast AS asr_loc_mast_3 - WHERE (loc_sts = 'X') AND (whs_type = 1) - GROUP BY row1 - UNION ALL - SELECT row1, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, COUNT(*) AS Expr5, 0 AS Expr6 - FROM dbo.asr_loc_mast AS asr_loc_mast_2 - WHERE (loc_sts = 'D') AND (whs_type = 1) - GROUP BY row1 - UNION ALL - SELECT row1, 0 AS Expr1, 0 AS Expr2, 0 AS Expr3, 0 AS Expr4, 0 AS Expr5, COUNT(*) AS Expr6 - FROM dbo.asr_loc_mast AS asr_loc_mast_1 - WHERE (loc_sts = 'R' OR - loc_sts = 'S' OR - loc_sts = 'P' OR - loc_sts = 'Q') AND (whs_type = 1) - GROUP BY row1) AS a -GROUP BY row1 -GO - - -- Gitblit v1.9.1