package com.vci.server.portal.service;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.List;

import com.vci.server.base.persistence.dao.BaseService;
import com.vci.server.portal.dao.impl.PLActionClsEntityDaoImp;
import com.vci.server.portal.dao.impl.PLActionEntityDaoImpl;
import com.vci.server.portal.dao.impl.PLActionParamEntityDaoImp;
import com.vci.server.portal.entity.PLActionClsEntity;
import com.vci.server.portal.entity.PLActionEntity;
import com.vci.server.portal.entity.PLActionParamEntity;
import com.vci.common.utility.ObjectUtility;
import com.vci.corba.portal.data.Constraint;

public class PLActionEntityService extends BaseService{
	private static PLActionEntityService instance = null;
	private DateFormat dFormat = new SimpleDateFormat("yyyy-MM-dd");
	
	private PLActionEntityService(){
		
	}
	
	public static PLActionEntityService getInstance(){
		if(instance == null){
			instance = new PLActionEntityService();
		}
		return instance;
	}
	/**
	 * 新增action对象
	 * @param obj
	 * @throws Throwable 
	 */
	public boolean savePLActionEntity(PLActionEntity obj) throws Throwable {

		try {
			PLActionEntityDaoImpl daoImpl = new PLActionEntityDaoImpl();
			daoImpl.saveOrUpdate(obj);
			return true;
		} catch(Throwable e){
			throw e;
		}
	}
	
	/**
	 * 更新action对象
	 * @param obj
	 * @return
	 * @throws Throwable 
	 */
	public boolean updatePLActionEntity(PLActionEntity obj) throws Throwable{
		try {
			PLActionEntityDaoImpl daoImpl = new PLActionEntityDaoImpl();
			PLActionEntity objGet = daoImpl.getById(obj.getId());
			if (objGet == null) {
				daoImpl.saveOrUpdate(obj);
			} else {
				// objGet.setId(obj.getId());
				objGet.setPlCode(obj.getPlCode());
				objGet.setPlName(obj.getPlName());
				objGet.setPlBSUrl(obj.getPlBSUrl());
				objGet.setPlCSClass(obj.getPlCSClass());
				objGet.setPlDesc(obj.getPlDesc());
				objGet.setPlTypeType(obj.getPlTypeType());
//				objGet.setPlCreateTime(obj.getPlCreateTime());
				objGet.setPlCreateUser(obj.getPlCreateUser());
				objGet.setPlModifyTime(obj.getPlModifyTime());
				objGet.setPlModifyUser(obj.getPlModifyUser());
				objGet.setPlLicensOrs(obj.getPlLicensOrs());
				objGet.setPlActionCls(obj.getPlActionCls());
				daoImpl.saveOrUpdate(objGet);
			}
			return true;
		} catch(Throwable e){
			throw e;
		}
		
	}
	
	/**
	 * 删除action对象
	 * @param obj
	 * @return
	 * @throws Throwable 
	 */
	public boolean deletePLActionEntity(PLActionEntity obj) throws Throwable{
		try {
			PLActionEntityDaoImpl daoImpl = new PLActionEntityDaoImpl();
			daoImpl.delete(obj);
			return true;
		} catch(Throwable e){
			throw e;
		}
		
	}

	/**
	 * 根据Id删除指定的action对象 
	 * @param id
	 * @return
	 * @throws Throwable 
	 */
	public boolean deletePLActionEntityById(String id) throws Throwable{
		try {
			PLActionEntityDaoImpl daoImpl = new PLActionEntityDaoImpl();
			PLActionEntity obj = daoImpl.getById(id);
			if (obj != null) {
				daoImpl.delete(obj);
			}
			return true;
		} catch(Throwable e){
			throw e;
		}
		
	}

	/**
	 * 根据ID获取指定的PLAction
	 * @param plOId
	 * @return
	 * @throws Throwable 
	 */
	public PLActionEntity getPLActionEntityById(String plOId) throws Throwable {
		try {
			PLActionEntityDaoImpl daoImpl = new PLActionEntityDaoImpl();
			return daoImpl.getById(plOId);
		} catch(Throwable e){
			throw e;
		}
		
	}
	
	/**
	 * 获取所有PLAction
	 * @return
	 * @throws Throwable 
	 */
	public List<PLActionEntity> getAllPLActionEntity() throws Throwable{
		try {
			PLActionEntityDaoImpl daoImpl = new PLActionEntityDaoImpl();
			StringBuilder sql = new StringBuilder("select * from PLAction p order by plCode");
			List<PLActionEntity> loadAll = daoImpl.findEntites(sql.toString(), new Object[0], "", PLActionEntity.class);
			return loadAll;
		} catch(Throwable e){
			throw e;
		}
		
	}

	/**
	 * 根据约束条件组查询数组, 查询PLActions
	 * @throws Throwable 
	 */
	public List<PLActionEntity> getPLActionEntitysByConsMap(Constraint[] consArray) throws Throwable {
		try {
			PLActionEntityDaoImpl daoImpl = new PLActionEntityDaoImpl();
			StringBuilder sql = new StringBuilder("select * from PLAction p where 1 = 1 ");
			for(int i = 0; i < consArray.length; i++){
				Constraint cons = consArray[i];
				if(cons.value == null || cons.value.equals("")){
					if(!cons.key.equalsIgnoreCase("plactioncls")) {
						continue;
					}
				}
				
				if(cons.key.equalsIgnoreCase("plCreateTime") || cons.key.equalsIgnoreCase("plModifyTime")){
					sql.append(" and p.");
					sql.append(cons.key + " = ");
					sql.append(dFormat.parse(cons.value));
				} else if (cons.key.equalsIgnoreCase("plactioncls") && cons.value.equals("")) {
					sql.append(" and (p.");
					sql.append(cons.key + " is null or p." + cons.key + "= '') ");
				} else {
					sql.append(" and p.");
					sql.append(cons.key + " like ");
					sql.append("'%" + cons.value + "%'");
				}
				
			}
			List<PLActionEntity> list = daoImpl.findEntites(sql.toString(), new Object[0], "", PLActionEntity.class);
			return list;
		} catch(Throwable e){
			e.printStackTrace();
			throw e;
		}
	}
	
	/**
	 * 查询所有分类
	 * @return
	 */
	public List<PLActionClsEntity> getAllActionCls() {
		PLActionClsEntityDaoImp daoImpl = new PLActionClsEntityDaoImp();
		return daoImpl.loadAll();
	}
	
	/**
	 * 创建分类
	 * @param entity
	 * @return
	 */
	public synchronized String createPLActionCls(PLActionClsEntity entity) {
		try {
			PLActionClsEntityDaoImp daoImpl = new PLActionClsEntityDaoImp();
			//判断分类id是否正确 Add By ZhongGY 2015-06-12
			if (entity.getOid().trim().equals("")) {
				entity.setOid(ObjectUtility.getNewObjectID36());
			}else {
				List<PLActionClsEntity> loadAll = daoImpl.findEntites(
						"select * from plactioncls t where t.oid = '" + entity.getOid() + "'",
						new Object[0], "", PLActionClsEntity.class);
				if(loadAll != null && !loadAll.isEmpty()) {
					//entity.setOid(ObjectUtility.getNewObjectID36());
					return "00";
				}
			}
			//判断分类能否创建
			List<PLActionClsEntity> loadAll = daoImpl.findEntites(
					"select * from plactioncls t where t.name = '" + entity.getName() + "'",
					new Object[0], "", PLActionClsEntity.class);
			if(loadAll != null && !loadAll.isEmpty()) {
				return "01";
			}
			//判断同级分类下是否存在相同的编号
			String condition = "";
			if(entity.getPid().equals("")) {
				condition = " or t.pid is null";
			}
			List<PLActionClsEntity> queryList = daoImpl.findEntites(
					"select * from plactioncls t where (t.pid = '" + entity.getPid() 
					+ "' " + condition + ") and t.serialno = " + entity.getSerialNo(),
					new Object[0], "", PLActionClsEntity.class);
			if(queryList != null && !queryList.isEmpty()) {
				return "02";
			}
			//保存分类
			daoImpl.save(entity);
		} catch (Exception e) {
			e.printStackTrace();
			return "0" + e.getMessage();
		}
		return "1";
	}
	
	/**
	 * 修改分类
	 * @param entity
	 * @return
	 */
	public synchronized String editPLActionCls(PLActionClsEntity entity) {
		try {
			PLActionClsEntityDaoImp daoImpl = new PLActionClsEntityDaoImp();
			//判断分类id是否正确 Add By ZhongGY 2015-06-12
			if (entity.getOid().trim().equals("")) {
				//entity.setOid(ObjectUtility.getNewObjectID36());
				return "001";	//修改保存分类对象id不能为空,修改保存失败！
			}else {
				List<PLActionClsEntity> loadAll = daoImpl.findEntites(
						"select * from plactioncls t where t.oid = '" + entity.getOid() + "'",
						new Object[0], "", PLActionClsEntity.class);
				if(loadAll == null || loadAll.isEmpty()) {
					//entity.setOid(ObjectUtility.getNewObjectID36());
					return "002";//修改保存分类对象id不存在,修改保存失败！
				}
			}
			//判断分类能否创建
			List<PLActionClsEntity> loadAll = daoImpl.findEntites(
					"select * from plactioncls t where t.name = '" + entity.getName()
					+ "' and t.oid != '" + entity.getOid() + "'",
					new Object[0], "", PLActionClsEntity.class);
			if(loadAll != null && !loadAll.isEmpty()) {
				return "01";
			}
			//判断同级分类下是否存在相同的编号
			String condition = "";
			if(entity.getPid().equals("")) {
				condition = " or t.pid is null";
			}
			List<PLActionClsEntity> queryList = daoImpl.findEntites(
					"select * from plactioncls t where (t.pid = '" + entity.getPid() 
					+ "' " + condition + ") and t.serialno = " + entity.getSerialNo()
					+ " and t.oid != '" + entity.getOid() + "'",
					new Object[0], "", PLActionClsEntity.class);
			if(queryList != null && !queryList.isEmpty()) {
				return "02";
			}
			//保存分类
			//entity.setOid(ObjectUtility.getNewObjectID36());
			daoImpl.merge(entity);
		} catch (Exception e) {
			e.printStackTrace();
			return "0" + e.getMessage();
		}
		return "1";
	}
	
	/**
	 * 删除分类
	 * @param id
	 * @return
	 */
	public synchronized String deletePLActionCls(String id) {
		try {
			PLActionClsEntityDaoImp daoImpl = new PLActionClsEntityDaoImp();
			daoImpl.deleteByKey(id);
			//更新所有Action分类为"";
			PLActionEntityDaoImpl actionDao = new PLActionEntityDaoImpl();
			String sql = "update plaction t set t.plactioncls = null where t.plactioncls = '" + id + "'";
			actionDao.createSQLQuery(sql);
		} catch (Exception e) {
			e.printStackTrace();
			return "0" + e.getMessage();
		}
		return "1";
	}
	
	/**
	 * 查询Action参数配置信息
	 * @return
	 */
	public List<PLActionParamEntity> getActionParamsById(String actionId) {
		PLActionParamEntityDaoImp daoImpl = new PLActionParamEntityDaoImp();
		return daoImpl.loadByActionId(actionId);
	}
	
	public List<PLActionParamEntity> getActionParams() {
		PLActionParamEntityDaoImp daoImpl = new PLActionParamEntityDaoImp();
		return daoImpl.loadAll();
	}
	
	/**
	 * 创建Action参数
	 * @param entity
	 * @return
	 */
	public synchronized String createPLActionParam(PLActionParamEntity entity) {
		try {
			PLActionParamEntityDaoImp daoImpl = new PLActionParamEntityDaoImp();
			//判断分类能否创建
			List<PLActionParamEntity> loadAll = daoImpl.findEntites(
					"select * from plactionparam t where t.name = '" + entity.getName() 
					+ "' and t.action = '" + entity.getAction() + "'",
					new Object[0], "", PLActionParamEntity.class);
			if(loadAll != null && !loadAll.isEmpty()) {
				return "01";
			}
			//保存分类
			entity.setOid(ObjectUtility.getNewObjectID36());
			daoImpl.save(entity);
		} catch (Exception e) {
			e.printStackTrace();
			return "0" + e.getMessage();
		}
		return "1";
	}
	
	/**
	 * 修改Action参数
	 * @param entity
	 * @return
	 */
	public synchronized String editPLActionParam(PLActionParamEntity entity) {
		try {
			PLActionParamEntityDaoImp daoImpl = new PLActionParamEntityDaoImp();
			//判断分类能否创建
			List<PLActionParamEntity> loadAll = daoImpl.findEntites(
					"select * from plactionparam t where t.name = '" + entity.getName()
					+ "' and t.oid != '" + entity.getOid() + "' and t.action = '" + entity.getAction() + "'",
					new Object[0], "", PLActionClsEntity.class);
			if(loadAll != null && !loadAll.isEmpty()) {
				return "01";
			}
			//保存分类
			daoImpl.update(entity);
		} catch (Exception e) {
			e.printStackTrace();
			return "0" + e.getMessage();
		}
		return "1";
	}
	
	/**
	 * 删除Action参数
	 * @param id
	 * @return
	 */
	public synchronized String deletePLActionParam(String id) {
		try {
			PLActionParamEntityDaoImp daoImpl = new PLActionParamEntityDaoImp();
			daoImpl.deleteByKey(id);
		} catch (Exception e) {
			e.printStackTrace();
			return "0" + e.getMessage();
		}
		return "1";
	}

	public PLActionClsEntity getPLActionCls(String objId) throws Throwable{
		try {
			PLActionClsEntityDaoImp actionClsEntityDaoImp = new PLActionClsEntityDaoImp();
			return actionClsEntityDaoImp.getById(objId);
		} catch (Throwable e) {
			throw e;
		}
	}

	public PLActionParamEntity getPLActionParam(String objId) throws Throwable{
		try {
			PLActionParamEntityDaoImp plActionParamEntityDaoImp = new PLActionParamEntityDaoImp();
			return plActionParamEntityDaoImp.getById(objId);
		} catch (Throwable e) {
			throw e;
		}
	}
}