X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=plugins%2FCustomFields.class.php;h=d9762b58d0487a0efb95a69afbb0c269dba91a03;hb=8bc57bab34ec45117348070eec17fb3d00f327fd;hp=a2e88326948cbd3689f2cccf0b635f34b2b99875;hpb=95d031241d1e1970e92171e733c81896b53f7cdc;p=timetracker.git diff --git a/plugins/CustomFields.class.php b/plugins/CustomFields.class.php index a2e88326..d9762b58 100644 --- a/plugins/CustomFields.class.php +++ b/plugins/CustomFields.class.php @@ -37,11 +37,16 @@ class CustomFields { var $options = array(); // Array of options for a dropdown custom field. // Constructor. - function __construct($group_id) { + function __construct() { + global $user; $mdb2 = getConnection(); + $group_id = $user->getGroup(); + $org_id = $user->org_id; + // Get fields. - $sql = "select id, type, label, required from tt_custom_fields where group_id = $group_id and status = 1 and type > 0"; + $sql = "select id, type, label, required from tt_custom_fields". + " where group_id = $group_id and org_id = $org_id and status = 1 and type > 0"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { @@ -52,7 +57,8 @@ class CustomFields { // If we have a dropdown obtain options for it. if ((count($this->fields) > 0) && ($this->fields[0]['type'] == CustomFields::TYPE_DROPDOWN)) { - $sql = "select id, value from tt_custom_field_options where field_id = ".$this->fields[0]['id']." and status = 1 order by value"; + $sql = "select id, value from tt_custom_field_options". + " where field_id = ".$this->fields[0]['id']." and group_id = $group_id and org_id = $org_id and status = 1 order by value"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { @@ -221,7 +227,7 @@ class CustomFields { $org_id = $user->org_id; $sql = "select value from tt_custom_field_options". - " where id = $id and group_id = $group_id and org_id = $org_id"; + " where id = $id and group_id = $group_id and org_id = $org_id and status = 1"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow();