Advertisement
jamboljack

Import Excel

May 14th, 2015
401
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.05 KB | None | 0 0
  1. function do_upload()
  2. {
  3.     $config['upload_path'] = './temp_upload/';
  4.     $config['allowed_types'] = 'xls';
  5.  
  6.     $this->load->library('upload', $config);
  7.  
  8.     if ( ! $this->upload->do_upload())
  9.     {
  10.         $data = array('error' => $this->upload->display_errors());
  11.     }
  12.     else
  13.     {
  14.        
  15.     $data = array('error' => false);
  16.     $upload_data = $this->upload->data();
  17.  
  18.         $this->load->library('excel_reader');
  19.     $this->excel_reader->setOutputEncoding('CP1251');
  20.  
  21.     $file =  $upload_data['full_path'];
  22.     $this->excel_reader->read($file);
  23.     error_reporting(E_ALL ^ E_NOTICE);
  24.  
  25.     // Sheet 1
  26.     $data = $this->excel_reader->sheets[0] ;
  27.            
  28.         $dataexcel = Array();
  29.     for ($i = 1; $i <= $data['numRows']; $i++) {
  30.         if ($data['cells'][$i][1] == '') break;
  31.         // Variabel Data NIM
  32.         $alumni_nim = $data['cells'][$i][1];
  33.         // Pengecekan jika ada NIM sama                    
  34.         $cek_data = $this->import_model->cek_data($alumni_nim)->result();
  35.         $jml_data = count($cek_data);
  36.                
  37.         if ($jml_data == 0) {
  38.             $dataexcel[$i-1]['alumni_nim'] = $data['cells'][$i][1];
  39.                     $dataexcel[$i-1]['alumni_nama'] = $data['cells'][$i][2];
  40.                     $dataexcel[$i-1]['fakultas_id'] = $data['cells'][$i][3];
  41.                     $dataexcel[$i-1]['progdi_id'] = $data['cells'][$i][4];
  42.                     $dataexcel[$i-1]['alumni_tmpt_lhr'] = $data['cells'][$i][5];
  43.                     $dataexcel[$i-1]['alumni_tgl_lhr'] = $data['cells'][$i][6];
  44.                     $dataexcel[$i-1]['alumni_hp'] = $data['cells'][$i][7];
  45.                     $dataexcel[$i-1]['alumni_agama'] = $data['cells'][$i][8];
  46.                     $dataexcel[$i-1]['alumni_tgl_masuk'] = $data['cells'][$i][9];
  47.                     $dataexcel[$i-1]['alumni_tgl_lulus'] = $data['cells'][$i][10];
  48.                 }
  49.                 else
  50.                 {
  51.                     echo 'NIM sudah Ada.';
  52.                 }
  53.     }
  54.     delete_files($upload_data['file_path']);            
  55.         $this->import_model->tambahdataalumni($dataexcel);
  56.         $data['alumni'] = $this->import_model->getuser();
  57.     }
  58. $this->template->display('panel/hasil_import_v', $data);
  59. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement