Ejemplo n.º 1
0
 if ($colNum == $numCols) {
     break;
 }
 $display[$colNum]['width'] = $column['width'];
 $display[$colNum]['dashlets'] = array();
 foreach ($column['dashlets'] as $num => $id) {
     // clint - fixes bug #20398
     // only display dashlets that are from visibile modules and that the user has permission to list
     if (!empty($id) && isset($dashlets[$id]) && is_file($dashlets[$id]['fileLocation'])) {
         $module = 'Home';
         if (!empty($dashletsFiles[$dashlets[$id]['className']]['module'])) {
             $module = $dashletsFiles[$dashlets[$id]['className']]['module'];
         } elseif (!empty($dashlets[$id]['module'])) {
             $module = $dashlets[$id]['module'];
         }
         $myDashlet = new MySugar($module);
         if ($myDashlet->checkDashletDisplay()) {
             require_once $dashlets[$id]['fileLocation'];
             $dashlet = new $dashlets[$id]['className']($id, isset($dashlets[$id]['options']) ? $dashlets[$id]['options'] : array());
             // Need to add support to dynamically display/hide dashlets
             // If it has a method 'shouldDisplay' we will call it to see if we should display it or not
             if (method_exists($dashlet, 'shouldDisplay')) {
                 if (!$dashlet->shouldDisplay()) {
                     // This dashlet doesn't want us to show it, skip it.
                     continue;
                 }
             }
             array_push($dashletIds, $id);
             $dashlets = $current_user->getPreference('dashlets', 'Home');
             // Using hardcoded 'Home' because DynamicAction.php $_REQUEST['module'] value is always Home
             $lvsParams = array();
Ejemplo n.º 2
0
 public function run()
 {
     if (!($this->from_flavor == 'ce' && $this->toFlavor('pro'))) {
         return;
     }
     $dashletsFiles = array();
     if (file_exists($cachedfile = sugar_cached('dashlets/dashlets.php'))) {
         require $cachedfile;
     }
     if (file_exists('modules/Home/dashlets.php')) {
         require 'modules/Home/dashlets.php';
     }
     require_once 'include/MySugar/MySugar.php';
     $prefstomove = array('mypbss_date_start' => 'MyPipelineBySalesStageDashlet', 'mypbss_date_end' => 'MyPipelineBySalesStageDashlet', 'mypbss_sales_stages' => 'MyPipelineBySalesStageDashlet', 'mypbss_chart_type' => 'MyPipelineBySalesStageDashlet', 'lsbo_lead_sources' => 'OpportunitiesByLeadSourceByOutcomeDashlet', 'lsbo_ids' => 'OpportunitiesByLeadSourceByOutcomeDashlet', 'pbls_lead_sources' => 'OpportunitiesByLeadSourceDashlet', 'pbls_ids' => 'OpportunitiesByLeadSourceDashlet', 'pbss_date_start' => 'PipelineBySalesStageDashlet', 'pbss_date_end' => 'PipelineBySalesStageDashlet', 'pbss_sales_stages' => 'PipelineBySalesStageDashlet', 'pbss_chart_type' => 'PipelineBySalesStageDashlet', 'obm_date_start' => 'OutcomeByMonthDashlet', 'obm_date_end' => 'OutcomeByMonthDashlet', 'obm_ids' => 'OutcomeByMonthDashlet');
     $result = $this->db->query("SELECT id FROM users where deleted = '0' AND status != 'Reserved' AND portal_only = 0");
     while ($row = $this->db->fetchByAssoc($result)) {
         $current_user = BeanFactory::getBean('Users', $row['id']);
         // Set the user theme to be 'Sugar' theme since this is run for CE
         // flavor conversions
         $current_user->setPreference('user_theme', 'Sugar', 0, 'global');
         $pages = $current_user->getPreference('pages', 'Home');
         if (empty($pages)) {
             continue;
         }
         $empty_dashlets = array();
         $dashlets = $current_user->getPreference('dashlets', 'Home');
         $dashlets = !empty($dashlets) ? $dashlets : $empty_dashlets;
         $existingDashlets = array();
         foreach ($dashlets as $id => $dashlet) {
             if (!empty($dashlet['className']) && !is_array($dashlet['className'])) {
                 $existingDashlets[$dashlet['className']] = $dashlet['className'];
             }
         }
         // foreach
         // BEGIN 'Sales Page'
         $salesDashlets = array();
         foreach ($defaultSalesDashlets as $salesDashletName => $module) {
             // clint - fixes bug #20398
             // only display dashlets that are from visibile modules and that
             // the user has permission to list
             $myDashlet = new MySugar($module);
             $displayDashlet = $myDashlet->checkDashletDisplay();
             if (isset($dashletsFiles[$salesDashletName]) && $displayDashlet) {
                 $options = array();
                 $prefsforthisdashlet = array_keys($prefstomove, $salesDashletName);
                 foreach ($prefsforthisdashlet as $pref) {
                     $options[$pref] = $current_user->getPreference($pref);
                 }
                 $salesDashlets[create_guid()] = array('className' => $salesDashletName, 'module' => $module, 'fileLocation' => $dashletsFiles[$salesDashletName]['file'], 'options' => $options);
             }
         }
         foreach ($defaultSalesChartDashlets as $salesChartDashlet => $module) {
             $savedReport = new SavedReport();
             $reportId = $savedReport->retrieveReportIdByName($salesChartDashlet);
             // clint - fixes bug #20398
             // only display dashlets that are from visibile modules and that
             // the user has permission to list
             $myDashlet = new MySugar($module);
             $displayDashlet = $myDashlet->checkDashletDisplay();
             if (isset($reportId) && $displayDashlet) {
                 $salesDashlets[create_guid()] = array('className' => 'ChartsDashlet', 'module' => $module, 'fileLocation' => $dashletsFiles['ChartsDashlet']['file'], 'reportId' => $reportId);
             }
         }
         $count = 0;
         $salesColumns = array();
         $salesColumns[0] = array();
         $salesColumns[0]['width'] = '60%';
         $salesColumns[0]['dashlets'] = array();
         $salesColumns[1] = array();
         $salesColumns[1]['width'] = '40%';
         $salesColumns[1]['dashlets'] = array();
         foreach ($salesDashlets as $guid => $dashlet) {
             if ($count % 2 == 0) {
                 array_push($salesColumns[0]['dashlets'], $guid);
             } else {
                 array_push($salesColumns[1]['dashlets'], $guid);
             }
             $count++;
         }
         // END 'Sales Page'
         // BEGIN 'Marketing Page'
         $marketingDashlets = array();
         foreach ($defaultMarketingChartDashlets as $marketingChartDashlet => $module) {
             $savedReport = new SavedReport();
             $reportId = $savedReport->retrieveReportIdByName($marketingChartDashlet);
             // clint - fixes bug #20398
             // only display dashlets that are from visibile modules and that
             // the user has permission to list
             $myDashlet = new MySugar($module);
             $displayDashlet = $myDashlet->checkDashletDisplay();
             if (isset($reportId) && $displayDashlet) {
                 $marketingDashlets[create_guid()] = array('className' => 'ChartsDashlet', 'module' => $module, 'fileLocation' => $dashletsFiles['ChartsDashlet']['file'], 'reportId' => $reportId);
             }
         }
         foreach ($defaultMarketingDashlets as $marketingDashletName => $module) {
             // clint - fixes bug #20398
             // only display dashlets that are from visibile modules and that
             // the user has permission to list
             $myDashlet = new MySugar($module);
             $displayDashlet = $myDashlet->checkDashletDisplay();
             if (isset($dashletsFiles[$marketingDashletName]) && $displayDashlet) {
                 $options = array();
                 $prefsforthisdashlet = array_keys($prefstomove, $marketingDashletName);
                 foreach ($prefsforthisdashlet as $pref) {
                     $options[$pref] = $current_user->getPreference($pref);
                 }
                 // foreach
                 $marketingDashlets[create_guid()] = array('className' => $marketingDashletName, 'module' => $module, 'fileLocation' => $dashletsFiles[$marketingDashletName]['file'], 'options' => $options);
             }
         }
         $count = 0;
         $marketingColumns = array();
         $marketingColumns[0] = array();
         $marketingColumns[0]['width'] = '30%';
         $marketingColumns[0]['dashlets'] = array();
         $marketingColumns[1] = array();
         $marketingColumns[1]['width'] = '30%';
         $marketingColumns[1]['dashlets'] = array();
         $marketingColumns[2] = array();
         $marketingColumns[2]['width'] = '40%';
         $marketingColumns[2]['dashlets'] = array();
         foreach ($marketingDashlets as $guid => $dashlet) {
             if ($count % 3 == 0) {
                 array_push($marketingColumns[0]['dashlets'], $guid);
             } else {
                 if ($count % 3 == 1) {
                     array_push($marketingColumns[1]['dashlets'], $guid);
                 } else {
                     array_push($marketingColumns[2]['dashlets'], $guid);
                 }
             }
             $count++;
         }
         // END 'Marketing Page'
         // BEGIN 'Support Page'- bug46195
         $supportDashlets = array();
         foreach ($defaultSupportChartDashlets as $supportChartDashlet => $module) {
             $savedReport = new SavedReport();
             $reportId = $savedReport->retrieveReportIdByName($supportChartDashlet);
             $myDashlet = new MySugar($module);
             $displayDashlet = $myDashlet->checkDashletDisplay();
             if (isset($reportId) && $displayDashlet) {
                 $supportDashlets[create_guid()] = array('className' => 'ChartsDashlet', 'module' => $module, 'fileLocation' => $dashletsFiles['ChartsDashlet']['file'], 'reportId' => $reportId);
             }
         }
         foreach ($defaultSupportDashlets as $supportDashletName => $module) {
             $myDashlet = new MySugar($module);
             $displayDashlet = $myDashlet->checkDashletDisplay();
             if (isset($dashletsFiles[$supportDashletName]) && $displayDashlet) {
                 $options = array();
                 $prefsforthisdashlet = array_keys($prefstomove, $supportDashletName);
                 foreach ($prefsforthisdashlet as $pref) {
                     $options[$pref] = $current_user->getPreference($pref);
                 }
                 // foreach
                 $supportDashlets[create_guid()] = array('className' => $supportDashletName, 'module' => $module, 'fileLocation' => $dashletsFiles[$supportDashletName]['file'], 'options' => $options);
             }
         }
         $count = 0;
         $supportColumns = array();
         $supportColumns[0] = array();
         $supportColumns[0]['width'] = '30%';
         $supportColumns[0]['dashlets'] = array();
         $supportColumns[1] = array();
         $supportColumns[1]['width'] = '30%';
         $supportColumns[1]['dashlets'] = array();
         $supportColumns[2] = array();
         $supportColumns[2]['width'] = '40%';
         $supportColumns[2]['dashlets'] = array();
         foreach ($supportDashlets as $guid => $dashlet) {
             if ($count % 3 == 0) {
                 array_push($supportColumns[0]['dashlets'], $guid);
             } else {
                 if ($count % 3 == 1) {
                     array_push($supportColumns[1]['dashlets'], $guid);
                 } else {
                     array_push($supportColumns[2]['dashlets'], $guid);
                 }
             }
             $count++;
         }
         // END ' Support Page' - bug 46195
         // Set the dashlets pages to user preferences table
         $pageIndex = count($pages);
         $pages[$pageIndex]['columns'] = $salesColumns;
         $pages[$pageIndex]['numColumns'] = '2';
         $pages[$pageIndex]['pageTitle'] = $this->mod_strings['LBL_HOME_PAGE_2_NAME'];
         // "Sales Page"
         $pageIndex++;
         $pages[$pageIndex]['columns'] = $marketingColumns;
         $pages[$pageIndex]['numColumns'] = '3';
         $pages[$pageIndex]['pageTitle'] = $this->mod_strings['LBL_HOME_PAGE_6_NAME'];
         // "Marketing Page"
         $pageIndex++;
         $pages[$pageIndex]['columns'] = $supportColumns;
         $pages[$pageIndex]['numColumns'] = '4';
         $pages[$pageIndex]['pageTitle'] = $this->mod_strings['LBL_HOME_PAGE_3_NAME'];
         // "Support Page" - bug 46195
         $dashlets = array_merge($dashlets, $salesDashlets, $marketingDashlets, $supportDashlets);
         $current_user->setPreference('dashlets', $dashlets, 0, 'Home');
         $current_user->setPreference('pages', $pages, 0, 'Home');
     }
     // while
 }
Ejemplo n.º 3
0
 function getReportCharts($category)
 {
     global $current_user;
     $chartsList = array();
     require_once 'modules/Reports/SavedReport.php';
     $sq = new SugarQuery();
     $savedReportBean = BeanFactory::getBean('Reports');
     $sq->from($savedReportBean);
     // Make sure the user isn't seeing reports they don't have access to
     $modules = array_keys(getACLDisAllowedModules());
     if (count($modules)) {
         $sq->where()->notIn('module', $modules);
     }
     //create the $where statement(s)
     $sq->where()->notEquals('chart_type', 'none');
     switch ($category) {
         case 'global':
             // build global where string
             $sq->where()->equals('saved_reports.team_set_id', '1');
             break;
         case 'myTeams':
             // build myTeams where string
             $myTeams = $current_user->get_my_teams();
             $teamWhere = '';
             foreach ($myTeams as $team_id => $team_name) {
                 if ($team_id != '1' && $team_id != $current_user->getPrivateTeamID()) {
                     if ($teamWhere == '') {
                         $teamWhere .= ' ';
                     } else {
                         $teamWhere .= 'OR ';
                     }
                     $teamWhere .= "saved_reports.team_set_id='" . $team_id . "' ";
                 }
             }
             $sq->whereRaw($teamWhere);
             break;
         case 'mySaved':
             // build mySaved where string
             $sq->where()->equals('saved_reports.team_set_id', $current_user->getPrivateTeamID());
             break;
         case 'myFavorites':
             global $current_user;
             $sugaFav = BeanFactory::getBean('SugarFavorites');
             $current_favorites_beans = $sugaFav->getUserFavoritesByModule('Reports', $current_user);
             $current_favorites = array();
             foreach ((array) $current_favorites_beans as $key => $val) {
                 array_push($current_favorites, $val->record_id);
             }
             if (is_array($current_favorites) && !empty($current_favorites)) {
                 $sq->where()->in('saved_reports.id', array_values($current_favorites));
             } else {
                 $sq->where()->in('saved_reports.id', array('-1'));
             }
             break;
         default:
             break;
     }
     //retrieve array of reports
     $savedReports = $savedReportBean->fetchFromQuery($sq);
     $chartsList = array();
     if (!empty($savedReports)) {
         foreach ($savedReports as $savedReport) {
             // clint - fixes bug #20398
             // only display dashlets that are from visibile modules and that the user has permission to list
             require_once 'include/MySugar/MySugar.php';
             $myDashlet = new MySugar($savedReport->module);
             $displayDashlet = $myDashlet->checkDashletDisplay();
             if ($displayDashlet) {
                 $title = getReportNameTranslation($savedReport->name);
                 $report_def = array('title' => $title, 'onclick' => 'return SUGAR.mySugar.addDashlet(\'' . $savedReport->id . '\', \'chart\', \'' . $savedReport->module . '\');');
                 array_push($chartsList, $report_def);
             }
         }
     }
     asort($chartsList);
     $this->dashlets[$category] = $chartsList;
 }
Ejemplo n.º 4
0
 /**
  * @todo the css is not fully inherited in this file
  */
 function retrievePage()
 {
     global $current_user, $sugar_version, $sugar_config, $sugar_flavor, $current_language;
     global $app_strings, $theme;
     // build dashlet cache file if not found
     if (!is_file(sugar_cached('dashlets/dashlets.php'))) {
         require_once 'include/Dashlets/DashletCacheBuilder.php';
         $dc = new DashletCacheBuilder();
         $dc->buildCache();
     }
     require_once sugar_cached('dashlets/dashlets.php');
     $pages = $current_user->getPreference('pages', $this->type);
     $dashlets = $current_user->getPreference('dashlets', $this->type);
     $count = 0;
     $dashletIds = array();
     // collect ids to pass to javascript
     $display = array();
     $predefinedChartsList = array('MyPipelineBySalesStageDashlet', 'OpportunitiesByLeadSourceDashlet', 'OpportunitiesByLeadSourceByOutcomeDashlet', 'OutcomeByMonthDashlet', 'PipelineBySalesStageDashlet', 'CampaignROIChartDashlet', 'MyOpportunitiesGaugeDashlet', 'MyForecastingChartDashlet', 'MyModulesUsedChartDashlet', 'MyTeamModulesUsedChartDashlet');
     $pageData = array();
     $chartsArray = array();
     $chartStyleCSS = SugarThemeRegistry::current()->getCSSURL('chart.css');
     $chartColorsXML = SugarThemeRegistry::current()->getImageURL('sugarColors.xml');
     $chartStringsXML = $sugar_config['tmp_dir'] . 'chart_strings.' . $current_language . '.lang.xml';
     require_once 'include/SugarCharts/SugarChartFactory.php';
     $sugarChart = SugarChartFactory::getInstance();
     if (!file_exists($chartStringsXML)) {
         $sugarChart->generateChartStrings($chartStringsXML);
     }
     $selectedPage = $_REQUEST['pageId'];
     $numCols = $pages[$selectedPage]['numColumns'];
     $trackerScript = '';
     $dashletScript = '';
     $trackerScriptArray = "<script>var trackerGridArray = [";
     $toggleHeaderToolsetScript = "";
     foreach ($pages[$selectedPage]['columns'] as $colNum => $column) {
         if ($colNum == $numCols) {
             break;
         }
         $display[$colNum]['width'] = $column['width'];
         $display[$colNum]['dashlets'] = array();
         foreach ($column['dashlets'] as $num => $id) {
             if (!empty($id) && isset($dashlets[$id]) && is_file($dashlets[$id]['fileLocation'])) {
                 // clint - fixes bug #20398
                 // only display dashlets that are from visibile modules and that the user has permission to list
                 $module = 'Home';
                 if (isset($dashletsFiles[$dashlets[$id]['className']]['module'])) {
                     $module = $dashletsFiles[$dashlets[$id]['className']]['module'];
                 }
                 $myDashlet = new MySugar($module);
                 if ($myDashlet->checkDashletDisplay()) {
                     require_once $dashlets[$id]['fileLocation'];
                     if ($dashlets[$id]['className'] == 'ChartsDashlet') {
                         $dashlet = new $dashlets[$id]['className']($id, $dashlets[$id]['reportId'], isset($dashlets[$id]['options']) ? $dashlets[$id]['options'] : array());
                         $chartsArray[$id] = array();
                         $chartsArray[$id]['id'] = $id;
                         $chartsArray[$id]['xmlFile'] = sugar_cached("xml/") . $dashlets[$id]['reportId'] . '_saved_chart.xml';
                         $chartsArray[$id]['width'] = '100%';
                         $chartsArray[$id]['height'] = '480';
                         $chartsArray[$id]['styleSheet'] = $chartStyleCSS;
                         $chartsArray[$id]['colorScheme'] = $chartColorsXML;
                         $chartsArray[$id]['langFile'] = $chartStringsXML;
                     } else {
                         $dashlet = new $dashlets[$id]['className']($id, isset($dashlets[$id]['options']) ? $dashlets[$id]['options'] : array());
                         if (in_array($dashlets[$id]['className'], $predefinedChartsList)) {
                             $chartsArray[$id] = array();
                             $chartsArray[$id]['id'] = $id;
                             $chartsArray[$id]['xmlFile'] = $sugarChart->getXMLFileName($id);
                             $chartsArray[$id]['width'] = '100%';
                             $chartsArray[$id]['height'] = '480';
                             $chartsArray[$id]['styleSheet'] = $chartStyleCSS;
                             $chartsArray[$id]['colorScheme'] = $chartColorsXML;
                             $chartsArray[$id]['langFile'] = $chartStringsXML;
                         }
                     }
                     // Need to add support to dynamically display/hide dashlets
                     // If it has a method 'shouldDisplay' we will call it to see if we should display it or not
                     if (method_exists($dashlet, 'shouldDisplay')) {
                         if (!$dashlet->shouldDisplay()) {
                             // This dashlet doesn't want us to show it, skip it.
                             continue;
                         }
                     }
                     array_push($dashletIds, $id);
                     try {
                         $dashlet->process();
                         $display[$colNum]['dashlets'][$id]['display'] = $dashlet->display();
                         $display[$colNum]['dashlets'][$id]['displayHeader'] = $dashlet->getHeader();
                         $display[$colNum]['dashlets'][$id]['displayFooter'] = $dashlet->getFooter();
                         if ($dashlet->hasScript) {
                             $dashletScript .= $dashlet->displayScript();
                         }
                         if ($dashlets[$id]['className'] == 'TrackerDashlet') {
                             $trackerScriptArray .= "'{$id}',";
                             $trackerScript = empty($trackerScript) ? $dashlet->displayScript() : $trackerScript;
                         }
                         $toggleHeaderToolsetScript .= "SUGAR.mySugar.attachToggleToolsetEvent('{$id}');";
                     } catch (Exception $ex) {
                         $display[$colNum]['dashlets'][$id]['display'] = $ex->getMessage();
                         $display[$colNum]['dashlets'][$id]['displayHeader'] = $dashlet->getHeader();
                         $display[$colNum]['dashlets'][$id]['displayFooter'] = $dashlet->getFooter();
                     }
                 }
             }
         }
     }
     $sugar_smarty = new Sugar_Smarty();
     $sugar_smarty->assign('sugarVersion', $sugar_version);
     $sugar_smarty->assign('sugarFlavor', $sugar_flavor);
     $sugar_smarty->assign('currentLanguage', $GLOBALS['current_language']);
     $sugar_smarty->assign('serverUniqueKey', $GLOBALS['server_unique_key']);
     $sugar_smarty->assign('imagePath', $GLOBALS['image_path']);
     $sugar_smarty->assign('lblLnkHelp', $GLOBALS['app_strings']['LNK_HELP']);
     $sugar_smarty->assign('mod', return_module_language($current_language, 'Home'));
     $sugar_smarty->assign('app', $GLOBALS['app_strings']);
     $sugar_smarty->assign('maxCount', empty($sugar_config['max_dashboards']) ? 15 : $sugar_config['max_dashboards']);
     $sugar_smarty->assign('dashletCount', $count);
     $sugar_smarty->assign('columns', $display);
     $sugar_smarty->assign('selectedPage', $selectedPage);
     $sugar_smarty->assign('numCols', $numCols);
     if (!empty($sugar_config['lock_homepage']) && $sugar_config['lock_homepage'] == true) {
         $sugar_smarty->assign('lock_homepage', true);
     }
     $htmlOutput = $sugar_smarty->fetch('include/MySugar/tpls/retrievePage.tpl');
     $json = getJSONobj();
     $scriptResponse = array();
     $scriptResponse['dashletScript'] = $dashletScript;
     $scriptResponse['newDashletsToReg'] = $dashletIds;
     $scriptResponse['numCols'] = sizeof($pages[$selectedPage]['columns']);
     //custom chart code
     $scriptResponse['chartsArray'] = $chartsArray;
     $scriptResponse['trackerScript'] = $trackerScript . (strpos($trackerScriptArray, ',') ? substr($trackerScriptArray, 0, strlen($trackerScriptArray) - 1) . ']; </script>' : $trackerScriptArray . ']; </script>');
     $scriptResponse['toggleHeaderToolsetScript'] = "<script>" . $toggleHeaderToolsetScript . "</script>";
     $scriptOutput = 'var scriptResponse = ' . $json->encode($scriptResponse);
     return $json->encode(array('html' => $htmlOutput, 'script' => $scriptOutput));
 }