/**
*
*/
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');
}
