<?php include('header.php'); 

?>





			<div>

				<ul class="breadcrumb">

					<li>

						<a href="#">Home</a> <span class="divider">/</span>

					</li>

					<li>

						<a href="#">Savings Account Transactions</a>

					</li>

				</ul>

			</div>

			

			

			<div class="row-fluid sortable">	

				<div class="box span12">

					<div class="box-header well" data-original-title>

						<h2>Savings Account Transaction Details</h2>

						<div class="box-icon">

							<a href="#" class="btn btn-setting btn-round"><i class="icon-cog"></i></a>

							<a href="#" class="btn btn-minimize btn-round"><i class="icon-chevron-up"></i></a>

							<a href="#" class="btn btn-close btn-round"><i class="icon-remove"></i></a>

						</div>

					</div>

					<div class="box-content">

                    <form action="<?php $_SERVER['PHP_SELF']?>" name="search" method="post">

                    <div class="form-actions">

                      <input type="date" class="input-xlarge datepicker" id="date01" placeholder="Form" name="form_date" required>

               		  <input type="date" class="input-xlarge datepicker" id="date02" placeholder="To" name="to_date" required><br />



                      <input type="hidden" name="today" value="<?php $date = date('Y-m-d'); ?>" />

               		  <!--<input type="text" name="act_number" id="act_number" placeholder="Account Number"  /><br />-->

					  <button type="submit" class="btn btn-primary" name="get_transaction">Get Details</button>

					</div>

                    </form>

						<table class="table table-bordered table-striped table-condensed">

							  <thead>

								  <tr>

                                  	  <th>Account Number</th>

									  <th>Transaction ID</th>

                                      <th>Debited(USD)</th>

                                      <th>Credited(USD)</th>

									  <th>Date Of Transaction</th>

									  <th>Balance(USD)</th>

								  </tr>

							  </thead> 

                              <?php

							  if(isset($_REQUEST['get_transaction'])) {
								$form_date = date("Y-m-d", strtotime($_REQUEST['form_date']));
								$to_date = date("Y-m-d", strtotime($_REQUEST['to_date']));
							  $transaction_details = custom_mysql_query("SELECT act.cust_atc_type,trans.* FROM act_holder_details act,transaction trans WHERE act.cust_act_number = trans.act_number AND act.cust_atc_type = 'savings' AND trans.transaction_date between '".$form_date."' AND '".$to_date."'");

							  while($transaction_details_fetch = custom_mysql_fetch_array($transaction_details)) {

							  

							  ?>  

							  <tbody>

								<tr>

                                	<td><?php echo $transaction_details_fetch['act_number']; ?></td>

									<td><?php echo $transaction_details_fetch['transaction_id']; ?></td>

                                    <td><?php echo $transaction_details_fetch['debited']; ?></td>

                                    <td><?php echo $transaction_details_fetch['credited']; ?></td>

									<td class="center"><?php echo $transaction_details_fetch['transaction_date']; ?></td>

									<td class="center"><?php echo $transaction_details_fetch['present_balance']; ?></td>  

								</tr>

							  </tbody>

                              <?php } }?>

						 </table>  

						 <!--<div class="pagination pagination-centered">

						  <ul>

							<li><a href="#">Prev</a></li>

							<li class="active">

							  <a href="#">1</a>

							</li>

							<li><a href="#">2</a></li>

							<li><a href="#">3</a></li>

							<li><a href="#">4</a></li>

							<li><a href="#">Next</a></li>

						  </ul>

						</div>   -->  

					</div>

				</div><!--/span-->

			</div><!--/row-->

    

<?php include('footer.php'); ?>

