method getLastModifiedLines documentation in bbn\Db\History
function(string $table, int $start = 0, int $limit = 20)
{
$r = [];
if ($id_table = $this->database_obj->tableId($table, $this->db->getCurrent())) {
$tab = $this->db->escape($this->getHistoryTableName());
$tab_uids = $this->db->escape($this->getHistoryUidsTableName());
$uid = $this->db->cfn($this->getHistoryUidsColumnName('bbn_uid'), $this->getHistoryUidsTableName(), true);
$active = $this->db->cfn($this->getHistoryUidsColumnName('bbn_active'), $this->getHistoryUidsTableName(), true);
$id_tab = $this->db->cfn($this->getHistoryUidsColumnName('bbn_table'), $this->getHistoryUidsTableName(), true);
$line = $this->db->escape($this->getHistoryTableColumnName('uid'));
$chrono = $this->db->escape($this->getHistoryTableColumnName('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 = $this->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
