Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.
 All Data Structures Functions Variables Pages
ZurmoRedBeanPluginQueryLogger.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 
37  class ZurmoRedBeanPluginQueryLogger extends RedBean_Plugin_QueryLogger
38  {
39  public static function getInstanceAndAttach( RedBean_Observable $adapter )
40  {
41  $queryLog = new ZurmoRedBeanPluginQueryLogger;
42  $adapter->addEventListener( "sql_exec", $queryLog );
43  return $queryLog;
44  }
45 
46  private function __construct()
47  {
48  }
49 
50  /*
51  public function onEvent( $eventName, $adapter )
52  {
53  if ($eventName == "sql_exec")
54  {
55  $sql = $adapter->getSQL();
56  $this->logs[] = $sql;
57  }
58  }
59  */
60 
61  public function getQueriesCount()
62  {
63  return count($this->getLogs());
64  }
65 
66  public function getDuplicateQueriesCount()
67  {
68  $existingLogs = array();
69  $duplicateCount = 0;
70  foreach ($this->getLogs() as $log)
71  {
72  if (in_array($log, $existingLogs))
73  {
74  $duplicateCount++;
75  }
76  else
77  {
78  $existingLogs[] = $log;
79  }
80  }
81  return $duplicateCount;
82  }
83 
84  public function getDuplicateQueriesData()
85  {
86  $existingLogs = array();
87  $duplicateData = array();
88  foreach ($this->getLogs() as $log)
89  {
90  if (in_array($log, $existingLogs))
91  {
92  if (isset($duplicateData[$log]))
93  {
94  $duplicateData[$log]++;
95  }
96  else
97  {
98  $duplicateData[$log] = 1;
99  }
100  }
101  else
102  {
103  $existingLogs[] = $log;
104  }
105  }
106  return $duplicateData;
107  }
108  }
109 ?>
Generated on Wed Jul 8 2020 07:10:30
Account Suspended
Account Suspended
This Account has been suspended.
Contact your hosting provider for more information.