function cek_login()
{
$query = "select *\r\n from tb_users\r\n where username = '******'username') . "' and password = '******'password')) . "'";
//echo $query;
$hasil = $this->db->query($query);
return $hasil->row();
}
function cek_login()
{
$query = "select u.id, u.username, u.nama, u.password, ug.id as id_group\r\n from tb_users u\r\n join tb_user_group ug on (ug.id = u.id_user_group)\r\n where u.username = '******'username') . "' and u.password = '******'password')) . "'";
//echo $query;
$hasil = $this->db->query($query);
return $hasil->row();
}
function signup_post()
{
$tgl_lahir = post_safe('year') . '-' . post_safe('month') . '-' . post_safe('date');
$param = array('nama_depan' => post_safe('nama_depan'), 'nama_belakang' => post_safe('nama_belakang'), 'tanggal_lahir' => $tgl_lahir, 'jekel' => post_safe('jekel'), 'email' => post_safe('email'), 'password' => md5(post_safe('password')));
$data = $this->m_user->save_registration($param);
$this->response($data, 200);
}
function logmein_post()
{
$param = array('email' => post_safe('username'), 'password' => md5(post_safe('password')));
$data = $this->m_user->logmein_member($param);
if ($data['status'] === TRUE) {
$session = array('id_user' => $data['data']->id, 'nama_depan' => $data['data']->nama_depan, 'nama_belakang' => $data['data']->nama_belakang, 'name' => $data['data']->nama_depan . ' ' . $data['data']->nama_belakang, 'image' => $data['data']->foto_profile, 'email' => $data['data']->email);
$this->session->set_userdata($session);
$result = $data;
} else {
$result = $data;
}
$this->response($result, 200);
}
function change_password()
{
$data_post = array('passlama' => post_safe('passlama'), 'passbaru' => post_safe('passbaru'), 'ulangipass' => post_safe('ulangipass'));
$check = $this->db->get_where('tb_users', array('id' => $this->session->userdata('id_user'), 'password' => md5($data_post['passlama'])))->num_rows();
if ($check === 0) {
$result['status'] = FALSE;
$result['message'] = 'Password lama yang anda masukkan salah !';
} else {
$this->db->where('id', $this->session->userdata('id_user'));
$this->db->update('tb_users', array('password' => md5($data_post['passbaru'])));
$result['status'] = TRUE;
$result['message'] = 'Password barhasil diubah !';
}
return $result;
}
function save_penerimaan()
{
$id = post_safe('id');
$data_array = array('id_parent' => post_safe('parent') !== '' ? post_safe('parent') : NULL, 'kode' => post_safe('judul'), 'nama_program' => post_safe('isi'), 'nominal' => currencyToNumber(post_safe('nominal')), 'id_tahun_anggaran' => post_safe('id_tahun_anggaran'));
if ($id === '') {
$this->db->insert('tb_master_penerimaan', $data_array);
$result['act'] = 'add';
$result['id'] = $this->db->insert_id();
} else {
$this->db->where('id', $id);
$this->db->update('tb_master_penerimaan', $data_array);
$result['act'] = 'edit';
$result['id'] = $id;
}
return $result;
}
function save_image_slider()
{
$UploadDirectory = 'assets/images/slideshow/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
$data_image = array('id' => post_safe('id'), 'judul' => post_safe('judul'), 'keterangan' => post_safe('keterangan'));
if ($data_image['id'] === '') {
$this->db->insert('tb_slider', $data_image);
$id_slider = $this->db->insert_id();
$result['act'] = 'add';
} else {
$this->db->where('id', $data_image['id']);
$this->db->update('tb_slider', $data_image);
$id_slider = $data_image['id'];
$result['act'] = 'edit';
}
if (isset($_FILES['mFile']['name'])) {
$foto = post_safe('foto');
$FileName = strtolower($_FILES['mFile']['name']);
//uploaded file name
//$FileTitle = $FileName;
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['mFile']['type'];
//file type
//$FileSize = $_FILES['mFile']["size"]; //file size
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
//$uploaded_date = date("Y-m-d H:i:s");
if ($foto !== '') {
@unlink('assets/images/slideshow/' . $foto);
}
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
// case 'application/pdf': //PDF file
// case 'application/msword': //ms word file
// case 'application/vnd.ms-excel': //ms excel file
// case 'application/x-zip-compressed': //zip file
// case 'text/plain': //text file
// case 'text/html': //html file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_image['judul']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['mFile']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $id_slider);
$this->db->update('tb_slider', array('gambar' => $NewFileName));
} else {
die('error uploading File!');
}
}
return $result;
}
function save_places($data)
{
$this->db->trans_begin();
if ($data['id'] === '') {
$add = array();
if (post_safe('kategori') === '3') {
$add = array('reservasi' => post_safe('reservasi'), 'kursi_ruang_terbuka' => post_safe('krt'), 'akses_kursi_roda' => post_safe('akr'), 'opsi_makan' => post_safe('opsi_makan'), 'parkir' => post_safe('parkir'), 'toilet' => post_safe('toilet'), 'credit_card' => post_safe('cc'));
}
$this->db->insert('tb_lokasi', array_merge($data, $add));
$result['act'] = 'add';
$id = $this->db->insert_id();
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
$param_lokasi_kategori = array('id_lokasi' => $id, 'id_kategori' => post_safe('kategori'));
$this->db->insert('tb_kategori_lokasi', $param_lokasi_kategori);
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
} else {
$this->db->where('id', $data['id']);
$this->db->update('tb_lokasi', $data);
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
$result['act'] = 'edit';
$result['id'] = $data['id'];
$this->db->delete('tb_kategori_lokasi', array('id_lokasi' => $data['id']));
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
$param_lokasi_kategori = array('id_lokasi' => $data['id'], 'id_kategori' => post_safe('kategori'));
$this->db->insert('tb_kategori_lokasi', $param_lokasi_kategori);
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
} else {
$this->db->trans_commit();
$result['status'] = TRUE;
}
return $result;
}
function save_bulan_rencana_terbang()
{
$kode_latihan = post_safe('kode_latihan');
$rencana = post_safe('rencana');
$bulan = post_safe('tanggal') . '-01';
$this->db->delete('tb_rencana_jam_lat_ops', array('bulan' => $bulan));
foreach ($kode_latihan as $key => $data) {
$time = $rencana[$key] . ':00';
$parsed = explode(':', $time);
$seconds = $parsed[0] * 3600 + $parsed[1] * 60 + $parsed[2];
$array = array('bulan' => $bulan, 'id_kode_latihan' => $data, 'jumlah' => $seconds);
$this->db->insert('tb_rencana_jam_lat_ops', $array);
}
return TRUE;
}
function kategori_post()
{
$param = array('id' => post_safe('id'), 'id_parent' => post_safe('kategori') !== '' ? post_safe('kategori') : NULL, 'nama' => post_safe('nama'), 'keterangan' => post_safe('keterangan'), 'icon' => post_safe('fontawesome'));
$data = $this->m_masterdata->save_layanan($param);
$this->response($data, 200);
}
function save_import_pembayaran_mahasiswa()
{
$this->db->trans_begin();
$id = post_safe('id');
$UploadDirectory = 'assets/images/company/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
//die($UploadDirectory);
// replace with your mysql database details
if (!@file_exists($UploadDirectory)) {
//destination folder does not exist
die('No upload directory');
}
if ($id === '') {
if (isset($_FILES['mFile']['name'])) {
$foto = post_safe('foto');
$FileName = strtolower($_FILES['mFile']['name']);
//uploaded file name
$FileTitle = 'slide';
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['mFile']['type'];
//file type
//$FileSize = $_FILES['mFile']["size"]; //file size
$RandNumber = rand(0, 9999999999);
//Random number to make each filename unique.
//$uploaded_date = date("Y-m-d H:i:s");
if ($foto !== '') {
@unlink('assets/img/content/' . $foto);
}
switch (strtolower($FileType)) {
//allowed file types
case 'application/wps-office.xls':
//ms excel file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($FileTitle));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
/*if(move_uploaded_file($_FILES['mFile']["tmp_name"], $UploadDirectory . $NewFileName ))
{
//die('Success! File Uploaded.');
}else{
//die('error uploading File!');
}*/
}
// membaca file excel yang diupload
$data = new Spreadsheet_Excel_Reader($_FILES['mFile']['tmp_name']);
// membaca jumlah baris dari data excel
$baris = $data->rowcount($sheet_index = 0);
for ($i = 2; $i <= $baris; $i++) {
$nim = trim($data->val($i, 1));
$tanggal = $data->val($i, 3);
$transaksi = $data->val($i, 4);
$jumlah = $data->val($i, 5);
$norek = $data->val($i, 6);
//echo $nim.'#'.$tanggal.'#'.$transaksi.'#'.$jumlah.'#'.$norek.'<br/>';
$get = $this->db->query("select row_id from tb_mahasiswa where k_mhs = '{$nim}'")->row();
$get2 = $this->db->query("select id from tb_jenis_penerimaan where nama = '{$transaksi}'")->row();
$get3 = $this->db->query("select id from tb_bank where no_rekening = '{$norek}'")->row();
$array = array('tanggal' => date2mysql($tanggal), 'id_jenis_penerimaan' => $get2->id, 'id_mhs' => $get->row_id, 'nominal' => currencyToNumber($jumlah), 'id_bank' => $get3->id);
$this->db->insert('tb_pembayaran', $array);
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
} else {
$this->db->trans_commit();
$result['status'] = TRUE;
}
}
return $result;
}
function profile_buku_post()
{
$param = array('id' => post_safe('id'), 'kd_profile' => post_safe('kode'), 'nama' => post_safe('nama'), 'hrg_sewa' => currencyToNumber(post_safe('harga')), 'waktu' => post_safe('lama'), 'status' => post_safe('status'), 'ket' => post_safe('keterangan'));
$data = $this->m_masterdata->save_profile_buku($param);
$this->response($data, 200);
}
function drp_post()
{
$data_array = array('id' => post_safe('id'), 'tanggal' => date2mysql(post_safe('tanggal')), 'penemu' => post_safe('penemu'), 'id_pasien' => post_safe('pasien_auto'), 'id_fase' => post_safe('fase'), 'id_tipe_mederr' => post_safe('tipe_mederr'), 'masalah' => post_safe('masalah'), 'id_barang' => post_safe('nama_obat'), 'id_komunikasi' => post_safe('komunikasi'), 'id_saran' => post_safe('saran'), 'penyelesaian' => post_safe('penyelesaian'), 'id_kategori_mederr' => post_safe('kategori_mederr'), 'id_respon' => post_safe('respon'));
$data = $this->m_farklin->save_drp($data_array);
$this->response($data, 200);
}
function manage_privileges($mode)
{
switch ($mode) {
case 'list':
$id = get_safe('id');
$data = $this->get_group_privileges($id);
$this->load->view('masterdata/list_privileges', $data);
break;
case 'add':
$add = array('privileges' => post_safe('data'), 'id_group' => post_safe('id_group'));
$this->m_masterdata->privileges_edit_data($add);
$data = $this->get_group_privileges(post_safe('id_group'));
$this->load->view('masterdata/list_privileges', $data);
break;
default:
break;
}
}
function save_institusi_post()
{
$array = array('id' => post_safe('id'), 'nama' => post_safe('nama'), 'alamat' => post_safe('alamat'), 'provinsi' => post_safe('provinsi'), 'kabupaten' => post_safe('kabupaten'), 'kecamatan' => post_safe('kecamatan'), 'kelurahan' => post_safe('kelurahan'), 'kepala' => post_safe('kepsek'), 'nip_kepala' => post_safe('nipkepsek'), 'ketua_komite' => post_safe('ketua_komite'), 'bendahara' => post_safe('bendahara'), 'nip_bendahara' => post_safe('nip_bendahara'), 'nsm' => post_safe('nsm'));
$data = $this->m_config->save_config_institusi($array);
$this->response($data, 200);
}
function pencairan_post()
{
$data_array = array('id' => post_safe('id'), 'tanggal' => date2mysql(post_safe('tanggal')), 'tanggal_kegiatan' => date2mysql(post_safe('tanggal_kegiatan')), 'id_rka' => post_safe('nokode'), 'no_bukti' => post_safe('nobukti'), 'uraian' => post_safe('uraian'), 'satuan' => post_safe('satuan'), 'volume' => post_safe('volume'), 'nominal' => currencyToNumber(post_safe('nominal')), 'penerima' => post_safe('penerima'), 'id_tahun_anggaran' => $this->id_tahun_anggaran);
$data = $this->m_transaksi->save_pencairan($data_array);
$this->response($data, 200);
}
function account_post()
{
$param = array('nama' => post_safe('nama_user'), 'username' => post_safe('username'), 'id_user_group' => post_safe('group'), 'id' => post_safe('id_account'));
$data = $this->m_configuration->save_account($param);
$this->response($data, 200);
}
function save_set_daily_program_report()
{
$id = post_safe('id');
$kategori = post_safe('kategori');
$nama = post_safe('nama');
$tanggal = date2mysql(post_safe('tanggal'));
$start = post_safe('start');
$end = post_safe('end');
$status = post_safe('status');
$data = array('id' => $id, 'id_kategori' => $kategori, 'nama' => $nama, 'tanggal' => $tanggal, 'time_start' => $start, 'time_end' => $end, 'status' => $status !== '' ? $status : NULL);
if ($data['id'] !== '') {
$this->db->where('id', $data['id']);
$this->db->update('tb_daily_program', $data);
$result['act'] = 'edit';
$result['id'] = $data['id'];
}
return $result;
}
function save_pendaftaran_sumb()
{
$this->db->trans_begin();
$data_array = array('no_pendaftaran' => $this->create_no_daftar('SUMB'), 'tahun_ajaran' => post_safe('tahun_ajaran'), 'nama' => post_safe('nama_lengkap'), 'tempat' => post_safe('tempat_lahir'), 'tanggal_lahir' => date2mysql(post_safe('tanggal_lahir')), 'agama' => post_safe('agama'), 'jekel' => post_safe('jenis_kelamin'), 'alamat' => post_safe('alamat_rumah'), 'rt' => post_safe('rt'), 'rw' => post_safe('rw'), 'kabupaten' => post_safe('kabupaten'), 'kecamatan' => post_safe('kecamatan'), 'desa' => post_safe('desa'), 'id_desa' => NULL, 'telp' => post_safe('telp'), 'nama_ayah' => post_safe('nama_ayah'), 'nama_ibu' => post_safe('nama_ibu'), 'pekerjaan_ayah' => post_safe('pekerjaan_ayah'), 'pekerjaan_ibu' => post_safe('pekerjaan_ibu'), 'penghasilan_ayah' => currencyToNumber(post_safe('penghasilan_ayah')), 'penghasilan_ibu' => currencyToNumber(post_safe('penghasilan_ibu')), 'pembiaya' => post_safe('biayai'), 'nama_wali' => post_safe('nama_wali'), 'hubungan_wali' => post_safe('hubungan_wali'), 'penghasilan_wali' => currencyToNumber(post_safe('penghasilan_wali')), 'alamat_wali' => post_safe('alamat_wali'), 'asal_sekolah' => post_safe('asal_sekolah'), 'jurusan' => post_safe('jurusan'), 'status_sekolah' => post_safe('status_sekolah'), 'alamat_sekolah' => post_safe('alamat_sekolah'), 'telp_sekolah' => post_safe('telp_sekolah'), 'prodi_pil_1' => post_safe('pilihan1'), 'prodi_pil_2' => post_safe('pilihan2'), 'jenis_daftar' => 'SUMB');
$this->db->insert('tb_pendaftaran', $data_array);
$result['id'] = $this->db->insert_id();
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
} else {
$this->db->trans_commit();
$result['status'] = TRUE;
}
$UploadDirectory = 'assets/img/pendaftaran/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
if (!@file_exists($UploadDirectory)) {
//destination folder does not exist
die('No upload directory');
}
if (isset($_FILES['ijasah']['name'])) {
$FileName = strtolower($_FILES['ijasah']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['ijasah']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['ijasah']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('ijasah' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['hasil_un']['name'])) {
$FileName = strtolower($_FILES['hasil_un']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['hasil_un']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['hasil_un']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('hasil_un' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti1']['name'])) {
$FileName = strtolower($_FILES['bukti1']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti1']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti1']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti1' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti2']['name'])) {
$FileName = strtolower($_FILES['bukti2']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti2']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti2']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti2' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti3']['name'])) {
$FileName = strtolower($_FILES['bukti3']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti3']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti3']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti3' => $NewFileName));
} else {
die('error uploading File!');
}
}
if (isset($_FILES['bukti4']['name'])) {
$FileName = strtolower($_FILES['bukti4']['name']);
//uploaded file name
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['bukti4']['type'];
//file type
$RandNumber = rand(0, 99999);
//Random number to make each filename unique.
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($data_array['no_pendaftaran']));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['bukti4']["tmp_name"], $UploadDirectory . $NewFileName)) {
$this->db->where('id', $result['id']);
$this->db->update('tb_pendaftaran', array('bukti4' => $NewFileName));
} else {
die('error uploading File!');
}
}
return $result;
}
function profile_member_post()
{
$UploadDirectory = 'assets/img/profiles/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
//die($UploadDirectory);
// replace with your mysql database details
if (!@file_exists($UploadDirectory)) {
//destination folder does not exist
die('No upload directory');
}
if (isset($_FILES['import']['name'])) {
$foto = post_safe('gambar');
$FileName = strtolower($_FILES['import']['name']);
//uploaded file name
$FileTitle = $FileName;
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['import']['type'];
//file type
//$FileSize = $_FILES['import']["size"]; //file size
$RandNumber = rand(1000000, 9999999);
//Random number to make each filename unique.
//echo $FileType; die;
//$uploaded_date = date("Y-m-d H:i:s");
if ($foto !== '') {
@unlink('assets/img/profiles/' . $foto);
}
switch (strtolower($FileType)) {
//allowed file types
case 'image/png':
//png file
//png file
case 'image/gif':
//gif file
//gif file
case 'image/jpeg':
//jpeg file
// case 'application/pdf': //PDF file
// case 'application/msword': //ms word file
// case 'application/vnd.ms-excel': //ms excel file
// case 'application/octet-stream': //ms excel file
// case 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet': //xlsx file
// case 'text/plain': //text file
// case 'text/html': //html file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
//$NewFileName = preg_replace(array('/\s/', '/\.[\.]+/', '/[^\w_\.\-]/'), array('_', '.', ''), strtolower($FileTitle));
$NewFileName = crypt(post_safe('nama_depan') . $RandNumber) . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['import']["tmp_name"], $UploadDirectory . $NewFileName)) {
$param = array('id' => $this->session->userdata('id_user'), 'nama_depan' => post_safe('nama_depan'), 'nama_belakang' => post_safe('nama_belakang'), 'tanggal_lahir' => date2mysql(post_safe('tanggal_lahir')), 'telp' => post_safe('telp'), 'jekel' => post_safe('jekel'), 'foto_profile' => $NewFileName);
$this->db->where('id', $param['id']);
$this->db->update('tb_member', $param);
$result['status_image'] = TRUE;
$result['id'] = $this->session->userdata('id_user');
} else {
$result['status_image'] = FALSE;
}
} else {
$param = array('id' => $this->session->userdata('id_user'), 'nama_depan' => post_safe('nama_depan'), 'nama_belakang' => post_safe('nama_belakang'), 'tanggal_lahir' => date2mysql(post_safe('tanggal_lahir')), 'telp' => post_safe('telp'), 'jekel' => post_safe('jekel'));
$this->db->where('id', $param['id']);
$this->db->update('tb_member', $param);
$result['status_image'] = FALSE;
}
$this->response($result, 200);
}
function save_config()
{
$data = array('tahun' => post_safe('tahun'), 'form_pmdk' => post_safe('aktif_pmdk'), 'form_sumb' => post_safe('aktif_sumb'));
$this->db->update('tb_ta_aktif', $data);
return TRUE;
}
function upload_history_post()
{
$this->db->trans_begin();
$UploadDirectory = 'assets/excel/';
//Upload Directory, ends with slash & make sure folder exist
$NewFileName = "";
//die($UploadDirectory);
// replace with your mysql database details
if (!@file_exists($UploadDirectory)) {
//destination folder does not exist
die('No upload directory');
}
if (isset($_FILES['import']['name'])) {
// $foto = post_safe('gambar');
$FileName = strtolower($_FILES['import']['name']);
//uploaded file name
$FileTitle = $FileName;
$ImageExt = substr($FileName, strrpos($FileName, '.'));
//file extension
$FileType = $_FILES['import']['type'];
//file type
//$FileSize = $_FILES['import']["size"]; //file size
$RandNumber = '';
//rand(0, 999); //Random number to make each filename unique.
//echo $FileType; die;
//$uploaded_date = date("Y-m-d H:i:s");
// if ($foto !== '') {
// @unlink('assets/images/projects/'.$foto);
// }
switch (strtolower($FileType)) {
//allowed file types
// case 'image/png': //png file
// case 'image/gif': //gif file
// case 'image/jpeg': //jpeg file
// case 'application/pdf': //PDF file
// case 'application/msword': //ms word file
case 'application/vnd.ms-excel':
//ms excel file
//ms excel file
case 'application/octet-stream':
//ms excel file
//ms excel file
case 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet':
//xlsx file
// case 'text/plain': //text file
// case 'text/html': //html file
break;
default:
die('Unsupported File!');
//output error
}
//File Title will be used as new File name
$NewFileName = preg_replace(array('/\\s/', '/\\.[\\.]+/', '/[^\\w_\\.\\-]/'), array('_', '.', ''), strtolower($FileTitle));
$NewFileName = $NewFileName . '_' . $RandNumber . $ImageExt;
//Rename and save uploded file to destination folder.
if (move_uploaded_file($_FILES['import']["tmp_name"], $UploadDirectory . $NewFileName)) {
} else {
die('error uploading File!');
}
}
//$media = $this->upload->data('import');
$inputFileName = './assets/excel/' . $NewFileName;
// Read your Excel workbook
$this->load->library(array('PHPExcel', 'PHPExcel/IOFactory'));
try {
$inputFileType = IOFactory::identify($inputFileName);
$objReader = IOFactory::createReader($inputFileType);
$objPHPExcel = $objReader->load($inputFileName);
} catch (Exception $e) {
die('Error loading file "' . pathinfo($inputFileName, PATHINFO_BASENAME) . '": ' . $e->getMessage());
}
// Get worksheet dimensions
$sheet = $objPHPExcel->getSheet(0);
$highestRow = $sheet->getHighestRow();
$highestColumn = $sheet->getHighestColumn();
// Loop through each row of the worksheet in turn
for ($row = 2; $row <= $highestRow; $row++) {
// Read a row of data into an array
$rowData = $sheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
// Insert row data array into your database of choice here
if ($rowData[0][1] !== NULL) {
$get_data = $this->db->get_where('tb_kategori_cuti', array('id' => post_safe('jenis_pengajuan_cuti')))->row();
$data = array('id_kategori_cuti' => post_safe('jenis_pengajuan_cuti'), 'tanggal' => date2mysql_export($rowData[0][7]), 'nip' => str_replace(' ', '', $rowData[0][2]), 'nama' => $rowData[0][1], 'pangkat' => $rowData[0][3] !== NULL ? $rowData[0][3] : '', 'jabatan' => $rowData[0][4] !== NULL ? $rowData[0][4] : '', 'unit_satuan' => $rowData[0][5] !== NULL ? $rowData[0][5] : '', 'status_pengajuan' => 'Selesai', 'no_ijin' => '', 'jumlah' => $rowData[0][6], 'satuan' => 'Hari', 'dari' => date2mysql_export($rowData[0][7]), 'sampai' => $rowData[0][8] !== NULL ? date2mysql_export($rowData[0][8]) : NULL, 'tanggal_cetak' => date2mysql_export($rowData[0][7]), 'keterangan_disetujui' => $get_data->keterangan_pokok_surat, 'tembusan' => $rowData[0][10] !== NULL ? $rowData[0][10] : '', 'import_excel' => 'Ya');
$this->db->insert('tb_pengajuan_cuti', $data);
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
}
}
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
$result['status'] = FALSE;
} else {
$this->db->trans_commit();
$result['status'] = TRUE;
}
$this->response($result, 200);
}
function jam_logbook_post()
{
$param = array('id_penerbang' => post_safe('id_penerbang'), 'bulan' => post_safe('bulan'), 'dff' => post_safe('dff'), 'dfd' => post_safe('dfd'), 'nff' => post_safe('nff'), 'nfd' => post_safe('nfd'));
$data = $this->m_transaksi->save_jam_logbook($param);
$this->response($data, 200);
}
