AppGini Community Forums

Code: Select all

Bob has changed table Office, 
Field_1 was previously "YES" and now is changed to "NO", 
Field_2 was previously "testing" and now is changed to "working",
Field_3 was previously "none" and now is changed to "filled" 

Code: Select all

/* create a text field named 'log' in your table */

/* tablename-dv.js */

$j('#field1').on('change', function(){

var field_name = 'Field 1';

var table_name = 'Tablename';

var content = $j('#test').val();

var utc = new Date().toJSON().slice(0,19).replace(/-/g,'/');
var utc2 = utc.replace(/T/g,' ');
var now = utc2;


var url1="getMemberInfo.php"; 
jQuery.ajax({
url: url1,
dataType: 'json',
success:function(response){
	if( response ){
			var user = response;	
			
			var old_log = $j('#log').val();

			var current_edit = '\n\n'+user+' has changed table: '+table_name+' and field: '+field_name+'to: '+content+' at '+now+'\n\n';


			var new_log = current_edit+old_log;

			$j('#log').val(new_log);

			console.log(new_log);


	}
}

});



});

Code: Select all

<?php
$curr_dir = dirname(__FILE__);
include("{$curr_dir}/defaultLang.php");
include("{$curr_dir}/language.php");
include("{$curr_dir}/lib.php");

$mi = getMemberInfo();
echo json_encode($mi['username']);
?>

Code: Select all

tiger_admin has changed table: Tablename and field: Field 1to: rrr at 2022/02/11 22:06:27



tiger_admin has changed table: Tablename and field: Field 1to:  at 2022/02/11 22:06:22



tiger_admin has changed table: Tablename and field: Field 1to: test at 2022/02/11 22:06:21



tiger_admin has changed table: Tablename and field: Field 1to: teste at 2022/02/11 22:06:16



tiger_admin has changed table: Tablename and field: Field 1to: hi at 2022/02/11 22:06:14

Code: Select all

function TABLENAME_after_insert($data, $memberInfo, &$args){
    $object = new \NAMESPACENAME\TABLENAME();
    return $object->afterInsert($data, $memberInfo, $args);
}
function TABLENAME_after_update($data, $memberInfo, &$args){
    $object = new \NAMESPACENAME\TABLENAME();
    return $object->afterUpdate($data, $memberInfo, $args);   
}
function TABLENAME_before_delete($selectedID, &$skipChecks, $memberInfo, &$args){
    $object = new \NAMESPACENAME\TABLENAME();
    return $object->softDelete('id', $selectedID, 'status_id', 3, $memberInfo, $args);
}