package cn.ksource.web.facade.linkcate;

import java.util.HashMap;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.apache.commons.lang.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.ksource.beans.CMS_LINK_CATEGORY;
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.page.PageInfo;
import cn.ksource.core.util.AjaxUtil;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.JsonUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.web.Constants;

@Service("linkCateFacade")
public class LinkCateFacadeImpl implements LinkCateFacade {
	
	@Autowired
	private BaseDao baseDao;

	@Override
	public int checkName(HttpServletRequest request) {
		String id = request.getParameter("id");
		Map map=new HashMap();
        String up_id=null;
        if(!"".equals(id)){
             String sql="select * from CMS_LINK_CATEGORY where ID="+Integer.parseInt(id);
     		map=baseDao.queryForMap(sql);
     		//获取上一级ID
    		if(map!=null){
    			up_id=map.get("ID").toString();
    		}
        }
        String name = request.getParameter("category_name");
        if(name!=null&&!"".equals(name)){
        	name = AjaxUtil.decode(name).trim();
        }
        
        StringBuilder t_sql = new StringBuilder();
		t_sql.append("select count(*) from CMS_LINK_CATEGORY where CATEGORY_NAME='").append(name).append("' ");
    	if (StringUtils.isNotBlank(id)) {
    		
            t_sql.append(" and ID <> ").append(Integer.parseInt(id)).append(" ");
        }
    	if (StringUtils.isNotBlank(up_id)) {
            t_sql.append(" and UP_ID <> ").append(Integer.parseInt(up_id)).append(" ");
        }
    	int count=baseDao.queryForInteger(t_sql.toString());
    	return count;
	}

	@Override
	public PageInfo queryLinkcateData(PageInfo pageInfo,String pId) {
		StringBuilder builder = new StringBuilder("SELECT * FROM CMS_LINK_CATEGORY  WHERE 1 = 1 ");
		Map paramMap = new HashMap();
		if(StringUtil.notEmpty(pId)) {
			builder.append(" AND UP_ID = :pId ");
			paramMap.put("pId", pId);
		} else {
			builder.append(" AND LEVEL = 1 ");
		}
		
		builder.append(" ORDER BY LEVEL,ORDERNUM ");
		
		PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, builder.toString(), paramMap);
		
		return info;
	}

	@Override
	public int queryLinkcateCount(String pId) {
		StringBuilder builder = new StringBuilder("SELECT COUNT(ID) FROM CMS_LINK_CATEGORY  WHERE 1 = 1 ");
		Map paramMap = new HashMap();
		if(StringUtil.notEmpty(pId)) {
			builder.append(" AND UP_ID = :pId ");
			paramMap.put("pId", pId);
		} else {
			builder.append(" AND LEVEL = 1 ");
		}
		
		int count = baseDao.queryForInteger(builder.toString(),paramMap);
		
		return count;
	}

	@Override
	public List<Map> queryLinkcateTree(HttpServletRequest request) {
		Map paramMap = new HashMap();
		String selectSubSql = "SELECT * FROM CMS_LINK_CATEGORY  ORDER BY LEVEL,ORDERNUM ";
		List<Map> cates = baseDao.queryForList(selectSubSql,paramMap);
        Map result = new HashMap();
		
		List<Map> resultList = new LinkedList<Map>();
		
		Map<String, Map> yjgnCache = new HashMap<String, Map>();
		Map<String, Map> ejgnCache = new HashMap<String, Map>();
		Map<String, Map> sjgnCache = new HashMap<String, Map>();
		
		for (Map map : cates) {
			String level = map.get("LEVEL").toString();
			String id = map.get("ID").toString();
			
			//一级树
			if (level.equalsIgnoreCase("1")) {
				yjgnCache.put(id, map);
				List<Map> ejgnList = new LinkedList<Map>();
				map.put("ejTree", ejgnList);
				resultList.add(map);
				continue;
			}
			//二级树
			if (level.equalsIgnoreCase("2")) {
				String pId = map.get("UP_ID").toString();
				if(yjgnCache.containsKey(pId)) {
					Map yjgnMap = yjgnCache.get(pId);
					List<Map> list = (List<Map>)yjgnMap.get("ejTree");
					map.put("sjTree", new LinkedList<Map>());
					list.add(map);
					
					ejgnCache.put(id, map);
				}
				continue;
			}
			//三级树
			if (level.equalsIgnoreCase("3")) {
				if(null!=map.get("UP_ID")){
					String pId = map.get("UP_ID").toString();
					if(ejgnCache.containsKey(pId)) {
						Map ejgnMap = ejgnCache.get(map.get("UP_ID").toString());
						List<Map> list = (List<Map>)ejgnMap.get("sjTree");
						list.add(map);
					}
				}
			}
		}
		System.out.println(JsonUtil.list2Json(resultList));
		return resultList;
	}

	@Override
	public void saveLinkcate(HttpServletRequest request) {
		int level=0;
		String id = request.getParameter("id");
		String pId = request.getParameter("up_id");
		String category_name = request.getParameter("category_name");
		String ordernum = request.getParameter("ordernum");
		String titleimage = request.getParameter("titleimage");
		String content = request.getParameter("content");
		String summary = request.getParameter("summary");
		String titleimage_width = request.getParameter("titleimage_width");
		String titleimage_height = request.getParameter("titleimage_height");
		String thumbnail = request.getParameter("thumbnail");
		String note = request.getParameter("note");
		if(StringUtil.isBlank(id)){
	        if (StringUtil.isEmpty(pId)||Constants.TOP_ID.equals(pId)) {
	        	level=1;
	        } else {
	        	level=2;
	        }
	        int num=Integer.parseInt(ordernum);
	        int title=Integer.parseInt(titleimage);
	        int con=Integer.parseInt(content);
	        int sum = Integer.parseInt(summary);
	        int width=0;
	        int height=0;
	        if(titleimage_width!=null){
	        	width=Integer.parseInt(titleimage_width);
	            height=Integer.parseInt(titleimage_height);
	        }
	        
	        String idSql = "SELECT MAX(ID) FROM CMS_LINK_CATEGORY";
	        Integer idObj = baseDao.queryForInteger(idSql);
			int saveId = 1;
			if(null != idObj) {
				saveId = idObj;
			}
	        
	        int thumb=Integer.parseInt(thumbnail);
	        Map map=new HashMap();
	        map.put("id", saveId+1);
	        map.put("category_name", category_name);
			map.put("level", level);
			if(StringUtil.isEmpty(pId)){
				
				map.put("up_id", "-1");
			}else{
				map.put("up_id", pId);
			}
			map.put("ordernum", num);
			map.put("titleimage", title);
			map.put("content", con);
			map.put("summary", sum);
			map.put("titleimage_width",width);
			map.put("titleimage_height",height);
			map.put("thumbnail", thumb);
			map.put("note", note);
	    	StringBuffer sBuffer = new StringBuffer("insert into CMS_LINK_CATEGORY(");
			StringBuffer fileds = new StringBuffer("ID,CATEGORY_NAME,");
			StringBuffer values = new StringBuffer(":id,:category_name,");		
				fileds.append("LEVEL,");
				values.append(":level,");
				fileds.append("UP_ID,");
				values.append(":up_id,");
				fileds.append("ORDERNUM,");
				values.append(":ordernum,");
				fileds.append("TITLEIMAGE,");
				values.append(":titleimage,");
				fileds.append("TITLEIMAGE_WIDTH,");
				values.append(":titleimage_width,");
				fileds.append("TITLEIMAGE_HEIGHT,");
				values.append(":titleimage_height,");
				fileds.append("CONTENT,");
				values.append(":content,");
				fileds.append("SUMMARY,");
				values.append(":summary,");
				fileds.append("THUMBNAIL,");
				values.append(":thumbnail,");
				fileds.append("NOTE,");
				values.append(":note,");
			sBuffer.append(StringUtils.removeEnd(fileds.toString(), ",") + ") values("+StringUtils.removeEnd(values.toString(), ",")+")");
			
			baseDao.execute(sBuffer.toString(),map);
		}else{
			int ID=Integer.parseInt(id);
	        int num=Integer.parseInt(ordernum);
	        int title=Integer.parseInt(titleimage);
	        int con=Integer.parseInt(content);
	        int sum = Integer.parseInt(summary);
	        int width=0;
	        int height=0;
	        if(titleimage_width!=null){
	        	width=Integer.parseInt(titleimage_width);
	            height=Integer.parseInt(titleimage_height);
	        }
	        
	        int thumb=Integer.parseInt(thumbnail);
	        Map map=new HashMap();
	        map.put("category_name", category_name);
			map.put("ordernum", num);
			map.put("titleimage", title);
			map.put("titleimage_width",width);
			map.put("titleimage_height",height);
			map.put("content", con);
			map.put("summary", sum);
			map.put("thumbnail", thumb);
			map.put("note", note);
			StringBuffer sBuffer = new StringBuffer("update CMS_LINK_CATEGORY set ");
				sBuffer.append("CATEGORY_NAME=:category_name,");
				sBuffer.append("ORDERNUM=:ordernum,");
				sBuffer.append("TITLEIMAGE=:titleimage,");
				sBuffer.append("TITLEIMAGE_WIDTH=:titleimage_width,");
				sBuffer.append("TITLEIMAGE_HEIGHT=:titleimage_height,");
				sBuffer.append("CONTENT=:content,");
				sBuffer.append("SUMMARY=:summary,");
				sBuffer.append("THUMBNAIL=:thumbnail,");
				sBuffer.append("NOTE=:note,");
			String sql=StringUtils.removeEnd(sBuffer.toString(), ",") + " where id="+ID;
			baseDao.execute(sql,map);
		}
		
	}

	@Override
	public Map deletelinkcate(HttpServletRequest request) {
		String id = request.getParameter("id");
		String sql = "SELECT COUNT(ID) FROM CMS_LINK_CATEGORY WHERE UP_ID = :up_id ";
		Map param = new HashMap();
		param.put("up_id", id);
		int count = baseDao.queryForInteger(sql, param);
		
		String firstCate = new String();
		String secondCate = new String();
		CMS_LINK_CATEGORY cate = new CMS_LINK_CATEGORY(id).getInstanceById();
		String sjbh = ConvertUtil.obj2StrBlank(cate.getUp_id());
		if(StringUtil.notEmpty(sjbh)&&!Constants.TOP_ID.equals(sjbh)) {
			CMS_LINK_CATEGORY pcate = new CMS_LINK_CATEGORY(sjbh).getInstanceById();
			int level = pcate.getLevel();
			if(level==2) {
				firstCate = ConvertUtil.obj2StrBlank(pcate.getUp_id());
				secondCate = pcate.getId();
			} else {
				firstCate = pcate.getId();
			}
		}
		Map result = new HashMap();
		if(count > 0){
			result.put("msg", "存在子分类，不能删除");
		}else{
			cate.deleteById();
			result.put("msg", "1");
		}
		result.put("firstCate", firstCate);
		result.put("secondCate", secondCate);
		return result;
	}

}