function index()
{
//$data['title'] = $this->mutil->get_menu_name('dashboard/index');
$data['title'] = $this->title;
$data['menu'] = $this->menu;
$data['submenu'] = $this->submenu;
$this->load->helper('pusdiklat');
$currentYYYY = getCurrentYYYY();
$data['availableYYYY'] = $this->m_penilaianskp->ambildaftartahunyangtersedia();
if (isset($_POST['tahun'])) {
$tahunyangdinilaisaatini = $this->common->filter($this->input->post('tahun'));
} else {
$tahunyangdinilaisaatini = $currentYYYY;
}
$data['tahunyangdinilaisaatini'] = $tahunyangdinilaisaatini;
$currentnip = $this->session->userdata('nip');
$results_pejabat_penilai_i = $this->m_profil->ambil_detail_pegawai_dari_current_db($currentnip);
//ambil detail pejabat penilai
$nip_pejabat_penilai = $results_pejabat_penilai_i['rows']->pejabat_penilai;
if ($nip_pejabat_penilai == NULL) {
$data['pejabat_penilai_nip'] = "-";
$data['pejabat_penilai_nama'] = "-";
$data['pejabat_penilai_pangkat'] = "-";
$data['pejabat_penilai_unit_organisasi'] = NULL;
$data['pejabat_penilai_id_jabatan'] = NULL;
$data['pejabat_penilai_desc_jabatan'] = NULL;
} else {
$this->load->database('other', TRUE);
$results_pejabat_penilai_other = $this->m_profil->ambil_detail_pegawai_dari_other_db($nip_pejabat_penilai);
$data['pejabat_penilai_nip'] = $nip_pejabat_penilai;
if ($results_pejabat_penilai_other['num_rows'] != 0) {
$data['pejabat_penilai_nama'] = $results_pejabat_penilai_other['rows']->peg_nm;
$data['pejabat_penilai_pangkat'] = $results_pejabat_penilai_other['rows']->peg_gol_pangkat;
} else {
$data['pejabat_penilai_nama'] = "-";
$data['pejabat_penilai_pangkat'] = "-";
}
//ambil jabatan, unit organisasi dari currentdb
$results_pejabat_penilai_ii = $this->m_penilaianskp->ambil_detail_pegawai_dari_current_db_join_jabatan($nip_pejabat_penilai);
$data['pejabat_penilai_unit_organisasi'] = $results_pejabat_penilai_ii['rows']->unit_organisasi;
$data['pejabat_penilai_id_jabatan'] = $results_pejabat_penilai_ii['rows']->id_jabatan;
$data['pejabat_penilai_desc_jabatan'] = $results_pejabat_penilai_ii['rows']->deskripsi;
}
//hitung nilai_capaian_skp_rata_rata
$raw_nilai_capaian_skp = $this->m_realisasiskp->ambilpenilaianskp_average_nilai_capaian_skp($currentnip, $tahunyangdinilaisaatini);
if ($raw_nilai_capaian_skp->average != NULL) {
$nilai_capaian_skp = $raw_nilai_capaian_skp->average;
} else {
$nilai_capaian_skp = 0;
}
$data['nilai_capaian_skp'] = $nilai_capaian_skp;
$nilai_prestasi_akademik = $nilai_capaian_skp * (60 / 100);
$data['nilai_prestasi_akademik'] = $nilai_prestasi_akademik;
$this->load->view('vpenilaianSKP', $data);
}
public function index()
{
$data['menu'] = $this->menu;
$data['title'] = $this->title;
$this->load->helper('pusdiklat');
$currentYYYY = getCurrentYYYY();
$data['currentYYYY'] = $currentYYYY;
$currentnip = $this->session->userdata('nip');
//ambil total target kuantitas dan total realisasi kuantitas
$jeniskegiatan = 1;
//ambil penilaian_ke terakhir
$penilaian_ke_akhir = $this->mdasbord->caripenilaiankeakhir($currentnip, $currentYYYY, $jeniskegiatan)->penilaian_ke;
//speedometer
$data['total_kuantitas'] = $this->mdasbord->gettotalkuantitas($jeniskegiatan, $currentnip, $currentYYYY, $penilaian_ke_akhir);
//column bar
//ambil daftar tahun yang dimiliki
$raw_daftar_tahun_pribadi_currentnip = $this->mdasbord->getdaftartahunpribadi($currentnip, $jeniskegiatan);
if ($raw_daftar_tahun_pribadi_currentnip['num_rows'] != 0) {
$daftar_tahun_pribadi_currentnip = $raw_daftar_tahun_pribadi_currentnip['rows'];
} else {
$daftar_tahun_pribadi_currentnip = $currentYYYY;
}
$array_dtpc = array();
$obj_kuantitas = new stdClass();
if ($raw_daftar_tahun_pribadi_currentnip['num_rows'] != 0) {
foreach ($daftar_tahun_pribadi_currentnip as $dtpc) {
array_push($array_dtpc, $dtpc);
//ambil penilaian_ke terakhir
$penilaian_ke_akhir_dtpc = $this->mdasbord->caripenilaiankeakhir($currentnip, $dtpc, $jeniskegiatan)->penilaian_ke;
$total_kuantitas_dtpc = $this->mdasbord->gettotalkuantitas($jeniskegiatan, $currentnip, $dtpc, $penilaian_ke_akhir_dtpc);
$obj_kuantitas->tahun = $dtpc;
$obj_kuantitas->target = $total_kuantitas_dtpc->sum_target_kuantitas;
$obj_kuantitas->realisasi = $total_kuantitas_dtpc->sum_realisasi_kuantitas;
}
} else {
array_push($array_dtpc, $currentYYYY);
$obj_kuantitas->tahun = $currentYYYY;
$obj_kuantitas->target = 0;
$obj_kuantitas->realisasi = 0;
}
$imploded_array_dtpc = implode(",", $array_dtpc);
//column chart
$data['daftar_tahun'] = $imploded_array_dtpc;
//target
$array_target = (array) $obj_kuantitas->target;
//realisasi
$array_realisasi = (array) $obj_kuantitas->realisasi;
$data['column_data_target'] = implode(",", $array_target);
$data['column_data_realisasi'] = implode(",", $array_realisasi);
//data table diambil dari data terakhir
//$data['title'] = $this->mutil->get_menu_name('dashboard/index');
$this->load->view('vdashboard', $data);
}
function index()
{
$this->load->helper('pusdiklat');
$currentYYYY = getCurrentYYYY();
$currentnip = $this->session->userdata('nip');
//ambil data dari penilaian skp
$data['kegiatan_tugas_jabatan'] = $this->m_realisasiskp->ambilpenilaianskp_ktj($currentnip, $currentYYYY);
//ambil data tugas tambahan dan kreativitas
$data['tugas_tambahan_kreativitas'] = $this->m_realisasiskp->ambilpenilaianskp_tt_k($currentnip, $currentYYYY);
//hitung nilai_capaian_skp_rata_rata
$data['nilai_capaian_skp'] = $this->m_realisasiskp->ambilpenilaianskp_average_nilai_capaian_skp($currentnip, $currentYYYY);
$this->load->view("vrealisasiSkp", $data);
}
function index()
{
$data['title'] = $this->title;
$data['menu'] = $this->menu;
$this->load->helper('pusdiklat');
$currentYYYY = getCurrentYYYY();
$data['availableYYYY'] = $this->m_penilaianskp->ambildaftartahunyangtersedia();
if (isset($_POST['tahun'])) {
$tahunyangdinilaisaatini = $this->common->filter($this->input->post('tahun'));
} else {
$tahunyangdinilaisaatini = $currentYYYY;
}
$data['tahunyangdinilaisaatini'] = $tahunyangdinilaisaatini;
$currentnip = $this->session->userdata('nip');
$this->load->view('vhasilpenilaian', $data);
}
function index()
{
//$data['title'] = $this->mutil->get_menu_name('dashboard/index');
$data['title'] = $this->title;
$data['menu'] = $this->menu;
$data['submenu'] = $this->submenu;
$this->load->helper('pusdiklat');
$currentYYYY = getCurrentYYYY();
$currentnip = $this->session->userdata('nip');
//cek jika ada penilaian skp yang memiliki status = 2 / executing
//ambil data dari penilaian skp
$data['kegiatan_tugas_jabatan'] = $this->m_realisasiskp->ambilpenilaianskp_ktj($currentnip, $currentYYYY);
//ambil data tugas tambahan dan kreativitas
$data['tugas_tambahan_kreativitas'] = $this->m_realisasiskp->ambilpenilaianskp_tt_k($currentnip, $currentYYYY);
//hitung nilai_capaian_skp_rata_rata
$data['nilai_capaian_skp'] = $this->m_realisasiskp->ambilpenilaianskp_average_nilai_capaian_skp($currentnip, $currentYYYY);
$this->load->view("vrealisasiSkp", $data);
}
function index()
{
$data['title'] = $this->title;
$data['menu'] = $this->menu;
$this->load->helper('pusdiklat');
$currentYYYY = getCurrentYYYY();
$data['availableYYYY'] = $this->m_penilaianskp->ambildaftartahunyangtersedia();
//demo tampilan -- seharusnya bukan post
if (isset($_POST['textinput_keberatan'])) {
$data['showcompletemode'] = TRUE;
} else {
$data['showcompletemode'] = FALSE;
}
if (isset($_POST['tahun'])) {
$tahunyangdinilaisaatini = $this->common->filter($this->input->post('tahun'));
} else {
$tahunyangdinilaisaatini = $currentYYYY;
}
$data['tahunyangdinilaisaatini'] = $tahunyangdinilaisaatini;
$currentnip = $this->session->userdata('nip');
$this->load->view('vdetailpenilaian', $data);
}
function index()
{
//$data['title'] = $this->mutil->get_menu_name('dashboard/index');
$data['title'] = $this->title;
$data['menu'] = $this->menu;
$data['submenu'] = $this->submenu;
$this->load->helper('pusdiklat');
$currentYYYY = getCurrentYYYY();
$data['availableYYYY'] = $this->m_penilaianskp->ambildaftartahunyangtersedia();
if (isset($_POST['tahun'])) {
$tahunyangdinilaisaatini = $this->common->filter($this->input->post('tahun'));
} else {
$tahunyangdinilaisaatini = $currentYYYY;
}
$data['tahunyangdinilaisaatini'] = $tahunyangdinilaisaatini;
$currentnip = $this->session->userdata('nip');
$results_pejabat_penilai_i = $this->m_profil->ambil_detail_pegawai_dari_current_db($currentnip);
//ambil detail pejabat penilai
$nip_pejabat_penilai = $results_pejabat_penilai_i['rows']->pejabat_penilai;
if ($nip_pejabat_penilai == NULL) {
$data['pejabat_penilai_nip'] = "-";
$data['pejabat_penilai_nama'] = "-";
$data['pejabat_penilai_pangkat'] = "-";
$data['pejabat_penilai_unit_organisasi'] = NULL;
$data['pejabat_penilai_id_jabatan'] = NULL;
$data['pejabat_penilai_desc_jabatan'] = NULL;
} else {
$this->load->database('other', TRUE);
$results_pejabat_penilai_other = $this->m_profil->ambil_detail_pegawai_dari_other_db($nip_pejabat_penilai);
$data['pejabat_penilai_nip'] = $nip_pejabat_penilai;
if ($results_pejabat_penilai_other['num_rows'] != 0) {
$data['pejabat_penilai_nama'] = $results_pejabat_penilai_other['rows']->peg_nm;
$data['pejabat_penilai_pangkat'] = $results_pejabat_penilai_other['rows']->peg_gol_pangkat;
} else {
$data['pejabat_penilai_nama'] = "-";
$data['pejabat_penilai_pangkat'] = "-";
}
//ambil jabatan, unit organisasi dari currentdb
$results_pejabat_penilai_ii = $this->m_penilaianskp->ambil_detail_pegawai_dari_current_db_join_jabatan($nip_pejabat_penilai);
$data['pejabat_penilai_unit_organisasi'] = $results_pejabat_penilai_ii['rows']->unit_organisasi;
$data['pejabat_penilai_id_jabatan'] = $results_pejabat_penilai_ii['rows']->id_jabatan;
$data['pejabat_penilai_desc_jabatan'] = $results_pejabat_penilai_ii['rows']->deskripsi;
}
$status_penilaian_skp = FALSE;
$status_penilaian_perilaku_kerja = FALSE;
$status_complete = FALSE;
//hitung nilai_capaian_skp_rata_rata
$raw_nilai_capaian_skp = $this->m_realisasiskp->ambilpenilaianskp_average_nilai_capaian_skp($currentnip, $tahunyangdinilaisaatini);
if ($raw_nilai_capaian_skp->average != NULL) {
$nilai_capaian_skp = $raw_nilai_capaian_skp->average;
$status_penilaian_skp = TRUE;
} else {
$nilai_capaian_skp = 0;
}
$data['nilai_capaian_skp'] = $nilai_capaian_skp;
$nilai_prestasi_akademik = $nilai_capaian_skp * (60 / 100);
$data['nilai_prestasi_akademik'] = $nilai_prestasi_akademik;
$raw_penilaianperilakukerja = $this->m_penilaianperilakukerja->ambilnilaiperilaku($tahunyangdinilaisaatini, $currentnip);
if (isset($raw_penilaianperilakukerja->nilai_rata_rata)) {
$nilai_rata_rata = $raw_penilaianperilakukerja->nilai_rata_rata;
$status_penilaian_perilaku_kerja = TRUE;
} else {
$nilai_rata_rata = 0;
}
if ($status_penilaian_skp == TRUE && $status_penilaian_perilaku_kerja == TRUE) {
$status_complete = TRUE;
}
$data['status_complete'] = $status_complete;
$data['nilai_rata_rata'] = $nilai_rata_rata;
$nilai_perilaku_kerja = $nilai_rata_rata * (40 / 100);
$data['nilai_perilaku_kerja'] = $nilai_perilaku_kerja;
//=IF(R26<=50;"(Buruk)";IF(R26<=60;"(Sedang)";IF(R26<=75;"(Cukup)";IF(R26<=90.99;"(Baik)";"(Sangat Baik)"))))
$total_nilai = $nilai_prestasi_akademik + $nilai_perilaku_kerja;
if ($status_complete == FALSE) {
$kriteria_nilai = "-";
} else {
switch ($total_nilai) {
case $total_nilai <= 50:
$kriteria_nilai = "Buruk";
break;
case $total_nilai <= 60:
$kriteria_nilai = "Sedang";
break;
case $total_nilai <= 75:
$kriteria_nilai = "Cukup";
break;
case $total_nilai <= 90.98999999999999:
$kriteria_nilai = "Baik";
break;
case $total_nilai >= 91:
$kriteria_nilai = "Sangat Baik";
break;
}
}
$data['status_complete'] = $status_complete;
$data['total_nilai'] = $total_nilai;
$data['kriteria_nilai'] = $kriteria_nilai;
$this->load->view('vtanggapan', $data);
}
