/** * Gives sales reports csv export. * * @since 2.2.2 * @return null. */ public function csvexport() { $model = $this->getModel("salesreport"); $CSVData = $model->getCsvexportData(); $filename = "SalesReport_" . date("Y-m-d"); $csvDataString = null; $headColumn = array(); $headColumn[0] = JText::_('COM_QUICK2CART_SALESREPORT_STORE_ITEMID'); $headColumn[1] = JText::_('COM_QUICK2CART_SALESREPORT_PROD_NAME'); $headColumn[2] = JText::_('COM_QUICK2CART_SALESREPORT_STORE_NAME'); $headColumn[3] = JText::_('COM_QUICK2CART_SALESREPORT_STORE_ID'); $headColumn[4] = JText::_('COM_QUICK2CART_SALESREPORT_SALES_COUNT'); $headColumn[5] = JText::_('COM_QUICK2CART_SALESREPORT_AMOUNT'); $headColumn[6] = JText::_('COM_QUICK2CART_SALESREPORT_CREATED_BY'); $csvDataString .= implode(";", $headColumn); $csvDataString .= "\n"; header("Content-type: application/vnd.ms-excel"); header("Content-disposition: csv" . date("Y-m-d") . ".csv"); header("Content-disposition: filename=" . $filename . ".csv"); // Getting all store list $comquick2cartHelper = new comquick2cartHelper(); $store_details = $comquick2cartHelper->getAllStoreDetails(); $productHelper = new productHelper(); if (!empty($CSVData)) { foreach ($CSVData as $data) { $store_id = $data['store_id']; $csvrow = array(); $csvrow[0] = '"' . $data['item_id'] . '"'; $csvrow[1] = '"' . $data['item_name'] . '"'; $csvrow[2] = '""'; if (!empty($store_details[$store_id])) { $csvrow[2] = '"' . $store_details[$store_id]['title'] . '"'; } $csvrow[3] = '"' . $data['store_id'] . '"'; $csvrow[4] = '"' . $data['saleqty'] . '"'; // GETTING PRODUCT PRICE $prodAttDetails = $productHelper->getProdPriceWithDefltAttributePrice($data['item_id']); // CONSIDERING FIELD DISCOUNT, NOT COUPON DISCOUNT $discountPrice = $prodAttDetails['itemdetail']['discount_price']; $prodBasePrice = !empty($discountPrice) ? $discountPrice : $prodAttDetails['itemdetail']['price']; $prodPrice = $prodBasePrice + $prodAttDetails['attrDetail']['tot_att_price']; $prodPrice = strip_tags($comquick2cartHelper->getFromattedPrice($prodPrice)); $csvrow[5] = '"' . $prodPrice . '"'; $csvrow[6] = '""'; if (!empty($store_details[$store_id])) { $csvrow[6] = '"' . $store_details[$store_id]['firstname'] . '"'; } $csvDataString .= implode(";", $csvrow); $csvDataString .= "\n"; } } ob_clean(); echo $csvDataString . "\n"; jexit(); $link = 'index.php?option=com_quick2cart&view=salesreport'; $this->setRedirect($link); }
<td class="q2c_width_10 center" data-title="<?php echo JText::_('COM_QUICK2CART_SALESREPORT_QTY'); ?> "> <?php echo $row->saleqty; ?> </td> <td class="q2c_width_10" data-title="<?php echo JText::_('COM_QUICK2CART_SALESREPORT_AMOUNT'); ?> "> <?php $productHelper = new productHelper(); $prodAttDetails = $productHelper->getProdPriceWithDefltAttributePrice($row->item_id); // CONSIDERING FIELD DISCOUND, NOT COUP DISCOUNT $prodBasePrice = !empty($prodAttDetails['itemdetail']['discount_price']) ? $prodAttDetails['itemdetail']['discount_price'] : $prodAttDetails['itemdetail']['price']; $prodPrice = $prodBasePrice + $prodAttDetails['attrDetail']['tot_att_price']; echo $comquick2cartHelper->getFromattedPrice($prodPrice); ?> </td> <!-- created by--> <td class="q2c_width_10" data-title="<?php echo JText::_('COM_QUICK2CART_SALESREPORT_CREATED_BY'); ?> "> <?php if (!empty($store_details[$row->store_id])) { echo $store_details[$row->store_id]['firstname'];