/** * 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); }