lavarel console command批处理文件-CSDN博客

本文链接：https://blog.csdn.net/weixin_41865469/article/details/130623444

该文章展示了一个Laravel应用中使用phpartisan命令执行批处理操作的例子，具体是批量复制并注册商店的商品信息。通过Goods模型的chunkById方法，以每次处理10条数据的方式，高效地遍历并导入两千多条商品记录，整个过程大约耗时18分钟。

摘要由CSDN通过智能技术生成

一面板执行命令
php artisan XX
比如 php artisan command:batch_register_shop

<?php

namespace App\Console\Commands;

use App\Libraries\Error;
use App\Libraries\Mysql;
use App\Libraries\Shop;
use App\Models\WholesaleCmSupplierTemp;
use App\Services\Goods\CopyGoodsService;
use Illuminate\Console\Command;
use Monolog\Handler\RotatingFileHandler;
use Monolog\Logger;
use App\Models\MerchantsCategory;
use App\Models\Goods;
use App\Repositories\Common\BaseRepository;
class BatchRegisterShop extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'command:batch_register_shop';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '批量（ 复制商品信息等）';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        
        echo '开始：' . date('Y-m-d H:i:s');
       
       
        $cm_srv = new CopyGoodsService();
        Goods::where('user_id', 179)->whereNotIn('goods_id',$arlist)->chunkById(10, function ($goods) use ($cm_srv) {
            foreach ($goods as $good) {
                $good = $good->toArray();
                $res = $cm_srv->importData($good['goods_id'],60);
            }
        });
       
        echo '结束：' . date('Y-m-d H:i:s');
        return ;
    }
  
}

二分块处理数据

Goods::where( $w h ere) - > c h u nk B y I d (10, f u n c t i o n ($ goods) use ( $KaTeX parse error: Expected '}', got 'EOF' at end of input: \dots foreach ($ goods as $good) {
$good = $good->toArray();
$res = $cm_srv->importData($ good[‘goods_id’],60);
}
});
分块每次处理10条整体处理完两千多商品的数据导入大概用时 18分钟