Example #1
0
printf("<option value='%s' %s>" . _("Breastfeeding Followup") . "</option>\n", ACTION_BREASTFEEDING_FOLLOWUP, $survey == ACTION_BREASTFEEDING_FOLLOWUP ? 'selected' : '');
printf("<option value='%s' %s>" . _("Self Efficacy Survey") . "</option>\n", ACTION_SELF_EFFICACY, $survey == ACTION_SELF_EFFICACY ? 'selected' : '');
printf("<option value='%s' %s>" . _("Breastfeeding Evaluation") . "</option>\n", ACTION_BREASTFEEDING_EVALUATION, $survey == ACTION_BREASTFEEDING_EVALUATION ? 'selected' : '');
printf("<option value='%s' %s>" . _("Postnatal Depression") . "</option>\n", ACTION_POSTNATAL_DEPRESSION, $survey == ACTION_POSTNATAL_DEPRESSION ? 'selected' : '');
echo "</select>";
?>
            
            <input type="submit" name="questionaire" value="<?php 
echo _("Survey Results");
?>
">
          </form>
          <?php 
if (isset($_SESSION['surveyT']) && isset($_SESSION['q_mid'])) {
    // Get survey resonses
    $query = "SELECT * FROM " . surveyTable($_SESSION['surveyT']) . " WHERE mid = " . $_SESSION['q_mid'] . " ;";
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    echo "<br />";
    echo "<form method='post' action='admin/post/survey_download.php'>";
    echo "<input type='hidden' name='survey' value='{$survey}' />";
    echo "<input type='hidden' name='mid' value='" . $_SESSION['q_mid'] . "' />";
    if ($row) {
        echo "<input type='submit' name='downloadsurveyresults' value='" . _('Download For This User') . "'>";
    }
    echo "<input type='submit' name='downloadAll' value='" . _('Download All Of This Type') . "'>";
    echo "</form>";
    echo "<br /><br />";
    // Check if anything was returned from query, if not no info to display
    if ($row) {
        // Echo the results os SystemFeedback survey
        case ACTION_SELF_EFFICACY:
            return _("Self Efficacy");
        case ACTION_BREASTFEEDING_EVALUATION:
            return _("Breastfeeding Evaluation");
        case ACTION_POSTNATAL_DEPRESSION:
            return _("Postnatal Depression");
        default:
            return "";
    }
}
if (!can_access_mother((int) $_POST['mid'])) {
    header("HTTP/1.0 403 Forbidden");
    die("<h1>Forbidden</h1>");
}
$survey = $_POST["survey"];
$query = "SELECT * FROM " . surveyTable($survey) . " WHERE mid in ( %s );";
if (isset($_POST['downloadAll'])) {
    if ($_SESSION['admin'] == SUPER_ADMIN) {
        $query = sprintf($query, "SELECT M.mid FROM Mothers M");
    } else {
        if ($_SESSION['admin'] == HOSPITAL_ADMIN) {
            $query = sprintf($query, "SELECT M.mid FROM Mothers M where M.hospital_id = " . $_SESSION['hospital_id']);
        } else {
            $query = sprintf($query, "SELECT M.mid FROM Mothers M,Mothers_Scientists MS where M.mid=MS.mid AND MS.sid=" . $_SESSION['sid']);
        }
    }
} else {
    $query = sprintf($query, (int) @$_POST['mid']);
}
$result = mysql_query($query);
if (!$result) {