package com.shlanbao.tzsc.pms.qm.prod.service.impl;
|
|
import java.text.DecimalFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.ResourceBundle;
|
import java.util.UUID;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpSession;
|
|
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.QmProdFileDao;
|
import com.shlanbao.tzsc.base.dao.QmProdManageDao;
|
import com.shlanbao.tzsc.base.mapping.MdMat;
|
import com.shlanbao.tzsc.base.mapping.QmProdFile;
|
import com.shlanbao.tzsc.base.mapping.QmProdManage;
|
import com.shlanbao.tzsc.base.mapping.SysUser;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.base.model.SessionInfo;
|
import com.shlanbao.tzsc.base.service.BaseService;
|
import com.shlanbao.tzsc.pms.qm.prod.beans.QmProdFileBean;
|
import com.shlanbao.tzsc.pms.qm.prod.beans.QmProdManageBean;
|
import com.shlanbao.tzsc.pms.qm.prod.service.QmProdManageService;
|
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
|
import com.shlanbao.tzsc.utils.tools.FileConvertSwfUtil;
|
import com.shlanbao.tzsc.utils.tools.StringUtil;
|
/**
|
* 工艺规程业务实现类
|
* @author luther.zhang
|
* @create 2014-12-22
|
*/
|
@Service
|
public class QmProdManageServiceImpl extends BaseService implements QmProdManageService{
|
@Autowired
|
private QmProdManageDao qmProdManageDao;
|
@Autowired
|
private QmProdFileDao qmProdFileDao;
|
private static final ResourceBundle bundle = ResourceBundle.getBundle("config");
|
public QmProdManageBean getBeanById(String id) throws Exception {
|
String hql=" from QmProdManage o left join fetch o.mdMat mat where o.id=? ";//品名(牌号)
|
QmProdManage qmProdManage = qmProdManageDao.unique(QmProdManage.class,hql.toString(), id);
|
QmProdManageBean bean = BeanConvertor.copyProperties(qmProdManage, QmProdManageBean.class);
|
if(null!=qmProdManage.getMdMat()){
|
bean.setProcId(qmProdManage.getMdMat().getId());
|
bean.setMdMatName(qmProdManage.getMdMat().getName());
|
}
|
return bean;
|
}
|
@Override
|
public DataGrid queryList(QmProdManageBean bean, PageParams pageParams) throws Exception{
|
|
StringBuffer hql=new StringBuffer();
|
hql.append("from QmProdManage o ");
|
hql.append("left join fetch o.mdMat mat ");//品名(牌号)
|
//hql.append("left join fetch o.sysUserByReviewUserid pzr "); //批准人ID
|
//hql.append("left join fetch o.sysUserByAddUserid xzr "); //新增人ID
|
//hql.append("left join fetch o.sysUserByUploadUserid uplaod "); //上传人ID
|
hql.append("where o.prodStop=0 ");
|
List<Object> params = new ArrayList<Object>();
|
if(StringUtil.notNull(bean.getProcId())){//品名
|
hql.append("and mat.id = ? ");
|
params.add(bean.getProcId());
|
}
|
if(StringUtil.notNull(bean.getProdNumber())){//编号
|
hql.append("and o.prodNumber like ? ");
|
params.add("%"+bean.getProdNumber()+"%");
|
}
|
if(StringUtil.notNull(bean.getProdName())){//名称
|
hql.append("and o.prodName like ? ");
|
params.add("%"+bean.getProdName()+"%");
|
}
|
if(StringUtil.notNull(bean.getProdVersion())){//版本号
|
String prodVersion = bean.getProdVersion().toUpperCase();//大写
|
prodVersion = prodVersion.replaceAll("V","");
|
if(null!=prodVersion&&!"".equals(prodVersion)){
|
hql.append("and o.prodVersion like ? ");
|
params.add("%"+prodVersion+"%");
|
}
|
}
|
if(StringUtil.notNull(bean.getProdStatus())){//审核状态
|
hql.append("and o.prodStatus = ? ");
|
params.add(bean.getProdStatus());
|
}
|
try {
|
long total=qmProdManageDao.queryTotal("select count(*) "+hql.toString().replaceAll("fetch", ""),params);
|
List<QmProdManageBean> list= new ArrayList<QmProdManageBean>();
|
if(total>0){
|
hql.append("order by o.createDatetime desc ");
|
List<QmProdManage> rows = qmProdManageDao.queryByPage(hql.toString(), pageParams.getPage(), pageParams.getRows(), params);
|
for(QmProdManage manage:rows){
|
QmProdManageBean manageBean = BeanConvertor.copyProperties(manage, QmProdManageBean.class);
|
|
if(null!=manage.getMdMat()){//品名
|
manageBean.setProcId(manage.getMdMat().getId());
|
manageBean.setMdMatName(manage.getMdMat().getName());
|
}
|
if(null!=manage.getSysUserByAddUserid()){//新增人
|
manageBean.setAddUserId(manage.getSysUserByAddUserid().getId());
|
manageBean.setAddUserName(manage.getSysUserByAddUserid().getName());
|
}
|
if(null!=manage.getSysUserByReviewUserid()){//批准人
|
manageBean.setReviewUserId(manage.getSysUserByReviewUserid().getId());
|
manageBean.setReviewUserName(manage.getSysUserByReviewUserid().getName());
|
}
|
list.add(manageBean);
|
}
|
}
|
return new DataGrid(list, total);
|
} catch (Exception e) {
|
log.error("POVO转换异常", e);
|
}
|
return null;
|
}
|
/**
|
* 根据ID查询
|
*/
|
@Override
|
public DataGrid queryListById(String id,PageParams pageParams){
|
StringBuffer hql=new StringBuffer();
|
String prix=bundle.getString("service_url");
|
hql.append("from QmProdFile o ");//上传的文件集合
|
hql.append("left join fetch o.sysUserByCreateUserId su "); //上传人ID
|
hql.append("left join fetch o.qmProdManage pm "); //版本号
|
List<Object> params = new ArrayList<Object>();
|
hql.append("where o.isDeleted=0 and pm.id=? ");
|
params.add(id);
|
try {
|
List<QmProdFileBean> list= new ArrayList<QmProdFileBean>();
|
hql.append(" order by o.createTime desc ");//排序
|
List<QmProdFile> rows = qmProdFileDao.queryByPage(hql.toString(), pageParams.getPage(), pageParams.getRows(), params);
|
for(QmProdFile manage:rows){
|
QmProdFileBean manageBean = BeanConvertor.copyProperties(manage, QmProdFileBean.class);
|
manageBean.setFileId(prix+manageBean.getFileId());
|
if(null!=manage.getSysUserByCreateUserId()){
|
manageBean.setAddUserName(manage.getSysUserByCreateUserId().getName());
|
}
|
list.add(manageBean);
|
}
|
return new DataGrid(list, 0L);
|
} catch (Exception e) {
|
log.error("POVO转换异常", e);
|
}
|
return null;
|
}
|
|
@LogAnno(operateType = "添加产品规程")
|
@Override
|
public String addBean(QmProdManageBean bean) throws Exception {
|
QmProdManage addBean=BeanConvertor.copyProperties(bean, QmProdManage.class);
|
|
MdMat mdMat = new MdMat();
|
mdMat.setId(bean.getProcId());//mdMat 品名(牌号)
|
addBean.setMdMat(mdMat);
|
SysUser add = new SysUser();
|
add.setId(bean.getAddUserId());
|
addBean.setSysUserByAddUserid(add);//新增人ID
|
addBean.setSysUserByModifyUserid(add);//修改人ID
|
addBean.setCreateDatetime(new Date());
|
addBean.setModifyDatetime(new Date());
|
addBean.setId(UUID.randomUUID().toString());
|
addBean.setProdStatus("0");//审核状态
|
addBean.setProdVersion("1.0");//版本号
|
boolean flag = qmProdManageDao.save(addBean);
|
String serializableId ="";
|
if(flag){
|
serializableId = addBean.getId();
|
}
|
return serializableId;
|
}
|
@LogAnno(operateType = "编辑产品规程")
|
@Override
|
public void editBean(QmProdManageBean bean) throws Exception {
|
QmProdManage manageBean=qmProdManageDao.findById(QmProdManage.class, bean.getId());
|
BeanConvertor.copyProperties(bean, manageBean);//修改内容
|
SysUser add = new SysUser();
|
add.setId(bean.getModifyUserId());
|
manageBean.setSysUserByModifyUserid(add);//修改人
|
manageBean.setModifyDatetime(new Date());//修改时间
|
MdMat mdMat = new MdMat();
|
mdMat.setId(bean.getProcId());//mdMat 品名(牌号)
|
manageBean.setMdMat(mdMat);
|
if(null!=manageBean.getProdVersion()&&!"".equals(manageBean.getProdVersion())){//版本号
|
double vs = Double.parseDouble(manageBean.getProdVersion())+0.1;
|
DecimalFormat format = new DecimalFormat("#0.0"); //java.text包里面的DecimalFormat 类搜索
|
String buf = format.format(vs).toString();
|
manageBean.setProdVersion(buf);//版本号
|
}else{
|
manageBean.setProdVersion("1.0");
|
}
|
}
|
@Override
|
public void deleteBean(String id) throws Exception{
|
QmProdManage bean = qmProdManageDao.findById(QmProdManage.class,id);
|
bean.setProdStop("1");
|
}
|
@LogAnno(operateType = "批量删除产品规程")
|
@Override
|
public void batchDeleteByIds(String ids) throws Exception {
|
for (String id : StringUtil.splitToStringList(ids, ",")) {
|
this.deleteBean(id);
|
}
|
}
|
@LogAnno(operateType = "审核产品规程")
|
@Override
|
public void editReview(String ids,String status,HttpSession session){
|
SessionInfo sessionInfo = (SessionInfo) session.getAttribute("sessionInfo");
|
for (String id : StringUtil.splitToStringList(ids, ",")) {
|
QmProdManage bean = qmProdManageDao.findById(QmProdManage.class,id);
|
bean.setProdStatus(status);
|
bean.setModifyDatetime(new Date());
|
SysUser user = new SysUser();//用户
|
user.setId(sessionInfo.getUser().getId());
|
bean.setSysUserByModifyUserid(user);
|
bean.setReviewDatetime(new Date());
|
bean.setSysUserByReviewUserid(user);
|
}
|
}
|
@LogAnno(operateType = "下发产品规程")
|
@Override
|
public void editSend(String ids,String status,HttpSession session){
|
SessionInfo sessionInfo = (SessionInfo) session.getAttribute("sessionInfo");
|
for (String id : StringUtil.splitToStringList(ids, ",")) {
|
QmProdManage bean = qmProdManageDao.findById(QmProdManage.class,id);
|
bean.setProdStatus(status);
|
bean.setModifyDatetime(new Date());
|
SysUser user = new SysUser();//用户
|
user.setId(sessionInfo.getUser().getId());
|
bean.setSysUserByModifyUserid(user);
|
bean.setSendDatetime(new Date());
|
bean.setSysUserBySendUserid(user);
|
}
|
}
|
@LogAnno(operateType = "批量删除规程文档")
|
@Override
|
public void deleteFiles(String ids,HttpSession session){
|
SessionInfo sessionInfo = (SessionInfo) session.getAttribute("sessionInfo");
|
for (String id : StringUtil.splitToStringList(ids, ",")) {
|
QmProdFile bean = qmProdFileDao.findById(QmProdFile.class,id);
|
bean.setIsDeleted("1");
|
bean.setModifyTime(new Date());
|
SysUser user = new SysUser();//用户
|
user.setId(sessionInfo.getUser().getId());
|
bean.setSysUserByModifyUserId(user);
|
}
|
}
|
|
|
@Override
|
public void batchInsert(List<QmProdManageBean> users) throws Exception {
|
try {
|
qmProdManageDao.batchInsert(users,QmProdManageBean.class);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
|
@LogAnno(operateType = "产品规程文件上传")
|
@Override
|
public void fileUpdate(String prodManageId,HttpSession session, HttpServletRequest request,
|
QmProdFileBean fmBean) throws Exception {
|
request.setCharacterEncoding("utf-8");
|
SessionInfo sessionInfo = (SessionInfo) session.getAttribute("sessionInfo");
|
//获取文件名
|
String[] fileUrls = (String[])request.getParameterValues("fileUrl")[0].split(",");
|
String[] fileNames = (String[])request.getParameterValues("fileName")[0].split(",");
|
Long l = Long.valueOf(request.getParameter("securityLevel"));
|
String prodVersion =request.getParameter("prodVersion");
|
|
for (int i = 0; i < fileUrls.length; i++) {
|
QmProdFile file = new QmProdFile();
|
file.setProdVersion(prodVersion);//版本号
|
SysUser user = new SysUser();//新增用户
|
user.setId(sessionInfo.getUser().getId());
|
file.setSysUserByCreateUserId(user);
|
|
QmProdManage prod = new QmProdManage();
|
prod.setId(prodManageId);
|
file.setQmProdManage(prod);
|
|
file.setCreateTime(new Date());
|
file.setSecurityLevel(l);
|
|
file.setFileId(fileUrls[i]);
|
file.setFileName(fileNames[i]);
|
file.setFileType(fileUrls[i].substring(fileUrls[i].lastIndexOf(".")+1));
|
file.setIsDeleted("0");
|
file.setModifyTime(new Date());
|
SysUser addUser = new SysUser();//用户
|
addUser.setId(sessionInfo.getUser().getId());
|
file.setSysUserByModifyUserId(user);
|
qmProdFileDao.save(file);
|
//根据主键ID查询 并回写数据
|
QmProdManage findBean = qmProdManageDao.findById(QmProdManage.class,prodManageId);
|
findBean.setModifyDatetime(new Date());
|
findBean.setSysUserByModifyUserid(user);//修改人
|
findBean.setSysUserByUploadUserid(user);//上传人
|
//映射路径 供doc、txt等文档装pdf用
|
/*ResourceBundle bundle = ResourceBundle.getBundle("config");
|
String fileId = file.getFileId();
|
String suffix = fileId.substring(file.getFileId().lastIndexOf("."));
|
fileId = fileId.substring(fileId.lastIndexOf("/")+1);
|
fileId = fileId.substring(0,fileId.lastIndexOf("."));
|
String sourceFilePath = request.getServletContext().getRealPath(bundle.getString("upload"))+"\\"+fileId+suffix;
|
String pdfFilePath = request.getServletContext().getRealPath(bundle.getString("pdf"))+"\\"+fileId+".pdf";
|
String swfFilePath = request.getServletContext().getRealPath(bundle.getString("swf"))+"\\"+fileId+".swf";
|
|
//转成pdf转成swf
|
try{
|
FileConvertSwfUtil.fileConvert(sourceFilePath,pdfFilePath,swfFilePath);
|
}catch(Exception e){
|
log.error("QmProdManageServiceImpl->fileUpdate->fileConvert() is error:",e);
|
}*/
|
}
|
|
}
|
|
|
|
}
|
