<?
require_once 'common.php';
require_once 'core.php';

class Base{
	var $mySQL;
	var $myResult;
	var $myInit;
	var $myCountry;
	var $mySetup;
	
	function __construct()
        {
            $this->myInit = new init();
            $this->mySQL = new sql($this->myInit);

            $statement = 'select s.id_mena,s.mjazyk,men.kod,s.upload_foto_limit,s.gen_vodoznak,s.zob_autorska_odmena,s.autom_slevovy_kupon,s.zob_recyklacni_poplatek,s.ceny_dle_dkat,s.dealerska_sleva_katalog,rabat_ds,mnslv_castka,mnslv_katalog,filtr_katalog,distr_flt_automat,s.id_datove_schema,ds.telefon as telefon_ds,ds.email as email_ds,ds.nazev as nazev_ds from setup s left join cc_mena men on men.id = s.id_mena left join datove_schema ds on ds.id = s.id_datove_schema  LIMIT 1';
            $tmp = $this->mySQL->select($statement);
            for ($i=0;$i<count($tmp);$i++)
            {
                $this->mySetup["lang"]=$tmp[$i]["mjazyk"];
                $this->mySetup["mena"]=$tmp[$i]["kod"];
                $this->mySetup["id_mena"]=$tmp[$i]["id_mena"];
                $this->mySetup["zob_autorska_odmena"]=$tmp[$i]["zob_autorska_odmena"];
                $this->mySetup["zob_recyklacni_poplatek"]=$tmp[$i]["zob_recyklacni_poplatek"];
                $this->mySetup["ceny_dle_dkat"]=$tmp[$i]["ceny_dle_dkat"];
                $this->mySetup["autom_slevovy_kupon"]=$tmp[$i]["autom_slevovy_kupon"];
                $this->mySetup["dealerska_sleva_katalog"]=$tmp[$i]["dealerska_sleva_katalog"];
                $this->mySetup["gen_vodoznak"]=$tmp[$i]["gen_vodoznak"];
                $this->mySetup["rabat_ds"]=$tmp[$i]["rabat_ds"];
                $this->mySetup["mnslv_castka"]=$tmp[$i]["mnslv_castka"];
                $this->mySetup["mnslv_katalog"]=$tmp[$i]["mnslv_katalog"];
                $this->mySetup["upload_foto_limit"]=$tmp[$i]["upload_foto_limit"];
                $this->mySetup["filtr_katalog"]=$tmp[$i]["filtr_katalog"];
                $this->mySetup["distr_flt_automat"]=$tmp[$i]["distr_flt_automat"];
                $this->mySetup["email_ds"]=$tmp[$i]["email_ds"];
                $this->mySetup["telefon_ds"]=$tmp[$i]["telefon_ds"];
                $this->mySetup["nazev_ds"]=$tmp[$i]["nazev_ds"];
            }
	}
	function getInit(){
		return $this->myInit;
	}

	function getSetup()
	{
		return $this->mySetup;
	}
	
	function getNavId($reqText)
	{
		$statement = 'select id from kategorie where nazev = "'.$reqText.'" and finalni="A" and zobrazovat="A" limit 1';
		$tmp = $this->mySQL->select($statement);
		if ($this->mySQL->getRows()==0):
			$rtn = "";
		else:
			$rtn = $tmp[0]["id"];
		endif;
		return $rtn;
	}

	function genKlic($delka=7)
	{
		$moznosti='abcdefghijklmnopqrstuvwxyz'. 
		      'ABCDEFGHIJKLMNOPQRSTUVWXYZ'. 
		      '0123456789';
	
		$klic=""; 
		while(strlen($klic) < $delka) { 
		  $klic .= substr($moznosti, mt_rand(0, strlen($moznosti) - 1), 1); 
		  } 
		return $klic; 
	}

	function getHledejNazev($reqNazev){
		$statement = 'select a.id,a.id_kategorie,k.id_parent as parent,k1.id_parent as parent1 from katalog a left join kategorie k on k.id = a.id_kategorie left join kategorie k1 on k1.id = k.id_parent where a.nazev like "%'.$reqNazev.'%"';
//echo $statement;
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["id_kategorie"] = -1;
			$rtn[0]["parent"] = -1;
			$rtn[0]["parent1"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["kategorie"] = $this->myResult[$i]["id_kategorie"];
				if ($this->myResult[$i]["parent1"]!=""):
					$rtn[$i]["parent"] = $this->myResult[$i]["parent1"];
					$rtn[$i]["subparent"] = $this->myResult[$i]["parent"];
				else:
					$rtn[$i]["parent"] = $this->myResult[$i]["parent"];
					$rtn[$i]["subparent"] = "";
				endif;						
			}		
		endif;
		return $rtn;					
	}
    function getHledejModel($reqNazev){
        $statement = 'select a.id,a.id_kategorie,k.id_parent as parent,k1.id_parent as parent1 from katalog a left join kategorie k on k.id = a.id_kategorie left join kategorie k1 on k1.id = k.id_parent where a.model like "%'.$reqNazev.'%"';
//echo $statement;
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["id_kategorie"] = -1;
            $rtn[0]["parent"] = -1;
            $rtn[0]["parent1"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++){
                $rtn[$i]["id"] = $this->myResult[$i]["id"];
                $rtn[$i]["kategorie"] = $this->myResult[$i]["id_kategorie"];
                if ($this->myResult[$i]["parent1"]!=""):
                    $rtn[$i]["parent"] = $this->myResult[$i]["parent1"];
                    $rtn[$i]["subparent"] = $this->myResult[$i]["parent"];
                else:
                    $rtn[$i]["parent"] = $this->myResult[$i]["parent"];
                    $rtn[$i]["subparent"] = "";
                endif;                        
            }        
        endif;
        return $rtn;                    
    }
    function getSkupina($reqId){
            $statement = 'select objednavka from skupina where id = "'.$reqId.'"';
//echo $statement;
            $this->myResult = $this->mySQL->select($statement);

            if ($this->mySQL->getRows() == 0):
                    $rtn = -1;
            else:
                    for ($i=0;$i<count($this->myResult);$i++){
                            $rtn = $this->myResult[$i]["objednavka"];
                    }		
            endif;
            return $rtn;					
    }
    function getOrientation()
    {
        $statement = 'select kod,nazev,id from cc_orientation order by nazev ASC';
        $arrOrientation = $this->mySQL->select($statement);
        $rtn = $arrOrientation;
        return $rtn;
    }    
    function getLokalita($reqId="")
    {
        if ($reqId!=""):
            $statement = 'select * from cc_rozvoz_lokalita where id = "'.$reqId.'"';
        else:
            $statement = 'select * from cc_rozvoz_lokalita order by nazev ASC';
        endif;
            
//echo $statement;
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
            $rtn[0]["limit_objednavek"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                $rtn[$i]["id"] = $this->myResult[$i]["id"];
                $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                $rtn[$i]["limit_objednavek"] = $this->myResult[$i]["limit_objednavek"];
            }		
        endif;
        return $rtn;					
    }
    function getJazyk($reqId=""){
        $statement = 'select kod,id,nazev,kurz,id_mena from cc_jazyky '.decode($reqId=="",'',' where id = "'.$reqId.'"');
//echo $statement;
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["kod"] = -1;
            $rtn[0]["nazev"] = -1;
            $rtn[0]["kurz"] = -1;
            $rtn[0]["id_mena"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++){
                $rtn[$i]["id"] = $this->myResult[$i]["id"];
                $rtn[$i]["kod"] = $this->myResult[$i]["kod"];
                $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                $rtn[$i]["kurz"] = $this->myResult[$i]["kurz"];
                $rtn[$i]["id_mena"] = $this->myResult[$i]["id_mena"];
            }        
        endif;
        return $rtn;                    
    }
    function getSk($varLang,$reqId="")
    {
        $rtn = array();

        if ($reqId==""):
            $statement = 'select id,nazev from skupina order by nazev ASC'; 
        else:
            $statement = 'select id,nazev from skupina where id = "'.$reqId.'" order by nazev ASC'; 
        endif;    
        
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'skupina','nazev');
                endif;        
            }
        endif;
        return $rtn;
        
    }  
    
    function getMena($reqId="")
    {
        $rtn = array();

        if ($reqId==""):
            $statement = 'select id,kod from cc_mena order by kod ASC'; 
        else:
            $statement = 'select id,kod from cc_mena where id = "'.$reqId.'" order by kod ASC'; 
        endif;    
        
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["kod"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
//                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["kod"] = $this->myResult[$i]["kod"];
//                else:
//                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
//                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'skupina','nazev');
//                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'skupina','nazev');
//                endif;        
            }
        endif;
        return $rtn;
        
    }  
    
	function getRealKatalogFiltr($reqIdKatalog){
                if ($this->mySetup["filtr_katalog"]=="N"):
                    $statement = 'select kf.id,fl.nazev from katalog_filtr kf join filtr fl on fl.id = kf.id_filtr left join skupina sk on sk.id = fl.id_skupina  where kf.id_katalog = "'.$reqIdKatalog.'" and kf.prirazen = "A" and fl.id_katalog is null and sk.objednavka="A"';
                else:
                    $statement = 'select kf.id,fl.nazev from katalog_filtr kf join filtr fl on fl.id = kf.id_filtr left join skupina sk on sk.id = fl.id_skupina  where kf.id_katalog = "'.$reqIdKatalog.'" and kf.prirazen = "A" and fl.id_katalog = "'.$reqIdKatalog.'" and sk.objednavka="A"';
                endif;
//echo $statement;
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["nazev"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
			}		
		endif;
		return $rtn;					
	}


	function getHledejEvCis($reqEvcis){
		$statement = 'select a.id,a.id_kategorie,k.id_parent as parent,k1.id_parent as parent1 from katalog a left join kategorie k on k.id = a.id_kategorie left join kategorie k1 on k1.id = k.id_parent where a.evidencni_cislo = "'.$reqEvcis.'"';
//echo $statement;
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["id_kategorie"] = -1;
			$rtn[0]["parent"] = -1;
			$rtn[0]["parent1"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["kategorie"] = $this->myResult[$i]["id_kategorie"];
				if ($this->myResult[$i]["parent1"]!=""):
					$rtn[$i]["parent"] = $this->myResult[$i]["parent1"];
					$rtn[$i]["subparent"] = $this->myResult[$i]["parent"];
				else:
					$rtn[$i]["parent"] = $this->myResult[$i]["parent"];
					$rtn[$i]["subparent"] = "";
				endif;						
			}		
		endif;
		return $rtn;					
	}
	function getHledejVyrobce($reqNazev){
		$statement = 'select a.id,a.id_kategorie,k.id_parent as parent,k1.id_parent as parent1 from katalog a left join kategorie k on k.id = a.id_kategorie left join kategorie k1 on k1.id = k.id_parent left join vyrobce v on v.id = a.id_vyrobce where v.nazev like "%'.$reqNazev.'%"';
//echo $statement;
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["id_kategorie"] = -1;
			$rtn[0]["parent"] = -1;
			$rtn[0]["parent1"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["kategorie"] = $this->myResult[$i]["id_kategorie"];
				if ($this->myResult[$i]["parent1"]!=""):
					$rtn[$i]["parent"] = $this->myResult[$i]["parent1"];
					$rtn[$i]["subparent"] = $this->myResult[$i]["parent"];
				else:
					$rtn[$i]["parent"] = $this->myResult[$i]["parent"];
					$rtn[$i]["subparent"] = "";
				endif;						
			}		
		endif;
		return $rtn;					
	}

	function getNavigaceBack($reqID){
		$statement = 'SELECT id_kategorie FROM katalog WHERE id = "'.$reqID.'"';
		$tmpKat = $this->mySQL->select($statement);
		
		$rtn["kategorie"] = $tmpKat[0]["id_kategorie"];
		
		$statement = 'select id_parent from kategorie where id = "'.$tmpKat[0]["id_kategorie"].'"';
		$tmpParent0 = $this->mySQL->select($statement);
		
		if ($tmpParent0[0]["id_parent"]==""):
			$rtn["parent"] = $tmpKat[0]["id_kategorie"];
			$rtn["subparent"] = "";
		else:
			$statement = 'select id_parent from kategorie where id = "'.$tmpParent0[0]["id_parent"].'"';
			$tmpParent1 = $this->mySQL->select($statement);
			if ($tmpParent1[0]["id_parent"]==""):
				$rtn["parent"] = $tmpParent0[0]["id_parent"];
				$rtn["subparent"] = $tmpKat[0]["id_kategorie"];
			else:
				$rtn["parent"] = $tmpParent1[0]["id_parent"];
				$rtn["subparent"] = $tmpParent0[0]["id_parent"];
			endif;
		endif;
		return $rtn;
	}
    
    function getLang($varLang,$reqId,$reqTab,$reqCol){
        $statement = 'select id,typ from mutace where tabulka = "'.$reqTab.'" and sloupec = "'.$reqCol.'"';
        $tmpDefinice = $this->mySQL->select($statement);
        
        for ($i=0;$i<count($tmpDefinice);$i++){
            $statement = 'select hodnota_'.$tmpDefinice[$i]["typ"].' from mutace_data where id_mutace = "'.$tmpDefinice[$i]["id"].'" and id_zdroj = "'.$reqId.'" and jazyk = "'.$varLang.'"';
    
//    echo $statement;
    
            $tmpTrans = $this->mySQL->select($statement);
            if ($this->mySQL->getRows()==0):
                return -2;
            else:
                return $tmpTrans[0]["hodnota_".$tmpDefinice[$i]["typ"]];
            endif;    
        }
        
    }
	
    function getDostupnost($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from cc_dostupnost order by nazev ASC'; 
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_dostupnost','nazev');
                endif;        
            }
        endif;
        return $rtn;
    }
    function getDealerskaKategorie($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from dealerska_kategorie order by nazev ASC'; 
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'dealerska_kategorie','nazev');
                endif;        
            }
        endif;
        return $rtn;
    }
    function getDodavka($varLang,$reqId='')
    {
        $rtn = array();
        if ($reqId == ''):
            $statement = 'select id,nazev from cc_dodavka order by nazev ASC'; 
        else:
            $statement = 'select id,nazev from cc_dodavka where id = '.$reqId.' order by nazev ASC'; 
        endif;
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_dodavka','nazev');
                endif;        
            }
        endif;
        return $rtn;
    }
    function getZpusobPlatby($varLang,$reqId='')
    {
        $rtn = array();

        if ($reqId == ''):
            $statement = 'select id,nazev from cc_zpusob_platby order by poradi,nazev'; 
        else:
            $statement = 'select id,nazev from cc_zpusob_platby where id = '.$reqId.' order by poradi,nazev'; 
        endif;
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_zpusob_platby','nazev');
                endif;        
            }
        endif;
        return $rtn;
    }    

    function getStat($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from cc_stat order by nazev'; 
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_stat','nazev');
                endif;        
            }
        endif;
        return $rtn;
    }

    function getVydejniMisto($varLang,$zpDodani='',$id='')
    {
        $rtn = array();

        if ($id==''):
            if ($zpDodani==''):
                $statement = 'select id,nazev,adresa,psc,mesto,telefon,gps,text from cc_vydejni_misto order by nazev'; 
            else:
                $statement = 'select v.id,v.nazev,v.adresa,v.psc,v.mesto,v.telefon,v.gps,v.text from cc_vydejni_misto v join cc_dodavka_cc_vydejni_misto dvm on dvm.id_vydejni_misto = v.id where dvm.id_dodavka = '.$zpDodani.' order by nazev'; 
            endif;
        else:
            $statement = 'select id,nazev,adresa,psc,mesto,telefon,gps,text from cc_vydejni_misto where id = '.$id.' order by nazev'; 
        endif;
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
            $rtn[0]["adresa"] = -1;
            $rtn[0]["psc"] = -1;
            $rtn[0]["mesto"] = -1;
            $rtn[0]["telefon"] = -1;
            $rtn[0]["gps"] = -1;
            $rtn[0]["text"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                $rtn[$i]["id"] = $this->myResult[$i]["id"];
                $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                $rtn[$i]["adresa"] = $this->myResult[$i]["adresa"];
                $rtn[$i]["psc"] = $this->myResult[$i]["psc"];
                $rtn[$i]["mesto"] = $this->myResult[$i]["mesto"];
                $rtn[$i]["telefon"] = $this->myResult[$i]["telefon"];
                $rtn[$i]["gps"] = $this->myResult[$i]["gps"];
                $rtn[$i]["text"] = $this->myResult[$i]["text"];
/*
                if ($varLang == $this->mySetup["lang"]):
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_stat','nazev');
                endif;        
 * 
 */
            }
        endif;
        return $rtn;
    }
    
    function getSoutez($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from soutez order by plati_od DESC'; 
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'soutez','nazev');
                endif;        
            }
        endif;
        return $rtn;
    }
    
    function getVyrobce($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from vyrobce order by nazev ASC'; 
        
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'vyrobce','nazev');
                endif;        
            }
        endif;
        return $rtn;
        
    }
    function getOblast($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from oblast order by nazev ASC'; 
        
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'oblast','nazev');
                endif;        
            }
        endif;
        return $rtn;
        
    }
    
    function getZaruka($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from cc_zaruka order by nazev ASC'; 
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_zaruka','nazev');
                endif;        
            }
        endif;
        return $rtn;
        
    }

    function getAtribut($varLang,$reqNazev)
    {
        $rtn = array();

        $statement = 'select id,nazev from cc_atribut where nazev = "'.$reqNazev.'" order by nazev ASC'; 
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_atribut','nazev');
                endif;        
            }
        endif;
        return $rtn;
        
    }

   function getSektor($varLang)
    {
        $rtn = array();

        $statement = 'select id,nazev from cc_sektor_kategorie order by nazev ASC'; 
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_sektor_kategorie','nazev');
                endif;        
            }
        endif;
        return $rtn;
        
    }

    function getFiltr($varLang,$reqNazev)
    {
        $rtn = array();

        $statement = 'select id,nazev from cc_filtr where nazev = "'.addslashes($reqNazev).'" order by nazev ASC'; 
        
        
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++)
            {
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'cc_filtr','nazev');
                endif;        
            }
        endif;
        return $rtn;
        
    }

    
	function getMain($reqID="",$lang=''){
		$rtn = array();
		if ($reqID == ''):	
			$statement = 'select id,nazev,text,zadano from main order by zadano desc';
		else:
			$statement = 'select id,nazev,text,zadano from main where id = "'.$reqID.'"';
		endif;	
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["nazev"] = -1;
			$rtn[0]["text"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				if ($lang == $this->mySetup["lang"]):
					$rtn[$i]["id"] = $this->myResult[$i]["id"];
					$rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
					$rtn[$i]["text"] = nl2br($this->myResult[$i]["text"]);
				else:
					$rtn[$i]["id"] = -1;
					$rtn[$i]["nazev"] = -1;
					$rtn[$i]["text"] = -1;
				endif;		
			}		
		endif;
		return $rtn;					
	}

	function getKatalog($varLang,$reqID="",$reqNovinka="N",$reqVyprodej="N",$reqUser=""){
//print_r($reqFiltr);

		$rtn = array();
	
		if ($reqID == ""):
			$statement = 'select a.id,a.id_kategorie,a.id_sazba_dph,a.id_vyrobce,a.evidencni_cislo,a.nazev,a.novinka,a.vyprodej,a.doporucujeme,a.url_vyrobce,a.popis,a.zkracene,a.cena_mo,a.cena_vo,a.cena_dop,a.elektroodpad,a.autorska_odmena,zar.nazev as zaruka,s.sazba,v.nazev as vyrobce,a.pevna_koncova_cena from katalog a left join cc_sazba_dph s on s.id = a.id_sazba_dph left join vyrobce v on v.id = a.id_vyrobce left join cc_zaruka zar on zar.id = a.id_zaruka where a.id is not null '.decode($reqNovinka=="A",' and a.novinka="A"','').decode($reqVyprodej=="A",' and a.vyprodej="A"','');
		else:
			$statement = 'select a.id,a.id_kategorie,a.id_sazba_dph,a.id_vyrobce,a.evidencni_cislo,a.nazev,a.novinka,a.vyprodej,a.doporucujeme,a.url_vyrobce,a.popis,a.zkracene,a.cena_mo,a.cena_vo,a.cena_dop,a.elektroodpad,a.autorska_odmena,zar.nazev as zaruka,s.sazba,v.nazev as vyrobce,a.pevna_koncova_cena from katalog a left join cc_sazba_dph s on s.id = a.id_sazba_dph left join vyrobce v on v.id = a.id_vyrobce left join cc_zaruka zar on zar.id = a.id_zaruka where a.id = "'.$reqID.'"';
		endif;	

		$tmpResult = $this->mySQL->select($statement);
		$tmpTotal = $this->mySQL->getRows();

//echo $statement;

		$this->myResult = $this->mySQL->select($statement);

        $statement = 'select ifnull(jaz.kurz,1) as kurz,men.kod,jaz.id_mena from cc_jazyky jaz left join cc_mena men on men.id = jaz.id_mena where jaz.kod = "'.$varLang.'"';
        $tmp = $this->mySQL->select($statement,$reqCpNames);
        if ($this->mySQL->getRows()==0):
            $kurz = 1;
            $mena = $this->mySetup["mena"];
            $id_mena = $this->mySetup["id_mena"];
        else:
            $kurz = $tmp[0]["kurz"];
            $mena = $tmp[0]["kod"];
            $id_mena = $tmp[0]["id_mena"];
        endif;
        
        
		if ($tmpTotal == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["id_kategorie"] = -1;
			$rtn[0]["nazev"] = -1;
			$rtn[0]["evidencni_cislo"] = -1;
			$rtn[0]["popis"] = -1;
			$rtn[0]["popis_short"] = -1;
			$rtn[0]["novinka"] = -1;
			$rtn[0]["vyprodej"] = -1;
			$rtn[0]["doporucujeme"] = -1;
			$rtn[0]["cena_mo"] = -1;
			$rtn[0]["cena_vo"] = -1;
			$rtn[0]["cena_dop"] = -1;
			$rtn[0]["cena_mo_s_dph"] = -1;
			$rtn[0]["cena_vo_s_dph"] = -1;
			$rtn[0]["cena_dop_s_dph"] = -1;
			$rtn[0]["id_sazba_dph"] = -1;
			$rtn[0]["sazba"] = -1;
			$rtn[0]["vyrobce"] = -1;
			$rtn[0]["zaruka"] = -1;
			$rtn[0]["total"]=$tmpTotal;
			$rtn[0]["autorska_odmena"] = -1;
			$rtn[0]["elektroodpad"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["total"]=$tmpTotal;
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["novinka"] = $this->myResult[$i]["novinka"];
				$rtn[$i]["vyprodej"] = $this->myResult[$i]["vyprodej"];
				$rtn[$i]["doporucujeme"] = $this->myResult[$i]["doporucujeme"];
				$rtn[$i]["evidencni_cislo"] = $this->myResult[$i]["evidencni_cislo"];
				$rtn[$i]["zaruka"] = $this->myResult[$i]["zaruka"];
				$rtn[$i]["id_kategorie"] = $this->myResult[$i]["id_kategorie"];

                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                    $rtn[$i]["popis"] = $this->myResult[$i]["popis"];
                    $rtn[$i]["popis_short"] = $this->myResult[$i]["zkracene"];
                else:
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'katalog','nazev');
                    $rtn[$i]["popis_short"] = $this->getLang($varLang,$this->myResult[$i]["id"],'katalog','zkracene');
                    $rtn[$i]["popis"] = $this->getLang($varLang,$this->myResult[$i]["id"],'katalog','popis');
                endif;
                
                $rtn[$i]["mena"] = $mena;
                $rtn[$i]["id_mena"] = $id_mena;


// Rabat 
                $statement = 'select rabat from kategorie where id = "'.$rtn[$i]["id_kategorie"].'"';
                $tmp = $this->mySQL->select($statement,$reqCpNames);
                if ($this->mySQL->getRows()==0):
                    $rabat = 0;
                else:
                    $rabat = $tmp[0]["rabat"];
                endif;


// naplni standardni koncovou cenu bez dph                
                $tmpCenaKon = $this->myResult[$i]["cena_mo"];

                $mySleva="";
/*
                if ($this->mySetup["dealerska_sleva_katalog"]=="N"):
// Dealerske slevy na kategorii 
    
                    if ($reqUser!=""):
                        $statement = 'select slv.sleva from users usr left join sleva slv on slv.id_kategorie = "'.$this->myResult[$i]["id_kategorie"].'" and slv.id_dealerska_kategorie = usr.id_dealerska_kategorie where usr.id = "'.$reqUser.'"';
                        $tmpDS = $this->mySQL->select($statement);
                        if ($this->mySQL->getRows()==0):
                            $mySleva = "";
                        else:
                            $mySleva = $tmpDS[0]["sleva"];
                        endif;
                    else:
    // pouze pro Champion default se nastavuje i pro neprihlasenehe uzivatele implicitni dealerska kat
    
                        if ($this->mySetup["ceny_dle_dkat"]=="A"):
                            $statement = 'select slv.sleva from dealerska_kategorie usr left join sleva slv on slv.id_kategorie = "'.$this->myResult[$i]["id_kategorie"].'" and slv.id_dealerska_kategorie = usr.id where usr.implicitni = "A"';
                            $tmpDS = $this->mySQL->select($statement);
                            if ($this->mySQL->getRows()==0):
                                $mySleva = "";
                            else:
                                $mySleva = $tmpDS[0]["sleva"];
                            endif;
                        else:
                            $mySleva = "";
                        endif;                
                    endif;
                    
// Odecte procento dealerske slevy ktera je nastavena na kategorii
                    if ($mySleva != "" and $this->myResult[$i]["pevna_koncova_cena"]=="N"):
                        $tmpCena = $this->myResult[$i]["cena_mo"] / 100;
                        $tmpSleva = $tmpCena * $mySleva;
                        $tmpCenaKon = $this->myResult[$i]["cena_mo"] - $tmpSleva;
                    endif;
                    
                    
                else:
                    if ($reqUser!=""):

                        $statement = 'select cen.cena,cen.cena_s_dph from users usr join cenik cen on cen.id_dealerska_kategorie = usr.id_dealerska_kategorie where usr.id = "'.$reqUser.'" and cen.id_katalog = "'.$rtn[$i]["id"].'"';

//echo $statement;

                        $tmpCenik = $this->mySQL->select($statement);
                        if ($this->mySQL->getRows()==0):
                        else:
                            $tmpCenaKon = $tmpCenik[0]["cena"];
                        endif;

                    endif;                    
                endif;
 */

                // Pricteni rabatu
                $tmpRabatCastka = $tmpCenaKon / 100;
                $tmpRabatCastka = $tmpRabatCastka * $rabat;

// V pripade ze se nejedna o pevnou koncovou cenu pak pricte rabat
//                
                if ($rabat > 0 and $this->myResult[$i]["pevna_koncova_cena"]=="N"):    
                    $tmpCenaKon = $tmpCenaKon + $tmpRabatCastka;
                endif;    

// dopocita DPH a pricte dalsi poplatky

                if ($this->myResult[$i]["cena_mo"]==0):
                    $rtn[$i]["cena_mo"] = $tmpCenaKon;
                else:
                    $rtn[$i]["cena_mo"] = $tmpCenaKon + $this->myResult[$i]["autorska_odmena"] + $this->myResult[$i]["elektroodpad"];
                endif;    
                
                if ($this->myResult[$i]["cena_dop"]==0):
                    $rtn[$i]["cena_dop"] = $this->myResult[$i]["cena_dop"];
                else:
                    $rtn[$i]["cena_dop"] = $this->myResult[$i]["cena_dop"] + $this->myResult[$i]["autorska_odmena"] + $this->myResult[$i]["elektroodpad"];
                endif;    


                if ($this->myResult[$i]["cena_mo"]==0):
                    $rtn[$i]["cena_mo_s_dph"] = $tmpCenaKon;
                else:
                    $tmpCena = (($this->myResult[$i]["autorska_odmena"] + $this->myResult[$i]["elektroodpad"] + $tmpCenaKon)* $this->myResult[$i]["sazba"]);
                    $rtn[$i]["cena_mo_s_dph"] = $tmpCena;
                endif;

                $rtn[$i]["cena_dop_s_dph"] = $this->myResult[$i]["cena_dop"];
                
                $rtn[$i]["cena_mo"]=$rtn[$i]["cena_mo"]*$kurz;

                $rtn[$i]["cena_mo_s_dph"]=round($rtn[$i]["cena_mo_s_dph"],1);

                $rtn[$i]["cena_mo_s_dph"]=$rtn[$i]["cena_mo_s_dph"]*$kurz;
                $rtn[$i]["cena_dop"]=$rtn[$i]["cena_dop"]*$kurz;
                $rtn[$i]["cena_dop_s_dph"]=$rtn[$i]["cena_dop_s_dph"]*$kurz;
                $rtn[$i]["id_sazba_dph"] = $this->myResult[$i]["id_sazba_dph"];
                $rtn[$i]["sazba"] = $this->myResult[$i]["procento"];
                $rtn[$i]["vyrobce"] = $this->myResult[$i]["vyrobce"];
                $rtn[$i]["url_vyrobce"] = $this->myResult[$i]["url_vyrobce"];
                $rtn[$i]["autorska_odmena"] = $this->myResult[$i]["autorska_odmena"];
                $rtn[$i]["elektroodpad"] = $this->myResult[$i]["elektroodpad"];

            }		
		endif;
		return $rtn;					
	}


        /**
         * 
         * @param string $sendRange skupina
         * @param int $reqId id uzivatele
         * @param string $omezeni CZ/GB atd
         * @param int $id_dealerska_kategorie
         * @param string $obchodni_nabidka Informace o tom ydlai se jedna o obchodni nabidku
         * @return type
         */
	function getUserNL($sendRange="N",$reqId="",$omezeni="",$id_dealerska_kategorie="",$obchodni_nabidka="N"){
		if ($sendRange == "A"):
                    $statement = 'select id,email,language from users where stav="C" '.decode($omezeni=="",'',' and language = "'.$omezeni.'"').decode($id_dealerska_kategorie=="",'',' and id_dealerska_kategorie = "'.$id_dealerska_kategorie.'"').decode($obchodni_nabidka=="A",' and zasilat_nabidky = "A"','');
                    $statement .=  ' union select 0 as id,email,language from externi_adresar where aktivni = "A" ';
                elseif ($sendRange == "S"): // sysadmin pro test
                    $statement = 'select id,email,language from users where stav="C" and typ="A" '.decode($omezeni=="",'',' and language = "'.$omezeni.'"').decode($id_dealerska_kategorie=="",'',' and id_dealerska_kategorie = "'.$id_dealerska_kategorie.'"').decode($obchodni_nabidka=="A",' and zasilat_nabidky = "A"','');
 		else:
                    if ($reqId==""):
                        $statement = 'select id,email,language from users where newsletter="A" '.decode($omezeni=="",'',' and language = "'.$omezeni.'"').decode($id_dealerska_kategorie=="",'',' and id_dealerska_kategorie = "'.$id_dealerska_kategorie.'"').decode($obchodni_nabidka=="A",' and zasilat_nabidky = "A"','');
                        $statement .=  ' union select 0 as id,email,language from externi_adresar where aktivni = "A" ';
                    else:
                        $statement = 'select id,email,language from users where id="'.$reqId.'"';
                    endif;    
		endif;
			
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
                    $rtn[0]["id"] = -1;
                    $rtn[0]["email"] = -1;
                    $rtn[0]["language"] = -1;
		else:
                    for ($i=0;$i<count($this->myResult);$i++){
                        $rtn[$i]["id"] = $this->myResult[$i]["id"];
                        $rtn[$i]["email"] = $this->myResult[$i]["email"];
                        $rtn[$i]["language"] = $this->myResult[$i]["language"];
                    }		
		endif;
		return $rtn;					
	}
    
    function getUsers($varLang,$reqId="",$reqSort=""){
        if ($reqId==""):
            if ($reqSort==""):
                $statement = 'select id,firma,jmeno,prijmeni from users';
            else:
                $statement = 'select id,firma,jmeno,prijmeni from users order by '.$reqSort.'';
            endif;
            
        else:
            $statement = 'select id,firma,jmeno,prijmeni from users where id="'.$reqId.'"';
        endif;


            
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["firma"] = -1;
            $rtn[0]["jmeno"] = -1;
            $rtn[0]["prijmeni"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++){
                $rtn[$i]["id"] = $this->myResult[$i]["id"];
                $rtn[$i]["firma"] = $this->myResult[$i]["firma"];
                $rtn[$i]["jmeno"] = $this->myResult[$i]["jmeno"];
                $rtn[$i]["prijmeni"] = $this->myResult[$i]["prijmeni"];
            }        
        endif;
        return $rtn;                    
    }

	function getKategorie($druh,$reqParent="",$reqId=""){
		if ($reqId == ''):
			if ($reqParent==""):
				$statement = 'select id,nazev,finalni from kategorie where druh="'.$druh.'" and id_parent is null order by mporadi';
			else:
				$statement = 'select id,nazev,finalni from kategorie where druh="'.$druh.'" and id_parent = "'.$reqParent.'" order by mporadi';
			endif;	
		else:
			$statement = 'select id,nazev,finalni from kategorie where id = "'.$reqId.'"';
		endif;      
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["nazev"] = -1;
			$rtn[0]["finalni"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
				$rtn[$i]["finalni"] = $this->myResult[$i]["finalni"];
			}		
		endif;
		return $rtn;					
		
	}
    function getAllKategorie($varLang,$druh){
        $statement = 'select id,nazev,finalni from kategorie where druh ="'.$druh.'" order by mporadi';
        echo $statement;
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn[0]["id"] = -1;
            $rtn[0]["nazev"] = -1;
        else:
            for ($i=0;$i<count($this->myResult);$i++){
                if ($varLang == $this->mySetup["lang"]):
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
                else:
                    $rtn[$i]["id"] = $this->myResult[$i]["id"];
                    $rtn[$i]["nazev"] = $this->getLang($varLang,$this->myResult[$i]["id"],'kategorie','nazev');
                endif;        
            }        
        endif;
        return $rtn;                    
        
    }
	
	function getTree($reqKategorie){
		$rtn = array();
		$statement = 'SELECT a.id,a.id_parent,a.nazev,b.nazev as parent FROM kategorie a left join kategorie b on b.id = a.id_parent where a.id = \''.$reqKategorie.'\'';
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["nazev"] = -1;
			$rtn[0]["id_parent"] = -1;
			$rtn[0]["parent"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
				$rtn[$i]["id_parent"] = decode($this->myResult[$i]["id_parent"]=="","",$this->myResult[$i]["id_parent"]);
				$rtn[$i]["parent"] = decode($this->myResult[$i]["parent"]=="","",$this->myResult[$i]["parent"]);
//				$rtn[$i]["id_parent"] = "";
//				$rtn[$i]["parent"] = "Prodej";

			}		
		endif;
		return $rtn;					
	}
		
    function getParentKat(&$id_parent)
    {
        $rtn = array();
        $statement = 'SELECT a.id,a.id_parent,a.nazev FROM kategorie a where a.id = \''.$id_parent.'\'';
        $this->myResult = $this->mySQL->select($statement);

        if ($this->mySQL->getRows() == 0):
            $rtn["id"] = -1;
            $rtn["nazev"] = -1;
            $id_parent = null;
        else:
            for ($i=0;$i<count($this->myResult);$i++){
                $rtn["id"] = $this->myResult[$i]["id"];
                $rtn["nazev"] = $this->myResult[$i]["nazev"];
                $id_parent = $this->myResult[$i]["id_parent"];
            }        
        endif;
        return $rtn;                    
    }		

	function getUserStatus($reqID){
		$rtn = array();
		$statement = 'select online from users where id = "'.$reqID.'"';
		
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn = "N";
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn = $this->myResult[$i]["online"];
				break;
			}		
		endif;
		return $rtn;					
	}	

	function setUserStatus($reqID,$status){
		$rtn = array();
		$statement = 'update users set online = "'.$status.'" where id = "'.$reqID.'"';
//		echo $statement;
		
		$this->myResult = $this->mySQL->update($statement);

		return $rtn;					
	}	
			
	function getVlastnik($reqID=""){
		$rtn = array();
		if ($reqID == ''):	
			$statement = 'select v.id,v.id_stat,v.nazev,v.nazev1,v.adresa,v.psc,v.mesto,v.ico,v.dic,v.ucet,v.banka,v.tel,v.fax,v.email,s.doprava_zdarma,v.url,v.konstantni_symbol,v.email_dodavatele from vlastnik v left join cc_stat s on s.id = v.id_stat';
		else:
			$statement = 'select v.id,v.id_stat,v.nazev,v.nazev1,v.adresa,v.psc,v.mesto,v.ico,v.dic,v.ucet,v.banka,v.tel,v.fax,v.email,s.doprava_zdarma,v.url,v.konstantni_symbol,v.email_dodavatele from vlastnik v left join cc_stat s on s.id = v.id_stat where v.id = "'.$reqID.'"';
		endif;	
		$this->myResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn[0]["id"] = -1;
			$rtn[0]["nazev"] = -1;
			$rtn[0]["nazev1"] = -1;
			$rtn[0]["adresa"] = -1;
			$rtn[0]["psc"] = -1;
			$rtn[0]["mesto"] = -1;
			$rtn[0]["ico"] = -1;
			$rtn[0]["dic"] = -1;
			$rtn[0]["ucet"] = -1;
			$rtn[0]["banka"] = -1;
			$rtn[0]["tel"] = -1;
			$rtn[0]["fax"] = -1;
			$rtn[0]["email"] = -1;
			$rtn[0]["doprava_zdarma"] = -1;
			$rtn[0]["konstantni_symbol"] = -1;
			$rtn[0]["url"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
				$rtn[$i]["nazev1"] = $this->myResult[$i]["nazev1"];
				$rtn[$i]["adresa"] = $this->myResult[$i]["adresa"];
				$rtn[$i]["psc"] = $this->myResult[$i]["psc"];
				$rtn[$i]["mesto"] = $this->myResult[$i]["mesto"];
				$rtn[$i]["ico"] = $this->myResult[$i]["ico"];
				$rtn[$i]["dic"] = $this->myResult[$i]["dic"];
				$rtn[$i]["ucet"] = $this->myResult[$i]["ucet"];
				$rtn[$i]["banka"] = $this->myResult[$i]["banka"];
				$rtn[$i]["tel"] = $this->myResult[$i]["tel"];
				$rtn[$i]["fax"] = $this->myResult[$i]["fax"];
				$rtn[$i]["email"] = $this->myResult[$i]["email"];
				$rtn[$i]["doprava_zdarma"] = $this->myResult[$i]["doprava_zdarma"];
				$rtn[$i]["url"] = $this->myResult[$i]["url"];
				$rtn[$i]["konstantni_symbol"] = $this->myResult[$i]["konstantni_symbol"];
                $rtn[$i]["id_stat"] = $this->myResult[$i]["id_stat"];
                $rtn[$i]["email_dodavatele"] = $this->myResult[$i]["email_dodavatele"];
			}		
		endif;
        
//        print_r($rtn);
		return $rtn;					
	}	
	
	function getPrilohy($reqOblast,$reqID,$reqVelikost="N",$reqPath="PICTURE_PATH"){
		$statement = 'select id,soubornew,sirka,vyska,typ,soubor,sektor,popis from prilohy where '.$reqOblast.' = "'.$reqID.'" order by id asc';
//echo $statement;
		$this->myResult = $this->mySQL->select($statement);
		
//		print_r($this->mySQL->getRows());
		if ($this->mySQL->getRows() == 0):
				$rtn[0]["id"] = -1;
				$rtn[0]["cesta"] = -1;
				$rtn[0]["vyska"] = -1;
				$rtn[0]["sirka"] = -1;
				$rtn[0]["typ"] = -1;
				$rtn[0]["soubor"] = -1;
				$rtn[0]["sektor"] = -1;
				$rtn[0]["popis"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				if ($reqPath=="PICTURE_PATH"):
					if ($reqVelikost=='N'):
						$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/small/".$this->myResult[$i]["soubornew"];
					elseif ($reqVelikost=='M'):
						$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/middle/".$this->myResult[$i]["soubornew"];
					else:
						$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/large/".$this->myResult[$i]["soubornew"];
					endif;				
				else:
					$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/".$this->myResult[$i]["soubornew"];
				endif;
				$rtn[$i]["id"] = $this->myResult[$i]["id"];
				$rtn[$i]["vyska"] = $this->myResult[$i]["vyska"];
				$rtn[$i]["sirka"] = $this->myResult[$i]["sirka"];
				$rtn[$i]["typ"] = $this->myResult[$i]["typ"];
				$rtn[$i]["soubor"] = $this->myResult[$i]["soubor"];
				$rtn[$i]["soubornew"] = $this->myResult[$i]["soubornew"];
				$rtn[$i]["sektor"] = $this->myResult[$i]["sektor"];
				$rtn[$i]["popis"] = $this->myResult[$i]["popis"];
		  }
		endif;
	  return $rtn;
	}
	function getFoto($reqID,$reqVelikost="N",$reqPath="PICTURE_PATH"){
		$statement = 'select soubornew,sirka,vyska,typ,soubor from prilohy where id = "'.$reqID.'"';
		$this->myResult = $this->mySQL->select($statement);
		if ($this->mySQL->getRows() == 0):
				$rtn[0]["cesta"] = -1;
				$rtn[0]["vyska"] = -1;
				$rtn[0]["sirka"] = -1;
				$rtn[0]["typ"] = -1;
				$rtn[0]["soubor"] = -1;
		else:
			for ($i=0;$i<count($this->myResult);$i++){
				if ($reqPath=="PICTURE_PATH"):
					if ($reqVelikost=='N'):
						$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/small/".$this->myResult[$i]["soubornew"];
					elseif ($reqVelikost=='M'):
						$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/middle/".$this->myResult[$i]["soubornew"];
					else:
						$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/large/".$this->myResult[$i]["soubornew"];
					endif;				
				else:
					$rtn[$i]["cesta"] = $this->myInit->f_getVal($reqPath)."/".$this->myResult[$i]["soubornew"];
				endif;
				
				$rtn[$i]["vyska"] = $this->myResult[$i]["vyska"];
				$rtn[$i]["sirka"] = $this->myResult[$i]["sirka"];
				$rtn[$i]["typ"] = $this->myResult[$i]["typ"];
				$rtn[$i]["soubor"] = $this->myResult[$i]["soubor"];
		  }
		endif;
	  return $rtn;
		
	}
        
        

}

class Menu
        {
        /**
         *
         * @var sql
         */
	var $mySQL;
        /**
         *
         * @var init
         */
	var $myInit;
        /**
         *
         * @var array 
         */
	var $menuTop;
        /**
         *
         * @var array
         */
	var $menuNext;
        
	var $myUsr;
        public $varLang;
        /**
         *
         * @var string 
         */
        public $defLang;

	function __construct($reqUsr,$varLang='CZ'){
                $this->varLang = $varLang;
                
                $this->myInit = new init();
		$this->mySQL = new sql($this->myInit);
		$this->myUsr = $reqUsr;

                $statement = 'select mjazyk from setup';
                $tmpArr = $this->mySQL->select($statement);
                $this->defLang = $tmpArr[0]["mjazyk"];
                
                
                $statement = 'select m.* from menu m, permission p where m.nadr_id is null and m.id = p.modul and p.uzivatel = "'.$reqUsr.'" order by m.mporadi asc';

		$this->menuTop = $this->mySQL->select($statement);
                
                for ($i=0;$i<count($this->menuTop);$i++)
                {
                    if ($this->varLang != $this->defLang):
                        $this->menuTop[$i]["text"]=$this->getLang($this->varLang,$this->menuTop[$i]["id"],'menu','text');
                    endif;
                }                
	}

	function getTop(){
		return $this->menuTop;
	}	
	function getNext($reqParent){
            
		$statement = 'select m.* from menu m, permission p where m.nadr_id = "'.$reqParent.'" and m.id = p.modul and p.uzivatel = "'.$this->myUsr.'" order by m.mporadi asc';
		//echo $statement;
                $tmpPodr = $this->mySQL->select($statement);
		
		if ($this->mySQL->getRows() == 0):
			$this->menuNext[0]["id"] = -1;
		else:
                        for ($i=0;$i<count($tmpPodr);$i++)
                        {
                            if ($this->varLang != $this->defLang):
                                //echo 'MENIM MUTACI';
                                $tmpPodr[$i]["text"]=$this->getLang($this->varLang,$tmpPodr[$i]["id"],'menu','text');
                            endif;
                        }                
			$this->menuNext = $tmpPodr;
                
		endif;
		
		return $this->menuNext;
	}	
        function getLang($varLang,$reqId,$reqTab,$reqCol){
            $statement = 'select id,typ from mutace where tabulka = "'.$reqTab.'" and sloupec = "'.$reqCol.'"';
            //echo $statement;
        
            $tmpDefinice = $this->mySQL->select($statement);

            for ($i=0;$i<count($tmpDefinice);$i++){
                $statement = 'select hodnota_'.$tmpDefinice[$i]["typ"].' from mutace_data where id_mutace = "'.$tmpDefinice[$i]["id"].'" and id_zdroj = "'.$reqId.'" and jazyk = "'.$varLang.'"';

        //echo $statement;

                $tmpTrans = $this->mySQL->select($statement);
                if ($this->mySQL->getRows()==0):
                    return -2;
                else:
                    return $tmpTrans[0]["hodnota_".$tmpDefinice[$i]["typ"]];
                endif;    
            }

        }        
}


class Maska{
	var $mySQL;
	var $myResult;
	var $myInit;
	var $prefix;
	var $sufix;
	var $typ_rok;
	var $cislic;
	var $column;
	
	function __construct($reqTabulka,$reqColumn){
		$this->myInit = new init();
		$this->mySQL = new sql($this->myInit);
		$statement = 'select prefix,sufix,typ_rok,cislic from cc_ciselna_rada where tabulka = "'.$reqTabulka.'" and "'.date('Y-m-d').'" between plati_od and plati_do';
		$this->column = $reqColumn;
		
		$this->myResult = $this->mySQL->select($statement);
		if ($this->mySQL->getRows()==0):
			$this->prefix = "";
			$this->typ_rok = "Y";
			$this->cislic = "6";
			$this->sufix = "";
		else:
			$this->prefix = $this->myResult[0]["prefix"];
			$this->typ_rok = $this->myResult[0]["typ_rok"];
			$this->cislic = $this->myResult[0]["cislic"];
			$this->sufix = $this->myResult[0]["sufix"];
		endif;	
	}
	function getColumn(){
		$startPoz = strlen($this->prefix);
		if ($this->typ_rok=="Y"):
			$startPoz += 4;
		elseif ($this->typ_rok=="y"):
			$startPoz += 2;
		endif;
		
		$startPoz++;
		
		$znaku = $startPoz + $this->cislic;
	
		$rtn = 'ifnull(MAX(SUBSTRING('.$this->column.','.$startPoz.decode($znaku==0,'',','.$znaku).')),0)';
		return $rtn;
	}
	function getWhere(){
		$startPoz = strlen($this->prefix);
		$znaku = 0;
		if ($this->typ_rok=="Y"):
			$znaku = 4;
		elseif ($this->typ_rok=="y"):
			$znaku = 2;
		endif;
		$startPoz++;

		if ($this->typ_rok!=""):
			$rtn = 'SUBSTRING('.$this->column.','.$startPoz.decode($znaku==0,'',','.$znaku).') = "'.date($this->typ_rok).'"';
		else:
			$rtn = 'SUBSTRING('.$this->column.',1'.','.($startPoz-1).') = "'.$this->prefix.'"';
		endif;	

		return $rtn;
	}
	function getCislic(){
		return $this->cislic;
	}

	function getPrefix(){
		return $this->prefix;
	}
	function getRok(){
		return date($this->typ_rok);
	}
	function getSufix(){
		return $this->sufix;
	}
	

}
class Objednavka{
	var $mySQL;
	var $myResult;
	var $myInit;
	var $myHlavicka;
	var $myPolozky;
	var $myOrderNumber;
	var $myObjId;

	function __construct(){
		$this->myInit = new init();
		$this->mySQL = new sql($this->myInit);
	}
	function setHlavicka(	$reqJmeno,
				$reqPrijmeni,
				$reqFirma,
				$reqIco,
				$reqDic,
				$reqAdresa,
				$reqPsc,
				$reqMesto,
				$reqStat,
				$reqJmeno_dod,
				$reqPrijmeni_dod,
				$reqFirma_dod,
				$reqAdresa_dod,
				$reqPsc_dod,
				$reqMesto_dod,
				$reqStat_dod,
				$reqTelefon,
				$reqFax,
				$reqEmail,
				$reqPoznamka,
				$reqDodavka,
				$reqID="",
				$reqCislo=""){
		$this->myHlavicka = new mPar();
		$this->myHlavicka->f_setVal("jmeno",$reqJmeno);
		$this->myHlavicka->f_setVal("prijmeni",$reqPrijmeni);
		$this->myHlavicka->f_setVal("firma",$reqFirma);
		$this->myHlavicka->f_setVal("ico",$reqIco);
		$this->myHlavicka->f_setVal("dic",$reqDic);
		$this->myHlavicka->f_setVal("adresa",$reqAdresa);
		$this->myHlavicka->f_setVal("psc",$reqPsc);
		$this->myHlavicka->f_setVal("mesto",$reqMesto);
		$this->myHlavicka->f_setVal("stat",$reqStat);
		$this->myHlavicka->f_setVal("jmeno_dod",$reqJmeno_dod);
		$this->myHlavicka->f_setVal("prijmeni_dod",$reqPrijmeni_dod);
		$this->myHlavicka->f_setVal("firma_dod",$reqFirma_dod);
		$this->myHlavicka->f_setVal("adresa_dod",$reqAdresa_dod);
		$this->myHlavicka->f_setVal("psc_dod",$reqPsc_dod);
		$this->myHlavicka->f_setVal("mesto_dod",$reqMesto_dod);
		$this->myHlavicka->f_setVal("stat_dod",$reqStat_dod);
		$this->myHlavicka->f_setVal("telefon",$reqTelefon);
		$this->myHlavicka->f_setVal("fax",$reqFax);
		$this->myHlavicka->f_setVal("email",$reqEmail);
		$this->myHlavicka->f_setVal("poznamka",$reqPoznamka);
		$this->myHlavicka->f_setVal("id_dodavka",$reqDodavka);
		$this->myHlavicka->f_setVal("id",$reqID);
		$this->myHlavicka->f_setVal("cislo",$reqCislo);
	}
	function setPolozky(	$reqMnozstvi,
				$reqIdKatalog,
				$reqKatalog,
				$reqevidencni_cislo,
				$reqCena,
				$reqIdSazbaDph,
				$reqCelkem,
				$reqDPH,
				$reqCenasDPH,
				$reqIdDodavka=""){
		if (!is_array($this->myPolozky)):
			$i=0;
		else:
			$i=count($this->myPolozky);
		endif;
			
		$this->myPolozky[$i] = new mPar();
		$this->myPolozky[$i]->f_setVal("mnozstvi",$reqMnozstvi);			
		$this->myPolozky[$i]->f_setVal("id_katalog",$reqIdKatalog);			
		$this->myPolozky[$i]->f_setVal("katalog",$reqKatalog);			
		$this->myPolozky[$i]->f_setVal("evidencni_cislo",$reqevidencni_cislo);			

		$this->myPolozky[$i]->f_setVal("cena",$reqCena);			
		$this->myPolozky[$i]->f_setVal("id_sazba_dph",$reqIdSazbaDph);			
		$this->myPolozky[$i]->f_setVal("celkem",$reqCelkem);			
		$this->myPolozky[$i]->f_setVal("dph",$reqDPH);			
		$this->myPolozky[$i]->f_setVal("cena_s_dph",$reqCenasDPH);			
		$this->myPolozky[$i]->f_setVal("id_dodavka",$reqIdDodavka);			
	}
	function save($reqID=""){
		$this->myOrderNumber = $this->getNr("N");

		$statement = 'insert into objednavka(cislo,jmeno_zak,prijmeni_zak,firma_zak,ico,dic,adresa_zak,psc_zak,mesto_zak,stat_zak,jmeno_dod,prijmeni_dod,firma_dod,adresa_dod,psc_dod,mesto_dod,stat_dod,tel,fax,email,id_user, id_dodavka ,poznamka) values(';
		$statement.= '"'.$this->myOrderNumber.'",';
		$statement.= decode($this->myHlavicka->f_getVal("jmeno")=="",'NULL','"'.$this->myHlavicka->f_getVal("jmeno").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("prijmeni")=="",'NULL','"'.$this->myHlavicka->f_getVal("prijmeni").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("firma")=="",'NULL','"'.$this->myHlavicka->f_getVal("firma").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("ico")=="",'NULL','"'.$this->myHlavicka->f_getVal("ico").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("dic")=="",'NULL','"'.$this->myHlavicka->f_getVal("dic").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("adresa")=="",'NULL','"'.$this->myHlavicka->f_getVal("adresa").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("psc")=="",'NULL','"'.$this->myHlavicka->f_getVal("psc").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("mesto")=="",'NULL','"'.$this->myHlavicka->f_getVal("mesto").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("stat")=="",'NULL','"'.$this->myHlavicka->f_getVal("stat").'"').',';

		$statement.= decode($this->myHlavicka->f_getVal("jmeno_dod")=="",'NULL','"'.$this->myHlavicka->f_getVal("jmeno_dod").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("prijmeni_dod")=="",'NULL','"'.$this->myHlavicka->f_getVal("prijmeni_dod").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("firma_dod")=="",'NULL','"'.$this->myHlavicka->f_getVal("firma_dod").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("adresa_dod")=="",'NULL','"'.$this->myHlavicka->f_getVal("adresa_dod").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("psc_dod")=="",'NULL','"'.$this->myHlavicka->f_getVal("psc_dod").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("mesto_dod")=="",'NULL','"'.$this->myHlavicka->f_getVal("mesto_dod").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("stat_dod")=="",'NULL','"'.$this->myHlavicka->f_getVal("stat_dod").'"').',';

		$statement.= decode($this->myHlavicka->f_getVal("telefon")=="",'NULL','"'.$this->myHlavicka->f_getVal("telefon").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("fax")=="",'NULL','"'.$this->myHlavicka->f_getVal("fax").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("email")=="",'NULL','"'.$this->myHlavicka->f_getVal("email").'"').',';

		$statement.= '"'.$_SESSION['uzivatel'].'",';

		$statement.= decode($this->myHlavicka->f_getVal("id_dodavka")=="",'NULL','"'.$this->myHlavicka->f_getVal("id_dodavka").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("poznamka")=="",'NULL','"'.$this->myHlavicka->f_getVal("poznamka").'"').')';

		$this->myResult = $this->mySQL->insert($statement);

		if ($this->mySQL->getRows() > 0):
			$rtn["error_code"] = '0';
			$rtn["error_txt"] = '';
			$rtn["id"] = $this->mySQL->getID();
			$this->myObjId = $this->mySQL->getID();
		else:
			$rtn["error_code"] = '-1';
			$rtn["error_txt"] = 'Chyba b?hem insertu';
			$rtn["id"] = '-1';
		endif;	

		if ($this->mySQL->getRows() > 0):
			for ($i=0;$i<count($this->myPolozky);$i++){
				$statement = 'insert into objednavka_detail(id_objednavka,id_sazba_dph,id_katalog,zbozi,evidencni_cislo,id_user,id_dodavka,mnozstvi,cena_mj,celkem,dph,celkem_s_dph) values(';
				$statement.= '"'.$this->myObjId.'",';
				$statement.= decode($this->myPolozky[$i]->f_getVal("id_sazba_dph")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("id_sazba_dph").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("id_katalog")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("id_katalog").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("katalog")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("katalog").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("evidencni_cislo")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("evidencni_cislo").'"').',';
				$statement.= '"'.$_SESSION['uzivatel'].'",';
				$statement.= decode($this->myPolozky[$i]->f_getVal("id_dodavka")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("id_dodavka").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("mnozstvi")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("mnozstvi").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("cena")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("cena").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("celkem")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("celkem").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("dph")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("dph").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("cena_s_dph")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("cena_s_dph").'"').')';
				
				$this->myResult = $this->mySQL->insert($statement);
			}
		endif;
		

		return $rtn;		
		
	}

	function getOrderNumber(){
		return $this->myOrderNumber;
	}

	function getNr($reqAction="C"){
		
		$myMaska = new Maska('objednavka','cislo');
		
		$rtn = "";
		$statement = 'SELECT '.$myMaska->getColumn().' as cislo FROM objednavka where '.$myMaska->getWhere();
//		echo $statement;


		$this->myResult = $this->mySQL->select($statement);

		for ($i=0;$i<count($this->myResult);$i++){
			if ($this->mySQL->getRows() == 0):
				$rtn = str_pad('1', 5, "0", STR_PAD_LEFT); 
			else:
				if ($reqAction == 'C'):
					$rtn = str_pad($this->myResult[$i]["cislo"], $myMaska->getCislic(), "0", STR_PAD_LEFT); 
				elseif($reqAction == 'N'):
					$rtn = str_pad($this->myResult[$i]["cislo"]+1, $myMaska->getCislic(), "0", STR_PAD_LEFT); 
				endif;				
			endif;				
		}		
		$rtn = $myMaska->getPrefix().$myMaska->getRok().$rtn.$myMaska->getSufix();
		return $rtn;
	}
	
	function listObjednavky($reqUser){
		$statement = 'SELECT a.id,a.cislo,a.jmeno_zak,a.prijmeni_zak,a.firma_zak,a.ico,a.dic,a.adresa_zak,a.psc_zak,a.mesto_zak,a.stat_zak,a.tel,a.fax,a.email,a.jmeno_dod,a.prijmeni_dod,a.firma_dod,a.adresa_dod,a.psc_dod,a.mesto_dod,a.stat_dod,a.poznamka,a.id_dodavka,a.zadano,b.nazev as dodavka FROM objednavka a left join cc_dodavka b on b.id = a.id_dodavka where a.id_user = \''.$reqUser.'\'';
		$this->myResult = $this->mySQL->select($statement);

		for ($i=0;$i<count($this->myResult);$i++){

			$rtn[$i]["jmeno_zak"]=$this->myResult[$i]["jmeno_zak"];
			$rtn[$i]["prijmeni_zak"]=$this->myResult[$i]["prijmeni_zak"];
			$rtn[$i]["firma_zak"]=$this->myResult[$i]["firma_zak"];
			$rtn[$i]["ico"]=$this->myResult[$i]["ico"];
			$rtn[$i]["dic"]=$this->myResult[$i]["dic"];
			$rtn[$i]["adresa_zak"]=$this->myResult[$i]["adresa_zak"];
			$rtn[$i]["psc_zak"]=$this->myResult[$i]["psc_zak"];
			$rtn[$i]["mesto_zak"]=$this->myResult[$i]["mesto_zak"];
			$rtn[$i]["stat_zak"]=$this->myResult[$i]["stat_zak"];
			$rtn[$i]["jmeno_dod"]=$this->myResult[$i]["jmeno_dod"];
			$rtn[$i]["prijmeni_dod"]=$this->myResult[$i]["prijmeni_dod"];
			$rtn[$i]["firma_dod"]=$this->myResult[$i]["firma_dod"];
			$rtn[$i]["adresa_dod"]=$this->myResult[$i]["adresa_dod"];
			$rtn[$i]["psc_dod"]=$this->myResult[$i]["psc_dod"];
			$rtn[$i]["mesto_dod"]=$this->myResult[$i]["mesto_dod"];
			$rtn[$i]["stat_dod"]=$this->myResult[$i]["stat_dod"];
			$rtn[$i]["tel"]=$this->myResult[$i]["tel"];
			$rtn[$i]["fax"]=$this->myResult[$i]["fax"];
			$rtn[$i]["email"]=$this->myResult[$i]["email"];
			$rtn[$i]["poznamka"]=$this->myResult[$i]["poznamka"];
			$rtn[$i]["id_dodavka"]=$this->myResult[$i]["id_dodavka"];
			$rtn[$i]["dodavka"]=$this->myResult[$i]["dodavka"];
			$rtn[$i]["id"]=$this->myResult[$i]["id"];
			$rtn[$i]["cislo"]=$this->myResult[$i]["cislo"];
			$rtn[$i]["zadano"]=substr($this->myResult[$i]["zadano"],6,2).'.'.substr($this->myResult[$i]["zadano"],4,2).'.'.substr($this->myResult[$i]["zadano"],0,4);

			$statement = 'select sum(celkem) as celkem,sum(celkem_s_dph) as celkem_s_dph from objednavka_detail where id_objednavka = "'.$rtn[$i]["id"].'"';
			$tmpSt = $this->mySQL->select($statement);
			
			$rtn[$i]["cena"]=$tmpSt[0]["celkem"];
			$rtn[$i]["cena_s_dph"]=$tmpSt[0]["celkem_s_dph"];

		}		

		return $rtn;		
	}

	function setObjednavka($reqID){
		$statement = 'SELECT a.id,a.cislo,a.jmeno_zak,a.prijmeni_zak,a.firma_zak,a.ico,a.dic,a.adresa_zak,a.psc_zak,a.mesto_zak,a.stat_zak,a.tel,a.fax,a.email,a.jmeno_dod,a.prijmeni_dod,a.firma_dod,a.adresa_dod,a.psc_dod,a.mesto_dod,a.stat_dod,a.poznamka,a.id_dodavka,a.zadano,b.nazev as dodavka FROM objednavka a left join cc_dodavka b on b.id = a.id_dodavka where a.id = \''.$reqID.'\'';
//echo $statement;
		$this->myResult = $this->mySQL->select($statement);
		for ($i=0;$i<count($this->myResult);$i++){
			$this->setHlavicka(	
				$this->myResult[$i]["jmeno_zak"],
				$this->myResult[$i]["prijmeni_zak"],
				$this->myResult[$i]["firma_zak"],
				$this->myResult[$i]["ico"],
				$this->myResult[$i]["dic"],
				$this->myResult[$i]["adresa_zak"],
				$this->myResult[$i]["psc_zak"],
				$this->myResult[$i]["mesto_zak"],
				$this->myResult[$i]["stat_zak"],
				$this->myResult[$i]["jmeno_dod"],
				$this->myResult[$i]["prijmeni_dod"],
				$this->myResult[$i]["firma_dod"],
				$this->myResult[$i]["adresa_dod"],
				$this->myResult[$i]["psc_dod"],
				$this->myResult[$i]["mesto_dod"],
				$this->myResult[$i]["stat_dod"],
				$this->myResult[$i]["tel"],
				$this->myResult[$i]["fax"],
				$this->myResult[$i]["email"],
				$this->myResult[$i]["poznamka"],
				$this->myResult[$i]["id_dodavka"],
				$this->myResult[$i]["id"],
				$this->myResult[$i]["cislo"]);
		}		


		$statement = 'SELECT a.id,a.mnozstvi,a.cena_mj,a.celkem,a.celkem_s_dph,a.dph,a.id_katalog,ifnull(b.nazev,c.nazev) as katalog,b.evidencni_cislo,a.id_sazba_dph,a.id_dodavka FROM objednavka_detail a left join katalog b on a.id_katalog = b.id left join cc_dodavka c on a.id_dodavka = c.id where a.id_objednavka = \''.$reqID.'\'';

		$this->myResult = $this->mySQL->select($statement);
		for ($i=0;$i<count($this->myResult);$i++){
			$this->setPolozky(	$this->myResult[$i]["mnozstvi"],
						$this->myResult[$i]["id_katalog"],
						$this->myResult[$i]["katalog"],
						$this->myResult[$i]["evidencni_cislo"],
						$this->myResult[$i]["cena_mj"],
						$this->myResult[$i]["id_sazba_dph"],
						$this->myResult[$i]["celkem"],
						$this->myResult[$i]["dph"],
						$this->myResult[$i]["celkem_s_dph"],
						$this->myResult[$i]["id_dodavka"]);
		}	
	}
	function getHlavicka(){
		return $this->myHlavicka;
	}
	function getPolozky(){
		return $this->myPolozky;
	}
	function getZboziName($reqId){
		$statement = 'select nazev from katalog where id = "'.$reqId.'"';

		$this->myResult = $this->mySQL->select($statement);

		return $this->myResult[0]["nazev"];
	}
	function getDodavkaName($reqId){
		$statement = 'select nazev from cc_dodavka where id = "'.$reqId.'"';

		$this->myResult = $this->mySQL->select($statement);

		return $this->myResult[0]["nazev"];
	}
	function getEvCis($reqId){
		$statement = 'select evidencni_cislo from katalog where id = "'.$reqId.'"';

		$this->myResult = $this->mySQL->select($statement);

		return $this->myResult[0]["evidencni_cislo"];
	}
	function getSazba($reqId){
		$statement = 'select nazev from cc_sazba_dph where id = "'.$reqId.'"';

		$this->myResult = $this->mySQL->select($statement);

		return $this->myResult[0]["nazev"];

	}
}
class PlanAkce
{
    var $mySQL;
    var $myResult;
    var $myInit;
    var $myHlavicka;
    var $myId;

    function __construct(){
        $this->myInit = new init();
        $this->mySQL = new sql($this->myInit);
    }

    function setHlavicka($reqKatalog,$reqOd,$reqDo,$reqKategorie,$reqCena=0)
    {                        
        $this->myHlavicka = new mPar();
        $this->myHlavicka->f_setVal("id_katalog",$reqKatalog);
        $this->myHlavicka->f_setVal("datum_od",$reqOd);
        $this->myHlavicka->f_setVal("datum_do",$reqDo);
        $this->myHlavicka->f_setVal("id_kategorie",$reqKategorie);
        $this->myHlavicka->f_setVal("cena_mo",$reqCena);
    }    
    function save($reqID=""){

        $statement = 'insert into planovac_akce(id_katalog,datum_od,datum_do,id_kategorie,cena_mo) values(';
        $statement.= decode($this->myHlavicka->f_getVal("id_katalog")=="",'NULL','"'.$this->myHlavicka->f_getVal("id_katalog").'"').',';
        $statement.= decode($this->myHlavicka->f_getVal("datum_od")=="",'NULL','"'.$this->myHlavicka->f_getVal("datum_od").'"').',';
        $statement.= decode($this->myHlavicka->f_getVal("datum_do")=="",'NULL','"'.$this->myHlavicka->f_getVal("datum_do").'"').',';
        $statement.= decode($this->myHlavicka->f_getVal("id_kategorie")=="",'NULL','"'.$this->myHlavicka->f_getVal("id_kategorie").'"').',';
        $statement.= decode($this->myHlavicka->f_getVal("cena_mo")=="",'NULL','"'.$this->myHlavicka->f_getVal("cena_mo").'"').')';

        $this->myResult = $this->mySQL->insert($statement);

        if ($this->mySQL->getRows() > 0):
            $rtn["error_code"] = '0';
            $rtn["error_txt"] = '';
            $rtn["id"] = $this->mySQL->getID();
            $this->myId = $this->mySQL->getID();
        else:
            $rtn["error_code"] = '-1';
            $rtn["error_txt"] = 'Chyba během insertu';
            $rtn["id"] = '-1';
        endif;
        return $rtn;
    }
}


class Faktura{
	var $mySQL;
	var $myResult;
	var $myInit;
	var $myHlavicka;
	var $myPolozky;
	var $myOrderNumber;
	var $myObjId;
    var $koef;

	function __construct(){
		$this->myInit = new init();
		$this->mySQL = new sql($this->myInit);
	}
	function setHlavicka(	$reqJmeno,
				$reqPrijmeni,
				$reqFirma,
				$reqIco,
				$reqDic,
				$reqAdresa,
				$reqPsc,
				$reqMesto,
				$reqStat, 
                $reqIdStat,
				$reqTelefon,
				$reqFax,
				$reqEmail,
				$reqID_vla,
				$reqFirma_vla,
				$reqNazev1_vla,
				$reqIco_vla,
				$reqDic_vla,
				$reqAdresa_vla,
				$reqPsc_vla,
				$reqMesto_vla,
				$reqStat_vla,
				$reqTelefon_vla,
				$reqFax_vla,
				$reqEmail_vla,
				$reqPoznamka,
				$reqDatVys,
				$reqDatPln,
				$reqDatSpl,
                $reqObj,
				$reqObjId,
				$reqZpPla,				
                $reqUser,
                $reqLang,
				$reqKonS="",
				$reqID="",
				$reqVarS=""){
					
		$this->myHlavicka = new mPar();
		$this->myHlavicka->f_setVal("jmeno",$reqJmeno);
		$this->myHlavicka->f_setVal("prijmeni",$reqPrijmeni);
		$this->myHlavicka->f_setVal("firma",$reqFirma);
		$this->myHlavicka->f_setVal("ico",$reqIco);
		$this->myHlavicka->f_setVal("dic",$reqDic);
		$this->myHlavicka->f_setVal("adresa",$reqAdresa);
		$this->myHlavicka->f_setVal("psc",$reqPsc);
		$this->myHlavicka->f_setVal("mesto",$reqMesto);
		$this->myHlavicka->f_setVal("stat",$reqStat);
        $this->myHlavicka->f_setVal("id_stat",$reqIdStat);
		$this->myHlavicka->f_setVal("telefon",$reqTelefon);
		$this->myHlavicka->f_setVal("fax",$reqFax);
		$this->myHlavicka->f_setVal("email",$reqEmail);

		$this->myHlavicka->f_setVal("id_vla",$reqID_vla);
		$this->myHlavicka->f_setVal("firma_vla",$reqFirma_vla);
		$this->myHlavicka->f_setVal("nazev1_vla",$reqNazev1_vla);
		$this->myHlavicka->f_setVal("ico_vla",$reqIco_vla);
		$this->myHlavicka->f_setVal("dic_vla",$reqDic_vla);
		$this->myHlavicka->f_setVal("adresa_vla",$reqAdresa_vla);
		$this->myHlavicka->f_setVal("psc_vla",$reqPsc_vla);
		$this->myHlavicka->f_setVal("mesto_vla",$reqMesto_vla);
		$this->myHlavicka->f_setVal("stat_vla",$reqStat_vla);
		$this->myHlavicka->f_setVal("telefon_vla",$reqTelefon_vla);
		$this->myHlavicka->f_setVal("fax_vla",$reqFax_vla);
		$this->myHlavicka->f_setVal("email_vla",$reqEmail_vla);

		$this->myHlavicka->f_setVal("poznamka",$reqPoznamka);
		$this->myHlavicka->f_setVal("id",$reqID);
		$this->myHlavicka->f_setVal("id_zpusob_platby",$reqZpPla);
		$this->myHlavicka->f_setVal("variabilni_symbol",$reqVarS);
		$this->myHlavicka->f_setVal("konstantni_symbol",$reqKonS);
		$this->myHlavicka->f_setVal("datum_vystaveni",$reqDatVys);
		$this->myHlavicka->f_setVal("datum_plneni",$reqDatPln);
		$this->myHlavicka->f_setVal("datum_splatnosti",$reqDatSpl);
        $this->myHlavicka->f_setVal("objednavka",$reqObj);
		$this->myHlavicka->f_setVal("id_objednavka",$reqObjId);
        $this->myHlavicka->f_setVal("language",$reqLang);
        
        $this->myHlavicka->f_setVal("id_user",$reqUser);

        // koeficient meny v danem case vygenerovani fa
        if ($reqLang != $this->mySetup["lang"]):
          $statement = 'select ifnull(jaz.kurz,1) as kurz,men.kod,jaz.id_mena from cc_jazyky jaz left join cc_mena men on men.id = jaz.id_mena where jaz.kod = "'.$reqLang.'"';
          $tmp = $this->mySQL->select($statement);
          for ($i=0;$i<count($tmp);$i++)
          {
             $this->koef=$tmp[$i]["kurz"];
          }
        else:
          $this->koef=1;
        endif;           
        		
		
	}
	function setPolozky(	$reqMnozstvi,
				$reqKatalog,
                $reqIdKatalog,
				$reqevidencni_cislo,
				$reqCena,
				$reqIdSazbaDph,
				$reqCelkem,
				$reqDPH,
				$reqCenasDPH,
				$reqIdDodavka="",
				$reqAutorkaOdmena,
				$reqElektroOdpad,
				$reqIdMena){
		if (!is_array($this->myPolozky)):
			$i=0;
		else:
			$i=count($this->myPolozky);
		endif;
			
		$this->myPolozky[$i] = new mPar();
		$this->myPolozky[$i]->f_setVal("mnozstvi",$reqMnozstvi);			
		$this->myPolozky[$i]->f_setVal("katalog",$reqKatalog);			
        $this->myPolozky[$i]->f_setVal("id_katalog",$reqIdKatalog);            
		$this->myPolozky[$i]->f_setVal("evidencni_cislo",$reqevidencni_cislo);			
		$this->myPolozky[$i]->f_setVal("cena",$reqCena);			
		$this->myPolozky[$i]->f_setVal("id_sazba_dph",$reqIdSazbaDph);			
		$this->myPolozky[$i]->f_setVal("celkem",$reqCelkem);			
		$this->myPolozky[$i]->f_setVal("dph",$reqDPH);			
		$this->myPolozky[$i]->f_setVal("cena_s_dph",$reqCenasDPH);			
		$this->myPolozky[$i]->f_setVal("id_dodavka",$reqIdDodavka);			
		$this->myPolozky[$i]->f_setVal("autorska_odmena",$reqAutorkaOdmena);			
		$this->myPolozky[$i]->f_setVal("elektroodpad",$reqElektroOdpad);			
		$this->myPolozky[$i]->f_setVal("id_mena",$reqIdMena);			
	}
	function getStatId($reqStat){
		$statement = 'select id from cc_stat where nazev = "'.$reqStat.'"';
		$tmpResult = $this->mySQL->select($statement);

		if ($this->mySQL->getRows() == 0):
			$rtn = '';
		else:
			$rtn = $tmpResult[0]["id"];
		endif;	
		return $rtn;
	}	
	
	function save($reqID=""){
		$this->myOrderNumber = $this->getNr("N");
		
		

		$statement = 'insert into faktura(cislo,stav,variabilni_symbol,objednavka,id_objednavka,jmeno,prijmeni,firma,ico,dic,adresa,psc,mesto,stat,tel,fax,email,id_vlastnik,vla_nazev,vla_nazev1,vla_ico,vla_dic,vla_adresa,vla_psc,vla_mesto,vla_stat,vla_tel,vla_fax,vla_email,id_user,poznamka,konstantni_symbol,id_zpusob_platby,datum_vystaveni,datum_plneni,datum_splatnosti,id_stat,language) values(';
		$statement.= '"'.$this->myOrderNumber.'","N",';
		$statement.= '"'.decode($this->myHlavicka->f_getVal("variabilni_symbol")=="",$this->myOrderNumber,$this->myHlavicka->f_getVal("variabilni_symbol")).'",';
        $statement.= decode($this->myHlavicka->f_getVal("objednavka")=="",'NULL','"'.$this->myHlavicka->f_getVal("objednavka").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("id_objednavka")=="",'NULL','"'.$this->myHlavicka->f_getVal("id_objednavka").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("jmeno")=="",'NULL','"'.$this->myHlavicka->f_getVal("jmeno").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("prijmeni")=="",'NULL','"'.$this->myHlavicka->f_getVal("prijmeni").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("firma")=="",'NULL','"'.$this->myHlavicka->f_getVal("firma").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("ico")=="",'NULL','"'.$this->myHlavicka->f_getVal("ico").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("dic")=="",'NULL','"'.$this->myHlavicka->f_getVal("dic").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("adresa")=="",'NULL','"'.$this->myHlavicka->f_getVal("adresa").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("psc")=="",'NULL','"'.$this->myHlavicka->f_getVal("psc").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("mesto")=="",'NULL','"'.$this->myHlavicka->f_getVal("mesto").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("stat")=="",'NULL','"'.$this->myHlavicka->f_getVal("stat").'"').',';


		$statement.= decode($this->myHlavicka->f_getVal("telefon")=="",'NULL','"'.$this->myHlavicka->f_getVal("telefon").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("fax")=="",'NULL','"'.$this->myHlavicka->f_getVal("fax").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("email")=="",'NULL','"'.$this->myHlavicka->f_getVal("email").'"').',';

		$statement.= decode($this->myHlavicka->f_getVal("id_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("id_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("firma_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("firma_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("nazev1_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("nazev1_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("ico_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("ico_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("dic_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("dic_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("adresa_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("adresa_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("psc_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("psc_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("mesto_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("mesto_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("stat_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("stat_vla").'"').',';


		$statement.= decode($this->myHlavicka->f_getVal("telefon_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("telefon_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("fax_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("fax_vla").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("email_vla")=="",'NULL','"'.$this->myHlavicka->f_getVal("email_vla").'"').',';

        $statement.= decode($this->myHlavicka->f_getVal("id_user")=="","0",'"'.$this->myHlavicka->f_getVal("id_user").'"').',';

//		$statement.= '"'.$_SESSION['uzivatel'].'",';

		$statement.= decode($this->myHlavicka->f_getVal("poznamka")=="",'NULL','"'.$this->myHlavicka->f_getVal("poznamka").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("konstantni_symbol")=="",'NULL','"'.$this->myHlavicka->f_getVal("konstantni_symbol").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("id_zpusob_platby")=="",'NULL','"'.$this->myHlavicka->f_getVal("id_zpusob_platby").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("datum_vystaveni")=="",'NULL','"'.$this->myHlavicka->f_getVal("datum_vystaveni").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("datum_plneni")=="",'NULL','"'.$this->myHlavicka->f_getVal("datum_plneni").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("datum_splatnosti")=="",'NULL','"'.$this->myHlavicka->f_getVal("datum_splatnosti").'"').',';
		$statement.= decode($this->myHlavicka->f_getVal("id_stat")=="",'NULL','"'.$this->myHlavicka->f_getVal("id_stat").'"').',';
        $statement.= decode($this->myHlavicka->f_getVal("language")=="",'NULL','"'.$this->myHlavicka->f_getVal("language").'"').')';

		$this->myResult = $this->mySQL->insert($statement);

		if ($this->mySQL->getRows() > 0):
			$rtn["error_code"] = '0';
			$rtn["error_txt"] = '';
			$rtn["id"] = $this->mySQL->getID();
			$this->myObjId = $this->mySQL->getID();
		else:
			$rtn["error_code"] = '-1';
			$rtn["error_txt"] = 'Chyba b?hem insertu';
			$rtn["id"] = '-1';
		endif;	

		if ($this->mySQL->getRows() > 0):
			for ($i=0;$i<count($this->myPolozky);$i++){
				$statement = 'insert into faktura_detail(id_faktura,id_katalog,koeficient,id_sazba_dph,id_mena,zbozi,evidencni_cislo,id_dodavka,mnozstvi,cena_mj,autorska_odmena,elektroodpad,celkem,dph,celkem_s_dph) values(';
				$statement.= '"'.$this->myObjId.'",';
                $statement.= decode($this->myPolozky[$i]->f_getVal("id_katalog")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("id_katalog").'"').',';
                $statement.= decode($this->koef=="",'NULL','"'.$this->koef.'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("id_sazba_dph")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("id_sazba_dph").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("id_mena")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("id_mena").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("katalog")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("katalog").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("evidencni_cislo")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("evidencni_cislo").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("id_dodavka")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("id_dodavka").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("mnozstvi")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("mnozstvi").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("cena")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("cena").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("autorska_odmena")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("autorska_odmena").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("elektroodpad")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("elektroodpad").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("celkem")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("celkem").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("dph")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("dph").'"').',';
				$statement.= decode($this->myPolozky[$i]->f_getVal("cena_s_dph")=="",'NULL','"'.$this->myPolozky[$i]->f_getVal("cena_s_dph").'"').')';
				
				$this->myResult = $this->mySQL->insert($statement);
			}
		endif;
		

		return $rtn;		
		
	}

	function getOrderNumber(){
		return $this->myOrderNumber;
	}

	function getOstPoplatky($reqId){
		$statement = 'select ifnull(autorska_odmena,0) as autorska_odmena,ifnull(elektroodpad,0) as elektroodpad from katalog where id = "'.$reqId.'"';

		$this->myResult = $this->mySQL->select($statement);

		$rtn["autorska_odmena"]=$this->myResult[0]["autorska_odmena"];
		$rtn["elektroodpad"]=$this->myResult[0]["elektroodpad"];
		return $rtn;
	}


	function getNr($reqAction="C"){
		
		$myMaska = new Maska('faktura','cislo');
		
		$rtn = "";
		$statement = 'SELECT '.$myMaska->getColumn().' as cislo FROM faktura where '.$myMaska->getWhere();
//		echo $statement;


		$this->myResult = $this->mySQL->select($statement);

		for ($i=0;$i<count($this->myResult);$i++){
			if ($this->mySQL->getRows() == 0):
				$rtn = str_pad('1', 5, "0", STR_PAD_LEFT); 
			else:
				if ($reqAction == 'C'):
					$rtn = str_pad($this->myResult[$i]["cislo"], $myMaska->getCislic(), "0", STR_PAD_LEFT); 
				elseif($reqAction == 'N'):
					$rtn = str_pad($this->myResult[$i]["cislo"]+1, $myMaska->getCislic(), "0", STR_PAD_LEFT); 
				endif;				
			endif;				
		}		
		$rtn = $myMaska->getPrefix().$myMaska->getRok().$rtn.$myMaska->getSufix();
		
		return $rtn;
		
	}

	function setFaktura($reqID){
		$statement = 'SELECT a.id,a.id_zpusob_platby,a.variabilni_symbol,a.objednavka,a.id_objednavka,a.jmeno,a.prijmeni,a.firma,a.ico,a.dic,a.adresa,a.psc,a.mesto,a.stat,a.id_stat,a.tel,a.fax,a.email,a.id_vlastnik,a.vla_nazev,a.vla_nazev1,a.vla_ico,a.vla_dic,a.vla_adresa,a.vla_psc,a.vla_mesto,a.vla_stat,a.vla_tel,a.vla_fax,a.vla_email,a.poznamka,a.konstantni_symbol,a.datum_vystaveni,a.datum_plneni,a.datum_splatnosti FROM faktura a where a.id = \''.$reqID.'\'';
//echo $statement;
		$this->myResult = $this->mySQL->select($statement);
		for ($i=0;$i<count($this->myResult);$i++){
			$this->setHlavicka(	
				$this->myResult[$i]["jmeno"],
				$this->myResult[$i]["prijmeni"],
				$this->myResult[$i]["firma"],
				$this->myResult[$i]["ico"],
				$this->myResult[$i]["dic"],
				$this->myResult[$i]["adresa"],
				$this->myResult[$i]["psc"],
				$this->myResult[$i]["mesto"],
				$this->myResult[$i]["stat"],
                $this->myResult[$i]["id_stat"],
				$this->myResult[$i]["tel"],
				$this->myResult[$i]["fax"],
				$this->myResult[$i]["email"],
				$this->myResult[$i]["id_vlastnik"],
				$this->myResult[$i]["vla_nazev"],
				$this->myResult[$i]["vla_nazev1"],
				$this->myResult[$i]["vla_ico"],
				$this->myResult[$i]["vla_dic"],
				$this->myResult[$i]["vla_adresa"],
				$this->myResult[$i]["vla_psc"],
				$this->myResult[$i]["vla_mesto"],
				$this->myResult[$i]["vla_stat"],
				$this->myResult[$i]["vla_tel"],
				$this->myResult[$i]["vla_fax"],
				$this->myResult[$i]["vla_email"],
				$this->myResult[$i]["poznamka"],
				$this->myResult[$i]["datum)vystaveni"],
				$this->myResult[$i]["datum_plneni"],
				$this->myResult[$i]["datum_splatnosti"],
                $this->myResult[$i]["objednavka"],
				$this->myResult[$i]["id_objednavka"],
				$this->myResult[$i]["id_zpusob_platby"],
				$this->myResult[$i]["konstantni_symbol"],
				$this->myResult[$i]["id"],
				$this->myResult[$i]["variabilni_symbol"]);
		}		


		$statement = 'SELECT a.id,a.mnozstvi,a.cena_mj,a.id_mena,a.celkem,a.celkem_s_dph,a.dph,a.zbozi,a.id_katalog,a.evidencni_cislo,a.id_sazba_dph,a.id_dodavka,a.elektroodpad,a.autorska_odmena FROM faktura_detail a where a.id_faktura = \''.$reqID.'\'';

		$this->myResult = $this->mySQL->select($statement);
		for ($i=0;$i<count($this->myResult);$i++){
			$this->setPolozky(	$this->myResult[$i]["mnozstvi"],
						$this->myResult[$i]["zbozi"],
                        $this->myResult[$i]["id_katalog"],
						$this->myResult[$i]["evidencni_cislo"],
						$this->myResult[$i]["cena_mj"],
						$this->myResult[$i]["id_sazba_dph"],
						$this->myResult[$i]["celkem"],
						$this->myResult[$i]["dph"],
						$this->myResult[$i]["celkem_s_dph"],
						$this->myResult[$i]["id_dodavka"],
						$this->myResult[$i]["autorska_odmena"],
						$this->myResult[$i]["elektroodpad"],
						$this->myResult[$i]["id_mena"]);
		}	
	}
	function getHlavicka(){
		return $this->myHlavicka;
	}
	function getPolozky(){
		return $this->myPolozky;
	}
	function getDodavkaName($reqId){
		$statement = 'select nazev from cc_dodavka where id = "'.$reqId.'"';

		$this->myResult = $this->mySQL->select($statement);

		return $this->myResult[0]["nazev"];
	}
	function getSazba($reqId){
		$statement = 'select nazev from cc_sazba_dph where id = "'.$reqId.'"';

		$this->myResult = $this->mySQL->select($statement);

		return $this->myResult[0]["nazev"];

	}
	function getSplatnost($reqDate,$pouzijSplatnost){
        if ($pouzijSplatnost=="N"):
		    $statement = 'select ifnull(splatnost,0) as splatnost from vlastnik limit 1';
		    $this->myResult = $this->mySQL->select($statement);
            return date("Y-m-d", mktime(0, 0, 0, date('m'), date('d')+$this->myResult[0]["splatnost"], date('Y')));
        else:
            return $reqDate;
        endif;
	}
}


class GoogleApi
{

    var $mySQL;
    var $myResult;
    var $myInit;
    var $myKatalog;
    var $myKategorie;
    var $myDoprava;

    function __construct($varLang='CZ')
    {
        $this->myInit = new init();
        $this->mySQL = new sql($this->myInit);
    
        $instBase = new Base($langVar);
        $mySetup = $instBase->getSetup();
        
        $sqlStat = 'select k.id,k.nazev,k.evidencni_cislo,k.zkracene,k.popis,k.cena_mo,k.cena_mo_s_dph,k.id_kategorie,v.nazev as vyrobce,kat.kod_google from katalog k left join vyrobce v on v.id=k.id_vyrobce left join kategorie kat on kat.id=k.id_kategorie';
        $this->myKatalog = $this->mySQL->select($sqlStat);
        for ($i=0;$i<count($this->myKatalog);$i++)
        {
            if ($varLang!=$mySetup["lang"]):
                $this->myKatalog[$i]["nazev"] = ($instBase->getLang($varLang,$this->myKatalog[$i]["id"],'katalog','nazev'));
                $this->myKatalog[$i]["zkracene"] = ($instBase->getLang($varLang,$this->myKatalog[$i]["id"],'katalog','zkracene'));
                $this->myKatalog[$i]["popis"] = ($instBase->getLang($varLang,$this->myKatalog[$i]["id"],'katalog','popis'));
            endif;
        }
        
        $sqlStatKat = 'select id,nazev,id_parent from kategorie where druh="E"';
        $this->myKategorie = $this->mySQL->select($sqlStatKat);
        for ($i=0;$i<count($this->myKategorie);$i++)
        {
            if ($varLang!=$mySetup["lang"]):
                $this->myKategorie[$i]["nazev"] = ($instBase->getLang($varLang,$this->myKategorie[$i]["id"],'kategorie','nazev'));
            endif;
        }
        
//        $sqlStatClanek = 'select id,nazev from clanek where sektor!="C" order by id asc';
        $sqlStatClanek = 'select id,nazev from clanek order by id asc';
        $this->myClanek = $this->mySQL->select($sqlStatClanek);
        for ($i=0;$i<count($this->myClanek);$i++)
        {
            if ($varLang!=$mySetup["lang"]):
                $this->myClanek[$i]["nazev"] = ($instBase->getLang($varLang,$this->myClanek[$i]["id"],'clanek','nazev'));
            endif;
        }

//        $sqlStatArtist = 'select id,jmeno,prijmeni from users where typ="T" and stav="C" order by id asc';
//        $this->myArtist = $this->mySQL->select($sqlStatArtist);

        /*
        if ($varLang==$this->mySetup["lang"]):
            $rtn[$i]["nazev"] = $this->myResult[$i]["nazev"];
        else:
            $rtn[$i]["nazev"] = ($this->getLang($varLang,$this->myResult[$i]["id"],'cc_dodavka','nazev'));
        endif;
        */
        
    }
    
    function getKategorie($reqId){
//        $sqlStat = 'select k.id as id0,k.nazev kat0,k1.id as id1,k1.nazev as kat1,k2.id as id2,k2.nazev as kat2 from kategorie k left join kategorie k1 on k.id_parent = k1.id left join kategorie k2 on k1.id_parent = k2.id where k.id = "'.$reqId.'"';
        $sqlStat = 'select k.id as id0,k.kod_heureka kat0,k1.id as id1,k1.nazev as kat1,k2.id as id2,k2.nazev as kat2 from kategorie k left join kategorie k1 on k.id_parent = k1.id left join kategorie k2 on k1.id_parent = k2.id where k.id = "'.$reqId.'"';

//echo $sqlStat .'<br><br>';
        $tmpKategorie = $this->mySQL->select($sqlStat);
//        $rtn = "BuyFineArtsOnline.com";
        $rtn = "";
        
        for ($i=0;$i<count($tmpKategorie);$i++)    {
            if ($tmpKategorie[$i]["kat0"]!=""):
//                $rtn .= ' > ' .$tmpKategorie[$i]["kat0"];
                $rtn .= '' .$tmpKategorie[$i]["kat0"];
            endif;    
            if ($tmpKategorie[$i]["kat1"]!=""):
                $rtn .= ' ' .$tmpKategorie[$i]["kat1"];
            endif;
            if ($tmpKategorie[$i]["kat2"]!=""):
                $rtn .= ' ' .$tmpKategorie[$i]["kat2"];
            endif;
        }
        return $rtn;
    
    }
    function getDopravaGoogle(){
        $sqlStat = 'SELECT d.price,s.kod from tmpDoprava d left join cc_stat s on s.nazev = d.country group by d.country';
        $this->myDoprava = $this->mySQL->select($sqlStat);

        $rtn = "<g:shipping>";
        for ($i=0;$i<count($this->myDoprava);$i++)
        {
            $rtn .= '<g:country>'.$this->myDoprava[$i]["kod"].'</g:country>';
            $rtn .= '<g:price>'.$this->myDoprava[$i]["price"].' USD</g:price>';
        }
        $rtn .= "</g:shipping>";
        return $rtn;
        
        
    }

    
    function generuj()
    {
        $myXml = new XMLWriter();
        $myXml->openMemory();
        $myXml->startDocument('1.0', 'UTF-8');
        
        $myXml->startElement('rss');
        $myXml->writeAttribute("version", "2.0");
        $myXml->writeAttribute("xmlns:g", "http://base.google.com/ns/1.0");
        $myXml->startElement('channel');

        $tmpBase = new Base($varLang);
        $tmpVlastnik = $tmpBase->getVlastnik();

        for ($i=0;$i<count($this->myKatalog);$i++){

            $tmpNav = $tmpBase->getNavigaceBack($this->myKatalog[$i]["id"]);    
            $dopParent = $tmpNav["parent"];
            $dopSubparent = $tmpNav["subparent"];
            $dopKategorie = $tmpNav["kategorie"];

    
            $tmpFile = $tmpBase->getPrilohy('id_katalog',$this->myKatalog[$i]["id"],"P");
            
            $myXml->startElement('item');
            $myXml->writeElement('title',htmlspecialchars($this->myKatalog[$i]["nazev"]));
            
//            if (strlen($this->myKatalog[$i]["zkracene"]) < 5):
//                $myXml->writeElement('description',$this->myKatalog[$i]["nazev"]);
//            else:
                $myXml->writeElement('description',htmlspecialchars($this->myKatalog[$i]["nazev"]).' -'.htmlspecialchars($this->getKategorie($this->myKatalog[$i]["id_kategorie"])).' Za výhodnou cenu '.number_format($this->myKatalog[$i]["cena_mo_s_dph"], 0,""," ").',-Kč. Nakupujte od specializovaného eshopu!');
//            endif;    
//            $myXml->writeElement('g:product_type',htmlspecialchars($this->getKategorie($this->myKatalog[$i]["id_kategorie"])));
//            $myXml->writeElement('g:google_product_category',htmlspecialchars($this->getKategorie($this->myKatalog[$i]["id_kategorie"])));
            $myXml->writeElement('g:product_type',htmlspecialchars($this->myKatalog[$i]["kod_google"]));
            $myXml->writeElement('g:google_product_category',htmlspecialchars($this->myKatalog[$i]["kod_google"]));
            $myXml->writeElement('g:availability','in stock');
            $myXml->writeElement('g:brand',htmlspecialchars($this->myKatalog[$i]["vyrobce"]));
            $myXml->writeElement('g:condition','new');
            $myXml->writeElement('g:link',htmlspecialchars($tmpVlastnik[0]["url"].'/eshop/'.$this->myKatalog[$i]["id"]).'/'.stripcz_seo($this->myKatalog[$i]["nazev"]).'.html');

            for ($y=0;$y<count($tmpFile);$y++){
                if ($tmpFile[$y]["sektor"]=='HLAVNI'):
                    $myXml->writeElement('g:image_link',$tmpVlastnik[0]["url"].'/picture/large/'.$tmpFile[$y]["soubornew"]);
                    break;
                endif;
            }    

            $myXml->writeElement('g:price',$this->myKatalog[$i]["cena_mo_s_dph"]);

            $myXml->startElement('g:tax');
                $myXml->writeElement('g:country',"CZ");
                $myXml->writeElement('g:rate',"0");
            $myXml->endElement();

//            $doprava = $this->getDopravaGoogle();
//            print_r($doprava);
//            $myXml->writeRaw($this->getDopravaGoogle());
            $myXml->startElement('g:shipping');
                $myXml->writeElement('g:price',"100 CZK ");
            $myXml->endElement();
            
            $myXml->writeElement('g:id',htmlspecialchars ($this->myKatalog[$i]["evidencni_cislo"]));
            $myXml->writeElement('g:mpn',htmlspecialchars ($this->myKatalog[$i]["evidencni_cislo"]));
            $myXml->endElement();
        }

        
////        
        $myXml->endElement();
        $myXml->endElement();
        
        $xmlContent = $myXml->outputMemory(true);
        
        $filename ="../google.xml";
        $fd = fopen( $filename, "w" );
        $write = fputs($fd, $xmlContent);
        fclose( $fd );
        
        unset($tmpBase);
    }

 function generujSitemap()
    {
        $myXml = new XMLWriter();
        $myXml->openMemory();
        $myXml->startDocument('1.0', 'UTF-8');
        
        $myXml->startElement('urlset');
        $myXml->writeAttribute("xmlns", "http://www.sitemaps.org/schemas/sitemap/0.9");

        $tmpBase = new Base($varLang);
        $tmpVlastnik = $tmpBase->getVlastnik();
        
        $myXml->startElement('url');
        $myXml->writeElement('loc',htmlspecialchars($tmpVlastnik[0]["url"]).'/podminky.html');
        $myXml->endElement();
        $myXml->startElement('url');
        $myXml->writeElement('loc',htmlspecialchars($tmpVlastnik[0]["url"]).'/kontakty.html');
        $myXml->endElement();
    
        for ($i=0;$i<count($this->myClanek);$i++){
            $myXml->startElement('url');
            $myXml->writeElement('loc',htmlspecialchars($tmpVlastnik[0]["url"].'/clanek/'.$this->myClanek[$i]["id"].'/'.stripcz_seo($this->myClanek[$i]["nazev"]).'.html'));
            $myXml->endElement();
        }

        for ($i=0;$i<count($this->myKategorie);$i++){
            if ($this->myKategorie[$i]["id_parent"]!="" or $this->myKategorie[$i]["nazev"]!="NULL"):
                $myXml->startElement('url');
                $myXml->writeElement('loc',htmlspecialchars($tmpVlastnik[0]["url"].'/'.stripcz_seo($this->myKategorie[$i]["nazev"]).'/'.$this->myKategorie[$i]["id"]).'/');
                $myXml->endElement();
            else:
                $myXml->startElement('url');
                $myXml->writeElement('loc',htmlspecialchars($tmpVlastnik[0]["url"].'/'.stripcz_seo($this->myKategorie[$i]["nazev"]).'/'.$this->myKategorie[$i]["id"]).'/prvni/');
                $myXml->endElement();
            endif;
        }
        
        for ($i=0;$i<count($this->myKatalog);$i++){
            $myXml->startElement('url');
            $myXml->writeElement('loc',htmlspecialchars($tmpVlastnik[0]["url"].'/eshop/'.$this->myKatalog[$i]["id"]).'/'.stripcz_seo($this->myKatalog[$i]["nazev"]).'.html');
            $myXml->endElement();
        }

        
////        
        $myXml->endElement();
        $myXml->endElement();
        
        $xmlContent = $myXml->outputMemory(true);
        
        $filename ="../sitemap.xml";
        $fd = fopen( $filename, "w" );
        $write = fputs($fd, $xmlContent);
        fclose( $fd );
        
        unset($tmpBase);
    }    
}
class jyxo{
	var $mySQL;
	var $myResult;
	var $myInit;
	var $myKatalog;
	var $myKategorie;

	function __construct(){
		$this->myInit = new init();
		$this->mySQL = new sql($this->myInit);
	
		$sqlStat = 'select k.id,k.velkosklad_cislo,k.evidencni_cislo,k.nazev,k.zkracene,k.popis,k.cena_mo,k.id_kategorie,ifnull(k.elektroodpad,0) as elektroodpad,ifnull(k.autorska_odmena,0) as autorska_odmena,s.sazba,ifnull(vyr.nazev,"Ostatn?") as vyrobce,DATEDIFF(CURDATE(),k.dostupnost_datum) as dostupnost_dnu,k.dostupnost_datum,ifnull(dos.kod_jyxo,0) as kod_jyxo,kat.rabat,k.pevna_koncova_cena,k.prednostni_vypis_jyxo,s.nazev as sazba_nazev from katalog k left join cc_dostupnost dos on dos.id = k.id_dostupnost left join cc_sazba_dph s on s.id = k.id_sazba_dph left join vyrobce vyr on vyr.id = k.id_vyrobce left join kategorie kat on kat.id = k.id_kategorie where k.zobrazovat="A" and kat.export_jyxo="A" order by k.prednostni_vypis_jyxo ASC ';
//echo $sqlStat .'<br><br>';

		$this->myKatalog = $this->mySQL->select($sqlStat);
	}
	
	function getKategorie($reqId){
		$sqlStat = 'select k.id as id0,k.nazev kat0,k1.id as id1,k1.nazev as kat1,k2.id as id2,k2.nazev as kat2 from kategorie k left join kategorie k1 on k.id_parent = k1.id left join kategorie k2 on k1.id_parent = k2.id where k.id = "'.$reqId.'"';

//echo $sqlStat .'<br><br>';
		$tmpKategorie = $this->mySQL->select($sqlStat);
		$rtn = '';
		
		for ($i=0;$i<count($tmpKategorie);$i++)	{
			if ($tmpKategorie[$i]["kat0"]!=""):
				$rtn .= decode($rtn=="",'',' - ') . $tmpKategorie[$i]["kat0"];
			endif;	
			if ($tmpKategorie[$i]["kat1"]!=""):
				$rtn .= decode($rtn=="",'',' - ') . $tmpKategorie[$i]["kat1"];
			endif;
			if ($tmpKategorie[$i]["kat2"]!=""):
				$rtn .= decode($rtn=="",'',' - ') . $tmpKategorie[$i]["kat2"];
			endif;
		}
		return $rtn;
	
	}
	function getKategorieHeureka($reqId){
		$sqlStat = 'select k.kod_heureka from kategorie k  where k.id = "'.$reqId.'"';

//echo $sqlStat .'<br><br>';
		$tmpKategorie = $this->mySQL->select($sqlStat);
		$rtn = '';
		
		for ($i=0;$i<count($tmpKategorie);$i++)	{
                    $rtn .= $tmpKategorie[$i]["kod_heureka"];
		}
		return $rtn;
	}
        function getFilters($katalogId)
        {
            $arrRtn = array(array()=>array());
            $statement = 'SELECT s.nazev as skupina,f.nazev as filtr,kf.sklad FROM katalog_filtr kf LEFT JOIN filtr f on f.id = kf.id_filtr LEFT JOIN skupina s on s.id = f.id_skupina WHERE kf.id_katalog = '.$katalogId.' and kf.prirazen = "A" order by s.nazev,f.nazev';
            $arrFiltr = $this->mySQL->select($statement);
                
            for ($i=0;$i<count($arrFiltr);$i++)
            {
                if ($arrFiltr[$i]["skupina"]!='' && $arrFiltr[$i]["filtr"]!=''):
                    $arrRtn[$arrFiltr[$i]["skupina"]][count($arrRtn[$arrFiltr[$i]["skupina"]])]=$arrFiltr[$i]["filtr"];
                endif;
            }
            return $arrRtn;
        }
        
	function generuj($isHeureka=false){
	
		$rtn = "0";
                $tmpXml = '<?xml version="1.0" encoding="utf-8"?>';
                if ($isHeureka):
                    $tmpXml .= '<SHOP>';
                else:
                    $tmpXml .= '<SHOP xmlns="http://www.zbozi.cz/ns/offer/1.0">';
                endif;
		
		$tmpXml .= "\n";

		$tmpBase = new Base();
		$tmpVlastnik = $tmpBase->getVlastnik();
		$mySetup = $tmpBase->getSetup();

                for ($i=0;$i<count($this->myKatalog);$i++){

			$tmpNav = $tmpBase->getNavigaceBack($this->myKatalog[$i]["id"]);	
			$dopParent = $tmpNav["parent"];
			$dopSubparent = $tmpNav["subparent"];
			$dopKategorie = $tmpNav["kategorie"];



			$tmpCenaKon = $this->myKatalog[$i]["cena_mo"];
			$tmpCenaKonDph = $this->myKatalog[$i]["cena_mo_s_dph"];

			
			if ($mySetup["ceny_dle_dkat"]=="A"):
				$statement = 'select slv.sleva from dealerska_kategorie usr left join sleva slv on slv.id_kategorie = "'.$this->myKatalog[$i]["id_kategorie"].'" and slv.id_dealerska_kategorie = usr.id where usr.implicitni = "A"';
	
				$tmpDS = $this->mySQL->select($statement);
				if ($this->mySQL->getRows()==0):
					$mySleva = "";
				else:
					$mySleva = $tmpDS[0]["sleva"];
				endif;
	
				if ($mySleva != ""):
					$tmpCena = $this->myKatalog[$i]["cena_mo"] / 100;
					$tmpSleva = $tmpCena * $mySleva;
					$tmpCenaKon = $this->myKatalog[$i]["cena_mo"] - $tmpSleva;
				endif;
			endif;
			
				// Pricteni rabatu
			$rabat = $this->myKatalog[$i]["rabat"];
			$tmpRabatCastka = $tmpCenaKon / 100;
			$tmpRabatCastka = $tmpRabatCastka * $rabat;
	
			
			if ($rabat > 0 and $this->myKatalog[$i]["pevna_koncova_cena"]=="N"):	
				$tmpCenaKon = $tmpCenaKon + $tmpRabatCastka;
			endif;	
	
			$tmpFile = $tmpBase->getPrilohy('id_katalog',$this->myKatalog[$i]["id"],"P");
			
			$tmpXml .= '<SHOPITEM>';
			$tmpXml .= "\n";
//			$tmpXml .= '<PRODUCT>'.$tmpVlastnik[0]["nazev"].' '.htmlspecialchars ($this->myKatalog[$i]["nazev"]);
//			$tmpXml .= ' - '.htmlspecialchars ($this->getKategorie($this->myKatalog[$i]["id_kategorie"]));

                        $tmpXml .= '<PRODUCTNAME>'.htmlspecialchars ($this->myKatalog[$i]["nazev"]);			
                        $tmpXml .=  '</PRODUCTNAME>';
                        $tmpXml .= "\n";

                        $tmpXml .= '<ITEM_ID>'.htmlspecialchars ($this->myKatalog[$i]["evidencni_cislo"]);			
                        $tmpXml .=  '</ITEM_ID>';
                        $tmpXml .= "\n";

                        $tmpXml .= '<EAN>'.htmlspecialchars ($this->myKatalog[$i]["velkosklad_cislo"]);			
                        $tmpXml .=  '</EAN>';
			$tmpXml .= "\n";

                        $tmpXml .= '<CATEGORYTEXT>';
                        if ($isHeureka):
                            $tmpXml .= htmlspecialchars (ltrim($this->getKategorieHeureka($this->myKatalog[$i]["id_kategorie"])));
                        else:
                            $tmpXml .= htmlspecialchars ($this->getKategorie($this->myKatalog[$i]["id_kategorie"]));
                        endif;
			$tmpXml .=  '</CATEGORYTEXT>';
			$tmpXml .= "\n";

			if (strlen($this->myKatalog[$i]["zkracene"]) < 5):
				$tmpXml .= '<DESCRIPTION>'.htmlspecialchars ($this->myKatalog[$i]["nazev"]).'</DESCRIPTION>';
			else:
				$tmpXml .= '<DESCRIPTION>'.htmlspecialchars ($this->myKatalog[$i]["zkracene"]).'</DESCRIPTION>';
			endif;	
			$tmpXml .= "\n";

//			$tmpXml .= '<DUES>'.(($this->myKatalog[$i]["elektroodpad"]+$this->myKatalog[$i]["autorska_odmena"])*$this->myKatalog[$i]["sazba"]).'</DUES>';
//			$tmpXml .= "\n";
			
                        if ($this->myKatalog[$i]["prednostni_vypis_jyxo"]=="N"):
//                            $tmpXml .= '<TOLLFREE>1</TOLLFREE>';
//                            $tmpXml .= "\n";
                        endif;
            
//			$tmpXml .= '<URL>'.htmlspecialchars ($tmpVlastnik[0]["url"].'/index.php?stranka=eshop&id='.$this->myKatalog[$i]["id"]).'</URL>';
			$tmpXml .= '<URL>'.htmlspecialchars ($tmpVlastnik[0]["url"].'/eshop/'.$this->myKatalog[$i]["id"]).'-'.stripcz_seo($this->myKatalog[$i]["nazev"]).'.html</URL>';

			$tmpXml .= "\n";

			for ($y=0;$y<count($tmpFile);$y++){
				if ($tmpFile[$y]["sektor"]=='HLAVNI'):
//				$tmpXml .= '<IMGURL>'.$tmpVlastnik[0]["url"].'/picture/large/'.$img.'</IMGURL>';
					$tmpXml .= '<IMGURL>'.$tmpVlastnik[0]["url"].'/picture/large/'.$tmpFile[$y]["soubornew"].'</IMGURL>';
					$tmpXml .= "\n";
					break;
				endif;
			}	
                        if ($isHeureka):
                            for ($y=0;$y<count($tmpFile);$y++){
                                    if ($tmpFile[$y]["sektor"]=='OSTATNI'):
    //				$tmpXml .= '<IMGURL>'.$tmpVlastnik[0]["url"].'/picture/large/'.$img.'</IMGURL>';
                                            $tmpXml .= '<IMGURL_ALTERNATIVE>'.$tmpVlastnik[0]["url"].'/picture/large/'.$tmpFile[$y]["soubornew"].'</IMGURL_ALTERNATIVE>';
                                            $tmpXml .= "\n";
//                                            break;
                                    endif;
                            }	
                        endif;
                        
			$tmpXml .= '<MANUFACTURER>'.htmlspecialchars($this->myKatalog[$i]["vyrobce"]).'</MANUFACTURER>';
			$tmpXml .= "\n";
			
// zde filtry pokud existuji
                        if ($isHeureka):
                            $arrFiltr = array();
                            $arrFiltr=$this->getFilters($this->myKatalog[$i]["id"]);

                            if (count($arrFiltr)>0):
                                foreach ($arrFiltr as $key => $value) 
                                {
                                    for ($v=0;$v<count($value);$v++)
                                    {
                                        $tmpXml .= '<PARAM>';
                                        $tmpXml .= "\n";
                                        $tmpXml .= '<PARAM_NAME>';
                                        $tmpXml .= $key;
                                        $tmpXml .= '</PARAM_NAME>';
                                        $tmpXml .= "\n";

                                        $tmpXml .= '<VAL>';
                                        $tmpXml .= $value[$v];
                                        $tmpXml .= '</VAL>';
                                        $tmpXml .= "\n";
                                        $tmpXml .= '</PARAM>';
                                        $tmpXml .= "\n";
                                    }                                
                                }
                            endif;
                        endif;
                        
            
                        if ($this->myKatalog[$i]["kod_jyxo"]==""):
                            if ($this->myKatalog[$i]["dostupnost_datum"]==""):
                                $tmpDd = 0;
                            else:
                                $tmpDd = $this->myKatalog[$i]["dostupnost_datum"];
                            endif;    
                        else:
                            $tmpDd = $this->myKatalog[$i]["kod_jyxo"];
                        endif;

            /*            
			if ($this->myKatalog[$i]["dostupnost_dnu"]!=""):
			 $tmpAv = ($this->myKatalog[$i]["dostupnost_dnu"]*24);
 			 if ($tmpAv < 0):
				 $tmpAv=169;
			 endif;
			 $tmpDd = $this->myKatalog[$i]["dostupnost_datum"];
			else:
			 $tmpAv = $this->myKatalog[$i]["kod_jyxo"];
			 $tmpDd = date('Y-m-d');
			endif;
*/
			
//			$tmpXml .= '<AVAILABILITY>'.$tmpAv.'</AVAILABILITY>';
//			$tmpXml .= "\n";
			$tmpXml .= '<DELIVERY_DATE>'.$tmpDd.'</DELIVERY_DATE>';
			$tmpXml .= "\n";
                        if ($isHeureka):
                            $tmpXml .= '<PRICE>'.round($tmpCenaKon,1).'</PRICE>';
                            $tmpXml .= "\n";
                            $tmpXml .= '<VAT>'.str_replace('%','',$this->myKatalog[$i]["sazba_nazev"]).'</VAT>';
                            $tmpXml .= "\n";
                        else:
                            $tmpXml .= '<PRICE_VAT>'.round($tmpCenaKonDph,1).'</PRICE_VAT>';
                            $tmpXml .= "\n";
                        endif;

			$tmpXml .= '</SHOPITEM>';
			$tmpXml .= "\n";

// progress bar
			if ($i>0):
				$jednoProcento = $i / count($this->myKatalog);
				$aktProcento = round($jednoProcento * 100); 
			
				$tmpPozice = $aktProcento;
								
				echo '<script>';
				echo 'progress('.$tmpPozice.');';
				echo '</script>';
			endif;
			
		}

		$tmpXml .= '</SHOP>';
		$tmpXml .= "\n";

                if ($isHeureka):
                    $filename ="../jyxoHeureka.xml";
                else:
                    $filename ="../jyxo.xml";
                endif;
		$fd = fopen( $filename, "w" );
		$write = fputs($fd, $tmpXml);
		fclose( $fd );
		
		unset($tmpBase);

						
		echo '<script>';
		echo 'progress(100);';
		echo '</script>';
		
		
	}
	
}



/**
 * @deprecated since version 2.0
 */
class jyxoPuv{
	var $mySQL;
	var $myResult;
	var $myInit;
	var $myKatalog;
	var $myKategorie;

	function __construct(){
		$this->myInit = new init();
		$this->mySQL = new sql($this->myInit);
	
		$sqlStat = 'select k.id,k.nazev,k.zkracene,k.popis,k.cena_mo,k.id_kategorie,ifnull(k.elektroodpad,0) as elektroodpad,ifnull(k.autorska_odmena,0) as autorska_odmena,s.sazba,ifnull(vyr.nazev,"Ostatn?") as vyrobce,DATEDIFF(CURDATE(),k.dostupnost_datum) as dostupnost_dnu,k.dostupnost_datum,ifnull(dos.kod_jyxo,0) as kod_jyxo,kat.rabat,k.pevna_koncova_cena,k.prednostni_vypis_jyxo,ifnull(k.prednostni_vypis_firmy,"N") as prednostni_vypis_firmy,s.nazev as sazba_nazev from katalog k left join cc_dostupnost dos on dos.id = k.id_dostupnost left join cc_sazba_dph s on s.id = k.id_sazba_dph left join vyrobce vyr on vyr.id = k.id_vyrobce left join kategorie kat on kat.id = k.id_kategorie where k.zobrazovat="A" and kat.export_jyxo="A" order by k.prednostni_vypis_jyxo ASC ';
		$this->myKatalog = $this->mySQL->select($sqlStat);
	}
	
	function getKategorie($reqId){
		$sqlStat = 'select k.id as id0,k.nazev kat0,k1.id as id1,k1.nazev as kat1,k2.id as id2,k2.nazev as kat2 from kategorie k left join kategorie k1 on k.id_parent = k1.id left join kategorie k2 on k1.id_parent = k2.id where k.id = "'.$reqId.'"';

//echo $sqlStat .'<br><br>';
		$tmpKategorie = $this->mySQL->select($sqlStat);
		$rtn = '';
		
		for ($i=0;$i<count($tmpKategorie);$i++)	{
			if ($tmpKategorie[$i]["kat0"]!=""):
				$rtn .= decode($rtn=="",'',' - ') . $tmpKategorie[$i]["kat0"];
			endif;	
			if ($tmpKategorie[$i]["kat1"]!=""):
				$rtn .= decode($rtn=="",'',' - ') . $tmpKategorie[$i]["kat1"];
			endif;
			if ($tmpKategorie[$i]["kat2"]!=""):
				$rtn .= decode($rtn=="",'',' - ') . $tmpKategorie[$i]["kat2"];
			endif;
		}
		return $rtn;
	
	}
	
	function generuj(){
	
		$rtn = "0";

		$tmpXml = '<?xml version="1.0" encoding="utf-8"?>';
		$tmpXml .= '<SHOP>';
		$tmpXml .= "\n";

		$tmpBase = new Base();
		$tmpVlastnik = $tmpBase->getVlastnik();
		$mySetup = $tmpBase->getSetup();
		for ($i=0;$i<count($this->myKatalog);$i++){

			$tmpNav = $tmpBase->getNavigaceBack($this->myKatalog[$i]["id"]);	
			$dopParent = $tmpNav["parent"];
			$dopSubparent = $tmpNav["subparent"];
			$dopKategorie = $tmpNav["kategorie"];



			$tmpCenaKon = $this->myKatalog[$i]["cena_mo"];

			
			if ($mySetup["ceny_dle_dkat"]=="A"):
				$statement = 'select slv.sleva from dealerska_kategorie usr left join sleva slv on slv.id_kategorie = "'.$this->myKatalog[$i]["id_kategorie"].'" and slv.id_dealerska_kategorie = usr.id where usr.implicitni = "A"';
	
				$tmpDS = $this->mySQL->select($statement);
				if ($this->mySQL->getRows()==0):
					$mySleva = "";
				else:
					$mySleva = $tmpDS[0]["sleva"];
				endif;
	
				if ($mySleva != ""):
					$tmpCena = $this->myKatalog[$i]["cena_mo"] / 100;
					$tmpSleva = $tmpCena * $mySleva;
					$tmpCenaKon = $this->myKatalog[$i]["cena_mo"] - $tmpSleva;
				endif;
			endif;
			
				// Pricteni rabatu
			$rabat = $this->myKatalog[$i]["rabat"];
			$tmpRabatCastka = $tmpCenaKon / 100;
			$tmpRabatCastka = $tmpRabatCastka * $rabat;
	
			
			if ($rabat > 0 and $this->myKatalog[$i]["pevna_koncova_cena"]=="N"):	
				$tmpCenaKon = $tmpCenaKon + $tmpRabatCastka;
			endif;	
	
			$tmpFile = $tmpBase->getPrilohy('id_katalog',$this->myKatalog[$i]["id"],"P");
			
			$tmpXml .= '<SHOPITEM>';
			$tmpXml .= "\n";
//			$tmpXml .= '<PRODUCT>'.$tmpVlastnik[0]["nazev"].' '.htmlspecialchars ($this->myKatalog[$i]["nazev"]);
			$tmpXml .= '<PRODUCT>'.htmlspecialchars ($this->myKatalog[$i]["nazev"]);			
//			$tmpXml .= ' - '.htmlspecialchars ($this->getKategorie($this->myKatalog[$i]["id_kategorie"]));

			
			$tmpXml .=  '</PRODUCT>';
			$tmpXml .= "\n";
			$tmpXml .= '<CATEGORYTEXT>';
			$tmpXml .= htmlspecialchars ($this->getKategorie($this->myKatalog[$i]["id_kategorie"]));
			$tmpXml .=  '</CATEGORYTEXT>';
			$tmpXml .= "\n";

			if (strlen($this->myKatalog[$i]["zkracene"]) < 5):
				$tmpXml .= '<DESCRIPTION>'.htmlspecialchars ($this->myKatalog[$i]["nazev"]).'</DESCRIPTION>';
			else:
				$tmpXml .= '<DESCRIPTION>'.htmlspecialchars ($this->myKatalog[$i]["zkracene"]).'</DESCRIPTION>';
			endif;	
			$tmpXml .= "\n";

			$tmpXml .= '<DUES>'.(($this->myKatalog[$i]["elektroodpad"]+$this->myKatalog[$i]["autorska_odmena"])*$this->myKatalog[$i]["sazba"]).'</DUES>';
			$tmpXml .= "\n";
			
            if ($this->myKatalog[$i]["prednostni_vypis_jyxo"]=="N"):
                $tmpXml .= '<TOLLFREE>1</TOLLFREE>';
                $tmpXml .= "\n";
            endif;
            if ($this->myKatalog[$i]["prednostni_vypis_firmy"]=="A"):
                $tmpXml .= '<FIRMY_CZ>1</FIRMY_CZ>';
                $tmpXml .= "\n";
            else:
                $tmpXml .= '<FIRMY_CZ>0</FIRMY_CZ>';
                $tmpXml .= "\n";
            endif;

            
//			$tmpXml .= '<URL>'.htmlspecialchars ($tmpVlastnik[0]["url"].'/index.php?stranka=eshop&id='.$this->myKatalog[$i]["id"]).'</URL>';
			$tmpXml .= '<URL>'.htmlspecialchars ($tmpVlastnik[0]["url"].'/eshop/'.$this->myKatalog[$i]["id"]).'-'.stripcz_seo($this->myKatalog[$i]["nazev"]).'.html</URL>';

			$tmpXml .= "\n";

			for ($y=0;$y<count($tmpFile);$y++){
				if ($tmpFile[$y]["sektor"]=='HLAVNI'):
//				$tmpXml .= '<IMGURL>'.$tmpVlastnik[0]["url"].'/picture/large/'.$img.'</IMGURL>';
					$tmpXml .= '<IMGURL>'.$tmpVlastnik[0]["url"].'/picture/large/'.$tmpFile[$y]["soubornew"].'</IMGURL>';
					$tmpXml .= "\n";
					break;
				endif;
			}	
			$tmpXml .= '<MANUFACTURER>'.htmlspecialchars($this->myKatalog[$i]["vyrobce"]).'</MANUFACTURER>';
			$tmpXml .= "\n";
			
            
            
            if ($this->myKatalog[$i]["kod_jyxo"]==""):
                if ($this->myKatalog[$i]["dostupnost_datum"]==""):
                    $tmpDd = 0;
                else:
                    $tmpDd = $this->myKatalog[$i]["dostupnost_datum"];
                endif;    
            else:
                $tmpDd = $this->myKatalog[$i]["kod_jyxo"];
            endif;
            

            /*            
			if ($this->myKatalog[$i]["dostupnost_dnu"]!=""):
			 $tmpAv = ($this->myKatalog[$i]["dostupnost_dnu"]*24);
 			 if ($tmpAv < 0):
				 $tmpAv=169;
			 endif;
			 $tmpDd = $this->myKatalog[$i]["dostupnost_datum"];
			else:
			 $tmpAv = $this->myKatalog[$i]["kod_jyxo"];
			 $tmpDd = date('Y-m-d');
			endif;
*/
			
//			$tmpXml .= '<AVAILABILITY>'.$tmpAv.'</AVAILABILITY>';
//			$tmpXml .= "\n";
			$tmpXml .= '<DELIVERY_DATE>'.$tmpDd.'</DELIVERY_DATE>';
			$tmpXml .= "\n";
			$tmpXml .= '<PRICE>'.round($tmpCenaKon,1).'</PRICE>';
			$tmpXml .= "\n";
			$tmpXml .= '<VAT>'.str_replace('%','',$this->myKatalog[$i]["sazba_nazev"]).'</VAT>';
			$tmpXml .= "\n";

			$tmpXml .= '</SHOPITEM>';
			$tmpXml .= "\n";

// progress bar
			if ($i>0):
				$jednoProcento = $i / count($this->myKatalog);
				$aktProcento = round($jednoProcento * 100); 
			
				$tmpPozice = $aktProcento;
								
				echo '<script>';
				echo 'progress('.$tmpPozice.');';
				echo '</script>';
			endif;
			
		}

		$tmpXml .= '</SHOP>';
		$tmpXml .= "\n";

		$filename ="../jyxo.xml";
		$fd = fopen( $filename, "w" );
		$write = fputs($fd, $tmpXml);
		fclose( $fd );
		
		unset($tmpBase);

						
		echo '<script>';
		echo 'progress(100);';
		echo '</script>';
		
		
	}
	
}


class naseptavac{
    var $mySQL;
    var $myResult;
    var $myInit;
    var $myKatalog;
    var $myKategorie;

    function __construct()
    {
        $this->myInit = new init();
        $this->mySQL = new sql($this->myInit);
    
        $sqlStat = 'select k.id,k.nazev,k.zkracene,k.popis,k.cena_mo,k.id_kategorie,ifnull(k.elektroodpad,0) as elektroodpad,ifnull(k.autorska_odmena,0) as autorska_odmena,s.sazba,ifnull(vyr.nazev,"Ostatn?") as vyrobce,DATEDIFF(CURDATE(),k.dostupnost_datum) as dostupnost_dnu,k.dostupnost_datum,ifnull(dos.kod_jyxo,0) as kod_jyxo,kat.rabat,k.pevna_koncova_cena,k.prednostni_vypis_jyxo,s.nazev as sazba_nazev from katalog k left join cc_dostupnost dos on dos.id = k.id_dostupnost left join cc_sazba_dph s on s.id = k.id_sazba_dph left join vyrobce vyr on vyr.id = k.id_vyrobce left join kategorie kat on kat.id = k.id_kategorie where k.zobrazovat="A" and kat.export_jyxo="A" order by k.prednostni_vypis_jyxo ASC ';
//echo $sqlStat .'<br><br>';

        $this->myKatalog = $this->mySQL->select($sqlStat);
    }
    

    
      function generuj_naseptavac($varLang="CZ"){
    
        $rtn = "0";

        $tmpXml = 'var hledani = [';
        $tmpXml .= "\n";

        $tmpBase = new Base();
        $mySetup = $tmpBase->getSetup();

        for ($i=0;$i<count($this->myKatalog);$i++){

            if ($i<(count($this->myKatalog)-1)):
                if ($mySetup["lang"]==$varLang):
                    $tmpXml .= '"'.htmlspecialchars ($this->myKatalog[$i]["nazev"]).'",';
                else:
                    $tmpXml .= '"'.htmlspecialchars ($tmpBase->getLang($varLang, $this->myKatalog[$i]["id"], "katalog", "nazev")).'",';
                endif;
            else:
                if ($mySetup["lang"]==$varLang):
                    $tmpXml .= '"'.htmlspecialchars ($this->myKatalog[$i]["nazev"]).'"';
                else:
                    $tmpXml .= '"'.htmlspecialchars ($tmpBase->getLang($varLang, $this->myKatalog[$i]["id"], "katalog", "nazev")).'"';
                endif;

            endif;
        } 
        
//        $tmpXml .= substr($tmpXml,0,-1);
        $tmpXml .= '];';

        $filename ="../naseptavac/localdata-".$varLang.".js";
        $fd = fopen( $filename, "w" );
        $write = fputs($fd, $tmpXml);
        fclose( $fd );
        
        unset($tmpBase);
        
        echo '<script>';
        echo 'progress(100);';
        echo '</script>';
        
    }
    
}

class VariableLanguage
{
    var $mySQL;
    var $myInit;
    var $myLang;

    function __construct($varLang){
        $this->myInit = new init();
        $this->mySQL = new sql($this->myInit);
        $this->myLang = $varLang;
    }

  function getVal($reqPromenna)
  {
        $statement = 'select '.$this->myLang.' from variable_language_admin where promenna = "'.$reqPromenna.'"';
//        echo $statement;
        $myResult = $this->mySQL->select($statement);
//        print_r($myResult);
        
        if ($this->mySQL->getRows()==0):
            $rtn = $reqPromenna.'-N/A';
        else:    
            for ($i=0;$i<count($myResult);$i++)
            {
                $rtn = $myResult[$i][$this->myLang];
                break;
            }
        endif;
        return $rtn;
  }
}

class MailDefinice extends Base
{
    var $myLang;

    function __construct($varLang){
        parent::__construct($varLang);
        $this->myLang = $varLang;
    }
    function getVarLang()
    {
        return $this->myLang;
    }
                
    function getMail($reqMail,$reqObjekt)
    {
        $rtn=-1;
        if (!is_object($reqObjekt)):
            $rtn=-3;
        else:
            $statement = 'select id,text from cc_mail_definice where kod = "'.$reqMail.'"';
            $myResult = $this->mySQL->select($statement);
            
            
            if ($this->mySQL->getRows()==0):
                $rtn = -1;
            else:    
                for ($i=0;$i<count($myResult);$i++)
                {
                    if ($this->getVarLang() == $this->mySetup["lang"]):
                        $tempMail = $myResult[$i]["text"];
                    else:
                        $tempMail = $this->getLang($this->getVarLang(),$myResult[$i]["id"],'cc_mail_definice','text');
                    endif;        

                    $tgMail = "";

                    $startPoz=0;
                    $pozice = strpos($tempMail,"[",$startPoz);

                    do
                    {
                        $delka = $pozice-$startPoz;
                        $tgCast = substr($tempMail,$startPoz,$delka);

                        if (substr($tgCast,0,1)=='[')://promenna
                           $poziceCast = strpos($tgCast,"]",0);
                           $myVar = substr($tgCast,1,($poziceCast-1));
                           $tgMail .= $reqObjekt->f_getVal($myVar).substr($tgCast,$poziceCast+1);
                        else:
                            $tgMail .= $tgCast;
                        endif;

                        $startPoz = $pozice;
                        $pozice = strpos($tempMail,"[",$pozice+1);
                        
                        if ($pozice===false): //Jiz neni dalsi vyskyt doplnime zbytek retezce
                        
                            $tgCast = substr($tempMail,$startPoz);
                            if (substr($tgCast,0,1)=='[')://promenna
                               $poziceCast = strpos($tgCast,"]",0);
                               $myVar = substr($tgCast,1,($poziceCast-1));
                               $tgMail .= $reqObjekt->f_getVal($myVar).substr($tgCast,$poziceCast+1);
                            else:
                                $tgMail .= $tgCast;
                            endif;
                        endif;
                    } 
                    while ($pozice !== false);
                    
                }
                $rtn = $tgMail;
            endif;
            
        endif;                                                          
        return $rtn;
    }    
}

class Provize extends Base
{
    var $myLang;

    function __construct($varLang){
        parent::__construct($varLang);
        $this->myLang = $varLang;
    }
    function getVarLang()
    {
        return $this->myLang;
    }
     
    function isParticipate($reqUserId)            
    {
            $statement = 'select id from multilevel_marketing where id_user = "'.$reqUserId.'"';
// echo  $statement;
            $myResult = $this->mySQL->select($statement);
            if ($this->mySQL->getRows() > 0):
                return true;
            else:
                return false;
            endif;
    }
    function addProvize($reqUserId,$reqParentId,$reqPrimyProdej,$reqProvize)
    {                
            $statement = 'insert into multilevel_marketing(id_user,id_parent,primy_prodej,provize) values(';
            $statement .= decode($reqUserId!='','"'.$reqUserId.'"','NULL').',';
            $statement .= decode($reqParentId!='','"'.$reqParentId.'"','NULL').',';
            $statement .= decode($reqPrimyProdej!='','"'.$reqPrimyProdej.'"','"0"').',';
            $statement .= decode($reqProvize!='','"'.$reqProvize.'"','"0"').')';

            $myResult = $this->mySQL->insert($statement);
            $myId =  $this->mySQL->getID();
                
            $tmpMod = $this->getModul("Multilevel marketing");
            if ($tmpMod!=-1):
                if ($this->getPermission($reqUserId,$tmpMod)==-1):
                    $this->addPermission($reqUserId,$tmpMod);
                endif;    
            endif;                    
            $tmpMod = $this->getModul("Sestava provize");
            if ($tmpMod!=-1):
                if ($this->getPermission($reqUserId,$tmpMod)==-1):
                    $this->addPermission($reqUserId,$tmpMod);
                endif;    
            endif;                    
    }    
    function getPermission($reqUserId,$reqModul)
    {
        $statement = 'select id from permission where modul = "'.$reqModul.'" and uzivatel = "'.$reqUserId.'"';
//echo $statement;
        $myResult = $this->mySQL->select($statement);
        if ($this->mySQL->getRows() == 0):
            return -1;
        else:
            return $myResult[0]["id"];
        endif;
    }
    function addPermission($reqUserId,$reqModul)
    {
        $statement = 'insert into permission(modul,uzivatel) values(';
        $statement .= decode($reqModul!='','"'.$reqModul.'"','NULL').',';
        $statement .= decode($reqUserId!='','"'.$reqUserId.'"','NULL').')';

 //       echo $statement;

        $myResult = $this->mySQL->insert($statement);
    }
    function getModul($reqNazev)
    {
            $statement = 'select id from menu where text = "'.$reqNazev.'"';
//            echo $statement;                
            
            $myResult = $this->mySQL->select($statement);
            if ($this->mySQL->getRows() == 0):
                return -1;
            else:
                return $myResult[0]["id"];
            endif;
    }
    function getAllPodrizeni($reqUserId)
    {
        echo 'getAllPodrizeni '. $reqUserId;
        $userList = $reqUserId;
        $myResult = $this->getPodrizeni($userList,"A");            
        do {
            $myResult = $this->getPodrizeni($userList,"N");            
        } while ($myResult > 0);
        
        return $userList;
    }
    
    function getPodrizeni(&$reqUserList,$removeInput="N")
    {
        $rtn = 0;
        $_arr = array();
                 
        $statement = 'select id_user from multilevel_marketing where id_parent in('.$reqUserList.') and id_user not in ('.$reqUserList.')';

//   echo  $statement;

        $myResult = $this->mySQL->select($statement);
        if ($this->mySQL->getRows() == 0):
            $rtn = -1;
            if ($removeInput=="A"):    
                $reqUserList = "";
            endif;    
        else:
            $rtn = count($myResult);
            for ($i=0;$i<$rtn;$i++)
            {
                $_arr[$i] = $myResult[$i]["id_user"];               
            }
            $pom = implode(",",$_arr);
            if ($pom!=""):
                if ($removeInput=="A"):    
                    $reqUserList = $pom;
                else:    
                    $reqUserList .= ',' . $pom;
                endif;    
            endif;    
        endif;

        return $rtn;
    }

}
class Kategorie
{
    var $mySQL;
    var $myInit;
    function __construct(){
        $this->myInit = new init();
        $this->mySQL = new sql($this->myInit);
    }
    
    /**
    * Vrátí celý uzel v poli od root po konečnou
    * 
    * @param Int $reqId
    */
    function getNode($reqId)
    {
        $arrRtn = array();
        
        while ($reqId>0)
        {
            array_unshift($reqId);
            $this->getParent($reqId);
        }
        return $arrRtn;
    }

    /**
    * Vrátí nadřízené id kategorie
    * 
    * @param Int $reqId
    */
    function getParent(&$reqId)
    {
        $statement = 'select ifnull(id_parent,-1) from kategorie where id = '.$reqId;
        $tmpKat = $this->mySQL->select($statement);
        if ($this->mySQL->getRows()==0):
            $reqId = -1;
        else:
            $reqId = $tmpKat[0]["id_parent"];
        endif;
    }
    
}

class HlidaciPes
{
    var $mySQL;
    var $myResult;
    var $myInit;
    var $myHlavicka;

    function __construct(){
        $this->myInit = new init();
        $this->mySQL = new sql($this->myInit);
        $this->myHlavicka=array();
    }
    function add($email,$id_uzivatel,$id_katalog='',$id_kategorie)
    {
        $index = count($this->myHlavicka);    
        $this->myHlavicka[$index] = new mPar();
        $this->myHlavicka[$index]->f_setVal("email",$email);
        $this->myHlavicka[$index]->f_setVal("id_uzivatel",$id_uzivatel);
        $this->myHlavicka[$index]->f_setVal("id_katalog",$id_katalog);
        $this->myHlavicka[$index]->f_setVal("id_kategorie",$id_kategorie);
    }
    function save()
    {
        for ($i=0;$i<count($this->myHlavicka);$i++)
        {
            $statement = "insert into hlidaci_pes(email,id_uzivatel,id_katalog,id_kategorie,zadano) values(";
            $statement.= decode($this->myHlavicka[$i]->f_getVal("email")=="",'NULL','"'.$this->myHlavicka[$i]->f_getVal("email").'"').',';
            $statement.= decode($this->myHlavicka[$i]->f_getVal("id_uzivatel")=="",'NULL','"'.$this->myHlavicka[$i]->f_getVal("id_uzivatel").'"').',';
            $statement.= decode($this->myHlavicka[$i]->f_getVal("id_katalog")=="",'NULL','"'.$this->myHlavicka[$i]->f_getVal("id_katalog").'"').',';
            $statement.= decode($this->myHlavicka[$i]->f_getVal("id_kategorie")=="",'NULL','"'.$this->myHlavicka[$i]->f_getVal("id_kategorie").'"').',';
            $statement.= '"'.date('Y-m-d h:i:s').'")';

            $this->mySQL->insert($statement);
        }
    }
    function setZmenaKategorie($reqKategorie)
    {
        $statement = 'update hlidaci_pes set zmena = "'.date('Y-m-d H:i:s').'" where id_kategorie = '.$reqKategorie;
//        echo $statement;
        $this->mySQL->update($statement);    
    }
    function setZmenaKatalog($reqKatalog)
    {
        $statement = 'update hlidaci_pes set zmena = "'.date('Y-m-d H:i:s').'" where id_katalog = '.$reqKatalog;
//        echo $statement;
        $this->mySQL->update($statement);    
    }
    function getRespondent()
    {
        $statement = 'select ifnull(u.email,h.email) as email,h.id_kategorie,h.id_katalog,z.evidencni_cislo,k.nazev as kategorie from hlidaci_pes h join users u on u.id = h.id_uzivatel left join katalog z on z.id = h.id_katalog left join kategorie k on k.id = h.id_kategorie where date(h.zmena) = "'.date('Y-m-d').'"';
        $tmpResult = $this->mySQL->update($statement,$reqCpNames);
        
        return $tmpResult;        
    }
}

?>