|
Last change
on this file since 430 was 430, checked in by chronos, 12 years ago |
- Přidáno: Správci sítě mají dostupný z hlavní stránky po přihlášení odkaz na Správu dat.
- Opraveno: Zobrazení vazeb 1:n a akcí v seznamech.
- Přidáno: Zobrazení formulářů ve správě dat.
|
|
File size:
1.5 KB
|
| Line | |
|---|
| 1 | <?php
|
|---|
| 2 |
|
|---|
| 3 | include_once(dirname(__FILE__).'/Base.php');
|
|---|
| 4 |
|
|---|
| 5 | class TypeOneToMany extends TypeBase
|
|---|
| 6 | {
|
|---|
| 7 | function OnView($Item)
|
|---|
| 8 | {
|
|---|
| 9 | $Type = $this->System->Type->TypeDefinitionList[$Item['Type']];
|
|---|
| 10 | if($Item['Value'] != '')
|
|---|
| 11 | {
|
|---|
| 12 | $DbResult = $this->System->Database->query('SELECT '.$Type['Parameters']['Name'].
|
|---|
| 13 | ' AS `Name` FROM `'.$Type['Parameters']['Table'].'` WHERE `'.
|
|---|
| 14 | $Type['Parameters']['Id'].'`='.$Item['Value']);
|
|---|
| 15 | $DbRow = $DbResult->fetch_assoc();
|
|---|
| 16 | $Output = '<a href="?t='.$Type['Parameters']['Table'].'&a='.
|
|---|
| 17 | 'view'.'&id='.$Item['Value'].'">'.$DbRow['Name'].'</a>';
|
|---|
| 18 | } else $Output = '';
|
|---|
| 19 | return($Output);
|
|---|
| 20 | }
|
|---|
| 21 |
|
|---|
| 22 | function OnEdit($Item)
|
|---|
| 23 | {
|
|---|
| 24 | $Output = '<select name="'.$Item['Name'].'">';
|
|---|
| 25 | $Type = $this->System->Type->TypeDefinitionList[$Item['Type']];
|
|---|
| 26 | if(array_key_exists('Condition', $Type['Parameters'])) $Where = ' WHERE '.$Type['Parameters']['Condition'];
|
|---|
| 27 | else $Where = '';
|
|---|
| 28 | $DbResult = $this->System->Database->query('SELECT '.$Type['Parameters']['Name'].' AS `Name`,'.$Type['Parameters']['Id'].' AS `Id` FROM `'.$Type['Parameters']['Table'].'`'.$Where.' ORDER BY `Name`');
|
|---|
| 29 | while($DbRow = $DbResult->fetch_assoc())
|
|---|
| 30 | {
|
|---|
| 31 | if($Item['Value'] == $DbRow['Id']) $Selected = ' selected="1"'; else $Selected = '';
|
|---|
| 32 | $Output .= '<option value="'.$DbRow['Id'].'"'.$Selected.'>'.$DbRow['Name'].'</option>';
|
|---|
| 33 | }
|
|---|
| 34 | $Output .= '</select>';
|
|---|
| 35 | return($Output);
|
|---|
| 36 | }
|
|---|
| 37 |
|
|---|
| 38 | function OnLoad($Item)
|
|---|
| 39 | {
|
|---|
| 40 | return($_POST[$Item['Name']]);
|
|---|
| 41 | }
|
|---|
| 42 | }
|
|---|
| 43 |
|
|---|
| 44 | ?>
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
