"; $export_xls .=""; $export_xls .=""; $export_xls .=""; $export_xls .=""; $export_xls .=""; if ($filter_group == 'year') { $export_xls .= ""; } elseif ($filter_group == 'quarter') { $export_xls .= ""; $export_xls .= ""; } elseif ($filter_group == 'month') { $export_xls .= ""; $export_xls .= ""; } elseif ($filter_group == 'day') { $export_xls .= ""; } elseif ($filter_group == 'order') { $export_xls .= ""; $export_xls .= ""; } else { $export_xls .= ""; $export_xls .= ""; } isset($_POST['so20']) ? $export_xls .= "" : ''; isset($_POST['so21']) ? $export_xls .= "" : ''; isset($_POST['so22']) ? $export_xls .= "" : ''; isset($_POST['so23']) ? $export_xls .= "" : ''; isset($_POST['so24']) ? $export_xls .= "" : ''; isset($_POST['so25']) ? $export_xls .= "" : ''; isset($_POST['so27']) ? $export_xls .= "" : ''; isset($_POST['so26']) ? $export_xls .= "" : ''; isset($_POST['so28']) ? $export_xls .= "" : ''; isset($_POST['so29']) ? $export_xls .= "" : ''; isset($_POST['so30']) ? $export_xls .= "" : ''; isset($_POST['so31']) ? $export_xls .= "" : ''; isset($_POST['so32']) ? $export_xls .= "" : ''; isset($_POST['so33']) ? $export_xls .= "" : ''; $export_xls .=""; foreach ($results as $result) { $export_xls .=""; if ($filter_group == 'year') { $export_xls .= ""; } elseif ($filter_group == 'quarter') { $export_xls .= ""; $export_xls .= ""; } elseif ($filter_group == 'month') { $export_xls .= ""; $export_xls .= ""; } elseif ($filter_group == 'day') { $export_xls .= ""; } elseif ($filter_group == 'order') { $export_xls .= ""; $export_xls .= ""; } else { $export_xls .= ""; $export_xls .= ""; } isset($_POST['so20']) ? $export_xls .= "" : ''; isset($_POST['so21']) ? $export_xls .= "" : ''; isset($_POST['so22']) ? $export_xls .= "" : ''; isset($_POST['so23']) ? $export_xls .= "" : ''; isset($_POST['so24']) ? $export_xls .= "" : ''; isset($_POST['so25']) ? $export_xls .= "" : ''; isset($_POST['so27']) ? $export_xls .= "" : ''; isset($_POST['so26']) ? $export_xls .= "" : ''; isset($_POST['so28']) ? $export_xls .= "" : ''; isset($_POST['so29']) ? $export_xls .= "" : ''; isset($_POST['so30']) ? $export_xls .= "" : ''; isset($_POST['so31']) ? $export_xls .= "" : ''; isset($_POST['so32']) ? $export_xls .= "" : ''; isset($_POST['so33']) ? $export_xls .= "" : ''; $export_xls .=""; } $export_xls .=""; $export_xls .= ""; isset($_POST['so20']) ? $export_xls .= "" : ''; isset($_POST['so21']) ? $export_xls .= "" : ''; isset($_POST['so22']) ? $export_xls .= "" : ''; isset($_POST['so23']) ? $export_xls .= "" : ''; isset($_POST['so24']) ? $export_xls .= "" : ''; isset($_POST['so25']) ? $export_xls .= "" : ''; isset($_POST['so27']) ? $export_xls .= "" : ''; isset($_POST['so26']) ? $export_xls .= "" : ''; isset($_POST['so28']) ? $export_xls .= "" : ''; isset($_POST['so29']) ? $export_xls .= "" : ''; isset($_POST['so30']) ? $export_xls .= "" : ''; isset($_POST['so31']) ? $export_xls .= "" : ''; isset($_POST['so32']) ? $export_xls .= "" : ''; isset($_POST['so33']) ? $export_xls .= "" : ''; $export_xls .="

".$this->language->get('column_year')."

".$this->language->get('column_year')."

".$this->language->get('column_quarter')."

".$this->language->get('column_year')."

".$this->language->get('column_month')."

".$this->language->get('column_date')."

".$this->language->get('column_order_order_id')."

".$this->language->get('column_order_date_added')."

".$this->language->get('column_date_start')."

".$this->language->get('column_date_end')."

".$this->language->get('column_orders')."

".$this->language->get('column_customers')."

".$this->language->get('column_products')."

".$this->language->get('column_sub_total')."

".$this->language->get('column_handling')."

".$this->language->get('column_loworder')."

".$this->language->get('column_shipping')."

".$this->language->get('column_reward')."

".$this->language->get('column_coupon')."

".$this->language->get('column_tax')."

".$this->language->get('column_credit')."

".$this->language->get('column_voucher')."

".$this->language->get('column_commission')."

".$this->language->get('column_total')."

".$result['year']."

".$result['year']."

".'Q' . $result['quarter']."

".$result['year']."

".$result['month']."

".date($this->language->get('date_format_short'), strtotime($result['date_start']))."

".$result['order_id']."

".date($this->language->get('date_format_short'), strtotime($result['date_start']))."

".date($this->language->get('date_format_short'), strtotime($result['date_start']))."

".date($this->language->get('date_format_short'), strtotime($result['date_end']))."

".$result['orders']."

".$result['customers']."

".$result['products']."

".$result['sub_total']."

".$result['handling']."

".$result['low_order_fee']."

".$result['shipping']."

".$result['reward']."

".$result['coupon']."

".$result['tax']."

".$result['credit']."

".$result['voucher']."

".-$result['commission']."

".$result['total']."

".$this->language->get('text_filter_total')."

".$result['orders_total']."

".$result['customers_total']."

".$result['products_total']."

".$result['sub_total_total']."

".$result['handling_total']."

".$result['low_order_fee_total']."

".$result['shipping_total']."

".$result['reward_total']."

".$result['coupon_total']."

".$result['tax_total']."

".$result['credit_total']."

".$result['voucher_total']."

".-$result['commission_total']."

".$result['total_total']."

"; $export_xls .=""; $filename = "sale_order_report_".date("Y-m-d",time()); header('Expires: 0'); header('Cache-control: private'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Content-Description: File Transfer'); header('Content-Type: application/vnd.ms-excel; charset=UTF-8; encoding=UTF-8'); header('Content-Disposition: attachment; filename='.$filename.".xls"); header('Content-Transfer-Encoding: UTF-8'); print $export_xls; exit; ?>