Example #1
0
     $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'));
Example #2
0
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>";
    }
}