cuquest.prg

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

  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('act'=>'digits','qid'=>'string','qlang'=>'string',
'form_qid'=>'digits','form_lang'=>'array','form_txt_'=>'prefix_s',
'form_ex_txt_'=>'prefix_s','btnSave'=>'string','form_type_'=>'prefix_s','Remote_Update'=>'array');

dms_import($dms_ok);

    $HCU_Lang_Codes = array("en_US"=>"American English", "es_US"=>"American Spanish","pl_US"=>"Polish");

    $self = $_SERVER['PHP_SELF'];

    $act = (isset($act) && intval($act) > 0 ? intval($act) : 2);


    $form_err = "";
    $err_msg = "";
    $sql = "";


    // *** SAVE CODE
    if ($act == 1 && isset($btnSave)) {

        /* VALIDATE THE INFORMATION - whether it's been saved before or NOT
            After validation fails it will send the information back to the edit form
            So it looks like it did before, the fail information will be at the bottom of the
            screen.

        */

                // Now we need to load all the fields from the CU form, and post them back
                // So the user does not have to press the back button.
                // Load all the Fields from the previous form into hidden fields on this form

        if ($err_msg == "") {

            $save_qid = "";
            $Remote_Results = "";

            // Everything was validated, we now need to save the information, either insert for new or update for edited.

            $save_lang = $form_lang;

            if (isset($form_qid) && intval($form_qid) > 0) {
                $save_qid = intval($form_qid);
            } else {
                $sql = "SELECT nextval('cuquestmaster_quest_id_seq');";
                $qid_rs = db_query($sql, $link);
                list($save_qid) = db_fetch_array($qid_rs);
                db_free_result($qid_rs);
            }

            $sql = "";
            foreach ($form_lang as $lang_key => $lang_value) {
                $save_text = prep_save(trim(${"form_txt_" . $lang_value}));
                $save_ex_text = prep_save(trim(${"form_ex_txt_" . $lang_value}));
                $save_type = prep_save(trim(${"form_type_" . $lang_value}));


                // *** FIRST LOOK FOR THE RECORD
                $lkup_sql = "SELECT count(quest_id)
                                FROM cuquestmaster
                                WHERE quest_id = '$save_qid'
                                    AND quest_lang = '$lang_value'; ";
                $lookup_rs = db_query($lkup_sql, $link);
                list($qid_count) = db_fetch_array($lookup_rs);
                db_free_result($lookup_rs);


                if ($qid_count > 0) {
                    // *** UPDATE THE TABLE
                    $sql .= "UPDATE cuquestmaster SET
                                        quest_text = '$save_text',
                                        example_text = '$save_ex_text',
                                        quest_type = '$save_type'
                                    WHERE quest_id = '$save_qid'
                                        AND quest_lang = '$lang_value'; ";

                } else {
                    // *** INSERT INTO TABLE
                    $sql .= "INSERT INTO cuquestmaster
                                        (quest_id, quest_lang, quest_text, example_text, quest_type)
                                    VALUES
                                        ('$save_qid',
                                         '$lang_value',
                                         '$save_text',
                                         '$save_ex_text',
                                         '$save_type' ); ";
                }


                // ** SAVE ANY REMOTE OPTIONS
                if (Remote_Update_Selected()) {
                    // ** NOW CHECK FOR SAVING TO A REMOTE SERVER
                    // ** Add Each field that will be updated

                    Remote_Field_Add("cuquest", "qst_id", $save_qid);
                    Remote_Field_Add("cuquest", "qst_lang", $lang_value);
                    Remote_Field_Add("cuquest", "qst_txt", trim(${"form_txt_" . $lang_value}));
                    Remote_Field_Add("cuquest", "qst_etxt", trim(${"form_ex_txt_" . $lang_value}));
                    Remote_Field_Add("cuquest", "qst_type", $save_type);

                    // ** Need to create the url I am going to send to the remote server
                    $Remote_Results .= Remote_Update_Send("U", "cuquest") . "<br>";

                    $Remote_Fields = array();
                }


            }

            $save_msg = "";

            if (!$save_rs = db_query($sql, $link)) {
                // ** SAVE FAILED
                $form_err = "Unable to Save Challenge Question!";
            } else {
                // ** ALL WAS SUCCESSFULL

                if ($save_qid == 0) {
                    // ** FOR NEW RECORDS -- fetch the ID
                    // *** POSTGRES METHOD
                    $psql_lastoid = pg_last_oid($save_rs);
                    $sql = "SELECT quest_id
                                    FROM cuquestmaster
                                    WHERE oid = '" . intval($psql_lastoid) . "'; ";
                    $oid_rs = db_query($sql, $link);
                    list($save_qid) = db_fetch_array($oid_rs);
                    db_free_result($oid_rs);
                }

                // ** FORWARD the browser back to the 'list' screen along with a confirmation message
                header ("Location: $self?msg=" . urlencode("The Challenge Question was saved.<br>") . urlencode($Remote_Results));

                exit;
            }
        } else {
            // ** Failed Validation -- set the error up here -- reshow the form
            $act = 1;
        }
    }



    switch ($act):
        case "1":           // Edit Challenge Questions
            $qst_id = "";
            $qst_txt = array();
            // $qst_lang = array();
            $qst_ex_txt = array();
            $qst_type = array();

            $use_form = "";

            // ** Determine if we are Adding or Editing
            if (isset($form_qid)) {

                // ** We are reloading the information --- set it up here
                $qst_id = $form_qid;
                foreach ($form_lang as $key=>$value) {
                    $qst_txt[$value] = ${"form_txt_" . $value};
                    $qst_ex_txt[$value] = ${"form_ex_txt_" . $value};
                    $qst_type[$value] = ${"form_type_" . $value};
                }
                $use_form = $form_use;
            } elseif (isset($qid)) {

                // *Question ID set -- assume we are editing

                    // Connect to the database - get the team information from the database
                    $query = "select *
                            from cuquestmaster
                            where quest_id = '" . intval($qid) . "'";

                    $result = db_query($query, $link);
                    // Now fetch the row
                    $cnt = 0;
                    while ($cuquest_row = db_fetch_object($result, $cnt)) {
                        $qst_id = $cuquest_row->quest_id;
                        $qst_txt[$cuquest_row->quest_lang] = trim($cuquest_row->quest_text);
                        $qst_ex_txt[$cuquest_row->quest_lang] = trim($cuquest_row->example_text);
                        $qst_type[$cuquest_row->quest_lang] = $cuquest_row->quest_type;

                        $cnt++;
                    }
                    db_free_result($result);

                    $use_form = "Edit";
            } else {
                // Adding new Challenge Question, setup empty data.
                foreach($HCU_Lang_Codes as $lang_key=>$lang_value) {
                    $qst_txt[$lang_key] = "";
                    $qst_type[$lang_key] = "";
                    $qst_ex_txt[$lang_key] = "";
                }
            }

            $use_form = ($use_form == "" ? "Add" : $use_form);
            cu_header("Edit Challenge Questions");
?>
            <form action="<?php echo $self; ?>?act=<?php echo $act; ?>" method="post">
            <p>&nbsp;<br>
            <?php
                if (strlen($form_err) > 0)
                    printf("\n<font color=\"red\">Errors found before saving the information.  Please review errors at bottom of screen.\n<p></font>");
            ?>
            <center>
            <table cellpadding="3" cellspacing="0" border="0" class="dmsbg" width="500"><tr><td>
            <table cellpadding="2" cellspacing="0" border="0" bgcolor=white width="100%">
                <tr>
                    <td colspan="2" class="bar" align="center">
                            <?php echo strtoupper($use_form); ?> CHALLENGE QUESTION
                    </td>
                </tr>
                <tr>
                    <td nowrap align="right" class="hdr">
                        Question ID:
                    </td>
                    <td nowrap  class='dtl'>
                        <?php if ($use_form == "Add"): ?>
                            New Question
                        <?php else:
                            echo $qst_id; ?>
                        <?php endif; ?>
                        <input type="hidden" name="form_qid" value="<?php echo $qst_id; ?>">
                    </td>
                </tr>
                <?php foreach($HCU_Lang_Codes as $lang_key=>$lang_value): ?>
                    <tr>
                        <td nowrap align="right" class="hdr">
                            <input type="hidden" name="form_lang[]" value="<?php echo $lang_key; ?>">
                            &nbsp;
                        </td>
                        <td nowrap align="left" class="hdr">
                            Question for <?php echo $lang_value; ?>
                        </td>
                    </tr>
                    <tr>
                        <td nowrap align="right" class="hdr">
                            Question:
                        </td>
                        <td nowrap  class='dtl'>
                            <input type="text" name="form_txt_<?php echo $lang_key; ?>" size="50" maxlength="80" value="<?php echo $qst_txt[$lang_key]; ?>">
                        </td>
                    </tr>
                    <tr>
                        <td nowrap align="right" class="hdr">
                            Question Answer Format:
                        </td>
                        <td nowrap  class='dtl'>
                            <select name="form_type_<?php echo $lang_key; ?>">
                                <option value="T" <?php echo ($qst_type[$lang_key] == "T" ? "SELECTED" : ""); ?>>Text</option>
                                <option value="D" <?php echo ($qst_type[$lang_key] == "D" ? "SELECTED" : ""); ?>>Date Format</option>
                            </select>
                        </td>
                    </tr>
                    <tr>
                        <td nowrap align="right" class="hdr">
                            Example Text:
                        </td>
                        <td nowrap  class='dtl'>
                            <input type="text" name="form_ex_txt_<?php echo $lang_key; ?>" size="20" maxlength="30" value="<?php echo $qst_ex_txt[$lang_key]; ?>">
                        </td>
                    </tr>
            <?php endforeach; ?>
                <tr>
                    <td class='dtl'>&nbsp;</td>
                    <td nowrap class='dtl'>
                        <?php remote_update_list(); ?>
                    </td>
                </tr>
                <tr>
                    <td class='dtl'>&nbsp;</td>
                    <td nowrap class='dtl'>
                        <input type="submit" name="btnSave" Value="Save">
                        <input type="button" name="Cancel" Value="Cancel" onClick="document.location='cuquest.prg'">
                    </td>
                </tr>
            <?php // If the error value is here then print it at the end
                if (isset($form_err)) {
                    echo "<tr><td colspan=2 class='err'>$form_err</td></tr>";
                }
            echo "
                </table>
                </td></tr></table> ";
            break;
        case "2":
            cu_header("CU Challenge Questions");
            ?>
            <form>
                <?php
                    // Connect to the data and retrieve the current list of Home CU Products
                    $query = "SELECT * FROM cuquestmaster ORDER BY quest_id, quest_lang, quest_text ";
                    $qst_result = db_query($query, $link);

                ?>

            <!-- Print out the top of the table -->
            <table border="0" cellpadding="3" cellspacing="0" align="center" width="500" class="dmsbg"><tr><td>
            <table border="0" cellpadding="2" cellspacing="0" align="center" width="100%" bgcolor=white>
                <tr>
                    <td colspan="4" class="bar" align="center">
                        CHALLENGE QUESTION LIST
                    </td>
                </tr>
                <?php if (isset($msg)): ?>
                    <tr>
                        <td colspan="4" class="msg" align="center">
                            <?php echo $msg; ?>
                        </td>
                    </tr>
                <?php endif; ?>
                <tr>
                    <td class="hdr" align="center">
                        Question ID
                    </td>
                    <td class="hdr" align="center">
                        Language
                    </td>
                    <td class="hdr" align="center">
                        Question Text
                    </td>
                    <td class="hdr" align="center">
                        Select
                    </td>
                </tr>
                <?php
                    $RGB = "odd";
                    $row = 0;
                    $last_qid = "";
                    while ($qst_row = db_fetch_object($qst_result, $row)):
                    $row++;
                ?>
                <tr class="<?php echo $RGB; ?>">
                    <?php if ($last_qid != $qst_row->quest_id): ?>
                        <td nowrap >
                            <?php echo trim($qst_row->quest_id) ?>
                        </td>
                        <td nowrap >
                            <?php echo trim($HCU_Lang_Codes["$qst_row->quest_lang"]) ?>
                        </td>
                        <td nowrap >
                            <?php echo trim($qst_row->quest_text) ?>
                        </td>
                        <td nowrap >
                            <a href="<?php echo $self; ?>?act=1&qid=<?php echo trim($qst_row->quest_id) ?>&qlang=<?php echo trim($qst_row->quest_lang); ?>">Edit</a>
                            <?php /*&nbsp;|&nbsp;
                            <a href="">Delete</a>
                            */ ?>
                        </td>
                    <?php
                        $last_qid = $qst_row->quest_id;
                    else: ?>
                        <td nowrap >
                            &nbsp;
                        </td>
                        <td nowrap >
                            <?php echo trim($HCU_Lang_Codes["$qst_row->quest_lang"]) ?>
                        </td>
                        <td nowrap >
                            <?php echo trim($qst_row->quest_text) ?>
                        </td>
                        <td nowrap >
                            &nbsp;
                        </td>
                    <?php endif; ?>
                </tr>
                <?php
                    $RGB = ($RGB == "odd" ? "even" : "odd");
                    endwhile;
                    db_free_result($qst_row);
                ?>

                <tr>
                    <td colspan="4">
                        <a href="<?php echo $self; ?>?act=1">Add Challenge Questions</a>
                        &nbsp;|&nbsp;
            <a href="<?php echo $infourl ?>/hcuadm/cuilist.prg" target="parent">Credit Union List</a>
                    </td>
                </tr>
            </table>
            </td></tr></table>
<?php
            break;
        default:
            cu_header("Error Displaying Form");
            print ("<form>");
            printError("Requested form not found!<br>Cancelling action.");
    endswitch;
    ?>
    </form>
    </body>
</html>