Joomla! Documentation - User contributions [en]

Talk:Creating a modal form field

2011-12-09T16:22:58Z

IslandBilly:

I think there is a small omission in the display of /administrator/components/com_library/views/books/tmpl/modal.php

There is no opening php tag at the top, ie '<?php'

One other thing: being a novice, I find that I am not clear on just what file the getInput method is supposed to be in. I'm guessing from the context that it belongs in the same file as described above the method, ie admin/models/fields/modal/book.php, but it would be nice if you make that clear.

Bill

[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 09:05, 9 December 2011 (CST)

Talk:Creating a modal form field

2011-12-09T15:05:23Z

IslandBilly: Created page with "I think there is a small omission in the display of /administrator/components/com_library/views/books/tmpl/modal.php There is no opening php tag at the top, ie '<?php' Bill ~~~~"

I think there is a small omission in the display of /administrator/components/com_library/views/books/tmpl/modal.php

There is no opening php tag at the top, ie '<?php'

Bill

[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 09:05, 9 December 2011 (CST)

J1.5 talk:Adding sortable columns to a table in a component

2011-11-28T21:21:21Z

IslandBilly: /* order clause in getListQuery() causing SQL syntax error in Joomla v1.7 */ new section

==Article Altered==
Hopefully final fix after much head-banging upon desk
[[User:Zola|Zola]] 03:38, 7 March 2010 (UTC)
==Suggested Fix==
There is a problem with this example. As reported in many posts, the column headings only allow DESCending sorts. In addition, the grid.sort method called by JHTML doesn't display the sort direction arrow graphic. If you can live without having the final sort column and sort direction stored in the user state for future use, the problem can be fixed as follows. The whole process is shown rather than alterations.

1. Add a new private variable to the MODEL. This is used to store the sort column field name and the sort direction.

<source lang="php">
var $_order = array();
</source>

2. Add the following lines to the MODEL __construct() function. Values for filter_order and filter_order_Dir are pulled from the $_REQUEST array (if present) or default values substituted. Replace 'fieldName' with the name of the MySQL field name you want to sort by default. Change 'asc' to 'desc' if you want the default sort direction to be descending.

<source lang="php">
$this->_order[] = JRequest::getVar('filter_order', 'fieldName', 'POST', 'cmd');
$this->_order[] = JRequest::getVar('filter_order_Dir', 'asc', 'POST', 'word');
</source>

3. Add a new private function to the MODEL to general the necessary MySQL query suffix. The MODEL will need to call this function and append the result to any existing MySQL query before execution.

<source lang="php">
function _buildContentOrderBy() {
return ' ORDER BY '.$this->_order[0].' '.$this->_order[1].' ';
}
</source>

If, for example, the query was stored in a private variable called $_query, the following would need to be added before the query is passed for execution.

<source lang="php">
$this->_query .= $this->_buildContentOrderBy();
</source>

4. Add a new public function to the MODEL so that the ordering field and sort direction can be accessed by the VIEW using the get() method.

<source lang="php">
function getOrder() {
return $this->_order;
}
</source>

5. Add the following lines to the display() function in the VIEW (usually view.html.php). This uses the JView::get() method to 'get' a copy of the array containing the ordering field and sort direction from the MODEL. The array is then assigned to the TEMPLATE.

<source lang="php">
$lists =& $this->get( 'order' );
$this->assignRef( 'lists', $lists );
</source>

6. To conform with HTML add the following to the TEMPLATE (usually default.php). This ensures that the Javascript necessary is placed between the the <head></head> tags. Change 'formName' to the name attribute of the <form> used later (see below)

<source lang="php">
<?php
JFactory::getDocument()->addScriptDeclaration( "
function tableOrdering( order, dir, task ) {
var form = document.formName;
form.filter_order.value = order;
form.filter_order_Dir.value = dir;
form.submit( task );
}"
);
?>
</source>

7. Enclose the table to be sorted in <form></form> tags and add two hidden input fields as follows

<source lang="php">
<form action="index.php?option=com_componentName" method="post" name="formName">
...
table goes here
...
<input type="hidden" name="filter_order" value="<?php echo $this->lists[0]; ?>" />
<input type="hidden" name="filter_order_Dir" value="<?php echo $this->lists[1]; ?>" />
</form>
</source>

Change the <form> action attribute as needed or use the JRoute method if you have the file router.php set up for SEF URLs.

8. For each of the columns you want to sort, replace each of the column headings with the following (enclosed in 'th' and '/th' tags). Change 'columnXName' to the table columns heading text you want and change fieldXName to the corresponding MySQL field names. Leave non-sortable columns unchanged.

<source lang="php">
<tr>
<th><?php echo JHTML::_( 'grid.sort', 'column1Name', 'field1Name', $this->lists[1], $this->lists[0]); ?></th>
<th><?php echo JHTML::_( 'grid.sort', 'column2Name', 'field2Name', $this->lists[1], $this->lists[0]); ?></th>
<th><?php echo JText::_( 'unSortableColumnName'); ?></th>
<th><?php echo JHTML::_( 'grid.sort', 'column3Name', 'field3Name', $this->lists[1], $this->lists[0]); ?></th>
</tr>
</source>

Preserving the state of 'filter_order' and 'filter_order_Dir' could be achieved by altering the MODEL __construct() function.

[[User:Fletcher|Fletcher]] 17:11, 11 October 2009 (UTC)

== order clause in getListQuery() causing SQL syntax error in Joomla v1.7 ==

I have been trying to add sortable columns using this page, and when I add the order clause,

$query->order($db->getEscaped($this->getState('filter_order', 'default_sort_column')) . ' ' . $db->getEscaped($this->getState('filter_order_Dir', 'ASC')));

I get a sql syntax error (MySQL 5.5). The display indicates that the order function has generated "ORDER BY" with nothing after it.

Any ideas on what's going wrong? I have all the other pieces in place, according to this document.

Bill

[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 15:21, 28 November 2011 (CST)

Archived talk:Developing a MVC Component/Adding ACL

2011-11-12T17:35:38Z

IslandBilly:

Somehow the ACL doesn't work on Edit permission for me. It shows both Save & New and Save as Copy buttons when it has no create rights. Gone through the code twice, but cannot see anything wrong with it... Anybody else have same problem? --[[User:A2Ggeir|A2Ggeir]] 10:19, 6 December 2010 (UTC)

Did a little debug and it seems the values from function canDo() in Helper does not return the right values when it is in edit view.

Result when in listview:
<code>
'core.admin' => NULL,
'core.manage' => true,
'core.create' => false,
'core.edit' => true,
'core.delete' => false,
</code>

Result when in editview:
<code>
'core.admin' => NULL,
'core.manage' => NULL,
'core.create' => true,
'core.edit' => true,
'core.delete' => true,
</code>

--[[User:A2Ggeir|A2Ggeir]] 12:02, 7 December 2010 (UTC)

== Delet dosn't work ==

when you want to delete a message it goes wrong and the message appears:

500 - Es ist ein Fehler aufgetreten

Layout „default“ nicht gefunden

downt know why its not working... maybee some can check this out.

Greetz

-------------------------------------------------------------------------------

Ok, so I have carefully followed the tutorial to here. What I need to know now is HOW do I allow a user who only has edit.own rights to get to the admin edit for the component??

I tried for a while to create an edit page on the front end, but no luck and no help. It occurred to me that perhaps if I could not bring the mountain to Mohammed, I could get Mohammed access to the mountain. But how to do it without making every user an administrator? Even a manager has too much other access.
<p>

[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 10:14, 12 November 2011 (CST) Using v1.7

Archived talk:Developing a MVC Component/Adding ACL

2011-11-12T17:33:18Z

IslandBilly:

Somehow the ACL doesn't work on Edit permission for me. It shows both Save & New and Save as Copy buttons when it has no create rights. Gone through the code twice, but cannot see anything wrong with it... Anybody else have same problem? --[[User:A2Ggeir|A2Ggeir]] 10:19, 6 December 2010 (UTC)

Did a little debug and it seems the values from function canDo() in Helper does not return the right values when it is in edit view.

Result when in listview:
<code>
'core.admin' => NULL,
'core.manage' => true,
'core.create' => false,
'core.edit' => true,
'core.delete' => false,
</code>

Result when in editview:
<code>
'core.admin' => NULL,
'core.manage' => NULL,
'core.create' => true,
'core.edit' => true,
'core.delete' => true,
</code>

--[[User:A2Ggeir|A2Ggeir]] 12:02, 7 December 2010 (UTC)

== Delet dosn't work ==

when you want to delete a message it goes wrong and the message appears:

500 - Es ist ein Fehler aufgetreten

Layout „default“ nicht gefunden

downt know why its not working... maybee some can check this out.

Greetz

-------------------------------------------------------------------------------

Ok, so I have carefully followed the tutorial to here. What I need to know now is HOW do I allow a user who only has edit.own rights to get to the admin edit for the component??

I tried for a while to create an edit page on the front end, but no luck and no help. It occurred to me that perhaps if I could not bring the mountain to Mohammed, I could get Mohammed access to the mountain. But how to do it without making every user an administrator? Even a manager has too much other access.
<p>
[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 10:14, 12 November 2011 (CST)

Archived talk:Developing a MVC Component/Adding configuration

2011-11-12T17:29:58Z

IslandBilly: Blanked the page

Archived talk:Developing a MVC Component/Adding configuration

2011-11-12T16:14:41Z

IslandBilly:

Ok, so I have carefully followed the tutorial to here. What I need to know now is HOW do I allow a user who only has edit.own rights to the component to get to the admin edit for the component??

I tried for a while to create an edit page on the front end, but no luck and no help. It occurred to me that perhaps if I could not bring the mountain to Mohammed, I could get Mohammed access to the mountain. But how to do it without making every user an administrator? Even a manager has too much other access.
<p>
[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 10:14, 12 November 2011 (CST)

Archived talk:Developing a MVC Component/Adding configuration

2011-11-12T16:14:05Z

IslandBilly:

Ok, so I have carefully followed the tutorial to here. What I need to know now is HOW do I allow a user who only has edit.own rights to the component to get to the admin edit for the component??

I tried for a while to create an edit page on the front end, but no luck and no help. It occurred to me that perhaps if I could not bring the mountain to Mohammed, I could get Mohammed access to the mountain. But how to do it without making every user an administrator? Even a manager has too much other access.
[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 10:14, 12 November 2011 (CST)

Archived talk:Developing a MVC Component/Adding configuration

2011-11-12T16:12:52Z

IslandBilly: How to give an edit.own level user access to the back end edits?

Talk:Extension types (technical definitions)

2011-10-14T17:46:29Z

IslandBilly: How does the site (user) interface work?

The last thing this article says is "The user portion has no menu component, but is otherwise very similar to the admin portion." Okay, so how exactly does the user side work? Where is that specified? I wish there were a link to that in the article because that is the part I need to undrstand. I have gone through the MVC tutorial on writing a component, but this does virtually nothing. I want to know how to present an edit form to the user similar to what's on the admin side.
Do I really have to write a module for this?

Archived talk:Developing a MVC Component/Adding verifications

2011-10-03T13:21:44Z

IslandBilly: /* verification seems to operate even when required="false" is coded */

Why is the protected function _populateState() in the /admin/models/helloworld.php file? It doesn't appear in the original helloworld.php model file, and there isn't any indication as to the purpose of this function aside from the annotations within the function, which I don't fully understand.

== Attention ==

Section about admin/views/helloworld/tmpl/edit.php is not the same as in file present in archive.

== verification seems to operate even when required="false" is coded ==

I have expanded the helloworld component to have several other fields now, and set some of them to required="false" in the /models/forms/app.xml file. I still get "invalid field" when I leave the input box empty. Any ideas?

(later) I think I figured it out: the client-side script operates on every field it's assigned to, whereas the server-side <i>may</i> operate only on a field that's required and not empty. Not sure about that last, but I am sure that the client-side script operates, so you may want to code the regex differently in admin/models/forms/<com-name>.js (the client side) vs admin/models/rules/<field>.php .

[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 10:51, 30 September 2011 (CDT)

Archived talk:Developing a MVC Component/Adding verifications

2011-10-03T13:21:08Z

IslandBilly: /* verification seems to operate even when required="false" is coded */

Why is the protected function _populateState() in the /admin/models/helloworld.php file? It doesn't appear in the original helloworld.php model file, and there isn't any indication as to the purpose of this function aside from the annotations within the function, which I don't fully understand.

== Attention ==

Section about admin/views/helloworld/tmpl/edit.php is not the same as in file present in archive.

== verification seems to operate even when required="false" is coded ==

I have expanded the helloworld component to have several other fields now, and set some of them to required="false" in the /models/forms/app.xml file. I still get "invalid field" when I leave the input box empty. Any ideas?

(later) I think I figured it out: the client-side script operates on every field it's assigned to, whereas the server-side <i>may</i> operate only on a field that's required and not empty. Not sure about that last, but I am sure that the client-side script operates, so you may want to code the regex differnently in admin/models/forms/<com-name>.js (the client side) vs admin/models/rules/<field>.php .

[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 10:51, 30 September 2011 (CDT)

Archived talk:Developing a MVC Component/Adding verifications

2011-10-03T13:20:12Z

IslandBilly: /* verification seems to operate even when required="false" is coded */

Why is the protected function _populateState() in the /admin/models/helloworld.php file? It doesn't appear in the original helloworld.php model file, and there isn't any indication as to the purpose of this function aside from the annotations within the function, which I don't fully understand.

== Attention ==

Section about admin/views/helloworld/tmpl/edit.php is not the same as in file present in archive.

== verification seems to operate even when required="false" is coded ==

I have expanded the helloworld component to have several other fields now, and set some of them to required="false" in the /models/forms/app.xml file. I still get "invalid field" when I leave the input box empty. Any ideas?

(later) I think I figured it out: the client-side script operates on every field it's assigned to, whereas the server-side may operate only on a field that's required and not empty. Not sure about that last, but I am sure that the client-side script operates, so you may want to code the regex differnently in admin/models/forms/<com-name>.js (the client side) vs admin/models/rules/<field>.php .

[[User:IslandBilly|"In theory, there's no difference between theory and practice; in practice, there is" --Yogi Berra]] 10:51, 30 September 2011 (CDT)

Archived talk:Developing a MVC Component/Adding verifications

2011-09-30T15:52:17Z

IslandBilly: /* verification seems to operate even when required="false" is coded */

Archived talk:Developing a MVC Component/Adding verifications

2011-09-30T15:51:41Z

IslandBilly: /* verification seems to operate even when required="false" is coded */ new section