/** * 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=?";