From 06af2ffa26ed44bb2a8a60c0618f8d0490fdd6ed Mon Sep 17 00:00:00 2001
From: “djh” <“3298565835@qq.com”>
Date: 星期三, 05 三月 2025 08:38:22 +0800
Subject: [PATCH] 用量统计页面及导出 修改
---
hazmat-system/src/main/java/com/gkhy/hazmat/system/service/impl/SysCompanyServiceImpl.java | 25 +++++++++++++++++++++++++
1 files changed, 25 insertions(+), 0 deletions(-)
diff --git a/hazmat-system/src/main/java/com/gkhy/hazmat/system/service/impl/SysCompanyServiceImpl.java b/hazmat-system/src/main/java/com/gkhy/hazmat/system/service/impl/SysCompanyServiceImpl.java
index 9116355..b585b60 100644
--- a/hazmat-system/src/main/java/com/gkhy/hazmat/system/service/impl/SysCompanyServiceImpl.java
+++ b/hazmat-system/src/main/java/com/gkhy/hazmat/system/service/impl/SysCompanyServiceImpl.java
@@ -12,6 +12,7 @@
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
+import javax.annotation.Resource;
import java.util.List;
/**
@@ -25,6 +26,8 @@
@Service
public class SysCompanyServiceImpl extends ServiceImpl<SysCompanyMapper, SysCompany> implements SysCompanyService {
+ @Resource
+ private SysCompanyMapper companyMapper;
@Override
public CommonPage selectCompanyList(SysCompany company) {
@@ -75,6 +78,7 @@
}
+ @Override
public boolean checkNameUnique(SysCompany company){
Long companyId=company.getId()==null?-1L:company.getId();
SysCompany com= baseMapper.checkNameUnique(company.getName());
@@ -85,6 +89,27 @@
}
+ @Override
+ public void createProductTables(Long companyId) {
+ // 这里可以使用 MyBatis-Plus 的动态 SQL 或者直接执行 SQL 语句来创建表
+ // 为了简化示例，我们直接执行 SQL 语句
+ String createProductCategoryTableSql = "CREATE TABLE IF NOT EXISTS product_category_demo"+"_"+companyId+" (" +
+ "id BIGINT AUTO_INCREMENT PRIMARY KEY, " +
+ "name VARCHAR(255) NOT NULL, " +
+ "company_id BIGINT NOT NULL)";
+ String createProductTableSql = "CREATE TABLE IF NOT EXISTS product_demo"+"_"+companyId+" (" +
+ "id BIGINT AUTO_INCREMENT PRIMARY KEY, " +
+ "name VARCHAR(255) NOT NULL, " +
+ "description TEXT, " +
+ "price DECIMAL(10, 2) NOT NULL, " +
+ "category_id BIGINT NOT NULL)";
+
+ // 执行 SQL 语句
+ companyMapper.execute(createProductCategoryTableSql);
+ companyMapper.execute(createProductTableSql);
+ }
+
+
public boolean checkCodeUnique(SysCompany company){
Long companyId=company.getId()==null?-1L:company.getId();
SysCompany com= baseMapper.checkCodeUnique(company.getCode());
--
Gitblit v1.9.2