From 4c604b5ccea2fabc586adaa6c5b8c0fde601255c Mon Sep 17 00:00:00 2001 From: anuko Date: Mon, 24 Oct 2016 11:11:24 +0000 Subject: [PATCH] Fixing white space. --- plugins/CustomFields.class.php | 284 ++++++++++++++++----------------- 1 file changed, 139 insertions(+), 145 deletions(-) diff --git a/plugins/CustomFields.class.php b/plugins/CustomFields.class.php index ddd1c4d1..f9592f1c 100644 --- a/plugins/CustomFields.class.php +++ b/plugins/CustomFields.class.php @@ -35,23 +35,23 @@ class CustomFields { var $fields = array(); // Array of custom fields for team. var $options = array(); // Array of options for a dropdown custom field. - + // Constructor. function __construct($team_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"; + $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"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { $this->fields[] = array('id'=>$val['id'],'type'=>$val['type'],'label'=>$val['label'],'required'=>$val['required'],'value'=>''); } } - + // 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']." order by value"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { @@ -61,47 +61,47 @@ class CustomFields { } } } - + function insert($log_id, $field_id, $option_id, $value) { - - $mdb2 = getConnection(); + + $mdb2 = getConnection(); $sql = "insert into tt_custom_field_log (log_id, field_id, option_id, value) values($log_id, $field_id, ".$mdb2->quote($option_id).", ".$mdb2->quote($value).")"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } function update($log_id, $field_id, $option_id, $value) { - if (!$field_id) - return true; // Nothing to update. - - // Remove older custom field values, if any. - $res = $this->delete($log_id); - if (!$res) - return false; - - if (!$value && !$option_id) - return true; // Do not insert NULL values. - + if (!$field_id) + return true; // Nothing to update. + + // Remove older custom field values, if any. + $res = $this->delete($log_id); + if (!$res) + return false; + + if (!$value && !$option_id) + return true; // Do not insert NULL values. + return $this->insert($log_id, $field_id, $option_id, $value); } - + function delete($log_id) { - - $mdb2 = getConnection(); + + $mdb2 = getConnection(); $sql = "update tt_custom_field_log set status = NULL where log_id = $log_id"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } - + function get($log_id) { - $fields = array(); - - $mdb2 = getConnection(); + $fields = array(); + + $mdb2 = getConnection(); $sql = "select id, field_id, option_id, value from tt_custom_field_log where log_id = $log_id and status = 1"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { - $fields[] = $val; + $fields[] = $val; } return $fields; } @@ -110,80 +110,80 @@ class CustomFields { // insertOption adds a new option to a custom field. static function insertOption($field_id, $option_name) { - - $mdb2 = getConnection(); - - // Check if the option exists. - $id = 0; - $sql = "select id from tt_custom_field_options where field_id = $field_id and value = ".$mdb2->quote($option_name); - $res = $mdb2->query($sql); - if (is_a($res, 'PEAR_Error')) - return false; + + $mdb2 = getConnection(); + + // Check if the option exists. + $id = 0; + $sql = "select id from tt_custom_field_options where field_id = $field_id and value = ".$mdb2->quote($option_name); + $res = $mdb2->query($sql); + if (is_a($res, 'PEAR_Error')) + return false; if ($val = $res->fetchRow()) $id = $val['id']; - + // Insert option. if (!$id) { $sql = "insert into tt_custom_field_options (field_id, value) values($field_id, ".$mdb2->quote($option_name).")"; $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) - return false; + return false; } return true; } - + // updateOption updates option name. static function updateOption($id, $option_name) { - + $mdb2 = getConnection(); - + $sql = "update tt_custom_field_options set value = ".$mdb2->quote($option_name)." where id = $id"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } - + // delete Option deletes an option and all custom field log entries that used it. static function deleteOption($id) { - global $user; - $mdb2 = getConnection(); - - $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"; - $res = $mdb2->query($sql); - if (is_a($res, 'PEAR_Error')) - return false; - $val = $res->fetchRow(); - if ($user->team_id != $val['team_id']) - return false; - + global $user; + $mdb2 = getConnection(); + + $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"; + $res = $mdb2->query($sql); + if (is_a($res, 'PEAR_Error')) + return false; + $val = $res->fetchRow(); + if ($user->team_id != $val['team_id']) + return false; + // Delete log entries with this option. $sql = "update tt_custom_field_log set status = NULL where field_id = $field_id and value = ".$mdb2->quote($id); $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) - return false; - - // Delete the option. - $sql = "delete from tt_custom_field_options where id = $id"; - $affected = $mdb2->exec($sql); + return false; + + // Delete the option. + $sql = "delete from tt_custom_field_options where id = $id"; + $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } - + // getOptions returns an array of options for a custom field. static function getOptions($field_id) { - global $user; - $mdb2 = getConnection(); - $options = array(); - - // First make sure that the field is ours. - $sql = "select team_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']) - return false; - + global $user; + $mdb2 = getConnection(); + $options = array(); + + // First make sure that the field is ours. + $sql = "select team_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']) + return false; + // Get options. $sql = "select id, value from tt_custom_field_options where field_id = $field_id order by value"; $res = $mdb2->query($sql); @@ -195,25 +195,25 @@ class CustomFields { } return false; } - - // getOptiondName returns an option name for a custom field. + + // getOptionName returns an option name for a custom field. static function getOptionName($id) { global $user; - $mdb2 = getConnection(); - - $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"; - $res = $mdb2->query($sql); - if (is_a($res, 'PEAR_Error')) - return false; - $val = $res->fetchRow(); - if ($user->team_id != $val['team_id']) - return false; - - // Get option name. - $sql = "select value from tt_custom_field_options where id = $id"; + $mdb2 = getConnection(); + + $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"; + $res = $mdb2->query($sql); + if (is_a($res, 'PEAR_Error')) + return false; + $val = $res->fetchRow(); + if ($user->team_id != $val['team_id']) + return false; + + // Get option name. + $sql = "select value from tt_custom_field_options where id = $id"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); @@ -222,14 +222,14 @@ class CustomFields { } return false; } - + // getFields returns an array of custom fields for team. static function getFields() { - global $user; - $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"; + global $user; + $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"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { @@ -242,10 +242,10 @@ class CustomFields { // getField returns a custom field. static function getField($id) { - global $user; - $mdb2 = getConnection(); - - $sql = "select label, type, required from tt_custom_fields where id = $id and team_id = $user->team_id"; + global $user; + $mdb2 = getConnection(); + + $sql = "select label, type, required from tt_custom_fields where id = $id and team_id = $user->team_id"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); @@ -255,12 +255,12 @@ class CustomFields { } return false; } - + // getFieldIdForOption returns field id from an associated option id. static function getFieldIdForOption($option_id) { - $mdb2 = getConnection(); - - $sql = "select field_id from tt_custom_field_options where id = $option_id"; + $mdb2 = getConnection(); + + $sql = "select field_id from tt_custom_field_options where id = $option_id"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); @@ -269,14 +269,11 @@ class CustomFields { } return false; } - + // The insertField inserts a custom field for team. static function insertField($field_name, $field_type, $required) { - - global $user; - - $mdb2 = getConnection(); - + 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)"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); @@ -284,49 +281,46 @@ class CustomFields { // The updateField updates custom field for team. static function updateField($id, $name, $type, $required) { - - global $user; - - $mdb2 = getConnection(); - + 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"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } - + // The deleteField deletes a custom field, its options and log entries for team. static function deleteField($field_id) { - - // Our overall intention is to keep the code simple and manageable. - // If a users wishes to delete a field, we will delete all its options and log entries. - // Otherwise we have to do conditional queries depending on field status (this complicates things). - - global $user; - $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"; - $res = $mdb2->query($sql); - if (is_a($res, 'PEAR_Error')) - return false; - $val = $res->fetchRow(); - if ($user->team_id != $val['team_id']) - return false; - - // Mark log entries as deleted. - $sql = "update tt_custom_field_log set status = NULL where field_id = $field_id"; + + // Our overall intention is to keep the code simple and manageable. + // If a user wishes to delete a field, we will delete all its options and log entries. + // Otherwise we have to do conditional queries depending on field status (this complicates things). + + global $user; + $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"; + $res = $mdb2->query($sql); + if (is_a($res, 'PEAR_Error')) + return false; + $val = $res->fetchRow(); + if ($user->team_id != $val['team_id']) + return false; + + // Mark log entries as deleted. + $sql = "update tt_custom_field_log set status = NULL where field_id = $field_id"; $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) - return false; + return false; - // Delete field options. - $sql = "delete from tt_custom_field_options where field_id = $field_id"; + // Delete field options. + $sql = "delete from tt_custom_field_options where field_id = $field_id"; $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) - return false; + return false; - // Delete the field. - $sql = "delete from tt_custom_fields where id = $field_id and team_id = $user->team_id"; + // Delete the field. + $sql = "delete from tt_custom_fields where id = $field_id and team_id = $user->team_id"; $affected = $mdb2->exec($sql); return (!is_a($affected, 'PEAR_Error')); } -- 2.20.1