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); }