monthly_genbillpdf1.php

 <?php  

//CREATED BY: Monika Gautam
//E-MAIL: monika315gtm@gmail.com

require('fpdf.php');
//Connecting to the database
 $dbhandle = mysqli_connect("localhost", "root", "123456","cabBills")
       or die("Unable to connect to MySQL");
  
                $id = $_POST['id'];      



										   
 
 $sql3="select * from employee where id='".$id."'";
            
           $result1 =mysqli_query($dbhandle,$sql3);
		   $number_of_rows1 = mysqli_num_rows($result1);
           while ($row1 = mysqli_fetch_array($result1,MYSQLI_NUM)) 
                                {     
                                     
                                    $name=$row1{1};
                                   
                                   $acc=$row1{2}; 
                                   $manager=$row1{3}; 
                                   $exp=$row1{4}; 
                                   $pmtdt=$row1{5}; 
           }

		   //Initialize the 9 columns and the total
$column_itemno = "";
$column_date = "";
$column_desc = "";
$column_code = "";
$column_curr = "";
$column_amt = "";
$column_rate = "";
$column_amtAED = "";

$column_itemno1 = "";
$column_date1 = "";
$column_desc1 = "";
$column_code1 = "";
$column_curr1 = "";
$column_amt1 = "";
$column_rate1 = "";
$column_amtAED1 = "";
//$column_sdt = "";
	   $sql4="select * from temp_collectdata LIMIT 0,25";
	  $sql5="select * from temp_collectdata LIMIT 26,19";
      $result2=mysqli_query($dbhandle,$sql4);
	  $result3=mysqli_query($dbhandle,$sql5);
	  $number_of_rows3 = mysqli_num_rows($result3);
	  $number_of_rows2 = mysqli_num_rows($result2);
           $item=1; 
           $aed=0;
		   $total2=0.00;
		   $pos=0;
		   $aed1=0;
		   $total1=0.00;
		   $total=0.00;
//For each row, add the field to the corresponding column
while($row = mysqli_fetch_array($result2,MYSQLI_NUM)) 
{
	
    $dbdate=$row{0};
								   
    $dbbrdtm=$row{1};
    $dbamt=$row{2};
    $dbrate=$row{3};
   
	   if(strcmp($dbbrdtm,"Morning")==0)
		   $cabstr="Cab Pickup Charges";
	    else
			$cabstr="Cab Drop Charges";
	$column_itemno = $column_itemno.$item."\n";
    $column_date = $column_date.$dbdate."\n";
    $column_desc = $column_desc.$cabstr." - ".$dbbrdtm."\n";
    $column_code = $column_code."--- "."\n";
    $column_curr = $column_curr." INR "."\n";
    $column_amt = $column_amt.$dbamt."\n";
    $column_rate = $column_rate.$dbrate."\n";
	
	//$aed=  floatval($dbamt)*floatval($dbrate);
	//$aed=  $dbamt*$dbrate;
	$aed=  number_format(($dbamt*$dbrate), 2,'.', '');
	$total2=number_format(($total2+$aed), 2,'.', '');
    $column_amtAED = $column_amtAED.$aed."\n";
  
	
    
    $item=$item+1;   
}


$item1=26;
while($row1 = mysqli_fetch_array($result3,MYSQLI_NUM)) 
{
	
    $dbdate1=$row1{0};
								   
    $dbbrdtm1=$row1{1};
    $dbamt1=$row1{2};
    $dbrate1=$row1{3};
   
	   if(strcmp($dbbrdtm1,"Morning")==0)
		   $cabstr1="Cab Pickup Charges";
	    else
			$cabstr1="Cab Drop Charges";
	$column_itemno1 = $column_itemno1.$item1."\n";
    $column_date1 = $column_date1.$dbdate1."\n";
    $column_desc1 = $column_desc1.$cabstr1." - ".$dbbrdtm1."\n";
    $column_code1 = $column_code1."--- "."\n";
    $column_curr1 = $column_curr1." INR "."\n";
    $column_amt1 = $column_amt1.$dbamt1."\n";
    $column_rate1 = $column_rate1.$dbrate1."\n";
	
	//$aed=  floatval($dbamt)*floatval($dbrate);
	//$aed=  $dbamt*$dbrate;
	$aed1=  number_format(($dbamt1*$dbrate1), 2,'.', '');
	$total1=number_format(($total1+$aed1), 2,'.', '');
    $column_amtAED1 = $column_amtAED1.$aed1."\n";
  
	
    
    $item1=$item1+1;   
}

$total=number_format(($total1+$total2), 2,'.', '');








       $tempq="SELECT * FROM temp_collectdata";
                            $result33= mysqli_query($dbhandle,$tempq);
							 while ($temprow = mysqli_fetch_array($result33,MYSQLI_NUM))
                                {
									$insertq="insert into collectdata values('".$id."','".$pmtdt."','".$temprow{0} ."','".$temprow{1} ."',".$temprow{2} .",".$temprow{3} .")";
									mysqli_query(  $dbhandle, $insertq );
								}		 




       /*$del1="delete from employee";
        mysqli_query($dbhandle,$del1);*/
		$del2="drop table temp_collectdata";
        mysqli_query($dbhandle,$del2);
 mysqli_close($dbhandle);
 /*class PDF extends FPDF {

 function Footer() {
$this->SetY(-15);
//$this->SetX(140);
$this->setFont('Arial', 'I', 8);
$this->Cell(0,10,'['.$name.']',0,0,'C');

}
}
*/ 


//Create a new PDF file
$pdf=new FPDF();
$pdf->AddPage();

$pdf->SetFont('times','B',18);
$pdf->SetY(22);

$pdf->SetTextColor(165,42,42);
$pdf->Cell(0,16,'BUSINESS EXPENSE REPORT',0,0,'C');

$pdf->SetTextColor(255,0,0);
$pdf->SetY(42);
$pdf->SetX(11);

$pdf->SetFont('Times','B',10);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0, 4, "Employee Name (ID): ",0,0, 'L');

$pdf->SetX(43);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, $name."(".$id.")", 0,0,'L');
$pdf->SetX(109);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0,4,'Claim Submission Date:',0,0,'L');
$pdf->SetX(150);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, $pmtdt, 0,0,'L');

$pdf->SetY(48);
$pdf->SetX(11);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0,4,"Payment:", 0,0,'L');
$pdf->SetX(43);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, "Transportation", 0,0,'L');
$pdf->SetX(109);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0,4,'Manager:',0,0,'L');
$pdf->SetX(150);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, $manager, 0,0,'L');

$pdf->SetY(54);
$pdf->SetX(11);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0,4,"Expenses Nature:", 0,0,'L');
$pdf->SetX(43);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, "Cab Charges - ".$exp, 0,0,'L');
$pdf->SetX(109);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0,4,'Bank Account Number:',0,0,'L');
$pdf->SetX(150);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, $acc, 0,0,'L');

$pdf->SetY(60);
$pdf->SetX(11);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0,4,"Expenses Total:", 0,0,'L');
$pdf->SetX(43);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, "Rs ".$total, 0,0,'L');
$pdf->SetX(109);
$pdf->SetTextColor(0,0,0);
$pdf->Cell(0,4,'Finance:',0,0,'L');
$pdf->SetX(150);
$pdf->SetTextColor(0,0,255);
$pdf->Cell(0,4, "---", 0,0,'L');





$pdf->SetTextColor(0,0,0);
//Fields Name position
$Y_Fields_Name_position = 75;
//Table position, under Fields Name
$Y_Table_Position = 81;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(232,232,232);
//Bold Font for Field Name
$pdf->SetFont('Arial','B',8);
$pdf->SetY($Y_Fields_Name_position);
$pdf->SetX(5);
$pdf->Cell(8,6,'Item',1,0,'C',1);
$pdf->SetX(13);
$pdf->Cell(25,6,'Date',1,0,'C',1);
$pdf->SetX(38);
$pdf->Cell(65,6,'Description',1,0,'C',1);

$pdf->SetX(103);
$pdf->Cell(15,6,'Item Code',1,0,'C',1);
$pdf->SetX(118);
$pdf->Cell(10,6,'Curr.',1,0,'C',1);
$pdf->SetX(128);
$pdf->Cell(35,6,'Amount',1,0,'C',1);
$pdf->SetX(163);
$pdf->Cell(8,6,"Rate",1,0,'C',1);
$pdf->SetX(171);
$pdf->Cell(35,6,"Amount AED",1,0,'C',1);
$pdf->Ln();
//Now show the 3 columns
$pdf->SetFillColor(255,255,255);

$pdf->SetFont('Arial','',8);
$pdf->SetAutoPageBreak(false,3);
$pdf->SetY($Y_Table_Position);
$pdf->SetX(5);
$pdf->MultiCell(8,6,$column_itemno,1,'C');

$pdf->SetY($Y_Table_Position);
$pdf->SetX(13);
$pdf->MultiCell(25,6,$column_date,1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(38);
$pdf->MultiCell(65,6,$column_desc,1,'C');
$pdf->SetY($Y_Table_Position);

$pdf->SetX(103);
$pdf->MultiCell(15,6,$column_code,1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(118);
$pdf->MultiCell(10,6,$column_curr,1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(128);
$pdf->MultiCell(35,6,$column_amt,1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(163);
$pdf->MultiCell(8,6,$column_rate,1,'C');
$pdf->SetY($Y_Table_Position);
$pdf->SetX(171);
$pdf->MultiCell(35,6,$column_amtAED,1,'C');


//Creating lines (boxes) for each ROW (Product)
//If we don't use the following code, you don't create the lines separating each row
$j = 0;
$pdf->SetY($Y_Table_Position);
while ($j < $number_of_rows2)
{
    $pdf->SetX(5);
    $pdf->MultiCell(201,6,'',1);
    $j = $j +1;
}



$pdf->SetFont('Times','B',10);

$pdf->SetY(270);
$pdf->SetX(140);
//$pdf->setFont('Times', 'I', 8);
$pdf->Cell(50,6,'['.$name.']',0,0,'C');








$pdf->SetAutoPageBreak(true,2);
$pdf->AddPage();
$Y_Fields_Name_position1 = 40;
//Table position, under Fields Name
$Y_Table_Position1 = 46;
//First create each Field Name
//Gray color filling each Field Name box
$pdf->SetFillColor(232,232,232);
//Bold Font for Field Name
$pdf->SetFont('Arial','B',8);
$pdf->SetY($Y_Fields_Name_position1);
$pdf->SetX(5);
$pdf->Cell(8,6,'Item',1,0,'C',1);
$pdf->SetX(13);
$pdf->Cell(25,6,'Date',1,0,'C',1);
$pdf->SetX(38);
$pdf->Cell(65,6,'Description',1,0,'C',1);

$pdf->SetX(103);
$pdf->Cell(15,6,'Item Code',1,0,'C',1);
$pdf->SetX(118);
$pdf->Cell(10,6,'Curr.',1,0,'C',1);
$pdf->SetX(128);
$pdf->Cell(35,6,'Amount',1,0,'C',1);
$pdf->SetX(163);
$pdf->Cell(8,6,"Rate",1,0,'C',1);
$pdf->SetX(171);
$pdf->Cell(35,6,"Amount AED",1,0,'C',1);
$pdf->Ln();



$pdf->SetFillColor(255,255,255);

$pdf->SetFont('Arial','',8);
$pdf->SetAutoPageBreak(false,3);
$pdf->SetY($Y_Table_Position1);
$pdf->SetX(5);
$pdf->MultiCell(8,6,$column_itemno1,1,'C');

$pdf->SetY($Y_Table_Position1);
$pdf->SetX(13);
$pdf->MultiCell(25,6,$column_date1,1,'C');
$pdf->SetY($Y_Table_Position1);
$pdf->SetX(38);
$pdf->MultiCell(65,6,$column_desc1,1,'C');
$pdf->SetY($Y_Table_Position1);

$pdf->SetX(103);
$pdf->MultiCell(15,6,$column_code1,1,'C');
$pdf->SetY($Y_Table_Position1);
$pdf->SetX(118);
$pdf->MultiCell(10,6,$column_curr1,1,'C');
$pdf->SetY($Y_Table_Position1);
$pdf->SetX(128);
$pdf->MultiCell(35,6,$column_amt1,1,'C');
$pdf->SetY($Y_Table_Position1);
$pdf->SetX(163);
$pdf->MultiCell(8,6,$column_rate1,1,'C');
$pdf->SetY($Y_Table_Position1);
$pdf->SetX(171);
$pdf->MultiCell(35,6,$column_amtAED1,1,'C');


$pdf->SetX(157);
$pdf->SetFont('Arial','B',10);


$pdf->Cell(0,6,"TOTAL = ". $total, 0,0,'C');
$pdf->SetFont('Times','B',10);

$pdf->SetY(270);
$pdf->SetX(140);
//$pdf->setFont('Times', 'I', 8);
$pdf->Cell(50,6,'['.$name.']',0,0,'C');

$pdf->Output($name.'_cabBill('.$pmtdt.').pdf','D');
?>