1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / dev.mfmsbd.com /
Filename : acc_sav_withd_dps.php
back
<?PHP
	require 'functions.php';
	checkLogin();
	$db_link = connect();
	getCustID($db_link);
    $cust_id = $_SESSION['cust_id'];

	//Generate Timestamp
	$timestamp = time();

    // Update DPS balance for current customer and store into variable
	updateDPSBalance ($db_link, $_SESSION['cust_id']);
	$dps_balance = getDPSBalance($db_link, $_SESSION['cust_id']);
	$dps_fixed = getDPSFixed($db_link, $_SESSION['cust_id']);


	//DPS WITHDRAW-Button  
	if (isset($_POST['withdraw'])){

		//Sanitize user input
		$sav_amount = sanitize($db_link, $_POST['sav_amount'])*(-1);
		$sav_slip = sanitize($db_link, $_POST['sav_slip']);
		$sav_receipt = sanitize($db_link, $_POST['sav_receipt']);
		$sav_date = strtotime(sanitize($db_link, $_POST['sav_date']));
		$sav_deduct = sanitize($db_link, $_POST['sav_deduct']);
        $savbranch_id = sanitize($db_link, $_POST['savbranch_id']);

		// Insert into DPS
		$sql_insert = "INSERT INTO dps (cust_id, sav_date, sav_amount, savtype_id, sav_receipt, sav_slip, savbranch_id, sav_created, user_id) VALUES ('$_SESSION[cust_id]', '$sav_date', $sav_amount, '11', '$sav_receipt', '$sav_slip', $savbranch_id, '$timestamp', '$_SESSION[log_id]')";
		$query_insert = mysqli_query($db_link, $sql_insert);
		checkSQL($db_link, $query_insert);

        // Update DPS account balance
		updateDPSBalance($db_link, $_SESSION['cust_id']);


		// Get SAV_ID for the latest entry
		$sql_savid = "SELECT MAX(sav_id) FROM dps WHERE cust_id = '$_SESSION[cust_id]' AND sav_receipt = '$sav_receipt' AND sav_created = '$timestamp'";
		$query_savid = mysqli_query($db_link, $sql_savid);
		checkSQL($db_link, $query_savid);
		$sav_id = mysqli_fetch_row($query_savid);

		// Insert Fee into INCOMES
		$sql_insert_income = "INSERT INTO incomes (cust_id, inctype_id, sav_id, inc_amount, inc_date, inc_receipt, inc_created, user_id) VALUES ('$_SESSION[cust_id]', '2', '$sav_id[0]', '$_SESSION[fee_withdraw]', '$sav_date', '$sav_receipt', '$timestamp', '$_SESSION[log_id]')";
		$query_insert_income = mysqli_query($db_link, $sql_insert_income);
		checkSQL($db_link, $query_insert_income);

		// Insert Fee into DPS, if applicable
		if($sav_deduct == 1){
			$fee_withdraw_neg = ($_SESSION['fee_withdraw'] * -1);

			$sql_insert_fee = "INSERT INTO dps (sav_mother, cust_id, sav_date, sav_amount, savtype_id, sav_receipt, sav_slip, sav_created, user_id) VALUES ('$sav_id[0]', '$_SESSION[cust_id]', '$sav_date', '$fee_withdraw_neg', '4', '$sav_receipt', '$sav_slip', '$timestamp', '$_SESSION[log_id]')";
			$query_insert_fee = mysqli_query($db_link, $sql_insert_fee);
			checkSQL($db_link, $query_insert_fee);

            // Update DPS account balance
			updateDPSBalance($db_link, $_SESSION['cust_id']);
		}

		// Forward to acc_sav_withd.php
		header('Location: acc_sav_withd_dps.php?cust='.$_SESSION['cust_id']);
	}

	// Get current customer's details
	$result_cust = getCustomer($db_link, $_SESSION['cust_id']);


    //Select Branches
	$sql_branch = "SELECT * FROM customer LEFT JOIN branch ON customer.custbranch_id=branch.branch_id WHERE cust_id = $cust_id";
	$query_branch = mysqli_query($db_link, $sql_branch);
	checkSQL($db_link, $query_branch);
	$row_branches = mysqli_fetch_assoc($query_branch);
?>


		<script>
			function validate(form){
				var savbalance = <?PHP echo $dps_balance; ?>;
				var savfixed = <?PHP echo $dps_fixed; ?>;
				var minsavbal = <?PHP echo $_SESSION['set_msb']; ?>;
				if (document.getElementById('sav_deduct').checked) var wd_fee = <?PHP echo $_SESSION['fee_withdraw']; ?>;
					else var wd_fee = 0;
				fail = validateDate(form.sav_date.value)
				fail += validateSlip(form.sav_slip.value)
				fail += validateAmount(form.sav_amount.value)
				fail += validateOverdraft(form.sav_amount.value, savbalance, wd_fee, minsavbal, savfixed)
				fail += validateReceipt(form.sav_receipt.value)
				if (fail == "") return true
				else { alert(fail); return false }
			}
		</script>
		<script src="functions_validate.js"></script>
		<script src="function_randCheck.js"></script>

<?php headandmenu('DPS withdrawal', '1c'); ?>

<!--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="#">Customers</a></li>
                              <li class="breadcrumb-item active" aria-current="page">DPS withdrawal</li>
                          </ol>
                      </nav>
                  </div>
              </div>
             <!--breadcrumbs end -->


		<!-- MENU -->
		<div id="menu_main">
			<a href="customer.php?cust=<?PHP echo $_SESSION['cust_id'] ?>">Back</a>
			<a href="cust_search.php">Search</a>
			<a href="acc_sav_depos.php?cust=<?PHP echo $_SESSION['cust_id'] ?>">Deposit</a>
			<a href="acc_sav_withd.php?cust=<?PHP echo $_SESSION['cust_id'] ?>">Withdrawal</a>
            <a href="acc_sav_dps.php?cust=<?PHP echo $_SESSION['cust_id'] ?>" >DPS</a>
			<a href="acc_sav_withd_dps.php?cust=<?PHP echo $_SESSION['cust_id']?>" id="item_selected">DPS Withdrawal</a>
			<a href="acc_share_buy.php?cust=<?PHP echo $_SESSION['cust_id'] ?>">Share Buy</a>
			<a href="acc_share_sale.php?cust=<?PHP echo $_SESSION['cust_id'] ?>">Share Sale</a>
			<a href="loan_new.php?cust=<?PHP echo $_SESSION['cust_id'] ?>">New Loan</a>
			<!-- <a href="cust_new.php">New Customer</a>
			<a href="cust_act.php">Active Cust.</a>
			<a href="cust_inact.php">Inactive Cust.</a> -->
		</div>

		<div class="row">
			
		
		<!-- LEFT SIDE: Input for new Withdrawal -->
		<div class="col-md-4">
			<p class="heading_narrow">Withdrawal for <?PHP echo $result_cust['cust_name'].' ('.$result_cust['cust_no'].')'; ?> </p>

			<form action="acc_sav_withd_dps.php" method="post" onsubmit="return validate(this);">
				<table id="tb_fields">
					<tr>
						<td>Date:</td>
						<td><input type="text" id="datepicker" name="sav_date" value="<?PHP echo date("d.m.Y",$timestamp); ?>" tabindex="1" required="required" /></td>
					</tr>
					<tr>
						<td>Amount:</td>
						<td><input type="number" name="sav_amount" placeholder="<?PHP echo $_SESSION['set_cur'] ?>" class="defaultnumber" min=1 tabindex="2" required="required" /></td>
					</tr>
					<tr>
						<td>W/drawal Slip:</td>
						<td><input type="number" name="sav_slip" placeholder="Slip No." class="defaultnumber" tabindex="3" required="required" /></td>
					</tr>
					<tr>
						<td>Receipt No:</td>
						<td><input type="number" name="sav_receipt" placeholder="for Withdrawal Fee" class="defaultnumber" tabindex="4" required="required" /></td>
					</tr>
                    <tr>
						<td>Branch: </td>
						<td>
							<select name="savbranch_id" size="1" tabindex="10">
								<option value="<?php echo $row_branches['branch_id']; ?>"><?php echo $row_branches['branch_name']; ?></option>
							</select>
						</td>
					</tr>
					<tr>
						<td>W/drawal Fee:</td>
						<td><input type="checkbox" name="sav_deduct" id="sav_deduct" value="1" tabindex="5" /> deduct from Savings</td>
					</tr>
					<tr>
						<td colspan="2" class="center"><input type="submit" class="btn btn-primary" name="withdraw" value="Withdraw" tabindex="6"  /></td>
					</tr>
				</table>
			</form>
		</div>

		<!-- RIGHT SIDE: Statement for Savings Account -->
		<div class="col-md-8" >
			<div class="table-responsive">
				<?PHP include 'acc_sav_list_dps.php'; ?>
			</div>
			

		</div>

		</div>



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