order.php

<?PHP
	require 'includes/master.inc.php';
	$Auth->requireAdmin('login.php');
	$nav = 'orders';

	$o = new Order(@$_GET['id']);
	if(!$o->ok()) redirect('orders.php');

	if(isset($_GET['act']) && $_GET['act'] == 'email')
		$o->emailLicense();
	
	if(isset($_GET['act']) && $_GET['act'] == 'download')
		$o->downloadLicense();

	if(isset($_GET['act']) && $_GET['act'] == 'upgrade')
	{
		$upgraded_order = $o->upgradeLicense();
		redirect('order.php?id=' . $upgraded_order->id);
		exit;
	}
	
	if(isset($_GET['act']) && $_GET['act'] == 'deactivate')
	{
		$o->deactivated = 1;
		$o->update();
		redirect('order.php?id=' . $o->id);
	}

	if(isset($_GET['act']) && $_GET['act'] == 'delete')
	{
		$o->delete();
		redirect('orders.php');
	}

	if(isset($_POST['btnNotes']))
	{
		$o->notes = $_POST['notes'];
		$o->update();
		redirect('order.php?id=' . $o->id);
	}
	
	$lt_id = $o->license_type_id;
	if (!empty($lt_id)) {
		$lt = new LicenseType($lt_id);
		if (!$lt->ok()) unset($lt);
	}

	$app = new Application($o->app_id);

	// Get related orders
	$db = Database::getDatabase();
	$orders = DBObject::glob('Order', 'SELECT * FROM shine_orders WHERE payer_email = ' . $db->quote($o->payer_email) .  ' AND id <> ' .  $o->id .  ' ORDER BY dt DESC');
?>
<?PHP include('inc/header.inc.php'); ?>

        <div id="bd">
            <div id="yui-main">
                <div class="yui-b"><div class="yui-g">

                    <div class="block">
                        <div class="hd">
                            <h2>
								Order #<?PHP echo $o->id; ?>
								<?PHP if($o->deactivated == 1) : ?> (Deactivated) <?PHP endif; ?>
							</h2>
                        </div>
                        <div class="bd">
							<table class="lines">
								<?PHP foreach($o->columns as $k => $v) : ?>
								<?php if ($k == 'license_type_id' && !empty($lt)) : ?>
									<tr>
										<th><strong>license_abbreviation</strong></th>
										<td><a href="license-types.php?id=<?PHP echo $o->app_id; ?>"><?PHP echo $lt->abbreviation; ?></a></td>
									</tr>
								<?php else : ?>
									<?PHP if(strlen(trim($v)) > 0) : ?>
									<tr>
										<th><strong><?PHP echo $k; ?></strong></th>
										<td><?PHP echo $v; ?></td>
									</tr>
									<?PHP endif; ?>
								<?php endif; ?>
								<?PHP endforeach; ?>
							</table>
						</div>
					</div>

					<div class="block">
						<div class="hd">
							<h2>Order Notes</h2>
						</div>
						<div class="bd">
							<form action="order.php?id=<?PHP echo $o->id; ?>" method="post" class="bd">
								<textarea style="width:100%;" name="notes" id="notes"><?PHP echo $o->notes; ?></textarea>
								<input type="submit" name="btnNotes" value="Save Notes" id="btnNotes">
								<span class="info">Notes will NOT be sent or made visible to customers.</span>
							</form>
						</div>
					</div>              

                </div></div>
            </div>
            <div id="sidebar" class="yui-b">
				<div class="block">
					<div class="hd">
						<h3>Customer Info</h3>
					</div>
					<div id="rapportive" class="bd"></div>
				</div>

				<div class="block">
					<div class="hd">
						<h3>Related Orders and Activations</h3>
					</div>
					<div class="bd">
						<p><a href="activations.php?q=<?PHP echo $o->payer_email; ?>">Activated <?PHP echo $o->activationCount(); ?> times</a></p>
					    <table class="lines">
					        <thead>
					            <tr>
					                <td>Date</td>
					                <td>App Name</td>
					            </tr>
					        </thead>
					        <tbody>
    							<?PHP foreach($orders as $o2) : ?>
    							<tr>
    							    <td><a href="order.php?id=<?PHP echo $o2->id; ?>"><?PHP echo time2str($o2->dt); ?></a></td>
    							    <td><?PHP echo $o2->applicationName(); ?></td>
    							</tr>
    							<?PHP endforeach; ?>
					        </tbody>
					    </table>
					</div>
				</div>

                <div class="block">
                    <div class="hd">
                        <h3>License Options</h3>
                    </div>
                    <div class="bd">
						<ul class="biglist">
							<li><a href="order.php?id=<?PHP echo $o->id; ?>&amp;act=email" id="email">Email to User</a></li>
							<li><a href="<?PHP echo $o->getDownloadLink(); ?>">Download Link (does not expire)</a></li>
							<li><a href="<?PHP echo $o->getDownloadLink(86400); ?>">Download Link (1 day)</a></li>
							<li><a href="<?PHP echo $o->getDownloadLink(86400 * 3); ?>">Download Link (3 days)</a></li>
							<li><a href="<?PHP echo $o->getDownloadLink(86400 * 7); ?>">Download Link (1 week)</a></li>
							<li><a href="order.php?id=<?PHP echo $o->id; ?>&amp;act=deactivate" id="deactivate">Deactivate License</a></li>
						</ul>
					</div>
				</div>
				
				<div class="block">
					<div class="hd">
						<h3>Order Options</h3>
					</div>
					<div class="bd">
						<ul class="biglist">
							<?PHP if($app->upgrade_app_id > 0) : ?>
							<li><a href="order.php?id=<?PHP echo $o->id; ?>&amp;act=upgrade" id="upgrade">Upgrade Order</a></li>
							<?PHP endif; ?>
							<li><a href="order.php?id=<?PHP echo $o->id; ?>&amp;act=delete" id="delete">Delete Order</a></li>
						</ul>
					</div>
				</div>

				<div class="block">
					<div class="hd">
						<h3>Cut &amp; Paste License</h3>
					</div>
					<div class="bd">
						<?PHP if($app->engine_class_name == 'aquaticprime') : ?>
						<textarea style="width:100%;"><?PHP echo $o->license; ?></textarea>
						<?PHP elseif($app->engine_class_name == 'dual') : ?>
						<textarea style="width:100%;"><?PHP echo "Email: {$o->payer_email}\nSerial Number: {$o->serial_number}"; ?></textarea>
						<?PHP else : ?>
						<textarea style="width:100%;"><?PHP echo "Email: {$o->payer_email}\nReg Key: {$o->license}"; ?></textarea>
						<?PHP endif; ?>
					</div>
				</div>

				
            </div>
        </div>

<?PHP include('inc/footer.inc.php'); ?>
<script type="text/javascript" charset="utf-8">
	$(function() {
		$('#rapportive').load('rapportive.php?email=<?PHP echo $o->payer_email; ?>');
	});
</script>