ventas_php/classes/metodoPago.class.php

<?php

class MetodoPago extends Main
{
	private $metodoPagoId;
	private $nombre;
	
	public function setMetodoPagoId($value)
	{
		$this->Util()->ValidateInteger($value);
		$this->metodoPagoId = $value;
	}
		
	public function setNombre($value)
	{
		$this->Util()->ValidateString($value, $max_chars=50, $minChars = 1, "Nombre");
		$this->nombre = $value;
	}
	
	public function Info()
	{
		
		$sql = 'SELECT 
					* 
				FROM 
					metodoPago 
				WHERE 
					metodoPagoId = "'.$this->metodoPagoId.'"';
	
		$this->Util()->DBSelect($_SESSION["empresaId"])->setQuery($sql);
		$info = $this->Util()->DBSelect($_SESSION["empresaId"])->GetRow();
		
		$row = $this->Util()->EncodeRow($info);
				
		return $row;
	}
	
	public function EnumerateAll()
	{		
		$sql = 'SELECT 
					* 
				FROM 
					metodoPago
				WHERE
					baja = "0"
				ORDER BY
					nombre ASC';	
		$this->Util()->DBSelect($_SESSION["empresaId"])->setQuery($sql);
		$result = $this->Util()->DBSelect($_SESSION["empresaId"])->GetResult();
						
		return $result;
	}
	
	public function EnumSingle()
	{		
		$sql = 'SELECT 
					* 
				FROM 
					metodoPago
				WHERE	
					metodoPagoId = "'.$this->metodoPagoId.'"';	
		$this->Util()->DBSelect($_SESSION["empresaId"])->setQuery($sql);
		$result = $this->Util()->DBSelect($_SESSION["empresaId"])->GetResult();
						
		return $result;
	}
	
	public $page = 0;

	public function SetPage($page)
	{
		$this->page = $page;
	}

	function Enumerate()
	{
		$db = $this->Util()->DBSelect($_SESSION["empresaId"]);
		
		$sql = "SELECT COUNT(*) FROM metodoPago WHERE baja = '0'";
		$db->setQuery($sql);
		$total = $db->GetSingle();

		$pages = $this->Util()->HandleMultipages($this->page, $total ,WEB_ROOT."/metodos-pago", "p");

		$sqlAdd = "LIMIT ".$pages["start"].", ".$pages["items_per_page"];
		
		$sql = "SELECT * FROM metodoPago WHERE baja = '0' ORDER BY nombre ASC ".$sqlAdd;
		$db->setQuery($sql);
		$result = $db->GetResult();

		$data["items"] = $result;
		$data["pages"] = $pages;

		return $data;
	}

	function Save()
	{
		if($this->Util()->PrintErrors()){ return false; }
		$this->Util()->DBSelect($_SESSION["empresaId"])->setQuery("
			INSERT INTO `metodoPago` ( 
				`nombre`				
				) 
			VALUES (
				'".utf8_decode($this->nombre)."'
				)"
			);
		
		$metodoPagoId = $this->Util()->DBSelect($_SESSION["empresaId"])->InsertData();
		
		$this->Util()->setError(30001, "complete");
		$this->Util()->PrintErrors();
		
		return true;
	}
		
	function Update()
	{
		if($this->Util()->PrintErrors()){ return false; }
		
		$sql = "
			UPDATE `metodoPago` SET 				
				`nombre` = '".utf8_decode($this->nombre)."'				
			WHERE metodoPagoId = '".$this->metodoPagoId."'
			";
		
		$this->Util()->DBSelect($_SESSION["empresaId"])->setQuery($sql);
		$this->Util()->DBSelect($_SESSION["empresaId"])->UpdateData();

		$this->Util()->setError(30002, "complete");
		$this->Util()->PrintErrors();
		
		return true;
	}
	
	function Delete()
	{
		$this->Util()->DBSelect($_SESSION["empresaId"])->setQuery("
			DELETE FROM metodoPago 
			WHERE metodoPagoId = '".$this->metodoPagoId."'"
		);
		$this->Util()->DBSelect($_SESSION["empresaId"])->DeleteData();
		$this->Util()->setError(30003, "complete");
		$this->Util()->PrintErrors();
		
		return true;
	}
	
	function Baja(){

		$this->Util()->DBSelect($_SESSION['empresaId'])->setQuery("
			UPDATE metodoPago SET 
				baja = '1'		
			WHERE 
				metodoPagoId = '".$this->metodoPagoId."'"
			);
		$this->Util()->DBSelect($_SESSION['empresaId'])->UpdateData();
		
		$this->Util()->setError(30003, "complete");
		$this->Util()->PrintErrors();
		
		return true;	

	}//Baja
	
	function GetNameById()
	{		
		$sql = 'SELECT nombre FROM metodoPago
				WHERE metodoPagoId = "'.$this->metodoPagoId.'"';
		
		$this->Util()->DBSelect($_SESSION["empresaId"])->setQuery($sql);
		$nombre = $this->Util()->DBSelect($_SESSION["empresaId"])->GetSingle();

		return $nombre;
	}
	
}


?>