Exemplo n.º 1
0
function manage_review_s($option, $sorting)
{
    global $database, $mainframe, $mosConfig_list_limit;
    global $table_prefix;
    // for J 1.6
    $limit = $mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mosConfig_list_limit);
    $limitstart = $mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0);
    $database->setQuery("SELECT count(*) FROM #__booklibrary_review;");
    $total = $database->loadResult();
    echo $database->getErrorMsg();
    $pageNav = new JPagination($total, $limitstart, $limit);
    // for J 1.6
    //********************   begin request for reviews manager   **********************/
    //if for sorting
    if (isset($_COOKIE['TestCookie']) and $_COOKIE['TestCookie'] == $sorting) {
        $sorting .= ' DESC';
        setcookie("TestCookie", $sorting, time() - 3600);
    } else {
        setcookie("TestCookie", $sorting, time() + 3600);
    }
    if ($sorting != "") {
        $request_string = "SELECT b.id as fk_bookid, a.id as review_id, b.isbn, b.title as title_book,\n                GROUP_CONCAT(c.title  SEPARATOR ', ') as title_catigory, a.title as title_review,\n                a.comment, e.user_name, a.date, a.rating, a.published" . "\nFROM\n\t\t{$table_prefix}booklibrary_review as a,\n\t\t{$table_prefix}booklibrary as b,\n\t\t{$table_prefix}booklibrary_main_categories as c,\n\t\t{$table_prefix}booklibrary_categories AS w,\n      (SELECT DISTINCT d.name as user_name, a.fk_userid\n\t  FROM {$table_prefix}booklibrary_review as a,\n\t  {$table_prefix}users as d\n\t  WHERE d.id = a.fk_userid" . "\nunion all" . "\nSELECT DISTINCT 'anonymous' as user_name, a.fk_userid\n\t\tFROM {$table_prefix}booklibrary_review as a\n\t\tWHERE a.fk_userid = 0) as e" . "\nWHERE a.fk_bookid = b.id AND b.id = w.bookid AND w.catid = c.id AND a.fk_userid = e.fk_userid\n      GROUP BY review_id\n      ORDER by {$sorting}" . "\nLIMIT {$pageNav->limitstart},{$pageNav->limit};";
    } else {
        $request_string = "\n\t\t\tSELECT\n\t\t\t\tb.id AS fk_bookid, a.id AS review_id, b.isbn, b.title AS title_book,\n\t\t\t\tGROUP_CONCAT(c.title  SEPARATOR ', ') AS title_catigory,\n\t\t\t\ta.title AS title_review, a.comment, e.user_name, a.date, a.rating, a.published" . "\n FROM\n\t\t\t\t#__booklibrary_review AS a,\n\t\t\t\t#__booklibrary AS b,\n\t\t\t\t#__booklibrary_main_categories AS c,\n\t\t\t\t#__booklibrary_categories AS w,\n\t\t\t  ( SELECT DISTINCT d.name AS user_name, a.fk_userid\n\t\t\t\tFROM #__booklibrary_review AS a,\n\t\t\t\t\t #__users AS d\n\t\t\t\tWHERE d.id = a.fk_userid" . "\n UNION all \n" . "SELECT DISTINCT 'anonymous' AS user_name, a.fk_userid\n\t\t\t\tFROM #__booklibrary_review AS a\n\t\t\t\tWHERE a.fk_userid = 0) AS e" . "\n WHERE a.fk_bookid = b.id\n\t\t\tAND b.id = w.bookid AND w.catid = c.id AND a.fk_userid = e.fk_userid\n\n\t\t\tGROUP BY review_id\n\t\t\tORDER by date" . "\n LIMIT {$pageNav->limitstart},{$pageNav->limit};";
    }
    $database->setQuery($request_string);
    $reviews = $database->loadObjectList();
    //**************   end request for reviews manager   ***************************/
    HTML_booklibrary::showManageReviews($option, $pageNav, $reviews);
}