if (!$memberID) {
die('No member ID exists');
}
// Just to be safe make sure a memberID exists before continuing
$billTotal = new number_formatting();
// Used to make sure the bills are showing in the admins currency
$billTotal->set_custom_cur_defaults($config['settings']['defaultcur']);
$parms['noDefault'] = true;
$billResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}billings\r\n\t\t\tLEFT JOIN {$dbinfo[pre]}invoices \r\n\t\t\tON {$dbinfo[pre]}billings.bill_id = {$dbinfo[pre]}invoices.bill_id\r\n\t\t\tWHERE {$dbinfo[pre]}billings.member_id = {$memberID}\r\n\t\t\tAND {$dbinfo[pre]}billings.deleted = 0\r\n\t\t\tORDER BY {$dbinfo[pre]}invoices.invoice_date DESC\r\n\t\t\t");
if ($returnRows = mysqli_num_rows($billResult)) {
while ($bill = mysqli_fetch_assoc($billResult)) {
$billsArray[$bill['bill_id']] = $bill;
$billsArray[$bill['bill_id']]['invoice_date_display'] = $customDate->showdate($bill['invoice_date'], 0);
$billsArray[$bill['bill_id']]['due_date_display'] = $customDate->showdate($bill['due_date'], 0);
if ($bill['payment_status'] != 2) {
$cleanTotal['display'] = $billTotal->currency_display($bill['total'], 1);
$cleanTotal['raw'] = round($price, 2);
$billsArray[$bill['bill_id']]['total'] = $cleanTotal;
} else {
$billsArray[$bill['bill_id']]['total'] = getCorrectedPrice($bill['total'], $parms);
}
// Unpaid invoice can show in the members currency
$billsArray[$bill['bill_id']]['payment_status_lang'] = billStatusNumToText($bill['payment_status']);
if ($nowGMT > $bill['due_date'] and ($bill['payment_status'] == 2 or $bill['payment_status'] == 4)) {
$billsArray[$bill['bill_id']]['past_due'] = true;
}
// See if the bill is past due
}
$smarty->assign('notice', $notice);
$smarty->assign('billsArray', $billsArray);
$smarty->assign('billRows', $returnRows);
// Used to make sure the bills are showing in the admins currency
$invoiceTotals->set_custom_cur_defaults($config['settings']['defaultcur']);
$parms['noDefault'] = true;
$adminCurrency = getCurrencyInfo($config['settings']['defaultcur']);
if ($orderInfo = $invoice->getOrderDetails()) {
$invoiceInfo = $invoice->getInvoiceDetailsViaOrderDBID($orderInfo['order_id']);
$invoiceItemsCount = $invoice->queryInvoiceItems();
// Number of invoice items total
//print_r($invoiceInfo); exit;
$invoice->options = false;
// Do not select options here
$digitalInvoiceItems = $invoice->getDigitalItems();
$physicalInvoiceItems = $invoice->getPhysicalItems();
$orderInfo['orderPlacedDate'] = $customDate->showdate($orderInfo['order_date'], 0);
// Convert to local date
$invoiceInfo['total'] = $invoiceTotals->currency_display($invoiceInfo['total'], 1);
$invoiceInfo['priceSubTotal'] = $invoiceTotals->currency_display($invoiceInfo['subtotal'], 1);
$invoiceInfo['shippingTotal'] = $invoiceTotals->currency_display($invoiceInfo['shipping_cost'], 1);
$invoiceInfo['taxA'] = $invoiceTotals->currency_display($invoiceInfo['taxa_cost'], 1);
$invoiceInfo['taxB'] = $invoiceTotals->currency_display($invoiceInfo['taxb_cost'], 1);
$invoiceInfo['taxC'] = $invoiceTotals->currency_display($invoiceInfo['taxc_cost'], 1);
$invoiceInfo['discountsTotal'] = $invoiceTotals->currency_display($invoiceInfo['discounts_total'] * -1, 1);
$maxDownloadAttempts = $config['settings']['dl_attempts'] == 0 ? 999 : $config['settings']['dl_attempts'];
// Find the max download attempts - if unlimited use 999
// Added the download authorization to prevent sharing of download links
if ($orderInfo['order_status'] == 1) {
// Order is approved
//print_k($orderInfo); exit;
$_SESSION['downloadAuthorization'] = k_encrypt($orderInfo['order_id']);
} else {
$_SESSION['downloadAuthorization'] = false;
// Do not select options here
$adminCurrency = getCurrencyInfo($config['settings']['defaultcur']);
if ($billID) {
$invoiceObj->setUBillID($billID);
if ($billInfo = $invoiceObj->getBillDetails()) {
$invoice = $invoiceObj->getInvoiceDetailsViaBillDBID($billInfo['bill_id']);
if ($billInfo['bill_type'] == 2) {
$ordersResult = mysqli_query($db, "\r\n\t\t\t\t\t\tSELECT * FROM {$dbinfo[pre]}orders \r\n\t\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}invoices \r\n\t\t\t\t\t\tON {$dbinfo[pre]}orders.order_id = {$dbinfo[pre]}invoices.order_id\r\n\t\t\t\t\t\tWHERE {$dbinfo[pre]}orders.bill_id = {$billInfo[bill_id]}\r\n\t\t\t\t\t\t");
// Select invoice items
$invoiceItemsCount = mysqli_num_rows($ordersResult);
while ($order = mysqli_fetch_array($ordersResult)) {
$invoiceItems[$order['order_id']] = $order;
$invoiceItems[$order['order_id']]['name'] = "{$lang[order]} {$order[order_number]}";
$invoiceItems[$order['order_id']]['quantity'] = 1;
if ($invoice['payment_status'] != 2) {
$invoiceItems[$order['order_id']]['price_total'] = $billTotal->currency_display($order['total'], 1);
} else {
$priceTotal = getCorrectedPrice($order['total'], $parms);
// Unpaid invoice can show in the members currency
$invoiceItems[$order['order_id']]['price_total'] = $priceTotal['display'];
}
}
} else {
$invoiceItemsCount = $invoiceObj->queryInvoiceItems();
// Number of invoice items total
$invoiceItems = $invoiceObj->getInvoiceItemsRaw();
}
}
}
if ($orderID) {
$invoiceObj->setOrderID($orderID);
} else {
$contrSales['itemName'] = 'orig';
}
}
switch ($contrSales['compay_status']) {
case 0:
// Unpaid
$textMatch = 'unpaid';
break;
case 1:
// PAID/APPROVED
$textMatch = 'paid';
break;
}
$contrSales['statusDisplayLang'] = $textMatch;
$contrSales['commissionDisplay'] = $saleCur->currency_display($itemCommission, 1);
$contrSales['orderDateDisplay'] = $customDate->showdate($contrSales['order_date'], 0);
if ($contrSales['compay_status'] == 1) {
$runningPaidTotal += $itemCommission;
} else {
$runningUnpaidTotal += $itemCommission;
}
$salesArray[$contrSales['com_id']] = $contrSales;
}
}
$runningPaidTotalDisplay = $saleCur->currency_display($runningPaidTotal, 1);
$runningUnpaidTotalDisplay = $saleCur->currency_display($runningUnpaidTotal, 1);
$smarty->assign('runningPaidTotalDisplay', $runningPaidTotalDisplay);
$smarty->assign('runningUnpaidTotalDisplay', $runningUnpaidTotalDisplay);
//print_r($salesArray);
$smarty->assign('salesArray', $salesArray);
try {
$memberID = $_SESSION['member']['mem_id'];
if (!$memberID) {
die('No member ID exists');
}
// Just to be safe make sure a memberID exists before continuing
$orderTotal = new number_formatting();
// Used to make sure the bills are showing in the admins currency
$orderTotal->set_custom_cur_defaults($config['settings']['defaultcur']);
$parms['noDefault'] = true;
$orderResult = mysqli_query($db, "\r\n\t\t\tSELECT *\r\n\t\t\tFROM {$dbinfo[pre]}orders\r\n\t\t\tLEFT JOIN {$dbinfo[pre]}invoices ON {$dbinfo[pre]}orders.order_id = {$dbinfo[pre]}invoices.order_id\r\n\t\t\tWHERE {$dbinfo[pre]}orders.member_id = {$memberID} \r\n\t\t\tAND {$dbinfo[pre]}orders.order_status != '2' \r\n\t\t\tAND {$dbinfo[pre]}orders.deleted = 0 \r\n\t\t\tORDER BY {$dbinfo[pre]}orders.order_date DESC\r\n\t\t\t");
if ($returnRows = mysqli_num_rows($orderResult)) {
while ($order = mysqli_fetch_assoc($orderResult)) {
$ordersArray[$order['order_id']] = $order;
$ordersArray[$order['order_id']]['order_date_display'] = $customDate->showdate($order['order_date'], 1);
$cleanTotal['display'] = $orderTotal->currency_display($order['total'], 1);
$cleanTotal['raw'] = round($order['total'], 2);
$ordersArray[$order['order_id']]['total'] = $cleanTotal;
$ordersArray[$order['order_id']]['order_payment_lang'] = orderPaymentNumToText($order['payment_status']);
$ordersArray[$order['order_id']]['order_status_lang'] = orderStatusNumToText($order['order_status']);
}
$smarty->assign('ordersArray', $ordersArray);
$smarty->assign('orderRows', $returnRows);
}
$smarty->display('orders.tpl');
} catch (Exception $e) {
echo $e->getMessage();
}
include BASE_PATH . '/assets/includes/debug.php';
if ($db) {
mysqli_close($db);
