📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/2vinternational.com/admin/dgenerate_pdf.php
<?php require("dbconnect.php"); require("fpdf.php"); if (!isset($_GET['id'])) { die("Invalid Demand ID"); } $demand_id = intval($_GET['id']); // ---------------- HEADER ---------------- $header = $con->query("SELECT * FROM demand_header WHERE id=$demand_id")->fetch_assoc(); // ---------------- TRADES ---------------- $trades = $con->query("SELECT * FROM demand_trades WHERE demand_id=$demand_id"); // ---------------- TERMS ---------------- $terms = $con->query("SELECT * FROM demand_terms WHERE demand_id=$demand_id")->fetch_assoc(); // ---------------- FOOTER ---------------- $footer = $con->query("SELECT * FROM demand_footer WHERE demand_id=$demand_id")->fetch_assoc(); // ✅ Create PDF $pdf = new FPDF(); $pdf->AddPage(); // --------- BACKGROUND COLOR ---------- $pdf->SetFillColor(245, 248, 250); // light grey-blue $pdf->Rect(0, 0, 210, 297, 'F'); // fill full A4 page // --------- LOGO LEFT & RIGHT ---------- if ($header['logo_left']) { $pdf->Image("uploads/".$header['logo_left'], 15, 10, 30, 0); // auto height } if ($header['logo_right']) { $pdf->Image("uploads/".$header['logo_right'], 165, 10, 30, 0); } // --------- TITLE ---------- $pdf->SetFont('Arial','B',16); $pdf->SetTextColor(40,40,90); // dark blue $pdf->Cell(0,12, strtoupper($header['title']), 0,1,'C'); $pdf->SetFont('Arial','B',13); $pdf->SetTextColor(20,20,20); $pdf->Cell(0,10, strtoupper($header['company_name']), 0,1,'C'); $pdf->SetFont('Arial','',11); $pdf->SetTextColor(60,60,60); $pdf->Cell(0,8, strtoupper($header['visa_type']." - ".$header['selection_type']), 0,1,'C'); $pdf->Ln(8); // --------- TRADES TABLE ---------- $pdf->SetFont('Arial','B',11); $pdf->SetFillColor(52, 152, 219); // blue header $pdf->SetTextColor(255,255,255); $pdf->Cell(10,10,"#",1,0,'C',true); $pdf->Cell(80,10,"Trade",1,0,'C',true); $pdf->Cell(30,10,"Qty",1,0,'C',true); $pdf->Cell(70,10,"Salary",1,1,'C',true); $pdf->SetFont('Arial','',11); $pdf->SetTextColor(0,0,0); $sn=1; while($row = $trades->fetch_assoc()){ $pdf->Cell(10,10,$sn++,1,0,'C'); $pdf->Cell(80,10,$row['trade'],1,0,'C'); $pdf->Cell(30,10,$row['qty'],1,0,'C'); $pdf->Cell(70,10,$row['salary'],1,1,'C'); } $pdf->Ln(6); // --------- TERMS ---------- $pdf->SetFont('Arial','B',12); $pdf->SetTextColor(40,40,90); $pdf->Cell(0,10,"Terms and Conditions",0,1); $pdf->SetFont('Arial','',11); $pdf->SetTextColor(50,50,50); $pdf->MultiCell(0,8, "• Duty Hours : ".$terms['duty_hours']."\n". "• Age Limit : ".$terms['age_limit']."\n". "• Contract Period : ".$terms['contract_period']."\n". "• Medical : ".$terms['medical']."\n". "• Accommodation & Transportation : ".$terms['accommodation'] ); // --------- AGENCY INFO (FOOTER) ---------- $pdf->Ln(6); if ($footer['agency_logo']) { $pdf->Image("uploads/".$footer['agency_logo'], 15, $pdf->GetY(), 30, 0); } $pdf->SetFont('Arial','B',13); $pdf->SetTextColor(0,0,0); $pdf->Cell(0,8,$footer['agency_name'],0,1,'C'); $pdf->SetFont('Arial','',11); $pdf->SetTextColor(80,80,80); $pdf->MultiCell(0,6,$footer['address']."\nPhone: ".$footer['phone']." | Email: ".$footer['email'],0,'C'); // --------- OUTPUT ---------- $pdf->Output("I","demand_$demand_id.pdf"); ?>
Save
Cancel