require_once BASE_PATH . '/assets/includes/cart.inc.php';
require_once BASE_PATH . '/assets/includes/affiliate.inc.php';
define('META_TITLE', '');
// Override page title, description, keywords and page encoding here
define('META_DESCRIPTION', '');
define('META_KEYWORDS', '');
define('PAGE_ENCODING', '');
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
try {
$memberID = $_SESSION['member']['mem_id'];
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);
define('META_DESCRIPTION', '');
define('META_KEYWORDS', '');
define('PAGE_ENCODING', '');
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
require_once BASE_PATH . '/assets/classes/invoicetools.php';
require_once BASE_PATH . '/assets/classes/mediatools.php';
if (!$_GET['orderID']) {
// Make sure an order ID is passed and if not die
die("No order ID was passed");
}
try {
$invoice = new invoiceTools();
$invoice->setOrderID($orderID);
// Set the order ID
$invoiceTotals = new number_formatting();
// 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
$result = mysqli_query($db, $sql);
$keyID = mysqli_insert_id($db);
echo '{"errorCode": "1","keyID":"' . $keyID . '","errorMessage":""}';
break;
case "editContrMedia":
if (!$_SESSION['member']['mem_id']) {
exit;
}
// Don't continue if no session member id exists
if (!$_SESSION['loggedIn']) {
exit;
}
// Don't continue if member is not logged in
$memID = $_SESSION['member']['mem_id'];
// Shortcut
$cleanCurrency = new number_formatting();
// Setup a cleanup object for converting currency to the admin currency
$cleanCurrency->set_custom_cur_defaults($priCurrency['currency_id']);
$approvalStatus = $_SESSION['member']['membershipDetails']['approval'] ? 1 : 0;
// Check the approval status
if ($_SESSION['member']['membershipDetails']['admin_galleries']) {
mysqli_query($db, "DELETE FROM {$dbinfo[pre]}media_galleries WHERE gmedia_id = '{$mediaID}'");
// Do delete
} else {
// Delete any previous album assignment
$albumResult = mysqli_query($db, "\r\n\t\t\t\t\t\tSELECT {$dbinfo[pre]}galleries.gallery_id \r\n\t\t\t\t\t\tFROM {$dbinfo[pre]}galleries\r\n\t\t\t\t\t\tLEFT JOIN {$dbinfo[pre]}media_galleries \r\n\t\t\t\t\t\tON {$dbinfo[pre]}galleries.gallery_id = {$dbinfo[pre]}media_galleries.gallery_id \r\n\t\t\t\t\t\tWHERE {$dbinfo[pre]}media_galleries.gmedia_id = '{$mediaID}' \r\n\t\t\t\t\t\tAND {$dbinfo[pre]}galleries.album = 1 \r\n\t\t\t\t\t\tAND {$dbinfo[pre]}galleries.owner = '{$memID}' \r\n\t\t\t\t\t\t");
if (mysqli_num_rows($albumResult)) {
while ($album = mysqli_fetch_array($albumResult)) {
mysqli_query($db, "DELETE FROM {$dbinfo[pre]}media_galleries WHERE gmedia_id = '{$mediaID}' AND gallery_id = '{$album[gallery_id]}'");
// Do delete
//$sql = "UPDATE {$dbinfo[pre]}invoices SET payment_status='6' WHERE invoice_id = '{$bill[invoice_id]}'";
define('META_DESCRIPTION', '');
define('META_KEYWORDS', '');
define('PAGE_ENCODING', '');
$memberID = $_SESSION['member']['mem_id'];
if (!$memberID) {
die('No member ID exists');
}
// Just to be safe make sure a memberID exists before continuing
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/init.contributor.php';
require_once BASE_PATH . '/assets/includes/errors.php';
require_once BASE_PATH . '/assets/classes/mediatools.php';
try {
$runningPaidTotal = 0;
$runningUnpaidTotal = 0;
$saleCur = new number_formatting();
// Used to make sure the bills are showing in the admins currency
$saleCur->set_custom_cur_defaults($config['settings']['defaultcur']);
$parms['noDefault'] = true;
$contrSalesResult = mysqli_query($db, "\r\n\t\t\tSELECT * FROM {$dbinfo[pre]}commission \r\n\t\t\tLEFT JOIN {$dbinfo[pre]}invoice_items \r\n\t\t\tON {$dbinfo[pre]}commission.oitem_id = {$dbinfo[pre]}invoice_items.oi_id \r\n\t\t\tWHERE {$dbinfo[pre]}commission.contr_id = '{$_SESSION[member][mem_id]}' \r\n\t\t\tAND {$dbinfo[pre]}commission.order_status = '1' \r\n\t\t\tORDER BY {$dbinfo[pre]}commission.com_id DESC\r\n\t\t");
if ($saleRows = mysqli_num_rows($contrSalesResult)) {
while ($contrSales = mysqli_fetch_assoc($contrSalesResult)) {
if ($contrSales['omedia_id']) {
/*
$media = new mediaTools($contrSales['omedia_id']);
$mediaInfo = $media->getMediaInfoFromDB();
$thumbInfo = $media->getIconInfoFromDB();
$verify = $media->verifyMediaSubFileExists('icons');
$mediaStatus = $verify['status'];
*/
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM {$dbinfo[pre]}media WHERE media_id = '{$contrSales[omedia_id]}'";
require_once BASE_PATH . '/assets/includes/commands.php';
require_once BASE_PATH . '/assets/includes/init.member.php';
require_once BASE_PATH . '/assets/includes/security.inc.php';
require_once BASE_PATH . '/assets/includes/language.inc.php';
require_once BASE_PATH . '/assets/includes/cart.inc.php';
require_once BASE_PATH . '/assets/includes/affiliate.inc.php';
define('META_TITLE', '');
// Override page title, description, keywords and page encoding here
define('META_DESCRIPTION', '');
define('META_KEYWORDS', '');
define('PAGE_ENCODING', '');
require_once BASE_PATH . '/assets/includes/header.inc.php';
require_once BASE_PATH . '/assets/includes/errors.php';
require_once BASE_PATH . '/assets/classes/invoicetools.php';
try {
$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;
if (!$billID and !$orderID) {
die('No bill/order ID was passed');
}
// Just to be safe make sure a bill/order ID was passed
$invoiceObj = new invoiceTools();
// Create new invoice object
$invoiceObj->options = false;
// Do not select options here
$adminCurrency = getCurrencyInfo($config['settings']['defaultcur']);
if ($billID) {
$invoiceObj->setUBillID($billID);
if ($billInfo = $invoiceObj->getBillDetails()) {
