diff options
| author | Sergey Lukin <sergej.lukin@gmail.com> | 2015-12-02 14:24:02 +0200 |
|---|---|---|
| committer | Sergey Lukin <sergej.lukin@gmail.com> | 2015-12-02 14:24:02 +0200 |
| commit | e16df70255f7657f1f6c9252043976758fda08c6 (patch) | |
| tree | e9381186a393b7534911ac9f3c359e87e3b849c7 /usr/share/build-errors/www/index.php | |
| download | build-errors-e16df70255f7657f1f6c9252043976758fda08c6.tar.bz2 build-errors-e16df70255f7657f1f6c9252043976758fda08c6.tar.xz | |
initial commit
Diffstat (limited to 'usr/share/build-errors/www/index.php')
| -rw-r--r-- | usr/share/build-errors/www/index.php | 136 |
1 files changed, 136 insertions, 0 deletions
diff --git a/usr/share/build-errors/www/index.php b/usr/share/build-errors/www/index.php new file mode 100644 index 0000000..75c43e8 --- /dev/null +++ b/usr/share/build-errors/www/index.php @@ -0,0 +1,136 @@ +<!DOCTYPE html> +<html> +<head> + <meta charset="utf-8"> + <title>Alpine Linux - build errors</title> + + <!-- jquery dataTables --> + <script type="text/javascript" src="jquery/dataTables/js/jquery.js"></script> + <script type="text/javascript" src="jquery/dataTables/js/jquery.dataTables.min.js"></script> + <link rel="stylesheet" type="text/css" href="jquery/dataTables/css/jquery.dataTables.min.css"> + <link rel="stylesheet" type="text/css" href="styles.css"> + + <script> + function filterGlobal () { + $('#list_table').DataTable().search( + $('#global_filter').val(), + $('#global_regex').prop('checked'), + $('#global_smart').prop('checked') + ).draw(); + } + + function filterColumn ( i ) { + $('#list_table').DataTable().column( i ).search( + $('#col'+i+'_filter').val(), + $('#col'+i+'_regex').prop('checked'), + $('#col'+i+'_smart').prop('checked') + ).draw(); + } + + $(document).ready(function(){ + var table = $('#list_table').DataTable( { + "order": [[ 5, "desc" ], [ 0, "asc" ], [ 1, "asc" ]], + "paging": false, + "aoColumns": [ + { "bSortable": false }, + null, + null, + null, + { "bSortable": false }, + null + ] + } ); + + $('input.global_filter').on( 'keyup click', function () { + filterGlobal(); + } ); + + $('input.column_filter').on( 'keyup click', function () { + filterColumn( $(this).parents('tr').attr('data-column') ); + } ); + }); + </script> +</head> +<body> + <h1>Alpine Linux - build errors</h1> + <div id="search_table_container"> + <!-- + <table id="search_table"> + <thead> + <tr> + <th>Target</th> + <th>Search text</th> + <th>Treat as regex</th> + <th>Use smart search</th> + </tr> + </thead> + <tbody> + <tr id="filter_global"> + <td class="left">Global search</td> + <td class="left"><input type="text" class="global_filter text" id="global_filter"></td> + <td class="center"><input type="checkbox" class="global_filter" id="global_regex"></td> + <td class="center"><input type="checkbox" class="global_filter" id="global_smart" checked="checked"></td> + </tr> + <tr id="filter_col1" data-column="0"> + <td class="left">hostname</td> + <td class="left"><input type="text" class="column_filter text" id="col0_filter"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col0_regex"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col0_smart" checked="checked"></td> + </tr> + <tr id="filter_col2" data-column="1"> + <td class="left">pkgname</td> + <td class="left"><input type="text" class="column_filter text text" id="col1_filter"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col1_regex"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col1_smart" checked="checked"></td> + </tr> + <tr id="filter_col3" data-column="2"> + <td class="left">reponame</td> + <td class="left"><input type="text" class="column_filter text" id="col2_filter"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col2_regex"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col2_smart" checked="checked"></td> + </tr> + <tr id="filter_col5" data-column="5"> + <td class="left">date</td> + <td class="left"><input type="text" class="column_filter text" id="col5_filter"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col5_regex"></td> + <td class="center"><input type="checkbox" class="column_filter" id="col5_smart" checked="checked"></td> + </tr> + </tbody> + </table> + --> + <table id="list_table" class="hover stripe order-column row-border cell-border"> + <thead> + <tr class="head"> + <th>hostname</th> + <th>pkgname</th> + <th>reponame</th> + <th>logurl</th> + <th>comment</th> + <th>date (UTC)</th> + </tr> + </thead> + <thead> + <tbody> + <?php + $db = new SQLite3("/var/spool/build-errors/sqlite/build-errors.db"); //create the Database object + $query = "select * from build_errors"; + $result = $db->query($query) or die("Failed to read errors from database."); + while ($row = $result->fetchArray()){ + $tr = <<<EOD + <tr> + <td class="nowrap">{$row['hostname']}</td> + <td class="nowrap">{$row['pkgname']}</td> + <td class="nowrap">{$row['reponame']}</td> + <td class="nowrap"><a href="{$row['logurl']}">logurl</a></td> + <td class="nowrap">{$row['comment']}</td> + <td class="nowrap">{$row['datetime']}</td> + </tr> +EOD; + echo $tr; + } + ?> + </tbody> + </table> + </div> +</body> +</html> |