File Manager

X7ROOT File Manager

Current Path: /home/notabjze/just4dastreets.com/libraries/src/Form/Field

home / notabjze / just4dastreets.com / libraries / src / Form / Field /

ðŸ“ ..
ðŸ“„ AccessiblemediaField.php(4.58 KB)
ðŸ“„ AccesslevelField.php(900 B)
ðŸ“„ AliastagField.php(1.71 KB)
ðŸ“„ AuthorField.php(1.66 KB)
ðŸ“„ CachehandlerField.php(1.1 KB)
ðŸ“„ CalendarField.php(10.72 KB)
ðŸ“„ CaptchaField.php(4.15 KB)
ðŸ“„ CategoryField.php(2.9 KB)
ðŸ“„ CheckboxField.php(3.51 KB)
ðŸ“„ CheckboxesField.php(3.95 KB)
ðŸ“„ ChromestyleField.php(5.57 KB)
ðŸ“„ ColorField.php(8.14 KB)
ðŸ“„ ComboField.php(1.4 KB)
ðŸ“„ ComponentlayoutField.php(7.54 KB)
ðŸ“„ ComponentsField.php(1.73 KB)
ðŸ“„ ContenthistoryField.php(1.72 KB)
ðŸ“„ ContentlanguageField.php(908 B)
ðŸ“„ ContenttypeField.php(2.3 KB)
ðŸ“„ DatabaseconnectionField.php(2.05 KB)
ðŸ“„ EditorField.php(7.37 KB)
ðŸ“„ EmailField.php(1.45 KB)
ðŸ“„ FileField.php(3.41 KB)
ðŸ“„ FilelistField.php(5.6 KB)
ðŸ“„ FolderlistField.php(5.48 KB)
ðŸ“„ FrontendlanguageField.php(1.89 KB)
ðŸ“„ GroupedlistField.php(3.89 KB)
ðŸ“„ HeadertagField.php(970 B)
ðŸ“„ HiddenField.php(1.26 KB)
ðŸ“„ ImagelistField.php(926 B)
ðŸ“„ IntegerField.php(1.75 KB)
ðŸ“„ LanguageField.php(2.12 KB)
ðŸ“„ LastvisitdaterangeField.php(1.39 KB)
ðŸ“„ LimitboxField.php(2.19 KB)
ðŸ“„ ListField.php(5.98 KB)
ðŸ“„ MediaField.php(10.56 KB)
ðŸ“„ MenuField.php(3.06 KB)
ðŸ“„ MenuitemField.php(5.9 KB)
ðŸ“„ MeterField.php(4.53 KB)
ðŸ“„ ModulelayoutField.php(6.24 KB)
ðŸ“„ ModuleorderField.php(3.28 KB)
ðŸ“„ ModulepositionField.php(4.42 KB)
ðŸ“„ ModuletagField.php(1011 B)
ðŸ“„ NoteField.php(2.19 KB)
ðŸ“„ NumberField.php(5.08 KB)
ðŸ“„ OrderingField.php(4.89 KB)
ðŸ“„ PasswordField.php(6.12 KB)
ðŸ“„ PluginsField.php(4.4 KB)
ðŸ“„ PluginstatusField.php(649 B)
ðŸ“„ PredefinedlistField.php(3 KB)
ðŸ“„ RadioField.php(1.1 KB)
ðŸ“„ RadiobasicField.php(1.29 KB)
ðŸ“„ RangeField.php(1.38 KB)
ðŸ“„ RedirectStatusField.php(724 B)
ðŸ“„ RegistrationdaterangeField.php(1.39 KB)
ðŸ“„ RulesField.php(7.3 KB)
ðŸ“„ SessionhandlerField.php(1.2 KB)
ðŸ“„ SpacerField.php(3.39 KB)
ðŸ“„ SqlField.php(7.28 KB)
ðŸ“„ StatusField.php(714 B)
ðŸ“„ SubformField.php(10.79 KB)
ðŸ“„ TagField.php(8.24 KB)
ðŸ“„ TelephoneField.php(1.61 KB)
ðŸ“„ TemplatestyleField.php(4.84 KB)
ðŸ“„ TextField.php(7.17 KB)
ðŸ“„ TextareaField.php(4.57 KB)
ðŸ“„ TimeField.php(3.8 KB)
ðŸ“„ TimezoneField.php(3.83 KB)
ðŸ“„ TransitionField.php(4.5 KB)
ðŸ“„ UrlField.php(1.78 KB)
ðŸ“„ UserField.php(3.87 KB)
ðŸ“„ UseractiveField.php(1.08 KB)
ðŸ“„ UsergrouplistField.php(2.53 KB)
ðŸ“„ UserstateField.php(672 B)
ðŸ“„ WorkflowComponentSectionsField.php(1.47 KB)
ðŸ“„ WorkflowconditionField.php(3.23 KB)
ðŸ“„ WorkflowstageField.php(4.08 KB)

Editing: SqlField.php

<?php
/**
 * Joomla! Content Management System
 *
 * @copyright  (C) 2010 Open Source Matters, Inc. <https://www.joomla.org>
 * @license    GNU General Public License version 2 or later; see LICENSE.txt
 */

namespace Joomla\CMS\Form\Field;

\defined('JPATH_PLATFORM') or die;

use Joomla\CMS\Factory;
use Joomla\CMS\HTML\HTMLHelper;
use Joomla\CMS\Language\Text;
use Joomla\Database\DatabaseQuery;
use Joomla\Database\Exception\ExecutionFailureException;

/**
 * Supports a custom SQL select list
 *
 * @since  1.7.0
 */
class SqlField extends ListField
{
	/**
	 * The form field type.
	 *
	 * @var    string
	 * @since  1.7.0
	 */
	public $type = 'SQL';

/**
	 * The keyField.
	 *
	 * @var    string
	 * @since  3.2
	 */
	protected $keyField;

/**
	 * The valueField.
	 *
	 * @var    string
	 * @since  3.2
	 */
	protected $valueField;

/**
	 * The translate.
	 *
	 * @var    boolean
	 * @since  3.2
	 */
	protected $translate = false;

/**
	 * The query.
	 *
	 * @var    string
	 * @since  3.2
	 */
	protected $query;

/**
	 * Method to get certain otherwise inaccessible properties from the form field object.
	 *
	 * @param   string  $name  The property name for which to get the value.
	 *
	 * @return  mixed  The property value or null.
	 *
	 * @since   3.2
	 */
	public function __get($name)
	{
		switch ($name)
		{
			case 'keyField':
			case 'valueField':
			case 'translate':
			case 'query':
				return $this->$name;
		}

return parent::__get($name);
	}

/**
	 * Method to set certain otherwise inaccessible properties of the form field object.
	 *
	 * @param   string  $name   The property name for which to set the value.
	 * @param   mixed   $value  The value of the property.
	 *
	 * @return  void
	 *
	 * @since   3.2
	 */
	public function __set($name, $value)
	{
		switch ($name)
		{
			case 'keyField':
			case 'valueField':
			case 'translate':
			case 'query':
				$this->$name = (string) $value;
				break;

default:
				parent::__set($name, $value);
		}
	}

/**
	 * Method to attach a Form object to the field.
	 *
	 * @param   \SimpleXMLElement  $element  The SimpleXMLElement object representing the `<field>` tag for the form field object.
	 * @param   mixed              $value    The form field value to validate.
	 * @param   string             $group    The field name group control value. This acts as an array container for the field.
	 *                                       For example if the field has name="foo" and the group value is set to "bar" then the
	 *                                       full field name would end up being "bar[foo]".
	 *
	 * @return  boolean  True on success.
	 *
	 * @see     FormField::setup()
	 * @since   3.2
	 */
	public function setup(\SimpleXMLElement $element, $value, $group = null)
	{
		$return = parent::setup($element, $value, $group);

if ($return)
		{
			// Check if its using the old way
			$this->query = (string) $this->element['query'];

if (empty($this->query))
			{
				// Get the query from the form
				$query    = array();
				$defaults = array();

$sql_select = (string) $this->element['sql_select'];
				$sql_from   = (string) $this->element['sql_from'];

if ($sql_select && $sql_from)
				{
					$query['select'] = $sql_select;
					$query['from']   = $sql_from;
					$query['join']   = (string) $this->element['sql_join'];
					$query['where']  = (string) $this->element['sql_where'];
					$query['group']  = (string) $this->element['sql_group'];
					$query['order']  = (string) $this->element['sql_order'];

// Get the filters
					$filters = isset($this->element['sql_filter']) ? explode(',', $this->element['sql_filter']) : '';

// Get the default value for query if empty
					if (\is_array($filters))
					{
						foreach ($filters as $filter)
						{
							$name   = "sql_default_{$filter}";
							$attrib = (string) $this->element[$name];

if (!empty($attrib))
							{
								$defaults[$filter] = $attrib;
							}
						}
					}

// Process the query
					$this->query = $this->processQuery($query, $filters, $defaults);
				}
			}

$this->keyField   = (string) $this->element['key_field'] ?: 'value';
			$this->valueField = (string) $this->element['value_field'] ?: (string) $this->element['name'];
			$this->translate  = (string) $this->element['translate'] ?: false;
			$this->header     = (string) $this->element['header'] ?: false;
		}

return $return;
	}

/**
	 * Method to process the query from form.
	 *
	 * @param   array   $conditions  The conditions from the form.
	 * @param   string  $filters     The columns to filter.
	 * @param   array   $defaults    The defaults value to set if condition is empty.
	 *
	 * @return  DatabaseQuery  The query object.
	 *
	 * @since   3.5
	 */
	protected function processQuery($conditions, $filters, $defaults)
	{
		// Get the database object.
		$db = Factory::getDbo();

// Get the query object
		$query = $db->getQuery(true);

// Select fields
		$query->select($conditions['select']);

// From selected table
		$query->from($conditions['from']);

// Join over the groups
		if (!empty($conditions['join']))
		{
			$query->join('LEFT', $conditions['join']);
		}

// Where condition
		if (!empty($conditions['where']))
		{
			$query->where($conditions['where']);
		}

// Group by
		if (!empty($conditions['group']))
		{
			$query->group($conditions['group']);
		}

// Process the filters
		if (\is_array($filters))
		{
			$html_filters = Factory::getApplication()->getUserStateFromRequest($this->context . '.filter', 'filter', array(), 'array');

foreach ($filters as $k => $value)
			{
				if (!empty($html_filters[$value]))
				{
					$escape = $db->quote($db->escape($html_filters[$value]), false);

$query->where("{$value} = {$escape}");
				}
				elseif (!empty($defaults[$value]))
				{
					$escape = $db->quote($db->escape($defaults[$value]), false);

$query->where("{$value} = {$escape}");
				}
			}
		}

// Add order to query
		if (!empty($conditions['order']))
		{
			$query->order($conditions['order']);
		}

return $query;
	}

/**
	 * Method to get the custom field options.
	 * Use the query attribute to supply a query to generate the list.
	 *
	 * @return  array  The field option objects.
	 *
	 * @since   1.7.0
	 */
	protected function getOptions()
	{
		$options = array();

// Initialize some field attributes.
		$key   = $this->keyField;
		$value = $this->valueField;
		$header = $this->header;

if ($this->query)
		{
			// Get the database object.
			$db = Factory::getDbo();

// Set the query and get the result list.
			$db->setQuery($this->query);

try
			{
				$items = $db->loadObjectList();
			}
			catch (ExecutionFailureException $e)
			{
				Factory::getApplication()->enqueueMessage(Text::_('JERROR_AN_ERROR_HAS_OCCURRED'), 'error');
			}
		}

// Add header.
		if (!empty($header))
		{
			$header_title = Text::_($header);
			$options[] = HTMLHelper::_('select.option', '', $header_title);
		}

// Build the field options.
		if (!empty($items))
		{
			foreach ($items as $item)
			{
				if ($this->translate == true)
				{
					$options[] = HTMLHelper::_('select.option', $item->$key, Text::_($item->$value));
				}
				else
				{
					$options[] = HTMLHelper::_('select.option', $item->$key, $item->$value);
				}
			}
		}

// Merge any additional options in the XML definition.
		$options = array_merge(parent::getOptions(), $options);

return $options;
	}
}

X7ROOT File Manager

Editing: SqlField.php

Upload File

Create Folder