<?php
$headerInclude = 'subgatewayusers';
include 'includes/sessioncheck.php';
require_once "../includes/updateAccess.php";
include 'includes/header.php';
$userId = intval($_REQUEST['userIdList'] ? $_REQUEST['userIdList'] : $_REQUEST['userId']);
//$access = getMerchantAccess();
$access = getAccessInfo("\n\nuserId,\n\n'General Info' as access_header,\nReferenceNumber, transaction_type, username, password, companyname, reseller_id, email, phonenumber,address,city,state,country,zipcode,\nfax_number,how_about_us,company_type, legal_name, incorporated_country, incorporated_number,fax_dba,physical_address,\ncellular,technical_contact_details,admin_contact_details,\n\n'Personal Info' as access_header,\nfirst_name,family_name,job_title,contact_email,contact_phone,stitle,sdateofbirth,\nssex,sAddress,sPostCode,sResidenceTelephone,sFax,\n\n'Processing Info' as access_header,\ngoods_list, max_ticket_amt,min_ticket_amt,volume_last_month,volume_prev_30days,volume_prev_60days,totals,forecast_volume_1month,\nforecast_volume_2month,forecast_volume_3month,current_anti_fraud_system,customer_service_program,refund_policy\n\n", "cs_companydetails", "userId = {$userId} and cd_subgateway_id = '" . $resellerInfo['reseller_id'] . "'");
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$access['Data']['how_about_us']['DisplayName'] = "How did you hear about us?";
$access['Data']['sAddress']['DisplayName'] = "Address";
$access['Data']['sPostCode']['DisplayName'] = "ZipCode";
$access['Data']['sResidenceTelephone']['DisplayName'] = "Home Phone";
$access['Data']['sFax']['DisplayName'] = "Home Fax";
$access['Data']['sPostCode']['DisplayName'] = "ZipCode";
$access['Data']['stitle']['DisplayName'] = "Title";
$access['Data']['sdateofbirth']['DisplayName'] = "Date of Birth";
$access['Data']['ssex']['DisplayName'] = "Sex";
$access['Data']['username']['disable'] = 1;
$access['Data']['ReferenceNumber']['disable'] = 1;
$access['Data']['transaction_type']['disable'] = 1;
$access['Data']['volume_last_month']['Input'] = "selectvolume";
$access['Data']['volume_prev_30days']['Input'] = "selectvolume";
$access['Data']['volume_prev_60days']['Input'] = "selectvolume";
$access['Data']['forecast_volume_1month']['Input'] = "selectvolume";
$access['Data']['forecast_volume_2month']['Input'] = "selectvolume";
$access['Data']['forecast_volume_3month']['Input'] = "selectvolume";
$access['Data']['userId']['Input'] = "hidden";
<td><a href="confirmUploads.php?userIdList=<?php
echo $company_id;
?>
&searchby=id&search=<?php
echo $company_id;
?>
"><IMG SRC="<?php
echo $tmpl_dir;
?>
/images/uploadown_tab.gif" WIDTH="128" HEIGHT="32" BORDER="0" ALT=""></a></td>
</tr>
</table>
<?php
$access['SerializedData']['Source'] = 'en_info';
$access['SerializedData']['Data'] = array('General_Notes' => array('General_Notes'));
$access = getAccessInfo("\n\nuserId,\nen_ID,\nen_info,\n\n'Merchant Status' as access_header,\n\nactiveuser,\n0 as Email_Active_Notification,\n\nen_pay_type,\nen_pay_data,\n\n'Merchant Contract' as access_header,\nen_company,\ncd_merchant_show_contract,\n0 as Email_Contract_Notification,\n cd_custom_contract, \ncd_completion,\n\n'Notes' as access_header_spanned,\n1 as 'General_Notes'\n", "cs_entities left join cs_companydetails on en_type='merchant' and en_type_ID = userId", "en_ID = '{$en_ID}'", array('Size' => 30, 'Rows' => 2), $access);
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$company_id = $access['Data']['userId']['Value'];
$en_ID = $access['Data']['en_ID']['Value'];
$sql = "Select en_ID,en_company From cs_entities, cs_entities_affiliates where en_ID = ea_affiliate_ID and ea_type = 'Reseller' and ea_en_ID = '{$en_ID}'";
$result = sql_query_read($sql) or dieLog($sql);
while ($aff = mysql_fetch_assoc($result)) {
$ress[$aff['en_ID']] = $aff['en_company'];
}
if (!sizeof($ress)) {
$ress[''] = 'No Reseller';
}
$access['Data']['en_pay_type']['DisplayName'] = 'Pay Mode';
$access['Data']['en_pay_data']['AddHtml'] = "<span class='small'><br>Monthly (1-28) ('1,15' = paid 1st and 15th)<br>OR Weekly (0-6) ('1,5' = paid Mon and Fri)</span>";
//******************************************************************//
// This file is part of the Skillshire development package. //
// Copyright (C) Company Setup 2003-2004, All Rights Reserved. //
// //
//******************************************************************//
// Package: Skillshire
// Description: Online Company Setup
// Files: index.php,home.php,cheque.php,creditcard.php,report.php,reportBottom.php, reportBottomSummary.php,companyEdit.php
// config.php,useraccount.php,viewCompany.php,topheader.php,ViewreportPage.php,addcheque.php,blank.php,profile_blank.php
// VT_blank.php,creditcardfb.php,customerservice_blank.php,report_custom.php,callback.php,ledger.php
// useraccount.php: The page functions for the company account editing.
include 'includes/sessioncheck.php';
$headerInclude = "profile";
include 'includes/header.php';
$access = getAccessInfo("\n\t\n\ten_username as 'User Name', en_password as 'Enter_Old_Password' ,en_password, en_password as 'Confirm_New_Password'\n\t\n\t\n\t", "cs_entities ", "en_ID = '" . $companyInfo['en_ID'] . "'", array('Size' => 30, 'Valid' => 'req', 'ExcludeQuery' => true), $access);
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$access['Data']['User Name']['disable'] = true;
$access['Data']['en_password']['DisplayName'] = 'Enter New Password';
$access['Data']['en_password']['Input'] = 'password';
$access['Data']['en_password']['Valid'] = 'password';
$access['Data']['Confirm_New_Password']['Input'] = 'password';
$access['Data']['Confirm_New_Password']['Valid'] = 'confirm|en_password';
$access['Data']['Enter_Old_Password']['Input'] = 'password';
$access['Data']['Enter_Old_Password']['Valid'] = 'password';
if ($_POST['en_password']) {
if ($_POST['en_password'] != $_POST['Confirm_New_Password']) {
unset($_POST['en_password']);
}
<?php
$headerInclude = 'subgatewayusers';
include 'includes/sessioncheck.php';
require_once "../includes/updateAccess.php";
include 'includes/header.php';
$reseller_id = intval($_REQUEST['reselIdList'] ? $_REQUEST['reselIdList'] : $_REQUEST['reseller_id']);
//$access = getMerchantAccess();
$access = getAccessInfo("\nreseller_id,\n\n'General Info' as access_header,\n rd_referenceNumber,reseller_username, reseller_password, reseller_companyname, reseller_contactname, reseller_url, reseller_email, reseller_phone,\n\n'Personal Info' as access_header,\nreseller_firstname,reseller_lastname,reseller_jobtitle,reseller_title,\nreseller_sex,reseller_address,reseller_zipcode,reseller_res_phone,reseller_faxnumber,\n\n'Processing Info' as access_header,\nreseller_monthly_volume\n\n", "cs_resellerdetails", "reseller_id = {$reseller_id} and rd_subgateway_id = '" . $resellerInfo['reseller_id'] . "'");
if ($access == -1) {
dieLog("Invalid Reseller", "Invalid Reseller");
}
$access['Data']['reseller_username']['disable'] = 1;
$access['Data']['rd_referenceNumber']['disable'] = 1;
$access['Data']['reseller_monthly_volume']['Input'] = "selectvolume";
$access['Data']['reseller_id']['Input'] = "hidden";
$access['Data']['reseller_id']['disable'] = 1;
foreach ($access['Data'] as $key => $data) {
$access['Data'][$key]['DisplayName'] = str_replace('Reseller ', '', $data['DisplayName']);
}
if ($_POST['submit_access'] == 'Submit') {
$result = processAccessForm(&$access);
if ($result) {
$msg = "Reseller Updated Successfully ({$result} Field(s))";
} else {
$msg = "No Updates Detected";
}
}
$access['HeaderMessage'] = $msg;
beginTable();
writeAccessForm(&$access);
}
}
if (is_array($gw_options)) {
if (sizeof($gw_options) < 2) {
$gw_options = NULL;
}
}
}
$search = "userId = {$company_id}";
if ($en_ID) {
$search = "en_ID = {$en_ID}";
}
//$access = getMerchantAccess();
$access['SerializedData']['Source'] = 'en_info';
$access['SerializedData']['Data'] = array('General_Notes' => array('General_Notes'), 'Company_Url' => array('General_Info', 'Company_Url'), 'Company_Legal_Name' => array('General_Info', 'Company_Legal_Name'), 'Company_Address' => array('General_Info', 'Company_Address'), 'Company_Fax_DBA' => array('General_Info', 'Company_Fax_DBA'), 'Company_Tech_Contact' => array('General_Info', 'Company_Tech_Contact'), 'Incorporated_Country' => array('General_Info', 'Incorporated_Country'), 'Incorporated_Number' => array('General_Info', 'Incorporated_Number'), 'Sex' => array('General_Info', 'Sex'), 'Date_of_Birth' => array('General_Info', 'Date_of_Birth'), 'Address' => array('General_Info', 'Address'), 'Zip_Code' => array('General_Info', 'Zip_Code'), 'City' => array('General_Info', 'City'), 'State' => array('General_Info', 'State'), 'Country' => array('General_Info', 'Country'), 'Contact_Phone' => array('General_Info', 'Contact_Phone'), 'Cell_Phone' => array('General_Info', 'Cell_Phone'), 'Contact_IM' => array('General_Info', 'Contact_IM'), 'Time_Zone' => array('General_Info', 'Time_Zone'), 'Contact_Fax' => array('General_Info', 'Contact_Fax'), 'Personal_Phone' => array('General_Info', 'Personal_Phone'), 'Personal_Fax' => array('General_Info', 'Personal_Fax'), 'Hear_About_Us' => array('General_Info', 'Hear_About_Us'), 'Service_List' => array('Processing_Info', 'Service_List'), 'Anti_Fraud_System' => array('Processing_Info', 'Anti_Fraud_System'), 'CS_Program' => array('Processing_Info', 'CS_Program'), 'Refund_Policy' => array('Processing_Info', 'Refund_Policy'), 'Volume_Last_month' => array('Processing_Info', 'Volume_Last_month'), 'Volume_Prev_30Days' => array('Processing_Info', 'Volume_Prev_30Days'), 'Volume_Prev_60Days' => array('Processing_Info', 'Volume_Prev_60Days'), 'Volume_Forcast_1Month' => array('Processing_Info', 'Volume_Forcast_1Month'), 'Volume_Forcast_2Month' => array('Processing_Info', 'Volume_Forcast_2Month'), 'Volume_Forcast_3Month' => array('Processing_Info', 'Volume_Forcast_3Month'), 'Projected_Monthly_Sales' => array('Processing_Info', 'Projected_Monthly_Sales'), 'Average_Ticket_Price' => array('Processing_Info', 'Average_Ticket_Price'), 'Chargeback_%' => array('Processing_Info', 'Chargeback_%'), 'Previous_Processor_Trans_Fee' => array('Processing_Info', 'Previous_Processor_Trans_Fee'), 'Previous_Processor_Disc_Fee' => array('Processing_Info', 'Previous_Processor_Disc_Fee'), 'Previous_Processing' => array('Processing_Info', 'Previous_Processing'), 'Previous_Processor_Reason' => array('Processing_Info', 'Previous_Processor_Reason'), 'Recur_Billing' => array('Processing_Info', 'Recur_Billing'), 'Currently_Processing' => array('Processing_Info', 'Currently_Processing'));
$access = getAccessInfo("\r\n\r\nuserId,\r\nen_ID,\r\nen_info,\r\n\r\n\r\n'General Info' as access_header,\r\nen_username, en_password,\r\nen_ref, 1 as Merchant_Websites, 1 as Merchant_Documents, 1 as Merchant_Payouts, en_company,1 as 'Company_Url' ,\r\n\r\nen_email, 1 as 'Contact_Phone',1 as 'Company_Tech_Contact', 1 as 'Contact_IM',1 as 'Time_Zone', 1 as 'Contact_Fax', 1 as 'Company_Fax_DBA',1 as 'Company_Address',1 as 'Hear_About_Us' ,\r\n\r\n'Personal Info' as access_header,\r\nen_firstname,en_lastname,1 as 'Date_of_Birth',\r\n1 as 'Sex',1 as 'Address',1 as 'City', 1 as 'State', 1 as 'Country',1 as 'Zip_Code',1 as 'Personal_Phone',1 as 'Personal_Fax', 1 as 'Cell_Phone',\r\n\r\n\r\n'Processing/Company Info' as access_header,\r\n transaction_type as 'Transaction_Type', 1 as 'Company_Legal_Name', 1 as 'Incorporated_Country', 1 as 'Incorporated_Number', 1 as 'Previous_Processing', 1 as 'Previous_Processor_Reason', 1 as 'Previous_Processor_Disc_Fee', 1 as 'Previous_Processor_Trans_Fee', 1 as 'Chargeback_%', 1 as 'Recur_Billing', 1 as 'Currently_Processing', 1 as 'Service_List', 1 as 'Average_Ticket_Price',1 as 'Volume_Last_month',1 as 'Volume_Prev_30Days',1 as 'Volume_Prev_60Days',1 as 'Volume_Forcast_1Month', 1 as 'Volume_Forcast_2Month',1 as 'Volume_Forcast_3Month', 1 as 'Projected_Monthly_Sales', 1 as 'Anti_Fraud_System',1 as 'CS_Program',1 as 'Refund_Policy',\r\n \r\n'Notes' as access_header,\r\n1 as 'Account_Rep',\r\n1 as 'General_Notes',\r\n\r\n'Merchant Status' as access_header,\r\n1 as 'Reseller',\r\ncd_completion, en_gateway_ID,\r\n\r\nactiveuser,\r\n0 as Email_Active_Notification,\r\n\r\ncd_merchant_show_contract,\r\n0 as Email_Contract_Notification,\r\ncd_enable_tracking,\r\ncd_pay_status,\r\ncd_ignore,\r\n cd_custom_contract, \r\nif(merchant_contract_agree='1','Yes','No') as Contract_Signed,\r\nDate_Format(FROM_UNIXTIME(cd_contract_date),'%W %M %D %Y') as Date_Signed,\r\ncd_contract_ip as Signed_IP,\r\n\r\n'Merchant Settings' as access_header,\r\ncd_allow_rand_pricing, cd_enable_price_points, cd_max_transaction,cd_max_volume,\r\ncd_pay_bimonthly, cd_payperiod, cd_paydelay, cd_wirefee, cd_rollover, cd_appfee, \r\ncd_appfee_upfront, cs_monthly_charge, cd_next_pay_day, cd_orderpage_settings,\r\n cd_approve_timelimit, cd_fraudscore_limit, cd_orderpage_disable_fraud_checks, 0 as merchant_log\r\n", "cs_entities left join cs_companydetails on en_type='merchant' and en_type_ID = userId", $search, array('Size' => 30, 'Rows' => 2), $access);
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$access['EntityManager'] = true;
$access['EnablePlusMinus'] = true;
$company_id = $access['Data']['userId']['Value'];
$en_ID = $access['Data']['en_ID']['Value'];
$access['Data']['userId']['Input'] = "hidden";
$access['Data']['en_ID']['Input'] = "hidden";
$affiliate_data = en_get_affiliates($en_ID);
$emaildata['email'] = $access['Data']['en_email']['Value'];
if ($affiliate_data) {
foreach ($affiliate_data as $type => $group) {
if (in_array($type, array('Reseller', 'Representative'))) {
foreach ($group as $id => $ed) {
require_once "includes/dbconnection.php";
require_once 'includes/function.php';
require_once 'includes/header.php';
require_once "includes/transaction.class.php";
require_once "includes/updateAccess.php";
$userId = $companyInfo['userId'];
$transactionId = intval($_REQUEST['id']);
$ref = quote_smart($_REQUEST['ref']);
$transTable = 'cs_transactiondetails';
if ($_REQUEST['test']) {
$transTable = 'cs_test_transactiondetails';
}
$id = $ref;
$field = 'reference_number';
//$access = getMerchantAccess();
$access = getAccessInfo("\ntransactionId,\n\n'Customer Information' as access_header,\n\tCONCAT(surname,', ',name) as Full_Name,\n\t{$transTable}.address as Address,\n\t{$transTable}.city,\n\t{$transTable}.state,\n\t{$transTable}.zipcode,\n\t{$transTable}.country,\n\tipaddress as IP_Address,\n\t{$transTable}.email,\n\t\n'Billing Information' as access_header,\n\trd_subName,\n\tamount,\n\tCONCAT(\t\n\t\tif(status!='D',\n\t\t\tif(status='P','Pending', 'Approved'),\n\t\t\t'Declined'\n\t\t)\t\t\n\t) as status,\n\ttd_process_msg as 'Processor_Response',\n\tif(td_is_a_rebill=1,' Rebilled Transaction',' New Order') as Type_Of_Purchase,\n\tcardtype,\n\tCCnumber,\n\tbankaccountnumber,\n\tbankroutingcode,\n\tif(cancelstatus='Y',CONCAT('Refunded - ',cancel_refer_num),'') as Refunded,\n\tif(td_is_chargeback='1','Charged Back','') as Chargeback,\n\t\n'Purchase Information' as access_header,\n\treference_number as Reference_ID,\n\tDate_Format(transactionDate,'%W %b %D %Y %H:%i:%s') as Transaction_Date,\n\tCONCAT(td_product_id,': ',productdescription) as Product_Description,\n\tcs.cs_name as Website,\n\tcs.cs_ID as WebsiteID,\n\t\n'Subscription Information' as access_header,\n\tss_subscription_ID as Subscription_ID,\n\tDate_Format(ss_account_start_date,'%W %b %D %Y %H:%i:%s') as Account_Started,\n\tDate_Format(ss_account_expire_date,'%W %b %D %Y %H:%i:%s') as Account_Expiration,\n\tss_cancel_id,\n\tss_cust_username,\n\tss_cust_password,\n\tss_account_status,\n\tCONCAT(ss_rebill_status_text,' (',ss_rebill_status,')') as Rebill_Status,\n\tDate_Format(ss_last_rebill,'%W %b %D %Y %H:%i:%s') as Last_Rebill_Date,\n\t\n'Tracking Information' as access_header,\n\tcd_enable_tracking,\n\ttd_enable_tracking,\n\ttd_tracking_id,\n\ttd_tracking_link,\n\ttd_tracking_order_id,\n\ttd_tracking_company,\n\ttd_tracking_ship_date,\n\ttd_tracking_ship_est,\n\ttd_tracking_info,\n\t\n'Misc Information' as access_header_spanned,\n\ttd_non_unique\n\t\n", "{$transTable}\nleft join cs_subscription on td_ss_ID = ss_ID\nleft join cs_rebillingdetails as rd on rd_subaccount = td_rebillingID\nleft join cs_company_sites as cs on cs_ID = td_site_ID\nleft join cs_companydetails as cd on cd.userId = {$transTable}.userId\n", "{$field} = '{$id}' && {$transTable}.userId = '{$userId}'", array('disable' => true));
if ($access == -1) {
dieLog("Invalid Transaction ~ ({$id})", "Invalid Transaction ~ ({$id})");
}
$transactionId = $access['Data']['transactionId']['Value'];
$transaction = new transaction_class(false);
$transaction->pull_transaction($transactionId);
unset($access['Data']['transactionId']);
$access['Data']['email']['Value'] = "<a href='mailto:" . $access['Data']['email']['Value'] . "'>" . $access['Data']['email']['Value'] . "</a>";
$access['Data']['cardtype']['DisplayName'] = 'Billing Type';
$access['Data']['amount']['Value'] = '$' . formatMoney($access['Data']['amount']['Value']);
$access['Data']['amount']['DisplayName'] = 'Amount Charged';
$access['Data']['Website']['Value'] = "<a href='addwebsiteuser.php?mode=edit&cs_ID=" . $access['Data']['WebsiteID']['Value'] . "'>" . $access['Data']['Website']['Value'] . "</a>";
unset($access['Data']['WebsiteID']);
if (!$access['Data']['Chargeback']['Value']) {
unset($access['Data']['Chargeback']);
$access['Data']['access_header1'] = getAttrib('access_header');
$access['Data']['access_header1']['Value'] = 'PricePoint Information';
$access['Data']['rd_description'] = getAttrib('rd_description');
$access['Data']['access_header2'] = getAttrib('access_header');
$access['Data']['access_header2']['Value'] = 'Enable Trial';
$access['Data']['rd_trial_enabled'] = getAttrib('rd_trial_enabled');
$access['Data']['rd_initial_amount'] = getAttrib('rd_initial_amount');
$access['Data']['rd_trial_days'] = getAttrib('rd_trial_days');
$access['Data']['access_header3'] = getAttrib('access_header');
$access['Data']['access_header3']['Value'] = 'Recurring Billing Information';
$access['Data']['rd_recur_enabled'] = getAttrib('rd_recur_enabled');
$access['Data']['recur_charge'] = getAttrib('recur_charge');
$access['Data']['recur_day'] = getAttrib('recur_day');
$access['Submitable'] = 1;
} else {
$access = getAccessInfo("\n\t\n\t'PricePoint Information' as access_header,\n\t\t`rd_subName` as 'Price_Point_Name', \n\t\t`rd_description`,\n\t\t`rd_enabled`,\n\t\n\t'Enable Trial' as access_header,\n\t\t`rd_trial_enabled`,\n\t\t`rd_initial_amount`, `rd_trial_days`,\n\t\n\t'Recurring Billing Information' as access_header,\n\t\t`rd_recur_enabled`, `recur_charge`, `recur_day`,\n\t\t\n\t'Usage Information' as access_header,\n\t\tsum(ss_ID is not null) as 'sub_num',\n\t\tsum(ss_rebill_status = 'active') as 'sub_active',\n\t\tsum(ss_rebill_status = 'inactive') as 'sub_inactive'\n\t\n\t\t\n\t", "cs_rebillingdetails left join cs_subscription on rd_subaccount = ss_rebill_id", "rd_subName = '{$rd_subName}' && company_user_id = '{$userId}' && rd_hide=0", array('req' => 1), $access);
if ($access == -1) {
dieLog("Invalid PricePoint: " . print_r($_REQUEST, true), "Invalid PricePoint", false);
}
$access['Data']['Price_Point_Name']['DisplayName'] = 'Price Point Name';
$access['Data']['Price_Point_Name']['disable'] = 1;
}
$access['Data']['rd_enabled']['disable'] = 1;
$access['Data']['rd_enabled']['DisplayName'] = "Price Point Enabled";
$access['Data']['rd_recur_enabled']['DisplayName'] = 'Enable Recurring Billing';
$access['Data']['rd_recur_enabled']['Input'] = 'checkbox';
$access['Data']['rd_recur_enabled']['AddHtml'] = "<span class='small'><br>This will disable all active subscriptions using this price point.</span>";
$access['Data']['recur_charge']['DisplayName'] = 'Recuring $ Amount';
$access['Data']['recur_charge']['Valid'] = 'between|1.00|' . $companyInfo['cd_max_transaction'];
$access['Data']['recur_day']['DisplayName'] = 'Recuring Period';
$access['Data']['rd_recur_enabled']['InputAdditional'] = "onclick='" . '$(recur_charge).disabled=!this.checked; $(recur_day).disabled=!this.checked; ' . "'";
if ($_POST['refund']) {
$refund_reason = $_POST['refund_reason'];
if (strlen($refund_reason) > 3) {
$trans = new transaction_class(false);
$trans->pull_transaction($ref, $field);
$status = $trans->process_refund_request(array("actor" => 'Administrator', 'notes' => "{$refund_reason}"));
$msg .= $status['status'] . "<BR>";
}
}
if ($_POST['charged_back']) {
$qry_details = "UPDATE cs_transactiondetails SET `td_is_chargeback` = '1',`td_bank_deducted`=0,`td_merchant_deducted`=0,`td_reseller_deducted`=0 WHERE {$field} = '{$ref}'";
$rst_details = sql_query_write($qry_details) or dieLog(mysql_errno() . ": " . mysql_error() . "<BR>Cannot execute query");
$msg .= "{$ref} Set as Charged Back<BR>";
}
//$access = getMerchantAccess();
$access = getAccessInfo("\n\n'Customer Info' as access_header,\n\tCONCAT(surname,', ',name) as Full_Name,\n\tcs_transactiondetails.address as Address,\n\tcs_transactiondetails.city,\n\tcs_transactiondetails.state,\n\tcs_transactiondetails.zipcode,\n\tco_full as Country,\n\tipaddress as IP_Address,\n\tcs_transactiondetails.email,\n\tcs_transactiondetails.phonenumber as 'Phone',\n\t\n'Billing Info' as access_header,\n\trd_subName,\n\tamount,\n\tCONCAT(\t\n\t\tif(status!='D',\n\t\t\tif(status='P','Pending', 'Approved'),\n\t\t\t'Declined'\n\t\t)\t\t\n\t) as status,\n\ttd_process_msg as 'Processor_Response',\n\t0 as 'Ban_Info',\n\tif(td_is_a_rebill=1,' Rebilled Transaction',' New Order') as Type_Of_Purchase,\n\tcardtype,\n\tCCnumber,\n\tbankaccountnumber,\n\tbankroutingcode,\n\ttd_bank_transaction_id as 'Bank_Trans_ID',\n\tif(cancelstatus='Y',CONCAT('Refunded - ',cancel_refer_num),'') as Refunded,\n\tcustomer_notes as Refund_Requested,\n\tif(td_is_chargeback='1','Charged Back','') as Chargeback,\n\t\n'Purchase Info' as access_header,\n\tcd.userId as userId,\n\tcompanyname,\n\ttransactionId,\n\treference_number as Reference_ID,\n\tDate_Format(transactionDate,'%W %b %D %Y %H:%i:%s') as Transaction_Date,\n\tCONCAT(td_product_id,': ',productdescription) as Product_Description,\n\tcs.cs_name as Website,\n\tfrom_url as WebsiteURL,\n\t\n'Subscription Info' as access_header,\n\tss_subscription_ID as Subscription_ID,\n\tDate_Format(ss_account_start_date,'%W %b %D %Y %H:%i:%s') as Account_Started,\n\tDate_Format(ss_account_expire_date,'%W %b %D %Y %H:%i:%s') as Account_Expiration,\n\tss_cancel_id,\n\tss_cust_username,\n\tss_cust_password,\n\tss_account_status,\n\tCONCAT(ss_rebill_status_text,' (',ss_rebill_status,')') as Rebill_Status,\n\tDate_Format(ss_last_rebill,'%W %b %D %Y %H:%i:%s') as Last_Rebill_Date,\n\t\n'Tracking Info' as access_header,\n\tcd_enable_tracking,\n\ttd_enable_tracking,\n\ttd_tracking_id,\n\ttd_tracking_link,\n\ttd_tracking_order_id,\n\ttd_tracking_company,\n\ttd_tracking_ship_date,\n\ttd_tracking_ship_est,\n\ttd_tracking_info,\n\t\n'Profit Info' as access_header_spanned,\n\t'' as Breakdown,\n\t\n'Misc Info' as access_header_spanned,\n\ttd_non_unique,\n\ttd_merchant_fields as Merchant_Data,\n\ttd_process_query as Debug_Query,\n\ttd_process_result as Debug_Result,\n\ttd_process_duration as Query_Time\n\t\n\t\n", "cs_transactiondetails\nleft join cs_subscription on td_ss_ID = ss_ID\nleft join cs_rebillingdetails as rd on rd_subaccount = td_rebillingID\nleft join cs_company_sites as cs on cs_ID = td_site_ID\nleft join cs_companydetails as cd on cd.userId = cs_transactiondetails.userId\nleft join cs_country as co on cs_transactiondetails.country = co_ISO\nleft join cs_callnotes as co on transaction_id = transactionId and cn_type='refundrequest'\n\nleft join cs_profit_action on pa_trans_id = transactionId \n", "{$field} = '{$id}'", array('disable' => true));
if ($access == -1) {
dieLog("Invalid Transaction", "Invalid Transaction");
}
$transactionId = $access['Data']['transactionId']['Value'];
$fraud = new fraud_class();
$transaction = new transaction_class(false);
$transaction->pull_transaction($transactionId);
unset($access['Data']['transactionId']);
$access['EnablePlusMinus'] = true;
$access['Data']['Misc Info']['PlusMinus'] = 'Closed';
$access['Data']['Profit Info']['PlusMinus'] = 'Closed';
$banInfo = $fraud->check_banlist($transaction->row['transactionTable'], true);
if (!$banInfo['bansfound']) {
unset($access['Data']['Ban_Info']);
} else {
$company_id = isset($_REQUEST['userIdList']) ? quote_smart($_REQUEST['userIdList']) : "";
}
if ($company_id == "") {
$company_id = isset($HTTP_GET_VARS['companyname']) ? quote_smart($HTTP_GET_VARS['companyname']) : "";
}
$companyname = isset($HTTP_GET_VARS['companyname']) ? $HTTP_GET_VARS['companyname'] : "";
$companytype = isset($HTTP_GET_VARS['companymode']) ? $HTTP_GET_VARS['companymode'] : "";
$companytrans_type = isset($HTTP_GET_VARS['companytrans_type']) ? quote_smart($HTTP_GET_VARS['companytrans_type']) : "";
$qry_select_companies = "\n\tselect \n\t\tstate,\n\t\tostate,\n\t\ttransaction_type,\n\t\tcompleted_merchant_application,\n\t\tusername,\n\t\tpassword,\n\t\tcompanyname,\n\t\tuserid \n\tfrom \n\t\tcs_companydetails \n\twhere \n\t\tuserid='{$company_id}' \n\t\t{$bank_sql_limit}\n\t";
if ($qry_select_companies != "") {
$show_sql = sql_query_read($qry_select_companies) or dieLog(mysql_error() . " ~ {$qry_select_companies}");
}
$companyInfo = mysql_fetch_assoc($show_sql);
$userId = intval($_REQUEST['userIdList'] ? $_REQUEST['userIdList'] : $_REQUEST['userId']);
//$access = getMerchantAccess();
$access = getAccessInfo("\n\nuserId,\n\n'Reseller Request Rate Markup' as access_header,\n\n'Contract' as access_header,\n\n\tcd_merchant_show_contract,\n\tcd_custom_contract,\n\tmerchant_contract_agree,\n\tcd_contract_ip,\n\tcd_contract_date,\n\n'Credit Card Rates & Fees' as access_header,\n\n\tcc_customer_fee,\n\tcc_underchargeback,\n\tcc_overchargeback,\n\tcc_discountrate,\n\tcc_reserve,\n\tbank_Creditcard,\n\tcd_cc_bank_extra,\n\tcc_visa_billingdescriptor,\n\tcc_master_billingdescriptor,\n\tcc_total_discount_rate,\n\tcc_reseller_discount_rate,\n\tcc_merchant_discount_rate,\n\tcc_total_trans_fees,\n\tcc_reseller_trans_fees,\n\tcc_merchant_trans_fees,\n\n'Check Rates & Fees' as access_header,\n\nch_chargeback,\nch_discountrate,\nch_reserve,\nbank_check,\nch_billingdescriptor,\nch_total_discount_rate,\nch_reseller_discount_rate,\nch_merchant_discount_rate,\nch_total_trans_fees,\nch_reseller_trans_fees,\nch_merchant_trans_fees,\n\n'ETEL900 Rates & Fees' as access_header,\n\n\tweb_chargeback,\n\tweb_discountrate,\n\tweb_reserve,\n\tcd_web900bank,\n\twe_billingdescriptor,\n\tweb_total_trans_fees,\n\tweb_reseller_trans_fees,\n\tweb_merchant_trans_fees,\n\n'Reseller Name' as access_header,\n\nreseller_id,\n\n'Manage Settings' as access_header,\n\n\tgateway_id,\n\tcd_completion,\n\tblock_virtualterminal,\n\tcd_allow_gatewayVT,\n\tsuspenduser,\n\tcd_pay_status,\n\tcd_ignore,\n\tactiveuser,\n\tcontact_email,\n\tcustomer_service_phone,\n\tsend_mail,\n\tsend_ecommercemail,\n\tcancel_ecommerce_letter,\n\tcd_enable_price_points,\n\tcd_allow_rand_pricing,\n\tcd_custom_recur,\n\tcd_max_volume,\n\tcd_max_transaction,\n\n'Pay Period Information' as access_header,\n\ncd_pay_bimonthly,cd_payperiod,cd_paydelay,cd_rollover,cd_wirefee,cd_appfee,cd_appfee_upfront,cs_monthly_charge,cd_next_pay_day,\n\n'Order Page Settings' as access_header,\n\ncd_orderpage_settings,cd_orderpage_useraccount,cd_approve_timelimit,cd_fraudscore_limit,cd_custom_orderpage\n\n", "cs_companydetails", "userId = {$company_id}");
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$access['Data']['bank_Creditcard']['Input'] = "selectcc";
$access['Data']['bank_check']['Input'] = "selectcheckbank";
$access['Data']['cd_web900bank']['Input'] = "selectetelbank";
$access['Data']['reseller_id']['Input'] = "selectreseller";
$access['Data']['gateway_id']['Input'] = "selectgateway";
$access['Data']['cd_completion']['Input'] = "selectcompletion";
$access['Data']['cd_pay_status']['Input'] = "selectenum";
$access['Data']['cd_pay_status']['Table'] = "cs_companydetails";
$access['Data']['cd_pay_status']['Name'] = "cd_pay_status";
$access['Data']['cd_pay_bimonthly']['Input'] = "selectenum";
$access['Data']['cd_pay_bimonthly']['Table'] = "cs_companydetails";
$access['Data']['cd_pay_bimonthly']['Name'] = "cd_pay_bimonthly";
$link_info = '';
foreach ($query as $key => $data) {
$sql_where .= ($sql_where ? "and " : "") . " {$key} = '" . quote_smart($data) . "' ";
}
foreach ($allowed as $key) {
if ($_REQUEST[$key]) {
$link_info .= $key . "=" . $_REQUEST[$key] . "&";
}
}
if (sizeof($query) < 2) {
beginTable();
echo "Insufficient Information. Please try again.";
endTable('Insufficient Information', "lookup.php?{$link_info}", false, true);
die;
}
$access = getAccessInfo("\nss_ID,\n\n'Account Information' as access_header,\n\tss_subscription_ID as Subscription_ID,\n\tDate_Format(ss_account_start_date,'%W %b %D %Y %H:%i:%s') as Account_Started,\n\tss_productdescription,\n\tss_cust_username,\n\tss_cust_password,\n\tss_account_status,\n\tss_account_expire_date,\n\tcs.cs_name as Website,\n\tcs.cs_member_url as WebsiteURL,\n\t\n'Customer Information' as access_header,\n\tCONCAT(ss_billing_lastname,', ',ss_billing_mi,' ',ss_billing_firstname) as Full_Name,\n\tss_cust_email as Email,\n\t\n'Billing Information' as access_header,\n\tss_billing_type,\n\tss_billing_card,\n\tss_billing_check_account, \t \n\tss_billing_check_routing,\n\tDate_Format(ss_rebill_next_date,'%W %b %D %Y %H:%i:%s') as Next_Rebill_Date,\n\tss_rebill_amount,\n\tss_rebill_status,\n\tDate_Format(ss_last_rebill,'%W %b %D %Y %H:%i:%s') as Last_Rebill_Date,\n\treference_number as Last_Transaction,\n\t\n\n'Account Notes' as access_header,\n\tss_account_notes,\n\n'Cancel Subscription' as access_header,\n\tss_cancel_id,\n\t'' as cancel_subscription_select,\n\t'' as cancel_subscription_reason,\n\t'' as cancel_subscription\n", "cs_subscription\nleft join cs_transactiondetails on transactionID = ss_transaction_id\nleft join cs_rebillingdetails as rd on rd_subaccount = ss_rebill_ID\nleft join cs_company_sites as cs on cs_ID = ss_site_ID\n", "{$sql_where}", array('disable' => true, 'HideIfEmpty' => true));
if ($access == -1) {
beginTable();
echo "Transaction Information was not found. Please try again.";
endTable('Transaction Not Found', "lookup.php?{$link_info}", false, true);
die;
}
$subscription = new transaction_class(false);
$subscription->pull_subscription($access['Data']['ss_ID']['Value']);
$access['Data']['ss_rebill_amount']['Value'] = '$' . formatMoney($access['Data']['ss_rebill_amount']['Value']);
$access['Data']['ss_rebill_amount']['DisplayName'] = 'Next Rebill Amount';
if ($_POST['cancel_rebill'] && $access['Data']['ss_rebill_status']['Value'] == 'active') {
if ($_POST['ss_rebill_status_text']) {
$notes = quote_smart($_POST['ss_rebill_status_text'] . " - " . $_POST['cancel_subscription_reason']);
$status = $subscription->process_cancel_request(array("actor" => '.NET', 'notes' => $notes));
if ($status) {
$company_id = intval($_REQUEST['userIdList']);
}
$pageConfig['AllowBank'] = true;
$pageConfig['Title'] = "Merchant Wire Info";
require_once "../includes/updateAccess.php";
$headerInclude = "companies";
include "includes/header.php";
$search = "userId = {$company_id}";
if ($en_ID) {
$search = "en_ID = {$en_ID}";
}
$access = array();
$access['SerializedData']['Source'] = 'en_info';
$access['SerializedData']['Data'] = array('Method' => array('Payment_Data', 'Method'), 'ACH_Bank_Name' => array('Payment_Data', 'ACH', 'Bank_Name'), 'ACH_Bank_Address' => array('Payment_Data', 'ACH', 'Bank_Address'), 'ACH_Bank_ZipCode' => array('Payment_Data', 'ACH', 'Bank_ZipCode'), 'ACH_Bank_City' => array('Payment_Data', 'ACH', 'Bank_City'), 'ACH_Bank_State' => array('Payment_Data', 'ACH', 'Bank_State'), 'ACH_Bank_Country' => array('Payment_Data', 'ACH', 'Bank_Country'), 'ACH_Bank_Phone' => array('Payment_Data', 'ACH', 'Bank_Phone'), 'ACH_Bank_Beneficiary_Name' => array('Payment_Data', 'ACH', 'Bank_Beneficiary_Name'), 'ACH_Bank_Account_Name' => array('Payment_Data', 'ACH', 'Bank_Account_Name'), 'ACH_Bank_Account_Number' => array('Payment_Data', 'ACH', 'Bank_Account_Number'), 'ACH_Bank_Routing_Number' => array('Payment_Data', 'ACH', 'Bank_Routing_Number'), 'ACH_Bank_Additional_Notes' => array('Payment_Data', 'ACH', 'Bank_Additional_Notes'), 'Wire_Bank_Name' => array('Payment_Data', 'Wire', 'Bank_Name'), 'Wire_Bank_Address' => array('Payment_Data', 'Wire', 'Bank_Address'), 'Wire_Bank_ZipCode' => array('Payment_Data', 'Wire', 'Bank_ZipCode'), 'Wire_Bank_City' => array('Payment_Data', 'Wire', 'Bank_City'), 'Wire_Bank_State' => array('Payment_Data', 'Wire', 'Bank_State'), 'Wire_Bank_Country' => array('Payment_Data', 'Wire', 'Bank_Country'), 'Wire_Bank_Phone' => array('Payment_Data', 'Wire', 'Bank_Phone'), 'Wire_Bank_Beneficiary_Name' => array('Payment_Data', 'Wire', 'Bank_Beneficiary_Name'), 'Wire_Bank_Account_Name' => array('Payment_Data', 'Wire', 'Bank_Account_Name'), 'Wire_Bank_Account_Number' => array('Payment_Data', 'Wire', 'Bank_Account_Number'), 'Wire_Bank_Routing_Number' => array('Payment_Data', 'Wire', 'Bank_Routing_Number'), 'Wire_Bank_Routing_Type' => array('Payment_Data', 'Wire', 'Bank_Routing_Type'), 'Wire_Bank_Sort_Code' => array('Payment_Data', 'Wire', 'Bank_Sort_Code'), 'Wire_Bank_VAT_Number' => array('Payment_Data', 'Wire', 'Bank_VAT_Number'), 'Wire_Bank_Registration_Number' => array('Payment_Data', 'Wire', 'Bank_Registration_Number'), 'Wire_Bank_Additional_Notes' => array('Payment_Data', 'Wire', 'Bank_Additional_Notes'), 'Wire_Intermediary_Bank_Routing_Type' => array('Payment_Data', 'Wire', 'Intermediary_Bank_Routing_Type'), 'Wire_Intermediary_Bank_Routing_Number' => array('Payment_Data', 'Wire', 'Intermediary_Bank_Routing_Number'), 'Wire_Intermediary_Bank_Name' => array('Payment_Data', 'Wire', 'Intermediary_Bank_Name'), 'Wire_Intermediary_Bank_City' => array('Payment_Data', 'Wire', 'Intermediary_Bank_City'), 'Wire_Intermediary_Bank_State' => array('Payment_Data', 'Wire', 'Intermediary_Bank_State'));
//$access = getMerchantAccess();
$access = getAccessInfo("\n\n\tuserId,\n\ten_ID,\n\ten_info,\n\t\n\t'Payment Method' as access_header,\n\t1 as 'Method',\n\t\n\t'ACH Banking Info' as access_header,\n\t\t1 as 'ACH_Bank_Name', 1 as 'ACH_Bank_Address', 1 as 'ACH_Bank_ZipCode', 1 as 'ACH_Bank_City', 1 as 'ACH_Bank_State', \n\t\t1 as 'ACH_Bank_Country', 1 as 'ACH_Bank_Phone', 1 as 'ACH_Bank_Beneficiary_Name', 1 as 'ACH_Bank_Account_Name', 1 as 'ACH_Bank_Account_Number', \n\t\t1 as 'ACH_Bank_Routing_Number', 1 as 'ACH_Bank_Additional_Notes',\n\t\t\n\t'Wire Banking Info' as access_header,\n\t\t1 as 'Wire_Bank_Name', 1 as 'Wire_Bank_Address', 1 as 'Wire_Bank_ZipCode', 1 as 'Wire_Bank_City', 1 as 'Wire_Bank_State', \n\t\t1 as 'Wire_Bank_Country', 1 as 'Wire_Bank_Phone', 1 as 'Wire_Bank_Beneficiary_Name', 1 as 'Wire_Bank_Account_Name', 1 as 'Wire_Bank_Account_Number', \n\t\t1 as 'Wire_Bank_Routing_Number', 1 as 'Wire_Bank_Routing_Type', 1 as 'Wire_Intermediary_Bank_Routing_Number',\n\t\t1 as 'Wire_Intermediary_Bank_Routing_Type',\t1 as 'Wire_Intermediary_Bank_Name', 1 as 'Wire_Intermediary_Bank_City', 1 as 'Wire_Intermediary_Bank_State', \n\t\t1 as 'Wire_Bank_Sort_Code', 1 as 'Wire_Bank_VAT_Number', 1 as 'Wire_Bank_Registration_Number', 1 as 'Wire_Bank_Additional_Notes'\n\n", "cs_entities left join cs_companydetails on en_type='merchant' and en_type_ID = userId", $search, array('Size' => 30, 'Rows' => 2, 'Length' => 32), $access);
/*
echo "<table width='100%'><tr><td>";
echo "<pre>";
print_r($access);
echo "</pre>";
echo "</td></tr></table>";
exit();
*/
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$company_id = $access['Data']['userId']['Value'];
$en_ID = $access['Data']['en_ID']['Value'];
$access['Data']['userId']['Input'] = "hidden";
$access['Data']['en_ID']['Input'] = "hidden";
// Copyright (C) Etelegate.com 2003-2004, All Rights Reserved. //
// //
//******************************************************************//
// Package: Zerone-consulting
// Description: Online Payment Gateway
// Files: index.php,home.php,cheque.php,creditcard.php,report.php,reportBottom.php, reportBottomSummary.php,companyEdit.php
// config.php,useraccount.php,viewCompany.php,topheader.php,ViewreportPage.php,addcheque.php,blank.php,administration_blank.php,virtualterminal.php,creditcardfb.php,negativedatabase.php
// viewreportpage_negative.php,batchuploads.php,voicesystem.php,voicesystemreport.php,voicesystemdetails.php,companyAdd.php,companies_blank.php
// modifycompany.php,companyuser.php,orderemail.php,enquires.php,report_custom.php,service_users.php,export.php,ledger.php
// labels.php,printemailforms.php,maileditor.php,shipping.php,shippingdetails.php,logout.php
// editCompanyProfile1.php: This admin page functions for editing the company details.
$pageConfig['Title'] = "Merchant Application :: Step #1";
$headerInclude = "startHere";
require_once "includes/header.php";
//$access = getMerchantAccess();
$access = getAccessInfo("\n\nuserId,\n\n'General Info' as access_header,\nReferenceNumber, companyname, url1 , 1 as Merchant_Websites, 1 as Merchant_Documents, transaction_type, username, password, email, phonenumber,address,city,state,country,zipcode,\nfax_number,how_about_us,company_type, legal_name, incorporated_country, incorporated_number,fax_dba,physical_address,\ncellular,technical_contact_details,admin_contact_details,\n\n'Personal Info' as access_header,\nfirst_name,family_name,job_title,contact_email,contact_phone,customer_service_phone,stitle,sdateofbirth,\nssex,sAddress,sPostCode,sResidenceTelephone,sFax,\n\n'Processing Info' as access_header,\npreprocess, cd_previous_processor, cd_processing_reason, cd_previous_discount, cd_previous_transaction_fee, recurbilling, currprocessing,\ngoods_list, max_ticket_amt,min_ticket_amt,volume_last_month,volume_prev_30days,volume_prev_60days,totals,forecast_volume_1month,\nforecast_volume_2month,forecast_volume_3month,current_anti_fraud_system,customer_service_program,refund_policy,\n\n'Merchant Notes' as access_header,\ncd_notes,\n\n'Status/Contract Info' as access_header,\n\ncd_completion, gateway_id,\n\nactiveuser,\n0 as Email_Active_Notification,\n\ncd_merchant_show_contract,\n0 as Email_Contract_Notification,\ncd_pay_status,\ncd_ignore,\nsend_mail,\n cd_custom_contract, \nif(merchant_contract_agree='1','Yes','No') as Contract_Signed,\nDate_Format(FROM_UNIXTIME(cd_contract_date),'%W %M %D %Y') as Date_Signed,\ncd_contract_ip as Signed_IP,\n\n\n'Merchant Settings' as access_header,\ncd_allow_rand_pricing, cd_enable_price_points, cd_max_transaction,cd_max_volume,\ncd_pay_bimonthly, cd_payperiod, cd_paydelay, cd_wirefee, cd_rollover, cd_appfee, \ncd_appfee_upfront, cs_monthly_charge, cd_next_pay_day, cd_orderpage_settings,\n cd_approve_timelimit, cd_fraudscore_limit\n\n", "cs_companydetails", "userId = {$company_id}", array('Size' => 30, 'Rows' => 2));
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$data['email'] = $access['Data']['email']['Value'];
$data['companyname'] = $access['Data']['companyname']['Value'];
$data['full_name'] = $access['Data']['companyname']['Value'];
$data['username'] = $access['Data']['username']['Value'];
$data['password'] = $access['Data']['password']['Value'];
$data['Reference_ID'] = $access['Data']['ReferenceNumber']['Value'];
$data["gateway_select"] = $access['Data']['gateway_id']['Value'];
$access['Data']['activeuser']['Input'] = 'checkbox';
$access['Data']['activeuser']['DisplayName'] = 'Merchant Live';
$access['Data']['activeuser']['InputAdditional'] = "onclick='" . 'if(this.checked) {addNotes("Merchant Turned Active."); $(Email_Active_Notification).checked=true;$(cd_completion).value = 10;}' . ' else {addNotes("Merchant Turned Inactive."); $(cd_completion).value = 9;}' . "'";
$access['Data']['cd_pay_status']['DisplayName'] = 'Company Payable';
$access['Data']['cd_pay_status']['InputAdditional'] = "onchange='" . 'addNotes("Merchant Payable Status Changed to "+this.value+".");' . "'";
//******************************************************************//
// Package: Zerone-consulting
// Description: Online Payment Gateway
// Files: index.php,home.php,cheque.php,creditcard.php,report.php,reportBottom.php, reportBottomSummary.php,companyEdit.php
// config.php,useraccount.php,viewCompany.php,topheader.php,ViewreportPage.php,addcheque.php,blank.php,administration_blank.php,virtualterminal.php,creditcardfb.php,negativedatabase.php
// viewreportpage_negative.php,batchuploads.php,voicesystem.php,voicesystemreport.php,voicesystemdetails.php,companyAdd.php,companies_blank.php
// modifycompany.php,companyuser.php,orderemail.php,enquires.php,report_custom.php,service_users.php,export.php,ledger.php
// labels.php,printemailforms.php,maileditor.php,shipping.php,shippingdetails.php,logout.php
// editCompanyProfile1.php: This admin page functions for editing the company details.
$pageConfig['Title'] = "Merchant Application :: Step #1 - Company Information";
$headerInclude = "startHere";
require_once "includes/header.php";
require_once "includes/updateAccess.php";
$userId = intval($companyInfo['userId']);
//$access = getMerchantAccess();
$access = getAccessInfo("\r\n\r\nuserId,\r\n\r\n'General Info' as access_header,\r\nReferenceNumber, username, password, password as 'cpassword', companyname, url1 , email, phonenumber,address,city,state,country,zipcode,\r\nfax_number,how_about_us,company_type, legal_name, incorporated_country, incorporated_number,fax_dba,physical_address,\r\ncellular,technical_contact_details,admin_contact_details\r\n\r\n\r\n", "cs_companydetails", "userId = '{$userId}'", array('Size' => 30, 'Rows' => 2, 'HideIfEmpty' => true));
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$access['Data']['ReferenceNumber']['disable'] = true;
$access['Data']['url1']['DisplayName'] = 'Company URL';
$access['Data']['email']['DisplayName'] = 'Notification Email';
$access['Data']['companyname']['DisplayName'] = 'Company Name';
$access['Data']['password']['Input'] = 'password';
$access['Data']['password']['alt'] = 'confirm|cpassword';
$access['Data']['cpassword']['Input'] = 'password';
$access['Data']['cpassword']['DisplayName'] = 'Confirm Password';
$access['Data']['cpassword']['ExcludeQuery'] = true;
$access['Data']['country']['Input'] = 'selectcustom';
$access['Data']['country']['Style'] = 'width:205px;';
$access['Data']['country']['Input_Custom'] = "Select co_ISO,co_full From {$database["database_main"]}.cs_country";
function step_3($en_ID, $skipIfComplete = true)
{
// Step 3
$access['SerializedData']['Source'] = 'en_info';
$access['SerializedData']['Data'] = array('Service_List' => array('Processing_Info', 'Service_List'), 'Anti_Fraud_System' => array('Processing_Info', 'Anti_Fraud_System'), 'CS_Program' => array('Processing_Info', 'CS_Program'), 'Refund_Policy' => array('Processing_Info', 'Refund_Policy'), 'Volume_Last_month' => array('Processing_Info', 'Volume_Last_month'), 'Volume_Prev_30Days' => array('Processing_Info', 'Volume_Prev_30Days'), 'Volume_Prev_60Days' => array('Processing_Info', 'Volume_Prev_60Days'), 'Volume_Forcast_1Month' => array('Processing_Info', 'Volume_Forcast_1Month'), 'Volume_Forcast_2Month' => array('Processing_Info', 'Volume_Forcast_2Month'), 'Volume_Forcast_3Month' => array('Processing_Info', 'Volume_Forcast_3Month'), 'Projected_Monthly_Sales' => array('Processing_Info', 'Projected_Monthly_Sales'), 'Chargeback_%' => array('Processing_Info', 'Chargeback_%'), 'Average_Ticket_Price' => array('Processing_Info', 'Average_Ticket_Price'), 'Previous_Processor_Trans_Fee' => array('Processing_Info', 'Previous_Processor_Trans_Fee'), 'Previous_Processor_Disc_Fee' => array('Processing_Info', 'Previous_Processor_Disc_Fee'), 'Previous_Processing' => array('Processing_Info', 'Previous_Processing'), 'Previous_Processor_Reason' => array('Processing_Info', 'Previous_Processor_Reason'), 'Recur_Billing' => array('Processing_Info', 'Recur_Billing'), 'Currently_Processing' => array('Processing_Info', 'Currently_Processing'));
$access = getAccessInfo("\r\n\t\r\n\tuserId,\r\n\ten_ID,\r\n\ten_info,\r\n\t\r\n\t'Processing Info' as access_header,\r\n\t'' as Service_List,'' as Anti_Fraud_System,'' as CS_Program,'' as Refund_Policy,\r\n\t'' as Volume_Last_month, '' as Volume_Prev_30Days, '' as Volume_Prev_60Days,\r\n\t'' as Volume_Forcast_1Month, '' as Volume_Forcast_2Month, '' as Volume_Forcast_3Month, '' as Projected_Monthly_Sales, '' as Average_Ticket_Price, '' as 'Chargeback_%',\r\n\t'' as Previous_Processor_Trans_Fee, '' as Previous_Processor_Disc_Fee, '' as Previous_Processing, '' as Previous_Processor_Reason, '' as Recur_Billing, '' as Currently_Processing\r\n\t\r\n\t\r\n\t", "cs_entities left join cs_companydetails on en_type='merchant' and en_type_ID = userId", "en_ID = '{$en_ID}'", array('Size' => 30, 'Rows' => 2, 'HideIfEmpty' => true, 'Valid' => 'req'), $access);
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$access['Data']['userId']['Input'] = "hidden";
$access['Data']['userId']['disable'] = 1;
$access['Data']['en_ID']['Input'] = "hidden";
$access['Data']['en_ID']['disable'] = 1;
$access['Data']['Service_List']['Input'] = 'textarea';
$access['Data']['Anti_Fraud_System']['Input'] = 'textarea';
$access['Data']['CS_Program']['Input'] = 'textarea';
$access['Data']['Refund_Policy']['Input'] = 'textarea';
$access['Data']['Previous_Processor_Trans_Fee']['DisplayName'] = 'Previous Processor Transaction Fee';
$access['Data']['Previous_Processor_Disc_Fee']['DisplayName'] = 'Previous Processor Discount Rate';
$access['Data']['Volume_Last_month']['Input'] = "selectvolume";
$access['Data']['Volume_Last_month']['DisplayName'] = "Last Month's Volume";
$access['Data']['Volume_Prev_30Days']['Input'] = "selectvolume";
$access['Data']['Volume_Prev_30Days']['DisplayName'] = "Volume 2 Months Ago";
$access['Data']['Volume_Prev_60Days']['Input'] = "selectvolume";
$access['Data']['Volume_Prev_60Days']['DisplayName'] = "Volume 3 Months Ago";
$access['Data']['Volume_Forcast_1Month']['Input'] = "selectvolume";
$access['Data']['Volume_Forcast_1Month']['DisplayName'] = "Forcast Volume This Month";
$access['Data']['Volume_Forcast_2Month']['Input'] = "selectvolume";
$access['Data']['Volume_Forcast_2Month']['DisplayName'] = "Forcast Volume Next Month";
$access['Data']['Volume_Forcast_3Month']['Input'] = "selectvolume";
$access['Data']['Volume_Forcast_3Month']['DisplayName'] = "Forcast Volume in two Months";
$access['Data']['Projected_Monthly_Sales']['Input'] = "selectvolume";
$access['Data']['Projected_Monthly_Sales']['DisplayName'] = "Projected Monthly Sales Volume";
$access['Data']['Previous_Processor_Trans_Fee']['DisplayName'] = "Previous Processing";
$access['Data']['Previous_Processing']['DisplayName'] = "Previous Processor";
$access['Data']['Previous_Processor_Reason']['DisplayName'] = "Reason for Leaving Previous Processor";
$access['Data']['Previous_Processor_Reason']['Valid'] = '';
$access['Data']['Recur_Billing']['DisplayName'] = "Recuring Billing";
$access['Data']['Currently_Processing']['DisplayName'] = "Currently Processing";
$access['Data']['Average_Ticket_Price']['DisplayName'] = "Average Ticket Price";
$access['Data']['Chargeback_%']['DisplayName'] = "Chargeback %";
$access['Data']['Service_List']['DisplayName'] = "Please List Your Products and Services";
$access['Data']['Anti_Fraud_System']['DisplayName'] = "Describe your Current Anti Fraud System";
$access['Data']['CS_Program']['DisplayName'] = "Describe your Customer Service Program";
$access['Data']['Refund_Policy']['DisplayName'] = "Describe your Refund Policy";
$access['SubmitValue'] = 'Update Information';
if ($skipIfComplete) {
$access['SubmitValue'] = 'Complete Merchant Application';
}
$access['SubmitName'] = 'submit_step3';
// Submit
$showvalidation = false;
if ($_POST[$access['SubmitName']]) {
$result = processAccessForm(&$access);
$showvalidation = true;
}
$access['Columns'] = 1;
// Validate
$valid = true;
foreach ($access['Data'] as $key => $data) {
if (!$data['Value'] && $data['Valid']) {
$valid = false;
if ($showvalidation) {
$access['Data'][$key]['Highlight'] = true;
}
}
}
if (!$valid || !$skipIfComplete) {
draw_step_buttons(3, $skipIfComplete);
$access['HeaderMessage'] = "Please Complete all required fields to continue.";
beginTable();
writeAccessForm(&$access);
endTable("Step #3 - Processing Information", "");
include "includes/footer.php";
die;
}
}
$addvar .= '&nolink=' . $nolink;
}
if ($_REQUEST['hide_header']) {
$addvar .= '&hide_header=' . $_REQUEST['hide_header'];
}
$ss_subscription_ID = intval($_REQUEST['subscription_ID']);
if ($_POST['cancel']) {
$trans = new transaction_class(false);
$trans->pull_subscription($ss_subscription_ID, 'ss_subscription_ID');
$status = $trans->process_cancel_request(array("actor" => 'Administrator'));
if ($status['success']) {
$msg .= "Subscription ID " . $trans->row['subscriptionTable']['ss_subscription_ID'] . " cancelled.<BR>";
}
}
//$access = getMerchantAccess();
$access = getAccessInfo("\n\tss_ID,\n\t\n'Customer Info' as access_header,\n\tCONCAT(ss_billing_lastname,', ',ss_billing_mi,' ',ss_billing_firstname) as Full_Name,\n\tCONCAT(ss_billing_address,' ',ss_billing_address2) as Address,\n\tss_billing_city as City,\n\tss_billing_state as State,\n\tss_billing_zipcode as Zipcode,\n\tco_full as Country,\n\tss_billing_last_ip as IP_Address,\n\t\n'Account Notes' as access_header,\n\tss_account_notes,\n\t\n'Billing Info' as access_header,\n\tcompanyname,\n\tss_user_ID,\n\trd_subName,\n\tss_billing_type,\n\tss_billing_card,\n\tss_billing_check_account, \t \n\tss_billing_check_routing,\n\t \n\tDate_Format(ss_rebill_next_date,'%W %b %D %Y %H:%i:%s') as Next_Rebill_Date,\n\tss_rebill_amount,\n\tCONCAT(ss_rebill_status_text,' (',ss_rebill_status,') (frozen=',ss_rebill_frozen,')') as Rebill_Status,\n\tss_rebill_status,\n\tss_rebill_attempts as Rebill_Attempts,\n\tss_rebill_count as Rebill_Count,\n\tss_cancel_id,\n\tDate_Format(ss_last_rebill,'%W %b %D %Y %H:%i:%s') as Last_Rebill_Date,\n\ttd.reference_number as Last_Transaction,\n\t\n'Account Info' as access_header,\n\tss_subscription_ID as Subscription_ID,\n\tDate_Format(ss_account_start_date,'%W %b %D %Y %H:%i:%s') as Account_Started,\n\tss_productdescription,\n\tss_cust_email,\n\tss_cust_username,\n\tss_cust_password,\n\tss_account_status,\n\t0 as update_manager,\n\tss_account_expire_date,\n\tcs.cs_name as Website,\n\tcs.cs_member_url as WebsiteMembers,\n\n'Transaction History' as access_header_spanned,\n\t1 as trans_log,\n\n'Profit Info' as access_header_spanned,\n\t'' as Breakdown\n\t\n", "cs_subscription\nleft join cs_transactiondetails as td on transactionID = ss_transaction_id\nleft join cs_companydetails as cd on cd.userId = ss_user_ID \nleft join cs_rebillingdetails as rd on rd_subaccount = ss_rebill_ID\nleft join cs_company_sites as cs on cs_ID = ss_site_ID\nleft join cs_country as co on ss_billing_country = co_ISO\n", "ss_subscription_ID = '{$ss_subscription_ID}'", array('disable' => true));
if ($access == -1) {
dieLog("Invalid Subscription", "Invalid Subscription");
}
$ss_ID = $access['Data']['ss_ID']['Value'];
$subscription = new transaction_class(false);
$subscription->pull_subscription($ss_ID);
$access['EnablePlusMinus'] = true;
$access['Data']['Profit Info']['PlusMinus'] = 'Closed';
//$access['Data']['Email']['Value'] = "<a href='mailto:".$access['Data']['Email']['Value']."'>".$access['Data']['Email']['Value']."</a>";
unset($access['Data']['ss_ID']);
$access['Data']['ss_productdescription']['disable'] = false;
$access['Data']['ss_productdescription']['DisplayName'] = 'Product Description';
$access['Data']['ss_productdescription']['Size'] = '30';
$access['Data']['ss_cust_username']['disable'] = false;
$access['Data']['ss_cust_username']['DisplayName'] = 'UserName';
$link_info = '';
foreach ($query as $key => $data) {
$sql_where .= ($sql_where ? "and " : "") . " {$key} = '" . quote_smart($data) . "' ";
}
foreach ($allowed as $key) {
if ($_REQUEST[$key]) {
$link_info .= $key . "=" . $_REQUEST[$key] . "&";
}
}
if (sizeof($query) < 2) {
beginTable();
echo "Insufficient Information. Please try again.";
endTable('Insufficient Information', "lookup.php?{$link_info}", false, true);
die;
}
$access = getAccessInfo("\ntransactionId,\n\n'Customer Information' as access_header,\n\tCONCAT(surname,', ',name) as Full_Name,\n\tcs_transactiondetails.country,\n\tcs_transactiondetails.email,\n\t\n'Billing Information' as access_header,\n\tamount,\n\tCONCAT(\t\n\t\tif(status!='D',\n\t\t\tif(status='P','Pending', 'Approved'),\n\t\t\t'Declined'\n\t\t)\t\t\n\t) as status,\n\tif(td_is_a_rebill=1,' Rebilled Transaction',' New Order') as Type_Of_Purchase,\n\tcardtype,\n\tCCnumber,\n\tbankaccountnumber,\n\tbankroutingcode,\n\tbk_descriptor_visa as Billing_Descriptor,\n\tif(cancelstatus='Y',CONCAT('Refunded - ',cancel_refer_num),'') as Refunded,\n\tif(td_is_chargeback='1','Charged Back','') as Chargeback,\n\t\n'Purchase Information' as access_header,\n\treference_number as Reference_ID,\n\tDate_Format(transactionDate,'%W %b %D %Y %H:%i:%s') as Transaction_Date,\n\tproductdescription as Product_Description,\n\tcs.cs_name as Website,\n\tcs.cs_member_url as WebsiteURL,\n\t\n'Subscription Information' as access_header,\n\tss_subscription_ID as Subscription_ID,\n\tDate_Format(ss_account_start_date,'%W %b %D %Y %H:%i:%s') as Account_Started,\n\tDate_Format(ss_account_expire_date,'%W %b %D %Y %H:%i:%s') as Account_Expiration,\n\tss_cancel_id,\n\tss_cust_username,\n\tss_cust_password,\n\tss_account_status,\n\tDate_Format(ss_last_rebill,'%W %b %D %Y %H:%i:%s') as Last_Rebill_Date,\n\t\n'Tracking Information' as access_header,\n\tcd_enable_tracking,\n\ttd_enable_tracking,\n\ttd_tracking_id,\n\ttd_tracking_link,\n\ttd_tracking_order_id,\n\ttd_tracking_company,\n\ttd_tracking_ship_date,\n\ttd_tracking_ship_est,\n\ttd_tracking_info,\n\t\n'Refund Request' as access_header,\n\t'' as refund_select,\n\t'' as refund_reason,\n\t'' as refund_request,\n\tnote_id,\n\tDate_Format(call_date_time,'%W %b %D %Y %H:%i:%s') as Refund_Requested_On,\n\tcustomer_notes\n\t\n", "cs_transactiondetails\nleft join cs_subscription on td_ss_ID = ss_ID\nleft join cs_bank as bk on cs_transactiondetails.bank_id = bk.bank_id\nleft join cs_rebillingdetails as rd on rd_subaccount = td_rebillingID\nleft join cs_company_sites as cs on cs_ID = td_site_ID\nLEFT JOIN `cs_callnotes` as cn ON `transactionId` = cn.`transaction_id` \nleft join cs_companydetails as cd on cd.userId = cs_transactiondetails.userId\n", "{$sql_where}", array('disable' => true, 'HideIfEmpty' => true));
if ($access == -1) {
beginTable();
echo "Transaction Information was not found. Please try again.";
endTable('Transaction Not Found', "lookup.php?{$link_info}", false, true);
die;
}
$transaction = new transaction_class(false);
$transaction->pull_transaction($access['Data']['transactionId']['Value']);
$style_refund_select = '';
$style_refund_reason = '';
if ($_POST['refund_request'] && !$access['Data']['Refunded']['Value'] && !$access['Data']['note_id']['Value']) {
$notes = quote_smart($_POST['refund_select'] . " - " . $_POST['refund_reason']);
$msg = "<b>Please Enter a Detailed Reason for the Refund Request.</b>";
if (strlen($_POST['refund_reason']) > 10 && $_POST['refund_select']) {
$refInfo = $transaction->process_refund_request(array("actor" => '.NET', 'notes' => $notes));
function step_2($en_ID, $skipIfComplete = true)
{
global $companyInfo, $etel_routing_types;
// Step 2
$access = array();
$access['SerializedData']['Source'] = 'en_info';
$access['SerializedData']['Data'] = array('Method' => array('Payment_Data', 'Method'), 'ACH_Bank_Name' => array('Payment_Data', 'ACH', 'Bank_Name'), 'ACH_Bank_Address' => array('Payment_Data', 'ACH', 'Bank_Address'), 'ACH_Bank_ZipCode' => array('Payment_Data', 'ACH', 'Bank_ZipCode'), 'ACH_Bank_City' => array('Payment_Data', 'ACH', 'Bank_City'), 'ACH_Bank_State' => array('Payment_Data', 'ACH', 'Bank_State'), 'ACH_Bank_Country' => array('Payment_Data', 'ACH', 'Bank_Country'), 'ACH_Bank_Phone' => array('Payment_Data', 'ACH', 'Bank_Phone'), 'ACH_Bank_Beneficiary_Name' => array('Payment_Data', 'ACH', 'Bank_Beneficiary_Name'), 'ACH_Bank_Account_Name' => array('Payment_Data', 'ACH', 'Bank_Account_Name'), 'ACH_Bank_Account_Number' => array('Payment_Data', 'ACH', 'Bank_Account_Number'), 'ACH_Bank_Routing_Number' => array('Payment_Data', 'ACH', 'Bank_Routing_Number'), 'ACH_Bank_Additional_Notes' => array('Payment_Data', 'ACH', 'Bank_Additional_Notes'), 'Wire_Bank_Name' => array('Payment_Data', 'Wire', 'Bank_Name'), 'Wire_Bank_Address' => array('Payment_Data', 'Wire', 'Bank_Address'), 'Wire_Bank_ZipCode' => array('Payment_Data', 'Wire', 'Bank_ZipCode'), 'Wire_Bank_City' => array('Payment_Data', 'Wire', 'Bank_City'), 'Wire_Bank_State' => array('Payment_Data', 'Wire', 'Bank_State'), 'Wire_Bank_Country' => array('Payment_Data', 'Wire', 'Bank_Country'), 'Wire_Bank_Phone' => array('Payment_Data', 'Wire', 'Bank_Phone'), 'Wire_Bank_Beneficiary_Name' => array('Payment_Data', 'Wire', 'Bank_Beneficiary_Name'), 'Wire_Bank_Account_Name' => array('Payment_Data', 'Wire', 'Bank_Account_Name'), 'Wire_Bank_Account_Number' => array('Payment_Data', 'Wire', 'Bank_Account_Number'), 'Wire_Bank_Routing_Number' => array('Payment_Data', 'Wire', 'Bank_Routing_Number'), 'Wire_Bank_Routing_Type' => array('Payment_Data', 'Wire', 'Bank_Routing_Type'), 'Wire_Bank_Sort_Code' => array('Payment_Data', 'Wire', 'Bank_Sort_Code'), 'Wire_Bank_VAT_Number' => array('Payment_Data', 'Wire', 'Bank_VAT_Number'), 'Wire_Bank_Registration_Number' => array('Payment_Data', 'Wire', 'Bank_Registration_Number'), 'Wire_Bank_Additional_Notes' => array('Payment_Data', 'Wire', 'Bank_Additional_Notes'), 'Wire_Intermediary_Bank_Routing_Type' => array('Payment_Data', 'Wire', 'Intermediary_Bank_Routing_Type'), 'Wire_Intermediary_Bank_Routing_Number' => array('Payment_Data', 'Wire', 'Intermediary_Bank_Routing_Number'), 'Wire_Intermediary_Bank_Name' => array('Payment_Data', 'Wire', 'Intermediary_Bank_Name'), 'Wire_Intermediary_Bank_City' => array('Payment_Data', 'Wire', 'Intermediary_Bank_City'), 'Wire_Intermediary_Bank_State' => array('Payment_Data', 'Wire', 'Intermediary_Bank_State'));
//if($companyInfo['cd_bank_routingcode']) $payment['Payment_Data']['Wire']['Bank_Routing_Type'] = $routingTypes[$companyInfo['cd_bank_routingcode']];
//if($companyInfo['bank_IBRoutingCodeType']) $payment['Payment_Data']['Wire']['Intermediary_Bank_Routing_Type'] = $routingTypes[$companyInfo['bank_IBRoutingCodeType']];
$access = getAccessInfo("\n\t\n\ten_ID,\n\ten_info,\n\t\n\t'Payment Method' as access_header,\n\t1 as 'Method',\n\t\n\t'ACH Banking Info' as access_header,\n \t\t1 as 'ACH_Bank_Name', 1 as 'ACH_Bank_Address', 1 as 'ACH_Bank_ZipCode', 1 as 'ACH_Bank_City', 1 as 'ACH_Bank_State', \n \t\t1 as 'ACH_Bank_Country', 1 as 'ACH_Bank_Phone', 1 as 'ACH_Bank_Beneficiary_Name', 1 as 'ACH_Bank_Account_Name', 1 as 'ACH_Bank_Account_Number', \n \t\t1 as 'ACH_Bank_Routing_Number', 1 as 'ACH_Bank_Additional_Notes',\n\t\t\n\t'Wire Banking Info' as access_header,\n \t\t1 as 'Wire_Bank_Name', 1 as 'Wire_Bank_Address', 1 as 'Wire_Bank_ZipCode', 1 as 'Wire_Bank_City', 1 as 'Wire_Bank_State', \n \t\t1 as 'Wire_Bank_Country', 1 as 'Wire_Bank_Phone', 1 as 'Wire_Bank_Beneficiary_Name', 1 as 'Wire_Bank_Account_Name', 1 as 'Wire_Bank_Account_Number', \n \t\t1 as 'Wire_Bank_Routing_Number', 1 as 'Wire_Bank_Routing_Type', 1 as 'Wire_Intermediary_Bank_Routing_Number',\n\t\t1 as 'Wire_Intermediary_Bank_Routing_Type',\t1 as 'Wire_Intermediary_Bank_Name', 1 as 'Wire_Intermediary_Bank_City', 1 as 'Wire_Intermediary_Bank_State', \n\t\t1 as 'Wire_Bank_Sort_Code', 1 as 'Wire_Bank_VAT_Number', 1 as 'Wire_Bank_Registration_Number', 1 as 'Wire_Bank_Additional_Notes'\n\t", "cs_entities", "en_ID = '{$en_ID}'", array('Size' => 30, 'Rows' => 2, 'HideIfEmpty' => true, 'Length' => 32, 'Valid' => 'req'), $access);
if ($access == -1) {
dieLog("Invalid Company", "Invalid Company");
}
$access['Data']['en_ID']['Input'] = "hidden";
$access['Data']['en_ID']['disable'] = 1;
$access['Data']['Method']['Input'] = "selectcustomarray";
$access['Data']['Method']['Input_Custom'] = array('' => 'Please Select a Method', 'Wire' => 'Wire (International)', 'ACH' => 'ACH (US Only)');
$access['Data']['Method']['InputAdditional'] = 'onchange="this.form.submit()"';
$access['Data']['ACH_Bank_Additional_Notes']['Valid'] = '';
$access['Data']['Wire_Bank_Additional_Notes']['Input'] = 'textarea';
$access['Data']['Wire_Bank_Additional_Notes']['Size'] = '50';
$access['Data']['Wire_Bank_Additional_Notes']['Rows'] = '6';
$access['Data']['ACH_Bank_Additional_Notes']['Input'] = 'textarea';
$access['Data']['ACH_Bank_Additional_Notes']['Size'] = '50';
$access['Data']['ACH_Bank_Additional_Notes']['Rows'] = '6';
$access['Data']['Wire_Bank_Sort_Code']['Valid'] = '';
$access['Data']['Wire_Bank_VAT_Number']['Valid'] = '';
$access['Data']['Wire_Bank_Registration_Number']['Valid'] = '';
$access['Data']['Wire_Bank_Additional_Notes']['Valid'] = '';
$access['Data']['Wire_Bank_Additional_Notes']['RowDisplay'] = 'Wide';
$access['Data']['ACH_Bank_Additional_Notes']['Valid'] = '';
$access['Data']['ACH_Bank_Additional_Notes']['RowDisplay'] = 'Wide';
$access['Data']['Wire_Bank_Country']['Style'] = 'width:205px;';
$access['Data']['Wire_Bank_Country']['Input'] = 'selectcustom';
$access['Data']['Wire_Bank_Country']['Input_Custom'] = "Select co_ISO,co_full From cs_country";
$access['Data']['Wire_Bank_Country']['InputAdditional'] = "onchange='" . "\$(\"Wire_Intermediary_Bank_Routing_Number\").setAttribute(\"valid\",(this.value!=\"US\"?\"req\":\"\"));" . "\$(\"Wire_Intermediary_Bank_Routing_Type\").setAttribute(\"valid\",(this.value!=\"US\"?\"req\":\"\"));" . "\$(\"Wire_Intermediary_Bank_Name\").setAttribute(\"valid\",(this.value!=\"US\"?\"req\":\"\"));" . "\$(\"Wire_Intermediary_Bank_City\").setAttribute(\"valid\",(this.value!=\"US\"?\"req\":\"\"));" . "\$(\"Wire_Intermediary_Bank_State\").setAttribute(\"valid\",(this.value!=\"US\"?\"req\":\"\"));" . "';" . ($access['Data']['Wire_Bank_State']['Input'] = 'selectcustom');
$access['Data']['Wire_Bank_State']['Style'] = 'width:205px;';
$access['Data']['Wire_Bank_State']['Input_Custom'] = "Select st_abbrev,st_full From cs_states";
$access['Data']['ACH_Bank_Country']['Style'] = 'width:205px;';
$access['Data']['ACH_Bank_Country']['Input'] = 'selectcustom';
$access['Data']['ACH_Bank_Country']['Input_Custom'] = "Select co_ISO,co_full From cs_country";
$access['Data']['ACH_Bank_State']['Input'] = 'selectcustom';
$access['Data']['ACH_Bank_State']['Style'] = 'width:205px;';
$access['Data']['ACH_Bank_State']['Input_Custom'] = "Select st_abbrev,st_full From cs_states";
$access['Data']['Wire_Intermediary_Bank_Routing_Type']['Input'] = "selectcustomarray";
$access['Data']['Wire_Intermediary_Bank_Routing_Type']['Input_Custom'] = $etel_routing_types;
$access['Data']['Wire_Bank_Routing_Type']['Input'] = "selectcustomarray";
$access['Data']['Wire_Bank_Routing_Type']['Input_Custom'] = $etel_routing_types;
$access['SubmitValue'] = 'Update Information';
if ($skipIfComplete) {
$access['SubmitValue'] = 'Continue to Step 3';
}
$access['SubmitName'] = 'submit_step2';
// Submit
$showvalidation = false;
if ($_POST[$access['SubmitName']] || $_POST['Method']) {
$result = processAccessForm(&$access);
$showvalidation = true;
}
$access['Columns'] = 1;
// Display Parsing
foreach ($access['Data'] as $key => $data) {
$access['Data'][$key]['DisplayName'] = preg_replace('/Wire |ACH /', '', $access['Data'][$key]['DisplayName']);
if ($access['Data']['Method']['Value'] != 'Wire') {
if (strpos($key, 'Wire_') !== false) {
unset($access['Data'][$key]);
}
if ($access['Data'][$key]['Name'] == 'access_header' && $access['Data'][$key]['Value'] == 'Wire Banking Info') {
unset($access['Data'][$key]);
}
}
if ($access['Data']['Method']['Value'] != 'ACH') {
if (strpos($key, 'ACH_') !== false) {
unset($access['Data'][$key]);
}
if ($access['Data'][$key]['Name'] == 'access_header' && $access['Data'][$key]['Value'] == 'ACH Banking Info') {
unset($access['Data'][$key]);
}
}
}
if ($access['Data']['Wire_Bank_Country']['Value'] == 'US') {
$access['Data']['Wire_Intermediary_Bank_Routing_Type']['Valid'] = '';
$access['Data']['Wire_Intermediary_Bank_Routing_Number']['Valid'] = '';
$access['Data']['Wire_Intermediary_Bank_Name']['Valid'] = '';
$access['Data']['Wire_Intermediary_Bank_City']['Valid'] = '';
$access['Data']['Wire_Intermediary_Bank_State']['Valid'] = '';
}
// Validate
$valid = true;
foreach ($access['Data'] as $key => $data) {
if (!$data['Value'] && $data['Valid']) {
$valid = false;
if ($showvalidation) {
$access['Data'][$key]['Highlight'] = true;
}
}
}
if (!$valid || !$skipIfComplete) {
draw_step_buttons(2, $skipIfComplete);
$access['HeaderMessage'] = "Please Complete all required fields to continue.";
beginTable();
writeAccessForm(&$access);
endTable("Step #2 - Company Information", "");
include "includes/footer.php";
die;
}
}
