PHP Report::getGroupBys方法代码示例

 /**
  * @param ReportWizardForm $formModel
  */
 protected function setCommonAttributes(ReportWizardForm $formModel)
 {
     $formModel->id = $this->report->getId();
     $formModel->description = $this->report->getDescription();
     $formModel->moduleClassName = $this->report->getModuleClassName();
     if ($this->report->getOwner()->id > 0) {
         $formModel->ownerId = (int) $this->report->getOwner()->id;
         $formModel->ownerName = strval($this->report->getOwner());
     }
     $formModel->name = $this->report->getName();
     $formModel->type = $this->report->getType();
     $formModel->filtersStructure = $this->report->getFiltersStructure();
     $formModel->currencyConversionType = $this->report->getCurrencyConversionType();
     $formModel->spotConversionCurrencyCode = $this->report->getSpotConversionCurrencyCode();
     if ($this->report->isNew()) {
         $formModel->setIsNew();
     }
     $formModel->setExplicitReadWriteModelPermissions($this->report->getExplicitReadWriteModelPermissions());
     $formModel->filters = $this->report->getFilters();
     $formModel->orderBys = $this->report->getOrderBys();
     $formModel->groupBys = $this->report->getGroupBys();
     $formModel->displayAttributes = $this->report->getDisplayAttributes();
     $formModel->drillDownDisplayAttributes = $this->report->getDrillDownDisplayAttributes();
     $formModel->chart = $this->report->getChart();
 }

 /**
  * @param ModelRelationsAndAttributesToReportAdapter $modelToReportAdapter
  * @param RedBeanModel $precedingModel
  * @param null|string $precedingRelation
  * @throws NotSupportedException if the treeType is invalid or null
  */
 protected function getAttributesData(ModelRelationsAndAttributesToReportAdapter $modelToReportAdapter, RedBeanModel $precedingModel = null, $precedingRelation = null)
 {
     if ($this->treeType == ComponentForReportForm::TYPE_FILTERS) {
         return $modelToReportAdapter->getAttributesForFilters();
     } elseif ($this->treeType == ComponentForReportForm::TYPE_DISPLAY_ATTRIBUTES) {
         return $modelToReportAdapter->getAttributesForDisplayAttributes($this->report->getGroupBys(), $precedingModel, $precedingRelation);
     } elseif ($this->treeType == ComponentForReportForm::TYPE_ORDER_BYS) {
         return $modelToReportAdapter->getAttributesForOrderBys($this->report->getGroupBys(), $this->report->getDisplayAttributes(), $precedingModel, $precedingRelation);
     } elseif ($this->treeType == ComponentForReportForm::TYPE_GROUP_BYS) {
         return $modelToReportAdapter->getAttributesForGroupBys($precedingModel, $precedingRelation);
     } elseif ($this->treeType == ComponentForReportForm::TYPE_DRILL_DOWN_DISPLAY_ATTRIBUTES) {
         return $modelToReportAdapter->getForDrillDownAttributes($precedingModel, $precedingRelation);
     } else {
         throw new NotSupportedException();
     }
 }

 /**
  * @return array
  */
 public function resolveGroupBys()
 {
     return $this->report->getGroupBys();
 }

 /**
  * @param array $data
  * @param Report $report
  */
 protected static function resolveChart($data, Report $report)
 {
     if ($report->getType() != Report::TYPE_SUMMATION) {
         return;
     }
     $moduleClassName = $report->getModuleClassName();
     if ($moduleClassName != null) {
         $modelClassName = $moduleClassName::getPrimaryModelName();
         $adapter = ModelRelationsAndAttributesToSummationReportAdapter::make($moduleClassName, $modelClassName, $report->getType());
         $seriesDataAndLabels = ReportUtil::makeDataAndLabelsForSeriesOrRange($adapter->getAttributesForChartSeries($report->getGroupBys(), $report->getDisplayAttributes()));
         $rangeDataAndLabels = ReportUtil::makeDataAndLabelsForSeriesOrRange($adapter->getAttributesForChartRange($report->getDisplayAttributes()));
     } else {
         $seriesDataAndLabels = array();
         $rangeDataAndLabels = array();
     }
     $chart = new ChartForReportForm($seriesDataAndLabels, $rangeDataAndLabels);
     if (null != ($chartData = ArrayUtil::getArrayValue($data, 'ChartForReportForm'))) {
         $chart->setAttributes($chartData);
     }
     $report->setChart($chart);
 }

 /**
  * @depends testGetAvailableAttributesForMatrixGroupBys
  */
 public function testGetAvailableAttributesForMatrixDisplayAttributes()
 {
     //Without any group by displayed, nothing is available
     $model = new ReportModelTestItem();
     $rules = new ReportsTestReportRules();
     $report = new Report();
     $report->setType(Report::TYPE_MATRIX);
     $report->setModuleClassName('ReportsTestModule');
     $adapter = new ModelRelationsAndAttributesToMatrixReportAdapter($model, $rules, $report->getType());
     $attributes = $adapter->getAttributesForDisplayAttributes($report->getGroupBys());
     $this->assertEquals(0, count($attributes));
     //Select dropDown as the groupBy attribute
     $groupBy = new GroupByForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $groupBy->attributeIndexOrDerivedType = 'dropDown';
     $report = new Report();
     $report->setType(Report::TYPE_MATRIX);
     $report->setModuleClassName('ReportsTestModule');
     $report->addGroupBy($groupBy);
     $adapter = new ModelRelationsAndAttributesToMatrixReportAdapter($model, $rules, $report->getType());
     $attributes = $adapter->getAttributesForDisplayAttributes($report->getGroupBys());
     $this->assertEquals(21, count($attributes));
     $compareData = array('label' => 'Count');
     $this->assertEquals($compareData, $attributes['Count']);
     $compareData = array('label' => 'Created Date Time -(Min)');
     $this->assertEquals($compareData, $attributes['createdDateTime__Minimum']);
     $compareData = array('label' => 'Created Date Time -(Max)');
     $this->assertEquals($compareData, $attributes['createdDateTime__Maximum']);
     $compareData = array('label' => 'Modified Date Time -(Min)');
     $this->assertEquals($compareData, $attributes['modifiedDateTime__Minimum']);
     $compareData = array('label' => 'Modified Date Time -(Max)');
     $this->assertEquals($compareData, $attributes['modifiedDateTime__Maximum']);
     $compareData = array('label' => 'Date -(Min)');
     $this->assertEquals($compareData, $attributes['date__Minimum']);
     $compareData = array('label' => 'Date -(Max)');
     $this->assertEquals($compareData, $attributes['date__Maximum']);
     $compareData = array('label' => 'Date Time -(Min)');
     $this->assertEquals($compareData, $attributes['dateTime__Minimum']);
     $compareData = array('label' => 'Date Time -(Max)');
     $this->assertEquals($compareData, $attributes['dateTime__Maximum']);
     $compareData = array('label' => 'Float -(Min)');
     $this->assertEquals($compareData, $attributes['float__Minimum']);
     $compareData = array('label' => 'Float -(Max)');
     $this->assertEquals($compareData, $attributes['float__Maximum']);
     $compareData = array('label' => 'Float -(Sum)');
     $this->assertEquals($compareData, $attributes['float__Summation']);
     $compareData = array('label' => 'Float -(Avg)');
     $this->assertEquals($compareData, $attributes['float__Average']);
     $compareData = array('label' => 'Integer -(Min)');
     $this->assertEquals($compareData, $attributes['integer__Minimum']);
     $compareData = array('label' => 'Integer -(Max)');
     $this->assertEquals($compareData, $attributes['integer__Maximum']);
     $compareData = array('label' => 'Integer -(Sum)');
     $this->assertEquals($compareData, $attributes['integer__Summation']);
     $compareData = array('label' => 'Integer -(Avg)');
     $this->assertEquals($compareData, $attributes['integer__Average']);
     $compareData = array('label' => 'Currency Value -(Min)');
     $this->assertEquals($compareData, $attributes['currencyValue__Minimum']);
     $compareData = array('label' => 'Currency Value -(Max)');
     $this->assertEquals($compareData, $attributes['currencyValue__Maximum']);
     $compareData = array('label' => 'Currency Value -(Sum)');
     $this->assertEquals($compareData, $attributes['currencyValue__Summation']);
     $compareData = array('label' => 'Currency Value -(Avg)');
     $this->assertEquals($compareData, $attributes['currencyValue__Average']);
 }

 /**
  * @param Report $report
  * @param SavedReport$savedReport
  */
 public static function resolveReportToSavedReport(Report $report, SavedReport $savedReport)
 {
     $savedReport->description = $report->getDescription();
     $savedReport->moduleClassName = $report->getModuleClassName();
     $savedReport->name = $report->getName();
     $savedReport->owner = $report->getOwner();
     $savedReport->type = $report->getType();
     $data = array();
     $data['filtersStructure'] = $report->getFiltersStructure();
     $data['currencyConversionType'] = $report->getCurrencyConversionType();
     $data['spotConversionCurrencyCode'] = $report->getSpotConversionCurrencyCode();
     $data[ComponentForReportForm::TYPE_FILTERS] = self::makeArrayFromComponentFormsAttributesData($report->getFilters());
     $data[ComponentForReportForm::TYPE_ORDER_BYS] = self::makeArrayFromComponentFormsAttributesData($report->getOrderBys());
     $data[ComponentForReportForm::TYPE_GROUP_BYS] = self::makeArrayFromComponentFormsAttributesData($report->getGroupBys());
     $data[ComponentForReportForm::TYPE_DISPLAY_ATTRIBUTES] = self::makeArrayFromComponentFormsAttributesData($report->getDisplayAttributes());
     $data[ComponentForReportForm::TYPE_DRILL_DOWN_DISPLAY_ATTRIBUTES] = self::makeArrayFromComponentFormsAttributesData($report->getDrillDownDisplayAttributes());
     if ($report->getChart()->type != null) {
         $data['chart'] = self::makeArrayFromChartForReportFormAttributesData($report->getChart());
     }
     $savedReport->serializedData = serialize($data);
 }

 /**
  * @depends testGetAttributesForOrderBysOnUser
  */
 public function testGetAttributesForChartSeries()
 {
     $model = new ReportModelTestItem();
     $rules = new ReportsTestReportRules();
     $report = new Report();
     $report->setType(Report::TYPE_SUMMATION);
     $report->setModuleClassName('ReportsTestModule');
     $adapter = new ModelRelationsAndAttributesToSummationReportAdapter($model, $rules, $report->getType());
     $attributes = $adapter->getAttributesForChartSeries($report->getGroupBys());
     $this->assertEquals(0, count($attributes));
     //Add a group by, but not as a display attribute
     $groupBy = new GroupByForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $groupBy->attributeIndexOrDerivedType = 'dropDown';
     $report->setModuleClassName('ReportsTestModule');
     $report->addGroupBy($groupBy);
     $attributes = $adapter->getAttributesForChartSeries($report->getGroupBys());
     $this->assertEquals(0, count($attributes));
     //Add a group by as a display attribute
     $groupBy = new GroupByForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $groupBy->attributeIndexOrDerivedType = 'dropDown';
     $report->setModuleClassName('ReportsTestModule');
     $report->addGroupBy($groupBy);
     $displayAttribute = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $displayAttribute->attributeIndexOrDerivedType = 'dropDown';
     $report->addDisplayAttribute($displayAttribute);
     $attributes = $adapter->getAttributesForChartSeries($report->getGroupBys(), $report->getDisplayAttributes());
     $this->assertEquals(1, count($attributes));
     $compareData = array('label' => 'Drop Down');
     $this->assertEquals($compareData, $attributes['dropDown']);
     //Add a second group by as a display attribute
     $groupBy = new GroupByForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $groupBy->attributeIndexOrDerivedType = 'radioDropDown';
     $report->setModuleClassName('ReportsTestModule');
     $report->addGroupBy($groupBy);
     $displayAttribute = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $displayAttribute->attributeIndexOrDerivedType = 'radioDropDown';
     $report->addDisplayAttribute($displayAttribute);
     $attributes = $adapter->getAttributesForChartSeries($report->getGroupBys(), $report->getDisplayAttributes());
     $this->assertEquals(2, count($attributes));
     $compareData = array('label' => 'Drop Down');
     $this->assertEquals($compareData, $attributes['dropDown']);
     $compareData = array('label' => 'Radio Drop Down');
     $this->assertEquals($compareData, $attributes['radioDropDown']);
     //Add a third group by that is likeContactState as a display attribute
     $groupBy = new GroupByForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $groupBy->attributeIndexOrDerivedType = 'likeContactState';
     $report->setModuleClassName('ReportsTestModule');
     $report->addGroupBy($groupBy);
     $displayAttribute = new DisplayAttributeForReportForm('ReportsTestModule', 'ReportModelTestItem', $report->getType());
     $displayAttribute->attributeIndexOrDerivedType = 'likeContactState';
     $report->addDisplayAttribute($displayAttribute);
     $attributes = $adapter->getAttributesForChartSeries($report->getGroupBys(), $report->getDisplayAttributes());
     $this->assertEquals(3, count($attributes));
     $compareData = array('label' => 'Drop Down');
     $this->assertEquals($compareData, $attributes['dropDown']);
     $compareData = array('label' => 'Radio Drop Down');
     $this->assertEquals($compareData, $attributes['radioDropDown']);
     $compareData = array('label' => 'A name for a state');
     $this->assertEquals($compareData, $attributes['likeContactState']);
 }