public function upload()
{
if (Input::hasFile('playerfile')) {
$file = Input::file('playerfile');
$up = Excel::load($file, function ($reader) {
$results = $reader->get()->toArray();
foreach ($results as $row) {
$player_group_id = Group::where('name', 'Player')->firstOrFail();
$days = new DateTime(date('Y-m-d H:i:s', strtotime("+30 days")));
$player_account = array('email' => '', 'password' => Hash::make(''), 'confirmed' => 1, 'status' => 1, 'password_expiration_date' => $days, 'account_expiration_date' => $days, 'created_at' => new DateTime(), 'updated_at' => new DateTime());
foreach ($row as $key => $value) {
$player_account[$key] = $value;
}
try {
$add_account = User::create($player_account);
$user_member = array('user_id' => $add_account->id, 'group_id' => $player_group_id->id, 'date_created' => new DateTime());
$add_member = UserMember::create($user_member);
$player_points = array('account_id' => $add_account->id);
$add_points = Points::create($player_points);
} catch (Exception $e) {
// return false;
}
}
});
if ($up) {
$messages = 'Upload Successful.';
$status = 'success';
} else {
$messages = 'Upload failed.';
$status = 'error';
}
return Redirect::route('player.index')->with($status, $messages);
} else {
return Redirect::action('player.index')->with('error', 'Please select a Excel or CSV File.');
}
}
