/**
* @param $id
* @return mixed
*/
public function show($id)
{
$user = User::find($id);
if (!$user) {
return $this->respondNotFound('User does not exist.');
}
return $this->respond(['data' => $this->userTransformer->transform($user)]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
User::create(['first_name' => 'Maciej', 'last_name' => 'Sularz', 'phone_number' => '07586750240', 'email' => '*****@*****.**', 'password' => '$2y$10$Rsh78/ok4aIcIOQKJImFk.8XWhkVDy8/wG/wmI768eNdjg8Rjk7da', 'date_of_birth' => '1987-07-24', 'club_id' => 3, 'role_id' => 1]);
User::create(['first_name' => 'Owen', 'last_name' => 'Mallia', 'phone_number' => '07891498023', 'email' => '*****@*****.**', 'password' => '$2y$10$zMXsEEyhcMHvGSX.Biz.nOcF94XgGVf3CY7vanEkLYeAOrjwbdr8G', 'club_id' => 3, 'role_id' => 1]);
User::create(['first_name' => 'Rob', 'last_name' => 'Miller', 'phone_number' => '07879681414', 'email' => '*****@*****.**', 'password' => '$2y$10$/BEWocGuz8crDuI4uHwhX.Dr1b9WaDPTt3OVg.19mwECSPtlr5SOa', 'club_id' => 3, 'role_id' => 1]);
foreach (range(4, 30) as $index) {
User::create(['first_name' => $faker->firstName(), 'last_name' => $faker->lastName(), 'email' => $faker->email(), 'phone_number' => "07586750249", 'password' => bcrypt('password'), 'date_of_birth' => $faker->date(), 'club_id' => $faker->numberBetween(1, 5), 'role_id' => $faker->numberBetween(3, 5)]);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
$teamIds = Team::lists('id')->toArray();
$userIds = User::lists('id')->toArray();
$eventId = Event::current()->id;
foreach ($teamIds as $teamId) {
for ($i = 1; $i <= $faker->numberBetween(2, floor(count($userIds) / count($teamIds))); $i++) {
DB::table('users_pivot_team_user')->insert(['team_id' => $teamId, 'user_id' => $faker->unique()->randomElement($userIds), 'event_id' => $eventId]);
}
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$numberOfLoopPasses = 20;
$faker = Faker\Factory::create();
$userIds = User::lists('id')->toArray();
foreach ($userIds as $userId) {
for ($i = 1; $i <= $faker->numberBetween(0, 2); $i++) {
Boat::create(['name' => $faker->words($faker->numberBetween(1, 3), true), 'charter' => $faker->numberBetween(0, 1), 'user_id' => $userId]);
}
// Stop the loop after certain amount of passes.
if (--$numberOfLoopPasses == 0) {
break;
}
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = Faker\Factory::create();
$userIds = User::lists('id')->toArray();
$categoryIds = Category::lists('id')->toArray();
foreach ($userIds as $userId) {
$categories = $faker->randomElements($categoryIds, $faker->numberBetween(0, count($categoryIds)));
// Skip rest of the loop if $categories empty
if (empty($categories)) {
continue;
}
foreach ($categories as $categoryId) {
DB::table('users_pivot_category_user')->insert(['user_id' => $userId, 'category_id' => $categoryId]);
}
}
}
/**
* Store a newly created resource in storage.
*
* @param WeighInsRequest|Request $request
* @return \Illuminate\Http\Response
*/
public function store(WeighInsRequest $request)
{
// TODO: extract this as it is also used in weigh ins request
// Clear up the entries
$request['entries'] = array_filter(array_map(function ($entry) {
return array_filter($entry);
}, $request['entries']));
// If any exceptions are thrown any DB operations
// will be automatically rolled back.
DB::transaction(function () use($request) {
$weighIn = new WeighIn();
// Deal with boat section
if (!empty($request['boat']) && !empty($request['boat']['name'])) {
if (isset($request['boat']['id'])) {
// assign a boat to the weigh-in
$boat = Boat::findOrFail($request['boat']['id']);
} else {
// create a new boat
$boat = new Boat();
$boat->name = $request['boat']['name'];
$boat->charter = isset($request['boat']['charter']) ? true : false;
if (!empty($request['boat']['skipper']['id'])) {
$boat->skipper()->associate(User::find($request['boat']['skipper']['id']));
}
$boat->save();
}
$weighIn->boat()->associate($boat);
}
// TODO: discuss with Rob if it makes sense
// if(!empty($request['team_id'])){
// $weighIn->team()->associate(Team::find($request['team_id']));
// }
$weighIn->date = $request['date'];
$weighIn->entry_ticket_number = $request['entry_ticket_number'];
$weighIn->sheet_number = $request['sheet_number'];
$weighIn->team_number = !empty($request['team_number']) ? $request['team_number'] : null;
$weighIn->event()->associate(Event::find($request['event_id']));
$weighIn->site()->associate(Site::find($request['weigh_in_site_id']));
$weighIn->user()->associate(User::find($request['user_id']));
$weighIn->save();
foreach ($request['entries'] as $e) {
$entry = new Entry();
$entry->weight = Helpers::toDrams($e['species_weight']);
$entry->percentage = Weight::calculatePercentage($e['species_id'], $e['sector_id'], $e['species_weight']);
$entry->sector()->associate(Sector::find($e['sector_id']));
$entry->location()->associate(Location::find($e['location_id']));
$entry->event()->associate(Event::find($request['event_id']));
$entry->species()->associate(Species::find($e['species_id']));
$entry->user()->associate(User::find($request['user_id']));
$entry->weighIn()->associate($weighIn);
$entry->save();
if (isset($e['categories'])) {
$categories = [];
foreach ($e['categories'] as $catId) {
$categories[$catId] = ['event_id' => (int) $request['event_id']];
}
$entry->categories()->sync($categories);
}
}
//dd($request);
});
flash()->success('Success!', "New weigh-in has been created!");
return redirect(route('admin.weigh-ins.create'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$anglers = User::all();
$localClubs = Helpers::getUserClubs();
return view('admin.pages.anglers.index', compact('anglers', 'localClubs'));
}
public function index()
{
$skippers = User::with(['boats'])->has('boats')->get();
return $this->respond(['data' => $this->skipperTransformer->transformCollection($skippers->all())]);
}
public function profile()
{
$user = User::findOrFail(Auth::user()->id);
$userRoles = Helpers::getUserRoles();
return view('admin.pages.settings.profile', compact('user', 'userRoles'));
}
/**
* Update the specified resource in storage.
*
* @param Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
// Fetch the edited specie from the database
$boat = Boat::findOrFail($id);
DB::transaction(function () use($request, $boat) {
// Update the fields
$boat->name = $request['name'];
$boat->charter = $request['charter'];
if (!empty($request['user_id'])) {
$boat->skipper()->associate(User::findOrFail($request['user_id']));
} else {
if (!is_null($boat->skipper)) {
$boat->user_id = null;
}
}
$boat->save();
});
flash()->success('Success!', "Boat data has been updated!");
return redirect(route('admin.boats.index'));
}
public function anglers()
{
$event = Event::current();
$users = User::with(['categories', 'club'])->whereHas('weighIns', function ($query) use($event) {
$query->where('event_id', '=', $event->id);
})->get()->transform(function ($v) use($event) {
$categories = null;
if (!is_null($v->categories)) {
foreach ($v->categories as $cat) {
$categories[] = ['id' => $cat['id'], 'name' => $cat['name']];
}
}
$bestFish = Entry::with('species')->where('user_id', '=', $v['id'])->where('event_id', '=', $event->id)->orderBy('percentage', 'desc')->select('percentage', 'weight', 'species_id')->first();
return ['id' => $v['id'], 'fullName' => $v['last_name'] . ' ' . $v['first_name'], 'categories' => $categories, 'club' => ['id' => $v['club']['id'], 'name' => $v['club']['name']], 'fishCount' => Entry::where('user_id', '=', $v['id'])->where('event_id', '=', $event->id)->get()->count(), 'bestFish' => ['name' => $bestFish['species']['name'], 'weight' => Helpers::fromDrams($bestFish['weight']), 'percentage' => round($bestFish['percentage']) . "%"]];
})->toArray();
return $this->respond(['data' => $users ?: null]);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
// Fetch user object from the database
$user = User::findOrFail($id);
// Store users full name
$userName = "******";
// If user has avatar delete the file.
if (!is_null($user->avatar->name)) {
$avatarFile = public_path() . '\\avatars\\' . $user->avatar->name;
if (File::exists($avatarFile)) {
File::delete($avatarFile);
}
}
// Delete user from DB
$user->delete();
flash()->overlay('Success!', "Angler {$userName} has been deleted!", 'success');
return redirect(route('admin.users.index'));
}
