public function getIndex()
{
$breadcrumbs = array(array('Kompetensi' => ""), array('Realiasi' => ""), array('Diklat' => ""));
$diklat = DiklatEvaluasi::all();
$page = DiklatEvaluasi::paginate(5);
set_time_limit(0);
$user = Auth::user();
//ambil jabatan
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $user->nip);
//return $riwJabatan;
//ambil detail user
$masterPegawai = MasterPegawai::getDetailbyDate($this->competencyData->date_start, $user->nip);
if ($riwJabatan != false) {
$profileSoft = CompetencyProfile::getProfilebyJabatan($riwJabatan->unit_staf_id, 1)->get();
$profileBusiness = CompetencyProfile::getProfilebyJabatan($riwJabatan->unit_staf_id, 2)->get();
$competencyType = CompetencyType::all();
$data = array();
foreach ($competencyType as $rowType) {
$profile = CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $rowType->id);
$data[] = array('type' => array('id' => $rowType->id, 'name' => $rowType->name), 'profile' => $profile);
}
//return $data;
$this->layout->breadcrumbs = View::make('layouts.breadcrumb', compact('breadcrumbs'));
$this->layout->content = View::make('development::userrealisasidiklat.index', compact('data', 'masterPegawai', 'diklat', 'page'));
}
}
public function getIndex()
{
set_time_limit(0);
$user = Auth::user();
$breadcrumbs = array(array('Kompetensi' => ""), array('Realiasi' => ""), array('Diklat' => ""));
$prioritas = PreoritasDiklat::all();
//ambil jabatan
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $user->nip);
// return $riwJabatan;
//ambil detail user
$masterPegawai = MasterPegawai::getDetailbyDate($this->competencyData->date_start, $user->nip);
if ($riwJabatan != false) {
$profileSoft = CompetencyProfile::getProfilebyJabatan($riwJabatan->unit_staf_id, 1)->get();
$profileBusiness = CompetencyProfile::getProfilebyJabatan($riwJabatan->unit_staf_id, 2)->get();
$competencyType = CompetencyType::all();
$data = array();
foreach ($competencyType as $rowType) {
$profile = CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $rowType->id);
$data[] = array('type' => array('id' => $rowType->id, 'name' => $rowType->name), 'profile' => $profile);
}
// $db = DB::table('db_pegawai.master_pegawai')->get();
//return $db;
//ambil data recap individual
$preoritask = DB::table('competency_recap_individuals')->join('competency_recaps', 'competency_recap_individuals.competency_recap_id', '=', 'competency_recaps.id')->join('competency_dictionaries', 'competency_recap_individuals.competency_dictionary_id', '=', 'competency_dictionaries.id')->join('db_pegawai.master_pegawai', 'db_pegawai.master_pegawai.nip', '=', 'competency_recaps.user_nip')->join('db_pegawai.daf_unit_staf', 'db_pegawai.daf_unit_staf.unit_staf_id', '=', 'competency_recaps.occupation_id')->select(db::RAW('round(min(competency_recap_individuals.gap),2) as gap, count(competency_recaps.user_nip) as nip'), 'competency_recap_individuals.rcl', 'competency_recap_individuals.itj', 'competency_recap_individuals.ccl', 'competency_recap_individuals.gap', 'competency_recaps.id', 'db_pegawai.master_pegawai.nip', 'db_pegawai.daf_unit_staf.nama_lengkap', 'competency_dictionaries.id')->orderBy('rcl', 'asc')->orderBy('itj', 'desc')->groupBy('competency_dictionary_id')->paginate(8);
$this->layout->breadcrumbs = View::make('layouts.breadcrumb', compact('breadcrumbs'));
$this->layout->content = View::make('development::useridentificationdiklat.index', compact('data', 'masterPegawai', 'deputi', 'unit', 'prioritas', 'preoritask'));
}
}
public function action()
{
//data dari session
$nip = Auth::user()->nip;
//jabatan
$jabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $nip);
//get profile
$softProfiles = CompetencyProfile::getProfilebyJabatan($jabatan->unit_staf_id, 1)->get();
$hardProfiles = CompetencyProfile::getProfilebyJabatan($jabatan->unit_staf_id, 2)->get();
}
public function getIndex()
{
$breadcrumbs = array(array("Kompetensi" => ""), array("Profil Kompetensi" => ""));
set_time_limit(0);
$user = Auth::user();
//get jabatan
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $user->nip);
//get user detail
$masterPegawai = MasterPegawai::getDetailbyDate($this->competencyData->date_start, $user->nip);
if ($riwJabatan != false) {
$profileSoft = CompetencyProfile::getProfilebyJabatan($riwJabatan->unit_staf_id, 1)->get();
$profileBusiness = CompetencyProfile::getProfilebyJabatan($riwJabatan->unit_staf_id, 2)->get();
$competencyType = CompetencyType::all();
$data = array();
foreach ($competencyType as $rowType) {
$profile = CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $rowType->id);
$data[] = array('type' => array('id' => $rowType->id, 'name' => $rowType->name), 'profile' => $profile);
}
// return $data;
$this->layout->breadcrumbs = View::make('layouts.breadcrumb', compact('breadcrumbs'));
$this->layout->content = View::make('competency::profile.index', compact('data', 'masterPegawai'));
}
}
public function checkTest()
{
//data dari session
$userNip = Auth::user()->nip;
$userId = Auth::user()->id;
//cek data master golongan
$userData = CompetencyHistoryUser::where('nip', $userNip)->where('competency_id', $this->competencyId)->first();
$jabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $userNip);
//getProfile
$softProfiles = CompetencyProfile::getProfilebyJabatan($jabatan->unit_staf_id, 1)->get();
$hardProfiles = CompetencyProfile::getProfilebyJabatan($jabatan->unit_staf_id, 2)->get();
// //jika ada fung_id maka tidak menggunakan struk_id
// if($userData->fung_id != 0){
// //get profile
// $softProfiles = CompetencyProfile::with('competencyDictionary', 'competencyDictionary.level')
// ->join('competency_dictionaries', 'competency_profiles.competency_dictionary_id', '=', 'competency_dictionaries.id')
// ->where('competency_dictionaries.type_id', '=', '1')
// ->where('struktural_id', '=', $userData->struk_id)
// ->where('jabatan_id', '=', $userData->unit_id)
// ->groupBy('competency_dictionary_id')
// ->get();
//
// $hardProfiles = CompetencyProfile::with('competencyDictionary', 'competencyDictionary.level')
// ->join('competency_dictionaries', 'competency_profiles.competency_dictionary_id', '=', 'competency_dictionaries.id')
// ->where('competency_dictionaries.type_id', '=', '2')
// ->where('struktural_id', '=', $userData->struk_id)
// ->where('jabatan_id', '=', $userData->unit_id)
// ->groupBy('competency_dictionary_id')
// ->get();
// }else {
// //get profile
// $softProfiles = CompetencyProfile::with('competencyDictionary', 'competencyDictionary.level')
// ->join('competency_dictionaries', 'competency_profiles.competency_dictionary_id', '=', 'competency_dictionaries.id')
// ->where('competency_dictionaries.type_id', '=', '1')
// ->where('fungsional_id', '=', $userData->fung_id)
// ->where('jabatan_id', '=', $userData->unit_id)
// ->groupBy('competency_dictionary_id')
// ->get();
//
// $hardProfiles = CompetencyProfile::with('competencyDictionary', 'competencyDictionary.level')
// ->join('competency_dictionaries', 'competency_profiles.competency_dictionary_id', '=', 'competency_dictionaries.id')
// ->where('competency_dictionaries.type_id', '=', '2')
// ->where('fungsional_id', '=', $userData->fung_id)
// ->where('jabatan_id', '=', $userData->unit_id)
// ->groupBy('competency_dictionary_id')
// ->get();
// }
$this->layout->content = View::make('competency::test.check', compact('softProfiles', 'hardProfiles', 'userId'));
}
