mirror of
https://github.com/janickiy/yii2-nomer
synced 2025-03-09 15:39:59 +00:00
319 lines
13 KiB
PHP
319 lines
13 KiB
PHP
<?php
|
||
|
||
/* @var $this \yii\web\View */
|
||
/* @var $model \app\models\forms\AdminHistoryFilterForm */
|
||
/* @var $dataProvider \yii\data\ActiveDataProvider */
|
||
/* @var $queries array */
|
||
/* @var $users array */
|
||
/* @var $phones integer */
|
||
/* @var $sources array */
|
||
/* @var $sites array */
|
||
/* @var $requests array */
|
||
/* @var $sitesData array */
|
||
/* @var $searches array */
|
||
/* @var $payments array */
|
||
|
||
use app\models\Payment;
|
||
use yii\grid\GridView;
|
||
use yii\helpers\Json;
|
||
use yii\helpers\Url;
|
||
use yii\jui\DatePicker;
|
||
use yii\helpers\ArrayHelper;
|
||
use yii\helpers\Html;
|
||
use yii\widgets\ActiveForm;
|
||
use app\components\SearchHelper;
|
||
use app\models\SearchRequest;
|
||
use app\models\RequestResult;
|
||
use app\models\ResultCache;
|
||
|
||
$this->title = 'История поиска';
|
||
|
||
$sources = ArrayHelper::map($sources, "source_id", "count");
|
||
|
||
$freeNothing = SearchRequest::find()
|
||
->where(["is_payed" => 0, "is_has_name" => false, "is_has_photo" => false])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->andWhere(['or', ['users.is_admin' => false], ['users.is_admin' => null]])
|
||
->joinWith(['user'])
|
||
->count(1);
|
||
$freeAll = SearchRequest::find()
|
||
->where(["is_payed" => 0, "is_has_name" => true, "is_has_photo" => true])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->andWhere(['or', ['users.is_admin' => false], ['users.is_admin' => null]])
|
||
->joinWith(['user'])
|
||
->count(1);
|
||
$freeOnlyName = SearchRequest::find()
|
||
->where(["is_payed" => 0, "is_has_name" => true, "is_has_photo" => false])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->andWhere(['or', ['users.is_admin' => false], ['users.is_admin' => null]])
|
||
->joinWith(['user'])
|
||
->count(1);
|
||
$payed = SearchRequest::find()
|
||
->where(["is_payed" => 1])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->andWhere(['or', ['users.is_admin' => false], ['users.is_admin' => null]])
|
||
->joinWith(['user'])
|
||
->count(1);
|
||
$payedNothing = SearchRequest::find()
|
||
->where(["is_payed" => 2])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->andWhere(['or', ['users.is_admin' => false], ['users.is_admin' => null]])
|
||
->joinWith(['user'])
|
||
->count(1);
|
||
$anonymous = SearchRequest::find()
|
||
->where(["user_id" => null])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->count(1);
|
||
$regged = SearchRequest::find()
|
||
->where(["is_payed" => 0])
|
||
->andWhere(["is not", "user_id", null])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->count(1);
|
||
|
||
$androidSearches = SearchRequest::find()
|
||
->where(["source_id" => SearchRequest::SOURCE_ANDROID])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->count(1);
|
||
|
||
$androidSearchesPayed = SearchRequest::find()
|
||
->where(["source_id" => SearchRequest::SOURCE_ANDROID])
|
||
->andWhere(["is_payed" => 1])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->count(1);
|
||
|
||
$androidPayments = Payment::find()->where([">=", "tm", date("Y-m-d H:i:s", strtotime("-30 days"))])->andWhere(["type_id" => Payment::TYPE_ANDROID])->sum('amount');
|
||
$androidSearches30days = SearchRequest::find()->where([">=", "tm", date("Y-m-d H:i:s", strtotime("-30 days"))])->andWhere(["source_id" => SearchRequest::SOURCE_ANDROID])->count(1);
|
||
|
||
$appleSearches = SearchRequest::find()
|
||
->where(["source_id" => SearchRequest::SOURCE_IOS])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->count(1);
|
||
|
||
$appleSearchesPayed = SearchRequest::find()
|
||
->where(["source_id" => SearchRequest::SOURCE_IOS])
|
||
->andWhere(["is_payed" => 1])
|
||
->andWhere([">=", "tm", $model->from." 00:00:00"])
|
||
->andWhere(["<=", "tm", $model->to." 23:59:59"])
|
||
->count(1);
|
||
|
||
$applePayments = Payment::find()->where([">=", "tm", date("Y-m-d H:i:s", strtotime("-30 days"))])->andWhere(["type_id" => Payment::TYPE_APPLE])->sum('amount');
|
||
$appleSearches30days = SearchRequest::find()->where([">=", "tm", date("Y-m-d H:i:s", strtotime("-30 days"))])->andWhere(["source_id" => SearchRequest::SOURCE_IOS])->count(1);
|
||
?>
|
||
|
||
<div class="portlet light bordered">
|
||
<div class="portlet-title">
|
||
<div class="caption">Фильтры</div>
|
||
</div>
|
||
<div class="portlet-body form">
|
||
|
||
<?php $form = ActiveForm::begin(['method' => 'GET', 'action' => '/admin/history']); ?>
|
||
|
||
<div class="input-group input-medium">
|
||
<span class="input-group-addon">С</span>
|
||
<?= $form->field($model, 'from', ['template' => '{input}', 'options' => ['class' => '']])->textInput()->widget(DatePicker::className(), [
|
||
'language' => 'ru',
|
||
'dateFormat' => 'yyyy-MM-dd',
|
||
'options' => ['class' => 'form-control input-small']
|
||
]) ?>
|
||
<span class="input-group-addon">по</span>
|
||
<?= $form->field($model, 'to', ['template' => '{input}', 'options' => ['class' => '']])->widget(DatePicker::className(), [
|
||
'language' => 'ru',
|
||
'dateFormat' => 'yyyy-MM-dd',
|
||
'options' => ['class' => 'form-control input-small']
|
||
]) ?>
|
||
<?= $form->field($model, 'user', ['template' => '{input}', 'options' => ['class' => '']])->hiddenInput()->label(false) ?>
|
||
<span class="input-group-addon"></span>
|
||
<?= Html::submitButton('Показать', ['class' => 'form-control btn btn-primary input-small']) ?>
|
||
</div>
|
||
|
||
<?php ActiveForm::end(); ?>
|
||
|
||
</div>
|
||
</div>
|
||
|
||
<hr>
|
||
|
||
<div class="row">
|
||
<?php /*
|
||
<div class="col-md-4">
|
||
<table class="table table-striped table-bordered">
|
||
<?php foreach ($queries as $query): ?>
|
||
<tr>
|
||
<th><?= $query['registred'] ? 'Зарегистрированные' : 'Анонимные' ?></th>
|
||
<td><?= $query['count'] ?></td>
|
||
</tr>
|
||
<?php endforeach; ?>
|
||
<?php if (count($users) > 0): ?>
|
||
<tr>
|
||
<th>Сконвертировавшиеся пользователи</th>
|
||
<td><?= $users[0]['count'] ?></td>
|
||
</tr>
|
||
<?php endif; ?>
|
||
<tr>
|
||
<th>Количество уникальных номеров</th>
|
||
<td><?= $phones ?></td>
|
||
</tr>
|
||
</table>
|
||
</div>
|
||
<div class="col-md-4">
|
||
<table class="table table-striped table-bordered">
|
||
<tr>
|
||
<th><?=Html::a("бесплатные - анонимные", Url::current(["type" => 7]));?></th>
|
||
<td><?=$anonymous;?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?=Html::a("бесплатные - зареганные", Url::current(["type" => 8]));?></th>
|
||
<td><?=$regged;?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?=Html::a("бесплатные - ничего не найдено", Url::current(["type" => 1]));?></th>
|
||
<td><?=$freeNothing;?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?=Html::a("бесплатные - имя и фото", Url::current(["type" => 2]));?></th>
|
||
<td><?=$freeAll;?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?=Html::a("бесплатные - только имя", Url::current(["type" => 3]));?></th>
|
||
<td><?=$freeOnlyName;?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?=Html::a("платных запросов", Url::current(["type" => 4]));?></th>
|
||
<td><?=($payedNothing + $payed);?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?=Html::a("платные - ничего не найдено", Url::current(["type" => 5]));?></th>
|
||
<td><?=$payedNothing;?></td>
|
||
</tr>
|
||
<tr>
|
||
<th><?=Html::a("платные - найдено", Url::current(["type" => 6]));?></th>
|
||
<td><?=$payed;?></td>
|
||
</tr>
|
||
</table>
|
||
</div>
|
||
*/ ?>
|
||
<div class="col-md-12">
|
||
<table class="table table-striped table-bordered">
|
||
<tr>
|
||
<th colspan="3">Кол-во поисков</th>
|
||
</tr>
|
||
<tr>
|
||
<th>Сайт</th>
|
||
<th>Web (платные)</th>
|
||
<th>Mobile (платные)</th>
|
||
<th>Поиски (за 30 дн)</th>
|
||
<th>Платежи (за 30 дн)</th>
|
||
</tr>
|
||
<?php foreach ($sitesData as $siteID => $data): if(!$siteID) continue; ?>
|
||
<tr>
|
||
<th><?= Html::a($sites[$siteID]["name"], Url::current(["site_id" => $siteID])) ?> <?=$sites[$siteID]["comment"]?"(".$sites[$siteID]["comment"].")":"";?></th>
|
||
<td><?= (ArrayHelper::getValue($data, [SearchRequest::SOURCE_WEB, 0], 0) + ArrayHelper::getValue($data, [SearchRequest::SOURCE_WEB, 1], 0)) ?> (<?= ArrayHelper::getValue($data, [SearchRequest::SOURCE_WEB, 1], 0) ?>)</td>
|
||
<td><?= (ArrayHelper::getValue($data, [SearchRequest::SOURCE_MOBILE, 0], 0) + ArrayHelper::getValue($data, [SearchRequest::SOURCE_MOBILE, 1], 0)) ?> (<?= ArrayHelper::getValue($data, [SearchRequest::SOURCE_MOBILE, 1], 0) ?>)</td>
|
||
<td><?=ArrayHelper::getValue($searches, [$siteID, "count"]);?></td>
|
||
<td><?=\Yii::$app->formatter->asCurrency(ArrayHelper::getValue($payments, [$siteID, "sum"]), "RUB");?></td>
|
||
</tr>
|
||
<?php endforeach; ?>
|
||
<tr>
|
||
<th>Android</th>
|
||
<td colspan="2"><?=$androidSearches;?> (<?=$androidSearchesPayed;?>)</td>
|
||
<td><?=$androidSearches30days;?></td>
|
||
<td><?=\Yii::$app->formatter->asCurrency($androidPayments, 'RUB');?></td>
|
||
</tr>
|
||
<tr>
|
||
<th>Apple</th>
|
||
<td colspan="2"><?=$appleSearches;?> (<?=$appleSearchesPayed;?>)</td>
|
||
<td><?=$appleSearches30days;?></td>
|
||
<td><?=\Yii::$app->formatter->asCurrency($applePayments, 'RUB');?></td>
|
||
</tr>
|
||
<tr>
|
||
<th>Всего: </th>
|
||
<td><?= $sources[SearchRequest::SOURCE_WEB];?></td>
|
||
<td><?= $sources[SearchRequest::SOURCE_MOBILE];?></td>
|
||
</tr>
|
||
</table>
|
||
</div>
|
||
</div>
|
||
|
||
<?= GridView::widget([
|
||
'dataProvider' => $dataProvider,
|
||
'columns' => [
|
||
'tm',
|
||
[
|
||
'format' => 'raw',
|
||
'attribute' => 'phone',
|
||
'value' => function(SearchRequest $model) {
|
||
$phone = preg_replace('/^7/', '8', $model->phone);
|
||
return '<a href="/' . $phone . '">' . $phone . '</a>';
|
||
}
|
||
],
|
||
[
|
||
'attribute' => 'user_id',
|
||
'format' => 'raw',
|
||
'value' => function(SearchRequest $model) {
|
||
if (!$model->user) return 'Аноним';
|
||
return Html::a(trim($model->user->email)?$model->user->email:$model->user->uuid, ['users/view', 'id' => $model->user_id]);
|
||
}
|
||
],
|
||
[
|
||
'attribute' => 'ip',
|
||
'value' => function(SearchRequest $model) {
|
||
return join(', ', [$model->ip, SearchHelper::City($model->ip)]);
|
||
}
|
||
],
|
||
[
|
||
'header' => 'Индекс поиска',
|
||
'value' => function(SearchRequest $model) {
|
||
if ($model->is_payed) {
|
||
return array_sum(array_map(function(RequestResult $result) {
|
||
return $result->index;
|
||
}, $model->results));
|
||
}
|
||
|
||
$finds = [];
|
||
if ($model->is_has_name) $finds[] = 'Имя';
|
||
if ($model->is_has_photo) $finds[] = 'Фото';
|
||
|
||
return $finds ? join(', ', $finds) : 'Ничего не найдено';
|
||
}
|
||
],
|
||
[
|
||
'header' => 'Стоимость',
|
||
'value' => function(SearchRequest $model) {
|
||
$type = '';
|
||
|
||
switch ($model->is_payed) {
|
||
case 0: $type = 'Бесплатный (нет проверок)'; break;
|
||
case 1: $type = 'Платный'; break;
|
||
case 2: $type = 'Бесплатный (не нашли)'; break;
|
||
}
|
||
|
||
if (!$model->user_id) $type .= ', Аноним';
|
||
|
||
return $type;
|
||
}
|
||
],
|
||
[
|
||
'attribute' => 'source_id',
|
||
'value' => function(SearchRequest $model) {
|
||
return SearchRequest::getSourceText($model->source_id);
|
||
}
|
||
],
|
||
[
|
||
'attribute' => 'site_id',
|
||
'value' => function(SearchRequest $model) {
|
||
if (!$model->site) return null;
|
||
return $model->site->name;
|
||
}
|
||
]
|
||
]
|
||
]) ?>
|