git.roojs.org Git - Pman.Core/blob - mysql/core_person_has_perm.sql

   1
   2
   3
   4 DROP FUNCTION IF EXISTS core_person_has_perm;
   5
   6 DELIMITER $$
   7 CREATE FUNCTION core_person_has_perm(
   8        in_person_id INT(11),
   9        in_perm_name VARCHAR(64),
  10        in_perm_level VARCHAR(1)
  11     )  RETURNS INT(11) DETERMINISTIC
  12     BEGIN
  13
  14         DECLARE v_id INT(11);
  15         SET v_id = 0;
  16         SELECT
  17                 core_group_member.id INTO v_id
  18             FROM
  19                 core_group_right
  20             LEFT JOIN
  21                 core_group_member
  22             ON
  23                 core_group_right.group_id = core_group_member.group_id
  24             WHERE
  25                 core_group_right.rightname= in_perm_name AND
  26                 accessmask LIKE CONCAT('%', in_perm_level, '%') AND user_id = in_person_id LIMIT 1;
  27
  28         RETURN v_id;
  29     END $$
  30 DELIMITER ;