Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function do_upload()
- {
- $config['upload_path'] = './temp_upload/';
- $config['allowed_types'] = 'xls';
- $this->load->library('upload', $config);
- if ( ! $this->upload->do_upload())
- {
- $data = array('error' => $this->upload->display_errors());
- }
- else
- {
- $data = array('error' => false);
- $upload_data = $this->upload->data();
- $this->load->library('excel_reader');
- $this->excel_reader->setOutputEncoding('CP1251');
- $file = $upload_data['full_path'];
- $this->excel_reader->read($file);
- error_reporting(E_ALL ^ E_NOTICE);
- // Sheet 1
- $data = $this->excel_reader->sheets[0] ;
- $dataexcel = Array();
- for ($i = 1; $i <= $data['numRows']; $i++) {
- if ($data['cells'][$i][1] == '') break;
- // Variabel Data NIM
- $alumni_nim = $data['cells'][$i][1];
- // Pengecekan jika ada NIM sama
- $cek_data = $this->import_model->cek_data($alumni_nim)->result();
- $jml_data = count($cek_data);
- if ($jml_data == 0) {
- $dataexcel[$i-1]['alumni_nim'] = $data['cells'][$i][1];
- $dataexcel[$i-1]['alumni_nama'] = $data['cells'][$i][2];
- $dataexcel[$i-1]['fakultas_id'] = $data['cells'][$i][3];
- $dataexcel[$i-1]['progdi_id'] = $data['cells'][$i][4];
- $dataexcel[$i-1]['alumni_tmpt_lhr'] = $data['cells'][$i][5];
- $dataexcel[$i-1]['alumni_tgl_lhr'] = $data['cells'][$i][6];
- $dataexcel[$i-1]['alumni_hp'] = $data['cells'][$i][7];
- $dataexcel[$i-1]['alumni_agama'] = $data['cells'][$i][8];
- $dataexcel[$i-1]['alumni_tgl_masuk'] = $data['cells'][$i][9];
- $dataexcel[$i-1]['alumni_tgl_lulus'] = $data['cells'][$i][10];
- }
- else
- {
- echo 'NIM sudah Ada.';
- }
- }
- delete_files($upload_data['file_path']);
- $this->import_model->tambahdataalumni($dataexcel);
- $data['alumni'] = $this->import_model->getuser();
- }
- $this->template->display('panel/hasil_import_v', $data);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement