| Vehicle Number | Transporter Name | Halted Since | Halted Hours | Subuser Name | Current Location |
';
//
$stmt2 = $mysqlimatrix62->prepare("SELECT latest_telemetry.sys_service_id as sys_service_id, latest_telemetry.sys_proc_host as sys_proc_host ,adddate(lastspeed_row.gps_time, interval 330 minute) as lastspeedupdate, TIMESTAMPDIFF(hour, adddate(lastspeed_row.gps_time, interval 330 minute), NOW()) AS idelhrs, latest_telemetry.gps_latitude as gps_latitude, latest_telemetry.gps_longitude as gps_longitude FROM lastspeed_row left join matrix.latest_telemetry on lastspeed_row.sys_service_id=latest_telemetry.sys_service_id WHERE lastspeed_row.sys_service_id in(".$_SESSION['vehId1'].") AND adddate(lastspeed_row.gps_time, interval 330 minute) <= now() - interval 12 HOUR AND latest_telemetry.gps_latitude != 0 and latest_telemetry.gps_longitude != 0 ORDER BY lastspeed_row.gps_time DESC");
$stmt2->execute();
$stmt2->store_result();
$stmt2->bind_result($sys_service_id,$transporter,$lastspeedupdate,$idelhrs,$gps_latitude,$gps_longitude);
/*$stmt2 = $mysqlimatrix62->prepare("SELECT id, sys_service_id, adddate(gps_time, interval 330 minute) as lastupdate, TIMESTAMPDIFF(hour, adddate(gps_time, interval 330 minute), NOW()) AS notworkinghrs, gps_latitude, gps_longitude FROM latest_telemetry WHERE sys_service_id IN (".$_SESSION['vehId1'].") AND adddate(gps_time, interval 330 minute) <= now() - interval 12 HOUR AND adddate(gps_time, interval 330 MINUTE) >= now() - INTERVAL 49 HOUR ORDER BY gps_time DESC ");
$stmt2->execute();
$stmt2->store_result();
$stmt2->bind_result($lsid,$sys_service_id,$lastupdate,$notworkinghrs,$gps_latitude,$gps_longitude);*/
$num_alertsuserwise = $stmt2->num_rows;
if($num_alertsuserwise > 0) {
while($stmt2->fetch()){
/*echo "SELECT veh_reg FROM services WHERE id = ".$sys_service_id." ";
echo "1-". $sys_service_id; echo "
";
echo "2-". $transporter; echo "
";
echo "3-". $lastspeedupdate; echo "
";
echo "4-". $idelhrs; echo "
";
echo "5-". $gps_latitude; echo "
";
echo "6-". $gps_longitude; echo "
";*/
//echo $gps_latitude.'-'.$gps_longitude;echo "
";
$stmt3 = $mysqlimatrix62->prepare("SELECT veh_reg FROM services WHERE id = ".$sys_service_id." ");
$stmt3->execute();
$stmt3->bind_result($veh_reg);
//$vehnos = array();
while ($stmt3->fetch()){
//echo $idelhrs;echo "
";
if($idelhrs<49)
{
$hrsarray = array(12);
//if(in_array($idelhrs,$hrsarray))
if($idelhrs>=12)
{
$SubuserGroup = db__select("select group_concat(name separator ',') as subusers from group_services left join `group` on group_services.sys_group_id=`group`.id where sys_Service_id=".$sys_service_id." and sys_group_id not in (1998,53627)");
if($_SERVER['HTTP_HOST'] == 'localhost')
{
$Location = '';
}
else
{
$Location = $masterObj->GetLocationWitPOIwithoutlatlong($gps_latitude.','.$gps_longitude);
}
if($idelhrs>=12)
{
$hr12 = 1;
$msg1.= ' | '.$veh_reg.' | '.$transporter.' | '.$lastspeedupdate.' | '.$idelhrs.' | '.$SubuserGroup[0]["subusers"].' | '.$Location.' |
';
$success_insert = $mysqli235->prepare("INSERT INTO alert_bank (user_id,group_id,Username,alert_type,vehicleno,sys_service_id,gps_latitude,gps_longitude,number,email,msg,created_at,sent_at,status,email_status,aws_msg_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
//$user_Id=85182;
//$group_Id=57407;
$user_Id=85086;
$group_Id=57310;
$sys_username="Alumina";
$SetAlertType="idle";
$vehiclestr=$veh_reg;
$veh_id=$sys_service_id;
$veh_id=$sys_service_id;
$latitude=0.0;
$longitude=0.0;
$mobile_No=9971805001;
$email_id="priya@gtrac.in";
$message='Vehicle : '.$vehiclestr.' halted since last ,'.$idelhrs.' hours , Location: '.$Location.' ';
$def_empty = '';
$def_status = 0;
$def_status1 = 1;
$def_status1_str = '1';
$def_status2 = 2;
$def_status3 = 3;
$currentdatetime = date("Y-m-d H:i:s");
$success_insert->bind_param('ssssssssssssssss',$user_Id,$group_Id,$sys_username,$SetAlertType,$vehiclestr,$veh_id,$latitude,$longitude,$mobile_No,$email_id,$message,$currentdatetime,$currentdatetime,$def_status,$sentstatus,$aws_emailsentid);
$success_insert->execute();
$success_insert->close();
}
/*if($idelhrs==24)
{
$hr24 = 1;
$msg2.= ' | '.$veh_reg.' | '.$lastspeedupdate.' | '.$idelhrs.' | '.$SubuserGroup[0]["subusers"].' | '.$Location.' |
';
}
if($idelhrs>=48)
{
$hr48 = 1;
$msg3.= ' | '.$veh_reg.' | '.$lastspeedupdate.' | '.$idelhrs.' | '.$SubuserGroup[0]["subusers"].' | '.$Location.' |
';
}*/
}
}
}
$stmt3->close();
}
}
if($hr12==1)
{
$msg1.= "
";
$Subject="Halting";
$body = "Dear Sir,