function loadViewDataForSetratesView($jinput) { $taxHelper = new taxHelper(); $qtczoneShipHelper = new qtczoneShipHelper(); $qtcshiphelper = new qtcshiphelper(); $shipFormData = array(); $rateId = $jinput->get('rateId', 0); $methodId = $jinput->get('methodId', 0); $shipMethDetail = $qtcshiphelper->getShipMethDetail($methodId); // Load Zone helper. $path = JPATH_SITE . DS . "components" . DS . "com_quick2cart" . DS . 'helpers' . DS . "zoneHelper.php"; JLoader::register('zoneHelper', $path); JLoader::load('zoneHelper'); $zoneHelper = new zoneHelper(); // Get user's accessible zone list $shipFormData['zonelist'] = $zoneHelper->getStoreZoneList($shipMethDetail['store_id']); $shipFormData['ratelist'] = array(); if (!empty($methodId)) { $db = JFactory::getDBO(); $query = $db->getQuery(true); $query->select(" id AS rateId,methodId,zone_id,rangeFrom,rangeTo")->from('#__kart_zoneShipMethodRates')->where('methodId=' . $methodId); $db->setQuery((string) $query); $rateList = $db->loadAssocList(); if (!empty($rateList)) { foreach ($rateList as $key => $rate) { $query = $db->getQuery(true); $query->select(" id AS rateCurrId,rateId,shipCost,handleCost,currency")->from('#__kart_zoneShipMethodRateCurr')->where('rateId=' . $rate['rateId']); $db->setQuery((string) $query); $rateList[$key]['rateCurrDetails'] = $db->loadAssocList(); } } $shipFormData['ratelist'] = $rateList; } return $shipFormData; }