Discounts

6 files changed, 546 insertions, 141 deletions

diff --git a/include/discounts-edit.php b/include/discounts-edit.php
new file mode 100644
index 0000000..e6859a1
--- /dev/null
+++ b/include/discounts-edit.php
@@ -0,0 +1,59 @@
+<?php
+/**
+ * BusinessAdmin: administrative software for small companies
+ * Copyright (C) 2015 Camil Staps (ViviSoft)
+ * 
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ * 
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ * 
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+require_once('./conf.php');
+
+$response = new response();
+
+try {
+	$discount = new discount($_pdo, $_REQUEST['pk']);
+
+	$name = explode('-', $_REQUEST['name']);
+	$what_to_edit = $name[count($name) - 1];
+	switch ($what_to_edit) {
+		case 'title':
+			$response->success = $discount->setTitle($_REQUEST['value']);
+			break;
+		case 'value':
+			$response->success = $discount->setValue($_REQUEST['value']);
+			break;
+		case 'vat':
+			$response->success = $discount->setVAT($_REQUEST['value']);
+			break;
+		case 'description':
+			$response->success = $discount->setDescription($_REQUEST['value']);
+			break;
+		default:
+			$response->http_response_code(404);
+			$response->success = false;
+	}
+	if (!$response->success && $response->http_response_code() == 200) {
+		$response->http_response_code(500);
+		$response->message = "The discount could not be edited due to an error.";
+	}
+} catch (PDOException $e) {
+	$response->http_response_code(500);
+	$response->success = false;
+	$response->message = "The discount could not be edited due to a PDO error ({$e->getMessage()}).";
+} catch (Exception $e) {
+	$response->http_response_code(404);
+	$response->success = false;
+	$response->message = "The discount could not be edited due to an exception.";
+}
+echo $response->message;
diff --git a/include/discounts-new.php b/include/discounts-new.php
new file mode 100644
index 0000000..1900d47
--- /dev/null
+++ b/include/discounts-new.php
@@ -0,0 +1,44 @@
+<?php
+/**
+ * BusinessAdmin: administrative software for small companies
+ * Copyright (C) 2015 Camil Staps (ViviSoft)
+ * 
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ * 
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ * 
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+require_once('./conf.php');
+
+$response = new response();
+
+try {
+	$offer = new offer($_pdo, $_REQUEST['offerId']);
+
+	$discount = $offer->createDiscount(
+		$_REQUEST['title'],
+		$_REQUEST['description'],
+		$_REQUEST['value'],
+		$_REQUEST['vat']
+	);
+	$response->success = true;
+	$response->message = "Assignment {$discount->getTitle()} has been succesfully created. <a class='alert-link' href='javascript:location.reload(true);'>Refresh the page</a>.";
+} catch (PDOException $e) {
+	$response->http_response_code(500);
+	$response->success = false;
+	$response->message = "The discount could not be created due to a PDO error ({$e->getMessage()}).";
+} catch (Exception $e) {
+	$response->http_response_code(404);
+	$response->success = false;
+	$response->message = "The discount could not be created due to an error.";
+}
+echo $response->getJson();
diff --git a/include/discounts-overview.php b/include/discounts-overview.php
new file mode 100644
index 0000000..6160a8c
--- /dev/null
+++ b/include/discounts-overview.php
@@ -0,0 +1,159 @@
+<?php
+/**
+ * BusinessAdmin: administrative software for small companies
+ * Copyright (C) 2015 Camil Staps (ViviSoft)
+ * 
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ * 
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ * 
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>.
+ */
+?>
+
+<div class="col-lg-12">
+	<div class="panel panel-default">
+		<div class="panel-heading">Overview</div>
+		<div class="panel-body table-responsive">
+			<table class="table table-bordered table-striped mixitup dataTable" id="overview-discounts">
+				<thead>
+					<tr>
+						<th class="mixitup-sort sorting" data-sort="mixerOrderId:desc">#</th>
+						<th class="mixitup-sort sorting" data-sort="mixerOrderOffer:desc">Offer</th>
+						<th>Briefing</th>
+						<th class="mixitup-sort sorting" data-sort="mixerOrderValue:desc">Value</th>
+						<th>Tools</th>
+					</tr>
+				</thead>
+				<tbody>
+					<?php
+					$discounts = BusinessAdmin::getDiscounts($_pdo);
+					foreach ($discounts as $discount) {
+						echo "<tr class='mix'
+								data-mixer-order-id='{$discount->getId()}' 
+								data-mixer-order-offer='{$discount->getOffer()->getId()}'
+								data-mixer-order-value='{$discount->getValue()}'>
+							<td class='col-min-width'>{$discount->getId()}</td>
+							<td class='col-min-width'>
+								<a href='".constants::url_internal."/offers?id={$discount->getOffer()->getId()}'>#{$discount->getOffer()->getId()}</a> to
+								<a href='".constants::url_internal."/contacts?id={$discount->getOffer()->getContact()->getId()}'>{$discount->getOffer()->getContact()->getName()}</a>
+								(<a href='".constants::url_internal."/clients?id={$discount->getOffer()->getContact()->getClient()->getId()}'>{$discount->getOffer()->getContact()->getClient()->getName()}</a>)
+							<td class='col-max-width'>
+								<b><a href='#' class='editable' id='editable-discount-{$discount->getId()}-title' data-type='text' data-pk='{$discount->getId()}' data-url='".constants::url_external."discounts/edit'>{$discount->getTitle()}</a></b><br/>
+								<p><a href='#' class='editable editable-noshow' id='editable-discount-{$discount->getId()}-description' data-type='textarea' data-mode='inline' data-pk='{$discount->getId()}' data-url='".constants::url_external."discounts/edit'>{$discount->getDescription(false)}</a></p>
+							</td>
+							<td class='col-min-width'>
+							   ".constants::invoice_valuta."<a href='#' class='editable' id='editable-discount-{$discount->getId()}-value' data-type='text' data-pk='{$discount->getId()}' data-url='".constants::url_external."discounts/edit'>{$discount->getValue()}</a><br/>
+								<a href='#' class='editable' id='editable-discount-{$discount->getId()}-vat' data-type='text' data-pk='{$discount->getId()}' data-url='".constants::url_external."discounts/edit'>{$discount->getVAT()}</a>% VAT
+							</td>
+							<td class='col-min-width'>
+								<a title='View' href='?id={$discount->getId()}' class='btn btn-primary btn-circle fa fa-arrow-right'></a> 
+								<a title='Delete' href='?delete={$discount->getId()}' class='btn btn-danger btn-circle fa fa-times'></a>
+							</td>
+						</tr>";
+					}
+					if (count($discounts) == 0) {
+						echo "<tr><td colspan='6'>There are no discounts in the database. Why not start with creating one, below?</td></tr>";
+					}
+					?>
+				</tbody>
+			</table>
+		</div>
+	</div>
+</div>
+<div class="col-lg-12">
+	<div class="panel panel-default">
+		<div class="panel-heading">Create new</div>
+		<div class="panel-body">
+			<form role="form" id="newDiscount" action='<?=constants::url_external?>discounts/new' method="post" class="bootstrapValidator ajaxify" 
+				data-ajaxify-options='{"success":"newDiscountSuccess","error":"newDiscountError","beforeSubmit":"newDiscountBeforeSubmit"}'>
+				<div class="ajaxify-response alert alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button><span class="ajaxify-response-text"></span></div>
+				<div class="col-lg-6">
+					<div class="form-group">
+						<label>Offer:</label>
+						<select name="offerId" class="form-control">
+							<?php
+							foreach (BusinessAdmin::getOffers($_pdo) as $offer) {
+								echo "<option value='{$offer->getId()}'>#{$offer->getId()} to {$offer->getContact()->getName()} ({$offer->getContact()->getClient()->getName()})</option>";
+							}
+							?>
+						</select>
+					</div>
+					<div class="form-group">
+						<label>Title:</label>
+						<input 
+							type="text" name="title" class="form-control" placeholder="Title" 
+							data-bv-notempty="true" data-bv-notempty-message="You have to provide a title"/>
+					</div>
+					<div class="form-group">
+						<label>Description:</label>
+						<textarea 
+							name="description" class="form-control" placeholder="Description" rows="4"
+							data-bv-notempty="true" data-bv-notempty-message="You have to provide a description" 
+							data-bv-stringlength="true" data-bv-stringlength-message="The description should have at most 1000 characters" data-bv-stringlength-max="1000"></textarea>
+					</div>
+				</div>
+				<div class="col-lg-6">
+					<div class="form-group">
+						<label>Value (<?=constants::invoice_valuta?>):</label>
+						<input 
+							type="text" name="value" class="form-control" placeholder="Value" 
+							data-bv-notempty="true" data-bv-notempty-message="You have to give a value"
+							data-bv-numeric="true" data-bv-numeric-message="Please enter a number (with a '.' as decimal separator)" />
+					</div>
+					<div class="form-group">
+						<label>VAT (%):</label>
+						<input 
+							type="text" name="vat" class="form-control" placeholder="VAT" 
+							data-bv-notempty="true" data-bv-notempty-message="You have to provide a VAT percentage"
+							data-bv-numeric="true" data-bv-numeric-message="Please enter a number (with a '.' as decimal separator)" />
+					</div>
+				</div>
+				<div class="col-lg-6">
+					<button type="submit" class="btn btn-default">Go</button>
+				</div>
+			</form>
+			<script type="text/javascript">
+			// Callback for before the form is submitted
+			function newDiscountBeforeSubmit() {
+				$('#newDiscount input').prop('disabled', true);
+				$('#newDiscount .ajaxify-response').hide().removeClass('alert-success alert-danger').find('.ajaxify-response-text').html('');
+			}
+
+			// Callback for when the form is successfully submitted
+			function newDiscountSuccess(data) {
+				$('#newDiscount .ajaxify-response')
+					.addClass(data.success ? 'alert-success' : 'alert-danger')
+					.show()
+					.find('.ajaxify-response-text')
+						.html(data.message);
+
+				$('#newDiscount input, #newDiscount button').prop('disabled', false);
+				$('#newDiscount').data('bootstrapValidator').resetForm();
+				if (data.success) {
+					$('#newDiscount input, #newDiscount textarea').val('');
+				}
+			}
+
+			// Callback for when form submission encountered an error
+			function newDiscountError() {
+				$('#newDiscount .ajaxify-response')
+					.addClass('alert-danger')
+					.show()
+					.find('.ajaxify-response-text')
+						.html('An unknown error occurred. Please contact support.');
+
+				$('#newDiscount input, #newDiscount button').prop('disabled', false);
+					$('#newDiscount').data('bootstrapValidator').resetForm();
+			}
+			</script>
+		</div>
+	</div>
+</div>
diff --git a/include/discounts.php b/include/discounts.php
new file mode 100644
index 0000000..83cb1b8
--- /dev/null
+++ b/include/discounts.php
@@ -0,0 +1,98 @@
+<?php
+/**
+ * BusinessAdmin: administrative software for small companies
+ * Copyright (C) 2015 Camil Staps (ViviSoft)
+ * 
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ * 
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+ * GNU General Public License for more details.
+ * 
+ * You should have received a copy of the GNU General Public License
+ * along with this program.  If not, see <http://www.gnu.org/licenses/>.
+ */
+
+require_once('./index.php');
+require('./header.php');
+?>
+
+<div id="wrapper">
+
+	<?php require('./nav.php'); ?>
+
+	<div id="page-wrapper">
+		<div class="row">
+			<?php
+			//------------------------------------------------------------------------------
+			// Check for GET variables
+			//
+			// ?id=<id>           View information of the discount with id <id>
+			// ?delete=<id>       Delete the discount with id <id>
+			//------------------------------------------------------------------------------
+
+			// The header of the page
+			$header = 'Discounts';
+			// Whether or not to show an individual discount in the end (false if not, or the id if yes)
+			$show_individual = false;
+
+			// View discount
+			if (isset($_GET['id'])) {
+				$id = (int) $_GET['id'];
+				try {
+					$discount = new discount($_pdo, $id);
+					$header = "<a href='".constants::url_external."discounts'>Discounts</a> / {$discount->getTitle()}";
+					$show_individual = $id;
+				} catch (PDOException $e) {
+					$alert = "<div class='alert alert-danger alert-dismissable'><button type='button' class='close fa fa-times' data-dismiss='alert' aria-hidden='true'></button>The discount with id $id</i> could not be found.</div>";
+				} catch (Exception $e) {
+					$alert = "<div class='alert alert-warning alert-dismissable'><button type='button' class='close fa fa-times' data-dismiss='alert' aria-hidden='true'></button>The discount with id $id</i> could not be found.</div>";
+				}
+			}
+
+			// Show the header
+			echo "<div class='col-lg-12'><h1 class='page-header'>$header</h1></div>";
+			if (isset($alert)) echo "<div class='col-lg-12'>$alert</div>";
+
+			// Delete discount
+			if (isset($_GET['delete'])) {
+				echo "<div class='col-lg-12'>";
+				$id = (int) $_GET['delete'];
+				try {
+					$discount = new discount($_pdo, $id);
+					if ($discount->delete()) {
+						echo "<div class='alert alert-success alert-dismissable'><button type='button' class='close fa fa-times' data-dismiss='alert' aria-hidden='true'></button>The discount with title <i>{$discount->getTitle()}</i> has been removed.</div>";
+					} else {
+						echo "<div class='alert alert-warning alert-dismissable'><button type='button' class='close fa fa-times' data-dismiss='alert' aria-hidden='true'></button>The discount with title <i>{$discount->getTitle()}</i> could not be removed. Perhaps it's already removed?</div>";
+					}
+				} catch (PDOException $e) {
+					echo "<div class='alert alert-danger alert-dismissable'><button type='button' class='close fa fa-times' data-dismiss='alert' aria-hidden='true'></button>The discount could not be removed due to a PDO error.</div>";
+				} catch (Exception $e) {
+					echo "<div class='alert alert-warning alert-dismissable'><button type='button' class='close fa fa-times' data-dismiss='alert' aria-hidden='true'></button>The discount with id {$id} could not be found.</div>";
+				}
+
+				echo "</div>";
+			}
+
+			if ($show_individual !== false) {
+				$_id = $show_individual;
+				require('discounts-view.php');
+			} else {
+				require('discounts-overview.php');
+			}
+			?>
+		</div>
+		<!-- /.row -->
+	</div>
+	<!-- /#page-wrapper -->
+
+</div>
+<!-- /#wrapper -->
+
+<?php
+require('./footer.php');
+?>
diff --git a/include/offers-overview.php b/include/offers-overview.php
index 566f387..594f01c 100644
--- a/include/offers-overview.php
+++ b/include/offers-overview.php
@@ -19,151 +19,154 @@
 ?>
 
 <div class="col-lg-12">
-    <div class="panel panel-default">
-        <div class="panel-heading">Overview</div>
-        <div class="panel-body table-responsive">
-            <table class="table table-bordered table-striped">
-                <thead>
-                    <tr>
-                        <th>#</th>
-                        <th>Contact</th>
-                        <th>Assignments</th>
-                        <th>Dates</th>
-                        <th>Invoice</th>
-                        <th>Tools</th>
-                    </tr>
-                </thead>
-                <tbody>
-                    <?php
-                    $offers = BusinessAdmin::getOffers($_pdo);
-                    foreach ($offers as $offer) {   
-                        $invoiceFile = $offer->getInvoiceFile();
+	<div class="panel panel-default">
+		<div class="panel-heading">Overview</div>
+		<div class="panel-body table-responsive">
+			<table class="table table-bordered table-striped">
+				<thead>
+					<tr>
+						<th>#</th>
+						<th>Contact</th>
+						<th>Assignments &amp; discounts</th>
+						<th>Dates</th>
+						<th>Invoice</th>
+						<th>Tools</th>
+					</tr>
+				</thead>
+				<tbody>
+					<?php
+					$offers = BusinessAdmin::getOffers($_pdo);
+					foreach ($offers as $offer) {
+						$invoiceFile = $offer->getInvoiceFile();
 
-                        echo "<tr>
-                            <td class='col-min-width'>{$offer->getId()}</td>
-                            <td class='col-min-width'><span title='{$offer->getContact()->getClient()->getName()}'>{$offer->getContact()->getName()}</span></td>
-                            <td class='col-max-width'>";
-                        foreach ($offer->getAssignments() as $assignment) {
-                            echo "<b>{$assignment->getTitle()}</b><br/><span class='smaller'>(".constants::invoice_valuta."{$assignment->calculate(assignment::SUBTOTAL)} excl. VAT, ".constants::invoice_valuta."{$assignment->calculate(assignment::TOTAL)} incl. VAT)</span><br/><p>{$assignment->getDescription()}</p>";
-                        }
-                        echo "</td>
-                            <td class='col-min-width'>
-                                <table>
-                                    <tr>
-                                        <th style='padding-right:1em;'>From:</th>
-                                        <td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-start_date' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getStartDate(),false,true)."</a></td>
-                                    </tr>
-                                    <tr>
-                                        <th style='padding-right:1em;'>To:</th>
-                                        <td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-end_date' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getEndDate(),false,true)."</a></td>
-                                    </tr>
-                                    <tr>
-                                        <th style='padding-right:1em;'>Invoice:</th>
-                                        <td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-invoice_date' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getInvoiceDate(),false,true)."</a></td>
-                                    </tr>
-                                    <tr>
-                                        <th style='padding-right:1em;'>Payment received:</th>
-                                        <td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-payment_received' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getPaymentReceived(),false,true)."</a></td>
-                                    </tr>
-                                </table>
-                            </td>
-                            <td class='col-min-width'>"
-                            . (($invoiceFile instanceof file) 
-                                ? "<a title='View' href='{$invoiceFile->getFilenameURI()}' target='_blank' class='btn btn-default btn-circle fa fa-eye'></a>
-                                    <a title='Regenerate' href='?generate_invoice={$offer->getId()}' class='btn btn-default btn-circle fa fa-refresh'></a>
-                                    <a title='Trash' href='?trash_invoice={$offer->getId()}' class='btn btn-default btn-circle fa fa-trash'></a>"
-                                : "<a title='Create invoice' href='?generate_invoice={$offer->getId()}' class='btn btn-default btn-circle fa fa-calculator'></a>")
-                            . "<br/>
-                                <table>
-                                    <tr>
-                                        <th style='padding-right:1em;'>Subtotal:</th>
-                                        <td>".constants::invoice_valuta."{$offer->calculate(offer::SUBTOTAL)}</td>
-                                    </tr>
-                                    <tr>
-                                        <th style='padding-right:1em;'>VAT:</th>
-                                        <td>".constants::invoice_valuta."{$offer->calculate(offer::VAT)}</td>
-                                    <tr>
-                                    </tr>
-                                        <th style='padding-right:1em;'>Total:</th>
-                                        <td>".constants::invoice_valuta."{$offer->calculate(offer::TOTAL)}</td>
-                                    </tr>
-                                </table>
-                            </td>
-                            <td class='col-min-width'>
-                                <a title='" . ($offer->isAccepted() ? "Accepted" : "Not accepted") . "' href='?toggle_accept={$offer->getId()}' class='btn " . ($offer->isAccepted() ? "btn-success" : "btn-default") . " btn-circle fa fa-check'></a><a title='View' href='?id={$offer->getId()}' class='btn btn-primary btn-circle fa fa-arrow-right'></a><a title='Delete' href='?delete={$offer->getId()}' class='btn btn-danger btn-circle fa fa-times'></a>
-                            </td>
-                        </tr>";
-                    }
-                    if (count($offers) == 0) {
-                        echo "<tr><td colspan='6'>There are no offers in the database. Why not start with creating one, below?</td></tr>";
-                    }
-                    ?>
-                </tbody>
-            </table>
-        </div>
-    </div>
+						echo "<tr>
+							<td class='col-min-width'>{$offer->getId()}</td>
+							<td class='col-min-width'><span title='{$offer->getContact()->getClient()->getName()}'>{$offer->getContact()->getName()}</span></td>
+							<td class='col-max-width'>";
+						foreach ($offer->getAssignments() as $assignment) {
+							echo "<b>{$assignment->getTitle()}</b><br/><span class='smaller'>(".constants::invoice_valuta."{$assignment->calculate(assignment::SUBTOTAL)} excl. VAT, ".constants::invoice_valuta."{$assignment->calculate(assignment::TOTAL)} incl. VAT)</span><br/><p>{$assignment->getDescription()}</p>";
+						}
+						foreach ($offer->getDiscounts() as $discount) {
+							echo "<b>{$discount->getTitle()}</b><br/><span class='smaller'>(".constants::invoice_valuta."{$discount->calculate(discount::SUBTOTAL)} excl. VAT, ".constants::invoice_valuta."{$discount->calculate(discount::TOTAL)} incl. VAT)</span><br/><p>{$discount->getDescription()}</p>";
+						}
+						echo "</td>
+							<td class='col-min-width'>
+								<table>
+									<tr>
+										<th style='padding-right:1em;'>From:</th>
+										<td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-start_date' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getStartDate(),false,true)."</a></td>
+									</tr>
+									<tr>
+										<th style='padding-right:1em;'>To:</th>
+										<td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-end_date' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getEndDate(),false,true)."</a></td>
+									</tr>
+									<tr>
+										<th style='padding-right:1em;'>Invoice:</th>
+										<td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-invoice_date' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getInvoiceDate(),false,true)."</a></td>
+									</tr>
+									<tr>
+										<th style='padding-right:1em;'>Payment received:</th>
+										<td><a href='#' class='editable' id='editable-offer-{$offer->getId()}-payment_received' data-type='text' data-pk='{$offer->getId()}' data-url='".constants::url_external."offers/edit'>".BusinessAdmin::formatDate($offer->getPaymentReceived(),false,true)."</a></td>
+									</tr>
+								</table>
+							</td>
+							<td class='col-min-width'>"
+							. (($invoiceFile instanceof file)
+								? "<a title='View' href='{$invoiceFile->getFilenameURI()}' target='_blank' class='btn btn-default btn-circle fa fa-eye'></a>
+									<a title='Regenerate' href='?generate_invoice={$offer->getId()}' class='btn btn-default btn-circle fa fa-refresh'></a>
+									<a title='Trash' href='?trash_invoice={$offer->getId()}' class='btn btn-default btn-circle fa fa-trash'></a>"
+								: "<a title='Create invoice' href='?generate_invoice={$offer->getId()}' class='btn btn-default btn-circle fa fa-calculator'></a>")
+							. "<br/>
+								<table>
+									<tr>
+										<th style='padding-right:1em;'>Subtotal:</th>
+										<td>".constants::invoice_valuta."{$offer->calculate(offer::SUBTOTAL)}</td>
+									</tr>
+									<tr>
+										<th style='padding-right:1em;'>VAT:</th>
+										<td>".constants::invoice_valuta."{$offer->calculate(offer::VAT)}</td>
+									<tr>
+									</tr>
+										<th style='padding-right:1em;'>Total:</th>
+										<td>".constants::invoice_valuta."{$offer->calculate(offer::TOTAL)}</td>
+									</tr>
+								</table>
+							</td>
+							<td class='col-min-width'>
+								<a title='" . ($offer->isAccepted() ? "Accepted" : "Not accepted") . "' href='?toggle_accept={$offer->getId()}' class='btn " . ($offer->isAccepted() ? "btn-success" : "btn-default") . " btn-circle fa fa-check'></a><a title='View' href='?id={$offer->getId()}' class='btn btn-primary btn-circle fa fa-arrow-right'></a><a title='Delete' href='?delete={$offer->getId()}' class='btn btn-danger btn-circle fa fa-times'></a>
+							</td>
+						</tr>";
+					}
+					if (count($offers) == 0) {
+						echo "<tr><td colspan='6'>There are no offers in the database. Why not start with creating one, below?</td></tr>";
+					}
+					?>
+				</tbody>
+			</table>
+		</div>
+	</div>
 </div>
 <div class="col-lg-6 col-md-6">
-    <div class="panel panel-default">
-        <div class="panel-heading">Create new</div>
-        <div class="panel-body">
-            <form role="form" id="newOffer" action='<?=constants::url_external?>offers/new' method="post" class="bootstrapValidator ajaxify" 
-                data-ajaxify-options='{"success":"newOfferSuccess","error":"newOfferError","beforeSubmit":"newOfferBeforeSubmit"}'>
-                <div class="ajaxify-response alert alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button><span class="ajaxify-response-text"></span></div>
-                <div class="form-group">
-                    <label>Contact:</label>
-                    <select name="contactId" class="form-control">
-                        <?php
-                        foreach (BusinessAdmin::getContacts($_pdo) as $contact) {
-                            echo "<option value='{$contact->getId()}'>{$contact->getName()} ({$contact->getClient()->getName()})</option>";
-                        }
-                        ?>
-                    </select>
-                </div>
-                <button type="submit" class="btn btn-default">Go</button>
-            </form>
-            <script type="text/javascript">
-            // Callback for before the form is submitted
-            function newOfferBeforeSubmit() {
-                $('#newOffer input').prop('disabled', true);
-                $('#newOffer .ajaxify-response').hide().removeClass('alert-success alert-danger').find('.ajaxify-response-text').html('');
-            }
+	<div class="panel panel-default">
+		<div class="panel-heading">Create new</div>
+		<div class="panel-body">
+			<form role="form" id="newOffer" action='<?=constants::url_external?>offers/new' method="post" class="bootstrapValidator ajaxify" 
+				data-ajaxify-options='{"success":"newOfferSuccess","error":"newOfferError","beforeSubmit":"newOfferBeforeSubmit"}'>
+				<div class="ajaxify-response alert alert-dismissable"><button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button><span class="ajaxify-response-text"></span></div>
+				<div class="form-group">
+					<label>Contact:</label>
+					<select name="contactId" class="form-control">
+						<?php
+						foreach (BusinessAdmin::getContacts($_pdo) as $contact) {
+							echo "<option value='{$contact->getId()}'>{$contact->getName()} ({$contact->getClient()->getName()})</option>";
+						}
+						?>
+					</select>
+				</div>
+				<button type="submit" class="btn btn-default">Go</button>
+			</form>
+			<script type="text/javascript">
+			// Callback for before the form is submitted
+			function newOfferBeforeSubmit() {
+				$('#newOffer input').prop('disabled', true);
+				$('#newOffer .ajaxify-response').hide().removeClass('alert-success alert-danger').find('.ajaxify-response-text').html('');
+			}
 
-            // Callback for when the form is successfully submitted
-            function newOfferSuccess(data) {
-                if (data.success == true) {
-                    $('#newOffer .ajaxify-response')
-                        .addClass('alert-success')
-                        .show()
-                        .find('.ajaxify-response-text')
-                            .html(data.message);
+			// Callback for when the form is successfully submitted
+			function newOfferSuccess(data) {
+				if (data.success == true) {
+					$('#newOffer .ajaxify-response')
+						.addClass('alert-success')
+						.show()
+						.find('.ajaxify-response-text')
+							.html(data.message);
 
-                    $('#newOffer input, #newOffer button').prop('disabled', false);
-                    $('#newOffer').data('bootstrapValidator').resetForm();
-                } else {
-                    $('#newOffer .ajaxify-response')
-                        .addClass('alert-danger')
-                        .show()
-                        .find('.ajaxify-response-text')
-                            .html(data.message);
+					$('#newOffer input, #newOffer button').prop('disabled', false);
+					$('#newOffer').data('bootstrapValidator').resetForm();
+				} else {
+					$('#newOffer .ajaxify-response')
+						.addClass('alert-danger')
+						.show()
+						.find('.ajaxify-response-text')
+							.html(data.message);
 
-                    $('#newOffer input, #newOffer button').prop('disabled', false);
-                    $('#newOffer').data('bootstrapValidator').resetForm();
-                }
-            }
+					$('#newOffer input, #newOffer button').prop('disabled', false);
+					$('#newOffer').data('bootstrapValidator').resetForm();
+				}
+			}
 
-            // Callback for when form submission encountered an error
-            function newOfferError() {
-                $('#newOffer .ajaxify-response')
-                    .addClass('alert-danger')
-                    .show()
-                    .find('.ajaxify-response-text')
-                        .html('An unknown error occurred. Please contact support.');
-                
-                $('#newOffer input, #newOffer button').prop('disabled', false);
-                    $('#newOffer').data('bootstrapValidator').resetForm();
-            }
-            </script>
-        </div>
-    </div>
-</div>
\ No newline at end of file
+			// Callback for when form submission encountered an error
+			function newOfferError() {
+				$('#newOffer .ajaxify-response')
+					.addClass('alert-danger')
+					.show()
+					.find('.ajaxify-response-text')
+						.html('An unknown error occurred. Please contact support.');
+
+				$('#newOffer input, #newOffer button').prop('disabled', false);
+					$('#newOffer').data('bootstrapValidator').resetForm();
+			}
+			</script>
+		</div>
+	</div>
+</div>
diff --git a/include/offers-view.php b/include/offers-view.php
index c578522..eec7701 100644
--- a/include/offers-view.php
+++ b/include/offers-view.php
@@ -127,3 +127,45 @@ $_offer = new offer($_pdo, $_id);
         </div>
     </div>
 </div>
+<div class="col-lg-6">
+    <div class="panel panel-default">
+        <div class="panel-heading">Discounts</div>
+        <div class="panel-body table-responsive">
+            <table class="table table-bordered table-striped">
+                <thead>
+                    <tr>
+                        <th>#</th>
+                        <th>Briefing</th>
+                        <th>Value</th>
+                        <th>Tools</th>
+                    </tr>
+                </thead>
+                <tbody>
+                    <?php
+                    $discounts = BusinessAdmin::getDiscounts($_pdo, array("offerId = {$_offer->getId()}"));
+                    foreach ($discounts as $discount) {
+                        echo "<tr>
+                            <td class='col-min-width'>{$discount->getId()}</td>
+                            <td class='col-max-width'>
+                                <b><a href='#' class='editable' id='editable-discount-{$discount->getId()}-title' data-type='text' data-pk='{$discount->getId()}' data-url='".constants::url_external."discounts/edit'>{$discount->getTitle()}</a></b><br/>
+                                <p>{$discount->getDescription()}</p>
+                            </td>
+                            <td class='col-min-width'>
+                               ".constants::invoice_valuta."<a href='#' class='editable' id='editable-discount-{$discount->getId()}-value' data-type='text' data-pk='{$discount->getId()}' data-url='".constants::url_external."discounts/edit'>{$discount->getValue()}</a> / hr<br/>
+                                <a href='#' class='editable' id='editable-discount-{$discount->getId()}-vat' data-type='text' data-pk='{$discount->getId()}' data-url='".constants::url_external."discounts/edit'>{$discount->getVAT()}</a>% VAT
+                            </td>
+                            <td class='col-min-width'>
+                                <a title='View' href='".constants::url_internal."/discounts?id={$discount->getId()}' class='btn btn-primary btn-circle fa fa-arrow-right'></a>
+                                <a title='Delete' href='".constants::url_internal."/discounts?delete={$discount->getId()}' class='btn btn-danger btn-circle fa fa-times'></a>
+                            </td>
+                        </tr>";
+                    }
+                    if (count($discounts) == 0) {
+                        echo "<tr><td colspan='6'>There are no discounts in the database. Why not start with creating one, below?</td></tr>";
+                    }
+                    ?>
+                </tbody>
+            </table>
+        </div>
+    </div>
+</div>