From 17bfc74d3531f606034bd70ecc33ce97cb81e17f Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期一, 26 二月 2024 01:20:44 +0800
Subject: [PATCH] 优化代码
---
service-report/src/main/java/com/java110/report/cmd/reportCustomComponent/ListReportCustomComponentDataCmd.java | 20 ++++++++++++++++----
1 files changed, 16 insertions(+), 4 deletions(-)
diff --git a/service-report/src/main/java/com/java110/report/cmd/reportCustomComponent/ListReportCustomComponentDataCmd.java b/service-report/src/main/java/com/java110/report/cmd/reportCustomComponent/ListReportCustomComponentDataCmd.java
index 0e111be..dbb1b14 100644
--- a/service-report/src/main/java/com/java110/report/cmd/reportCustomComponent/ListReportCustomComponentDataCmd.java
+++ b/service-report/src/main/java/com/java110/report/cmd/reportCustomComponent/ListReportCustomComponentDataCmd.java
@@ -15,20 +15,22 @@
*/
package com.java110.report.cmd.reportCustomComponent;
+import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.java110.core.annotation.Java110Cmd;
import com.java110.core.context.ICmdDataFlowContext;
import com.java110.core.event.cmd.Cmd;
import com.java110.core.event.cmd.CmdEvent;
+import com.java110.core.log.LoggerFactory;
import com.java110.dto.PageDto;
-import com.java110.dto.reportCustomComponent.ReportCustomComponentDto;
+import com.java110.dto.reportCustom.ReportCustomComponentDto;
import com.java110.intf.report.IReportCustomComponentV1InnerServiceSMO;
import com.java110.service.smo.IQueryServiceSMO;
import com.java110.utils.exception.CmdException;
import com.java110.utils.util.Assert;
+import com.java110.utils.util.StringUtil;
import com.java110.vo.ResultVo;
import org.slf4j.Logger;
-import com.java110.core.log.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
@@ -50,9 +52,9 @@
public class ListReportCustomComponentDataCmd extends Cmd {
private static Logger logger = LoggerFactory.getLogger(ListReportCustomComponentDataCmd.class);
+
@Autowired
private IReportCustomComponentV1InnerServiceSMO reportCustomComponentV1InnerServiceSMOImpl;
-
@Autowired
@@ -63,8 +65,12 @@
super.validatePageInfo(reqJson);
Assert.hasKeyAndValue(reqJson, "componentId", "鏈寘鍚粍浠禝D");
}
+
@Override
public void doCmd(CmdEvent event, ICmdDataFlowContext cmdDataFlowContext, JSONObject reqJson) throws CmdException {
+
+ String storeId = cmdDataFlowContext.getReqHeaders().get("store-id");
+ reqJson.put("storeId", storeId);
//鏌ヨ缁勪欢鏄惁瀛樺湪
ReportCustomComponentDto reportCustomComponentDto = new ReportCustomComponentDto();
@@ -119,9 +125,15 @@
reqJson.put("page", (page - 1) * reqJson.getIntValue("row"));
}
JSONObject data = queryServiceSMOImpl.execQuerySql(reqJson, sql);
+ if (!sql.trim().contains("test=\"count")) {
+ total = JSONArray.parseArray(data.getString("td")).size();
+ }
+ if (!StringUtil.isEmpty(sql) && !sql.contains("limit #page#,#row#")) {
+ sql = sql + " limit #page#,#row#";
+ data = queryServiceSMOImpl.execQuerySql(reqJson, sql);
+ }
ResultVo resultVo = new ResultVo((int) Math.ceil((double) total / (double) reqJson.getInteger("row")), total, data);
ResponseEntity<String> responseEntity = new ResponseEntity<String>(resultVo.toString(), HttpStatus.OK);
cmdDataFlowContext.setResponseEntity(responseEntity);
}
-
}
--
Gitblit v1.8.0