| 3 |
include("config.inc"); |
include("config.inc"); |
| 4 |
include("common.inc"); |
include("common.inc"); |
| 5 |
|
|
| 6 |
function print_applicants($sql) { |
?> |
|
if (! ($db = open_db())) { |
|
|
return FALSE; |
|
|
} |
|
|
if (! ($query = pg_exec($db, $sql))) { |
|
|
echo "Problem with query", pg_ErrorMessage($db), "<BR>"; |
|
|
pg_Close($db); |
|
|
return FALSE; |
|
|
} |
|
|
$rows = pg_NumRows($query); |
|
|
for ($i = 0 ; $i < $rows ; $i++) { |
|
|
$row = pg_Fetch_Array($query, $i); |
|
|
echo "<TR><TD>", $row["apply_date"], "</TD>"; |
|
|
print_flag($row["advocate_ok"],"<TD><IMG src=\"/images/adv.png\" alt=\"V\"></TD>","<TD> </TD>"); |
|
|
print_flag($row["id_ok"],"<TD><IMG src=\"/images/mag.png\" alt=\"I\"></TD>","<TD> </TD>"); |
|
|
print_flag($row["pnp_ok"],"<TD><IMG src=\"/images/dfsg.png\" alt=\"P\"></TD>","<TD> </TD>"); |
|
|
print_flag($row["tns_ok"],"<TD><IMG src=\"/images/hammer.png\" alt=\"T\"></TD>","<TD> </TD>"); |
|
|
print_flag($row["approved"],"<TD><IMG src=\"/images/thumb.png\" alt=\"A\"></TD>","<TD> </TD>"); |
|
|
print_flag($row["da_approved"],"<TD><IMG src=\"/images/new.png\" alt=\"N\"></TD>","<TD> </TD>"); |
|
|
if ($row["approved"] == "f" || $row["da_approved"] == "f") { |
|
|
echo "<TD><IMG src=\"/images/hold.png\" alt=\"H\"></TD>"; |
|
|
} else { |
|
|
echo "<TD> </TD>"; |
|
|
} |
|
|
echo "<TD><A href=\"amstatus.php?"; ?><?=SID?><?; |
|
|
echo "&user=", urlencode($row["email"]), "\">", |
|
|
$row["forename"], " ", $row["surname"], " <", |
|
|
$row["email"], "></A>", |
|
|
" </TD><TD>", $row["manager"], "</TD></TR>\n"; |
|
|
} |
|
|
# Now for other stuff |
|
|
|
|
|
pg_Close($db); |
|
|
return TRUE; |
|
|
}?> |
|
| 7 |
#use wml::nmpage title="Debian New Maintainer - List of all Applicants" |
#use wml::nmpage title="Debian New Maintainer - List of all Applicants" |
| 8 |
<? |
<? |
|
|
|
| 9 |
if (!session_is_registered("s_username") || !session_is_registered("s_isam")) { |
if (!session_is_registered("s_username") || !session_is_registered("s_isam")) { |
| 10 |
?> |
?> |
| 11 |
<STRONG> |
<STRONG> |
| 23 |
<TABLE border=0> |
<TABLE border=0> |
| 24 |
<TR><TH>Appl Date</TH><TH colspan="6">Flags</TH><TH>Applicant</TH><TH>Manager</TH></TR> |
<TR><TH>Appl Date</TH><TH colspan="6">Flags</TH><TH>Applicant</TH><TH>Manager</TH></TR> |
| 25 |
<? |
<? |
| 26 |
$sql = "SELECT * from applicant WHERE newmaint IS NULL ORDER BY apply_date" ; |
if (($db = open_db())) { |
| 27 |
print_applicants($sql); |
$sql = "SELECT * from applicant WHERE newmaint IS NULL ORDER BY apply_date" ; |
| 28 |
|
print_applicants($db, $sql, 0, 1, 1, 1); |
| 29 |
|
} else { |
| 30 |
|
echo "<p>Cannot open database!</p>\n"; |
| 31 |
|
} |
| 32 |
?> |
?> |
| 33 |
</TABLE> |
</TABLE> |
| 34 |
<H3>Key</H3> |
<H3>Key</H3> |
| 35 |
<UL> |
<UL> |
| 36 |
<LI><IMG src="/images/adv.png" alt="I"> : Advocate Check OK |
<LI><IMG src="/images/shake.png" alt="I"> : Advocate Check OK |
| 37 |
<LI><IMG src="/images/mag.png" alt="I"> : Identification complete |
<LI><IMG src="/images/mag.png" alt="I"> : Identification complete |
| 38 |
<LI><IMG src="/images/dfsg.png" alt="P"> : Philosopy and Procedures complete |
<LI><IMG src="/images/dfsg.png" alt="P"> : Philosophy and Procedures complete |
| 39 |
<LI><IMG src="/images/hammer.png" alt="T"> : Tasks and Skills complete |
<LI><IMG src="/images/hammer.png" alt="T"> : Tasks and Skills complete |
| 40 |
<LI><IMG src="/images/thumb.png" alt="A"> : Application Manager Recommends applicant |
<LI><IMG src="/images/thumb.png" alt="A"> : Application Manager Recommends applicant |
| 41 |
<LI><IMG src="/images/new.png" alt="N"> : New Debian maintainer |
<LI><IMG src="/images/new.png" alt="N"> : New Debian maintainer |