package cn.com.lzt.projarrangegeneral.service.impl;
import cn.com.lzt.projarrangedetail.entity.ProjarrangeDetailEntity;
import cn.com.lzt.projarrangegeneral.dao.ProjArrangeGeneralMinidao;
import cn.com.lzt.projarrangegeneral.dto.ProjArrangeGeneralDto;
import cn.com.lzt.projarrangegeneral.entity.ProjArrangeGeneralEntity;
import cn.com.lzt.projarrangegeneral.service.ProjArrangeGeneralServiceI;
import org.jeecgframework.core.common.service.impl.CommonServiceImpl;
import org.jeecgframework.core.util.ApplicationContextUtil;
import org.jeecgframework.core.util.MyBeanUtils;
import org.jeecgframework.core.util.MyClassLoader;
import org.jeecgframework.core.util.StringUtil;
import org.jeecgframework.minidao.pojo.MiniDaoPage;
import org.jeecgframework.web.cgform.enhance.CgformEnhanceJavaInter;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.io.Serializable;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.UUID;

@Service("projArrangeGeneralService")
@Transactional
public class ProjArrangeGeneralServiceImpl extends CommonServiceImpl implements ProjArrangeGeneralServiceI {
	
	@Autowired
	ProjArrangeGeneralMinidao projArrangeGeneralMinidao;

	
 	public void delete(ProjArrangeGeneralEntity entity) throws Exception{
 		super.delete(entity);
 		//执行删除操作增强业务
		this.doDelBus(entity);
 	}
 	
 	public Serializable save(ProjArrangeGeneralEntity entity) throws Exception{
 		Serializable t = super.save(entity);
 		//执行新增操作增强业务
 		this.doAddBus(entity);
 		return t;
 	}
 	
 	public void saveOrUpdate(ProjArrangeGeneralEntity entity) throws Exception{
 		super.saveOrUpdate(entity);
 		//执行更新操作增强业务
 		this.doUpdateBus(entity);
 	}
 	
 	/**
	 * 新增操作增强业务
	 * @param t
	 * @return
	 */
	private void doAddBus(ProjArrangeGeneralEntity t) throws Exception{
		//-----------------sql增强 start----------------------------
	 	//-----------------sql增强 end------------------------------
	 	
	 	//-----------------java增强 start---------------------------
	 	//-----------------java增强 end-----------------------------
 	}
 	/**
	 * 更新操作增强业务
	 * @param t
	 * @return
	 */
	private void doUpdateBus(ProjArrangeGeneralEntity t) throws Exception{
		//-----------------sql增强 start----------------------------
	 	//-----------------sql增强 end------------------------------
	 	
	 	//-----------------java增强 start---------------------------
	 	//-----------------java增强 end-----------------------------
 	}
 	/**
	 * 删除操作增强业务
	 * @param id
	 * @return
	 */
	private void doDelBus(ProjArrangeGeneralEntity t) throws Exception{
	    //-----------------sql增强 start----------------------------
	 	//-----------------sql增强 end------------------------------
	 	
	 	//-----------------java增强 start---------------------------
	 	//-----------------java增强 end-----------------------------
 	}
 	
 	private Map<String,Object> populationMap(ProjArrangeGeneralEntity t){
		Map<String,Object> map = new HashMap<String,Object>();
		map.put("id", t.getId());
		map.put("yearmonth", t.getYearmonth());
		map.put("belong_unitid", t.getBelongUnitid());
		map.put("people_quantity", t.getPeopleQuantity());
		map.put("arrange_duty_status", t.getArrangeDutyStatus());
		map.put("reporter_id", t.getReporterId());
		map.put("create_name", t.getCreateName());
		map.put("create_by", t.getCreateBy());
		map.put("create_date", t.getCreateDate());
		map.put("update_name", t.getUpdateName());
		map.put("update_by", t.getUpdateBy());
		map.put("update_date", t.getUpdateDate());
		map.put("sys_org_code", t.getSysOrgCode());
		map.put("sys_company_code", t.getSysCompanyCode());
		return map;
	}
 	
 	/**
	 * 替换sql中的变量
	 * @param sql
	 * @param t
	 * @return
	 */
 	public String replaceVal(String sql,ProjArrangeGeneralEntity t){
 		sql  = sql.replace("#{id}",String.valueOf(t.getId()));
 		sql  = sql.replace("#{yearmonth}",String.valueOf(t.getYearmonth()));
 		sql  = sql.replace("#{belong_unitid}",String.valueOf(t.getBelongUnitid()));
 		sql  = sql.replace("#{people_quantity}",String.valueOf(t.getPeopleQuantity()));
 		sql  = sql.replace("#{arrange_duty_status}",String.valueOf(t.getArrangeDutyStatus()));
 		sql  = sql.replace("#{reporter_id}",String.valueOf(t.getReporterId()));
 		sql  = sql.replace("#{create_name}",String.valueOf(t.getCreateName()));
 		sql  = sql.replace("#{create_by}",String.valueOf(t.getCreateBy()));
 		sql  = sql.replace("#{create_date}",String.valueOf(t.getCreateDate()));
 		sql  = sql.replace("#{update_name}",String.valueOf(t.getUpdateName()));
 		sql  = sql.replace("#{update_by}",String.valueOf(t.getUpdateBy()));
 		sql  = sql.replace("#{update_date}",String.valueOf(t.getUpdateDate()));
 		sql  = sql.replace("#{sys_org_code}",String.valueOf(t.getSysOrgCode()));
 		sql  = sql.replace("#{sys_company_code}",String.valueOf(t.getSysCompanyCode()));
 		sql  = sql.replace("#{UUID}",UUID.randomUUID().toString());
 		return sql;
 	}
 	
 	/**
	 * 执行JAVA增强
	 */
 	private void executeJavaExtend(String cgJavaType,String cgJavaValue,Map<String,Object> data) throws Exception {
 		if(StringUtil.isNotEmpty(cgJavaValue)){
			Object obj = null;
			try {
				if("class".equals(cgJavaType)){
					//因新增时已经校验了实例化是否可以成功，所以这块就不需要再做一次判断
					obj = MyClassLoader.getClassByScn(cgJavaValue).newInstance();
				}else if("spring".equals(cgJavaType)){
					obj = ApplicationContextUtil.getContext().getBean(cgJavaValue);
				}
				if(obj instanceof CgformEnhanceJavaInter){
					CgformEnhanceJavaInter javaInter = (CgformEnhanceJavaInter) obj;
					javaInter.execute("t_bus_projarrange_general",data);
				}
			} catch (Exception e) {
				e.printStackTrace();
				throw new Exception("执行JAVA增强出现异常！");
			} 
		}
 	}

	@Override
	public MiniDaoPage<ProjArrangeGeneralDto> getProjArrangeGeneralDtoPage(
			ProjArrangeGeneralDto projArrangeGeneralDto, int page, int rows,
			String authSql)  throws Exception{
		
		MiniDaoPage<ProjArrangeGeneralDto> projArrangeGeneralDtoList = this.projArrangeGeneralMinidao.getProjArrangeGeneralDtoPage(projArrangeGeneralDto, page, rows, authSql);
		
		for (int i = 0; i < projArrangeGeneralDtoList.getResults().size(); i++) {
			
			ProjArrangeGeneralEntity t = this.get(ProjArrangeGeneralEntity.class, projArrangeGeneralDtoList.getResults().get(i).getId());
			ProjArrangeGeneralEntity projArrangeGeneralEntity=t;
			//查询项目排班详细表数据计算排班人数
			StringBuffer hql = new StringBuffer(" FROM ProjarrangeDetailEntity where pid=? and yearmonth=? ");
			List<ProjarrangeDetailEntity> projarrangeDetailEntityList = this.findHql(hql.toString(),projArrangeGeneralEntity.getBelongUnitid(),projArrangeGeneralEntity.getYearmonth());
			projArrangeGeneralEntity.setPeopleQuantity(projarrangeDetailEntityList.size());
			MyBeanUtils.copyBeanNotNull2Bean(projArrangeGeneralEntity, t);
			this.saveOrUpdate(t);
			projArrangeGeneralDtoList.getResults().get(i).setPeopleQuantity(projArrangeGeneralEntity.getPeopleQuantity());
		}
		
		return projArrangeGeneralDtoList;
	}

	@Override
	public List<ProjArrangeGeneralDto> getProjArrangeGeneralDtoExport(
			ProjArrangeGeneralDto projArrangeGeneralDto, String authSql)  throws Exception{
		// TODO Auto-generated method stub
		return projArrangeGeneralMinidao.getProjArrangeGeneralDtoExport(projArrangeGeneralDto, authSql);
	}
}