/**
* @param string $sql
* @param integer $item_id
* @param object $pdf
* @return object
*/
public static function get_equipment_item_report($sql, $item_id, $pdf)
{
if ($sql and is_object($pdf)) {
$result_array = Equipment_Wrapper::list_item_equipments($sql, null, null, null, null);
if (is_array($result_array) and count($result_array) >= 1) {
$pdf->addPage();
$pdf->SetFont('dejavusans', 'B', 14, '', true);
$pdf->Write(0, 'Equipment', '', 0, 'C', true, 0, false, false, 0);
$pdf->Write(0, '', '', 0, 'L', true, 0, false, false, 0);
$pdf->MultiCell(70, 0, "Equipment Name", 1, 'L', 1, 0, '', '', true, 0, false, true, 0);
$pdf->MultiCell(60, 0, "Category", 1, 'L', 1, 0, '', '', true, 0, false, true, 0);
$pdf->MultiCell(60, 0, "Date/Time", 1, 'L', 1, 1, '', '', true, 0, false, true, 0);
$pdf->SetFont('dejavusans', '', 14, '', true);
foreach ($result_array as $key => $value) {
$datetime_handler = new DatetimeHandler($result_array[$key]['datetime']);
$result_array[$key]['datetime'] = $datetime_handler->get_datetime(false);
$pdf->MultiCell(70, 0, $result_array[$key]['name'], 1, 'L', 1, 0, '', '', true, 0, false, true, 0);
$pdf->MultiCell(60, 0, $result_array[$key]['category'], 1, 'L', 1, 0, '', '', true, 0, false, true, 0);
$pdf->MultiCell(60, 0, $result_array[$key]['datetime'], 1, 'L', 1, 1, '', '', true, 0, false, true, 0);
}
}
return $pdf;
} else {
return null;
}
}
/**
* @param string $json_argument_array
* @return integer
*/
public static function count_organisation_unit_related_equipment($json_argument_array)
{
$argument_array = json_decode($json_argument_array);
$organisation_unit_id = $argument_array[1];
if (is_numeric($organisation_unit_id)) {
return Equipment_Wrapper::count_organisation_unit_equipments($organisation_unit_id);
} else {
return null;
}
}
