public function actionPrivilege() { $investSum = InvestList::find()->where(['status' => InvestList::STATUS_PAYED, 'member_id' => wanhunet::$app->user->getId()])->joinWith(['invest' => function ($query) { /** @var \yii\db\ActiveQuery $query */ $query->andWhere(['type' => Invest::TYPE_MONEY]); }])->sum('investment_sum'); $friends = wanhunet::app()->member->findFriendIds(); $fInveset = 0; if (count($friends) > 0) { $ids = []; foreach ($friends as $id) { $ids[] = $id['id']; } $fInveset = InvestList::find()->where(['status' => InvestList::STATUS_PAYED, 'member_id' => $ids])->joinWith(['invest' => function ($query) { /** @var \yii\db\ActiveQuery $query */ $query->andWhere(['type' => Invest::TYPE_MONEY]); }])->sum('investment_sum'); } $emMaxList = AssetMoney::find()->where(['type' => AssetMoney::TYPE_EXPERIENCE_MONEY_MAX, 'user_id' => wanhunet::$app->user->getId()])->orderBy('id desc')->joinWith(['actionUid'])->limit(50)->all(); $einvestListModle = InvestList::find()->where(['status' => InvestList::STATUS_PAYED, 'member_id' => wanhunet::$app->user->getId()])->joinWith(['invest' => function ($query) { /** @var \yii\db\ActiveQuery $query */ $query->andWhere(['type' => Invest::TYPE_EXPERIENCE_MONEY]); }]); $einvestListSum = $einvestListModle->sum('interest'); $einvestList = $einvestListModle->limit(50)->orderBy('id desc')->all(); return $this->view('privilege', ['myInveset' => $investSum, 'fInveset' => $fInveset, 'emMaxList' => $emMaxList, 'einvestList' => $einvestList, 'einvestListSum' => $einvestListSum]); }
private function getList($startTime = 0, $endTime = 0) { $endTime = $endTime == 0 ? time() : $endTime; $investLists = InvestList::find()->joinWith(['member' => function ($query) { /** @var \yii\db\ActiveQuery $query */ $query->select(Member::$SELECT_ROW); }, 'invest'])->andWhere(['>=', InvestList::tableName() . '.created_at', $startTime])->andWhere(['<=', InvestList::tableName() . '.created_at', $endTime])->orderBy('id desc')->asArray()->all(); foreach ($investLists as &$investList) { $this->makeView($investList); } return $investLists; }
public function actionOwnProfit() { $member = wanhunet::app()->member; $model = InvestList::find()->where(['member_id' => $member->getId()])->andWhere(['status' => InvestList::STATUS_PAYED])->orWhere(['status' => InvestList::STATUS_ORDER_TRIAL])->orderBy('id desc')->limit(50); $eModel = clone $model; $eModel = $eModel->joinWith(['invest' => function ($query) { /** @var \yii\db\ActiveQuery $query */ $query->andWhere(['type' => Invest::TYPE_EXPERIENCE_MONEY])->orWhere(['type' => Invest::TYPE_REG]); }])->all(); $mModel = clone $model; $mModel = $mModel->joinWith(['invest' => function ($query) { /** @var \yii\db\ActiveQuery $query */ $query->andWhere(['type' => Invest::TYPE_MONEY]); }])->all(); return $this->view('own_profit', ['eModel' => $eModel, 'mModel' => $mModel, 'member' => $member]); }
public function actionSignupFinish() { try { $member = wanhunet::app()->member; $wechat_id = $member->getOtherInfo(MemberOther::TABLE_WECHAT); /** @var ShareGift $shateGift */ $shateGift = ShareGift::find()->where(['wechat_id' => $wechat_id->row])->one(); $limit = $shateGift->gift_limit; /** @var Invest $invest */ $invest = Invest::find()->where(["type" => Invest::TYPE_REG])->one(); if (InvestList::hasBuy($member->getId(), $invest->id)) { $investOrder = InvestList::find()->where(["member_id" => $member->getId()])->andWhere(['invest_id' => $invest->id])->andWhere(['status' => self::STATUS_PAYED])->one(); } else { $investOrder = new InvestList(); $investOrder->investment_sum = $limit; $investOrder->invest_id = $invest->id; $order = $invest->markOrderReg($investOrder); $investOrder->finishPay(new Event()); $shateGift->has_gift = ShareGift::HAS_GIFT; $shateGift->user_id = $member->id; $shateGift->save(); } return $this->view("signup_finish", ['info' => $investOrder]); } catch (\Exception $e) { // throw $e; return $this->redirect(Url::to(['site/signin'])); } }
<?php /** @var $invest */ $web = \wanhunet\wanhunet::getAlias('@web') . '/'; $isGuest = \wanhunet\wanhunet::$app->user->isGuest; $isEm = $invest['type'] == \modules\invest\models\Invest::TYPE_EXPERIENCE_MONEY; $investList = \modules\invest\models\InvestList::find()->where(['invest_id' => $invest['id'], \modules\invest\models\InvestList::tableName() . '.`status`' => \modules\invest\models\InvestList::STATUS_PAYED])->joinWith(["member" => function ($q) { /** @var \yii\db\ActiveQuery $q */ $q->select(\modules\member\models\Member::$SELECT_ROW); }])->asArray()->orderBy("id desc")->limit(10)->all(); $sum = $invest['orderSum']['10'] + $invest['orderSum']['20']; $sheng = $invest['amount'] - $sum; if ($sheng <= 0) { $investListCount = \modules\invest\models\InvestList::find()->where(['invest_id' => $invest['id'], \modules\invest\models\InvestList::tableName() . '.`status`' => \modules\invest\models\InvestList::STATUS_PAYED])->count(); $investListLast = \modules\invest\models\InvestList::find()->where(['invest_id' => $invest['id'], \modules\invest\models\InvestList::tableName() . '.`status`' => \modules\invest\models\InvestList::STATUS_PAYED])->asArray()->orderBy("id desc")->one(); $shouqingshijian = \wanhunet\helpers\Utils::timeCut($investListLast['pay_time'], $invest['buy_time_start']); } ?> <style type="text/css"> @media screen and (min-width: 320px) body { font-size: 16px ; } body { color: #3a3a3a; font-family: "Helvetica";