//print the header row...
echo "<tr><td bgcolor=\"#E0E2F2\"> </td><td bgcolor=\"#E0E2F2\">Name</td><td align=\"center\" bgcolor=\"#E0E2F2\">Status</td><td align=\"center\" bgcolor=\"#E0E2F2\">Description (click to edit)</td><td align=\"center\" bgcolor=\"#E0E2F2\">Status</td></tr>\n";
while ($bug_info_row = mysql_fetch_array($bug_result)) {
//current...
if ($bug_info_row['status'] == "Active") {
$bgcolor = "#FFCCCC";
}
if ($bug_info_row['status'] == "On hold") {
$bgcolor = "#FFFFCC";
}
if ($bug_info_row['status'] == "Resolved") {
$bgcolor = "#99FFCC";
}
echo "<tr>\n";
echo "<td bgcolor=\"#E0E2F2\"><input type=\"checkbox\" name=\"" . $bug_info_row['uid'] . "\"></td>";
echo "<td bgcolor=\"{$bgcolor}\" class=\"row_default\">" . username_to_common($bug_info_row['username']) . "</td>";
echo "<td bgcolor=\"{$bgcolor}\" class=\"row_default\">";
if ($_SESSION['egps_username'] == $bug_info_row['username'] && $bug_info_row['status'] != "Resolved" || $permission_level <= $IPP_MIN_EDIT_BUG_PERMISSION) {
echo "<a href=\"" . IPP_PATH . "edit_bug.php?uid=" . $bug_info_row['uid'] . "\" class=\"editable_text\">";
}
echo $bug_info_row['status'];
if ($_SESSION['egps_username'] == $bug_info_row['username'] && $bug_info_row['status'] != "Resolved" || $permission_level <= $IPP_MIN_EDIT_BUG_PERMISSION) {
echo "</a>";
}
echo "</td>\n";
echo "<td bgcolor=\"{$bgcolor}\" class=\"row_default\">";
if ($_SESSION['egps_username'] == $bug_info_row['username'] && $bug_info_row['status'] != "Resolved" || $permission_level <= $IPP_MIN_EDIT_BUG_PERMISSION) {
echo "<a href=\"" . IPP_PATH . "edit_bug.php?uid=" . $bug_info_row['uid'] . "\" class=\"editable_text\">";
}
echo $bug_info_row['bug'];
if ($_SESSION['egps_username'] == $bug_info_row['username'] && $bug_info_row['status'] != "Resolved" || $permission_level <= $IPP_MIN_EDIT_BUG_PERMISSION) {
$this->SetTextColor(153, 153, 153);
//greyish
$this->SetFillColor(255, 255, 255);
$this->Ln(1);
$this->MultiCell(0, 5, "MYIEP System Copyright 2014 Chelsea School | �2005-2007 Grasslands Public Schools | licensed under the Gnu Public License", 'T', 'C', 1);
//Set colour back
$this->SetTextColor(0, 0, 0);
// Well, I'm back in black, yes I'm back in black!
}
}
//Instanciation of inherited class
$pdf = new IPP();
$pdf->AliasNbPages();
$pdf->AddPage();
//set the pdf information
$pdf->SetAuthor(username_to_common($_SESSION['egps_username']));
$pdf->SetCreator('MyIEP Special Education Program Management');
$pdf->SetTitle('Individual Program Plan - ' . $student_row['first_name'] . ' ' . $student_row['last_name']);
//begin pdf...
$pdf->SetFont('Times', '', 20);
$pdf->SetTextColor(220, 50, 50);
//set the colour a loverly redish
$pdf->Cell(30);
$pdf->Cell(130, 5, ' Program Plan ', 0, 0, 'C');
//$pdf->Image(IPP_PATH . 'images/bounding_box.png',$pdf->GetX()-1,$pdf->GetY()-4);
$mark = $pdf->GetY();
/* if(isset($code) && is_numeric($code)) {
$pdf->SetFont('Times','B',50);
if($code > 99) $pdf->SetFont('Times','B',30);
if($code >999) $pdf->SetFont('Times','B',25);
if($code >9999) $pdf->SetFont('Times','B',20);
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
//we need to notify the school based ipp administrator
$ipp_admin_query = "SELECT * FROM support_member WHERE school_code=" . mysql_real_escape_string($_POST['school_code']) . " and is_local_ipp_administrator='Y'";
$ipp_admin_result = mysql_query($ipp_admin_query);
if (!$ipp_admin_result) {
$error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$ipp_admin_query}'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
if (mysql_num_rows($ipp_admin_result) <= 0) {
$system_message = $system_message . "There doesn't appear to be a school based IPP administrator for this school. The student has been moved but there was nobody at the receiving school notified (You might want to phone and let them know).<BR>";
} else {
while ($ipp_admin_row = mysql_fetch_array($ipp_admin_result)) {
mail_notification($ipp_admin_row['egps_username'], "This email has been sent to you to notify you that " . $student_row['first_name'] . " " . $student_row['last_name'] . "'s IPP has been moved to your school by " . username_to_common($_SESSION['egps_username']) . ". Please contact them for more information.\n\nYou should update the supervisor information and add the appropriate support members for your school to this students IPP (and remove anybody who should no longer be a support member).");
$system_message = $system_message . $ipp_admin_row['egps_username'] . " ";
}
$system_message .= " received an emailed notification that this student's IPP was forwarded to their school<BR>";
}
}
//take a snapshot...
$pdf = create_pdf($student_id);
//we add the entry.
$insert_query = "INSERT INTO snapshot(student_id,date,file,filename) VALUES (" . mysql_real_escape_string($student_id) . ",NOW(),'" . mysql_real_escape_string($pdf->Output("ignored", 'S')) . "','IPP-" . $student_row['first_name'] . " " . $student_row['last_name'] . " " . date("F-d-Y") . ".pdf')";
$insert_result = mysql_query($insert_query);
if (!$insert_result) {
$error_message = "Snapshot not taken because the database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '" . substr($insert_query, 0, 100) . "[truncated]'<BR>";
$system_message = $system_message . $error_message;
IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
} else {
