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 && (bbn\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.