public function get_elem_skripsi($univ = null, $jurusan = null, $tahun = 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 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 WHERE KD_R_ELEM_BEASISWA='" . $this->_skripsi . "'";
if ($user != "") {
$sql .= " AND d.KD_USER ='******'";
}
if ($univ != "") {
$sql .= " AND d.KD_UNIV ='" . $univ . "'";
}
if ($jurusan != "") {
$sql .= " AND b.KD_JUR ='" . $jurusan . "'";
}
if ($tahun != "") {
$sql .= " AND a.TAHUN_MASUK ='" . $tahun . "'";
}
$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_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['NM_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;
}
