企业信息
__DOoeSJp26wVqbyYYf50
__DOoeSJp26wVqbyYYf50
published
UTF-8
post
/hangye/qiyexinxi
json
= 0){
var sql1 = "SELECT item_domain_id,ITEM_company_name,ITEM_office_type,case ITEM_office_type when '0101' then '保安协会' when '0102' then '保安服务公司' when '0103' then '保安培训单位' when '0104' then '自行招用保安单位' end as ITEM_office_type_name,ITEM_legal_person,ITEM_legal_person_phone,"+
"ITEM_supervise_office,date_format(ITEM_entry_date,'%Y-%m-%d') as ITEM_entry_date, case when '0' then '0' else '0' end as is_sub "+
" FROM `tlk_companyinfoquery` where " + addDomainPermissionFilterCondition("__DOoeSJp26wVqbyYYf50",domainid) + " and ITEM_company_name like CONCAT('%','"+companyName+"','%') limit " + x +"," +pageSize
println("sql1====="+sql1);
var datas = queryByDSName("companyInfoCollect",sql1);
result1.put("data",datas);
return result1;
}else{
var sql1 = "SELECT item_domain_id,ITEM_company_name,ITEM_office_type,case ITEM_office_type when '0101' then '保安协会' when '0102' then '保安服务公司' when '0103' then '保安培训单位' when '0104' then '自行招用保安单位' end as ITEM_office_type_name,ITEM_legal_person,ITEM_legal_person_phone,"+
"ITEM_supervise_office,date_format(ITEM_entry_date,'%Y-%m-%d') as ITEM_entry_date, case when '0' then '0' else '0' end as is_sub "+
" FROM `tlk_companyinfoquery` where " + addDomainPermissionFilterCondition("__DOoeSJp26wVqbyYYf50",domainid) + " and ITEM_company_name like CONCAT('%','"+companyName+"','%') 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 pk_id,case ITEM_is_sub when '2' then '分公司' when '3' then '子公司' end as ITEM_is_sub ,item_group_name,item_company_name,item_company_phone,item_legal_person,"+
"item_company_region,date_format(item_foundation_date,'%Y-%m-%d') as item_foundation_date,case when '1' then '1' else '1' end as is_sub,item_legal_person_phone "+
" from sub_company where " + addDomainPermissionFilterCondition("__DOoeSJp26wVqbyYYf50",domainid) + " and item_company_name like CONCAT('%','"+companyName+"','%') and ITEM_IS_DELETE = '0' 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;
}
})()]]>