package com.northglass.service.identifymachine;
|
|
import java.sql.ResultSet;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.swing.text.html.HTML;
|
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Component;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import com.northglass.Globel.mes;
|
import com.northglass.SqlHelper.DBSession;
|
import com.northglass.constants.StateConstants.ConnectState;
|
import com.northglass.constants.StateConstants.GaoliweiMachineState;
|
import com.northglass.constants.StateConstants.GlassArrangeState;
|
import com.northglass.constants.StateConstants.GlassState;
|
import com.northglass.constants.StateConstants.sendGlassState;
|
import com.northglass.entity.GalssTask;
|
import com.northglass.entity.IdentifyError;
|
import com.northglass.entity.LoadRack;
|
import com.northglass.entity.Password;
|
import com.northglass.entity.PatternTask;
|
import com.northglass.entity.PreprocessingGlass;
|
import com.northglass.entity.Rank;
|
import com.northglass.entity.RawPackage;
|
import com.northglass.entity.ShelfRack;
|
import com.northglass.entity.ShelfTask;
|
import com.northglass.entity.Slicecage;
|
import com.northglass.entity.SlicecagePattern;
|
import com.northglass.repository.GalssTaskDao;
|
import com.northglass.repository.IdentifyErrorDao;
|
import com.northglass.repository.PasswordDao;
|
import com.northglass.repository.PatternTaskDao;
|
import com.northglass.repository.PreprocessingGlassDao;
|
|
|
@Component
|
@Transactional
|
public class IdentifyMachineService {
|
|
@Autowired
|
private GalssTaskDao galssTaskDao;
|
|
@Autowired
|
private PatternTaskDao patternTaskDao;
|
|
@Autowired
|
private PasswordDao passwordDao;
|
|
@Autowired
|
private IdentifyErrorDao identifyErrorDao;
|
|
@Autowired
|
private PreprocessingGlassDao preprocessingGlassDao;
|
|
private static final Logger LOGGER = LoggerFactory.getLogger(IdentifyMachineService.class);
|
|
public Map<String, Object> getCeliangManageData(String groups) {
|
|
// Long machineId = Long.valueOf(groups);
|
PreprocessingGlass preprocessingGlass = preprocessingGlassDao.findBygroup(Integer.parseInt(groups));
|
Map<String, Object> param = new HashMap<String, Object>();
|
if(preprocessingGlass!=null){
|
param.put("actuallength", preprocessingGlass.getActualLength());
|
param.put("actualwidth", preprocessingGlass.getActualWidth());
|
param.put("color", preprocessingGlass.getColor());
|
param.put("thickness", preprocessingGlass.getThickness());
|
param.put("status", preprocessingGlass.getStatu());
|
if (preprocessingGlass.getGlassId() != 0) {
|
param.put("width", preprocessingGlass.getWidth());
|
param.put("length", preprocessingGlass.getLength());
|
param.put("glassid", preprocessingGlass.getGlassId());
|
}
|
if (preprocessingGlass.getStatu().equals("匹配失败")) {
|
param.put("img", "quxiao.png");
|
param.put("mesgess", "玻璃匹配失败");
|
}else if(preprocessingGlass.getStatu().equals("匹配失败1")){
|
param.put("img", "quxiao.png");
|
param.put("mesgess", "玻璃摆放不正确");
|
}else if(preprocessingGlass.getStatu().equals("多数据匹配")){
|
param.put("img", "quxiao.png");
|
param.put("mesgess", "玻璃多数据匹配失败");
|
}else {
|
param.put("img", "zhengque.png");
|
}
|
/*int totalPieces = 0;
|
int completePieces = 0;
|
if (preprocessingGlass.getRawPackageTxt()!=null) {
|
List<Glass> glasses = glassDao.findByRaw(preprocessingGlass.getRawPackageTxt().getId());
|
if (glasses.size()>0) {
|
for (Glass glass : glasses) {
|
completePieces = completePieces + glass.getCompletePieces();
|
totalPieces = totalPieces + glass.getPieces();
|
}
|
}
|
}
|
param.put("totalPieces", totalPieces);
|
param.put("completePieces", completePieces);
|
param.put("leftPieces", totalPieces - completePieces);
|
param.put("progress", ((double) completePieces / (double) totalPieces * 100) + "%");*/
|
// 测量结果显示。
|
// - 若找到匹配玻璃，则显示结果为匹配成功，不需要人工处理，自动执行送片；
|
// - 若没有找到识别玻璃，则显示两个按钮
|
// - 一个是重新匹配，允许用户校正并重新测量；
|
// - 另一个是匹配失败，需要用户自己将玻璃移除，并确认；
|
StringBuffer html = new StringBuffer();
|
param.put("identifyResultHtml", html.toString());
|
}
|
return param;
|
|
}
|
|
public List<GalssTask> getGlass(Long groups) {
|
PreprocessingGlass preprocessingGlass=preprocessingGlassDao.findBygroup(Integer.parseInt(String.valueOf(groups)));
|
if(preprocessingGlass.getStatu().equals("多数据匹配")){
|
IdentifyError identifyError=identifyErrorDao.findBygroup(Integer.parseInt(String.valueOf(groups)));
|
List<GalssTask> glass=new ArrayList<GalssTask>();
|
double minwidth=preprocessingGlass.getActualWidth()-identifyError.getHeigtherror();
|
double maxwidth=preprocessingGlass.getActualWidth()+identifyError.getHeigtherror();
|
double minheigth=preprocessingGlass.getActualLength()-identifyError.getWidtherror();
|
double maxheigth=preprocessingGlass.getActualLength()+identifyError.getWidtherror();
|
|
glass=galssTaskDao.findByidentify2(groups,minwidth,maxwidth,minheigth,maxheigth);
|
return glass;
|
}else{
|
List<GalssTask> glass=new ArrayList<GalssTask>();
|
glass=galssTaskDao.findByidentify1(groups,preprocessingGlass.getMinwidths());
|
return glass;
|
}
|
|
}
|
|
public List<GalssTask> getGlass2(Long groups) {
|
PatternTask patternTask =patternTaskDao.findbygroups2(groups);
|
PreprocessingGlass preprocessingGlass=preprocessingGlassDao.findBygroup(Integer.parseInt(String.valueOf(groups)));
|
List<GalssTask> glass;
|
if(patternTask!=null){
|
glass=galssTaskDao.findpattern2(groups,preprocessingGlass.getMinwidths());
|
/*glass=galssTaskDao.findByidentify1(groups);*/
|
glass.addAll(galssTaskDao.findpattern1(patternTask.getId(),preprocessingGlass.getMinwidths()));
|
}else if(preprocessingGlass.getStatu().equals("多数据匹配")){
|
IdentifyError identifyError=identifyErrorDao.findBygroup(Integer.parseInt(String.valueOf(groups)));
|
double minwidth=preprocessingGlass.getActualWidth()-identifyError.getHeigtherror();
|
double maxwidth=preprocessingGlass.getActualWidth()+identifyError.getHeigtherror();
|
double minheigth=preprocessingGlass.getActualLength()-identifyError.getWidtherror();
|
double maxheigth=preprocessingGlass.getActualLength()+identifyError.getWidtherror();
|
|
glass=galssTaskDao.findByidentify2(groups,minwidth,maxwidth,minheigth,maxheigth);
|
return glass;
|
}else{
|
glass=galssTaskDao.findByidentify1(groups,preprocessingGlass.getMinwidths());
|
}
|
|
return glass;
|
|
|
}
|
|
public String rankhtml(Long groups){
|
/*PatternTask patternTask =patternTaskDao.findbygroups2(groups);
|
if(patternTask!=null){
|
return patternTask.getRank().toString();
|
}else{
|
return "";
|
}*/
|
/*
|
Long galssTask=galssTaskDao.findBypatternTask(groups);
|
List<GalssTask> g=galssTaskDao.findBypatternTask(groups,galssTask);
|
System.out.println(galssTask+":"+g.size());*/
|
try {
|
DBSession sn=mes.getMesDBHelper().createSession(false);
|
sn.createSql("select * from y_Len_CeLiang where Mode_State=1 and groups=? limit 0,1");
|
ResultSet r= sn.query(groups).getCurrentResult();
|
String minpattern="";
|
while (r.next()) {
|
minpattern=r.getString("minpattern");
|
}
|
sn.createSql(minpattern);
|
ResultSet r2= sn.query(groups).getCurrentResult();
|
while (r2.next()) {
|
return r2.getString(1);
|
}
|
} catch (Exception e) {
|
// TODO: handle exception
|
}
|
return "";
|
}
|
|
public String buttonhmtl(int groups){
|
StringBuffer html = new StringBuffer();
|
PreprocessingGlass preprocessingGlass=preprocessingGlassDao.findBygroup(groups);
|
if (preprocessingGlass.getMarking()==1){
|
html.append("<button style='background-color: red' type='button' onclick='onchecks(1)' class='btn btn-primary '>打标模式</button> ");
|
html.append("<button type='button' onclick='onchecks(0)' class='btn btn-primary '>不打标模式</button>");
|
}else if (preprocessingGlass.getMarking()==0){
|
html.append("<button type='button' onclick='onchecks(1)' class='btn btn-primary '>打标模式</button> ");
|
html.append("<button style='background-color: red' type='button' onclick='onchecks(0)' class='btn btn-primary '>不打标模式</button>");
|
}
|
return html.toString();
|
}
|
|
public String buttonhmtl2(Long groups){
|
StringBuffer html = new StringBuffer();
|
List<PatternTask> patternTask =patternTaskDao.findbygroups3(groups);
|
if (patternTask.size()>0){
|
html.append("<button style='background-color: red' type='button' onclick='onchecks3()' class='btn btn-primary '>全单模式</button> ");
|
}
|
return html.toString();
|
}
|
public String buttonhmthtml(Long groups){
|
StringBuffer html = new StringBuffer();
|
PreprocessingGlass preprocessingGlass=preprocessingGlassDao.findBygroup(Integer.parseInt(groups+""));
|
try {
|
DBSession sn=mes.getMesDBHelper().createSession(false);
|
sn.createSql("select * from y_Len_CeLiang where Mode_State=1 and groups=? limit 0,1");
|
ResultSet r= sn.query(groups).getCurrentResult();
|
String Fx_Content="";
|
while (r.next()) {
|
Fx_Content=r.getString("Fx_Content");
|
}
|
sn.createSql(Fx_Content);
|
ResultSet r2= sn.query(groups).getCurrentResult();
|
while (r2.next()) {
|
String work_procedure=r2.getString("work_procedure");
|
String work_state=r2.getString("work_state");
|
Long id=Long.valueOf(r2.getString("id"));
|
String width=r2.getString("width");
|
String height=r2.getString("height");
|
String edgwidth=r2.getString("edg_width");
|
String edgheight=r2.getString("edg_height");
|
if("测量".equals(work_procedure)){
|
if(Double.parseDouble(width)<preprocessingGlass.getMinwidths() ||Double.parseDouble(height)<preprocessingGlass.getMinwidths() ){
|
html.append("<button id='button' onclick='onchecks1("+id+")' style='width:"+(Double.parseDouble(edgheight)/5)+"px;")
|
.append("height:"+(Double.parseDouble(edgwidth)/5)+"px;' type='button' class='btn btn-primary2'>"+width+"x"+height+"</button>");
|
}else if("破损".equals(work_state) ){
|
html.append("<button id='button' onclick='onchecks2("+id+")' style='width:"+(Double.parseDouble(edgheight)/5)+"px;")
|
.append("height:"+(Double.parseDouble(edgwidth)/5)+"px;' type='button' class='btn btn-primary1'>"+width+"x"+height+"</button>");
|
}else{
|
html.append("<button id='button' onclick='onchecks2("+id+")' style='width:"+(Double.parseDouble(edgheight)/5)+"px;")
|
.append("height:"+(Double.parseDouble(edgwidth)/5)+"px;' type='button' class='btn btn-primary'>"+width+"x"+height+"</button>");
|
}
|
}else{
|
html.append("<button id='button' style='width:"+(Double.parseDouble(edgheight)/5)+"px;")
|
.append("height:"+(Double.parseDouble(edgwidth)/5)+"px;' type='button' class='btn btn-primary3'>"+width+"x"+height+"</button>");
|
}
|
}
|
} catch (Exception e) {
|
// TODO: handle exception
|
System.out.println("异常：冷加工测量 - 线路："+groups);
|
}
|
|
|
return html.toString();
|
}
|
/* public String buttonhmthtml(Long groups){
|
StringBuffer html = new StringBuffer();
|
PreprocessingGlass preprocessingGlass=preprocessingGlassDao.findBygroup(Integer.parseInt(groups+""));
|
PatternTask patternTask =patternTaskDao.findbygroups2(groups);
|
if(patternTask!=null){
|
if(patternTask.getRank()!=0){
|
List<GalssTask> galssTasklist=galssTaskDao.findpattern(patternTask.getId());
|
|
if(galssTasklist!=null){
|
for (GalssTask galssTask : galssTasklist) {
|
if(galssTask.getWorkProcedure().equals("测量")){
|
if(galssTask.getWidth()<preprocessingGlass.getMinwidths() ||galssTask.getHeight()<preprocessingGlass.getMinwidths() ){
|
html.append("<button id='button' onclick='onchecks1("+galssTask.getId()+")' style='width:"+(Double.parseDouble(galssTask.getEdgHeight())/5)+"px;")
|
.append("height:"+(Double.parseDouble(galssTask.getEdgWidth())/5)+"px;' type='button' class='btn btn-primary2'>"+galssTask.getWidth()+"x"+galssTask.getHeight()+"</button>");
|
}else if(galssTask.getWorkState().equals("破损") ){
|
html.append("<button id='button' onclick='onchecks2("+galssTask.getId()+")' style='width:"+(Double.parseDouble(galssTask.getEdgHeight())/5)+"px;")
|
.append("height:"+(Double.parseDouble(galssTask.getEdgWidth())/5)+"px;' type='button' class='btn btn-primary1'>"+galssTask.getWidth()+"x"+galssTask.getHeight()+"</button>");
|
}else{
|
html.append("<button id='button' onclick='onchecks2("+galssTask.getId()+")' style='width:"+(Double.parseDouble(galssTask.getEdgHeight())/5)+"px;")
|
.append("height:"+(Double.parseDouble(galssTask.getEdgWidth())/5)+"px;' type='button' class='btn btn-primary'>"+galssTask.getWidth()+"x"+galssTask.getHeight()+"</button>");
|
}
|
|
}else{
|
html.append("<button id='button' style='width:"+(Double.parseDouble(galssTask.getEdgHeight())/5)+"px;")
|
.append("height:"+(Double.parseDouble(galssTask.getEdgWidth())/5)+"px;' type='button' class='btn btn-primary3'>"+galssTask.getWidth()+"x"+galssTask.getHeight()+"</button>");
|
}
|
}
|
}
|
}
|
}
|
|
|
return html.toString();
|
}*/
|
|
public void Deleteglalls(String groups, String glassid) {
|
//破损
|
PreprocessingGlass gs = preprocessingGlassDao.findBygroup(Integer.parseInt(groups));
|
if(gs.getFlag()==0){
|
GalssTask glass=galssTaskDao.findOne(Integer.valueOf(glassid).longValue());
|
gs.setFlag(3);
|
glass.setWorkState("破损");
|
preprocessingGlassDao.save(gs);
|
galssTaskDao.save(glass);
|
}
|
}
|
|
public void updatestate(Long id) {
|
GalssTask glass=galssTaskDao.findOne(id);
|
glass.setWorkState("破损");
|
galssTaskDao.save(glass);
|
|
}
|
|
|
public void updatepatternstate(Long groups,String id) {
|
|
if(id.equals("上")){
|
PatternTask patternTask = patternTaskDao.findbygroupsfalg(groups);
|
if(patternTask!=null){
|
patternTask.setFlag(0);
|
patternTaskDao.save(patternTask);
|
}
|
|
}else if(id.equals("下")){
|
PatternTask patternTask = patternTaskDao.findbygroups2(groups);
|
if(patternTask!=null){
|
patternTask.setFlag(1);
|
patternTaskDao.save(patternTask);
|
}
|
}
|
|
|
|
}
|
public void updatepatternstates(Long groups) {
|
|
List<PatternTask> patternTask = patternTaskDao.findIdGroup(groups);
|
for (PatternTask patternTask2 : patternTask) {
|
if(patternTask2!=null){
|
patternTask2.setFlag(1);
|
patternTaskDao.save(patternTask2);
|
}
|
}
|
|
}
|
|
public void yichu(String groups) {
|
//移除
|
PreprocessingGlass gs = preprocessingGlassDao.findBygroup(Integer.parseInt(groups));
|
gs.setFlag(-1);
|
preprocessingGlassDao.save(gs);
|
}
|
public void modify(String groups, String glassid) {
|
PreprocessingGlass preprocessingGlass = preprocessingGlassDao.findBygroup(Integer.parseInt(groups));
|
//找出当前的玻璃,并修改指认
|
if(preprocessingGlass.getFlag()==0){
|
|
preprocessingGlass.setFlag(Long.parseLong(glassid));
|
|
preprocessingGlassDao.save(preprocessingGlass);
|
}
|
|
}
|
|
public void updatemarking(String type,int groups) {
|
PreprocessingGlass preprocessingGlass = preprocessingGlassDao.findBygroup(groups);
|
preprocessingGlass.setMarking(Integer.parseInt(type));
|
preprocessingGlassDao.save(preprocessingGlass);
|
}
|
|
public IdentifyError getfloor(String groups) {
|
|
return identifyErrorDao.findBygroup(Integer.parseInt(groups));
|
}
|
|
public double getminwidth(String groups) {
|
PreprocessingGlass preprocessingGlass = preprocessingGlassDao.findBygroup(Integer.parseInt(groups));
|
return preprocessingGlass.getMinwidths();
|
}
|
|
|
public void modifyErrorRange(String groups, String floor, String ceiling) {
|
IdentifyError identifyError = identifyErrorDao.findBygroup(Integer.parseInt(groups));
|
if (identifyError != null) {
|
identifyError.setWidtherror(Double.parseDouble(floor));
|
identifyError.setHeigtherror(Double.parseDouble(ceiling));
|
identifyErrorDao.save(identifyError);
|
}
|
}
|
|
public void modifyErrorRange2(String groups, String floor) {
|
PreprocessingGlass preprocessingGlass = preprocessingGlassDao.findBygroup(Integer.parseInt(groups));
|
if (preprocessingGlass != null) {
|
preprocessingGlass.setMinwidths(Double.parseDouble(floor));
|
preprocessingGlassDao.save(preprocessingGlass);
|
}
|
}
|
|
public String BupianForHtml() {
|
StringBuffer html = new StringBuffer();
|
List<GalssTask> glassLists=galssTaskDao.findByidentify();
|
for (GalssTask glass : glassLists) {
|
html.append("<tr><td style='text-align:center;'>").append(glass.getId()).append("</td>");
|
html.append("<td style='text-align:center;'>").append(glass.getHeight()).append("</td>");
|
html.append("<td style='text-align:center;'>").append(glass.getWidth()).append("</td>");
|
html.append("<td style='text-align:center;'>").append(glass.getThickness()).append("</td>");
|
html.append("<td style='text-align:center;'>").append(glass.getColor()).append("</td>");
|
html.append("<td style='text-align:center;'>").append(glass.getWorkState()).append("</td>");
|
html.append("</tr>");
|
}
|
|
|
|
return html.toString();
|
}
|
|
|
public void addgalsstask(HttpServletRequest request) {
|
GalssTask galssTask=new GalssTask();
|
galssTask.setGalssId(Long.valueOf(request.getParameter("galssid")));
|
galssTask.setWidth(Double.valueOf(request.getParameter("width")));
|
galssTask.setHeight(Double.valueOf(request.getParameter("heigth")));
|
galssTask.setThickness(Double.valueOf(request.getParameter("thickness")));
|
galssTask.setColor(request.getParameter("color"));
|
galssTask.setEdgHeight(request.getParameter("edgwidth"));
|
galssTask.setEdgWidth(request.getParameter("edgheight"));
|
galssTask.setEdgSpeed1(request.getParameter("edgspeed1"));
|
galssTask.setEdgSpeed2(request.getParameter("edgspeed2"));
|
galssTask.setDropFrame(request.getParameter("dropframe"));
|
galssTask.setFineThrowing(Integer.parseInt(request.getParameter("finethrowing")));
|
galssTask.setWorkProcedure(request.getParameter("workprocedure"));
|
galssTask.setWorkState(request.getParameter("workstart"));
|
galssTask.setSlicecageFlag("0");
|
galssTask.setStartTime(new Date());
|
galssTaskDao.save(galssTask);
|
}
|
|
|
public boolean modifypassword(String password1,String password2) {
|
System.out.println(password2);
|
Password password =passwordDao.findpassword(password1);
|
if(password!=null){
|
password.setPassword(password2);
|
passwordDao.save(password);
|
return true;
|
}else{
|
return false;
|
}
|
|
}
|
}
|
