1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / mbcsl.mfmsbd.com /
Filename : loan_sec.php
back
<?PHP
	require 'functions.php';
	checkLogin();
	$db_link = connect();
	getLoanID($db_link);


	//Retrieve loan_id and loan_no of newly created loan from LOANS.
	$sql_loan = "SELECT loan_id, loan_no FROM loans WHERE loan_id = '$_SESSION[loan_id]'";
	$query_loan = mysqli_query($db_link, $sql_loan);
	checkSQL($db_link, $query_loan);
	$result_loan = mysqli_fetch_assoc($query_loan);

	// Select Securities from SECURITIES
	$securities = getLoanSecurities($db_link, $_SESSION['loan_id']);
	foreach ($securities as $s){
		if ($s['sec_no'] == 1) $security1 = $s;
		elseif ($s['sec_no'] == 2) $security2 = $s;
	}

	// Generate timestamp
	$timestamp = time();

	//SKIP-Button
	if (isset($_POST['skip'])){
		header('Location: loan.php?lid='.$_SESSION['loan_id']);
	}

	//UPLOAD-Button
	if (isset($_POST['upload'])){

		$target_path = "uploads/securities/";

		//Check if a file was uploaded for security 1
		if ($_FILES['sec1']['size'] != 0){

			//Determine where file 1 is going to be stored and create file name
			$path_part1 = pathinfo($_FILES['sec1']['name']);
			$extension1 = $path_part1['extension'];
			$file_name1 = $security1['loan_id'].'_01';

			//Add original filename 1 to target path 1
			$target_path1 = $target_path.$file_name1.'.'.$extension1;

			//Move uploaded file 1 from temporary storage to final location
			move_uploaded_file($_FILES['sec1']['tmp_name'], $target_path1);

			//UPDATE file path for security 1 in SECURITIES
			$sql_update_sec1_path = "UPDATE securities SET sec_path = '$target_path1' WHERE sec_id = '$security1[sec_id]'";
			$query_update_sec1_path = mysqli_query($db_link, $sql_update_sec1_path);
			checkSQL($db_link, $query_update_sec1_path);

		}

		//Check if a file was uploaded for security 2
		if ($_FILES['sec2']['size'] != 0){

			//Determine where file 2 is going to be stored and create file name
			$path_part2 = pathinfo($_FILES['sec2']['name']);
			$extension2 = $path_part2['extension'];
			$file_name2 = $security2['loan_id'].'_02';

			//Add original filename to target path 2
			$target_path2 = $target_path.$file_name2.'.'.$extension2;

			//Move uploaded file 2 from temporary storage to final location
			move_uploaded_file($_FILES['sec2']['tmp_name'], $target_path2);

			//UPDATE file path for security 2 in SECURITIES
			$sql_update_sec2_path = "UPDATE securities SET sec_path = '$target_path2' WHERE sec_id = '$security2[sec_id]'";
			$query_update_sec2_path = mysqli_query($db_link, $sql_update_sec2_path);
			checkSQL($db_link, $query_update_sec2_path);
		}

		//Unset session variables and refer to LOAN.PHP
		header('Location: loan.php?lid='.$_SESSION['loan_id']);
	}
?>

<?php headandmenu('New Loan', '1l'); ?>

<!--main content start-->
      <section id="main-content">
          <section class="wrapper" style="min-height: 850px;">


          <!--breadcrumbs start -->
          	<div class="row">
                  <div class="col-lg-12 pb-4">
                      <!--breadcrumbs start -->
                      <nav aria-label="breadcrumb">
                          <ol class="breadcrumb">
                              <li class="breadcrumb-item"><a href="start.php"><i class="fa fa-home"></i> Dashboard</a></li>
                              <!-- <li class="breadcrumb-item"><a href="#">Settings</a></li> -->
                              <li class="breadcrumb-item active" aria-current="page">New Loan</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->



		<div class="content_center">
			<p class="heading">Upload Documents for Loan <?PHP echo $result_loan['loan_no']; ?></p>

			<form enctype="multipart/form-data" action="loan_sec.php" method="POST">
				<input type="hidden" name="MAX_FILE_SIZE" value="1000000" />
				<?PHP
				if (isset($security1) AND $security1['sec_name'] != ""){
					echo '<label for="sec1" class="file-upload">
									<i class="fa fa-file-text-o"></i> '.$security1['sec_name'].'
								</label>
								<input type="file" name="sec1" id="sec1" accept=".pdf,.jpg,.jpeg,.png,.tif,.tiff,.doc,.docx,.xls,.xlsx,.odt,.ods,.txt" />
								<br/>';
				}
				if (isset($security2) AND $security2['sec_name'] != ""){
					echo '<label for="sec2" class="file-upload">
									<i class="fa fa-file-text-o"></i> '.$security2['sec_name'].'
								</label>
								<input type="file" name="sec2" id="sec2" accept=".pdf,.jpg,.jpeg,.png,.tif,.tiff,.doc,.docx,.xls,.xlsx,.odt,.ods,.txt" />
								<br/>';
				}
				?>
				<input type="submit" name="upload" value="Upload" />
				<input type="submit" name="skip" value="Skip" />
			</form>
		</div>



</section>
      </section>
      <!--main content end-->
      
   <?php footer(); ?>