webwml/newmaint/nmstatus.wml

<?
  include("config.inc");
  include("common.inc");

  function find_applicant($email) {
  global $row, $query;
  # start looking at stuff
  if (! ($db = open_db())) {
    return FALSE;
  }
  $sql = "SELECT * from applicant WHERE email='$email'";
  if (! ($query = pg_exec($db, $sql))) {
    echo "Problem with query", pg_ErrorMessage($db), "<BR>";
    return FALSE;
  }
  if ( pg_numRows($query) < 1) {
    echo "Could not find $email in the database.  You can find a full list of applicants <A href=\"nmlist.php\">here</A>.<BR>";
    return FALSE;
  }
  $row = pg_Fetch_Array($query, 0);
  return TRUE;
}
  function print_textarea($title, $name, $value, $editable)
  {
    if ($editable) {
      echo "<B>$title</B><BR><INPUT type=\"textarea\" name=\"$name\" rows=\"5\" cols=\"15\">$value</TEXTAREA>\n";
    } else {
      echo "<B>$title</B><BR>$value<HR><BR>\n";
    }
  }
  function print_boolcheck($title, $bool, $date, $nulltext, $failtext)
  {
    echo "<TR><TD>$title</TD><TD>";
    if ($bool == '') {
      echo "Not Checked</TD></TR>\n";
      return $nulltext;
    }
    if ($bool == 't') {
      echo "Passed on $date</TD></TR>\n";
      return "";
    }
    echo "Failed on $date</TD></TR>\n";
    return $failtext;
  }
?>
#use wml::nmpage title="Debian New Maintainer - Applicant Status"
<?
  $email = trim(strip_tags($email));
  if (find_applicant($email)) {
    $whattodo = "";
?>
<H1>Status Page for applicant: <? echo $row["forename"], " ", $row["surname"], " &lt;", $row["email"], "&gt;"; ?> </H1><BR>

<?
  if (pg_FieldIsNull($query, 0, "advocate_checked")) {
?>
<H3>Advocate application</H3>
<P>If you are an existing Debian developer and would like to advocate this
application, click 
<? echo "<A href=\"nmadvocate.php?email=", urlencode($row["email"]), "\">here</A>";
 } ?>
<BR>
<H3>Applicant Status</H3>
<TABLE width=100%>
<TR><TD>Received application</TD><TD><? echo $row["apply_date"]?></TD></TR>
<TR><TD>Advocate</TD><TD>
<?
  if ($row["advocate"] == "") { 
    echo "None";
    $whattodo .= "<LI>Find an advocate to approve your application.\n";
  } else {
    echo $row["advocate"];
  }
  $whattodo .= print_boolcheck("Advocate Check", $row["advocate_ok"], $row["advocate_checked"],
                 "<LI>Advocate has to verify application.\n",
                 "<LI>Advocate rejected application.\n");
?>
</TD></TR>
<TR><TD>Application Manager Assigned</TD><TD>
<?
  if (pg_FieldIsNull($query, 0, "manager") || pg_FieldIsNull($query, 0, "manager_date")) {
    echo "None Assigned";
    $whattodo .= "<LI>Front desk to assign Application Manager\n";
  } else {
    echo $row["manager"], " assigned on ", $row["manager_date"];
  }
?>
</TD></TR>
<?
  $whattodo .= print_boolcheck("ID Check", $row["id_ok"], $row["id_checked"],
                 "<LI>ID to be checked by AM", 
                 "<LI>ID checked failed, you should ask your AM why.");
  
  $whattodo .= print_boolcheck("Philosophy and Procedures Check", $row["pnp_ok"], $row["pnp_checked"],
                 "<LI>Philosophy and Procedures to be checked by AM.\n",
                 "<LI>Resubmit for Philosophy and Procedures check.\n");
?>
</TD></TR>
<TR><TD>Tasks and Skills Check</TD><TD>
<?
  if (pg_FieldIsNull($query, 0, "tns_ok") || pg_FieldIsNull($query, 0, "tns_checked")) {
    echo "Not Checked";
    $whattodo .= "<LI>Tasks and Skills to be checked by AM.\n";
  } else {
    if ($row["tns_ok"] == 't') {
      echo "Passed on ", $row["tns_checked"];
    } else {
      echo "Failed on ", $row["tns_checked"];
      $whattodo .= "<LI>Resubmit for Tasks and Skills check.\n";
    }
  }
?>
</TD></TR>
<TR><TD>Application Manager recomends to DAM</TD><TD>
<?
  if (pg_FieldIsNull($query, 0, "approved") || pg_FieldIsNull($query, 0, "decision")) {
    echo "--";
    $whattodo .= "<LI>Your Application Manager will put their approval to the DAM.\n";
  } else {
    if ($row["approved"] == 't') {
      echo "Approved on ", $row["decision"];
    } else {
      echo "Not approved on ", $row["decision"];
      $whattodo .= "<LI>You Application Manager has not approved you to the DAM, they should explain why.\n";
    }
  }
?>
</TD></TR>
<TR><TD>DAM Phone Contact</TD><TD>
<?
  if ($row["da_phone_required"] == 't') { 
    if (pg_FieldIsNull($query, 0, "da_phone") ) {
      echo "--";
      $whattodo .= "<LI>The DAM will phone you for final check-in.\n";
    } else {
      echo "Called on ", $row["da_phone"];
    }
  } else {
    echo "Not Required";
  }
?>
</TD></TR>
<TR><TD>DAM Approval</TD><TD>
<?
  if (pg_FieldIsNull($query, 0, "da_approved")) {
    echo "--";
    $whattodo .= "<LI>DAM to approve application\n";
  } else {
    if ($row["da_approved"] == 't') {
      echo "Approved";
    } else {
      echo "Not approved";
      $whattodo .= "<LI>For some reason you were not approved by the DAM, they will be in contact with you about this soon.\n";
    }
  }
?>
<TR><TD>Account Created</TD><TD>
<?
  if (pg_FieldIsNull($query, 0, "newmaint")) {
    echo "No";
    $whattodo .= "<LI>DAM creates new account\n";
  } else {
    echo $row["newmaint"];
  }
?>
</TD></TR>
</TABLE>
<?
  print_textarea("Application Manager Comments", "man_comment", $row["man_comment"], FALSE);
  print_textarea("Debian Account Manager Comments", "da_comment", $row["da_comment"], FALSE);
?>

<P>The following things need to happen still:
<UL>
<? if ($whattodo == "") {
     echo "<LI>nothing!!\n";
   } else {
     echo $whattodo;
   }
?>
</UL>
<? } ?>
1	csmall	1.1	<?
2			include("config.inc");
3			include("common.inc");
4
5			function find_applicant($email) {
6			global $row, $query;
7	tbm	1.4	# start looking at stuff
8	csmall	1.1	if (! ($db = open_db())) {
9			return FALSE;
10			}
11			$sql = "SELECT * from applicant WHERE email='$email'";
12			if (! ($query = pg_exec($db, $sql))) {
13			echo "Problem with query", pg_ErrorMessage($db), "<BR>";
14			return FALSE;
15			}
16			if ( pg_numRows($query) < 1) {
17			echo "Could not find $email in the database. You can find a full list of applicants <A href=\"nmlist.php\">here</A>.<BR>";
18			return FALSE;
19			}
20			$row = pg_Fetch_Array($query, 0);
21			return TRUE;
22			}
23			function print_textarea($title, $name, $value, $editable)
24			{
25			if ($editable) {
26			echo "<B>$title</B><BR><INPUT type=\"textarea\" name=\"$name\" rows=\"5\" cols=\"15\">$value</TEXTAREA>\n";
27			} else {
28			echo "<B>$title</B><BR>$value<HR><BR>\n";
29			}
30			}
31	csmall	1.3	function print_boolcheck($title, $bool, $date, $nulltext, $failtext)
32			{
33			echo "<TR><TD>$title</TD><TD>";
34			if ($bool == '') {
35			echo "Not Checked</TD></TR>\n";
36			return $nulltext;
37			}
38			if ($bool == 't') {
39	tbm	1.5	echo "Passed on $date</TD></TR>\n";
40	csmall	1.3	return "";
41			}
42	tbm	1.5	echo "Failed on $date</TD></TR>\n";
43	csmall	1.3	return $failtext;
44			}
45	csmall	1.1	?>
46			#use wml::nmpage title="Debian New Maintainer - Applicant Status"
47			<?
48			$email = trim(strip_tags($email));
49			if (find_applicant($email)) {
50			$whattodo = "";
51			?>
52			<H1>Status Page for applicant: <? echo $row["forename"], " ", $row["surname"], " <", $row["email"], ">"; ?> </H1><BR>
53	csmall	1.3
54			<?
55			if (pg_FieldIsNull($query, 0, "advocate_checked")) {
56			?>
57			<H3>Advocate application</H3>
58			<P>If you are an existing Debian developer and would like to advocate this
59			application, click
60			<? echo "<A href=\"nmadvocate.php?email=", urlencode($row["email"]), "\">here</A>";
61			} ?>
62			<BR>
63			<H3>Applicant Status</H3>
64	csmall	1.1	<TABLE width=100%>
65			<TR><TD>Received application</TD><TD><? echo $row["apply_date"]?></TD></TR>
66	csmall	1.3	<TR><TD>Advocate</TD><TD>
67			<?
68			if ($row["advocate"] == "") {
69			echo "None";
70			$whattodo .= "<LI>Find an advocate to approve your application.\n";
71			} else {
72			echo $row["advocate"];
73			}
74			$whattodo .= print_boolcheck("Advocate Check", $row["advocate_ok"], $row["advocate_checked"],
75			"<LI>Advocate has to verify application.\n",
76			"<LI>Advocate rejected application.\n");
77			?>
78			</TD></TR>
79	csmall	1.1	<TR><TD>Application Manager Assigned</TD><TD>
80			<?
81			if (pg_FieldIsNull($query, 0, "manager") \|\| pg_FieldIsNull($query, 0, "manager_date")) {
82			echo "None Assigned";
83			$whattodo .= "<LI>Front desk to assign Application Manager\n";
84			} else {
85			echo $row["manager"], " assigned on ", $row["manager_date"];
86			}
87			?>
88			</TD></TR>
89			<?
90	csmall	1.3	$whattodo .= print_boolcheck("ID Check", $row["id_ok"], $row["id_checked"],
91			"<LI>ID to be checked by AM",
92			"<LI>ID checked failed, you should ask your AM why.");
93
94			$whattodo .= print_boolcheck("Philosophy and Procedures Check", $row["pnp_ok"], $row["pnp_checked"],
95			"<LI>Philosophy and Procedures to be checked by AM.\n",
96			"<LI>Resubmit for Philosophy and Procedures check.\n");
97	csmall	1.1	?>
98			</TD></TR>
99			<TR><TD>Tasks and Skills Check</TD><TD>
100			<?
101			if (pg_FieldIsNull($query, 0, "tns_ok") \|\| pg_FieldIsNull($query, 0, "tns_checked")) {
102			echo "Not Checked";
103			$whattodo .= "<LI>Tasks and Skills to be checked by AM.\n";
104			} else {
105			if ($row["tns_ok"] == 't') {
106	tbm	1.5	echo "Passed on ", $row["tns_checked"];
107	csmall	1.1	} else {
108	tbm	1.5	echo "Failed on ", $row["tns_checked"];
109	csmall	1.1	$whattodo .= "<LI>Resubmit for Tasks and Skills check.\n";
110			}
111			}
112			?>
113			</TD></TR>
114			<TR><TD>Application Manager recomends to DAM</TD><TD>
115			<?
116			if (pg_FieldIsNull($query, 0, "approved") \|\| pg_FieldIsNull($query, 0, "decision")) {
117			echo "--";
118			$whattodo .= "<LI>Your Application Manager will put their approval to the DAM.\n";
119			} else {
120			if ($row["approved"] == 't') {
121			echo "Approved on ", $row["decision"];
122			} else {
123			echo "Not approved on ", $row["decision"];
124			$whattodo .= "<LI>You Application Manager has not approved you to the DAM, they should explain why.\n";
125			}
126			}
127			?>
128			</TD></TR>
129			<TR><TD>DAM Phone Contact</TD><TD>
130			<?
131			if ($row["da_phone_required"] == 't') {
132			if (pg_FieldIsNull($query, 0, "da_phone") ) {
133			echo "--";
134			$whattodo .= "<LI>The DAM will phone you for final check-in.\n";
135			} else {
136			echo "Called on ", $row["da_phone"];
137			}
138			} else {
139			echo "Not Required";
140			}
141			?>
142			</TD></TR>
143			<TR><TD>DAM Approval</TD><TD>
144			<?
145			if (pg_FieldIsNull($query, 0, "da_approved")) {
146			echo "--";
147			$whattodo .= "<LI>DAM to approve application\n";
148			} else {
149			if ($row["da_approved"] == 't') {
150			echo "Approved";
151			} else {
152			echo "Not approved";
153			$whattodo .= "<LI>For some reason you were not approved by the DAM, they will be in contact with you about this soon.\n";
154			}
155			}
156			?>
157			<TR><TD>Account Created</TD><TD>
158			<?
159			if (pg_FieldIsNull($query, 0, "newmaint")) {
160			echo "No";
161			$whattodo .= "<LI>DAM creates new account\n";
162			} else {
163			echo $row["newmaint"];
164			}
165			?>
166			</TD></TR>
167			</TABLE>
168			<?
169			print_textarea("Application Manager Comments", "man_comment", $row["man_comment"], FALSE);
170			print_textarea("Debian Account Manager Comments", "da_comment", $row["da_comment"], FALSE);
171			?>
172
173			<P>The following things need to happen still:
174			<UL>
175			<? if ($whattodo == "") {
176			echo "<LI>nothing!!\n";
177			} else {
178			echo $whattodo;
179			}
180			?>
181			</UL>
182			<? } ?>