<?php
|
|
class plugin_dbhistory extends plugin_base {
|
|
var $module;
|
var $form;
|
var $tab;
|
var $record_id;
|
var $formdef;
|
var $options;
|
|
function onShow() {
|
|
global $app, $conf;
|
|
$content = '';
|
|
$db_table = $app->tform->formDef["db_table"];
|
$db_table_idx = $app->tform->formDef["db_table_idx"];
|
$primary_id = $this->form->id;
|
if($_SESSION["s"]["user"]["typ"] == 'admin') {
|
$sql = "SELECT action, tstamp, user, data FROM sys_datalog WHERE dbtable = '".$db_table."' AND dbidx = '".$db_table_idx.":".$primary_id."'";
|
} else {
|
$sql = "SELECT action, tstamp, user, data FROM sys_datalog WHERE user = '".$_SESSION["s"]["user"]["username"]."' dbtable = '".$db_table."' AND dbidx = '".$db_table_idx.":".$primary_id."'";
|
}
|
|
$records = $app->db->queryAllRecords($sql);
|
if(is_array($records)) {
|
$content .= '<table width="100%">';
|
foreach($records as $rec) {
|
$content .= "<tr><td class='frmText11' bgcolor='#EEEEEE'><b>".date("d.m.Y",$rec["tstamp"])." ".$rec["user"]."</b></td></tr>";
|
}
|
$content .= '</table>';
|
}
|
|
return $content;
|
|
}
|
}
|
|
?>
|