public function actionSearch() { $request = Yii::$app->request; $type = $request->get("type"); $query = Yii::$app->session->getFlash('query'); if (!$type) { $type = $request->post("type"); $content = $request->post("content"); } else { $content = $request->get("content"); } if ($type || !$query) { switch ($type) { case 'userId': $query = Service::find()->where(['userId' => $content]); break; case 'date': $query = Service::find()->where(['between', 'createDate', date('Y-m-d H:i:s', strtotime($content)), date('Y-m-d H:i:s')]); break; case 'state': if ($content == 'noReply') { $query = Service::find()->where(['state' => Service::STATE_UNREPLY]); } elseif ($content == 'replied') { $query = Service::find()->where(['state' => Service::STATE_REPLIED]); } elseif ($content == 'publish') { $query = Service::find()->where(['state' => Service::STATE_PUBLISH]); } else { $query = Service::find(); } break; case 'nickname': $table_a = Service::tableName(); $table_b = Users::tableName(); $query = Service::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(['like', "{$table_b}.nickname", $content]); break; case 'content': $query = Service::find()->where(['like', $type, $content]); break; default: $query = Service::find(); break; } } $pagination = new Pagination(['defaultPageSize' => Yii::$app->params['pageSize'], 'totalCount' => $query->count()]); $models = $query->offset($pagination->offset)->limit($pagination->limit)->orderBy(['createDate' => SORT_DESC])->all(); return $this->render('index', ['models' => $models, 'pages' => $pagination]); }
/** 查询 */ public function actionSearch() { $request = Yii::$app->request; $query = Yii::$app->session->getFlash('query'); if ($request->isPost) { $type = $request->post('type'); $content = $request->post('content'); } else { $type = $request->get('type'); $content = trim($request->get('content')); } if ($type || !$query) { $user = Yii::$app->session->get('user'); switch ($type) { case 'income': if ($content == 'my') { $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME, 'userId' => $user['userId']]); } elseif ($content == 'others') { $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME, 'FromUserId' => $user['userId']]); } break; case 'consume': if ($content == 'my') { $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_CONSUME, 'userId' => $user['userId']]); } break; case 'userId': $query = IncomeConsume::find()->where(['userId' => $user['userId']])->orWhere(['fromUserId' => $user['userId']])->andWhere(['userId' => $content]); break; case 'nickname': case 'realname': $table_a = IncomeConsume::tableName(); $table_b = Users::tableName(); $query = IncomeConsume::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(["{$table_a}.userId" => $user['userId']])->orWhere(["{$table_a}.fromUserId" => $user['userId']])->andWhere(['like', "{$table_b}.{$type}", $content]); break; default: $query = IncomeConsume::find()->where(['userId' => $user['userId']])->orWhere(['fromUserId' => $user['userId']]); break; } } Yii::$app->session->setFlash('query', $query); $pagination = new Pagination(['defaultPageSize' => Yii::$app->params['pageSize'], 'totalCount' => $query->count()]); $model = $query->offset($pagination->offset)->limit($pagination->limit)->orderBy(['createDate' => SORT_DESC])->all(); return $this->render('index', ['models' => $model, 'pages' => $pagination]); }
public function actionSearch() { $request = Yii::$app->request; $query = Yii::$app->session->getFlash('query'); if ($request->isPost) { $type = $request->post('type'); $content = trim($request->post('content')); } else { $type = $request->get('type'); $content = trim($request->get('content')); } if ($type || !$query) { switch ($type) { case 'province': $table_a = Users::tableName(); $table_b = Province::tableName(); $query = Users::find()->leftJoin($table_b, "{$table_a}.provinceId={$table_b}.provinceId")->where(['like', "{$table_b}.name", $content]); break; case 'majorJob': $table_a = Users::tableName(); $table_b = MajorJob::tableName(); $query = Users::find()->leftJoin($table_b, "{$table_a}.majorJobId={$table_b}.majorJobId")->where(['like', $table_b . ".name", $content]); break; case 'nickname': case 'cellphone': $query = Users::find()->where(['like', $type, $content]); break; default: $query = Users::find(); break; } $query = $query->andWhere('weixin is not null'); //添加微信用户条件,位置不可改 } Yii::$app->session->setFlash('query', $query); $pagination = new Pagination(['defaultPageSize' => Yii::$app->params['pageSize'], 'totalCount' => $query->count()]); $user = $query->offset($pagination->offset)->limit($pagination->limit)->orderBy(['registerDate' => SORT_DESC])->all(); return $this->render('index', ['users' => $user, 'pages' => $pagination]); }
/** 资金查询 */ public function actionSearch() { $request = Yii::$app->request; $query = Yii::$app->session->getFlash('query'); if ($request->isPost) { $type = $request->post('type'); $content = $request->post('content'); } else { $type = $request->get('type'); $content = trim($request->get('content')); } if ($type || !$query) { switch ($type) { case 'type': $query = Money::find()->where(['type' => $content]); break; case 'userId': $query = Money::find()->Where(['userId' => $content]); break; case 'nickname': $table_a = Money::tableName(); $table_b = Users::tableName(); $query = Money::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(['like', "{$table_b}.nickname", $content]); break; case 'pay-more': $query = Money::find()->Where(['>=', 'money', $content])->andWhere(['type' => Money::TYPE_PAY]); break; case 'pay-equal': $query = Money::find()->where(['=', 'money', $content])->andWhere(['type' => Money::TYPE_PAY]); break; case 'pay-less': $query = Money::find()->Where(['<=', 'money', $content])->andWhere(['type' => Money::TYPE_PAY]); break; case 'withdraw-more': $query = Money::find()->Where(['>=', 'money', $content])->andWhere(['type' => Money::TYPE_WITHDRAW]); break; case 'withdraw-equal': $query = Money::find()->where(['=', 'money', $content])->andWhere(['type' => Money::TYPE_WITHDRAW]); break; case 'withdraw-less': $query = Money::find()->Where(['<=', 'money', $content])->andWhere(['type' => Money::TYPE_WITHDRAW]); break; case 'role': $role = ''; if ($content == 'a' || $content == 'A' || $content == 'A级') { $role = Users::ROLE_A; } elseif (strstr('金牌伙伴', $content)) { $role = Users::ROLE_AA; } elseif (strstr('钻石伙伴', $content)) { $role = Users::ROLE_AAA; } elseif ($content == '管理员') { $role = Users::ROLE_ADMIN; } $table_a = Money::tableName(); $table_b = Users::tableName(); $query = Money::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(["{$table_b}.role" => $role]); break; default: $query = Money::find(); break; } } Yii::$app->session->setFlash('query', $query); $pagination = new Pagination(['defaultPageSize' => Yii::$app->params['pageSize'], 'totalCount' => $query->count()]); $model = $query->offset($pagination->offset)->limit($pagination->limit)->orderBy(['moneyId' => SORT_DESC])->all(); return $this->render('index', ['models' => $model, 'pages' => $pagination]); }
/** 发票查询 */ public function actionSearch() { $request = Yii::$app->request; $session = Yii::$app->session; $query = $session->getFlash('query'); if ($request->isPost) { $type = $request->post('type'); $content = $request->post('content'); } else { $type = $request->get('type'); $content = trim($request->get('content')); } if ($type || !$query) { switch ($type) { case 'nickname': $table_a = Invoice::tableName(); $table_b = Users::tableName(); $query = Invoice::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(['like', "{$table_b}.nickname", $content]); break; case 'money-more': $query = Invoice::find()->Where(['>=', 'money', $content]); break; case 'money-equal': $query = Invoice::find()->where(['==', 'money', $content]); break; case 'money-less': $query = Invoice::find()->Where(['<=', 'money', $content]); break; case 'role': $role = ''; if ($content == 'a' || $content == 'A' || $content == 'A级') { $role = Users::ROLE_A; } elseif (strstr('金牌伙伴', $content)) { $role = Users::ROLE_AA; } elseif (strstr('钻石伙伴', $content)) { $role = Users::ROLE_AAA; } elseif ($content == '管理员') { $role = Users::ROLE_ADMIN; } $table_a = Invoice::tableName(); $table_b = Users::tableName(); $query = Invoice::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(["{$table_b}.role" => $role]); break; default: $query = Invoice::find()->where(['like', $type, $content]); break; } } $view = $session->getFlash('view'); if (!$view) { //非下一页 $view = $request->get('view'); //取哪个页面的搜索 if (!$view) { //不存在即为index的搜索 $view = 'index'; } } if ($view == 'apply') { //发票申请的搜索 $query->andWhere(['state' => Invoice::STATE_ING]); } elseif ($view == 'opener') { //发票开具的搜索 $query->andWhere(['state' => Invoice::STATE_PASS]); } $session->setFlash('view', $view); $session->setFlash('query', $query); $pagination = new Pagination(['defaultPageSize' => Yii::$app->params['pageSize'], 'totalCount' => $query->count()]); $models = $query->offset($pagination->offset)->limit($pagination->limit)->orderBy(['createDate' => SORT_DESC])->all(); return $this->render($view, ['models' => $models, 'pages' => $pagination]); }