Admin_SurveyView.prg

<?php
    $monLibrary= dirname(__FILE__) . "/../library";
    require_once("$monLibrary/cu_top.i");
    require_once("$monLibrary/ck_hticket.i");

  if (!CheckPerm($link, $Hu, basename($_SERVER['SCRIPT_NAME']), $_SERVER['REMOTE_ADDR'])) {
    // ** Permissions failed
    // ** redirect to new page
    header("Location: /hcuadm/hcu_noperm.prg");
    exit;
  }

$dms_ok=array('showid'=>'string','viewmsg'=>'digits');
dms_import($dms_ok);

    print <<<EOF
            <CENTER>
            <TABLE WIDTH=95% BORDER=0 CELLPADDING=0 CELLSPACING=0>
            <tr><td CLASS=""><DIV CLASS="barb">Admin Survey</DIV></td></tr>
            <tr><td>
                <table border=0 cellspacing=0 cellpadding=2 width=100%>
                    <tr><td class='bar'>HomeCU Survey</td></tr></table>
                        <table border=0 cellspacing=0 cellpadding=2 width=100%>
EOF;

    $showid = trim(strtoupper((empty($showid) ? "PRESENT" : $showid)));

    switch ($showid) {
        case "ALL":
            $sclause = "";
            break;
        case "PRESENT":
            $sclause = " and runstat = 1 and m.startdate < now() and m.stopdate > now() ";
            break;
        case "DRAFT":
            $sclause = " and m.runstat = 0 ";
            break;
        case "FUTURE":
            $sclause = " and m.runstat = 1 and m.startdate > now() ";
            break;
        default:
            $sclause = " and m.surveyid = $showid ";
            break;
    }
    $sql = "select m.surveyid, qstyle, question, answerid, answertext
                    from cuadmin_surveymaster m, cuadmin_surveydetail d
                    where m.surveyid = d.surveyid $sclause
                    order by stopdate, surveyid, answerid";

      $sth = db_query($sql,$link);

    print "<form>";

    for ($row=0; list( $surveyid, $qstyle, $qtext, $answerid, $atext ) =
                db_fetch_array($sth,$row); $row++) {

        if ($cur_sid != "$surveyid"){

            // if not first question

            if ($cur_sid != "" ) {
                echo "</table><br>";
            }

            if (intval($viewmsg) == 0) {
                $qtext = htmlspecialchars($qtext);
            } else {
                $qtext = trim($qtext);
            }
            echo "<table border=0 CELLSPACING=1 CELLPADDING=2 width=100%><tr>\n
                <td CLASS=hdr1>$qtext</td></tr>";
                $cur_sid = "$surveyid";
                $rbg="odd";
        }

        if (intval($viewmsg) == 0) {
            $atext = htmlspecialchars($atext);
            print <<<EOF
                <tr CLASS={$rbg}_small>
                    <td><input type="radio" name="response[$surveyid]" value="$answerid">
                        &nbsp;<font size=-1>$atext</font></td></tr>
EOF;
        }
        $rbg =  ($rbg == "odd" ? "even" : "odd");
  }
    db_free_result($sth);

    if ($cur_sid == "" ) {
        switch ($showid) {
            case "PRESENT":
                $notfound = "No PRESENT Surveys Found";
                break;
            case "DRAFT":
                $notfound = "No DRAFT Surveys Found";
                break;
            case "FUTURE":
                $notfound = "No FUTURE Surveys Found";
                break;
            default:
                $notfound = "No Surveys Found";
                break;
        }
        print <<<EOF
            <table border=0 cellspacing=0 cellpadding=2 width=100%>
                <tr><td class='hdr1'>$notfound</td></tr>
EOF;
    }
    print <<<EOF
        </table></td></tr></TABLE><br>
        <input type=button value='Close' onClick='self.close();'></form>
EOF;
    echo "</body></html>";
?>