sgj
2026-01-07 e356555905a02466a25206bae8f9bc66f3432d4f
报表优化修改
已修改13个文件
124 ■■■■ 文件已修改
fzzy-igdss-core/src/main/java/com/fzzy/igds/service/EventInfoService.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-core/src/main/java/com/fzzy/igds/service/QuantityService.java 7 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SnapRecordService.java 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-view/src/main/java/com/fzzy/igds/QuantityData.view.xml 36 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-view/src/main/java/com/fzzy/igds/QuantityDataPR.java 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportInDetail.view.xml 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportOutDetail.view.xml 9 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-view/src/main/java/com/fzzy/igds/SuperInventoryReport.view.xml 12 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-web/src/main/java/com/fzzy/common/manager/CommonManager.java 6 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-web/src/main/java/com/fzzy/security/EventInfoController.java 12 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-web/src/main/java/com/fzzy/security/SnapRecordController.java 15 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-web/src/main/resources/templates/security/eventInfo/eventInfo.html 5 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-web/src/main/resources/templates/security/snap/snapRecord/snapRecord.html 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
fzzy-igdss-core/src/main/java/com/fzzy/igds/service/EventInfoService.java
@@ -55,7 +55,7 @@
        }
        // 收储公司检索
        if (StringUtils.isNotBlank(param.getKey())) {
            queryWrapper.apply("dept_id IN (SELECT dept_id FROM sys_dept WHERE parent_id = {0})", param.getKey());
            queryWrapper.likeRight("dept_id", param.getKey());
        }
        //抓拍时间检索
        if (null != param.getStart()) {
fzzy-igdss-core/src/main/java/com/fzzy/igds/service/QuantityService.java
@@ -48,10 +48,11 @@
        QueryWrapper<Quantity> queryWrapper = new QueryWrapper<>();
        param.setCompanyId(ContextUtil.getCompanyId());
        param.setDeptId(ContextUtil.subDeptId(null));
        queryWrapper.eq("company_id", param.getCompanyId());
        queryWrapper.eq("dept_id", param.getDeptId());
        //库区检索
        if (StringUtils.isNotBlank(param.getDeptId())) {
            queryWrapper.like("dept_id", param.getDeptId());
        }
        //仓库检索
        if (StringUtils.isNotBlank(param.getDepotId())) {
            queryWrapper.eq("depot_id", param.getDepotId());
fzzy-igdss-core/src/main/java/com/fzzy/igds/service/SnapRecordService.java
@@ -51,7 +51,7 @@
        }
        // 收储公司检索
        if (StringUtils.isNotBlank(param.getKey())) {
            queryWrapper.apply("dept_id IN (SELECT dept_id FROM sys_dept WHERE parent_id = {0})", param.getKey());
            queryWrapper.likeRight("dept_id", param.getKey());
        }
        //抓拍时间检索
        if (null != param.getStart()) {
fzzy-igdss-view/src/main/java/com/fzzy/igds/QuantityData.view.xml
@@ -9,6 +9,15 @@
        <Property></Property>
        <Property name="label">检测批次</Property>
      </PropertyDef>
      <PropertyDef name="deptId">
        <Property></Property>
        <Property name="label">所属库区</Property>
        <Property name="mapping">
          <Property name="mapValues">${dorado.getDataProvider(&quot;deptPR#getAllData&quot;).getResult()}</Property>
          <Property name="keyProperty">id</Property>
          <Property name="valueProperty">kqmc</Property>
        </Property>
      </PropertyDef>
      <PropertyDef name="companyId">
        <Property></Property>
        <Property name="label">组织编码</Property>
@@ -17,7 +26,7 @@
        <Property></Property>
        <Property name="label">所属仓库</Property>
        <Property name="mapping">
          <Property name="mapValues">${dorado.getDataProvider(&quot;depotPR#getAllCache&quot;).getResult()}</Property>
          <Property name="mapValues">${dorado.getDataProvider(&quot;depotPR#getData&quot;).getResult()}</Property>
          <Property name="keyProperty">id</Property>
          <Property name="valueProperty">name</Property>
        </Property>
@@ -25,10 +34,12 @@
      <PropertyDef name="weight">
        <Property name="dataType">Double</Property>
        <Property name="label">重量</Property>
        <Property name="displayFormat">#0.0 KG</Property>
      </PropertyDef>
      <PropertyDef name="bulk">
        <Property name="dataType">Double</Property>
        <Property name="label">体积</Property>
        <Property name="displayFormat">#0.0 m³</Property>
      </PropertyDef>
      <PropertyDef name="receiveDate">
        <Property name="dataType">Date</Property>
@@ -57,11 +68,20 @@
      <PropertyDef name="title">
        <Property name="label"> </Property>
      </PropertyDef>
      <PropertyDef name="deptId">
        <Property></Property>
        <Property name="label">所属库区</Property>
        <Property name="mapping">
          <Property name="mapValues">${dorado.getDataProvider(&quot;deptPR#getAllData&quot;).getResult()}</Property>
          <Property name="keyProperty">id</Property>
          <Property name="valueProperty">kqmc</Property>
        </Property>
      </PropertyDef>
      <PropertyDef name="depotId">
        <Property></Property>
        <Property name="label">选择仓库</Property>
        <Property name="mapping">
          <Property name="mapValues">${dorado.getDataProvider(&quot;depotPR#getAllCache&quot;).getResult()}</Property>
          <Property name="mapValues">${dorado.getDataProvider(&quot;depotPR#getData&quot;).getResult()}</Property>
          <Property name="keyProperty">id</Property>
          <Property name="valueProperty">name</Property>
        </Property>
@@ -100,12 +120,17 @@
    <Container>
      <Property name="className">c-param</Property>
      <AutoForm>
        <Property name="cols">*,*,*,90,90</Property>
        <Property name="cols">*,*,*,*,90,90</Property>
        <Property name="dataSet">dataSetC</Property>
        <Property name="labelSeparator">:</Property>
        <Property name="labelAlign">right</Property>
        <Property name="labelWidth">110</Property>
        <Property name="exClassName">bg-color</Property>
        <AutoFormElement>
          <Property name="name">deptId</Property>
          <Property name="property">deptId</Property>
          <Editor/>
        </AutoFormElement>
        <AutoFormElement>
          <Property name="name">depotId</Property>
          <Property name="property">depotId</Property>
@@ -204,6 +229,11 @@
          <Property name="property">batchId</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn>
          <Property name="property">deptId</Property>
          <Property name="align">center</Property>
          <Property name="name">deptId</Property>
        </DataColumn>
        <DataColumn name="depotId">
          <Property name="property">depotId</Property>
          <Property name="align">center</Property>
fzzy-igdss-view/src/main/java/com/fzzy/igds/QuantityDataPR.java
@@ -16,7 +16,7 @@
import java.util.Date;
/**
 *
 *数量检测数据报表
 *
 * @author sgj
 * @date 2025/12/18
@@ -43,7 +43,7 @@
        result.setTitle("数量检测数据");
        if (null != subDept) {
            result.setTitle(subDept.getDeptName() + "数量检测数据");
            result.setDepotId(String.valueOf(subDept.getDeptId()));
            result.setDeptId(String.valueOf(subDept.getDeptId()));
        }
        result.setEnd(new Date());
        Date start = DateUtil.getNewByDay(new Date(), -90);
fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportInDetail.view.xml
@@ -543,7 +543,15 @@
        </AutoFormElement>
        <Button>
          <ClientEvent name="onClick">    var data = view.get(&quot;#dsQuery.data&quot;);&#xD;
    view.get(&quot;#dsMain&quot;).set(&quot;parameter&quot;,data).flushAsync();</ClientEvent>
    var deptId=data.get(&quot;deptId&quot;);&#xD;
    var companyId=data.get(&quot;companyId&quot;);&#xD;
    if(!companyId || !deptId){&#xD;
        $alert(&quot;请先选择收储公司和和所属库区&quot;);&#xD;
&#xD;
    }else{&#xD;
        view.get(&quot;#dsMain&quot;).set(&quot;parameter&quot;,data).flushAsync();&#xD;
    }&#xD;
</ClientEvent>
          <Property name="caption">搜索</Property>
          <Property name="exClassName">btn-q1</Property>
          <Property name="iconClass">fa fa-search</Property>
fzzy-igdss-view/src/main/java/com/fzzy/igds/ReportOutDetail.view.xml
@@ -536,7 +536,14 @@
        </AutoFormElement>
        <Button>
          <ClientEvent name="onClick">    var data = view.get(&quot;#dsQuery.data&quot;);&#xD;
    view.get(&quot;#dsMain&quot;).set(&quot;parameter&quot;,data).flushAsync();</ClientEvent>
    var deptId=data.get(&quot;deptId&quot;);&#xD;
    var companyId=data.get(&quot;companyId&quot;);&#xD;
    if(!companyId || !deptId){&#xD;
        $alert(&quot;请先选择收储公司和和所属库区&quot;);&#xD;
    }else{&#xD;
        view.get(&quot;#dsMain&quot;).set(&quot;parameter&quot;,data).flushAsync();&#xD;
    }&#xD;
</ClientEvent>
          <Property name="caption">搜索</Property>
          <Property name="exClassName">btn-q1</Property>
          <Property name="iconClass">fa fa-search</Property>
fzzy-igdss-view/src/main/java/com/fzzy/igds/SuperInventoryReport.view.xml
@@ -80,7 +80,7 @@
        <Property></Property>
        <Property name="label">装卸仓库</Property>
        <Property name="mapping">
          <Property name="mapValues">${dorado.getDataProvider(&quot;depotPR#getAllCache&quot;).getResult()}</Property>
          <Property name="mapValues">${dorado.getDataProvider(&quot;depotPR#getData&quot;).getResult()}</Property>
          <Property name="keyProperty">id</Property>
          <Property name="valueProperty">name</Property>
        </Property>
@@ -256,42 +256,52 @@
          <Property name="property">customerId</Property>
          <Property name="width">326</Property>
          <Property name="name">customerId</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="deptId">
          <Property name="property">deptId</Property>
          <Property name="width">250</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="depotId">
          <Property name="property">depotId</Property>
          <Property name="width">326</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="initialWeight">
          <Property name="property">initialWeight</Property>
          <Property name="width">100</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="recordInWeight">
          <Property name="property">recordInWeight</Property>
          <Property name="width">100</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="changeInWeight">
          <Property name="property">changeInWeight</Property>
          <Property name="width">100</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="recordOutWeight">
          <Property name="property">recordOutWeight</Property>
          <Property name="width">100</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="changeOutWeight">
          <Property name="property">changeOutWeight</Property>
          <Property name="width">100</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="lossWeight">
          <Property name="property">lossWeight</Property>
          <Property name="width">100</Property>
          <Property name="align">center</Property>
        </DataColumn>
        <DataColumn name="finalWeight">
          <Property name="property">finalWeight</Property>
          <Property name="width">100</Property>
          <Property name="align">center</Property>
        </DataColumn>
      </DataGrid>
      <ToolBar id="tool" layoutConstraint="bottom">
fzzy-igdss-web/src/main/java/com/fzzy/common/manager/CommonManager.java
@@ -134,13 +134,13 @@
    /**
     * 获取分库列表
     * 根据公司ID获取公司下的分库列表
     *
     * @author sgj
     * @date 2025/12/12
     */
    public List<Dept> listDeptData() {
        return coreDeptService.getDeptData();
    public List<Dept> listDeptData(String parentId) {
        return coreDeptService.getDeptByUserType(parentId);
    }
    /**
fzzy-igdss-web/src/main/java/com/fzzy/security/EventInfoController.java
@@ -6,6 +6,7 @@
import com.fzzy.igds.constant.WarnType;
import com.fzzy.igds.data.IgdsBaseParam;
import com.fzzy.igds.data.PageResponse;
import com.fzzy.igds.domain.Company;
import com.fzzy.igds.domain.EventInfo;
import com.fzzy.security.manager.EventInfoManager;
import com.ruoyi.common.utils.StringUtils;
@@ -42,10 +43,15 @@
     */
    @GetMapping
    public String getEventInfo(@RequestParam(value = "viewType", required = false) String viewType, Model model) {
        List<Company> companies = commonManager.listCompanyData();
        String defaultCompany =  "" ;
        if (companies != null && !companies.isEmpty()) {
            defaultCompany = companies.get(0).getId();
        }
        IgdsBaseParam param = new IgdsBaseParam();
        param.setPage(1);
        param.setLimit(6);
        param.setKey(defaultCompany);
        Page<EventInfo> events = eventInfoManager.pageData(param);
        model.addAttribute("eventInfoList", events.getRecords());
        model.addAttribute("currentPage", events.getCurrent());
@@ -60,7 +66,7 @@
        //设备数据
        model.addAttribute("cameraList", commonManager.listCameraData());
        //库区数据
        model.addAttribute("deptList", commonManager.listDeptData());
        model.addAttribute("deptList", commonManager.listDeptData(null));
        //业务类型数据
        List<Map<String, String>> bizTypeList = new ArrayList<>();
        for (WarnType type : WarnType.values()) {
@@ -71,7 +77,7 @@
        }
        model.addAttribute("bizTypeList", bizTypeList);
        //公司数据
        model.addAttribute("companyList", commonManager.listCompanyData());
        model.addAttribute("companyList", companies);
        return prefix + "/eventInfo";
    }
fzzy-igdss-web/src/main/java/com/fzzy/security/SnapRecordController.java
@@ -5,6 +5,7 @@
import com.fzzy.igds.constant.RespCodeEnum;
import com.fzzy.igds.data.IgdsBaseParam;
import com.fzzy.igds.data.PageResponse;
import com.fzzy.igds.domain.Company;
import com.fzzy.igds.domain.SnapRecord;
import com.fzzy.security.manager.SnapRecordManager;
import com.ruoyi.common.utils.StringUtils;
@@ -14,6 +15,7 @@
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
import java.util.List;
@Slf4j
@@ -34,10 +36,15 @@
     */
    @GetMapping
    public String getSnapRecord(@RequestParam(value = "viewType", required = false) String viewType, Model model) {
        List<Company> companies = commonManager.listCompanyData();
        String defaultCompany =  "" ;
        if (companies != null && !companies.isEmpty()) {
            defaultCompany = companies.get(0).getId();
        }
        IgdsBaseParam param = new IgdsBaseParam();
        param.setPage(1);
        param.setLimit(6);
        param.setKey(defaultCompany);
        Page<SnapRecord> images = snapRecordManager.pageData(param);
        model.addAttribute("snapRecordList", images.getRecords());
        model.addAttribute("currentPage", images.getCurrent());
@@ -52,9 +59,11 @@
        //设备数据
        model.addAttribute("cameraList", commonManager.listCameraData());
        //库区数据
        model.addAttribute("deptList", commonManager.listDeptData());
        model.addAttribute("deptList", commonManager.listDeptData(null));
        //公司数据
        model.addAttribute("companyList", commonManager.listCompanyData());
        model.addAttribute("companyList", companies);
        //默认查询公司数据
        model.addAttribute("defaultCompany", defaultCompany);
        return prefix + "/snapRecord";
    }
fzzy-igdss-web/src/main/resources/templates/security/eventInfo/eventInfo.html
@@ -20,8 +20,9 @@
                    <ul>
                        <li>
                            收储公司:<select  class="form-control"  name="key">
                            <option value="">所有</option>
                            <option th:each="company : ${companyList}" th:value="${company.id}" th:text="${company.dwmc}">
                            <option th:each="company : ${companyList}" th:value="${company.id}"
                                    th:text="${company.dwmc}"
                                    th:selected="${company.id == defaultCompany}">
                            </option>
                        </select>
                        </li>
fzzy-igdss-web/src/main/resources/templates/security/snap/snapRecord/snapRecord.html
@@ -20,9 +20,9 @@
                    <ul>
                        <li>
                            收储公司:<select class="form-control" name="key">
                            <option value="">所有</option>
                            <option th:each="company : ${companyList}" th:value="${company.id}"
                                    th:text="${company.dwmc}">
                                    th:text="${company.dwmc}"
                                    th:selected="${company.id == defaultCompany}">
                            </option>
                        </select>
                        </li>