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