CheckPriceController.php
2.46 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
<?php
namespace backend\controllers;
use Yii;
use yii\bootstrap\Modal;
use yii\data\ActiveDataProvider;
use yii\filters\AccessControl;
use backend\components\base\BaseController;
use yii\filters\VerbFilter;
use backend\models\Details;
use backend\models\ImportersFiles;
use backend\models\Importers;
use yii\base\ErrorException;
use common\components\CustomVarDamp;
/**
* Parser controller
*/
class CheckPriceController extends BaseController
{
public $layout = "/column";
/**
* @inheritdoc
*/
public function behaviors()
{
return [
'access' => [
'class' => AccessControl::className(),
'rules' => [
[
'actions' => ['index', 'view'],
'allow' => true,
'roles' => ['@'],
],
],
],
// 'verbs' => [
// 'class' => VerbFilter::className(),
// 'actions' => [
// 'logout' => ['post'],
// ],
// ],
];
}
/**
* @inheritdoc
*/
public function actions()
{
return [
'error' => [
'class' => 'yii\web\ErrorAction',
],
];
}
public function actionIndex()
{
//$query = (new Query())->select('*')->from('{{%importer_files}}')->where(['not', ['time_end' => null]])->orderBy(['upload_time' => SORT_DESC]);
$query = Importers::find()->where(['active' => true])->orderBy(['price_date_update' => SORT_DESC]);
$provider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'pageSize' => 10,
],
]);
return $this->render('index',
[
'dataProvider' => $provider,
]);
}
public function actionView ($id, $date_update)
{
$query = Details::find()->where(['IMPORT_ID' => $id, 'timestamp' => $date_update])->limit(20);
$importer = Importers::findOne($id)->name;
$date = Yii::$app->formatter->asDate( $date_update, 'yyyy-MM-dd' );
$provider = new ActiveDataProvider([
'query' => $query,
'pagination' => false,
'sort' => false,
]);
return $this->renderAjax('view',
['dataProvider' => $provider,
'importer' => $importer,
'date' => $date,
]);
}
}