method getAllHistory documentation in bbn\Appui\History
function(string $table, int $start = 0, int $limit = 20, string $dir = NULL)
{
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);
$id_tab = $db->cfn('bbn_table', self::$table_uids, true);
$uid2 = $db->cfn('uid', self::$table, true);
$chrono = $db->cfn('tst', self::$table, true);
$order = $dir && (Str::changeCase($dir, 'lower') === 'asc') ? 'ASC' : 'DESC';
$sql = <<< MYSQL
SELECT DISTINCT($uid)
FROM $tab_uids
JOIN $tab
ON $uid = $uid2
WHERE $id_tab = ?
ORDER BY $chrono $order
LIMIT $start, $limit
MYSQL;
return $db->getColArray($sql, hex2bin($id_table));
}
return [];
}
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-2024
BBN Solutions
