/** * */ public function import(Request $request) { Excel::filter('chunk')->load($request->only('file')['file'], 'UTF-8')->chunk(100, function ($language) { // Loop through all rows $language->each(function ($row) { $default = Locale::find(1); $locales = Locale::lists('id', 'name'); $langs = []; foreach ($row as $lang => $translation) { if (array_key_exists(ucfirst($lang), $locales->toArray())) { // if imported lang exist $ilang_id = $locales[ucfirst($lang)]; // if ($ilang_id == $default->id) { $langs[ucfirst($lang)]['translation'] = $translation; $langs[ucfirst($lang)]['id'] = $ilang_id; } else { $langs['child'][ucfirst($lang)]['translation'] = $translation; $langs['child'][ucfirst($lang)]['id'] = $ilang_id; } } } $new_trans = LocaleTranslation::firstOrNew(['locale_id' => $langs[$default->name]['id'], 'translation' => $langs[$default->name]['translation']]); $new_trans->save(); foreach ($langs['child'] as $cland => $ctrans) { $new_ctrans = LocaleTranslation::firstOrNew(['locale_id' => $ctrans['id'], 'translation_id' => $new_trans->id]); $new_ctrans->translation = $ctrans['translation']; $new_ctrans->save(); } }); }); return redirect()->route('admin.language.index')->withFlashSuccess('Imported'); }