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