summaryrefslogtreecommitdiffstats
path: root/rpm.php
diff options
context:
space:
mode:
authorRemi Collet <fedora@famillecollet.com>2010-05-25 06:40:18 +0200
committerRemi Collet <fedora@famillecollet.com>2010-05-25 06:40:18 +0200
commitba771dc91b13c70509b6da1589e7e9c4a95b3384 (patch)
treef5eea1c46aaad29c7d3ea2304d975b0e42dc4f76 /rpm.php
parent2ec0f85de586973a65e88194216810c9f2ad335e (diff)
parentb76086add9ffb0cbd9ddf54955df51db436ed07a (diff)
Merge branch 'master' of http://github.com/trasher/rpmphp
Diffstat (limited to 'rpm.php')
-rw-r--r--rpm.php293
1 files changed, 121 insertions, 172 deletions
diff --git a/rpm.php b/rpm.php
index 2da5bfc..7c42c3c 100644
--- a/rpm.php
+++ b/rpm.php
@@ -3,80 +3,26 @@ $what=(isset($_GET["what"]) ? $_GET["what"] : "%fedora");
$type=(isset($_GET["type"]) ? $_GET["type"] : "pecl");
require "config.inc.php";
-?>
-<html>
- <head>
- <title><?php echo $type; ?> extensions in Fedora</title>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <link rel="stylesheet" type="text/css" media="print" href="http://docs.fedoraproject.org/css/print.css">
- <style type="text/css" media="screen">
- @import url("http://docs.fedoraproject.org/css/layout.css");
- @import url("http://docs.fedoraproject.org/css/content.css");
- @import url("http://docs.fedoraproject.org/css/docbook.css");
-
-body {
- background-image:none;
-}
-.error {
- background:url(http://fedoraproject.org/wikidata/kindofblue/img/icon-error.png) no-repeat left;
- padding-left: 21px;
-}
-
-.info {
- background:url(http://fedoraproject.org/wikidata/kindofblue/img/icon-info.png) no-repeat left;
- padding-left: 21px;
-}
-
-.attn {
- background:url(http://fedoraproject.org/wikidata/kindofblue/img/attention.png) no-repeat left;
- padding-left: 21px;
-}
-
-.check {
- background:url(http://fedoraproject.org/wikidata/kindofblue/img/checkmark.png) no-repeat left;
- padding-left: 21px;
-}
-
-.cpan {
- background:url(http://www.perl.com/favicon.ico) no-repeat left;
- padding-left: 18px;
-}
-
-.rt {
- background:url(/img/rt.png) no-repeat left;
- padding-left: 18px;
-}
-
-.bz {
- background:url(/img/bz.png) no-repeat left;
- padding-left: 18px;
-}
-<?php
-
-function Report ($db, $type) {
- global $what;
-
- echo "<h1>".strtoupper($type)." extensions in Fedora</h1>\n";
-
-
- $repos=array();
+function listRepos($db){
+ $repos = array();
$res=$db->query("SELECT * FROM repo WHERE active=1 ORDER BY ID");
if ($res) while ($repo = $res->fetchObject()) {
$repos[$repo->main][$repo->sub]=$repo;
}
- // echo "<pre>"; print_r($repos);echo "</pre>";
-
- echo "<table id='fedora-list-packages'>\n";
- echo "<tr class='odd'><th>Package</th><th>Owner(s)</th><th>Upstream</th>";
-
+ // echo "<pre>"; print_r($repos);echo "</pre>";
foreach($repos as $repomain) {
foreach ($repomain as $repo) {
- printf ("<th align='left'>%s</th>", $repo->main);
+ /*printf ("<th align='left'>%s</th>", $repo->main);*/
+ $repos[$repo->main][$repo->sub] = $repo;
break;
}
}
- echo "</tr>\n";
+ return $repos;
+}
+
+function Report ($db, $type, $repos) {
+ global $what;
$i=0;
$resup=$db->query("SELECT * FROM upstream WHERE type='$type' ORDER BY name");
@@ -97,7 +43,7 @@ function Report ($db, $type) {
case '%fedora':
$display = ($rpm !== false);
break;
- case '%stable':
+ case '%stable':
$display = !empty($upstream->stable);
break;
case '%all':
@@ -110,7 +56,7 @@ function Report ($db, $type) {
if ($display) {
if ($rpm) {
- $dispname = "<a href='zoom.php?rpm=" . $rpmname . "' title='" . $rpm->summary . "'>$rpmname</a>";
+ $dispname = "<a href=\"zoom.php?rpm=" . $rpmname . "\" title=\"" . htmlentities($rpm->summary) . "\">$rpmname</a>";
} else {
$dispname = $rpmname;
}
@@ -121,14 +67,14 @@ function Report ($db, $type) {
$dispowner="";
foreach ($owners as $owner) {
- if ($dispowner) $dispowner .= "<br>";
- $dispowner .= sprintf ("<a href='%s?type=$type&what=%s'>%s</a>", $_SERVER["PHP_SELF"], $owner, $owner);
+ if ($dispowner) $dispowner .= "<br/>";
+ $dispowner .= sprintf ("<a href=\"%s?type=$type&amp;what=%s\">%s</a>", $_SERVER["PHP_SELF"], $owner, $owner);
}
- printf ("<tr class='%s'><td>%s<br><small>%s</small></td><td>%s</td><td>%s%s</td>",
- ($i%2 ? "odd" : "even"), $dispname,
+ printf ("<tr class=\"%s\">\n\t<td>%s<br/><small>%s</small></td>\n\t<td>%s</td>\n\t<td>%s%s</td>\n",
+ ($i%2 ? "odd" : "even"), $dispname,
($upstream->channel != $upstream->type ? "channel: " . $upstream->channel : ""),
$dispowner,
- ($upstream->stable ? "<b>".$upstream->stable."</b><br />" : "&nbsp;"),
+ ($upstream->stable ? "<strong>".$upstream->stable."</strong><br />" : "&nbsp;"),
($upstream->unstable && (!$upstream->stable || $upstream->stable!=$upstream->unstable) ? $upstream->unstable." <small>(".$upstream->state.")</small>" : "&nbsp;"));
$verup = strtolower($upstream->stable ? $upstream->stable : $upstream->unstable);
@@ -137,132 +83,118 @@ function Report ($db, $type) {
$display="";
$class="";
foreach ($repomain as $repo) {
- if (isset($rpms[$repo->main."-".$repo->sub])) {
+ if (isset($rpms[$repo->main."-".$repo->sub])) {
$rpm=$rpms[$repo->main."-".$repo->sub];
$verpm=$rpm->ver;
if (preg_match("/\.((beta|RC)\d*)\./i", $rpm->rel, $res)) {
$verpm .= strtolower($res[1]);
}
-
+
switch ($repo->sub) {
case "base":
if (isset($rpms[$repo->main."-updates"])) {
- $display .= sprintf("%s-%s<br>", $rpm->ver, $rpm->rel);
+ $display .= sprintf("%s-%s<br/>", $rpm->ver, $rpm->rel);
} else {
- $display .= sprintf("<b>%s</b>-%s<br>", $rpm->ver, $rpm->rel);
+ $display .= sprintf("<strong>%s</strong>-%s<br/>", $rpm->ver, $rpm->rel);
}
if ($verup==$verpm) $class="check";
break;
case "":
- $display .= sprintf("<b>%s</b>-%s<br>", $rpm->ver, $rpm->rel);
+ $display .= sprintf("<strong>%s</strong>-%s<br/>", $rpm->ver, $rpm->rel);
if ($verup==$verpm) $class="check";
break;
case "updates":
- $display .= sprintf("<b>%s</b>-%s <small>(updates)</small><br>", $rpm->ver, $rpm->rel);
+ $display .= sprintf("<strong>%s</strong>-%s <small>(updates)</small><br/>", $rpm->ver, $rpm->rel);
if ($verup==$verpm) $class="check";
break;
case "testing":
- $display .= sprintf("%s-%s <small>(testing)</small><br>", $rpm->ver, $rpm->rel);
+ $display .= sprintf("%s-%s <small>(testing)</small><br/>", $rpm->ver, $rpm->rel);
if ($verup==$verpm) $class="info";
- break;
+ break;
}
} // RPM exists
} // sub repo
if ($display && empty($class)) $class="attn";
if ($display) {
- printf("<td><div class='%s'>%s</div></td>", $class, $display);
+ printf("\t<td class=\"%s\">%s</td>\n", $class, $display);
} else {
- echo "<td>&nbsp;</td>";
+ echo "\t<td>&nbsp;</td>\n";
}
} // mainrepo
echo "</tr>\n";
- $i++;
+ $i++;
}
} // each $unstable
- echo "</table>\n";
- echo "<p>$i packages found</p>";
+ echo "<tr id=\"count_found\"><td colspan=\"" . (count(array_keys($repos)) + 3) . "\">$i packages found</td></tr>\n";
}
-try {
- $db = new PDO ("mysql:dbname=" . MYBASE . ";host=" . MYHOST, MYUSER, MYPASS);
?>
- </style>
-
- <meta name="MSSmartTagsPreventParsing" content="TRUE">
- <link rel="shortcut icon" href="http://docs.fedoraproject.org/images/favicon.ico">
- <link rel="icon" href="http://docs.fedoraproject.org/images/favicon.ico">
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
+ <head>
+ <title><?php echo $type; ?> extensions in Fedora</title>
+ <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
+ <link rel="stylesheet" type="text/css" media="screen" href="css/rpmphp.css"/>
+ <!--<link rel="stylesheet" type="text/css" media="print" href="css/rpmphp-print.css">-->
+ <link rel="shortcut icon" href="images/favicon.ico"/>
+ <link rel="icon" href="images/favicon.ico"/>
</head>
-
<body>
- <!-- header BEGIN -->
- <div id="fedora-header">
- <div id="fedora-header-logo">
-
- <a href="http://fedoraproject.org"><img src="http://docs.fedoraproject.org/images/header-fedora_logo01.png" alt="Fedora Project"></a>
- </div>
-
- <div id="fedora-header-items">
- <span class="fedora-header-search">
+ <div id="wrapper">
<?php
- echo "<form action='" . $_SERVER["PHP_SELF"] . "' method='get'>";
- echo "<input type='hidden' name='type' value='$type' />";
+include '_header.php';
?>
- <select name='what' size='1'>
- <optgroup label='Pakages'>
- <option value='%fedora' <?php if ($what=='%fedora') echo " selected='1'"; ?> >In fedora</option>
- <option value='%stable' <?php if ($what=='%stable') echo " selected='1'"; ?> >All stable</option>
- <option value='%all' <?php if ($what=='%all') echo " selected='1'"; ?> >All</option>
- </optgroup>
- <optgroup label='Owner'>
+ <!-- content BEGIN -->
+ <div id="fedora-content">
+ <div id="ariane">
+ <p>You are here: </p>
+ <ul>
+ <li><a href="./">Reports home</a></li>
+ <li><a href="#"><?php echo strtoupper($type) . ' extensions'; ?></a></li>
+ </ul>
+ </div>
+
+ <div id="filter">
+ <form action="rpm.php" method="get">
+ <fieldset>
+ <legend>Filter <?php echo strtoupper($type); ?> packages</legend>
+ <input type="hidden" name='type' value="<?php echo $type; ?>" />
+ <label for="what">Where to search: </label>
+ <select name="what" id="what">
+ <optgroup label="Pakages">
+ <option value="%fedora"<?php if ($what=='%fedora') echo " selected=\"selected\""; ?>>In fedora</option>
+ <option value="%stable"<?php if ($what=='%stable') echo " selected=\"selected\""; ?>>All stable</option>
+ <option value="%all"<?php if ($what=='%all') echo " selected=\"selected\""; ?>>All</option>
+ </optgroup>
+ <optgroup label="Owner">
<?php
+try {
switch ($type) {
case "pecl": $filter = "WHERE name LIKE 'php-pecl-%' "; break;
case "pear": $filter = "WHERE name LIKE 'php-%' "; break;
case "R": $filter = "WHERE name LIKE 'R-%' "; break;
default: $filter = "";
}
+
+ $db = new PDO ("mysql:dbname=" . MYBASE . ";host=" . MYHOST, MYUSER, MYPASS);
$sql="SELECT DISTINCT owner FROM acls $filter ORDER BY owner";
$res=$db->query($sql);
if ($res)while ($owner = $res->fetchObject()) {
- printf("<option value='%s' %s>%s</option>", $owner->owner, ($what==$owner->owner ? "selected='1'" : ""), $owner->owner);
+ printf("\t\t\t\t\t\t\t\t\t<option value=\"%s\" %s>%s</option>\n", $owner->owner, ($what==$owner->owner ? " selected=\"selected\"" : ""), $owner->owner);
} else {
- echo "<option value='remi'>remi</option>";
+ echo "\t\t\t\t\t\t\t\t\t<option value=\"remi\">remi</option>\n";
}
?>
- </optgroup>
- </select>
- <input type="image" src='http://docs.fedoraproject.org/images/header-search.png' alt="Search" />
- </form></span>
-
- </div>
-
- </div>
-
- <div id="fedora-nav"></div>
- &nbsp;<img src='http://docs.fedoraproject.org/images/link-offsite-side.png' />
- <a href="./">Reports home</a>
- &nbsp;<img src='http://docs.fedoraproject.org/images/link-offsite-side.png' />
- <?php echo "$type extensions"; ?>
- <!-- header END -->
-
- <!-- leftside BEGIN -->
- <div id="fedora-side-left">
- </div>
-
- <!-- leftside END -->
-
- <!-- content BEGIN -->
- <div id="fedora-middle-one">
- <div class="fedora-corner-tr">&nbsp;</div>
- <div class="fedora-corner-tl">&nbsp;</div>
- <div id="fedora-content">
-
- <!-- document BEGIN -->
-
-
-
+ </optgroup>
+ </select><br/>
+ <label for="rpmf">Criteria: </label>
+ <input type="text" name="rpmf" id="rpmf" size="20" />
+ <input type="submit" value="Filter" />
+ </fieldset>
+ </form>
+ </div>
<?php
$sql='SELECT MAX(stamp) AS stamp FROM repo';
@@ -271,40 +203,57 @@ try {
printf("<p>Repositories last updated %s.</p>", date("r", $row->stamp));
}
- Report($db, $type);
- echo "<p>&nbsp</p>";
-
+?>
+ <h1><?php echo strtoupper($type). ' extensions in Fedora'; ?></h1>
+ <table id="list-packages">
+ <thead>
+ <tr>
+ <th>Package</th>
+ <th>Owner(s)</th>
+ <th>Upstream</th>
+<?php
+$repos = listRepos($db);
+$repos_k = array_keys($repos);
+foreach ( $repos_k as $r ) {
+?>
+ <th><?php echo $r; ?></th>
+<?php
}
-catch(PDOException $e) {
+?>
+
+ </tr>
+ </thead>
+ <tbody>
+<?php
+ Report($db, $type, $repos);
+} catch(PDOException $e) {
+?>
+ <tr>
+ <td colspan="<?php echo count($repos_k) + 3; ?>">
+<?php
printf("%s ERREUR : %s\n", date("r"), $e->getMessage());
+?>
+ </td>
+ </tr>
+<?php
}
-
?>
+ </tbody>
+ </table>
+ <ul id="legend">
+ <li>Legend: </li>
+ <li><strong>Upstream</strong>: bold if stable. </li>
+ <li><strong>Repo</strong>: bold for latest release.</li>
+ <li class='check'>Lastest released (stable if exists)</li>
+ <li class='info'>Lastest in testing</li>
+ <li class='attn'>Lastest not available</li>
+ </ul>
+ </div><!-- /fedora-content -->
-<table id='fedora-list-packages'><tr><th>Legend:&nbsp;</th>
-<td><b>Upstream</b>: bold if stable. <b>Repo</b>: bold for latest release.</td>
-<td><div class='check'>Lastest released (stable if exists)</div></td>
-<td><div class='info'>Lastest in testing</div></td>
-<td><div class='attn'>Lastest not available</div></td>
-</tr></table>
-
- <!-- document END -->
- </div>
- <div class="fedora-corner-br">&nbsp;</div>
- <div class="fedora-corner-bl">&nbsp;</div>
- </div>
-
- <!-- content END -->
-
- <!-- footer BEGIN -->
-
- <div id="fedora-footer">
- <br/>The Fedora Project is maintained and driven by the community and sponsored by Red Hat.
- <br/><a href="http://fedoraproject.org/wiki/Legal">Legal</a> | <a href="http://fedoraproject.org/wiki/Legal/TrademarkGuidelines">Trademark Guidelines</a>
- <br>
+<?php
+include '_footer.php';
+?>
</div>
-
- <!-- footer END -->
</body>
</html>