From 2790d2558ef656ccddb4dbc94409decc8d227a1e Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期四, 05 九月 2024 10:10:02 +0800 Subject: [PATCH] #许可证 --- src/main/java/com/zy/system/controller/LicenseCreatorController.java | 18 +---- /dev/null | 18 ------ src/main/java/com/zy/system/entity/license/LicenseCheckListener.java | 34 ++++++++-- src/main/java/com/zy/system/entity/license/CustomKeyStoreParam.java | 2 src/main/java/com/zy/common/web/AuthController.java | 13 +--- src/main/java/com/zy/system/entity/license/LicenseVerify.java | 9 +++ src/main/java/com/zy/system/timer/LicenseTimer.java | 40 +++++++++++++ 7 files changed, 84 insertions(+), 50 deletions(-) diff --git a/src/main/java/autoMove.sql b/src/main/java/autoMove.sql deleted file mode 100644 index 86395f2..0000000 --- a/src/main/java/autoMove.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save autoMove record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'autoMove/autoMove.html', 'autoMove绠$悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'autoMove#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'autoMove#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'autoMove#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'autoMove#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'autoMove#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'autoMove/autoMove.html', N'autoMove绠$悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'autoMove#view', N'鏌ヨ', '', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'autoMove#btn-add', N'鏂板', '', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'autoMove#btn-edit', N'缂栬緫', '', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'autoMove#btn-delete', N'鍒犻櫎', '', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'autoMove#btn-export', N'瀵煎嚭', '', '3', '4', '1'); diff --git a/src/main/java/com/zy/common/web/AuthController.java b/src/main/java/com/zy/common/web/AuthController.java index b85c56a..3d1faab 100644 --- a/src/main/java/com/zy/common/web/AuthController.java +++ b/src/main/java/com/zy/common/web/AuthController.java @@ -16,6 +16,7 @@ import com.zy.system.entity.*; import com.zy.system.entity.license.LicenseVerify; import com.zy.system.service.*; +import com.zy.system.timer.LicenseTimer; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.transaction.annotation.Transactional; @@ -46,21 +47,15 @@ private PermissionService permissionService; @Autowired private RolePermissionService rolePermissionService; + @Autowired + private LicenseTimer licenseTimer; @RequestMapping("/login.action") @ManagerAuth(value = ManagerAuth.Auth.NONE, memo = "鐧诲綍") public R loginAction(String username, String password){ //楠岃瘉璁稿彲璇佹槸鍚︽湁鏁� - LicenseVerify licenseVerify = new LicenseVerify(); - boolean verify = licenseVerify.verify(); - if (!verify) {//璁稿彲璇佸凡澶辨晥 + if (!licenseTimer.getSystemSupport()){ return R.parse(CodeRes.SYSTEM_20001); - } - if (username.equals("super") && password.equals(Cools.md5(superPwd))) { - Map<String, Object> res = new HashMap<>(); - res.put("username", username); - res.put("token", Cools.enToken(System.currentTimeMillis() + username, superPwd)); - return R.ok(res); } EntityWrapper<User> userWrapper = new EntityWrapper<>(); userWrapper.eq("username", username); diff --git a/src/main/java/com/zy/system/controller/LicenseCreatorController.java b/src/main/java/com/zy/system/controller/LicenseCreatorController.java index 0aafb3b..6d0c904 100644 --- a/src/main/java/com/zy/system/controller/LicenseCreatorController.java +++ b/src/main/java/com/zy/system/controller/LicenseCreatorController.java @@ -3,6 +3,7 @@ import com.core.common.Cools; import com.core.common.R; import com.zy.system.entity.license.*; +import com.zy.system.timer.LicenseTimer; import de.schlichtherle.license.LicenseContent; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; @@ -29,7 +30,8 @@ @Autowired private LicenseCheckListener licenseCheckListener; - + @Autowired + private LicenseTimer licenseTimer; /** * 鑾峰彇鏈嶅姟鍣ㄧ‖浠朵俊鎭� * @param osName 鎿嶄綔绯荤粺绫诲瀷锛屽鏋滀负绌哄垯鑷姩鍒ゆ柇 @@ -61,19 +63,7 @@ */ @RequestMapping(value = "/getLicenseDays") public R getLicenseDays() { - LicenseVerify licenseVerify = new LicenseVerify(); - LicenseContent verifyInfo = licenseVerify.getVerifyInfo(); - if (verifyInfo == null) { - return R.error(); - } - - Date start = new Date(); - Date end = verifyInfo.getNotAfter(); - Long starTime = start.getTime(); - Long endTime = end.getTime(); - Long num = endTime - starTime;//鏃堕棿鎴崇浉宸殑姣鏁� - int day = (int) (num / 24 / 60 / 60 / 1000); - return R.ok().add(day); + return R.ok(licenseTimer.getLicenseDays()); } @RequestMapping(value = "/updateLicense") diff --git a/src/main/java/com/zy/system/entity/license/CustomKeyStoreParam.java b/src/main/java/com/zy/system/entity/license/CustomKeyStoreParam.java index 3d4e4b9..1732b20 100644 --- a/src/main/java/com/zy/system/entity/license/CustomKeyStoreParam.java +++ b/src/main/java/com/zy/system/entity/license/CustomKeyStoreParam.java @@ -47,7 +47,7 @@ */ @Override public InputStream getStream() throws IOException { - final InputStream in = new FileInputStream(new File(storePath)); + final InputStream in = this.getClass().getClassLoader().getResourceAsStream(storePath); if (null == in) { throw new FileNotFoundException(storePath); } diff --git a/src/main/java/com/zy/system/entity/license/LicenseCheckListener.java b/src/main/java/com/zy/system/entity/license/LicenseCheckListener.java index 1659df2..b3249d7 100644 --- a/src/main/java/com/zy/system/entity/license/LicenseCheckListener.java +++ b/src/main/java/com/zy/system/entity/license/LicenseCheckListener.java @@ -1,9 +1,11 @@ package com.zy.system.entity.license; import com.core.common.Cools; +import com.zy.system.timer.LicenseTimer; import de.schlichtherle.license.LicenseContent; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.context.ApplicationContext; import org.springframework.context.ApplicationListener; @@ -11,6 +13,7 @@ import org.springframework.stereotype.Component; import java.io.File; +import java.util.Date; /** * 鍦ㄩ」鐩惎鍔ㄦ椂瀹夎璇佷功 @@ -48,6 +51,8 @@ */ @Value("${license.publicKeysStorePath}") private String publicKeysStorePath; + @Autowired + private LicenseTimer licenseTimer; @Override public void onApplicationEvent(ContextRefreshedEvent event) { @@ -64,18 +69,18 @@ logger.info("++++++++ 寮�濮嬪姞杞借鍙瘉 ++++++++"); try { - String publicKeysStoreFileName = this.getClass().getClassLoader().getResource(publicKeysStorePath).getPath(); - File publicKeysStoreFile = new File(publicKeysStoreFileName); - - String licensePathFileName = this.getClass().getClassLoader().getResource(licensePath).getPath(); - File licensePathFile = new File(licensePathFileName); +// String publicKeysStoreFileName = this.getClass().getClassLoader().getResource(publicKeysStorePath).getPath(); +// File publicKeysStoreFile = new File(publicKeysStoreFileName); +// +// String licensePathFileName = this.getClass().getClassLoader().getResource(licensePath).getPath(); +// File licensePathFile = new File(licensePathFileName); LicenseVerifyParam param = new LicenseVerifyParam(); param.setSubject(subject); param.setPublicAlias(publicAlias); param.setStorePass(storePass); - param.setLicensePath(licensePathFile.getPath()); - param.setPublicKeysStorePath(publicKeysStoreFile.getPath()); + param.setLicensePath(licensePath); + param.setPublicKeysStorePath(publicKeysStorePath); LicenseVerify licenseVerify = new LicenseVerify(); //瀹夎璇佷功 @@ -83,12 +88,25 @@ logger.info("++++++++ 璁稿彲璇佸姞杞界粨鏉� ++++++++"); + licenseTimer.setSystemSupport(install!=null); + + if (install != null) { + Date start = new Date(); + Date end = install.getNotAfter(); + Long starTime = start.getTime(); + Long endTime = end.getTime(); + Long num = endTime - starTime;//鏃堕棿鎴崇浉宸殑姣鏁� + int day = (int) (num / 24 / 60 / 60 / 1000); + licenseTimer.setLicenseDays(day); + } + + return install != null; } catch (Exception e) { return false; } } - + licenseTimer.setSystemSupport(false); return false; } } \ No newline at end of file diff --git a/src/main/java/com/zy/system/entity/license/LicenseVerify.java b/src/main/java/com/zy/system/entity/license/LicenseVerify.java index 2175930..fd95fca 100644 --- a/src/main/java/com/zy/system/entity/license/LicenseVerify.java +++ b/src/main/java/com/zy/system/entity/license/LicenseVerify.java @@ -3,8 +3,11 @@ import de.schlichtherle.license.*; import org.apache.logging.log4j.LogManager; import org.apache.logging.log4j.Logger; +import org.apache.tomcat.util.http.fileupload.IOUtils; import java.io.File; +import java.io.FileOutputStream; +import java.io.InputStream; import java.text.DateFormat; import java.text.MessageFormat; import java.text.SimpleDateFormat; @@ -28,6 +31,12 @@ LicenseManager licenseManager = LicenseManagerHolder.getInstance(initLicenseParam(param)); licenseManager.uninstall(); + InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream(param.getLicensePath()); + File file = new File(param.getLicensePath()); + try (FileOutputStream out = new FileOutputStream(file)) { + IOUtils.copy(inputStream, out); + } + result = licenseManager.install(new File(param.getLicensePath())); logger.info(MessageFormat.format("璁稿彲璇佸姞杞芥垚鍔燂紝璁稿彲璇佹湁鏁堟湡锛歿0} - {1}",format.format(result.getNotBefore()),format.format(result.getNotAfter()))); }catch (Exception e){ diff --git a/src/main/java/com/zy/system/timer/LicenseTimer.java b/src/main/java/com/zy/system/timer/LicenseTimer.java new file mode 100644 index 0000000..a56a24c --- /dev/null +++ b/src/main/java/com/zy/system/timer/LicenseTimer.java @@ -0,0 +1,40 @@ +package com.zy.system.timer; + +import com.zy.system.entity.license.LicenseVerify; +import org.springframework.scheduling.annotation.Scheduled; +import org.springframework.stereotype.Component; + +@Component +public class LicenseTimer { + + private static boolean SYSTEM_SUPPORT = false;//绯荤粺婵�娲荤姸鎬侊紝榛樿鍏抽棴 + + private static int LICENSE_DAYS = 0;//璁稿彲璇佸ぉ鏁� + + //姣忓ぉ鏅氫笂11鐐规洿鏂扮郴缁熸縺娲荤姸鎬� + @Scheduled(cron = "0 0 23 * * ? ") + public void timer() { +// System.out.println(SYSTEM_SUPPORT); + //楠岃瘉璁稿彲璇佹槸鍚︽湁鏁� + LicenseVerify licenseVerify = new LicenseVerify(); + boolean verify = licenseVerify.verify(); + setSystemSupport(verify);//鏇存柊绯荤粺婵�娲荤姸鎬� + } + + public boolean getSystemSupport() { + return SYSTEM_SUPPORT; + } + + public void setSystemSupport(boolean systemSupport) { + SYSTEM_SUPPORT = systemSupport; + } + + public int getLicenseDays() { + return LICENSE_DAYS; + } + + public void setLicenseDays(int licenseDays) { + LICENSE_DAYS = licenseDays; + } + +} diff --git a/src/main/java/rowLastnoType.sql b/src/main/java/rowLastnoType.sql deleted file mode 100644 index 8cad4fa..0000000 --- a/src/main/java/rowLastnoType.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save rowLastnoType record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'rowLastnoType/rowLastnoType.html', 'rowLastnoType绠$悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'rowLastnoType#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'rowLastnoType#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'rowLastnoType#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'rowLastnoType#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'rowLastnoType#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'rowLastnoType/rowLastnoType.html', N'rowLastnoType绠$悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'rowLastnoType#view', N'鏌ヨ', '', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'rowLastnoType#btn-add', N'鏂板', '', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'rowLastnoType#btn-edit', N'缂栬緫', '', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'rowLastnoType#btn-delete', N'鍒犻櫎', '', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'rowLastnoType#btn-export', N'瀵煎嚭', '', '3', '4', '1'); diff --git a/src/main/java/wrkMastExecute.sql b/src/main/java/wrkMastExecute.sql deleted file mode 100644 index 910ba79..0000000 --- a/src/main/java/wrkMastExecute.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save wrkMastExecute record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecute/wrkMastExecute.html', 'wrkMastExecute绠$悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecute#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecute#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecute#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecute#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecute#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecute/wrkMastExecute.html', N'wrkMastExecute绠$悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecute#view', N'鏌ヨ', '', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecute#btn-add', N'鏂板', '', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecute#btn-edit', N'缂栬緫', '', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecute#btn-delete', N'鍒犻櫎', '', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecute#btn-export', N'瀵煎嚭', '', '3', '4', '1'); diff --git a/src/main/java/wrkMastExecuteLog.sql b/src/main/java/wrkMastExecuteLog.sql deleted file mode 100644 index cdd548f..0000000 --- a/src/main/java/wrkMastExecuteLog.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save wrkMastExecuteLog record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecuteLog/wrkMastExecuteLog.html', 'wrkMastExecuteLog绠$悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecuteLog#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecuteLog#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecuteLog#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecuteLog#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastExecuteLog#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecuteLog/wrkMastExecuteLog.html', N'wrkMastExecuteLog绠$悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecuteLog#view', N'鏌ヨ', '', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecuteLog#btn-add', N'鏂板', '', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecuteLog#btn-edit', N'缂栬緫', '', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecuteLog#btn-delete', N'鍒犻櫎', '', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastExecuteLog#btn-export', N'瀵煎嚭', '', '3', '4', '1'); diff --git a/src/main/java/wrkMastFourWarVehicle.sql b/src/main/java/wrkMastFourWarVehicle.sql deleted file mode 100644 index 7e39d7a..0000000 --- a/src/main/java/wrkMastFourWarVehicle.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save wrkMastFourWarVehicle record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicle/wrkMastFourWarVehicle.html', 'wrkMastFourWarVehicle绠$悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicle#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicle#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicle#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicle#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicle#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicle/wrkMastFourWarVehicle.html', N'wrkMastFourWarVehicle绠$悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicle#view', N'鏌ヨ', '', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicle#btn-add', N'鏂板', '', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicle#btn-edit', N'缂栬緫', '', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicle#btn-delete', N'鍒犻櫎', '', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicle#btn-export', N'瀵煎嚭', '', '3', '4', '1'); diff --git a/src/main/java/wrkMastFourWarVehicleLog.sql b/src/main/java/wrkMastFourWarVehicleLog.sql deleted file mode 100644 index 5f94b75..0000000 --- a/src/main/java/wrkMastFourWarVehicleLog.sql +++ /dev/null @@ -1,18 +0,0 @@ --- save wrkMastFourWarVehicleLog record --- mysql -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicleLog/wrkMastFourWarVehicleLog.html', 'wrkMastFourWarVehicleLog绠$悊', null , '2', null , '1'); - -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicleLog#view', '鏌ヨ', '', '3', '0', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicleLog#btn-add', '鏂板', '', '3', '1', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicleLog#btn-edit', '缂栬緫', '', '3', '2', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicleLog#btn-delete', '鍒犻櫎', '', '3', '3', '1'); -insert into `sys_resource` ( `code`, `name`, `resource_id`, `level`, `sort`, `status`) values ( 'wrkMastFourWarVehicleLog#btn-export', '瀵煎嚭', '', '3', '4', '1'); - --- sqlserver -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicleLog/wrkMastFourWarVehicleLog.html', N'wrkMastFourWarVehicleLog绠$悊', null, '2', null, '1'); - -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicleLog#view', N'鏌ヨ', '', '3', '0', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicleLog#btn-add', N'鏂板', '', '3', '1', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicleLog#btn-edit', N'缂栬緫', '', '3', '2', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicleLog#btn-delete', N'鍒犻櫎', '', '3', '3', '1'); -insert [dbo].[sys_resource] ( [code], [name], [resource_id], [level], [sort], [status]) values ( N'wrkMastFourWarVehicleLog#btn-export', N'瀵煎嚭', '', '3', '4', '1'); -- Gitblit v1.9.1