/**
* 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();
}
