public function getListPropReportsPdf()
{
$cat = Session::get('catid');
if ($cat == "*") {
$props = Properties::all();
$catid = "*";
} else {
$props = Properties::where('prop_category', $cat)->get();
$catid = PropertyCategory::where('id', $cat)->pluck('id');
}
Fpdf::AddPage();
Fpdf::Image('img/dap.jpg', 10, 5, 150);
Fpdf::SetFont('Arial', 'B', 12);
Fpdf::Ln(20.6);
Fpdf::Cell(40, 27, 'List of Properties', 0, 2, 'C', 0);
Fpdf::SetFont('Arial', 'B', 9.5);
Fpdf::Cell(27, 5, 'Property ID', 1, 0, 'C', 0);
Fpdf::Cell(27, 5, 'Serial No', 1, 0, 'C', 0);
Fpdf::Cell(27, 5, 'Property Name', 1, 0, 'C', 0);
Fpdf::Cell(27, 5, 'Category', 1, 0, 'C', 0);
Fpdf::Cell(27, 5, 'Status', 1, 0, 'C', 0);
Fpdf::Cell(27, 5, 'Cost', 1, 0, 'C', 0);
Fpdf::Cell(27, 5, 'Date Acquired', 1, 0, 'C', 0);
Fpdf::Ln();
foreach ($props as $prop) {
Fpdf::SetFont('Arial', 'B', 6);
Fpdf::Cell(27, 4, $prop->propname, 1, 0, 'C', 0);
Fpdf::Cell(27, 4, $prop->serialno, 1, 0, 'C', 0);
Fpdf::Cell(27, 4, $prop->propname, 1, 0, 'C', 0);
$category = PropertyCategory::find($prop->prop_category);
Fpdf::Cell(27, 4, $category->catname, 1, 0, 'C', 0);
Fpdf::Cell(27, 4, $prop->propstatus, 1, 0, 'C', 0);
Fpdf::Cell(27, 4, $prop->propcost, 1, 0, 'C', 0);
Fpdf::Cell(27, 4, $prop->formatDateAcquired(), 1, 0, 'C', 0);
Fpdf::Ln();
}
Fpdf::Output();
exit;
}
