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']);
