package com.shlanbao.tzsc.pms.equ.effective.controller;
|
|
import java.util.Date;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletResponse;
|
import javax.servlet.http.HttpSession;
|
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
|
import java.io.IOException;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Calendar;
|
import java.util.List;
|
|
import com.shlanbao.tzsc.base.mapping.EqmCullRecordBean;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.Json;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.base.model.SessionInfo;
|
import com.shlanbao.tzsc.pms.cos.spare.beans.CosSparePartsBean;
|
import com.shlanbao.tzsc.pms.equ.effective.beans.EffectiveGraphBean;
|
import com.shlanbao.tzsc.pms.equ.effective.beans.EffectiveOperaBean;
|
import com.shlanbao.tzsc.pms.equ.effective.beans.EffectiveRunTime;
|
import com.shlanbao.tzsc.pms.equ.effective.beans.EffectiveUtilizeTime;
|
import com.shlanbao.tzsc.pms.equ.effective.service.EffectiveOperaServiceI;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
/**
|
*
|
* @ClassName: EffectiveOperaController
|
* @Description: 设备有效作业率、运行效率查询
|
* @author luo
|
* @date 2015年3月9日 下午4:18:46
|
*
|
*/
|
@Controller
|
@RequestMapping("/pms/effect")
|
public class EffectiveOperaController {
|
|
@Autowired
|
public EffectiveOperaServiceI effectiveOperaServiceI;
|
/**
|
* <p>功能描述：设备有效作业率查询</p>
|
*@param bean
|
*@param pageParams
|
*@return
|
*shisihai
|
*2016上午10:26:43
|
*/
|
@ResponseBody
|
@RequestMapping("/queryDataGrid")
|
public DataGrid queryDataGrid(EffectiveOperaBean bean,PageParams pageParams){
|
return effectiveOperaServiceI.queryList(bean, pageParams);
|
}
|
/**
|
*
|
* @Title: queryGraph
|
* @Description: 设备有效作用率图表查询方法
|
* @param bean
|
* @return EffectiveGraphBean 返回类型
|
* @throws
|
*/
|
@ResponseBody
|
@RequestMapping("/queryGraph")
|
public EffectiveGraphBean queryGraph(EffectiveOperaBean bean){
|
return effectiveOperaServiceI.queryGraph(bean);
|
}
|
|
/**
|
*
|
* @Title: queryRunTimeEffective
|
* @Description: 设备运行效率
|
* @param bean
|
* @param pageParams
|
* @return DataGrid 返回类型
|
* @throws
|
*/
|
@ResponseBody
|
@RequestMapping("/queryRunTimeEffect")
|
public DataGrid queryRunTimeEffective(EffectiveRunTime bean,PageParams pageParams){
|
return effectiveOperaServiceI.queryRunTimeEffective(bean, pageParams);
|
}
|
|
/**
|
*
|
* @Title: queryRunTimeEffectivesChart
|
* @Description: 设备运行效率图表
|
* @param @param bean
|
* @param @return 设定文件
|
* @return EffectiveGraphBean 返回类型
|
* @throws
|
*/
|
@ResponseBody
|
@RequestMapping("/queryRunTimeEffectChart")
|
public EffectiveGraphBean queryRunTimeEffectivesChart(EffectiveRunTime bean){
|
return effectiveOperaServiceI.queryRunTimeEffectiveChart(bean);
|
}
|
|
|
@ResponseBody
|
@RequestMapping("/queryUtilizeEffective")
|
public DataGrid queryUtilizeEffective(EffectiveUtilizeTime bean,PageParams pageParams){
|
return effectiveOperaServiceI.quertyUtilizeEffective(bean, pageParams);
|
}
|
|
@ResponseBody
|
@RequestMapping("/queryUtilizeEffectiveChart")
|
public EffectiveGraphBean queryUtilizeEffectiveChart(EffectiveUtilizeTime bean){
|
return effectiveOperaServiceI.quertyUtilizeEffectiveChart(bean);
|
}
|
|
/**
|
* 功能说明：设备停机剔除时间管理-添加
|
* @param bean 数据实体对象
|
* @return
|
* @author wchuang
|
* @time 2015年7月21日16:18:46
|
*
|
* */
|
@ResponseBody
|
@RequestMapping("/addCullRecord")
|
public Json addCullRecord(HttpSession session,EqmCullRecordBean bean) throws Exception{
|
Json json=new Json();
|
SessionInfo loginBean = (SessionInfo) session.getAttribute("sessionInfo");
|
//创建人信息
|
bean.setCreate_user_id(loginBean.getUser().getId());
|
bean.setUpdate_user_id(loginBean.getUser().getId());
|
bean.setCreate_user_name(loginBean.getUser().getName());
|
bean.setUpdate_user_name(loginBean.getUser().getName());
|
bean.setCreate_time(new Date());
|
bean.setUpdate_time(new Date());
|
//当天（结束时间 - 起始时间） = 当天(停机时间)
|
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
|
SimpleDateFormat formatter=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
Date dBegin = sdf.parse(bean.getSdate());
|
// Date dEnd = sdf.parse(bean.getEdate());
|
bean.setDel(1);
|
|
|
Date st_date = formatter.parse(sdf.format(dBegin)+" "+bean.getStime());
|
Date ed_date = formatter.parse(sdf.format(dBegin)+" "+bean.getEtime());
|
|
bean.setSt_date(st_date);
|
bean.setEd_date(ed_date);
|
//毫秒ms
|
long diff = ed_date.getTime()-st_date.getTime();
|
//分钟
|
int stop_time=(int) (diff/(60 * 1000));
|
//当天总停机时间
|
bean.setStop_time(stop_time);
|
|
|
try{
|
//保存
|
boolean flag=effectiveOperaServiceI.addCullRecord(bean);
|
json.setMsg("添加成功");
|
json.setSuccess(flag);
|
}catch(Exception e){
|
json.setMsg("添加失败");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
/**
|
* 说明：返回日期时间段内所有日期集合
|
*
|
* */
|
public static List<Date> findDates(Date dBegin, Date dEnd) {
|
List lDate = new ArrayList();
|
lDate.add(dBegin);
|
Calendar calBegin = Calendar.getInstance();
|
// 使用给定的 Date 设置此 Calendar 的时间
|
calBegin.setTime(dBegin);
|
Calendar calEnd = Calendar.getInstance();
|
// 使用给定的 Date 设置此 Calendar 的时间
|
calEnd.setTime(dEnd);
|
// 测试此日期是否在指定日期之后
|
while (dEnd.after(calBegin.getTime())) {
|
// 根据日历的规则，为给定的日历字段添加或减去指定的时间量
|
calBegin.add(Calendar.DAY_OF_MONTH, 1);
|
lDate.add(calBegin.getTime());
|
}
|
return lDate;
|
}
|
|
|
/**
|
* 【功能说明】：设备停机剔除时间管理-查询
|
* @param bean 数据实体对象
|
* @return
|
* @author wchuang
|
* @time 2015年7月22日10:36:42
|
*
|
* */
|
@ResponseBody
|
@RequestMapping("/queryCullRecord")
|
public DataGrid queryCullRecord(EqmCullRecordBean bean,PageParams pageParams) throws Exception{
|
return effectiveOperaServiceI.queryCullRecord(bean, pageParams);
|
}
|
|
|
/**
|
* 【功能说明】：设备停机剔除时间管理-删除
|
* @param bean 数据实体对象
|
* @return
|
* @author wchuang
|
* @time 2015年7月22日14:26:21
|
*
|
* */
|
@ResponseBody
|
@RequestMapping("/deleteCullRecordById")
|
public Json deleteCullRecordById(HttpSession session,EqmCullRecordBean bean) throws Exception{
|
Json json=new Json();
|
try{
|
//保存
|
boolean flag=effectiveOperaServiceI.deleteCullRecordById(bean);
|
json.setMsg("删除成功！");
|
json.setSuccess(flag);
|
}catch(Exception e){
|
json.setMsg("删除失败！");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
/**
|
* 批量删除
|
* @param ids
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping("/batchDeleteCullRecord")
|
public Json batchDeleteCullRecord(String ids){
|
Json json=new Json();
|
try{
|
//保存
|
effectiveOperaServiceI.batchDeleteCullRecord(ids);
|
json.setMsg("删除成功！");
|
json.setSuccess(true);
|
}catch(Exception e){
|
json.setMsg("删除失败！");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
/**
|
* 导出设备有效作业率
|
* @param bean
|
*/
|
@ResponseBody
|
@RequestMapping("/deriveExcel")
|
public void deriveExcel(EffectiveOperaBean bean,HttpServletResponse response) {
|
try {
|
HSSFWorkbook wb =effectiveOperaServiceI.ExportExcelJBEffic(bean);
|
String addtime=DateUtil.getNowDateTime("yyyyMMddHHmmSSS");
|
response.reset();
|
response.setContentType("application/vnd.ms-excel");
|
response.setHeader("Content-Disposition","attachment; filename="+addtime+".xls");
|
ServletOutputStream os = response.getOutputStream();
|
wb.write(os);
|
os.flush();
|
os.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
|
/**
|
* 导出设备运行效率
|
* @param bean
|
* @param response
|
*/
|
@ResponseBody
|
@RequestMapping("/deriveEqpRunEfficExcel")
|
public void deriveEqpRunEfficExcel(EffectiveRunTime bean,HttpServletResponse response) {
|
try {
|
HSSFWorkbook wb =effectiveOperaServiceI.deriveEqpRunEfficExcel(bean);
|
String addtime=DateUtil.getNowDateTime("yyyyMMddHHmmSSS");
|
response.reset();
|
response.setContentType("application/vnd.ms-excel");
|
response.setHeader("Content-Disposition","attachment; filename="+addtime+".xls");
|
ServletOutputStream os = response.getOutputStream();
|
wb.write(os);
|
os.flush();
|
os.close();
|
} catch (IOException e) {
|
e.printStackTrace();
|
}
|
}
|
|
}
|
