public function FiltrarEst($Cond)
{
$oNivel=new ConfNivelDao();
$oNivel->tipo="PR";
$oNivel->nivel="5";
$tama1 = $oNivel->LeerNumCar();
$pos1=(25-$tama1)+1;
global $db;
$Rs = $db->Execute("select codestpro1,codestpro2,codestpro3,codestpro4,substr(codestpro5,{$pos1},{$tama1}) as codestpro5,denestpro5 from {$this->_table} where {$Cond} and {$this->_table}.codemp='{$this->codemp}'");
return $Rs;
}
public function FiltrarEst()
{
$oNivel=new ConfNivelDao();
$oNivel->tipo="PR";
$oNivel->nivel="1";
$tama = $oNivel->LeerNumCar();
$pos=(25-$tama)+1;
global $db;
$Rs = $db->Execute("select estcla,fecha_ini,fecha_fin,costototal,responsable,substr(codestpro1,{$pos},{$tama}) as codestpro1,denestpro1 from {$this->_table} where {$this->_table}.codemp='{$this->codemp}'");
return $Rs;
}
public function FiltrarEst()
{
$oNivel=new ConfNivelDao();
$oNivel->tipo="PL";
$oNivel->nivel="1";
$tama = $oNivel->LeerNumCar();
$pos=(25-$tama)+1;
global $db;
$Rs = $db->Execute("select substr(codest1,{$pos},{$tama}) as codest1,denest1 from {$this->_table} where {$this->_table}.codemp='{$this->codemp}'");
return $Rs;
}
public function FiltrarEst($Cond)
{
$oNivel=new ConfNivelDao();
$oNivel->tipo="PL";
$oNivel->nivel="2";
$tama1 = $oNivel->LeerNumCar();
$pos1=(25-$tama1)+1;
global $db;
//$db->debug=true;
$Rs = $db->Execute("select codest1,substr(codest2,{$pos1},{$tama1}) as codest2,denest2 from {$this->_table} where {$Cond} and {$this->_table}.codemp='{$this->codemp}'");
return $Rs;
}
public function FiltrarEst($Cond)
{
$oNivel=new ConfNivelDao();
$oNivel->tipo="PR";
$oNivel->nivel="3";
$tama1 = $oNivel->LeerNumCar();
$pos1=(25-$tama1)+1;
$oNivel->nivel="2";
$tama2 = $oNivel->LeerNumCar();
$pos2=(25-$tama2)+1;
$oNivel->nivel="1";
$tama3 = $oNivel->LeerNumCar();
$pos3=(25-$tama3)+1;
global $db;
$Rs = $db->Execute("select substr(codestpro1,{$pos3},{$tama3}) as codestpro1,substr(codestpro2,{$pos2},{$tama2}) as codestpro2,substr(codestpro3,{$pos1},{$tama1}) as codestpro3,denestpro3 from {$this->_table} where {$Cond} and {$this->_table}.codemp='{$this->codemp}'");
return $Rs;
}
public function ObtenerObjetoActual()
{
$oNiveles = new ConfNivelDao();
$nivel = $oNiveles->ObtenerNivelUb();
switch($nivel)
{
case '1':
$oUbicacion = new intUb1Dao();
break;
case '2':
$oUbicacion = new intUb2Dao();
break;
case '3':
$oUbicacion = new intUb3Dao();
break;
case '4':
$oUbicacion = new intUb4Dao();
break;
case '5':
$oUbicacion = new intUb5Dao();
break;
}
$ar['rs']=$oUbicacion;
$ar['nivel']=$nivel;
return $ar;
}
