{
  "properties" : { },
  "id" : "922e1b94c7c346d69c57467d21cb00e6",
  "script" : null,
  "groupId" : "05b429d9d76e469eb86e3e7ab55eb0fd",
  "name" : "调度智能预警",
  "createTime" : null,
  "updateTime" : 1698025359776,
  "lock" : null,
  "createBy" : null,
  "updateBy" : null,
  "path" : "/earlyWarning",
  "method" : "GET",
  "parameters" : [ {
    "name" : "isFirst",
    "value" : "0",
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  }, {
    "name" : "region",
    "value" : "娄底市公安局",
    "description" : null,
    "required" : false,
    "dataType" : "String",
    "type" : null,
    "defaultValue" : null,
    "validateType" : null,
    "error" : null,
    "expression" : null,
    "children" : null
  } ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : "{\n    \"code\": 1,\n    \"message\": \"success\",\n    \"data\": [\n        {\n            \"无联动值企业数\": 3679,\n            \"联动值低于500企业数\": 3681,\n            \"无硬件设备企业数\": 3684,\n            \"企业无坐标数\": 3526\n        }\n    ],\n    \"timestamp\": 1698025352424,\n    \"executeTime\": 1\n}",
  "description" : null,
  "requestBodyDefinition" : null,
  "responseBodyDefinition" : null
}
================================
var sql = """
select 
(SELECT
	COUNT(1)
FROM
	dispatch.rd_company_summary org
	LEFT JOIN dispatch.tlk_org_purse a ON org.id = a.item_organization_id
WHERE
    ?{isFirst!=null&&isFirst!='1', org.supervise_depart_name like CONCAT('%',#{region},'%') and }
	a.item_organization_id is null ) as "无联动值企业数",
    (SELECT
	COUNT(1)
FROM
	dispatch.rd_company_summary org
	LEFT JOIN dispatch.tlk_org_purse a ON org.id = a.item_organization_id
WHERE
?{isFirst!=null&&isFirst!='1', org.supervise_depart_name like CONCAT('%',#{region},'%') and }
	(a.item_organization_id is null or a.ITEM_POINTS<=500)) as "联动值低于500企业数",
    (
	select 
	COUNT(1)
	from 
	dispatch.rd_company_summary org
	LEFT JOIN ( select ITEM_DOMAIN_ID,id from tlk_device where ITEM_PRODUCT_CATEGORY="00001" and  ITEM_DOMAIN_ID!="" GROUP BY ITEM_DOMAIN_ID) d on org.id = d.ITEM_DOMAIN_ID
	where
	?{isFirst!=null&&isFirst!='1', org.supervise_depart_name like CONCAT('%',#{region},'%') and }
	 d.id is null) as "无硬件设备企业数",
    (select COUNT(1) from dispatch.rd_company_summary where
	?{isFirst!=null&&isFirst!='1', supervise_depart_name like CONCAT('%',#{region},'%') and }
	 lon_lat is null) as "企业无坐标数"
"""
return db.cache('one-earlyWarning-' + region, 1000 * 60 * 1).select(sql)