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 postIndex()
{
// return Input::all();
$competency = Competency::getActive();
$totalCompetency = 0;
$totalValue = 0;
if (count($competency) > 0) {
//list recap
$listRecap = CompetencyRecap::getlistAll($competency->id);
foreach ($listRecap as $recap) {
//clean recap individual
DB::table('competency_recap_individuals')->where('competency_recap_id', $recap->id)->delete();
//get profile
$sql = "SELECT c.competency_dictionary_id,c.rcl,c.itj,b.user_nip,a.level,d.value FROM competency_tests a, competency_dictionary_levels d, competency_recaps b RIGHT JOIN competency_profiles c on c.jabatan_id=b.occupation_id WHERE a.level=d.id AND a.competency_recap_id=b.id AND a.competency_dictionary_id=c.competency_dictionary_id AND b.competency_id=" . $competency->id . " and b.id=" . $recap->id . "";
$arr = DB::select(DB::raw($sql));
$arr = CompetencyProfile::getProfilefromRecapNip($recap->user_nip);
$total = 0;
foreach ($arr as $row) {
$test = CompetencyTest::getAvgTest($row->competency_dictionary_id, $recap->user_nip);
$recapInv = new CompetencyRecapIndividuals();
$recapInv->competency_recap_id = $recap->id;
$recapInv->competency_dictionary_id = $row->competency_dictionary_id;
$recapInv->rcl = $row->rcl;
$recapInv->itj = $row->itj;
$recapInv->ccl = $test->lvl;
$recapInv->gap = $test->lvl - $row->rcl;
$recapInv->priority = ($test->lvl - $row->rcl) * $row->itj;
$recapInv->save();
if ($recapInv->gap >= 0) {
$total = $total + 1;
}
}
$updateRecap = CompetencyRecap::find($recap->id);
if ($total == 0) {
$updateRecap->total = 0;
} else {
$updateRecap->total = $total / count($arr) * 100;
}
$updateRecap->save();
$totalCompetency = $totalCompetency + count($arr);
$totalValue = $totalValue + $total;
}
//update Competency
$updateCompetency = Competency::find($competency->id);
if ($totalValue == 0) {
$updateCompetency->value = 0;
} else {
$updateCompetency->value = $totalValue / $totalCompetency * 100;
}
$updateCompetency->save();
return Redirect::to('admin/competency/recap/result');
} else {
dd('fatal error');
}
}
public function postIndex()
{
$nip = Auth::user()->nip;
$competency = Competency::all();
$recap = CompetencyRecap::with('competency')->where('competency_id', '=', Input::get('competency_id'))->where('user_nip', '=', $nip)->first();
$competencyType = CompetencyType::all();
$masterPegawai = MasterPegawai::getDetailbyDate($recap->competency->date_start, $nip);
foreach ($competencyType as $rowCT) {
$profiles = CompetencyProfile::getProfilebyRecapType($recap->user_nip, $rowCT->id);
$result[] = array('name' => $rowCT->name, 'data' => $profiles);
}
// return $result;
$this->layout->content = View::make('competency::result.index', compact('competency', 'recap', 'result', 'masterPegawai'));
}
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 getProfile()
{
$rules = array('competency' => 'required', 'type' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->fails()) {
dd(Input::all());
Redirect::back()->with('errorMessage', 'inputan salah');
} else {
$competencies = Competency::all();
$competencyTypes = CompetencyType::all();
$type = Input::get('type');
$competency = Input::get('competency');
$nip = Auth::user()->nip;
$profile = CompetencyProfile::getProfile($nip, $competency, $type)->get();
// return $profile;
$this->layout->content = View::make('competency::userprofile.index', compact('competencies', 'competencyTypes', 'profile'));
}
}
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');
}
}
<table class="table table-bordered table-striped table-advance table-hover">
<thead>
<tr>
<th>Nama</th>
<th>Kemajuan</th>
<th style="width: 15%">Aksi</th>
</tr>
</thead>
<tbody>
@foreach ($listData as $data)
<tr>
<td> {{ $data->name }} </td>
<td>
<?php
$totalProfile = count(\Meniqa\Competency\Models\CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $competencyData->id, $data->id));
$checkProfile = count(\Meniqa\Competency\Models\CompetencyProfile::checkTestInv($user->nip, $riwJabatan->unit_staf_id, $competencyData->id, $data->id));
?>
{{ $totalProfile - $checkProfile }} pengisian dari {{ $totalProfile }} kompetensi
</td>
<td>
<a href="{{ url('competency/test/inv/type/'.$data->id) }}" class="btn btn-primary"><i class="fa fa-edit"></i> Pengukuran</a>
</td>
</tr>
@endforeach
</tbody>
</table>
</div>
</section>
</div>
</div>
public function getPrs()
{
$breadcrumbs = array(array("Kompetensi" => ""), array("Pengukuran" => ""), array("Kemajuan" => ""), array("Orang Lain" => ""));
$user = Auth::user();
//list Peers
$listPeers = CompetencyPeers::with('user', 'rater')->where('rater_id', '=', $user->nip)->where(function ($query) {
$query->where('status', '=', 'kolega');
// ->orWhere('status', '=', 'customer');
})->get();
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $user->nip);
$bawahan = DafUnitStaff::with('bawahan.bawahan')->where('unit_staf_id', '=', $riwJabatan->unit_staf_id)->first();
$atasan = DafUnitStaff::with('atasan')->where('unit_staf_id', '=', $riwJabatan->unit_staf_id)->first();
$data = array();
$competencyType = CompetencyType::all();
foreach ($listPeers as $peers) {
//get jabatan
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $peers->user_id);
$totalProfile = count(CompetencyProfile::getProfileAll($riwJabatan->unit_staf_id, $this->competencyData->id));
$checkProfile = count(CompetencyProfile::checkTestPrs($peers->user_id, $user->nip, $riwJabatan->unit_staf_id, $this->competencyData->id));
$result = array();
foreach ($competencyType as $rowType) {
$profile = CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $rowType->id);
$result[] = array('type' => array('id' => $rowType->id, 'name' => $rowType->name), 'profile' => $profile);
}
$data[] = array('id' => $peers->id, 'nip' => $peers->user_id, 'nama' => $peers->user->nama, 'status' => $peers->status, 'progress' => "" . $totalProfile - $checkProfile . " pengisian dari " . $totalProfile . " kompetensi", 'data' => $result);
}
//list bawahan level 1 & 2
if (isset($bawahan->bawahan) && $bawahan->bawahan != null) {
foreach ($bawahan->bawahan as $rowBawahanlvl1) {
//get user
$userBawahan = RiwJabStruk::getUser($this->competencyData->date_start, $rowBawahanlvl1->unit_staf_id);
if (isset($userBawahan) && $userBawahan != null) {
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $userBawahan->nip);
$totalProfile = count(CompetencyProfile::getProfileAll($riwJabatan->unit_staf_id, $this->competencyData->id));
$checkProfile = count(CompetencyProfile::checkTestPrs($userBawahan->nip, $user->nip, $riwJabatan->unit_staf_id, $this->competencyData->id));
$result = array();
foreach ($competencyType as $rowType) {
$profile = CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $rowType->id);
$result[] = array('type' => array('id' => $rowType->id, 'name' => $rowType->name), 'profile' => $profile);
}
$data[] = array('id' => $userBawahan->nip, 'nip' => $userBawahan->nip, 'nama' => $userBawahan->pegawai->nama, 'status' => 'bawahan level 1', 'progress' => "" . $totalProfile - $checkProfile . " pengisian dari " . $totalProfile . " kompetensi", 'data' => $result);
}
//list bawahan level 2
if (isset($bawahan->bawahan->bawahan) && $bawahan->bawahan->bawahan != null) {
foreach ($bawahan->bawahan as $rowBawahanlvl2) {
//get user
$userBawahan = RiwJabStruk::getUser($this->competencyData->date_start, [$rowBawahanlvl2->unit_staf_id]);
if (isset($userBawahan) && $userBawahan != null) {
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $userBawahan->nip);
$totalProfile = count(CompetencyProfile::getProfileAll($riwJabatan->unit_staf_id, $this->competencyData->id));
$checkProfile = count(CompetencyProfile::checkTestPrs($userBawahan->nip, $user->nip, $riwJabatan->unit_staf_id, $this->competencyData->id));
$result = array();
foreach ($competencyType as $rowType) {
$profile = CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $rowType->id);
$result[] = array('type' => array('id' => $rowType->id, 'name' => $rowType->name), 'profile' => $profile);
}
$data[] = array('id' => $userBawahan->nip, 'nip' => $userBawahan->nip, 'nama' => $userBawahan->pegawai->nama, 'status' => 'bawahan level 2', 'progress' => "" . $totalProfile - $checkProfile . " pengisian dari " . $totalProfile . " kompetensi", 'data' => $result);
}
}
}
}
}
//list atasan
if (isset($atasan->atasan) && $atasan->atasan != null) {
$rowAtasan = $atasan->atasan;
//get user
$userBawahan = RiwJabStruk::getUser($this->competencyData->date_start, $rowAtasan->unit_staf_id);
if (isset($userBawahan) && $userBawahan != null) {
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $userBawahan->nip);
$totalProfile = count(CompetencyProfile::getProfileAll($riwJabatan->unit_staf_id, $this->competencyData->id));
$checkProfile = count(CompetencyProfile::checkTestPrs($userBawahan->nip, $user->nip, $riwJabatan->unit_staf_id, $this->competencyData->id));
$result = array();
foreach ($competencyType as $rowType) {
$profile = CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $rowType->id);
$result[] = array('type' => array('id' => $rowType->id, 'name' => $rowType->name), 'profile' => $profile);
}
$data[] = array('id' => $userBawahan->nip, 'nip' => $userBawahan->nip, 'nama' => $userBawahan->pegawai->nama, 'status' => 'atasan', 'progress' => "" . $totalProfile - $checkProfile . " pengisian dari " . $totalProfile . " kompetensi", 'data' => $result);
}
}
// return $data;
$this->layout->breadcrumbs = View::make('layouts.breadcrumb', compact('breadcrumbs'));
$this->layout->content = View::make('competency::progress.peers', compact('data'));
}
public function peersAction($typeId, $step = 1)
{
$page = $step - 1;
if (Request::isMethod('post')) {
} else {
//data dari session
$nip = Auth::user()->nip;
$jabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $nip);
//cek peers
$peers = CompetencyPeers::getSoftPeers($this->competencyData->id, $nip);
if ($peers != null) {
//get jabatan Array
$jabatanArray = RiwJabStruk::getJabatanofPeers($this->competencyData->date_start, $peers);
//get profile by jabatan Array
$profiles = CompetencyProfile::getProfilefromPeers($this->competencyData->id, $jabatanArray, $typeId)->take(1)->skip($page)->first();
//get jabatan from profiles
$jabatanProfile = CompetencyProfile::getJabatanfromProfile($this->competencyData->id, $profiles->competency_dictionary_id);
//get user detail from jabatan
$jabatan = array_intersect($jabatanArray, $jabatanProfile);
$users = RiwJabStruk::getUserfromJabatan($this->competencyData->date_start, $jabatan);
$this->layout->content = View::make('competency::test.peers', compact('profiles', 'users'));
} else {
dd('error');
}
}
}
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'));
}
}
/**
* @param $competencyId
* @param $competencyDictionaryId
* @return array|null
*/
public static function getJabatanfromProfile($competencyId, $competencyDictionaryId)
{
$profiles = CompetencyProfile::where('competency_id', '=', $competencyId)->where('competency_dictionary_id', '=', $competencyDictionaryId)->get();
if ($profiles->count()) {
$jabatanArray = array();
foreach ($profiles as $profile) {
$jabatanArray[] = $profile->jabatan_id;
}
return $jabatanArray;
} else {
return null;
}
}
public function getAction($type, $id)
{
$user = Auth::user();
$peers = CompetencyPeers::find($id);
if ($peers != null) {
//get User
$pegawai = MasterPegawai::find($peers->user_id);
} else {
$pegawai = MasterPegawai::find($id);
}
//get jabatan
$riwJabatan = RiwJabStruk::getJabatanOnCompetency($this->competencyData->date_start, $pegawai->nip);
if ($riwJabatan != false) {
$profile = CompetencyProfile::getTestPrs($pegawai->nip, $user->nip, $riwJabatan->unit_staf_id, $this->competencyData->id, $type);
$totalProfile = count(CompetencyProfile::getProfile($riwJabatan->unit_staf_id, $this->competencyData->id, $type));
$checkProfile = count(CompetencyProfile::checkTestPrsType($pegawai->nip, $user->nip, $riwJabatan->unit_staf_id, $this->competencyData->id, $type));
$this->layout->content = View::make('competency::testPrs.type', compact('profile', 'pegawai', 'totalProfile', 'checkProfile'));
}
}