MachineController.java 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332
  1. package com.iamberry.rst.controllers.pts;
  2. import com.iamberry.rst.core.pts.*;
  3. import com.iamberry.rst.core.tools.QRCJson;
  4. import com.iamberry.rst.core.tools.WeixinUtil;
  5. import com.iamberry.rst.faces.pts.*;
  6. import com.iamberry.wechat.tools.NameUtils;
  7. import com.iamberry.wechat.tools.ResponseJson;
  8. import com.iamberry.wechat.tools.ResultInfo;
  9. import net.sf.json.JSONArray;
  10. import net.sf.json.JSONObject;
  11. import org.springframework.beans.factory.annotation.Autowired;
  12. import org.springframework.stereotype.Controller;
  13. import org.springframework.web.bind.annotation.RequestMapping;
  14. import org.springframework.web.bind.annotation.ResponseBody;
  15. import javax.servlet.http.HttpServletRequest;
  16. import java.text.ParseException;
  17. import java.text.SimpleDateFormat;
  18. import java.util.*;
  19. /**
  20. * Created by LJK on 2017/8/29.
  21. */
  22. @Controller
  23. @RequestMapping("/mcahine")
  24. public class MachineController {
  25. @Autowired
  26. private ProduceService produceService;
  27. @Autowired
  28. private MachineService machineService;
  29. @Autowired
  30. private DeviceService deviceService;
  31. @Autowired
  32. private PtsEmployeeService ptsEmployeeService;
  33. @Autowired
  34. private MachineLogsService machineLogsService;
  35. @Autowired
  36. private PtsBatchService ptsBatchService;
  37. @ResponseBody
  38. @RequestMapping("/uploadProcessOptions")
  39. public ResponseJson uploadProcessOptions(HttpServletRequest request) {
  40. ResponseJson rj = new ResponseJson();
  41. String nodeList = request.getParameter("nodeList"); //获取员工id
  42. if (nodeList == null || nodeList.equals("")) {
  43. rj.setResultCode(500);
  44. rj.setResultMsg("200");
  45. rj.setResultMsg("ERROR");
  46. return rj;
  47. }
  48. JSONObject query = JSONObject.fromObject(nodeList);
  49. Integer employeeId = query.getInt("employeeId");//员工id
  50. String produceNo = query.getString("produceId");//产品编号
  51. String nfcId = query.getString("nfcId");//NFCID(卡片id)
  52. JSONArray nodes = query.getJSONArray("nodes");//选项集合(包含一个或多个工序选项,详情见示例)
  53. //根据卡片id与生产时间判断数据库是否存在相同的数据
  54. JSONObject machineJsonObject = nodes.getJSONObject(0);
  55. String ProcessTime = machineJsonObject.getString("logsProcessTime"); //工序执行时间 (时间戳)
  56. Date ProcessDate = timeConversions(ProcessTime);
  57. PtsMachine machine = new PtsMachine();
  58. machine.setMachineNfcId(nfcId);
  59. machine.setMachineCreateTime(ProcessDate);
  60. Integer ishave = machineService.getMachineIsHave(machine);
  61. if (ishave > 0) {
  62. rj.setResultCode(500);
  63. rj.setResultMsg("500");
  64. rj.setResultMsg("此卡片内容已生成二维码");
  65. return rj;
  66. }
  67. Produce produce = produceService.getProduce(produceNo);//根据产品编号获取产品信息
  68. /*根据员工id,获取拉线,再将拉线存入机器表 */
  69. PtsEmployee employee = new PtsEmployee();
  70. employee.setEmployeeId(employeeId);
  71. employee = ptsEmployeeService.getPtsEmployeeWebApp(employee);
  72. String employeeLine = employee.getEmployeeLine();
  73. /*获取当前产品使用的批次 */
  74. PtsBatch ptsBatch = ptsBatchService.getUseBatch(produce.getProduceId());
  75. if (ptsBatch == null) {
  76. rj.setResultCode(500);
  77. rj.setResultMsg("500");
  78. rj.setResultMsg("系统中没有该产品正在使用的批次,请到管理平台完善");
  79. return rj;
  80. }
  81. //生成条形码,二维码
  82. String berQrcode = generationBarCode(produce);
  83. String json = String.format(NameUtils.QR_LIMIT_STR_SCENE, ResultInfo.barCodePrefix + berQrcode);
  84. QRCJson qrc = WeixinUtil.createQrcode(json);
  85. PtsMachine ptsMachine = new PtsMachine();
  86. if (!(qrc == null || qrc.getUrl() == null || qrc.getUrl().isEmpty())) {
  87. ptsMachine.setMachineQrcode(qrc.getUrl());//二维码
  88. ptsMachine.setMachineBarcode(berQrcode);//条形码
  89. ptsMachine.setMachineStatus(1);//机器状态
  90. ptsMachine.setMachineProducedTime(new Date());//生产时间
  91. ptsMachine.setMachineIsPrint(1);//是否打印1:未打印2:已打印
  92. ptsMachine.setMachineCompoundImg("合成的图片url");
  93. ptsMachine.setMachineProcessState(1);//生成流程状态1.正常2.异常
  94. ptsMachine.setMachineCreateTime(new Date());//创建时间
  95. ptsMachine.setMachineProduceType(produce.getProduceType());//产品类型
  96. ptsMachine.setMachineNfcId(nfcId);
  97. //ptsMachine.setMachineHardwareVersion(30);
  98. ptsMachine.setMachineSoftwareVersion(ptsBatch.getBatchSoftwareVersionId());
  99. ptsMachine.setMachineProduceId(produce.getProduceId());
  100. ptsMachine.setMachineBomId(0);//默认为0
  101. ptsMachine.setMachineBatchId(0);//默认为0
  102. ptsMachine.setMachineIsRetreading(2);
  103. ptsMachine.setMachineLine(employeeLine); //拉线信息
  104. ptsMachine.setMachineBatchId(ptsBatch.getBatchId()); //批次id
  105. ptsMachine.setMachineBomId(ptsBatch.getBomId()); //bom单id
  106. machineService.addMachine(ptsMachine);
  107. }
  108. boolean isAbnormality = true;//状态是否异常
  109. List<PtsMachineLogs> ptsMachineLogsList = new ArrayList<PtsMachineLogs>();
  110. for (int i = 0; i < nodes.size(); i++) {
  111. PtsMachineLogs ptsMachineLogs = new PtsMachineLogs();
  112. JSONObject jsonObject = nodes.getJSONObject(i);
  113. String processNo = jsonObject.getString("processId"); //工序编号
  114. String nodeNo = jsonObject.getString("nodeId"); //工序选项编号
  115. String logsProcessTime = jsonObject.getString("logsProcessTime"); //工序执行时间 (时间戳)
  116. Date logsProcessDate = timeConversions(logsProcessTime);
  117. ProduceProcess produceProcess = produceService.getProduceProcessAndNode(produce.getProduceId(), processNo);
  118. ProcessNode processNode = produceService.getprocessNode(produceProcess.getProcessId(), nodeNo);
  119. String deviceName = produceProcess.getDeviceName();
  120. String employeeName = produceProcess.getEmployeeName();
  121. if (deviceName == null) {
  122. String processName = produceProcess.getProcessName();
  123. rj.setResultCode(500);
  124. rj.setResultMsg("500");
  125. rj.setResultMsg("\"" + processName + "\"工序的打卡设备未完善,请到管理平台完善");
  126. return rj;
  127. }
  128. if (employeeName == null) {
  129. String processName = produceProcess.getProcessName();
  130. rj.setResultCode(500);
  131. rj.setResultMsg("500");
  132. rj.setResultMsg("\"" + processName + "\"工序的员工信息未完善,请到管理平台完善");
  133. return rj;
  134. }
  135. ptsMachineLogs.setDeviceId(produceProcess.getDriveId());
  136. ptsMachineLogs.setEmployeeId(produceProcess.getEmployeeId());
  137. ptsMachineLogs.setProduceId(produce.getProduceId());
  138. ptsMachineLogs.setProcessId(produceProcess.getProcessId());
  139. ptsMachineLogs.setMachineId(ptsMachine.getMachineId());
  140. ptsMachineLogs.setEmployeeName(employeeName);
  141. ptsMachineLogs.setProduceName(produce.getProduceName());
  142. ptsMachineLogs.setProcessName(produceProcess.getProcessName());
  143. ptsMachineLogs.setDeviceName(deviceName);
  144. ptsMachineLogs.setProcessNodeId(processNode.getNodeId());
  145. ptsMachineLogs.setProcessNodeName(processNode.getNodeDes());
  146. if (i == 0) {//如果当前循环的是第一条数据则排序必须是1,否则为异常
  147. if (produceProcess.getProcessSort() == 1) {
  148. if (processNode.getNodeStatus() == 0) {//工序选项状态为异常则机器表状态也是异常
  149. isAbnormality = false;
  150. }
  151. ptsMachineLogs.setLogsProcessStatus(processNode.getNodeStatus());
  152. } else {
  153. ptsMachineLogs.setLogsProcessStatus(0);
  154. isAbnormality = false;
  155. }
  156. } else {//默认为正常
  157. ptsMachineLogs.setLogsProcessStatus(processNode.getNodeStatus());
  158. }
  159. ptsMachineLogs.setLogsProcessPrompt(processNode.getNodeStatus() == 0 ? "检查不通过" : null);
  160. ptsMachineLogs.setLogsProcessTime(logsProcessDate);
  161. ptsMachineLogs.setLogsCreateTime(new Date());
  162. //根据上一条工序选项信息判断当前工序是否正常,如果当前为修理工序则忽略,如果上一条为修理工序则查询上上一条
  163. if (i > 0) {
  164. int num = 0;
  165. ProduceProcess produceProcess2 = null;//当前工序的上一条非修理工序
  166. JSONObject jsonObject2;//上一级工序信息
  167. String processNo2 = null;//上一级工序编号
  168. //先判断当前的上一次是否是修理工序,如果不是则不用执行下面的循环,否则需要循环判断
  169. jsonObject2 = nodes.getJSONObject(i - 1);
  170. if (jsonObject2 != null) {
  171. processNo2 = jsonObject2.getString("processId");
  172. produceProcess2 = produceService.getProduceProcess(produce.getProduceId(), processNo2);
  173. //判断当前工序是否是修理工序,如果是,则修改上一条为次品
  174. if (produceProcess.getProcessType() == 2) {
  175. ptsMachineLogsList.get(ptsMachineLogsList.size()-1).setLogsErrorType(2); //异常类型 1:流程异常 2:次品异常
  176. ptsMachineLogsList.get(ptsMachineLogsList.size()-1).setLogsProcessPrompt("次品异常");
  177. // ptsMachineLogs.setLogsErrorType(2);
  178. // ptsMachineLogs.setLogsProcessPrompt("次品异常");
  179. // machineLogsService.updateMachineLogs(ptsMachineLogs);
  180. isAbnormality = false;
  181. ptsMachineLogs.setLogsId(null);
  182. ptsMachineLogs.setLogsErrorType(null);
  183. ptsMachineLogs.setLogsProcessPrompt(null);
  184. } else {
  185. //判断是否是修理工序 1:生产工序 2:修理工序
  186. if (produceProcess2.getProcessType() == 1) {
  187. if (produceProcess.getProcessSort() - produceProcess2.getProcessSort() != 1) {
  188. ptsMachineLogs.setLogsProcessStatus(0);
  189. ptsMachineLogs.setLogsErrorType(1);//异常类型 1:流程异常 2:次品异常
  190. ptsMachineLogs.setLogsProcessPrompt("流程异常");
  191. isAbnormality = false;
  192. }
  193. } else {
  194. for (int j = i - 1; j <= i - 1; j--) {
  195. if (num == i) {
  196. break;//只能循环 i 次,超出则跳出当前循环
  197. }
  198. jsonObject2 = nodes.getJSONObject(j);
  199. if (jsonObject2 != null) {
  200. processNo2 = jsonObject2.getString("processId");
  201. produceProcess2 = produceService.getProduceProcess(produce.getProduceId(), processNo2);
  202. if (produceProcess2.getProcessType() == 1) {//判断是否是修理工序 1:生产工序 2:修理工序
  203. if (produceProcess.getProcessSort() > produceProcess2.getProcessSort()) {
  204. ptsMachineLogs.setLogsProcessStatus(0);
  205. ptsMachineLogs.setLogsErrorType(1);//异常类型 1:流程异常 2:次品异常
  206. ptsMachineLogs.setLogsProcessPrompt("流程异常");
  207. isAbnormality = false;
  208. }
  209. break;
  210. }
  211. }
  212. num++;
  213. }
  214. }
  215. }
  216. }
  217. }
  218. //执行添加日志操作
  219. ptsMachineLogsList.add(ptsMachineLogs);
  220. ptsMachineLogs.setLogsErrorType(null);//还原为默认值
  221. }
  222. machineLogsService.addMachineLogs(ptsMachineLogsList);
  223. //修改机器信息
  224. PtsMachine ptsMachine2 = new PtsMachine();
  225. ptsMachine2.setMachineId(ptsMachine.getMachineId());
  226. if (!isAbnormality) {
  227. ptsMachine2.setMachineProcessState(2);//2表示机器生产过程中出现异常
  228. }
  229. ptsMachine2.setMachineUpdateTime(new Date());
  230. ptsMachine2.setMachineProduceId(produce.getProduceId());
  231. machineService.updateMachine(ptsMachine2);
  232. //截取条形码尾号(4位)
  233. rj.addResponseKeyValue("barcodeTail", berQrcode.substring(berQrcode.length() - 4, berQrcode.length()));
  234. return rj;
  235. }
  236. private static Date timeConversions(String time) {
  237. if (time == null || time.equals("")) {
  238. return new Date();
  239. }
  240. //08311112
  241. Calendar date = Calendar.getInstance();
  242. String year = String.valueOf(date.get(Calendar.YEAR));//年
  243. String months = null;//月
  244. String sky = null;//天
  245. String when = null;//时
  246. String subdivision = null;//分
  247. months = time.substring(0, 2);
  248. sky = time.substring(2, 4);
  249. when = time.substring(4, 6);
  250. subdivision = time.substring(6, 8);
  251. time = year + "-" + months + "-" + sky + " " + when + ":" + subdivision;
  252. Date dates = new Date();
  253. try {
  254. SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
  255. dates = sdf.parse(time);
  256. } catch (ParseException e) {
  257. System.out.println(e.getMessage());
  258. }
  259. return dates;
  260. }
  261. private String productModel = "1X";//产品型号
  262. private String productFeatures = "A";//产品特性
  263. private String softwareVersion = "30";//软件版本
  264. //生成条形码
  265. public String generationBarCode(Produce produce) {
  266. java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM");
  267. java.util.Date currTime = new java.util.Date();
  268. String curTime = formatter.format(currTime);
  269. Calendar cal = Calendar.getInstance();
  270. int year = cal.get(Calendar.YEAR);
  271. int month = cal.get(Calendar.MONTH) + 1;
  272. //获取当前月机器总数
  273. Integer number = machineService.selectMonthCount(curTime);
  274. number = number + 1;
  275. String num = null;
  276. switch (String.valueOf(number).length()) {
  277. case 0:
  278. num = "0001";
  279. break;
  280. case 1:
  281. num = "000" + String.valueOf(number);
  282. break;
  283. case 2:
  284. num = "00" + String.valueOf(number);
  285. break;
  286. case 3:
  287. num = "0" + String.valueOf(number);
  288. break;
  289. case 4:
  290. num = String.valueOf(number);
  291. break;
  292. }
  293. String months = String.valueOf(month);
  294. if (month < 10) {
  295. months = "0" + months;
  296. }
  297. productModel = produce.getProduceModel();
  298. productFeatures = produce.getProduceFeature();
  299. //拼接
  300. String barcode = productModel + productFeatures + softwareVersion + String.valueOf(year).substring(2, 4) + months + num;
  301. return barcode;
  302. }
  303. }