<?php

namespace console\controllers;


use biz\item\classes\PtItemClass;
use biz\product\classes\ProductClass;
use biz\product\models\Product;
use yii\console\Controller;
use Yii;

class ProductController extends Controller
{

    // ./yii product/reset-cover
    public function actionResetCover()
    {
        $sql = "SELECT * FROM `" . Product::tableName() . "` WHERE cover not like '%.%'";
        $command = Yii::$app->db->createCommand($sql);
        $data = $command->queryAll();
        if (empty($data)) {
            foreach ($data as $item) {
                $id = $item['id'] ?? 0;
                $ptItemId = $item['itemId'] ?? 0;
                $ptItem = PtItemClass::getById($ptItemId, true);
                $cover = $ptItem->cover ?? '';
                ProductClass::updateById($id, ['cover' => $cover]);
                echo "productId:" . $id . " 恢复图片：" . $cover . "\n";
            }
        }
    }

}