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

    <body class="fixed-left">
        
        <!-- Begin page -->
        <div id="wrapper">
        
       <?php include 'include/side_menu.php';

        //` $arr_get1 = "status'='Accept' OR status'='Pending'";
        // $where = "status'='Accept' OR status'='Pending'";

                //    $req = $this->db->query("SELECT * FROM user_request WHERE  status='Pending' ORDER BY DESC")->result_array();

  $arr_get1 = ['status !='=>'Pending'];

         $this->db->order_by('id','desc');

         $req = $this->admin_common_model->get_where('plan_request',$arr_get1);
         
     //    $this->db->order_by('id','desc');

     //    $req = $this->admin_common_model->get_where('user_request',$where);

?>


<style>
.custom-select-10 .btn-default{
background-color:#31BFFC;
color:#fff;
width: 120px;
}
.custom-select-10 .dropdown-menu {
    box-shadow: 1px 2px 9px #C5C1C1;     
    min-width: 93px;
}
.btn-default.active, .btn-default:active, .open>.dropdown-toggle.btn-default{
background-color:#31BFFC;
color:#fff;
}
</style>


    <body class="fixed-left">
        
        <!-- Begin page -->
        <div id="wrapper">
        
      

      
            <div class="content-page">
                <!-- Start content -->
                <div class="content">
                    <div class="container">

                        <!-- Page-Title -->
                        <div class="row">
                            <div class="col-sm-12">
                                <h4 class="pull-left page-title">Welcome !</h4>&nbsp;	&nbsp;	
<!--      <a href="<?=base_url('admin/view_page/ExUser?type=pending');?>"><button type="button" class="btn btn-purple waves-effect waves-light" > Export csv</button></a>
-->                               
                                <ol class="breadcrumb pull-right">
                                    <li><a href="<?=base_url('admin/view_page/dashboard');?>">RESA</a></li>
                                    <li class="active">User Plan Request</li>
                                </ol>
                            </div>
                        </div>

                        <!-- Start Widget -->
                
<div class="row">
                            <div class="col-md-12">
                                <div class="panel panel-default">
                                    <div class="panel-heading">
                                        <h3 class="panel-title">JUST REQUESTED , NOT YET BOOKED REQUEST</h3>
                                    </div>
                                    <div class="panel-body">
      
                        <div style="height: 0px;">           <a href="<?=base_url('admin/view_page/user_plan_request_list');?>"><button type="button" class="btn btn-purple waves-effect waves-light" > Refresh</button></a>
</div>
            <div class="datew-times">
        
                                       <div class="col-md-6  col-md-offset-3" style="margin-bottom: 10px;">
                      <div class="col-md-5">
                      <div id="datetimepicker" class="input-append date">
                    <b> From: </b><input type="text" name="to" id="min" placeholder="12-04-2017 12:52 PM" class="form-control">
                      <span class="add-on">
                      <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i>
                      </span>
                      </div>
                      </div>
                      <div class="col-md-5">
                        <div id="datetimepicker_from" class="input-append date">
                    <b> To: </b><input type="text" name="from" id="max" placeholder="12-04-2017 12:52 PM" class="form-control">
                      <span class="add-on">
                      <i data-time-icon="icon-time" data-date-icon="icon-calendar"></i>
                      </span>
                      </div>
                      </div>
          </div>
                                            


                                        </div>


                                        <div class="row">
                                            <div class="col-md-12 col-sm-12 col-xs-12">
                                                <table id="datatable" class="table table-striped table-bordered">
                                                    <thead>
                                                         <tr>
                                                            <th>S.No</th>
                                                            <th>User Name</th>
                                                            <th>User Number</th>
                                                            <th>Plan Name</th>
                                                            <th>Plan Amount</th>
                                                            <th>Plan Day</th>
                                                            <th>Payment By</th>
                                                            <th>Request Status</th>
                                                            <th>Request Created Date</th>
                                                            <th>Action</th>
                                                        </tr>
                                                    </thead>

                                             
                                                   <tbody>

                                              <?php $i=1; foreach($req as $row){ 

                      $username = $this->admin_common_model->get_where('users',['id'=>$row['user_id']]);
                      $plan = $this->admin_common_model->get_where('plan_type',['id'=>$row['plan_id']]);



                                   ?>
                                                        <tr>
                                                            <td><?= $i; ?></td>
                                                            <td><?= $username[0]['first_name']; ?></td>
                                                            <td><?= $username[0]['mobile']; ?></td>
                                                            <td><?= $plan[0]['plan_type']; ?></td>
                                                            <td><?= $plan[0]['amount']; ?></td>
                                                            <td><?= $plan[0]['day']; ?></td>
                                                            <td><?= $row['payment_status']; ?></td>
                                                            <td><?= $row['status']; ?></td>

                                         
                               
                                            
                                      
                                                            
                                                            <td><?= $row['date_time']; ?></td>

                                                            <td class="text-center"> <button class="btn delete-t"><i class="fa   fa-trash-o" onclick="deleteUsers('<?=$row["id"];?>')"></i></button></td>


  

                                                        </tr>
<?php $i++; } ?>


                                                    </tbody>
                                                </table>

                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            
                        </div> <!-- End Row -->

                    </div> <!-- container -->
                               
                </div> <!-- content -->

                <footer class="footer text-right">
                    2018 © RESA.
                </footer>

            </div>
          
        </div>
        <!-- END wrapper -->
<script>
// delete function
function deleteUsers(id)
{
  swal({
  title: "Are you sure?",
  text: "You want to permanently remove this item!",
  type: "warning",
  showCancelButton: true,
  confirmButtonColor: "#DD6B55",
  confirmButtonText: "Yes, delete it!",
  closeOnConfirm: false
},
function(){



        $.ajax({
          url: "<?=base_url('admin/delete_data');?>",
          data: {'table': 'user_request_to_doctor', 'id': id}, // change this to send js object
          type: "POST",
          success: function(result){
            //alert(result);
            swal("Deleted!", "Your selected item has been deleted.", "success");
  
            $('.confirm').click(function(){
               location.reload();
            });
             

          }
        });

  

});

} 
// end delete function

</script>


 <?php include 'include/footer.php';?>
<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>



<script>
     $(document).ready(function(){
        $.fn.dataTable.ext.search.push(
        function (settings, data, dataIndex) {
            var min = $('#min').datepicker("getDate");
            var max = $('#max').datepicker("getDate");
            var startDate = new Date(data[9]);
            if (min == null && max == null) { return true; }
            if (min == null && startDate <= max) { return true;}
            if(max == null && startDate >= min) {return true;}
            if (startDate <= max && startDate >= min) { return true; }
            return false;
        }
        );

       
            $("#min").datepicker({ dateFormat: 'dd-mm-yy' },{ onSelect: function () { table.draw(); }, changeMonth: true, changeYear: true });
            $("#max").datepicker({ dateFormat: 'dd-mm-yy' },{ onSelect: function () { table.draw(); }, changeMonth: true, changeYear: true });
var table = $('#datatable').DataTable({
                "ordering": false,
            });
            // Event listener to the two range filtering inputs to redraw on input
            $('#min, #max').change(function () {
                table.draw();
            });
        });
</script>



<script>

    $('.table-select').change(function () { 

var id = $(this).attr('id');
//alert(id);

//$("#"+id).attr("disabled","disabled");
 
       //for open loader gif
       $(document).on({
         ajaxStart: function() { $(".loading").show(); },
         ajaxStop: function() { $(".loading").hide(); } 
       });

       var getId = $(this).attr('getId');
       var accept_driver_id = $(this).val(); 
       $.post("<?=base_url().'admin/upt_drvr_stts';?>", { accept_driver_id: accept_driver_id, id: getId });
      location.reload();

   
       
    });   

</script>


      
<script>
$('select').change(function () { 
       //for open loader gif
       $(document).on({
         ajaxStart: function() { $(".loading").show(); },
         ajaxStop: function() { $(".loading").hide(); }    
       });

       var getId1 = $(this).attr('getId1');
       var status = $(this).val();
    // alert(getId);
        url = "<?php echo base_url().'admin/upt_driver_stts_request'?>"; 
                $.ajax({
                  type:"POST",
                  url: url, 
                  data: {"id":getId1,"status":status}, 
                  success: function(data) { 
                     
                  location.reload();
            } });

    }); 

</script>
