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;
}
/**
* 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));
}
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));
}
/**
* 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)));
}
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));
}
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)));
}
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)));
}
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));
}
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));
}
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));
}
/**
* 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));
}
/**
* 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));
}
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));
}
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));
}
/**
* 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));
}
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));
}
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));
}
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));
}
/**
*
*/
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;
}
?>
<?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
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));
}
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));
}
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));
}
public function search_por_trabajador($codigo)
{
$criteria = new CDbCriteria();
$criteria->addcondition("codtra='" . $codigo . "' ");
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
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));
}
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));
}
/**
* 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)));
}
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)));
}
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));
}