$page_title = get_opendb_lang_var('check_in_item(s)'); if (is_numeric($listingObject->getItemsPerPage())) { $listingObject->setTotalItems(fetch_owner_borrowed_item_cnt(get_opendb_session_var('user_id'))); if ($listingObject->getTotalItemCount() > 0) { $checkbox_column = TRUE; $result = fetch_owner_borrowed_item_rs(get_opendb_session_var('user_id'), $listingObject->getCurrentOrderBy(), $listingObject->getCurrentSortOrder(), $listingObject->getStartIndex(), $listingObject->getItemsPerPage()); } } else { $result = fetch_owner_borrowed_item_rs(get_opendb_session_var('user_id'), $listingObject->getCurrentOrderBy(), $listingObject->getCurrentSortOrder()); } } else { if ($HTTP_VARS['op'] == 'owner_reserved') { //all titles the owner currently has reservations for. $page_title = get_opendb_lang_var('check_out_item(s)'); if (is_numeric($listingObject->getItemsPerPage())) { $listingObject->setTotalItems(fetch_owner_reserved_item_cnt(get_opendb_session_var('user_id'))); if ($listingObject->getTotalItemCount() > 0) { $checkbox_column = TRUE; $result = fetch_owner_reserved_item_rs(get_opendb_session_var('user_id'), $listingObject->getCurrentOrderBy(), $listingObject->getCurrentSortOrder(), $listingObject->getStartIndex(), $listingObject->getItemsPerPage()); } } else { $result = fetch_owner_reserved_item_rs(get_opendb_session_var('user_id'), $listingObject->getCurrentOrderBy()); } } else { if ($HTTP_VARS['op'] == 'my_item_history') { $show_listings = FALSE; $item_r = fetch_item_instance_r($HTTP_VARS['item_id'], $HTTP_VARS['instance_no']); if (is_not_empty_array($item_r)) { $footer_links_r[] = array(url => "item_display.php?item_id=" . $item_r['item_id'] . "&instance_no=" . $item_r['instance_no'], text => get_opendb_lang_var('back_to_item')); if (is_opendb_session_var('listing_url_vars')) { $footer_links_r[] = array(url => "listings.php?" . get_url_string(get_opendb_session_var('listing_url_vars')), text => get_opendb_lang_var('back_to_listing'));
function build_borrower_stats() { if (get_opendb_config_var('borrow', 'enable') !== FALSE) { echo "<h3>" . get_opendb_lang_var('borrow_stats') . "</h3>"; echo "<table class=\"itemStats\">"; echo "<tr class=\"navbar\">"; echo "<th>" . get_opendb_lang_var('owner') . "</th>"; echo "<th>" . theme_image('reserved.gif', get_opendb_lang_var('reserved'), "borrowed_item") . "</th>"; echo "<th>" . theme_image('borrowed.gif', get_opendb_lang_var('borrowed'), "borrowed_item") . "</th>"; echo "</tr>"; $result = fetch_user_rs(PERM_ITEM_OWNER); if ($result) { $toggle = TRUE; // Totals. $sum_loaned = 0; $sum_reserved = 0; while ($user_r = db_fetch_assoc($result)) { $user_name = get_opendb_lang_var('user_name', array('fullname' => $user_r['fullname'], 'user_id' => $user_r['user_id'])); echo "<tr class=\"data\"><th>"; if (is_user_granted_permission(PERM_VIEW_USER_PROFILE)) { echo "<a href=\"user_profile.php?uid=" . $user_r['user_id'] . "\">" . $user_name . "</a>"; } else { echo $user_name; } echo "</th>"; $reserved_total = fetch_owner_reserved_item_cnt($user_r['user_id']); $sum_reserved += $reserved_total; echo "\n<td>"; if ($reserved_total > 0) { echo $reserved_total; } else { echo "-"; } echo "</td>"; $loan_total = fetch_owner_borrowed_item_cnt($user_r['user_id']); $sum_loaned += $loan_total; echo "\n<td>"; if ($loan_total > 0) { echo $loan_total; } else { echo "-"; } echo "</td>"; echo "</tr>"; } //while ($user_r = db_fetch_assoc($result)) db_free_result($result); echo "<tr class=\"data totals\"><th>" . get_opendb_lang_var('totals') . "</th>"; // sum loaned. if (get_opendb_config_var('borrow', 'enable') !== FALSE) { echo "<td>" . $sum_reserved . "</td>"; echo "<td>" . $sum_loaned . "</td>"; } echo "</tr>"; } echo "</table>"; } }