nuBuilder Forum

Code: Select all

sri_creator

Code: Select all

sri_created

Code: Select all

sri_updater

Code: Select all

sri_updated

Code: Select all

// for temporary storage who updated
$rid = '#RECORD_ID#';
if ($rid != - 1) {
    $table = "calculation"; // table name
    $on = "cal_updated_on"; //updated on
    $by = "cal_updated_by"; //updated by
    $q = nuProcedure('CheckEditStatus');
    eval($q);
    unset($q);
}
unset($rid);

Code: Select all

$id = $table . "_id"; //record ID field name
$s = nuHash();
// on the form clone the field *_updated_by na *_updated_by_temp
$r = $s["record_id"];
$uon2 = $s[$on]; // from the form - status as at record opening.
$uby2 = $s[$by . "_temp"]; // from the form - status as at record opening.
$t = "SELECT " . $on . ',' . $by . " FROM " . $table . " WHERE " . $id . "=" . '"' . $r . '"';
$x = nuRunQuery($t);
$y = db_fetch_object($x);
$uon1 = $y->$on; // from the DB - current status just before saving.
$uby1 = $y->$by; // from the DB - current status just before saving.
$m_nok = "You can not save!!! This record was updated in the meantime by:<br>
         " . $uby1 . "  at  " . $uon1 . "<br>
         You can copy your data to Notepad for example for temporary storage.<br>
         Now you must leave this record without saving. After You can open it again and check the content.";

$on = ($uon1 == $uon2) ? 'OK' : nuDisplayError($m_nok);


if ($on == 'OK') {
    $by = ($uby1 == $uby2) ? 'OK' : nuDisplayError($m_nok);
}

unset($table, $on, $by, $id, $s, $r, $uon2, $uby2, $t, $x, $y, $uon1, $uby1, $m_nok, $on, $by);

Code: Select all

function nuBeforeSave() {
	$('#cal_updated_by_temp').val($('#cal_updated_by').val()).change(); //temporary field to store last user who modified that record
	$('#cal_updated_by').val(getUser()).change();
}

function getUser() {
   var user = nuUserName();
   if (user === '') { user = "admin";}
   return user;
}

Code: Select all

Uncaught ReferenceError: getUser is not defined
    at nuBeforeSave (<anonymous>:5:24)
    at nuUpdateData (nuajax.js?ts=20210701130651:671)
    at nuSaveAction (nuform.js?ts=20210701130651:3614)
    at HTMLInputElement.onclick (index.php)

Code: Select all

if(! nuHasNoRecordID()){
    
    $tLog = tLogData();
    $tTime = $tLog[1];
    $tUser = $tLog[2];    

    $cLog = cLogData($tLog[0]);
    $pTime = $cLog[0];

    if ($pTime !== $tTime) {
        nuDisplayError("Saving not possible. This record has been modified by <b>$tUser</b> in the meantime.");
    }

}

// Get current nulog data
function cLogData($log) {
    $jd = json_decode(stripslashes(nuHash()[$log]));
    $edited = isset($jd->edited);
    return array($edited ? $jd->edited->time : '', $edited ? $jd->edited->user : '');
}

// Get table nulog data
function tLogData() {
    $fd = nuHash()['nuFORMdata'][0];
    $r = nuRunQuery("SELECT `".$fd->table."_nulog"."` FROM ".$fd->table." WHERE ".$fd->primary_key." = ?", array("#RECORD_ID#"));
    $o = db_fetch_row($r);
    $jd = json_decode($o[0]);

    $edited = isset($jd->edited);
    $userName = '';
    if ($edited) {
       $r = nuRunQuery("SELECT `sus_name` FROM `zzzzsys_user` WHERE `zzzzsys_user_id` =  ?", array($jd->edited->user));
       $userName = db_num_rows($r) == 1 ? db_fetch_row($r)[0] : 'admin';
    }
    
    return array($fd->table."_nulog", $edited ? $jd->edited->time : '', $edited ? $userName : '');
}