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) {