method getNextUpdate documentation in bbn\Appui\History

function(string $table, string $id, $from_when, $column = NULL) { /** @todo To be redo totally with all the fields' IDs instead of the history column */ if ( bbn\Str::checkName($table) && ($date = self::validDate($from_when)) && ($db = self::_get_db()) && ($dbc = self::_get_database()) && ($id_table = $dbc->tableId($table)) ){ self::disable(); $tab = $db->escape(self::$table); $tab_uids = $db->escape(self::$table_uids); $uid = $db->cfn('bbn_uid', self::$table_uids); $id_tab = $db->cfn('bbn_table', self::$table_uids); $id_col = $db->cfn('col', self::$table); $line = $db->cfn('uid', self::$table); $usr = $db->cfn('usr', self::$table); $chrono = $db->cfn('tst', self::$table); $where = [ $uid => $id, $id_tab => $id_table, [$chrono, '>', $date] ]; if ( $column ){ $where[$id_col] = bbn\Str::isUid($column) ? $column : $dbc->columnId($column, $id_table); } else { $w = self::_get_table_where($table); //$where = $id_col." != UNHEX('$id_column') " . ($w ?: ''); } $res = $db->rselect([ 'tables' => [$tab_uids], 'fields' => [ $line, $id_col, $chrono, 'val' => 'IFNULL(val, ref)', $usr ], 'join' => [[ 'table' => $tab, 'on' => [ 'logic' => 'AND', 'conditions' => [[ 'field' => $uid, 'operator' => '=', 'exp' => $line ]] ]] ], 'where' => $where, 'order' => [$chrono => 'ASC'] ]); self::enable(); return $res; } return null; }

BBN is a suite of PHP and JS libraries and VueJS components - all open-source! bbn.io, build applications, the quick way

This website uses cookies to ensure you get the best experience on our website.