"avlt", "PWD" => "gvkavlt321$", "Database"=>"AVLT_UP");
//$connectionInfo = array("UID" => "sa", "PWD" => "emriup321$", "Database"=>"AVLTUP");
// Connect to MSSQL
//$link = sqlsrv_connect($serverName, $connectionInfo);
$link2=sqlsrv_connect($serverName1, $connectionInfo);
if (!$link2) {
echo ":::::::::: hiii ::::::::::::";
mail('support@glovision.co', '102 GVK server connection', ' DB connection failed'.$serverName1.'');
die('Something went wrong while connecting to MSSQL'.sqlsrv_errors());
}
/*
$databaseb='AVLTUP';
$db_selected = sqlsrv_select_db($databaseb, $link);
if (!$db_selected) {
die ('Can\'t use db : ' . sqlsrv_errors());
} */
/*
$server1_sims=array();
if($link){
if(($result = sqlsrv_query($link,"SELECT SIM_ID FROM T_LatestData")) !== false){
while( $obj = sqlsrv_fetch_object( $result )) {
$server1_sims[count($server1_sims)]=$obj->SIM_ID;
}
}
}
*/
$server2_sims=array();
$cnt=0;
if($link2){
if(($result1 = sqlsrv_query($link2,"SELECT SIM_ID, Sent_Time, Rec_Time, Latitude, Longitude, Speed,VehicleNumber FROM T_LatestData")) !== false){
while( $obj = sqlsrv_fetch_object( $result1 )) {
$server2_sims[count($server2_sims)]=$obj->SIM_ID;
// $cnt++;
$eventtime=strtotime($obj->Rec_Time->format('d-m-Y H:i:s'));
if(abs($eventtime-time())<60){
$cnt++;
// echo $obj->SIM_ID." ".$obj->VehicleNumber." Rec:".($obj->Rec_Time->format('d-m-Y H:i:s'))."
";
}
// echo $obj->SIM_ID." ".$obj->VehicleNumber." Rec:".($obj->Rec_Time->format('d-m-Y H:i:s'))."
";
}
}
}
//sqlsrv_close($link);
sqlsrv_close($link2);
if($cnt<=1000){
$a="";
$a1=[];
$file = file("/var/www/html/102pushdata/file.txt");
for ($i = max(0, count($file)-1); $i < count($file); $i++) {
if($file[$i]==""){
$a=$file[$i-1] . "\n";
}else{
$a=$file[$i] . "\n";
}
}
$a1 = explode(" ", $a);
$b="";
$b1=[];
$source = file_get_contents("http://up102.glovision.co/102pushdata/file.txt");
$filearray = explode("\n", $source);
for ($i = max(0, count($filearray)-1); $i < count($filearray); $i++) {
if($filearray[$i]==""){
$b=$filearray[$i-1] . "\n";
}else{
$b=$filearray[$i] . "\n";
}
}
$b1 = explode(" ", $b);
$c="";
$c1=[];
$source = file_get_contents("http://als.glovision.co/up102pushdata/file2.txt");
$filearray = explode("\n", $source);
for ($i = max(0, count($filearray)-1); $i < count($filearray); $i++) {
if($filearray[$i]==""){
$c=$filearray[$i-1] . "\n";
}else{
$c=$filearray[$i] . "\n";
}
}
$c1 = explode(" ", $c);
$total=$a1[0]+$b1[0]+$c1[0];
mail('support@glovision.co', ''.$cnt.'(AVLT) = Total - '.$total.'('.$a1[0].'(UP102EAST)+'.$b1[0].'(UP102WEST)+'.$c1[0].'(BACKUP))', 'Less than 1000 vehicles are getting updated '.$serverName1.'Number of vehicles updating in AVLT server - '.$cnt.'-'.time().' Vehicle count read in Up102east '.$a1[0].'-'.$a1[1].' Vehicle count read in Up102west '.$b1[0].'-'.$b1[1].' Vehicle count read in ALS BACKUP '.$c1[0].'-'.$c1[1].'');
//mail('support@glovision.co', 'Vehicle not updating properly in server 102', 'Less than 1000 vehicles are getting updated '.$serverName1.' AVLT '.$cnt.' Up102east '.$a1[0].'-'.$a1[1].' Up102west '.$b1[0].'-'.$b1[1].'');
}
echo "With in 1 mints:".$cnt."===Count";
echo count($server2_sims);
unset($arr);
error_log('end ');
?>