FeedController.php
2.52 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
<?php
/**
* Created by PhpStorm.
* User: Alex Savenko
* Date: 05.12.2016
* Time: 18:36
*/
namespace console\controllers;
use yii\console\Controller;
use Yii;
use yii\helpers\Url;
use common\modules\product\models\Product;
use common\modules\product\models\ProductVariant;
use common\modules\product\models\Category;
use frontend\models\ProductFrontendSearch;
use common\models\Page;
use yii\filters\VerbFilter;
use yii\helpers\ArrayHelper;
use yii\web\NotFoundHttpException;
class FeedController extends Controller
{
private $idList = [];
private $count = 1;
public function getProducts() {
return Product::find()
->innerJoin(ProductVariant::tableName(), ProductVariant::tableName() .'.product_id = '. Product::tableName() .'.product_id')
->where(['and', ProductVariant::tableName().'.status = 0', ProductVariant::tableName().'.stock > 0'])
->limit(3)
->all();
}
public function createRow( $product, &$content ){
if ($this->checkId($product->product_id)) {
print $this->count++ . "\r\n";
$url = Url::to(['catalog/product', 'product' => $product]);
$content[] = [
$product->variant->product_variant_id,
$product->category->category_id,
$product->category->name,
$product->name,
$product->price.' UAH',
$product->images->imageUrl,
$url,
];
}
}
public function checkId($id){
if(!in_array($id, $this->idList)){
$this->idList[] = $id;
return true;
} else {
return false;
}
}
public function actionProcess() {
$config = ArrayHelper::merge(
require(__DIR__ . '/../../frontend/config/main.php'),
require(__DIR__ . '/../../common/config/main.php')
);
Yii::$app->urlManager->addRules($config['components']['urlManager']['rules']);
$dirName = Yii::getAlias('@frontend').'/web';
$filename = 'feed.csv';
setlocale(LC_ALL, 'ru_RU.CP1251');
$handle = fopen($dirName .'/'. $filename, "w");
$content[] = ['ID', 'ID2', 'Item Category', 'Item title', 'Price', 'Final URL', 'Image URL'];
foreach ($this->getProducts() as $product) {
$this->createRow($product, $content);
}
foreach ($content as $item) {
fputcsv($handle, $item);
}
fclose($handle);
print $dirName .'/'. $filename;
}
}