PHP IPP_LOG函数代码示例

function getSupportMembers()
{
    global $error_message, $iLimit, $iCur, $student_id;
    if (!connectIPPDB()) {
        $system_message = $system_message . $error_message;
        //just to remember we need this
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    }
    // LEFT JOIN area_list ON support_list.uid=area_list.support_list_uid LEFT JOIN area_type ON area_list.area_type_id=area_type.area_type_id
    // original $query = "SELECT * FROM support_list where student_id=" . $student_id . " ORDER BY egps_username ASC LIMIT $iCur,$iLimit";
    $query = "SELECT * FROM support_list where student_id=" . $student_id . " ORDER BY egps_username ASC";
    $result = mysql_query($query);
    if (!$result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$query}'<BR>";
        return NULL;
    }
    return $result;
}

function echoJSServicesArray()
{
    global $system_message;
    $acclist_query = "SELECT accomodation FROM typical_accomodation WHERE 1 ORDER BY `order` DESC, accomodation ASC LIMIT 400";
    $acclist_result = mysql_query($acclist_query);
    if (!$acclist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$acclist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        if (mysql_num_rows($acclist_result)) {
            echo createJavaScript($acclist_result, "popuplist");
        }
    }
}

function getLogTotals()
{
    global $error_message, $iLimit, $iCur, $szLevel;
    if (!connectIPPDB()) {
        $error_message = $error_message;
        //just to remember we need this
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    }
    if ($szLevel == "ALL") {
        $log_query = "SELECT * FROM error_log WHERE 1=1";
    } else {
        $log_query = "SELECT * FROM error_log WHERE level='{$szLevel}'";
    }
    $log_result = mysql_query($log_query);
    if (!$log_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$log_query}'<BR>";
        return NULL;
    }
    return mysql_num_rows($log_result);
}

function runQuery()
{
    global $target_result;
    if (isset($_GET['target'])) {
        $target_query = "";
        switch ($_GET['target']) {
            case "guardian":
                if (!isset($_GET['guardian_id'])) {
                    $system_message = $system_message . "You have arrived at this page without supplying a valid guardian_id (" . __FILE__ . ":" . __LINE__ . ")<BR>";
                    IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
                } else {
                    $target_query = "SELECT guardian.*,guardian.first_name as guardian_first_name,guardian.last_name as guardian_last_name,guardians.*,student.first_name,student.last_name,address.* FROM guardian LEFT JOIN guardians ON guardian.guardian_id=guardians.guardian_id LEFT JOIN student ON guardians.student_id=student.student_id LEFT JOIN address ON guardian.address_id=address.address_id WHERE guardian.guardian_id=" . $_GET['guardian_id'];
                }
                break;
        }
        $target_result = mysql_query($target_query);
        if (!$target_result) {
            $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$target_query}'<BR>";
            $system_message = $system_message . $error_message;
            IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        }
    }
}

function echoJSServicesArray()
{
    global $system_message, $student_id;
    //get a list of all available goal categories...
    $catlist_query = "SELECT name FROM typical_long_term_goal_category WHERE is_deleted='N' ORDER BY name ASC";
    $catlist_result = mysql_query($catlist_query);
    if (!$catlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        return;
    } else {
        //call the function to create the javascript array...
        echo createJavaScript($catlist_result, "popuplist");
    }
}

function parse_submission()
{
    if (!$_POST['first_name']) {
        return "You must supply a first name<BR>";
    }
    if (!$_POST['last_name']) {
        return "You must supply a last name<BR>";
    }
    //check that date is the correct pattern...
    $regexp = '/^\\d\\d\\d\\d-\\d\\d?-\\d\\d?$/';
    if (!preg_match($regexp, $_POST['birthday'])) {
        return "Birthday must be in YYYY-MM-DD format<BR>";
    }
    if (!preg_match($regexp, $_POST['at_school_since'])) {
        return "At School Since must be in YYYY-MM-DD format<BR>";
    }
    //if(!$_POST['prov_ed_num']) return "You must supply a Provincial Education Number<BR>";
    //if(!$_POST['ab_ed_code']) return "You must supply an Alberta Education Coding Value<BR>";
    //check duplicate prov ed number...
    if (!connectIPPDB()) {
        $error_message = $error_message;
        //just to remember we need this
        $system_message = $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    }
    if ($_POST['prov_ed_num'] != "") {
        $duplicate_query = "SELECT * FROM student WHERE prov_ed_num='" . mysql_real_escape_string($_POST['prov_ed_num']) . "'";
        $duplicate_result = mysql_query($duplicate_query);
        if (mysql_num_rows($duplicate_result) > 0) {
            $duplicate_row = mysql_fetch_array($duplicate_result);
            return "Duplicate Provincial Education Number (name:" . $duplicate_row['first_name'] . " " . $duplicate_row['last_name'] . "),<BR>This student probably already exists in the database<BR>";
        }
    }
    //$duplicate_query = "SELECT * FROM student WHERE ab_ed_code='" . mysql_real_escape_string($_POST['ab_ed_code']) ."'";
    //$duplicate_result= mysql_query($duplicate_query);
    //if(mysql_num_rows($duplicate_result) > 0) {$duplicate_row = mysql_fetch_array($duplicate_result);return "Duplicate Alberta Education Code Number (name:" . $duplicate_row['first_name'] . " " . $duplicate_row['last_name'] ."),<BR>This student probably already exists in the database<BR>"; }
    return NULL;
}

function echoJSServicesArray()
{
    global $system_message;
    $acclist_query = "SELECT DISTINCT egps_username FROM support_list WHERE 1 ORDER BY egps_username ASC";
    $acclist_result = mysql_query($acclist_query);
    if (!$acclist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$acclist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        echo createJavaScript($acclist_result, "popuplist");
    }
}

/** @fn 	getStudents()
 *  @brief	Gets a count of students from the database that go to a member
 *  @return NULL|resource
 *  @todo	get_student_count()
 */
function getStudents()
{
    global $error_message, $IPP_MIN_VIEW_LIST_ALL_LOCAL_STUDENTS, $permission_level, $system_message, $IPP_MIN_VIEW_LIST_ALL_STUDENTS, $iLimit, $iCur, $szSchool, $szTotalStudents;
    if (!connectIPPDB()) {
        $system_message = $system_message . $error_message;
        //just to remember we need this
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    }
    //do a subquery to find our school code...easier than messing with the ugly
    //query below...
    $school_code_query = "SELECT school_code FROM support_member WHERE egps_username='" . mysql_real_escape_string($_SESSION['egps_username']) . "'";
    $school_code_result = mysql_query($school_code_query);
    if (!$school_code_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$school_code_query}'<BR>";
        return NULL;
    }
    $school_code_row = mysql_fetch_array($school_code_result);
    $school_code = $school_code_row['school_code'];
    //$student_query = "SELECT student.student_id,last_name,first_name,school_history.school_code,school.* FROM student LEFT JOIN school_history ON student.student_id=school_history.student_id LEFT JOIN school ON school_history.school_code=school.school_code WHERE end_date IS NULL ";
    $student_query = "SELECT DISTINCT student.student_id,last_name,first_name,school_history.school_code,school.* FROM student LEFT JOIN support_list ON student.student_id = support_list.student_id LEFT JOIN school_history ON student.student_id=school_history.student_id LEFT JOIN school ON school_history.school_code=school.school_code WHERE ((support_list.egps_username='" . mysql_real_escape_string($_SESSION['egps_username']) . "' AND school_history.end_date IS NULL AND support_list.student_id IS NOT NULL) OR (";
    //prior to march 18/06: $student_query = "SELECT DISTINCT student.student_id,last_name,first_name,school_history.school_code,school.* FROM student LEFT JOIN support_list ON student.student_id = support_list.student_id LEFT JOIN school_history ON student.student_id=school_history.student_id LEFT JOIN school ON school_history.school_code=school.school_code WHERE (support_list.egps_username='" . mysql_real_escape_string($_SESSION['egps_username']) . "' AND support_list.student_id IS NOT NULL) OR (";
    if (!($IPP_MIN_VIEW_LIST_ALL_STUDENTS >= $permission_level)) {
        //$IPP_MIN_VIEW_LIST_ALL_LOCAL_STUDENTS >= $permission_level) {
        $student_query = $student_query . "school_history.school_code='{$school_code}' AND ";
        //prior to 2006-03-21: $student_query = $student_query . "school_history.school_code='$school_code' AND ";
        if ($IPP_MIN_VIEW_LIST_ALL_LOCAL_STUDENTS < $permission_level) {
            //$system_message .= "debug: permission level: $IPP_MIN_VIEW_LIST_ALL_LOCAL_STUDENTS < $permission_level<BR><BR>";
            $student_query .= "support_list.egps_username='" . mysql_real_escape_string($_SESSION['egps_username']) . "' AND ";
        }
        $student_query .= "end_date IS NULL) ";
    } else {
        $student_query = $student_query . "end_date IS NULL) ";
    }
    if (isset($_GET['SEARCH'])) {
        switch ($_GET['field']) {
            case 'last_name':
                $student_query = $student_query . "AND student.last_name LIKE '" . mysql_real_escape_string($_GET['szSearchVal']) . "' ";
                break;
            case 'first_name':
                $student_query = $student_query . "AND student.first_name LIKE '" . mysql_real_escape_string($_GET['szSearchVal']) . "' ";
                break;
            case 'last_name':
                $student_query = $student_query . "AND student.last_name LIKE '" . mysql_real_escape_string($_GET['szSearchVal']) . "' ";
                break;
            case 'school_name':
                $student_query = $student_query . "AND school.school_name LIKE '" . mysql_real_escape_string($_GET['szSearchVal']) . "' ";
                break;
            case 'school_code':
                $student_query = $student_query . "AND school_history.school_code LIKE '" . mysql_real_escape_string($_GET['szSearchVal']) . "' ";
        }
    }
    //added 2006-04-20: to prevent null school histories from showing up as active.
    $student_query .= ") AND EXISTS (SELECT school_history.student_id FROM school_history WHERE school_history.student_id=student.student_ID) ";
    //end added 2006-04-20
    $student_query_limit = $student_query . "ORDER BY school_history.school_code,student.last_name ASC LIMIT {$iCur},{$iLimit}";
    $student_result_limit = mysql_query($student_query_limit);
    if (!$student_result_limit) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$student_query_limit}'<BR>";
        return NULL;
    }
    //$system_message = $system_message . "debug: " . $student_query_limit . "<BR>";
    //find the totals...
    $student_result_total = mysql_query($student_query);
    if (!$student_result_total) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$student_query}'<BR>";
        return NULL;
    }
    $szTotalStudents = mysql_num_rows($student_result_total);
    return $student_result_limit;
}

function echoJSServicesArray()
{
    global $system_message;
    //get a list of all available goal categories...
    $catlist_query = "SELECT * FROM typical_long_term_goal_category where is_deleted='N'";
    $catlist_result = mysql_query($catlist_query);
    if (!$catlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$catlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        return;
    }
    while ($catlist = mysql_fetch_array($catlist_result)) {
        $objlist_query = "SELECT typical_long_term_goal.goal FROM typical_long_term_goal WHERE cid=" . $catlist['cid'] . " AND typical_long_term_goal.is_deleted='N'";
        $objlist_result = mysql_query($objlist_query);
        if (!$objlist_result) {
            $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$objlist_query}'<BR>";
            $system_message = $system_message . $error_message;
            IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        } else {
            //call the function to create the javascript array...
            echo createJavaScript($objlist_result, $catlist['name']);
        }
    }
}

function create_pdf($student_id)
{
    global $system_message, $student_row;
    $student_query = "SELECT * FROM student WHERE student_id = " . mysql_real_escape_string($student_id);
    $student_result = mysql_query($student_query);
    if (!$student_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$student_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        $student_row = mysql_fetch_array($student_result);
    }
    //get the goals...
    $long_goal_query = "SELECT * FROM long_term_goal WHERE student_id={$student_id}  ORDER BY area ASC, is_complete DESC, goal ASC";
    $long_goal_result = mysql_query($long_goal_query);
    if (!$long_goal_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$long_goal_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        echo $system_message;
        exit;
    }
    //get the supervisor...
    $supervisor_row = "";
    $supervisor_query = "SELECT * FROM supervisor WHERE student_id={$student_id}";
    $supervisor_result = mysql_query($supervisor_query);
    if (!$supervisor_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$supervisor_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        //echo $system_message;
        //exit();
        //just carry on
    } else {
        $supervisor_row = mysql_fetch_array($supervisor_result);
    }
    //get the school code...
    $school_row = "";
    $school_query = "SELECT * FROM school_history LEFT JOIN school on school_history.school_code=school.school_code WHERE student_id=" . $student_id . " AND end_date IS NULL";
    $school_result = mysql_query($school_query);
    if (!$school_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$school_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        $school_row = mysql_fetch_array($school_result);
    }
    //get the school code...
    $school_history_row = "";
    $school_history_query = "SELECT * FROM school_history WHERE student_id=" . $student_id . " AND end_date IS NOT NULL ORDER BY end_date DESC";
    $school_history_result = mysql_query($school_history_query);
    if (!$school_history_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$school_history_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        //just carry on
    }
    //get the coding and history...
    $code = "";
    $code_text = "(?)";
    $ipp_history = "Unknown";
    $code_query = "SELECT * FROM coding LEFT JOIN valid_coding ON coding.code=valid_coding.code_number WHERE student_id=" . $student_id . " ORDER BY end_date ASC";
    $code_result = mysql_query($code_query);
    if (!$code_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$code_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        //just carry on
    } else {
        if (mysql_num_rows($code_result)) {
            $code_row = mysql_fetch_array($code_result);
            $code = $code_row['code'];
            $code_text = " (" . $code_row['code_text'] . ")";
            $ipp_history = "Code " . $code_row['code'] . " from " . $code_row['start_date'] . " to ";
            if ($code_row['end_date'] == "") {
                $ipp_history .= "present";
            } else {
                $ipp_history .= $code_row['end_date'];
            }
            while ($code_row = mysql_fetch_array($code_result)) {
                $ipp_history .= "\nCode " . $code_row['code'] . " from " . $code_row['start_date'] . " to ";
                if ($code_row['end_date'] == "") {
                    $ipp_history .= "present";
                } else {
                    $ipp_history .= $code_row['end_date'];
                }
            }
        }
    }
    //get the guardian information...
    $guardian_query = "SELECT * FROM guardians LEFT JOIN guardian ON guardians.guardian_id=guardian.guardian_id LEFT JOIN address ON guardian.address_id=address.address_id WHERE guardians.to_date IS NULL AND student_id=" . $student_id . " ORDER BY last_name ASC, first_name ASC";
    $guardian_result = mysql_query($guardian_query);
    if (!$guardian_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$guardian_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        //just carry on
    }
    $supervisors = "none listed";
    $supervisor_query = "SELECT * FROM supervisor LEFT JOIN support_member ON supervisor.egps_username=support_member.egps_username WHERE student_id=" . $student_id . " AND end_date IS NULL";
//.........这里部分代码省略.........

        $system_message = $system_message . $error_message;
        if (isset($_SESSION['egps_username'])) {
            IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        } else {
            IPP_LOG($system_message, 'no session', 'ERROR');
        }
        require IPP_PATH . 'index.php';
        exit;
    }
} else {
    if (!validate()) {
        $system_message = $system_message . $error_message;
        if (isset($_SESSION['egps_username'])) {
            IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        } else {
            IPP_LOG($system_message, "no session", 'ERROR');
        }
        require IPP_PATH . 'index.php';
        exit;
    }
}
?>




<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">

function getUsers()
{
    global $error_message, $iLimit, $iCur, $bShowNav, $system_message;
    if (!connectIPPDB()) {
        $system_message = $system_message . $error_message;
        //just to remember we need this
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    }
    if (!isset($_GET['username'])) {
        if (isset($_GET['showall'])) {
            $query = "SELECT * FROM support_member LEFT JOIN school ON support_member.school_code=school.school_code where 1=1 ORDER BY egps_username ASC";
        } else {
            $query = "SELECT * FROM support_member LEFT JOIN school ON support_member.school_code=school.school_code where 1=1 ORDER BY egps_username ASC LIMIT {$iCur},{$iLimit}";
            $bShowNav = TRUE;
        }
    } else {
        $query = "SELECT * FROM support_member LEFT JOIN school ON support_member.school_code=school.school_code WHERE egps_username LIKE '" . $_GET['username'] . "' ORDER BY egps_username ASC";
    }
    if (isset($_GET['index'])) {
        $query = "SELECT * FROM support_member LEFT JOIN school on support_member.school_code=school.school_code WHERE ASCII(LOWER(egps_username)) >= ASCII('" . mysql_real_escape_string($_GET['index']) . "') ORDER BY egps_username ASC LIMIT {$iLimit}";
        //do some moronic thing to find our index- were I not so lazy I'd find a more elegant method.
        $get_index_query = "SELECT * FROM support_member LEFT JOIN school on support_member.school_code=school.school_code WHERE ASCII(LOWER(egps_username)) < ASCII('" . mysql_real_escape_string($_GET['index']) . "')";
        $get_index_result = mysql_query($get_index_query);
        if ($get_index_result) {
            $iCur = mysql_num_rows($get_index_result);
        } else {
            $system_message .= "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$get_index_query}'<BR>";
        }
    }
    $result = mysql_query($query);
    if (!$result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$query}'<BR>";
        return NULL;
    }
    return $result;
}

function create_anecdotals($student_id)
{
    global $system_message, $student_row;
    $student_query = "SELECT * FROM student WHERE student_id = " . mysql_real_escape_string($student_id);
    $student_result = mysql_query($student_query);
    if (!$student_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$student_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        $student_row = mysql_fetch_array($student_result);
    }
    //get the goals...
    $anecdotal_query = "SELECT * FROM anecdotal WHERE student_id={$student_id}  ORDER BY date ASC";
    $anecdotal_result = mysql_query($anecdotal_query);
    if (!$anecdotal_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$anecdotal_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        //todo investigate and expand logging; implement email alerts on certain log key words
        echo $system_message;
        exit;
    }
    //get the coding and history...
    $code = "";
    $code_text = "";
    $ipp_history = "Unknown";
    $code_query = "SELECT * FROM coding LEFT JOIN valid_coding ON coding.code=valid_coding.code_number WHERE student_id=" . $student_id . " ORDER BY end_date ASC";
    $code_result = mysql_query($code_query);
    if (!$code_result) {
        $error_message = $error_message . "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$code_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
        //just carry on
    } else {
        if (mysql_num_rows($code_result)) {
            $code_row = mysql_fetch_array($code_result);
            $code = $code_row['code'];
            $code_text = " (" . $code_row['code_text'] . ")";
        }
    }
    //lets get some PDF making done...
    class IPP extends FPDF
    {
        //Page header
        function Header()
        {
            global $IPP_ORGANIZATION, $student_row, $IPP_ORGANIZATION_ADDRESS1, $IPP_ORGANIZATION_ADDRESS2, $IPP_ORGANIZATION_ADDRESS3;
            //Set a colour
            $this->SetTextColor(153, 153, 153);
            //greyish
            //Arial bold 15
            $this->SetFont('Arial', 'B', 12);
            //Move to the right
            $this->Cell(60);
            //out organization
            $this->Ln();
            $this->Cell(60);
            $this->Cell(0, 5, $IPP_ORGANIZATION, 'B', 1, 'R');
            //$this->Ln();
            $this->SetFont('Arial', 'I', 5);
            $this->Cell(60, 0, '', 0, 0, '');
            $this->Cell(0, 5, $IPP_ORGANIZATION_ADDRESS1 . ', ' . $IPP_ORGANIZATION_ADDRESS2 . ', ' . $IPP_ORGANIZATION_ADDRESS3, 0, 0, 'R');
            //Logo
            $this->Image(IPP_PATH . 'images/logo_pb.png', 10, 8, 50);
            // todo: html folk should not icon location for customization features
            //Line break
            $this->Ln(15);
            //Set colour back
            $this->SetTextColor(153, 153, 153);
            // Well, I'm back in black, yes I'm back in black! Ow!  Todo: note again nature of comment
        }
        //Page footer
        function Footer()
        {
            global $student_row;
            //Set a colour
            $this->SetTextColor(153, 153, 153);
            //greyish
            //Position at 1.5 cm from bottom
            $this->SetY(-10);
            //Arial italic 8
            $this->SetFont('Arial', 'I', 8);
            //Page number
            $this->Cell(0, 3, 'Anecdotal report for ' . $student_row['first_name'] . ' ' . $student_row['last_name'] . '-' . date('dS \\of F Y') . ' (Page ' . $this->PageNo() . '/{nb})', 0, 1, 'C');
            //output a little information on this
            $this->SetFont('Arial', 'i', 6);
            $this->SetTextColor(153, 153, 153);
            //greyish
            $this->SetFillColor(255, 255, 255);
            $this->Ln(1);
            $this->MultiCell(0, 5, "Grasslands Individual Program Plan System (�2005-2006 Grasslands Public Schools)", 'T', 'C', 1);
            //todo: this should be a variable controlled on admin console
            //Set colour back
            $this->SetTextColor(0, 0, 0);
            // Well, I'm back in black, yes I'm back in black!  Todo: note the dev listened to ACDC
        }
    }
    //Instanciation of inherited class
    $pdf = new IPP();
//.........这里部分代码省略.........

function echoJSServicesArray()
{
    global $system_message;
    $coordlist_query = "SELECT DISTINCT `name`, COUNT(`name`) AS `count` FROM typical_long_term_goal_category WHERE is_deleted='N' GROUP BY `name` ORDER BY `name` DESC LIMIT 200";
    $coordlist_result = mysql_query($coordlist_query);
    if (!$coordlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$coordlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        echo createJavaScript($coordlist_result, "popuplist");
    }
}

function echoJSServicesArray()
{
    global $system_message;
    $coordlist_query = "SELECT DISTINCT `agency`, COUNT(`agency`) AS `count` FROM coordination_of_services GROUP BY `agency` ORDER BY `count` DESC LIMIT 200";
    $coordlist_result = mysql_query($coordlist_query);
    if (!$coordlist_result) {
        $error_message = "Database query failed (" . __FILE__ . ":" . __LINE__ . "): " . mysql_error() . "<BR>Query: '{$coordlist_query}'<BR>";
        $system_message = $system_message . $error_message;
        IPP_LOG($system_message, $_SESSION['egps_username'], 'ERROR');
    } else {
        //call the function to create the javascript array...
        if (mysql_num_rows($coordlist_result)) {
            echo createJavaScript($coordlist_result, "popuplist");
        }
    }
}