PHP output_faculty_stats Exemples

Exemple #1

Fichier : summative_feedback.php Projet : vinod-co/centa

        $result = $mysqli->prepare("SELECT DISTINCT idfeedback_release, type FROM properties, properties_modules, feedback_release WHERE feedback_release.paper_id = properties.property_id AND properties.property_id = properties_modules.property_id {$date_range} AND paper_type = '2' AND idMod IN (" . implode(',', $moduleIDs) . ") AND deleted IS NULL");
        $result->execute();
        $result->bind_result($idfeedback_release, $type);
        while ($result->fetch()) {
            $master_array[$school][$type]++;
        }
        $result->close();
    }
}
$parts = array('exams', 'objectives', 'questions', 'cohort_performance', 'external_examiner');
$old_faculty = '';
$faculty_stats = array(0, 0, 0, 0, 0);
foreach ($master_array as $school => $data) {
    if ($old_faculty != $data['faculty']) {
        if ($old_faculty != '') {
            echo output_faculty_stats($faculty_stats);
        }
        echo '<tr><td colspan="6" class="faculty">' . $data['faculty'] . '</td></tr>';
        $faculty_stats = array(0, 0, 0, 0, 0);
    }
    echo "<tr><td>" . $school . "</td>";
    for ($i = 0; $i < 5; $i++) {
        $part = $parts[$i];
        if ($data[$part] == 0) {
            echo "<td class=\"n grey\">" . $data[$part] . "</td>";
        } else {
            if ($i == 1 or $i == 2 or $i == 3) {
                echo "<td class=\"n\"><a href=\"feedback_detail.php?calyear=" . $_GET['calyear'] . "&school=" . $master_array[$school]['id'] . "&type={$i}\">" . $data[$part] . "</a></td>";
            } else {
                echo "<td class=\"n\">" . $data[$part] . "</td>";
            }

Exemple #2

Fichier : questions_by_school.php Projet : vinod-co/centa

        $date_range = '';
        $result = $mysqli->prepare("SELECT DISTINCT questions.q_id, q_type FROM questions, questions_modules WHERE questions.q_id = questions_modules.q_id AND idMod IN (" . implode(',', $moduleIDs) . ") AND deleted IS NULL GROUP BY questions.q_id");
        $result->execute();
        $result->bind_result($q_id, $q_type);
        while ($result->fetch()) {
            $master_array[$school]['types'][$q_type]++;
        }
        $result->close();
    }
}
$old_faculty = '';
$faculty_stats = $types;
foreach ($master_array as $school => $data) {
    if ($old_faculty != $data['faculty']) {
        if ($old_faculty != '') {
            echo output_faculty_stats($faculty_stats, $types);
        }
        echo '<tr><td colspan="19" class="faculty">' . $data['faculty'] . '</td></tr>';
        $faculty_stats = array();
    }
    echo "<tr><td>" . $school . "</td>";
    foreach ($types as $type) {
        if ($data['types'][$type] == 0) {
            echo "<td class=\"n grey\">" . $data['types'][$type] . "</td>";
        } else {
            echo "<td class=\"n\">" . number_format($data['types'][$type]) . "</td>";
        }
        if (isset($faculty_stats[$type])) {
            $faculty_stats[$type] += $data['types'][$type];
        } else {
            $faculty_stats[$type] = $data['types'][$type];