public function index() { $user = new User($this->registry); $d_user = $user->getUser_id($this->kd_user); $univ = Session::get('univ'); $d_univ = array(); foreach ($univ as $univ) { $temp = array(); $pb = new Penerima($this->registry); $cuniv = new Universitas($this->registry); $univDao = new UniversitasDao(); $univDao->set_kode_in($univ); $cuniv = $cuniv->get_univ_by_id($univDao); $temp[] = $cuniv->get_nama(); $temp[] = $pb->get_jumlah_pegawai('universitas', $univ); $d_univ[] = $temp; } $this->view->is_pic = Session::get('role') == 2 || Session::get('role') == 3 || Session::get('role') == 4 || Session::get('role') == 5 || Session::get('role') == 6; $this->view->d_univ = $d_univ; $this->view->d_user = $d_user; $this->view->d_notif = $this->get_notifikasi(); $this->view->count_notif = count($this->view->d_notif); // print_r($this->view->d_notif); $this->view->render('index'); }
public function tabel_penerima_skripsi2() { if (isset($_POST['kd_jurusan']) && isset($_POST['thn_masuk']) && $_POST['kd_jurusan'] != "" && $_POST['thn_masuk'] != "" && $_POST['kd_el'] != "") { $kd_jur = $_POST['kd_jurusan']; $thn_masuk = $_POST['thn_masuk']; $pb = new Penerima($this->registry); $data_pb = $pb->get_penerima_by_kd_jur_thn_masuk($kd_jur, $thn_masuk); $bank = new Bank($this->registry); $this->view->penerima_el = new PenerimaElemenBeasiswa(); $this->view->kd_el = $_POST['kd_el']; $this->view->bank = $bank; $this->view->pb = $data_pb; $this->view->load('bantuan/tabel_penerima_skripsi2'); } if (isset($_POST['kd_jurusan']) && isset($_POST['thn_masuk']) && $_POST['kd_jurusan'] != "" && $_POST['thn_masuk'] == "") { $kd_jur = $_POST['kd_jurusan']; //$thn_masuk = $_POST['thn_masuk']; $pb = new Penerima($this->registry); $data_pb = $pb->get_penerima_by_kd_jur($kd_jur); $bank = new Bank($this->registry); $this->view->penerima_el = new PenerimaElemenBeasiswa(); $this->view->kd_el = $_POST['kd_el']; $this->view->bank = $bank; $this->view->pb = $data_pb; $this->view->load('bantuan/tabel_penerima_skripsi2'); } }
public function viewAddTagihanPb() { if (isset($_POST['kd_kontrak']) && isset($_POST['kd_biaya'])) { $kontrak = new Kontrak(); $data_kontrak = $kontrak->get_by_id($_POST['kd_kontrak']); $penerima = new Penerima($this->registry); $pb = $penerima->get_penerima_by_kd_jur_thn_masuk($data_kontrak->kd_jurusan, $data_kontrak->thn_masuk_kontrak); $penerima_biaya = new PenerimaBiayaKontrak(); $this->view->pb = $pb; $this->view->penerima_biaya = $penerima_biaya; $this->view->kd_biaya = $_POST['kd_biaya']; $this->view->load('kontrak/add_pb_to_tagihan_dialog'); } }
public function cek_pb_konek_st_ct(Penerima $pb, $jenis_cek = 'all', $is_lulus = false, $luaran = false) { if ($pb->get_kd_pb() == '' || is_null($pb->get_kd_pb())) { return false; } if ($pb->get_st() == '' || is_null($pb->get_st())) { $pb = $pb->get_penerima_by_id($pb); } $kd_st = $pb->get_st(); $status = $pb->get_status(); switch ($jenis_cek) { case 'all': if (!$is_lulus) { //status belum lulus $sts_cuti = $this->cek_pb_konek_st_ct($pb, 'cuti', false); //cek masih cuti? // var_dump($sts_cuti); if ($sts_cuti) { $status = $this->cek_pb_konek_st_ct($pb, 'cuti', false, true); if ($luaran) { return $status; } return true; } else { //jika tidak dalam keadaan cuti $status = $this->cek_pb_konek_st_ct($pb, 'st', false, true); return $status; } } else { //TO DO cek lebih ke st, tp cek dulu dia dalam keadaancuti apa tidak //klo dalam keadaan cuti ya tidak bisa dong, harus dikembalikan ke cuti $sts_cuti = $this->cek_pb_konek_st_ct($pb, 'cuti', true); if ($sts_cuti) { $status = $this->cek_pb_konek_st_ct($pb, 'cuti', true, true); if ($luaran) { return $status; } return true; } else { $status = $this->cek_pb_konek_st_ct($pb, 'st', true, true); return $status; } } break; case 'cuti': $ct = new Cuti($this->registry); $d_ct = $ct->get_cuti(Session::get('kd_user'), $pb); //TO DO cek apakah masa cuti masih ada $exist_data = count($d_ct) > 0; if ($exist_data) { if ($luaran) { return 4; //saat cuti tidak boleh lulus } else { return true; } } else { if ($is_lulus) { //untuk kode lulus if ($luaran) { $status = $this->cek_pb_konek_st_ct($pb, 'st', true, true); //kode untuk lulus return $status; } else { //TO DO kembalian boolean return true; } } else { //untuk kode belum lulus if ($luaran) { $status = $this->cek_pb_konek_st_ct($pb, 'st', false, true); //kode sebelum lulus return $status; } else { //TO DO kembalian boolean return false; } } if (!$luaran) { return false; } } break; case 'st': $st = new SuratTugas($this->registry); $st->set_kd_st($kd_st); $st = $st->get_surat_tugas_by_id($st); $tgl_sel_st = $st->get_tgl_selesai(); $child = $st->is_child($kd_st); //child pertama if ($child) { $st_child = new SuratTugas($this->registry); $st_child->set_kd_st($st->get_st_lama()); //st parent $st_child = $st_child->get_surat_tugas_by_id($st_child); $second_child = $st_child->is_child($st_child->get_kd_st()); if ($second_child) { //jika child kedua if ($is_lulus) { //untuk status lulus if ($pb->get_tgl_lapor() == '' || is_null($pb->get_tgl_lapor())) { $tgl_lapor = date('Y-m-d'); } else { $tgl_lapor = $pb->get_tgl_lapor(); } $status = $pb->get_status_change_pb($st, $tgl_lapor, $tgl_sel_st); } else { $status = 3; } return $status; } else { if ($is_lulus) { if ($pb->get_tgl_lapor() == '' || is_null($pb->get_tgl_lapor())) { $tgl_lapor = date('Y-m-d'); } else { $tgl_lapor = $pb->get_tgl_lapor(); } $status = $pb->get_status_change_pb($st, $tgl_lapor, $tgl_sel_st); } else { $status = 2; } return $status; } } else { return 1; } break; default: throw new Exception(); } }
public function cek_pb_on_st() { $nip = $_POST['nip']; $kd_st = $_POST['kd_st']; $return = 0; $pb = new Penerima($this->registry); // $pb->set_nip($nip); // $d_cek = $pb->cek_exist_pb(); $d_cek = $pb->is_prn_beasiswa_strata($nip, $kd_st); // var_dump($d_cek); // if(((int) $d_cek['cek'])>0) { if ($d_cek) { $return = 1; } echo $return; }
public function get_cuti_by_pb_name($name, $kd_user = null) { $sql = "SELECT a.KD_CUTI as KD_CUTI,\r\n a.KD_JNS_SRT_CUTI as KD_JNS_SRT_CUTI,\r\n a.KD_PB as KD_PB,\r\n a.NO_CUTI as NO_CUTI,\r\n a.TGL_CUTI AS TGL_CUTI,\r\n a.PRD_MUL_CUTI as PRD_MUL_CUTI,\r\n a.PRD_SEL_CUTI as PRD_SEL_CUTI,\r\n a.PERK_STOP as PERK_STOP,\r\n a.PERK_GO as PERK_GO,\r\n a.FILE_CUTI as FILE_CUTI\r\n FROM " . $this->t_cuti . " a \r\n LEFT JOIN d_pb b ON a.KD_PB=b.KD_PB\r\n LEFT JOIN r_jur c ON b.KD_JUR=c.KD_JUR\r\n LEFT JOIN r_fakul d ON c.KD_FAKUL=d.KD_FAKUL\r\n LEFT JOIN r_univ e ON d.KD_UNIV=e.KD_UNIV\r\n WHERE b.NM_PB LIKE '%" . $name . "%'"; if (!is_null($kd_user)) { $sql .= " AND e.KD_USER="******"-" . $d_pb->get_nip() . "-" . $d_jur->get_nama()); $cuti->set_no_surat_cuti($v['NO_CUTI']); $cuti->set_tgl_surat_cuti($v['TGL_CUTI']); $cuti->set_prd_mulai($v['PRD_MUL_CUTI']); $cuti->set_prd_selesai($v['PRD_SEL_CUTI']); $cuti->set_perk_stop($v['PERK_STOP']); $cuti->set_perk_go($v['PERK_GO']); unset($pb); unset($jur); $data[] = $cuti; } return $data; }
public function get_elem_per_pb(Penerima $pb, $lunas = false) { $sql = "SELECT a.KD_D_ELEM_BEASISWA AS KD_D_ELEM_BEASISWA,\r\n b.NM_ELEM_BEASISWA as KD_R_ELEM_BEASISWA,\r\n a.JML_PEG_D_ELEM_BEASISWA as JML_PEG_D_ELEM_BEASISWA,\r\n a.BLN_D_ELEM_BEASISWA as BLN_D_ELEM_BEASISWA,\r\n a.THN_D_ELEM_BEASISWA as THN_D_ELEM_BEASISWA,\r\n a.TOTAL_BAYAR_D_ELEM_BEASISWA as TOTAL_BAYAR_D_ELEM_BEASISWA,\r\n c.KD_PB as KD_PB,\r\n a.NO_SP2D_D_ELEM_BEASISWA as NO_SP2D_D_ELEM_BEASISWA\r\n FROM " . $this->_table . " a \r\n LEFT JOIN r_elem_beasiswa b ON a.KD_R_ELEM_BEASISWA = b.KD_R_ELEM_BEASISWA\r\n LEFT JOIN t_elem_beasiswa c ON a.KD_D_ELEM_BEASISWA = c.KD_D_ELEM_BEASISWA\r\n WHERE c.KD_PB=" . $pb->get_kd_pb(); if ($lunas) { $sql .= " AND a.NO_SP2D_D_ELEM_BEASISWA<>NULL"; } $result = $this->db->select($sql); $data = array(); foreach ($result as $v) { $elem = new $this($this->registry); $elem->set_kd_d($v['KD_D_ELEM_BEASISWA']); $elem->set_kd_r($v['KD_R_ELEM_BEASISWA']); $jml_peg = (int) $v['JML_PEG_D_ELEM_BEASISWA']; $total_bayar = (int) $v['TOTAL_BAYAR_D_ELEM_BEASISWA']; $by_per_peg = $total_bayar / $jml_peg; $elem->set_biaya_per_peg($v['BIAYA_PER_PEG_D_ELEM_BEASISWA']); $elem->set_total_bayar($by_per_peg); $elem->set_thn_masuk($val['TAHUN_MASUK']); $elem->set_bln(Tanggal::bulan_indo($v['BLN_D_ELEM_BEASISWA'])); $elem->set_thn($v['THN_D_ELEM_BEASISWA']); $elem->set_no_sp2d($v['NO_SP2D_KD_D_ELEM_BEASISWA']); $elem->set_no_sp2d($v['NO_SP2D_D_ELEM_BEASISWA']); $data[] = $elem; } return $data; }
public function get_cost_per_pb(Penerima $pb, $lunas = false) { $sql = "SELECT CONCAT(c.NO_KON,',',c.TGL_KON) as KD_KONTRAK,\r\n a.NM_TAGIHAN AS NM_TAGIHAN,\r\n a.BIAYA_PER_PEG_TAGIHAN AS BIAYA_PER_PEG_TAGIHAN,\r\n a.NO_SP2D_TAGIHAN as NO_SP2D_TAGIHAN,\r\n a.TGL_SP2D_TAGIHAN as TGL_SP2D_TAGIHAN\r\n FROM d_tagihan a \r\n LEFT JOIN t_tagihan_kontrak b ON a.KD_TAGIHAN=b.KD_TAGIHAN\r\n LEFT JOIN d_kontrak c ON a.KD_KON=c.KD_KON \r\n WHERE b.KD_PB=" . $pb->get_kd_pb(); if ($lunas) { $sql .= " AND a.NO_SP2D_TAGIHAN<>NULL"; } $result = $this->db->select($sql); $data = array(); foreach ($result as $v) { $bea = new $this(); $bea->kd_kontrak = $v['KD_KONTRAK']; $bea->nama_tagihan = $v['NM_TAGIHAN']; $bea->biaya_per_pegawai = $v['BIAYA_PER_PEG_TAGIHAN']; $bea->no_sp2d = $v['NO_SP2D_TAGIHAN']; $bea->tgl_sp2d = $v['TGL_SP2D_TAGIHAN']; $data[] = $bea; } return $data; }
public function cetak_profil($id) { $pb = new Penerima($this->registry); //mendapatkan informasi pb $st = new SuratTugas($this->registry); //mendapatkan informasi surat tugas $el = new ElemenBeasiswa($this->registry); //mendapatkan pembayaran $bank = new Bank($this->registry); //mendapatkan nama bank $jst = new JenisSuratTugas($this->registry); //mendapatkan jenis surat tugas $jur = new Jurusan($this->registry); $univ = new Universitas($this->registry); $nilai = new Nilai($this->registry); $cuti = new Cuti($this->registry); $mas = new MasalahPenerima($this->registry); $pemb = new PemberiBeasiswa(); $beaya = new Biaya(); $role = Session::get('role'); $pb->set_kd_pb($id); $this->view->d_pb = $pb->get_penerima_by_id($pb, $this->kd_user); if ($role == 3) { $this->view->d_pb = $pb->get_penerima_by_id($pb); } $st->set_kd_st($this->view->d_pb->get_st()); $this->view->d_st = $st->get_surat_tugas_by_id($st, $this->kd_user); if ($role == 3) { $this->view->d_st = $st->get_surat_tugas_by_id($st); } $pemb = $pemb->get_by_id($this->view->d_st->get_pemberi()); $this->view->d_pemb = $pemb->nama_pemberi; $this->view->d_bank = $bank->get_bank_id($this->view->d_pb->get_bank()); $jur->set_kode_jur($this->view->d_pb->get_jur()); $this->view->d_jur = $jur->get_jur_by_id($jur); $jst->set_kode($this->view->d_st->get_jenis_st()); $this->view->d_jst = $jst->get_jst_by_id($jst); $this->view->d_univ = $univ->get_univ_by_jur($this->view->d_jur->get_kode_jur()); $this->view->d_nil = $nilai->get_nilai($pb); $this->view->d_cur_ipk = $nilai->get_current_ipk($pb); $this->view->d_cuti = $cuti->get_cuti($this->kd_user, $pb); if ($role == 3) { $this->view->d_cuti = $cuti->get_cuti(0, $pb); } $this->view->d_rwt_beas = $pb->get_penerima_by_column($pb, $this->kd_user, 'nip', true); if ($role == 3) { $this->view->d_rwt_beas = $pb->get_penerima_by_column($pb, 0, 'nip', true); } $elem = $el->get_elem_per_pb($pb, false); $bea = $beaya->get_cost_per_pb($pb, false); $this->view->d_mas = $mas->get_masalah($pb); $d_bea = array(); /* * sementara versi dummy dulu ye :p */ foreach ($elem as $v) { $d = new BiayaPenerimaBeasiswa(); $is_jadup = $v->get_kd_r() == 'tunjangan hidup'; $is_buku = $v->get_kd_r() == 'buku'; $nama = $v->get_kd_r(); if ($is_jadup) { $nama .= " " . $v->get_bln() . " " . $v->get_thn(); } if ($is_buku) { $bulan = Tanggal::bulan_num($v->get_bln()); $bulan = $bulan == 1 ? 'ganjil' : 'genap'; $nama .= " semester " . $bulan . " " . $v->get_thn(); } $d->set_nama_biaya($nama); $d->set_jumlah_biaya($v->get_total_bayar()); $d_bea[] = $d; } foreach ($bea as $v) { $d = new BiayaPenerimaBeasiswa(); $d->set_nama_biaya($v->nama_tagihan); $d->set_jumlah_biaya($v->biaya_per_pegawai); $d_bea[] = $d; } $this->view->d_bea = $d_bea; $this->view->load('profil/cetak_profil'); }
public function dialog_add_pb() { $pb = new Penerima($this->registry); $this->view->d_pb = $pb->get_penerima(); $this->view->load('riwayat_tb/dialog_add_pb_sc'); }