package com.shlanbao.tzsc.pms.fileManage.moldingFile.service.impl;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.shlanbao.tzsc.base.dao.DocFileManageDaoI;
import com.shlanbao.tzsc.base.mapping.DocFilemanage;
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.model.SessionInfo;
import com.shlanbao.tzsc.base.service.BaseService;
import com.shlanbao.tzsc.pms.fileManage.moldingFile.beans.FileManageBean;
import com.shlanbao.tzsc.pms.fileManage.moldingFile.service.MoldingFileServiceI;
import com.shlanbao.tzsc.utils.tools.BeanConvertor;
import com.shlanbao.tzsc.utils.tools.StringUtil;
/**
 * 文件管理实现类
 * @author liuligong
 * @create 2014年9月21日上午9:12
 */
@Service
public class MoldingFileServiceImpl extends BaseService implements MoldingFileServiceI{
	@Autowired
	private DocFileManageDaoI docFileManageDao;
	
	@Override
	public void fileUpdate(HttpSession session,HttpServletRequest request,FileManageBean fmBean) throws Exception{
		request.setCharacterEncoding("utf-8");
		SessionInfo sessionInfo = (SessionInfo) session.getAttribute("sessionInfo");
		//DocFilemanage dfManage = BeanConvertor.copyProperties(fmBean, DocFilemanage.class);
	
		//获取文件名
		String[] fileUrls = (String[])request.getParameterValues("fileUrl")[0].split(",");
		String[] fileNames = (String[])request.getParameterValues("fileName")[0].split(",");
		
		Long L = Long.valueOf(request.getParameter("securityLevel"));
		
		for (int i = 0; i < fileUrls.length; i++) {
			DocFilemanage dfManage = new DocFilemanage();
			dfManage.setCreateName(sessionInfo.getUser().getName());
			dfManage.setCreatePersonId(sessionInfo.getUser().getId());
			dfManage.setCreateTime(new java.util.Date());
			dfManage.setSecurityLevel(L);

			dfManage.setFileId(fileUrls[i]);
			dfManage.setFileName(fileNames[i].substring(0,fileNames[i].lastIndexOf(".")));
			dfManage.setFileType(fileUrls[i].substring(fileUrls[i].lastIndexOf(".")+1));
			dfManage.setIsDeleted("0");
			docFileManageDao.save(dfManage);
		}
		
	}

	@Override
	public DataGrid queryFile(Long securityLevel,FileManageBean fmBean, PageParams pageParams) {
		//sql 语句拼装
		StringBuffer strBuffer = new StringBuffer();
		strBuffer.append("from DocFilemanage o where 1=1 and o.isDeleted='0' and o.securityLevel = ");
		strBuffer.append(securityLevel);
		String hql =strBuffer.toString();
		String params="";
		if(StringUtil.notNull(fmBean.getFileName())){
			params +=" and o.fileName like '%"+fmBean.getFileName()+"%'";
		}
		//执行查询 
		List rows = docFileManageDao.queryByPage(hql.concat(params), pageParams);
		
		strBuffer = new StringBuffer();
		strBuffer.append("select count(*) from DocFilemanage o where 1=1 and o.isDeleted='0' and o.securityLevel = ");
		strBuffer.append(securityLevel);
		hql = strBuffer.toString();
		
		try {
			rows = BeanConvertor.copyList(rows, FileManageBean.class);
			long total = docFileManageDao.queryTotal(hql.concat(params));
			hql = null;
			params = null;
			strBuffer = null;
			return new DataGrid(rows, total);
		} catch (Exception e) {
			log.error("POVO转换异常", e);
		}
		return null;
	}

	@Override
	public void delFile(String id) throws Exception {
		docFileManageDao.findById(DocFilemanage.class, id).setIsDeleted("1");
	}
}