<?

require("class.ImpressionTicket.php");

function print_ticket_pointage($sid,$emp,$debug=false)
{
  
  $IT= new ImpressionTicket($debug);

  $sql=new DB();


  if ($sql->query("SELECT * from session where sid='$sid'"))
    {
      if ($sql->next_row_assoc())
	{
	  $session=$sql->row;
	  $sql->free();
	}
    }
  else
    return false;


  if ($sql->query("SELECT * from enseigne where id='1'"))
    {
      if ($sql->next_row_assoc())
	{
	  $enseigne=$sql->row;
	  $sql->free();
	}
    }

  $IT->fwrite(strftime("%d/%m/%Y %H:%M"));
  $IT->ln();
  $IT->fwriteb("Ticket de pointage - S$sid");
  $IT->ln();
  $IT->fwriteb(strftime("%d/%m/%Y",strtotime($session['date_ouv'])));
  $IT->ln();
  
  
  if ($sql->query("SELECT * from personnel where id='{$emp}'"))
    {
      if ($sql->next_row_assoc())
	{
	  $employe = $sql->row;
	}
      $sql->free();
    }
  
  
  $IT->ln();
  $IT->fwrite(strtoupper($employe['nom']));
  $IT->fwrite(' ');
  $IT->fwrite(ucfirst($employe['prenom']));
  $IT->ln();
  

  $IT->fwrite(' ',5);
  $IT->fwrite('  HA ',-10);
  $IT->fwrite('  HD ',-10);
  $IT->ln();
 /*
  * La masse salariale
  */
  if ($sql->query("SELECT debut,fin,(TIME_TO_SEC(fin) - TIME_TO_SEC(debut))/3600 as temps  FROM `pointage` WHERE sid = '$sid' and employe='$emp'"))
    {

      if ($sql->numrows>0)
	{
	  while($sql->next_row_assoc())
	    {
	      $cout= round($employe['taux_horaire']*$sql->row['temps'],2);
	      
	      
	      $IT->fwrite(' ',5);
	      $IT->fwrite(strftime('%H:%M',strtotime($sql->row['debut'])),-10);
	      $IT->fwrite(strftime('%H:%M',strtotime($sql->row['fin'])),-10);
  
	      $IT->ln();
	      $t_temps+=$sql->row['temps'];
	      $t_cout+=$cout;
	    }
/*
	   $IT->fwrite('Total',-18);
	   $IT->mwrite($t_temps,6);
	   $IT->fwrite('H ');
	   $IT->mwrite($t_cout,6);
	   $IT->fwrite(' ');
	   if ($total['montant']>0)
	     $IT->mwrite($t_cout/$total['montant']*100,6);
	   $IT->fwrite('%');
	   $IT->ln();*/
	}
      else
	{
	  $IT->fwrite('Pas d\'informations de pointage.');
	  $IT->ln();
	}
      $sql->free();
    }

  $IT->ln();
    
  $IT->fwrite('Signature',30);
  $IT->ln();
  $IT->ln();
  $IT->ln();
  $IT->ln();
  $IT->ln();
  $IT->ln();
  $IT->ln();

  $IT->cut();
  $IT->close();
}


?>