<?php 

include ("include/makeSession.php"); 
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
	  $installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
	  $menuper=explode(',',$installment_id);
	   
	   if(in_array('Manage Accounts',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}

$_SESSION['page_name']="Accounts Transactions";
include('include/function.php');
include("include/header.php");
include("banktobalance.php");
include("include/sidebar.php");

//include("include/sidebar.php"); 

if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){

	  $dovalue="BankToCash";

	  $doid=$_REQUEST['upid'];

	  $upuserresult=mysqli_query($con,"select * from restaurant where id='".$_REQUEST['upid']."'");

	  $upuserarr=mysqli_fetch_array($upuserresult);

}else{

 	  $dovalue="BankToCash";

	  $doid='';

}


?>


<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Cash To Bank Transfer <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Cash To Bank Transfer</a></li>
    </ol>
  </section>
  <!-- Main content -->
  
  <!-- /.content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Cash To Bank Transfer</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
            <h1 class="section-heading text-highlight"><span class="line"> Cash To Bank Transfer Form </span></h1>
          <div class="section-content">
            <div class="row">
			  <form method="post" action="action2.php" enctype="multipart/form-data"  role="form">
                <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />
				 <input type="hidden"  name="types" value="CashToBank" />
				 <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
			          <div style="clear: both"></div>
			   <div class="col-md-4 col-sm-4 subject">
                 <label for="name">Transaction Amount</label>
              </div>
           
             <div class="col-md-4 col-sm-4 subject">
                  <input type='number' name='transactionamount' class="form-control" 
				  value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['transactionamount'];}?>"  id="ContentPlaceHolder1_txtBillamountg" />
              </div>
              <br> 
    
              
             
             <div style="clear: both"></div>
			   <div class="col-md-4 col-sm-4 subject">
                 <label>Total Cash  </label>
              </div>
              <div class="col-md-4 col-sm-4 subject">
                  <p> <?php echo $upuserresultgsf['cash'];?></p>
                  </div>
                  <br/>
                                <input type="hidden" name="totalcash" value="<?php echo $upuserresultgsf['cash']; ?>" id="totalcashs" />
			  	     <div style="clear: both"></div>
			   <div class="col-md-4 col-sm-4 subject">
                 <label>Bank Name  </label>
              </div>
              <div class="col-md-4 col-sm-4 subject">
                  
               <select name="bank" class="form-control subject" id='subj'>
                              <option  value="NA" class='asde'>-select-</option>
                              <?php $CasteQuery=mysqli_query($con,"select * from bankdetails");
                                 while($CasteRow=mysqli_fetch_array($CasteQuery)){ 
                                              echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['bank'] == $CasteRow['id'] ? 'selected="selected"' : '' ).'  >'.$CasteRow['bankname'].'</option>';
                                 } ?>                  
                           </select>
              </div>
              <br>
			          <!--  <div style="clear: both"></div>
			   <div class="col-md-4 col-sm-4 subject">
                 <label>Check No  </label>
              </div>
           
             <div class="col-md-4 col-sm-4 subject">
                  <input type='text' name='checkno' class="form-control" 
				  value="<?php //if(isset($_REQUEST['upid'])){ echo $upuserarr['checkno'];}?>"  id="ContentPlaceHolder1_txtBillamount" />
              </div>
              <br> -->
                   <div class="col-md-12 col-sm-12 subject">
                  <input type="submit" class="btn btn-primary col-md-offset-4" name="ctl00$ContentPlaceHolder1$btnsave" value="Save"/>
                  <input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_reset" class="btn btn-primary">
                </div>
				
            
			</form>
          
            
			  
               
          </div>
          <!-- /.box-body --> 
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col --> 
    </div>
    <!-- /.row --> 
  </section>
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
	      <?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-12">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
        <div class="box">
          <div class="box-header">
		  
            <!-- tools box -->
            <div class="pull-right box-tools">
              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
            </div>
           
          </div>
          <!-- /.box-header -->
          <div class="box-body">
            <table id="example1" class="table table-bordered table-striped">
              <thead>
              <tr>                   
                    <th scope="col">Sr no</th>
					 <th scope="col">Transaction Id</th>
                    <th scope="col">Transaction Amount</th>
					  <th scope="col">Type</th>
						 <th scope="col">Bank Name</th>
                     <th scope="col">Created At</th>
                   <th scope="col">Created User</th>
                  
                  </tr>                
              </thead>
              <tbody>
                <?php $Query=mysqli_query($con,"select *,banktocash.created_at as cret from banktocash left join bankdetails on 
       banktocash.bank=bankdetails.id
left join admin on 
       banktocash.user_id=admin.id
	  where  banktocash.types='CashToBank'
	  order by banktocash.id desc
	   "); 
			  		$i = 1;
	  				  while($Row=mysqli_fetch_array($Query)){ ?>
                <tr>
			
                  <td><?php echo $i; ?></td>
				     <td><?=$Row['tran_id'];?></td> 
					  <td><?=$Row['transactionamount'];?></td> 
                  <td><?=$Row['types'];?></td> 
				
                   <td><?=$Row['bankname'];?></td> 
						 
                  <td><?=$Row['cret'];?></td>
                <td><?=$Row['username'];?></td>
                 
                </tr>
                <?php $i++;} ?>
              </tbody>
            </table>
          </div> 
          <!-- /.box-body --> 
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col --> 
    </div>
    <!-- /.row --> 
  </section>
</div>
<?php include('include/footer.php');?>



<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/dataTables.buttons.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/jszip.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/pdfmake.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/buttons.colVis.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js"  type="text/javascript"></script>


 

<script  type="text/javascript">   
$(document).ready(function() {
    $('#example1').DataTable( {
        dom: 'Bfrtip',
        columnDefs: [
            {
                targets: 1,
                className: 'noVis'
            }
        ],
        buttons: [
            {
                extend: 'colvis',
                columns: ':not(.noVis)'
            }
        ],
		 buttons: [
		 { extend: 'colvis', text: 'COLOUMNS' },
		 { extend: 'csv', text: 'Export to CSV' },
		 { extend: 'excel', text: 'Export to Excel' },
           { extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
        ],
		  
		
    } );
    
    
} );

		$('#ContentPlaceHolder1_txtBillamountg').on('blur',function(){
		    var inputbalance=$('#ContentPlaceHolder1_txtBillamountg').val();
		   
	        var 	totalcashs=$('#totalcashs').val();
	       // alert(totalcashs);
	     if(parseInt(totalcashs)+1<=parseInt(inputbalance)){
	          alert('Please Enter Amount Less Then '+totalcashs);
	          $('#ContentPlaceHolder1_txtBillamountg').val('');  
	     }else{
	        
	     }

	});
</script>