<?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)) {
            return false;
        }
        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";
        }
    }

}