INSTRUCTION: REBILL only after customer confirms funds have been added.)"; } if( ($set_reason_code == "10") ) { $update_deposit_status = "FAILED"; $update_outgoing_status = "FAILED"; $update_incoming_status = "Chargeback"; $update_deposit_return_reason = "FAILED"; $update_outgoing_return_reason = "FAILED"; $update_incoming_return_reason = "SEPA Blocked. (Customer must call bank to \"activate SEPA Direct Debit\".)

INSTRUCTION: REBILL after customer confirms \"SEPA activation\"."; // actually, "Unknown Reason" } $datetime_updated = datetime(); ##################################################################################### ##################################################################################### #################################### ### UPDATE THE "DEPOSIT" TRANSACTION $tmp_sql = "UPDATE transactions SET status = '" . $update_deposit_status . "', return_datetime = '" . $datetime_updated . "', return_reason = '" . $update_deposit_return_reason . "' WHERE transactionid = '" . $transaction_deposit['transactionid'] . "';"; $tmp_update = updateTHECASHIER($tmp_sql); logger3("tmp_sql",$tmp_sql); logger3("tmp_update",$tmp_update); #################################### ### UPDATE THE ASSOCIATED "OUTGOING" TRANSFER: $tmp_sql = "UPDATE transactions SET status = '" . $update_outgoing_status . "', return_datetime = '" . $datetime_updated . "', return_reason = '" . $update_outgoing_return_reason . "' WHERE transactionid = '" . $transaction_outgoing['transactionid'] . "';"; $tmp_update = updateTHECASHIER($tmp_sql); logger3("tmp_sql",$tmp_sql); logger3("tmp_update",$tmp_update); #################################### ### UPDATE THE ASSOCIATED "INCOMING" TRANSACTION: //$balance_of_customer_before = balance($transaction_deposit['accountid']); // no need -- customer is a wash $balance_of_business_before = balance($transaction_incoming['accountid']); logger3("balance_of_business_before",$balance_of_business_before); logger3("transaction_incoming['fee_total_value']",$transaction_incoming['fee_total_value']); logger3("transaction_incoming['transaction_gross_value']",$transaction_incoming['transaction_gross_value']); $transaction_incoming['net_value'] = currency_format($transaction_incoming['transaction_gross_value'] - $transaction_incoming['fee_total_value']); logger3("incoming_net_value",$transaction_incoming['net_value']); //$balance_of_customer_after = $balance_of_customer_before['account'] - $transaction_deposit['transaction_gross_value']; // no need -- customer is a wash $balance_of_business_after['account'] = currency_format($balance_of_business_before['account_balance'] - $transaction_incoming['net_value']); logger3("balance_of_business_after['account']",$balance_of_business_after['account']); if( ($transaction_deposit['rolling_release_datetime'] != NULL) && ($transaction_deposit['rolling_release_datetime'] != "NULL") && ($transaction_deposit['rolling_release_datetime'] != "") && ($transaction_deposit['rolling_release_datetime'] != " ") ) { /// deduct from available balance: $balance_of_business_after['available'] = currency_format($balance_of_business_before['available'] - $transaction_incoming['net_value']); } else { $balance_of_business_after['available'] = currency_format($balance_of_business_before['available']); } logger3("balance_of_business_after",$balance_of_business_after); updateTHECASHIER("UPDATE balances SET account_balance = '" . $balance_of_business_after['account'] . "', available = '" . $balance_of_business_after['available'] . "' WHERE accountid = '" . $transaction_incoming['accountid'] . "';"); $tmp_sql = "UPDATE transactions SET status = '" . $update_incoming_status . "', return_datetime = '" . $datetime_updated . "', return_reason = '" . $update_incoming_return_reason . "', return_account_balance_before = '" . $balance_of_business_before['account'] . "', return_account_balance_after = '" . $balance_of_business_after['account'] . "', return_available_balance_before = '" . $balance_of_business_before['available'] . "', return_available_balance_after = '" . $balance_of_business_after['available'] . "' WHERE transactionid = '" . $transaction_incoming['transactionid'] . "';"; $tmp_update = updateTHECASHIER($tmp_sql); #################################### ### UPDATE THE ASSOCIATED "INCOMING" TRANSFER: $tmp_sql = "UPDATE transactions SET status = '" . $update_incoming_status . "', return_datetime = '" . $datetime_updated . "', return_reason = '" . $update_incoming_return_reason . "' WHERE transactionid = '" . $transaction_incoming['transactionid'] . "';"; $tmp_update = updateTHECASHIER($tmp_sql); logger3("tmp_sql",$tmp_sql); logger3("tmp_update",$tmp_update); ### EMAIL RECEIPT: $business_account = account($transaction_incoming['accountid']); logger3("business_account",$business_account); $customer_account = account($transaction_deposit['accountid']); logger3("customer_account",$customer_account); $customer_member = member($transaction_deposit['memberid']); logger3("customer_member",$customer_member); $email_receipt = "chargeback_business"; //include($_SESSION['template']['company']['file_path'] . "shared/email_receipts.shared"); $email_receipt = "reversal_customer"; //include($_SESSION['template']['company']['file_path'] . "shared/email_receipts.shared"); echo "OK"; ?>