/**
* Show list of items
*
* @param type $fields
*/
function listItemsForUser($requesters_id, $options = array())
{
$params['begin_date'] = "NULL";
$params['end_date'] = "NULL";
foreach ($options as $key => $val) {
$params[$key] = $val;
}
$data = $this->find('`requesters_id` = ' . $requesters_id . " " . "AND `end_date` >= '" . $params['begin_date'] . "' " . "AND (`end_date` <= '" . $params['end_date'] . "' OR `end_date` IS NULL)", "`end_date` DESC");
$message = null;
if (!empty($data)) {
$message .= "<table class='tab_cadre_fixe'>";
$message .= "<tr>";
$message .= "<th colspan='7'>" . __('Consumable request report', 'consumables') . "</th>";
$message .= "</tr>";
$message .= "<tr>";
$message .= "<th>" . _n('Consumable', 'Consumables', 1) . "</th>";
$message .= "<th>" . _n('Consumable type', 'Consumable types', 1) . "</th>";
$message .= "<th>" . __('Requester') . "</th>";
$message .= "<th>" . __('Approver') . "</th>";
$message .= "<th>" . __('Number of used consumables') . "</th>";
$message .= "<th>" . __('Request date') . "</th>";
$message .= "<th>" . __('Status') . "</th>";
$message .= "</tr>";
$consumable = new ConsumableItem();
foreach ($data as $field) {
$message .= "<tr class='tab_bg_1'>";
$consumable->getFromDB($field['consumables_id']);
$message .= "<td>" . $consumable->getLink() . "</td>";
$message .= "<td>" . Dropdown::getDropdownName(ConsumableItemType::getTable(), $field['consumableitemtypes_id']) . "</td>";
$message .= "<td>" . getUserName($field['requesters_id']) . "</td>";
$message .= "<td>" . getUserName($field['validators_id']) . "</td>";
$message .= "<td>" . $field['number'] . "</td>";
$message .= "<td>" . Html::convDateTime($field['date_mod']) . "</td>";
$message .= "<td>";
$bgcolor = CommonITILValidation::getStatusColor($field['status']);
$status = CommonITILValidation::getStatus($field['status']);
$message .= "<div style='background-color:" . $bgcolor . ";'>" . $status . "</div>";
$message .= "</td>";
$message .= "</tr>";
}
$message .= "</table>";
$message .= "</div>";
} else {
$message .= "<div class='center'>";
$message .= "<table class='tab_cadre_fixe'>";
$message .= "<tr>";
$message .= "<th colspan='6'>" . __('Consumable request report', 'consumables') . "</th>";
$message .= "</tr>";
$message .= "<tr><td class='center'>" . __('No item found') . "</td></tr>";
$message .= "</table>";
}
return array('success' => true, 'message' => $message);
}