}
}
if (isPermitted($primarymodule, 'index') == "yes" && $modules_permitted == true) {
$oReportRun = new ReportRun($reportid);
require_once 'include/Zend/Json.php';
$json = new Zend_Json();
$advft_criteria = $_REQUEST['advft_criteria'];
if (!empty($advft_criteria)) {
$advft_criteria = $json->decode($advft_criteria);
}
$advft_criteria_groups = $_REQUEST['advft_criteria_groups'];
if (!empty($advft_criteria_groups)) {
$advft_criteria_groups = $json->decode($advft_criteria_groups);
}
if ($_REQUEST['submode'] == 'saveCriteria') {
updateAdvancedCriteria($reportid, $advft_criteria, $advft_criteria_groups);
}
$filtersql = $oReportRun->RunTimeAdvFilter($advft_criteria, $advft_criteria_groups);
$list_report_form = new vtigerCRM_Smarty();
//Monolithic phase 6 changes
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);
$log->info("Reports :: Save->Successfully saved vtiger_reportsortcol");
$adb->pquery("INSERT INTO vtiger_reportdatefilter (datefilterid,datecolumnname,datefilter,startdate,enddate)\n\t\t\t\t\t\t\tSELECT {$genQueryId},datecolumnname,datefilter,startdate,enddate FROM vtiger_reportdatefilter WHERE datefilterid=?", array($reportid));
$log->info("Reports :: Save->Successfully saved vtiger_reportdatefilter");
$adb->pquery("INSERT INTO vtiger_reportsummary (reportsummaryid,summarytype,columnname)\n\t\t\t\t\t\t\tSELECT {$genQueryId},summarytype,columnname FROM vtiger_reportsummary WHERE reportsummaryid=?", array($reportid));
$log->info("Reports :: Save->Successfully saved vtiger_reportsummary");
$adb->pquery("INSERT INTO vtiger_relcriteria (queryid,columnindex,columnname,comparator,value,groupid,column_condition)\n\t\t\t\t\t\t\tSELECT {$genQueryId},columnindex,columnname,comparator,value,groupid,column_condition FROM vtiger_relcriteria WHERE queryid=?", array($reportid));
$log->info("Reports :: Save->Successfully saved vtiger_relcriteria");
$adb->pquery("INSERT INTO vtiger_relcriteria_grouping (groupid,queryid,group_condition,condition_expression)\n\t\t\t\t\t\t\tSELECT groupid,{$genQueryId},group_condition,condition_expression FROM vtiger_relcriteria_grouping WHERE queryid=?", array($reportid));
$log->info("Reports :: Save->Successfully saved vtiger_relcriteria_grouping");
$advft_criteria = $_REQUEST['advft_criteria'];
$advft_criteria_groups = $_REQUEST['advft_criteria_groups'];
if (!empty($advft_criteria) && !empty($advft_criteria_groups)) {
$json = new Zend_Json();
$advft_criteria = $json->decode($advft_criteria);
$advft_criteria_groups = $json->decode($advft_criteria_groups);
updateAdvancedCriteria($genQueryId, $advft_criteria, $advft_criteria_groups);
}
} else {
$errormessage = "<font color='red'><B>Error Message<ul>\n\t\t\t\t\t\t<li><font color='red'>Error while inserting the record</font>\n\t\t\t\t\t\t</ul></B></font> <br>";
$response_array['errormessage'] = $errormessage;
}
} else {
$errormessage = "<font color='red'><B>Error Message<ul>\n\t\t\t\t\t<li><font color='red'>Error while inserting the record</font>\n\t\t\t\t\t</ul></B></font> <br>";
$response_array['errormessage'] = $errormessage;
}
}
} else {
$errormessage = "<table border='0' cellpadding='5' cellspacing='0' width='100%' height='450px'><tr><td align='center'>";
$errormessage .= "<div style='border: 3px solid rgb(153, 153, 153); background-color: rgb(255, 255, 255); width: 80%; position: relative; z-index: 10000000;'>\n\n\t\t<table border='0' cellpadding='5' cellspacing='0' width='98%'>\n\t\t<tbody><tr>\n\t\t<td rowspan='2' width='11%'><img src='" . vtiger_imageurl('denied.gif', $theme) . "' ></td>\n\t\t<td style='border-bottom: 1px solid rgb(204, 204, 204);' nowrap='nowrap' width='70%'><span class='genHeaderSmall'>" . $mod_strings['LBL_NO_ACCESS'] . " : " . implode(",", $restrictedmodules) . " </span></td>\n\t\t</tr>\n\t\t<tr>\n\t\t<td class='small' align='right' nowrap='nowrap'>\t\t\t \t\n\t\t<a href='javascript:window.history.back();'>{$app_strings['LBL_GO_BACK']}</a><br></td>\n\t\t</tr>\n\t\t</tbody></table> \n\t\t</div>";
$errormessage .= "</td></tr></table>";
$response_array['errormessage'] = $errormessage;
