test88导入数据

2020-09-04 14:05:41 阅读:1 编辑
Artisan::command('test0904', function () {

    $file = "c:\\ok2.csv";
    $goods_list = [];
    $file = fopen($file, 'r');
    while ($data = fgetcsv($file)) {
        $goods_list[] = $data;
    }
    fclose($file);
    print_r($goods_list);

    $shop_id = 268;
    $price = 8.8;
    foreach ($goods_list as $item) {
        $phone = $item[0];
        $created_at = $item[1];
        $user = \App\User::where("phone", $phone)->first(["id"]);
        if (!$user) {
            $user = new \App\User();
            $user->phone = $phone;
            $user->password = bcrypt("123456");
            $user->save();
        }
        $buy_log = new \App\ShopBuyLog();
        $buy_log->user_id  =$user->id;
        $buy_log->shop_id = $shop_id;
        $buy_log->price = $price;
        $buy_log->order_sn = "";
        $buy_log->dist_user_id = 0;
        $buy_log->timestamps = false;
        $buy_log->created_at = $created_at;
        $buy_log->updated_at = $created_at;
        $buy_log->save();
    }
    echo "ok";
});