From 9e24e58c2294547bb03b8b1ba7bcfbb899d41b27 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 11 Apr 2018 11:45:22 +0200 Subject: web-scripts/todos.php: generate text-todos from database, too --- web-scripts/todos.php | 109 ++++++++++++++++++++++++++++++++------------------ 1 file changed, 69 insertions(+), 40 deletions(-) (limited to 'web-scripts') diff --git a/web-scripts/todos.php b/web-scripts/todos.php index 49bb9ac..99e991c 100644 --- a/web-scripts/todos.php +++ b/web-scripts/todos.php @@ -14,53 +14,82 @@ $result = $mysql -> query( "FROM `todos`;" ); -if ($result -> num_rows > 0) { +if (isset($_GET["graph"])) { - while ($row = $result->fetch_assoc()) - $knot_rows[$row["id"]] = - $row["file"]. " (line ".$row["line"]."):\\n".str_replace("\"","\\\"",$row["description"]); + if ($result -> num_rows > 0) { - unset($knots); - foreach ($knot_rows as $knot) - $knots=$knots . "\"" . $knot . "\";\n"; + while ($row = $result->fetch_assoc()) + $knot_rows[$row["id"]] = + $row["file"]. " (line ".$row["line"]."):\\n".str_replace("\"","\\\"",$row["description"]); -} + unset($knots); + foreach ($knot_rows as $knot) + $knots=$knots . "\"" . $knot . "\";\n"; -$result = $mysql -> query( - "SELECT DISTINCT " . - "`todo_links`.`dependent`," . - "`todo_links`.`depending_on` " . - "FROM `todo_links`;" -); + } -if ($result -> num_rows > 0) { - $count = 0; - while ($row = $result->fetch_assoc()) { - $link_rows[$count]["dependent"] = - $knot_rows[$row["dependent"]]; - $link_rows[$count]["depending_on"] = - $knot_rows[$row["depending_on"]]; - $count++; + $result = $mysql -> query( + "SELECT DISTINCT " . + "`todo_links`.`dependent`," . + "`todo_links`.`depending_on` " . + "FROM `todo_links`;" + ); + + if ($result -> num_rows > 0) { + $count = 0; + while ($row = $result->fetch_assoc()) { + $link_rows[$count]["dependent"] = + $knot_rows[$row["dependent"]]; + $link_rows[$count]["depending_on"] = + $knot_rows[$row["depending_on"]]; + $count++; + } + + unset($edges); + foreach ($link_rows as $link) + $edges=$edges . "\"" . $link["depending_on"] . "\" -> \"" . $link["dependent"] . "\";\n"; } - unset($edges); - foreach ($link_rows as $link) - $edges=$edges . "\"" . $link["depending_on"] . "\" -> \"" . $link["dependent"] . "\";\n"; -} + $knots = str_replace("\$","\\\$",$knots); + $edges = str_replace("\$","\\\$",$edges); -$knots = str_replace("\$","\\\$",$knots); -$edges = str_replace("\$","\\\$",$edges); - -header ("Content-type: image/png"); -passthru( - "dot -Tpng -o/dev/stdout /dev/stdin < num_rows > 0) { + + print "\n"; + print "\n"; + print "Todos in the build scripts\n"; + print "\n"; + print "\n"; + + while ($row = $result->fetch_assoc()) { + print "TODO #" . $row["id"] . ""; + print " - "; + print "" . $row["file"] . "(line " . $row["line"] . ")"; + print ":
\n"; + print str_replace("\\n","
\n",$row["description"]); + print "
\n"; + print "
\n"; + } + + print "\n"; + print "\n"; + + } + +} ?> -- cgit v1.2.3