Index: trunk/ippMonitor/raw/czartool_ipptopsps.php =================================================================== --- trunk/ippMonitor/raw/czartool_ipptopsps.php (revision 32784) +++ trunk/ippMonitor/raw/czartool_ipptopsps.php (revision 32784) @@ -0,0 +1,399 @@ +\n"; + +$labels = getLabels($czardb); + +if ($debug) { + echo "prog returned $status, and output:
"; + for ($i = 0; $i < count($distLabels); $i++) { + echo "$distLabels[$i]
"; + } +} + +$isUpdate = ($selectedMode == "update"); + +// set up the form +echo "
\n"; + +echo "\n"; +echo "\n"; +echo "\n"; +echo "
\n"; + +echo ""; + +echo ""; +echo ""; +echo ""; + +echo ""; +echo ""; +echo "\n"; +echo ""; +echo ""; + +echo "
"; +echo "

Czartool

"; +echo "

IPP to PSPS Monitoring

"; +echo "
"; + # time series plot +echo "
"; + echo "
"; + # rate time series plot +echo "
"; + echo "
"; +echo "		"; +echo ""; + +#echo "
"; + +// status table at top +$plotTypeLink = ($plotType == "linear") ? "log" : "linear"; +$link = "czartool_ipptopsps.php?pass=" . $pass . "&proj=" . $proj . "&label=" . $selectedLabel . "&stage=" . $selectedStage . "&revertstage=" . $stage . "&plottype=$plotTypeLink"; +echo "
"; +echo $table; +createTableTitle("Status and links", 3); +echo "
Time of last update$lastUpdateTime
Documentationhere
\n"; + +$plotTypeLink = ($plotType == "linear") ? "log" : "linear"; +$link = "czartool_ipptopsps.php?pass=" . $pass . "&proj=" . $proj . "&mode=" . $selectedMode . "&label=" . $selectedLabel . "&stage=" . $selectedStage . "&revertstage=" . $stage . "&plottype=$plotTypeLink"; + + + +echo "
"; + + createLabelsTable($pass, + $proj, + $czardb, + $selectedMode, + $labels, + $distLabels, + $pubLabels, + $stages, + "new", + $selectedLabel, + $selectedStage, + $plotType); + +echo "
"; + +echo ""; + +menu_end(); + +########################################################################### +# +# Gets labels in use over the last 24 hours +# +########################################################################### +function getLabels($db) { + + # order by descending priority as set in gpc1 database + $sql = "SELECT DISTINCT label FROM processed WHERE timestamp >= now() - INTERVAL 1 DAY"; + if ($debug) {echo "$sql
";} + + $qry = $db->query($sql); + if (dberror($qry)) {echo "error with $sql
\n";} + while ($qry->fetchInto($row)) { + + $labels[] = $row[0]; + } + + return $labels; +} + +########################################################################### +# +# Creates table for all labels showing all stages for given 'state' +# +########################################################################### +function createLabelsTable( + $pass, + $proj, + $db, + $selectedMode, + $labels, + $distLabels, + $pubLabels, + $stages, + $selectedState, + $selectedLabel, $selectedStage, $plotType) { + + $isUpdate = ($selectedMode == "update"); + global $headerColor; + global $columnHeaderColor; + + // setup table + global $table; + echo $table; + createTableTitle("Label status", 13); + + echo "\n"; + $link = "czartool_ipptopsps.php?pass=".$pass + ."&proj=".$proj + ."&mode=".$selectedMode + ."&label=".$selectedLabel + ."&stage=all_stages" + ."&plottype=".$plotType; + createFormattedTableCell(($selectedStage != "all_stages"), $link, "All stages", 0, "$columnHeaderColor"); + + #echo "Label (in order of priority)"; + foreach ($stages as &$stage) { + + if ($stage == $selectedStage) $showLink = 0; + else $showLink = 1; + $link = + "czartool_ipptopsps.php?pass=".$pass + ."&proj=".$proj + ."&mode=" .$selectedMode + ."&label=".$selectedLabel + ."&stage=".$stage + ."&plottype=".$plotType; + + createFormattedTableCell($showLink, $link, $stage, 0, "$columnHeaderColor"); +# createTableColumnHeader("Dates"); + } + + // setup default link + $defaultlink = + "czartool_ipptopsps.php?pass=".$pass + ."&proj=".$proj + ."&mode=" .$selectedMode + ."&label=".$selectedLabel + ."&stage=".$selectedStage + ."&plottype=".$plotType; + + $searchState = "new"; + if ($selectedMode == "update") $searchState = "update"; + + // write rows + foreach ($labels as &$thisLabel) { + + + $distributing = false; + $publishing = false; + + // show distribution/publishing status + echo "\n"; + + // create link to label summary page for each label + if ($thisLabel == $selectedLabel) $showLink = 0; + else $showLink = 1; + $link = + "czartool_ipptopsps.php?pass=".$pass + ."&proj=".$proj + ."&mode=" .$selectedMode + ."&label=".$thisLabel + ."&stage=".$selectedStage + ."&plottype=".$plotType; + createFormattedTableCell($showLink, $link, $thisLabel, 0, null); + + $str = ""; + $anyFaults = false; + + $link = $defaultlink; + getStateAndFaults($db, $thisLabel, $selectedState, "processed", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + getStateAndFaults($db, $thisLabel, $selectedState, "loaded_to_datastore", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + getStateAndFaults($db, $thisLabel, $selectedState, "loaded_to_ODM", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + getStateAndFaults($db, $thisLabel, $selectedState, "merge_worthy", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + getStateAndFaults($db, $thisLabel, $selectedState, "deleted_datastore", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + getStateAndFaults($db, $thisLabel, $selectedState, "deleted_dxlayer", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + getStateAndFaults($db, $thisLabel, $selectedState, "merged", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + getStateAndFaults($db, $thisLabel, $selectedState, "deleted_local", $str, $anyFaults); + createFormattedTableCell(0, $link, $str, $anyFaults, 0); + + echo "\n"; + } + + echo "\n"; + $link = "czartool_ipptopsps.php?pass=" . $pass . "&proj=" . $proj . "&mode=" . $selectedMode . "&label=all&stage=".$selectedStage."&plottype=".$plotType; + + echo "\n"; + if ($selectedLabel == "all") $showLink = 0; + else $showLink = 1; + $link = "czartool_ipptopsps.php?pass=".$pass."&proj=".$proj."&mode=".$selectedMode."&label=all&stage=".$selectedStage."&plottype=".$plotType; + + echo "\n"; + echo "\n"; +} + + +########################################################################### +# +# Creates a table title +# +########################################################################### +function createTableTitle($str, $colSpan) { + + global $headerColor; + echo "

$str

"; +} + +########################################################################### +# +# Creates a table header cell +# +########################################################################### +function createTableColumnHeader($str) { + + global $columnHeaderColor; + echo "

$str

"; +} + +########################################################################### +# +# Creates table cell with a red background if an error +# +########################################################################### +function createFormattedTableCell($showLink, $link, $str, $error, $color) { + + $fontColor = $error ? "black" : "blue"; + + if ($error) echo ""; + else if ($color) echo ""; + else echo ""; + if ($showLink) echo "$str"; + else if ($str) echo "$str"; + else echo " "; +} + + +########################################################################### +# +# Returns state and fault-count (if new) as a string +# +########################################################################### +function getStateAndFaults($db, $label, $state, $stage, &$str, &$anyFaults) { + + $anyFaults = false; + $sql = "SELECT pending, faults FROM $stage WHERE label LIKE '$label' ORDER BY timestamp DESC LIMIT 1"; + if ($debug) {echo "$sql
";} + + $qry = $db->query($sql); + if (dberror($qry)) {echo "error with $sql
\n";} + $qry->fetchInto($row); + + $pending = $row[0]; + $faults = $row[1]; + + if ($pending == 0) + $str = ""; + else + $str = "$pending"; + + if ($state == "new") { + + if ($faults > 0) { + + $str = $str."(".$faults.")"; + $anyFaults = true; + } + } +} + +########################################################################### +# +# Returns time of last czarDb update +# +########################################################################### +function getLastUpdateTime($db) { + + $anyFaults = false; + $sql = "SELECT timestamp FROM processed ORDER BY timestamp DESC LIMIT 1"; + if ($debug) {echo "$sql
";} + + $qry = $db->query($sql); + if (dberror($qry)) {echo "error with $sql
\n";} + $qry->fetchInto($row); + + return $row[0]; +} + + +?> +