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; }