| <?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(); | |
| ?> | |