Lines Matching refs:status

69      * @param string $status
72     public function addPattern($pattern, $user, $status)
75         $sql = 'REPLACE INTO structpublish_assignments_patterns (pattern, user, status) VALUES (?,?,?)';
76         $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
107      * @param string $status
110     public function removePattern($pattern, $user, $status)
113         $sql = 'DELETE FROM structpublish_assignments_patterns WHERE pattern = ? AND user = ? AND status = ?';
114         $ok = (bool) $this->sqlite->query($sql, [$pattern, $user, $status]);
120         $sql = 'SELECT pid FROM structpublish_assignments WHERE user = ? AND status = ?';
121         $pagerows = $this->sqlite->queryAll($sql, [$user, $status]);
126             $ok = $ok && $this->deassignPage($row['pid'], $user, $status);
144         foreach ($rules as $status => $users) {
146                 $this->assignPage($pid, $user, $status);
184      * @param string $status
187     public function assignPage($page, $user = null, $status = null)
189         $sql = 'REPLACE INTO structpublish_assignments (pid, user, status, assigned) VALUES (?, ?, ?, 1)';
190         return (bool) $this->sqlite->query($sql, [$page, $user, $status]);
200     public function deassignPage($page, $user, $status)
202         $sql = 'UPDATE structpublish_assignments SET assigned = 0 WHERE pid = ? AND user = ? AND status = ?';
203         return (bool) $this->sqlite->query($sql, [$page, $user, $status]);
217      * Returns a list of user/group string lists per status assigned to the given page
234                     $rules[$row['status']][] = $row['user'];
239             $sql = 'SELECT user, status FROM structpublish_assignments WHERE pid = ? AND assigned = 1';
242                 $rules[$row['status']][] = $row['user'];
257         $sql = 'SELECT pid, user, status, assigned FROM structpublish_assignments WHERE 1=1';
265         $sql .= ' ORDER BY pid, user, status';
273             $status = $row['status'];
277             $result[$pid][$user][$status] = (bool) $row['assigned'];