public function getList(Request $request) { $data = []; $data += [0 => '-- Selecciona Estado --']; $data += State::where('country_id', $request->country_id)->lists('name', 'id')->toArray(); return $data; }
/** * Display a listing of the resource. * * @return Response */ public function state(Request $request) { if ($request->ajax()) { $state = State::where('company_id', Auth::user()->company_id)->where('account_year_id', session('account'))->find($request->get('state'))->district()->orderBy('name')->lists('name', 'id'); return $state; } }
public function ajax(Request $request) { if ($request->mode === 'update') { $states = State::find($request->id); if ($states->state === 1) { $states->state = 0; } else { $states->state = 1; } $states->save(); $state = State::where('id', $request->id)->first(); return response()->json(['state' => $state->state, 'title' => $state->title]); } if ($request->mode === 'create') { if ($request->title) { $states = new State(); $states->title = $request->title; $states->save(); return response()->json(['id' => $states->id]); } } if ($request->mode === 'delete') { $states = State::find($request->id); $states->delete(); } }
public function location() { $query = \Input::get('l', ''); if (trim(urldecode($query)) == '') { return \Response::json(['data' => []], 200); } $lga = \App\Lga::where('name', 'like', '%' . $query . '%')->orderBy('name', 'asc')->take(10)->get(['id', 'name'])->toArray(); $state = \App\State::where('name', 'like', '%' . $query . '%')->orderBy('name', 'asc')->take(5)->get(['id', 'name'])->toArray(); $data = array_merge($lga, $state); return \Response::json(['data' => $data]); }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(LocationCreateRequest $request) { $state = $request->input('state'); if (!($existingState = State::where('id', $state)->first())) { $newState = new State(); $newState->name = $state; $newState->save(); } $locs = $request->input('lga'); foreach ($locs as $loc) { $area = new Lga(); $area->name = $loc; $area->state_id = $newState->id; $area->save(); } return redirect('/admin/location')->withSuccess("Area created."); }
public function __construct(Branch $branch, State $state, District $district) { $this->branch = $branch->where('company_id', Auth::user()->company_id)->where('account_year_id', session('account')); $this->district = $district->where('company_id', Auth::user()->company_id)->where('account_year_id', session('account')); $this->state = $state->where('company_id', Auth::user()->company_id)->where('account_year_id', session('account')); }
public function getResource($resource) { if (is_string($resource)) { if ('amount' == $resource) { $country_code = Input::get('country_code'); $mem_period = Input::get('mem_period'); // hard coding the currency ID to query payment-heads if ('IND' == $country_code) { $currency_id = 1; } else { $currency_id = 2; } Log::info('In getResource: ' . $country_code . $mem_period); $head = PaymentHead::getHead($mem_period, $currency_id)->first(); $data = ['amount' => $head->amount, 'service_tax' => ServiceTaxClass::find($head->service_tax_class_id)->tax_rate]; } else { if ('states' == $resource) { $country_code = Input::get('code'); Log::info('In getResource for states: ' . $country_code); // querying with states of india and not regions > states; $states = State::where('country_code', 'like', $country_code)->orderBy('name', 'asc')->get(['state_code', 'name'])->toarray(); Log::info('In getResource for states: typeof ' . gettype($states)); $data = $states; } else { if ('branches' == $resource) { $state_code = Input::get('code'); Log::info('In getResource for branches: ' . $state_code); $chapters = CsiChapter::where('csi_state_code', $state_code)->get(); $collection = new \Illuminate\Database\Eloquent\Collection(); $result = new \Illuminate\Database\Eloquent\Collection(); foreach ($chapters as $chapter) { $members = Member::where('csi_chapter_id', $chapter->id)->get(); if (!$members->isEmpty()) { $collection = $members->filter(function ($item) { $curr = $item->subType; if ($curr->membership_type_id == 1) { if ($curr->subType->is_student_branch) { return $item; } } }); } } foreach ($collection as $member) { $arr = []; $arr['member_id'] = $member->subType->id; $arr['name'] = $member->subType->name; $result->add($arr); } $data = $result->sortBy('name')->toarray(); } else { if ('chapters' == $resource) { $state_code = Input::get('code'); Log::info('In getResource for chapters: ' . $state_code); $chapters = CsiChapter::where('csi_state_code', $state_code)->orderBy('name', 'asc')->get(['id', 'name'])->toarray(); Log::info('In getResource for chapters: typeof ' . gettype($chapters)); $data = $chapters; } else { if ('institutions' == $resource) { } } } } } $response = Response::json($data, 200); } else { $response = Response::json(array('errors' => $e->getMessage()), 500); } return $response; }
/** * Remove a State from storage * @param $id * @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector */ public function destroyState($id) { State::where('id', $id)->delete(); Session::flash('success_message', 'State has been deleted from database'); return redirect('config'); }
public static function getBannerSearchData($user_config) { if ($user_config['name'] != '' && $user_config['city'] != '' && $user_config['state'] != '' && $user_config['zip'] != '') { $result['city'] = \App\City::where('city', 'LIKE', $user_config['city'] . '%')->pluck('id'); $result['state'] = \App\State::where('state', 'LIKE', $user_config['state'] . '%')->pluck('id'); $result_set = Restaurants::where('name', 'LIKE', $user_config['name'] . '%')->where('state_id', $result['state'])->where('city_id', $result['city'])->where('zip', $user_config['zip'])->get(); return $result_set; } else { if ($user_config['name'] != '' || $user_config['city'] != '' || $user_config['state'] != '' || $user_config['zip'] != '') { if ($user_config['name'] != '') { $result_set = Restaurants::where('name', 'LIKE', $user_config['name'] . '%')->get(); return $result_set; } else { if ($user_config['city'] != '') { $result = \App\City::where('city', 'LIKE', $user_config['city'] . '%')->pluck('id'); $result_set = Restaurants::where('city_id', $result)->get(); return $result_set; } else { if ($user_config['name'] != '' && $user_config['city'] != '') { $result = \App\City::where('city', 'LIKE', $user_config['city'] . '%')->pluck('id'); $result_set = Restaurants::where('city_id', $result)->where('name', 'LIKE', $user_config['name'] . '%')->get(); return $result_set; } else { return false; } } } } } }
public function __construct(State $state) { $this->state = $state->where('company_id', Auth::user()->company_id)->where('account_year_id', session('account')); }
public function __construct(Truck $truck, Driver $driver, State $state) { $this->truck = $truck->where('company_id', Auth::user()->company_id)->where('account_year_id', session('account')); $this->driver = $driver->where('company_id', Auth::user()->company_id)->where('account_year_id', session('account')); $this->state = $state->where('company_id', Auth::user()->company_id)->where('account_year_id', session('account')); }
<?php Route::get('/', 'CoursesController@index'); Route::get('/documentation', ['as' => 'documentation.index', 'uses' => 'DocumentationController@index']); Route::resource('users', 'UsersController'); Route::resource('courses', 'CoursesController'); Route::resource('courses.classes', 'SchedulesController'); Route::get('/course-schedule/{id}', ['middleware' => 'cache.response', function ($id) { $key = 'schedule-' . $id; $schedules = \App\Schedule::upcoming()->where('course_id', '=', $id)->orderBy('start')->get(); $data = view('javascript.course', compact('schedules')); return response()->view('javascript.handler', compact('key', 'data'))->header('Content-Type', 'application/javascript'); }])->where(['id' => '[0-9]+']); Route::get('/state-schedule/{code}', ['middleware' => 'cache.response', function ($code) { $state = \App\State::where('code', '=', $code)->firstOrFail(); $key = 'schedule-' . $code; $schedules = \App\Schedule::upcoming()->where('state_id', '=', $state->id)->orderBy('start')->get(); $data = view('javascript.state', compact('schedules')); return response()->view('javascript.handler', compact('key', 'data'))->header('Content-Type', 'application/javascript'); }])->where(['code' => '[A-Z]{2}']); Route::controllers(['auth' => 'Auth\\AuthController', 'password' => 'Auth\\PasswordController']);