Lines Matching refs:user
59 * @param string $user
65 public function auth_isMember($memberList, $user, $groups)
67 return auth_isMember($memberList, $user, explode('///', $groups));
250 * Is the given user one of the assignees for this page
253 * @param string $user user name to check
254 * @param string[] $groups groups this user is in
257 public function isUserAssigned($page, $user, $groups)
263 return auth_isMember($assignees, $user, $groups);
267 * Fetch all assignments for a given user, with additional page information,
271 * @param string $user
277 public function getUserAssignments($user, $groups, $includeDone = false)
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) )
290 return $this->db->queryAll($sql, $user, $user, implode('///', $groups));
296 * This can be slow on huge user bases!
415 * Has the given user acknowledged the given page?
418 * @param string $user
421 public function hasUserAcknowledged($page, $user)
427 AND A.user = ?
430 $acktime = $this->db->queryValue($sql, $page, $user);
437 * by the given user
440 * @param string $user
443 public function getLatestUserAcknowledgement($page, $user)
448 AND user = ?";
450 return $this->db->queryValue($sql, [$page, $user]);
454 * Save user's acknowledgement for a given page
457 * @param string $user
460 public function saveAcknowledgement($page, $user)
462 $sql = "INSERT INTO acks (page, user, ack) VALUES (?,?, strftime('%s','now'))";
464 $this->db->exec($sql, $page, $user);
469 * Get all pages that a user needs to acknowledge and/or the last acknowledgement infos
472 * @param string $user
478 public function getUserAcknowledgements($user, $groups, $status = '')
483 $sql = "SELECT A.page, A.pageassignees, A.autoassignees, B.lastmod, C.user, MAX(C.ack) AS ack
488 ON A.page = C.page AND C.user = ?
495 return $this->db->queryAll($sql, [$user, $user, implode('///', $groups)]);
504 * @param string $user
510 public function getPageAcknowledgements($page, $user = '', $status = '', $max = 0)
516 // filtering for user from input or using saved assignees?
517 if ($user) {
518 $users = [$user];
519 $userClause = ' AND (B.user = ? OR B.user IS NULL) ';
520 $params[] = $user;
531 $sql = "SELECT A.page, A.lastmod, B.user, MAX(B.ack) AS ack
535 AND B.user IN ($ulist)
537 $sql .= " GROUP BY A.page, B.user ";
552 'user' => null,
559 if ($ack['user'] !== null) {
560 $combined[$ack['user']] = $ack;
563 foreach ($users as $user) {
564 if (!isset($combined[$user])) {
565 $combined[$user] = array_merge($baseinfo, ['user' => $user]);
591 SELECT A.page, A.user, B.lastmod, max(A.ack) AS ack
594 GROUP BY A.user, A.page