<?php session_start(); ob_start(); ?>

<?php  include 'header.php'; ?>

<?php
ini_set('display_errors', 0);
if(empty($_SESSION['LOGINID']) && empty($_SESSION['LOGINNM']) ){

	header("Location:index.php");
}


date_default_timezone_set('Asia/Dhaka');
                    $date_c = date('Y-m-d H:i:s', time());

include("user.php");
$action="";
  if (isset($_GET['action'])) {
	  $action = $_GET['action'];
	   $eid = mysqli_real_escape_string($connection, $_GET['id']);
  }


$dayBookDate2=date('Y-m-31');

$dayBookDate1=date('Y-m-01', strtotime($dayBookDate1. ' - 1 years'));

  
if (isset($_POST['day_submit'])) {
	$dayBookDate1=$_POST['date1'];
	$dayBookDate2=$_POST['date2'];
	$sub=2;
}  
  
  
?>



<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Payments</title>
    <!-- ================= Favicon ================== -->
    <!-- Standard -->
    <link rel="shortcut icon" href="http://placehold.it/64.png/000/fff">
    <!-- Retina iPad Touch Icon-->
    <link rel="apple-touch-icon" sizes="144x144" href="http://placehold.it/144.png/000/fff">
    <!-- Retina iPhone Touch Icon-->
    <link rel="apple-touch-icon" sizes="114x114" href="http://placehold.it/114.png/000/fff">
    <!-- Standard iPad Touch Icon-->
    <link rel="apple-touch-icon" sizes="72x72" href="http://placehold.it/72.png/000/fff">
    <!-- Standard iPhone Touch Icon-->
    <link rel="apple-touch-icon" sizes="57x57" href="http://placehold.it/57.png/000/fff">
    <!-- Styles -->
     <link href="assets/css/lib/data-table/buttons.bootstrap.min.css" rel="stylesheet" />
    <link href="assets/css/lib/font-awesome.min.css" rel="stylesheet">
    <link href="assets/css/lib/themify-icons.css" rel="stylesheet">
    <link href="assets/css/lib/owl.carousel.min.css" rel="stylesheet" />
    <link href="assets/css/lib/owl.theme.default.min.css" rel="stylesheet" />
    <link href="assets/css/lib/weather-icons.css" rel="stylesheet" />
    <link href="assets/css/lib/menubar/sidebar.css" rel="stylesheet">
    <link href="assets/css/lib/bootstrap.min.css" rel="stylesheet">
    <link href="assets/css/lib/unix.css" rel="stylesheet">
    <link href="assets/css/style.css" rel="stylesheet">
</head>

<body>

   
   
   
     <?php include("sidebar.php"); ?>
	
	
    <!-- /# sidebar -->
     <?php include("top.php"); ?>
	<!-- /# topebar --> 
	
	
	
    <div class="content-wrap">
        <div class="main">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-8 p-r-0 title-margin-right">
                        <div class="page-header">
                            <div class="page-title">
                                <h1>Hello, <span>Welcome Here</span></h1>
                            </div>
                        </div>
                    </div>
                    <!-- /# column -->
                    <div class="col-lg-4 p-l-0 title-margin-left">
                        <div class="page-header">
                            <div class="page-title">
                                <ol class="breadcrumb text-right">
                                    <li><a href="#">Dashboard</a></li>
                                    <li class="active">Home</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                    <!-- /# column -->
                </div>
                <!-- /# row -->
				
					<?php if ($user_type==1 OR $user_type==4 OR $user_type==5){ ?>
                <section id="main-content">
				
				
			
				
				
				
				
				
				<div class="row">
				
				        <div class="col-lg-12">
						
						<div class="panel panel-info m-t-15">
                                            <div class="panel-heading">Payments</div>
                                            <div class="panel-body">
						
                          
     



	 

	<?php 

	if (isset($_POST['submit'])) {
									  
									  $sub=$_POST['sub'];
									  
									   
									 
									  if($sub=='1')
										  
										  {
											  
											 $new_id=$_POST['id'];
											  $new_date=$_POST['date'];
											  $new_amount=$_POST['amount'];
											  $new_mr=$_POST['mr_no'];
											  $new_method=$_POST['method'];
											  $new_details=$_POST['details'];
											  $new_updated_by=$ad_id;
												  
												  
												  
											   $sqlUpdate = "UPDATE transactions SET
                                                  date = '$new_date',
												  amount = '$new_amount',
												   mr_no = '$new_mr',
												    method = '$new_method',
													 details = '$new_details',
												   updated_by = '$new_updated_by',
												   updated_at = '$date_c'
												 
												  
												  
                                                

                                            WHERE
                                                  id = '$new_id'           
                     ";
					 
					                           											   
               
                             /* echo $sqlUpdate;
              exit;*/

                                            $sqlUpdated = mysqli_query($connection, $sqlUpdate); 
											
											
											
$sqlUpdate = "INSERT INTO `activity_log` (`id`, `user`, `activity`, `time`) VALUES (NULL, '$ad_id', 'payment / transaction $new_id updated from payment list page, MR NO $new_mr ', '$date_c')";
$sqlUpdate = mysqli_query($connection, $sqlUpdate); 
											
											
											 
											 echo "<div>
											 </br>
											 </div>";
											 include_once('updated.html'); 
										  }
										  
										  if($sub=='3') {
											  $del_id=$_POST['del_id'];
											
										      $sqlUpdate = "INSERT INTO transactions_deleted
  SELECT * FROM transactions where id = '$del_id'	           
";
$sqlUpdate = mysqli_query($connection, $sqlUpdate); 		
												  
												  
											   $sqlrmv = "DELETE FROM `transactions` WHERE `transactions`.`id` = '$del_id';";
											   
											   $sqlinsert = mysqli_query($connection, $sqlrmv); 
											  
											 echo "<div>
											 </br>
											 </div>";
											 include_once('updated.html');
					                        }
										  
	}
	
	
	
	
	
							if ($action=="edit") { 
							
							?>
								
								<?php if ($user_type==1){ ?>
								
								 <div class="">
                                    <div class="table-responsive">
                                        <table id="" class="table table-striped table-bordered">
                                            <thead>
                                                <tr>
                                                    <th>Date</th>
													 <th>MR NO</th>
													  <th>Method</th>
													 <th>Details</th>
													   <th>Amount</th>
												  
													
													  
													<th>Save</th>
                                                </tr>
                                            </thead>
                                            <tbody>
											
											<?php
											
						
                        
		  						

						$sqlSelectedLG = "SELECT * FROM `transactions` where id='$eid' ";

$sqlSelectedLG = mysqli_query($connection, $sqlSelectedLG);
while ($list = mysqli_fetch_object($sqlSelectedLG)) {

                                    
                                   
                                     $idn = $list->id;
								    
									
									
									
                                    $date = $list->date;
									   $amount = $list->amount;
									    $mr_no = $list->mr_no;
										$method = $list->method;
										$details = $list->details;
									   
								
                                    
                                   
                                ?>
											
											
											
											
                                                <tr> <form action="payments.php" id='edit' method="post">
                                                 
                                                    <td><input type='text' name='date' value='<?php echo $date;  ?>'></td>
													 <td><input type='text' name='mr_no' value='<?php echo $mr_no;  ?>'></td>
                                                     <td>
													 <select name="method" placeholder="payment method">
											    <option value="<?php echo $method;  ?>"> <?php echo $method;  ?></option>
											   <option value="cash"> cash </option>
											   <option value="bkash"> bkash </option>
											   <option value="cheque"> cheque </option>
											   <option value="bank"> bank </option>
											   <option value="card"> card </option>
											   </select>
													 
													 </td>
													   <td><input type='text' name='details' value='<?php echo $details;  ?>'></td>
													     <td><input type='text' name='amount' value='<?php echo $amount;  ?>'></td>
												
                                                  
												
														 
															 	
													<td>     <input type='hidden' name='sub' value='1'>
													      <input type='hidden' name='id' value='<?php echo $idn;  ?>'>
													<button class="btn btn-success btn-md" type="submit" name="submit"><i class="ti-save"></i></button> 
											
													</td>
													
													</form>
                                                </tr>
                                                
			
		<?php } ?>																
<?php } ?>			
												
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
								
								
								<?php } ?>	




								  	<div class="row-form clearfix">
					       <form action='payments.php'  method='POST'>   


						   <div class="col-sm-10"> 
						   
							<table>
							<tr>
							<td>
							From <input class="date" type="date" value="<?php echo $dayBookDate1; ?>" name="date1" id="datetimepicker2"/>
							</td>
							<td>
							To <input class="date" type="date"  value="<?php echo $dayBookDate2; ?>" name="date2" id="datetimepicker2"/>
							</td>
							<td>
							<input class="submit" type="submit"  name="day_submit"  value="Search" /> 
							</td>
							</tr>
							</table>
						    
						   </div>
						     
							
							
							 <div class="col-sm-2">  <div class="span3">  <a href="payment_deleted.php"> <span class="badge badge-danger"><i class="ti-trash"></i></span></a> 
							 </div>  </div>
							 
						</form>	
                     </div> 







							 


                                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card alert">
                                <div class="bootstrap-data-table-panel">
                                    <div class="table-responsive">
                                        <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
                                            <thead>
                                                <tr>
                                                    <th>Date</th>
													  <th>Booking ID</th>
														<th>MR NO.</th>
                                                   	<th>Method</th>
												<th>Details</th>
                                                    <th>Amount</th>
                                                    <th>Edited By</th>
													
													<th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
											
											
											
											<?php
                        
						$sqlSelectedLG = "select f1.* , f2.name from (SELECT t1.*,t2.booking_id FROM `transactions` as t1 left join bookings as t2 on t1.temp_booking_id=t2.id) as f1 left join users as f2 on f1.updated_by = f2.id  where f1.date BETWEEN '$dayBookDate1' AND '$dayBookDate2' order by f1.date desc";
						
						if($sub=="2")
								{$sqlSelectedLG = "select f1.* , f2.name from (SELECT t1.*,t2.booking_id FROM `transactions` as t1 left join bookings as t2 on t1.temp_booking_id=t2.id) as f1 left join users as f2 on f1.updated_by = f2.id  where f1.date BETWEEN '$dayBookDate1' AND '$dayBookDate2' order by f1.date desc";}
						

$sqlSelectedLG = mysqli_query($connection, $sqlSelectedLG);
while ($list = mysqli_fetch_object($sqlSelectedLG)) {

                                    $tempb_id = $list->temp_booking_id;
                                   
                                    $idn = $list->id;
								    $date = $list->date;
									$booking_id = $list->booking_id;
									$mr_no = $list->mr_no;
									$amount = $list->amount;
									$updated_by = $list->name;
									$method = $list->method;
								$details = $list->details;
									
									     
										 	
											   
                                  
								
                                    
                                   
                                ?>
											
											
											
											
											
											
											
											
											
                                                <tr>
                                                    <td><?php echo $date;  ?></td>
													
                                                  <td><a href="booking_details.php?id=<?php echo $tempb_id;  ?>" target="_blank"> <?php echo $booking_id;  ?></a></td>
													 <td><?php echo $mr_no;  ?></td>
													  <td><span class="badge badge-success"><?php echo $method;  ?></span></td>
													   <td><?php echo $details;  ?></td>
                                                    <td><?php echo $amount;  ?></td>
                                                    <td><?php echo $updated_by;  ?></td>
													<td>	
													<?php if ($user_type==1){ ?>
													<form action='payments.php' method='post'> <a href='payments.php?action=edit&id=<?php echo $idn;  ?>'><button class="btn btn-success btn-md" type="button"><i class="ti-pencil-alt"></i></button>  </a>
												
													<input type='hidden' name='sub' value='3'>
													<input type='hidden' name='del_id' value='<?php echo $idn;  ?>'>
													<button class="btn remove btn-danger btn-md" onclick="return confirm('Are you sure you want to Remove?');" type="submit" name='submit' ><i class="ti-close"></i></button> 
													
														<a href="print_receipt.php?id=<?php echo $idn;  ?>" target="_blank">	 <i class="ti-printer"></i>    </a> 
													
												   </form>
													<?php } ?>   
													
													<?php if ($user_type==5 OR $user_type==4){ ?>
													<a href="print_receipt.php?id=<?php echo $idn;  ?>" target="_blank">	 <i class="ti-printer"></i>    </a> 
													<?php } ?>   
													</td>
                                                </tr>
<?php } ?>       
											
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                            <!-- /# card -->
                        </div>
                        <!-- /# column -->
                    </div>

                                   


							 </div> </div>
							
                        </div>
				
				
                        <!-- /# column -->
                        
                    </div>
				
				
				
				
				
				
				   
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
                    <!-- /# row -->
                     <?php include("footer.php"); ?>
                </section>
				
				
				<?php } ?>
            </div>
        </div>
    </div>

    <div id="search">
        <button type="button" class="close">×</button>
        <form action="search.php">
            <input type="search" name="search" value="" placeholder="type keyword(s) here" />
            <button type="submit" class="btn btn-primary">Search</button>
        </form>
    </div>


    </div>
    <script src="assets/js/lib/jquery.min.js"></script>
    <!-- jquery vendor -->
    <script src="assets/js/lib/jquery.nanoscroller.min.js"></script>
    <!-- nano scroller -->
    <script src="assets/js/lib/menubar/sidebar.js"></script>
    <script src="assets/js/lib/preloader/pace.min.js"></script>
    <!-- sidebar -->
    <script src="assets/js/lib/bootstrap.min.js"></script>
    <!-- bootstrap -->
   
    <script src="assets/js/scripts.js"></script>
	
	 <script src="assets/js/lib/data-table/datatables.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.dataTables.min.js"></script>
    <script src="assets/js/lib/data-table/dataTables.buttons.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.flash.min.js"></script>
    <script src="assets/js/lib/data-table/jszip.min.js"></script>
    <script src="assets/js/lib/data-table/pdfmake.min.js"></script>
    <script src="assets/js/lib/data-table/vfs_fonts.js"></script>
    <script src="assets/js/lib/data-table/buttons.html5.min.js"></script>
    <script src="assets/js/lib/data-table/buttons.print.min.js"></script>
    <script src="assets/js/lib/data-table/datatables-init.js"></script>
</body>

</html>