Colony » Colony Scout

<?php                

$pageNum = (isset($_GET['page'])) ? $_GET['page'] : 1;        // if $_GET['page'] defined, use it as page number

$rowsPerPage = 20;                                                                                        // how many rows to show per page

$offset = ($pageNum - 1) * $rowsPerPage;                                        // counting the offset

/* SYSTEMS:

view (list)

add

remove (admin only option, and just makes it inactive)

modify (add remove items, edit details)

probably 10-30 systems total (including charging, diagnostics, etc)

tech specs contains number of parts used, type of system

*/

?>

<style>

        tr.odd {background:#ccc url('images/row_blue.jpg');height:87px;}

        tr.even {background:#ccc url('images/row_gray.jpg');height:87px;}

        table.system {background-color:#fff;width:920px;color:#000099;font-weight:500;}

        table.system td{vertical-align:top;}

        table.system img.thumb{border:2px solid #ececec;margin:4px;height:72px;}

</style>

<h1>Systems</h1><i>are comprised of multiple parts, and range from single circuit boards to full-blown accessory packs.</i>

<table class="system" cellspacing="1">

        <tr>

                <th><h2>Image</h2></th>

                <th width="320px"><h2>Description</h2></th>

                <th width="90px"><h2>Files</h2></th>

                <th width="220px"><h2>Tech Specs</h2></th>

                <th width="160px"><h2>Build Order</h2></th>

        </tr>

<?php

//gather the inventory based on search term or all

$get_system_sql = "SELECT ID, name, revision, active, left(notes,140) as notes_trunc, tags, contact, (SELECT count(systemid) from syspartlinks WHERE systems.id=syspartlinks.systemid) as partcount FROM systems ORDER BY active DESC LIMIT $offset, $rowsPerPage";

$get_system_res = mysqli_query($mysqli, $get_system_sql) or die(mysqli_error($mysqli));

if (mysqli_num_rows($get_system_res) < 1) {

        $display_block = "</table><br/><h1>No inventory matched those search terms.</h1>";

} else {

        //create the display string

        $display_block = "";

        $i = 0;

        while ($sys = mysqli_fetch_array($get_system_res)) {

                $class = ($i%2 ? 'odd' : 'even');

                $img_active = ($sys['active']!=0) ? "images/active_true.png" : "images/active_false.png";

                $display_block .=

                "<tr class=".$class.">

                        <td><img class=\"thumb\" src=\"".getSystemThumbFromDisk($sys['name']."_".$sys['revision'])."\"/></td>

                        <td><a href=\"?tab=viewsys&q=".$sys['ID']."\"><h2>".$sys['name']." ".$sys['revision']."</h2></a><img src=\"".$img_active."\"/><br/>".$sys['notes_trunc']."</td>

                        <td></td>

                        <td><b>Contact: </b>".$sys['contact']."<br/><br/><b>Part Count: </b>".getPartCountForSystem($sys['ID'])."</td>

                        <td></td>

                </tr>

                ";

                $i++;

        }

        $display_block .= "</table><br/><br/>";

}

        echo $display_block;

?>

        <tr>

                <td></td><td></td><td></td><td></td><td></td>

        </tr>

</table>