public function updateRadius()
{
Capsule::transaction(function () {
Capsule::table('radcheck')->where('username', $this->user)->delete();
Capsule::table('radreply')->where('username', $this->user)->delete();
Capsule::table('radcheck')->insert($this->check);
Capsule::table('radreply')->insert($this->reply);
});
}
public function store()
{
$seven_days = 60 * 60 * 24 * 7;
$two_hours = 60 * 60 * 2;
$season = $_REQUEST['season'];
$venue_id = $_REQUEST['venue_id'];
$activity = $_REQUEST['activity'];
$lastSeasonsLeague = League::where('season', $season - 1)->where('venue_id', $venue_id)->where('activity', $activity)->first();
$lastSeasonsLastGame = Event::where('league_id', $lastSeasonsLeague->id)->where('week_num', 'Wild Card')->where('game_num', 1)->first();
$start_dt = $_REQUEST['start_dt'];
$start_dt = $start_dt ? strtotime($start_dt) : strtotime($lastSeasonsLastGame->date) + $seven_days;
$start_wk = $_REQUEST['start_wk'];
$start_wk -= 1;
$week_cnt = $_REQUEST['week_cnt'];
$game_cnt = $_REQUEST['game_cnt'];
$games_tm = $_REQUEST['games_tm'];
$games_tm = $games_tm ? strtotime($games_tm) : strtotime($lastSeasonsLastGame->time);
$events = [];
for ($i = $start_wk; $i <= $week_cnt; $i++) {
$week_num = $i == $week_cnt ? 'Wild Card' : $i + 1;
for ($j = 0; $j < $game_cnt; $j++) {
$datetime = date('Y-m-d', $start_dt + $seven_days * $i) . ' ' . date('H:i:s', $games_tm + $two_hours * $j);
$game_num = $j + 1;
$league = League::where('season', $season)->where('venue_id', $venue_id)->where('activity', $activity)->first();
if (!$league) {
$league = new League();
$league->season = $season;
$league->venue_id = $venue_id;
$league->activity = $activity;
$league->save();
}
$event = new Event();
$event->league_id = $league->id;
$event->season = $league->season;
$event->venue_id = $league->venue_id;
$event->datetime = $datetime;
$event->week_num = $week_num;
$event->game_num = $game_num;
$event->activity = $league->activity;
$events[] = $event;
}
}
try {
DB::transaction(function () use($events) {
foreach ($events as $event) {
$event->save();
}
});
$_SESSION['ALERT'] = alert('Season Added!', "Season {$season} for " . Venue::find($venue_id)->name . " was created successfully.", 'success');
} catch (Excepton $e) {
print_r($e);
exit;
$_SESSION['ALERT'] = alert('Season Not Added!', "Season {$season} for " . Venue::find($venue_id)->name . " could not be created.", 'error');
}
return redirect('/seasons');
}
public function migrate()
{
DB::transaction(function () {
$this->createCategoriesTable();
$this->createTypesTable();
$this->createDealsTable();
$this->createDealsCategoriesTable();
$this->createDealsTypesTable();
$this->createMerchantsTable();
$this->createNetworksTable();
});
}
/**
* Execute a database transaction
*
* @param callable $callback
* @param callable $errorCallback (optional)
* @return mixed
*/
protected function dbTrans(callable $callback, callable $errorCallback = null, array $errorContext = null)
{
try {
return DB::transaction($callback);
} catch (\Exception $e) {
Log::log(LogLevel::ERROR, $e->getMessage(), $errorContext);
if (!empty($errorCallback)) {
$errorCallback($e);
} else {
throw $e;
}
}
}
/**
* Index route for getting all Emojis.
*
* @param ServerRequestInterface ServerRequestInterface $request PSR-7 standard for receiving client request
* @param ResponseInterface ResponseInterface $response PSR-& standard for sending server response
*
* @return ResponseInterface HTTP response of client request
*/
public function create(ServerRequestInterface $request, ResponseInterface $response)
{
//Get Emoji data from request
$data = $request->getParsedBody();
//Extract keywords from data
$keywords = $data['keywords'];
//Decode token to get object of data
$decodedToken = Auth::decodeToken($request->getHeader('Authorization')[0], $request);
//Check if user exist with the user id
$user = User::find($decodedToken->data->uid);
//Generate emoji data to return
$emoji = ['name' => $data['name'], 'char' => $data['char'], 'category' => $data['category']];
DB::transaction(function () use($user, $emoji, $keywords) {
//Insert Emoji data into emojis table
$emoji = $user->emojis()->create($emoji);
$keywordsObj = [];
//create emoji keyword objects
foreach ($keywords as $keyword) {
$obj = new EmojiKeyword();
$obj->name = $keyword;
$keywordsObj[] = $obj;
}
//Save all keywords objects
$emoji->keywords()->saveMany($keywordsObj);
});
$response->getBody()->write(json_encode(['message' => 'Emoji created']));
return $response;
}
