}
if (!is_numeric($transInfo['bankroutingcode'])) {
$transInfo['bankroutingcode'] = etelDec($transInfo['bankroutingcode']);
}
$serarray = array($transInfo['CCnumber'], $transInfo['bankaccountnumber'], $transInfo['bankroutingcode']);
$transInfo['td_process_query'] = str_replace($reparray, $serarray, $transInfo['td_process_query']);
$transInfo['td_process_result'] = str_replace($reparray, $serarray, $transInfo['td_process_result']);
etelPrint($transInfo);
//etelPrint($transInfo['td_process_result']);
$sql = "update cs_transactiondetails set \r\n\ttd_process_query = '" . quote_smart($transInfo['td_process_query']) . "',\r\n\ttd_process_result = '" . quote_smart($transInfo['td_process_result']) . "' \r\n\twhere transactionId = '" . intval($transInfo['transactionId']) . "' limit 1";
//mysql_query($sql) or dieLog(mysql_errno().": ".mysql_error()."<BR>$sql");
//echo mysql_affected_rows().'<BR>';
$affected += mysql_affected_rows();
die;
$Rates = new rates_fees();
$ratesInfo = $Rates->get_MerchantRates(1328);
$output = "<table style='report' border='1' width='100%'>\n";
$disp_array = array('trans' => 'Transaction Fee', 'disct' => 'Discount Rate', 'decln' => 'Decline Fee', 'refnd' => 'Refund Fee', 'chgbk' => 'Chargeback Fee', 'rserv' => 'Reserve Rate', 'cstsv' => 'Customer Service Fee');
$ratesInfo['Default Rates']['trans_type'] = "All other forms of Payment.";
foreach ($ratesInfo as $key => $banks) {
$output .= "<tr><td colspan='2'><b>Transaction Type: " . $banks['trans_type'] . "</b></td></tr>\n";
foreach ($banks['default']['Processor'] as $transtype => $rate) {
if ($disp_array[$transtype]) {
$output .= "<tr><td>" . $disp_array[$transtype] . "</td><td>{$rate}</td></tr>\n";
}
}
}
$output .= "</table >\n";
echo $output;
print_r($ratesInfo);
die;
$my_sql['skip_subquery'] = true;
$export_subname = '';
}
ob_end_clean();
$filename = 'Export' . $export_subname . '.csv';
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="' . $filename . '"');
echo "\n";
flush();
}
$result = smart_search($my_sql);
if ($export_data) {
if ($subquery_group == 'CB' && $result['sub_row']) {
$RF = new rates_fees();
foreach ($result['sub_row'] as $key => $row) {
$rates = @array_pop($RF->get_MerchantRates($row['en_ID'], array(intval($row['bank_id']))));
$cats = $RF->get_RateCategories();
if (!$rates) {
// Default rates
$rates = @array_pop($RF->get_MerchantRates($row['en_ID'], array(0)));
}
//etelPrint($row);etelPrint($rates);etelDie();
foreach ($rates['default']['Processor'] as $rate => $val) {
$result['sub_row'][$key]['proc_' . $rate] = $cats[$rate]['before'] . round($val, 2) . $cats[$rate]['after'];
}
foreach ($rates['default']['Bank'] as $rate => $val) {
$result['sub_row'][$key]['bank_' . $rate] = $cats[$rate]['before'] . round($val, 2) . $cats[$rate]['after'];
}
}
$my_sql['subquery']['queries']['3a|Proc_TransFee'] = array("name" => "proc_trans");
$my_sql['subquery']['queries']['3b|Proc_Disc'] = array("name" => "proc_disct");
$bank_name = $banks[$bank_id]['bank_name'];
$new_settings[$bank_name]['bank_id'] = $bank_id;
if ($tier == "d") {
$new_settings[$bank_name]['default'][$payee][$field] = round($value, 2);
} else {
$new_settings[$bank_name]['tier'][$tier][$payee][$field] = round($value, 2);
}
}
}
}
}
}
$rates_class->post_MerchantRate($en_ID, $new_settings);
}
$banks = $rates_class->get_BanksById();
$company_rates = $rates_class->get_MerchantRates($en_ID);
$payees = $rates_class->get_Payees();
$rate_cats = $rates_class->get_RateCategories();
$num_rate_cats = sizeof($rate_cats);
$data = JSON_get_data(array('func' => 'getEntityList', 'en_search' => array($en_ID), 'en_search_by' => array('id'), 'silent' => 1));
$json = new Services_JSON();
$JSON_output = $json->encode($data);
?>
<script language="javascript" src="<?php
echo $rootdir;
?>
/scripts/dynosearch.js"></script>
<script language="javascript">
function modify_row(id,disp)
{
print_r($data);
echo "<BR><BR>";
} else {
echo "Skipped<BR>";
}
}
}
die;
// Add wire fees!
$RF = new rates_fees();
$sql = " select * from cs_profit_action\r\n\tleft join cs_profit on pa_ID = pt_action_ID and pt_type = 'Funds Transfer Fee'\r\nwhere pa_type='Payout' and pt_ID is null \r\n";
$result = sql_query_read($sql) or dieLog(mysql_error() . $sql);
while ($invoiceInfo = mysql_fetch_assoc($result)) {
$en_ID = $invoiceInfo['pa_en_ID'];
$entityInfo = en_get_general_info($en_ID);
$ratesInfo = $RF->get_MerchantRates($en_ID, array(0));
// Wire/ACH Fee
$usefee = 'wirefee';
if ($entityInfo['en_info']['Payment_Data']['Method'] == 'ACH') {
$usefee = 'achfee';
}
$amount = $ratesInfo[0]['default']['Processor'][$usefee];
if (!$amount) {
$amount = 50;
}
$sql = " insert into cs_profit set \r\n\t\tpt_amount = '{$amount}',\r\n\t\tpt_date_effective = '" . $invoiceInfo['pa_date'] . "',\r\n\t\tpt_action_ID = '" . $invoiceInfo['pa_ID'] . "',\r\n\t\tpt_to_entity_ID = '2',\r\n\t\tpt_from_entity_ID = '{$en_ID}',\r\n\t\tpt_type = 'Funds Transfer Fee'\r\n\t";
sql_query_read($sql) or dieLog(mysql_error() . $sql);
}
die;
$sql = "Select en.en_ID, en.en_company, `mi_ID` , `mi_company_id` , `mi_date` , `mi_paydate`, `mi_notes` , `mi_title` , `mi_balance` , `mi_deduction` , `mi_status` from cs_merchant_invoice as mi left join cs_entities as en on en_type='merchant' and en_type_ID = mi_company_id and mi_status in ('WireSent', 'WireSuccess') ";
$result = sql_query_read($sql) or dieLog(mysql_error() . $sql);
