id = $_REQUEST['record']; } if(isset($_REQUEST['mode'])) { $focus->mode = $_REQUEST['mode']; } foreach($focus->column_fields as $fieldname => $val) { if(isset($_REQUEST[$fieldname])) { $value = $_REQUEST[$fieldname]; $focus->column_fields[$fieldname] = $value; } } //$focus->saveentity("Potentials"); $focus->save("Potentials"); $return_id = $focus->id; if(isset($_REQUEST['return_module']) && $_REQUEST['return_module'] != "") $return_module = $_REQUEST['return_module']; else $return_module = "Potentials"; if(isset($_REQUEST['return_action']) && $_REQUEST['return_action'] != "") $return_action = $_REQUEST['return_action']; else $return_action = "DetailView"; if(isset($_REQUEST['return_id']) && $_REQUEST['return_id'] != "") $return_id = $_REQUEST['return_id']; $local_log->debug("Saved record with id of ".$return_id); header("Location: index.php?action=$return_action&module=$return_module&record=$return_id"); //Code to save the custom field info into database function save_customfields($entity_id) { global $adb; $dbquery="select * from customfields where module='Potentials'"; $result = $adb->query($dbquery); $custquery = "select * from potentialscf where potentialid='".$entity_id."'"; $cust_result = $adb->query($custquery); if($adb->num_rows($result) != 0) { $columns=''; $values=''; $update=''; $noofrows = $adb->num_rows($result); for($i=0; $i<$noofrows; $i++) { $fldName=$adb->query_result($result,$i,"fieldlabel"); $colName=$adb->query_result($result,$i,"column_name"); if(isset($_REQUEST[$colName])) { $fldvalue=$_REQUEST[$colName]; if(get_magic_quotes_gpc() == 1) { $fldvalue = stripslashes($fldvalue); } } else { $fldvalue = ''; } if(isset($_REQUEST['record']) && $_REQUEST['record'] != '' && $adb->num_rows($cust_result) !=0) { //Update Block if($i == 0) { $update = $colName.'="'.$fldvalue.'"'; } else { $update .= ', '.$colName.'="'.$fldvalue.'"'; } } else { //Insert Block if($i == 0) { $columns='potentialid, '.$colName; $values='"'.$entity_id.'", "'.$fldvalue.'"'; } else { $columns .= ', '.$colName; $values .= ', "'.$fldvalue.'"'; } } } if(isset($_REQUEST['record']) && $_REQUEST['record'] != '' && $adb->num_rows($cust_result) !=0) { //Update Block $query = 'update potentialscf SET '.$update.' where potentialid="'.$entity_id.'"'; $adb->query($query); } else { //Insert Block $query = 'insert into potentialscf ('.$columns.') values('.$values.')'; $adb->query($query); } } /* srini patch else { if(isset($_REQUEST['record']) && $_REQUEST['record'] != '' && $adb->num_rows($cust_result) !=0) { //Update Block } else { //Insert Block $query = 'insert into opportunitycf ('.$columns.') values('.$values.')'; $adb->query($query); } }*/ } ?>