From 45f3ee40badcc43f1984ee67414443d3188c6b0e Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期一, 17 二月 2025 15:53:29 +0800
Subject: [PATCH] Merge branch 'master' of https://gitee.com/xiaochen991015/xizang

---
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java   |    4 -
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBillController.java       |    2 +
 ruoyi-system/src/main/resources/mapper/system/TInformationMapper.xml              |    3 +
 ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTenantController.java     |   77 +++++++++++++++++++++++++++++++++++++-
 ruoyi-system/src/main/java/com/ruoyi/system/query/TContractQuery.java             |    4 ++
 ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInvoiceServiceImpl.java |    8 ---
 ruoyi-system/src/main/java/com/ruoyi/system/model/TInformation.java               |    4 ++
 7 files changed, 88 insertions(+), 14 deletions(-)

diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBillController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBillController.java
index be95875..5816bc3 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBillController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TBillController.java
@@ -10,6 +10,7 @@
 import com.ruoyi.system.model.TBill;
 import com.ruoyi.system.query.TBillQuery;
 import com.ruoyi.system.service.TBillService;
+import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.security.access.prepost.PreAuthorize;
@@ -27,6 +28,7 @@
  * @author xiaochen
  * @since 2025-01-17
  */
+@Api(tags = "账单管理")
 @RestController
 @RequestMapping("/t-bill")
 public class TBillController {
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java
index c8a0d28..979451b 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TContractController.java
@@ -76,7 +76,6 @@
     private TCheckAcceptRecordService checkAcceptRecordService;
     @ApiOperation(value = "测试生成账单")
     @PostMapping(value = "/testBill")
-
     public R testBill(String id) {
         TContract contract = contractService.getById(id);
         // 查询所有已签订的合同并且未生成第一笔账单的
@@ -229,8 +228,7 @@
     @PreAuthorize("@ss.hasPermi('system:contract:delete')")
 
     @DeleteMapping(value = "/deleteContractByIds")
-    public R<Boolean> deleteContractByIds
-            (@RequestParam String ids) {
+    public R<Boolean> deleteContractByIds(@RequestParam String ids) {
         if (StringUtils.isNotEmpty(ids)){
             contractService.removeBatchByIds(Arrays.asList(ids.split(",")));
         }
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTenantController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTenantController.java
index 5a2b9b7..a9fdcb3 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTenantController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/api/TTenantController.java
@@ -1,6 +1,9 @@
 package com.ruoyi.web.controller.api;
 
 
+import cn.afterturn.easypoi.excel.ExcelExportUtil;
+import cn.afterturn.easypoi.excel.entity.ExportParams;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.ruoyi.common.annotation.Log;
 import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.common.constant.DictConstants;
@@ -9,18 +12,29 @@
 import com.ruoyi.common.utils.DictUtils;
 import com.ruoyi.common.utils.SecurityUtils;
 import com.ruoyi.common.utils.StringUtils;
+import com.ruoyi.common.utils.WebUtils;
 import com.ruoyi.system.dto.TTenantDTO;
+import com.ruoyi.system.export.ContractExport;
+import com.ruoyi.system.model.TContract;
 import com.ruoyi.system.model.TTenant;
+import com.ruoyi.system.query.TContractQuery;
 import com.ruoyi.system.query.TTenantQuery;
+import com.ruoyi.system.service.TContractService;
 import com.ruoyi.system.service.TTenantService;
 import com.ruoyi.system.vo.TenantVO;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
+import org.apache.poi.ss.usermodel.Workbook;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.security.access.prepost.PreAuthorize;
 import org.springframework.validation.annotation.Validated;
 import org.springframework.web.bind.annotation.*;
 
+import javax.servlet.ServletOutputStream;
+import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
+import java.net.URLEncoder;
+import java.util.ArrayList;
 import java.util.List;
 
 /**
@@ -37,9 +51,11 @@
 public class TTenantController {
 
     private final TTenantService tenantService;
+    private final TContractService contractService;
     @Autowired
-    public TTenantController(TTenantService tenantService) {
+    public TTenantController(TTenantService tenantService, TContractService contractService) {
         this.tenantService = tenantService;
+        this.contractService = contractService;
     }
 
     /**
@@ -88,9 +104,16 @@
     @GetMapping(value = "/getDetailById")
     public R<TTenant> getDetailById(@RequestParam String id) {
         TTenant tenant = tenantService.getById(id);
-        tenant.setTenantAttributes(DictUtils.getDictLabel(DictConstants.DICT_TYPE_TENANT_ATTRIBUTE,tenant.getTenantAttributes()));
-        tenant.setTenantType(DictUtils.getDictLabel(DictConstants.DICT_TYPE_TENANT_TYPE,tenant.getTenantType()));
+        tenant.setTenantAttributes(StringUtils.isNotEmpty(tenant.getTenantAttributes())?DictUtils.getDictLabel(DictConstants.DICT_TYPE_TENANT_ATTRIBUTE,tenant.getTenantAttributes()):"");
+        tenant.setTenantType(StringUtils.isNotEmpty(tenant.getTenantType())?DictUtils.getDictLabel(DictConstants.DICT_TYPE_TENANT_TYPE,tenant.getTenantType()):"");
         return R.ok(tenant);
+    }
+
+    @PreAuthorize("@ss.hasPermi('system:contract:list')")
+    @ApiOperation(value = "获取合同分页列表")
+    @GetMapping(value = "/contractListByTenantId")
+    public R<List<TContract>> contractListByTenantId(@RequestParam String tenantId) {
+        return R.ok(contractService.list(Wrappers.lambdaQuery(TContract.class).eq(TContract::getTenantId, tenantId)));
     }
 
     /**
@@ -115,5 +138,53 @@
         return R.ok(tenantService.removeByIds(ids));
     }
 
+    /**
+     * 导出
+     */
+    @ApiOperation(value = "导出")
+    @PreAuthorize("@ss.hasPermi('system:contract:export')")
+    @Log(title = "导出", businessType = BusinessType.EXPORT)
+    @PostMapping("/export")
+    public void exportOpticalInspection(@Validated @RequestBody TContractQuery query)
+    {
+        List<ContractExport> contractExports = new ArrayList<>();
+        List<TContract> exportList = contractService.list(Wrappers.lambdaQuery(TContract.class).eq(TContract::getTenantId, query.getTenantId()));
+        for (TContract contract : exportList) {
+            ContractExport contractExport = new ContractExport();
+            contractExport.setContractNumber(contract.getContractNumber());
+            contractExport.setContractName(contract.getContractName());
+            contractExport.setPartyOneName(contract.getPartyOneName());
+            contractExport.setPartyTwoName(contract.getPartyTwoName());
+            contractExport.setCreate_time(contract.getCreateTime());
+            contractExport.setStartTime(contract.getStartTime());
+            contractExport.setEndTime(contract.getEndTime());
+            contractExport.setPayType(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_PAY_TYPE,contract.getPayType()));
+            contractExport.setDeposit(contract.getDeposit()+"");
+            contractExport.setStatus(DictUtils.getDictLabel(DictConstants.DICT_TYPE_CONTRACT_STATUS,contract.getStatus()));
+        }
+        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), ContractExport.class, contractExports);
+        HttpServletResponse response = WebUtils.response();
+        response.setContentType("application/vnd.ms-excel");
+        response.setCharacterEncoding("utf-8");
+        ServletOutputStream outputStream = null;
+        try {
+            String fileName = URLEncoder.encode("合同列表.xls", "utf-8");
+            response.setHeader("Content-Disposition", "attachment;filename=" + fileName);
+            response.setContentType("application/vnd.ms-excel;charset=UTF-8");
+            response.setHeader("Pragma", "no-cache");
+            response.setHeader("Cache-Control", "no-cache");
+            outputStream = response.getOutputStream();
+            workbook.write(outputStream);
+        } catch (IOException e) {
+            e.printStackTrace();
+            System.err.println("合同列表信息导出失败");
+        } finally {
+            try {
+                outputStream.close();
+            } catch (IOException e) {
+                e.printStackTrace();
+            }
+        }
+    }
 }
 
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/model/TInformation.java b/ruoyi-system/src/main/java/com/ruoyi/system/model/TInformation.java
index eb090cf..3132361 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/model/TInformation.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/model/TInformation.java
@@ -59,6 +59,10 @@
     @TableField("cover")
     private String cover;
 
+    @ApiModelProperty(value = "简介")
+    @TableField("brief_introduction")
+    private String briefIntroduction;
+
     @ApiModelProperty(value = "内容")
     @TableField("content")
     private String content;
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/TContractQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/TContractQuery.java
index 52031d9..b12fbca 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/query/TContractQuery.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/TContractQuery.java
@@ -5,6 +5,7 @@
 import io.swagger.annotations.ApiModelProperty;
 import lombok.Data;
 
+import javax.validation.constraints.NotBlank;
 import java.util.List;
 
 @Data
@@ -20,4 +21,7 @@
     private Integer status;
     @ApiModelProperty(value = "选中的行")
     private List<String> ids;
+    @NotBlank(message = "租户id不可为空")
+    @ApiModelProperty(value = "租户id")
+    private String tenantId;
 }
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInvoiceServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInvoiceServiceImpl.java
index 81c4fdf..36dbad6 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInvoiceServiceImpl.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TInvoiceServiceImpl.java
@@ -1,23 +1,17 @@
 package com.ruoyi.system.service.impl;
 
 import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
 import com.ruoyi.common.basic.PageInfo;
 import com.ruoyi.common.utils.StringUtils;
 import com.ruoyi.system.mapper.TInvoiceMapper;
-import com.ruoyi.system.model.TBill;
 import com.ruoyi.system.model.TInvoice;
-import com.ruoyi.system.model.TInvoiceToBill;
 import com.ruoyi.system.query.TInvoiceQuery;
-import com.ruoyi.system.query.TInvoiceToBillQuery;
 import com.ruoyi.system.service.TBillService;
 import com.ruoyi.system.service.TInvoiceService;
-import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.sun.org.apache.regexp.internal.RE;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
-import org.springframework.web.bind.annotation.RequestParam;
 
-import java.util.ArrayList;
 import java.util.List;
 
 /**
diff --git a/ruoyi-system/src/main/resources/mapper/system/TInformationMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TInformationMapper.xml
index c8aa23a..1137271 100644
--- a/ruoyi-system/src/main/resources/mapper/system/TInformationMapper.xml
+++ b/ruoyi-system/src/main/resources/mapper/system/TInformationMapper.xml
@@ -11,6 +11,7 @@
         <result column="release_time" property="releaseTime" />
         <result column="cover" property="cover" />
         <result column="content" property="content" />
+        <result column="brief_introduction" property="briefIntroduction" />
         <result column="attachment" property="attachment" />
         <result column="attachment_name" property="attachmentName" />
         <result column="create_time" property="createTime" />
@@ -22,7 +23,7 @@
 
     <!-- 通用查询结果列 -->
     <sql id="Base_Column_List">
-        id, title_name, sort_by, info_source, release_time,cover, content, attachment,attachment_name, create_time, update_time, create_by, update_by, disabled
+        id, title_name, sort_by, info_source, release_time,cover, brief_introduction,content, attachment,attachment_name, create_time, update_time, create_by, update_by, disabled
     </sql>
     <select id="pageList" resultType="com.ruoyi.system.model.TInformation">
         select

--
Gitblit v1.7.1