/** 我的账户 */
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]);
}
