/** * 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); }
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); }
<?php $discount_present = $params->get('usedisc') && isset($this->price['discount_price']) && $this->price['discount_price'] != 0 ? 1 : 0; if (empty($this->qtcExtraParam['hideOriginalPrice'])) { ?> <div class="control-group"> <label class="control-label"><strong><?php echo JText::_('QTC_ITEM_AMT'); ?> </strong></label> <div class="controls qtc_controls_text"><span id="<?php echo isset($this->price['discount_price']) ? $this->product_id . '_price' : ''; ?> " > <?php //echo (($params->get('usedisc'))?((isset($this->price['discount_price'])) ? '<del>'.$this->price['price'].'</del>':$this->price['price']):$this->price); $pprice = $discount_present == 1 ? '<del>' . $comquick2cartHelper->getFromattedPrice($this->price['price']) . '</del>' : $comquick2cartHelper->getFromattedPrice($this->price['price']); echo $pprice; ?> </span></div> </div> <?php } if ($discount_present && empty($this->qtcExtraParam['hideDiscountPrice'])) { ?> <div class="control-group"> <label class="control-label"><strong><?php echo JText::_('QTC_ITEM_DIS_AMT'); ?> </strong></label> <div class="controls qtc_controls_text">
// user field data - eg text to print on T-shirt if (!empty($cart['product_attributesUserData']) && 0) { $productHelper = new productHelper(); $userdata = json_decode($cart['product_attributesUserData'], true); echo $productHelper->getFormattedAttributesUserData($userdata); } ?> </span> </td> <?php } ?> <td class="cartitem_price" id="cart_price[]" name="cart_price[]"> <div> <span><?php echo $helperobj->getFromattedPrice(number_format($cart['amt'] + $cart['opt_amt'], 2)); ?> </span> </div> </td> <td class="cartitem_qty" > <span><?php echo $cart['qty']; ?> </span> </td> <td class="cartitem_tprice" <?php echo $align_style; ?> > <span id="cart_total_price<?php
?> <!-- Start - stat boxes --> <div class="row"> <div class="col-sm-4 col-lg-4 col-md-12"> <div class="panel panel-green"> <div class="panel-heading"> <div class="row"> <div class="col-xs-3"> <i class="<?php echo Q2C_DASHBORD_ICON_SALES; ?> "></i> </div> <div class="col-xs-9 text-right"> <div class="huge"><?php echo !empty($perdIncome['amount']) ? $comquick2cartHelper->getFromattedPrice(number_format($perdIncome['amount'], 2)) : "0"; ?> </div> </div> </div> </div> <a href="<?php echo JRoute::_('index.php?option=com_quick2cart&view=orders&layout=storeorder&Itemid=' . $this->orders_itemid, false); ?> "> <div class="panel-footer"> <span class="pull-left"> <?php echo JText::_('COM_Q2C_PRD_REVENUE'); ?> </span>
} $payout->id = $append . $payout->id; } echo $payout->id; ?> </td> <td> <?php if (JVERSION < '1.6.0') { echo JHtml::_('date', $payout->date, '%Y/%m/%d'); } else { echo JHtml::_('date', $payout->date, "Y-m-d"); } ?> </td><td><?php echo $comquick2cartHelper->getFromattedPrice(number_format($payout->amount, 2)); ?> </td> <!-- <td><?php //echo $payout->cashback; ?> </td> --> </tr> <?php $i++; } ?> <tr rowspan="2" height="20"> <td class="com_quick2cart_align_right" colspan="3"></td> <td></td> </tr>
/** * Function used to calculate final price * * @param Obj $ipdata idata should in formats tdClass Object ( [totalprice] => 174.375 [country] => Bangladesh [region] => Dhaka [city] => punt ) * * @return json * * @since 1.0.0 */ public function calFinalShipPrice($ipdata = '') { $jinput = JFactory::getApplication()->input; // If called from Ajax if (empty($ipdata)) { $postdata = $jinput->post(); $jsondata = $postdata->get('data', '', 'STRING'); $data = json_decode($jsondata); } else { $data = $ipdata; } // Call model $model = $this->getModel('cartcheckout'); $finalshipdata = $model->getFinalShipPrice($data); // If not called from Ajax if (!empty($ipdata)) { return $finalshipdata; } $comquick2cartHelper = new comquick2cartHelper(); $finalshipdata['charges'] = $comquick2cartHelper->getFromattedPrice(number_format($finalshipdata['charges'], 2)); $finalshipdata['totalamt'] = $comquick2cartHelper->getFromattedPrice(number_format($finalshipdata['totalamt'], 2)); echo $json_ship_data = json_encode($finalshipdata); jexit(); }
echo JText::_('COM_QUICK2CART_HAVE_INSTALLED_VER') . ': ' . $this->version; ?> </span> </div> <div class="clearfix"> </div> </div> <!-- /.col-lg-12 --> </div> <!-- /.row --> <div class="clearfix"> </div> <?php if (!$this->allincome) { $this->allincome = 0; } $this->allincome = $comquick2cartHelper->getFromattedPrice($this->allincome); ?> <!-- Start - stat boxes --> <div class="row"> <div class="col-lg-3 col-md-6"> <div class="panel panel-green"> <div class="panel-heading"> <div class="row"> <div class="col-xs-3 "> <i class="fa fa-money fa-4x"></i> </div> <div class="col-xs-9 text-right"> <div class="huge"><?php echo $this->allincome; ?>
public function getPrefix($attoptionIds) { $comquick2cartHelper = new comquick2cartHelper(); $currency = $comquick2cartHelper->getCurrencySession(); //getFromattedPrice($price,$curr=NULL) $prefixarray = array(); $db = JFactory::getDBO(); foreach ($attoptionIds as $key => $attid) { $query = "Select i.`itemattributeoption_prefix` as prefix,op.`price` FROM `#__kart_itemattributeoptions` as i\n\t\t\t\t\t\tLEFT JOIN `#__kart_option_currency` AS op\n\t\t\t\t\t\t ON i.`itemattributeoption_id`=op.`itemattributeoption_id`\n\t\t\t\t\t\tWHERE i.`itemattributeoption_id`=" . $attid . " AND op.`currency`='" . $currency . "'"; $db->setQuery($query); $option_detail = $db->loadObject(); if (empty($option_detail)) { $option_detail = new stdClass(); $option_detail->price = 0; $option_detail->prefix = '+'; } $price = $comquick2cartHelper->getFromattedPrice($option_detail->price); $prefixarray[$key] = $option_detail->prefix . " " . $price; } return $prefixarray; }
<?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']; } ?> </td> </tr>
?> "> <label class="radio"> <input type="radio" name="<?php echo $radioFieldName; ?> " id="" value="<?php echo $shipMeth['methodId']; ?> " <?php echo $checked; ?> > <?php $pricetext = $comquick2cartHelper->getFromattedPrice(number_format($shipMeth['totalShipCost'], 2)); echo $pricetext . ' - ' . $shipMeth['name']; // echo $shipMeth['name']; ?> </label> </div> <?php } } else { echo JText::_('COM_QUICK2CART_NO_SHIPPING_METHOS_WE_WILL_CONTACT_U'); } ?> </div>
function getAttrFieldTypeHtml($data) { $parent = ''; if (isset($data['parent'])) { $parent = $data['parent']; } $product_id = $data['product_id']; $comquick2cartHelper = new comquick2cartHelper(); // $atri_options = comquick2cartHelper::getAttributeOption($attribute->itemattribute_id);// commented during multicurrency $atri_options = $comquick2cartHelper->getAttributeOptionCurrPrice($data['itemattribute_id']); $select_opt = array(); $userData = array(); $userData[] = 'Textbox'; if (!$data['attribute_compulsary'] && !in_array($data['fieldType'], $userData)) { $select_opt[] = JHtml::_('select.option', "", ""); } $returnHtml = ''; foreach ($atri_options as $atri_option) { $attOp_price = (int) $atri_option->itemattributeoption_currency_price; // IF 0 ATT PRIVE THEN DONT ADD +0 USD if (!empty($attOp_price)) { $priceText = $comquick2cartHelper->getFromattedPrice($atri_option->itemattributeoption_currency_price, NULL, 0); $opt_str = $atri_option->itemattributeoption_name . ": " . $atri_option->itemattributeoption_prefix . " " . $priceText; } else { // If no price than dont append like +00.0 USD $opt_str = $atri_option->itemattributeoption_name; } // Generate op according to datatype if (in_array($data['fieldType'], $userData)) { $returnHtml = "<input type='text' name='qtcUserField_" . $atri_option->itemattributeoption_id . "' class='input input-small " . $parent . '-' . $product_id . '_UserField' . "' >"; } else { /* Amol change*/ $default_value = ''; if (isset($data['default_value'])) { $default_value = $data['default_value']; } $field_name = 'attri_option'; if (isset($data['field_name'])) { $field_name = $data['field_name']; } // user data $select_opt[] = JHtml::_('select.option', $atri_option->itemattributeoption_id, $opt_str); $returnHtml = JHtml::_('select.genericlist', $select_opt, $field_name, " class='q2c_AttoptionsMaxWidth {$parent}-{$product_id}_options'", 'value', 'text', $default_value, false); } } return $returnHtml; /* if (!in_array($data['fieldType'],$userData)) { echo JHtml::_('select.genericlist', $select_opt, 'attri_option', " class='span2 {$parent}-{$product_id}_options'", 'value', 'text', '',false); }*/ }
alt="<?php echo JText::_('QTC_IMG_NOT_FOUND'); ?> " title="<?php echo $data['name']; ?> " /> </a> </div> <div class="caption"> <div class="center"> <?php $p_price = !empty($item_price['discount_price']) && ceil($item_price['discount_price']) ? $item_price['discount_price'] : $item_price['price']; echo JText::_('QTC_ITEM_AMT') . " : " . $helperobj->getFromattedPrice($p_price + $tot_att_price); ?> </div> <hr class="hr hr-condensed"/> <?php $textboxid = $data['parent'] . '-' . $item_id . "_itemcount"; $parent = $data['parent']; $slab = !empty($data['slab']) ? $data['slab'] : 1; $limits = $data['min_quantity'] . "," . $data['max_quantity']; $arg = "'" . $textboxid . "','" . $item_id . "','" . $parent . "','" . $slab . "'," . $limits; $min_msg = JText::_('QTC_MIN_LIMIT_MSG'); $max_msg = JText::_('QTC_MAX_LIMIT_MSG'); $fun_param = $parent . '-' . $data['product_id']; //com_content-31_itemcount $qty_buynow = $com_params->get('qty_buynow', 1); $qtyDivStyle = "";