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; }
<?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";