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