aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--client.php6
-rw-r--r--index.php19
2 files changed, 21 insertions, 4 deletions
diff --git a/client.php b/client.php
index 5d33ba2..43dd78b 100644
--- a/client.php
+++ b/client.php
@@ -14,7 +14,7 @@ $type = $_SESSION["type"];
require_once "config.php";
// Get orders
-$sql = "SELECT id, service, name, billing FROM orders WHERE client = ?";
+$sql = "SELECT id, service, name, billing, comments FROM orders WHERE client = ?";
$stmt = mysqli_prepare($link, $sql);
mysqli_stmt_bind_param($stmt, "s", $param_client);
$param_client = $clientid;
@@ -61,10 +61,10 @@ function getservicebyid($id) {
<div class="col5">
<h3>Active services</h3>
<table>
- <tr><th>service</th><th>instance</th><th>billing</th></tr>
+ <tr><th>service</th><th>instance</th><th>billing</th><th>comments</th></tr>
<?php
foreach ($orders as $order) {
- echo "<tr><td>".getservicebyid($order["service"])["name"]."</td><td>".$order["name"]."</td><td>".$order["billing"]."</tr>\n";
+ echo "<tr><td>".getservicebyid($order["service"])["name"]."</td><td>".$order["name"]."</td><td>".$order["billing"]."</td><td><pre>".$order["comments"]."</pre></td></tr>\n";
}
?>
</table>
diff --git a/index.php b/index.php
index db7b080..83de5b5 100644
--- a/index.php
+++ b/index.php
@@ -1,3 +1,13 @@
+<?php
+require_once "config.php";
+// Get services
+$sql = "SELECT id, name, type, billing FROM services";
+$stmt = mysqli_prepare($link, $sql);
+mysqli_stmt_execute($stmt);
+$result = mysqli_stmt_get_result($stmt);
+$services = $result->fetch_all(MYSQLI_ASSOC);
+?>
+
<!doctype html>
<html>
<head>
@@ -22,7 +32,14 @@
</div>
<div class="col5">
<h3>Services and plans</h3>
- <!-- TODO PHP list of services -->
+ <table>
+ <tr><th>name</th><th>type</th><th>billing</th></tr>
+ <?php
+ foreach ($services as $service) {
+ echo "<tr><td>".$service["name"]."</td><td>".$service["type"]."</td><td>".$service["billing"]."</tr>\n";
+ }
+ ?>
+ </table>
</div>
</div>
</div>