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 Wishlist_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('customers.name,customers.email, products.title,products.product_code')->from('wishlist')->join('customers', 'customers.id_customers = wishlist.customer_id', 'left')->join('products', 'products.id_products = wishlist.product_id', 'left')->order_by('customers.name', 'asc'); $query = $this->db->get()->result(); $date = date("Y-m-d"); header("Content-type: application/vnd-ms-excel"); header("Content-Disposition: attachment; filename=indolok_wishlist_excel_report_".$date.".xls"); $data['wishlist'] = $query; $this->load->view('wishlist_excel', $data); // $this->excel->stream('customer.xls', $data); } }