ProductController.php 448 B

123456789101112131415161718192021
  1. <?php
  2. namespace console\controllers;
  3. use biz\product\models\Product;
  4. use yii\console\Controller;
  5. use Yii;
  6. class ProductController extends Controller
  7. {
  8. // ./yii product/reset-cover
  9. public function actionResetCover()
  10. {
  11. $sql = "SELECT * FROM `" . Product::tableName() . "` WHERE cover not like '%.%'";
  12. $command = Yii::$app->db->createCommand($sql);
  13. $data = $command->queryAll();
  14. print_r($data);
  15. }
  16. }