企业设备车辆信息
__DOoeSJp26wVqbyYYf50
__DOoeSJp26wVqbyYYf50
published
UTF-8
post
/hangye/shebei
json
= 0){
var sql1 = "SELECT ITEM_equip_type,ITEM_equip_no,ITEM_equip_name,ITEM_equip_total,"+
"date_format(ITEM_first_storage_time,'%Y-%m-%d') as ITEM_first_storage_time,case when '0' then '0' else '0' end as is_sub "+
" FROM `tlk_device` where ITEM_domain_id = '"+item_domain_id+"' limit " + x +"," +pageSize
println("sql1====="+sql1);
var datas = queryByDSName("companyInfoCollect",sql1);
result1.put("data",datas)
return result1;
}else{
var sql1 = "SELECT ITEM_equip_type,ITEM_equip_no,ITEM_equip_name,ITEM_equip_total,"+
"date_format(ITEM_first_storage_time,'%Y-%m-%d') as ITEM_first_storage_time,case when '0' then '0' else '0' end as is_sub "+
" FROM `tlk_device` where ITEM_domain_id = '"+item_domain_id+"' limit " + x +"," +pageSize
println("sql1====="+sql1);
var datas = queryByDSName("companyInfoCollect",sql1);
var a = total - num;
var b = toFloor(a/pageSize);
if(b > 0){
b = (b - 1) * pageSize + a%pageSize;
}
println("b========="+b);
var c = "";
if(a < pageSize){
c = a;
}else{
c = pageSize;
}
var sql2 = "SELECT ITEM_vehicle_num,ITEM_vehicle_type,ITEM_vehicle_brand,ITEM_engine_num,ITEM_load_number,ITEM_clstate,ITEM_regorg,"+
"date_format(ITEM_reg_date,'%Y-%m-%d') as ITEM_reg_date,case when '1' then '1' else '1' end as is_sub,ITEM_annotation "+
" from tlk_vehicle where ITEM_domain_id = '"+item_domain_id+"' limit "+ b +","+ c;
println("sql2====="+sql2);
var datas2 = queryByDSName("companyInfoCollect",sql2);
var result = new Packages.java.util.List(datas); //创建指定类对象
if(datas2!=null){
for(var iterator = datas2.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值;
result.add(map1);
}
}
result1.put("data",result)
return result1;
}
})()]]>