/**
* Function saves Reports Sorting Fields
*/
function saveSortFields()
{
$db = PearDatabase::getInstance();
$sortFields = $this->get('sortFields');
$i = 0;
foreach ($sortFields as $fieldInfo) {
$db->pquery('INSERT INTO its4you_reports4you_sortcol(sortcolid, reportid, columnname, sortorder) VALUES (?,?,?,?)', array($i, $this->getId(), $fieldInfo[0], $fieldInfo[1]));
if (CustomReportUtils::IsDateField($fieldInfo[0])) {
if (empty($fieldInfo[2])) {
$fieldInfo[2] = 'None';
}
$db->pquery("INSERT INTO vtiger_reportgroupbycolumn(reportid, sortid, sortcolname, dategroupbycriteria)\n VALUES(?,?,?,?)", array($this->getId(), $i, $fieldInfo[0], $fieldInfo[2]));
}
$i++;
}
}
$groupByTime1Sql = 'INSERT INTO vtiger_reportgroupbycolumn(REPORTID,SORTID,SORTCOLNAME,DATEGROUPBYCRITERIA) values(?,?,?,?)';
$groupByTime1Res = $adb->pquery($groupByTime1Sql, array($reportid, 1, $sort_by1, $groupTime1));
}
}
if ($sort_by2 != "") {
$sort_by2sql = "insert into vtiger_reportsortcol (SORTCOLID,REPORTID,COLUMNNAME,SORTORDER) values (?,?,?,?)";
$sort_by2result = $adb->pquery($sort_by2sql, array(2, $reportid, $sort_by2, $sort_order2));
if (CustomReportUtils::IsDateField($sort_by2)) {
$groupByTime2Sql = 'INSERT INTO vtiger_reportgroupbycolumn(REPORTID,SORTID,SORTCOLNAME,DATEGROUPBYCRITERIA) values(?,?,?,?)';
$groupByTime2Res = $adb->pquery($groupByTime2Sql, array($reportid, 2, $sort_by2, $groupTime2));
}
}
if ($sort_by3 != "") {
$sort_by3sql = "insert into vtiger_reportsortcol (SORTCOLID,REPORTID,COLUMNNAME,SORTORDER) values (?,?,?,?)";
$sort_by3result = $adb->pquery($sort_by3sql, array(3, $reportid, $sort_by3, $sort_order3));
if (CustomReportUtils::IsDateField($sort_by3)) {
$groupByTime3Sql = 'INSERT INTO vtiger_reportgroupbycolumn(REPORTID,SORTID,SORTCOLNAME,DATEGROUPBYCRITERIA) values(?,?,?,?)';
$groupByTime3Res = $adb->pquery($groupByTime3Sql, array($reportid, 3, $sort_by3, $groupTime3));
}
}
$log->info("Reports :: Save->Successfully saved vtiger_reportsortcol");
//<<<<step3 vtiger_reportsortcol>>>>>>>
$idelreportdatefiltersql = "delete from vtiger_reportdatefilter where datefilterid=?";
$idelreportdatefiltersqlresult = $adb->pquery($idelreportdatefiltersql, array($reportid));
//<<<<step5 standarfilder>>>>>>>
$ireportmodulesql = "insert into vtiger_reportdatefilter (DATEFILTERID,DATECOLUMNNAME,DATEFILTER,STARTDATE,ENDDATE) values (?,?,?,?,?)";
$ireportmoduleresult = $adb->pquery($ireportmodulesql, array($reportid, $stdDateFilterField, $stdDateFilter, $startdate, $enddate));
$log->info("Reports :: Save->Successfully saved vtiger_reportdatefilter");
//<<<<step5 standarfilder>>>>>>>
//<<<<step4 columnstototal>>>>>>>
$idelreportsummarysql = "delete from vtiger_reportsummary where reportsummaryid=?";
