public function getSuggest($q) { $c = new CDbCriteria(); $c->addSearchCondition('username', $q, true, 'OR'); $c->addSearchCondition('email', $q, true, 'OR'); return $this->findAll($c); }
/** * 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() { $criteria = new CDbCriteria(); $criteria->compare('id', $this->id); $criteria->compare('workflow_id', $this->workflow_id); $criteria->addSearchCondition('name', $this->name, true, 'AND', 'ILIKE'); $criteria->addSearchCondition('label', $this->label, true, 'AND', 'ILIKE'); $criteria->compare('value', $this->value, true); $criteria->compare('description', $this->description, true); if ($this->setting_group == 'ungroup') { $criteria->addCondition("setting_group IS NULL OR setting_group = ''"); } else { $criteria->compare('setting_group', $this->setting_group, true); } if ($this->module == 'module_system') { $criteria->addCondition("module IS NULL OR module = ''"); } else { $criteria->compare('module', $this->module, true); } $criteria->order = 'module, setting_group, ordering, name'; $config = array('criteria' => $criteria, 'sort' => array('defaultOrder' => 'module, setting_group, name')); // if (empty($this->setting_group) === false && empty($this->module) === false) { $config['pagination'] = array('pageSize' => 1000); // } return new CActiveDataProvider(get_class($this), $config); }
public function run() { $model = new MailLog(); //条件 $criteria = new CDbCriteria(); $accept = trim(Yii::app()->request->getParam('accept')); //收件人 $subject = trim(Yii::app()->request->getParam('subject')); //主题 $start_time = Yii::app()->request->getParam('start_time'); $end_time = Yii::app()->request->getParam('end_time'); $accept && $criteria->addSearchCondition('accept', $accept); $subject && $criteria->addSearchCondition('subject', $subject); $start_time && $criteria->compare('sendtime', '>=' . strtotime($start_time)); $end_time && $criteria->compare('sendtime', '<=' . strtotime($end_time)); $criteria->order = 't.id DESC'; $count = $model->count($criteria); //分页 $pages = new CPagination($count); $pages->pageSize = 20; $pages->applyLimit($criteria); //查询 $result = $model->findAll($criteria); $this->controller->render('index', array('model' => $model, 'datalist' => $result, 'pagebar' => $pages)); }
/** * Настройки поиска * @return \CActiveDataProvider */ public function search() { $criteria = new CDbCriteria(); $criteria->compare('bhid', $this->bhid); $criteria->addSearchCondition('player_ip', $this->player_ip); $criteria->addSearchCondition('player_id', $this->player_id); $criteria->addSearchCondition('player_nick', $this->player_nick); $criteria->compare('admin_ip', $this->admin_ip, true); $criteria->compare('admin_id', $this->admin_id, true); if ($this->admin_nick) { $criteria->compare('admin_nick', $this->admin_nick, true); } $criteria->compare('ban_type', $this->ban_type, true); $criteria->addSearchCondition('ban_reason', $this->ban_reason, true); if ($this->ban_created) { $start = strtotime("{$this->ban_created} 00:00:00"); $end = strtotime("{$this->ban_created} 23:59:59"); $criteria->addBetweenCondition('ban_created', $start, $end); } $criteria->compare('ban_length', $this->ban_length); $criteria->compare('server_ip', $this->server_ip, true); $criteria->compare('server_name', $this->server_name, true); if ($this->unban_created) { $start = strtotime("{$this->unban_created} 00:00:00"); $end = strtotime("{$this->unban_created} 23:59:59"); $criteria->addBetweenCondition('unban_created', $start, $end); } $criteria->compare('unban_reason', $this->unban_reason, true); $criteria->compare('unban_admin_nick', $this->unban_admin_nick, true); $criteria->compare('map_name', $this->map_name, true); $criteria->order = '`bhid` DESC'; return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->config->bans_per_page))); }
public function run() { $model = new User(); //审核状态 $user_status = array('all' => '所有', User::STATUS_AUDIT => '待审核', User::STATUS_DISABLE => '禁用', User::STATUS_NORMAL => '正常'); //条件 $criteria = new CDbCriteria(); $groupid = intval(Yii::app()->request->getParam('groupid')); $username = trim(Yii::app()->request->getParam('username')); $status = Yii::app()->request->getParam('status', 'all'); $groupid > 0 && $criteria->addColumnCondition(array('groupid' => $groupid)); if ($status != 'all') { $criteria->addSearchCondition('status', $status); } $criteria->addSearchCondition('username', $username); $criteria->order = 'uid ASC'; $count = $model->count($criteria); //分页 $pages = new CPagination($count); $pages->pageSize = 10; $pages->applyLimit($criteria); //查询 $result = $model->findAll($criteria); $this->controller->render('index', array('datalist' => $result, 'pagebar' => $pages, 'status' => $status, 'user_status' => $user_status)); }
public function actionIndex() { $OrganID = Yii::app()->user->getOrganID(); $criteria = new CDbCriteria(); //表单提交查询 $phone = Yii::app()->request->getParam('phone'); $name = Yii::app()->request->getParam('name'); if (!empty($phone)) { $criteria->addSearchCondition('t.Phone', "{$phone}", "AND"); } if (!empty($name)) { $criteria->addSearchCondition('t.Name', "{$name}", "AND"); } //$criteria->select = "t.ID as ID, t.CreateTime as CreateTime, t.Name as Name, car.LicensePlate as LicensePlate, t.Phone as Phone"; //$criteria->join = " join jpd.jpd_service_car as car on t.id = car.OwnerID"; $criteria->with = "car"; $criteria->order = "t.UpdateTime DESC,t.ID DESC"; //排序条件:t.CreateTime,t.ID倒叙 $criteria->addCondition("t.OrganID = {$OrganID}", "AND"); $criteria->addCondition("t.Status = 0", "AND"); $dataProvider = new CActiveDataProvider('ServiceCarOwner', array('criteria' => $criteria, 'pagination' => array('pageSize' => '10'))); $data = $dataProvider->getData(); foreach ($data as $key => $val) { $LicensePlate = ''; foreach ($val['car'] as $k => $v) { $LicensePlate .= $v['LicensePlate'] . ','; } $val['car'] = substr($LicensePlate, 0, -1); } $this->render('index', array('dataProvider' => $dataProvider, 'phone' => $phone, 'name' => $name)); }
public function actionQuotelist() { $userID = Commonmodel::getOrganID(); $criteria = new CDbCriteria(); if ($_GET) { if ($_GET['num']) { $criteria->addSearchCondition('ItemNum', "{$_GET['num']}", "AND"); } if ($_GET['name']) { $criteria->addSearchCondition('ItemName', "{$_GET['name']}", "AND"); } } $criteria->order = "t.UpdateTime DESC,t.ID DESC"; //排序条件:t.UpdateTime,t.ID倒叙 $criteria->addCondition("t.OrganID = {$userID}"); $criteria->addCondition("t.Status = 0"); $count = ServiceItems::model()->count($criteria); $pages = new CPagination($count); $pages->pageSize = $_GET['rows']; $pages->applyLimit($criteria); $model = ServiceItems::model()->findAll($criteria); foreach ($model as $key => $value) { $data[$key] = $value->attributes; $data[$key]['ItemNums'] = F::msubstr($value['ItemNum']); $data[$key]['ItemNames'] = F::msubstr($value['ItemName']); $data[$key]['ItemExplan'] = F::msubstr($value['ItemIntro']); } $rs = array('total' => $count, 'rows' => $data ? $data : array()); echo json_encode($rs); }
public function actionGetAllResult() { $columns = array(0 => 'id', 1 => 'patient_name', 2 => 'service', 3 => 'time', 4 => 'status', 5 => 'created_at', 6 => 'action'); $request = Yii::app()->request; $start = $_REQUEST['start']; $length = $_REQUEST['length']; $column = $_REQUEST['order'][0]['column']; $order = $_REQUEST['order'][0]['dir']; $where = null; $criteria = new CDbCriteria(); $criteria->order = "{$columns[$column]} {$order}"; if (!empty($_REQUEST['search']['value'])) { $criteria->addSearchCondition("patient_name", $_REQUEST['search']['value'], 'true', 'OR'); $criteria->addSearchCondition("service", $_REQUEST['search']['value'], 'true', 'OR'); $criteria->addSearchCondition("time", $_REQUEST['search']['value'], 'true', 'OR'); $criteria->addSearchCondition("status", $_REQUEST['search']['value'], 'true', 'OR'); $where = true; } if (!empty(Yii::app()->session['provider_id'])) { $criteria->condition = "status >= 1 AND provider_id = " . Yii::app()->session['provider_id']; } $count = ResultMedlatec::model()->count($criteria); $criteria->limit = $length; $criteria->offset = $start; // $criteria->condition = "provider_id = " . Yii::app()->session['provider_id']; $data = ResultMedlatec::model()->findAll($criteria); $returnArr = array(); $service_name = null; $patient_name = null; foreach ($data as $item) { $order = OrderMedlatec::model()->findByPk($item->order_id); if ($order) { $service = ServiceMedlatec::model()->findByPk($order->service_id); if ($service) { $service_name = $service->service_name; } $patient_name = $order->name; } $itemArr = array(); $itemArr['id'] = $item->id; $itemArr['patient_name'] = $patient_name; $itemArr['service'] = $service_name; $itemArr['time'] = Date('d-m-Y', $item->time); $itemArr['status'] = Util::getStatusLabel($item->status); $itemArr['created_at'] = Date('d-m-Y', $item->created_at); if (empty(Yii::app()->session['provider_id'])) { $itemArr['provider_name'] = Provider::model()->getProviderName($item->provider_id); } $edit_url = Yii::app()->createUrl('result/edit', array('result_id' => $item->id)); $order_url = Yii::app()->createUrl('result/order', array('oid' => $item->order_id)); $action = '<a data-toggle="modal" href="' . $edit_url . '" data-target="#edit-order-modal" onclick="loadInfoResult(' . $item->id . ')"><span class="label label-primary">Sửa</span></a>'; $action .= ' <a data-toggle="modal" href="' . $order_url . '" data-target="#edit-order-modal" onclick="loadInfo(' . $item->order_id . ')"><span class="label label-info">Xem order</span></a>'; $itemArr['action'] = $action; $returnArr[] = $itemArr; } //$all = ResultMedlatec::model()->findAll(); echo json_encode(array('data' => $returnArr, "recordsTotal" => $count, "recordsFiltered" => count($data))); }
/** * 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->addSearchCondition('rule_name', $this->rule_name, true, 'OR'); $criteria->addSearchCondition('point', $this->rule_name, true, 'OR'); $criteria->order = 'id_rule DESC'; 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->addSearchCondition('user_id', $this->user_id, true, 'AND', 'ILIKE'); $criteria->addSearchCondition('param_name', $this->param_name, true, 'AND', 'ILIKE'); $criteria->addSearchCondition('value', $this->value, true, 'AND', 'ILIKE'); return new CActiveDataProvider(get_class($this), array('criteria' => $criteria, 'pagination' => array('pageSize' => defined('SETTINGS_BO_PAGE_SIZE') ? SETTINGS_BO_PAGE_SIZE : 50))); }
/** * 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->addSearchCondition('voucher_name', $this->voucher_name, true, 'OR'); $criteria->addSearchCondition('start_date', $this->voucher_name, true, 'OR'); $criteria->addSearchCondition('end_date', $this->voucher_name, true, 'OR'); $criteria->addSearchCondition('point_required', $this->voucher_name, true, 'OR'); $criteria->order = 'DATEDIFF(end_date,now()) DESC,id_voucher DESC'; return new CActiveDataProvider($this, array('criteria' => $criteria)); }
public function actionSelfquestion() { $criteria = new CDbCriteria(); $criteria->order = 'ID DESC'; $criteria->addCondition("Promoter = '" . Yii::app()->user->getOrganID() . "'"); //接收表单数据(查询条件) $title = Yii::app()->request->getParam("Title"); $organName = Yii::app()->request->getParam("OrganName"); $state = Yii::app()->request->getParam("State"); if (!empty($title)) { $criteria->addSearchCondition("Title", "{$title}"); } if (!empty($organName)) { $criteria->addSearchCondition("OrganName", "{$organName}"); } if (!empty($state)) { $criteria->addCondition("State = {$state}"); } $dataProvider = new CActiveDataProvider('Question', array('criteria' => $criteria, 'pagination' => array('pageSize' => '15'))); $data = $dataProvider->getData(); foreach ($data as $key => $val) { $val['SubmitTime'] = date("Y-m-d h:i:s", $val['SubmitTime']); //状态 if ($val['State'] == 1) { $val['State'] = "待分配"; } elseif ($val['State'] == 2) { $val['State'] = "待解答"; } elseif ($val['State'] == 3) { $val['State'] = "待反馈"; } elseif ($val['State'] == 4) { $val['State'] = "完结"; } elseif ($val['State'] == 5) { $val['State'] = "重新开启"; } elseif ($val['State'] == 6) { $val['State'] = "待回访"; } //类型 if ($val['Type'] == 1) { $val['Type'] = "账号问题"; } elseif ($val['Type'] == 2) { $val['Type'] = "交易问题"; } elseif ($val['Type'] == 3) { $val['Type'] = "商品问题"; } elseif ($val['Type'] == 4) { $val['Type'] = "数据问题"; } elseif ($val['Type'] == 5) { $val['Type'] = "意见和建议"; } elseif ($val['Type'] == 6) { $val['Type'] = "其他"; } } $this->render("selfquestion", array('dataProvider' => $dataProvider, 'title' => $title, 'organName' => $organName, 'state' => $state)); }
/** * 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('t.id', $this->id, true); $criteria->with = array('Brand', 'EquipmentType'); $criteria->addSearchCondition('LOWER(Brand.name)', strtolower($this->brand_id)); $criteria->addSearchCondition('LOWER(EquipmentType.type)', strtolower($this->equipment_type_id)); $criteria->compare('t.name', $this->name, true); $criteria->compare('t.active', $this->active); return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize'])))); }
/** * 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->addSearchCondition('name', $this->name, true, 'AND', 'ILIKE'); $criteria->compare('type', $this->type); $criteria->addSearchCondition('description', $this->description, true, 'AND', 'ILIKE'); $criteria->addSearchCondition('bizrule', $this->bizrule, true, 'AND', 'ILIKE'); $criteria->addSearchCondition('data', $this->data, true, 'AND', 'ILIKE'); $criteria->compare('is_system', $this->is_system); return new CActiveDataProvider(get_class($this), array('criteria' => $criteria, 'pagination' => array('pageSize' => defined('SETTINGS_BO_PAGE_SIZE') ? SETTINGS_BO_PAGE_SIZE : 50))); }
/** * 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('t.id', $this->id, true); $criteria->with = array('serviceType', 'equipmentType'); $criteria->addSearchCondition('LOWER(ServiceType.name)', strtolower($this->service_type_id)); $criteria->addSearchCondition('LOWER(EquipmentType.type)', strtolower($this->equipment_type_id)); // $criteria->compare('t.activity', $this->activity, true); $criteria->compare('t.description', $this->description, true); $criteria->compare('t.active', $this->active); return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => array('pageSize' => Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize'])))); }
public function actionStep2() { if (isFrontUserLoggedIn()) { $solicitor_name = Yii::app()->session['solicitor_name']; $criteria = new CDbCriteria(); $criteria->addSearchCondition('first_name', $solicitor_name, true, 'OR'); $criteria->addSearchCondition('last_name', $solicitor_name, true, 'OR'); $sol_list = Solicitor::model()->findAll($criteria); //pre($sol_list,true); $this->render('step2', array('sol_list' => $sol_list)); } else { $this->redirect(array("/user")); } }
public function actionGetAllOrder() { $columns = array(0 => 'id', 1 => 'name', 2 => 'phone', 3 => 'email', 4 => 'requirement', 5 => 'created_at', 6 => 'status', 7 => 'action'); // $request = Yii::app()->request; $start = $_REQUEST['start']; $length = $_REQUEST['length']; $column = $_REQUEST['order'][0]['column']; $order = $_REQUEST['order'][0]['dir']; $where = null; $criteria = new CDbCriteria(); if (!empty($_REQUEST['search']['value'])) { $criteria->addSearchCondition("name", $_REQUEST['search']['value'], 'true', 'OR'); $criteria->addSearchCondition("phone", $_REQUEST['search']['value'], 'true', 'OR'); $criteria->addSearchCondition("email", $_REQUEST['search']['value'], 'true', 'OR'); $criteria->addSearchCondition("requirement", $_REQUEST['search']['value'], 'true', 'OR'); $where = true; } //echo $order; $count = OrderMedlatec::model()->count($criteria); $criteria->limit = $length; $criteria->offset = $start; $criteria->order = "{$columns[$column]} {$order}"; // var_dump($start); die; $data = OrderMedlatec::model()->findAll($criteria); $returnArr = array(); foreach ($data as $item) { $itemArr = array(); $itemArr['id'] = $item->id; $itemArr['name'] = $item->name; // $itemArr['service_id'] = $item->service_id; $itemArr['phone'] = $item->phone; $itemArr['email'] = $item->email; $itemArr['requirement'] = $item->requirement; $itemArr['created_at'] = Date('d-m-Y', $item->created_at); $itemArr['status'] = $item->status; if (empty(Yii::app()->session['provider_id'])) { $itemArr['provider_name'] = Provider::model()->getProviderName($item->provider_id); } $itemArr['status_name'] = Util::getStatusLabel($item->status); // $edit_url = Yii::app()->createUrl('order/edit', array('oid' => $item->id)); // $result_url = Yii::app()->createUrl('order/result', array('oid' => $item->id)); $action = '<a data-toggle="modal" data-target="#edit-order-modal" onclick=loadInfo(' . $item->id . ')><span class="label label-primary">Sửa</span></a>'; $action .= ' <a data-toggle="modal" data-target="#delete-order-modal" onclick=loadInfoDelete(' . $item->id . ')><span class="label label-danger">Xóa</span></a>'; $action .= ' <a data-toggle="modal" data-target="#edit-order-result-modal" onclick=loadInfoResult(' . $item->id . ')><span class="label label-info">Thêm kết quả</span></a>'; $itemArr['action'] = $action; $returnArr[] = $itemArr; } // $all = OrderMedlatec::model()->findAll(); echo json_encode(array('data' => $returnArr, "recordsTotal" => $count, "recordsFiltered" => $count)); }
public function search() { $criteria = new CDbCriteria(); if ($this->comment_id) { if ($this->comment_id) { $criteria->addColumnCondition(array('t.id' => $this->comment_id)); } } else { if ($this->post_id) { $criteria->addColumnCondition(array('t.post_id' => $this->post_id)); } if ($this->user_id) { $criteria->addColumnCondition(array('t.user_id' => $this->user_id)); } if ($this->user_name) { $criteria->addColumnCondition(array('t.user_name' => $this->user_name)); } if ($this->keyword) { $criteria->addSearchCondition('t.content', $this->keyword); } if ($this->start_create_time || $this->end_create_time) { $criteria->addCondition(array('and', 't.create_time > :starttime', 't.create_time < :endtime')); $starttime = (int) $this->start_create_time ? strtotime($this->start_create_time) : 0; $endtime = (int) $this->end_create_time ? strtotime($this->end_create_time) : $_SERVER['REQUEST_TIME']; $params = array(':starttime' => $starttime, ':endtime' => $endtime); $criteria->params = array_merge($criteria->params, $params); } } $data = $criteria->condition ? AdminComment::fetchList($criteria) : null; return $data; }
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 actionPesquisa($search) { $criteria = new CDbCriteria(); $criteria->addSearchCondition('nome', $search); $professores = Professor::model()->findAll($criteria); $this->renderPartial('pesquisa', array('professores' => $professores)); }
/** * 操作日志列表 */ public function ActionOperationLogList() { $criteria = new CDbCriteria(); // 判断查询类型 (分页查询 / 条件查询) $searchType = Yii::app()->request->getParam('searchType'); if ($searchType === 'page') { $search_condition = unserialize(base64_decode(Yii::app()->request->getParam('search_condition'))); // 对分布传来的数据进行还原 } else { // 如有搜索条件 则获取条件并过滤条件数组中的空格与空值 if (!empty($_POST['search'])) { foreach ($_POST['search'] as $key => $val) { $search_condition[$key] = trim($val); } $search_condition = array_filter($search_condition); } else { $search_condition = ''; } } // 增加搜索条件 [S] // 搜索条件中包含时间 则添加时间查询条件 if (!empty($search_condition['start_time']) || !empty($search_condition['end_time'])) { // 如起始时间与结束时间一致 则查询同一个时间点的数据 if (!empty($search_condition['start_time']) && !empty($search_condition['end_time']) && $search_condition['start_time'] == $search_condition['end_time']) { $criteria->addSearchCondition('CreationDate', $search_condition['start_time']); } else { // 1.只按起始时间查询 2.只按结束时间查询 3.按起始+结束时间段查询 if (!empty($search_condition['start_time']) && empty($search_condition['end_time'])) { $criteria->addCondition('CreationDate >= :start_time'); $criteria->params[':start_time'] = $search_condition['start_time'] . ' 23:59:59'; } else { if (empty($search_condition['start_time']) && !empty($search_condition['end_time'])) { $criteria->addCondition('CreationDate <= :end_time'); $criteria->params[':end_time'] = $search_condition['end_time'] . ' 23:59:59'; } else { $criteria->addBetweenCondition('CreationDate', $search_condition['start_time'], $search_condition['end_time']); } } } } // 搜索条件中包含真实姓名 则添加关联查询及条件 if (!empty($search_condition['real_name'])) { $criteria->with = array('account' => array('joinType' => 'INNER JOIN', 'condition' => 'account.RealName="' . $search_condition['real_name'] . '"')); } //增加搜索条件 [E] // 分页配置 $criteria->order = 't.ID DESC'; $count = OperationLog::model()->count($criteria); $pager = new CPagination($count); if (!empty($search_condition)) { //判断是否存在搜索条件,并对搜索条件进行数据处理(便于url传输) $pager->params = array('search_condition' => base64_encode(serialize($search_condition)), 'searchType' => 'page'); } $pager->pageSize = 20; $pager->applyLimit($criteria); // 获取日志列表 $operation_log_list = OperationLog::model()->findAll($criteria); // 跳转至用户操作日志页面 $this->render('list_operation_log', array('operation_log_list' => $operation_log_list, 'pages' => $pager, 'search_condition' => $search_condition)); }
/** * Provides card management saettings */ public function actionCards() { $criteria = new CDbCriteria(); $criteria->addSearchCondition('t.key', 'dashboard_card_%', false); $cards = Configuration::model()->findAll($criteria); $this->render('cards', array('header' => array('h3' => Yii::t('Dashboard.main', 'Manage Dashboard Cards'), 'p' => Yii::t('Dashboard.main', 'Manage and add new dashboard cards.')), 'cards' => $cards)); }
public function getDataProvider($sortBy = 0, $keyWord = "", $gty = 0) { $criteria = new CDbCriteria(); //按like数从高到低排序 if ($sortBy == 0) { $criteria->order = "like_num DESC, _id DESC"; } else { $criteria->order = "_id DESC"; } // $criteria->addSearchCondition('descr', $keyWord); //搜索图片描述 if (strlen($keyWord) > 0) { $criteria->addSearchCondition('descr', $keyWord); //$criteria->addSearchCondition('user.username', $keyWord); } //选择了按性别排序 // 0:不排序, 1:男性,2:女性, 3:男性和女性 if ($gty !== 0) { $criteria->alias = 'style'; $criteria->join = 'LEFT JOIN tbl_style_category_rel ON tbl_style_category_rel.style_id=style._id'; $criteria->addCondition("category_id = :ctg_id"); $criteria->params[':ctg_id'] = $gty; } $dataProvider = new CActiveDataProvider('StyleModel', array('criteria' => $criteria, 'pagination' => array('pageSize' => 3, 'pageVar' => 'page'))); return $dataProvider; }
public function run() { if (isset($this->model) && isset($this->attribute)) { $results = array(); $q = $_GET['term']; if (is_int($q)) { $q = (int) $q; } if (isset($q)) { if (is_array($this->criteria)) { $criteria = new CDbCriteria($this->criteria); } else { $criteria = new CDbCriteria(); } $criteria->addSearchCondition("t." . $this->attribute, trim($q)); $criteria->limit = $this->limit; $model = new $this->model(); foreach ($model->findAll($criteria) as $m) { $results[] = $m->{$this->attribute}; } } } echo CJSON::encode($results); Yii::app()->end(); }
/** * 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($patientId = null) { // @todo Please modify the following code to remove attributes that should not be searched. $criteria = new CDbCriteria(); if (isset($patientId)) { $criteria->addSearchCondition('patient_id', $patientId, true, 'AND'); } // 搜尋就醫時間 if (!empty($this->searchByDateFrom) && !empty($this->searchByDateTo)) { $criteria->addBetweenCondition('date', $this->searchByDateFrom, $this->searchByDateTo); } // 搜尋回診時間 if (!empty($this->searchByNextBackDateFrom) && !empty($this->searchByNextBackDateTo)) { $criteria->addBetweenCondition('next_back_to_clinic_date', $this->searchByNextBackDateFrom, $this->searchByNextBackDateTo); } if (is_null($patientId)) { $criteria->with = array('patient'); } $criteria->compare('patient.name', $this->searchByPatient, true); $criteria->compare('t.id', $this->id, true); $criteria->compare('date', $this->date, true); $criteria->compare('purpose', $this->purpose, true); $criteria->compare('plan', $this->plan, true); $criteria->compare('result', $this->result, true); $criteria->compare('next_back_to_clinic_date', $this->next_back_to_clinic_date, true); $criteria->compare('next_back_to_clinic_notes', $this->next_back_to_clinic_notes, true); $criteria->order = 'next_back_to_clinic_date DESC, date DESC'; return new CActiveDataProvider($this, array('criteria' => $criteria)); }
/** * 梦想集合数据 * GET /api/activity/dream */ public function actionRestlist() { $this->checkRestAuth(); $criteria = new CDbCriteria(); if (!isset($_GET['skip'])) { $skip = 0; } else { $skip = $_GET['skip']; } if (!isset($_GET['take'])) { $take = 50; } else { $take = $_GET['take']; } if (isset($_GET['nickname'])) { $criteria->addSearchCondition('nickname', $_GET['nickname']); } if (isset($_GET['openId'])) { $criteria->compare('open_id', $_GET['openId']); } $criteria->limit = $take; $criteria->offset = $skip; $criteria->order = 'bonus DESC'; $result = Dream::model()->findAll($criteria); $json = new JsonData(); $json->limit = $take; $json->total = (int) Dream::model()->count($criteria); $json->result = $this->JSONArrayMapper($result); echo CJSON::encode($json); }
public function actionUrl($key) { $this->layout = 'main'; if ($key) { $key = implode(' ', explode('-', $key)); $model = Pages::model()->findByAttributes(array('key' => $key)); // var_dump($model); if ($model == null) { throw new CHttpException(404, 'Page Not Found'); } // var_dump($model); $services = []; // die('aaa'); // die('bbbccc'); // var_dump($key); if (preg_match('/service_/', $key)) { // die('aaa000'); $q = new CDbCriteria(); $q->addSearchCondition("'key'", 'service_'); $services = Pages::model()->findAllByAttributes([], "meta_tag like 'Services'"); // var_dump($services); } $this->render('view', array('model' => $model, 'services' => $services)); } else { throw new CHttpException(404, 'Page Not Found'); } }
private function search($search) { $criteria = new CDbCriteria(); $criteria->addSearchCondition('content', $search); $questions = Question::model()->with('user', 'tags')->findAll($criteria); return $questions; }
/** * Searches for stuff */ public function actionSearch() { $query = isset($_GET['q']) ? $_GET['q'] : null; // Scope $users = null; $shares = null; if ($query != null) { // Make the criteria object $userCriteria = new CDbCriteria(); $searchCriteria = new CDbCriteria(); // If there is a @ symbol, do a user search preg_match_all('/@([A-Za-z0-9\\/\\.]*)/', $query, $matches); $mentions = implode(',', $matches[1]); if (!empty($matches[1])) { $userCriteria->addInCondition('username', $matches[1]); $users = User::model()->findAll($userCriteria); // Remove the @users from the remaining query foreach ($matches[1] as $u) { $query = str_replace('@' . $u, '', $query); } } // Do a like Query $searchCriteria->addSearchCondition('text', $query); $searchCriteria->limit = 30; $shares = Share::model()->findAll($searchCriteria); } // Render the search $this->render('search', array('users' => $users, 'shares' => $shares)); }
public function run() { $model = new Comment(); //条件 $criteria = new CDbCriteria(); $type = trim(Yii::app()->request->getParam('type')); $type && $criteria->addColumnCondition(array('type' => $type)); $status = trim(Yii::app()->request->getParam('status')); $status && $criteria->addColumnCondition(array('status' => $status)); $title = trim(Yii::app()->request->getParam('content')); $title && $criteria->addSearchCondition('content', $title); $criteria->order = 't.id DESC'; $count = $model->count($criteria); //分页 $pages = new CPagination($count); $pages->pageSize = 10; $pages->applyLimit($criteria); //查询 $result = $model->findAll($criteria); //全部类型 $model_types = ModelType::model()->findAll(); Yii::app()->clientScript->registerCssFile($this->controller->_static_public . "/js/kindeditor/code/prettify.css"); Yii::app()->clientScript->registerScriptFile($this->controller->_static_public . "/js/kindeditor/code/prettify.js", CClientScript::POS_END); $this->controller->render('index', array('model' => $model, 'model_types' => $model_types, 'datalist' => $result, 'pagebar' => $pages)); }