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