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";
});