Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.
 All Data Structures Functions Variables Pages
CustomField.php
1 <?php
2  /*********************************************************************************
3  * Zurmo is a customer relationship management program developed by
4  * Zurmo, Inc. Copyright (C) 2017 Zurmo Inc.
5  *
6  * Zurmo is free software; you can redistribute it and/or modify it under
7  * the terms of the GNU Affero General Public License version 3 as published by the
8  * Free Software Foundation with the addition of the following permission added
9  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
10  * IN WHICH THE COPYRIGHT IS OWNED BY ZURMO, ZURMO DISCLAIMS THE WARRANTY
11  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
12  *
13  * Zurmo is distributed in the hope that it will be useful, but WITHOUT
14  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
15  * FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
16  * details.
17  *
18  * You should have received a copy of the GNU Affero General Public License along with
19  * this program; if not, see http://www.gnu.org/licenses or write to the Free
20  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
21  * 02110-1301 USA.
22  *
23  * You can contact Zurmo, Inc. with a mailing address at 27 North Wacker Drive
24  * Suite 370 Chicago, IL 60606. or at email address contact@zurmo.com.
25  *
26  * The interactive user interfaces in original and modified versions
27  * of this program must display Appropriate Legal Notices, as required under
28  * Section 5 of the GNU Affero General Public License version 3.
29  *
30  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
31  * these Appropriate Legal Notices must retain the display of the Zurmo
32  * logo and Zurmo copyright notice. If the display of the logo is not reasonably
33  * feasible for technical reasons, the Appropriate Legal Notices must display the words
34  * "Copyright Zurmo Inc. 2017. All rights reserved".
35  ********************************************************************************/
36 
38  {
39  public function __toString()
40  {
41  $s = strval($this->value);
42  if ($s == '')
43  {
44  return Zurmo::t('Core', '(None)');
45  }
46  return $s;
47  }
48 
49  public static function getDefaultMetadata()
50  {
51  $metadata = parent::getDefaultMetadata();
52  $metadata[__CLASS__] = array(
53  'members' => array(
54  'value',
55  ),
56  'relations' => array(
57  ),
58  'rules' => array(
59  array('value', 'type', 'type' => 'string'),
60  ),
61  'defaultSortAttribute' => 'value'
62  );
63  return $metadata;
64  }
65 
66  public static function updateValueByDataIdAndOldValueAndNewValue($customFieldDataId, $oldValue, $newValue)
67  {
69  $customFieldTableName = CustomField::getTableName();
70  $baseCustomFieldTableName = BaseCustomField::getTableName();
71  $baseCustomFieldJoinColumnName = $baseCustomFieldTableName . '_id';
72  $valueAttributeColumnName = 'value';
73  $dataAttributeColumnName = static::getForeignKeyName('BaseCustomField', 'data');
74  $sql = "update {$quote}{$customFieldTableName}{$quote}, {$quote}{$baseCustomFieldTableName}{$quote} ";
75  $sql .= "set {$quote}{$valueAttributeColumnName}{$quote} = '{$newValue}' ";
76  $sql .= "where {$quote}{$customFieldTableName}{$quote}.$baseCustomFieldJoinColumnName = "; // Not Coding Standard
77  $sql .= "{$quote}{$baseCustomFieldTableName}{$quote}.id ";
78  $sql .= "AND {$quote}{$dataAttributeColumnName}{$quote} = $customFieldDataId ";
79  $sql .= "AND {$quote}{$valueAttributeColumnName}{$quote} = '{$oldValue}'";
80  ZurmoRedBean::exec($sql);
81  }
82  }
83 ?>
static getTableName()
Generated on Wed Dec 2 2020 07:10:23
Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.