public function del_pb_from_st() { if (Session::get('role') != 2) { $this->datast(); } $d = $_POST['param']; $d = explode(",", $d); $pb = new Penerima($this->registry); $pb->set_kd_pb($d[1]); $pb->get_penerima_by_id($pb); $nama = $pb->get_nama(); $nip = $pb->get_nip(); $pb->delete_penerima(); $ref = " pegawai " . $nama . ":" . $nip; ClassLog::write_log('penerima_beasiswa', 'hapus', $ref); header('location:' . URL . 'surattugas/addpb/' . $d[0]); }
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 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 updct() { if (Session::get('role') != 2) { $this->datasc(); } $kd_ct = $_POST['kd_sc']; $jsc = $_POST['jsc']; $kd_pb = $_POST['kd_pb']; $no_sc = $_POST['no_sc']; $tgl_sc = Tanggal::ubahFormatTanggal($_POST['tgl_sc']); $prd_mul = $_POST['sem_mulai'] . " " . $_POST['thn_mulai']; $prd_sel = $_POST['sem_sel'] . " " . $_POST['thn_sel']; $perk_stop = $_POST['bln_stop'] . " " . $_POST['thn_stop']; $perk_go = $_POST['bln_go'] . " " . $_POST['thn_go']; $file = $_FILES['fupload']['name']; $ct = new Cuti($this->registry); $ct->set_kode_cuti($kd_ct); // echo $kd_ct."-".$jsc."-".$kd_pb."-".$no_sc."-".$tgl_sc."-".$prd_mul."-".$prd_sel."-".$perk_stop."-".$perk_go."-".$file; /* * cek eksistensi file */ // var_dump($_FILES['fupload']); $d_ct = $ct->get_cuti_by_id($ct, $this->kd_user); /* * sementara dulu * untuk update status tb, sambil nunggu fungsi yg benar :( */ $pb = new Penerima($this->registry); $kd_pb_ct = $ct->get_pb(); $pb->set_kd_pb($kd_pb_ct); $pb->get_penerima_by_id($pb); $status = $pb->cek_pb_konek_st_ct($pb, 'st', false, true); $pb->set_status($status); // $kd_st = $pb->get_st(); // $st = new SuratTugas($this->registry); // $is_child = $st->is_child($kd_st); // if($is_child){ // $kd_parent = $st->get_st_lama(); // if($kd_parent!=''){ // $pb->set_status(3); // }else{ // $pb->set_status(2); // } // }else{ // $pb->set_status(1); // } $pb->update_penerima(); unset($pb); // unlink($pb); /* * end update status */ $pb = new Penerima($this->registry); $pb->set_kd_pb($kd_pb); $d_pb = $pb->get_penerima_by_id($pb); if ($file != '') { $this->registry->upload->init('fupload'); $this->registry->upload->setDirTo('files/cuti/'); $tmp_prd = explode(" ", $prd_mul); $prd_mulai = $tmp_prd[count($tmp_prd) - 1]; $cname = array('CUTI', $d_pb->get_nip(), $prd_mulai); $this->registry->upload->changeFileName($this->registry->upload->getFileName(), $cname); $file = $this->registry->upload->getFileTo(); if (file_exists('files/cuti/' . $file)) { unlink('files/cuti/' . $file); } $this->registry->upload->uploadFile(); } else { // echo $kd_ct."</br>"; $file = $d_ct->get_file(); if ($kd_pb != $kd_pb_ct) { $tmp = explode("_", $file); $file_baru = $tmp[0] . "_" . $pb->get_nip() . "_" . $tmp[2]; rename("files/cuti/" . $file, "files/cuti/" . $file_baru); $file = $file_baru; } else { $file = $d_ct->get_file(); } // echo $file; } /* * set cuti */ $ct->set_jenis_cuti($jsc); $ct->set_pb($kd_pb); $ct->set_no_surat_cuti($no_sc); $ct->set_tgl_surat_cuti($tgl_sc); $ct->set_prd_mulai($prd_mul); $ct->set_prd_selesai($prd_sel); $ct->set_perk_stop($perk_stop); $ct->set_perk_go($perk_go); $ct->set_file($file); if ($ct->update_cuti()) { $pb->set_status(4); $pb->update_penerima(); $ref = " no SC " . $no_sc; ClassLog::write_log('cuti', 'ubah', $ref); header('location:' . URL . 'cuti/datasc'); } else { $this->view->d_ubah = $ct; $this->view->render('riwayat_tb/data_cuti'); } }