From ba1a7a9ef126296e2798e313dc5b43f775a1123c Mon Sep 17 00:00:00 2001
From: cl <418351270@qq.com>
Date: 星期四, 23 五月 2024 17:44:36 +0800
Subject: [PATCH] 修改数据采集
---
guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrdeInfo/controller/ProductionOrdeInfoController.java | 474 ++++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 421 insertions(+), 53 deletions(-)
diff --git a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrdeInfo/controller/ProductionOrdeInfoController.java b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrdeInfo/controller/ProductionOrdeInfoController.java
index 2af65c0..c8ad14d 100644
--- a/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrdeInfo/controller/ProductionOrdeInfoController.java
+++ b/guns-vip-main/src/main/java/cn/stylefeng/guns/modular/om/productionOrdeInfo/controller/ProductionOrdeInfoController.java
@@ -6,6 +6,14 @@
import cn.afterturn.easypoi.excel.entity.params.ExcelExportEntity;
import cn.afterturn.easypoi.view.PoiBaseView;
import cn.stylefeng.guns.base.pojo.page.LayuiPageInfo;
+import cn.stylefeng.guns.modular.bs.locationInfo.entity.LocationInfo;
+import cn.stylefeng.guns.modular.bs.locationInfo.service.LocationInfoService;
+import cn.stylefeng.guns.modular.bs.materialInfo.entity.MaterialInfo;
+import cn.stylefeng.guns.modular.bs.materialInfo.service.MaterialInfoService;
+import cn.stylefeng.guns.modular.cm.passingStationCollection.entity.PassingStationCollection;
+import cn.stylefeng.guns.modular.cm.passingStationCollection.model.params.PassingStationCollectionParam;
+import cn.stylefeng.guns.modular.cm.passingStationCollection.model.result.PassingStationCollectionResult;
+import cn.stylefeng.guns.modular.cm.passingStationCollection.service.PassingStationCollectionService;
import cn.stylefeng.guns.modular.om.productionOrdeInfo.entity.ProductionOrdeInfo;
import cn.stylefeng.guns.modular.om.productionOrdeInfo.model.params.ProductionOrdeInfoParam;
import cn.stylefeng.guns.modular.om.productionOrdeInfo.model.result.ProductionOrdeInfoResult;
@@ -13,6 +21,7 @@
import cn.stylefeng.guns.sys.modular.system.entity.Dict;
import cn.stylefeng.guns.sys.modular.system.service.DictService;
import cn.stylefeng.roses.core.base.controller.BaseController;
+import cn.stylefeng.roses.core.util.ToolUtil;
import cn.stylefeng.roses.kernel.model.response.ResponseData;
import com.alibaba.fastjson.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
@@ -27,6 +36,7 @@
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.security.core.parameters.P;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;
@@ -40,6 +50,7 @@
import java.text.SimpleDateFormat;
import java.time.LocalDate;
import java.util.*;
+import java.util.stream.Collectors;
/**
@@ -132,7 +143,7 @@
public ResponseData editItem(ProductionOrdeInfoParam productionOrdeInfoParam) {
if(productionOrdeInfoParam.getFlag()!=null){
productionOrdeInfoParam.setActualStartTime(new Date());
- }
+ }
this.productionOrdeInfoService.update(productionOrdeInfoParam);
this.productionOrdeInfoService.saveOrderBatchInfo(productionOrdeInfoParam);
return ResponseData.success();
@@ -202,6 +213,18 @@
}
/**
+ * 娴嬪姛鏈烘柊澧炴帴鍙�
+ * @return
+ */
+ @ResponseBody
+ @CrossOrigin
+ @RequestMapping("/addStationInfo")
+ public ResponseData addStationInfo(PassingStationCollectionParam passingStationCollectionParam) {
+ this.passingStationCollectionService.add(passingStationCollectionParam);
+ return ResponseData.success();
+ }
+
+ /**
* 澶у睆鍒楄〃鎺ュ彛
* @param productionOrdeInfoParam
* @return
@@ -255,8 +278,16 @@
@CrossOrigin
@RequestMapping("/lineFinishQty")
public ResponseData lineFinishQty() {
- List list = this.productionOrdeInfoService.lineFinishQty();
- return ResponseData.success(list);
+ SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
+ List resultList = new ArrayList();
+ List<ProductionOrdeInfoResult> list = this.productionOrdeInfoService.lineFinishQty();
+ for (ProductionOrdeInfoResult productionOrdeInfo : list) {
+ Map map = new HashMap();
+ map.put("name",format.format(productionOrdeInfo.getActualStartTime()));
+ map.put("value",productionOrdeInfo.getActualQty());
+ resultList.add(map);
+ }
+ return ResponseData.success(resultList);
}
/**
@@ -267,14 +298,50 @@
@CrossOrigin
@RequestMapping("/workshopOrderDetail")
public ResponseData workshopOrderDetail(ProductionOrdeInfoParam productionOrdeInfoParam) {
+// NumberFormat numberFormat = NumberFormat.getInstance();
+// numberFormat.setMaximumFractionDigits(2);
+// ProductionOrdeInfo one = productionOrdeInfoService.getOne(new QueryWrapper<ProductionOrdeInfo>()
+// .select("SUM\n" +
+// "\t( plan_qty ) AS planQty,\n" +
+// "\tSUM ( actual_qty ) AS actualQty,\n" +
+// "\tSUM ( scrap_qty ) AS scrapQty ")
+// );
+// //璁″垝
+// Integer plqnQty = one.getPlanQty();
+// //瀹屾垚
+// Integer actualQty = one.getActualQty();
+// //鎶ュ簾
+// Integer scrapQty = one.getScrapQty();
+// //鍚堟牸鏁伴噺
+// Integer paseQty = actualQty-scrapQty;
+//
+// Map map = new HashMap<String,String>();
+// map.put("produceQty",plqnQty);
+// map.put("finishQty",actualQty);
+// map.put("paseQty",paseQty);
+// map.put("noPaseQty",scrapQty);
+// map.put("CompletionRate",numberFormat.format((float) actualQty / (float) plqnQty * 100));
+// map.put("PassRate",numberFormat.format((float) paseQty / (float) actualQty * 100));
+// map.put("surplusQty",plqnQty-actualQty);
+// return ResponseData.success(map);
+ ProductionOrdeInfoParam param = new ProductionOrdeInfoParam();
+ param.setOrderStatus("3");
+ ProductionOrdeInfoResult one = new ProductionOrdeInfoResult();
NumberFormat numberFormat = NumberFormat.getInstance();
numberFormat.setMaximumFractionDigits(2);
- ProductionOrdeInfo one = productionOrdeInfoService.getOne(new QueryWrapper<ProductionOrdeInfo>()
- .select("SUM\n" +
- "\t( plan_qty ) AS planQty,\n" +
- "\tSUM ( actual_qty ) AS actualQty,\n" +
- "\tSUM ( scrap_qty ) AS scrapQty ")
- );
+ List<ProductionOrdeInfoResult> listMonth = productionOrdeInfoService.getListMonth();
+ List<ProductionOrdeInfoResult> listBySpec = productionOrdeInfoService.findListBySpec(param);
+ if(listBySpec.size() == 0){
+ ToolUtil.copyProperties(listMonth.get(0), one);
+ }else {
+ ToolUtil.copyProperties(listBySpec.get(0), one);
+ }
+ if(one.getActualQty() == null){
+ one.setActualQty(0);
+ }
+ if(one.getScrapQty() == null){
+ one.setScrapQty(0);
+ }
//璁″垝
Integer plqnQty = one.getPlanQty();
//瀹屾垚
@@ -285,12 +352,17 @@
Integer paseQty = actualQty-scrapQty;
Map map = new HashMap<String,String>();
- map.put("produceQty",plqnQty);
- map.put("finishQty",actualQty);
+ map.put("produceQty",one.getPlanQty());
+ map.put("finishQty",one.getActualQty());
map.put("paseQty",paseQty);
map.put("noPaseQty",scrapQty);
map.put("CompletionRate",numberFormat.format((float) actualQty / (float) plqnQty * 100));
- map.put("PassRate",numberFormat.format((float) paseQty / (float) actualQty * 100));
+ String format = numberFormat.format((float) paseQty / (float) actualQty * 100);
+ if(format.equals("锟�")){
+ map.put("PassRate","0");
+ }else {
+ map.put("PassRate",format);
+ }
map.put("surplusQty",plqnQty-actualQty);
return ResponseData.success(map);
}
@@ -311,63 +383,52 @@
@CrossOrigin
@RequestMapping("/lineChart")
public ResponseData lineChart(ProductionOrdeInfoParam productionOrdeInfoParam) {
+ SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
List<String> list = new ArrayList();
List<Integer> planQtyList = new ArrayList();
List<Integer> actualQtyList = new ArrayList();
Map map = new HashMap<String,String>();
-// for (int i = 0; i < 7; i++) {
-// String str = LocalDate.now().minusDays(i).toString();
- for (Object o : getWeek()) {
- QueryWrapper<ProductionOrdeInfo> queryWrapper = new QueryWrapper<ProductionOrdeInfo>();
- queryWrapper.select("SUM(plan_qty) as planQty,SUM(actual_qty) as actualQty");
- queryWrapper.apply("CONVERT ( VARCHAR ( 100 ), plan_start_time, 23 ) = {0}",o.toString() );
- ProductionOrdeInfo one = productionOrdeInfoService.getOne(queryWrapper);
- if(one!=null){
- if(one.getPlanQty()!=null){
- planQtyList.add(one.getPlanQty());
- }else {
- planQtyList.add(0);
- }
- if(one.getActualQty()!=null){
- actualQtyList.add(one.getActualQty());
- }else {
- actualQtyList.add(0);
- }
+ List<ProductionOrdeInfoResult> ColumnarDateList = productionOrdeInfoService.getColumnarDate();
+ for (ProductionOrdeInfoResult result : ColumnarDateList) {
+ String s = format.format(result.getActualStartTime());
+ QueryWrapper<ProductionOrdeInfo> queryWrapper = new QueryWrapper<ProductionOrdeInfo>();
+ queryWrapper.select("SUM(plan_qty) as planQty,SUM(actual_qty) as actualQty");
+ queryWrapper.apply("CONVERT ( VARCHAR ( 100 ), actual_start_time, 23 ) = {0}",s);
+ ProductionOrdeInfo one = productionOrdeInfoService.getOne(queryWrapper);
+ if(one!=null){
+ if(one.getPlanQty()!=null){
+ planQtyList.add(one.getPlanQty());
}else {
planQtyList.add(0);
+ }
+ if(one.getActualQty()!=null){
+ actualQtyList.add(one.getActualQty());
+ }else {
actualQtyList.add(0);
}
- list.add(o.toString());
+ }else {
+ planQtyList.add(0);
+ actualQtyList.add(0);
}
+ list.add(s);
+ }
-// }
map.put("category",list);
map.put("lineData",planQtyList);
map.put("barData",actualQtyList);
return ResponseData.success(map);
}
- public static void main(String[] args) {
-// List<String> weeks = getFormatDate("month");
-// System.out.println(JSONObject.toJSONString(weeks));
-// for (int i = 0; i < 7; i++) {
-// System.out.println(LocalDate.now().minusDays(i));
-// }
- System.out.println(getWeek());
-
+ @ResponseBody
+ @CrossOrigin
+ @RequestMapping("/findOrdrList")
+ public ResponseData findOrdrList(ProductionOrdeInfoParam productionOrdeInfoParam) {
+ ProductionOrdeInfoParam param = new ProductionOrdeInfoParam();
+ param.setProductionLine("");//浜х嚎
+ param.setOrderStatus("3");//宸ュ崟鐘舵��
+ List<ProductionOrdeInfoResult> list = productionOrdeInfoService.findListBySpec(param);
+ return ResponseData.success(list);
}
- public static List getWeek(){
- List<String> list = new ArrayList<>();
- list.add(LocalDate.now().minusDays(6).toString());
- list.add(LocalDate.now().minusDays(5).toString());
- list.add(LocalDate.now().minusDays(4).toString());
- list.add(LocalDate.now().minusDays(3).toString());
- list.add(LocalDate.now().minusDays(2).toString());
- list.add(LocalDate.now().minusDays(1).toString());
- list.add(LocalDate.now().minusDays(0).toString());
- return list;
- }
-
/**
* 涓嬭浇excel瀵煎叆妯℃澘
@@ -377,7 +438,7 @@
*/
@RequestMapping("/downloadExcelTemplate")
public void downloadExcelTemplate(ModelMap modelMap, HttpServletRequest request,
- HttpServletResponse response) {
+ HttpServletResponse response) {
//鍒濆鍖栬〃澶�
List<ExcelExportEntity> entity = new ArrayList<>();
entity.add(new ExcelExportEntity("鐢熶骇宸ュ崟鍙�", "workOrderNo"));
@@ -489,6 +550,313 @@
return value.trim();
}
+ @Autowired
+ MaterialInfoService materialInfoService;
+
+ @Autowired
+ PassingStationCollectionService passingStationCollectionService;
+
+ @Autowired
+ LocationInfoService locationInfoService;
+
+ /**
+ * 澶у睆杞﹂棿宸ュ崟淇℃伅鎺ュ彛
+ * @return
+ */
+ @ResponseBody
+ @CrossOrigin
+ @RequestMapping("/topData")
+ public ResponseData topData(ProductionOrdeInfoParam productionOrdeInfoParam) {
+ Map map = new HashMap<String,String>();
+ ProductionOrdeInfo result = null;
+ //浣嗗墠宸ュ崟
+ List<ProductionOrdeInfo> orderStatus = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("order_status", "3"));
+ if(productionOrdeInfoParam.getWorkOrderNo() != null && !productionOrdeInfoParam.getWorkOrderNo().equals("")){
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", productionOrdeInfoParam.getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }else if(orderStatus.size()!=0){
+ result = orderStatus.get(0);
+ }else {
+ List<ProductionOrdeInfoResult> results = productionOrdeInfoService.orderDescListFive();
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", results.get(0).getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }
+ //浜у搧
+ List<MaterialInfo> materialCode = materialInfoService.list(new QueryWrapper<MaterialInfo>().eq("material_code", result.getMaterialCode()));
+ Integer planQty = result.getPlanQty();
+ Integer actualQty = result.getActualQty();
+ Date date2 = new Date(); // 绗簩涓棩鏈�
+ long diffInMillis =result.getPlanEndTime().getTime() - date2.getTime(); //璁＄畻涓や釜鏃ユ湡鐨勬绉掑樊
+ long diffInHours = diffInMillis / (60 * 60 * 1000); // 灏嗘绉掑樊杞崲涓哄皬鏃跺樊
+ List<PassingStationCollection> list = passingStationCollectionService.list(new QueryWrapper<PassingStationCollection>()
+ .eq("out_rs_sign", "2")
+ .eq("work_order_no", result.getWorkOrderNo())
+ .eq("location_code", "OP1060")
+ );
+ Integer NgNumber = list.size();
+ map.put("workOrderNo",result.getWorkOrderNo());
+ map.put("planQty",planQty);
+ map.put("actualQty",actualQty);
+ map.put("materialName",materialCode.get(0).getMaterialName());
+ map.put("completionRate",Math.round((float) actualQty / planQty * 100));
+ map.put("remainder",diffInHours);
+ map.put("NgNumber",NgNumber);
+ if(list.size() == 0){
+ map.put("passRate","100");
+ }else {
+ map.put("passRate",Math.round((float) NgNumber / actualQty * 100));
+ }
+ return ResponseData.success(map);
+ }
+
+
+ @ResponseBody
+ @CrossOrigin
+ @RequestMapping("/centerLeftData")
+ public ResponseData centerLeftData(ProductionOrdeInfoParam productionOrdeInfoParam) {
+ Map map = new HashMap<String,String>();
+ List categoryList = new ArrayList();
+ List lineDataList = new ArrayList();
+ List barDataList = new ArrayList();
+ List percentageList = new ArrayList();
+ percentageList.add(0);
+
+ ProductionOrdeInfo result = null;
+ //浣嗗墠宸ュ崟
+ List<ProductionOrdeInfo> orderStatus = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("order_status", "3"));
+ if(productionOrdeInfoParam.getWorkOrderNo() != null && !productionOrdeInfoParam.getWorkOrderNo().equals("")){
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", productionOrdeInfoParam.getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }else if(orderStatus.size()!=0){
+ result = orderStatus.get(0);
+ }else {
+ List<ProductionOrdeInfoResult> results = productionOrdeInfoService.orderDescListFive();
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", results.get(0).getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }
+ List<PassingStationCollectionResult> resultList = passingStationCollectionService.centerLeftData(productionOrdeInfoParam.getWorkOrderNo());
+ int unQuantity = passingStationCollectionService.getUnqualifiedQuantity(productionOrdeInfoParam.getWorkOrderNo());
+ int variableInt = 0;
+ if(unQuantity == 0){
+ map.put("category",getLocationList());
+ map.put("barData",getZeroList());
+ map.put("percentage",getPercentageList());
+
+ }else {
+ for (int i = 0; i < resultList.size(); i++) {
+ categoryList.add(resultList.get(i).getLocationCode());
+ barDataList.add(resultList.get(i).getNum());
+ variableInt+=Integer.valueOf(resultList.get(i).getNum());
+ percentageList.add(Math.round((float) variableInt / unQuantity * 100));
+ }
+ map.put("category",categoryList);
+ map.put("barData",barDataList);
+ map.put("lineData",lineDataList);
+ map.put("percentage",percentageList);
+ }
+ return ResponseData.success(map);
+// Map map = new HashMap<String,String>();
+// List categoryList = new ArrayList();
+// List lineDataList = new ArrayList();
+// List barDataList = new ArrayList();
+//
+// ProductionOrdeInfo result = null;
+// //浣嗗墠宸ュ崟
+// List<ProductionOrdeInfo> orderStatus = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("order_status", "3"));
+// if(productionOrdeInfoParam.getWorkOrderNo() != null && !productionOrdeInfoParam.getWorkOrderNo().equals("")){
+// List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", productionOrdeInfoParam.getWorkOrderNo()));
+// result = workOrderNo.get(0);
+// }else if(orderStatus.size()!=0){
+// result = orderStatus.get(0);
+// }else {
+// List<ProductionOrdeInfoResult> results = productionOrdeInfoService.orderDescListFive();
+// List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", results.get(0).getWorkOrderNo()));
+// result = workOrderNo.get(0);
+// }
+// for (String o : getLocationList()) {
+// List<PassingStationCollection> list = passingStationCollectionService.list(new QueryWrapper<PassingStationCollection>()
+// .eq("location_code", o)
+// .eq("out_rs_sign", "2")
+// .eq("work_order_no",result.getWorkOrderNo())
+// );
+// List<PassingStationCollection> lineList = passingStationCollectionService.list(new QueryWrapper<PassingStationCollection>()
+// .eq("location_code", o)
+// .eq("work_order_no",result.getWorkOrderNo())
+// );
+// categoryList.add(o);
+// barDataList.add(list.size());
+// lineDataList.add(lineList.size());
+// }
+// map.put("category",categoryList);
+// map.put("barData",barDataList);
+// map.put("lineData",lineDataList);
+//
+// return ResponseData.success(map);
+ }
+
+ @ResponseBody
+ @CrossOrigin
+ @RequestMapping("/bottomData")
+ public ResponseData bottomData(ProductionOrdeInfoParam productionOrdeInfoParam) {
+ Map map = new HashMap<String,String>();
+ List unqualifiedList = new ArrayList();
+ List qualifiedList = new ArrayList();
+ List passRate = new ArrayList();
+// List<ProductionOrdeInfo> orderStatus = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("order_status", "3"));
+// ProductionOrdeInfo result = orderStatus.get(0);
+ ProductionOrdeInfo result = null;
+ //浣嗗墠宸ュ崟
+ List<ProductionOrdeInfo> orderStatus = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("order_status", "3"));
+ if(productionOrdeInfoParam.getWorkOrderNo() != null && !productionOrdeInfoParam.getWorkOrderNo().equals("")){
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", productionOrdeInfoParam.getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }else if(orderStatus.size()!=0){
+ result = orderStatus.get(0);
+ }else {
+ List<ProductionOrdeInfoResult> results = productionOrdeInfoService.orderDescListFive();
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", results.get(0).getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }
+ for (String o : getLocationList()) {
+ List<PassingStationCollection> list = passingStationCollectionService.list(new QueryWrapper<PassingStationCollection>()
+ .eq("location_code", o)
+ .eq("out_rs_sign", "2")
+ .eq("work_order_no",result.getWorkOrderNo())
+ );
+ List<PassingStationCollection> list1 = passingStationCollectionService.list(new QueryWrapper<PassingStationCollection>()
+ .eq("location_code", o)
+ .eq("work_order_no",result.getWorkOrderNo())
+ );
+ Integer unqualified = list.size();
+ Integer qualified = list1.size()-list.size();
+ unqualifiedList.add(unqualified);
+ qualifiedList.add(qualified);
+ if(unqualified == 0){
+ passRate.add(100);
+ }else {
+ passRate.add(Math.round((float) qualified / result.getActualQty() * 100));
+ }
+ }
+ map.put("unqualifiedList",unqualifiedList);
+ map.put("qualifiedList",qualifiedList);
+ map.put("passRate",passRate);
+ return ResponseData.success(map);
+ }
+
+ @ResponseBody
+ @CrossOrigin
+ @RequestMapping("/centerRightData")
+ public ResponseData centerRightData(ProductionOrdeInfoParam productionOrdeInfoParam) {
+// List<ProductionOrdeInfo> orderStatus = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("order_status", "3"));
+// ProductionOrdeInfo result = orderStatus.get(0);
+ ProductionOrdeInfo result = null;
+ //浣嗗墠宸ュ崟
+ List<ProductionOrdeInfo> orderStatus = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("order_status", "3"));
+ if(productionOrdeInfoParam.getWorkOrderNo() != null && !productionOrdeInfoParam.getWorkOrderNo().equals("")){
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", productionOrdeInfoParam.getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }else if(orderStatus.size()!=0){
+ result = orderStatus.get(0);
+ }else {
+ List<ProductionOrdeInfoResult> results = productionOrdeInfoService.orderDescListFive();
+ List<ProductionOrdeInfo> workOrderNo = productionOrdeInfoService.list(new QueryWrapper<ProductionOrdeInfo>().eq("work_order_no", results.get(0).getWorkOrderNo()));
+ result = workOrderNo.get(0);
+ }
+ Integer targetNumber = 70;
+ List resultList = new ArrayList();
+ SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
+ String format1 = format.format(new Date());
+ String paramPrefix = format1+" ";
+ for (String s : getCenterRightSpit()) {
+ List itemList = new ArrayList();
+ int outTotal = passingStationCollectionService.bigCenterRightTable(paramPrefix+s+":00",paramPrefix+s.substring(0,1)+":59:59",null,result.getWorkOrderNo());
+ int i = passingStationCollectionService.bigCenterRightTable(paramPrefix+s+":00",paramPrefix+s.substring(0,1)+":59:59","1",result.getWorkOrderNo());
+ if(outTotal<targetNumber){
+ itemList.add(boldText(s));
+ itemList.add(boldText(targetNumber.toString()));
+ itemList.add(boldText(String.valueOf(outTotal)));
+ itemList.add(boldText(String.valueOf(targetNumber-outTotal)));
+ itemList.add(boldText(Math.round((float) i / outTotal * 100)+"%"));
+ }else {
+ itemList.add(s);
+ itemList.add(targetNumber);
+ itemList.add(outTotal);
+ itemList.add(targetNumber-outTotal);
+ itemList.add(Math.round((float) i / outTotal * 100)+"%");
+ }
+ resultList.add(itemList);
+ }
+ return ResponseData.success(resultList);
+ }
+
+ @ResponseBody
+ @CrossOrigin
+ @RequestMapping("/orderDescListFive")
+ public ResponseData orderDescListFive() {
+ List list = new ArrayList();
+ List<ProductionOrdeInfoResult> results = productionOrdeInfoService.orderDescListFive();
+ for (ProductionOrdeInfoResult result : results) {
+ Map itemMap = new HashMap();
+ itemMap.put("value",result.getWorkOrderNo());
+ itemMap.put("label",result.getWorkOrderNo());
+ list.add(itemMap);
+ }
+ return ResponseData.success(list);
+ }
+
+ public static List<String> getLocationList(){
+ List<String> locationList = new ArrayList<>();
+ locationList.add("OP070");
+ locationList.add("OP100");
+ locationList.add("OP140");
+ locationList.add("OP150");
+ locationList.add("EOP080");
+ locationList.add("EOP090");
+ return locationList;
+ }
+
+ public static List<String> getZeroList(){
+ List<String> locationList = new ArrayList<>();
+ locationList.add("0");
+ locationList.add("0");
+ locationList.add("0");
+ locationList.add("0");
+ locationList.add("0");
+ locationList.add("0");
+ return locationList;
+ }
+
+ public static List<String> getPercentageList(){
+ List<String> locationList = new ArrayList<>();
+ locationList.add("100");
+ locationList.add("100");
+ locationList.add("100");
+ locationList.add("100");
+ locationList.add("100");
+ locationList.add("100");
+ return locationList;
+ }
+
+
+ public static List<String> getCenterRightSpit(){
+ List<String> locationList = new ArrayList<>();
+ locationList.add("8:00");
+ locationList.add("9:00");
+ locationList.add("10:00");
+ locationList.add("11:00");
+ locationList.add("12:00");
+ locationList.add("13:00");
+ locationList.add("14:00");
+ locationList.add("15:00");
+ locationList.add("16:00");
+ locationList.add("17:00");
+ return locationList;
+ }
+
+ public static String boldText(String param){
+ return "<span style='font-size: 20px' class='colorRed'>"+param+"</span>";
+ }
+
}
--
Gitblit v1.9.3