function lend_return($option, $bid) { global $database, $my; if (!is_array($bid) || count($bid) < 1) { echo "<script> alert('Select an item to lend'); window.history.go(-1);</script>\n"; exit; } $bids = implode(',', $bid); //for databases without subselect $select = "SELECT a.*, l.id as lendid, l.lend_from as lend_from, " . "l.lend_return as lend_return, l.lend_until as lend_until, l.fk_userid as fk_userid, " . "l.user_name as user_name, l.user_email as user_email, u.name AS name, u.email as email" . "\nFROM #__booklibrary AS a" . "\nLEFT JOIN #__booklibrary_lend AS l ON l.id = a.fk_lendid" . "\nLEFT JOIN #__users AS u ON u.id = l.fk_userid" . "\nWHERE a.id in (" . $bids . ")"; $database->setQuery($select); if (!$database->query()) { echo "<script> alert('" . addslashes($database->getErrorMsg()) . "'); window.history.go(-1); </script>\n"; exit; } $books = $database->loadObjectList(); $count = count($books); for ($i = 0; $i < 1; $i++) { if ($books[$i]->lend_from == '' && $books[$i]->lend_return == '') { ?> <script type = "text/JavaScript" language = "JavaScript"> alert('You cannot return books that were not lent out'); window.history.go(-1); </script> <?php exit; } } // get list of users $userlist[] = mosHTML::makeOption('-1', '----------'); $database->setQuery("SELECT id AS value, name AS text from #__users ORDER BY name"); $userlist = array_merge($userlist, $database->loadObjectList()); $usermenu = mosHTML::selectList($userlist, 'userid', 'class="inputbox" size="1"', 'value', 'text', '-1'); HTML_booklibrary::showLendBooks($option, $books, $usermenu, "lend_return"); }
static function lent($option, $bid) { PHP_booklibrary::addTitleAndMetaTags(); global $database, $my; if (!is_array($bid) || count($bid) < 1) { echo "<script> alert('Select an item to lend'); window.history.go(-1);</script>\n"; exit; } $bids = implode(',', $bid); $select = "SELECT a.*, cc.name AS category, l.id as lendid, l.lend_from as lend_from, " . "l.lend_return as lend_return, l.lend_until as lend_until, " . "l.user_name as user_name, l.user_email as user_email " . "\nFROM #__booklibrary AS a" . "\nLEFT JOIN #__booklibrary_categories AS bc ON bc.bookid = a.bookid " . "\nLEFT JOIN #__booklibrary_main_categories AS cc ON cc.id = bc.catid" . "\nLEFT JOIN #__booklibrary_lend AS l ON l.id = a.fk_lendid" . "\nWHERE a.id in (" . $bids . ")"; $database->setQuery($select); if (!$database->query()) { echo "<script> alert('" . $database->getErrorMsg() . "'); window.history.go(-1); </script>\n"; exit; } $books = $database->loadObjectList(); //for rent or not $count = count($books); // get list of categories $userlist[] = mosHTML::makeOption('-1', '----------'); $database->setQuery("SELECT id AS value, name AS text from #__users ORDER BY name"); $userlist = array_merge($userlist, $database->loadObjectList()); $usermenu = mosHTML::selectList($userlist, 'userid', 'class="inputbox" size="1"', 'value', 'text', '-1'); HTML_booklibrary::showLendBooks($option, $books, $usermenu, "lend"); }