证书信息 __DOoeSJp26wVqbyYYf50 __DOoeSJp26wVqbyYYf50 published UTF-8 post /hangye/zhengshu json " + regionCode); var regionCodeShort = "##"; if(isNotNull(regionCode) && regionCode.length() >=3){ regionCodeShort = regionCode.substring(0, 3) + '%'; } var domainid = getDomainid(); println("企业域========"+domainid); var jsonStr = getParameter("_content"); var json = JSON.parse(jsonStr); var name = json["name"];//人员id var pageIndex = json["pageIndex"];//页数 var pageSize = json["pageSize"];//条数 var x = (pageIndex - 1) * pageSize /**var sql = "select id,item_name,ITEM_document_id,ITEM_certificate_no,item_type as item_type_code,"+ "ITEM_sex,case ITEM_degree when '一级' then '一级' when '二级' then '二级' when '5' then '初级保安员' when '4' then '中级保安员' when '3' then '高级保安员' end as ITEM_degree,case ITEM_STATUS when '1' then '正常' when '2' then '撤销' when '0' then '吊销' when '3' then '注销' end as ITEM_STATUS,"+ "case item_type when '1' then '保安师' when '2' then '保安员等级证' when '3' then '保安员资格证' when '4' then '行业培训证书' end as item_type "+ "FROM `police_protection_app` where domainid='" + domainid +"' and item_name like '"+name+"%' or ITEM_document_id like '"+name+"%' or ITEM_certificate_no like '"+name+"%' limit " + x +"," +pageSize*/ var sql = "select * from (select id, item_name,ITEM_document_id,ITEM_certificate_no,'1' as item_type_code, case item_sex when '0' then '男' when '1' then '女' else item_sex end, ITEM_degree, case ITEM_STATUS when '1' then '正常' when '2' then '撤销' when '0' then '吊销' when '3' then '注销' end as ITEM_STATUS,'保安师' as item_type from tlk_master_management where region_code like '" +regionCodeShort + "' and item_name like '"+name+"%' or ITEM_document_id like '"+name+"%' or ITEM_certificate_no like '"+name+"%'" + " union " + "select id, ITEM_SECURITY_NAME as item_name,ITEM_document_id,ITEM_certificate_no,'2' as item_type_code, case ITEM_sex when '1' then '男' when '2' then '女' end as ITEM_sex, case ITEM_CERTIFICATE_LEVEL when '5' then '初级保安员' when '4' then '中级保安员' when '3' then '高级保安员' end as ITEM_degree, case ITEM_STATUS when '1' then '正常' when '2' then '撤销' when '0' then '吊销' when '3' then '注销' end as ITEM_STATUS,'保安员等级证' as item_type from tlk_grade_certificate where region_code like '" +regionCodeShort + "' and ITEM_SECURITY_NAME like '"+name+"%' or ITEM_document_id like '"+name+"%' or ITEM_certificate_no like '"+name+"%'" + " union " + "select id, ITEM_security_name as item_name,ITEM_document_id,ITEM_certificate_no,'3' as item_type_code, case ITEM_sex when '1' then '男' when '2' then '女' end as ITEM_sex, '' as ITEM_degree, case ITEM_STATUS when '1' then '正常' when '2' then '撤销' when '0' then '吊销' when '3' then '注销' end as ITEM_STATUS,'保安员资格证' as item_type from tlk_qualification_certificate where region_code like '" +regionCodeShort + "' and ITEM_SECURITY_NAME like '"+name+"%' or ITEM_document_id like '"+name+"%' or ITEM_certificate_no like '"+name+"%'" + " union " + "select id, ITEM_security_name as item_name,ITEM_document_id,ITEM_certificate_no,'4' as item_type_code, case ITEM_sex when '0' then '男' when '1' then '女' end as ITEM_sex, '' as ITEM_degree, case ITEM_STATUS when '1' then '正常' when '2' then '撤销' when '0' then '吊销' when '3' then '注销' end as ITEM_STATUS,'行业培训证书' as item_type from tlk_training_certificate where region_code like '" +regionCodeShort + "' and ITEM_security_name like '"+name+"%' or ITEM_document_id like '"+name+"%' or ITEM_certificate_no like '"+name+"%'" + ") t limit " + x +"," +pageSize; println("sql========="+sql); var datas = queryByDSName("companyInfoCollect",sql); result.put("data",datas); return result; })()]]>