Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.
 All Data Structures Functions Variables Pages
GamificationUtil.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 
41  {
51  public static function logAndNotifyOnDuplicateGameModel($logContent)
52  {
53  assert('is_string($logContent)');
54  $logContent .= "\n Use developer tools 'Repair Gamification' to resolve";
55  Yii::log($logContent, CLogger::LEVEL_WARNING);
56  $message = new NotificationMessage();
57  $message->textContent = Zurmo::t('GamificationModule', "Run 'Repair Gamification' under developer tools");
59  NotificationsUtil::submit($message, $rules);
60  }
61 
62  public static function findGameTableRowsThatAreDuplicatedByTypePersonKey($tableName)
63  {
64  assert('is_string($tableName)');
65  // Begin Not Coding Standard
66  $sql = "SELECT count(*) as count, person_item_id, type, CONCAT(type, '_', person_item_id) as unique_column " .
67  "FROM `".$tableName."` " .
68  "GROUP BY CONCAT(type, '_', person_item_id) having count(CONCAT(type, '_', person_item_id)) > 1";
69  // End Not Coding Standard
70  return ZurmoRedBean::getAll($sql);
71  }
72 
73  public static function findGameTableRowsThatAreDuplicatedByPersonKey($tableName)
74  {
75  assert('is_string($tableName)');
76  // Begin Not Coding Standard
77  $sql = "SELECT count(*) as count, person_item_id " .
78  "FROM `".$tableName."` " .
79  "GROUP BY person_item_id having count(person_item_id) > 1";
80  // End Not Coding Standard
81  return ZurmoRedBean::getAll($sql);
82  }
83 
84  public static function removeDuplicatesByModels(array $models, & $messageContent)
85  {
86  assert('is_string($messageContent) || $messageContent === null');
87  $modelToKeep = $models[0];
88  $maxValue = 0;
89  foreach ($models as $model)
90  {
91  if (get_class($model) == 'GameCollection' || ($model->value > $maxValue))
92  {
93  $modelToKeep = $model;
94  if (get_class($model) != 'GameCollection')
95  {
96  $maxValue = $model->value;
97  }
98  }
99  }
100  foreach ($models as $model)
101  {
102  if ($model->id != $modelToKeep->id)
103  {
104  $messageContent .= 'Deleting model: ' . get_class($model) . ' with id ' . $model->id . "<BR>";
105  $model->delete();
106  }
107  }
108  }
109  }
110 ?>
static logAndNotifyOnDuplicateGameModel($logContent)
static submit(NotificationMessage $message, NotificationRules $rules)
Generated on Thu Aug 6 2020 07:10:31
Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.