<?php
include 'core.php';
?>
<?php
header::all("view-shell");
?>
<div class="container-fluid view-top-box">
<div class="container">
<div class="row">
<div class="col-md-2 col-md-push-10 right status-shell">
<span class="status numbers">8908908 <i class="fa fa-map-pin"></i></span>
<span class="status">Open <i class="fa fa-square-o"></i></span>
<span class="status">3 days <i class="fa fa-clock-o"></i></span>
</div>
<div class="col-md-10 col-md-pull-2">
<h1>Broken Washing Machine</h1>
<p><i class="fa fa-home"></i> Flat 1, High Street, Cheltenham, Glos, GL51 A12</p>
<span class="user-info"><i class="fa fa-user"></i> John Smith </span> <span class="user-info"><i class="fa fa-envelope"></i> john.smith@email.com </span> <span class="user-info"><i class="fa fa-phone"></i> <span class="numbers">07123 456789</span></span>
</div>
<!--
<div class="col-md-10 col-md-pull-2">
<h1>Broken Washing Machine Broken Washing Machine Broken Washing</h1>
<p><i class="fa fa-home"></i> 2 Timperley Way, Up Hatherley, Cheltenham, GL51 3RH 2 Timperley Way, Up Hatherley, Cheltenham, GL51 3RH 2 Timperley Way, Up Hatherley, Cheltenham, GL51 3RH 2 Timperley Way, Up Hatherley, Cheltenham</p>
<span class="user-info"><i class="fa fa-user"></i> Robert Tribe Robert Tribe Robert Tribe Robert Trib </span> <span class="user-info"><i class="fa fa-envelope"></i> rob@robtribe.co.ukrob@robtribe.co.ukrob@robtribe.co.ukrob@robtribe.co.ukrob@robtribe.co.ukrobtribe12 </span> <span class="user-info"><i class="fa fa-phone"></i> <span class="numbers">07857772976</span></span>
</div>
-->
</div>
</div>
<?php
include 'core.php';
?>
<?php
header::all();
?>
<?php
// Generate new unique ticket ID by fetching the primary ID of the last ticket &
// using a substring of the time() function to avoid duplicates
// New DB Connection
$db = new MysqliDb($dbserver, $dbusername, $dbpassword, $dbdatabase);
// Order by primary ID descending to ensure we fetch the final table row.
$db->orderBy("primary_id", "desc");
// Fetch the primary ID of the last ticket in the database
$last_ticket = $db->getValue("tickets", "primary_id");
// Create new unique ticket number for this ticket
$new_ticket_number = $last_ticket . substr(time(), 7, 10);
// Get current time in PHP - we use this as a simple method of catching spambots
$spambot_time = time();
?>
<h1 class='mendhub-logo corner-logo'><a href='http://<?php
echo $_SERVER[HTTP_HOST];
?>
'>Mend<span class='mendhub-sub-logo'>Hub</span></a></h1>
<div class="container-fluid">
<div class="row">
