package cn.ksource.web.facade.link;

import java.io.File;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.http.HttpServletRequest;

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

import com.lowagie.tools.handout_pdf;

import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.page.PageInfo;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.FileUtil;
import cn.ksource.core.util.MyFileUploadException;
import cn.ksource.core.util.StringUtil;
import cn.ksource.web.Constants;
import cn.ksource.web.entity.link.CmsLink;

@Service("linkFacade")
public class LinkFacadeImpl implements LinkFacade {

	@Autowired
	private BaseDao baseDao;
	
	
	/**
	 * 查询指定分类下的列表信息
	 */
	@Override
	public Map queryLinkListJson(String categoryId, int page, int pageSize) {
		StringBuilder builder = new StringBuilder("SELECT * FROM CMS_LINK WHERE CATEGORY_ID = :categoryId");
		StringBuilder countBuilder = new StringBuilder("SELECT COUNT(ID) FROM CMS_LINK WHERE CATEGORY_ID = :categoryId");
		Map paramMap = new HashMap();
		builder.append(" ORDER BY THETOP ASC,ORDERNUM ASC");
	    builder.append(" LIMIT :begin,:size");
		page = page==0?1:page;
		pageSize = pageSize==0?10:pageSize;
		int begin = (page-1)*pageSize;
		paramMap.put("begin", begin);
		paramMap.put("size", pageSize);
		paramMap.put("categoryId", categoryId);
		int count = baseDao.queryForInteger(countBuilder.toString(), paramMap);
		List<Map> resultList = baseDao.queryForList(builder.toString(),paramMap);
		
		
		Map resultMap = new HashMap();
		resultMap.put("total", count); //信息总数
		resultMap.put("rows", resultList);
		return resultMap;
	}
	
	


	@Override
	public Map queryLinkCategoryById(String categoryId) {
		String sql = "SELECT * FROM CMS_LINK_CATEGORY WHERE ID = :id";
		return baseDao.queryForMap(sql, new SqlParameter().addValue("id", categoryId));
	}




	@Override
	public boolean save(CmsLink link, HttpServletRequest request) {
		String[] allowType =  new String[]{"gif","jpg","jpeg","png"};
		int categoryId = link.getCategoryId();
		System.out.println("categoryId:"+categoryId);
		Map linkCategory = queryLinkCategoryById(ConvertUtil.obj2StrBlank(categoryId));
		//判断是否需要标题图片
		int titleimage = ConvertUtil.obj2Int(linkCategory.get("TITLEIMAGE"));
		
		String uploadUrl = new String();
		if(titleimage==1) {
			try {
				uploadUrl = FileUtil.uploadFile4SpringMVC(request, "image" ,"/upload/classify"+categoryId,allowType);
				//判断是否需要生成缩略图
				int thumbnail = ConvertUtil.obj2Int(linkCategory.get("THUMBNAIL"));
				if(thumbnail!=1){
					//获得生成的缩略图的等比或者强制宽和高
					String widthStr = ConvertUtil.obj2StrBlank(linkCategory.get("TITLEIMAGE_WIDTH"));
					String heightStr = ConvertUtil.obj2StrBlank(linkCategory.get("TITLEIMAGE_HEIGHT"));
					if(!widthStr.equals("") && !heightStr.equals("") && !widthStr.equals("0") && !heightStr.equals("0")) {
						int width = ConvertUtil.obj2Int(widthStr);
						int height = ConvertUtil.obj2Int(heightStr);
						String pathPix = request.getSession().getServletContext().getRealPath("/");
						boolean b = false;
						if(thumbnail==3) {
							b = true;
						}
						String newName = FileUtil.resizeForEqualImg(new File(pathPix+uploadUrl), width, height, b);
						uploadUrl = uploadUrl.replace(uploadUrl.substring(uploadUrl.lastIndexOf("/")+1), newName);
					}
				}
				link.setTitleimage(uploadUrl);
				
			} catch (MyFileUploadException e) {
				return false;
			}
		}
		
		//保存信息
		
		String idSql = "SELECT MAX(ID) FROM CMS_LINK";
		Integer idObj = baseDao.queryForInteger(idSql);
		int id = 1;
		if(null != idObj) {
			id = idObj;
		}
		
		String sql = "INSERT INTO CMS_LINK(ID,CATEGORY_ID,TITLE,TITLEIMAGE,THETOP,SUMMARY,CONTENT,THEURL,ORDERNUM,POSITION_ID,LINK_STATUS) " +
					 "VALUES (:id,:categoryId,:title,:titleimage,:thetop,:summary,:content,:theurl,:ordernum,:positionId,:status)";
 
		Map paramMap = new HashMap();
		paramMap.put("id", id+1);
		paramMap.put("categoryId", link.getCategoryId());
		paramMap.put("title", link.getTitle());
		paramMap.put("titleimage", link.getTitleimage());
		paramMap.put("thetop", link.getThetop());
		paramMap.put("summary", link.getSummary());
		paramMap.put("content", link.getContent());
		paramMap.put("theurl", link.getTheurl());
		paramMap.put("ordernum", link.getOrdernum());
		paramMap.put("positionId", link.getPositionId());
		paramMap.put("status", 1);
		baseDao.execute(sql, paramMap);
		return true;
	}




	@Override
	public Map queryLinkById(String linkId) {
		String sql = "SELECT * FROM CMS_LINK WHERE ID = :id";
		return baseDao.queryForMap(sql, new SqlParameter().addValue("id", linkId));
	}




	@Override
	public boolean updateLink(CmsLink link, HttpServletRequest request) {
		String[] allowType =  new String[]{"gif","jpg","jpeg","png"};
		int categoryId = link.getCategoryId();
		Map linkCategory = queryLinkCategoryById(ConvertUtil.obj2StrBlank(categoryId));
		//判断是否需要标题图片
		int titleimage = ConvertUtil.obj2Int(linkCategory.get("TITLEIMAGE"));
		
		String uploadUrl = new String();
		if(titleimage==1) {
			try {
				uploadUrl = FileUtil.uploadFile4SpringMVC(request, "image" ,"/upload/classify"+categoryId,allowType);
				if(null!=uploadUrl) {
					//判断是否需要生成缩略图
					int thumbnail = ConvertUtil.obj2Int(linkCategory.get("THUMBNAIL"));
					if(thumbnail!=1){
						//获得生成的缩略图的等比或者强制宽和高
						String widthStr = ConvertUtil.obj2StrBlank(linkCategory.get("TITLEIMAGE_WIDTH"));
						String heightStr = ConvertUtil.obj2StrBlank(linkCategory.get("TITLEIMAGE_HEIGHT"));
						if(!widthStr.equals("") && !heightStr.equals("") && !widthStr.equals("0") && !heightStr.equals("0")) {
							int width = ConvertUtil.obj2Int(widthStr);
							int height = ConvertUtil.obj2Int(heightStr);
							String pathPix = request.getSession().getServletContext().getRealPath("/");
							boolean b = false;
							if(thumbnail==3) {
								b = true;
							}
							String newName = FileUtil.resizeForEqualImg(new File(pathPix+uploadUrl), width, height, b);
							uploadUrl = uploadUrl.replace(uploadUrl.substring(uploadUrl.lastIndexOf("/")+1), newName);
						}
					}
					link.setTitleimage(uploadUrl);
				}
				
			} catch (MyFileUploadException e) {
				return false;
			}
		}
		
		String sql = "UPDATE CMS_LINK SET TITLE = :title,TITLEIMAGE = :titleimage,THETOP = :thetop,SUMMARY = :summary,CONTENT = :content,THEURL = :theurl,ORDERNUM = :ordernum,POSITION_ID=:positionId WHERE ID = :id";
		Map parmaMap = new HashMap();
		parmaMap.put("title", link.getTitle());
		parmaMap.put("titleimage", link.getTitleimage());
		parmaMap.put("thetop", link.getThetop());
		parmaMap.put("content", link.getContent());
		parmaMap.put("summary", link.getSummary());
		parmaMap.put("theurl", link.getTheurl());
		parmaMap.put("ordernum", link.getOrdernum());
		parmaMap.put("positionId", link.getPositionId());
		parmaMap.put("id", link.getId());
		
		baseDao.execute(sql, parmaMap);
		return true;
		
	}




	@Override
	public void deleteLink(String id,String index) {
		String sql = "UPDATE CMS_LINK SET LINK_STATUS = :link_status WHERE ID = :id";
		Map param = new HashMap();
		param.put("link_status", index);
		param.put("id", id);
		baseDao.execute(sql,param);
	}




	@Override
	public Boolean queryMsgCountByCategoryId(String categoryId) {
		String sql = "SELECT COUNT(ID) FROM CMS_LINK WHERE CATEGORY_ID = :categoryId";
		int count = baseDao.queryForInteger(sql,new SqlParameter("categoryId",categoryId));
		if(count>0) {
			return false;
		}
		return true;
	}




	@Override
	public void updateState(int id, int state) {
		String sql = "UPDATE CMS_LINK SET LINK_STATUS=:state WHERE ID=:id";
		
		baseDao.execute(sql, new SqlParameter().addValue("state", state).addValue("id", id));
	}




	@Override
	public int querylinkCount(String categoryId) {
		StringBuilder builder = new StringBuilder("SELECT COUNT(ID) FROM CMS_LINK WHERE CATEGORY_ID = :categoryId ");
		Map paramMap = new HashMap();
		paramMap.put("categoryId", categoryId);
		
		
		int count = baseDao.queryForInteger(builder.toString(), paramMap);
		
		return count;
	}




	@Override
	public PageInfo querylinkData(PageInfo pageInfo,String categoryId) {
		StringBuilder builder = new StringBuilder("SELECT * FROM CMS_LINK WHERE CATEGORY_ID = :categoryId ");
		Map paramMap = new HashMap();
		paramMap.put("categoryId", categoryId);
		
		builder.append(" ORDER BY THETOP ASC,ORDERNUM ASC ");
		
		PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, builder.toString(), paramMap);
		
		return info;
	}
}