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