<?php
 include('include/include.php');
 include('pdf/fpdf.php');
 $query = executework("select * from student_fee where id ='".$_GET['id']."' and category='ADDITIONAL FEE'");
 $row = mysqli_fetch_array($query);
 $query1 = executework("select * from branch_list where branch_code = '".$row['branch']."'");
 $row1 = mysqli_fetch_array($query1);

 $student = executework("select * from student_registration where AdmissionNo = '".$row['admission_no']."'");
 $student_data = mysqli_fetch_array($student);

 $branch = $row['branch'];
 $year   = substr($row['yearOf'],5);
 $category   = substr($row['category'],0,5);
 $invoice   = $row['invoice'];
 $invoice_value = $year.$branch.'-'.$category.'-'.$invoice;


$pdf = new FPDF();

$pdf->AddPage();



 $pdf->Image('assets/img/Final_Logo.png',15,3,60);
 $pdf->SetFont('Arial','',12);
 $pdf->Cell(80,10,'');
 $pdf->Cell(80,10,'');
 $pdf->Cell(80,0,'Office Copy');
 $pdf->ln(9);
  $pdf->SetFont('Arial','',10);
  $pdf->Cell(7  ,5,'',0,0);
  
  $pdf->Cell(220,10,'13th Ward,Near Saibaba Temple, Macherla, PALANADU DISTRICT, A.P.');

  $pdf->ln(6);

   $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
  
  $pdf->Cell(220,10,'Phone : +91 9494753355, +91 8297333355');
  $pdf->ln(0);
  
   $pdf->SetFont('Arial','',23);
 // $pdf->SetFillColor(200,0,0);
 $pdf->Cell(10  ,5,'',0,0);
   $pdf->SetTextColor(255,255,255);
 $pdf->Cell(135,  10,'');

 $pdf->Cell(38,  10,'INVOICE',1,1,'C','true');
  $pdf->SetLineWidth(0.2);
 $pdf->Line(0,35,220,35);
  $pdf->ln(4);
 $pdf->SetTextColor(0,0,0);
  $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Branch              :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,$row1['branch_name'],0,0);
 
 $pdf->SetFont('Arial','',10);
 $pdf->Cell(34  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Invoice No       :',0,0);
  $pdf->SetFont('Arial','B',10);
 
 $pdf->Cell(40  ,5,$invoice_value,0,0);
 
 $pdf->ln(5);
 $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
  $pdf->Cell(35  ,5,'Student Name   :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,strtoupper($student_data['StudentName']),0,0);
 $pdf->SetFont('Arial','',10);
  $pdf->Cell(34  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Date                 :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,date('d-M-Y',strtotime($row['fee_date'])),0,0);
 $pdf->ln(5);
 
  $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Admission No    :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,$row['admission_no'],0,0);
 $pdf->ln(5);
 
  $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Class                 :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,$student_data['PresentClass'].' '.'-'.' '.$student_data['Section'],0,0);
 $pdf->ln(6);
$pdf->SetFont('Arial','',11);
 $pdf->SetFillColor(200,0,0);
 $pdf->Cell(8  ,5,'',0,0);
 $pdf->SetTextColor(255,255,255);
 $pdf->Cell(130,  10,'PAYMENT TYPE',1,0,'C','true');

 $pdf->Cell(45,  10,'AMOUNT (Rs)',1,1,'C','true');
 $pdf->Cell(8  ,5,'',0,0);

 $pdf->SetTextColor(0,0,0);

 $pdf->Cell(130,  8,'   Study Fee',1,0,);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   Bus Fee',1,0);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   Hostel Fee',1,0);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   Books Fee',1,0);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   AdditionaAl Fee',1,0);
 $pdf->Cell(45,  8,$row['study_daily_amount'],1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'TOTAL  ',1,0,'R');
 $pdf->Cell(45,  8,$row['study_daily_amount'],1,1,'C');
 
 $pdf->ln(14);

  $pdf->SetFont('Arial','B',10);
  $pdf->Cell(20  ,5,'',0,0);
  $pdf->Cell(35  ,5,'',0,0);
 $pdf->Cell(40  ,5,'',0,0);
 $pdf->Cell(55  ,5,'',0,0);
 $pdf->Cell(35  ,5,'(Parents Signature)',0,0);

$pdf->SetLineWidth(0.3);
$pdf->SetDash(4,2);
$pdf->Line(0,140,220,140);

$pdf->SetDash(0,0);
$pdf->ln(14);

$pdf->Image('assets/img/Final_Logo.png',15,142,60);
$pdf->SetFont('Arial','',12);
 $pdf->Cell(80,10,'');
 $pdf->Cell(77,10,'');
 $pdf->Cell(80,2,'Student Copy');
 $pdf->ln(12);

  $pdf->SetFont('Arial','',10);
  $pdf->Cell(7  ,5,'',0,0);
  $pdf->Cell(220,10,'13th Ward,Near Saibaba Temple, Macherla, PALANADU DISTRICT, A.P.');

  $pdf->ln(6);

  $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
  $pdf->Cell(220,10,'Phone : +91 9494753355, +91 8297333355');

$pdf->ln(0);

 $pdf->SetFont('Arial','',23);
 $pdf->SetFillColor(0,0,0);
 $pdf->Cell(10  ,5,'',0,0);
 $pdf->SetTextColor(255,255,255);
 $pdf->Cell(135,  8,'');
 $pdf->Cell(38,  10,'INVOICE',1,1,'C','true');

$pdf->SetLineWidth(0);
$pdf->Line(0,174,240,174);

  $pdf->ln(4);

  $pdf->SetTextColor(0,0,0);
  $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,3,'',0,0);
  $pdf->Cell(35  ,5,'Branch              :',0,0);
  $pdf->SetFont('Arial','B',10);
  $pdf->Cell(40  ,5,$row1['branch_name'],0,0);
 
 $pdf->SetFont('Arial','',10);
 $pdf->Cell(34  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Invoice No       :',0,0);
 $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,$invoice_value,0,0);

$pdf->ln(5);
 $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
  $pdf->Cell(35  ,5,'Student Name   :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,strtoupper($student_data['StudentName']),0,0);
 $pdf->SetFont('Arial','',10);
  $pdf->Cell(34  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Date                 :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,date('d-M-Y',strtotime($row['fee_date'])),0,0);
 $pdf->ln(5);
 
  $pdf->SetFont('Arial','',10);
  $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Admission No    :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,$row['admission_no'],0,0);
 $pdf->ln(5);
$pdf->SetFont('Arial','',10);
$pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(35  ,5,'Class                 :',0,0);
  $pdf->SetFont('Arial','B',10);
 $pdf->Cell(40  ,5,$student_data['PresentClass'].' '.'-'.' '.$student_data['Section'],0,0);
 $pdf->ln(6);
$pdf->SetFont('Arial','',11);
 $pdf->SetFillColor(200,0,0);
 $pdf->Cell(8  ,5,'',0,0);
 $pdf->SetTextColor(255,255,255);
 $pdf->Cell(130,  10,'PAYMENT TYPE',1,0,'C','true');

 $pdf->Cell(45,  10,'AMOUNT (Rs)',1,1,'C','true');
 $pdf->Cell(8  ,5,'',0,0);

 $pdf->SetTextColor(0,0,0);

 $pdf->Cell(130,  8,'   Study Fee',1,0,);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   Bus Fee',1,0);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   Hostel Fee',1,0);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   Books Fee',1,0);
 $pdf->Cell(45,  8,$row['study_daily_amount'],1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'   AdditionaAl Fee',1,0);
 $pdf->Cell(45,  8,'-',1,1,'C');

 $pdf->Cell(8  ,5,'',0,0);
 $pdf->Cell(130,  8,'TOTAL  ',1,0,'R');
 $pdf->Cell(45,  8,$row['study_daily_amount'],1,1,'C');
 
 $pdf->ln(14);

  $pdf->SetFont('Arial','B',10);
  $pdf->Cell(20  ,5,'',0,0);
  $pdf->Cell(35  ,5,'',0,0);
 $pdf->Cell(40  ,5,'',0,0);
 $pdf->Cell(50  ,5,'',0,0);
 $pdf->Cell(35  ,5,'(Authorized Signature)',0,0);

 $pdf->Output();





?>