All Data Structures Functions Variables Pages
OpportunitiesByStageChartDataProvider.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  {
42  protected $model;
43 
44  public function __construct()
45  {
46  $this->model = new Opportunity(false);
47  }
48 
49  public function getXAxisName()
50  {
51  return $this->model->getAttributeLabel('stage');
52  }
53 
54  public function getYAxisName()
55  {
56  return $this->model->getAttributeLabel('amount');
57  }
58 
59  public function getChartData()
60  {
61  $customFieldData = CustomFieldDataModelUtil::
62  getDataByModelClassNameAndAttributeName('Opportunity', 'stage');
63  $labels = CustomFieldDataUtil::
64  getDataIndexedByDataAndTranslatedLabelsByLanguage($customFieldData, Yii::app()->language);
65  $sql = static::makeChartSqlQuery();
66  $rows = ZurmoRedBean::getAll($sql);
67  $chartData = array();
68  foreach ($rows as $row)
69  {
70  $chartData[] = array(
71  'value' => $this->resolveCurrencyValueConversionRateForCurrentUserForDisplay($row['amount']),
72  'displayLabel' => static::resolveLabelByValueAndLabels($row['stage'], $labels),
73  );
74  }
75  return $chartData;
76  }
77 
78  protected static function makeChartSqlQuery()
79  {
81  $where = null;
82  $selectDistinct = false;
83  $joinTablesAdapter = new RedBeanModelJoinTablesQueryAdapter('Opportunity');
85  $joinTablesAdapter,
86  $where,
87  $selectDistinct);
88  $selectQueryAdapter = new RedBeanModelSelectQueryAdapter($selectDistinct);
89  $sumPart = "{$quote}currencyvalue{$quote}.{$quote}value{$quote} ";
90  $sumPart .= "* {$quote}currencyvalue{$quote}.{$quote}ratetobase{$quote}";
91  $selectQueryAdapter->addClause('customfield', 'value', 'stage');
92  $selectQueryAdapter->addClauseByQueryString("sum({$sumPart})", 'amount');
93  $joinTablesAdapter->addFromTableAndGetAliasName('customfield', 'stage_customfield_id', 'opportunity');
94  $joinTablesAdapter->addFromTableAndGetAliasName('currencyvalue', 'amount_currencyvalue_id', 'opportunity');
95  $groupBy = "{$quote}customfield{$quote}.{$quote}value{$quote}";
96  $sql = SQLQueryUtil::makeQuery('opportunity', $selectQueryAdapter,
97  $joinTablesAdapter, null, null, $where, null, $groupBy);
98  return $sql;
99  }
100  }
101 ?>
static getDataIndexedByDataAndTranslatedLabelsByLanguage(CustomFieldData $customFieldData, $language)
static resolveReadPermissionsOptimizationToSqlQuery(User $user, RedBeanModelJoinTablesQueryAdapter $joinTablesAdapter, &$where, &$selectDistinct)
resolveCurrencyValueConversionRateForCurrentUserForDisplay($valueInBaseCurrency)
static getDataByModelClassNameAndAttributeName($modelClassName, $attributeName)
Generated on Sat Feb 22 2020 07:10:32