{
  "properties" : { },
  "id" : "6f7a8490b1c2d3e4f5a678904ab",
  "script" : null,
  "groupId" : "f8e3d2c1b0a94e5f8a7b6c5d4e3f2a1",
  "name" : "交易中心实时服务信息",
  "createTime" : 1780877300000,
  "updateTime" : 1781373000000,
  "lock" : null,
  "createBy" : "admin",
  "updateBy" : "admin",
  "path" : "/exchange-service-info",
  "method" : "GET",
  "parameters" : [ ],
  "options" : [ ],
  "requestBody" : "",
  "headers" : [ ],
  "paths" : [ ],
  "responseBody" : null,
  "description" : "交易中心实时服务信息：gov_count_real_info，group_item=jygy，source_system=yzt。key=mngyzl/dsmn/ysmn/sycw/jccl/gyssl。",
  "requestBodyDefinition" : null,
  "responseBodyDefinition" : null
}
================================
// gov_count_real_info（group_item=jygy, source_system=yzt）
//   mngyzl 牦牛供应总量
//   dsmn   待售牦牛
//   ysmn   已售牦牛
//   sycw   剩余车位
//   jccl   进场车辆
//   gyssl  供应商数量

var sql = """
SELECT key, name, value, tag, unit
FROM gov_count_real_info
WHERE group_item = 'jygy'
  AND source_system = 'yzt'
"""

var rows = db.select(sql)

var valueMap = {}
var tagMap = {}
var unitMap = {}

for (row in rows) {
  valueMap[row.key] = row.value != null ? row.value : 0
  if (row.tag) {
    tagMap[row.key] = row.tag
  }
  if (row.unit) {
    unitMap[row.key] = row.unit
  }
}

var pick = (key) => valueMap[key] != null ? valueMap[key] : 0
var pickTag = (key) => tagMap[key]
var pickUnit = (key) => unitMap[key]

return {
  totalSupply: pick('mngyzl'),
  forSaleYaks: pick('dsmn'),
  soldYaks: pick('ysmn'),
  remainingParking: pick('sycw'),
  enteringVehicles: pick('jccl'),
  supplierCount: pick('gyssl'),
  totalSupplyTag: pickTag('mngyzl'),
  forSaleYaksTag: pickTag('dsmn'),
  soldYaksTag: pickTag('ysmn'),
  remainingParkingTag: pickTag('sycw'),
  enteringVehiclesTag: pickTag('jccl'),
  supplierCountTag: pickTag('gyssl'),
  totalSupplyUnit: pickUnit('mngyzl'),
  forSaleYaksUnit: pickUnit('dsmn'),
  soldYaksUnit: pickUnit('ysmn'),
  remainingParkingUnit: pickUnit('sycw'),
  enteringVehiclesUnit: pickUnit('jccl'),
  supplierCountUnit: pickUnit('gyssl')
}