function getCurrency() { $this->onExecuteBefore('getCurrency'); $id = JRequest::getInt('id'); $currency = KSSystem::loadDbItem($id, 'currencies'); $this->onExecuteAfter('getCurrency', array(&$currency)); return $currency; }
function getDiscount() { $this->onExecuteBefore('getDiscount'); $id = JRequest::getInt('id'); $discount = KSSystem::loadDbItem($id, 'discounts'); $discount = KSMedia::setItemMedia($discount, 'discount'); if (empty($discount->from_date)) { $discount->from_date = date('d.m.Y'); } if (empty($discount->to_date)) { $discount->to_date = date('d.m.Y'); } if (empty($discount->categories)) { $discount->categories = '{}'; } if (empty($discount->manufacturers)) { $discount->manufacturers = '{}'; } if (empty($discount->regions)) { $discount->regions = '{}'; } if (empty($discount->params)) { $discount->params = '{}'; } if (empty($discount->user_actions)) { $discount->user_actions = '{}'; } if (empty($discount->user_groups)) { $discount->user_groups = '{}'; } if (empty($discount->info_methods)) { $discount->info_methods = '{}'; } if (empty($discount->type)) { $discount->type = $this->getState('discount_type'); } $discount->categories = json_decode($discount->categories, true); $discount->manufacturers = json_decode($discount->manufacturers, true); $discount->regions = json_decode($discount->regions, true); $discount->params = json_decode($discount->params, true); $discount->user_actions = json_decode($discount->user_actions, true); $discount->user_groups = json_decode($discount->user_groups, true); $discount->info_methods = json_decode($discount->info_methods, true); $discount->from_date = date('d.m.Y', strtotime($discount->from_date)); $discount->to_date = date('d.m.Y', strtotime($discount->to_date)); $this->setState('discount_type', $discount->type); $this->setState('discount_params', $discount->params); $this->setState('discount_id', $discount->id); $this->onExecuteAfter('getDiscount', array(&$discount)); return $discount; }
function getManufacturer() { $this->onExecuteBefore('getManufacturer'); $id = JRequest::getInt('id'); $manufacturer = KSSystem::loadDbItem($id, 'manufacturers'); $manufacturer = KSMedia::setItemMedia($manufacturer, 'manufacturer'); $this->onExecuteAfter('getManufacturer', array(&$manufacturer)); return $manufacturer; }
function getRate() { $this->onExecuteBefore('getRate'); $id = JRequest::getInt('id'); $rate = KSSystem::loadDbItem($id, 'commentrates'); $this->onExecuteAfter('getRate', array(&$rate)); return $rate; }
public static function getPriceWithProperties($product_id, $properties = array(), $price = null) { $db = JFactory::getDBO(); if (empty($price)) { $product = KSSystem::loadDbItem($product_id, 'products'); $price = KSMPrice::getPriceInCurrentCurrency($product->price, $product->price_type); } foreach ($properties as $property_id => $values) { $query = $db->getQuery(true); $query->select('edit_price')->from('#__ksenmart_properties'); $query->where('id=' . $property_id); $db->setQuery($query); $edit_price = $db->loadResult(); if ($edit_price == 1) { foreach ($values as $value_id) { $query = $db->getQuery(true); $query->select('price')->from('#__ksenmart_product_properties_values'); $query->where('property_id=' . $property_id)->where('value_id=' . $value_id)->where('product_id=' . $product_id); $db->setQuery($query); $under_price = $db->loadResult(); if ($under_price && !empty($under_price)) { $under_price_act = substr($under_price, 0, 1); switch ($under_price_act) { case '+': $price += substr($under_price, 1, strlen($under_price) - 1); break; case '-': $price -= substr($under_price, 1, strlen($under_price) - 1); break; case '/': $price = $price / substr($under_price, 1, strlen($under_price) - 1); break; case '*': $price = $price * substr($under_price, 1, strlen($under_price) - 1); break; default: $price += $under_price; } } } } } return $price; }
function getRegion() { $this->onExecuteBefore('getRegion'); $id = JRequest::getInt('id'); $region = KSSystem::loadDbItem($id, 'regions'); $region = KSMedia::setItemMedia($region, 'region'); $this->onExecuteAfter('getRegion', array(&$region)); return $region; }
function getPayment($vars = array()) { $this->onExecuteBefore('getPayment', array(&$vars)); $id = JRequest::getInt('id'); $payment = KSSystem::loadDbItem($id, 'payments'); $payment = KSMedia::setItemMedia($payment, 'payment'); if (empty($payment->params)) { $payment->params = '{}'; } if (empty($payment->regions)) { $payment->regions = '{}'; } if (empty($payment->type)) { $payment->type = $this->getState('payment_type'); } $payment->params = json_decode($payment->params, true); $payment->regions = json_decode($payment->regions, true); $this->setState('payment_type', $payment->type); $this->setState('payment_params', $payment->params); $this->setState('payment_id', $payment->id); $this->onExecuteAfter('getPayment', array(&$payment)); return $payment; }
function getProperty() { $this->onExecuteBefore('getProperty'); $id = JRequest::getInt('id'); $property = KSSystem::loadDbItem($id, 'properties'); $property->type = $id > 0 ? $property->type : 'text'; $query = $this->_db->getQuery(true); $query->select('category_id')->from('#__ksenmart_product_categories_properties')->where('property_id=' . $id); $this->_db->setQuery($query); $property->categories = $this->_db->loadColumn(); $query = $this->_db->getQuery(true); $query->select('*')->from('#__ksenmart_property_values')->where('property_id=' . $id)->order('ordering'); $this->_db->setQuery($query); $property->values = $this->_db->loadObjectList(); $this->onExecuteAfter('getProperty', array(&$property)); return $property; }
function getOrderStatus() { $this->onExecuteBefore('getOrderStatus'); $id = JRequest::getInt('id'); $orderstatus = KSSystem::loadDbItem($id, 'orderstatuses'); $this->onExecuteAfter('getOrderStatus', array(&$orderstatus)); return $orderstatus; }
function getUserField() { $this->onExecuteBefore('getUserField'); $id = JRequest::getInt('id'); $userfield = KSSystem::loadDbItem($id, 'userfields'); $this->onExecuteAfter('getUserField', array(&$userfield)); return $userfield; }
function getShipping() { $this->onExecuteBefore('getShipping'); $id = JRequest::getInt('id'); $shipping = KSSystem::loadDbItem($id, 'shippings'); $shipping = KSMedia::setItemMedia($shipping, 'shipping'); $shipping->user_fields = array(); $shipping->address_fields = array(); if (empty($shipping->params)) { $shipping->params = '{}'; } if (empty($shipping->regions)) { $shipping->regions = '{}'; } if (empty($shipping->type)) { $shipping->type = $this->getState('shipping_type'); } $shipping->params = json_decode($shipping->params, true); $shipping->regions = json_decode($shipping->regions, true); if ($id > 0) { $query = $this->_db->getQuery(true); $query->select('*')->from('#__ksenmart_shipping_fields')->where('shipping_id=' . (int) $shipping->id)->where('position=' . $this->_db->quote('customer'))->order('ordering'); $this->_db->setQuery($query); $shipping->user_fields = $this->_db->loadAssocList('id'); foreach ($shipping->user_fields as &$user_field) { if ($user_field['type'] == 'select') { $query = $this->_db->getQuery(true); $query->select('*')->from('#__ksenmart_shipping_fields_values')->where('field_id=' . $user_field['id']); $this->_db->setQuery($query); $user_field['values'] = $this->_db->loadObjectList('id'); } } $query = $this->_db->getQuery(true); $query->select('*')->from('#__ksenmart_shipping_fields')->where('shipping_id=' . (int) $shipping->id)->where('position=' . $this->_db->quote('address'))->order('ordering'); $this->_db->setQuery($query); $shipping->address_fields = $this->_db->loadAssocList('id'); foreach ($shipping->address_fields as &$address_field) { if ($address_field['type'] == 'select') { $query = $this->_db->getQuery(true); $query->select('*')->from('#__ksenmart_shipping_fields_values')->where('field_id=' . $address_field['id']); $this->_db->setQuery($query); $address_field['values'] = $this->_db->loadObjectList('id'); } } } $this->setState('shipping_type', $shipping->type); $this->setState('shipping_params', $shipping->params); $this->setState('shipping_id', $shipping->id); $this->onExecuteAfter('getShipping', array(&$shipping)); return $shipping; }