public function login()
{
$user = $_POST['user'];
$pass = $_POST['pass'];
$pwd = Hash::create('sha1', $pass, HASH_SALT_KEY);
$cuser = new User($this->registry);
$res = $cuser->login($user, $pwd);
if ((int) $res[0] == 1) {
$univ = new Universitas($this->registry);
$d_univ = array();
$d_jur = array();
$aruniv = $univ->get_univ();
foreach ($aruniv as $v) {
if ($v->get_pic() == $res[2]) {
$d_univ[] = $v->get_kode_in();
$jur = new Jurusan($this->registry);
$arjur = $jur->get_jur_by_univ($v->get_kode_in());
foreach ($arjur as $w) {
$d_jur[] = $w->get_kode_jur();
}
}
}
Session::createSession();
Session::set('loggedin', TRUE);
Session::set('user', $user);
Session::set('role', $res[1]);
Session::set('kd_user', $res[3]);
Session::set('univ', $d_univ);
Session::set('jur', $d_jur);
ClassLog::write_log("login", "login", "user " . $user . " role:" . $res[1]);
header('location:' . URL);
} else {
if ((int) $res[0] == 0) {
$this->view->error = "user tidak ditemukan!";
$this->view->load('admin/login');
} else {
$this->view->error = "database tidak valid!";
$this->view->load('admin/login');
}
}
}
public function updFakultas()
{
$fakul = new Fakultas($this->registry);
$kd_fakul = $_POST['kd_fakul'];
$univ = $_POST['universitas'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$telepon = $_POST['telepon'];
$fakul->set_kode_univ($univ);
$fakul->set_nama($nama);
$fakul->set_alamat($alamat);
$fakul->set_telepon($telepon);
$fakul->set_kode_fakul($kd_fakul);
if (!$fakul->update_fakul()) {
$this->view->d_ubah = $fakul;
$this->view->error = $fakul->get_error();
$univ = new Universitas($this->registry);
$this->view->univ = $univ->get_univ();
$this->view->data = $fakul->get_fakul();
$this->view->render('admin/fakultas');
} else {
ClassLog::write_log('fakultas', 'ubah', $nama);
header('location:' . URL . 'admin/addFakultas/' . $halaman . "/" . $batas);
}
}
public function viewSkripsi()
{
$univ = new Universitas($this->registry);
$jur = new Jurusan($this->registry);
$user = Session::get('kd_user');
if (Session::get('role') == 2) {
$data = $univ->get_univ_by_pic($user);
$jurusan = $jur->get_jur_by_pic($user);
} else {
$data = $univ->get_univ();
$jurusan = $jur->get_jurusan();
}
$myArray = array();
foreach ($jurusan as $val2) {
$st = new SuratTugas($this->registry);
$thn = $st->get_thn_masuk_by_jur($val2->get_kode_jur());
//var_dump($thn);
foreach ($thn as $th) {
$penerima = new Penerima($this->registry);
$pb = $penerima->get_penerima_by_skripsi($val2->get_kode_jur(), $th);
$jml = count($pb);
//echo $jml;
$un = new Universitas($this->registry);
$c_univ = $un->get_univ_by_jur($val2->get_kode_jur());
$penerima_elemen = new PenerimaElemenBeasiswa();
$byr = $penerima_elemen->get_elemen_dibayar("3", $val2->get_kode_jur(), $th);
//echo $byr;
$pros = $penerima_elemen->get_elemen_proses_dibayar("3", $val2->get_kode_jur(), $th);
//echo $pros;
$arr = array('jur' => $val2->get_nama() . " " . $c_univ->get_kode(), 'thn' => $th, 'jml' => $jml, 'byr' => $byr, 'pros' => $pros);
array_push($myArray, $arr);
}
}
//var_dump($myArray);
foreach ($myArray as $c => $key) {
$sort_jur[] = $key['jur'];
$sort_thn[] = $key['thn'];
$sort_jml[] = $key['jml'];
$sort_byr[] = $key['byr'];
$sort_pros[] = $key['pros'];
}
if (!empty($myArray)) {
array_multisort($sort_thn, SORT_DESC, $myArray);
}
$this->view->univ = $data;
$this->view->arr = $myArray;
$this->view->render('bantuan/biaya_skripsi');
}
public function monitoring()
{
$universitas = new Universitas($this->registry);
$kd_user = Session::get('kd_user');
if (Session::get('role') == 2) {
$univ = $universitas->get_univ_by_pic($kd_user);
} else {
$univ = $universitas->get_univ();
}
$this->view->univ = $univ;
$this->view->render('kontrak/mon_pembayaran');
}
public function addpb($id)
{
$st = new SuratTugas($this->registry);
$pb = new Penerima($this->registry);
$univ = new Universitas($this->registry);
$bank = new Bank($this->registry);
$st->set_kd_st($id);
$pb->set_st($id);
$this->view->kd_st = $id;
$this->view->d_bank = $bank->get_bank();
$this->view->d_univ = $univ->get_univ();
if (Session::get('role') == 2) {
$this->view->d_st = $st->get_surat_tugas_by_id($st, $this->kd_user);
$this->view->d_pb = $pb->get_penerima_by_st($pb, $this->kd_user);
} else {
$this->view->d_st = $st->get_surat_tugas_by_id($st);
$this->view->d_pb = $pb->get_penerima_by_st($pb);
}
$this->view->d_th_masuk = $st->get_list_th_masuk();
// var_dump($this->view->d_st);
$this->view->render('riwayat_tb/pb_to_st');
}
public function datapb($halaman = 1, $batas = 10)
{
$pb = new Penerima($this->registry);
$univ = new Universitas($this->registry);
$st = new SuratTugas($this->registry);
$sts = new Status();
$role = Session::get('role');
$this->view->th_masuk = $st->get_list_th_masuk();
if ($role != 2) {
$this->view->th_masuk = $st->get_list_th_masuk();
}
if ($role == 2) {
$this->view->univ = $univ->get_univ($this->kd_user);
$this->view->d_pb_all = $pb->get_penerima($this->kd_user);
} else {
$this->view->univ = $univ->get_univ();
$this->view->d_pb_all = $pb->get_penerima();
}
$this->view->d_sts = $sts->get_status();
$this->view->nilai = new Nilai($this->registry);
/**start paging**/
$url = 'penerima/datapb';
$this->view->url = $url;
$this->view->paging = new Paging($url, $batas, $halaman);
$this->view->jmlData = count($this->view->d_pb_all);
$posisi = $this->view->paging->cari_posisi();
if ($role == 2) {
$this->view->d_pb = $pb->get_penerima($this->kd_user, $posisi, $batas);
} else {
$this->view->d_pb = $pb->get_penerima(0, $posisi, $batas);
}
/**end paging**/
$this->view->render('riwayat_tb/data_pb');
}
public function datasc($id = 0, $halaman = 1, $batas = 10)
{
$ct = new Cuti($this->registry);
if (isset($_POST['sb_add'])) {
$noct = $_POST['no_sc'];
$jsc = $_POST['jsc'];
$tgl_sc = $_POST['tgl_sc'];
$kd_pb = $_POST['kd_pb'];
// $jur = $_POST['jur'];
$sem_mul = $_POST['sem_mulai'];
$thn_mul = $_POST['thn_mulai'];
$sem_sel = $_POST['sem_sel'];
$thn_sel = $_POST['thn_sel'];
$bln_stop = $_POST['bln_stop'];
$thn_stop = $_POST['thn_stop'];
$bln_go = $_POST['bln_go'];
$thn_go = $_POST['thn_go'];
$data = $noct . " " . $jsc . " " . $tgl_sc . " " . $kd_pb . " " . $jur . " " . $sem_mul . " " . $sem_sel . " " . $thn_mul . " " . $thn_sel . " " . $bln_stop . " " . $bln_go . " " . $thn_stop . " " . $thn_go . " " . $_FILES['fupload']['name'];
// echo $data;
$pb = new Penerima($this->registry);
$pb->set_kd_pb($kd_pb);
$d_pb = $pb->get_penerima_by_id($pb);
// $upload = $this->registry->upload;
$cname = array('CUTI', $d_pb->get_nip(), $thn_mul);
$this->registry->upload->init('fupload');
$this->registry->upload->setDirTo('files/cuti/');
$this->registry->upload->changeFileName($this->registry->upload->getFileName(), $cname);
$file = $this->registry->upload->getFileTo();
// echo $file;
$ct->set_no_surat_cuti($noct);
$ct->set_jenis_cuti($jsc);
$ct->set_tgl_surat_cuti(Tanggal::ubahFormatTanggal($tgl_sc));
$ct->set_pb($kd_pb);
$ct->set_prd_mulai($sem_mul . " " . $thn_mul);
$ct->set_prd_selesai($sem_sel . " " . $thn_sel);
$ct->set_perk_stop($bln_stop . " " . $thn_stop);
$ct->set_perk_go($bln_go . " " . $thn_go);
$ct->set_file($file);
if ($ct->add_cuti()) {
// $pb->set_kd_pb($kd);
$d_pb->set_status(4);
$d_pb->update_penerima();
$this->registry->upload->uploadFile();
$ref = " no SC " . $noct;
ClassLog::write_log('cuti', 'rekam', $ref);
header('location:' . URL . 'cuti/datasc');
} else {
$this->view->d_rekam = $ct;
}
}
if ($id != 0) {
$ct->set_kode_cuti($id);
$this->view->d_ubah = $ct->get_cuti_by_id($ct, $this->kd_user);
// var_dump($this->view->d_ubah);
$pb = new Penerima($this->registry);
$pb->set_kd_pb($ct->get_pb());
$this->view->d_pb_ubah = $pb->get_penerima_by_id($pb, $this->kd_user);
$is_exist_file = $this->view->d_ubah->get_file() != NULL && $this->view->d_ubah->get_file() != '' ? true : false;
$file = array('file_exist' => $is_exist_file);
} else {
$file = array('file_exist' => false);
}
$jsc = new JenisSuratCuti($this->registry);
$univ = new Universitas($this->registry);
$st = new SuratTugas($this->registry);
$pb = new Penerima($this->registry);
if (Session::get('role') == 2) {
$this->view->d_pb = $pb->get_penerima($this->kd_user);
$this->view->d_ct_all = $ct->get_cuti($this->kd_user);
$this->view->d_univ = $univ->get_univ($this->kd_user);
} else {
$this->view->d_pb = $pb->get_penerima(0);
$this->view->d_ct_all = $ct->get_cuti(0);
$this->view->d_univ = $univ->get_univ();
}
$this->view->d_jsc = $jsc->get_jsc();
$this->view->d_th_masuk = $st->get_list_th_masuk();
$this->view->curr_year = date('Y');
$this->view->d_file_exist = json_encode($file);
/**start paging**/
$url = '';
if ($id == 0) {
$url = 'cuti/datasc/0';
} else {
$url = 'cuti/datasc/' . $id;
}
$this->view->url = $url;
$this->view->paging = new Paging($url, $batas, $halaman);
$this->view->jmlData = count($this->view->d_ct_all);
$posisi = $this->view->paging->cari_posisi();
if (Session::get('role') == 2) {
$this->view->d_ct = $ct->get_cuti_limit($posisi, $batas, $this->kd_user);
} else {
$this->view->d_ct = $ct->get_cuti_limit($posisi, $batas, 0);
}
/**end paging**/
$this->view->render('riwayat_tb/data_cuti');
}
