<!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> <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>