aboutsummaryrefslogtreecommitdiffstats
path: root/A8_srv_build/list.php
diff options
context:
space:
mode:
authorWilliam Harrington <kb0iic@berzerkula.org>2019-02-12 15:57:59 -0600
committerWilliam Harrington <kb0iic@berzerkula.org>2019-02-12 15:57:59 -0600
commit3b5a092df12e386624414f32962bfd500fbabcbb (patch)
treed36eafd2da29012631042d9bcaaa141eeca71bd9 /A8_srv_build/list.php
parent00b1a72baba3c842abdf705ccf0664abf453d75c (diff)
Add A8 server build layout
Diffstat (limited to 'A8_srv_build/list.php')
-rw-r--r--A8_srv_build/list.php253
1 files changed, 253 insertions, 0 deletions
diff --git a/A8_srv_build/list.php b/A8_srv_build/list.php
new file mode 100644
index 0000000..0bac433
--- /dev/null
+++ b/A8_srv_build/list.php
@@ -0,0 +1,253 @@
+<?php
+session_start();
+?>
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<?php
+if( isset( $_SESSION['counter'] )) {
+ $_SESSION['counter'] += 1;
+} else {
+ $_SESSION['counter'] = 1;
+}
+
+$con = isset($_SESSION['con']) ? $_SESSION['con'] : null;
+$bul = isset($_SESSION['bul']) ? $_SESSION['bul'] : null;
+$nst = isset($_SESSION['nst']) ? $_SESSION['nst'] : null;
+$set = isset($_SESSION['set']) ? $_SESSION['set'] : null;
+$not = isset($_SESSION['not']) ? $_SESSION['not'] : null;
+$url = isset($_SESSION['url']) ? $_SESSION['url'] : null;
+
+?>
+
+ <html>
+ <head>
+ <meta http-equiv="content-type" content="text/html;charset=utf-8">
+ <link rel="stylesheet" type="text/css" href="/css/style.css">
+ <link rel="stylesheet" type="text/css" href="/css/table.css">
+ <title>
+ </title>
+ </head>
+ <body>
+<?php
+//DEBUG
+//echo 'Session: ' . session_id() . '<br>';
+//echo '$_SESSION' . var_dump($_SESSION) . '<br>';
+//echo '$_POST' . var_dump($_POST) . '<br>';
+?>
+
+ <a href="add.php" class="stb">Add Record</a><br><br>
+ <form action="sessionvars.php" method="post">
+ Select columns:<br>
+ <input type="checkbox" name="con" value="Configure"
+ <?php echo isSet($con)?" checked":"";?>/>Configure
+ <input type="checkbox" name="bul" value="Build"
+ <?php echo isSet($bul)?" checked":"";?>/>Build
+ <input type="checkbox" name="nst" value="Install"
+ <?php echo isSet($nst)?" checked":"";?>/>Install
+ <input type="checkbox" name="set" value="Setup"
+ <?php echo isSet($set)?" checked":"";?>/>Setup
+ <input type="checkbox" name="not" value="Notes"
+ <?php echo isSet($not)?" checked":"";?>/>Notes
+ <input type="checkbox" name="url" value="URL"
+ <?php echo isSet($url)?" checked":"";?>/>URL<br>
+ <input type="submit" name="submit" value="Submit"/>
+ </form>
+
+<?php
+include 'config.inc';
+
+$sqlselect = 'SELECT id, seq, name, version';
+$sqlfrom = ' FROM PKG';
+$sqlwhere = '';
+
+#if columns are selected
+if($con || $bul || $nst || $set || $not || $url) {
+ $sqlwhere = ' WHERE';
+}
+$sqlorder = ' ORDER BY seq ASC';
+
+#if configure is checked
+if($con) {
+ $sqlselect .= ', configure';
+ $sqlfrom .= ', PKG_CFG';
+ $sqlwhere .= ' PKG_CFG.pkg_id = PKG.id';
+ if($bul || $nst || $set || $not || $url) {
+ $sqlwhere .= ' AND';
+ }
+}
+
+#if build is checked
+if($bul) {
+ $sqlselect .= ', build';
+ $sqlfrom .= ', PKG_BLD';
+ $sqlwhere .= ' PKG_BLD.pkg_id = PKG.id';
+ if($nst || $set || $not || $url) {
+
+ $sqlwhere .= ' AND';
+ }
+
+}
+
+#if install is checked
+if($nst) {
+ $sqlselect .= ', install';
+ $sqlfrom .= ', PKG_NST';
+ $sqlwhere .= ' PKG_NST.pkg_id = PKG.id';
+ if($set || $not || $url) {
+
+ $sqlwhere .= ' AND';
+ }
+
+}
+
+#if setup is checked
+if($set) {
+ $sqlselect .= ', setup';
+ $sqlfrom .= ', PKG_SET';
+ $sqlwhere .= ' PKG_SET.pkg_id = PKG.id';
+ if($not || $url) {
+
+ $sqlwhere .= ' AND';
+ }
+
+}
+
+#if notes is checked
+if($not) {
+ $sqlselect .= ', notes';
+ $sqlfrom .= ', PKG_NOT';
+ $sqlwhere .= ' PKG_NOT.pkg_id = PKG.id';
+ if($url) {
+
+ $sqlwhere .= ' AND';
+ }
+
+}
+
+#if url is checked
+if($url) {
+ $sqlselect .= ', url';
+ $sqlfrom .= ', PKG_URL';
+ $sqlwhere .= ' PKG_URL.pkg_id = PKG.id';
+}
+
+$sql = $sqlselect . $sqlfrom . $sqlwhere . $sqlorder;
+try {
+ $stmt = $pdo->prepare($sql);
+ $stmt->execute();
+} catch (PDOException $e) {
+ echo '<pre style="color:Red">Have a big problem</pre>';
+ throw $e;
+ echo "$e->getMessage()";
+}
+
+if ($stmt->rowCount() > 0) {
+
+ // Data received
+
+ echo '<form method="post" action="delete.php" onSubmit="return confirm(\'Do you really want to delete the selected record(s)?\')">';
+
+ // Begin Table
+ $html_table = '<table class="bdb"><caption>A8-3800 CLFS Server</caption>';
+
+ // Table Header
+ $html_table .= '<thead><tr><th>ACTION</th><th>SEQ</th><th>NAME</th>';
+ $html_table .= '<th>VERSION</th>';
+ if($con){$html_table .= '<th>CONFIGURE</b></th>';}
+ if($bul){$html_table .= '<th>BUILD</th>';}
+ if($nst){$html_table .= '<th>INSTALL</th>';}
+ if($set){$html_table .= '<th>SETUP</th>';}
+ if($not){$html_table .= '<th>NOTES</th>';}
+ if($url){$html_table .= '<th>URL</th>';}
+ $html_table .= '<th>DELETE</th></tr></thead>';
+
+ // Table Footer
+ $html_table .= '<tfoot><tr><th>ACTION</th><th>SEQ</th><th>NAME</th>';
+ $html_table .= '<th>VERSION</th>';
+ if($con){$html_table .= '<th>CONFIGURE</th>';}
+ if($bul){$html_table .= '<th>BUILD</th>';}
+ if($nst){$html_table .= '<th>INSTALL</th>';}
+ if($set){$html_table .= '<th>SETUP</th>';}
+ if($not){$html_table .= '<th>NOTES</th>';}
+ if($url){$html_table .= '<th>URL</th>';}
+ $html_table .= '<th>DELETE</th></tr></tfoot>';
+
+ // Table Body
+ $html_table .= '<tbody>';
+
+ // Table Rows
+ while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
+ $rowid = $row['id'];
+ $rowseq = $row['seq'];
+ $rownm = $row['name'];
+ $rowver = $row['version'];
+ if($con) {
+ $rowcfg = nl2br(str_replace(' ', '&nbsp;', $row['configure']));
+ }
+ if($bul) {
+ $rowbld = nl2br(str_replace(' ', '&nbsp;', $row['build']));
+ }
+ if($nst) {
+ $rownst = nl2br(str_replace(' ', '&nbsp;', $row['install']));
+ }
+ if($set) {
+ $rowset = nl2br(str_replace(' ', '&nbsp;', $row['setup']));
+ }
+ if($not) {
+ $rownot = nl2br(str_replace(' ', '&nbsp;', $row['notes']));
+ }
+ if($url) {
+ $rowurl = nl2br(str_replace(' ', '&nbsp;', $row['url']));
+ }
+ $html_table .= '<tr>';
+ $html_table .= "<td><a href='edit.php?id=".$rowid."'>View</a></td>";
+ $html_table .= '<td><a name="'.$rowseq.'">'.$rowseq.'</a></td>';
+ $html_table .= '<td><a href="openfile.php?name='.$rownm.'" title="installed-files"/'.$rownm.'" title="Installed files list" target="_blank">'.($rownm).'</a></td>';
+ $html_table .= '<td>'.($rowver).'</td>';
+ if($con){$html_table .= '<td>'.($rowcfg).'</td>';}
+ if($bul){$html_table .= '<td>'.($rowbld).'</td>';}
+ if($nst){$html_table .= '<td>'.($rownst).'</td>';}
+ if($set){$html_table .= '<td>'.($rowset).'</td>';}
+ if($not){$html_table .= '<td>'.($rownot).'</td>';}
+ if($url){$html_table .= '<td>'.($rowurl).'</td>';}
+ //$html_table .= "<td><a href='delete.php?id=".$rowid."'>Delete</a></td>";
+ $html_table .= '<td align="center"><input type="checkbox" name="delid[]" class="checks" value="'.($rowid).'"/></td>';
+ $html_table .= '</tr>';
+ }
+
+ // End Table Body
+ $html_table .= '</tbody>';
+
+ // End Table
+ $html_table .= '</table>';
+
+ //Output Table
+ echo $html_table;
+
+} else {
+ // No Data received
+ echo '<font color="#D00"><pre>No data found!</pre></font>';
+}
+?>
+ <input id="submit" type="submit" value="Submit" disabled="disabled"/>
+ <input type="checkbox" id="selectall"/>Check All
+ </form>
+ <!--- w3c tag -->
+ <p align="right">
+ <a href="http://validator.w3.org/check?uri=referer"><img
+ src="http://www.w3.org/Icons/valid-html401" alt="Valid HTML 4.01 Transitional" height="31" width="88"></a>
+ </p>
+ <!-- end w3c tag -->
+ <script src="//code.jquery.com/jquery-1.11.0.min.js"></script>
+ <script type='text/javascript'>
+$('#submit').prop("disabled", true);
+$('input:checkbox').click(function() {
+ if ($(this).is(':checked')) {
+ $('#submit').prop("disabled", false);
+ } else {
+ if ($('.checks').filter(':checked').length < 1){
+ $('#submit').attr('disabled',true);}
+ }
+});
+i </script>
+ </body>
+ </html>
generated by cgit v1.2.3-54-g00ecf (git 2.39.0) at 2025-01-18 10:12:46 +0000