示例#1
0
 static function rent_history($option)
 {
     global $database, $my, $Itemid, $booklibrary_configuration, $mainframe, $mosConfig_list_limit;
     PHP_booklibrary::addTitleAndMetaTags();
     //     $menu = new mosMenu($database);
     //     $menu->load( $Itemid );
     //     $params = new mosParameters( $menu->params );
     if (version_compare(JVERSION, '3.0', 'lt')) {
         $menu = new JTableMenu($database);
         // for 1.6
         $menu->load($Itemid);
         $params = new mosParameters($menu->params);
     } else {
         $menu = new JTableMenu($database);
         $menu->load($Itemid);
         $params = new JRegistry();
         $params->loadString($menu->params);
     }
     $database->setQuery("SELECT id FROM #__menu WHERE link='index.php?option=com_booklibrary'");
     if ($database->loadResult() != $Itemid) {
         $params->def('wrongitemid', '1');
     }
     if ($my->email == null) {
         echo "\n             <script type=\"text/JavaScript\" language = \"JavaScript\">\n                alert('You cannot view My Books that were not authorizated!');\n                window.history.go(-1);\n            </script>";
         exit;
     }
     $limit = $booklibrary_configuration['page']['items'];
     $limitstart = mosGetParam($_REQUEST, 'limitstart', 0);
     $database->setQuery("SELECT count(*) FROM #__booklibrary_lend AS l" . "\nLEFT JOIN #__booklibrary AS a ON a.id = l.   fk_bookid" . "\nWHERE l.fk_userid = '{$my->id}'");
     $total = $database->loadResult();
     echo $database->getErrorMsg();
     $pageNav = new JPagination($total, $limitstart, $limit);
     // for J 1.6
     $query = "SELECT l.*,a.* FROM #__booklibrary_lend AS l" . "\nLEFT JOIN #__booklibrary AS a ON a.id = l.   fk_bookid " . "\nWHERE l.fk_userid = '" . $my->id . "' LIMIT {$pageNav->limitstart},{$pageNav->limit};";
     $database->setQuery($query);
     $books = $database->loadObjectList();
     HTML_booklibrary::showRentHistory($option, $books, $pageNav, $params);
 }