lnappedit.i

<?php
  if (isset($_POST['removeid'])) {
    //** Try to delete the application
    $sql = "DELETE FROM {$DB_TABLE_PREFIX}userresponse
            WHERE userid = " . intval($DMSAPP_CURRENTUSERID) . "
              AND respid = " . intval($_POST['removeid']) . "; ";

   if ($del_rs = db_query($sql, $dbh)) {
      print <<< print_html

        <div class="col-xs-12 col-md-6 col-lg-4">
          <div class="row">
            <div class="alert alert-success col-xs-offset-1 col-xs-10">
              <p>Loan application was successfully deleted.</p>
            </div>
          </div>
          <div class="row">
            <div class="col-xs-offset-1 col-xs-10">
              <a class="k-button k-primary" href="{$self_full_url}?f=portal" id='linkFormPost' label='Submit'><i class="fa fa-home fa-fw"></i><span> Home</span></a>
            </div>
          </div>
        </div>
                  
print_html;

    } else {
      // * WAS UNABLE TO DELETE
      print <<< print_html
        <div class="col-xs-12 col-md-6 col-lg-4">
          <div class="row">
            <div class="alert alert-danger col-xs-offset-1 col-xs-10">
              <p>Unable to delete the loan at this time.</p>
              <p>Please make your selection again.</p>
            </div>
          </div>
          <div class="row">
            <div class="col-xs-offset-1 col-xs-10">
              <a class="k-button k-primary" href="{$self_full_url}?f=portal" id='linkFormPost' label='Submit'><i class="fa fa-home fa-fw"></i><span> Home</span></a>
            </div>
          </div>
        </div>
          
print_html;
    }
  } else {
    
    $sql = "SELECT  userresponse.*, schemamaster.loantitle,
              to_char(userresponse.respstarton,'MM/DD/YYYY') as user_startedon,
              to_char(userresponse.respsubmiton,'MM/DD/YYYY') as user_submiton,
              to_char(userresponse.respmodifiedon,'MM/DD/YYYY') as user_modifiedon
            FROM {$DB_TABLE_PREFIX}userresponse as userresponse
            JOIN  {$DB_TABLE_PREFIX}schemamaster as schemamaster
              ON schemamaster.loanid = userresponse.loanid
            WHERE userid = " . intval($DMSAPP_CURRENTUSERID) . "
              AND userresponse.respid = " . intval($_GET['remove']) . "
            ORDER BY respstarton desc ";
  
    $resp_rs = db_query($sql, $dbh);
    if ($resp_row = db_fetch_assoc($resp_rs)) {
      $form_found = true;
      
      $row_LoanType = disp_text($resp_row['loantitle']);
      
      $row_StartOn = disp_text($resp_row['user_startedon']);
      $row_SubmitOn = disp_text($resp_row['user_submiton']);
      $row_Modified = disp_text($resp_row['user_modifiedon']);
  
      $row_CULoanResp = disp_text($resp_row['respstatusdesc']);
  
      $form_respid = $resp_row['respid'];
    } else {
      $form_found = false;
    }

    
?>
  <?php if ($form_found): ?>
    <style>
      .form-delete-list ul {
        list-style: none;
      }
      .form-delete-list ul li {
        line-height: 2em;
        border-bottom: solid 1px #ABABAB;
      }
      .form-delete-list .delete-list-label {
        
      }
      .form-delete-list .delete-list-value {
        float:right;
      }
      .delete-button-group {
        float: right;
      }
    </style>
    <form id="appedit" name="appedit" action="<?php echo $self; ?>f=loandelete" method="post">
      <input type="hidden" name="form_set" value="$form_code">
      <input type="hidden" name="removeid" value="<?php echo $form_respid; ?>">
  
      <div class="col-xs-12 col-md-6 col-lg-4">
        <div class="panel panel-default">
          <div class="panel-heading">
            <h2 class="panel-title">Delete Application</h2>
          </div>
          <div class="panel-body">
            <div class="row">
              <div class="alert alert-info col-xs-offset-1 col-xs-10">
                <p>Are you sure you want to delete the following loan application?</p>
              </div>
            </div>
            <div class="row">
              <div class="col-xs-offset-1 col-xs-10">
                <div class="form-delete-list">
                  <br>                 
                  <ul>
                    <li><span class="delete-list-label">Loan Desc: &nbsp;</span><span class="delete-list-value"><?php echo $row_LoanType; ?></spqn></li>
                    <li><span class="delete-list-label">Started On:&nbsp;</span><span class="delete-list-value"><?php echo $row_StartOn; ?></span></li>
                    <li><span class="delete-list-label">Last Modified: &nbsp;</span><span class="delete-list-value"><?php echo $row_Modified; ?></span></li>
                    <li><span class="delete-list-label">Submitted On: &nbsp;</span><span class="delete-list-value"><?php echo $row_SubmitOn; ?></span></li>
                    <li><span class="delete-list-label">Status: &nbsp;</span><span class="delete-list-value"><?php echo $row_CULoanResp; ?></span></li>
                  </ul>
                </div>
              </div>
            </div>
            <div class="row">
              <div class="col-xs-offset-1 col-xs-10">
                <div class="delete-button-group">
                
                  <a class="" href="<?php echo $self_full_url; ?>?f=portal" style="margin-left: 6px" id='linkFormCancel'><span>Cancel</span></a>
  
                  <a class="k-button k-primary" href="#" id='linkFormPost' label='Submit'><span>Delete Loan</span></a>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <script language="javascript">
        $(function(){
          $('a[id^=linkFormPost]').click(function(){
            $('#appedit').submit();
          });
        });
  
      </script>
      

    </form> 
  

  <?php else: ?>
    <div class="col-xs-12 col-md-6 col-lg-4">
      <div class="row">
        <div class="alert alert-danger col-xs-offset-1 col-xs-10">
          <p>The loan you selected to delete was not found.</p>
          <p>Please make your selection again.</p>
        </div>
      </div>
      <div class="row">
        <div class="col-xs-offset-1 col-xs-10">
          <a class="k-button k-primary" href="<?php echo $self_full_url; ?>?f=portal" id='linkFormPost' label='Submit'><i class="fa fa-home fa-fw"></i><span> Home</span></a>
        </div>
      </div>
    </div>
  
  <?php endif; ?>

<?php
  }