public function get_current_ipk($pb)
{
$sql = "SELECT SEM_NIL_PB as SEM_NIL_PB, IPK_NIL_PB as IPK_NIL_PB FROM " . $this->_tb_nilai . " WHERE KD_PB=" . $pb->get_kd_pb();
$sql .= " AND SEM_NIL_PB=(SELECT MAX(SEM_NIL_PB) FROM " . $this->_tb_nilai . " WHERE KD_PB=" . $pb->get_kd_pb() . ")";
// echo $sql."</br>";
$result = $this->_db->select($sql);
$nilai = new Nilai($this->registry);
foreach ($result as $v) {
$nilai->set_kode($v['KD_NIL_PB']);
$nilai->set_pb($v['KD_PB']);
$nilai->set_ips($v['IPS_NIL_PB']);
$nilai->set_ipk($v['IPK_NIL_PB']);
$nilai->set_semester($v['SEM_NIL_PB']);
}
return $nilai;
}
public function add_nilai()
{
$kd_pb = $_POST['kd_pb'];
$ips = $_POST['ips'];
$ipk = $_POST['ipk'];
$sem = $_POST['semester'];
$pb = new Penerima($this->registry);
$pb->set_kd_pb($kd_pb);
$d_pb = $pb->get_penerima_by_id($pb, $this->kd_user);
// echo "penerima";
/*
* upload file
*/
// $upload = new Upload();
$this->registry->upload->init('sfile');
$this->registry->upload->setDirTo('files/transkrip/');
$nm_file = array('TRANSKRIP', $d_pb->get_nip(), $sem);
$this->registry->upload->changeFileName($this->registry->upload->getFileName(), $nm_file);
$file = $this->registry->upload->getFileTo();
$this->registry->upload->uploadFile();
/*
* rekam nilai di tabel d_nil
*/
$nilai = new Nilai($this->registry);
$nilai->set_pb($kd_pb);
$nilai->set_ips($ips);
$nilai->set_ipk($ipk);
$nilai->set_semester($sem);
$nilai->set_file($file);
$nilai->add_nilai();
}
