package cn.com.lzt.contractsale.service.impl;
import cn.com.lzt.contractsale.entity.ContractSaleEntity;
import cn.com.lzt.contractsale.service.ContractSaleServiceI;
import cn.com.lzt.contractsaleitem.entity.ContractSaleItemEntity;
import org.jeecgframework.core.common.exception.BusinessException;
import org.jeecgframework.core.common.service.impl.CommonServiceImpl;
import org.jeecgframework.core.constant.Globals;
import org.jeecgframework.core.util.DateUtils;
import org.jeecgframework.core.util.MyBeanUtils;
import org.jeecgframework.core.util.StringUtil;
import org.jeecgframework.core.util.oConvertUtils;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import java.util.Date;
import java.util.List;
import java.util.UUID;


@Service("contractSaleService")
@Transactional
public class ContractSaleServiceImpl extends CommonServiceImpl implements ContractSaleServiceI {
	
 	public <T> void delete(T entity) {
 		super.delete(entity);
 		//执行删除操作配置的sql增强
		this.doDelSql((ContractSaleEntity)entity);
 	}
	
	public void addMain(ContractSaleEntity contractSale,
	        List<ContractSaleItemEntity> contractSaleItemList){
			//保存主信息
			this.save(contractSale);
		
			/**保存-服务明细*/
			for(ContractSaleItemEntity contractSaleItem:contractSaleItemList){
				//外键设置
				contractSaleItem.setContractid(contractSale.getId());
				this.save(contractSaleItem);
			}
			//执行新增操作配置的sql增强
 			this.doAddSql(contractSale);
	}

	
	public void updateMain(ContractSaleEntity contractSale,
	        List<ContractSaleItemEntity> contractSaleItemList) {
		//保存主表信息
		if(StringUtil.isNotEmpty(contractSale.getId())){
			try {
				ContractSaleEntity temp = findUniqueByProperty(ContractSaleEntity.class, "id", contractSale.getId());
				MyBeanUtils.copyBeanNotNull2Bean(contractSale, temp);
				this.saveOrUpdate(temp);
			} catch (Exception e) {
				e.printStackTrace();
			}
		}else{
			this.saveOrUpdate(contractSale);
		}
		//===================================================================================
		//获取参数
		Object id0 = contractSale.getId();
		//===================================================================================
		//1.查询出数据库的明细数据-服务明细
	    String hql0 = "from ContractSaleItemEntity where 1 = 1 AND cONTRACTID =? ";
	    List<ContractSaleItemEntity> contractSaleItemOldList = this.findHql(hql0,id0);
		//2.筛选更新明细数据-服务明细
		if(contractSaleItemList!=null&&contractSaleItemList.size()>0){
		for(ContractSaleItemEntity oldE:contractSaleItemOldList){
			boolean isUpdate = false;
				for(ContractSaleItemEntity sendE:contractSaleItemList){
					//需要更新的明细数据-服务明细
					if(oldE.getId().equals(sendE.getId())){
		    			try {
							MyBeanUtils.copyBeanNotNull2Bean(sendE,oldE);
							this.saveOrUpdate(oldE);
						} catch (Exception e) {
							e.printStackTrace();
							throw new BusinessException(e.getMessage());
						}
						isUpdate= true;
		    			break;
		    		}
		    	}
	    		if(!isUpdate){
		    		//如果数据库存在的明细，前台没有传递过来则是删除-服务明细
		    		super.delete(oldE);
	    		}
	    		
			}
			//3.持久化新增的数据-服务明细
			for(ContractSaleItemEntity contractSaleItem:contractSaleItemList){
				if(oConvertUtils.isEmpty(contractSaleItem.getId())){
					//外键设置
					contractSaleItem.setContractid(contractSale.getId());
					this.save(contractSaleItem);
				}
			}
		}
		//执行更新操作配置的sql增强
 		this.doUpdateSql(contractSale);
	}

	
	public void delMain(ContractSaleEntity contractSale) {
		//删除主表信息
		this.delete(contractSale);
		//===================================================================================
		//获取参数
		Object id0 = contractSale.getId();
		//===================================================================================
		//删除-服务明细
	    String hql0 = "from ContractSaleItemEntity where 1 = 1 AND cONTRACTID =? ";
	    List<ContractSaleItemEntity> contractSaleItemOldList = this.findHql(hql0,id0);
		this.deleteAllEntitie(contractSaleItemOldList);
	}
	
 	
 	/**
	 * 默认按钮-sql增强-新增操作
	 * @param id
	 * @return
	 */
 	public boolean doAddSql(ContractSaleEntity t){
	 	return true;
 	}
 	/**
	 * 默认按钮-sql增强-更新操作
	 * @param id
	 * @return
	 */
 	public boolean doUpdateSql(ContractSaleEntity t){
	 	return true;
 	}
 	/**
	 * 默认按钮-sql增强-删除操作
	 * @param id
	 * @return
	 */
 	public boolean doDelSql(ContractSaleEntity t){
	 	return true;
 	}
 	
 	/**
	 * 替换sql中的变量
	 * @param sql
	 * @return
	 */
 	public String replaceVal(String sql,ContractSaleEntity t){
 		sql  = sql.replace("#{id}",String.valueOf(t.getId()));
 		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("#{bpm_status}",String.valueOf(t.getBpmStatus()));
 		sql  = sql.replace("#{code}",String.valueOf(t.getCode()));
 		sql  = sql.replace("#{name}",String.valueOf(t.getName()));
 		sql  = sql.replace("#{type}",String.valueOf(t.getType()));
 		sql  = sql.replace("#{signdate}",String.valueOf(t.getSigndate()));
 		sql  = sql.replace("#{nextbiddingdate}",String.valueOf(t.getNextbiddingdate()));
 		sql  = sql.replace("#{startdate}",String.valueOf(t.getStartdate()));
 		sql  = sql.replace("#{enddate}",String.valueOf(t.getEnddate()));
 		sql  = sql.replace("#{totalamount}",String.valueOf(t.getTotalamount()));
 		sql  = sql.replace("#{totalinvoice}",String.valueOf(t.getTotalinvoice()));
 		sql  = sql.replace("#{totalincome}",String.valueOf(t.getTotalincome()));
 		sql  = sql.replace("#{servicecontent}",String.valueOf(t.getServicecontent()));
 		sql  = sql.replace("#{auditdate}",String.valueOf(t.getAuditdate()));
 		sql  = sql.replace("#{busstatus}",String.valueOf(t.getBusstatus()));
 		sql  = sql.replace("#{customerid}",String.valueOf(t.getCustomerid()));
 		sql  = sql.replace("#{customername}",String.valueOf(t.getCustomername()));
 		sql  = sql.replace("#{projectid}",String.valueOf(t.getProjectid()));
 		sql  = sql.replace("#{projectname}",String.valueOf(t.getProjectname()));
 		sql  = sql.replace("#{paytype}",String.valueOf(t.getPaytype()));
 		sql  = sql.replace("#{description}",String.valueOf(t.getDescription()));
 		sql  = sql.replace("#{proc_inst_id}",String.valueOf(t.getProcInstId()));
 		sql  = sql.replace("#{step_name}",String.valueOf(t.getStepName()));
 		sql  = sql.replace("#{supplemental}",String.valueOf(t.getSupplemental()));
 		sql  = sql.replace("#{contractid}",String.valueOf(t.getContractid()));
 		sql  = sql.replace("#{addamount}",String.valueOf(t.getAddamount()));
 		sql  = sql.replace("#{UUID}",UUID.randomUUID().toString());
 		return sql;
 	}
 	@Override
	public void doActive() {
		String doActiveSQL = "update t_b_contract_sale set busstatus =? where left(startdate,10) <=? and busstatus = ? ";
		executeSql(doActiveSQL, Globals.CONTRACT_STATUS_ACTIVE,DateUtils.date_sdf.format(new Date()),Globals.CONTRACT_STATUS_SIGN);
		String doUnActiveSQL = "update t_b_contract_sale set busstatus = '8'  where id in( select id from (\n" + 
				" select sale.id from t_b_contract_sale sale \n" + 
				" left join ( \n" + 
				" select max(create_date) as create_date,contractid  from t_b_contract_sale addi group by contractid) tmp on tmp.contractid = sale.id \n" + 
				" left join  t_b_contract_sale additional  on additional.create_date = tmp.create_date and additional.contractid = tmp.contractid \n" + 
				" where ((additional.enddate is null and left(sale.enddate,10) <= ?) or left(additional.enddate,10) <= ?)"
				+ " and sale.busstatus = '2' and sale.type = '3') temp)";
		//刷新补充协议的状态
		String updateAdditionalSQL = "update t_b_contract_sale addi \n" + 
				"left join t_b_contract_sale sale on sale.id = addi.contractid \n" + 
				"set addi.busstatus = sale.busstatus \n" + 
				"where addi.busstatus != sale.busstatus and addi.type = '4'";
		executeSql(doUnActiveSQL, DateUtils.date_sdf.format(new Date()),DateUtils.date_sdf.format(new Date()));
		executeSql(updateAdditionalSQL);
	}
}