Exemple #1
0
 function debits()
 {
     if (isset($_SESSION['user_id'])) {
         $user_id = $_SESSION['user_id'];
         if (isset($_GET['page'])) {
             $page = tools::filter($_GET['page']);
         } else {
             $page = 1;
         }
         $sql = "SELECT auction_id, description, debit, created FROM " . DB_PREFIX . "bids";
         if (isset($_GET['auction_id'])) {
             $conditions = "WHERE user_id=" . $user_id . " AND debit > 0 AND credit = 0 AND auction_id=" . $_GET['auction_id'] . " ORDER BY created DESC";
         } else {
             $conditions = "WHERE user_id=" . $user_id . " AND debit > 0 AND credit = 0 ORDER BY created DESC";
         }
         list($bids, $pagination) = tools::paginate($sql, $conditions, "" . DB_PREFIX . "bids", $page, $this->settings['app']['per_page']);
         $this->smarty->assign(array('bids' => $bids, 'pagination' => $pagination));
         $this->smarty->display('user/debits.tpl');
     } else {
         tools::setFlash($this->l('Please log in to access this area'), 'error');
         tools::redirect('/user/login');
     }
 }