PHP KSSystem::loadDbItem方法代码示例

 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;
 }