public function actionIndex() { $last15days = []; $last6Month = []; $numDataOrder = []; // 订单生成数据 $numDataVolume = []; // 营业额数据 $numDataCompleted = []; // 订单完成数据 $numDataVolumeMonth = []; // 每月营业额 $today = strtotime("00:00:00"); $todayEnd = strtotime("23:59:59"); for ($i = 0; $i < 15; $i++) { $timestrap = strtotime('-' . $i . ' days', $today); $timestrapEnd = strtotime('-' . $i . ' days', $todayEnd); $where = ['and', ['store_id' => Yii::$app->user->identity->store_id], ['>=', 'created_at', $timestrap], ['<=', 'created_at', $timestrapEnd]]; array_unshift($last15days, date('m/d', $timestrap)); array_unshift($numDataOrder, Order::find()->where($where)->count()); $data = OrderVolume::find()->select(['sum(volume) AS volume', 'count(*) AS count'])->where($where)->asArray()->one(); array_unshift($numDataVolume, $data['volume']); array_unshift($numDataCompleted, $data['count']); } for ($i = 0; $i < 6; $i++) { $timestrap = strtotime("first day of -{$i} month", $today); $timestrapEnd = strtotime("last day of -{$i} month", $todayEnd); $where = ['and', ['store_id' => Yii::$app->user->identity->store_id], ['>=', 'created_at', $timestrap], ['<=', 'created_at', $timestrapEnd]]; array_unshift($last6Month, date('Y/m', $timestrap)); array_unshift($numDataVolumeMonth, OrderVolume::find()->where($where)->sum('volume')); } $data2 = OrderVolume::find()->select(['sum(volume) AS volume', 'count(*) AS count'])->where(['store_id' => Yii::$app->user->identity->store_id])->asArray()->one(); return $this->render('index', ['model' => Yii::$app->user->identity->store, 'last15days' => $last15days, 'last6Month' => $last6Month, 'numDataOrder' => $numDataOrder, 'numDataVolume' => $numDataVolume, 'numDataCompleted' => $numDataCompleted, 'numDataVolumeMonth' => $numDataVolumeMonth, 'countOrder' => Order::getCountByStoreId(Yii::$app->user->identity->store_id), 'countCompleted' => $data2['count'], 'sumVolume' => $data2['volume']]); }
</div> <div class="row"> <div class="col-lg-12"> <?php echo Alert::widget(); ?> </div> </div> <?php echo $content; ?> </div> <!-- /#page-wrapper --> </div> <!-- /#wrapper --> <audio class="audio-order hidden" controls="controls" data-count="<?php echo Order::getCountByStoreId(Yii::$app->user->identity->store_id); ?> "> <source src="<?php echo Url::base(); ?> /audio/alert.ogg" type="audio/ogg"> <source src="<?php echo Url::base(); ?> /audio/alert.mp3" type="audio/mpeg"> </audio> <?php $this->endContent();
public function actionCount() { Yii::$app->response->format = Response::FORMAT_JSON; $count = Order::getCountByStoreId(Yii::$app->user->identity->store_id); return ['count' => $count]; }