sqlite import
[dcaas.git] / table.php
blob:a/table.php -> blob:b/table.php
--- a/table.php
+++ b/table.php
@@ -1,1 +1,99 @@
+<?php
+include ("config.php");
+include ("lib/tag-cloud/src/lotsofcode/TagCloud/TagCloud.php");
 
+includeHeader("title");
+?>
+
+    <div class="starter-template">
+        <br/>
+        <br/>
+
+        <h1>Bootstrap starter template</h1>
+
+        <p class="lead">Use this document as a way to quickly start any new project.<br> All you get is this text and a
+            mostly barebones HTML document.</p>
+
+        <div id="search-example-year-filter" style="float: left;">
+            Year:
+            <select id="search-year" name="year">
+                <option></option>
+                <option>2001</option>
+                <option>2003</option>
+                <option>2008</option>
+                <option>2013</option>
+            </select>
+        </div>
+
+        <div id="search-function-example-price-filter" style="float: left; margin-bottom: 1em;">
+            Max Price:
+            $<input id="max-price" type="number" step="1000" data-dynatable-query="max-price">
+        </div>
+
+
+        <table id="my-table">
+            <thead>
+            <?php
+            $row = 0;
+            $csvfile = './data/DCaaS+Catalogue+September+2013 PublicDCaaS_AFI_Part_3_Sec_5_Service_.csv';
+            if (($handle = fopen($csvfile, "r")) !== FALSE) {
+                while (($data = fgetcsv($handle, 4096, ",")) !== FALSE) {
+                    if ($row == 0) {
+                        echo "<thead><th>" . implode($data, "</th><th>") . "</th></thead> \n";
+                    } else {
+                        echo "<tr><td>" . implode($data, "</td><td>") . "</td></tr> \n";
+                    }
+                    $row++;
+                }
+                fclose($handle);
+            }
+            ?>
+        </table>
+    </div>
+
+
+
+<!-- Bootstrap core JavaScript
+================================================== -->
+<!-- Placed at the end of the document so the pages load faster -->
+<script src="https://code.jquery.com/jquery-1.10.2.min.js"></script>
+<script src="js/bootstrap.min.js"></script>
+<script src="js/dynatable/jquery.dynatable.js"></script>
+<script>
+    $('#my-table').dynatable();
+
+    $('#search-example').dynatable({
+        features: {
+            paginate: false,
+            recordCount: false,
+            sorting: false
+        },
+        inputs: {
+            queries: $('#search-year')
+        }
+    });
+
+    $('#search-function-example')
+        .bind('dynatable:init', function (e, dynatable) {
+            dynatable.queries.functions['max-price'] = function (record, queryValue) {
+                return parseFloat(record.price.replace(/,/, '')) <= parseFloat(queryValue);
+            };
+        })
+        .dynatable({
+            features: {
+                paginate: false,
+                recordCount: false,
+                sorting: false,
+                search: false
+            },
+            inputs: {
+                queries: $('#max-price')
+            }
+        });
+
+</script>
+
+<?php
+includeFooter();
+?>
+