$listingObject->addHeaderColumn(get_opendb_lang_var('overdue_duration')); } else { if ($HTTP_VARS['op'] == 'my_borrowed' || $HTTP_VARS['op'] == 'all_borrowed' || $HTTP_VARS['op'] == 'owner_borrowed') { $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); }
function endItem() { if ($this->_is_item_finished !== TRUE) { if ($this->_item_obj != NULL) { // instance was not closed, close it now! if ($this->_is_item_instance) { $this->_is_item_instance = FALSE; } // if not item instance, create one if (is_empty_array($this->_instance_item_obj_rs)) { $this->startItemInstance(); $this->endItemInstance(); } // The item is finished, no more additions are allowed, until the // startItem method is called again. $this->_is_item_finished = TRUE; $item_vars = $this->__getItemHTTPVars($this->_item_obj); $item_vars['trial_run'] = $this->_cfg_is_trial_run ? 'true' : 'false'; $item_vars['confirmed'] = $this->_cfg_ignore_duplicate_title ? 'true' : 'false'; $item_r = array(s_item_type => $this->_item_obj->getItemType(), owner_id => $this->getOwner(), title => $this->_item_obj->getTitle()); $instance_valid = FALSE; $errors = array(); $return_val = handle_item_insert($item_r, $item_vars, $errors); if ($return_val === TRUE) { // store item id for later use if ($this->_cfg_is_trial_run !== TRUE && is_numeric($item_r['item_id'])) { $this->_item_id_list_r[] = $item_r['item_id']; } for ($i = 0; $i < count($this->_instance_item_obj_rs); $i++) { $instanceObj = $this->_instance_item_obj_rs[$i]; // if status type is to be overriden, do it here! if ($this->_cfg_override_status_type) { $status_type_r = $this->_cfg_default_status_type_r; } else { $status_type_r = fetch_status_type_r($instanceObj->getStatusType()); // if illegal type, then override by default. if ($status_type_r['closed_ind'] == 'Y') { $status_type_r = $this->_cfg_default_status_type_r; } } $item_r['owner_id'] = $instanceObj->getOwnerID(); $item_r['s_status_type'] = $status_type_r['s_status_type']; $instance_vars = $this->__getItemHTTPVars($instanceObj); // we are missing instance attributes if already set in item $instance_vars = array_merge($instance_vars, $item_vars); $return_val = handle_item_instance_insert($item_r, $status_type_r, $item_vars, $errors); if ($return_val !== FALSE) { $item_r['instance_no'] = $this->_cfg_is_trial_run ? $i + 1 : $item_r['instance_no']; //$instanceObj->setInstanceNo($this->_cfg_is_trial_run?$i+1:$item_r['instance_no']); $this->__listing_item_import_result_row($item_r, $status_type_r, $instance_vars, NULL); // indicates at least one instance inserted. $instance_valid = TRUE; } else { $item_r['instance_no'] = $this->_cfg_is_trial_run ? $i + 1 : $item_r['instance_no']; //$instanceObj->setInstanceNo($this->_cfg_is_trial_run?$i+1:$item_r['instance_no']); $this->__listing_item_import_result_row($item_r, $status_type_r, $instance_vars, $errors); } } } else { $this->__listing_item_import_result_row($item_r, NULL, $item_vars, $errors); } $this->_item_obj = NULL; // end of parent item. return TRUE; } else { $this->_item_obj = NULL; $this->addError('endItem', get_opendb_lang_var('undefined_error')); return FALSE; } } else { // if($this->_is_item_finished !== TRUE) return FALSE; } }
function handle_item_instance_update($item_r, $status_type_r, $HTTP_VARS, &$errors) { if (is_not_empty_array($item_r)) { if ($item_r['owner_id'] == get_opendb_session_var('user_id') || is_user_granted_permission(PERM_ITEM_ADMIN)) { $update_status_type = $HTTP_VARS['s_status_type']; // Do not allow use of default s_status_type, it needs to be explicitly specified. if (strlen($update_status_type) > 0 && $item_r['s_status_type'] != $update_status_type) { $update_status_type_r = fetch_status_type_r($update_status_type); } else { // Otherwise s_status_type is not being udated $update_status_type = $status_type_r['s_status_type']; $update_status_type_r = $status_type_r; // current s_status_type } // If $update_status_type_r not defined, then we are not updating the s_status_type, only the status_comment if ($item_r['s_status_type'] == $update_status_type || is_update_status_type_valid($item_r['item_id'], $item_r['instance_no'], $item_r['owner_id'], $status_type_r, $update_status_type_r, $errors)) { // assume validation attribute function converts borrow duration to a single element array. if (is_array($HTTP_VARS['borrow_duration']) && count($HTTP_VARS['borrow_duration']) == 1) { $borrow_duration = $HTTP_VARS['borrow_duration'][0]; } else { $borrow_duration = $HTTP_VARS['borrow_duration']; } $borrow_duration = ifempty($borrow_duration, $item_r['borrow_duration']); if (!is_numeric($borrow_duration)) { $borrow_duration = FALSE; // Not defined, so do not update } $status_comment = $HTTP_VARS['status_comment']; // trigger change owner processing at this point. if (strlen($HTTP_VARS['owner_id']) && $HTTP_VARS['owner_id'] != $item_r['owner_id']) { if ($status_type_r['change_owner_ind'] == 'Y') { if (!is_item_borrowed($item_r['item_id'], $item_r['instance_no'])) { if (!update_item_instance_owner($item_r['item_id'], $item_r['instance_no'], $item_r['owner_id'], $HTTP_VARS['owner_id'])) { $errors = array('error' => get_opendb_lang_var('item_instance_owner_not_changed')); } } else { $errors = array('error' => get_opendb_lang_var('item_instance_owner_not_changed')); } } else { $errors = array('error' => get_opendb_lang_var('operation_not_avail_change_owner'), 'detail' => ''); } } if (update_item_instance($item_r['item_id'], $item_r['instance_no'], $update_status_type, $status_comment, $borrow_duration)) { handle_item_attributes('updateinstance', $item_r, $HTTP_VARS, $errors); return TRUE; } else { $db_error = db_error(); $errors = array('error' => get_opendb_lang_var('item_instance_not_updated'), 'detail' => $db_error); return FALSE; } } else { return FALSE; } } else { $errors = array('error' => get_opendb_lang_var('cannot_update_item_not_owned'), detail => ''); opendb_logger(OPENDB_LOG_WARN, __FILE__, __FUNCTION__, 'User attempted to update item instance they do not own', $item_r); return FALSE; } } else { //if(is_not_empty_array($item_r)) $errors = array('error' => get_opendb_lang_var('item_not_found'), 'detail' => ''); return FALSE; } }
function is_item_instance_checkoutable($item_instance_r, &$errors) { if (!is_item_borrowed($item_instance_r['item_id'], $item_instance_r['instance_no'])) { $status_type_r = fetch_status_type_r($item_instance_r['s_status_type']); if ($status_type_r['borrow_ind'] == 'Y') { return TRUE; } else { if (is_array($status_type_r)) { $errors[] = get_opendb_lang_var('s_status_type_items_cannot_be_borrowed', 's_status_type_desc', $status_type_r['description']); } else { $errors[] = get_opendb_lang_var('invalid_s_status_type', 's_status_type', $item_instance_r['s_status_type']); } } } else { $errors[] = get_opendb_lang_var('item_is_already_checked_out'); } //else return FALSE; }
$errors[] = array('error' => 'Invalid Status Type specified'); } $HTTP_VARS['op'] = 'new'; } } else { if ($HTTP_VARS['op'] == 'installsql') { execute_sql_install($ADMIN_TYPE, $HTTP_VARS['sqlfile'], $errors); $HTTP_VARS['op'] = NULL; } } } } if ($HTTP_VARS['op'] == 'new' || $HTTP_VARS['op'] == 'edit') { echo "<p>[<a href=\"{$PHP_SELF}?type={$ADMIN_TYPE}\">Back to Main</a>]</p>"; if ($HTTP_VARS['op'] == 'edit') { $status_type_r = fetch_status_type_r($HTTP_VARS['s_status_type']); if ($status_type_r === FALSE) { $errors[] = 'Status Type (' . $HTTP_VARS['s_status_type'] . ') not found'; } echo "\n<h3>Edit Status Type</h3>"; $save_op = 'update'; $save_button = 'Update'; } else { echo "\n<h3>New Status Type</h3>"; $save_op = 'insert'; $save_button = 'Insert'; } if (is_not_empty_array($errors)) { echo format_error_block($errors); } echo "\n<form name=\"s_status_type\" action=\"{$PHP_SELF}\" method=\"POST\">";
/** * Used by all insert/update item_instance functions to make sure the data is valid. Will * also update $status_comment / $borrow_duration and set them to a legal value for the * specified $s_status_type */ function validate_item_instance_fields($s_status_type, &$status_comment, &$borrow_duration) { // At this point, a specific $s_status_type MUST be supplied. if (strlen($s_status_type) > 0) { $status_type_r = fetch_status_type_r($s_status_type); } if (is_not_empty_array($status_type_r)) { // A $borrow_duration explicitly set to FALSE, is // an indication that nothing should be done with it. if ($borrow_duration !== FALSE && $borrow_duration !== NULL) { //if already null, no need to check again. // Ensure we have a valid $borrow_duration if (is_numeric($borrow_duration)) { //column cannot handle more than 999 if ($borrow_duration > 999) { $borrow_duration = '999'; } } else { $borrow_duration = NULL; } } $status_comment = addslashes(substr(replace_newlines(trim(strip_tags($status_comment))), 0, 255)); return TRUE; } else { opendb_logger(OPENDB_LOG_ERROR, __FILE__, __FUNCTION__, 'Invalid Status Type', array($s_status_type)); return FALSE; } }
function get_search_query_matrix($HTTP_VARS) { function get_match_type($match) { if ($match == 'word') { return get_opendb_lang_var('word_match'); } else { if ($match == 'partial') { return get_opendb_lang_var('partial_match'); } else { if ($match == 'exact') { return get_opendb_lang_var('exact_match'); } else { return NULL; } } } } $searches = array(); if (strlen($HTTP_VARS['title']) > 0) { // Default title match is exact match. $HTTP_VARS['title_match'] = ifempty($HTTP_VARS['title_match'], 'exact'); if ($HTTP_VARS['title_match'] == 'word' || $HTTP_VARS['title_match'] == 'partial') { if (is_null($HTTP_VARS['title_case'])) { $searches[] = array(prompt => get_opendb_lang_var('title') . ' (<em>' . get_match_type($HTTP_VARS['title_match']) . '</em>)', field => $HTTP_VARS['title']); } else { $searches[] = array(prompt => get_opendb_lang_var('title') . ' (<em>' . get_match_type($HTTP_VARS['title_match']) . ', ' . get_opendb_lang_var('case_sensitive') . '</em>)', field => $HTTP_VARS['title']); } } else { $searches[] = array(prompt => get_opendb_lang_var('title'), field => $HTTP_VARS['title']); } } if (strlen($HTTP_VARS['category']) > 0) { // If s_item_type defined, we can get at the s_attribute_type of the category value. if (strlen($HTTP_VARS['s_item_type']) > 0) { $attribute_type_r = fetch_sfieldtype_item_attribute_type_r($HTTP_VARS['s_item_type'], 'CATEGORY'); $searches[] = array(prompt => get_opendb_lang_var('category'), field => get_item_display_field(NULL, $attribute_type_r, $HTTP_VARS['category'], FALSE)); } else { $searches[] = array(prompt => get_opendb_lang_var('category'), field => $HTTP_VARS['category']); } } if (strlen($HTTP_VARS['owner_id']) > 0) { $username = fetch_user_name($HTTP_VARS['owner_id']); if (strlen($username) > 0) { $searches[] = array(prompt => get_opendb_lang_var('owner'), field => $username . ' (' . $HTTP_VARS['owner_id'] . ')'); } } if (strlen($HTTP_VARS['s_item_type_group']) > 0) { $searches[] = array(prompt => get_opendb_lang_var('s_item_type_group'), field => $HTTP_VARS['s_item_type_group']); } if (is_array($HTTP_VARS['s_item_type'])) { $field = ''; for ($i = 0; $i < count($HTTP_VARS['s_item_type']); $i++) { $item_type_r = fetch_item_type_r($HTTP_VARS['s_item_type'][$i]); $field .= theme_image($item_type_r['image'], $item_type_r['description'], 's_item_type'); } $searches[] = array(prompt => get_opendb_lang_var('s_item_type'), field => $field); } else { if (strlen($HTTP_VARS['s_item_type']) > 0) { $item_type_r = fetch_item_type_r($HTTP_VARS['s_item_type']); $searches[] = array(prompt => get_opendb_lang_var('s_item_type'), field => theme_image($item_type_r['image'], $item_type_r['description'], 's_item_type')); } } if (is_numeric($HTTP_VARS['rating'])) { $attribute_type_r = fetch_cached_attribute_type_r('S_RATING'); $searches[] = array(prompt => $attribute_type_r['prompt'], field => get_display_field($attribute_type_r['s_attribute_type'], NULL, 'review()', $HTTP_VARS['rating'], FALSE)); } $attribute_type_r = NULL; if (strlen($HTTP_VARS['attribute_type']) > 0) { $attribute_type_r = fetch_cached_attribute_type_r($HTTP_VARS['attribute_type']); if (is_not_empty_array($attribute_type_r)) { $attribute_type_r['listing_link_ind'] = 'N'; // Default title match is exact match. $HTTP_VARS['attr_match'] = ifempty($HTTP_VARS['attr_match'], 'exact'); // Special category search, but ignore if category variable actually specified. if (strlen($HTTP_VARS['category']) == 0 && strlen($HTTP_VARS['attribute_val']) > 0 && $HTTP_VARS['attr_match'] == 'category') { // We do not want the Listing Link to be added to this display field $searches[] = array(prompt => $attribute_type_r['prompt'], field => get_item_display_field(NULL, $attribute_type_r, stripslashes($HTTP_VARS['attribute_val']), FALSE)); } else { if (strlen($HTTP_VARS['attribute_val']) > 0) { $HTTP_VARS['attribute_val'] = stripslashes($HTTP_VARS['attribute_val']); if (starts_with($HTTP_VARS['attribute_val'], '"') && ends_with($HTTP_VARS['attribute_val'], '"')) { $HTTP_VARS['attribute_val'] = substr($HTTP_VARS['attribute_val'], 1, -1); } $search = ifempty(get_item_display_field(NULL, $attribute_type_r, $HTTP_VARS['attribute_val'], FALSE), $HTTP_VARS['attribute_val']); } else { if (strlen($HTTP_VARS['lookup_attribute_val']) > 0) { $search = get_item_display_field(NULL, $attribute_type_r, stripslashes($HTTP_VARS['lookup_attribute_val']), FALSE); } } if (!is_lookup_attribute_type($HTTP_VARS['attribute_type']) && $HTTP_VARS['attr_match'] != 'exact') { $searches[] = array(prompt => $attribute_type_r['prompt'] . ' (<em>' . get_match_type($HTTP_VARS['attr_match']) . '</em>)', field => $search); } else { $searches[] = array(prompt => $attribute_type_r['prompt'], field => $search); } } } //if(is_not_empty_array($attribute_type_r)) } else { if (strlen($HTTP_VARS['attribute_val']) > 0) { // specified a search term without attribute type, this is a global search. if (is_null($HTTP_VARS['attr_case'])) { $searches[] = array(prompt => get_opendb_lang_var('attribute_val') . ' (<em>' . get_match_type(ifempty($HTTP_VARS['attr_match'], 'exact')) . '</em>)', field => stripslashes($HTTP_VARS['attribute_val'])); } else { $searches[] = array(prompt => get_opendb_lang_var('attribute_val') . ' (<em>' . get_match_type(ifempty($HTTP_VARS['attr_match'], 'exact')) . ', ' . get_opendb_lang_var('case_sensitive') . '</em>)', field => stripslashes($HTTP_VARS['attribute_val'])); } } } // add another search field if update_on value also specified. if (strlen($HTTP_VARS['attr_update_on']) > 0) { if (is_not_empty_array($attribute_type_r)) { $prompt = get_opendb_lang_var('attribute_prompt_updated', array('s_attribute_type' => $attribute_type_r['s_attribute_type'], 'prompt' => $attribute_type_r['prompt'])); } else { $prompt = get_opendb_lang_var('attributes_updated'); } if (strlen($HTTP_VARS['datetimemask']) > 0) { $searches[] = array(prompt => $prompt, field => $HTTP_VARS['attr_update_on'] . ' (' . $HTTP_VARS['datetimemask'] . ')'); } else { $searches[] = array(prompt => $prompt, field => $HTTP_VARS['attr_update_on']); } } else { if (is_numeric($HTTP_VARS['attr_update_on_days'])) { if (is_not_empty_array($attribute_type_r)) { $prompt = get_opendb_lang_var('attribute_prompt_updated', array('s_attribute_type' => $attribute_type_r['s_attribute_type'], 'prompt' => $attribute_type_r['prompt'])); } else { $prompt = get_opendb_lang_var('attributes_updated'); } if ($HTTP_VARS['attr_update_on_days'] == '1') { $field = get_opendb_lang_var('one_day_ago'); } else { if ($HTTP_VARS['attr_update_on_days'] == '7') { $field = get_opendb_lang_var('one_week_ago'); } else { if ($HTTP_VARS['attr_update_on_days'] == '28') { $field = get_opendb_lang_var('one_month_ago'); } else { if ($HTTP_VARS['attr_update_on_days'] == '365') { $field = get_opendb_lang_var('one_year_ago'); } } } } $searches[] = array(prompt => $prompt, field => $field); } } if (strlen($HTTP_VARS['update_on']) > 0) { if (strlen($HTTP_VARS['datetimemask']) > 0) { $searches[] = array(prompt => get_opendb_lang_var('updated'), field => $HTTP_VARS['update_on'] . ' (' . $HTTP_VARS['datetimemask'] . ')'); } else { $searches[] = array(prompt => get_opendb_lang_var('updated'), field => $HTTP_VARS['update_on']); } } else { if (is_numeric($HTTP_VARS['update_on_days'])) { if ($HTTP_VARS['update_on_days'] == '1') { $field = get_opendb_lang_var('one_day_ago'); } else { if ($HTTP_VARS['update_on_days'] == '7') { $field = get_opendb_lang_var('one_week_ago'); } else { if ($HTTP_VARS['update_on_days'] == '28') { $field = get_opendb_lang_var('one_month_ago'); } else { if ($HTTP_VARS['update_on_days'] == '365') { $field = get_opendb_lang_var('one_year_ago'); } } } } $searches[] = array(prompt => get_opendb_lang_var('updated'), field => $field); } } if (is_not_empty_array($HTTP_VARS['s_status_type']) > 0) { $search = ''; for ($i = 0; $i < count($HTTP_VARS['s_status_type']); $i++) { if (strlen($search) > 0) { $search .= ' '; } $status_type_r = fetch_status_type_r($HTTP_VARS['s_status_type'][$i]); if (is_not_empty_array($status_type_r)) { $search .= format_display_value('%img%', $status_type_r['img'], 'Y', $status_type_r['description'], 's_status_type'); } } if (strlen($search) > 0) { $searches[] = array(prompt => get_opendb_lang_var('s_status_type'), field => $search); } } if (strlen($HTTP_VARS['status_comment']) > 0) { // Default status_comment match is exact match. $HTTP_VARS['status_comment_match'] = ifempty($HTTP_VARS['status_comment_match'], 'exact'); if ($HTTP_VARS['status_comment_match'] == 'word' || $HTTP_VARS['status_comment_match'] == 'partial' || $HTTP_VARS['status_comment_match'] == 'exact') { if (is_null($HTTP_VARS['status_comment_case'])) { $searches[] = array(prompt => get_opendb_lang_var('status_comment') . ' (<em>' . get_match_type($HTTP_VARS['status_comment_match']) . '</em>)', field => $HTTP_VARS['status_comment']); } else { $searches[] = array(prompt => get_opendb_lang_var('status_comment') . ' (<em>' . get_match_type($HTTP_VARS['status_comment_match']) . ', ' . get_opendb_lang_var('case_sensitive') . '</em>)', field => $HTTP_VARS['status_comment']); } } else { $searches[] = array(prompt => get_opendb_lang_var('status_comment'), field => $HTTP_VARS['status_comment']); } } if (is_numeric($HTTP_VARS['interest_level']) && $HTTP_VARS['interest_level'] > 0) { $searches[] = array(prompt => get_opendb_lang_var('interest'), field => theme_image("interest_1.gif", get_opendb_lang_var('interest'), 's_item_type')); } return $searches; }
function get_related_items_listing($item_r, $HTTP_VARS, $related_mode) { global $PHP_SELF; $buffer = ''; $results = fetch_item_instance_relationship_rs($item_r['item_id'], $item_r['instance_no'], $related_mode); if ($results) { $listingObject = new HTML_Listing($PHP_SELF, $HTTP_VARS); $listingObject->setBufferOutput(TRUE); $listingObject->setNoRowsMessage(get_opendb_lang_var('no_items_found')); $listingObject->setShowItemImages(TRUE); $listingObject->setIncludeFooter(FALSE); $listingObject->addHeaderColumn(get_opendb_lang_var('type'), 'type', FALSE); $listingObject->addHeaderColumn(get_opendb_lang_var('title'), 'title', FALSE); $listingObject->addHeaderColumn(get_opendb_lang_var('action'), 'action', FALSE); $listingObject->addHeaderColumn(get_opendb_lang_var('status'), 'status', FALSE); $listingObject->addHeaderColumn(get_opendb_lang_var('status_comment'), 'status_comment', FALSE); $listingObject->addHeaderColumn(get_opendb_lang_var('category'), 'category', FALSE); $listingObject->startListing(NULL); while ($related_item_r = db_fetch_assoc($results)) { $listingObject->startRow(); $listingObject->addItemTypeImageColumn($related_item_r['s_item_type']); $listingObject->addTitleColumn($related_item_r); $action_links_rs = NULL; if (is_user_granted_permission(PERM_ITEM_OWNER) && get_opendb_session_var('user_id') === $item_r['owner_id'] || is_user_granted_permission(PERM_ITEM_ADMIN)) { $action_links_rs[] = array(url => 'item_input.php?op=edit&item_id=' . $related_item_r['item_id'] . '&instance_no=' . $related_item_r['instance_no'], img => 'edit.gif', text => get_opendb_lang_var('edit')); if (get_opendb_config_var('listings', 'show_refresh_actions') && is_item_legal_site_type($related_item_r['s_item_type'])) { $action_links_rs[] = array(url => 'item_input.php?op=site-refresh&item_id=' . $related_item_r['item_id'] . '&instance_no=' . $related_item_r['instance_no'], img => 'refresh.gif', text => get_opendb_lang_var('refresh')); } $action_links_rs[] = array(url => 'item_input.php?op=delete&item_id=' . $related_item_r['item_id'] . '&instance_no=' . $related_item_r['instance_no'] . '&parent_item_id=' . $item_r['item_id'] . '&parent_instance_no=' . $item_r['instance_no'], img => 'delete.gif', text => get_opendb_lang_var('delete')); $action_links_rs[] = array(url => 'item_input.php?op=delete-relation&item_id=' . $item_r['item_id'] . '&instance_no=' . $item_r['instance_no'] . '&parent_item_id=' . $related_item_r['item_id'] . '&parent_instance_no=' . $related_item_r['instance_no'], img => 'delete.gif', text => get_opendb_lang_var('delete_relationship')); } $listingObject->addActionColumn($action_links_rs); $status_type_r = fetch_status_type_r($related_item_r['s_status_type']); $listingObject->addThemeImageColumn($status_type_r['img'], $status_type_r['description'], $status_type_r['description'], 's_status_type'); //type // If a comment is allowed and defined, add it in. if ($status_type_r['status_comment_ind'] == 'Y' || get_opendb_session_var('user_id') === $related_item_r['owner_id'] || is_user_granted_permission(PERM_ITEM_ADMIN)) { // support newlines in this field $listingObject->addColumn(nl2br($related_item_r['status_comment'])); } else { $listingObject->addColumn(get_opendb_lang_var('not_applicable')); } $attribute_type_r = fetch_sfieldtype_item_attribute_type_r($related_item_r['s_item_type'], 'CATEGORY'); if (is_array($attribute_type_r)) { if ($attribute_type_r['lookup_attribute_ind'] === 'Y') { $attribute_val = fetch_attribute_val_r($related_item_r['item_id'], $related_item_r['instance_no'], $attribute_type_r['s_attribute_type'], $attribute_type_r['order_no']); } else { $attribute_val = fetch_attribute_val($related_item_r['item_id'], $related_item_r['instance_no'], $attribute_type_r['s_attribute_type'], $attribute_type_r['order_no']); } $listingObject->addAttrDisplayColumn($related_item_r, $attribute_type_r, $attribute_val); } $listingObject->endRow(); } $listingObject->endListing(); $buffer =& $listingObject->getContents(); unset($listingObject); return $buffer; } else { return NULL; } }
// we want to display all items - no pagination. $HTTP_VARS['items_per_page'] = ''; $listingObject = new HTML_Listing($PHP_SELF, $HTTP_VARS); $listingObject->setNoRowsMessage(get_opendb_lang_var('no_items_found')); $cfg_include_header_row = strcmp($HTTP_VARS['include_header_row'], 'Y') === 0 ? TRUE : FALSE; $cfg_ignore_duplicate_title = strcmp($HTTP_VARS['ignore_duplicate_title'], 'Y') === 0 ? TRUE : FALSE; $cfg_is_trial_run = strcmp($HTTP_VARS['trial_run'], 'Y') === 0 ? TRUE : FALSE; $cfg_override_status_type = strcmp($HTTP_VARS['override_status_type'], 'Y') === 0 ? TRUE : FALSE; // force disable of duplicate titles. set_opendb_config_ovrd_var('item_input', 'duplicate_title_support', $cfg_ignore_duplicate_title); set_opendb_config_ovrd_var('listings', 'show_item_image', FALSE); //set_opendb_config_ovrd_var('item_input', 'confirm_duplicate_insert', TRUE); if (is_valid_s_status_type($HTTP_VARS['s_status_type'])) { $cfg_default_status_type_r = fetch_status_type_r($HTTP_VARS['s_status_type']); } else { $cfg_default_status_type_r = fetch_status_type_r(fetch_default_status_type()); } $itemImportHandler = new ItemImportHandler($HTTP_VARS['owner_id'], $cfg_is_trial_run, $cfg_ignore_duplicate_title, $cfg_override_status_type, $cfg_default_status_type_r, $listingObject); if (strcmp($HTTP_VARS['owner_id'], get_opendb_session_var('user_id')) === 0) { $page_title = get_opendb_lang_var('type_import', array('description' => $importPlugin->get_display_name())); } else { $page_title = get_opendb_lang_var('type_import_items_for_name', array('description' => $importPlugin->get_display_name(), 'fullname' => fetch_user_name($HTTP_VARS['owner_id']), 'user_id' => $HTTP_VARS['owner_id'])); } echo _theme_header($page_title); echo "<h2>" . $page_title . "</h2>\n"; echo get_import_choices_table($importPlugin, $cfg_include_header_row, $cfg_ignore_duplicate_title, $cfg_is_trial_run, $cfg_override_status_type, $cfg_default_status_type_r); $listingObject->startListing(); $listingObject->addHeaderColumn('', 'flag', FALSE); // Success or Failure column $listingObject->addHeaderColumn(get_opendb_lang_var('type'), 's_item_type', FALSE); $listingObject->addHeaderColumn(get_opendb_lang_var('title'), 'title', FALSE);
/** * A handle_quick_checkout will only ever handle one request at a time, because * they are initiated from item_display & listings.php, but not borrow.php */ function handle_quick_checkout($item_id, $instance_no, $borrower_id, $borrow_duration, $more_information, &$errors) { if (!is_user_valid($borrower_id)) { $errors = get_opendb_lang_var('invalid_borrower_user', 'user_id', $borrower_id); return FALSE; } else { if (!is_user_granted_permission(PERM_USER_BORROWER, $borrower_id)) { $errors = get_opendb_lang_var('user_must_be_borrower', 'user_id', $borrower_id); return FALSE; } else { if (!is_user_allowed_to_checkout_item($item_id, $instance_no)) { $errors = get_opendb_lang_var('not_owner_of_item'); return FALSE; } else { if (is_user_owner_of_item($item_id, $instance_no, $borrower_id) && get_opendb_config_var('borrow', 'owner_self_checkout') !== TRUE) { $errors = get_opendb_lang_var('cannot_checkout_items_you_own'); return FALSE; } else { if (is_item_borrowed($item_id, $instance_no)) { $errors = get_opendb_lang_var('item_is_already_checked_out'); return FALSE; } } } } } $sequence_number = fetch_borrowed_item_seq_no($item_id, $instance_no, 'R', $borrower_id); if ($sequence_number !== FALSE) { if (get_opendb_config_var('borrow', 'quick_checkout_use_existing_reservation') !== FALSE) { if (check_out_item($sequence_number, $borrow_duration, $more_information)) { return $sequence_number; } else { return FALSE; } } else { $errors = get_opendb_lang_var('user_has_reservation', 'user_id', $borrower_id); return FALSE; } } else { //if($sequence_number !== FALSE) $status_type_r = fetch_status_type_r(fetch_item_s_status_type($item_id, $instance_no)); if ($status_type_r['borrow_ind'] == 'Y') { $new_borrowed_item_id = quick_check_out_item($item_id, $instance_no, $borrower_id, $borrow_duration, $more_information); if ($new_borrowed_item_id !== FALSE) { return $new_borrowed_item_id; } else { return FALSE; } } else { $errors = get_opendb_lang_var('s_status_type_items_cannot_be_borrowed', 's_status_type_desc', $status_type_r['description']); return FALSE; } } }
} else { $item_r = array(item_id => NULL, title => NULL, s_item_type => trim($HTTP_VARS['s_item_type'])); } $item_r['instance_no'] = NULL; // if a new copy / clone let insert process work out next instance no $item_r['owner_id'] = ifempty($HTTP_VARS['owner_id'], get_opendb_session_var('user_id')); $item_r['s_status_type'] = $status_type_r['s_status_type']; $item_r['status_comment'] = NULL; } else { //otherwise either a site refresh operation or an edit/update/delete $item_r = fetch_item_instance_r($HTTP_VARS['item_id'], $HTTP_VARS['instance_no']); // a new copy should be for the current user if ($HTTP_VARS['op'] == 'newinstance') { $item_r['owner_id'] = get_opendb_session_var('user_id'); } $status_type_r = fetch_status_type_r($item_r['s_status_type']); } // Includes 'new' because we artificially construct an $item_r array. if (is_not_empty_array($item_r)) { // We need a valid $status_type_r as well at this point, and should not continue without it. if (is_not_empty_array($status_type_r)) { $footer_links_r = NULL; // construct single instance of this object to use throughout the script. $titleMaskCfg = new TitleMask('item_display'); switch ($HTTP_VARS['op']) { case 'insert': perform_insert_process($item_r, $status_type_r, $HTTP_VARS, $footer_links_r); break; case 'delete': perform_delete_process($item_r, $status_type_r, $HTTP_VARS, $footer_links_r); break;