<?php

include "connetti.php";

$giorno=date(j);
$mese=date(n);
$anno=date(Y);
$ora=date(H);
$minuti=date(i);
$secondi=date(s);
$Data=$anno.'-'.$mese.'-'.$giorno;
$orario=$ora.':'.$minuti.':'.$secondi;
$a=0;



$orario1=$a.$a.':'.$a.$a.':'.$a.$a;

//echo $orario1;

//echo $giorno."-".$mese."-".$anno;
$Querycheck= "SELECT * from turno WHERE (username='".$_POST["user"]."') AND (data ='$Data') AND (orauscita = '".$orario1."');";

	$Query = "UPDATE turno set orauscita=CURTIME() WHERE (username='".$_POST["user"]."') AND (data ='$Data') AND (orauscita = '".$orario1."');";

	$Querycheck1= "SELECT * from impiegato WHERE (username= '".htmlspecialchars($_POST["user"])."') AND (password ='".htmlspecialchars($_POST['password'])."');";

$firstquery = mysql_query($Querycheck1);
  if(mysql_num_rows($firstquery) == 1){


        $Rescheck=mysql_query($Querycheck);

	if(mysql_num_rows($Rescheck) == 1){

		$Res = mysql_query($Query);
		$rows =  mysql_query("select * from turno where (orauscita='".$orario."') and (data = '".$Data."') and (username='".$_POST['user']."');");
		$row = mysql_fetch_assoc($rows);

		echo "ore di lavoro effettive: ".(date("H",strtotime($row['oraingresso']))-date("H",strtotime($row['orauscita']))).":".abs(date("i",strtotime($row['oraingresso']))-date("i",strtotime($row['orauscita']))).":".abs(date("s",strtotime($row['oraingresso']))-date("s",strtotime($row['orauscita'])));


		$minute = abs(date("i",strtotime($row['oraingresso']))-date("i",strtotime($row['orauscita'])));
		$hour = abs(date("H",strtotime($row['oraingresso']))-date("H",strtotime($row['orauscita'])))+($minute>45?1:0);
		if($minute > 45)
		  $minute = 0;
		else if($minute < 45 && $minute > 30)
		  $minute = 30;
		else if($minute < 15)
		  $minute = 0;
		else if($minute > 15 && $minute < 30)
		  $minute = 15;

		echo "<br>ore di lavoro approssimate: ".$hour.":".$minute.":0";



		print("<h2><b>Turno terminato, adesso compila la commessa:</b></h2>");
	  	echo "<br><br><br><br>";
include "comm2.php";
	}
	else

	if(mysql_num_rows($Rescheck) == 0){
	  print("prima effettua l ingresso");
	}
	else{

	  echo "username o password errati";
	}
  }

?>