$v_listing_url_vars['mode'] = NULL; // These are listing specific - we do not want to save them. $v_listing_url_vars['item_id_instance_no'] = NULL; $v_listing_url_vars['checked_item_id_instance_no'] = NULL; $v_listing_url_vars['checked_item_id_instance_no_list'] = NULL; register_opendb_session_var('listing_url_vars', $v_listing_url_vars); while ($item_r = db_fetch_assoc($result)) { $listingObject->startRow(); // Get the Status Type config for the current item_instance.s_status_type, but grab it once. if (!is_array($status_type_rs[$item_r['s_status_type']])) { $status_type_rs[$item_r['s_status_type']] = fetch_status_type_r($item_r['s_status_type']); } if ($show_checkbox_column) { if (!is_item_in_reserve_basket($item_r['item_id'], $item_r['instance_no'], get_opendb_session_var('user_id'))) { if ($status_type_rs[$item_r['s_status_type']]['borrow_ind'] == 'Y' && ($item_r['owner_id'] !== get_opendb_session_var('user_id') || get_opendb_config_var('borrow', 'owner_self_checkout') !== FALSE) && is_user_granted_permission(PERM_USER_BORROWER) && !is_item_reserved_or_borrowed_by_user($item_r['item_id'], $item_r['instance_no']) && (get_opendb_config_var('borrow', 'allow_reserve_if_borrowed') !== FALSE || !is_item_borrowed($item_r['item_id'], $item_r['instance_no'])) && (get_opendb_config_var('borrow', 'allow_multi_reserve') !== FALSE || !is_item_reserved($item_r['item_id'], $item_r['instance_no']))) { $listingObject->addCheckboxColumn($item_r['item_id'] . "_" . $item_r['instance_no'], FALSE); } else { $listingObject->addColumn(); } } else { $listingObject->addColumn(); } } for ($i = 0; $i < count($v_column_display_config_rs); $i++) { if ($v_column_display_config_rs[$i]['include_in_listing'] !== FALSE) { if ($v_column_display_config_rs[$i]['column_type'] == 's_attribute_type') { if ($v_column_display_config_rs[$i]['search_attribute_ind'] == 'y') { $attribute_val = $item_r[$v_column_display_config_rs[$i]['fieldname']]; } else { if ($v_column_display_config_rs[$i]['multi_attribute_ind'] == 'Y' || $v_column_display_config_rs[$i]['lookup_attribute_ind'] == 'Y') { $attribute_val = fetch_attribute_val_r($item_r['item_id'], $item_r['instance_no'], $v_column_display_config_rs[$i]['s_attribute_type']);
$listingObject->addHeaderColumn(get_opendb_lang_var('due_date'), 'due_date'); } else { // reserved! $listingObject->addHeaderColumn(get_opendb_lang_var('borrow_duration')); } } } $listingObject->addHeaderColumn(get_opendb_lang_var('more_information')); // If mysql resultset or static $item_reservation_rs array defined, we can continue. if ($result) { while ($borrowed_item_r = db_fetch_assoc($result)) { $listingObject->startRow(); $status_type_r = fetch_status_type_r($borrowed_item_r['s_status_type']); if ($checkbox_column !== FALSE) { if ($HTTP_VARS['op'] == 'my_reserve_basket' || $HTTP_VARS['op'] == 'my_reserved' || $HTTP_VARS['op'] == 'owner_borrowed' || $HTTP_VARS['op'] == 'owner_reserved' && !is_item_borrowed($borrowed_item_r['item_id'], $borrowed_item_r['instance_no'])) { $listingObject->addCheckboxColumn($borrowed_item_r['sequence_number'], FALSE); } else { $listingObject->addColumn(); } } if ($HTTP_VARS['op'] != 'my_item_history') { // Type $listingObject->addItemTypeImageColumn($borrowed_item_r['s_item_type']); if ($HTTP_VARS['op'] == 'my_borrowed' || $HTTP_VARS['op'] == 'my_history') { $listingObject->addTitleColumn($borrowed_item_r); } else { $listingObject->addTitleColumn($borrowed_item_r); } } // Owner/Borrower if ($HTTP_VARS['op'] == 'my_reserve_basket' || $HTTP_VARS['op'] == 'my_borrowed' || $HTTP_VARS['op'] == 'my_reserved' || $HTTP_VARS['op'] == 'my_history' || $HTTP_VARS['op'] == 'all_borrowed' || $HTTP_VARS['op'] == 'all_reserved') {
$listingObject->addHeaderColumn(get_opendb_lang_var('action')); $listingObject->addHeaderColumn(get_opendb_lang_var('user_role'), 'role'); if ($HTTP_VARS['restrict_active_ind'] != 'X') { $listingObject->addHeaderColumn(get_opendb_lang_var('last_visit'), 'lastvisit'); } if ($result) { $v_listing_url_vars = $HTTP_VARS; $v_listing_url_vars['mode'] = NULL; unset($v_listing_url_vars['show_deactivated_users_cbox']); register_opendb_session_var('user_listing_url_vars', $v_listing_url_vars); while ($user_r = db_fetch_assoc($result)) { $user_is_active = is_user_active($user_r['user_id']); $listingObject->startRow(); // todo - consider disabling for guest users! if ($HTTP_VARS['restrict_active_ind'] != 'X' ? $user_is_active : TRUE) { $listingObject->addCheckboxColumn($user_r['user_id'], FALSE); } else { $listingObject->addColumn(); } $user_name = get_opendb_lang_var('user_name', array('fullname' => $user_r['fullname'], 'user_id' => $user_r['user_id'])); $listingObject->addColumn('<a href="user_profile.php?uid=' . $user_r['user_id'] . '" title="' . get_opendb_lang_var('user_profile') . '">' . $user_name . '</a>'); $action_links_rs = NULL; $action_links_rs[] = array(url => 'user_admin.php?op=edit&user_id=' . $user_r['user_id'], img => 'edit_user.gif', text => get_opendb_lang_var('edit')); if ($user_r['user_id'] != get_opendb_session_var('user_id')) { if ($user_r['active_ind'] == 'X') { $action_links_rs[] = array(url => 'user_admin.php?op=delete&user_id=' . $user_r['user_id'], img => 'delete_user.gif', text => get_opendb_lang_var('delete_user')); } else { if ($user_is_active) { $action_links_rs[] = array(url => 'user_admin.php?op=deactivate&user_id=' . $user_r['user_id'], img => 'deactivate_user.gif', text => get_opendb_lang_var('deactivate_user')); } }