lots of changed, though it'll probably be all backed-out because
[configmanager.git] / lib / www.php
index 794279b..3b7c506 100644 (file)
@@ -15,7 +15,11 @@ $FUNCTIONS["config"] = "www_configure";
 $FUNCTIONS["addhost"] = "www_addhost";
 $FUNCTIONS["addhostnext"] = "www_addHostStageTwo";
 $FUNCTIONS["addhostthree"] = "www_addHostStageThree";
-
+$FUNCTIONS["delete"] = "www_deleteHost";
+$FUNCTIONS["update"] = "www_updateHost";
+$FUNCTIONS["detail"] = "www_hostDetail";
+$FUNCTIONS["getconfig"] = "www_getConfig";
+$FUNCTIONS["downloadconfig"] = "www_downloadConfig";
 
 function www_header()
 {
@@ -74,9 +78,120 @@ function www_body()
        
        $db = db_getDB();
        
-       // here we do the normal body, whatever that
+       // here we do the normal body
        // we'll list the hosts, the size of the current config and
        // the last time it was updated, plus the number of versions
+       $data = db_selectData("hosts");
+       if(!$data) {
+               echo "No hosts currently exist, add them from the right<br>"; 
+       } else {
+               echo "<table border=\"1\">";
+               echo "<tr><th>Name</th><th>Address</th><th>Last Update</th><th>Schedule</th><th>Versions</th><th>Controls</th></tr>";
+               foreach($data as $dstruct) {
+                       //print_r($dstruct);
+                       $name = $dstruct["hostname"];
+                       $addr = $dstruct["hostip"];
+                       if($dstruct["lastupdate"] != 0) {
+                               $dold = round((time()-$dstruct["lastupdate"])/86400);
+                               
+                               $lupdate = strftime("%T %e %b %G", $dstruct["lastupdate"])." ($dold days old)";
+                       } else {
+                               $lupdate = "Never";
+                       }
+                       $sched = $dstruct["updateschedule"];
+                       $vd = count(db_selectData("configs", "hostip", "$addr"));
+                       echo "<tr><td><a href=\"?action=detail&hip=$addr\">$name</a></td><td>$addr</td><td>$lupdate</td><td>$sched</td><td>$vd</td><td>";
+                       echo "<a href=\"?action=delete&hip=$addr\">Delete</a> <a href=\"?action=edit&hip=$addr\">Edit</a> <a href=\"?action=update&hip=$addr\">Update</a>";
+                       echo "</td></tr>";
+               
+               }
+               echo "</table>";
+       }
+       
+}
+
+function www_getConfig()
+{
+       global $HOST_TYPE;
+       
+       $cid = $_REQUEST["cid"];        
+       $hip = $_REQUEST["hip"];
+       $data = db_selectData("hosts", "hostip", "$hip");
+       
+       $hostname = $data[0]["hostname"];
+       $htype = $data[0]["hosttype"];
+       
+       $func = $HOST_TYPE["$htype"]["getconfig"];
+       
+       error_log("calling $func with $hip, and $cid");
+       $rdata = $func("$hip", "$cid");
+       
+       echo "Config:<br>";
+       echo "<pre>";
+       echo $rdata;
+       echo "</pre>";
+}
+
+function www_downloadConfig()
+{
+       global $HOST_TYPE;
+       
+       $cid = $_REQUEST["cid"];        
+       $hip = $_REQUEST["hip"];
+       $data = db_selectData("hosts", "hostip", "$hip");
+       
+       $hostname = $data[0]["hostname"];
+       $htype = $data[0]["hosttype"];
+       
+       $func = $HOST_TYPE["$htype"]["getconfig"];
+       
+       error_log("calling $func with $hip, and $cid");
+       $rdata = $func("$hip", "$cid");
+       
+       echo "Config:<br>";
+       echo "<pre>";
+       echo $rdata;
+       echo "</pre>";
+}
+
+function www_hostDetail()
+{
+       global $HOST_TYPE;
+       
+       //db_createTable("configs", "hostip", "configtime", "configdata");
+       //db_createTable("hosts", "hostname", "hostip", "hosttype", "hostconfig", "lastupdate", "updateschedule");
+       //function db_updateData($tablename, $column, $newdata, $wherecol, $wheredata, $exact=true)
+       $hip = $_REQUEST["hip"];
+       $data = db_selectData("hosts", "hostip", "$hip");
+       
+       $hconfig = $data[0]["hostconfig"];
+       $hostname = $data[0]["hostname"];
+       $htype = $data[0]["hosttype"];
+       
+       $func = $HOST_TYPE["$htype"]["detail"];
+       
+       error_log("calling $func with $hip, and $hconfig");
+       $func("$hip");
+}
+
+function www_updateHost()
+{
+       global $HOST_TYPE;
+       
+       //db_createTable("configs", "hostip", "configtime", "configdata");
+       //db_createTable("hosts", "hostname", "hostip", "hosttype", "hostconfig", "lastupdate", "updateschedule");
+       //function db_updateData($tablename, $column, $newdata, $wherecol, $wheredata, $exact=true)
+       $hip = $_REQUEST["hip"];
+       $data = db_selectData("hosts", "hostip", "$hip");
+       
+       $hconfig = $data[0]["hostconfig"];
+       $hostname = $data[0]["hostname"];
+       $htype = $data[0]["hosttype"];
+       
+       $func = $HOST_TYPE["$htype"]["updateconfig"];
+       
+       error_log("calling $func with $hip, and $hconfig");
+       $func("$hip", $hconfig);
        
 }
 
@@ -91,15 +206,54 @@ function www_hostTypesDropDown()
        }
 }
 
+function www_deleteHost()
+{
+       $hip = $_REQUEST["hip"];
+       $data = db_selectData("hosts", "hostip", "$hip");
+       
+       $hostname = $data[0]["hostname"];
+
+       if(isset($_REQUEST["confirmed"])) {
+               db_deleteData("hosts", "hostip", "$hip");
+               db_deleteData("configs", "hostip", "$hip");
+               echo "Done!";
+       } else {
+               echo "Are you use you wish to delete the host, $hostname with IP address $hip? (and all associated config info)<br>";
+               echo "<a href=\"?action=delete&hip=$hip&confirmed=yes\">Yes</a>";
+               echo "<pre>";
+               print_r($data);
+               echo "</pre>";
+       }
+}
+
+function www_updateSchedule()
+{
+?>
+<option value="0">Manual Only</option>
+<option value="900">Every 15 Minutes</option>
+<option value="3600">Every Hour</option>
+<option value="14400">Every 4 Hours</option>
+<option value="86400">Once a Day</option>
+<option value="604800">Once a Week</option>
+<option value="2592000">Once a Month (30 Days)</option>
+<option value="7776000">Every 3 Months (90 days)</option>
+<option value="10368000">Every 6 Months (180 Days)</option>
+<?php
+}
+
 function www_addhost()
 {
+       $db = db_getDB();
+       
+       db_createTable("hosts", "hostname", "hostip", "hosttype", "hostconfig", "lastupdate", "updateschedule");
+       db_createTable("configs", "hostip", "configtime", "configdata");
        ?>
 <form method="post" action="?action=addhostnext">
 <table>
 <tr><td>Name</td><td><input type="text" name="cname"></td></tr>
 <tr><td>Hostname/IP Address</td><td><input type="text" name="hname"></td></tr>
 <tr><td>Host Type</td><td><select name="hosttype"><?php www_hostTypesDropDown() ?></select></td></tr>
-</table>
+<tr><td>Update Schedule</td><td><select name="updatesched"><?php www_updateSchedule() ?></select></td></tr></table>
 <input type="submit" value="Next" name="Next">
 </form>
        <?php
@@ -108,11 +262,23 @@ function www_addhost()
 function www_addHostStageTwo()
 {
        global $HOST_TYPE;
+       
+       $data = db_selectData("hosts", "hostip", $_REQUEST["hname"]);
+       if($data) {
+               echo "Host already exists in database\n";
+               return false;
+       } else {
+               db_insertData("hosts", $_REQUEST["cname"], $_REQUEST["hname"], $_REQUEST["hosttype"], "", "", $_REQUEST["updatesched"]);
+       }
        if(isset($_REQUEST["hosttype"])) {
                $htype = $_REQUEST["hosttype"];
                $func = $HOST_TYPE["$htype"]["configform"];
+               $hip = $_REQUEST["hname"];
+               $hname = $_REQUEST["hname"];
+               $upsched = $_REQUEST["updatesched"];
                if(function_exists($func)) {
-                       echo "<form method=\"post\" action=\"?action=addhostthree&hosttype=$htype\">";
+                       
+                       echo "<form method=\"post\" action=\"?action=addhostthree&hosttype=$htype&hostname=$hname&hostip=$hip&upsched=$upsched\">";
                        $func();
                        echo "<input type=\"submit\" value=\"Add\" name=\"Add\">";
                } else echo "would call $func for $htype but it doesnt exist\n";
@@ -123,7 +289,7 @@ function www_addHostStageThree()
 {
        global $HOST_TYPE;
        if(isset($_REQUEST["hosttype"])) {
-               $htype = $_REQUEST["htype"];
+               $htype = $_REQUEST["hosttype"];
                $func = $HOST_TYPE["$htype"]["postfunction"];
                if(function_exists($func)) {
                        $func();