<?php
if (!array_key_exists('id', $_GET)) {
die("Couldn't find invoice ID");
}
$invoiceId = $_GET['id'];
$close = array_key_exists('close', $_GET) ? (bool) $_GET['close'] : true;
require_once 'API/DBase.php';
$db = new DBase();
$sql = "SELECT CAST(inv.created AS Date) as 'invoiceDate', inv.id as 'invoiceId', inv.bankDetails, cust.firstname, cust.lastname, cust.address, cust.city, cust.state, cust.postcode, c.make, c.model, c.registration FROM invoice inv INNER JOIN service serv ON (serv.id = inv.service) INNER JOIN customer cust ON (cust.id = serv.owner) INNER JOIN car c ON (serv.car = c.id) WHERE inv.id = " . $db->escape($invoiceId);
$invoice = $db->fetchOne($sql);
$invoice['invoiceDate'] = DateTime::createFromFormat('Y-m-d', $invoice['invoiceDate']);
$invoice['invoiceDate'] = $invoice['invoiceDate']->format("j F Y");
$sql = "SELECT det.*, (det.cost * det.quantity) AS total FROM detail det WHERE det.invoice = " . $db->escape($invoiceId);
$invoiceDetails = $db->fetchAll($sql);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Invoice - Sharpie's Auto Services</title>
<meta name="description" content="">
<meta name="author" content="">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/normalize.css">
<link rel="stylesheet" media="all" href="css/invoice.css">
<link rel="icon" type="image/png" href="images/favicon.png">
</head>
<body>
<table>
<tr>
