协会动态
__1m6BoSkXGgLOD9Yibv8
__1m6BoSkXGgLOD9Yibv8
published
UTF-8
post
/mhgl/xhdt
json
" + context);
var pageIndex = obj["pageIndex"];//获取页码
var pageSize = obj["pageSize"];//获取每页条数
//var classificationid = obj["classificationid"];//分类id
var start = (Number(pageIndex) - 1) * Number(pageSize);//定义limit起始条数
//获取当前企业域的注册地址
//表单某字段值为当前打开文档Id
var address=""
var sql = "SELECT place_of_register_province_name,place_of_register_city_name,place_of_register_district_name from tenant_organizations WHERE id = '"+getDomainid()+"'"
var datas = queryByDSName("obpm2",sql);
if(datas!=null){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
var province= map1.get("place_of_register_province_name");
//var city= map1.get("place_of_register_city_name")
//var area= map1.get("place_of_register_district_name")
//address=province+city+area
}
}
var sql = "SELECT"+
" ITEM_TITLE,"+
" ID as articleid ,"+
" ITEM_IMAGE,"+
" (SELECT COUNT(1) as count FROM tlk_reading_records WHERE ITEM_TITILE_ID=a.ID) as ITEM_READCOUNT,"+
" ITEM_CONTENT,"+
" (select ITEM_CLASSIFY_NAME from tlk_classification_details where ID = a.ITEM_ARTICLE) as ITEM_ARTICLE, "+
" DATE_FORMAT(ITEM_TIME,'%Y-%m-%d') AS ITEM_TIME "+
" FROM "+
" tlk_article_details a "+
" WHERE"+
" ITEM_ADDRESS like '%"+province+"%' and ITEM_STATE='0' and ITEM_ENTERPRISE_TYPE='2' order by ITEM_TOPPING asc"
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 ITEM_ADDRESS like '%"+province+"%' and ITEM_STATE='0'and ITEM_ENTERPRISE_TYPE='2' "
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;
})()]]>