小程序-本周热点TOP5
__ekbsagrjF60f5gJnBQQ
__ekbsagrjF60f5gJnBQQ
published
__XAfXjHYTYHThlJsD5un
UTF-8
post
/xcxfxpz/gethotspot
json
" + context);
var pageIndex = obj["pageIndex"];//获取页码
var pageSize = obj["pageSize"];//获取每页条数
var start = (Number(pageIndex) - 1) * Number(pageSize);//定义limit起始条数
var sql = "SELECT DISTINCT "+
" a.ITEM_TITLE,"+
" (SELECT COUNT(1) as count FROM tlk_reading_records_app WHERE ITEM_TITILE_ID=a.ID and YEARWEEK(date_format( ITEM_READ_TIME,'%Y-%m-%d %h:%m:%s')) = YEARWEEK(now())) as ITEM_READCOUNT,"+
" a.id as articleid"+
" FROM "+
" tlk_article_details_app a ,tlk_reading_records_app b "+
" WHERE"+
" a.id = b.ITEM_TITILE_ID and ITEM_STATE='0' and ITEM_ENTERPRISE_TYPE='0' ";
sql += "order by ITEM_READCOUNT DESC";
sql += " limit " + start + "," + pageSize;
println("sql=====" + sql);
var datas = queryByDSName("organizationAuth", sql);
//查询表的总记录数
var sql1 = "SELECT distinct count(1) as total from tlk_article_details_app where " +
"YEARWEEK(date_format( ITEM_TIME,'%Y-%m-%d %h:%m:%s')) = YEARWEEK(now()) and ITEM_STATE='0' and ITEM_ENTERPRISE_TYPE='0' ";
var datas1 = queryByDSName("organizationAuth", 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;
})()]]>