mambax7 / bookshop

recommended.php

<?php
/**
 * ****************************************************************************
 * bookshop - MODULE FOR XOOPS
 * Copyright (c) Hervé Thouzard of Instant Zero (http://www.instant-zero.com)
 * ****************************************************************************
 */

/**
 * Displays a list of recommended books
 */

include __DIR__ . '/header.php';
$GLOBALS['current_category']  = -1;
$xoopsOption['template_main'] = 'bookshop_recommended.tpl';
include_once XOOPS_ROOT_PATH . '/header.php';
include_once BOOKSHOP_PATH . 'class/registryfile.php';
include_once XOOPS_ROOT_PATH . '/class/pagenav.php';

// Initialisations
$tbl_books         = $tbl_categories = $tbl_lang = $tbl_users = $tbl_tmp_user = $tbl_tmp_categ = $tbl_tmp_lang = $tbl_tmp_vat = $tbl_vat = array();
$tbl_books_id      = $tbl_auteurs = $tbl_infos_auteurs = $tbl_tmp_auteurs = array();
$tbl_tmp_related   = $tbl_related = $tbl_info_related_books = array();
$tbl_related_books = array();
$start             = isset($_GET['start']) ? (int)$_GET['start'] : 0;
$limit             = bookshop_getmoduleoption('perpage');                // Maximum number of items to display in the admin
$baseurl           = BOOKSHOP_URL . basename(__FILE__);                    // URL of the script (no name)

$registry = new bookshop_registryfile();

// Some options for template
$xoopsTpl->assign('nostock_msg', bookshop_getmoduleoption('nostock_msg'));
$xoopsTpl->assign('mod_pref', $mod_pref);    // Module Preferences
$xoopsTpl->assign('welcome_msg', nl2br($registry->getfile('bookshop_recomm.txt')));

$itemsCount = $h_bookshop_books->getRecommendedCount();
if ($itemsCount > $limit) {
    $pagenav = new XoopsPageNav($itemsCount, $limit, $start);
    $xoopsTpl->assign('pagenav', $pagenav->renderNav());
}

if ($limit > 0) {

This code seems to be duplicated across your project.

    // Get the list of recent books
    $tbl_books = $h_bookshop_books->getRecentRecommendedBooks($start, $limit);

    // Get ID only necessary
    foreach ($tbl_books as $item) {
        $tbl_tmp_user[]  = $item->getVar('book_submitter');
        $tbl_tmp_categ[] = $item->getVar('book_cid');
        $tbl_tmp_lang[]  = $item->getVar('book_lang_id');
        $tbl_tmp_vat[]   = $item->getVar('book_vat_id');
        $tbl_books_id[]  = $item->getVar('book_id');
    }
    // Dedupe tables
    $tbl_tmp_user  = array_unique($tbl_tmp_user);
    $tbl_tmp_categ = array_unique($tbl_tmp_categ);
    $tbl_tmp_lang  = array_unique($tbl_tmp_lang);
    $tbl_tmp_vat   = array_unique($tbl_tmp_vat);

    sort($tbl_tmp_user);
    sort($tbl_tmp_categ);
    sort($tbl_tmp_lang);
    sort($tbl_tmp_vat);
    sort($tbl_books_id);

    // Get the list of authors
    // On commence en cherchant la liste de tous les auteurs et traducteurs de tous les livres
    $tbl_books_auteurs = array();
    $tbl_auteurs       = $h_bookshop_booksauthors->getObjects(new Criteria('ba_book_id', '(' . implode(',', $tbl_books_id) . ')', 'IN'), true);
    if (count($tbl_auteurs) > 0) {
        foreach ($tbl_auteurs as $item) {
            $tbl_tmp_auteurs[] = $item->getVar('ba_auth_id');
            // Grouping data by book
            $tbl_books_auteurs[$item->getVar('ba_book_id')][] = $item;
        }
        $tbl_tmp_auteurs = array_unique($tbl_tmp_auteurs);
        sort($tbl_tmp_auteurs);
        //  Then recovered the information from these authors / translators
        $tbl_infos_auteurs = $h_bookshop_authors->getObjects(new Criteria('auth_id', '(' . implode(',', $tbl_tmp_auteurs) . ')', 'IN'), true);
    }

    // Get a list of all related books
    $tbl_related = $h_bookshop_related->getObjects(new Criteria('related_book_id', '(' . implode(',', $tbl_books_id) . ')', 'IN'), true);
    foreach ($tbl_related as $item) {
        $tbl_tmp_related[]                                     = $item->getVar('related_book_related');
        $tbl_related_books[$item->getVar('related_book_id')][] = $item;
    }
    $tbl_tmp_related = array_unique($tbl_tmp_related);
    sort($tbl_tmp_related);

    // Then we grab the title and ID book
    if (count($tbl_tmp_related) > 0) {
        $tbl_info_related_books = $h_bookshop_books->getIdTitle(new Criteria('book_id', '(' . implode(',', $tbl_tmp_related) . ')', 'IN'));
    }

    // Get the list of categories
    if (count($tbl_tmp_categ) > 0) {
        $tbl_categories = $h_bookshop_cat->getObjects(new Criteria('cat_cid', '(' . implode(',', $tbl_tmp_categ) . ')', 'IN'), true);
    }

    // Get the list of languages
    if (count($tbl_tmp_lang) > 0) {
        $tbl_lang = $h_bookshop_lang->getObjects(new Criteria('lang_id', '(' . implode(',', $tbl_tmp_lang) . ')', 'IN'), true);
    }

    // Get the list of VAT
    if (count($tbl_tmp_vat) > 0) {
        $tbl_vat = $h_bookshop_vat->getObjects(new Criteria('vat_id', '(' . implode(',', $tbl_tmp_vat) . ')', 'IN'), true);
    }

    // Get the list of people who have published these recent books
    if (count($tbl_tmp_user) > 0) {
        $user_handler = $member_handler = xoops_getHandler('user');
        $criteria     = new Criteria('uid', '(' . implode(',', $tbl_tmp_user) . ')', 'IN');
        $tbl_users    = $user_handler->getObjects($criteria, true);
    }

    // Process books
    $lastTitle = '';
    foreach ($tbl_books as $item) {
        $tbl_tmp = array();
        $tbl_tmp = $item->toArray();
        if (xoops_trim($lastTitle) == '') {
            $lastTitle = $item->getVar('book_title');
        }
        $tbl_tmp['book_category'] = $tbl_categories[$item->getVar('book_cid')];
        $tbl_tmp['book_language'] = $tbl_lang[$item->getVar('book_lang_id')];
        $thisuser                 = $tbl_users[$item->getVar('book_submitter')];
        if (xoops_trim($thisuser->getVar('name')) != '') {
            $name = $thisuser->getVar('name');
        } else {
            $name = $thisuser->getVar('uname');
        }
        $tbl_tmp['book_submiter_name']      = $name;
        $linkeduser                         = '<a href="' . XOOPS_URL . '/userinfo.php?uid=' . $thisuser->getVar('uid') . '">' . $name . '</a>';
        $tbl_tmp['book_submiter_link']      = $name;
        $tbl_tmp['book_vat_rate']           = $tbl_vat[$item->getVar('book_vat_id')];
        $tbl_tmp['book_price_ttc']          = bookshop_getTTC($item->getVar('book_price'), $tbl_vat[$item->getVar('book_vat_id')]->getVar('vat_rate'));
        $tbl_tmp['book_discount_price_ttc'] = bookshop_getTTC($item->getVar('book_discount_price'), $tbl_vat[$item->getVar('book_vat_id')]->getVar('vat_rate'));

        // Search for  authors / translators
        $tbl_join1 = $tbl_join2 = array();
        if (isset($tbl_books_auteurs[$item->getVar('book_id')])) {
            $tbl_tmp2 = $tbl_books_auteurs[$item->getVar('book_id')];    // Returns a list of all authors / translators of a book
        } else {
            $tbl_tmp2 = array();
        }
        $tbl_livre_auteurs = $tbl_livre_traducteurs = array();
        foreach ($tbl_tmp2 as $oneauthor) {
            $auteur = $tbl_infos_auteurs[$oneauthor->getVar('ba_auth_id')];
            if ($oneauthor->getVar('ba_type') == 1) {
                $tbl_livre_auteurs[] = $auteur->toArray();
                $tbl_join1[]         = $auteur->getVar('auth_firstname') . ' ' . $auteur->getVar('auth_name');
            } else {
                $tbl_livre_traducteurs[] = $auteur->toArray();
                $tbl_join2[]             = $auteur->getVar('auth_firstname') . ' ' . $auteur->getVar('auth_name');
            }
        }
        if (count($tbl_join1) > 0) {
            $tbl_tmp['book_joined_authors'] = implode(', ', $tbl_join1);
        }
        if (count($tbl_join2) > 0) {
            $tbl_tmp['book_joined_translators'] = implode(', ', $tbl_join2);
        }
        $tbl_tmp['book_authors']     = $tbl_livre_auteurs;
        $tbl_tmp['book_translators'] = $tbl_livre_traducteurs;

        // Recherche des livres relatifs, s'il y en a !
        $tbl_related = $tbl_tmp2 = array();
        if (isset($tbl_related_books[$item->getVar('book_id')])) {
            $tbl_tmp2 = $tbl_related_books[$item->getVar('book_id')];    // Contient la liste des livres relatifs � CE livre
            foreach ($tbl_tmp2 as $onerelated) {
                $book_id = $onerelated->getVar('related_book_id');
                if (isset($tbl_info_related_books[$book_id])) {
                    $tbl_related[] = array('related_book_id' => $book_id, 'related_book_title' => $tbl_info_related_books[$book_id]);
                }
            }
        }
        $tbl_tmp['book_related_books'] = $tbl_related;
        // Et on place le tout dans le template
        $xoopsTpl->append('books', $tbl_tmp);
    }
}

bookshop_setCSS();
bookshop_set_metas(_BOOKSHOP_RECOMMENDED . ' - ' . bookshop_get_module_name(), bookshop_get_module_name());
include_once(XOOPS_ROOT_PATH . '/footer.php');