<?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; } }