Merge branch 'master' of http://github.com/trasher/rpmphp

author: Remi Collet <fedora@famillecollet.com> 2010-05-25 06:40:18 +0200
committer: Remi Collet <fedora@famillecollet.com> 2010-05-25 06:40:18 +0200
commit: ba771dc91b13c70509b6da1589e7e9c4a95b3384 (patch)
tree: f5eea1c46aaad29c7d3ea2304d975b0e42dc4f76 /rpm.php
parent: 2ec0f85de586973a65e88194216810c9f2ad335e (diff)
parent: b76086add9ffb0cbd9ddf54955df51db436ed07a (diff)
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>
author	Remi Collet <fedora@famillecollet.com>	2010-05-25 06:40:18 +0200
committer	Remi Collet <fedora@famillecollet.com>	2010-05-25 06:40:18 +0200
commit	ba771dc91b13c70509b6da1589e7e9c4a95b3384 (patch)
tree	f5eea1c46aaad29c7d3ea2304d975b0e42dc4f76 /rpm.php
parent	2ec0f85de586973a65e88194216810c9f2ad335e (diff)
parent	b76086add9ffb0cbd9ddf54955df51db436ed07a (diff)