id; if(isset($_REQUEST["setDefault"])) { $setdefault = 1; } else { $setdefault = 0; } if(isset($_REQUEST["setMetrics"])) { $setmetrics = 1; } else { $setmetrics = 0; } //$allKeys = array_keys($HTTP_POST_VARS); //this is will cause only the chosen fields to be added to the vtiger_cvcolumnlist table $allKeys = array_keys($_REQUEST); //<<<<<<>>>>>>>>> for ($i=0;$i>>>>>>>> //<<<<<<>>>>>>>> $stdfiltercolumn = $_REQUEST["stdDateFilterField"]; $std_filter_list["columnname"] = $stdfiltercolumn; $stdcriteria = $_REQUEST["stdDateFilter"]; $std_filter_list["stdfilter"] = $stdcriteria; $startdate = $_REQUEST["startdate"]; $enddate = $_REQUEST["enddate"]; if($stdcriteria == "custom") { $startdate = getDBInsertDateValue($startdate); $enddate = getDBInsertDateValue($enddate); } $std_filter_list["startdate"] = $startdate; $std_filter_list["enddate"]=$enddate; if(empty($startdate) && empty($enddate)) unset($std_filter_list); //<<<<<<>>>>>>>> //<<<<<<>>>>>>>> for ($i=0;$i>>>>>>> if(!$cvid) { $genCVid = $adb->getUniqueID("vtiger_customview"); if($genCVid != "") { $customviewsql = "INSERT INTO vtiger_customview(cvid, viewname, setdefault, setmetrics, entitytype, status, userid) VALUES (?,?,?,?,?,?,?)"; $customviewparams = array($genCVid, $viewname, 0, $setmetrics, $cvmodule, $status, $userid); $customviewresult = $adb->pquery($customviewsql, $customviewparams); $log->info("CustomView :: Save :: vtiger_customview created successfully"); if($setdefault == 1) { $sql_result = $adb->pquery("SELECT * FROM vtiger_user_module_preferences WHERE userid = ? and tabid = ?",array($current_user->id, $cv_tabid)); if($adb->num_rows($sql_result) > 0) { $updatedefaultsql = "UPDATE vtiger_user_module_preferences SET default_cvid = ? WHERE userid = ? and tabid = ?"; $updatedefaultresult = $adb->pquery($updatedefaultsql, array($genCVid, $current_user->id, $cv_tabid)); } else { $insertdefaultsql = "INSERT INTO vtiger_user_module_preferences(userid, tabid, default_cvid) values (?,?,?)"; $insertdefaultresult = $adb->pquery($insertdefaultsql, array($userid, $cv_tabid, $genCVid)); } } else { $sql_result = $adb->pquery("SELECT * FROM vtiger_user_module_preferences WHERE userid = ? and tabid = ?",array($current_user->id, $cv_tabid)); if($adb->num_rows($sql_result) > 0) { $deletedefaultsql = "DELETE FROM vtiger_user_module_preferences WHERE userid = ? and tabid = ?"; $deletedefaultresult = $adb->pquery($deletedefaultsql, array($current_user->id, $cv_tabid)); } } $log->info("CustomView :: Save :: setdefault upated successfully"); if($customviewresult) { if(isset($columnslist)) { for($i=0;$ipquery($columnsql, $columnparams); } $log->info("CustomView :: Save :: vtiger_cvcolumnlist created successfully"); if($std_filter_list["columnname"] !="") { $stdfiltersql = "INSERT INTO vtiger_cvstdfilter(cvid,columnname,stdfilter,startdate,enddate) VALUES (?,?,?,?,?)"; $stdfilterparams = array($genCVid, $std_filter_list["columnname"], $std_filter_list["stdfilter"], $adb->formatDate($std_filter_list["startdate"], true), $adb->formatDate($std_filter_list["enddate"], true)); $stdfilterresult = $adb->pquery($stdfiltersql, $stdfilterparams); $log->info("CustomView :: Save :: vtiger_cvstdfilter created successfully"); } for($i=0;$ipquery($advfiltersql, $advfilterparams); } $log->info("CustomView :: Save :: vtiger_cvadvfilter created successfully"); } } $cvid = $genCVid; } } else { if($is_admin == true || $current_user->id) { $updatecvsql = "UPDATE vtiger_customview SET viewname = ?, setmetrics = ?, status = ? WHERE cvid = ?"; $updatecvparams = array($viewname, $setmetrics, $status, $cvid); $updatecvresult = $adb->pquery($updatecvsql, $updatecvparams); $log->info("CustomView :: Save :: vtiger_customview upated successfully".$cvid); if($setdefault == 1) { $sql_result = $adb->pquery("SELECT * FROM vtiger_user_module_preferences WHERE userid = ? and tabid = ?",array($current_user->id, $cv_tabid)); if($adb->num_rows($sql_result) > 0) { $updatedefaultsql = "UPDATE vtiger_user_module_preferences SET default_cvid = ? WHERE userid = ? and tabid = ?"; $updatedefaultresult = $adb->pquery($updatedefaultsql, array($cvid, $current_user->id, $cv_tabid)); } else { $insertdefaultsql = "INSERT INTO vtiger_user_module_preferences(userid, tabid, default_cvid) values (?,?,?)"; $insertdefaultresult = $adb->pquery($insertdefaultsql, array($userid, $cv_tabid, $cvid)); } } else { $sql_result = $adb->pquery("SELECT * FROM vtiger_user_module_preferences WHERE userid = ? and tabid = ?",array($current_user->id, $cv_tabid)); if($adb->num_rows($sql_result) > 0) { $deletedefaultsql = "DELETE FROM vtiger_user_module_preferences WHERE userid = ? and tabid = ?"; $deletedefaultresult = $adb->pquery($deletedefaultsql, array($current_user->id, $cv_tabid)); } } $log->info("CustomView :: Save :: setdefault upated successfully".$cvid); $deletesql = "DELETE FROM vtiger_cvcolumnlist WHERE cvid = ?"; $deleteresult = $adb->pquery($deletesql, array($cvid)); $deletesql = "DELETE FROM vtiger_cvstdfilter WHERE cvid = ?"; $deleteresult = $adb->pquery($deletesql, array($cvid)); $deletesql = "DELETE FROM vtiger_cvadvfilter WHERE cvid = ?"; $deleteresult = $adb->pquery($deletesql, array($cvid)); $log->info("CustomView :: Save :: vtiger_cvcolumnlist,cvstdfilter,cvadvfilter deleted successfully before update".$genCVid); $genCVid = $cvid; if($updatecvresult) { if(isset($columnslist)) { for($i=0;$ipquery($columnsql, $columnparams); } $log->info("CustomView :: Save :: vtiger_cvcolumnlist update successfully".$genCVid); if($std_filter_list["columnname"] !="") { $stdfiltersql = "INSERT INTO vtiger_cvstdfilter (cvid,columnname,stdfilter,startdate,enddate) VALUES (?,?,?,?,?)"; $stdfilterparams = array($genCVid, $std_filter_list["columnname"], $std_filter_list["stdfilter"], $adb->formatDate($std_filter_list["startdate"], true), $adb->formatDate($std_filter_list["enddate"], true)); $stdfilterresult = $adb->pquery($stdfiltersql, $stdfilterparams); $log->info("CustomView :: Save :: vtiger_cvstdfilter update successfully".$genCVid); } for($i=0;$ipquery($advfiltersql, $advfilterparams); } $log->info("CustomView :: Save :: vtiger_cvadvfilter update successfully".$cvid); } } } } } header("Location: index.php?action=$return_action&parenttab=$parenttab&module=$cvmodule&viewname=$cvid"); ?>