function UpdateOnDb($data)
{
//query insert data
$this->db->flush_cache();
$this->db->set('kd_pt', $data['kd_pt']);
$this->db->set('Nama', $data['Nama']);
$this->db->set('TglMulai', FormatDateToMysql($data['TglMulai']));
$this->db->set('Alamat1', $data['Alamat1']);
//$this->db->set('Alamat2', $data['Alamat2']);
$this->db->set('Kota', $data['Kota']);
$this->db->set('KodePos', $data['KodePos']);
$this->db->set('Telepon', $data['Telepon']);
$this->db->set('Fax', $data['Fax']);
$this->db->set('Email', $data['Email']);
$this->db->set('Website', $data['Website']);
$this->db->set('NoAkta', $data['NoAkta']);
$this->db->set('TglAkta', FormatDateToMysql($data['TglAkta']));
$this->db->set('NoSah', $data['NoSah']);
$this->db->set('TglSah', FormatDateToMysql($data['TglSah']));
if ($data['Logo'] != '') {
$this->db->set('Logo', $data['Logo']);
}
$this->db->set('MUID', $this->session->userdata('user_id'));
$this->db->set('MDATE', date('Y-m-d H:i:s'));
$this->db->set('status', isset($data['status']) ? 'A' : 'T');
$this->db->where('kd_pt', $data['kode']);
$result = $this->db->update('ref_universitas');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function UpdateOnDb($data)
{
//query insert data
$this->db->flush_cache();
$this->db->set('category_id', $data['category_id']);
$this->db->set('content_title', $data['content_title']);
$this->db->set('content', $data['content']);
$this->db->set('summary', $data['summary']);
$this->db->set('url', $data['url']);
$this->db->set('date_post', FormatDateToMysql($data['datepost']));
$this->db->set('published', $data['published']);
$this->db->where('content_id', $data['kode']);
$result = $this->db->update('portal_content');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function UpdateOnDb($data)
{
//query insert data
$this->db->flush_cache();
$this->db->set('PMBPeriodID', $data['PMBPeriodID']);
$this->db->set('kd_pt', $data['kd_pt']);
$this->db->set('Nama', $data['Nama']);
$this->db->set('TglMulai', FormatDateToMysql($data['TglMulai']));
$this->db->set('TglSelesai', FormatDateToMysql($data['TglSelesai']));
$this->db->set('UjianMulai', FormatDateToMysql($data['UjianMulai']));
$this->db->set('UjianSelesai', FormatDateToMysql($data['UjianSelesai']));
$this->db->set('BayarMulai', FormatDateToMysql($data['BayarMulai']));
$this->db->set('BayarSelesai', FormatDateToMysql($data['BayarSelesai']));
//$this->db->set('TelitiBayarProdi', isset($data['TelitiBayarProdi'])? 'Agribisnis':'Agro Eko Teknologi');
$tmp_TelitiBayarProdi = "";
if (isset($data['TelitiBayarProdi1'])) {
$tmp_TelitiBayarProdi .= "Agribisnis, ";
}
if (isset($data['TelitiBayarProdi2'])) {
$tmp_TelitiBayarProdi .= "Agro Eko Teknologi, ";
}
if (isset($data['TelitiBayarProdi3'])) {
$tmp_TelitiBayarProdi .= "Akutansi, ";
}
if (isset($data['TelitiBayarProdi4'])) {
$tmp_TelitiBayarProdi .= "Biologi, ";
}
if (isset($data['TelitiBayarProdi5'])) {
$tmp_TelitiBayarProdi .= "Ekonomi Pembangunan, ";
}
if (isset($data['TelitiBayarProdi6'])) {
$tmp_TelitiBayarProdi .= "Geologi, ";
}
if (isset($data['TelitiBayarProdi7'])) {
$tmp_TelitiBayarProdi .= "Kehutanan, ";
}
if (isset($data['TelitiBayarProdi8'])) {
$tmp_TelitiBayarProdi .= "Manejmen, ";
}
if (isset($data['TelitiBayarProdi9'])) {
$tmp_TelitiBayarProdi .= "Manejemen Sumberdaya Pesisir, ";
}
if (isset($data['TelitiBayarProdi10'])) {
$tmp_TelitiBayarProdi .= "Sistem Informasi, ";
}
$this->db->set('TelitiBayarProdi', $tmp_TelitiBayarProdi);
$this->db->set('MUID', $this->session->userdata('user_id'));
$this->db->set('MDATE', date('Y-m-d H:i:s'));
$this->db->set('status', isset($data['status']) ? 'A' : 'T');
$this->db->where('PMBPeriodID', $data['kode']);
$result = $this->db->update('pmb_jadwal');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function UpdateOnDb($data)
{
//query insert data
$this->db->flush_cache();
$this->db->set('kd_kurikulum', $data['kd_kurikulum']);
$this->db->set('nama_kurikulum', $data['nama_kurikulum']);
$this->db->set('deskripsi', $data['deskripsi']);
$this->db->set('kd_pt', $data['kd_pt']);
$this->db->set('kd_fakultas', $data['kd_fakultas']);
$this->db->set('kd_prodi', $data['kd_prodi']);
$this->db->set('tgl_efektif', FormatDateToMysql($data['tgl_efektif']));
$this->db->set('status', isset($data['status']) ? 'A' : 'T');
$this->db->set('MUID', $this->session->userdata('user_id'));
$this->db->set('MDATE', date('Y-m-d H:i:s'));
$this->db->where('kd_kurikulum', $data['kode']);
$result = $this->db->update('ref_kurikulum');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function UpdateOnDb($data)
{
//query edit data
$this->db->flush_cache();
$this->db->set('judul_proposal', $data['judul_proposal']);
$this->db->set('pembimbing1', $data['pembimbing1']);
$this->db->set('pembimbing2', $data['pembimbing2']);
$this->db->set('proposal', $data['proposal']);
$this->db->set('keterangan', $data['keterangan']);
$this->db->set('tgl_daftar', FormatDateToMysql($data['tgl_daftar']));
// $this->db->set('tgl_selesai', date('Y-m-d', strtotime("+6 months", strtotime(FormatDateToMysql($data['tgl_mulai'])))));
if ($data['file_upload'] != '') {
$this->db->set('file_proposal', $data['file_upload']);
}
$this->db->set('MUID', $this->session->userdata('user_id'));
$this->db->set('MDATE', date('Y-m-d H:i:s'));
$this->db->where('id', $data['id']);
$result = $this->db->update('tbl_up');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function UpdateOnDb($data)
{
//query insert data
$this->db->flush_cache();
$this->db->set('PMBPeriodID', $data['PMBPeriodID']);
$this->db->set('no_pendaftaran', $data['no_pendaftaran']);
$this->db->set('nama', $data['nama']);
$this->db->set('tempat_lahir', $data['tempat_lahir']);
$this->db->set('tgl_lahir', FormatDateToMysql($data['tgl_lahir']));
$this->db->set('kota', $data['kd_kabup']);
$this->db->set('alamat', $data['alamat']);
$this->db->set('asal_sekolah', $data['asal_sekolah']);
$this->db->set('no_telp', $data['no_telp']);
$this->db->set('email', $data['email']);
$this->db->set('fakultas1', $data['fakultas1']);
$this->db->set('prodi1', $data['prodi1']);
$this->db->set('fakultas2', $data['fakultas2']);
$this->db->set('prodi2', $data['prodi2']);
$this->db->set('nama_ortu', $data['nama_ortu']);
$this->db->set('alamat_ortu', $data['alamat_ortu']);
$this->db->set('pekerjaan', $data['pekerjaan']);
$this->db->set('status', $data['status']);
$this->db->where('id_pendaftaran', $data['id_pendaftaran']);
$this->db->set('MUID', $this->session->userdata('user_id'));
$this->db->set('MDATE', date('Y-m-d H:i:s'));
$result = $this->db->update('pmb_pendaftaran');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function InsertOnDBverifikasi($data)
{
$this->db->trans_start();
# update table mutasi mahasiswa
$this->db->flush_cache();
$this->db->set('nim', $data['nim']);
$this->db->set('verifikasi', 'Sudah');
$this->db->where('kd_mahasiswa', $data['kd_mahasiswa']);
$this->db->update('tbl_mutasi_mahasiswa');
# insert to table mahasiswa
$this->db->flush_cache();
$this->db->set('thn_angkatan', $data['thn_angkatan']);
$this->db->set('nim', $data['nim']);
$this->db->set('nama', $data['nama']);
$this->db->set('tempat_lahir', $data['tempat_lahir']);
$this->db->set('tgl_lahir', FormatDateToMysql($data['tgl_lahir']));
$this->db->set('alamat', $data['alamat']);
$this->db->set('no_telp', $data['no_telp']);
$this->db->set('kd_prodi', $data['kd_prodi']);
$this->db->set('kd_dosen', $data['kd_dosen']);
$this->db->set('nama_ortu', $data['nama_ortu']);
$this->db->set('alamat_ortu', $data['alamat_ortu']);
$this->db->set('pekerjaan', $data['pekerjaan']);
$this->db->set('telp_ortu', $data['telp_ortu']);
$this->db->set('status', 'Mahasiswa Aktif');
$this->db->set('CUID', $this->session->userdata('user_id'));
$this->db->set('CDATE', date('Y-m-d H:i:s'));
$this->db->insert('tbl_mahasiswa');
$this->db->trans_complete();
return $this->db->trans_status();
}
function UpdateOnDb($data)
{
//query edit data
$this->db->flush_cache();
$this->db->flush_cache();
$this->db->set('penguji1', $data['penguji1']);
$this->db->set('penguji2', $data['penguji2']);
$this->db->set('ketua_sidang', $data['ketua_sidang']);
$this->db->set('sidang', $data['sidang']);
$this->db->set('keterangan', $data['keterangan']);
$this->db->set('sk_yudisium', $data['sk_yudisium']);
//$this->db->set('tgl_daftar',date('Y-m-d'));
$this->db->set('tgl_sidang', FormatDateToMysql($data['tgl_sidang']));
$this->db->set('tgl_yudisium', FormatDateToMysql($data['tgl_yudisium']));
// $this->db->set('tgl_selesai', date('Y-m-d', strtotime("+6 months", strtotime(FormatDateToMysql($data['tgl_mulai'])))));
if ($data['file_upload'] != '') {
$this->db->set('file_ta', $data['file_upload']);
}
$this->db->set('MUID', $this->session->userdata('user_id'));
$this->db->set('MDATE', date('Y-m-d H:i:s'));
$this->db->where('id', $data['id']);
$result = $this->db->update('tbl_sidang');
//update tabel mahasiswa
if ($data['sidang'] == 'Lulus') {
$this->db->flush_cache();
$this->db->where('nim', $data['nim']);
$this->db->set('status', 'Lulus');
$this->db->set('tahun_lulus', substr($data['tgl_yudisium'], 6, 4));
$result = $this->db->update('tbl_mahasiswa');
}
if ($data['sidang'] == 'Tidak Lulus') {
$this->db->flush_cache();
$this->db->where('nim', $data['nim']);
$this->db->set('status', 'Mahasiswa Aktif');
$this->db->set('tahun_lulus', '');
$result = $this->db->update('tbl_mahasiswa');
}
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function UpdateOnDb($data)
{
//query update data
$this->db->flush_cache();
$this->db->set('id_tahunajaran', $data['id_tahunajaran'] . $data['semester']);
$this->db->set('kd_pt', $data['kd_pt']);
$this->db->set('kd_fakultas', $data['kd_fakultas']);
$this->db->set('kd_prodi', $data['kd_prodi']);
$this->db->set('Nama', $data['Nama']);
$this->db->set('TglKRSMulai', FormatDateToMysql($data['TglKRSMulai']));
$this->db->set('TglKRSSelesai', FormatDateToMysql($data['TglKRSSelesai']));
$this->db->set('TglKRSOnlineMulai', FormatDateToMysql($data['TglKRSOnlineMulai']));
$this->db->set('TglKRSOnlineSelesai', FormatDateToMysql($data['TglKRSOnlineSelesai']));
$this->db->set('TglUbahKRSMulai', FormatDateToMysql($data['TglUbahKRSMulai']));
$this->db->set('TglUbahKRSSelesai', FormatDateToMysql($data['TglUbahKRSSelesai']));
$this->db->set('TglCetakKSS1', FormatDateToMysql($data['TglCetakKSS1']));
$this->db->set('TglCetakKSS2', FormatDateToMysql($data['TglCetakKSS2']));
$this->db->set('TglCuti', FormatDateToMysql($data['TglCuti']));
$this->db->set('TglMundur', FormatDateToMysql($data['TglMundur']));
$this->db->set('TglBayarMulai', FormatDateToMysql($data['TglBayarMulai']));
$this->db->set('TglBayarSelesai', FormatDateToMysql($data['TglBayarSelesai']));
$this->db->set('TglKembaliUangKuliah', FormatDateToMysql($data['TglKembaliUangKuliah']));
$this->db->set('TglKuliahMulai', FormatDateToMysql($data['TglKuliahMulai']));
$this->db->set('TglKuliahSelesai', FormatDateToMysql($data['TglKuliahSelesai']));
$this->db->set('TglUTSMulai', FormatDateToMysql($data['TglUTSMulai']));
$this->db->set('TglUTSSelesai', FormatDateToMysql($data['TglUTSSelesai']));
$this->db->set('TglUASMulai', FormatDateToMysql($data['TglUASMulai']));
$this->db->set('TglUASSelesai', FormatDateToMysql($data['TglUASSelesai']));
$this->db->set('TglNilai', FormatDateToMysql($data['TglNilai']));
$this->db->set('TglAkhirKSS', FormatDateToMysql($data['TglAkhirKSS']));
$this->db->set('SP', $data['semester'] == '3' ? 'Y' : 'N');
$this->db->set('Catatan', $data['Catatan']);
//$this->db->set('CUID', $this->session->userdata('user_id'));
//$this->db->set('CDATE', date('Y-m-d H:i:s'));
$this->db->set('MUID', $this->session->userdata('user_id'));
$this->db->set('MDATE', date('Y-m-d H:i:s'));
$this->db->set('Status', isset($data['Status']) ? 'A' : 'D');
$this->db->where('id_tahunajaran', $data['kode']);
$this->db->where('kd_pt', $data['kd_pt']);
$this->db->where('kd_prodi', $data['kd_prodi']);
$result = $this->db->update('tbl_tahunajaran');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
function UpdateOnDb($data)
{
//query insert data
$this->db->flush_cache();
$this->db->set('thn_angkatan', $data['thn_angkatan']);
$this->db->set('nim', $data['nim']);
$this->db->set('nama', $data['nama']);
$this->db->set('tempat_lahir', $data['tempat_lahir']);
$this->db->set('tgl_lahir', FormatDateToMysql($data['tgl_lahir']));
$this->db->set('kd_jk', $data['kd_jk']);
$this->db->set('kd_kabup', $data['kd_kabup']);
$this->db->set('alamat', $data['alamat']);
$this->db->set('no_telp', $data['no_telp']);
$this->db->set('kd_prodi', $data['kd_prodi']);
$this->db->set('kd_program', $data['kd_program']);
$this->db->set('kd_dosen', $data['kd_dosen']);
$this->db->set('nama_ortu', $data['nama_ortu']);
$this->db->set('alamat_ortu', $data['alamat_ortu']);
$this->db->set('pekerjaan', $data['pekerjaan']);
$this->db->set('telp_ortu', $data['telp_ortu']);
if ($data['passwd'] != '') {
$this->db->set('passwd', md5($data['passwd']));
}
$this->db->set('user_level_id', $data['user_level_id']);
$this->db->set('status', $data['status']);
$this->db->where('kd_mahasiswa', $data['kd_mahasiswa']);
$result = $this->db->update('tbl_mahasiswa');
//return
if ($result) {
return TRUE;
} else {
return FALSE;
}
}
