$qry_check_userexist = "select cd.*,rd.* from cs_companydetails as cd \n\t\tleft join cs_resellerdetails as rd on cd.reseller_id = rd.reseller_id\n\t\t where cd.userId='{$userid}' {$bank_sql_limit}";
$result = mysql_query($qry_check_userexist) or dieLog(mysql_error() . " ~ {$qry_check_userexist}");
$companyInfo = mysql_fetch_assoc($result);
$completion = "";
$bank_update_sql = "";
if ($strUnsubscribe != $companyInfo['send_mail']) {
if ($strUnsubscribe) {
removeListEmail($companyInfo['email']);
removeListEmail($companyInfo['contact_email']);
} else {
addListEmail($companyInfo['email'], "Admin Unsubscribed Email", $companyInfo['userId'], 'merchant', 'unsubscribe');
addListEmail($companyInfo['contact_email'], "Admin Unsubscribed Email", $companyInfo['userId'], 'merchant', 'unsubscribe');
}
}
if ($cd_custom_contract && !$companyInfo['cd_custom_contract']) {
$contract = genMerchantContract(&$companyInfo);
$sql = "insert into cs_email_templates set et_name='merchant_contract', et_custom_id='" . $companyInfo['userId'] . "', et_title='" . quote_smart($companyInfo['companyname']) . " Contract', et_access='admin', et_to_title='" . quote_smart($companyInfo['companyname']) . "', et_subject='Custom Merchant Contract for " . quote_smart($companyInfo['companyname']) . "', et_htmlformat='" . quote_smart($contract['et_htmlformat']) . "', et_catagory='Merchant'";
$result = mysql_query($sql) or etelPrint(mysql_error());
$cd_custom_contract = mysql_insert_id();
} else {
if (!$cd_custom_contract && $companyInfo['cd_custom_contract']) {
$sql = "delete from cs_email_templates where et_name='merchant_contract' and et_custom_id='" . $companyInfo['userId'] . "'";
$result = mysql_query($sql) or dieLog(mysql_error());
$cd_custom_contract = 'null';
} else {
$cd_custom_contract = intval($companyInfo['cd_custom_contract']);
}
}
if ($cd_merchant_show_contract == 1 && $companyInfo['cd_completion'] <= 3) {
$completion = ' cd_completion=4, ';
}
$access['Data']['cd_previous_processor']['DisplayName'] = "Previous Processor";
$access['Data']['cd_processing_reason']['DisplayName'] = "Reason for Leaving Previous Processor";
$access['Data']['recurbilling']['DisplayName'] = "Recuring Billing";
$access['Data']['currprocessing']['DisplayName'] = "Currently Processing";
$access['Data']['userId']['Input'] = "hidden";
$access['Data']['userId']['disable'] = 1;
// Actions
if ($_POST['submit_access'] == 'Submit') {
if ($_POST['Email_Contract_Notification'] && $access['Data']['send_mail']['Value'] == 1) {
send_email_template('contract_notification_email', $data);
}
if ($_POST['Email_Active_Notification'] && $access['Data']['send_mail']['Value'] == 1) {
send_email_template('active_notification_email', $data);
}
if ($_POST['cd_custom_contract'] && !$access['Data']['cd_custom_contract']['Value']) {
$contract = genMerchantContract($company_id);
$sql = "insert into cs_email_templates \n\t\t\tset et_name='merchant_contract', \n\t\t\tet_custom_id='" . $company_id . "', \n\t\t\tet_title='" . quote_smart($access['Data']['companyname']['Value']) . " Contract', \n\t\t\tet_access='admin', \n\t\t\tet_to_title='" . quote_smart($access['Data']['companyname']['Value']) . "', \n\t\t\tet_subject='Custom Merchant Contract for " . quote_smart($access['Data']['companyname']['Value']) . "', \n\t\t\tet_htmlformat='" . quote_smart($contract['et_htmlformat']) . "', \n\t\t\tet_catagory='Merchant'";
$result = sql_query_write($sql) or dieLog(mysql_error() . " ~ sql");
$_POST['cd_custom_contract'] = mysql_insert_id();
} else {
if (!$_POST['cd_custom_contract'] && $access['Data']['cd_custom_contract']['Value']) {
$sql = "delete from cs_email_templates where et_name='merchant_contract' and et_custom_id='" . $company_id . "'";
$result = sql_query_write($sql) or dieLog(mysql_error() . " ~ sql");
$access['Data']['cd_custom_contract']['AddHtml'] = NULL;
}
}
}
// Submit
if ($_POST['submit_access'] == 'Submit') {
$result = processAccessForm(&$access);
if ($result) {
