Index
» Projects
» phpMyEdit
» Forum
» Dynamic filters in the lists (rights) |
|
nosky
Joined: 23 Nov 2007
Posts: 1
Posted: 2007-11-23 15:30
Back to top
Reply with quote
|
Hello,
this is my first letter on forum - so I greets to all :-)
I am new in PME and SQL... and surely therefore I have problems... ;-)
My first problem...
I have database with tables:
Code: |
--- Users ---
id, username, Systemy_id |
Code: |
--- Systemy ---
id, Nazwa, Rights |
I substitute under Systemy_id suitable name Nazwa from Systemy.
Till this moment it is OK:
Code: |
$opts['fdd']['Systemy_id'] = array(
'name' => 'System',
'values' => Array(
'table' => 'Systemy',
'column' => 'id',
'description' => 'Nazwa'),
'join' => '$main_table.Zgloszenia = $join_table.Systemy',
'select' => 'D',
'maxlen' => 1,
'default' => 0,
'sort' => true,
'required' => true
);
$opts['fdd']['virtual_2'] = array(
'name' => 'System_virtual',
'sql' => 'PMEtable0.Systemy_id',
'select' => 'D',
'sort' => true,
'options' => 'H'
); |
and my problem begins...
I want to display to users on list exclusively these systems which they should see (send an authorization to systems in column Rights).
And I do not know how to make this... I checked already probably all ways and I surrendered :-{
Additional - in field Rights I wanted to record the name of systems (not id, but this has not meaning) with commas before and after name (to SQL question). And basing on on this field I wanted to display users only their systems...
But this does not works for me in panel admina too...
Is some solution on this? Does someone have idea? Thanks in advanced for every proposal :-)
Best regards
|
Post new topic
Reply to topic
|
|
|
|