package cn.stylefeng.guns.modular.kb.greaseBoard;
|
|
import cn.stylefeng.guns.base.pojo.page.LayuiPageInfo;
|
import cn.stylefeng.guns.modular.gm.greaseManage.entity.GreaseManage;
|
import cn.stylefeng.guns.modular.gm.greaseManage.model.params.GreaseManageParam;
|
import cn.stylefeng.guns.modular.gm.greaseManage.model.result.GreaseManageResult;
|
import cn.stylefeng.guns.modular.gm.greaseManage.service.GreaseManageService;
|
import cn.stylefeng.guns.modular.kb.utils.IPUtil;
|
import cn.stylefeng.guns.modular.om.productionOrdeInfo.model.result.ProductionOrdeInfoResult;
|
import cn.stylefeng.guns.modular.sc.kanbanConf.model.params.KanbanConfParam;
|
import cn.stylefeng.guns.modular.sc.kanbanConf.service.KanbanConfService;
|
import cn.stylefeng.guns.plcserver.opc.unit.OPCUnit;
|
import cn.stylefeng.roses.core.base.controller.BaseController;
|
import cn.stylefeng.roses.kernel.model.response.ResponseData;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import javafx.stage.Stage;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.CrossOrigin;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletRequest;
|
import java.text.SimpleDateFormat;
|
import java.time.LocalDate;
|
import java.time.format.DateTimeFormatter;
|
import java.time.temporal.ChronoUnit;
|
import java.util.*;
|
|
/**
|
* 返修上线看板
|
*
|
* @author cl
|
* @Date 2022-10-27 15:50:56
|
*/
|
@Controller
|
@RequestMapping("/greaseBoard")
|
public class GreaseBoardController extends BaseController {
|
|
private String PREFIX = "modular/kb/greaseBoard";
|
@Autowired
|
private KanbanConfService kanbanConfService;
|
|
@Autowired
|
private GreaseManageService greaseManageService;
|
/**
|
* 跳转到主页面
|
*
|
* @author cl
|
* @Date 2022-10-27
|
*/
|
@RequestMapping("")
|
public String index() {
|
return PREFIX + "/greaseBoard.html";
|
}
|
|
/**
|
* 新增看板配置页面
|
*
|
* @author cl
|
* @Date 2022-10-31
|
*/
|
@RequestMapping("/add")
|
public String add() {
|
return PREFIX + "/kanbanConf_add.html";
|
}
|
|
/**
|
* 编辑页面
|
*
|
* @author cl
|
* @Date 2022-10-31
|
*/
|
@RequestMapping("/edit")
|
public String edit() {
|
return PREFIX + "/kanbanConf_edit.html";
|
}
|
|
@RequestMapping("/orderEdit")
|
public String orderEdit() {
|
return PREFIX + "/kanbanConf_orderEdit.html";
|
}
|
|
/**
|
* 新增接口
|
*
|
* @author cl
|
* @Date 2022-10-31
|
*/
|
@RequestMapping("/addKanBanConfItem")
|
@ResponseBody
|
public ResponseData addItem(KanbanConfParam kanbanConfParam, HttpServletRequest request) {
|
String realIp = IPUtil.getRealIp(request);
|
kanbanConfParam.setIpAddress(realIp);
|
kanbanConfParam.setWarehouseCode(kanbanConfParam.getScrapReason());
|
kanbanConfParam.setWarehouseName(kanbanConfParam.getScrapCategory());
|
this.kanbanConfService.add(kanbanConfParam);
|
return ResponseData.success();
|
}
|
|
/**
|
* 新增接口
|
* MIGICC17500E00136V250WX23K03A0003B
|
* @author cl
|
* @Date 2022-10-31
|
*/
|
@RequestMapping("/updategreaseManage")
|
@ResponseBody
|
public ResponseData updategreaseManage(GreaseManageParam greaseManageParam) {
|
SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String currentDate = format.format(new Date());
|
String barCode = greaseManageParam.getBarcode();
|
String lastTwelveChars = barCode.substring(barCode.length() - 12);
|
String locationCode = getLocationCode(lastTwelveChars);
|
String DuaDate = getDuaDate(lastTwelveChars);
|
GreaseManage greaseManage = new GreaseManage();
|
greaseManage.setBarcode(barCode);
|
greaseManage.setLocationCode(locationCode);
|
greaseManage.setDuaDate(DuaDate);
|
greaseManage.setDaysRemaining(getRemainder(currentDate,DuaDate));
|
greaseManage.setCreateTime(new Date());
|
greaseManage.setCreateUser("admin");
|
// greaseManageService.save(greaseManage);
|
greaseManageService.update(greaseManage,new LambdaQueryWrapper<GreaseManage>().eq(GreaseManage::getLocationCode, locationCode));
|
return ResponseData.success();
|
}
|
|
@ResponseBody
|
@CrossOrigin
|
@RequestMapping("/bigListGreaseBoard")
|
public ResponseData orderDescListFive() {
|
SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String currentDate = format.format(new Date());
|
List list = new ArrayList();
|
List<GreaseManage> results = greaseManageService.list();
|
for (GreaseManage result : results) {
|
String DuaDate = result.getDuaDate();
|
String remainder = getRemainder(currentDate, DuaDate);
|
if(Integer.valueOf(remainder)<=90){
|
List itemList = new ArrayList();
|
itemList.add(boldText(result.getLocationCode()));
|
itemList.add(boldText(DuaDate));
|
itemList.add(boldText(remainder));
|
list.add(itemList);
|
}else {
|
List itemList = new ArrayList();
|
itemList.add(whiteBoldText(result.getLocationCode()));
|
itemList.add(whiteBoldText(DuaDate));
|
itemList.add(whiteBoldText(remainder));
|
list.add(itemList);
|
}
|
|
}
|
return ResponseData.success(list);
|
}
|
|
@ResponseBody
|
@CrossOrigin
|
@RequestMapping("/testhandleOilState")
|
public long handleOilState(){
|
SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String currentDate = format.format(new Date());
|
GreaseManageParam param = new GreaseManageParam();
|
param.setLocationCode("OP050");
|
List<GreaseManageResult> list = greaseManageService.findListBySpec(param);
|
if(list.size()>0) {
|
String duaDate = list.get(0).getDuaDate();
|
//
|
long daysBetween = Long.parseLong(getRemainder(currentDate,duaDate));
|
|
// long daysBetween = ChronoUnit.DAYS.between(date1, date2);
|
// return daysBetween;
|
}
|
return 0;
|
}
|
|
public static String boldText(String param){
|
return "<span style='font-size: 20px' class='colorRed'>"+param+"</span>";
|
}
|
|
public static String whiteBoldText(String param){
|
return "<span style='font-size: 20px'>"+param+"</span>";
|
}
|
|
public static void main(String[] args) {
|
DateTimeFormatter dateFormatter = DateTimeFormatter.ofPattern("yyyyMMdd");
|
SimpleDateFormat format = new SimpleDateFormat("yyyyMMdd");
|
String format1 = format.format(new Date());
|
System.out.println("Difference in days: " + getRemainder("20231215",format1));
|
}
|
|
public static String getRemainder(String currentDate,String tableDate){
|
DateTimeFormatter dateFormatter = DateTimeFormatter.ofPattern("yyyyMMdd");
|
LocalDate localDate1 = LocalDate.parse(currentDate, dateFormatter);
|
LocalDate localDate2 = LocalDate.parse(tableDate, dateFormatter);
|
long days = ChronoUnit.DAYS.between(localDate1, localDate2);
|
return String.valueOf(days);
|
}
|
|
public static String getDuaDate(String str){
|
String year = str.substring(1,3);
|
String month = getMonth(str.substring(3,4));
|
String day = str.substring(4,6);
|
return "20"+year+month+day;
|
}
|
|
public static String getLocationCode(String str){
|
String locationCode = "";
|
switch (str.substring(0,1)) {
|
case "X":
|
locationCode = "DOP020";
|
break;
|
case "Y":
|
locationCode = "OP050";
|
break;
|
case "Z":
|
locationCode = "BOP030/040";
|
break;
|
default:
|
break;
|
}
|
return locationCode;
|
}
|
|
public static String getMonth(String str){
|
String Month = "";
|
switch (str) {
|
case "A":
|
Month = "01";
|
break;
|
case "B":
|
Month = "02";
|
break;
|
case "C":
|
Month = "03";
|
break;
|
case "D":
|
Month = "04";
|
break;
|
case "E":
|
Month = "05";
|
break;
|
case "F":
|
Month = "06";
|
break;
|
case "G":
|
Month = "07";
|
break;
|
case "H":
|
Month = "08";
|
break;
|
case "I":
|
Month = "09";
|
break;
|
case "J":
|
Month = "10";
|
break;
|
case "K":
|
Month = "11";
|
break;
|
case "L":
|
Month = "12";
|
break;
|
default:
|
break;
|
}
|
return Month;
|
}
|
|
|
/**
|
* 编辑接口
|
*
|
* @author cl
|
* @Date 2022-10-31
|
*/
|
@RequestMapping("/editKanBanConfItem")
|
@ResponseBody
|
public ResponseData editItem(KanbanConfParam kanbanConfParam) {
|
this.kanbanConfService.update(kanbanConfParam);
|
return ResponseData.success();
|
}
|
|
/**
|
* 查询列表
|
*
|
* @author cl
|
* @Date 2022-10-31
|
*/
|
@ResponseBody
|
@RequestMapping("/qryKBConflist")
|
public LayuiPageInfo list(KanbanConfParam kanbanConfParam, HttpServletRequest request) {
|
String realIp = IPUtil.getRealIp(request);
|
kanbanConfParam.setIpAddress(realIp);
|
|
return this.kanbanConfService.findPageBySpec(kanbanConfParam);
|
}
|
}
|
