public function get_pb_jadup()
{
$sql = "SELECT \r\n a.KD_PB AS KD_PB,\r\n a.NM_PB AS NM_PB,\r\n a.KD_GOL AS KD_GOL,\r\n b.NM_STS_TB AS NM_STS_TB,\r\n c.NM_BANK AS NM_BANK,\r\n a.NO_REKENING_PB AS NO_REKENING_PB\r\n FROM d_pb a\r\n LEFT JOIN \r\n r_stb b ON a.KD_STS_TB = b.KD_STS_TB\r\n LEFT JOIN\r\n r_bank c ON a.KD_BANK = c.KD_BANK\r\n ";
$result = $this->db->select($sql);
$data = array();
foreach ($result as $value) {
$pb = new Penerima($this->registry);
$pb->set_kd_pb($value['KD_PB']);
$pb->set_nama($value['NM_PB']);
$pb->set_status($value['NM_STS_TB']);
$pb->set_bank($value['NM_BANK']);
$pb->set_no_rek($value['NO_REKENING_PB']);
$data[] = $pb;
}
return $data;
}
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');
}
}
