protected function _getAssetParentId(JTable $table = null, $id = null) { $assetId = null; if (isset($this->cat_id) && $this->cat_id) { $cat_id = $this->cat_id; } elseif ($this->id) { $cat_id = JUDirectoryHelper::getListingById($this->id)->cat_id; } if ($cat_id) { $query = $this->_db->getQuery(true); $query->select($this->_db->quoteName('asset_id')); $query->from($this->_db->quoteName('#__judirectory_categories')); $query->where($this->_db->quoteName('id') . ' = ' . $cat_id); $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } if ($assetId === null) { $query = $this->_db->getQuery(true); $query->select($this->_db->quoteName('id')); $query->from($this->_db->quoteName('#__assets')); $query->where($this->_db->quoteName('name') . ' = ' . $this->_db->quote('com_judirectory')); $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
/** * Get the parent asset id for the record * * @return int * @since 1.6 */ protected function _getAssetParentId($table = null, $id = null) { // Initialise variables. $assetId = null; $db = $this->getDbo(); // This is a article under a category. if ($this->catid) { // Build the query to get the asset id for the parent category. $query = $db->getQuery(true); $query->select('asset_id'); $query->from('#__categories'); $query->where('id = ' . (int) $this->catid); // Get the asset id from the database. $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } // Return the asset id. if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
protected function _getAssetParentId(JTable $table = null, $id = null) { $assetId = null; if ($this->group_id > 0) { $query = $this->_db->getQuery(true); $query->select($this->_db->quoteName('asset_id')); $query->from($this->_db->quoteName('#__judirectory_fields_groups')); $query->where($this->_db->quoteName('id') . ' = ' . $this->group_id); $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } if (!$assetId) { $query = $this->_db->getQuery(true); $query->select($this->_db->quoteName('id')); $query->from($this->_db->quoteName('#__assets')); $query->where($this->_db->quoteName('name') . ' = ' . $this->_db->quote('com_judirectory')); $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
/** * Get the parent asset id for the record * * @return int * @since 1.6 */ protected function _getAssetParentId(JTable $table = null, $id = null) { // search parent document asset ID $this->_db->setQuery('SELECT `asset_id` FROM `#__joomdoc` WHERE `path` = ' . $this->_db->Quote($this->parent_path) . ' ORDER BY `version` DESC'); if ($parentAssetId = (int) $this->_db->loadResult()) { return $parentAssetId; } // search component asset ID $this->_db->setQuery('SELECT `id` FROM `#__assets` WHERE `name` = ' . $this->_db->Quote(JOOMDOC_OPTION)); if ($parentAssetId = (int) $this->_db->loadResult()) { return $parentAssetId; } // return default parent asset ID return parent::_getAssetParentId($table, $id); }
/** * Method to get the parent asset id for the record * * @param JTable $table A JTable object for the asset parent * @param integer $id * * @return integer */ protected function getAssetParentId(JTable $table = null, $id = null) { // Initialise variables. $assetId = null; $db = $this->getDbo(); $query = $db->getQuery(true)->select('id')->from('#__assets')->where('name = ' . $db->quote('com_modules')); // Get the asset id from the database. $db->setQuery($query); if ($result = $db->loadResult()) { $assetId = (int) $result; } // Return the asset id. if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
protected function _getAssetParentId($table = null, $id = null) { $assetId = null; $db = $this->getDbo(); $query = $db->getQuery(true); $query->select('id'); $query->from('#__assets'); $query->where('name = ' . $db->quote('com_igallery')); $db->setQuery($query); if ($result = $db->loadResult()) { $assetId = (int) $result; } if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
protected function _getAssetParentId(JTable $table = null, $id = null) { $assetId = null; $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('id'); $query->from('#__assets'); $query->where('name = "com_judirectory"'); $db->setQuery($query); if ($result = $db->loadResult()) { $assetId = (int) $result; } if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
/** * Method to get the parent asset id for the record * * @param JTable $table A JTable object (optional) for the asset parent * @param integer $id The id (optional) of the content. * * @return integer * * @since 11.1 */ protected function _getAssetParentId(JTable $table = null, $id = null) { $assetId = null; // This is a module that needs to parent with the extension. if ($assetId === null) { // Build the query to get the asset id of the parent component. $query = $this->_db->getQuery(true)->select($this->_db->quoteName('id'))->from($this->_db->quoteName('#__assets'))->where($this->_db->quoteName('name') . ' = ' . $this->_db->quote('com_modules')); // Get the asset id from the database. $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } // Return the asset id. if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
/** * Method to get the parent asset id for the record * * @param JTable $table A JTable object (optional) for the asset parent * @param integer $id The id (optional) of the content. * * @return integer * * @since 11.1 */ protected function _getAssetParentId(JTable $table = null, $id = null) { $assetId = null; // This is a point under a category. if ($this->townid) { // Build the query to get the asset id for the parent category. $query = $this->_db->getQuery(true)->select($this->_db->quoteName('asset_id'))->from($this->_db->quoteName('#__places_point'))->where($this->_db->quoteName('id') . ' = ' . (int) $this->townid); // Get the asset id from the database. $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } // Return the asset id. if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
/** * Get the parent asset id for the record * * @return int */ protected function _getAssetParentId() { // Initialise variables. $assetId = null; $db = $this->getDbo(); // Build the query to get the asset id for the parent category. $query = $db->getQuery(true); $query->select('id'); $query->from('#__assets'); $query->where('name = ' . $db->quote('com_jinc')); // Get the asset id from the database. $db->setQuery($query); if ($result = $db->loadResult()) { $assetId = (int) $result; } // Return the asset id. if ($assetId) { return $assetId; } else { return parent::_getAssetParentId(); } }
/** * Method to get the parent asset id for the record * * @param JTable $table A JTable object (optional) for the asset parent * @param integer $id The id (optional) of the content. * * @return integer * * @since 11.1 */ protected function _getAssetParentId(JTable $table = null, $id = null) { // Initialise variables. $assetId = null; // Build the query to get the asset id for the component. $query = $this->_db->getQuery(true); $query->select($this->_db->quoteName('id')); $query->from($this->_db->quoteName('#__assets')); $query->where($this->_db->quoteName('name') . " LIKE 'com_bwpostman'"); // Get the asset id from the database. $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } // Return the asset id. if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
/** * Get the parent asset id for the record * * @return int * @since 1.6 */ protected function _getAssetParentId($table = null, $id = null) { // Initialise variables. $assetId = null; $db = $this->getDbo(); $extension = 'com_solidres'; // This is a category under a category. if ($this->parent_id > 1) { // Build the query to get the asset id for the parent category. $query = $db->getQuery(true); $query->select('asset_id')->from('#__sr_categories')->where('id = ' . (int) $this->parent_id); // Get the asset id from the database. $db->setQuery($query); if ($result = $db->loadResult()) { $assetId = (int) $result; } } elseif ($assetId === null) { // Build the query to get the asset id for the parent category. $query = $db->getQuery(true); $query->select('id')->from('#__assets')->where('name = ' . $db->quote($extension)); // Get the asset id from the database. $db->setQuery($query); if ($result = $db->loadResult()) { $assetId = (int) $result; } } // Return the asset id. if ($assetId) { return $assetId; } else { return parent::_getAssetParentId($table, $id); } }
/** * Method to get the parent asset under which to register this one. * By default, all assets are registered to the ROOT node with ID, * which will default to 1 if none exists. * The extended class can define a table and id to lookup. If the * asset does not exist it will be created. * * @param JTable $table A JTable object for the asset parent. * @param integer $id Id to look up * * @return integer * * @since 3.6 */ protected function _getAssetParentId(JTable $table = null, $id = null) { $assetId = null; $asset = JTable::getInstance('asset'); if ($asset->loadByName('com_menus')) { $assetId = $asset->id; } return is_null($assetId) ? parent::_getAssetParentId($table, $id) : $assetId; }
/** * Method to get the asset-parent-id of the item * * @return int */ protected function _getAssetParentId(JTable $table = null, $id = null) { // We will retrieve the parent-asset from the visforms table $assetId = null; $fid = $this->fid; if ($fid > 0) { // Build the query to get the asset id for the parent category. $query = $this->_db->getQuery(true); $query->select($this->_db->quoteName('asset_id')); $query->from($this->_db->quoteName('#__visforms')); $query->where($this->_db->quoteName('id') . ' = ' . (int) $fid); // Get the asset id from the database. $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } else { //use component as default $assetParent = JTable::getInstance('Asset'); // Default: if no asset-parent can be found we take the global asset $assetId = $assetParent->getRootId(); // The item has the component as asset-parent $assetParent->loadByName('com_visforms'); // Return the found asset-parent-id if ($assetParent->id) { $assetId = $assetParent->id; } } // Return the asset id. if ($assetId) { return $assetId; } return parent::_getAssetParentId($table, $id); }
/** * Get the parent asset id for the record * * @return int * @since 1.6 */ protected function _getAssetParentId(JTable $table = null, $id = null) { // Initialise variables. $assetId = null; // This is a project under a department. if ($this->parent_id_key) { // Build the query to get the asset id for the parent category. $query = $this->_db->getQuery(true); $query->select($this->_db->quoteName('asset_id')); $query->from($this->_db->quoteName('#__parent_item_table')); $query->where($this->_db->quoteName('id') . ' = ' . (int) $this->parent_id_key); // Get the asset id from the database. $this->_db->setQuery($query); if ($result = $this->_db->loadResult()) { $assetId = (int) $result; } } // Return the asset id. if ($assetId) { return $assetId; } return parent::_getAssetParentId($table, $id); }
protected function _getAssetParentId(JTable $table = null, $id = null) { $parts = DPFieldsHelper::extract($this->context); $component = $parts ? $parts[0] : null; if ($component) { // Build the query to get the asset id for the parent category. $query = $this->_db->getQuery(true)->select($this->_db->quoteName('id'))->from($this->_db->quoteName('#__assets'))->where($this->_db->quoteName('name') . ' = ' . $this->_db->quote($component)); // Get the asset id from the database. $this->_db->setQuery($query); $assetId = null; if ($result = $this->_db->loadResult()) { $assetId = (int) $result; if ($assetId) { return $assetId; } } } return parent::_getAssetParentId($table, $id); }