<?php

class Core extends Config
{
    protected $template;
    protected $discount=0;
   

    public function __construct()
    {
	$this->smarty = new Smarty();
	$this->smarty->template_dir = $_SERVER['DOCUMENT_ROOT'] . '/tmpl/templates';
	$this->smarty->compile_dir = $_SERVER['DOCUMENT_ROOT'] . '/tmpl/templates_c';
	$this->db = new goDB($this->config);
	$this->db->query("SET NAMES utf8");
        if(isset($_COOKIE['SESSID']))
        {
            session_start();
            if(isset($_SESSION['LOGIN']))
            {
                $this->smarty->assign('user_login', $_SESSION['LOGIN']);
                $this->discount = $_SESSION['DISCOUNT'];
            }
        }
    }
    
    protected function cartinfo()
    {
        $pattern = 'SELECT 
                        temp1.temporderdetail_quantity * CEIL(temp2.product_price -(temp2.product_price/100*'.$this->discount.')) as subtotal,
                        temp1.temporderdetail_quantity as quantity
                    FROM 
                        temporderdetail as temp1
                    LEFT JOIN
                        product as temp2
                    ON
                        temp2.product_id = temp1.product_id
                    WHERE 
                        temp1.temporderdetail_sesid=?';
        
        $data = array(session_id());
        $table = $this->db->query($pattern, $data, 'assoc');
         
        
        if(!empty($table)) 
        {
            $sumprod=0;
            $quant=0;
            
            $this->smarty->assign('session', true);
            $_SESSION['cart'] = true;
            foreach($table as $row) 
            {
                $sumprod += $row['subtotal'];
                $quant += $row['quantity'];
            
            }
            $sumprod = number_format($sumprod, 0, '', ', '); 
            $this->smarty->assign('numberofproducts', $quant); 
            $this->smarty->assign('sumoforder', $sumprod);
        }
        else
        {
            $_SESSION['cart'] = false; 
        }
    }
    
    private function _shownews()
    {
        $news = $this->db->query('SELECT 
                                     news_id,
                                     DATE_FORMAT(news_date, "%d-%m-%Y") as news_date, 
                                     news_header
                                  FROM 
                                     news
                                  ORDER BY 
                                     news_date DESC LIMIT 10 ', array(), 'assoc');
        $this->smarty->assign('news', $news);
        
    }
    
    protected function _paginator($sql, $sqldata, $pagetodisplay, $rowonpage)
    {
        $countofrows = $this->db->query($sql, $sqldata, 'num');
        $totalpages = ceil($countofrows/$rowonpage); //Общее коичество страниц в результате запроса
        
        if($countofrows <= $rowonpage) //Если менее одной страницы
            $pageline = NULL;
        elseif($totalpages < $pagetodisplay) //Если запрошенная страница больше, чем можно отобразить.
            $pageline = FALSE;
        else 
        {
            $start = ($pagetodisplay-1)*$rowonpage;
            $sql .= " LIMIT $start, $rowonpage";
            
            if($totalpages <= 9)
            {
                for($i=1; $i<=$totalpages; $i++)
                {
                    if($pagetodisplay == $i)
                        $pageline[]=$i*(-1);
                    else
                        $pageline[]=$i;
                }
            }
            elseif($pagetodisplay > 5 && $pagetodisplay <= $totalpages-5) 
            {
                $pageline=array(1,0);
                for($i=$pagetodisplay-3;  $i<=$pagetodisplay+3; $i++)
                {
                    if($pagetodisplay == $i)
                        $pageline[]=$i*(-1);
                    else
                        $pageline[]=$i;
                }
                $pageline[]=0;
                $pageline[]=$totalpages;
            }
            elseif($pagetodisplay <= 5 && $totalpages > 9) 
            {
                for($i=1; $i<=7; $i++)
                {
                    if($pagetodisplay == $i)
                        $pageline[]=$i*(-1);
                    else
                        $pageline[]=$i;
                }
                $pageline[]=0;
                $pageline[]=$totalpages;
            }
            elseif($pagetodisplay > 5 && $pagetodisplay > $totalpages-5)
            {
                $pageline=array(1,0);
                for($i=$totalpages-6; $i<=$totalpages; $i++)
                {
                    if($pagetodisplay == $i)
                        $pageline[]=$i*(-1);
                    else
                        $pageline[]=$i;
                }
            }
            
        }
        return(array('sql' => $sql, 'pageline' => $pageline));
    }
	    
    public function __destruct()
    {
        if(!empty($_SESSION['cart']) && !isset($_SESSION['admin']))
            $this->cartinfo(); //отображаем содержимое корзины
        $this->_shownews(); //показать новости
        if($this->template)
	   $this->smarty->display($this->template);
	else
           $this->smarty->display('error/error_pagenotfound.tpl');
    }
}
?>

<?php
class search extends Core
{
    public function show()
    {
        $pattern='SELECT 
                        temp1.product_id,
                        temp1.product_partnumber,
                        temp1.product_description,
                        CEIL(temp1.product_price - (temp1.product_price/100*' . $this->discount . ')) AS product_price,
                        temp2.photo_id
                  FROM 
                        product AS temp1 
                  LEFT JOIN
                        photo AS temp2
                  ON
                        temp1.product_id = temp2.product_id
                  WHERE 
                        product_description LIKE CONCAT("%", ?, "%") OR 
                        product_partnumber LIKE CONCAT("%", ?, "%")';
        
        if(!isset($_GET['partnumber']))
        {
            $_GET['partnumber']='';
        }
        
        $patterndata = array($_GET['partnumber'], $_GET['partnumber']);
        
        if(isset($_GET['page']) && (int)$_GET['page'] > 0) //нормальный номер страницы
        {
            $page=(int)$_GET['page'];
            $new_pattern = $this->_paginator($pattern, $patterndata, $page, 10);
            if($new_pattern['pageline'] === FALSE || $new_pattern['pageline'] === NULL) //нет такой страницы. Или одна страница
            {
               header("HTTP/1.0 404 Not Found");
               $this->template='error/error_pagenotfound.tpl';
               exit();
            }

        }   
        elseif(isset($_GET['page']) && (int)$_GET['page']<=0) //подсунули бяку
        {
            header("HTTP/1.0 404 Not Found");
            $this->template='error/error_pagenotfound.tpl';
            exit();
        }
        else
        {
            $new_pattern = $this->_paginator($pattern, $patterndata, 1, 10);
        }
        
        $data = $this->db->query($new_pattern['sql'], $patterndata, 'assoc');
        $this->smarty->assign('request', $_GET['partnumber']);
        $this->smarty->assign('pagebar', $new_pattern['pageline']);
        $this->smarty->assign('data', $data);
        $this->template='blocks/blocks_search.tpl';
    }
    
}
?>