/** * Method to get Processed array of data for Export * @param object array $data * return array */ public function export($data) { //include the prices library require_once JPATH_ADMINISTRATOR . '/components/com_j2store/library/prices.php'; //get the data to be exported $items = $this->getList(); //here we process objectlist into array list $export_data = $this->getProcessedDataArray($items); require_once JPATH_ADMINISTRATOR . '/components/com_j2store/library/csv.php'; //get the header fields $headers = $this->getExportHeader($export_data); //get the data to inserted in writer for export $insertExportdata = $this->getProcessedExportData($export_data, $headers); $file_name = 'j2store_report_orderitems_export_order_id_' . date('Y-m-d') . '_' . time(); $exporter = new J2StoreCSVExport(); $exporter->headerAry = $headers; $exporter->dataAry = $insertExportdata; $exporter->filename = 'j2store_report_orderitems_export_'; $exporter->csv(); $exporter->download(); JFactory::getApplication()->close(); }
/** * Method to get Processed array of data for Export * @param object array $data * return array */ public function export($data) { $status; $export_data = array(); foreach ($data as $i => $item) { $export_data[$i]['product_id'] = $item->product_id; $export_data[$i]['product_name'] = $item->orderitem_name; $option = array(); if (isset($item->orderitem_attribute_names) && $item->orderitem_attribute_names) { $attributes = json_decode(stripcslashes($item->orderitem_attribute_names)); $string = ''; foreach ($attributes as $a => $attr) { $string .= $attr->name . ' : ' . $attr->value; } $export_data[$i]['item_option'] = $string; } $export_data[$i]['category_name'] = $item->category_name; $export_data[$i]['product_qty'] = $item->sum; $export_data[$i]['no_of_orders'] = $item->count; } $header = $this->getHeaderfields($export_data); require_once JPATH_ADMINISTRATOR . '/components/com_j2store/library/csv.php'; $exporter = new J2StoreCSVExport(); $exporter->headerAry = $header; $exporter->dataAry = $export_data; $exporter->filename = 'j2store_report_itemised_export_'; $exporter->csv(); $exporter->download(); JFactory::getApplication()->close(); }