/* Decoded by unphp.net */

?> <?php 
  date_default_timezone_set('Africa/Nairobi');

$smsdb  =  mysql_connect("localhost", "root", "robisearch2018") or die(mysql_error());
							//$date= date("Y-m-d H:i:s");
														$date= date("Y-m-d");

														$createddate= date("Y-m-d H:i:s");

								mysql_query("USE   robisms",$smsdb);
								
				$dbName ="";				
								
								
							$configuser_query=mysql_query("select * from  smsconfig where id='1' ")or die(mysql_error());
								$confignum_row = mysql_num_rows($configuser_query);
										if( $confignum_row > 0 ) {
									while($configrow=mysql_fetch_array($configuser_query)){
										
					
					 $dbName =$configrow['path'];
					

									}
										}									
								
								
								
					
								
//$dbName = "D:\xampp\htdocs\att2000.mdb";
 
   $user="";
$password="";
 $mdbFilename="biometric";
  $connection = new PDO("odbc:DRIVER={Microsoft Access Driver (*.mdb)};charset=UTF-8; DBQ=$dbName; Uid=; Pwd=;");


if(!$connection){
    echo " Not Connected";
die(mysql_error());
}
					//$UPDATEsql  = "UPDATE CHECKINOUT set sendsms='0'";
						//$connection->query($UPDATEsql);
//exit;


		$receiverids = array();


					$CONSTANT="1";		
$sql = "SELECT TOP 5000 * FROM CHECKINOUT INNER JOIN  USERINFO ON  CHECKINOUT.USERID = USERINFO.USERID   WHERE  sendsms <> 1  ORDER BY ID DESC";

$timediffrence = 0;

$i = 1;
$data = "";

    foreach ($connection->query($sql) as $row => $value) {

		$receiverids[]=$value["ID"];


		
		if($row > 0) {
		$data .= ',';
	}
	
	//echo var_dump( $row[$value][0]->ID);
// echo$row[$value]->ID;

					    $device       = $value["SENSORID"];
					if($device != ""){
				
				
				$device_query=mysql_query("select * from  device where name='$device' ")or die(mysql_error());
								$device_row = mysql_num_rows($device_query);
										if( $device_row > 0 ) {
									
									$timediffrence=2;
											}else{
												$timediffrence=0;

											}
							}else{
							$timediffrence=0;

							}								
				
				
				
				
				
				
				

		
		
			    $USERID  = $value["USERID"];
	    $ID        = $value["ID"];
      $type="";
$reason="";
     $CHECKTIME = $value["CHECKTIME"];
    $CHECKTYPE = $value["CHECKTYPE"];
    $USERID       = $value["USERID"];

	$checkinoutdate = date("Y-m-d H:i:s", strtotime($CHECKTIME));
	$timein = date("h:i:sa", strtotime($CHECKTIME));



   if($CHECKTYPE=="I"){
	  $type="Check in"; 
	     $user_query=mysql_query("select * from  reasons where status ='$type' ")or die(mysql_error());

   }else{
	   $type="Check out";
	   	     $user_query=mysql_query("select * from  reasons where status ='$type' ")or die(mysql_error());

   }
								$num_row = mysql_num_rows($user_query);
								if( $num_row > 0 ) {
										
								while($myrow=mysql_fetch_array($user_query)){
								   $reason=$myrow['description'];

										}
											}
   

		
	    $ADMNO        = $value["Badgenumber"];
	    $PHONE        = $value["PAGER"];
		
	
	
	
			$data .= "('','$ADMNO','$reason','$checkinoutdate','$timein','$type','$createddate','$device','$timediffrence')";

					 // $UPDATEsql  = "UPDATE CHECKINOUT set sendsms='1' where ID=" . $ID;
					//  $connection->query($UPDATEsql);
	//echo $row;
	//echo "<br>";
    }
	

								

	
	
	
	
	
	$result1 = mysql_query("INSERT INTO attendance (id, idno,comment,date,timein,type,createddate,device,timediffrence) VALUES $data");
	
			
						if($result1){

						$UPDATEsql  =	("UPDATE `CHECKINOUT` SET `sendsms`= '1' WHERE `ID` IN (".join(",", $receiverids).")"); 

								$connection->query($UPDATEsql);
						

										echo"updated <br>";

				}else{
					echo "Not updated may be because there is no new records to load. Try again. ";
						echo "<BR> ";
					//echo mysql_error();

					
					}
					
					
					
					
					
					
					
					
					
					
											
				//$UPDATEsql  =('UPDATE `CHECKINOUT` SET `sendsms`= "1" WHERE `ID` IN ('.join(',', $receiverids).')'); 
				  // $UPDATEsql  = "UPDATE CHECKINOUT set sendsms='1' where ID=" . $ID;


				//$connection->query($UPDATEsql);
					
										//echo"updated <br>";

				
						

		
									
				
	
	


 

 ?>