package com.shlanbao.tzsc.pms.equ.assessment.service.impl;
|
|
|
import java.math.BigDecimal;
|
import java.math.RoundingMode;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import com.shlanbao.tzsc.utils.tools.FillUserInfoUtil;
|
import com.shlanbao.tzsc.utils.tools.LogAnno;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.EqmWkshopAssessmentDaoI;
|
import com.shlanbao.tzsc.base.dao.SchFilterCountDaoI;
|
import com.shlanbao.tzsc.base.interceptor.WorkOrderStatChangeInterceptor;
|
import com.shlanbao.tzsc.base.mapping.EqmWkshopAssessment;
|
import com.shlanbao.tzsc.base.mapping.SchFilterCount;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.equ.assessment.EqmAssessment;
|
import com.shlanbao.tzsc.pms.equ.assessment.EqmWkshopAssessmentBean;
|
import com.shlanbao.tzsc.pms.equ.assessment.service.WkshopAssessmentServiceI;
|
import com.shlanbao.tzsc.pms.md.FilterCount.SchFilterCountBean;
|
import com.shlanbao.tzsc.pms.md.FilterCount.service.FilterCountServiceI;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
@Service
|
public class WkshopAssessmentServiceImpl extends BaseService implements
|
WkshopAssessmentServiceI {
|
@Autowired
|
private EqmWkshopAssessmentDaoI filterCountDaoI;
|
@Autowired
|
private HttpServletRequest request;
|
|
@Override
|
public DataGrid getAllFilterCount(EqmWkshopAssessmentBean filterCount) throws Exception {
|
String hql = "from EqmWkshopAssessment o where 1=1 ";
|
if (StringUtil.notEmpty(filterCount.getDate())) {
|
hql+="and to_char(o.date,'yyyy-mm')='"+filterCount.getDate()+"'";
|
}
|
if (StringUtil.notEmpty(filterCount.getWorkShop())) {
|
hql+="and o.workShop = '"+filterCount.getWorkShop()+"'";
|
}
|
List<EqmWkshopAssessment> query = filterCountDaoI.query(hql);
|
List<EqmWkshopAssessmentBean> rows = BeanConvertor.copyList(query, EqmWkshopAssessmentBean.class);
|
for(int i=0;i<query.size();i++){
|
FillUserInfoUtil.fillCreateAndUpdateUserInfo(query.get(i),rows.get(i));
|
}
|
return new DataGrid(rows, 0L);
|
}
|
@LogAnno(operateType = "新增车间")
|
@Override
|
public void addFilterCount(EqmWkshopAssessmentBean filterCount) throws Exception {
|
EqmWkshopAssessment o = BeanConvertor.copyProperties(filterCount, EqmWkshopAssessment.class);
|
FillUserInfoUtil.fillCreateUserInfo(o,request);
|
filterCountDaoI.save(o);
|
}
|
@LogAnno(operateType = "编辑车间")
|
@Override
|
public void editFilterCount(EqmWkshopAssessmentBean filterCount) throws Exception {
|
EqmWkshopAssessment o = BeanConvertor.copyProperties(filterCount, EqmWkshopAssessment.class);
|
EqmWkshopAssessment eqmWkshopAssessment = filterCountDaoI.findById(EqmWkshopAssessment.class, filterCount.getId());
|
BeanConvertor.copyProperties(o,eqmWkshopAssessment);
|
FillUserInfoUtil.fillUpdateUserInfo(eqmWkshopAssessment,request);
|
filterCountDaoI.update(eqmWkshopAssessment);
|
}
|
@LogAnno(operateType = "删除车间")
|
@Override
|
public void deleteFilterCount(String id) throws Exception {
|
filterCountDaoI.deleteById(id, EqmWkshopAssessment.class);
|
|
}
|
@Override
|
public EqmWkshopAssessmentBean getFilterCountById(String id) throws Exception {
|
return BeanConvertor.copyProperties(filterCountDaoI.findById(EqmWkshopAssessment.class, id),EqmWkshopAssessmentBean.class);
|
}
|
@LogAnno(operateType = "车间考核数据维护反馈MES")
|
@Override
|
public void orderResult(String ids,String user) {
|
String[] idst=ids.split(",");
|
String lsqlp = "select count(*)"+
|
" from SYS_EQP_CATEGORY a join EQM_LUBRICATION b"+
|
" on a.id = b.sys_ec and b.enable = 1 and a.del = 0 and a.enable = 1 and a.maintainace_type=2"+
|
" join EQM_WHEEL_COVEL_PLAN c on c.attr1=a.cycle_type and c.attr2=a.cycle_num and (c.shift_id = b.shift_id or b.shift_id = 0 or b.shift_id is null)"+
|
" join MD_EQUIPMENT d on c.eqp_id = d.id and a.eqp_type = d.eqp_type_id and d.work_shop = ? "+
|
" where to_char(c.plan_date,'yyyy-mm')=? and c.type =2 and d.id=?";
|
String lsqls = "select count(1) "+
|
" from SYS_EQP_CATEGORY a join EQM_LUBRICATION b"+
|
" on a.id = b.sys_ec and b.enable = 1 and a.del = 0 and a.enable = 1 and a.maintainace_type=2"+
|
" join EQM_WHEEL_COVEL_PLAN c on c.attr1=a.cycle_type and c.attr2=a.cycle_num and (c.shift_id = b.shift_id or b.shift_id = 0 or b.shift_id is null)"+
|
" join MD_EQUIPMENT d on c.eqp_id = d.id and a.eqp_type = d.eqp_type_id and d.work_shop = ?"+
|
" join EQM_WHEEL_COVEL_PARAM e on c.id = e.ewcp_id and b.num = e.job_no and e.sys_ec = b.id and e.complete_status = '已反馈MES'"+
|
" where to_char(c.plan_date,'yyyy-mm')=? and c.type =2 and d.id=?";
|
String isqlp = "select count(1) "+
|
"from SYS_EQP_CATEGORY a join EQM_INSPECTION b "+
|
"on a.id = b.sys_ec and b.enable = 1 and a.del = 0 and a.enable = 1 and a.maintainace_type=5 "+
|
"join EQM_WHEEL_COVEL_PLAN c on c.attr1=a.cycle_type and c.attr2=a.cycle_num and (c.shift_id = b.shift_id or b.shift_id = 0 or b.shift_id is null) "+
|
"join MD_EQUIPMENT d on c.eqp_id = d.id and a.eqp_type = d.eqp_type_id and d.work_shop = ? "+
|
"where to_char(c.plan_date,'yyyy-mm')=? and c.type =5 and d.id=? ";
|
String isqls = "select count(1) "+
|
"from SYS_EQP_CATEGORY a join EQM_INSPECTION b "+
|
"on a.id = b.sys_ec and b.enable = 1 and a.del = 0 and a.enable = 1 and a.maintainace_type=5 "+
|
"join EQM_WHEEL_COVEL_PLAN c on c.attr1=a.cycle_type and c.attr2=a.cycle_num and (c.shift_id = b.shift_id or b.shift_id = 0 or b.shift_id is null) "+
|
" join MD_EQUIPMENT d on c.eqp_id = d.id and a.eqp_type = d.eqp_type_id and d.work_shop = ? "+
|
"join EQM_WHEEL_COVEL_PARAM e on c.id = e.ewcp_id and b.num = e.job_no and e.complete_status = '已反馈MES' and b.id = e.sys_ec "+
|
"where to_char(c.plan_date,'yyyy-mm')=? and c.type =5 and d.id=? ";
|
for(int i=0;i<idst.length;i++){
|
EqmWkshopAssessment bean = filterCountDaoI.findById(EqmWkshopAssessment.class, idst[i]);
|
EqmWkshopAssessmentBean assessmentBean = null;
|
try {
|
assessmentBean = BeanConvertor.copyProperties(bean, EqmWkshopAssessmentBean.class);
|
} catch (Exception e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
List<EqmAssessment> ealist = new ArrayList<>();
|
if ("2".equals(bean.getWorkShop())) {
|
|
EqmAssessment eqmAssessment = null;
|
List<?> list = filterCountDaoI.queryBySql("select a.id,a.EQUIPMENT_NAME from MD_EQUIPMENT a where WORK_SHOP = 1", null);
|
|
if (list!=null&&list.size()>0) {
|
for (Object object : list) {
|
eqmAssessment = new EqmAssessment();
|
Object[] o = (Object[]) object;
|
eqmAssessment.setSystem(o[1].toString());
|
List<?> plan = filterCountDaoI.queryBySql(lsqlp, 1,assessmentBean.getDate(),o[0].toString());
|
if (plan!=null&&plan.size() > 0&&Integer.valueOf(plan.get(0).toString())>0) {
|
eqmAssessment.setPlanCheckNum(Integer.valueOf(plan.get(0).toString()));
|
List<?> actual = filterCountDaoI.queryBySql(lsqls, 1,assessmentBean.getDate(),o[0].toString());
|
eqmAssessment.setCheckType("2");
|
if (actual!=null&&actual.size()>0) {
|
eqmAssessment.setActualCheckNum(Integer.valueOf(actual.get(0).toString()));
|
}else{
|
eqmAssessment.setActualCheckNum(0);
|
}
|
eqmAssessment.setClRate(Double.valueOf(eqmAssessment.getActualCheckNum())/eqmAssessment.getPlanCheckNum()*100);
|
eqmAssessment.setClRate(new BigDecimal(eqmAssessment.getClRate()).setScale(2, RoundingMode.HALF_UP).doubleValue());
|
ealist.add(eqmAssessment);
|
}
|
}
|
for (Object object : list) {
|
eqmAssessment = new EqmAssessment();
|
Object[] o = (Object[]) object;
|
eqmAssessment.setSystem(o[1].toString());
|
List<?> plan = filterCountDaoI.queryBySql(isqlp, 1,assessmentBean.getDate(),o[0].toString());
|
if (plan!=null&&plan.size() > 0&&Integer.valueOf(plan.get(0).toString())>0) {
|
eqmAssessment.setPlanCheckNum(Integer.valueOf(plan.get(0).toString()));
|
List<?> actual = filterCountDaoI.queryBySql(isqls, 1,assessmentBean.getDate(),o[0].toString());
|
eqmAssessment.setCheckType("5");
|
if (actual!=null&&actual.size()>0) {
|
eqmAssessment.setActualCheckNum(Integer.valueOf(actual.get(0).toString()));
|
}else{
|
eqmAssessment.setActualCheckNum(0);
|
}
|
eqmAssessment.setClRate(Double.valueOf(eqmAssessment.getActualCheckNum())/eqmAssessment.getPlanCheckNum()*100);
|
eqmAssessment.setClRate(new BigDecimal(eqmAssessment.getClRate()).setScale(2, RoundingMode.HALF_UP).doubleValue());
|
ealist.add(eqmAssessment);
|
}
|
}
|
}
|
}
|
if ("6".equals(bean.getWorkShop())) {
|
|
EqmAssessment eqmAssessment = null;
|
List<?> list = filterCountDaoI.queryBySql("select a.id,a.EQUIPMENT_NAME from MD_EQUIPMENT a where WORK_SHOP = 2", null);
|
|
if (list!=null&&list.size()>0) {
|
for (Object object : list) {
|
eqmAssessment = new EqmAssessment();
|
Object[] o = (Object[]) object;
|
eqmAssessment.setSystem(o[1].toString());
|
List<?> plan = filterCountDaoI.queryBySql(lsqlp, 2,assessmentBean.getDate(),o[0].toString());
|
if (plan!=null&&plan.size() > 0&&Integer.valueOf(plan.get(0).toString())>0) {
|
eqmAssessment.setPlanCheckNum(Integer.valueOf(plan.get(0).toString()));
|
List<?> actual = filterCountDaoI.queryBySql(lsqls, 2,assessmentBean.getDate(),o[0].toString());
|
eqmAssessment.setCheckType("2");
|
if (actual!=null&&actual.size()>0) {
|
eqmAssessment.setActualCheckNum(Integer.valueOf(actual.get(0).toString()));
|
}else{
|
eqmAssessment.setActualCheckNum(0);
|
}
|
|
eqmAssessment.setClRate(Double.valueOf(eqmAssessment.getActualCheckNum())/eqmAssessment.getPlanCheckNum()*100);
|
eqmAssessment.setClRate(new BigDecimal(eqmAssessment.getClRate()).setScale(2, RoundingMode.HALF_UP).doubleValue());
|
ealist.add(eqmAssessment);
|
}
|
}
|
for (Object object : list) {
|
eqmAssessment = new EqmAssessment();
|
Object[] o = (Object[]) object;
|
eqmAssessment.setSystem(o[1].toString());
|
List<?> plan = filterCountDaoI.queryBySql(isqlp, 2,assessmentBean.getDate(),o[0].toString());
|
if (plan!=null&&plan.size() > 0&&Integer.valueOf(plan.get(0).toString())>0) {
|
eqmAssessment.setPlanCheckNum(Integer.valueOf(plan.get(0).toString()));
|
List<?> actual = filterCountDaoI.queryBySql(isqls, 2,assessmentBean.getDate(),o[0].toString());
|
eqmAssessment.setCheckType("5");
|
if (actual!=null&&actual.size()>0) {
|
eqmAssessment.setActualCheckNum(Integer.valueOf(actual.get(0).toString()));
|
}else{
|
eqmAssessment.setActualCheckNum(0);
|
}
|
eqmAssessment.setClRate(Double.valueOf(eqmAssessment.getActualCheckNum())/eqmAssessment.getPlanCheckNum()*100);
|
eqmAssessment.setClRate(new BigDecimal(eqmAssessment.getClRate()).setScale(2, RoundingMode.HALF_UP).doubleValue());
|
ealist.add(eqmAssessment);
|
}
|
}
|
}
|
|
}
|
assessmentBean.setTotalAmount( Double.valueOf(filterCountDaoI.queryBySql("select sum(REPAIRAMOUNT) from EQM_WKSHOP_ASSESSMENT where WORKSHOP = ?", bean.getWorkShop()).get(0).toString()));
|
assessmentBean.setList(ealist);
|
WorkOrderStatChangeInterceptor.getInstance().DASSendWkshopAssessment(assessmentBean);
|
bean.setIsFeedback("1");
|
bean.setFeedbacker(user);
|
bean.setFeedbackTime(new Date());
|
FillUserInfoUtil.fillUpdateUserInfo(bean,request);
|
}
|
}
|
@LogAnno(operateType = "批量删除车间")
|
@Override
|
public void batchDeleteFilterCount(String ids) {
|
String[] split = ids.split(",");
|
try {
|
for (int i = 0; i <split.length; i++) {
|
filterCountDaoI.deleteById(split[i], EqmWkshopAssessment.class);
|
}
|
|
}catch (Exception e){
|
e.printStackTrace();
|
}
|
|
}
|
|
}
|
