public function getItem() { parent::getItem(); if (!isset($this->item)) { $id = $this->getState('driver.id'); $query = $this->_db->getQuery(true)->from('#__fleet_driver as h')->leftJoin('#__fleet_entity as c ON h.entity_id=c.id')->select('h.*, c.name as entity')->where('h.id=' . (int) $id); $this->_db->setQuery($query); if (!($this->item = $this->_db->loadObject())) { $this->setError($this->_db->getErrorMsg()); } } return $this->item; }
public function getItem() { parent::getItem(); if (!isset($this->item) || FALSE === $this->item) { $id = $this->getState('map.id'); $this->_db->setQuery($this->_db->getQuery(true)->from('fleet_trip as h')->select('h.*')->where('h.id=' . (int) $id)); if (!($this->item = $this->_db->loadObject())) { $this->setError($this->_db->getErrorMsg()); } else { // success } } return $this->item; }
public function getItem() { parent::getItem(); if (!isset($this->item)) { $id = $this->getState('user.id'); $this->_db->setQuery($this->_db->getQuery(true)->from('#__fleet_user as h')->leftJoin('#__users as a ON h.id=a.id')->leftJoin('#__fleet_entity as c ON h.entity_id=c.id')->select('h.*, a.username, a.name, a.email')->where('h.id=' . (int) $id)); if (!($this->item = $this->_db->loadObject())) { $this->setError($this->_db->getErrorMsg()); } else { // success } } return $this->item; }
public function getItem() { parent::getItem(); if (!isset($this->item)) { $clause = "h.*, a.name as entity, a.id as entity_id, b.name as driver, b.id as driver_id," . "c.id as weight_id, CONCAT(c.min, '-', c.max) as weight"; $id = $this->getState('subscription.id'); $query = $this->_db->getQuery(true)->from('#__fleet_subscription as h')->leftJoin('#__fleet_entity as a ON h.entity_id=a.id')->leftJoin('#__fleet_driver as b ON h.driver_id=b.id')->leftJoin('#__fleet_weight as c ON h.weight_id=c.id')->select($clause)->where('h.id=' . (int) $id); $this->_db->setQuery($query); if (!($this->item = $this->_db->loadObject())) { $this->setError($this->_db->getErrorMsg()); } } return $this->item; }
public function getItem() { parent::getItem(); if (!isset($this->item) || FALSE === $this->item) { $id = $this->getState('entity.id'); $this->_db->setQuery($this->_db->getQuery(true)->from('#__fleet_entity as h')->leftJoin('#__fleet_entity as c ON h.parent_entity_id=c.id')->select('h.*, c.name as parent_entity')->where('h.id=' . (int) $id)); if (!($this->item = $this->_db->loadObject())) { $this->setError($this->_db->getErrorMsg()); } else { // success } } return $this->item; }
public function getItem() { parent::getItem(); return $this; }