\n"; switch ($school_num) { case 251: case 19438: $onlineMessage .= "-- Please note that Interac Debit cards are not accepted --"; break; default: $onlineMessage .= "-- Please note that MasterCard Debit and Interac Debit cards are not accepted --"; break; } $onlineMessageDisplayed = false; // // Bambora Form // if ($school_record['bambora_enabled'] == 'Y' && strlen($school_record['bambora_merchant_id']) > 0) { // Get current balance $balance = db_getVal("select sum(transaction_amount) as balance from user_account where school_num = $school_num and user_num = $user_num AND (deleted != 'Y' OR deleted IS NULL)"); if (!$balance) $balance = 0.00; if (isset($selected_amount) && $selected_amount > 0) $balance = $selected_amount; if ($balance >= $school_record['bambora_minimum_amount']) { $trx_time = date("Y-m-d H:i:s",$now); // Calculate the transaction fee $trx_time = date("Y-m-d H:i:s",$now); $trx_fee = intval($balance * $school_record['bambora_percentage']) / 100 + $school_record['bambora_fee']; $owing = $balance + $trx_fee; if (!$onlineMessageDisplayed && strlen($onlineMessage)) { displayStatusMessage($onlineMessage,"warningframedspan"); $onlineMessageDisplayed = true; } // Calculate any payment discounts // Check for an entry to the online payments table $query = "select * from user_online_payments " . "where school_num = $school_num " . "and user_num = $user_num " . "and status = 'Pending'"; $results = db_query($query); if (db_num_rows($results) > 0) { $row = db_fetch_array($results); $trxnum = $row['record_num']; $query = "update user_online_payments " . "set user_account_balance = $balance, " . "transaction_fee = $trx_fee, " . "balance_owing = $owing, " . "transaction_datetime = '$trx_time', " . "transaction_time = $now " . "where school_num = $school_num " . "and user_num = $user_num " . "and status = 'Pending'"; db_query($query); } else { $query = "insert into user_online_payments (school_num,user_num,transaction_datetime,transaction_time,user_account_balance,transaction_fee,balance_owing,status) " . "values ($school_num,$user_num,'$trx_time',$now,$balance,$trx_fee,$owing,'Pending')"; db_query($query); $trxnum = db_insert_id(); } // If there is a transaction fee if ($trx_fee != 0 || strlen(trim($school_record['bambora_fee_message'])) > 0) { $trx_title = getLanguageText('TEXT-TRX-FEE'); if (strlen($school_record['bambora_fee_title'])) $trx_title = $school_record['bambora_fee_title']; ?> 0) { ?> \n"); echo(" \n"); echo(" \n"); echo(" \n"); } } ?>