1 | <?php
|
---|
2 |
|
---|
3 | class DatabaseList extends Module
|
---|
4 | {
|
---|
5 | var $Dependencies = array('Log', 'User');
|
---|
6 |
|
---|
7 | function AddItem($TableId, $Values)
|
---|
8 | {
|
---|
9 | $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
|
---|
10 | $DbRow = $DbResult->fetch_assoc();
|
---|
11 | $TableName = $DbRow['TableName'];
|
---|
12 |
|
---|
13 | $this->Database->insert(array('Table' => $TableName), $Values);
|
---|
14 | return($this->Database->insert_id);
|
---|
15 | }
|
---|
16 |
|
---|
17 | function DeleteItem($TableId, $ItemId)
|
---|
18 | {
|
---|
19 | $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
|
---|
20 | $DbRow = $DbResult->fetch_assoc();
|
---|
21 | $TableName = $DbRow['TableName'];
|
---|
22 | $this->Database->delete(array('Table' => $TableName, 'Condition' => 'Id='.$ItemId), array('DeletionTime' => 'NOW()'));
|
---|
23 | }
|
---|
24 |
|
---|
25 | function EditItem($TableId, $Values, $ItemId)
|
---|
26 | {
|
---|
27 | $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
|
---|
28 | $DbRow = $DbResult->fetch_assoc();
|
---|
29 | $TableName = $DbRow['TableName'];
|
---|
30 | $this->DeleteItem($TableId, $ItemId);
|
---|
31 | $Values['Id'] = $ItemId;
|
---|
32 | $this->Database->replace(array('Table' => $TableName), $Values);
|
---|
33 | }
|
---|
34 | }
|
---|
35 |
|
---|
36 | ?>
|
---|