joeschoe
Joined: 04 May 2009
Posts: 9
Posted: 2009-05-20 15:49
Back to top
Reply with quote
|
Where can I find a description of the sorting and filtering options available to the end user.
This is in the list mode.
For example how to filter a range of dates, or only records above or below a certain date.
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-05-23 18:08
Back to top
Reply with quote
|
Try the documentation "Selection boxes"
http://opensource.platon.sk/projects/doc.php/phpMyEdit/html/configuration.basic-options.html#AEN833
select N is probably what you need
|
joeschoe
Joined: 04 May 2009
Posts: 9
Posted: 2009-05-23 22:02
Back to top
Reply with quote
|
Thanks Doug, this is not what I am looking for though.
The resulting view of a table listing has various options available to the viewer, such as sorting and filtering.
I am looking for instructions for the viewer, how can he select by a specific date, or a range of dates for example.
Is there a write up of using the interface once it is shown on the screen.?
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-05-23 22:28
Back to top
Reply with quote
|
No instructions are written. Everyone has different needs, and frequently a different language. One hint that might be helpful is that if $_REQUEST['PME_sys_operation'] is NOT set then the page is in List mode. Knowing this would enable you to conditionally display instructions in the header or footer for List mode, which would not appear in the other page modes.
|
joeschoe
Joined: 04 May 2009
Posts: 9
Posted: 2009-05-23 22:48
Back to top
Reply with quote
|
| doug wrote: |
| No instructions are written. Everyone has different needs, and frequently a different language. One hint that might be helpful is that if $_REQUEST['PME_sys_operation'] is NOT set then the page is in List mode. Knowing this would enable you to conditionally display instructions in the header or footer for List mode, which would not appear in the other page modes. |
OK no documentation for your final interface is available.
Perhaps you can answer one need. In the list mode with filter available, I have a list of students and their examination results as a percent. (0 to 100).
If the end user wants to see all the students who achieved 60% and above, how can he do it? Is there a method of specifying a range like 60 to 100 , or greater than 60?
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-05-23 23:05
Back to top
Reply with quote
|
'select' => 'N' will yield a drop down in List mode having =, >=, <=, and > (but a range cannot be specified)
|
joeschoe
Joined: 04 May 2009
Posts: 9
Posted: 2009-05-24 00:59
Back to top
Reply with quote
|
Thanks Doug.
You have been very helpful and patient.
Is there any hope that a range will be included in future releases?
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2009-05-24 01:23
Back to top
Reply with quote
|
Not to my knowledge. Development has pretty much reached a stand-still. Think about the 'filters' option. There are examples in the forum for creating your own links that can pass variables which you might evaluate using PHP and create various filters which provide users with pre-set ranges. The following example was used to pass the first letter of a company name from an address book sort of application, to filter out by A-B-C, etc.
| Code: |
// Example of displaying A HREF tags and filtering records.
// Get fl2 (passed from custom links appearing in the page footer)
$fl2 = array_key_exists('fl2', @$_REQUEST) ? strip_tags(stripslashes(trim(@$_REQUEST['fl2']))) : '';
if($fl2 > '') {
$opts['cgi']['persist'] = array('fl2' => $fl2);
$opts['filters'] = 'Company REGEXP "^'.$fl2.'"';
$special_label = 'Filter by Company ('.$fl2.')';
}
// Get fl3 (passed from custom links appearing in the page footer)
$fl3 = array_key_exists('fl3', @$_REQUEST) ? strip_tags(stripslashes(trim(@$_REQUEST['fl3']))) : '';
if($fl3 > '') {
$opts['cgi']['persist'] = array('fl3' => $fl3);
$opts['filters'] = 'LastName REGEXP "^'.$fl3.'"';
$special_label = 'Filter by Last Name ('.$fl3.')';
}
// normal form content...
$opts['tb'] = 'contacts';
$opts['key'] = 'ID';
$opts['key_type'] = 'int';
$opts['sort_field'] = array('Company');
$opts['inc'] = 10;
$opts['options'] = 'ACPVDF';
$opts['multiple'] = '4';
$opts['navigation'] = 'TUD';
$opts['display'] = array('form' => true, 'query' => true, 'sort' => true, 'time' => false, 'tabs' => true);
$opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
$opts['fdd']['ID'] = array(
'css' => array('postfix' => 'right-justify'),
'default' => '0',
'input' => 'R',
'maxlen' => 8,
'name' => 'ID',
'options' => 'VD',
'required' => true,
'select' => 'T',
'size|ACP' => 8,
'tab' => 'Company',
'sort' => true
);
$opts['fdd']['Company'] = array(
'help|ACP' => 'Limit 255 chars.',
'input' => '',
'maxlen' => 255,
'name' => 'Company',
'options' => 'ACPVDLF',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'sort' => true
);
$opts['fdd']['FirstName'] = array(
'input' => '',
'maxlen' => 255,
'name' => 'FirstName',
'options' => 'ACPVDLF',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'sort' => true
);
// Column type: string - varchar(255)
$opts['fdd']['LastName'] = array(
'input' => '',
'maxlen' => 255,
'name' => 'LastName',
'options' => 'ACPVDFL',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'sort' => true
);
require('phpMyEdit.tabclass.php');
new phpMyEdit($opts);
/*
// Determine current page mode, and then display A HREF tags with filters.
$_REQUEST['PME_sys_operation'] (if set) will return one of View, Change, Copy, or Delete
If the above is not set then one of the following is probably set.
$_REQUEST['PME_sys_canceladd'] (if set) returns Cancel
$_REQUEST['PME_sys_cancelchange'] (if set) returns Cancel
$_REQUEST['PME_sys_cancelcopy'] (if set) returns Cancel
$_REQUEST['PME_sys_canceldelete'] (if set) returns Cancel
$_REQUEST['PME_sys_cancelview'] (if set) returns Cancel
$_REQUEST['PME_sys_moreadd'] (if set) returns More
$_REQUEST['PME_sys_morechange'] (if set) returns Apply
$_REQUEST['PME_sys_saveadd'] (if set) returns Save
$_REQUEST['PME_sys_savechange'] (if set) returns Save
$_REQUEST['PME_sys_savecopy'] (if set) returns Save
$_REQUEST['PME_sys_savedelete'] (if set) returns Save
*/
if(!isset($_REQUEST['PME_sys_operation']) && !isset($_REQUEST['PME_sys_moreadd']) && !isset($_REQUEST['PME_sys_morechange'])){
echo "\n".'<table class="container"><tr><td>Company Filter</td><td>';
for($i=65; $i<91; ++$i) {
echo "\n".'<a href="'.basename($_SERVER["PHP_SELF"]).'?fl2='.chr($i).'">'.chr($i).'</a>';
echo ($i < 90) ? ' - '."\n" : "\n";
}
echo "\n".'</td></tr>';
echo "\n".'<tr><td>Last Name Filter</td><td>';
for($i=65; $i<91; ++$i) {
echo "\n".'<a href="'.basename($_SERVER["PHP_SELF"]).'?fl3='.chr($i).'">'.chr($i).'</a>';
echo ($i < 90) ? ' - '."\n" : "\n";
}
echo "\n".'</td></tr><tr><td colspan="2"><a href="'.basename($_SERVER["PHP_SELF"]).'?fl2=&fl3=">List All</a></td></tr></table>';
}
|
|
joeschoe
Joined: 04 May 2009
Posts: 9
Posted: 2009-05-24 05:41
Back to top
Reply with quote
|
| doug wrote: |
Not to my knowledge. Development has pretty much reached a stand-still. Think about the 'filters' option. There are examples in the forum for creating your own links that can pass variables which you might evaluate using PHP and create various filters which provide users with pre-set ranges. The following example was used to pass the first letter of a company name from an address book sort of application, to filter out by A-B-C, etc.
| Code: |
// Example of displaying A HREF tags and filtering records.
// Get fl2 (passed from custom links appearing in the page footer)
$fl2 = array_key_exists('fl2', @$_REQUEST) ? strip_tags(stripslashes(trim(@$_REQUEST['fl2']))) : '';
if($fl2 > '') {
$opts['cgi']['persist'] = array('fl2' => $fl2);
$opts['filters'] = 'Company REGEXP "^'.$fl2.'"';
$special_label = 'Filter by Company ('.$fl2.')';
}
// Get fl3 (passed from custom links appearing in the page footer)
$fl3 = array_key_exists('fl3', @$_REQUEST) ? strip_tags(stripslashes(trim(@$_REQUEST['fl3']))) : '';
if($fl3 > '') {
$opts['cgi']['persist'] = array('fl3' => $fl3);
$opts['filters'] = 'LastName REGEXP "^'.$fl3.'"';
$special_label = 'Filter by Last Name ('.$fl3.')';
}
// normal form content...
$opts['tb'] = 'contacts';
$opts['key'] = 'ID';
$opts['key_type'] = 'int';
$opts['sort_field'] = array('Company');
$opts['inc'] = 10;
$opts['options'] = 'ACPVDF';
$opts['multiple'] = '4';
$opts['navigation'] = 'TUD';
$opts['display'] = array('form' => true, 'query' => true, 'sort' => true, 'time' => false, 'tabs' => true);
$opts['language'] = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
$opts['fdd']['ID'] = array(
'css' => array('postfix' => 'right-justify'),
'default' => '0',
'input' => 'R',
'maxlen' => 8,
'name' => 'ID',
'options' => 'VD',
'required' => true,
'select' => 'T',
'size|ACP' => 8,
'tab' => 'Company',
'sort' => true
);
$opts['fdd']['Company'] = array(
'help|ACP' => 'Limit 255 chars.',
'input' => '',
'maxlen' => 255,
'name' => 'Company',
'options' => 'ACPVDLF',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'sort' => true
);
$opts['fdd']['FirstName'] = array(
'input' => '',
'maxlen' => 255,
'name' => 'FirstName',
'options' => 'ACPVDLF',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'sort' => true
);
// Column type: string - varchar(255)
$opts['fdd']['LastName'] = array(
'input' => '',
'maxlen' => 255,
'name' => 'LastName',
'options' => 'ACPVDFL',
'required' => false,
'select' => 'T',
'size|ACP' => 60,
'sqlw' => 'TRIM("$val_as")',
'sort' => true
);
require('phpMyEdit.tabclass.php');
new phpMyEdit($opts);
/*
// Determine current page mode, and then display A HREF tags with filters.
$_REQUEST['PME_sys_operation'] (if set) will return one of View, Change, Copy, or Delete
If the above is not set then one of the following is probably set.
$_REQUEST['PME_sys_canceladd'] (if set) returns Cancel
$_REQUEST['PME_sys_cancelchange'] (if set) returns Cancel
$_REQUEST['PME_sys_cancelcopy'] (if set) returns Cancel
$_REQUEST['PME_sys_canceldelete'] (if set) returns Cancel
$_REQUEST['PME_sys_cancelview'] (if set) returns Cancel
$_REQUEST['PME_sys_moreadd'] (if set) returns More
$_REQUEST['PME_sys_morechange'] (if set) returns Apply
$_REQUEST['PME_sys_saveadd'] (if set) returns Save
$_REQUEST['PME_sys_savechange'] (if set) returns Save
$_REQUEST['PME_sys_savecopy'] (if set) returns Save
$_REQUEST['PME_sys_savedelete'] (if set) returns Save
*/
if(!isset($_REQUEST['PME_sys_operation']) && !isset($_REQUEST['PME_sys_moreadd']) && !isset($_REQUEST['PME_sys_morechange'])){
echo "\n".'<table class="container"><tr><td>Company Filter</td><td>';
for($i=65; $i<91; ++$i) {
echo "\n".'<a href="'.basename($_SERVER["PHP_SELF"]).'?fl2='.chr($i).'">'.chr($i).'</a>';
echo ($i < 90) ? ' - '."\n" : "\n";
}
echo "\n".'</td></tr>';
echo "\n".'<tr><td>Last Name Filter</td><td>';
for($i=65; $i<91; ++$i) {
echo "\n".'<a href="'.basename($_SERVER["PHP_SELF"]).'?fl3='.chr($i).'">'.chr($i).'</a>';
echo ($i < 90) ? ' - '."\n" : "\n";
}
echo "\n".'</td></tr><tr><td colspan="2"><a href="'.basename($_SERVER["PHP_SELF"]).'?fl2=&fl3=">List All</a></td></tr></table>';
}
|
|
Thats a great example, thanks for preparing it for me.
|
|
Post new topic
Reply to topic
|
|
Login
Registration
Slovak
