/reports/ebpls_fish_permit.php
PHP | 297 lines | 223 code | 38 blank | 36 comment | 19 complexity | f0fb32e545aedb5957601c1380b34b59 MD5 | raw file
- <?php
- require_once("../lib/ebpls.utils.php");
- define('FPDF_FONTPATH','font/');
- require('../ebpls-php-lib/html2pdf_lib/fpdf.php');
- $permit_type='Fishery';
- include"../includes/variables.php";
- include_once("../lib/multidbconnection.php");
- $dbLink =Open($dbtype,$connecttype,$dbhost,$dbuser,$dbpass,$dbname);
- $result=mysql_query("select lguname, lguprovince, lguoffice from ebpls_buss_preference") or die(mysql_error());
- $resulta=mysql_fetch_row($result);
- $getlgu = @mysql_query("select city_municipality_desc from ebpls_city_municipality where city_municipality_code = '$resulta[0]'");
- $getlgu = @mysql_fetch_row($getlgu);
- $getprov = @mysql_query("select province_desc from ebpls_province where province_code = '$resulta[1]'");
- $getprov = @mysql_fetch_row($getprov);
- $pdf=new FPDF('P','mm','A4');
- $pdf->AddPage();
- //$pdf->image('',10,5,33);
- $pdf->Image('../images/ebpls_logo.jpg',10,5,33);
- $pdf->SetFont('Arial','B',12);
- $pdf->Cell(190,5,'REPUBLIC OF THE PHILIPPINES',0,1,'C');
- $pdf->Cell(190,5,$getprov[0],0,1,'C');
- $pdf->Cell(190,5,$getlgu[0],0,2,'C');
- $pdf->SetFont('Arial','B',12);
- $pdf->Cell(190,5,'Office of the Mayor',0,2,'C');
- $pdf->Cell(190,5,'',0,2,'C');
- $pdf->SetFont('Arial','BU',16);
- $pdf->Cell(190,5,'FISHERY PERMIT/LICENSE',0,1,'C');
- if ($reportpermit == '1') {
- $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),
- concat(a.owner_street, ', ', d.zone_desc, ', ', e.barangay_desc, ', ', f.district_desc, ', ', g.city_municipality_desc, ', ',
- h.province_desc, ' ', a.owner_zip_code), a.owner_id, b.transaction, b.for_year, b.ebpls_fishery_permit_code
- from ebpls_owner a, ebpls_fishery_permit b, ebpls_zone d, ebpls_barangay e, ebpls_district f, ebpls_city_municipality g, ebpls_province h, ebpls_zip i
- where a.owner_id=b.owner_id and b.active = '1' and b.ebpls_fishery_permit_code ='$permit_num' or a.owner_last_name = '$owner_last' limit 1")
- or die("1".mysql_error());
- } else {
- $result = mysql_query("select concat(a.owner_first_name, ' ', a.owner_middle_name, ' ', a.owner_last_name),
- concat(a.owner_street, ', ', d.zone_desc, ', ', e.barangay_desc, ', ', f.district_desc, ', ', g.city_municipality_desc, ', ',
- h.province_desc, ' ', a.owner_zip_code), a.owner_id, b.transaction, b.for_year, b.ebpls_fishery_permit_code
- from $owner a, $permittable b, ebpls_zone d, ebpls_barangay e, ebpls_district f, ebpls_city_municipality g, ebpls_province h, ebpls_zip i
- where a.owner_id=b.owner_id and $incode ='$permit_num' and b.active = '1'")
- or die($permittype.mysql_error());
- }
- $resulta=mysql_fetch_row($result);
- $permit_num = $resulta[5];
- $nValidity = $resulta[4];
- //$permit_num
- $pdf->Cell(190,5,'',0,1,'C');
- $pdf->Cell(190,5,'',0,1,'C');
- $pdf->SetFont('Arial','B',10);
- $pdf->SetX(5);
- $pdf->Cell(50,5,'TO WHOM IT MAY CONCERN:',0,1,'L');
- $pdf->Cell(190,5,'',0,1,'C');
- $pdf->SetFont('Arial','',10);
- $pdf->SetX(10);
- $pdf->Cell(40,5,'This is to certify that',0,0,'L');
- $pdf->SetX(50);
- $pdf->SetFont('Arial','B',10);
- $pdf->Cell(150,5,$resulta[0],0,1,'C');
- $pdf->SetX(50);
- $pdf->Cell(150,5,'-----------------------------------------------------------------------------------------------------------------------------',0,1,'C');
- $pdf->Cell(200,5,'',0,1,'C');
- $pdf->SetX(10);
- $pdf->SetFont('Arial','',10);
- $pdf->Write(5,'of ');
- $pdf->SetFont('Arial','BU',10);
- $pdf->Write(5,$resulta[1]);
- $pdf->SetFont('Arial','',10);
- $pdf->Write(5,' is hereby granted to operate his/her fishing activity.',0,1,'L');
- $pdf->Cell(200,5,'',0,1,'C');
- $pdf->Cell(200,5,'',0,1,'C');
- if ($reportpermit == '1') {
- $fish= mysql_query("select boat_name, crew, engine_type, engine_cap, reg_no from fish_boat where owner_id='$resulta[2]'")
- or die("12".mysql_error());
- } else {
- $fish= mysql_query("select boat_name, crew, engine_type, engine_cap, reg_no from fish_boat where owner_id='$owner_id'")
- or die("12".mysql_error());
- }
- $pdf->Cell(200,5,'',0,1,'C');
- $pdf->SetFont('Arial','B',10);
- $pdf->SetX(5);
- $pdf->Cell(60,5,'NAME OF FISHING BOAT',1,0,'C');
- $pdf->SetX(65);
- $pdf->Cell(40,5,'NO. OF CREW(S)',1,0,'C');
- $pdf->SetX(105);
- $pdf->Cell(60,5,'ENGINE TYPE/CAPACITY',1,0,'C');
- $pdf->SetX(165);
- $pdf->Cell(35,5,'REGISTRATION NO.',1,1,'C');
- while ($fish1=mysql_fetch_row($fish))
- {
- //put values here
- $pdf->SetFont('Arial','B',10);
- $pdf->SetX(5);
- $pdf->Cell(60,5,$fish1[0],1,0,'C');
- $pdf->Cell(40,5,$fish1[1],1,0,'C');
- $pdf->Cell(60,5,$fish1[2]."/".$fish1[3],1,0,'C');
- $pdf->Cell(35,5,$fish1[4],1,1,'C');
- }
- $pdf->Cell(200,5,'',0,1,'C');
- $pdf->Cell(200,5,'',0,1,'C');
- $owner_id=$resulta[2];
- $stat = $resulta[3];
- if ($reportpermit == '1') {
- $getboat = mysql_query("select * from fish_boat where owner_id='$resulat[2]'") or die('3'.mysql_error);
- } else {
- $getboat = mysql_query("select * from fish_boat where owner_id=$owner_id");
- }
- while ($getb = mysql_fetch_row($getboat))
- {
- $getfee = mysql_query("select amt,range_lower, range_higher
- from boat_fee where boat_type='$getb[4]' and
- range_lower<$getb[5] and range_higher>=$getb[5] and
- transaction='$stat' and active = 1") or die(mysql_error());
- $getnum=mysql_num_rows($getfee);
- if ($getnum==0) {
- $getfee = mysql_query("select amt
- from boat_fee where boat_type='$getb[4]' and
- range_lower<=$getb[5] and range_higher=0 and
- transaction='$stat' and active = 1") or die(mysql_error());
- }
- $getfee = mysql_fetch_row($getfee);
- $ttfee = $ttfee+$getfee[0];
- }
- $ttfee = number_format($ttfee,2);
- if (reportpermit == '1') {
- $getboat = SelectDataWhere($dbtype,$dbLink,"fish_assess","where owner_id=$resulta[2]") or die('4'.mysql_error);
- } else {
- $getboat = SelectDataWhere($dbtype,$dbLink,"fish_assess","where owner_id=$owner_id");
- }
- while ($getb = FetchArray($dbtype,$getboat))
- {
- $getfee = SelectDataWhere($dbtype,$dbLink,"culture_fee",
- "where culture_id='$getb[culture_id]' and
- active = '1'");
- $getnum = FetchArray($dbtype,$getfee);
-
- if ($getnum[fee_type]=='3') {
-
- $getfee = SelectDataWhere($dbtype,$dbLink,"culture_range",
- "where culture_id='$getb[culture_id]' and
- range_lower<=$getb[amt] and range_higher>=$getb[amt] ");
- $getnum = NumRows($dbtype,$getfee);
- if ($getnum==0) {
-
- $getfee = SelectDataWhere($dbtype,$dbLink,"culture_range",
- "where culture_id='$getb[culture_id]' and
- range_lower<=$getb[amt] and range_higher=0");
- }
- $getfee1 = FetchArray($dbtype,$getfee);
- $getfee1 = $getfee1[amt];
- } elseif ($getnum[fee_type]=='1') { //constant
- $getfee1 = $getnum[const_amt];
- } elseif ($getnum[fee_type]=='2') { //formula
- eval("\$getfee1=$getb[amt]$getnum[formula_amt];");
- }
- $ttfee1 = $ttfee1+$getfee1;
- }
- $getot = mysql_query("select * from ebpls_fishery_fees where permit_type='$stat' and active=1") or die('5'.mysql_error);
- $getact = mysql_query("select sum(amt) from fish_assess where owner_id=$owner_id
- and transaction='$stat' and active = 1") or die (mysql_error());
- $getact = mysql_fetch_row($getact);
- $tfee1 = $getact[0];
- $tfee1=number_format($tfee1,2);
- $pdf->SetFont('Arial','B',10);
- $pdf->SetX(5);
- $pdf->Cell(200,5,'',0,1,'L');
- $pdf->SetX(5);
- $pdf->Cell(100,5,'TAX/FEE DEFINITION',1,0,'C');
- $pdf->Cell(40,5,'AMOUNT',1,1,'C');
- $ff = 0;
- $pdf->SetX(5);
- $pdf->Cell(100,5,'Boat Registration Fee',1,0,'L');
- $pdf->Cell(40,5,$ttfee,1,1,'R');
- $pdf->SetX(5);
- $pdf->Cell(100,5,'Fish Activities Fee',1,0,'L');
- $pdf->Cell(40,5,number_format($ttfee1,2),1,1,'R');
- $ff = $ff + $ttfee + $ttfee1;
- while ($getj = mysql_fetch_row($getot))
- {
-
- $pdf->SetX(5);
- $pdf->Cell(100,5,$getj[1],1,0,'L');
- $pdf->Cell(40,5,number_format($getj[2],2),1,1,'R');
- $ff = $ff + $getj[2];
- }
- $pdf->SetX(5);
- $pdf->Cell(100,5,'TOTAL',1,0,'R');
- $pdf->Cell(40,5,number_format($ff,2),1,1,'R');
- /*
- $getid = mysql_query("select owner_id, transaction from ebpls_motorized_operator_permit
- where motorized_operator_permit_id ='$permit_num' and active = 1");
- $getid = mysql_query("select owner_id, transaction from ebpls_motorized_operator_permit
- where motorized_operator_permit_id ='$permit_num'");
- //000000000000007
- $getd = mysql_fetch_row($getid);
- $owner_id = $getd[0];
- $stat = $getd[1];
-
- $i = 1;
- $pdf->SetY($Y_Table_Position);
- while ($busline=mysql_fetch_row($getfee))
- {
- $pdf->SetX(5);
- $pdf->Cell(120,5,$getfee[0],1,0,'L');
- $pdf->SetX(125);
- $pdf->Cell(40,5,'',1,0,'R');
- $pdf->SetX(165);
- $pdf->Cell(40,5,number_format($getfee[0],2),1,0,'R');
-
- $i++;
- $pdf->SetY($pdf->GetY()+5);
- }
- */
- $pdf->Cell(200,5,'',0,1,'C');
- $pdf->SetFont('Arial','',10);
- $pdf->SetX(10);
- $pdf->Cell(100,5,'Issued for all legal intents and/or registration purpose this',0,0,'L');
- $pdf->SetX(110);
- $pdf->SetFont('Arial','BU',10);
- $pdf->Cell(30,5,date("F dS Y"),0,1,'L');
- $pdf->SetX(10);
- $pdf->SetFont('Arial','',10);
- $pdf->Cell(40,5,' with permit number ',0,0,'L');
- $pdf->SetFont('Arial','B',10);
- $pdf->Cell(25,5,$permit_num ,0,0,'L');
- $pdf->SetFont('Arial','',10);
- $pdf->Cell(50,5,'Valid until December 31, ',0,0,'R');
- $pdf->SetFont('Arial','BU',12);
- $pdf->Cell(25,5,$nValidity.".",0,0,'L');
- $pdf->Cell(200,5,'',0,1,'C');
- $pdf->Cell(200,5,'',0,1,'C');
- //new signatories table
- // $result=mysql_query("select gs_name, gs_pos, gs_office from global_sign where sign_id =1") or die(mysql_error());
- // $resulta=mysql_fetch_row($result);
- //$Y_Table_Position = $Y_Table_Position + 20;
-
- $pdf->Cell(200,5,'',0,1,'C');
- //$pdf->SetY(-18);
- $pdf->SetX(5);
- $pdf->SetFont('Arial','B',10);
- $pdf->SetX(5);
- $pdf->Cell(100,5,'',0,0,'L');
- $pdf->SetX(135);
- $pdf->Cell(70,5,'Approved:',0,1,'C');
- $pdf->Cell(200,5,'',0,1,'C');
- $pdf->Cell(200,5,'',0,1,'C');
- $getsignatories = @mysql_query("select * from report_signatories where report_file='Fishery Permit' and sign_type='1'");
- $getsignatories1 = @mysql_fetch_array($getsignatories);
- $getsignatories = @mysql_query("select * from global_sign where sign_id='$getsignatories1[sign_id]'");
- $getsignatories1 = @mysql_fetch_array($getsignatories);
- $pdf->SetFont('Arial','B',10);
- $pdf->SetX(5);
- $pdf->Cell(100,5,'',0,0,'L');
- $pdf->SetX(135);
- $pdf->Cell(70,5,$getsignatories1[gs_name],0,1,'C');
- $pdf->SetFont('Arial','B',10);
- $pdf->SetX(5);
- $pdf->Cell(100,5,'',0,0,'L');
- $pdf->SetX(135);
- $pdf->Cell(70,5,$getsignatories1[gs_pos],0,1,'C');
- $pdf->Output();
- ?>