<?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 Master";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	$check=mysqli_query($con,"delete from opening_balance_to_cash where id='$doid'");
	if($check){
	$_SESSION['msg']='Record Deleted Successfully';
	}
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=addbankopeningbalance.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="EditCashOpeningBal";
	  $doid=$_REQUEST['upid'];
	 
	  $upuserresult=mysqli_query($con,"select * from opening_balance_to_cash where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
	  
}else{
 	  $dovalue="AddCashOpeningBal";
	  $doid='';
} 
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Opening Balance To Cash<small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#"> Opening Balance To Cash</a></li>
    </ol>
  </section>
  <!-- Main content --> 
  <section class="content">
    <div class="row">
      <div class="col-md-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 box-info">
          <div class="box-header">
            <h3 class="box-title"> Opening Balance To Cash <small></small></h3>
			
            <!-- 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><!-- /. tools -->
          </div><!-- /.box-header -->
          <div class="box-body pad">
		 
			 <form method="post" action="action.php" name="addcategory" id="addcategory" 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="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
               
                <div class="form-group">
                  <label> Opening Balance  *</label>
                  <input name="op_bal" type="text"  placeholder="Opening Balance  " id="ContentPlaceHolder1_txtMobile" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['cach_balance'];}?>" class="form-control" required>                  
                </div>
                
                
                                   <div class="box-footer">
                  <input type="submit" class="btn btn-primary" 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>
          </div>
        </div><!-- /.box -->
      </div><!-- /.col-->
   <!-- ./row -->
  </section><!-- /.content -->
  
   <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">REPORT</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
		  <form name="datesearch" method="get" action="" class="pull-right">
Form: <input id="demo1" name="datefrom" placeholder="yyyy-mm-dd" type="text" value="<?php if(!empty($_GET['datefrom'])){ echo $_GET['datefrom'];}else{ } ?>">


To: <input id="demo1" name="dateto" placeholder="yyyy-mm-dd" type="text" value="<?php if(!empty($_GET['dateto'])){ echo $_GET['dateto'];}else{ } ?>" size="25">

<input type="submit" value="Search" class='btn btn-primary' >
</form>
            <table id="example1" class="table table-bordered table-striped">
              <thead>
                <tr>                 
                    <th scope="col">No</th>
                 
                        <th scope="col">Cash Opening Balance</th>
                    <th scope="col">Created Date</th>
					<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
                    <th scope="col">Action</th>
					<?php } ?>
                </tr>
              </thead>
              <tbody>
			
			  
                <?php 
			
				if(!empty($_GET['datefrom']) && !empty($_GET['dateto'])){
				$start =$_GET["datefrom"];
                $end =$_GET["dateto"]; 
					$Query=mysqli_query($con,"select * from opening_balance_to_cash   WHERE created_at between '".$start."' and '".$end."'");
				
				}else{
				$Query=mysqli_query($con,"select * from opening_balance_to_cash limit 10");
				}
			  		$i = 1;
	  				  while($Row=mysqli_fetch_array($Query)){ ?>
                <tr>
                  <td><?php echo $i; ?></td>

                  <td><?=$Row['cach_balance'];?></td> 
                
                 
                  <td><?php echo $Row['created_at']; ?></td>
				  	  <?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
                  <td><a href="?upid=<?php echo $Row["id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a>&nbsp;&nbsp; <a href="?did=<?php echo $Row["id"]; ?>" onclick="return confirm_click();"><i class="fa fa-remove text-red"></i></a></td>
					  <?php } ?> 
                </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  type="text/javascript">
	$(function () {
	$("#example1").DataTable();
	$('#example2').DataTable({
		"paging": true,
		"lengthChange": false,
		"searching": false,
		"ordering": true,
		"info": true,
		"autoWidth": false
	});
	});
</script>