文章详情里上=47下一条文章查询接口
__RdXCISdqA4CycTJDFsz
__RdXCISdqA4CycTJDFsz
published
UTF-8
post
/xwgl/getcursor
json
" + context);
var pageIndex = obj["pageIndex"];//获取页码
var pageSize = obj["pageSize"];//获取每页条数
var numberid = obj["numberid"];//序号id
var cursor = obj["cursor"];//上一页/下一页
var start = (Number(pageIndex) - 1) * Number(pageSize);//定义limit起始条数
if(cursor=="0"){//上一页
var sql = "SELECT"+
" ITEM_TITLE,"+
" CASE ITEM_HOME_ROTATION"+
" WHEN '0' THEN '是'"+
" WHEN '1' THEN '否' "+
" ELSE '无'"+
" END ITEM_HOME_ROTATION,"+
" ID as articleid ,"+
" ITEM_IMAGE,"+
" ITEM_CONTENT,"+
" ITEM_DEPARTMENT,"+
" (SELECT COUNT(1) as count FROM tlk_reading_records WHERE ITEM_TITILE_ID=a.ID) as ITEM_READCOUNT,"+
" ITEM_ENCLOSURE,"+
" ITEM_NUMBER,"+
" DATE_FORMAT(ITEM_TIME,'%Y-%m-%d %h:%m:%s') AS ITEM_TIME "+
" FROM "+
" tlk_article_details a "+
" WHERE"+
" a.domainid = '" + getDomainid() + "' and ITEM_NUMBER ='"+numberid+"'-1 "
}
if(cursor=="1"){//下一页
var sql = "SELECT"+
" ITEM_TITLE,"+
" CASE ITEM_HOME_ROTATION"+
" WHEN '0' THEN '是'"+
" WHEN '1' THEN '否' "+
" ELSE '无'"+
" END ITEM_HOME_ROTATION,"+
" ID as articleid ,"+
" ITEM_IMAGE,"+
" ITEM_CONTENT,"+
" ITEM_DEPARTMENT,"+
" ITEM_READCOUNT,"+
" ITEM_ENCLOSURE,"+
" ITEM_NUMBER,"+
" DATE_FORMAT(ITEM_TIME,'%Y-%m-%d %h:%m:%s') AS ITEM_TIME "+
" FROM "+
" tlk_article_details a "+
" WHERE"+
" a.domainid = '" + getDomainid() + "' and ITEM_NUMBER ='"+numberid+"'+1 "
}
sql += " limit " + start + "," + pageSize;
println("sql=====" + sql)
var datas = queryByDSName("localmysql", sql);
result.put("sql",sql);
result.put("code", "0");
result.put("msg", "获取成功");
result.put("data", datas);
// result.put("total", total);
return result;
})()]]>