pquery($query, $params); if($adb->num_rows($result) > 0) { echo $mod_strings['LBL_ACCOUNT_EXIST']; } else { echo 'SUCCESS'; } die; } //Ended $local_log =& LoggerManager::getLogger('index'); global $log; $focus = new Accounts(); global $current_user; $currencyid=fetchCurrency($current_user->id); $rate_symbol = getCurrencySymbolandCRate($currencyid); $rate = $rate_symbol['rate']; $curr_symbol = $rate_symbol['symbol']; if(isset($_REQUEST['record'])) { $focus->id = $_REQUEST['record']; $log->info("id is ".$focus->id); } if(isset($_REQUEST['mode'])) { $focus->mode = $_REQUEST['mode']; } foreach($focus->column_fields as $fieldname => $val) { if(isset($_REQUEST[$fieldname])) { if(is_array($_REQUEST[$fieldname])) $value = $_REQUEST[$fieldname]; else $value = trim($_REQUEST[$fieldname]); $log->DEBUG($fieldname."=Field Name &first& Value =".$value); $focus->column_fields[$fieldname] = $value; } } if($_REQUEST['assigntype'] == 'U') { $focus->column_fields['assigned_user_id'] = $_REQUEST['assigned_user_id']; } elseif($_REQUEST['assigntype'] == 'T') { $focus->column_fields['assigned_user_id'] = $_REQUEST['assigned_group_id']; } //When changing the Account Address Information it should also change the related contact address - dina if($focus->mode == 'edit' && $_REQUEST['address_change'] == 'yes') { $query = "update vtiger_contactaddress set mailingcity=?,mailingstreet=?,mailingcountry=?,mailingzip=?,mailingpobox=?,mailingstate=?,othercountry=?,othercity=?,otherstate=?,otherzip=?,otherstreet=?,otherpobox=? where contactaddressid in (select contactid from vtiger_contactdetails where accountid=?)" ; $params = array($focus->column_fields['bill_city'], $focus->column_fields['bill_street'], $focus->column_fields['bill_country'], $focus->column_fields['bill_code'], $focus->column_fields['bill_pobox'], $focus->column_fields['bill_state'], $focus->column_fields['ship_country'], $focus->column_fields['ship_city'], $focus->column_fields['ship_state'], $focus->column_fields['ship_code'], $focus->column_fields['ship_street'], $focus->column_fields['ship_pobox'], $focus->id); $adb->pquery($query, $params); } //Changing account address - Ends $focus->save("Accounts"); if(isset($_REQUEST['return_module']) && $_REQUEST['return_module'] == "Campaigns") { if(isset($_REQUEST['return_id']) && $_REQUEST['return_id'] != "") { $campAccStatusResult = $adb->pquery("select campaignrelstatusid from vtiger_campaignaccountrel where campaignid=? AND accountid=?",array($_REQUEST['return_id'], $focus->id)); $accountStatus = $adb->query_result($campAccStatusResult,0,'campaignrelstatusid'); $sql = "delete from vtiger_campaignaccountrel where accountid = ?"; $adb->pquery($sql, array($focus->id)); if(isset($accountStatus) && $accountStatus!=''){ $sql = "insert into vtiger_campaignaccountrel values (?,?,?)"; $adb->pquery($sql, array($_REQUEST['return_id'], $focus->id,$accountStatus)); } else{ $sql = "insert into vtiger_campaignaccountrel values (?,?,1)"; $adb->pquery($sql, array($_REQUEST['return_id'], $focus->id)); } } } $return_id = $focus->id; $parenttab = getParentTab(); if(isset($_REQUEST['return_module']) && $_REQUEST['return_module'] != "") $return_module = vtlib_purify($_REQUEST['return_module']); else $return_module = "Accounts"; if(isset($_REQUEST['return_action']) && $_REQUEST['return_action'] != "") $return_action = vtlib_purify($_REQUEST['return_action']); else $return_action = "DetailView"; if(isset($_REQUEST['return_id']) && $_REQUEST['return_id'] != "") $return_id = vtlib_purify($_REQUEST['return_id']); $local_log->debug("Saved record with id of ".$return_id); //code added for returning back to the current view after edit from list view if($_REQUEST['return_viewname'] == '') $return_viewname='0'; if($_REQUEST['return_viewname'] != '')$return_viewname=vtlib_purify($_REQUEST['return_viewname']); header("Location: index.php?action=$return_action&module=$return_module&parenttab=$parenttab&record=$return_id&viewname=$return_viewname&start=".vtlib_purify($_REQUEST['pagenumber']).$search); /** Function to save Accounts custom field info into database * @param integer $entity_id - accountid */ function save_customfields($entity_id) { global $log; $log->debug("Entering save_customfields(".$entity_id.") method ..."); $log->info("save customfields invoked"); global $adb; $dbquery = "SELECT * FROM customfields WHERE module = 'Accounts'"; $result = $adb->pquery($dbquery, array()); $custquery = "SELECT * FROM vtiger_accountcf WHERE vtiger_accountid = ?"; $cust_result = $adb->pquery($custquery, array($entity_id)); if($adb->num_rows($result) != 0) { $columns=''; $values=''; $ins_params = array(); $update=''; $upd_params = array(); $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."=?"; array_push($upd_params, $fldvalue); } else { $update .= ', '.$colName."=?"; array_push($upd_params, $fldvalue); } } else { //Insert Block if($i == 0) { $columns='accountid, '.$colName; array_push($ins_params, $entity_id, $fldvalue); } else { $columns .= ', '.$colName; array_push($ins_params, $fldvalue); } } } if(isset($_REQUEST['record']) && $_REQUEST['record'] != '' && $adb->num_rows($cust_result) !=0) { //Update Block $query = "UPDATE vtiger_accountcf SET $update WHERE vtiger_accountid=?"; array_push($upd_params, $entity_id); $adb->pquery($query, $upd_params); } else { //Insert Block $query = "INSERT INTO vtiger_accountcf ($columns) VALUES(" . generateQuestionMarks($ins_params) .")"; $adb->pquery($query, $ins_params); } } $log->debug("Exiting save_customfields method ..."); } ?>