@copyright Copyright (C) 2020 Vast Development Method. All rights reserved. @license GNU/GPL Version 2 or later - http://www.gnu.org/licenses/gpl-2.0.html Portal for mobile health clinics /-----------------------------------------------------------------------------------------------------------------------------*/ // No direct access to this file defined('_JEXEC') or die('Restricted access'); use Joomla\CMS\Factory; use Joomla\CMS\Table\Table; use Joomla\CMS\Access\Access as AccessRules; use Joomla\CMS\Access\Rules; use Joomla\Registry\Registry; use Joomla\String\StringHelper; use Joomla\Utilities\ArrayHelper; use Joomla\CMS\String\PunycodeHelper; use Joomla\CMS\Table\Observer\Tags as TableObserverTags; use Joomla\CMS\Table\Observer\ContentHistory as TableObserverContenthistory; use Joomla\CMS\Application\ApplicationHelper; /** * Testing_reasons Table class */ class EhealthportalTableTesting_reason extends Table { /** * Ensure the params and metadata in json encoded in the bind method * * @var array * @since 3.3 */ protected $_jsonEncode = array('params', 'metadata'); /** * Constructor * * @param object Database connector object */ function __construct(&$db) { parent::__construct('#__ehealthportal_testing_reason', 'id', $db); // Adding History Options TableObserverContenthistory::createObserver($this, array('typeAlias' => 'com_ehealthportal.testing_reason')); } public function bind($array, $ignore = '') { if (isset($array['params']) && is_array($array['params'])) { $registry = new Registry; $registry->loadArray($array['params']); $array['params'] = (string) $registry; } if (isset($array['metadata']) && is_array($array['metadata'])) { $registry = new Registry; $registry->loadArray($array['metadata']); $array['metadata'] = (string) $registry; } // Bind the rules. if (isset($array['rules']) && is_array($array['rules'])) { $rules = new AccessRules($array['rules']); $this->setRules($rules); } return parent::bind($array, $ignore); } /** * Overload the store method for the Testing_reason table. * * @param boolean Toggle whether null values should be updated. * @return boolean True on success, false on failure. * @since 1.6 */ public function store($updateNulls = false) { $date = Factory::getDate(); $user = Factory::getUser(); if ($this->id) { // Existing item $this->modified = $date->toSql(); $this->modified_by = $user->get('id'); } else { // New testing_reason. A testing_reason created and created_by field can be set by the user, // so we don't touch either of these if they are set. if (!(int) $this->created) { $this->created = $date->toSql(); } if (empty($this->created_by)) { $this->created_by = $user->get('id'); } } if (isset($this->alias)) { // Verify that the alias is unique $table = Table::getInstance('testing_reason', 'EhealthportalTable'); if ($table->load(array('alias' => $this->alias)) && ($table->id != $this->id || $this->id == 0)) { $this->setError(Text::_('COM_EHEALTHPORTAL_TESTING_REASON_ERROR_UNIQUE_ALIAS')); if ($table->published === -2) { $this->setError(Text::_('COM_EHEALTHPORTAL_TESTING_REASON_ERROR_UNIQUE_ALIAS_TRASHED')); } return false; } } if (isset($this->url)) { // Convert IDN urls to punycode $this->url = PunycodeHelper::urlToPunycode($this->url); } if (isset($this->website)) { // Convert IDN urls to punycode $this->website = PunycodeHelper::urlToPunycode($this->website); } return parent::store($updateNulls); } /** * Overloaded check method to ensure data integrity. * * @return boolean True on success. */ public function check() { if (isset($this->alias)) { // Generate a valid alias $this->generateAlias(); $table = Table::getInstance('testing_reason', 'ehealthportalTable'); while ($table->load(array('alias' => $this->alias)) && ($table->id != $this->id || $this->id == 0)) { $this->alias = StringHelper::increment($this->alias, 'dash'); } } /* * Clean up keywords -- eliminate extra spaces between phrases * and cr (\r) and lf (\n) characters from string. * Only process if not empty. */ if (!empty($this->metakey)) { // Array of characters to remove. $bad_characters = array("\n", "\r", "\"", "<", ">"); // Remove bad characters. $after_clean = StringHelper::str_ireplace($bad_characters, "", $this->metakey); // Create array using commas as delimiter. $keys = explode(',', $after_clean); $clean_keys = []; foreach ($keys as $key) { // Ignore blank keywords. if (trim($key)) { $clean_keys[] = trim($key); } } // Put array back together delimited by ", " $this->metakey = implode(", ", $clean_keys); } // Clean up description -- eliminate quotes and <> brackets if (!empty($this->metadesc)) { // Only process if not empty $bad_characters = array("\"", "<", ">"); $this->metadesc = StringHelper::str_ireplace($bad_characters, "", $this->metadesc); } // If we don't have any access rules set at this point just use an empty AccessRules class if (!$this->getRules()) { $rules = $this->getDefaultAssetValues('com_ehealthportal.testing_reason.'.$this->id); $this->setRules($rules); } // Set ordering if ($this->published < 0) { // Set ordering to 0 if state is archived or trashed $this->ordering = 0; } return true; } /** * Gets the default asset values for a component. * * @param $string $component The component asset name to search for * * @return AccessRules The AccessRules object for the asset */ protected function getDefaultAssetValues($component, $try = true) { // Need to find the asset id by the name of the component. $db = Factory::getDbo(); $query = $db->getQuery(true) ->select($db->quoteName('id')) ->from($db->quoteName('#__assets')) ->where($db->quoteName('name') . ' = ' . $db->quote($component)); $db->setQuery($query); $db->execute(); if ($db->loadRowList()) { // asset already set so use saved rules $assetId = (int) $db->loadResult(); return AccessRules::getAssetRules($assetId); // (TODO) instead of keeping inherited Allowed it becomes Allowed. } // try again elseif ($try) { $try = explode('.',$component); $result = $this->getDefaultAssetValues($try[0], false); if ($result instanceof AccessRules) { if (isset($try[1])) { $_result = (string) $result; $_result = json_decode($_result); foreach ($_result as $name => &$rule) { $v = explode('.', $name); if ($try[1] !== $v[0]) { // remove since it is not part of this view unset($_result->$name); } else { // clear the value since we inherit $rule = []; } } // check if there are any view values remaining if (count( (array) $_result)) { $_result = json_encode($_result); $_result = array($_result); // Instantiate and return the AccessRules object for the asset rules. $rules = new AccessRules; $rules->mergeCollection($_result); return $rules; } } return $result; } } return AccessRules::getAssetRules(0); } /** * Method to compute the default name of the asset. * The default name is in the form 'table_name.id' * where id is the value of the primary key of the table. * * @return string * @since 2.5 */ protected function _getAssetName() { $k = $this->_tbl_key; return 'com_ehealthportal.testing_reason.'.(int) $this->$k; } /** * Method to return the title to use for the asset table. * * @return string * @since 2.5 */ protected function _getAssetTitle() { if (isset($this->title)) { return $this->title; } return ''; } /** * Get the parent asset id for the record * * @return int * @since 2.5 */ protected function _getAssetParentId(?Table $table = null, $id = null) { $asset = Table::getInstance('Asset'); $asset->loadByName('com_ehealthportal'); return $asset->id; } /** * Generate a valid alias from title / date. * Remains public to be able to check for duplicated alias before saving * * @return string */ public function generateAlias() { if (empty($this->alias)) { $this->alias = $this->name; } $this->alias = ApplicationHelper::stringURLSafe($this->alias); if (trim(str_replace('-', '', $this->alias)) == '') { $this->alias = Factory::getDate()->format('Y-m-d-H-i-s'); } return $this->alias; } }