function csvexport()
{
$model = $this->getModel("delaysreport");
$CSVData = $model->getCsvexportData();
$filename = "DelaysReport_" . date("Y-m-d");
$csvData = null;
//$csvData.= "Item_id;Product Name;Store Name;Store Id;Sales Count;Amount;Created By;";
$headColumn = array();
//$headColumn[0] = JText::_('COM_QUICK2CART_DELAYSREPORT_ID');
$headColumn[1] = JText::_('COM_QUICK2CART_DELAYSREPORT_ORDER_ID');
// 'Product Name';
$headColumn[2] = JText::_('COM_QUICK2CART_DELAYSREPORT_DAYS');
$headColumn[3] = JText::_('COM_QUICK2CART_DELAYSREPORT_BUYER');
$headColumn[4] = JText::_('COM_QUICK2CART_DELAYSREPORT_STATUS');
$csvData .= implode(";", $headColumn);
$csvData .= "\n";
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header("Content-disposition: filename=" . $filename . ".csv");
if (!empty($CSVData)) {
$storeHelper = new storeHelper();
foreach ($CSVData as $data) {
$csvrow = array();
//$csvrow[0] = '';
$csvrow[1] = '"' . $data['prefix'] . $data['id'] . '"';
$delay = $storeHelper->GetDelaysInOrder($data['id']);
if ($delay) {
$csvrow[2] = '"' . $delay . '"';
} else {
$csvrow[2] = '"-"';
}
$csvrow[3] = '"' . $data['name'] . '"';
if ($data['status'] == 'C') {
$status = JText::_('ORDER_CONFIRMED');
} elseif ($data['status'] == 'S') {
$status = JText::_('ORDER_SHIPPED');
} else {
$status = JText::_('ORDER_CANCELLED');
}
$csvrow[4] = '"' . $status . '"';
$csvData .= implode(";", $csvrow);
$csvData .= "\n";
}
}
ob_clean();
echo $csvData . "\n";
jexit();
$link = JUri::base() . substr(JRoute::_('index.php?option=com_quick2cart&view=delaysreport', false), strlen(JUri::base(true)) + 1);
$this->setRedirect($link);
}
