Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function do_upload2()
- {
- $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());
- $this->session->set_flashdata('msg_excel', 'Insert failed. Please check your file, only .xls file allowed.');
- }
- 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] ;
- // Ambil Data
- $dataexcelalumni = Array();
- for ($i = 1; $i <= $data['numRows']; $i++) {
- if($data['cells'][$i][1] == '') break;
- $tgl_lhr = $data['cells'][$i][6];
- $date_lahir = date('Y-m-d', strtotime($tgl_lhr));
- $tgl_masuk = $data['cells'][$i][9];
- $date_masuk = date('Y-m-d', strtotime($tgl_masuk));
- $tgl_lulus = $data['cells'][$i][10];
- $date_lulus = date('Y-m-d', strtotime($tgl_lulus));
- $dataexcelalumni[$i-1]['alumni_nim'] = $data['cells'][$i][1];
- $dataexcelalumni[$i-1]['alumni_nama'] = $data['cells'][$i][2];
- $dataexcelalumni[$i-1]['fakultas_id'] = $data['cells'][$i][3];
- $dataexcelalumni[$i-1]['progdi_id'] = $data['cells'][$i][4];
- $dataexcelalumni[$i-1]['alumni_tmpt_lhr'] = $data['cells'][$i][5];
- $dataexcelalumni[$i-1]['alumni_tgl_lhr'] = $date_lahir;
- $dataexcelalumni[$i-1]['alumni_hp'] = $data['cells'][$i][7];
- $dataexcelalumni[$i-1]['alumni_agama'] = $data['cells'][$i][8];
- $dataexcelalumni[$i-1]['alumni_tgl_masuk'] = $date_masuk;
- $dataexcelalumni[$i-1]['alumni_tgl_lulus'] = $date_lulus;
- $dataexcelalumni[$i-1]['user_username'] = $data['cells'][$i][11];
- $dataexcelalumni[$i-1]['user_password'] = $data['cells'][$i][12];
- }
- //cek data
- $check= $this->import_model->search_nim($dataexcelalumni);
- if (count($check) > 0)
- {
- $this->import_model->update_alumni($dataexcelalumni);
- }
- else
- {
- $this->import_model->insert_alumni($dataexcelalumni);
- }
- }
- delete_files($upload_data['file_path']);
- $data['data_import'] = $this->import_model->select_import()->result(); // Insert Data Users
- $this->template->display('panel/hasil_import_v', $data);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement