Warning: Undefined variable $cod_temp in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 219

Warning: Undefined variable $empresa in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 220

OK. RALENTI


Warning: Undefined variable $cod_temp in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 232

Warning: Undefined variable $empresa in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 234

Warning: Undefined variable $cod_temp in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 249

Warning: Undefined variable $empresa in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 249

Warning: Undefined variable $cod_temp in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 266

Warning: Undefined variable $empresa in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 266
consultaSELECT id, objectno, REPLACE(b.patente,'-','') patente, date_format(DATE_ADD(STR_TO_DATE(start_time,'%Y-%m-%d %H:%i:%s'),INTERVAL round(cast(TIMEDIFF(NOW(),UTC_TIMESTAMP) as signed)/10000) HOUR),'%Y-%m-%dT%H:%i:%s') start_time, if(start_time!=end_time, date_format(DATE_ADD(STR_TO_DATE(end_time,'%Y-%m-%d %H:%i:%s'),INTERVAL round(cast(TIMEDIFF(NOW(),UTC_TIMESTAMP) as signed)/10000) HOUR),'%Y-%m-%dT%H:%i:%s'), date_format(DATE_ADD(STR_TO_DATE(adddate(end_time,INTERVAL 15 second),'%Y-%m-%d %H:%i:%s'),INTERVAL round(cast(TIMEDIFF(NOW(),UTC_TIMESTAMP) as signed)/10000) HOUR),'%Y-%m-%dT%H:%i:%s') ) end_time, if(start_time!=end_time, TIME_TO_SEC(timediff(end_time,start_time)), TIME_TO_SEC(timediff(adddate(end_time,INTERVAL 15 second),start_time)) ) duracion, start_speed, end_speed, min_rpm, max_rpm, start_dir, end_dir, start_odometer, end_odometer, start_latitude, start_longitude, end_latitude, end_longitude, objectuid, duration, confirmado, enviado FROM integracion_qanalytics_sotraser_rpm a JOIN integracion_qanalytics_sotraser_vehiculos b ON a.objectuid=b.nro WHERE confirmado='S' AND enviado='' AND b.empresa=''


Warning: Undefined variable $cod_temp in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 388

Warning: Undefined variable $empresa in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 389

OK. RPM


Warning: Undefined variable $empresa in /home/telemati/public_html/api/integracion_qanalytics_sotraser_eventos.php on line 414
consultaSELECT a.id,objectno,b.nro objectuid,objectname patente, -1 start_odometer, -1 end_odometer, date_format(DATE_ADD(STR_TO_DATE(start_time,'%Y-%m-%d %H:%i:%s'),INTERVAL round(cast(TIMEDIFF(NOW(),UTC_TIMESTAMP) as signed)/10000) HOUR),'%Y-%m-%dT%H:%i:%s') start_time, date_format(DATE_ADD(STR_TO_DATE(concat(DATE(start_time),' ',SEC_TO_TIME(time_to_Sec(start_time)+(round(duration/1000)))),'%Y-%m-%d %H:%i:%s'),INTERVAL round(cast(TIMEDIFF(NOW(),UTC_TIMESTAMP) as signed)/10000) HOUR),'%Y-%m-%dT%H:%i:%s') end_time, round(duration/1000) duracion, start_speed, end_speed, accel_dir,max_accel,max_accelspeed,accel_type, max_accel, latitude, longitude from integracion_qanalytics_sotraser_eventos a JOIN integracion_qanalytics_sotraser_vehiculos b ON a.objectuid=b.nro WHERE a.empresa='' and enviado='0'
OK. eventos


Terminado OK.