<!DOCTYPE html>
<html>
  <?php
	 include"includes/admin_header.php";
	 ?>
	 <link rel="stylesheet" href="<?php echo base_url();?>assets/adminlte/plugins/datatables/dataTables.bootstrap.css">
  <body class="hold-transition skin-blue sidebar-mini">
    <div class="wrapper">

      <!-- Left side column. contains the logo and sidebar -->
     <?php
	 include"includes/admin_sidebar.php";
	 ?>

      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper cnt-wr-1">
        <!-- Content Header (Page header) -->
        <section class="content-header">
          <h1>
            Point To Point Transfer Details
          </h1>
          <ol class="breadcrumb">
            <li><a href="<?php echo base_url();?>admin/dashboard"><i class="fa fa-dashboard"></i> Home</a></li>
            <li><a href="#">VBD</a></li>
            <li class="active">Assign Driver</li>
          </ol>
        </section>

        <!-- Main content -->
        <section class="content">
          <div class="row">
            <div class="col-xs-12">
              

              <div class="box">
                <div class="box-header">
                
                </div><!-- /.box-header -->
                <div class="box-body">
                  <table id="example1" class="table table-bordered table-striped tbl_package tbl_package1">
  <?php
								$query = $this->db->query(" SELECT * FROM `settings` order by id DESC ");
								$row = $query->row('settings');
						
								$str = $row->currency;
								$s = explode(',',$str);
								$paypal =$row->paypal_option;
								$s="";
								if($paypal=='PayPal'){
								$s = "and item_status='Completed'";
								}
									$status='Booking';	
								
								 // $query1 = $this->db->query("SELECT * FROM  bookingdetails WHERE purpose='Point to Point Transfer'  and status='$status' and (item_status='Completed' or item_status='')  ORDER BY id DESC");

                  $query1 = $this->db->query("SELECT * FROM bookingdetails WHERE purpose='Point to Point Transfer' and status='$status' and assigned_for='0' and item_status='Completed' ORDER BY id DESC");
								?>
                                
                                    <thead>
                                        <tr>
                                            <th>ID</th>
                                            <th>From</th>
                                            <th>To</th>
                                             <th>Date</th>
                                             <th>Status</th>
                                            <th>Action</th>
                                           
                                        </tr>
                                    </thead>
                                    <tbody>
                                     <?php
		
       foreach($query1->result_array('userdetails') as $row1){
        ?>
                                    
                                        <tr class="odd gradeX" >
                                            <td class="center"> <?php echo $row1['uneaque_id'];?></td>
                                            <td class="center"> <?php echo $row1['pickup_area'];?></td>
                                            <td class="center"> <?php echo $row1['drop_area'];?></td>
                                            <td class="center"> <?php echo $row1['pickup_date'];?></td>
                                            <td class="center"> <?php echo $row1['status'];?></td>
                                            <td class="center"><a href="<?php echo base_url();?>admin/edit_point?id3=<?php echo $row1['id'];?>"><i class="fa fa-pencil-square-o"></i></a>&nbsp;&nbsp;<a href="#" title="<?php echo $row1['id'];?>" class="delete"><i class="fa fa-trash-o "></i></a></td>
                                        </tr>
                                       <?php
	   }
									?> 
                   
                  </table>
                </div><!-- /.box-body -->
              </div><!-- /.box -->
            </div><!-- /.col -->
          </div><!-- /.row -->
        </section><!-- /.content -->
      </div><!-- /.content-wrapper -->
     <?php
	 include"includes/admin-footer.php";
	 ?>

   
    </div><!-- ./wrapper -->

    <!-- jQuery 2.1.4 -->
    <script src="<?php echo base_url();?>assets/adminlte/plugins/jQuery/jQuery-2.1.4.min.js"></script>
    <!-- Bootstrap 3.3.5 -->
    <script src="<?php echo base_url();?>assets/adminlte/bootstrap/js/bootstrap.min.js"></script>
    <!-- DataTables -->
    <script src="<?php echo base_url();?>assets/adminlte/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="<?php echo base_url();?>assets/adminlte/plugins/datatables/dataTables.bootstrap.min.js"></script>
    <!-- SlimScroll -->
    <script src="<?php echo base_url();?>assets/adminlte/plugins/slimScroll/jquery.slimscroll.min.js"></script>
    <!-- FastClick -->
    <script src="<?php echo base_url();?>assets/adminlte/plugins/fastclick/fastclick.min.js"></script>
    <!-- AdminLTE App -->
    <script src="<?php echo base_url();?>assets/adminlte/dist/js/app.min.js"></script>
    <!-- AdminLTE for demo purposes -->
    <script src="<?php echo base_url();?>assets/adminlte/dist/js/demo.js"></script>
    <!-- page script -->
    <script>
      $(function () {
        $("#example1").DataTable({
			"ordering": false
			});
        
      });
    </script>
	

   
<script>
$(function () {
 $(document).on('click',"#example1 .delete",function(){
        
		
		
			var r = confirm("Are you sure want to delete the Booking details ");
			if (r == true) {
				var th=$(this);			
				var id = $(this).attr('title');
				
				
				$.ajax({
					url:'<?php echo base_url();?>admin/bookingdelete',
					type:'post',
					data:{'id':id},
					success:function(cancel){
						console.log(cancel);
						if(cancel==1){
							th.hide();
							location.reload();
					
						}
						else{
						  alert("err");
						}
					}
				});  								
			}

        });	

});	

    </script>






  </body>
</html>