method getLastModifiedLines documentation in bbn\Appui\History
function(string $table, int $start = 0, int $limit = 20)
{
$r = [];
if (
($db = self::_get_db()) &&
($dbc = self::_get_database()) &&
($id_table = $dbc->tableId($table, self::$db->getCurrent()))
){
$tab = $db->escape(self::$table);
$tab_uids = $db->escape(self::$table_uids);
$uid = $db->cfn('bbn_uid', self::$table_uids, true);
$active = $db->cfn(self::$column, self::$table_uids, true);
$id_tab = $db->cfn('bbn_table', self::$table_uids, true);
$line = $db->escape('uid', self::$table);
$chrono = $db->escape('tst');
$sql = <<< MYSQL
SELECT DISTINCT($line)
FROM $tab_uids
JOIN $tab
ON $uid = $line
WHERE $id_tab = ?
AND $active = 1
ORDER BY $chrono
LIMIT $start, $limit
MYSQL;
$r = $db->getColArray($sql, hex2bin($id_table));
}
return $r;
}
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.
© 2011-2023
BBN Solutions
