J3.x:Developing an MVC Component/Adding Access - Revision history

Robbiej: root record needs to have language set to * (All) and access set to 1

2022-09-20T17:01:21Z

root record needs to have language set to * (All) and access set to 1

← Older revision		Revision as of 17:01, 20 September 2022
Line 173:		Line 173:
	CREATE UNIQUE INDEX `aliasindex` ON `#__helloworld` (`alias`, `catid`);		CREATE UNIQUE INDEX `aliasindex` ON `#__helloworld` (`alias`, `catid`);

	INSERT INTO `#__helloworld` (`greeting`,`alias`,`language`, `parent_id`, `level`, `path`, `lft`, `rgt`, `published`) VALUES		INSERT INTO `#__helloworld` (`greeting`,`alias`,`language`, `parent_id`, `level`, `path`, `lft`, `rgt`, `published`, `access`) VALUES
	('helloworld root','helloworld-root-alias','~~en-GB~~', 0, 0, '', 0, 5, 1),		('helloworld root','helloworld-root-alias','*', 0, 0, '', 0, 5, 1, 1),
	('Hello World!','hello-world','en-GB', 1, 1, 'hello-world', 1, 2, 0),		('Hello World!','hello-world','en-GB', 1, 1, 'hello-world', 1, 2, 0, 1),
	('Goodbye World!','goodbye-world','en-GB', 1, 1, 'goodbye-world', 3, 4, 0);		('Goodbye World!','goodbye-world','en-GB', 1, 1, 'goodbye-world', 3, 4, 0, 1);

	INSERT INTO `#__content_types` (`type_title`, `type_alias`, `content_history_options`, `table`, `field_mappings`, `router`)		INSERT INTO `#__content_types` (`type_title`, `type_alias`, `content_history_options`, `table`, `field_mappings`, `router`)

ThiagoG: published column added since https://docs.joomla.org/J3.x:Developing_an_MVC_Component/Adding_Levels as we can't publish items without having our helloworld root record published.

2020-03-20T17:37:04Z

published column added since https://docs.joomla.org/J3.x:Developing_an_MVC_Component/Adding_Levels as we can't publish items without having our helloworld root record published.

← Older revision		Revision as of 17:37, 20 March 2020
Line 173:		Line 173:
	CREATE UNIQUE INDEX `aliasindex` ON `#__helloworld` (`alias`, `catid`);		CREATE UNIQUE INDEX `aliasindex` ON `#__helloworld` (`alias`, `catid`);

	INSERT INTO `#__helloworld` (`greeting`,`alias`,`language`, `parent_id`, `level`, `path`, `lft`, `rgt`) VALUES		INSERT INTO `#__helloworld` (`greeting`,`alias`,`language`, `parent_id`, `level`, `path`, `lft`, `rgt`, `published`) VALUES
	('helloworld root','helloworld-root-alias','en-GB', 0, 0, '', 0, 5),		('helloworld root','helloworld-root-alias','en-GB', 0, 0, '', 0, 5, 1),
	('Hello World!','hello-world','en-GB', 1, 1, 'hello-world', 1, 2),		('Hello World!','hello-world','en-GB', 1, 1, 'hello-world', 1, 2, 0),
	('Goodbye World!','goodbye-world','en-GB', 1, 1, 'goodbye-world', 3, 4);		('Goodbye World!','goodbye-world','en-GB', 1, 1, 'goodbye-world', 3, 4, 0);

	INSERT INTO `#__content_types` (`type_title`, `type_alias`, `content_history_options`, `table`, `field_mappings`, `router`)		INSERT INTO `#__content_types` (`type_title`, `type_alias`, `content_history_options`, `table`, `field_mappings`, `router`)

Robbiej: small code fix in ajax response, handling case where catid=0

2019-01-31T17:32:38Z

small code fix in ajax response, handling case where catid=0

← Older revision		Revision as of 17:32, 31 January 2019
Line 1,167:		Line 1,167:
	$query->where('h.access IN (' . implode(",", $userAccessLevels) . ')');		$query->where('h.access IN (' . implode(",", $userAccessLevels) . ')');
	$query->join('LEFT', $db->quoteName('#__categories', 'c') . ' ON c.id = h.catid');		$query->join('LEFT', $db->quoteName('#__categories', 'c') . ' ON c.id = h.catid');
	$query->where('c.access IN (' . implode(",", $userAccessLevels) . ')');		$query->where('(c.access IN (' . implode(",", $userAccessLevels) . ') OR h.catid = 0)');
	}		}

Sandra97: Marked this version for translation

2019-01-19T05:34:49Z

Marked this version for translation

← Older revision		Revision as of 05:34, 19 January 2019
Line 44:		Line 44:
	<translate><!--T:14--> To enable us to have an Access Level against a helloworld record, we need to specify a new field in the database, which we'll call "access". We'll set the database default value of this access field to be 0, however in the <tt>JTable</tt> constructor there is code which looks for a database field called "access" and if it finds it then it sets the default value of the <tt>access</tt> property in the <tt>JTable</tt> object to have the value specified in the global config (in configuration.php). So we use this mechanism to align with what an administrator would want to have as the default access across the Joomla website.</translate>		<translate><!--T:14--> To enable us to have an Access Level against a helloworld record, we need to specify a new field in the database, which we'll call "access". We'll set the database default value of this access field to be 0, however in the <tt>JTable</tt> constructor there is code which looks for a database field called "access" and if it finds it then it sets the default value of the <tt>access</tt> property in the <tt>JTable</tt> object to have the value specified in the global config (in configuration.php). So we use this mechanism to align with what an administrator would want to have as the default access across the Joomla website.</translate>

	<translate>However, for those helloworld records already present in the database, we don't want to have the access field set to 0 (the SQL default), so after altering the table to introduce the new access field we must update those records. Ideally we should use an install script and perform a SQL UPDATE to set <tt>access</tt> to <tt>JFactory::getConfig()->get('access')</tt>, but for simplicity we just use a SQL UPDATE statement to set it to 1 (ie public access).</translate>		<translate><!--T:69--> However, for those helloworld records already present in the database, we don't want to have the access field set to 0 (the SQL default), so after altering the table to introduce the new access field we must update those records. Ideally we should use an install script and perform a SQL UPDATE to set <tt>access</tt> to <tt>JFactory::getConfig()->get('access')</tt>, but for simplicity we just use a SQL UPDATE statement to set it to 1 (ie public access).</translate>

	<translate><!--T:15--> We also have a change to our content_types field mapping, as described below.</translate>		<translate><!--T:15--> We also have a change to our content_types field mapping, as described below.</translate>

Sandra97: Marked for translation

2019-01-19T05:34:31Z

Marked for translation

← Older revision		Revision as of 05:34, 19 January 2019
Line 44:		Line 44:
	<translate><!--T:14--> To enable us to have an Access Level against a helloworld record, we need to specify a new field in the database, which we'll call "access". We'll set the database default value of this access field to be 0, however in the <tt>JTable</tt> constructor there is code which looks for a database field called "access" and if it finds it then it sets the default value of the <tt>access</tt> property in the <tt>JTable</tt> object to have the value specified in the global config (in configuration.php). So we use this mechanism to align with what an administrator would want to have as the default access across the Joomla website.</translate>		<translate><!--T:14--> To enable us to have an Access Level against a helloworld record, we need to specify a new field in the database, which we'll call "access". We'll set the database default value of this access field to be 0, however in the <tt>JTable</tt> constructor there is code which looks for a database field called "access" and if it finds it then it sets the default value of the <tt>access</tt> property in the <tt>JTable</tt> object to have the value specified in the global config (in configuration.php). So we use this mechanism to align with what an administrator would want to have as the default access across the Joomla website.</translate>

	However, for those helloworld records already present in the database, we don't want to have the access field set to 0 (the SQL default), so after altering the table to introduce the new access field we must update those records. Ideally we should use an install script and perform a SQL UPDATE to set <tt>access</tt> to <tt>JFactory::getConfig()->get('access')</tt>, but for simplicity we just use a SQL UPDATE statement to set it to 1 (ie public access).		<translate>However, for those helloworld records already present in the database, we don't want to have the access field set to 0 (the SQL default), so after altering the table to introduce the new access field we must update those records. Ideally we should use an install script and perform a SQL UPDATE to set <tt>access</tt> to <tt>JFactory::getConfig()->get('access')</tt>, but for simplicity we just use a SQL UPDATE statement to set it to 1 (ie public access).</translate>

	<translate><!--T:15--> We also have a change to our content_types field mapping, as described below.</translate>		<translate><!--T:15--> We also have a change to our content_types field mapping, as described below.</translate>

Robbiej: include sql update to fix initial value of access field

2019-01-18T17:07:41Z

include sql update to fix initial value of access field

← Older revision		Revision as of 17:07, 18 January 2019
Line 43:		Line 43:
	</translate>		</translate>
	<translate><!--T:14--> To enable us to have an Access Level against a helloworld record, we need to specify a new field in the database, which we'll call "access". We'll set the database default value of this access field to be 0, however in the <tt>JTable</tt> constructor there is code which looks for a database field called "access" and if it finds it then it sets the default value of the <tt>access</tt> property in the <tt>JTable</tt> object to have the value specified in the global config (in configuration.php). So we use this mechanism to align with what an administrator would want to have as the default access across the Joomla website.</translate>		<translate><!--T:14--> To enable us to have an Access Level against a helloworld record, we need to specify a new field in the database, which we'll call "access". We'll set the database default value of this access field to be 0, however in the <tt>JTable</tt> constructor there is code which looks for a database field called "access" and if it finds it then it sets the default value of the <tt>access</tt> property in the <tt>JTable</tt> object to have the value specified in the global config (in configuration.php). So we use this mechanism to align with what an administrator would want to have as the default access across the Joomla website.</translate>

			However, for those helloworld records already present in the database, we don't want to have the access field set to 0 (the SQL default), so after altering the table to introduce the new access field we must update those records. Ideally we should use an install script and perform a SQL UPDATE to set <tt>access</tt> to <tt>JFactory::getConfig()->get('access')</tt>, but for simplicity we just use a SQL UPDATE statement to set it to 1 (ie public access).

	<translate><!--T:15--> We also have a change to our content_types field mapping, as described below.</translate>		<translate><!--T:15--> We also have a change to our content_types field mapping, as described below.</translate>
Line 116:		Line 118:
	<source lang="sql">		<source lang="sql">
	ALTER TABLE `#__helloworld` ADD COLUMN `access` tinyint(4) NOT NULL DEFAULT '0' AFTER `published`;		ALTER TABLE `#__helloworld` ADD COLUMN `access` tinyint(4) NOT NULL DEFAULT '0' AFTER `published`;
			UPDATE `#__helloworld` SET `access` = 1;

	UPDATE `#__content_types` SET		UPDATE `#__content_types` SET

Sandra97: Marked this version for translation

2019-01-12T04:11:45Z

Marked this version for translation

Show changes

Sandra97: Marked for translation

2019-01-12T04:11:31Z

Marked for translation

Show changes

Robbiej: include language field in field mapping

2019-01-10T22:23:30Z

include language field in field mapping

← Older revision		Revision as of 22:23, 10 January 2019
Line 100:		Line 100:
	`field_mappings` =		`field_mappings` =
	'{"common": {		'{"common": {
	"core_content_item_id": "id",		"core_content_item_id": "id",
	"core_title": "greeting",		"core_title": "greeting",
	"core_state": "published",		"core_state": "published",
	"core_alias": "alias",		"core_alias": "alias",
	"core_created_time": "created",		"core_language":"language",
	"core_body": "description",		"core_created_time": "created",
			"core_body": "description",
	"core_access": "access",		"core_access": "access",
	"core_catid": "catid"		"core_catid": "catid"
	}}'		}}'
	WHERE `type_alias` = 'com_helloworld.helloworld';		WHERE `type_alias` = 'com_helloworld.helloworld';
Line 115:		Line 116:
	<span id="admin/sql/install.mysql.utf8.sql">		<span id="admin/sql/install.mysql.utf8.sql">
	<tt>admin/sql/install.mysql.utf8.sql</tt>		<tt>admin/sql/install.mysql.utf8.sql</tt>
	<source lang="sql" highlight="20,59">		<source lang="sql" highlight="20,60">
	DROP TABLE IF EXISTS `#__helloworld`;		DROP TABLE IF EXISTS `#__helloworld`;

Line 128:		Line 129:
	`description` VARCHAR(4000) NOT NULL DEFAULT '',		`description` VARCHAR(4000) NOT NULL DEFAULT '',
	`alias` VARCHAR(40) NOT NULL DEFAULT '',		`alias` VARCHAR(40) NOT NULL DEFAULT '',
	`language` CHAR(7) NOT NULL DEFAULT '*',		`language` CHAR(7) NOT NULL DEFAULT '*',
	`parent_id` int(10) NOT NULL DEFAULT '1',		`parent_id` int(10) NOT NULL DEFAULT '1',
	`level` int(10) NOT NULL DEFAULT '0',		`level` int(10) NOT NULL DEFAULT '0',
Line 168:		Line 169:
	"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}',		"common":{"dbtable":"#__ucm_content","key":"ucm_id","type":"Corecontent","prefix":"JTable","config":"array()"}}',
	'{"common": {		'{"common": {
	"core_content_item_id": "id",		"core_content_item_id": "id",
	"core_title": "greeting",		"core_title": "greeting",
	"core_state": "published",		"core_state": "published",
	"core_alias": "alias",		"core_alias": "alias",
	"core_created_time": "created",		"core_language":"language",
	"core_body": "description",		"core_created_time": "created",
			"core_body": "description",
	"core_access": "access",		"core_access": "access",
	"core_catid": "catid"		"core_catid": "catid"
	}}',		}}',
	'HelloworldHelperRoute::getHelloworldRoute'),		'HelloworldHelperRoute::getHelloworldRoute'),

Robbiej: some small fixes

2019-01-05T20:36:57Z

some small fixes

← Older revision		Revision as of 20:36, 5 January 2019
Line 7:		Line 7:

	There is a video accompanying this step (which was originally produced at the same time as the other videos for ACL) available at [https://youtu.be/CS_Ok1t550E Access Levels].		There is a video accompanying this step (which was originally produced at the same time as the other videos for ACL) available at [https://youtu.be/CS_Ok1t550E Access Levels].

	~~== Under Construction! ==~~

	== Introduction ==		== Introduction ==
Line 954:		Line 952:
	<span id="site/models/helloworld.php">		<span id="site/models/helloworld.php">
	<tt>site/models/helloworld.php</tt>		<tt>site/models/helloworld.php</tt>
	<source lang="php" highlight="78,~~109~~-~~126~~,~~175~~-~~183~~">		<source lang="php" highlight="78-79,110-127,163,176-184">
	<?php		<?php
	/**		/**
Line 1,032:		Line 1,030:
	$db = JFactory::getDbo();		$db = JFactory::getDbo();
	$query = $db->getQuery(true);		$query = $db->getQuery(true);
	$query->select('h.greeting, h.params, h.image as image, c.title as category, h.latitude as latitude, h.longitude as longitude, h.access as access,		$query->select('h.greeting, h.params, h.image as image, c.title as category, c.access as catAccess,
			h.latitude as latitude, h.longitude as longitude, h.access as access,
	h.id as id, h.alias as alias, h.catid as catid, h.parent_id as parent_id, h.level as level, h.description as description')		h.id as id, h.alias as alias, h.catid as catid, h.parent_id as parent_id, h.level as level, h.description as description')
	->from('#__helloworld as h')		->from('#__helloworld as h')
Line 1,116:		Line 1,115:
	$db = JFactory::getDbo();		$db = JFactory::getDbo();
	$query = $db->getQuery(true);		$query = $db->getQuery(true);
	$query->select('h.id, h.alias, h.catid, h.greeting, h.latitude, h.longitude')		$query->select('h.id, h.alias, h.catid, h.greeting, h.latitude, h.longitude, h.access')
	->from('#__helloworld as h')		->from('#__helloworld as h')
	->where('h.latitude > ' . $mapbounds['minlat'] .		->where('h.latitude > ' . $mapbounds['minlat'] .
Line 1,509:		Line 1,508:
	if (isset($row->canAccess) && !$row->canAccess) : ?>		if (isset($row->canAccess) && !$row->canAccess) : ?>
	<tr>		<tr>
	<td align="center" colspan="5"><?php echo $row->greeting . JText::_('COM_HELLOWORLD_MUST_LOGIN'); ?></td>		<td align="center" colspan="5"><?php echo $row->greeting . " - " . JText::_('COM_HELLOWORLD_MUST_LOGIN'); ?></td>
	</tr>		</tr>
	<?php else :		<?php else :