Example #1
0
 public function devuelveinventario($centro, $almacen, $codigo)
 {
     $criteria = new CDbCriteria();
     $criteria->addcondition("codcen=:vcodcen", 'AND');
     $criteria->addcondition("codalm=:vcodalm", 'AND');
     $criteria->addcondition("codart=:vcodart");
     $criteria->params = array(":vcodcen" => trim($centro), ":vcodalm" => trim($almacen), ":vcodart" => trim($codigo));
     $registro = Alinventario::model()->find($criteria);
     return !is_null($registro) ? $registro : 0;
 }
Example #2
0
 /**
  * Retrieves a list of models based on the current search/filter conditions.
  *
  * Typical usecase:
  * - Initialize the model fields with values from filter form.
  * - Execute this method to get CActiveDataProvider instance which will filter
  * models according to data in model fields.
  * - Pass data provider to CGridView, CListView or any similar widget.
  *
  * @return CActiveDataProvider the data provider that can return the models
  * based on the search/filter conditions.
  */
 public function search($idobjeto, $iduser)
 {
     $idobjeto = (int) $idobjeto;
     $iduser = (int) $iduser;
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id, true);
     $criteria->compare('hidobjeto', $this->hidobjeto);
     $criteria->compare('valor1', $this->valor1, true);
     $criteria->compare('valor2', $this->valor2, true);
     $criteria->compare('signo', $this->signo);
     $criteria->addcondition('iduser='******'hidobjeto=' . $idobjeto);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #3
0
 public function search_docu($documento, $identidad)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id);
     $criteria->compare('usuario', $this->usuario, true);
     $criteria->compare('cuando', $this->cuando, true);
     $criteria->compare('codocu', $this->codocu, true);
     $criteria->compare('enviadoel', $this->enviadoel, true);
     $criteria->compare('nombrefichero', $this->nombrefichero, true);
     $criteria->addcondition("codocu='" . $documento . "'");
     $criteria->addcondition(" hidocu=" . $identidad . "");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #4
0
 /**
  * Retrieves a list of models based on the current search/filter conditions.
  *
  * Typical usecase:
  * - Initialize the model fields with values from filter form.
  * - Execute this method to get CActiveDataProvider instance which will filter
  * models according to data in model fields.
  * - Pass data provider to CGridView, CListView or any similar widget.
  *
  * @return CActiveDataProvider the data provider that can return the models
  * based on the search/filter conditions.
  */
 public function search()
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $criteria = new CDbCriteria();
     //$criteria->compare('codart',$this->codart,true);
     $criteria->compare('desum', $this->desum, true);
     $criteria->compare('punit', $this->punit);
     $criteria->compare('descripcion', $this->descripcion, true);
     $criteria->compare('ptlibre', $this->ptlibre);
     $criteria->compare('ranking', $this->ranking);
     $criteria->compare('clase', $this->clase, true);
     $criteria->compare('acumulado', $this->acumulado);
     $criteria->compare('porcentaje', $this->porcentaje);
     $criteria->compare('hinventario', $this->hinventario, true);
     $criteria->compare('idsesion', $this->idsesion);
     $criteria->compare('column_7', $this->column_7);
     $criteria->compare('porcentajeac', $this->porcentajeac);
     $criteria->addcondition('idsesion=' . Yii::app()->user->getId() . '');
     if (isset($_SESSION['sesion_Maestrocompo'])) {
         $criteria->addInCondition('codart', $_SESSION['sesion_Maestrocompo'], 'AND');
     } else {
         $criteria->compare('codart', $this->codart, true);
     }
     $criteria->order = "ranking";
     return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 1000)));
 }
Example #5
0
 public function search_por_almacen($codal, $codcen)
 {
     $criteria = new CDbCriteria();
     $criteria->compare('destipo', $this->destipo, true);
     $criteria->compare('codtipo', $this->codtipo, true);
     $criteria->compare('codcen', $this->codcen, true);
     $criteria->compare('codalm', $this->codalm, true);
     $criteria->compare('codsoc', $this->codsoc, true);
     $criteria->compare('nomal', $this->nomal, true);
     $criteria->compare('stocklibre', $this->stocklibre);
     $criteria->compare('stockreservado', $this->stockreservado);
     $criteria->compare('stocktransito', $this->stocktransito);
     $criteria->addcondition("codcen='" . $codcen . "'");
     $criteria->addcondition("codalm='" . $codal . "'");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #6
0
 public function search_por_carga($id)
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $criteria = new CDbCriteria();
     $criteria->addcondition("hidcarga=:vid");
     $criteria->params = array(":vid" => $id);
     return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 60)));
 }
Example #7
0
 public function search_window()
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('codserv', $this->codserv, true);
     $criteria->addcondition(" descripcion like '%" . $this->descripcion . "%' ");
     return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 100)));
 }
Example #8
0
 public function search_por_id($id)
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('iddocu', $this->iddocu, true);
     $criteria->compare('codocu', $this->codocu);
     $criteria->compare('codimpuesto', $this->codimpuesto, true);
     $criteria->addcondition("iddocu=" . (int) $id);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #9
0
 public function search_por_lista($hid)
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $hid = (int) $hid;
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id, true);
     $criteria->compare('hidlista', $this->hidlista, true);
     $criteria->compare('codigo', $this->codigo, true);
     $criteria->addcondition(" hidlista=" . $hid);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
 public function search_por_temporada($idtemporada)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('nomespecie', $this->nomespecie, true);
     $criteria->compare('idespecie', $this->idespecie);
     $criteria->compare('idtemporada', $this->idtemporada);
     $criteria->compare('sum', $this->sum, true);
     $criteria->addcondition("idtemporada=" . $idtemporada);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #11
0
 public function search_por_contacto($id)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id);
     $criteria->compare('mail', $this->mail, true);
     $criteria->compare('activo', $this->activo);
     $criteria->compare('codocu', $this->codocu, true);
     $criteria->addcondition('hidcontacto=' . $id);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #12
0
 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search_por_peticion($id)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('punit', $this->punit);
     $criteria->compare('plista', $this->plista);
     $criteria->compare('igv_monto', $this->igv_monto);
     $criteria->compare('pventa', $this->pventa);
     $criteria->compare('descuento', $this->descuento);
     $criteria->addcondition('hidpeticion=' . $id);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #13
0
 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search($id)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('nigv', $this->nigv);
     $criteria->compare('descuento', $this->descuento);
     $criteria->compare('subtotaldes', $this->descuento);
     $criteria->compare('subtotal', $this->subtotal);
     $criteria->compare('destotal', $this->destotal);
     $criteria->compare('impuesto', $this->impuesto);
     $criteria->addcondition('hidguia=' . $id);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #14
0
 public function search_ide($id)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id);
     $criteria->compare('iddetcompra', $this->iddetcompra, true);
     $criteria->compare('cant', $this->cant);
     $criteria->compare('fecha', $this->fecha, true);
     $criteria->compare('idkardex', $this->idkardex, true);
     $criteria->compare('usuario', $this->usuario, true);
     $criteria->addcondition("iddetcompra=" . $id . "");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #15
0
 public function search_por_docu($docu)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id);
     $criteria->compare('codocu', $this->codocu, true);
     $criteria->compare('campo', $this->campo, true);
     $criteria->compare('nombrecampo', $this->nombrecampo, true);
     $criteria->compare('tipodato', $this->tipodato, true);
     $criteria->compare('longitud', $this->longitud);
     $criteria->compare('nombredelmodelo', $this->nombredelmodelo, true);
     $criteria->compare('primercampolista', $this->primercampolista, true);
     $criteria->compare('segundocampolista', $this->segundocampolista, true);
     $criteria->compare('seleccionable', $this->seleccionable, true);
     $criteria->addcondition("codocu='" . $docu . "'");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #16
0
 /**
  * Retrieves a list of models based on the current search/filter conditions.
  * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
  */
 public function search_por_docu($docu)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     //$criteria->compare('coddocu',$this->coddocu,true);
     $criteria->compare('mensaje', $this->mensaje, true);
     $criteria->compare('posicion', $this->posicion, true);
     $criteria->compare('creadoel', $this->creadoel, true);
     $criteria->compare('modificadopor', $this->modificadopor, true);
     $criteria->compare('modificadoel', $this->modificadoel, true);
     $criteria->compare('creadopor', $this->creadopor, true);
     $criteria->compare('activo', $this->activo, true);
     $criteria->compare('logo', $this->logo, true);
     $criteria->compare('id', $this->id);
     $criteria->addcondition("coddocu='" . $docu . "'");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #17
0
 public function search_docu($documento)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id);
     $criteria->compare('codocu', $this->codocu, true);
     $criteria->compare('estadofinal', $this->estadofinal, true);
     $criteria->compare('estadoinicial', $this->estadoinicial, true);
     $criteria->compare('descripcion', $this->descripcion, true);
     $criteria->compare('creadopor', $this->creadopor, true);
     $criteria->compare('creadoel', $this->creadoel, true);
     $criteria->compare('einicial', $this->einicial, true);
     $criteria->compare('desdocu', $this->desdocu, true);
     $criteria->compare('efinal', $this->efinal, true);
     $criteria->addcondition(" codocu='" . $documento . "' ");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #18
0
 public function search_aprobados()
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('numero', $this->numero, true);
     $criteria->compare('estado', $this->estado, true);
     $criteria->compare('fechaent', $this->fechaent, true);
     $criteria->compare('tipsolpe', $this->tipsolpe, true);
     $criteria->compare('centro', $this->centro, true);
     $criteria->compare('codal', $this->codal, true);
     $criteria->compare('codart', $this->codart, true);
     $criteria->compare('imputacion', $this->imputacion, true);
     $criteria->compare('cant', $this->cant);
     $criteria->compare('desum', $this->desum, true);
     $criteria->compare('txtmaterial', $this->txtmaterial, true);
     $criteria->compare('cantatendida', $this->cantatendida);
     $criteria->compare('cant_pendiente', $this->cant_pendiente);
     $criteria->addcondition("estado='" . ESTADO_OC_APROBADA . "'");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #19
0
 public function search_por_compra($idcabeza)
 {
     $idcabeza = (int) $idcabeza;
     $criteria = new CDbCriteria();
     if (!isset($idcabeza) or is_null($idcabeza)) {
         $idcabeza = 0;
     }
     $criteria->addcondition("hidguia=" . $idcabeza);
     //$criteria->addcondition("iduser=".Yii::app()->user->id);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #20
0
 /**
  *
  */
 public function getLearnLessonNum()
 {
     $criteria = new CDbCriteria();
     $criteria->join = 'left join {{lesson}} l on t.lessonId=l.id';
     $criteria->addcondition("l.courseId={$this->id}");
     $criteria->addcondition('t.userId=' . Yii::app()->user->id);
     $num = LessonLearn::model()->count($criteria);
     return $num ? (int) $num : 0;
 }
Example #21
0
?>
		<?php 
echo $form->error($model, 'horascambio');
?>
	</div>
	
	
	
	<div class="row">
		<?php 
echo $form->labelEx($model, 'tipoaceite');
?>
		<?php 
$criteria = new CDbCriteria();
//$criteria->addcondition("cod='".$codep."'");
$criteria->addcondition("flag='1'");
$datos = CHtml::listData(Maestrocompo::model()->findall($criteria), 'codigo', 'descripcion');
echo $form->DropDownList($model, 'tipoaceite', $datos, array('empty' => '--Seleccione lubricantes--'));
?>
		<?php 
echo $form->error($model, 'tipoaceite');
?>
	</div>	

	<div class="row buttons">
		<?php 
echo CHtml::submitButton($model->isNewRecord ? 'Crear' : 'Grabar');
?>
	</div>

<?php 
Example #22
0
 public function search_por_otros($id, $codigo)
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $criteria = new CDbCriteria();
     // $criteria->compare('codart',$this->codart,true);
     $criteria->compare('desum', $this->desum, true);
     $criteria->compare('um', $this->um, true);
     $criteria->compare('cant', $this->cant);
     $criteria->compare('numreserva', $this->numreserva);
     $criteria->compare('fechares', $this->fechares, true);
     $criteria->compare('estado', $this->estado, true);
     $criteria->compare('atendido', $this->atendido, true);
     $criteria->compare('usuario', $this->usuario, true);
     $criteria->addcondition("hidesolpe <> " . $id . "  ");
     $criteria->addcondition("codart='" . trim($codigo) . "' AND estadoreserva<>'30'");
     /*  if(!is_null($centro))
     				 $criteria->addcondition("centro='".trim($centro)."' ");
     			if(!is_null($almacen))
     				$criteria->addcondition("almacen='".trim($almacen)."'");
     			   */
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #23
0
 public function search_por_solpe_mas_puro($id)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     //$criteria->addcondition("est <>'99'");
     $criteria->addcondition("hidsolpe=" . $id);
     $criteria->addcondition(" vale='1' ");
     //$criteria->addcondition("est in ('03') and tipsolpe='M'");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #24
0
 public function search_codigo($codpro)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id);
     $criteria->compare('codart', $this->codart, true);
     $criteria->compare('codpro', $this->codpro, true);
     $criteria->compare('codmon', $this->codmon, true);
     $criteria->compare('precio', $this->precio);
     $criteria->addcondition("codpro='" . $codpro . "'");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #25
0
 public function search_por_trabajador($codigo)
 {
     $criteria = new CDbCriteria();
     $criteria->addcondition("codtra='" . $codigo . "'  ");
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #26
0
 public function search_por_reserva($hidreserva)
 {
     $criteria = new CDbCriteria();
     $criteria->addcondition("hidreserva=:vidsolpe");
     $criteria->params = array(":vidsolpe" => $hidreserva);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #27
0
 public function search_poractivo($canica)
 {
     // Warning: Please modify the following code to remove attributes that
     // should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('idactivo', $this->idactivo, true);
     $criteria->addcondition('idactivo=' . (int) $canica);
     $criteria->compare('tipo', $this->tipo, true);
     $criteria->compare('guiaremision', $this->guiaremision, true);
     $criteria->compare('numerofactura', $this->numerofactura, true);
     $criteria->compare('fecha', $this->fecha, true);
     $criteria->compare('idemplazamientoactual', $this->idemplazamientoactual, true);
     $criteria->compare('idemplazamientoanterior', $this->idemplazamientoanterior, true);
     $criteria->compare('codobraencurso', $this->codobraencurso, true);
     $criteria->compare('ccanterior', $this->ccanterior, true);
     $criteria->compare('ccactual', $this->ccactual, true);
     $criteria->compare('comentario', $this->comentario, true);
     $criteria->compare('numformato', $this->numformato, true);
     $criteria->compare('idformato', $this->idformato, true);
     $criteria->compare('codestado', $this->codestado, true);
     $criteria->compare('almacen', $this->almacen, true);
     $criteria->compare('valesalida', $this->valesalida, true);
     $criteria->compare('ocompra', $this->ocompra, true);
     $criteria->compare('creadopor', $this->creadopor, true);
     $criteria->compare('creadoel', $this->creadoel, true);
     $criteria->compare('modificadopor', $this->modificadopor, true);
     $criteria->compare('modificadoel', $this->modificadoel, true);
     $criteria->compare('coddocu', $this->coddocu, true);
     $criteria->compare('codepanterior', $this->codepanterior, true);
     $criteria->compare('codep', $this->codep, true);
     $criteria->compare('codlugaranterior', $this->codlugaranterior, true);
     $criteria->compare('codlugarnuevo', $this->codlugarnuevo, true);
     $criteria->compare('codcentro', $this->codcentro, true);
     $criteria->compare('solicitante', $this->solicitante, true);
     $criteria->compare('documento', $this->documento, true);
     $criteria->compare('numeroref', $this->numeroref, true);
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }
Example #28
0
 /**
  * Retrieves a list of models based on the current search/filter conditions.
  *
  * Typical usecase:
  * - Initialize the model fields with values from filter form.
  * - Execute this method to get CActiveDataProvider instance which will filter
  * models according to data in model fields.
  * - Pass data provider to CGridView, CListView or any similar widget.
  *
  * @return CActiveDataProvider the data provider that can return the models
  * based on the search/filter conditions.
  */
 public function search_por_doc($codigodoc)
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $criteria = new CDbCriteria();
     $criteria->compare('id', $this->id);
     //$criteria->compare('codocu',$this->codocu,true);
     $criteria->compare('left_', $this->left_);
     $criteria->compare('top', $this->top);
     $criteria->compare('font_size', $this->font_size);
     $criteria->compare('font_family', $this->font_family, true);
     $criteria->compare('font_weight', $this->font_weight, true);
     $criteria->compare('font_color', $this->font_color, true);
     $criteria->compare('nombre_campo', $this->nombre_campo, true);
     $criteria->compare('lbl_left', $this->lbl_left);
     $criteria->compare('lbl_top', $this->lbl_top);
     $criteria->compare('lbl_font_size', $this->lbl_font_size);
     $criteria->compare('lbl_font_weight', $this->lbl_font_weight, true);
     $criteria->compare('lbl_font_family', $this->lbl_font_family, true);
     $criteria->compare('lbl_font_color', $this->lbl_font_color, true);
     $criteria->addcondition("codocu='" . trim($codigodoc) . "'");
     return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 40)));
 }
Example #29
0
 public function search_otrasreservas($iduser, $codart, $codcen, $codal)
 {
     // @todo Please modify the following code to remove attributes that should not be searched.
     $iddesolpe = (int) MiFactoria::cleanInput($iduser);
     $codal = MiFactoria::cleanInput($codal);
     $codcen = MiFactoria::cleanInput($codcen);
     $codart = MiFactoria::cleanInput($codart);
     $criteria = new CDbCriteria();
     $criteria->addcondition("codal=:vcodal");
     $criteria->addcondition("centro=:vcentro");
     $criteria->addcondition("codart=:vcodart");
     //$criteria->addcondition("iddesolpe=".$iddesolpe);
     $criteria->addcondition("idusersolpe <> :viduser");
     $criteria->params = array(":viduser" => $iduser, ":vcodart" => $codart, ":vcentro" => $codcen, ":vcodal" => $codal);
     $criteria->addcondition('cantidad_pendiente > 0 or cantidad_pendiente IS NULL ');
     $criteria->addcondition(" estadoreserva not in ( '30','20','70') ");
     return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pagesize' => 100)));
 }
Example #30
0
 public function search()
 {
     $criteria = new CDbCriteria();
     $criteria->compare('ptopartida', $this->ptopartida, true);
     $criteria->compare('distpartida', $this->distpartida, true);
     $criteria->compare('provpartida', $this->provpartida, true);
     $criteria->compare('dptopartida', $this->dptopartida, true);
     $criteria->compare('ptollegada', $this->ptollegada, true);
     $criteria->compare('distllegada', $this->distllegada, true);
     $criteria->compare('provllegada', $this->provllegada, true);
     $criteria->compare('dptollegada', $this->dptollegada, true);
     $criteria->compare('direccionformaldes', $this->direccionformaldes, true);
     $criteria->compare('direcciontransportista', $this->direcciontransportista, true);
     $criteria->compare('c_numgui', $this->c_numgui, true);
     $criteria->compare('c_coclig', $this->c_coclig, true);
     $criteria->compare('d_fecgui', $this->d_fecgui, true);
     $criteria->compare('c_estgui', $this->c_estgui, true);
     $criteria->compare('c_rsguia', $this->c_rsguia, true);
     $criteria->compare('c_codtra', $this->c_codtra, true);
     $criteria->compare('c_trans', $this->c_trans, true);
     $criteria->compare('c_motivo', $this->c_motivo, true);
     $criteria->compare('c_placa', $this->c_placa, true);
     $criteria->compare('c_licon', $this->c_licon, true);
     $criteria->addcondition(" c_descri like '%" . $this->c_descri . "%' ");
     $criteria->compare('c_texto', $this->c_texto, true);
     $criteria->compare('c_dirsoc', $this->c_dirsoc, true);
     $criteria->compare('c_serie', $this->c_serie, true);
     $criteria->compare('razondestinatario', $this->razondestinatario, true);
     $criteria->compare('rucdestinatario', $this->rucdestinatario, true);
     $criteria->compare('ructrans', $this->ructrans, true);
     $criteria->compare('razontransportista', $this->razontransportista, true);
     $criteria->compare('c_estado', $this->c_estado, true);
     $criteria->compare('n_direc', $this->n_direc);
     $criteria->compare('n_direcformaldes', $this->n_direcformaldes);
     $criteria->compare('n_directran', $this->n_directran);
     $criteria->compare('n_dirsoc', $this->n_dirsoc);
     $criteria->compare('creadopor', $this->creadopor, true);
     $criteria->compare('modificadopor', $this->modificadopor, true);
     $criteria->compare('creadoel', $this->creadoel, true);
     $criteria->compare('modificadoel', $this->modificadoel, true);
     $criteria->compare('rucsoc', $this->rucsoc, true);
     $criteria->compare('estado', $this->estado, true);
     $criteria->compare('n_hguia', $this->n_hguia, true);
     $criteria->compare('c_itguia', $this->c_itguia, true);
     $criteria->compare('n_cangui', $this->n_cangui);
     $criteria->compare('c_codgui', $this->c_codgui, true);
     $criteria->compare('c_edgui', $this->c_edgui, true);
     $criteria->compare('m_obs', $this->m_obs, true);
     $criteria->compare('c_codactivo', $this->c_codactivo, true);
     $criteria->compare('c_um', $this->c_um, true);
     $criteria->compare('c_codep', $this->c_codep, true);
     $criteria->compare('l_libre', $this->l_libre, true);
     $criteria->compare('nomep', $this->nomep, true);
     $criteria->compare('estadodetalle', $this->estadodetalle, true);
     $criteria->compare('c_af', $this->c_af, true);
     $criteria->compare('cod_cen', $this->cod_cen, true);
     $criteria->compare('c_codsap', $this->c_codsap, true);
     $criteria->compare('hidref', $this->hidref, true);
     $criteria->compare('docref', $this->docref, true);
     $criteria->compare('codocu', $this->codocu, true);
     $criteria->compare('codocu', $this->codocu, true);
     if (isset($this->d_fectra) && trim($this->d_fectra) != "" && (isset($this->d_fectra1) && trim($this->d_fectra1) != "")) {
         $criteria->addBetweenCondition('d_fectra', '' . $this->d_fectra . '', '' . $this->d_fectra1 . '');
     }
     return new CActiveDataProvider($this, array('criteria' => $criteria));
 }