服务站电子栅栏
corp_info ,kajia_corp_info ,,efence_cfg,efence_area
电子栅栏 驶入驶出
SELECT * from kajia_vehicle_alarm_msg where ALARM ='-1'; 进入
SELECT * from kajia_vehicle_alarm_msg where ALARM ='-2'; 离开
SELECT * from kajia_vehicle_alarm_msg where bind_obj_id = 'Va9fb24e5f28490c015f2a5ad6fa0008' ORDER BY RECIVED_TIME desc ;
电子栅栏与车的距离
select round(6378.138*2*asin(sqrt(pow(sin((dph.pos_LATITUDE*pi()/180-eca.start_pos_lat*pi()/180)/2),
2)+cos(dph.pos_LATITUDE*pi()/180)*cos(eca.start_pos_lat*pi()/180)*pow(sin((dph.pos_LONGITUDE*pi()/180-eca.start_pos_long*pi()/180)/2),2)))*1000) distance,
dph.pos_LATITUDE,dph.POS_LONGITUDE,dph.RECIVED_TIME,pos_ADDRESS
from kajia_position.device_position_his1710 dph,study_base.efence_cfg ec
inner join efence_cfg_area eca on ec.efence_id=eca.efence_id
where ec.corp_id='8a9fb24e5f2fc8a7015f34802e740007' and dph.BIND_OBJ_ID='Va9fb24e5f28490c015f2a5ad6fa0008' ORDER BY RECIVED_TIME DESC;
故障码在redis 的存值方式
{
"cmd": "queryValueByKey",
"token": "201710241185581110",
"version": "1",
"params": {
"key": "康明斯-4360-3"
}
{
"cmd": "queryValueByKey",
"token": "201712122185581110",
"version": "1",
"params": {
"key": "vtc-J165688"
}
}
redis里面的跟故障码表是同步的，要么两个都有，要么两个都删
}
锁车：待执行--正在执行
task-kajia: tail -10000f com-study-service-task-kajia.log|grep -i sendInstruction
在task-kajia 查找sql
防控指令下发的网关时间
1.tail -1000000f catalina.out |grep sendGpsLockResponse 网关成功的时间
2 tail -1000000f catalina.out |grep zkcontrol 网关初次收到的原因
新鉴权接口
{
"cmd": "queryVehicleInfoFroAuth",
"token": "201712081585581110",
"version": "1",
"params": {
"sim":"",
"deviceId":"",
}
}