* @see http://www.admidio.org/
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License v2.0 only
*
* Parameters:
***********************************************************************************************
*/
require_once '../../system/common.php';
// only users with the right to edit inventory could use this script
if (!$gCurrentUser->editInventory()) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
// set headline of the script
$headline = $gL10n->get('INV_ITEM_MANAGEMENT');
// Navigation of the module starts here
$gNavigation->addStartUrl(CURRENT_URL, $headline);
$gInventoryFields = new InventoryFields($gDb, $gCurrentOrganization->getValue('org_id'));
// alle Items zur Auswahl selektieren
$sql = 'SELECT inv_id, item_name.ind_value as item_name, room_id.ind_value as room_id,
COALESCE(inv_timestamp_change, inv_timestamp_create) as timestamp
FROM ' . TBL_INVENT . '
INNER JOIN ' . TBL_INVENT_DATA . ' as item_name
ON item_name.ind_itm_id = inv_id
AND item_name.ind_inf_id = ' . $gInventoryFields->getProperty('ITEM_NAME', 'inf_id') . '
INNER JOIN ' . TBL_INVENT_DATA . ' as room_id
ON room_id.ind_itm_id = inv_id
AND room_id.ind_inf_id = ' . $gInventoryFields->getProperty('ROOM_ID', 'inf_id') . '
WHERE inv_valid = 1
ORDER BY item_name.ind_value, room_id.ind_value ';
$mglStatement = $gDb->query($sql);
// create html page object
$page = new HtmlPage($headline);
// if new_inventory isn't set and no inventory id is set then show dialog to create a inventory
if ($getItemId == 0 && $getNewItem == 0) {
$getNewItem = 1;
}
// set headline of the script
if ($getNewItem == 1) {
$headline = $gL10n->get('PRO_ADD_inventory');
} else {
$headline = $gL10n->get('PRO_EDIT_PROFILE');
}
// inventory-ID nur uebernehmen, wenn ein vorhandener Benutzer auch bearbeitet wird
if ($getItemId > 0 && $getNewItem != 0) {
$gMessage->show($gL10n->get('SYS_INVALID_PAGE_VIEW'));
}
// read inventory data
$gInventoryFields = new InventoryFields($gDb, $gCurrentOrganization->getValue('org_id'));
$inventory = new Inventory($gDb, $gInventoryFields, $getItemId);
// pruefen, ob Modul aufgerufen werden darf
switch ($getNewItem) {
case 0:
// prueft, ob der user die notwendigen Rechte hat, das entsprechende Profil zu aendern
if (!$gCurrentUser->editInventory($inventory)) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
break;
case 1:
// prueft, ob der inventory die notwendigen Rechte hat, neue items anzulegen
if (!$gCurrentUser->editInventory()) {
$gMessage->show($gL10n->get('SYS_NO_RIGHTS'));
}
break;
