<?php

		

$con=mysqli_connect("localhost","raghu80504822","8050482213","Adarash_Gokak_Std");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
  
  $date = new DateTime('now', new DateTimeZone('Asia/Kolkata'));
  $date1=$date->format('d-m-Y');
  

  //first rows
  $res1=mysqli_query($con,"SELECT DISTINCT `RFId`,`TimeOfTransaction` FROM attendreports where `DateOfTransaction`='$date1'  GROUP BY RFId ");

  while($res3=mysqli_fetch_array($res1))
{

  $res5=mysqli_query($con,"SELECT * FROM `student_registration` WHERE  `RFID`='$res3[RFId]' ");
       $res6=mysqli_fetch_array($res5);
       
	mysqli_query($con,"INSERT INTO `attendence_m_report` (`RFID`, `Name`, `Class`, `Division`, `Roll_number`, `Status`, `In_Time`, `Date`) VALUES ( '$res3[RFId]', '$res6[Name]', '$res6[Class]', '$res6[Division]', '$res6[Roll_number]','PRESENT', '$res3[TimeOfTransaction]', '$date1')");
			
	
	
	$res9=mysqli_query($con,"SELECT * FROM `student_registration` WHERE  `RFID`!='$res3[RFId]' ");
       $res10=mysqli_fetch_array($res9);
       
	mysqli_query($con,"INSERT INTO `attendence_m_report` (`RFID`, `Name`, `Class`, `Division`, `Roll_number`, `Status`, `In_Time`, `Out_Time`,`Date`) VALUES ( '$res3[RFId]', '$res6[Name]', '$res6[Class]', '$res6[Division]', '$res6[Roll_number]','ABSENT', null, 'null','$date1')");
	
	

}


    $res2=mysqli_query($con,"SELECT * FROM attendreports  WHERE AttendanceId IN (SELECT MAX(AttendanceId) FROM attendreports where`DateOfTransaction`='$date1' GROUP BY RFId)");

	//last Rows
 while($res4=mysqli_fetch_array($res2))
{

       mysqli_query($con,"UPDATE `attendence_m_report` SET `Out_Time` = '$res4[TimeOfTransaction]' WHERE `attendence_m_report`.`RFID` = '$res4[RFId]'");


	}

?>