/** * Run the database seeds. * * @return void */ public function run() { DB::table('Article')->delete(); $csv = new CSV(); $articles = $csv->fromFile(dirname(__FILE__) . '/csv/Article.csv')->toArray(); foreach ($articles as $a) { $content = \App\Models\ContentBase::create(["content_type" => 0]); $content->article()->create($a); } }
public function importCsv(Request $request) { $csvFile = $request->file('csv'); $fileName = str_random(10) . $csvFile->getClientOriginalName(); $csvFile->move(storage_path('uploads'), $fileName); $csv = new CSV(); $arr = $csv->fromFile(storage_path('uploads/' . $fileName), true)->toArray(); $arr = collect($arr)->map(function ($row, $k) use($request) { $row['type'] = $request->input('type'); return $row; })->toArray(); DB::table('allowed_users')->insert($arr); return redirect()->back()->with(['alert' => true, 'class' => 'success', 'message' => 'Le fichier à été importé vers la base données (table: <strong>allowed_users</strong>)']); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('UlibierPermission')->delete(); DB::table('Ulibier')->delete(); DB::table('UlibierProfile')->delete(); \App\UlibierPermission::create(array('permission_name' => 'admin')); \App\UlibierPermission::create(array('permission_name' => 'user')); $csv = new CSV(); $ulibiers = $csv->fromFile(dirname(__FILE__) . '/csv/Ulibier.csv')->toArray(); $profiles = $csv->fromFile(dirname(__FILE__) . '/csv/UlibierProfile.csv')->toArray(); for ($i = 0; $i < count($ulibiers); $i++) { $k = $ulibiers[$i]; $v = $profiles[$i]; $ulibier = new Ulibier(); $ulibier->fill($k)->setAttribute('password', bcrypt($k['password']))->save(); $ulibier->profile()->create($v); } }
/** * Store a newly created resource in storage. * * @param Destination $dest * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Destination $dest, Request $request) { $photo_url = $request->input('photo_url'); $photo_like = $request->input('photo_like', 0); $photo_csvFile = database_path('seeds/csv/Photo.csv'); $csv = new CSV(); $photo_csvContent = $csv->fromFile($photo_csvFile)->toArray(); $photo_added = array(['username' => \Auth::user()->username, 'des_id' => $dest->des_id, 'photo_like' => $photo_like, 'photo_sample_name' => $photo_url]); array_push($photo_csvContent, $photo_added); $csv->with($photo_csvContent)->put($photo_csvFile); // insert image to database $uploadtime = time(); $img_ext = pathinfo($photo_url, PATHINFO_EXTENSION) || 'jpg'; $hash = uniqid($uploadtime, true); $local_imgname = $hash . '.' . $img_ext; Storage::put('/imgtemp/' . $local_imgname, file_get_contents($photo_url)); /** @var Photo $photo */ $photo = Photo::create(array('username' => \Auth::user()->username, 'des_id' => $dest->des_id, 'photo_like' => $photo_like, 'photo_hash' => $hash, 'photo_uptime' => $uploadtime, 'photo_extensions' => $img_ext)); return response()->json($photo, 200); }