/** * this function returns the information about a widget in an array * @return array(stuffid=>"id", stufftype=>"type", stufftitle=>"title") */ function getHomePageFrame() { global $adb; global $current_user; $querystuff = "select vtiger_homestuff.stuffid,stufftype,stufftitle,setype from vtiger_homestuff\n\t\t\t\t\t\tleft join vtiger_homedefault on vtiger_homedefault.stuffid=vtiger_homestuff.stuffid\n\t\t\t\t\t\twhere visible=0 and userid=? order by stuffsequence desc"; $resultstuff = $adb->pquery($querystuff, array($current_user->id)); for ($i = 0; $i < $adb->num_rows($resultstuff); $i++) { $modulename = $adb->query_result($resultstuff, $i, 'setype'); $stuffid = $adb->query_result($resultstuff, $i, 'stuffid'); $stufftype = $adb->query_result($resultstuff, $i, 'stufftype'); if (!empty($modulename) && $modulename != 'NULL') { if (!vtlib_isModuleActive($modulename)) { continue; } } elseif ($stufftype == 'Module') { //check for setype in vtiger_homemodule table and hide if module is de-activated $sql = "select setype from vtiger_homemodule where stuffid=?"; $result_setype = $adb->pquery($sql, array($stuffid)); if ($adb->num_rows($result_setype) > 0) { $module_name = $adb->query_result($result_setype, 0, "setype"); } if (!empty($module_name) && $module_name != 'NULL') { if (!vtlib_isModuleActive($module_name)) { continue; } } } elseif ($stufftype == 'DashBoard') { if (!vtlib_isModuleActive('Dashboard')) { continue; } } elseif (!empty($stufftype) && $stufftype == 'RSS') { if (!vtlib_isModuleActive('Rss')) { continue; } } elseif ($stufftype == 'ReportCharts') { if (vtlib_isModuleActive('Reports') === false) { continue; } else { require_once 'modules/Reports/CustomReportUtils.php'; $query = "SELECT * FROM vtiger_homereportchart WHERE stuffid=?"; $result = $adb->pquery($query, array($stuffid)); $reportId = $adb->query_result($result, 0, 'reportid'); $reportQuery = CustomReportUtils::getCustomReportsQuery($reportId); $reportResult = $adb->query($reportQuery); $num_rows = $adb->num_rows($reportResult); if ($num_rows <= 0) { continue; } } } $nontrans_stufftitle = $adb->query_result($resultstuff, $i, 'stufftitle'); $trans_stufftitle = getTranslatedString($nontrans_stufftitle); $stufftitle = decode_html($trans_stufftitle); if (strlen($stufftitle) > 100) { $stuff_title = substr($stufftitle, 0, 97) . "..."; } else { $stuff_title = $stufftitle; } if ($stufftype == 'Default' && $nontrans_stufftitle != 'Home Page Dashboard' && $nontrans_stufftitle != 'Tag Cloud') { if ($modulename != 'NULL') { if (isPermitted($modulename, 'index') == "yes") { $homeval[] = array('Stuffid' => $stuffid, 'Stufftype' => $stufftype, 'Stufftitle' => $stuff_title); } } else { $homeval[] = array('Stuffid' => $stuffid, 'Stufftype' => $stufftype, 'Stufftitle' => $stuff_title); } } else { if ($stufftype == 'Tag Cloud') { $homeval[] = array('Stuffid' => $stuffid, 'Stufftype' => $stufftype, 'Stufftitle' => $stuff_title); } else { if ($modulename != 'NULL') { if (isPermitted($modulename, 'index') == "yes") { $homeval[] = array('Stuffid' => $stuffid, 'Stufftype' => $stufftype, 'Stufftitle' => $stuff_title); } } else { $homeval[] = array('Stuffid' => $stuffid, 'Stufftype' => $stufftype, 'Stufftitle' => $stuff_title); } } } } $homeframe = $homeval; return $homeframe; }
if ($showCharts == true) { $list_report_form->assign("SHOWCHARTS", $showCharts); require_once 'modules/Reports/CustomReportUtils.php'; require_once 'include/ChartUtils.php'; $groupBy = $oReportRun->getGroupingList($reportid); if (!empty($groupBy)) { foreach ($groupBy as $key => $value) { //$groupByConditon = explode(" ",$value); //$groupByNew = explode("'",$groupByConditon[0]); list($tablename, $colname, $module_field, $fieldname, $single) = explode(":", $key); list($module, $field) = explode("_", $module_field); $fieldDetails = $key; break; } //$groupByField = $oReportRun->GetFirstSortByField($reportid); $queryReports = CustomReportUtils::getCustomReportsQuery($Report_ID, $filtersql); $queryResult = $adb->pquery($queryReports, array()); //ChartUtils::generateChartDataFromReports($queryResult, strtolower($groupByNew[1])); if ($adb->num_rows($queryResult)) { $pieChart = ChartUtils::getReportPieChart($queryResult, strtolower($module_field), $fieldDetails, $reportid); $barChart = ChartUtils::getReportBarChart($queryResult, strtolower($module_field), $fieldDetails, $reportid); $list_report_form->assign("PIECHART", $pieChart); $list_report_form->assign("BARCHART", $barChart); } else { $showCharts = false; } } else { $showCharts = false; } $list_report_form->assign("SHOWCHARTS", $showCharts); }