Open sidebar
$csv = Reader::createFromPath($destinationPath . '' . $fileupdate); $keys = ['category_id', 'position_id', 'squ', 'orig_number', 'title', 'price', 'ostatok']; // $csv->setDelimiter(';'); $csv->setOffset(1); $results = $csv->fetchAssoc($keys); // $prov = new Catalog(); foreach ($results as $row) { $cat = explode('\\', $row['category_id']); $last = last($cat); $orig_number =$row['orig_number']; // проверяю на наличие в базе $prov = Catalog::firstOrNew(['orig_number'=> $orig_number]); // dd($prov); if ($prov->exists) { print_r('1'); $update = Catalog::where('orig_number', $row['orig_number']); $update->price = $row['price']; $update->ostatok = $row['ostatok']; $update->save(); } else { print_r('2'); $update = new Catalog(); $update->category_id = $last; $update->position_id = $row['position_id']; $update->squ = $row['squ']; $update->orig_number = $row['orig_number']; $update->title = $row['title']; $update->price = $row['price']; $update->ostatok = $row['ostatok']; $update->save(); } }
Close sidebar
Back
Please note that all pasted data is publicly available.
Twitter
GitHub
Use setting
Back
Please note that all pasted data is publicly available.
Twitter
GitHub
Use setting