###START_AUTOCODE
/* the code below is auto generated do not remove the above tag */
- public $__table = 'Office'; // table name
+ public $__table = 'core_office'; // table name
public $id; // int(11) not_null primary_key auto_increment
public $company_id; // int(11) not_null
public $name; // string(64) not_null
+++ /dev/null
-
-DROP FUNCTION IF EXISTS person_get_action_type;
-
-DELIMITER $$
-CREATE FUNCTION person_get_action_type(in_id INT(11)) RETURNS VARCHAR(32) DETERMINISTIC
- BEGIN
-
- DECLARE v_ret VARCHAR(32);
- SET v_ret= '';
- SELECT action_type INTO v_ret FROM Person WHERE id = in_id LIMIT 1;
- RETURN v_ret;
- END $$
-DELIMITER ;
+++ /dev/null
-
-DROP FUNCTION IF EXISTS person_get_by_email;
-
-DELIMITER $$
-CREATE FUNCTION person_get_by_email(
- in_addr VARCHAR(254)
-
-
- ) RETURNS INT(11) DETERMINISTIC
- BEGIN
-
- DECLARE v_id INT(11);
- SET v_id = 0;
- SELECT id INTO v_id FROM Person WHERE email = in_addr LIMIT 1;
- RETURN v_id;
-
- END $$
-DELIMITER ;
+++ /dev/null
-
-DROP FUNCTION IF EXISTS person_get_company;
-
-DELIMITER $$
-CREATE FUNCTION person_get_company(
- in_id INT(11)
- ) RETURNS INT(11) DETERMINISTIC
- BEGIN
-
- DECLARE v_id INT(11);
- SET v_id = 0;
- SELECT company_id INTO v_id FROM Person WHERE id = in_id LIMIT 1;
- RETURN v_id;
- END $$
-DELIMITER ;
+++ /dev/null
-
-DROP FUNCTION IF EXISTS person_get_internal_id;
-
-DELIMITER $$
-CREATE FUNCTION person_get_internal_id(
- in_addr VARCHAR(254)
-
-
- ) RETURNS INT(11) DETERMINISTIC
- BEGIN
-
- DECLARE v_id INT(11);
- DECLARE v_company_id INT(11);
- SET v_id = 0;
- SET v_company_id = 0;
-
- SELECT company_get_owner() INTO v_company_id;
- IF v_company_id < 1 THEN
- RETURN 0;
- END IF;
-
- SELECT id INTO v_id FROM Person WHERE
- company_id = v_company_id
- AND email = in_addr LIMIT 1;
-
- RETURN v_id;
-
-
-
-
- END $$
-DELIMITER ;
+++ /dev/null
-
-
-DROP FUNCTION IF EXISTS person_get_name;
-
-DELIMITER $$
-CREATE FUNCTION person_get_name(in_id INT(11)) RETURNS VARCHAR(254) DETERMINISTIC
- BEGIN
-
- DECLARE v_ret VARCHAR(254);
- SET v_ret= '';
- SELECT name INTO v_ret FROM Person WHERE id = in_id LIMIT 1;
- RETURN v_ret;
- END $$
-DELIMITER ;
\ No newline at end of file
+++ /dev/null
-
-
-DROP FUNCTION IF EXISTS person_get_project_id;
-
-DELIMITER $$
-CREATE FUNCTION person_get_project_id(
- in_id INT(11)
- ) RETURNS INT(11) DETERMINISTIC
- BEGIN
-
- DECLARE v_id INT(11);
- SET v_id = 0;
- SELECT project_id INTO v_id FROM Person WHERE id = in_id LIMIT 1;
- RETURN v_id;
- END $$
-
-
-DELIMITER ;
+++ /dev/null
-
-
-
-DROP FUNCTION IF EXISTS person_has_perm;
-
-DELIMITER $$
-CREATE FUNCTION person_has_perm(
- in_person_id INT(11),
- in_perm_name VARCHAR(64),
- in_perm_level VARCHAR(1)
- ) RETURNS INT(11) DETERMINISTIC
- BEGIN
-
- DECLARE v_id INT(11);
- SET v_id = 0;
- SELECT
- group_members.id INTO v_id
- FROM
- group_rights
- LEFT JOIN
- group_members
- ON
- group_rights.group_id = group_members.group_id
- WHERE
- group_rights.rightname= in_perm_name AND
- accessmask LIKE CONCAT('%', in_perm_level, '%') AND user_id = in_person_id LIMIT 1;
-
- RETURN v_id;
- END $$
-DELIMITER ;
+++ /dev/null
-
-DROP FUNCTION IF EXISTS project_get_type;
-DELIMITER $$
-CREATE FUNCTION project_get_type(in_id INT(11)) RETURNS VARCHAR(2) DETERMINISTIC
- BEGIN
- DECLARE v_ret VARCHAR(2);
- SET v_ret= '';
- SELECT type INTO v_ret FROM Projects WHERE id = in_id LIMIT 1;
- RETURN v_ret;
- END $$
-DELIMITER ;
\ No newline at end of file