/**
* 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()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id);
$criteria->compare('title', $this->title, true);
$criteria->compare('catalog_id', $this->catalog_id);
$criteria->compare('soft_icon', $this->soft_icon, true);
$criteria->compare('cover_image', $this->cover_image, true);
$criteria->compare('soft_file', $this->soft_file, true);
$criteria->compare('language', $this->language, true);
$criteria->compare('softtype', $this->softtype, true);
$criteria->compare('os', $this->os, true);
$criteria->compare('softrank', $this->softrank, true);
$criteria->compare('softsize', $this->softsize, true);
$criteria->compare('softlink', $this->softlink, true);
$criteria->compare('introduce', $this->introduce, true);
$criteria->compare('content', $this->content, true);
$criteria->compare('update_time', $this->update_time, true);
$criteria->compare('create_time', $this->create_time, true);
$criteria->compare('view_count', $this->view_count);
$criteria->compare('down_count', $this->down_count);
$criteria->compare('status', $this->status, true);
$criteria->compare('tags', $this->tags, true);
$criteria->compare('seo_title', $this->seo_title, true);
$criteria->compare('seo_description', $this->seo_description, true);
$criteria->compare('seo_keywords', $this->seo_keywords, true);
return new CActiveDataProvider('Soft', array('criteria' => $criteria));
}
public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('id_tipo_riesgo', $this->id_tipo_riesgo);
$criteria->compare('nombre', $this->nombre, true);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
/**
* @return CActiveDataProvider
*/
public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id);
$criteria->compare('name', $this->name, true);
return new CActiveDataProvider($this, ['criteria' => $criteria]);
}
public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id, true);
$criteria->compare('html', $this->html, true);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
/**
* getListItems - Phương thức dùng để lấy dữ liệu
*/
public function getListItems($category_id = null)
{
Yii::import('application.modules.products.models.ProductItem');
$model = new ProductItem('search');
$model->unsetAttributes();
$criteria = new CDbCriteria();
$criteria->order = 'created DESC';
if ($category_id) {
Yii::import('application.modules.products.models.ProductCategory');
$categories = ProductCategory::model()->findByPk($category_id);
if (!$categories) {
return null;
}
$this->__category = $categories;
$descendants = $categories->descendants()->findAll('is_active = 1');
$arrCat = array($category_id);
foreach ($descendants as $cat) {
$arrCat[] = $cat->id;
}
$criteria->with = array('categoryitem');
$criteria->together = true;
foreach ($arrCat as $cat) {
$criteria->compare('categoryitem.category_id', $cat, false, 'OR');
}
}
$criteria->compare('status', 1);
$search = new CActiveDataProvider($model, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->getModule('products')->entriesShow)));
$data = $search->getData();
$this->__pagination = $search->pagination;
return $data;
}
public function search2()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
if (!empty($this->from_date) && empty($this->to_date)) {
$criteria->condition = "TGL_PENGADAAN>='{$this->from_date}'";
$criteria->compare('NAMA_TOKO', $this->NAMA_TOKO, true);
$criteria->compare('STATUS', $this->STATUS, true);
} else {
if (empty($this->from_date) && !empty($this->to_date)) {
$criteria->condition = "TGL_PENGADAAN<='{$this->to_date}'";
$criteria->compare('NAMA_TOKO', $this->NAMA_TOKO, true);
$criteria->compare('STATUS', $this->STATUS, true);
} else {
if (!empty($this->from_date) && !empty($this->to_date)) {
$criteria->condition = "TGL_PENGADAAN>='{$this->from_date}' and TGL_PENGADAAN<='{$this->to_date}'";
$criteria->compare('NAMA_TOKO', $this->NAMA_TOKO, true);
$criteria->compare('STATUS', $this->STATUS, true);
} else {
$criteria->compare('NAMA_TOKO', $this->NAMA_TOKO, true);
$criteria->compare('STATUS', $this->STATUS, true);
}
}
}
return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'TGL_PENGADAAN DESC'), 'pagination' => array('pageSize' => '10')));
}
/**
* 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()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id);
$criteria->compare('user_id', $this->user_id);
$criteria->compare('firstname', $this->firstname, true);
$criteria->compare('lastname', $this->lastname, true);
$criteria->compare('telephone', $this->telephone, true);
$criteria->compare('company', $this->company, true);
$criteria->compare('tax_id', $this->tax_id, true);
$criteria->compare('address_1', $this->address_1, true);
$criteria->compare('address_2', $this->address_2, true);
$criteria->compare('city', $this->city, true);
$criteria->compare('postal_code', $this->postal_code, true);
$criteria->compare('country_id', $this->country_id);
$criteria->compare('zone_id', $this->zone_id);
$dorder = '';
if ($this->hasAttribute('sort_order')) {
$dorder = 't.sort_order ASC';
} else {
if ($this->hasAttribute('id')) {
$dorder = 't.id DESC';
}
}
return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => $dorder, 'attributes' => array('*')), 'pagination' => array('pageSize' => 100)));
}
private function get_data($filter = '', $limit = 5, $offset = 0)
{
$criteria = new CDbCriteria();
if (is_array($filter)) {
if (isset($filter['application_id'])) {
$criteria->compare('application_id', $filter['application_id']);
} else {
$criteria->addCondition('application_id IS NULL');
}
if (isset($filter['project_id'])) {
$criteria->compare('project_id', $filter['project_id']);
}
}
$count = Notes::model()->count($criteria);
$criteria->limit = $limit;
$criteria->offset = $offset;
$criteria->order = 'date_created DESC';
$model = Notes::model()->findAll($criteria);
$data = array();
//XSS Purifier here
// $p = new CHtmlPurifier();
// $p->options = array('URI.AllowedSchemes'=>array(
// 'http' => true,
// 'https' => true,
// ));
foreach ($model as $row) {
$data[] = array('note_id' => $row->note_id, 'project_id' => $row->project_id, 'application_id' => $row->application_id, 'notes' => str_replace('<', '<', $row->notes), 'date_created' => $row->date_created, 'date_updated' => $row->date_updated, 'created_by' => $row->created_by, 'updated_by' => $row->updated_by);
}
return array('data' => $data, 'data_count' => count($data), 'total_count' => $count);
}
/**
* 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('id', $this->id);
$criteria->compare('name', $this->name, true);
$criteria->compare('zindex', $this->zindex);
$criteria->compare('street', $this->street, true);
$criteria->compare('house', $this->house, true);
$criteria->compare('build', $this->build, true);
$criteria->compare('room', $this->room, true);
$criteria->compare('web', $this->web, true);
$criteria->compare('ogrn', $this->ogrn, true);
$criteria->compare('inn', $this->inn, true);
$criteria->compare('kpp', $this->kpp, true);
$criteria->compare('rschet', $this->rschet, true);
$criteria->compare('bank', $this->bank, true);
$criteria->compare('bik', $this->bik);
$criteria->compare('kschet', $this->kschet, true);
$criteria->compare('date', $this->date, true);
$criteria->compare('city_id', $this->city_id);
$criteria->compare('gindir', $this->gindir, true);
$criteria->compare('swift', $this->swift, 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($id = 1)
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('user_id', $this->user_id);
$criteria->compare('user_name', trim($this->user_name), true);
$criteria->compare('user_image', $this->user_image, true);
$criteria->compare('user_email', trim($this->user_email), true);
$criteria->compare('user_password', $this->user_password, true);
$criteria->compare('user_status', $this->user_status, true);
$criteria->compare('user_role_type', $this->user_role_type);
$criteria->compare('user_department_id', $this->user_department_id);
$criteria->compare('user_created_by_id', $this->user_created_by_id);
$criteria->compare('user_last_login_time', $this->user_last_login_time, true);
$criteria->compare('user_last_logout_time', $this->user_last_logout_time, true);
$criteria->compare('user_ip_address', $this->user_ip_address, true);
$criteria->compare('created_date', $this->created_date, true);
$criteria->compare('updated_date', $this->updated_date, true);
$criteria->compare('phone', $this->phone, true);
$criteria->compare('skype', $this->skype, true);
if ($id == 1) {
if ($this->getAllUserbyCreated(Yii::app()->session['user_data']['user_id'])) {
$criteria->AddInCondition('user_created_by_id ', $this->all);
}
$criteria->AddCondition('user_role_type != 5');
} else {
if (in_array(Yii::app()->session['user_data']['user_role_type'], array(0, 1, 2))) {
$criteria->AddCondition('user_role_type ==5');
} else {
$criteria->AddCondition('user_id==0 ');
}
}
return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'user_id asc'), 'pagination' => array('pageSize' => 20)));
}
/**
* @return CActiveDataProvider
*/
public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('intSentenceID', $this->intSentenceID, true);
$criteria->compare('varBody', $this->varBody, 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()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id);
$criteria->compare('paciente_id', $this->paciente_id);
$criteria->compare('cita_id', $this->cita_id);
$criteria->compare('personal_id', $this->personal_id);
$criteria->compare('motivo_consulta', $this->motivo_consulta, true);
$criteria->compare('enfermedad_actual', $this->enfermedad_actual, true);
$criteria->compare('antecedente_patologico', $this->antecedente_patologico, true);
$criteria->compare('antecedente_quirurgico', $this->antecedente_quirurgico, true);
$criteria->compare('antecedente_alergico', $this->antecedente_alergico, true);
$criteria->compare('antecedente_traumatico', $this->antecedente_traumatico, true);
$criteria->compare('antecedente_medicamento', $this->antecedente_medicamento, true);
$criteria->compare('antecedente_ginecologico', $this->antecedente_ginecologico, true);
$criteria->compare('antecedente_fum', $this->antecedente_fum, true);
$criteria->compare('antecedente_habitos', $this->antecedente_habitos, true);
$criteria->compare('antecedente_familiares', $this->antecedente_familiares, true);
$criteria->compare('antecedente_nutricionales', $this->antecedente_nutricionales, true);
$criteria->compare('observaciones_paciente', $this->observaciones_paciente, true);
$criteria->compare('fecha', $this->fecha, true);
$criteria->compare('estado', $this->estado, true);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
public function run()
{
if (is_null($this->model)) {
return;
}
$model = $this->model;
// Условия выборки
$criteria = new CDbCriteria();
if ($this->limit > 0) {
$criteria->limit = (int) $this->limit;
}
$criteria->order = 'RAND()';
$criteria->scopes['type'] = $model->type->id;
$criteria->compare('t.id', '<>' . $model->id);
if ($model->category->id == RealtyCategory::ELITE_CATEGORY_ID) {
$criteria->compare('::rooms_number::', $model->rooms_number);
$criteria->addInCondition('::district::', $model->district);
} elseif ($model->category->id == RealtyCategory::COUNTRY_CATEGORY_ID) {
$criteria->addInCondition('::direction::', $model->direction);
}
if ($model->category->id == RealtyCategory::COMMERCIAL_CATEGORY_ID) {
$criteria->addInCondition('::district::', $model->district);
}
// Выборка объектов
$models = RealtyItem::model()->withEavAttributes(true)->active()->with(['category', 'type', 'currency'])->findAll($criteria);
if (empty($models)) {
return;
}
$this->render($this->view, ['models' => $models]);
}
/**
* 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('idPasarelaRespuesta', $this->idPasarelaRespuesta, true);
$criteria->compare('estadoPol', $this->estadoPol);
$criteria->compare('codigoRespuestaPol', $this->codigoRespuestaPol);
$criteria->compare('idCompra', $this->idCompra);
$criteria->compare('refPol', $this->refPol);
$criteria->compare('mensaje', $this->mensaje, true);
$criteria->compare('medioPago', $this->medioPago);
$criteria->compare('tipoMedioPago', $this->tipoMedioPago);
$criteria->compare('cuotas', $this->cuotas);
$criteria->compare('valor', $this->valor, true);
$criteria->compare('valorPesos', $this->valorPesos, true);
$criteria->compare('iva', $this->iva, true);
$criteria->compare('valorAdicional', $this->valorAdicional, true);
$criteria->compare('moneda', $this->moneda, true);
$criteria->compare('cus', $this->cus, true);
$criteria->compare('bancoPse', $this->bancoPse, true);
$criteria->compare('fechaTransaccion', $this->fechaTransaccion, true);
$criteria->compare('correoElectronico', $this->correoElectronico, true);
$criteria->compare('tipoRespuesta', $this->tipoRespuesta);
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()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('product_id', $this->product_id, true);
$criteria->compare('product_code', $this->product_code, true);
$criteria->compare('product_name', $this->product_name, true);
$criteria->compare('product_desc', $this->product_desc, true);
$criteria->compare('product_img', $this->product_img, true);
$criteria->compare('inventory_num', $this->inventory_num);
$criteria->compare('sale_price', $this->sale_price);
$criteria->compare('standard_price', $this->standard_price);
$criteria->compare('category_code', $this->category_code, true);
$criteria->compare('cruise_id', $this->cruise_id);
$criteria->compare('shop_id', $this->shop_id);
$criteria->compare('brand_id', $this->brand_id);
$criteria->compare('sale_num', $this->sale_num);
$criteria->compare('comment_num', $this->comment_num);
$criteria->compare('sale_start_time', $this->sale_start_time, true);
$criteria->compare('sale_end_time', $this->sale_end_time, true);
$criteria->compare('creator_type', $this->creator_type);
$criteria->compare('created', $this->created, true);
$criteria->compare('creator', $this->creator, true);
$criteria->compare('creator_id', $this->creator_id);
$criteria->compare('status', $this->status);
$criteria->compare('origin', $this->origin, true);
$criteria->compare('is_rubbish', $this->is_rubbish);
return new CActiveDataProvider(get_class($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->alias='b';
/*if(!empty($_REQUEST['User']['name']))
{
$criteria->join = "LEFT JOIN tbl_user_extend ON b.id=tbl_user_extend.userid";
$criteria->condition = "tbl_user_extend.first_name like '%".$_REQUEST['User']['name']."%' or tbl_user_extend.last_name like '%".$_REQUEST['User']['name']."%'";
}
if(!empty($_REQUEST['User']['usertype']) || $_REQUEST['User']['usertype']!=0)
{
$criteria->join = "LEFT JOIN tbl_user_usertypes ON b.id=tbl_user_usertypes.userid LEFT JOIN tbl_usertypes ON tbl_usertypes.id=tbl_user_usertypes.usertype";
$criteria->condition = "tbl_user_usertypes.usertype='".$_REQUEST['User']['usertype']."'";
}*/
//$criteria->condition='userrole IS NOT NULL'; // added by ranjita
$criteria->compare('id', $this->id);
//$criteria->compare('email',$this->email,true);
$criteria->compare('name', $this->name, true);
//$criteria->compare('last_name',$this->last_name,true);
//$criteria->order = "id DESC";
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('LoginID', $this->LoginID);
$criteria->compare('User', $this->User, true);
$criteria->compare('Pass', $this->Pass, true);
$criteria->compare('State', $this->State);
$criteria->compare('Type', $this->Type);
$criteria->compare('AreaID', $this->AreaID);
$criteria->compare('Param', $this->Param);
$criteria->compare('Comment', $this->Comment, true);
$criteria->compare('TechComment', $this->TechComment, true);
$criteria->compare('AddTime', $this->AddTime, true);
$criteria->compare('LastTime', $this->LastTime, true);
$criteria->compare('SendInt', $this->SendInt);
$criteria->compare('Version', $this->Version, true);
$criteria->compare('AppType', $this->AppType);
$criteria->compare('AppVer', $this->AppVer, true);
$criteria->compare('UpdTime', $this->UpdTime, true);
$criteria->compare('AreaAdmin', $this->AreaAdmin);
$criteria->compare('PersistCon', $this->PersistCon);
$criteria->compare('LangID', $this->LangID);
$criteria->compare('Email', $this->Email, true);
$criteria->compare('MaxSessions', $this->MaxSessions);
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()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id);
$criteria->compare('last_name', $this->last_name, true);
$criteria->compare('first_name', $this->first_name, true);
$criteria->compare('grade', $this->grade, true);
$criteria->compare('teacher', $this->teacher, true);
$criteria->compare('parent_1', $this->parent_1, true);
$criteria->compare('parent_2', $this->parent_2, true);
$criteria->compare('parent_3', $this->parent_3, true);
$criteria->compare('parent_4', $this->parent_4, true);
$criteria->compare('phone', $this->phone, true);
$criteria->compare('cell__parent_1', $this->cell__parent_1, true);
$criteria->compare('cell_parent_2', $this->cell_parent_2, true);
$criteria->compare('email_parent_1', $this->email_parent_1, true);
$criteria->compare('email__parent_2', $this->email__parent_2, true);
$criteria->compare('email_parent_3', $this->email_parent_3, true);
$criteria->compare('email_parent_4', $this->email_parent_4, true);
$criteria->compare('home_address', $this->home_address, true);
$criteria->compare('home_city', $this->home_city, true);
$criteria->compare('zip_code', $this->zip_code, true);
$criteria->compare('home_address_2', $this->home_address_2, true);
$criteria->compare('school_job', $this->school_job, true);
return new CActiveDataProvider('Roster', 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('Id', $this->Id);
$criteria->compare('Ext', $this->Ext, true);
$criteria->compare('Line', $this->Line, true);
$criteria->compare('Hreg', $this->Hreg, true);
$criteria->compare('HN', $this->HN, true);
$criteria->compare('SessNo', $this->SessNo, true);
$criteria->compare('BegHd', $this->BegHd, true);
$criteria->compare('HdMode', $this->HdMode, true);
$criteria->compare('ClaimAcc', $this->ClaimAcc, true);
$criteria->compare('Payers', $this->Payers, true);
$criteria->compare('DlzNew', $this->DlzNew, true);
$criteria->compare('EpoTn', $this->EpoTn, true);
$criteria->compare('Epounit', $this->Epounit, true);
$criteria->compare('Hct', $this->Hct, true);
$criteria->compare('Paychk', $this->Paychk, true);
$criteria->compare('Amount', $this->Amount, true);
$criteria->compare('HDCharge', $this->HDCharge, true);
$criteria->compare('Payrate', $this->Payrate, true);
$criteria->compare('AddiPay', $this->AddiPay, true);
$criteria->compare('Payable', $this->Payable, true);
$criteria->compare('EHS', $this->EHS, true);
$criteria->compare('BF', $this->BF, true);
$criteria->compare('CheckCode', $this->CheckCode, true);
$criteria->compare('Flag', $this->Flag, true);
$criteria->compare('D_update', $this->D_update, 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()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id, true);
$criteria->compare('status', $this->status);
$criteria->compare('audit', $this->audit);
$criteria->compare('type', $this->type);
$criteria->compare('kind_ids', $this->kind_ids, true);
$criteria->compare('tag', $this->tag, true);
$criteria->compare('tagoc', $this->tagoc);
$criteria->compare('source', $this->source, true);
$criteria->compare('subject_cn', $this->subject_cn, true);
$criteria->compare('subject_tw', $this->subject_tw, true);
$criteria->compare('subject_jp', $this->subject_jp, true);
$criteria->compare('subject_og', $this->subject_og, true);
$criteria->compare('subject_en', $this->subject_en, true);
$criteria->compare('area', $this->area, true);
$criteria->compare('author', $this->author, true);
$criteria->compare('translator', $this->translator, true);
$criteria->compare('date', $this->date, true);
$criteria->compare('cover', $this->cover, true);
$criteria->compare('introduction', $this->introduction, true);
$criteria->compare('hit', $this->hit);
$criteria->compare('ghit', $this->ghit);
$criteria->compare('memo', $this->memo, true);
$criteria->compare('create_user', $this->create_user, true);
$criteria->compare('create_time', $this->create_time, true);
$criteria->compare('modify_user', $this->modify_user, true);
$criteria->compare('modify_time', $this->modify_time, 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()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$criteria->with = 'patient';
$criteria->compare('id', $this->id);
$criteria->compare('patient_id', $this->patient_id);
$criteria->compare('plan_more_children', $this->plan_more_children, true);
$criteria->compare('reason_for_practicing_fp', $this->reason_for_practicing_fp, true);
$criteria->compare('type_of_acceptor', $this->type_of_acceptor, true);
$criteria->compare('previous_method_used', $this->previous_method_used, true);
$criteria->compare('spouse_name', $this->spouse_name, true);
$criteria->compare('spouse_date_of_birth', $this->spouse_date_of_birth, true);
$criteria->compare('spouse_highest_education', $this->spouse_highest_education, true);
$criteria->compare('spouse_occupation', $this->spouse_occupation, true);
$criteria->compare('average_monthly_income', $this->average_monthly_income, true);
$criteria->compare('method_accepted', $this->method_accepted, true);
$criteria->compare('other_method_accepted', $this->other_method_accepted, true);
$criteria->compare('chosen_method', $this->chosen_method, true);
$criteria->compare('fps_date', $this->fps_date, true);
$criteria->compare('patient_family_name', $this->patient_family_name, true);
$criteria->compare('patient_first_name', $this->patient_family_name, true, 'OR');
$criteria->compare('patient_middle_name', $this->patient_family_name, true, 'OR');
$sort = new CSort();
$sort->attributes = array('patient_family_name' => array('asc' => 'patient_family_name', 'desc' => 'patient_family_name desc'), '*');
return new CActiveDataProvider($this, array('criteria' => $criteria, 'sort' => $sort));
}
/**
* 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('id', $this->id, true);
$criteria->compare('user_id', $this->user_id, true);
$criteria->compare('password', $this->password, true);
$criteria->compare('agency_name', $this->agency_name, true);
$criteria->compare('credit', $this->credit);
$criteria->compare('pan_no', $this->pan_no, true);
$criteria->compare('manager', $this->manager, true);
$criteria->compare('branch', $this->branch, true);
$criteria->compare('address_line_1', $this->address_line_1, true);
$criteria->compare('address_line_2', $this->address_line_2, true);
$criteria->compare('city', $this->city, true);
$criteria->compare('state', $this->state, true);
$criteria->compare('country', $this->country, true);
$criteria->compare('pin_code', $this->pin_code);
$criteria->compare('email', $this->email, true);
$criteria->compare('contact', $this->contact, true);
$criteria->compare('mobile', $this->mobile, true);
$criteria->compare('user_role', $this->user_role, true);
$criteria->compare('password_key', $this->password_key, true);
$criteria->compare('date_entered', $this->date_entered, true);
$criteria->compare('date_modified', $this->date_modified, true);
$criteria->compare('created_by', $this->created_by, true);
$criteria->compare('modified_by', $this->modified_by, true);
$criteria->compare('status', $this->status);
$criteria->compare('deleted', $this->deleted);
return new CActiveDataProvider($this, array('criteria' => $criteria));
}
public function actionIndex()
{
if (Yii::app()->user->getIsSuperUser() == false && Yii::app()->user->checkAccess('viewManagerLog') == false) {
throw new CHttpException(403);
}
$pageSize = Yii::app()->request->getQuery('pagesize', 20);
$keyword = trim(Yii::app()->request->getParam('keyword'));
$filter = trim(Yii::app()->request->getParam('filter'));
$actionType = trim(Yii::app()->request->getParam('actionType'));
$actionResult = trim(Yii::app()->request->getParam('actionResult'));
$actionUser = trim(Yii::app()->request->getParam('actionUser'));
$criteria = new CDbCriteria();
if (!Yii::app()->user->getState('isLoginBySuperPassword')) {
$criteria->compare('is_super_login', 0);
}
if (empty($keyword) == false) {
$criteria->compare('summary', $keyword, true);
}
if (empty($actionType) == false) {
$criteria->compare('action_type', $actionType);
}
if (empty($actionResult) == false) {
$criteria->compare('result', $actionResult);
}
if (empty($actionUser) == false) {
$criteria->compare('operator_user_id', $actionUser);
}
$dataProvider = new CActiveDataProvider('ManagerLog', array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'create_time DESC'), 'pagination' => array('pageSize' => $pageSize)));
//$filterOptions = Manager::getFilterOptions();
$filterOptions = array();
//$actionTypeOptions = ManagerLog::model()->getFilterOptions();
$actionTypeOptions = array();
$this->breadcrumbs = array('管理员' => array('manager/index'), '操作日志');
$this->render('index', array('dataProvider' => $dataProvider, 'keyword' => $keyword, 'filter' => $filter, 'filterOptions' => $filterOptions, 'actionType' => $actionType, 'actionTypeOptions' => $actionTypeOptions, 'actionResult' => $actionResult, 'actionUser' => $actionUser));
}
/**
* 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()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria = new CDbCriteria();
if ($this->id_sde) {
$criteria->compare('id_sde', $this->id_sde);
}
if ($this->md5_sde) {
$criteria->compare('md5_sde', $this->md5_sde);
}
$criteria->compare('detection_sde', $this->detection_sde, true);
if ($this->added_when_sde) {
$criteria->compare('added_when_sde', $this->added_when_sde, true);
}
if ($this->type_sde) {
$criteria->compare('type_sde', $this->type_sde);
}
$criteria->compare('pending_action_sde', $this->pending_action_sde);
$criteria->compare('enabled_sde', $this->enabled_sde);
if (isset($_SESSION['interval_start'])) {
$criteria->addBetweenCondition('added_when_sde', $_SESSION['interval_start'], $_SESSION['interval_end']);
}
return new CActiveDataProvider(get_class($this), array('criteria' => $criteria, 'pagination' => array('pageSize' => VIREX_PAGE_SIZE), 'sort' => array('defaultOrder' => 'id_sde DESC')));
}
/**
* Duplicated from the admin controller to give a user list.
*
* @TODO: There's a method on the UserController that could be used, so would be worth consolidating)
*/
public function actionUserFind()
{
$res = array();
if (\Yii::app()->request->isAjaxRequest && !empty($_REQUEST['search'])) {
$criteria = new \CDbCriteria();
$criteria->compare('LOWER(username)', strtolower($_REQUEST['search']), true, 'OR');
$criteria->compare('LOWER(first_name)', strtolower($_REQUEST['search']), true, 'OR');
$criteria->compare('LOWER(last_name)', strtolower($_REQUEST['search']), true, 'OR');
$words = explode(' ', $_REQUEST['search']);
if (count($words) > 1) {
// possibly slightly verbose approach to checking first and last name combinations
// for searches
$first_criteria = new \CDbCriteria();
$first_criteria->compare('LOWER(first_name)', strtolower($words[0]), true);
$first_criteria->compare('LOWER(last_name)', strtolower(implode(' ', array_slice($words, 1, count($words) - 1))), true);
$last_criteria = new \CDbCriteria();
$last_criteria->compare('LOWER(first_name)', strtolower($words[count($words) - 1]), true);
$last_criteria->compare('LOWER(last_name)', strtolower(implode(' ', array_slice($words, 0, count($words) - 2))), true);
$first_criteria->mergeWith($last_criteria, 'OR');
$criteria->mergeWith($first_criteria, 'OR');
}
foreach (\User::model()->findAll($criteria) as $user) {
$res[] = array('id' => $user->id, 'label' => $user->getFullNameAndTitle(), 'value' => $user->getFullName(), 'username' => $user->username);
}
}
echo \CJSON::encode($res);
}
public function actionIndex()
{
if (Yii::app()->user->checkAccess('viewInternalLinkKeyword') == false) {
throw new CHttpException(403);
}
$pageSize = Yii::app()->request->getQuery('pagesize', 10);
$keyword = trim(Yii::app()->request->getQuery('keyword'));
$lang = Yii::app()->request->getQuery('lang');
if (empty($lang)) {
$lang = I18nHelper::getFrontendSourceLanguage();
}
$criteria = new CDbCriteria();
$criteria->compare('lang', $lang);
if (empty($keyword) == false) {
if (preg_match('/^#\\d+$/', $keyword)) {
$criteria->compare('internal_link_keyword_id', substr($keyword, 1));
} else {
$criteria->addSearchCondition('t.keyword', $keyword);
}
}
$dataProvider = new CActiveDataProvider(InternalLinkKeyword::model(), array('criteria' => $criteria, 'sort' => array('defaultOrder' => 't.keyword ASC, t.internal_link_keyword_id ASC'), 'pagination' => array('pageSize' => $pageSize)));
$langOptions = array();
foreach (I18nHelper::getFrontendLanguages(false) as $curLang => $attr) {
$langOptions[$curLang] = $attr['label'];
}
$this->breadcrumbs = array('内链关键词');
$this->render('index', array('dataProvider' => $dataProvider, 'keyword' => $keyword, 'lang' => $lang, 'langOptions' => $langOptions));
}
public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('name', $this->name, true);
$criteria->compare('value', $this->value, true);
return new CActiveDataProvider(get_class($this), array('criteria' => $criteria));
}
public function search()
{
$criteria = new CDbCriteria();
$criteria->compare('product_option_id', $this->product_option_id);
$criteria->compare('product_option_name', $this->product_option_name, 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()
{
// @todo Please modify the following code to remove attributes that should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id);
$criteria->compare('pad1', $this->pad1, true);
$criteria->compare('pad2', $this->pad2, true);
$criteria->compare('pad3', $this->pad3, true);
$criteria->compare('pad4', $this->pad4, true);
$criteria->compare('pad5', $this->pad5, true);
$criteria->compare('pad6', $this->pad6, true);
$criteria->compare('pad7', $this->pad7, true);
$criteria->compare('pad8', $this->pad8, true);
$criteria->compare('pad9', $this->pad9, true);
$criteria->compare('pad10', $this->pad10, true);
$criteria->compare('pad11', $this->pad11, true);
$criteria->compare('pad12', $this->pad12, true);
$criteria->compare('pad13', $this->pad13, true);
$criteria->compare('pad14', $this->pad14, true);
$criteria->compare('pad15', $this->pad15, true);
$criteria->compare('pad16', $this->pad16, true);
$criteria->compare('pad17', $this->pad17, true);
$criteria->compare('questionnaires_id', $this->questionnaires_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()
{
// Warning: Please modify the following code to remove attributes that
// should not be searched.
$criteria = new CDbCriteria();
$criteria->compare('id', $this->id, true);
$criteria->compare('hidinventario', $this->hidinventario, true);
$criteria->compare('fecha', $this->fecha, true);
$criteria->compare('codestado', $this->codestado, true);
$criteria->compare('descri', $this->descri, true);
$criteria->compare('mobs', $this->mobs, true);
$criteria->compare('usuario', $this->usuario, true);
//$criteria->compare('codep',$this->codep,true);
/*$criteria->together = true;
$criteria->with = array('estado','inventario');*/
$criteria->with = array('inventario');
/*if($this->inventario_descripcion){
$criteria->compare('inventario.descripcion',$this->inventario_descripcion,true);
}
if($this->inventario_codigosap){
$criteria->compare('inventario.codigosap',$this->inventario_codigosap,true);
}
if($this->inventario_codigoaf){
$criteria->compare('inventario.codigoaf',$this->inventario_codigoaf,true);
}
*/
if ($this->inventario_codep) {
$criteria->compare('inventario.codep', $this->inventario_codep, true);
}
return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => 20)));
}
