/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$report_dates = ReportDate::lists('petsa', 'id');
$job_placement_graduate = JobPlacementGraduate::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($job_placement_graduate->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($job_placement_graduate->occupation->id)->lists('name', 'id');
return view('tviadmin.job_placement_graduates.edit', compact('job_placement_graduate', 'sectors', 'subsectors', 'occupations', 'report_dates'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$report_dates = ReportDate::lists('petsa', 'id');
$assessment_transferee = AssessmentTransferee::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($assessment_transferee->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($assessment_transferee->occupation->id)->lists('name', 'id');
return view('tviadmin.assessment_transferees.edit', compact('assessment_transferee', 'sectors', 'subsectors', 'occupations', 'report_dates'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$report_dates = ReportDate::lists('petsa', 'id');
$dropout_shortterm = DropoutShortTermTrainee::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($dropout_shortterm->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($dropout_shortterm->occupation->id)->lists('name', 'id');
return view('tviadmin.dropout_short_term.edit', compact('dropout_shortterm', 'sectors', 'subsectors', 'occupations', 'report_dates'));
}
public function levelC($subsector_id)
{
$occupation_ids = Occupation::select('id')->where(array('subsector_id' => $subsector_id))->lists('id');
$level_C = Trainer::select(DB::raw('occupation_id,
SUM(full_time_male) as male,
SUM(full_time_female) as female,
(SUM(full_time_male) + SUM(full_time_female)) as total'))->where('level', 'Level C')->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->whereIn('occupation_id', $occupation_ids)->get();
return $level_C;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$report_dates = ReportDate::lists('petsa', 'id');
$cooperative_training_transferee = CooperativeTrainingTransferee::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($cooperative_training_transferee->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($cooperative_training_transferee->occupation->id)->lists('name', 'id');
return view('tviadmin.cooperative_training_transferees.edit', compact('cooperative_training_transferee', 'sectors', 'subsectors', 'occupations', 'report_dates'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$user = Auth::user();
$report_dates = ReportDate::lists('petsa', 'id');
$graduate = Graduate::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($graduate->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($graduate->occupation->id)->lists('name', 'id');
return view('tviadmin.graduates.edit', compact('graduate', 'sectors', 'subsectors', 'occupations', 'report_dates'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$user = Auth::user();
$report_dates = ReportDate::lists('petsa', 'id');
$assessment = Assessment::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($assessment->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($assessment->occupation->id)->lists('name', 'id');
return view('tviadmin.assessments.edit', array('assessment' => $assessment, 'report_dates' => $report_dates, 'sectors' => $sectors, 'subsectors' => $subsectors, 'occupations' => $occupations));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$user = Auth::user();
$report_dates = ReportDate::lists('petsa', 'id');
$formal_training = FormalTraining::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($formal_training->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($formal_training->occupation->id)->lists('name', 'id');
return view('tviadmin.formal_trainings.edit', array('formal_training' => $formal_training, 'report_dates' => $report_dates, 'sectors' => $sectors, 'subsectors' => $subsectors, 'occupations' => $occupations));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
//
$occupation = Occupation::find($id);
//return $gender;
if (count($occupation) > 0) {
$statusCode = 200;
$response = ['id' => $occupation->id, 'Occupation' => $occupation->occupation];
} else {
$response = ["error" => "Occupation doesn`t exist"];
$statusCode = 404;
}
return response($response, $statusCode)->header('Content-Type', 'application/json');
}
<li class="list-group-item">{{ $occupation->name }} : {{ $o->total }}</li>
@endforeach
</ul>
<p>Male</p>
<ul class="list-group">
@foreach($student_ratio->top3_occupations_extension_male() as $o)
<?php
$occupation = \App\Occupation::find($o->occupation_id);
?>
<li class="list-group-item">{{ $occupation->name }} : {{ $o->total }}</li>
@endforeach
</ul>
<p>Female</p>
<ul class="list-group">
@foreach($student_ratio->top3_occupations_extension_female() as $o)
<?php
$occupation = \App\Occupation::find($o->occupation_id);
?>
<li class="list-group-item">{{ $occupation->name }} : {{ $o->total }}</li>
@endforeach
</ul>
</div>
</div>
</div>
</div>
public function delete($id)
{
$occupation = Occupation::findOrFail($id);
return view('sysadmin.occupations.delete', compact('occupation'));
}
public function subsectors()
{
$sub_sectors = Subsector::whereIn('id', Occupation::select('subsector_id')->whereIn('id', Trainer::select('occupation_id')->where('report_date_id', $this->report_date_id)->where('institution_id', $this->institution_id)->distinct()->lists('occupation_id'))->distinct()->lists('subsector_id'))->get();
return $sub_sectors;
}
public function for_print_rpt1_non_gov_drop_grad($id)
{
$user = Auth::user();
$region = Region::findOrFail($user->region_id);
$report_date = ReportDate::findOrFail($id);
$rpt1 = new RTAReport1NonGovernment($report_date->id, $user->region_id);
// get occupations
$occupations = Occupation::whereIn('id', DropoutGraduate::select('occupation_id')->where('report_date_id', $id)->whereIn('institution_id', Institution::select('id')->where('region_id', $region->id)->where('ownership', '!=', 'Public')->lists('id'))->lists('occupation_id'))->orderBy('name')->get();
// get sectors
$sectors = Sector::whereIn('id', Subsector::select('sector_id')->whereIn('id', $occupations->lists('subsector_id'))->get())->get();
// get subsectors
$subsectors = Subsector::whereIn('id', $occupations->lists('subsector_id'))->get();
return view('rtaadmin.print_rpt1nongov_7', compact('rpt1', 'region', 'report_date', 'sectors', 'subsectors', 'occupations'));
}
Route::group(array('middleware' => 'auth'), function () {
Route::get('load-sub-sectors', function () {
$input = Input::get('option');
$sector = \App\Sector::find($input);
$subsectors = $sector->subsectors()->where('active', true)->orderBy('name', 'asc');
return Response::make($subsectors->get(['id', 'name']));
});
Route::get('load-occupations', function () {
$input = Input::get('option');
$subsector = \App\Subsector::find($input);
$occupations = $subsector->occupations()->where('active', true)->orderBy('name', 'asc');
return Response::make($occupations->get(['id', 'name']));
});
Route::get('load-competencies', function () {
$input = Input::get('option');
$occupation = \App\Occupation::find($input);
$competencies = $occupation->competencies()->where('active', true)->orderBy('name', 'asc');
return Response::make($competencies->get(['id', 'name']));
});
});
// RTA Admin routes...
Route::group(array('before' => 'rta', 'middleware' => 'auth'), function () {
// Institutions
Route::get('rta-institutions', 'RTA\\RTAController@institutions');
Route::get('rta-institutions/{id}', 'RTA\\RTAController@school_profile');
// Report Dates routes...
Route::get('create-report-date', 'TVI\\ReportDateController@create');
Route::post('create-report-date', 'TVI\\ReportDateController@store');
Route::get('report-dates', 'TVI\\ReportDateController@index');
Route::get('report-dates/{id}/edit', 'TVI\\ReportDateController@edit');
Route::patch('report-dates/{id}', 'TVI\\ReportDateController@update');
public function run()
{
DB::table('occupations')->delete();
Occupation::create(['id' => '1', 'occupation' => 'Business & Finance']);
Occupation::create(['id' => '2', 'occupation' => 'Computers & Technology']);
Occupation::create(['id' => '3', 'occupation' => 'Construction Trades']);
Occupation::create(['id' => '4', 'occupation' => 'Education, Teaching & Training']);
Occupation::create(['id' => '5', 'occupation' => 'Engineering & Engineering Technicians']);
Occupation::create(['id' => '6', 'occupation' => 'Fishing, Farming & Forestry']);
Occupation::create(['id' => '7', 'occupation' => 'Health & Medical']);
Occupation::create(['id' => '8', 'occupation' => 'Hospitality, Travel & Tourism']);
Occupation::create(['id' => '9', 'occupation' => 'Media Communications & Broadcasting']);
Occupation::create(['id' => '10', 'occupation' => 'Military & Armed Forces']);
Occupation::create(['id' => '11', 'occupation' => 'Office Administration & Management']);
Occupation::create(['id' => '12', 'occupation' => 'Production & Manufacturing']);
Occupation::create(['id' => '13', 'occupation' => 'Professional & Service']);
Occupation::create(['id' => '14', 'occupation' => 'Psychology & Counseling']);
Occupation::create(['id' => '15', 'occupation' => 'Installation, Repair & Maintenance']);
Occupation::create(['id' => '16', 'occupation' => 'Sales & Marketing']);
Occupation::create(['id' => '17', 'occupation' => 'Social & Life Sciences']);
Occupation::create(['id' => '18', 'occupation' => 'Transportation & Moving']);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit()
{
//
$gender = Gender::lists('gender', 'id');
$age = Age::lists('age', 'id');
$occupation = Occupation::lists('occupation', 'id');
$country = Country::orderBy('country')->lists('country', 'id');
//for alphabetic order
$education = Education::lists('education', 'id');
//return Auth::User()->profile;
return view('user.edit', compact('gender', 'age', 'occupation', 'country', 'education'));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$user = Auth::user();
$report_dates = ReportDate::lists('petsa', 'id');
$short_term_training = ShortTermTraining::findOrFail($id);
$sectors = Sector::all()->lists('name', 'id');
$subsectors = Subsector::findOrFail($short_term_training->occupation->subsector->id)->lists('name', 'id');
$occupations = Occupation::findOrFail($short_term_training->occupation->id)->lists('name', 'id');
$competencies = Occupation::findOrFail($short_term_training->occupation->id)->competencies()->lists('name', 'id');
return view('tviadmin.short_term_trainings.edit', array('short_term_training' => $short_term_training, 'report_dates' => $report_dates, 'sectors' => $sectors, 'subsectors' => $subsectors, 'occupations' => $occupations, 'competencies' => $competencies));
}
