public function post(Step2Request $request) { // if id is found, update advisor if ($advisor_id = $request->input('id')) { $advisor = Advisor::find($advisor_id); $advisor->update($request->all()); } else { // create new advisor $advisor = new Advisor($request->all()); $advisor->school_id = Session::get('school')->id; $advisor->event_id = Session::get('event')->id; $advisor->save(); } Session::set('advisor', Advisor::find($advisor->id)); if (!$request->input('other_school')) { // auto create first advisor $attendee = new Attendee(); // split up the attending advisor name $attendee_name = explode(' ', $request->input('attending_advisor')); if (is_array($attendee_name) && count($attendee_name) > 1) { $attendee->first_name = $attendee_name[0]; $attendee->last_name = $attendee_name[1]; } else { $attendee->first_name = $request->input('attending_advisor'); $attendee->last_name = ''; } $attendee->event_id = Session::get('event')->id; $attendee->school_id = Session::get('school')->id; $attendee->role_id = Role::where(['name' => 'Advisor', 'event_id' => Session::get('event')->id])->first()->id; $attendee->advisor_id = Session::get('advisor')->id; $attendee->save(); Flash::info(trans('notifications.edit_as_needed')); } return redirect('/event/' . Session::get('event')->slug . '/step/3'); }
/** * Run the database seeds. * * @return void */ public function run() { $advisor = new Advisor(); $advisor->name = 'Testing Testerman'; $advisor->email = '*****@*****.**'; $advisor->attending_advisor = 'Testie Testerman'; $advisor->comments = 'These are comments.'; $advisor->event_id = 1; $advisor->school_id = 1; $advisor->save(); $advisor = new Advisor(); $advisor->name = 'Testing Testerman 2'; $advisor->email = '*****@*****.**'; $advisor->attending_advisor = 'Testie Testerman 2'; $advisor->comments = 'These are comments.'; $advisor->event_id = 1; $advisor->school_id = 1; $advisor->save(); }
/** * Checks if first advisor for the school. */ public function shouldGetDiscount() { // has someone registered with this school already? if ($this->id == Advisor::where('school_id', $this->school->id)->orderBy('created_at', 'asc')->first()->id) { return true; } else { return false; } }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // $advisor = Advisor::find($id); $advisor->delete(); return redirect()->route('advisor.index'); }
/** * Output table data as csv. */ public function export($format = 'csv') { // grab data $data = Advisor::select('advisors.id as AdvisorID', 'advisors.created_at as RegistrationTime', 'advisors.name as AdvisorName', 'schools.name as SchoolName', 'advisors.email as AdvisorEmail', 'advisors.attending_advisor as AttAdvisorResponsible', 'advisors.comments as Comments')->leftJoin('schools', 'schools.id', '=', 'advisors.school_id')->get(); // create empty file $csv = Writer::createFromFileObject(new \SplTempFileObject()); // create header $csv->insertOne(['AdvisorID', 'RegistrationTime', 'AdvisorName', 'SchoolName', 'AdvisorEmail', 'AttAdvisorResponsible', 'Comments']); // insert rows as associative array $csv->insertAll($data->toArray()); $csv->output('advisors_' . \Carbon\Carbon::now()->timestamp . '.csv'); }
<?php $totals = \App\School::totals(Session::get('event')->id); $advisor = \App\Advisor::find(Session::get('advisor')); $total = $totals->flatten()->sum(); ?> <div class="widget stacked"> <div class="widget-header"> <i class="icon-star"></i> <h3>Invoice Summary</h3> </div> <!-- /widget-header --> <div class="widget-content"> <table class="table"> @foreach ($totals as $role => $charges) <tr> <th align="right">{{ str_plural(\App\Role::find($role)->name) }}</th> <td>{{ count($charges) }}</td> <td>x ${{ \App\Role::find($role)->cost }} =</td> <td align="right">${{ collect($charges)->sum() }}.00</td> </tr> @endforeach <tr> <th align="right">Total</th> <td colspan="3" align="right"><big><strong>${{ \App\School::total() }}.00</strong></big></td> </tr> </table> </div> </div>
public function index() { return view('step.parent', ['step' => 3, 'attendees' => Advisor::find(Session::get('advisor')->id)->attendees]); }