\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; // // School account processing // if ($balance > 0 && !isset($selected_amount)) { if ($school_record['school_account_enabled'] == 'Y') { ?>

" . $school_record['school_account_title'] . "

\n"); ?> " . $school_record['school_account_text'] . "

\n"); ?> " . getLanguageText('TEXT-BALANCE') . ": $currencySymbol" . number_format($balance,2) . "

\n"); ?>

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) { ?>

'>".getLanguageText('TEXT-CREDIT-CARD-PAYMENT').""); } } echo("
\n"); echo("
\n"); echo("
\n"); echo("
\n"); } } // // PayPal Account Payments // if ($school_record['paypal_enabled'] == 'Y' && strlen($school_record['paypal_code']) > 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['paypal_minimum_amount']) { $trx_time = date("Y-m-d H:i:s",$now); // if (!$onlineMessageDisplayed && strlen($onlineMessage)) { // displayStatusMessage($onlineMessage,"warningframedspan"); // $onlineMessageDisplayed = true; // } // Calculate the transaction fee $trx_time = date("Y-m-d H:i:s",$now); $trx_fee = intval($balance * $school_record['paypal_percentage']) / 100 + $school_record['paypal_fee']; $owing = $balance + $trx_fee; // 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(); } $message = getLanguageText('TEXT-PAYPAL-DELAY-MSG'); // displayStatusMessage($message,"warningframedspan"); // If there is a transaction fee if ($trx_fee != 0) { $trx_title = getLanguageText('TEXT-TRX-FEE'); if (strlen($school_record['paypal_fee_title'])) $trx_title = $school_record['paypal_fee_title']; ?>

0) { ?>

\n"; try { ob_start(); include $oldPpBtnFile; $oldPpBtnOut = ob_get_clean(); echo "\n"; echo $oldPpBtnOut; } catch (\Throwable $e) { if (ob_get_level() > 0) ob_end_clean(); echo "\n"; } echo("
\n"); } } // End of PayPal Code // // Square Account Payments // Deploy: this file lives at / (home). Square lives at /square/. // The "Pay with Square" button appears ONLY when this school is onboarded with // Square (connected, not revoked, Square location able to take payments); for // every other school nothing is rendered. Payments are charged with the // school's own Square token, so the money goes to that school's Square account. // Buffered + wrapped like the PayPal button so a failure here can never break // the rest of the payment page. // $sqRoot = rtrim((string)($_SERVER['DOCUMENT_ROOT'] ?? ''), '/\\'); $sq_button = $sqRoot . '/square/square_button.php'; if (!is_file($sq_button) && is_file(__DIR__ . '/square/square_button.php')) { $sq_button = __DIR__ . '/square/square_button.php'; } if (!is_file($sq_button) && is_file(__DIR__ . '/../square_button.php')) { $sq_button = __DIR__ . '/../square_button.php'; } if (is_file($sq_button)) { try { ob_start(); include $sq_button; $sqBtnOut = ob_get_clean(); if (strpos($sqBtnOut, 'sq-pay-btn') !== false) $sqBtnOut .= "
\n"; echo $sqBtnOut; } catch (\Throwable $e) { if (ob_get_level() > 0) ob_end_clean(); if (function_exists('writeLog')) writeLog('square button error: ' . $e->getMessage()); echo "\n\n"; } } else { echo "\n\n"; } // // E-xact Account Payments // if ($school_record['exact_enabled'] == 'Y' && strlen($school_record['exact_code']) > 0) { // Calculate the transaction fee $trx_time = date("Y-m-d H:i:s",$now); $trx_fee = intval($balance * $school_record['exact_percentage']) / 100 + $school_record['exact_fee']; $owing = $balance + $trx_fee; // 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) { ?>

\n"); } // End of Exact code // // Merchant Account Payments // if ($school_record['merchant_account_enabled'] != 'None' && strlen($school_record['merchant_account_key_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; $owing = $balance; // Calculate any payment discounts $today = date("Y-m-d",$now); $payment_discount = 0; $query = "SELECT * FROM payment_discounts WHERE school_num = $school_num AND start_date <= '$today' AND end_date >= '$today'"; $results = db_query($query); if (db_num_rows($results)) { $row = db_fetch_assoc($results); $discount_type = $row['discount_type']; $discount = $row['discount']; $discount_message = $row['discount_message']; switch ($discount_type) { case 'Amount': $payment_discount = $discount; break; case 'Percentage': $payment_discount = round($owing * $discount) / 100; break; } $owing = $owing - $payment_discount; } // Calculate the transaction fee $trx_time = date("Y-m-d H:i:s",$now); $trx_fee = intval($owing * $school_record['merchant_account_percentage']) / 100 + $school_record['merchant_account_fee']; $owing = $owing + $trx_fee; // 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, " . "payment_discount = $payment_discount, " . "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,payment_discount,transaction_fee,balance_owing,status) " . "values ($school_num,$user_num,'$trx_time',$now,$balance,$payment_discount,$trx_fee,$owing,'Pending')"; db_query($query); $trxnum = db_insert_id(); } // If there is a payment discount message if ($payment_discount > 0) { ?>

:
:

0) { ?>

\n"); } // End of Merchant Account code if ($balance > 0 && !isset($selected_amount)) { if ($school_record['display_remittance_button'] == 'Y') { $btnText = trim($school_record['remittance_button_text']); if (strlen($btnText) == 0) $btnText = getLanguageText('TEXT-PRINT-REMITTANCE'); ?>

0) { echo("

" . nl2br($text) . "

\n"); } } } } ?>