大屏总览
城市签约数排行
公司ID/城市名（来源企业）/签约数/TOP10
接口：http://pai.flyrise.cn/screen-manager-api/screen/get
输入：
{
"ComAddressStatis[]": {
"page": 0,
"count": 10,
"ComAddressStatis": {
"com_id": "1",
"type": "签约",
"@column": "province,city,city_code,type,value",
"@order": "value-,id+"
}
}
}输出：
{
"ComAddressStatis[]": [
{
"province": "广东省",
"city": "广州市",
"city_code": "440100",
"type": "签约",
"value": 90
},
{
"province": "广东省",
"city": "珠海市",
"city_code": "440400",
"type": "签约",
"value": 85
},
{
"province": "黑龙江省",
"city": "齐齐哈尔市",
"city_code": "230200",
"type": "签约",
"value": 80
},
{
"province": "黑龙江省",
"city": "牡丹江市",
"city_code": "231000",
"type": "签约",
"value": 75
},
{
"province": "内蒙古自治区",
"city": "呼和浩特市",
"city_code": "150100",
"type": "签约",
"value": 70
},
{
"province": "重庆市",
"city": "重庆市",
"city_code": "500000",
"type": "签约",
"value": 65
},
{
"province": "广东省",
"city": "中山市",
"city_code": "442000",
"type": "签约",
"value": 63
},
{
"province": "广东省",
"city": "佛山市",
"city_code": "440600",
"type": "签约",
"value": 61
},
{
"province": "广东省",
"city": "江门市",
"city_code": "440700",
"type": "签约",
"value": 60
},
{
"province": "广东省",
"city": "汕头市",
"city_code": "440500",
"type": "签约",
"value": 55
}
],
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "10|9|1|200",
"depth:count|max": "3|5",
"time:start|duration|end": "1600155619724|40|1600155619764"
}年度项目走势
公司ID/年份+月份（最近6个月）/类型（新增/跟进/签约）/数量
接口：http://pai.flyrise.cn/screen-manager-api/screen/get
输入：
{
"ComMonthStatis[]": {
"page": 0,
"count": 6,
"ComMonthStatis": {
"com_id": "1",
"type": "项目", #或"跟进"或"签约"
"@column": "date_format(month,%Y-%m):month;type,value",
"@order": "month-"
}
}
}输出：
{
"ComMonthStatis[]": [
{
"month": "2020-09",
"type": "签约",
"value": 100
},
{
"month": "2020-08",
"type": "签约",
"value": 50
},
{
"month": "2020-07",
"type": "签约",
"value": 50
},
{
"month": "2020-06",
"type": "签约",
"value": 50
},
{
"month": "2020-05",
"type": "签约",
"value": 50
},
{
"month": "2020-04",
"type": "签约",
"value": 50
}
],
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "6|5|1|200",
"depth:count|max": "3|5",
"time:start|duration|end": "1600141399302|49|1600141399351"
}签约总数
公司ID/类型（项目总数/跟进总数/签约总数/入驻总数）/总数
接口：http://pai.flyrise.cn/screen-manager-api/screen/get
输入：
{
"ComMonthStatis[]": {
"ComMonthStatis": {
"com_id": "1",
"@column": "type;sum(value):value",
"@group": "type"
}
}
}输出：
{
"ComMonthStatis[]": [
{
"type": "入驻",
"value": 50
},
{
"type": "签约",
"value": 500
},
{
"type": "跟进",
"value": 450
},
{
"type": "项目",
"value": 1800
}
],
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "5|4|1|200",
"depth:count|max": "3|5",
"time:start|duration|end": "1600141552697|43|1600141552740"
}全国招商分布图
公司ID/省份/城市/数量（项目数量）
接口：http://pai.flyrise.cn/screen-manager-api/screen/get
输入：
{
"ComAddressStatis[]": {
"page": 0,
"count": 100,
"ComAddressStatis": {
"com_id": "1",
"type": "项目",
"@column": "province,city,type,value",
"@order": "value-,id+"
}
}
}输出：
{
"ComAddressStatis[]": [
{
"province": "广东省",
"city": "广州市",
"type": "项目",
"value": 90
},
{
"province": "广东省",
"city": "珠海市",
"type": "项目",
"value": 85
},
{
"province": "黑龙江省",
"city": "齐齐哈尔市",
"type": "项目",
"value": 80
},
{
"province": "黑龙江省",
"city": "牡丹江市",
"type": "项目",
"value": 75
},
{
"province": "内蒙古自治区",
"city": "呼和浩特市",
"type": "项目",
"value": 70
},
{
"province": "重庆市",
"city": "重庆市",
"type": "项目",
"value": 65
},
{
"province": "广东省",
"city": "中山市",
"type": "项目",
"value": 63
},
{
"province": "广东省",
"city": "佛山市",
"type": "项目",
"value": 61
},
{
"province": "广东省",
"city": "江门市",
"type": "项目",
"value": 60
},
{
"province": "广东省",
"city": "汕头市",
"type": "项目",
"value": 55
}
],
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "10|9|1|200",
"depth:count|max": "3|5",
"time:start|duration|end": "1600072044130|180|1600072044310"
}本月签约状态
公司ID/年份+月份/项目类型（入库（项目）/跟进/签约）/数量
接口：http://pai.flyrise.cn/screen-manager-api/screen/get
输入：
{
"ComMonthStatis[]": {
"ComMonthStatis": {
"com_id": "1",
"show":true,
"month": "2020-09-01",
"@column": "type,value",
"@order": "value-,id+"
}
}
}输出：
{
"ComMonthStatis[]": [
{
"type": "项目",
"value": 200
},
{
"type": "跟进",
"value": 50
},
{
"type": "签约",
"value": 50
}
],
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "4|3|1|200",
"depth:count|max": "3|5",
"time:start|duration|end": "1600075252291|173|1600075252464"
}本月签约环比
公司ID/年份+月份+日期/数量
接口：http://pai.flyrise.cn/screen-manager-api/screen/get
输入：
{
"ComDailyStatis[]": {
"page": 0,
"count": 31,
"ComDailyStatis": {
"com_id": "1",
"type": "签约",
"day%": "2020-09-01,2020-09-31",
"@column": "day,value",
"@order": "day+"
}
}
}
`输出：
{
"ComDailyStatis[]": [
{
"day": "2020-09-01",
"value": 1
},
{
"day": "2020-09-02",
"value": 1
},
{
"day": "2020-09-03",
"value": 1
},
{
"day": "2020-09-04",
"value": 1
},
{
"day": "2020-09-05",
"value": 1
},
{
"day": "2020-09-06",
"value": 1
},
{
"day": "2020-09-07",
"value": 1
},
{
"day": "2020-09-08",
"value": 1
},
{
"day": "2020-09-09",
"value": 1
},
{
"day": "2020-09-10",
"value": 1
},
{
"day": "2020-09-11",
"value": 1
},
{
"day": "2020-09-12",
"value": 1
},
{
"day": "2020-09-13",
"value": 1
},
{
"day": "2020-09-14",
"value": 1
},
{
"day": "2020-09-15",
"value": 1
},
{
"day": "2020-09-16",
"value": 1
},
{
"day": "2020-09-17",
"value": 1
},
{
"day": "2020-09-18",
"value": 1
},
{
"day": "2020-09-19",
"value": 1
},
{
"day": "2020-09-20",
"value": 1
},
{
"day": "2020-09-21",
"value": 1
},
{
"day": "2020-09-22",
"value": 1
},
{
"day": "2020-09-23",
"value": 1
},
{
"day": "2020-09-24",
"value": 1
},
{
"day": "2020-09-25",
"value": 1
},
{
"day": "2020-09-26",
"value": 1
},
{
"day": "2020-09-27",
"value": 1
},
{
"day": "2020-09-28",
"value": 1
},
{
"day": "2020-09-29",
"value": 1
},
{
"day": "2020-09-30",
"value": 1
}
],
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "31|30|1|200",
"depth:count|max": "3|5",
"time:start|duration|end": "1600073693288|624|1600073693912"
}本月签约排行
公司ID/年份+月份/部门/数量
接口：http://pai.flyrise.cn/screen-manager-api/screen/get
输入：
{
"ComDepartmentStatis[]": {
"page": 0,
"count": 5,
"ComDepartmentStatis": {
"com_id": "1",
"type": "签约",
"month": "2020-09-01",
"@column": "department,value",
"@order": "value-,id+"
}
}
}输出：
{
"ComDepartmentStatis[]": [
{
"department": "珠海一部",
"value": 100
},
{
"department": "珠海二部",
"value": 70
},
{
"department": "北京二部",
"value": 50
},
{
"department": "珠海三部",
"value": 30
},
{
"department": "北京一部",
"value": 10
},
{
"department": "上海一部",
"value": 10
}
],
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "7|6|1|200",
"depth:count|max": "3|5",
"time:start|duration|end": "1600073324530|250|1600073324780"
}数据接口
数据输入接口
接口:http://pai.flyrise.cn/screen-manager-api/screen/post
输入：
{
"ComTimeStatis[]": [
{
"com_id": "1",
"department": "珠海一部",
"province": "广东省",
"city": "珠海市",
"day": "2020-09-15 11:03:46",
"type": "项目",
"value": 1,
"create_time": "2020-09-15 11:04:05",
"update_time": "2020-09-15 11:04:06"
},
{
"com_id": "1",
"department": "珠海一部",
"province": "广东省",
"city": "珠海市",
"day": "2020-09-15 11:03:46",
"type": "跟进",
"value": 1,
"create_time": "2020-09-15 11:04:05",
"update_time": "2020-09-15 11:04:06"
},
{
"com_id": "1",
"department": "珠海一部",
"province": "广东省",
"city": "珠海市",
"day": "2020-09-15 11:03:46",
"type": "签约",
"value": 1,
"create_time": "2020-09-15 11:04:05",
"update_time": "2020-09-15 11:04:06"
},
{
"com_id": "1",
"department": "珠海一部",
"province": "广东省",
"city": "广州市",
"day": "2020-09-15 11:03:46",
"type": "入驻",
"value": 1,
"create_time": "2020-09-15 11:04:05",
"update_time": "2020-09-15 11:04:06"
}
],
"tag": "ComTimeStatis"
}输出：
{
"ComTimeStatis": {
"ok": true,
"code": 200,
"msg": "success",
"count": 4,
"id[]": [
1600139371982,
1600139372198,
1600139372239,
1600139372284
]
},
"tag": "ComTimeStatis",
"ok": true,
"code": 200,
"msg": "success",
"sql:generate|cache|execute|maxExecute": "4|0|4|200",
"depth:count|max": "2|5",
"time:start|duration|end": "1600139371981|357|1600139372338"
}文档更新时间: 2021-05-25 16:14 作者：伍润源
