public function updateUangSkripsi()
 {
     if (isset($_POST['ubah_uskripsi'])) {
         if (isset($_POST['js']) && $_POST['js'] == 1) {
             header('location:' . URL . 'elemenBeasiswa/viewSkripsi');
         }
         if ($_POST['kd_el'] && $_POST['setuju'] != "" && $_POST['r_elem'] != "" && $_POST['kode_jur'] != "" && $_POST['tahun_masuk'] != "" && $_POST['biaya_skripsi'] != "" && $_POST['total_bayar'] != "") {
             $elem = new ElemenBeasiswa();
             $pb = $_POST['setuju'];
             $jml_peg = count($pb);
             $elem->set_kd_d($_POST['kd_el']);
             $elem->set_jml_peg($jml_peg);
             $elem->set_kd_r($_POST['r_elem']);
             $elem->set_kd_jur($_POST['kode_jur']);
             $elem->set_thn_masuk($_POST['tahun_masuk']);
             $elem->set_biaya_per_peg(str_replace(',', '', $_POST['biaya_skripsi']));
             $elem->set_total_bayar(str_replace(',', '', $_POST['total_bayar']));
             $elem->set_no_sp2d($_POST['no_sp2d']);
             $elem->set_tgl_sp2d(date('Y-m-d', strtotime($_POST['tgl_sp2d'])));
             //var_dump($elem);
             //echo $kd_elemen_beasiswa;
             //exit();
             //var_dump($elem);
             $upload = new Upload();
             $upload->init('fupload');
             if ($upload->getFileName() != "") {
                 $upload->setDirTo("files/sp2d/");
                 $nama = array($elem->get_no_sp2d(), $elem->get_tgl_sp2d());
                 //$upload->uploadFile2("", $nama);
                 if ($upload->uploadFile2("", $nama) == false) {
                     $url = URL . 'elemenBeasiswa/editJadup/' . $elem->get_kd_d();
                     echo '<script> alert("File gagal diupload.") </script>';
                     echo '<script language="JavaScript"> window.location.href ="' . $url . '" </script>';
                     exit;
                 }
                 $elem->set_file_sp2d($upload->getFileTo());
                 //echo $upload->getFileName();
                 if ($_POST['fupload_lama'] != "") {
                     $file = "files/sp2d/" . $_POST['fupload_lama'];
                     //echo $file;
                     if (file_exists($file)) {
                         unlink($file);
                     }
                 }
                 //echo $upload->getFileName();
             } else {
                 if ($_POST['fupload_lama'] != "") {
                     $elem->set_file_sp2d($_POST['fupload_lama']);
                     //echo $_POST['fupload_lama'];
                 } else {
                     $elem->set_file_sp2d("");
                 }
             }
             $elem->update_elem($elem);
             $penerima = new PenerimaElemenBeasiswa();
             $penerima->delete($elem->get_kd_d());
             foreach ($pb as $val) {
                 $penerima_elemen = new PenerimaElemenBeasiswa();
                 $penerima_elemen->kd_elemen_beasiswa = $elem->get_kd_d();
                 $penerima_elemen->kd_pb = $val;
                 $penerima_elemen->add($penerima_elemen);
             }
             ClassLog::write_log("elemen beasiswa", "ubah uang penelitian", "kd_el." . $elem->get_kd_d());
             //$url = URL . 'elemenBeasiswa/editSkripsi/' . $elem->get_kd_d();
             $url = URL . 'elemenBeasiswa/viewSkripsi';
             echo '<script> alert("Data berhasil disimpan") </script>';
             echo '<script language="JavaScript"> window.location.href ="' . $url . '" </script>';
         } else {
             header('location:' . URL . 'elemenBeasiswa/editSkripsi/' . $elem->get_kd_d());
         }
     } else {
         header('location:' . URL . 'elemenBeasiswa/viewSkripsi');
     }
 }
 public function get_list_elem($univ = NULL, $jurusan = NULL, $tahun = NULL, $sts = NULL, $user = NULL)
 {
     $sql = "SELECT \r\n            a.KD_D_ELEM_BEASISWA AS KD_D_ELEM_BEASISWA,\r\n            a.KD_R_ELEM_BEASISWA AS KD_R_ELEM_BEASISWA,\r\n            a.TAHUN_MASUK AS TAHUN_MASUK,\r\n            a.KD_JUR AS KD_JUR,\r\n            b.NM_JUR as NM_JUR,\r\n            c.KD_FAKUL AS KD_FAKUL,\r\n            d.NM_UNIV as NM_UNIV,\r\n            a.NO_SP2D_D_ELEM_BEASISWA as NO_SP2D_D_ELEM_BEASISWA,\r\n            a.TGL_SP2D_D_ELEM_BEASISWA as TGL_SP2D_D_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            FROM " . $this->_table . " a\r\n                LEFT JOIN r_jur b ON a.KD_JUR = b.KD_JUR\r\n                LEFT JOIN r_fakul c ON b.KD_FAKUL = c.KD_FAKUL\r\n                LEFT JOIN r_univ d ON c.KD_UNIV = d.KD_UNIV\r\n                ";
     if ($user != "") {
         $sql .= " WHERE d.KD_USER = '******'";
     }
     if ($univ != "") {
         if ($user != "") {
             $sql .= " AND d.KD_UNIV ='" . $univ . "'";
         } else {
             $sql .= " WHERE d.KD_UNIV ='" . $univ . "'";
         }
     }
     if ($jurusan != "") {
         if ($user != "" || $univ != "") {
             $sql .= " AND b.KD_JUR ='" . $jurusan . "'";
         } else {
             $sql .= " WHERE b.KD_JUR ='" . $jurusan . "'";
         }
     }
     if ($tahun != "") {
         if ($user != "" || $univ != "" || $jurusan != "") {
             $sql .= " AND a.TAHUN_MASUK ='" . $tahun . "'";
         } else {
             $sql .= " WHERE a.TAHUN_MASUK ='" . $tahun . "'";
         }
     }
     if ($sts != "") {
         if ($user != "" || $univ != "" || $jurusan != "" || $tahun != "") {
             if ($sts == "1") {
                 $sql .= " AND NO_SP2D_D_ELEM_BEASISWA IS NULL OR NO_SP2D_D_ELEM_BEASISWA =''";
             }
             if ($sts == "2") {
                 $sql .= " AND NO_SP2D_D_ELEM_BEASISWA !=''";
             }
         } else {
             if ($sts == "1") {
                 $sql .= " WHERE NO_SP2D_D_ELEM_BEASISWA IS NULL OR NO_SP2D_D_ELEM_BEASISWA =''";
             }
             if ($sts == "2") {
                 $sql .= " WHERE NO_SP2D_D_ELEM_BEASISWA !=''";
             }
         }
     }
     $sql .= " order by a.KD_D_ELEM_BEASISWA desc";
     $result = $this->db->select($sql);
     $data = array();
     foreach ($result as $key => $value) {
         $elem = new ElemenBeasiswa();
         $elem->set_kd_d($value['KD_D_ELEM_BEASISWA']);
         $elem->set_kd_r($value['KD_R_ELEM_BEASISWA']);
         $elem->set_no_sp2d($value['NO_SP2D_D_ELEM_BEASISWA']);
         $elem->set_tgl_sp2d(date('d-m-Y', strtotime($value['TGL_SP2D_D_ELEM_BEASISWA'])));
         $elem->set_univ($value['NM_UNIV']);
         $elem->set_thn_masuk($value['TAHUN_MASUK']);
         $elem->set_kd_jur($value['KD_JUR']);
         $elem->set_jml_peg($value['JML_PEG_D_ELEM_BEASISWA']);
         $elem->set_bln($value['BLN_D_ELEM_BEASISWA']);
         $elem->set_biaya_per_peg($v['BIAYA_PER_PEG_D_ELEM_BEASISWA']);
         $elem->set_thn($value['THN_D_ELEM_BEASISWA']);
         $elem->set_total_bayar($value['TOTAL_BAYAR_D_ELEM_BEASISWA']);
         $data[] = $elem;
     }
     //var_dump($data);
     return $data;
 }