summaryrefslogtreecommitdiffstats
path: root/rpm.php
diff options
context:
space:
mode:
authorRemi Collet <fedora@famillecollet.com>2010-05-30 19:37:05 +0200
committerRemi Collet <fedora@famillecollet.com>2010-05-30 19:37:05 +0200
commit9a9c61c739c976a9fcbe086e03b5305b0e646d5c (patch)
tree33716a03fd9e88e5b1d2de9bde7efc8603e02d1e /rpm.php
parentb613aa3f99a51e08b16b4402de2b684d3f266b66 (diff)
parent4fe73c547050003599021850f0c6099f7c224f07 (diff)
merge
Diffstat (limited to 'rpm.php')
-rw-r--r--rpm.php463
1 files changed, 234 insertions, 229 deletions
diff --git a/rpm.php b/rpm.php
index edad029..5073f9f 100644
--- a/rpm.php
+++ b/rpm.php
@@ -1,256 +1,261 @@
<?php
+
+/* vim: set expandtab tabstop=4 shiftwidth=4 softtabstop=4: */
+
+/**
+ * RPMs listing
+ *
+ * PHP version 5
+ *
+ * Copyright © 2010 Remi Collet
+ *
+ * This file is part of rpmphp.
+ *
+ * rpmphp is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Affero General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * rpmphp is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU Affero General Public License for more details.
+ *
+ * You should have received a copy of the GNU Affero General Public License
+ * along with rpmphp. If not, see <http://www.gnu.org/licenses/>.
+ *
+ * @category Main
+ * @package RPMPHP
+ *
+ * @author Remi Collet <unknown@unknwown.com>
+ * @author Johan Cwiklinski <johan@x-tnd.be>
+ * @copyright 2010 Remi Collet
+ * @license http://www.gnu.org/licenses/agpl-3.0-standalone.html AGPL License 3.0 or (at your option) any later version
+ * @link http://github.com/remicollet/rpmphp/
+ * @since The begining of times.
+*/
+require 'main.inc.php';
+
$what=(isset($_GET["what"]) ? $_GET["what"] : "%fedora");
$type=(isset($_GET["type"]) ? $_GET["type"] : "pecl");
-require "config.inc.php";
+$ariane[] = array(
+ 'url' => '#',
+ 'text' => strtoupper($type). ' extensions in Fedora'
+);
+$smarty->assign('ariane', $ariane);
-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>";
- foreach($repos as $repomain) {
- foreach ($repomain as $repo) {
- /*printf ("<th align='left'>%s</th>", $repo->main);*/
- $repos[$repo->main][$repo->sub] = $repo;
- break;
- }
- }
- return $repos;
-}
+$smarty->assign('type', $type);
+$smarty->assign('what', $what);
+$smarty->assign('page_title', strtoupper($type). ' extensions in Fedora');
-function Report ($db, $type, $repos) {
- global $what;
+/**
+* Retrieve packages informations
+*
+* @param Object $db A reference to the database
+* @param string $type The current type
+*
+* @return array
+*/
+function report($db, $type)
+{
+ global $what, $smarty;
+ $packages = null;
+ $repos = listRepos($db);
+ $smarty->assign('repos', $repos);
- $i=0;
- $resup=$db->query("SELECT * FROM upstream WHERE type='$type' ORDER BY name");
- if ($resup) while ($upstream = $resup->fetchObject()) {
- $rpmname = $upstream->name;
+ $i=0;
+ $resup=$db->query("SELECT * FROM upstream WHERE type='$type' ORDER BY name");
+ if ($resup) {
+ while ($upstream = $resup->fetchObject()) {
+ $package = null;
+ $rpmname = $upstream->name;
- $sql2="SELECT DISTINCT owner FROM acls WHERE name = '$rpmname'";
- $res2=$db->query($sql2);
- $owners=array();
- if ($res2) while ($owner= $res2->fetchObject()) $owners[] = $owner->owner;
+ $sql2="SELECT DISTINCT owner FROM acls WHERE name = '$rpmname'";
+ $res2=$db->query($sql2);
+ $owners=array();
+ if ( $res2 ) {
+ while ($owner= $res2->fetchObject()) {
+ $owners[] = $owner->owner;
+ }
+ }
- $sql = "SELECT * FROM rpm WHERE name = '$rpmname'";
+ $sql = "SELECT * FROM rpm WHERE name = '$rpmname'";
- $res=$db->query($sql);
- $rpm = ($res ? $res->fetchObject() : false);
+ $res=$db->query($sql);
+ $rpm = ($res ? $res->fetchObject() : false);
- switch ($what) {
- case '%fedora':
- $display = ($rpm !== false);
- break;
- case '%stable':
- $display = !empty($upstream->stable);
- break;
- case '%all':
- $display = true;
- break;
- default: // owner
- $display = (array_search($what, $owners) !== false);
- break;
- }
+ switch ($what) {
+ case '%fedora':
+ $display = ($rpm !== false);
+ break;
+ case '%stable':
+ $display = !empty($upstream->stable);
+ break;
+ case '%all':
+ $display = true;
+ break;
+ default: // owner
+ $display = (array_search($what, $owners) !== false);
+ break;
+ }
- if ($display) {
- if ($rpm) {
- $dispname = "<a href=\"zoom.php?rpm=" . $rpmname . "\" title=\"" . htmlentities($rpm->summary) . "\">$rpmname</a>";
- } else {
- $dispname = $rpmname;
- }
- $rpms=array();
- if ($rpm) do {
- $rpms[$rpm->repo_main."-".$rpm->repo_sub]=$rpm;
- } while ($rpm = $res->fetchObject());
+ if ($display) {
+ if ($rpm) {
+ $package['name'] = '<a href="zoom.php?rpm=' . $rpmname .
+ '" title="' . htmlentities($rpm->summary) . '">' .
+ $rpmname . '</a>';
+ } else {
+ $package['name'] = $rpmname;
+ }
+ if ( $upstream->channel != $upstream->type ) {
+ $package['channel'] = $upstream->channel;
+ }
+ $rpms=array();
+ if ( $rpm ) {
+ do {
+ $rpms[$rpm->repo_main."-".$rpm->repo_sub]=$rpm;
+ } while ($rpm = $res->fetchObject());
+ }
- $dispowner="";
- foreach ($owners as $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\">\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 ? "<strong>".$upstream->stable."</strong><br />" : "&nbsp;"),
- ($upstream->unstable && (!$upstream->stable || $upstream->stable!=$upstream->unstable) ? $upstream->unstable." <small>(".$upstream->state.")</small>" : "&nbsp;"));
+ $dispowner="";
+ $package['owners'] = $owners;
+ if ( $upstream->stable ) {
+ $package['upstream_stable'] = $upstream->stable;
+ }
+ if ( $upstream->unstable
+ && (!$upstream->stable
+ || $upstream->stable!=$upstream->unstable)
+ ) {
+ $package['upstream_unstable'] = $upstream->unstable .
+ ' <small>(' . $upstream->state . ')</small>';
+ }
- $verup = strtolower($upstream->stable ? $upstream->stable : $upstream->unstable);
+ $verup = strtolower($upstream->stable ? $upstream->stable : $upstream->unstable);
- foreach($repos as $repomain) {
- $display="";
- $class="";
- foreach ($repomain as $repo) {
- if (isset($rpms[$repo->main."-".$repo->sub])) {
- $rpm=$rpms[$repo->main."-".$repo->sub];
+ $versions = null;
+ foreach ( $repos as $repomain ) {
+ $display="";
+ $class="";
+ foreach ( $repomain as $k=>$repo ) {
+ 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]);
- }
+ $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);
- } else {
- $display .= sprintf("<strong>%s</strong>-%s<br/>", $rpm->ver, $rpm->rel);
- }
- if ($verup==$verpm) $class="check";
- break;
- case "":
- $display .= sprintf("<strong>%s</strong>-%s<br/>", $rpm->ver, $rpm->rel);
- if ($verup==$verpm) $class="check";
- break;
- case "updates":
- $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);
- if ($verup==$verpm) $class="info";
- break;
- }
- } // RPM exists
- } // sub repo
- if ($display && empty($class)) $class="attn";
- if ($display) {
- printf("\t<td class=\"%s\">%s</td>\n", $class, $display);
- } else {
- echo "\t<td>&nbsp;</td>\n";
- }
- } // mainrepo
+ switch ($repo->sub) {
+ case "base":
+ if ( isset($rpms[$repo->main."-updates"]) ) {
+ $display .= sprintf(
+ "%s-%s<br/>",
+ $rpm->ver,
+ $rpm->rel
+ );
+ } else {
+ $display .= sprintf(
+ "<strong>%s</strong>-%s<br/>",
+ $rpm->ver,
+ $rpm->rel
+ );
+ }
+ if ( $verup==$verpm ) {
+ $class="check";
+ }
+ break;
+ case "":
+ $display .= sprintf(
+ "<strong>%s</strong>-%s<br/>",
+ $rpm->ver,
+ $rpm->rel
+ );
+ if ( $verup==$verpm ) {
+ $class="check";
+ }
+ break;
+ case "updates":
+ $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
+ );
+ if ( $verup==$verpm ) {
+ $class="info";
+ }
+ break;
+ }
+ } // RPM exists
+ } // sub repo
+ if ( $display && empty($class) ) {
+ $class="attn";
+ }
+ $versions[] = array(
+ 'class' => $class,
+ 'display' => $display
+ );
+ $package['versions'] = $versions;
+ } // mainrepo
- echo "</tr>\n";
- $i++;
- }
- } // each $unstable
- echo "<tr id=\"count_found\"><td colspan=\"" . (count(array_keys($repos)) + 3) . "\">$i packages found</td></tr>\n";
+ $i++;
+ $packages[] = $package;
+ }
+ } // each $unstable
+ }
+ return $packages;
}
-?>
-<!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>
- <div id="wrapper">
-<?php
-include '_header.php';
-?>
- <!-- 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">Criteria: </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 = "";
- }
+ 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("\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 "\t\t\t\t\t\t\t\t\t<option value=\"remi\">remi</option>\n";
- }
-?>
- </optgroup>
- </select>
- <input type="submit" value="Filter" />
- </fieldset>
- </form>
- </div>
-<?php
+ $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() ) {
+ $owners[] = $owner;
+ }
+ $smarty->assign('owners', $owners);
+ }
- $sql='SELECT MAX(stamp) AS stamp FROM repo';
- $res=$db->query($sql);
- if ($res && $row=$res->fetchObject()) {
- printf("<p>Repositories last updated %s.</p>", date("r", $row->stamp));
- }
+ $sql='SELECT MAX(stamp) AS stamp FROM repo';
+ $res=$db->query($sql);
+ if ($res && $row=$res->fetchObject()) {
+ $smarty->assign('repositories_update', date("r", $row->stamp));
+ }
-?>
- <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
-}
-?>
- </tr>
- </thead>
- <tbody>
-<?php
- Report($db, $type, $repos);
+ $smarty->assign('packages', report($db, $type));
} 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
+ $smarty->assign(
+ 'error',
+ sprintf("%s ERREUR : %s\n", date("r"), $e->getMessage())
+ );
}
-?>
- </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 -->
-
-<?php
-include '_footer.php';
-?>
- </div>
- </body>
-</html>
+$page_content = $smarty->fetch('rpm.tpl');
+$smarty->assign('page_content', $page_content);
+$smarty->display('main.tpl');
+?> \ No newline at end of file