<?
global $DAplikacija;

class DRabat extends DSifarnik 
{

	function DRabat(&$Db)
	{
		$this->DSifarnik($Db);
		$this->Stranicenje=1;
	}

	function DodeliSqlForme()
	{
		$idKlijent=$_SESSION["DKorisnik"]->VratiIdVezaLicniPodaci();
		$izabrani=$this->Izabrani["Get"]["idk"];

		$this->SqlString="
		select
			idRabat,
			kolicina,
			popust
		from Rabat
		where idRabat = $izabrani
		and idKlijent=$idKlijent";
	}

	/** VratiDodatnePodatke
	*
	* dodeljuje nizove atributu podaci  i prepisuje se u konkretnim klasama
	* @return array	
	*/
	function VratiDodatnePodatke()
	{

	}

	/** VratiDodatnePodatkeIzabrani
	*
	* radi dodatne upite da bi dobio sve neophodne podatke za prikaz forme
	* @return array 	
	*/
	function VratiDodatnePodatkeIzabrani()
	{
		
	}
	
	

	
	function DodeliFilter()
	{
		$idKlijent=$_SESSION["DKorisnik"]->VratiIdVezaLicniPodaci();
		$filter='';
	
		if (!isset($this->Parametri["Post"]["KolicinaFilter"]))
		{
			$this->Parametri["Post"]["KolicinaFilter"]='';
		}
		else 
		{
			$kolicina=$this->Parametri["Post"]["KolicinaFilter"];
			$filter.=" and kolicina like'$kolicina%'";
		}
		if (!isset($this->Parametri["Get"]["KolicinaFilter"]))
		{
			$this->Parametri["Get"]["KolicinaFilter"]='';
		}
		else 
		{
			$kolicina=$this->Parametri["Get"]["KolicinaFilter"];
			$filter.=" and kolicina like'$kolicina%'";
		}
		
		if (!isset($this->Parametri["Post"]["PopustFilter"]))
		{
			$this->Parametri["Post"]["PopustFilter"]='';
		}
		else 
		{
			$popust=$this->Parametri["Post"]["PopustFilter"];
			$filter.=" and popust like'$popust%'";
		}
		if (!isset($this->Parametri["Get"]["PopustFilter"]))
		{
			$this->Parametri["Get"]["PopustFilter"]='';
		}
		else 
		{
			$popust=$this->Parametri["Get"]["PopustFilter"];
			$filter.=" and popust like'$popust%'";
		}
		
		$filter.=" and idKlijent=$idKlijent order by kolicina";
		
		$l=new logPhp();
		$l->UpisiLog("$filter");
		$this->Filter=$filter;

	}

	function Snimi()
	{		
	}

	

	function Dodaj()
	{
	}


	function brisi()
	{
	}

	
	function DodeliSqlString()
	{
		$this->SqlString="
			select
				idRabat,
				kolicina,
				popust
		from Rabat";
	}
	
	function LookUp()
	{
		$idKlijent=$_SESSION["DKorisnik"]->vratiIdVezaLicniPodaci();
		
		$filter= " where 1=1 and kolicina like '".$this->Parametri["Get"]["qid"]."%' and idKlijent=$idKlijent order by kolicina";
				
		$SqlString=("select 
						idRabat,
						kolicina,
						popust
						from Rabat 
						$filter");
		
		if (isset($this->Parametri["Get"]["OdabranaStranica"]))
		{
			$this->OdabranaStranica=$this->Parametri["Get"]["OdabranaStranica"];
		}
		else 
		{
			$this->OdabranaStranica=1;
		}
		$sqlcount="select count(*) ".stristr($SqlString, 'from');
		//$this->Podaci["Podaci"]=$this->IzvrsiSql($this->SqlString);
		
		$Podaci["BrojPodataka"]=$this->IzvrsiSql("$sqlcount");
		if ($this->Stranicenje!=0)
		{
			$ofset=$this->BrojElemenataListe*($this->OdabranaStranica-1);
			$SqlString.=" LIMIT $ofset,$this->BrojElemenataListe ";
			$Podaci["Podaci"]=$this->IzvrsiSql("$SqlString");
		}
		else 
		{
			$Podaci["Detalji"]=$this->IzvrsiSql("$SqlString");
		}
		
		return $Podaci;	
	}

}

?>