X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/timetracker.git/blobdiff_plain/82113b6a111dc3f716c71fb8fb55b11845cbd697..45c855269d952873285f7a835e82fc2b3eff3971:/plugins/CustomFields.class.php diff --git a/plugins/CustomFields.class.php b/plugins/CustomFields.class.php index f9592f1c..afb59dae 100644 --- a/plugins/CustomFields.class.php +++ b/plugins/CustomFields.class.php @@ -37,11 +37,11 @@ class CustomFields { var $options = array(); // Array of options for a dropdown custom field. // Constructor. - function __construct($team_id) { + function __construct($group_id) { $mdb2 = getConnection(); // Get fields. - $sql = "select id, type, label, required from tt_custom_fields where team_id = $team_id and status = 1 and type > 0"; + $sql = "select id, type, label, required from tt_custom_fields where group_id = $group_id and status = 1 and type > 0"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { @@ -149,12 +149,12 @@ class CustomFields { $field_id = CustomFields::getFieldIdForOption($id); // First make sure that the field is ours. - $sql = "select team_id from tt_custom_fields where id = $field_id"; + $sql = "select group_id from tt_custom_fields where id = $field_id"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) return false; $val = $res->fetchRow(); - if ($user->team_id != $val['team_id']) + if ($user->group_id != $val['group_id']) return false; // Delete log entries with this option. @@ -176,12 +176,12 @@ class CustomFields { $options = array(); // First make sure that the field is ours. - $sql = "select team_id from tt_custom_fields where id = $field_id"; + $sql = "select group_id from tt_custom_fields where id = $field_id"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) return false; $val = $res->fetchRow(); - if ($user->team_id != $val['team_id']) + if ($user->group_id != $val['group_id']) return false; // Get options. @@ -204,12 +204,12 @@ class CustomFields { $field_id = CustomFields::getFieldIdForOption($id); // First make sure that the field is ours. - $sql = "select team_id from tt_custom_fields where id = $field_id"; + $sql = "select group_id from tt_custom_fields where id = $field_id"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) return false; $val = $res->fetchRow(); - if ($user->team_id != $val['team_id']) + if ($user->group_id != $val['group_id']) return false; // Get option name. @@ -229,7 +229,7 @@ class CustomFields { $mdb2 = getConnection(); $fields = array(); - $sql = "select id, type, label from tt_custom_fields where team_id = $user->team_id and status = 1 and type > 0"; + $sql = "select id, type, label from tt_custom_fields where group_id = $user->group_id and status = 1 and type > 0"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { @@ -245,7 +245,7 @@ class CustomFields { global $user; $mdb2 = getConnection(); - $sql = "select label, type, required from tt_custom_fields where id = $id and team_id = $user->team_id"; + $sql = "select label, type, required from tt_custom_fields where id = $id and group_id = $user->group_id"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); @@ -274,7 +274,7 @@ class CustomFields { static function insertField($field_name, $field_type, $required) { global $user; $mdb2 = getConnection(); - $sql = "insert into tt_custom_fields (team_id, type, label, required, status) values($user->team_id, $field_type, ".$mdb2->quote($field_name).", $required, 1)"; + $sql = "insert into tt_custom_fields (group_id, type, label, required, status) values($user->group_id, $field_type, ".$mdb2->quote($field_name).", $required, 1)"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } @@ -283,7 +283,7 @@ class CustomFields { static function updateField($id, $name, $type, $required) { global $user; $mdb2 = getConnection(); - $sql = "update tt_custom_fields set label = ".$mdb2->quote($name).", type = $type, required = $required where id = $id and team_id = $user->team_id"; + $sql = "update tt_custom_fields set label = ".$mdb2->quote($name).", type = $type, required = $required where id = $id and group_id = $user->group_id"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } @@ -299,12 +299,12 @@ class CustomFields { $mdb2 = getConnection(); // First make sure that the field is ours so that we can safely delete it. - $sql = "select team_id from tt_custom_fields where id = $field_id"; + $sql = "select group_id from tt_custom_fields where id = $field_id"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) return false; $val = $res->fetchRow(); - if ($user->team_id != $val['team_id']) + if ($user->group_id != $val['group_id']) return false; // Mark log entries as deleted. @@ -320,7 +320,7 @@ class CustomFields { return false; // Delete the field. - $sql = "delete from tt_custom_fields where id = $field_id and team_id = $user->team_id"; + $sql = "delete from tt_custom_fields where id = $field_id and group_id = $user->group_id"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); }