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