audit-trial feature in phpmaker only use as a data-store Without functional efficiency
it's only save data without reporting
i have 2 suggestion:
1- add ability to build report. for example in <table>view.php, developer can add a tab as audit for current record.
2- every event have a unique ID, for example when a user edit 4 record from device table, 8 record inserted in audittrial table, but i can not determine with query which group of records are related together. device with id=476 at 2 times has been edited but we don't have any separator in audit table for this 2 event
i suggest to add a event_id field to this table
id,datetime,script,user,action,table,field,keyvalue,oldvalue,newvalue
65026 2015-10-06 11:21:22 /devicesedit.php 862 U devices DeviceName 473 14.50 ESX 14.50
65027 2015-10-06 11:21:22 /devicesedit.php 862 U devices UserDate 473 2015-10-06 11:14:57 2015-10-06 11:21:22
65028 2015-10-06 11:21:31 /devicesedit.php 862 U devices DeviceName 476 14.40 ESX 14.40
65029 2015-10-06 11:21:31 /devicesedit.php 862 U devices UserDate 476 2015-10-05 14:31:54 2015-10-06 11:21:31
65030 2015-10-06 11:21:39 /devicesedit.php 862 U devices DeviceName 3 14.25 ESX 14.25
65031 2015-10-06 11:21:39 /devicesedit.php 862 U devices UserDate 3 2015-10-05 14:28:59 2015-10-06 11:21:39
65032 2015-10-06 11:21:47 /devicesedit.php 862 U devices DeviceName 476 14.30 ESX 14.30
65033 2015-10-06 11:21:47 /devicesedit.php 862 U devices UserDate 476 2015-10-05 14:30:36 2015-10-06 11:21:47