Lines Matching refs:ack

279         $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, C.ack FROM assignments A
283                 ON A.page = C.page AND ( (C.user = ? AND C.ack > B.lastmod) )
287             $sql .= ' AND ack IS NULL';
423         $sql = "SELECT ack
428                    AND A.ack >= B.lastmod";
445         $sql = "SELECT MAX(ack)
462         $sql = "INSERT INTO acks (page, user, ack) VALUES (?,?, strftime('%s','now'))";
483         $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, MAX(C.ack) AS ack
499      * Get ack status for all assigned users of a given page
531         $sql = "SELECT A.page, A.lastmod, B.user, MAX(B.ack) AS ack
553             'ack' => null,
558         foreach ($acknowledgements as $ack) {
559             if ($ack['user'] !== null) {
560                 $combined[$ack['user']] = $ack;
574                 return $info['ack'] < $info['lastmod'];
591             SELECT A.page, A.user, B.lastmod, max(A.ack) AS ack
595           ORDER BY ack DESC
612                 $filterClause = " HAVING ack >= $alias.lastmod ";
615                 $filterClause = " HAVING (ack IS NULL) OR (ack < $alias.lastmod) ";
618                 $filterClause = " HAVING ack < $alias.lastmod ";