|
Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/angkasapuraretail.com/public_html/application/controllers/admin/ |
Upload File : |
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Upload_shipment_price extends Admin_Controller {
public function __construct(){
parent::__construct();
}
public function upload_excel(){
$config['upload_path'] = 'uploads/excel/';
$config['allowed_types'] = 'xlsx|xls';
$this->load->library('upload', $config);
if ( ! $this->upload->do_upload('file_excel')){
$this->session->set_flashdata('upload_excel_info', '<p style="background:red; color:white; padding:5px; font-weight:bold;">'.strip_tags($this->upload->display_errors()).'</p>');
redirect('admin/warehouses');
}
else{
require_once APPPATH . 'third_party/PHPExcel/IOFactory.php';
$data = array('upload_data' => $this->upload->data());
$upload_data = $this->upload->data(); //Mengambil detail data yang di upload
$filename = $upload_data['file_name'];//Nama File
ini_set('memory_limit', '-1');
$inputFileName = 'uploads/excel/'.$filename;
try {
$objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
}
catch(Exception $e) {
die('Error loading file :' . $e->getMessage());
}
$worksheet = $objPHPExcel->getActiveSheet()->toArray(null,true,true,true);
$numRows = count($worksheet);
$this->db->empty_table('indah_cargo');
for ($i=1; $i < ($numRows+1) ; $i++) {
if($i != 1){
$ins = array(
"destination_code" => $worksheet[$i]["D"],
"destination_city" => $worksheet[$i]["B"],
"destination_province" => $worksheet[$i]["C"],
"shipping_time" => $worksheet[$i]["E"],
"destination_price" => $worksheet[$i]["F"],
"destination_price_2" => $worksheet[$i]["G"],
);
$this->db->insert('indah_cargo', $ins);
}
}
unlink('uploads/excel/'.$filename);
$this->session->set_flashdata('upload_excel_info', '<p style="background:green; color:white; padding:5px; font-weight:bold;">Upload Shipment Price File Success</p>');
redirect('admin/warehouses');
}
}
}