package com.shlanbao.tzsc.pms.equ.lubricate.service.impl;
|
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import com.shlanbao.tzsc.base.dao.BaseDaoI;
|
import com.shlanbao.tzsc.base.dao.EqmLubricantDaoI;
|
import com.shlanbao.tzsc.base.dao.EqmLubricantPlanDaoI;
|
import com.shlanbao.tzsc.base.mapping.EqmLubricant;
|
import com.shlanbao.tzsc.base.mapping.EqmLubricantPlan;
|
import com.shlanbao.tzsc.base.mapping.MdEquipment;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.equ.lubricate.beans.EqmBubricantfBean;
|
import com.shlanbao.tzsc.pms.equ.lubricate.beans.EqmLubricantPlanBean;
|
import com.shlanbao.tzsc.pms.equ.lubricate.service.EqmLubricantPlanServiceI;
|
import com.shlanbao.tzsc.utils.params.SysEqpTypeBase;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
|
@Service
|
public class EqmLubricantPlanServiceImpl extends BaseService implements EqmLubricantPlanServiceI{
|
|
@Autowired
|
private BaseDaoI<Object> baseDao;
|
@Autowired
|
private EqmLubricantPlanDaoI eqmLubricantPlanDaoI;
|
@Autowired
|
private EqmLubricantDaoI eqmLubricantDaoI;
|
|
|
/**
|
* @Title: lubricantSavePlan
|
* @Description: 根据设备周期创建设备润滑计划
|
* @param 设备润滑周期ID
|
* @param 设备ID
|
* @return boolean 返回类型
|
* @throws
|
*/
|
public EqmLubricantPlan lubricantSavePlan(String lid,String eqpId){
|
EqmLubricant bean=eqmLubricantDaoI.findById(EqmLubricant.class, lid);
|
EqmLubricantPlan plan=new EqmLubricantPlan();
|
plan.setEqp(new MdEquipment(eqpId));//设备id
|
//plan.setRule_id(rule_id);
|
plan.setLub_id(bean.getId());//设备润滑周期id
|
plan.setStatus(0);//默认新建状态
|
plan.setDate_p(new Date());//计划完成执行日期
|
eqmLubricantPlanDaoI.save(plan);
|
return plan;
|
}
|
|
@Override
|
public EqmLubricantPlan saveBean(EqmLubricantPlan bean) {
|
eqmLubricantPlanDaoI.saveBackKey(bean);
|
return bean;
|
}
|
@Override
|
public EqmLubricantPlan getBeanById(String id) {
|
return eqmLubricantPlanDaoI.findById(EqmLubricantPlan.class, id);
|
}
|
|
@Override
|
public boolean updateBean(EqmLubricantPlanBean bean) throws Exception {
|
EqmLubricantPlan b=getBeanById(bean.getId());
|
beanConvertor.copyProperties(bean, b);
|
b.setDate_p(DateUtil.formatStringToDate(bean.getDate_plan(), "yyyy-MM-dd"));
|
eqmLubricantPlanDaoI.saveOrUpdate(b);
|
return false;
|
}
|
|
@Override
|
public DataGrid queryDataGrid(EqmLubricantPlanBean bean,PageParams pageParams) throws Exception {
|
String hql="from EqmLubricantPlan o where 1=1 ";
|
StringBuffer params = new StringBuffer();
|
if(StringUtil.notNull(bean.getId())){
|
params.append("and o.id = '" + bean.getId() +"' ");
|
}
|
if(StringUtil.notNull(bean.getEqp_id())){
|
params.append("and o.eqp.id= '" + bean.getEqp_id() +"' ");
|
}
|
if(StringUtil.notNull(bean.getCode())){
|
params.append("and o.code like '%" + bean.getCode() +"%' ");
|
}
|
if(StringUtil.notNull(bean.getDate_plan1())){
|
params.append("and to_char(o.date_p,'yyyy-mm-dd') >= '" + bean.getDate_plan1() +"' ");
|
}
|
if(StringUtil.notNull(bean.getDate_plan2())){
|
params.append("and to_char(o.date_p,'yyyy-mm-dd') <= '" + bean.getDate_plan2() +"' ");
|
}
|
List<EqmLubricantPlan> rows = eqmLubricantPlanDaoI.queryByPage(hql.concat(params.toString())+" order by o.date_p desc,o.eqp.equipmentCode ",pageParams);
|
hql = "select count(*) from EqmLubricantPlan o where 1=1 ";
|
long total=eqmLubricantPlanDaoI.queryTotal(hql.concat(params.toString()));
|
List<EqmLubricantPlanBean> beans = new ArrayList<EqmLubricantPlanBean>();
|
for(EqmLubricantPlan b:rows){
|
EqmLubricantPlanBean plan=new EqmLubricantPlanBean();
|
beanConvertor.copyProperties(b, plan);
|
if(b.getEqp()!=null){
|
plan.setEqp_id(b.getEqp().getId());
|
plan.setEqp_name(b.getEqp().getEquipmentName());
|
}
|
|
if(b.getLubricating()!=null){
|
plan.setLubricating_id(b.getLubricating().getId());
|
plan.setLubricating_name(b.getLubricating().getName());
|
}
|
if(b.getOperatives()!=null){
|
plan.setOperatives_id(b.getOperatives().getId());
|
plan.setOperatives_name(b.getOperatives().getName());
|
}
|
plan.setDate_plan(DateUtil.formatDateToString(b.getDate_p(),"yyyy-MM-dd"));
|
if(b.getEtim()!=null){
|
plan.setEtims(DateUtil.formatDateToString(b.getEtim(),"yyyy-MM-dd"));
|
}
|
if(b.getShift_id()!=null){
|
if(b.getShift_id().equals(SysEqpTypeBase.shift_0)){//班次 1-早 2-中 3-晚 0-全部
|
plan.setShift_name("全部");//获得班次
|
}
|
if(b.getShift_id().equals(SysEqpTypeBase.shift_1)){
|
plan.setShift_name("早班");
|
}
|
if(b.getShift_id().equals(SysEqpTypeBase.shift_2)){
|
plan.setShift_name("中班");
|
}
|
if(b.getShift_id().equals(SysEqpTypeBase.shift_3)){
|
plan.setShift_name("晚班");
|
}
|
}
|
if(b.getLub_id()!=null){
|
if(b.getLub_id().equals(SysEqpTypeBase.period_1)){//日润滑
|
plan.setLub_id("日润滑");//获得润滑类型
|
}
|
if(b.getLub_id().equals(SysEqpTypeBase.period_2)){//周润滑
|
plan.setLub_id("周润滑");//获得润滑类型
|
}
|
if(b.getLub_id().equals(SysEqpTypeBase.period_3)){//月润滑
|
plan.setLub_id("月润滑");//获得润滑类型
|
}
|
if(b.getLub_id().equals(SysEqpTypeBase.period_4)){//年润滑
|
plan.setLub_id("日润滑");//获得润滑类型
|
}
|
|
}
|
beans.add(plan);
|
}
|
return new DataGrid(beans,total);
|
}
|
|
@Override
|
public EqmLubricantPlanBean getBeanByIds(String id) throws Exception {
|
EqmLubricantPlan b=eqmLubricantPlanDaoI.findById(EqmLubricantPlan.class, id);
|
EqmLubricantPlanBean plan=new EqmLubricantPlanBean();
|
beanConvertor.copyProperties(b, plan);
|
if(b.getEqp()!=null){
|
plan.setEqp_id(b.getEqp().getId());
|
plan.setEqp_name(b.getEqp().getEquipmentName());
|
}
|
if(b.getLubricating()!=null){
|
plan.setLubricating_id(b.getLubricating().getId());
|
plan.setLubricating_name(b.getLubricating().getName());
|
}
|
if(b.getOperatives()!=null){
|
plan.setOperatives_id(b.getOperatives().getId());
|
plan.setOperatives_name(b.getOperatives().getName());
|
}
|
plan.setDate_plan(DateUtil.formatDateToString(b.getDate_p(),"yyyy-MM-dd"));
|
if(b.getEtim()!=null){
|
plan.setEtims(DateUtil.formatDateToString(b.getEtim(),"yyyy-MM-dd"));
|
}
|
return plan;
|
}
|
|
/**
|
* 功能说明：设备润滑计划管理-添加
|
* @author wanchanghuang
|
* @time 2015年8月21日16:35:42
|
*
|
* */
|
@Override
|
public List<?> addEqmLubricatPlan(EqmBubricantfBean bean) {
|
String sql="select id,eqp_type_id,equipment_code,equipment_name from MD_EQUIPMENT where eqp_type_id='"+bean.getEqp_typeId()+"'";
|
List<?> listMdEquipment= baseDao.queryBySql(sql);
|
return listMdEquipment;
|
}
|
|
|
/**
|
*润滑管理主表批量删除以及字表批量删除
|
* 2015.9.9--张璐
|
*/
|
@Override
|
public void deleteCycle(String ids) throws Exception {
|
ids=ids.replaceAll(",", "','");
|
String sqlZ="delete from EQM_LUBRICAT_PLAN_PARAM where PLAN_ID in ( '"+ids+"')";
|
String sqlM="delete from EQM_LUBRICAT_PLAN where ID in ( '"+ids+"')" ;
|
baseDao.updateBySql(sqlZ, null);
|
baseDao.updateBySql(sqlM, null);
|
}
|
|
|
}
|
