public function actionChannelreport()
{
$listChannel = Channel::find()->where('enabled<>0')->asArray()->all();
$startDate = strtotime(Yii::$app->request->get('startdate') . ' 00:00:00');
$endDate = strtotime(Yii::$app->request->get('enddate') . ' 23:59:59');
for ($i = 0; $i < count($listChannel); $i++) {
$baseQuery = Record::find()->andWhere(['channel_id' => $listChannel[$i]['id']]);
$baseQuery->andWhere(['>', 'created_at', $startDate]);
$baseQuery->andWhere(['<', 'created_at', $endDate]);
$tempQuery = clone $baseQuery;
$listChannel[$i]['total'] = $tempQuery->count();
$tempQuery = clone $baseQuery;
$listChannel[$i]['validcount'] = $tempQuery->andWhere(['is_valid' => 1])->count();
$tempQuery = clone $baseQuery;
$listChannel[$i]['reservecount'] = $tempQuery->andWhere(['is_reserve' => 1])->count();
$tempQuery = clone $baseQuery;
$listChannel[$i]['arrivedcount'] = $tempQuery->andWhere(['is_arrive' => 1])->count();
//消费
$totalCost = 0;
$cost = ChannelCost::find()->where('startdate>=:startdate and enddate<=:enddate and channel_id=:channel_id', [':startdate' => $startDate, ':enddate' => $endDate, ':channel_id' => $listChannel[$i]['id']])->sum('fee');
$totalCost += $cost;
//后开始还未到结束日期的费用
$channelCost = ChannelCost::find()->where('startdate>=:startdate and enddate>:enddate and channel_id=:channel_id', [':startdate' => $startDate, ':enddate' => $endDate, ':channel_id' => $listChannel[$i]['id']])->all();
foreach ($channelCost as $tmpCost) {
$days = ceil(($tmpCost['enddate'] - $tmpCost['startdate']) / 86400);
$avgCost = $tmpCost['fee'] / $days;
//平均每天费用
$days = ceil(($endDate - $tmpCost['startdate']) / 86400);
$cost = round($avgCost * $days, 2);
$totalCost += $cost;
}
//先开始提前结束的费用
$channelCost = ChannelCost::find()->where('startdate<:startdate and enddate<=:enddate and channel_id=:channel_id', [':startdate' => $startDate, ':enddate' => $endDate, ':channel_id' => $listChannel[$i]['id']])->all();
foreach ($channelCost as $tmpCost) {
$days = ceil(($tmpCost['enddate'] - $tmpCost['startdate']) / 86400);
$avgCost = $tmpCost['fee'] / $days;
$days = ceil(($tmpCost['enddate'] - $startDate) / 86400);
$cost = round($avgCost * $days, 2);
$totalCost += $cost;
}
//提前开始还未结束的费用
$channelCost = ChannelCost::find()->where('startdate<:startdate and enddate>:enddate and channel_id=:channel_id', [':startdate' => $startDate, ':enddate' => $endDate, ':channel_id' => $listChannel[$i]['id']])->all();
foreach ($channelCost as $tmpCost) {
$days = ceil(($tmpCost['enddate'] - $tmpCost['startdate']) / 86400);
$avgCost = $tmpCost['fee'] / $days;
$days = ceil(($endDate - $startDate) / 86400);
$cost = round($avgCost * $days, 2);
$totalCost += $cost;
}
$listChannel[$i]['cost'] = $totalCost;
}
return $this->renderPartial('channelreport', ['model' => $listChannel]);
}
public function actionCostlist($page = 1)
{
$query = ChannelCost::find();
$query->andFilterWhere(['channel_id' => Yii::$app->request->get('channel_id')]);
if ($startTime = strtotime(Yii::$app->request->get('startdate')) !== false) {
$startTime = strtotime(Yii::$app->request->get('startdate') . ' 00:00:00');
$query->andFilterWhere(['>=', 'startdate', $startTime]);
}
if ($endTime = strtotime(Yii::$app->request->get('enddate')) !== false) {
$endTime = strtotime(Yii::$app->request->get('enddate') . ' 23:59:59');
$query->andFilterWhere(['<=', 'enddate', $endTime]);
}
$provider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10], 'sort' => ['defaultOrder' => ['enddate' => SORT_DESC]]]);
return $this->renderPartial('costlist', ['provider' => $provider]);
}
