במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

]]jkjjgdjffksdkdxdsghfghdfghfgdfsdsdfsdfsfdsbcxvxcbccwewqeqwewqskfgj במ12[cxvbcxvbxcvbcxvcxvbcvxcvbsdfsdfsdfsdfsdfsdfxcvbxcvxbbxqwqewqewv;'

<?php include("header.php");
$sel_obj= new config();
?>

<?php 
@$del_id=$_GET['del_id']; 
 if(isset($del_id) and !empty($del_id)){
  $where = array(   
           'id'     =>  $_GET["del_id"] 
      );  
  $sel_obj->delete("tbl_rating", $where);
  
}

if(isset($_GET['update_id']) && $_GET['update_id']!=''){
    $update = array('status'=>$_GET['status']);
    $where_condition = array('id'=>$_GET['update_id']);
    $sel_obj->update("tbl_rating",$update,$where_condition);
}
?>

<?php include("sidebar.php");?>

<div class="content-wrapper">
    
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark"> Rates</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="dashboard.php">Home</a></li>
              <li class="breadcrumb-item active">Product Rating</li>
            </ol>
          </div>
        </div>
      </div>
      <div class="container">
        
      </div>
    </div>

<section class="content">
      <div class="container-fluid">
        
        
        
        <div class="row">
          <div class="col-md-12">
             <div class="card">
              <div class="card-header">
            
              </div>
              
              <div class="card-body">
                
                <table id="example1" class="table table-bordered table-striped">
                  <thead>
                 
                  <tr>
                    <th>S.No</th>
                    <th>User Name</th>
                    <th>Product</th>
                    <th>Rating</th>
                     <th>Comment</th>
                    <th>Status</th>
                    <th>Action</th>
                  </tr>
                  </thead>
                  <tbody>
                    <?php
                    $where = 'user_id!=0 ORDER BY ID DESC';
                    $query=$sel_obj->display_rcd('tbl_rating', $where);
                  
                    if(is_array($query) || !empty($query))
                    {
                    foreach ($query as $data )
                    {
                        $whereUser = 'id='.$data['user_id'];
                        $query_user=$sel_obj->display_rcd('tblusers', $whereUser);
                        if(is_array($query_user) || !empty($query_user))
                        {
                        foreach ($query_user as $data_user )
                        {
                        
                        }
                        }
                        
                        $whereProduct = 'p_id='.$data['product_id'];
                        $query_product=$sel_obj->display_rcd('product', $whereProduct);
                        if(is_array($query_product) || !empty($query_product))
                        {
                        foreach ($query_product as $data_product )
                        {
                        
                        }
                        }
                        
                     ?>
                      <tr>
                        <td><?php echo $a+1;?></td>
                        <td><?php echo $data_user['FullName'];?></td>
                        <td><?php echo $data_product['p_name'];?></td>
                        <td><?php echo $data['rating'];?></td>
                        <td><?php echo $data['comment'];?></td>
                        
                        <td>
                            <?php if($data['status'] == 1):?>
                                
                                <label class="switch"  onclick="functionchange(2,<?php echo $data['id']; ?>)">
                                  <input type="checkbox"  checked >
                                  <span class="slider round"  ></span>
                                </label>
                            <?php else:?>
                                    
                                    <label class="switch" onclick="functionchange(1,<?php echo $data['id']; ?>)">
                                      <input type="checkbox" >
                                      <span class="slider round" ></span>
                                    </label>
                            <?php endif;?>
                        </td>
                        
                        <td class="td_alignvertical">  <a href="?del_id=<?php echo $data['id']; ?>" style="color:#fff;" class="btn btn-danger btn-sm delete_coupon" class="btn btn-danger"><i class="fa fa-trash"></i></a>
    
                        </td>
                      </tr>
                   <?php
                   $a++;
                          }
                        }
                   ?>
                  </tbody>
                 
                </table>
              </div>
              
            </div>
          </div>
        </div>
        
      </div>
    </section>
    
  </div>
  
 <?php include("footer.php");?>
   <script type="text/javascript">
    
    $(document).on('click','.delete_coupon',function(){  
           if(confirm("Are you sure to delete?"))  
           {  
                 return true;
           }  
           else  
           {  
                return false;  
           }  
      });

</script>
  
  <script type="text/javascript">
    
 window.setTimeout(function() {
    $(".alert").fadeTo(1000, 0).slideUp(10, function(){
        $(this).remove(); 
    });
}, 1000);

</script>
  <script>
      function functionchange(status,id){
          window.location.href='?status='+status+'&update_id='+id;
      }
  </script>
  <style>
.switch {
  position: relative;
  display: inline-block;
  width: 60px;
  height: 34px;
}

.switch input { 
  opacity: 0;
  width: 0;
  height: 0;
}

.slider {
  position: absolute;
  cursor: pointer;
  top: 0;
  left: 0;
  right: 0;
  bottom: 0;
  background-color: #f00;
  -webkit-transition: .4s;
  transition: .4s;
}

.slider:before {
  position: absolute;
  content: "";
  height: 26px;
  width: 26px;
  left: 4px;
  bottom: 4px;
  background-color: white;
  -webkit-transition: .4s;
  transition: .4s;
}

input:checked + .slider {
  background-color: #21f33a;
}

input:focus + .slider {
  box-shadow: 0 0 1px #21f33a;
}

input:checked + .slider:before {
  -webkit-transform: translateX(26px);
  -ms-transform: translateX(26px);
  transform: translateX(26px);
}

/* Rounded sliders */
.slider.round {
  border-radius: 34px;
}

.slider.round:before {
  border-radius: 50%;
}
</style>