public function testMakeDataAndLabelsForSeriesOrRange()
 {
     $attributesData = array('a' => array('label' => 'an A'), 'b' => array('label' => 'a b'));
     $dataAndLabels = ReportUtil::makeDataAndLabelsForSeriesOrRange($attributesData);
     $compareData = array('a' => 'an A', 'b' => 'a b');
     $this->assertEquals($compareData, $dataAndLabels);
 }
Esempio n. 2
0
 public function actionAdd()
 {
     $op = EnvUtil::getRequest("op");
     if (!in_array($op, array("new", "save"))) {
         $op = "new";
     }
     if ($op == "new") {
         $typeid = intval(EnvUtil::getRequest("typeid"));
         if (!$typeid) {
             $typeid = 1;
         }
         $uid = Ibos::app()->user->uid;
         $upUid = UserUtil::getSupUid($uid);
         $reportType = ReportType::model()->fetchByPk($typeid);
         $summaryAndPlanDate = ReportUtil::getDateByIntervalType($reportType["intervaltype"], $reportType["intervals"]);
         $subject = ICReport::handleShowSubject($reportType, strtotime($summaryAndPlanDate["summaryBegin"]), strtotime($summaryAndPlanDate["summaryEnd"]));
         $lastRep = Report::model()->fetchLastRepByUidAndTypeid($uid, $typeid);
         $orgPlanList = array();
         if (!empty($lastRep)) {
             $orgPlanList = ReportRecord::model()->fetchRecordByRepidAndPlanflag($lastRep["repid"], 2);
         }
         $params = array("typeid" => $typeid, "summaryAndPlanDate" => $summaryAndPlanDate, "intervals" => $reportType["intervals"], "intervaltype" => $reportType["intervaltype"], "subject" => $subject, "upUid" => StringUtil::wrapId($upUid), "uploadConfig" => AttachUtil::getUploadConfig(), "orgPlanList" => $orgPlanList, "isInstallCalendar" => ModuleUtil::getIsEnabled("calendar"));
         $this->setPageTitle(Ibos::lang("Add report"));
         $this->setPageState("breadCrumbs", array(array("name" => Ibos::lang("Personal Office")), array("name" => Ibos::lang("Work report"), "url" => $this->createUrl("default/index")), array("name" => Ibos::lang("Add report"))));
         $this->render("add", $params);
     } else {
         $this->{$op}();
     }
 }
Esempio n. 3
0
 public function getStamp()
 {
     static $stamp = array();
     if (empty($stamp)) {
         $enableStamp = ReportUtil::getEnableStamp();
         $stampIds = implode(",", array_keys($enableStamp));
         $stamp = Stamp::model()->fetchAllSortByPk("id", array("condition" => "FIND_IN_SET(id,'{$stampIds}')", "order" => "sort ASC"));
     }
     return $stamp;
 }
Esempio n. 4
0
 public function scoreReport($repId, $uid, $stamp)
 {
     $record = $this->fetchByAttributes(array("repid" => $repId));
     $attributes = array("repid" => $repId, "uid" => $uid, "stamp" => $stamp, "integration" => ReportUtil::getScoreByStamp($stamp), "scoretime" => TIMESTAMP);
     if (empty($record)) {
         $this->add($attributes);
     } else {
         $this->modify($record["id"], $attributes);
     }
 }
 public static function getReportsByCid($cid, $startDate, $endDate, $numCat = 4, $desiredPlatform)
 {
     $apps = array();
     $excludeApps = array();
     foreach (AppUtil::getAppsByUid($_SESSION['uid']) as $app) {
         if ($desiredPlatform == 0 || $desiredPlatform == $app->platform) {
             $apps[$app->id] = $app->name;
         } else {
             $excludeApps[$app->id] = $app->name;
         }
     }
     fb("getRbyCid");
     fb("apps", $apps);
     return ReportUtil::getReportsByIdAndGroup('nid', $cid, 'aid', $startDate, $endDate, $apps, $numCat, $excludeApps);
 }
 public function getXML()
 {
     $this->printHeader = false;
     $this->printFooter = false;
     $reports = ReportUtil::getNetworkReportsByUid($this->user->id, $this->startDate, $this->endDate);
     $dates = array();
     for ($i = $this->startDate; $i <= $this->endDate; $i = date('Y-m-d', strtotime('+1 day', strtotime($i)))) {
         $dates[] = $i;
     }
     $networks = array();
     foreach ($reports['types'] as $type => $discard) {
         $networks[$type] = isset(Network::$NETWORKS[$type]) ? Network::$NETWORKS[$type]['name'] : 'Unknown';
     }
     $this->smarty->assign('networks', $networks);
     $this->smarty->assign('reports', $reports);
     $this->smarty->assign('dates', $dates);
     return $this->smarty->fetch('../tpl/www/reports/networkReportsXML.tpl');
 }
Esempio n. 7
0
 protected function search()
 {
     $type = EnvUtil::getRequest("type");
     $conditionCookie = MainUtil::getCookie("condition");
     if (empty($conditionCookie)) {
         MainUtil::setCookie("condition", $this->_condition, 10 * 60);
     }
     if ($type == "advanced_search") {
         $search = $_POST["search"];
         $this->_condition = ReportUtil::joinSearchCondition($search);
     } elseif ($type == "normal_search") {
         $keyword = $_POST["keyword"];
         MainUtil::setCookie("keyword", $keyword, 10 * 60);
         $this->_condition = " ( content LIKE '%{$keyword}%' OR subject LIKE '%{$keyword}%' ) ";
     } else {
         $this->_condition = $conditionCookie;
     }
     if ($this->_condition != MainUtil::getCookie("condition")) {
         MainUtil::setCookie("condition", $this->_condition, 10 * 60);
     }
 }
 /**
  * @param $savedReport
  * @return Report
  */
 public static function makeReportBySavedReport($savedReport)
 {
     $report = new Report();
     if ($savedReport->id > 0) {
         $report->setId((int) $savedReport->id);
     }
     $report->setDescription($savedReport->description);
     $report->setModuleClassName($savedReport->moduleClassName);
     $report->setName($savedReport->name);
     $report->setOwner($savedReport->owner);
     $report->setType($savedReport->type);
     $explicitReadWriteModelPermissions = ExplicitReadWriteModelPermissionsUtil::makeBySecurableItem($savedReport);
     $report->setExplicitReadWriteModelPermissions($explicitReadWriteModelPermissions);
     if ($savedReport->serializedData != null) {
         $unserializedData = unserialize($savedReport->serializedData);
         if (isset($unserializedData['filtersStructure'])) {
             $report->setFiltersStructure($unserializedData['filtersStructure']);
         }
         if (isset($unserializedData['currencyConversionType'])) {
             $report->setCurrencyConversionType((int) $unserializedData['currencyConversionType']);
         }
         if (isset($unserializedData['spotConversionCurrencyCode'])) {
             $report->setSpotConversionCurrencyCode($unserializedData['spotConversionCurrencyCode']);
         }
         self::makeComponentFormAndPopulateReportFromData($unserializedData[ComponentForReportForm::TYPE_FILTERS], $report, 'Filter');
         self::makeComponentFormAndPopulateReportFromData($unserializedData[ComponentForReportForm::TYPE_ORDER_BYS], $report, 'OrderBy');
         self::makeComponentFormAndPopulateReportFromData($unserializedData[ComponentForReportForm::TYPE_GROUP_BYS], $report, 'GroupBy');
         self::makeComponentFormAndPopulateReportFromData($unserializedData[ComponentForReportForm::TYPE_DISPLAY_ATTRIBUTES], $report, 'DisplayAttribute');
         self::makeComponentFormAndPopulateReportFromData($unserializedData[ComponentForReportForm::TYPE_DRILL_DOWN_DISPLAY_ATTRIBUTES], $report, 'DrillDownDisplayAttribute');
         if (isset($unserializedData['chart'])) {
             $moduleClassName = $report->getModuleClassName();
             $modelClassName = $moduleClassName::getPrimaryModelName();
             $adapter = ModelRelationsAndAttributesToSummationReportAdapter::make($moduleClassName, $modelClassName, $report->getType());
             $chart = new ChartForReportForm(ReportUtil::makeDataAndLabelsForSeriesOrRange($adapter->getAttributesForChartSeries($report->getGroupBys(), $report->getDisplayAttributes())), ReportUtil::makeDataAndLabelsForSeriesOrRange($adapter->getAttributesForChartRange($report->getDisplayAttributes())));
             $chart->setAttributes($unserializedData['chart']);
             $report->setChart($chart);
         }
     }
     return $report;
 }
Esempio n. 9
0
 private function personal()
 {
     $uid = Ibos::app()->user->uid;
     $typeid = EnvUtil::getRequest("typeid");
     $getUid = intval(EnvUtil::getRequest("uid"));
     $condition = "uid = '{$getUid}'";
     if (!UserUtil::checkIsSub($uid, $getUid)) {
         $condition .= " AND FIND_IN_SET('{$uid}', toid )";
     }
     if (!empty($typeid)) {
         $condition .= " AND typeid = '{$typeid}'";
     }
     if (EnvUtil::getRequest("param") == "search") {
         $this->search();
     }
     $this->_condition = ReportUtil::joinCondition($this->_condition, $condition);
     $paginationData = Report::model()->fetchAllByPage($this->_condition);
     $params = array("dashboardConfig" => Ibos::app()->setting->get("setting/reportconfig"), "typeid" => $typeid, "pagination" => $paginationData["pagination"], "reportList" => ICReport::handelListData($paginationData["data"]), "reportCount" => Report::model()->count("uid = '{$getUid}'"), "commentCount" => Report::model()->count("uid='{$getUid}' AND isreview=1"), "user" => User::model()->fetchByUid($getUid), "supUid" => UserUtil::getSupUid($getUid));
     $this->setPageTitle(Ibos::lang("Review subordinate report"));
     $this->setPageState("breadCrumbs", array(array("name" => Ibos::lang("Personal Office")), array("name" => Ibos::lang("Work report"), "url" => $this->createUrl("default/index")), array("name" => Ibos::lang("Subordinate personal report"))));
     $this->render("personal", $params);
 }
Esempio n. 10
0
 public function run()
 {
     $data = array("config" => ReportUtil::getSetting(), "id" => $this->getController()->getId());
     $this->render(self::VIEW, $data);
 }
 /**
  * @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);
 }
Esempio n. 12
0
 public function run()
 {
     $data = array("typeid" => EnvUtil::getRequest("typeid"), "lang" => Ibos::getLangSource("report.default"), "deptArr" => UserUtil::getManagerDeptSubUserByUid(Ibos::app()->user->uid), "dashboardConfig" => ReportUtil::getSetting(), "deptRoute" => $this->inStats() ? "stats/review" : "review/index", "userRoute" => $this->inStats() ? "stats/review" : "review/personal");
     $this->render(self::VIEW, $data);
 }
 public function actionGetAvailableSeriesAndRangesForChart($type, $id = null, $isBeingCopied = false)
 {
     $postData = PostUtil::getData();
     $savedReport = null;
     $report = null;
     $this->resolveSavedReportAndReportByPostData($postData, $savedReport, $report, $type, $id, (bool) $isBeingCopied);
     $moduleClassName = $report->getModuleClassName();
     $modelClassName = $moduleClassName::getPrimaryModelName();
     $modelToReportAdapter = ModelRelationsAndAttributesToReportAdapter::make($moduleClassName, $modelClassName, $report->getType());
     if (!$modelToReportAdapter instanceof ModelRelationsAndAttributesToSummationReportAdapter) {
         throw new NotSupportedException();
     }
     $seriesAttributesData = $modelToReportAdapter->getAttributesForChartSeries($report->getGroupBys(), $report->getDisplayAttributes());
     $rangeAttributesData = $modelToReportAdapter->getAttributesForChartRange($report->getDisplayAttributes());
     $dataAndLabels = array();
     $dataAndLabels['firstSeriesDataAndLabels'] = array('' => Zurmo::t('Core', '(None)'));
     $dataAndLabels['firstSeriesDataAndLabels'] = array_merge($dataAndLabels['firstSeriesDataAndLabels'], ReportUtil::makeDataAndLabelsForSeriesOrRange($seriesAttributesData));
     $dataAndLabels['firstRangeDataAndLabels'] = array('' => Zurmo::t('Core', '(None)'));
     $dataAndLabels['firstRangeDataAndLabels'] = array_merge($dataAndLabels['firstRangeDataAndLabels'], ReportUtil::makeDataAndLabelsForSeriesOrRange($rangeAttributesData));
     $dataAndLabels['secondSeriesDataAndLabels'] = array('' => Zurmo::t('Core', '(None)'));
     $dataAndLabels['secondSeriesDataAndLabels'] = array_merge($dataAndLabels['secondSeriesDataAndLabels'], ReportUtil::makeDataAndLabelsForSeriesOrRange($seriesAttributesData));
     $dataAndLabels['secondRangeDataAndLabels'] = array('' => Zurmo::t('Core', '(None)'));
     $dataAndLabels['secondRangeDataAndLabels'] = array_merge($dataAndLabels['secondRangeDataAndLabels'], ReportUtil::makeDataAndLabelsForSeriesOrRange($rangeAttributesData));
     echo CJSON::encode($dataAndLabels);
 }
 /**
  * Override to handle report filters
  * @param SavedCalendar | ModelForm $model
  * @param string $postVariableName
  * @throws NotSupportedException();
  */
 protected function attemptToValidateAjaxFromPost($model, $postVariableName)
 {
     if (isset($_POST['ajax']) && $_POST['ajax'] == 'edit-form') {
         $postData = PostUtil::getData();
         $readyToUsePostData = ExplicitReadWriteModelPermissionsUtil::removeIfExistsFromPostData($_POST[$postVariableName]);
         $sanitizedPostdata = PostUtil::sanitizePostByDesignerTypeForSavingModel($model, $readyToUsePostData);
         $sanitizedOwnerPostData = PostUtil::sanitizePostDataToJustHavingElementForSavingModel($sanitizedPostdata, 'owner');
         $sanitizedPostDataWithoutOwner = PostUtil::removeElementFromPostDataForSavingModel($sanitizedPostdata, 'owner');
         $model->setAttributes($sanitizedPostDataWithoutOwner);
         if ($model->validate()) {
             $modelToStringValue = strval($model);
             if ($sanitizedOwnerPostData != null) {
                 $model->setAttributes($sanitizedOwnerPostData);
             }
             if ($model instanceof OwnedSecurableItem) {
                 $model->validate(array('owner'));
             }
         }
         $wizardFormClassName = ReportToWizardFormAdapter::getFormClassNameByType(Report::TYPE_ROWS_AND_COLUMNS);
         if (!isset($postData[$wizardFormClassName])) {
             throw new NotSupportedException();
         }
         $report = SavedCalendarToReportAdapter::makeReportBySavedCalendar($model);
         DataToReportUtil::resolveFiltersStructure($postData[$wizardFormClassName], $report);
         DataToReportUtil::resolveFilters($postData[$wizardFormClassName], $report);
         //This would do the filter and filter structure validation
         $reportToWizardFormAdapter = new ReportToWizardFormAdapter($report);
         $reportForm = $reportToWizardFormAdapter->makeFormByType();
         $postData['validationScenario'] = $wizardFormClassName::FILTERS_VALIDATION_SCENARIO;
         $filtersErrorData = ReportUtil::validateReportWizardForm($postData, $reportForm);
         $errorData = ZurmoActiveForm::makeErrorsDataAndResolveForOwnedModelAttributes($model);
         $errorData = array_merge($errorData, $filtersErrorData);
         echo CJSON::encode($errorData);
         Yii::app()->end(0, false);
     }
 }
 public function getXML()
 {
     $this->printHeader = false;
     $this->printFooter = false;
     $apps = AppUtil::getAppsByUid($_SESSION['uid']);
     fb("app", $apps);
     $reports = ReportUtil::getReportsByCid($this->cid, $this->startDate, $this->endDate, $this->numCat, $this->platform);
     fb("reports", $reports);
     $new_reports = $this->collapseReport($reports);
     if ($this->metricTypeSelected == "CTR") {
         $this->calculateCTR($new_reports);
     }
     fb("nr", $new_reports);
     $this->smarty->assign('reports', $new_reports);
     $this->smarty->assign('nets', $reports['nets']);
     $this->smarty->assign('dates', $new_reports['dates']);
     $this->smarty->assign('metric', strtolower($this->metricTypeSelected));
     //fb("smarty",$this->smarty->get_template_vars());
     return $this->smarty->fetch('../tpl/www/reports/applicationReportsXML.tpl');
     //
     //     foreach($houseAds as $houseAd) {
     //       $houseAd->reports = ReportUtil::getReportsByCid($houseAd->id, $this->startDate, $this->endDate);
     //     }
     //
     //     $totals = array();
     //     $dates = array();
     //     for($i=$this->startDate; $i<=$this->endDate; $i=date('Y-m-d', strtotime('+1 day', strtotime($i)))) {
     //       $dates[] = $i;
     //
     //       foreach($houseAds as $houseAd) {
     // if(isset($totals[$i])) {
     //   $totals[$i]['impressions'] += $houseAd->reports[$i]['impressions'];
     //   $totals[$i]['clicks'] += $houseAd->reports[$i]['clicks'];
     // }
     // else {
     //   $totals[$i]['impressions'] = $houseAd->reports[$i]['impressions'];
     //   $totals[$i]['clicks'] = $houseAd->reports[$i]['clicks'];
     // }
     //       }
     //     }
     //
     //     $this->smarty->assign('houseAds', $houseAds);
     //     $this->smarty->assign('dates', $dates);
     //     $this->smarty->assign('totals', $totals);
     //
     //     return $this->smarty->fetch('../tpl/www/reports/houseAdReportsXML.tpl');
 }
 public function getXML()
 {
     $this->printHeader = false;
     $this->printFooter = false;
     if ($this->aid != null) {
         $app = new App($this->aid);
     } else {
         $apps = AppUtil::getAppsByUid($this->user->id);
         $app = $apps['0'];
     }
     $reports = ReportUtil::getReportsByAid($app->id, $this->startDate, $this->endDate);
     fb("reports", $reports);
     $new_reports = $this->collapseReport($reports);
     fb("nr", $new_reports);
     $this->smarty->assign('reports', $new_reports);
     $this->smarty->assign('nets', $reports['nets']);
     $this->smarty->assign('dates', $new_reports['dates']);
     $this->smarty->assign('metric', 'impressions');
     return $this->smarty->fetch('../tpl/www/reports/applicationReportsXML.tpl');
 }