Urbano

<?
 
 
/**
* 
*/
class Urbano_BarraCode
{
	public $shipper,$ciclo,$producto,$cliente,$zon_codigo,$zon_nombre,$ciudad,$shipper_codigo,$nextel_informix;
 
	function __construct($barra_code,&$nextel_informix){
		//Obtén Shipper
		$this->nextel_informix=$nextel_informix;
		$ban=0;
		$pos=1;
		$suma=1;
		$arreglo_shippers=array("0","5","9","1","8","7","6");
		$this->shipper=substr($barra_code,0,$pos);
		for($i=0;$i<count($arreglo_shippers);$i++){
			if($this->shipper==$arreglo_shippers[$i]){
				$ban=1;
				$pos++;
				$suma=2;
			}
		}
		if($ban==1){
			$this->shipper=substr($barra_code,0,2);
		}
		$this->producto=substr($barra_code,$pos,$pos);
		$this->ciclo=substr($barra_code,$pos+$suma,4);
		$this->cliente=str_replace($this->shipper.$this->producto.$this->ciclo,"",$barra_code);
		//Obtén Shipper
	}
	function get_zona(){
 
 
		$query='select * from urbano20@ol_urbanoprv:shipper WHERE shi_id="'.$this->shipper.'";';
		$sqlquery = $this->nextel_informix->SelectLimit($query) or die($this->nextel_informix->ErrorMsg());
		 while (!$sqlquery->EOF){
			$shipper_codigo=$sqlquery->Fields("shi_codigo");
			$sqlquery->MoveNext();
		 }
		$this->shipper_codigo=$shipper_codigo;
 
		$query='select * from urbano20@ol_urbanoprv:zonifica WHERE shi_codigo="'.$shipper_codigo.'" and pro_codigo="'.$this->producto.'" and cli_codigo="'.$this->cliente.'" order by aud_fecha_proc DESC;';
		$sqlquery = $this->nextel_informix->SelectLimit($query) or die($this->nextel_informix->ErrorMsg());
 
		$this->zon_codigo=$sqlquery->Fields("zon_codigo");
		$ciudad=$sqlquery->Fields("cli_ciudad");
 
		$query='select * from urbano20@ol_urbanoprv:zona WHERE zon_codigo="'.$this->zon_codigo.'" ;';
		$sqlquery = $this->nextel_informix->SelectLimit($query) or die($this->nextel_informix->ErrorMsg());
 
		$this->zon_nombre=$sqlquery->Fields("zon_nombre");
 
 
		$query='select * from urbano20@ol_urbanoprv:provincia WHERE prov_nombre="'.$ciudad.'" ;';
		$sqlquery = $this->nextel_informix->SelectLimit($query) or die($this->nextel_informix->ErrorMsg());
		$this->ciudad=$sqlquery->Fields("prov_codigo");	
	}
 
	function set_zona(){
 
 
		$fecha=getdate();
		$fecha_set=$fecha["mday"]."/".$fecha["mon"]."/".$fecha["year"];
		$hora=$fecha["hours"].":".$fecha["minutes"].":".$fecha["seconds"];
		$query='INSERT INTO urbano20@ol_urbanoprv:lector_npi VALUES("'.$this->shipper_codigo.'",
		"'.$this->producto.'","'.$this->cliente.'","'.$this->ciudad.'","'.$this->zon_codigo.'","webservice_prueba",
		"'.$fecha_set.'","'.$hora.'","'.$this->shipper.'")';
		$sqlquery = $this->nextel_informix->SelectLimit($query) or die($this->nextel_informix->ErrorMsg());
 
	}
 
}
 
 
 
?>