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];
}
