$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'));
}
}
