$page_title = get_opendb_lang_var('my_reserved_items');
if (is_numeric($listingObject->getItemsPerPage())) {
$listingObject->setTotalItems(fetch_my_reserved_item_cnt(get_opendb_session_var('user_id')));
if ($listingObject->getTotalItemCount() > 0) {
$checkbox_column = TRUE;
$result = fetch_my_reserved_item_rs(get_opendb_session_var('user_id'), $listingObject->getCurrentOrderBy(), $listingObject->getCurrentSortOrder(), $listingObject->getStartIndex(), $listingObject->getItemsPerPage());
}
} else {
$result = fetch_my_reserved_item_rs(get_opendb_session_var('user_id'), $listingObject->getCurrentOrderBy(), $listingObject->getCurrentSortOrder());
}
} else {
if ($HTTP_VARS['op'] == 'owner_borrowed') {
//all titles the owner currently has lent out to others.
$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;
function handle_user_deactivate($user_id, $HTTP_VARS, &$errors)
{
if ($user_id == get_opendb_session_var('user_id')) {
$errors[] = array('error' => get_opendb_lang_var('cannot_deactivate_yourself'), 'detail' => '');
return FALSE;
} else {
if (fetch_my_borrowed_item_cnt($user_id) > 0) {
$errors[] = array('error' => get_opendb_lang_var('user_with_borrows_not_deactivated'), 'detail' => '');
return FALSE;
} else {
if (fetch_owner_borrowed_item_cnt($user_id) > 0) {
$errors[] = array('error' => get_opendb_lang_var('user_with_owner_borrows_not_deactivated'), 'detail' => '');
return FALSE;
} else {
if ($HTTP_VARS['confirmed'] == 'true') {
// Cancel all reservations.
$results = fetch_owner_reserved_item_rs($user_id);
if ($results) {
while ($borrowed_item_r = db_fetch_assoc($results)) {
cancel_reserve_item($borrowed_item_r['sequence_number']);
}
db_free_result($results);
}
$results = fetch_my_reserved_item_rs($user_id);
if ($results) {
while ($borrowed_item_r = db_fetch_assoc($results)) {
cancel_reserve_item($borrowed_item_r['sequence_number']);
}
db_free_result($results);
}
// deactivate user.
if (deactivate_user($user_id)) {
return TRUE;
} else {
return FALSE;
}
} else {
if ($HTTP_VARS['confirmed'] != 'false') {
// confirmation required.
return "__CONFIRM__";
} else {
return "__ABORTED__";
}
}
}
}
}
}
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>";
}
}
