CheckPriceController.php
3.02 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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
namespace backend\controllers;
use backend\models\ImportersCheckPriceSearch;
use common\components\PriceWriter;
use common\models\DetailsCurrency;
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;
use yii\web\GoneHttpException;
use yii\web\HttpException;
use yii\web\NotFoundHttpException;
/**
* Parser controller
*/
class CheckPriceController extends BaseController
{
public $layout = "/column";
/**
* @inheritdoc
*/
public function behaviors()
{
return [
'access' => [
'class' => AccessControl::className(),
'rules' => [
[
'actions' => ['index', 'view', 'delete'],
'allow' => true,
'roles' => ['@'],
],
],
],
'verbs' => [
'class' => VerbFilter::className(),
'actions' => [
'delete ' => ['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]);
$searchModel = new ImportersCheckPriceSearch();
$provider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index',
[
'searchModel' => $searchModel,
'dataProvider' => $provider,
]);
}
public function actionView ($id, $date_update)
{
$query = DetailsCurrency::find()->where(['IMPORT_ID' => $id, 'timestamp' => $date_update])->limit(100);
$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,
]);
}
public function actionDelete ($id, $update_date)
{
$price_writer = new PriceWriter();
$price_writer->setConfiguration(['importer_id' => $id,'update_date' => $update_date]);
if ( $price_writer->deletePriceFromDB() ) {
return $this->redirect('index');
} else {
throw new NotFoundHttpException('не удалось удалить прайс из базы данных');
}
}
}