Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Friday, March 29, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Dynamic filters in the lists (rights)

phpMyEdit General     Dynamic filters in the lists (rights)
Post new topic   Reply to topic    
 
nosky     Joined: 23 Nov 2007   Posts: 1  
Post 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    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy