$value) { if($header=="PAAYASMILKAPPV1") { $httpHeader=$value; } } if($httpHeader!="MakeInGtracAppV1") { die(); }*/ if($_GET) { $masterObj = new master(); $data = array(); if(empty($_GET['token'])) { $arr=array ( 'status' => 0, 'message' => "Feilds are Empty. Kindly Check.", ); array_push($data,$arr); } else { //veh_id=186488&veh_reg=RJ14GQ8345&alertype=Freewheeling&userid=81707&startdatetime=2026-02-20 00:00:00&enddatetime=2026-02-27 23:59:59&token=53823 $groupid = addslashes($_GET['token']); $veh_id = addslashes($_GET['veh_id']); $alertype = addslashes($_GET['alertype']); $startdatetime = addslashes($_GET['startdatetime']); $enddatetime = addslashes($_GET['enddatetime']); $showAll = isset($_GET['showAll']) ? addslashes($_GET['showAll']) : null; if($groupid=="54470" || $groupid=="59278" || $groupid=="50225" ) { $groupid = 6364; } if($alertype=="Freewheeling") { $query = "SELECT TRIM(SUBSTRING_INDEX( SUBSTRING_INDEX(a.msg, 'since ', -1), ' to', 1 )) AS starttime, TRIM(SUBSTRING_INDEX( SUBSTRING_INDEX(a.msg, ' to ', -1), ',Duration', 1 )) AS endtime, a.vehicleno AS vehicle_no,'Free Wheeling' AS exception_type, '' AS startlocation, a.gps_latitude AS startlat, a.gps_longitude AS startLong, a.gps_latitude AS endlat, a.gps_latitude AS endLong, '' AS endlocation, '' AS KM, CONCAT(ROUND(1/60), ' Min') AS duration, 0 AS speed, a.sys_service_id AS veh_id, 1 AS rn FROM alert_bank a WHERE a.alert_type = 'freewheeling' AND a.group_id = '$groupid' AND a.created_at BETWEEN '$startdatetime' AND '$enddatetime' AND a.sys_service_id = '$veh_id'; "; } else { $query = "SELECT a.id AS alert_id, a.alert_type, a.vehicleno, a.sys_service_id, a.msg, a.created_at AS datetime, '1' AS alertcount, a.issue, a.gps_time FROM alert_bank a WHERE a.group_id = '$groupid' AND a.created_at BETWEEN '$startdatetime' AND '$enddatetime' AND a.sys_service_id = '$veh_id' AND a.alert_type = '$alertype' ORDER BY datetime DESC LIMIT 2000;"; } $getalrts=db__select_staging($query); // $getalrts = $masterObj->getAlertsforpopupsall($groupid); function utf8ize($mixed) { if (is_array($mixed)) { foreach ($mixed as $key => $value) { $mixed[$key] = utf8ize($value); } } else if (is_string($mixed)) { return mb_convert_encoding($mixed, 'UTF-8', 'UTF-8'); } return $mixed; } //print_r($getalrts);die; if(count($getalrts)>0) { //echo "

";
                $getalrts = utf8ize($getalrts);
echo json_encode($getalrts, JSON_UNESCAPED_UNICODE);
die;

                /*echo json_encode($getalrts);
                echo json_last_error_msg();
                die;*/
            }
            else
            {
                $arr=array (
                    'status'             => 404,
                    'message'            => "No Alerts Found.",
                );
                array_push($data,$arr);
            }
        
        
        
    }
    
    echo json_encode($data);
    
    
}

?>