/** 我的账户 */ public function actionIndex() { $user = Yii::$app->session->get('user'); $query = IncomeConsume::find()->where(['userId' => $user['userId']])->orderBy(['createDate' => SORT_DESC]); $pagination = new Pagination(['defaultPageSize' => 20, 'totalCount' => $query->count()]); $incomeConsumes = $query->offset($pagination->offset)->limit($pagination->limit)->all(); return $this->render('index', ['incomeConsumes' => $incomeConsumes, '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() { $user = Yii::$app->session->get('user'); $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 'income-more': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME, 'userId' => $user['userId']])->andWhere(['>=', 'bitcoin', $content]); break; case 'income-equal': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME, 'userId' => $user['userId']])->andwhere(['==', 'bitcoin', $content]); break; case 'income-less': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME, 'userId' => $user['userId']])->andWhere(['<=', 'bitcoin', $content]); break; case 'consume-more': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_CONSUME, 'userId' => $user['userId']])->andWhere(['>=', 'bitcoin', $content]); break; case 'consume-equal': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_CONSUME, 'userId' => $user['userId']])->andwhere(['==', 'bitcoin', $content]); break; case 'consume-less': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_CONSUME, 'userId' => $user['userId']])->andWhere(['<=', 'bitcoin', $content]); break; default: $query = IncomeConsume::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(['createDate' => SORT_DESC])->all(); return $this->render('index', ['models' => $model, 'pages' => $pagination]); }
/** * 根据用户查询记录 * @param $userId * @return array|\yii\db\ActiveRecord[] */ public static function findByUser($userId) { return IncomeConsume::find()->where(['userId' => $userId])->orderBy(['createDate' => SORT_DESC])->all(); }
/** 云豆收支记录查询 */ 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 'usageModeName': $query = IncomeConsume::find()->where(['usageModeId' => $content]); break; case 'nickname': $table_a = IncomeConsume::tableName(); $table_b = Users::tableName(); $query = IncomeConsume::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(['like', "{$table_b}.nickname", $content]); break; case 'income-more': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME])->andWhere(['>=', 'bitcoin', $content]); break; case 'income-equal': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME])->andwhere(['==', 'bitcoin', $content]); break; case 'income-less': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_INCOME])->andWhere(['<=', 'bitcoin', $content]); break; case 'pay-more': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_CONSUME])->andWhere(['>=', 'bitcoin', $content]); break; case 'pay-equal': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_CONSUME])->andwhere(['==', 'bitcoin', $content]); break; case 'pay-less': $query = IncomeConsume::find()->where(['type' => IncomeConsume::TYPE_CONSUME])->andWhere(['<=', 'bitcoin', $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 = IncomeConsume::tableName(); $table_b = Users::tableName(); $query = IncomeConsume::find()->leftJoin($table_b, "{$table_a}.userId={$table_b}.userId")->where(["{$table_b}.role" => $role]); break; case 'type': $query = IncomeConsume::find()->where(['type' => $content]); break; default: $query = IncomeConsume::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(['incomeConsumeId' => SORT_DESC])->all(); return $this->render('index', ['models' => $model, 'pages' => $pagination]); }