function csvexport()
{
$model = $this->getModel("vendor");
$CSVData = $model->getCsvexportData();
$filename = "SalesPerSellerReport_" . 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_SALESPERSELLER_STORENAME');
$headColumn[1] = JText::_('COM_QUICK2CART_SALESPERSELLER_VENDORNAME');
// 'Product Name';
$headColumn[2] = JText::_('COM_QUICK2CART_SALESPERSELLER_STATUS');
$headColumn[3] = JText::_('COM_QUICK2CART_SALESPERSELLER_EMAIL');
$headColumn[4] = JText::_('COM_QUICK2CART_SALESPERSELLER_PHONE');
$headColumn[5] = JText::_('COM_QUICK2CART_SALESPERSELLER_SALE');
$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] = '"' . $data['title'] . '"';
$csvrow[1] = '"' . $data['username'] . '"';
if ($data['published'] == 1) {
$status = JText::_('COM_QUICK2CART_PUBLISH');
} else {
$status = JText::_('COM_QUICK2CART_UNPUBLISH');
}
$csvrow[2] = '"' . $status . '"';
$csvrow[3] = '"' . $data['store_email'] . '"';
$csvrow[4] = '"' . $data['phone'] . '"';
$storeHelper = new storeHelper();
$comquick2cartHelper = new comquick2cartHelper();
$total_sale = $storeHelper->getTotalSalePerStore($data['id']);
if ($total_sale) {
$sale = $comquick2cartHelper->getFromattedPrice($total_sale);
}
$csvrow[5] = '"' . $sale . '"';
$csvData .= implode(";", $csvrow);
$csvData .= "\n";
}
}
ob_clean();
echo $csvData . "\n";
jexit();
$link = JUri::base() . substr(JRoute::_('index.php?option=com_quick2cart&view=vendor&layout=salespervendor', false), strlen(JUri::base(true)) + 1);
$this->setRedirect($link);
}
