<?php
include("dbconfig.php");
define('FPDF_font_path','font/');
//require('../CAR/template.php');
require('../php2stock/fpdf.php');
//
$head1 = "สรุปผลการบริการของพนักงานขับรถยนต์"  ;
$head2 = " ฝ่ายบริหารงานทั่วไป  โรงพยาบาลสั ตหีบ กม.10 "  ;
$date_p = date("d/m/").(date("Y")+543);
$pdf=new FPDF( 'P', 'mm', 'A4' );
$pdf->Open();
$pdf->AddPage(2);
$pdf->AddFont('angsa','','angsa.php');
$pdf->SetFont('angsa','',16);
$pdf->Text('120','30',$head1);  
$pdf->SetFont('angsa','',22);
$pdf->Text('100','40',$head2);
$pdf->SetFont('angsa','',16);
$pdf->Text('250','58',$date_p);
//
mysql_select_db($__db__);
mysql_query(" SET NAMES 'tis620'; ");
				$sql="select  sum(t1) as st1,sum(t2) as st2,sum(t3) as st3,sum(t4) as st4,sum(t5) as st5,sum(t6) as st6,count(driver) as cc,driver,audit.audit_id,tran.audit_id  from audit,tran where audit.audit_id = tran.audit_id  group by  driver ";
				$result=mysql_query($sql);
	$lrow=90 ;
	$row=85 ;
	$q=1 ;
	while ($object = mysql_fetch_object($result))
			{
		     $driver = $object ->driver;
			  $t1 = $object ->st1 ;
			  $t2 =$object ->st2 ;
			  $t3 = $object ->st3 ;
			  $t4 = $object ->st4 ;
			  $t5 = $object ->st5  ;
			  $t6 = $object ->st6 ;
			   $scc = $object ->cc ;
			  $sum = $t1+$t2+$t3+$t4+$t5+$t6 ;
mysql_select_db($__dbwp__);
mysql_query(" SET NAMES 'tis620'; ");
					  $sqll="select  id,name  from user  where id = '$driver'";
					   $lresult=mysql_query($sqll);
					   while ($objectl = mysql_fetch_object($lresult))
			  			{
						 $name = $objectl->name;
						 }
		
			$pdf->Text('25',$row,$name  );
			$pdf->Text('70',$row,$scc  );
			$pdf->Text('80',$row,$sum  );
			$pdf->Text('95',$row,$t1  );
			$pdf->Text('125',$row,$t2 );
			$pdf->Text('155',$row,$t3 );
	    	$pdf->Text('190',$row,$t4 );
			$pdf->Text('220',$row,$t5);
			$pdf->Text('250',$row,$t6);
			
			$pdf->line(20,$lrow, 270,$lrow);       
			$row=$row+15;
			$lrow=$lrow+15;
			$q++ ;
			}
 
//
$pdf->Text('25','70',"ชื่อพนักงานขับรถยนต์");
$pdf->Text('70','70',"ครั้ง");
$pdf->Text('80','70',"รวม");
$pdf->Text('90','70',"ตรงเวลา");
$pdf->Text('105','70',"ความพร้อมของรถ");
$pdf->Text('140','70',"ความมีน้ำใจ");
$pdf->Text('170','70',"ปฏิบัติตามกฏจราจร");
$pdf->Text('210','70',"พฤติกรรมบริการ");
$pdf->Text('240','70',"พฤติกรรมขับรถ");

$pdf->line(20, 60, 270, 60);       // Draw  line1
$pdf->line(20, 75, 270, 75);       // Draw  line2

$pdf->Output();
?>