设置了首页显示分类
__RdXCISdqA4CycTJDFsz
__RdXCISdqA4CycTJDFsz
published
UTF-8
post
/xwgl/gethomeclassification
json
" + context);
var pageIndex = obj["pageIndex"];//获取页码
var pageSize = obj["pageSize"];//获取每页条数
var start = (Number(pageIndex) - 1) * Number(pageSize);//定义limit起始条数
var sql = "SELECT"+
" a.ITEM_CLASSIFY_NAME,"+
" CASE ITEM_STATE"+
" WHEN '0' THEN '显示'"+
" WHEN '1' THEN '隐藏' "+
" ELSE '无' "+
" END ITEM_STATE,"+
" CASE ITEM_TYPE"+
" WHEN '0' THEN '文章分类'"+
" WHEN '1' THEN '单位分类' "+
" ELSE '无' "+
" END ITEM_TYPE,"+
" ITEM_ORDERBY, "+
" CASE ITEM_HOME_DISPLAY"+
" WHEN '0' THEN '是'"+
" WHEN '1' THEN '否' "+
" ELSE '无'"+
" END ITEM_HOME_DISPLAY,"+
" CASE ITEM_WORKBENCH"+
" WHEN '0' THEN '是'"+
" WHEN '1' THEN '否' "+
" ELSE '无'"+
" END ITEM_WORKBENCH, "+
" ID as classificationid ,"+
" (SELECT COUNT(1) FROM tlk_article_details WHERE ITEM_COMPANY = a.ID or ITEM_ARTICLE =a.ID ) as articlecount"+
" FROM "+
" tlk_classification_details a"+
" WHERE"+
" a.domainid = '" + getDomainid() + "' and item_type='0' and item_home_display='0' and ITEM_STATE='0' "
sql +=" order by ITEM_ORDERBY asc"
sql += " limit " + start + "," + pageSize;
println("sql=====" + sql)
var datas = queryByDSName("localmysql", sql);
//查询表的总记录数
var sql1 = "SELECT distinct count(1) as total from tlk_classification_details where domainid = '" + getDomainid() + "' and item_type='0' and item_home_display='0' and ITEM_STATE='0' "
var datas1 = queryByDSName("localmysql", sql1);
for (var iterator = datas1.iterator(); iterator.hasNext();) {
var map1 = iterator.next();//取值
var total = map1.get("total");
}
result.put("sql", sql);
result.put("code", "0");
result.put("msg", "获取成功");
result.put("data", datas);
result.put("total", total);
return result;
})()]]>