<?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");
?>
