>>>>>>>> $selectedcolumnstring = $_REQUEST["selectedColumnsString"]; //<<<<<<>>>>>>>> //<<<<<<>>>>>>>> $sort_by1 = decode_html(vtlib_purify($_REQUEST["Group1"])); $sort_order1 = vtlib_purify($_REQUEST["Sort1"]); $sort_by2 =decode_html(vtlib_purify($_REQUEST["Group2"])); $sort_order2 = vtlib_purify($_REQUEST["Sort2"]); $sort_by3 = decode_html(vtlib_purify($_REQUEST["Group3"])); $sort_order3 = vtlib_purify($_REQUEST["Sort3"]); //<<<<<<>>>>>>>> $selectedcolumns = explode(";",$selectedcolumnstring); if(!in_array($sort_by1,$selectedcolumns)){ $selectedcolumns[] = $sort_by1; } if(!in_array($sort_by2,$selectedcolumns)){ $selectedcolumns[] = $sort_by2; } if(!in_array($sort_by3,$selectedcolumns)){ $selectedcolumns[] = $sort_by3; } //<<<<<<>>>>>>>> $pmodule = vtlib_purify($_REQUEST["primarymodule"]); $smodule = vtlib_purify($_REQUEST["secondarymodule"]); //<<<<<<>>>>>>>> //<<<<<<>>>>>>>> $reportname = vtlib_purify($_REQUEST["reportName"]); $reportdescription = vtlib_purify($_REQUEST["reportDesc"]); $reporttype = vtlib_purify($_REQUEST["reportType"]); $folderid = vtlib_purify($_REQUEST["folder"]); //<<<<<<>>>>>>>> //<<<<<<>>>>>>>> $stdDateFilterField = vtlib_purify($_REQUEST["stdDateFilterField"]); $stdDateFilter = vtlib_purify($_REQUEST["stdDateFilter"]); $startdate = getDBInsertDateValue($_REQUEST["startdate"]); $enddate = getDBInsertDateValue($_REQUEST["enddate"]); //<<<<<<>>>>>>>> //<<<<<<>>>>>>>> $sharetype = vtlib_purify($_REQUEST["stdtypeFilter"]); $shared_entities = vtlib_purify($_REQUEST["selectedColumnsStr"]); //<<<<<<>>>>>>>> //<<<<<<>>>>>>>>> $allKeys = array_keys($_REQUEST); for ($i=0;$i>>>>>>>> //<<<<<<>>>>>>> $json = new Zend_Json(); $advft_criteria = $_REQUEST['advft_criteria']; $advft_criteria = $json->decode($advft_criteria); $advft_criteria_groups = $_REQUEST['advft_criteria_groups']; $advft_criteria_groups = $json->decode($advft_criteria_groups); //<<<<<<>>>>>>> if($reportid == "") { $genQueryId = $adb->getUniqueID("vtiger_selectquery"); if($genQueryId != "") { $iquerysql = "insert into vtiger_selectquery (QUERYID,STARTINDEX,NUMOFOBJECTS) values (?,?,?)"; $iquerysqlresult = $adb->pquery($iquerysql, array($genQueryId,0,0)); $log->info("Reports :: Save->Successfully saved vtiger_selectquery"); if($iquerysqlresult!=false) { //<<<>>>>>>> if(!empty($selectedcolumns)) { for($i=0 ;$ipquery($icolumnsql, array($genQueryId,$i,(decode_html($selectedcolumns[$i])))); } } } if($shared_entities != "") { if($sharetype == "Shared") { $selectedcolumn = explode(";",$shared_entities); for($i=0 ;$i< count($selectedcolumn) -1 ;$i++) { $temp = split("::",$selectedcolumn[$i]); $icolumnsql = "insert into vtiger_reportsharing (reportid,shareid,setype) values (?,?,?)"; $icolumnsqlresult = $adb->pquery($icolumnsql, array($genQueryId,$temp[1],$temp[0])); } } } $log->info("Reports :: Save->Successfully saved vtiger_selectcolumn"); //<<<>>>>>>> if($genQueryId != "") { $ireportsql = "insert into vtiger_report (REPORTID,FOLDERID,REPORTNAME,DESCRIPTION,REPORTTYPE,QUERYID,STATE,OWNER,SHARINGTYPE) values (?,?,?,?,?,?,?,?,?)"; $ireportparams = array($genQueryId, $folderid, $reportname, $reportdescription, $reporttype, $genQueryId,'CUSTOM',$current_user->id,$sharetype); $ireportresult = $adb->pquery($ireportsql, $ireportparams); $log->info("Reports :: Save->Successfully saved vtiger_report"); if($ireportresult!=false) { //<<<>>>>>> $ireportmodulesql = "insert into vtiger_reportmodules (REPORTMODULESID,PRIMARYMODULE,SECONDARYMODULES) values (?,?,?)"; $ireportmoduleresult = $adb->pquery($ireportmodulesql, array($genQueryId, $pmodule, $smodule)); $log->info("Reports :: Save->Successfully saved vtiger_reportmodules"); //<<<>>>>>> //<<<>>>>>> if($sort_by1 != "") { $sort_by1sql = "insert into vtiger_reportsortcol (SORTCOLID,REPORTID,COLUMNNAME,SORTORDER) values (?,?,?,?)"; $sort_by1result = $adb->pquery($sort_by1sql, array(1, $genQueryId, $sort_by1, $sort_order1)); } if($sort_by2 != "") { $sort_by2sql = "insert into vtiger_reportsortcol (SORTCOLID,REPORTID,COLUMNNAME,SORTORDER) values (?,?,?,?)"; $sort_by2result = $adb->pquery($sort_by2sql, array(2,$genQueryId,$sort_by2,$sort_order2)); } if($sort_by3 != "") { $sort_by3sql = "insert into vtiger_reportsortcol (SORTCOLID,REPORTID,COLUMNNAME,SORTORDER) values (?,?,?,?)"; $sort_by3result = $adb->pquery($sort_by3sql, array(3,$genQueryId,$sort_by3,$sort_order3)); } $log->info("Reports :: Save->Successfully saved vtiger_reportsortcol"); //<<<>>>>>> //<<<>>>>>> $ireportmodulesql = "insert into vtiger_reportdatefilter (DATEFILTERID,DATECOLUMNNAME,DATEFILTER,STARTDATE,ENDDATE) values (?,?,?,?,?)"; $ireportmoduleresult = $adb->pquery($ireportmodulesql, array($genQueryId, $stdDateFilterField, $stdDateFilter, $startdate, $enddate)); $log->info("Reports :: Save->Successfully saved vtiger_reportdatefilter"); //<<<>>>>>> //<<<>>>>>> for ($i=0;$ipquery($ireportsummarysql, array($genQueryId, $i, $columnstototal[$i])); } $log->info("Reports :: Save->Successfully saved vtiger_reportsummary"); //<<<>>>>>> //<<<>>>>>> foreach($advft_criteria as $column_index => $column_condition) { if(empty($column_condition)) continue; $adv_filter_column = $column_condition["columnname"]; $adv_filter_comparator = $column_condition["comparator"]; $adv_filter_value = $column_condition["value"]; $adv_filter_column_condition = $column_condition["columncondition"]; $adv_filter_groupid = $column_condition["groupid"]; $column_info = explode(":",$adv_filter_column); $temp_val = explode(",",$adv_filter_value); if(($column_info[4] == 'D' || ($column_info[4] == 'T' && $column_info[1] != 'time_start' && $column_info[1] != 'time_end') || ($column_info[4] == 'DT')) && ($column_info[4] != '' && $adv_filter_value != '' )) { $val = Array(); for($x=0;$xpquery($irelcriteriasql, array($genQueryId, $column_index, $adv_filter_column, $adv_filter_comparator, $adv_filter_value, $adv_filter_groupid, $adv_filter_column_condition)); // Update the condition expression for the group to which the condition column belongs $groupConditionExpression = ''; if(!empty($advft_criteria_groups[$adv_filter_groupid]["conditionexpression"])) { $groupConditionExpression = $advft_criteria_groups[$adv_filter_groupid]["conditionexpression"]; } $groupConditionExpression = $groupConditionExpression .' '. $column_index .' '. $adv_filter_column_condition; $advft_criteria_groups[$adv_filter_groupid]["conditionexpression"] = $groupConditionExpression; } foreach($advft_criteria_groups as $group_index => $group_condition_info) { if(empty($group_condition_info)) continue; $irelcriteriagroupsql = "insert into vtiger_relcriteria_grouping(GROUPID,QUERYID,GROUP_CONDITION,CONDITION_EXPRESSION) values (?,?,?,?)"; $irelcriteriagroupresult = $adb->pquery($irelcriteriagroupsql, array($group_index, $genQueryId, $group_condition_info["groupcondition"], $group_condition_info["conditionexpression"])); } $log->info("Reports :: Save->Successfully saved vtiger_relcriteria"); //<<<>>>>>> }else { $errormessage = "Error Message

• Error while inserting the record

" ; echo $errormessage; die; } } }else { $errormessage = "Error Message

• Error while inserting the record

" ; echo $errormessage; die; } echo ''; } }else { if($reportid != "") { if(!empty($selectedcolumns)) { $idelcolumnsql = "delete from vtiger_selectcolumn where queryid=?"; $idelcolumnsqlresult = $adb->pquery($idelcolumnsql, array($reportid)); if($idelcolumnsqlresult != false) { for($i=0 ;$ipquery($icolumnsql, array($reportid,$i,(decode_html($selectedcolumns[$i])))); } } } } $delsharesqlresult = $adb->pquery("DELETE FROM vtiger_reportsharing WHERE reportid=?", array($reportid)); if($delsharesqlresult != false && $sharetype=="Shared" && $shared_entities!='') { $selectedcolumn = explode(";",$shared_entities); for($i=0 ;$i< count($selectedcolumn) -1 ;$i++) { $temp = split("::",$selectedcolumn[$i]); $icolumnsql = "INSERT INTO vtiger_reportsharing (reportid,shareid,setype) VALUES (?,?,?)"; $icolumnsqlresult = $adb->pquery($icolumnsql, array($reportid,$temp[1],$temp[0])); } } //<<<>>>>>> $ireportmodulesql = "UPDATE vtiger_reportmodules SET primarymodule=?,secondarymodules=? WHERE reportmodulesid=?"; $ireportmoduleresult = $adb->pquery($ireportmodulesql, array($pmodule, $smodule,$reportid)); $log->info("Reports :: Save->Successfully saved vtiger_reportmodules"); //<<<>>>>>> $ireportsql = "update vtiger_report set REPORTNAME=?, DESCRIPTION=?, REPORTTYPE=?, SHARINGTYPE=? where REPORTID=?"; $ireportparams = array($reportname, $reportdescription, $reporttype, $sharetype, $reportid); $ireportresult = $adb->pquery($ireportsql, $ireportparams); $log->info("Reports :: Save->Successfully saved vtiger_report"); $idelreportsortcolsql = "delete from vtiger_reportsortcol where reportid=?"; $idelreportsortcolsqlresult = $adb->pquery($idelreportsortcolsql, array($reportid)); $log->info("Reports :: Save->Successfully deleted vtiger_reportsortcol"); if($idelreportsortcolsqlresult!=false) { //<<<>>>>>> if($sort_by1 != "") { $sort_by1sql = "insert into vtiger_reportsortcol (SORTCOLID,REPORTID,COLUMNNAME,SORTORDER) values (?,?,?,?)"; $sort_by1result = $adb->pquery($sort_by1sql, array(1, $reportid, $sort_by1, $sort_order1)); } 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($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)); } $log->info("Reports :: Save->Successfully saved vtiger_reportsortcol"); //<<<>>>>>> $idelreportdatefiltersql = "delete from vtiger_reportdatefilter where datefilterid=?"; $idelreportdatefiltersqlresult = $adb->pquery($idelreportdatefiltersql, array($reportid)); //<<<>>>>>> $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"); //<<<>>>>>> //<<<>>>>>> $idelreportsummarysql = "delete from vtiger_reportsummary where reportsummaryid=?"; $idelreportsummarysqlresult = $adb->pquery($idelreportsummarysql, array($reportid)); for ($i=0;$ipquery($ireportsummarysql, array($reportid, $i, $columnstototal[$i])); } $log->info("Reports :: Save->Successfully saved vtiger_reportsummary"); //<<<>>>>>> //<<<>>>>>> $idelrelcriteriasql = "delete from vtiger_relcriteria where queryid=?"; $idelrelcriteriasqlresult = $adb->pquery($idelrelcriteriasql, array($reportid)); $idelrelcriteriagroupsql = "delete from vtiger_relcriteria_grouping where queryid=?"; $idelrelcriteriagroupsqlresult = $adb->pquery($idelrelcriteriagroupsql, array($reportid)); foreach($advft_criteria as $column_index => $column_condition) { if(empty($column_condition)) continue; $adv_filter_column = $column_condition["columnname"]; $adv_filter_comparator = $column_condition["comparator"]; $adv_filter_value = $column_condition["value"]; $adv_filter_column_condition = $column_condition["columncondition"]; $adv_filter_groupid = $column_condition["groupid"]; $column_info = explode(":",$adv_filter_column); $temp_val = explode(",",$adv_filter_value); if(($column_info[4] == 'D' || ($column_info[4] == 'T' && $column_info[1] != 'time_start' && $column_info[1] != 'time_end') || ($column_info[4] == 'DT')) && ($column_info[4] != '' && $adv_filter_value != '' )) { $val = Array(); for($x=0;$xpquery($irelcriteriasql, array($reportid, $column_index, $adv_filter_column, $adv_filter_comparator, $adv_filter_value, $adv_filter_groupid, $adv_filter_column_condition)); // Update the condition expression for the group to which the condition column belongs $groupConditionExpression = ''; if(!empty($advft_criteria_groups[$adv_filter_groupid]["conditionexpression"])) { $groupConditionExpression = $advft_criteria_groups[$adv_filter_groupid]["conditionexpression"]; } $groupConditionExpression = $groupConditionExpression .' '. $column_index .' '. $adv_filter_column_condition; $advft_criteria_groups[$adv_filter_groupid]["conditionexpression"] = $groupConditionExpression; } foreach($advft_criteria_groups as $group_index => $group_condition_info) { if(empty($group_condition_info)) continue; $irelcriteriagroupsql = "insert into vtiger_relcriteria_grouping(GROUPID,QUERYID,GROUP_CONDITION,CONDITION_EXPRESSION) values (?,?,?,?)"; $irelcriteriagroupresult = $adb->pquery($irelcriteriagroupsql, array($group_index, $reportid, $group_condition_info["groupcondition"], $group_condition_info["conditionexpression"])); } $log->info("Reports :: Save->Successfully saved vtiger_relcriteria"); //<<<>>>>>> }else { $errormessage = "Error Message

• Error while inserting the record

" ; echo $errormessage; die; } }else { $errormessage = "Error Message

• Error while inserting the record

" ; echo $errormessage; die; } echo ''; } ?>