public function getOfflinetest()
{
//q1 => jabatan_id
$dataScheduleActive = Competency::where('status', '=', 'active')->first();
$dataJabatan = DafUnitStaff::where('aktif_id', '=', 1)->get();
$dataProfile = null;
if (Input::has('q1')) {
$jabatanTerpilih = DafUnitStaff::where('unit_staf_id', Input::get('q1'))->first();
$dataProfile = CompetencyProfile::with('competencyDictionary.competencyType', 'competencyDictionary.level')->where('competency_id', '=', $dataScheduleActive->id)->where('jabatan_id', '=', Input::get('q1'))->get();
// return $jabatanTerpilih;
$html = View::make('competency::adminProfile.downloadoffflinetest', compact('dataProfile', 'jabatanTerpilih'));
return PDF::load($html, 'A4', 'portrait')->download('offline test competency');
} else {
$this->layout->content = View::make('competency::adminProfile.offlineTest', compact('dataScheduleActive', 'dataJabatan'));
}
}
public function downloadUnit($idUnit)
{
$unit = DafUnit::find($idUnit);
// $profiles = CompetencyProfile::with(['competencyDictionary' => function($q) use($idUnit) {
//
// }])->where('jabatan_id', '=', $idUnit)->get();
$profiles = CompetencyProfile::with(['competencyDictionary' => function ($q) use($idUnit) {
$q->with('level')->get();
}])->where('jabatan_id', '=', $idUnit)->get();
if (count($profiles) > 0) {
// echo "<pre>";
// print_r($profiles) ;
return $profiles;
// $dictionaries = CompetencyDictionary::with('competencyType', 'kopet', 'child', 'level')->take('20')->get();
$html = View::make('competency::dictionary.unitDownload', compact('profiles'));
// return $html;
return PDF::load($html, 'A4', 'portrait')->show($unit->nama);
} else {
dd('tidak memiliki kompetensi');
}
}
public function index()
{
$units = DafUnitStaff::all();
if (Request::isMethod('post')) {
// create the validation rules ------------------------
$rules = array('unit' => 'required');
// validate against the inputs from our form
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
// get the error messages from the validator
$messages = $validator->messages();
// redirect our user back to the form with the errors from the validator
return Redirect::back()->withErrors($messages);
} else {
$unit = DafUnitStaff::where('unit_staf_id', Input::get('unit'))->first();
$softProfiles = CompetencyProfile::with('competencyDictionary')->join('competency_dictionaries', 'competency_profiles.competency_dictionary_id', '=', 'competency_dictionaries.id')->where('competency_dictionaries.type_id', '=', '1')->where('jabatan_id', '=', Input::get('unit'))->groupBy('competency_dictionary_id')->get();
$hardProfiles = CompetencyProfile::with('competencyDictionary')->join('competency_dictionaries', 'competency_profiles.competency_dictionary_id', '=', 'competency_dictionaries.id')->where('competency_dictionaries.type_id', '=', '2')->where('jabatan_id', '=', Input::get('unit'))->groupBy('competency_dictionary_id')->get();
// return $profiles;
$this->layout->content = View::make('competency::profile.postindex', compact('units', 'unit', 'softProfiles', 'hardProfiles'));
}
} else {
$this->layout->content = View::make('competency::profile.index', compact('units'));
}
}
