<?php require_once 'app/master.php'; $master = Master::getInstance(); include 'index.php';
function SaveOrder($abv, $amt, $total, $surcharge) { $db = Master::getInstance(); $mysqli = $db->getConnection(); $res = $mysqli->query("select id, name, rates, surchage from fcurrency where abreviation = '{$abv}'"); $row = $res->fetch_assoc(); $fCurrencyID = $row['id']; $name = $row['name']; $surchageAmount = $surcharge; $r = $mysqli->query("insert into purchase_order (amount_purchased, amount_to_be_paid, amount_surcharged, date_created, fcurrency_id) values ('{$amt}', '{$total}', '{$surchageAmount}', NOW(), '{$fCurrencyID}')"); $n = $mysqli->affected_rows; if ($n == 1) { $orderID = $mysqli->insert_id; if ($abv == "GBP") { $message = "Foreign Currency purchased: " . $name . "\n Amount Purchased = " . $amt . "\n Amount to pay in ZAR = " . $total . "\n"; $db->sendMail($message); } if ($abv == "EUR") { $afterDiscount = $total - $total * 0.02; $results = $mysqli->query("update purchase_order set after_discount = {$afterDiscount} where id = '{$orderID}'"); } return TRUE; } return FALSE; }