lnappview.i

<?php
/*
 * File: lnappview
 * Purpose: This form will perform the function of creating a VIEW ONLY
 *            representation of the application.
 *          This form may also be what I call from HomeCU admin to show the application
 *            as well.  Not sure..
 *
 * Paramters:  viewapp -- this will be on the URL and will be the respid for the
 *              application to view
*/
  $App_Confirm = false;
  $Form_LoadRespID = 0;     // * this is the respid to load for the user
  if (isset($_GET['viewapp']) || intval($Admin_View_App) > 0) {
    // * there is an ID being passed.
    // * try to load the application here
    if (intval($Admin_View_App) > 0) {
      $Form_LoadRespID = intval($Admin_View_App);
    } else {
      $Form_LoadRespID = intval($_GET['viewapp']);
    }

    $sql = "SELECT loanschemadetail.*, loanschemamaster.*
            FROM {$DB_TABLE_PREFIX}userresponse as userresponse
            JOIN {$DB_TABLE_PREFIX}user as lnappuser
              on lnappuser.userid = userresponse.userid
            JOIN {$DB_TABLE_PREFIX}schemadetail as loanschemadetail
              on loanschemadetail.loanid = userresponse.loanid
            JOIN {$DB_TABLE_PREFIX}schemamaster as loanschemamaster
              on loanschemamaster.loanid = loanschemadetail.loanid
            WHERE userresponse.respid = {$Form_LoadRespID}
              AND userresponse.userid = " . intval($DMSAPP_CURRENTUSERID) . "
              AND lnappuser.cu = '" . $DMSAPP_CURRENTCUCODE . "'
            ORDER BY loanschemadetail.loanid, loanschemadetail.pageid, loanschemadetail.groupid, loanschemadetail.lineid
            ";

    $App_SchemaDetail = Array();
    $App_SchemaFields = Array();
    $App_AnswerDetail = Array();

    $loan_idx = 0;
    if ($loan_rs = db_query($sql, $dbh)) {
      // ** LOAN WAS FOUND
      // ** Load the code to actually view the application
      // ** LOAD THE USER RESPONSE

      $sql = "SELECT * 
              FROM {$DB_TABLE_PREFIX}userresponse
              WHERE respid = {$Form_LoadRespID}
              AND userid = " . intval($DMSAPP_CURRENTUSERID) . " ";
      $app_rs = db_query($sql, $dbh);
      $app_row = db_fetch_assoc($app_rs);
      

      // * Create the value to check
      if (!(intval($Admin_View_App) > 0)) {
        if (isset($_GET['confid'])) {
          $l_cookiename = ReturnDeviceCookieName($DMSAPP_CURRENTCUCODE, $DMSAPP_LOGINTYPE, $DMSAPP_CURRENTEMAIL, $DMSAPP_CURRENTUSERID);
          // ** Get Cookie Contents and include it with the value being crypted
          $l_cookieval = $_COOKIE[$l_cookiename];

          // $RecordVal = sha1($DMSAPP_SECRET_KEY . strtolower(trim($app_row['respfname'])) . strtolower(trim($app_row['resplname'])) . trim($app_row['respssn']) .  date('mdY', strtotime($app_row['respdob'])) . $l_cookieval);
          $RecordVal = sha1($DMSAPP_SECRET_KEY . trim($app_row['respssn']) .  date('mdY', strtotime($app_row['respdob'])) . $l_cookieval);
  /*
  print "RecordVal - $RecordVal<Br>";
  print "confid - " . $_GET['confid'] . "<Br>";
  print "cookie - " . $l_cookieval . "<br>";
  print "crypt - " . crypt($RecordVal, $_GET['confid']);

  print_r($_GET);
  exit;
  */

          if (crypt($RecordVal, $_GET['confid']) == $_GET['confid']) {
            $App_Confirm = true;
            // ** Allow them to Load
          } else {
            // ** they failed credential check
            $FORM_VALIDATION_ERROR = "<li>The answers you provided did not match with what we have on file for this loan.  Please try again.</li>";
          }
        }
      } else {
        // ** FOR ADMIN VIEW -- SET TO CONFIRMED
        $App_Confirm = true;
      }

      if (!$App_Confirm) {
        //** Application confirm FAILED
        // ** Either Include Script or redirect

        // ** Create redirect option
        $lnapp_security_return_form_code = $form_code;
        $lnapp_security_params = "viewapp=" . $_GET['viewapp'];
        $lnapp_security_respid = "";
        // ** Either case --

        include_once($inc_path . "lnappsecurity.i");
        exit;
      }

      // ** Load data from user application
      $JSON_FormPopulate = $app_row['respapplication'];
      $JSON_FormValues = json_decode($app_row['respapplication']);

      print "</div>
          </form>
          <div id='printoption'>
            <p><a href='javascript: window.print();'><i class='fa fa-print'></i> Print Page</a>&nbsp;&nbsp;&nbsp; <a href='javascript: window.close();'><i class='fa fa-window-close-o'></i> Close Window</a></p>
          </div>
      ";

      while ($loan_row = db_fetch_assoc($loan_rs, $loan_idx++)) {
        // ** Need to create the Loan Master Schema Array
        // ** Make the detailid the key so I can look it up quickly
        $App_SchemaDetail[$loan_row['detailid']] = $loan_row;

        if (strpos(":" . trim($loan_row['fieldtype']) . ":", ":YNR:YNR01:YNS:YNS01:GN:GA:GT:AS:AR:") >= 0) {
          // * This appears to be a valid type... This is a field that should be saved
          // to the database field response
          // ** All fields save will be the field name "formfield_{detailid}"
          $fieldname = "formfield_" . $loan_row['detailid'];
          $App_SchemaFields[$fieldname] = "";

        }
      }

      // ** Retrieve loan records - In order.. Now start displaying
      // * information


      // * some thoughts. If I can truly create the <div> tags how I envision,
        // Then i should be able to create the menu div section as I go, then the
        // style sheet can decide where to place this information
      $PageTagOpen = False;
      $GroupTagOpen = False;
      $LineTagOpen = False;
      $HoldLineOpen = False;

      $LAYOUT_PAGE = 1;
      $LAYOUT_GROUP = 2;
      $LAYOUT_LINE = 3;

      $CURRENT_LAYOUT = 0;
      $PAGE_COUNT = 0;
      $GROUP_COUNT = 0;

      // * This will be the left menu built on the left side for navigatino
      $Build_CSS_Menu = "";

      // ** Loan Information


      print "
        <form id='appview' name='appview' method='post' action='#'>
        <div class='container-fluid' id='appsolecontent'>";
      // while ($loan_row = db_fetch_array($loan_rs, $loan_idx++))
      $form_build_required_list = "";     // * this is the required list that will be included on teh form for whent eh user SUBMITS to the core
      foreach ($App_SchemaDetail as $Detail_key => $Detail_value) {

    //    $fieldtype = $loan_row['fieldtype'];
    //    $fieldvalue = disp_text($loan_row['fieldvalue']);
    //    // ** LOAD ThE JSON Object
    //    $fieldattr = json_decode($loan_row['fieldattr']);
    //
    //    $formfieldname = "formfield_" . $loan_row['detailid'];

        $fieldtype = $Detail_value['fieldtype'];
        $fieldvalue = disp_text($Detail_value['fieldvalue']);
        // ** LOAD ThE JSON Object
        $fieldattr = json_decode($Detail_value['fieldattr']);

        $formfieldname = "formfield_" . $Detail_key;
        $defaultval = '';

        $formfieldrequired = (GetClassPropertyVal($fieldattr, 'validation_require') == 1 ? "<em>*</em>" : "");
    //    // ** Based on the Field type we will do differen things..
    //    if ($loan_row['fieldtype'] == "P") {
    //      // ** PAGE HEADER
    //    } elseif ($loan_row['fieldtype'] == "H") {
    //      // ** Section Header
    //    } elseif ($loan_row['fieldtype']
    //print "WHILE LOOP - $loan_idx";
        $field_class = "";

        // ** FETCH THE USER RESPONSE VALUE
        $response_user_value = GetClassPropertyVal($JSON_FormValues, $formfieldname);

        switch ($fieldtype) {
          case "P":
            // Page Header
            // * Check to see if we need to Close any tags
            $PAGE_COUNT++;
    //        print "NEW P";
            StartDMSTag ($LAYOUT_PAGE, $PAGE_COUNT, $fieldvalue);
            print "<h1>$fieldvalue</h1>";

            break;
          case "H":
            // Section Header
    //        print "New H";
            $GROUP_COUNT++;
            StartDMSTag($LAYOUT_GROUP, 0,$fieldvalue);
            print "<legend>$fieldvalue</legend>";
            break;
          case "L":
            // Label
            print "<p id='' class=''>$fieldvalue</p>";
            break;
          case "YNR":
          case "YNS":
            // Yes/No OPTIONS
            StartDMSTag($LAYOUT_LINE);
            $defaultval = ($response_user_value == "Y" ? "Yes" : "No");

            break;
          case "YNR01":
          case "YNS01":
            // Yes/No OPTIONS
            StartDMSTag($LAYOUT_LINE);
            $defaultval = ($response_user_value == "1" ? "Yes" : "No");

            break;
          case "AS":
            // Answer Lookup
          case "AR":
            StartDMSTag($LAYOUT_LINE);

              if ($response_user_value != '') {
                $defaultval = Display_AnswerList($fieldattr->fieldansid, $formfieldname, "R", $fieldvalue, $response_user_value);
              }
            break;
          case "GT":
            // General Text (Reg Input)
            // ** validate changes based on the type of information we want


            if (isset($fieldattr->hidden) && $fieldattr->hidden == 1) {
              // ** DO NOT PRINT HIDDEN FIELDS
              // DO NOTHING
            } else {
              StartDMSTag($LAYOUT_LINE);
              $defaultval = $response_user_value;
            }
            break;
         default:
        }
        if ($defaultval != '') {
          print "<label for='$formfieldname'>$fieldvalue $formfieldrequired</label><input readonly='readonly' type='text' id='$formfieldname' name='$formfieldname' class='readonly' value='$defaultval' title='$fieldvalue' >";
        }
      }
      // ** -- Close the TAG??
      StartDMSTag($LAYOUT_PAGE, -1);    // * This should close all the tags left open


    } else {
    // * No ID found -- Report error to the screen
      print <<< print_html
      
      <div class="col-lg-6">
        <div class="alert alert-danger " role="alert">
          <div>
            A problem was encountered:
            <ul>
              Unable to find the loan you requested.  <br>
              Please make your selection again.
            </ul>
          </div>
        </div>
        <div >
          <a href='javascript: window.close();'><i class='fa fa-window-close-o'></i> Close Window</a>
        </div>
      </div>
      
print_html;
    }
  } else {
    // * No ID found -- Report error to the screen
      print <<< print_html
      
      <div class="col-lg-6">
        <div class="alert alert-danger " role="alert">
          <div>
            A problem was encountered:
            <ul>
              Unable to find the loan you requested.  <br>
              Please make your selection again.
            </ul>
          </div>
        </div>
        <div >
          <a href='javascript: window.close();'><i class='fa fa-window-close-o'></i> Close Window</a>
        </div>
      </div>
print_html;

  }
?>
  <style>
    #printoption {
      margin-left: 20px;
    }
  </style>