package cn.ksource.web.service.colunm;

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

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

import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.util.FileUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.web.Constants;
import cn.ksource.web.entity.colunm.CmsCategory;

@Service("colunmService")
@SuppressWarnings("unchecked")
public class ColunmServiceImpl implements ColunmService {

	@Autowired
    private BaseDao baseDao;

	@Override
	public List<Map> getColunmClassifyTree(String id) {
		StringBuilder builder = new StringBuilder();
		Map paramMap = new HashMap();
		if(StringUtil.isBlank(id) || Constants.TOP_ID.equals(id)) {
			builder.append("SELECT * FROM CMS_CATEGORY WHERE USINGSTATE = 1 ORDER BY LEVEL,ORDERNUM");
		} else {
			builder.append("SELECT * FROM CMS_CATEGORY WHERE USINGSTATE = 1 AND UP_ID = :id ORDER BY ORDERNUM");
			paramMap.put("id", id);
		}
		return baseDao.queryForList(builder.toString(), paramMap);
	}

	/**
	 * 查询栏目管理列表
	 */
	@Override
	public Map getColunmList(String nodeId, int page, int rows) {
		StringBuilder builder = new StringBuilder();
		StringBuilder countBuilder = new StringBuilder();
		Map paramMap = new HashMap();
		if(StringUtil.isBlank(nodeId) || Constants.TOP_ID.equals(nodeId)) {
			builder.append("SELECT * FROM CMS_CATEGORY WHERE USINGSTATE = 1 AND UP_ID IS NULL ");
			countBuilder.append("SELECT COUNT(*) FROM CMS_CATEGORY WHERE USINGSTATE = 1 AND UP_ID IS NULL ");
		} else {
			builder.append("SELECT * FROM CMS_CATEGORY WHERE USINGSTATE = 1 AND UP_ID = :id ");
			countBuilder.append("SELECT COUNT(*) FROM CMS_CATEGORY WHERE USINGSTATE = 1 AND UP_ID = :id ");
			paramMap.put("id", nodeId);
		}
		builder.append(" ORDER BY ORDERNUM ");
	    builder.append(" LIMIT :begin,:size");
		page = page==0?1:page;
		rows = rows==0?10:rows;
		int begin = (page-1)*rows;
		paramMap.put("begin", begin);
		paramMap.put("size", rows);
		int count = baseDao.queryForInteger(countBuilder.toString(), paramMap);
		List resultList = new ArrayList();
		if(count>0) {
			resultList = baseDao.queryForList(builder.toString(),paramMap);
		}
		Map resultMap = new HashMap();
		resultMap.put("total", count); //信息总数
		resultMap.put("rows", resultList);
		return resultMap;
	}

	/**
	 * 通过id查询级别
	 */
	@Override
	public int queryLevelById(String nodeId) {
		String sql = "SELECT LEVEL FROM  CMS_CATEGORY WHERE ID = :id";
		return baseDao.queryForInteger(sql, new SqlParameter().addValue("id", nodeId));
	}

	@Override
	public void saveColumnClassify(CmsCategory cmsCategory) {
		String idSql = "SELECT MAX(ID) FROM CMS_CATEGORY";
		String sql = "INSERT INTO CMS_CATEGORY (ID,CATEGORY_NAME,LEVEL,UP_ID,ORDERNUM,SHOW_TYPE,SUMMARY,ATTACHEMENTS,TITLEIMAGE,TITLEIMAGE_WIDTH,TITLEIMAGE_HEIGHT,THUMBNAIL,USINGSTATE,NOTE,SHENPI,SHANGB,CLASSIFYIMAGE) " +
				"VALUES (:id,:categoryName,:level,:upId,:ordernum,:showType,:summary,:attachments,:titleimage,:titleimageWidth,:titleimageHeight,:thumbnail,1,:note,:shenpi,:shangb,:classifyImage)";
		Map paramMap = new HashMap();
		Integer idObj = baseDao.queryForInteger(idSql);
		int id = 1;
		System.out.println("idObj"+idObj);
		if(null != idObj) {
			id = idObj;
		}
		paramMap.put("id",id+1);
		paramMap.put("categoryName", cmsCategory.getCategoryName());
		paramMap.put("level", cmsCategory.getLevel());
		paramMap.put("upId", cmsCategory.getUpId());
		paramMap.put("ordernum", cmsCategory.getOrdernum());
		paramMap.put("showType", cmsCategory.getShowType());
		paramMap.put("summary", cmsCategory.getSummary());
		paramMap.put("attachments", cmsCategory.getAttachements());
		paramMap.put("titleimage", cmsCategory.getTitleimage());
		paramMap.put("titleimageWidth", cmsCategory.getTitleimageWidth());
		paramMap.put("titleimageHeight", cmsCategory.getTitleimageHeight());
		paramMap.put("thumbnail", cmsCategory.getThumbnail());
		paramMap.put("note", cmsCategory.getNote());
		paramMap.put("shenpi", cmsCategory.getShenpi());
		paramMap.put("shangb", cmsCategory.getShangb());
		paramMap.put("classifyImage", cmsCategory.getClassifyImage());
		baseDao.execute(sql, paramMap);
	}

	/**
	 * 删除栏目
	 */
	@Override
	public void deleteColumnClassify(String id) {
		String sql = "UPDATE CMS_CATEGORY SET USINGSTATE = 2 WHERE ID = :id OR UP_ID = :id";
		baseDao.execute(sql, new SqlParameter().addValue("id", id));
	}

	/**
	 * 通过id查询栏目信息
	 */
	@Override
	public Map queryColunmById(String id) {
		String sql = "SELECT * FROM CMS_CATEGORY WHERE ID = :id";
	    return baseDao.queryForMap(sql, new SqlParameter().addValue("id", id));
	}

	/**
	 * 更新栏目
	 */
	@Override
	public void updateColunm(CmsCategory cmsCategory) {
		System.out.println(cmsCategory.getCategoryName());
		String sql = "UPDATE CMS_CATEGORY SET CATEGORY_NAME = :catgeoryName,ORDERNUM = :ordernum,SHOW_TYPE = :showType,SUMMARY = :summary,ATTACHEMENTS = :attachments,TITLEIMAGE = :titleimage,TITLEIMAGE_WIDTH = :titleimageWidth,TITLEIMAGE_HEIGHT = :titleimageHeight,SHANGB = :shangb,SHENPI = :shenpi,THUMBNAIL = :thumbnail,NOTE = :note,CLASSIFYIMAGE=:classifyImage WHERE ID = :id";
		Map paramMap = new HashMap();
		paramMap.put("id", cmsCategory.getId());
		paramMap.put("catgeoryName", cmsCategory.getCategoryName());
		paramMap.put("ordernum", cmsCategory.getOrdernum());
		paramMap.put("showType", cmsCategory.getShowType());
		paramMap.put("summary", cmsCategory.getSummary());
		paramMap.put("attachments", cmsCategory.getAttachements());
		paramMap.put("titleimage", cmsCategory.getTitleimage());
		paramMap.put("titleimageWidth", cmsCategory.getTitleimageWidth());
		paramMap.put("titleimageHeight", cmsCategory.getTitleimageHeight());
		paramMap.put("shangb", cmsCategory.getShangb());
		paramMap.put("shenpi", cmsCategory.getShenpi());
		paramMap.put("thumbnail", cmsCategory.getThumbnail());
		paramMap.put("note", cmsCategory.getNote());
		paramMap.put("shenpi", cmsCategory.getShenpi());
		paramMap.put("shangb", cmsCategory.getShangb());
		paramMap.put("classifyImage", cmsCategory.getClassifyImage());
		baseDao.execute(sql, paramMap);
	}
}