add sitemap
[dcaas.git] / view.php
blob:a/view.php -> blob:b/view.php
--- a/view.php
+++ b/view.php
@@ -1,1 +1,42 @@
+<?php
+include("config.php");
+$data = $db->query("Select * from dcaas_services where acnabn = '31010545267' and service_name = 'Software as a Service (SaaS) - Microsoft Exchange e-mail';")->fetchAll(PDO::FETCH_ASSOC);
+if (count($data) == 0) {
+    header('HTTP/1.0 404 Not Found');
+    includeHeader('Not Found');
+    echo "not found";
+} else {
 
+    $service = $data[0];
+    includeHeader($service['service_name']);
+    ?>
+    <div itemscope itemtype="http://schema.org/Product">
+    <h1 itemprop="name"><?= $service['service_name'] ?></h1>
+
+    <div itemprop="offers" itemscope itemtype="http://schema.org/Offer">
+        <div itemprop="seller" itemscope itemtype="http://schema.org/Organization">
+            <h2>(<span itemprop="name"><?= $service['trading_or_business_name'] ?></span>)</h2>
+            <small><a
+                    href="https://www.tenders.gov.au/?event=public.advancedsearch.CNSONRedirect&type=cnEvent&atmType=archived%2Cclosed%2Cpublished%2Cproposed&agencyUUID=&agencyStatus=0&portfolioUUID=&keyword=&KeywordTypeSearch=AllWord&CNID=&dateType=Publish+Date&dateStart=&dateEnd=&supplierName=&supplierABN=<?= $service['acnabn'] ?>&valueFrom=&valueTo=&ATMID=&AgencyRefId=&consultancy=&submit=Search">
+                    View Australian Government contracts with this supplier on AusTender</a></small>
+            <br/>
+        </div>
+    </div>
+    <br/>
+    <i><span itemprop="description"><?= $service['service_description'] ?></span></i><br/>
+    <table>
+    <?php
+    foreach ($service as $key => $value) {
+        if (trim($value) != "" && !in_array($key, Array('trading_or_business_name' , 'acnabn' , 'service_name' ,'service_description', 'id'))) {
+
+                echo "<tr><td>".ucwords(str_replace("_", " ", $key)) . "</td><td>$value</td></tr>\n";
+
+
+        }
+
+    }
+    echo "</table>";
+
+}
+includeFooter();
+