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);
|
}
|
}
|
