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/indolok.id/application/controllers/admin/ |
Upload File : |
<?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Penawaran_excel_export extends Admin_Controller { public function __construct() { parent::__construct(); // Load the Library $this->load->library('excel'); // Load the Model } public function index() { /*$this->excel->setActiveSheetIndex(0);*/ // Gets all the data using MY_Model.php $this->db->select('penawaran_harga.time_added, penawaran_harga.no_penawaran_harga, customers.company_name, penawaran_harga.sub_total, penawaran_harga.total_shipping_fee, penawaran_harga.free_shipping, penawaran_harga.status, penawaran_harga.no_po, sales_list.sales_name')->from('penawaran_harga')->join('customers', 'customers.sales_id = penawaran_harga.sales_id', 'left')->join('sales_list', 'sales_list.employee_id = penawaran_harga.employee_id', 'left')->order_by('penawaran_harga.time_added', 'asc'); $query = $this->db->get()->result(); $date = date("Y-m-d"); header("Content-type: application/vnd-ms-excel"); header("Content-Disposition: attachment; filename=indolok_product_excel_report_".$date.".xls"); $data['penawarans'] = $query; $this->load->view('penawaran_excel', $data); // $this->excel->stream('customer.xls', $data); } }