<?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()
            ->limit(1000)
            ->innerJoin(ProductVariant::tableName(), ProductVariant::tableName() .'.product_id = '. Product::tableName() .'.product_id')
            ->where(['and', ProductVariant::tableName().'.status = 0', ProductVariant::tableName().'.stock > 0'])
            ->all();
    }

    public function createRow( $product, &$content ){
        if ($this->checkId($product->product_id)) {
            print $this->count++ . "\r\n";
            $content[] = [
                $product->product_id,
                $product->category->category_id,
                $product->category->name,
                $product->name,
                $product->price.' UAH',
            ];
        }
    }

    public function checkId($id){
        if(!in_array($id, $this->idList)){
            $this->idList[] = $id;
            return true;
        } else {
            return false;
        }
    }

    public function actionProcess() {

        $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'];

        foreach ($this->getProducts() as $product) {
            $this->createRow($product, $content);
        }

        foreach ($content as $item) {
            fputcsv($handle, $item);
        }
        fclose($handle);

        print $dirName .'/'. $filename;
    }
}