<?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_rate", $where);
  
}
?>

  <!-- Main Sidebar Container -->
 <?php include("sidebar.php");?>

  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1 class="m-0 text-dark">Shipping Rates</h1>
          </div><!-- /.col -->
          <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">Shipping Rates</li>
            </ol>
          </div><!-- /.col -->
        </div><!-- /.row -->
      </div><!-- /.container-fluid -->
      <div class="container">
        <?php 
        $z_a_active = ""; $z_b_active = ""; $z_c_active = ""; $z_d_active = ""; $z_e_active = "";
          if (isset($_GET['zone'])) {
            if ($_GET['zone']=='z_a') {
              $z_a_active = "active";
            }if ($_GET['zone']=='z_b') {
              $z_b_active = "active";
            }if ($_GET['zone']=='z_c') {
              $z_c_active = "active";
            }if ($_GET['zone']=='z_d') {
              $z_d_active = "active";
            }if ($_GET['zone']=='z_e') {
              $z_e_active = "active";
            }
          }
        ?>
        <a href="rates.php?zone=z_a" class="btn btn-outline-primary btn-sm pl-4 pr-4 mr-5 <?php echo $z_a_active; ?>">Zone - A</a>
        <a href="rates.php?zone=z_b" class="btn btn-outline-primary btn-sm pl-4 pr-4 mr-5 <?php echo $z_b_active; ?>">Zone - B</a>
        <a href="rates.php?zone=z_c" class="btn btn-outline-primary btn-sm pl-4 pr-4 mr-5 <?php echo $z_c_active; ?>">Zone - C</a>
        <a href="rates.php?zone=z_d" class="btn btn-outline-primary btn-sm pl-4 pr-4 mr-5 <?php echo $z_d_active; ?>">Zone - D</a>
        <a href="rates.php?zone=z_e" class="btn btn-outline-primary btn-sm pl-4 pr-4 mr-5 <?php echo $z_e_active; ?>">Zone - E</a>
      </div>
    </div>
    <!-- /.content-header -->

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <!-- Small boxes (Stat box) -->
        <!-- /.row -->
        <!-- Main row -->
        <div class="row">
          <div class="col-md-12">
             <div class="card">
              <div class="card-header">
                <?php if(isset($_GET['zone'])){ ?>
                <h3 class="card-title float-right"><a href="add_rate.php?zone=<?php echo $_GET['zone']; ?>" class="btn btn-info float-right">Add Rate</a></h3>
                <?php }else{ ?>
                <h3 class="card-title float-right"><a href="add_rate.php" class="btn btn-info float-right">Add Rate</a></h3>
                <?php } ?>
              </div>
              <!-- /.card-header -->
              <div class="card-body">
                
                <table id="example1" class="table table-bordered table-striped">
                  <thead>
                    <?php
                     if(!empty($_GET['a'])){
                        echo  $msg="<div class='alert alert-success'><strong>Delete Succesfully</strong></div>";
                        echo "<script type='text/javascript'>
                               var timer = setTimeout(function() {
                                     window.location='rates.php'
                                    },1000);
                              </script>";
                      }
                    ?>
                  <tr>
                    <th>S.No</th>
                    <th>Zone</th>
                    <th>Weight(Kg)</th>
                    <th>Rate(₹)</th>
                    <th>Action</th>
                  </tr>
                  </thead>
                  <tbody>
                <?php
                $where = array('zone' =>$_GET['zone']);
                $query=$sel_obj->select_where('tbl_rate', $where);
                // print_r($query);
                $keys = array_column($query, 'weight');
                array_multisort($keys, SORT_ASC, $query);
                $a=0;
                if(is_array($query) || !empty($query))
                {
               foreach ($query as $data )
                {
                 ?>
                  <tr>
                    <td><?php echo $a+1;?></td>
                    <td><?php echo $data['zone'];?></td>
                    <td><?php echo $data['weight'];?></td>
                    <td><?php echo $data['prepaid_cost'];?></td>
                    <td class="td_alignvertical"> <a href="add_rate.php?edit=1&post_id=<?php echo $data['id']; ?>" class="btn btn-sm btn-info" data-toggle="tooltip" data-original-title="Edit"><i class="fa fa-edit"></i></a> | <a href="?zone=<?php echo $_GET['zone']; ?>&&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>
              <!-- /.card-body -->
            </div>
          </div>
        </div>
        <!-- /.row (main row) -->
      </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
  </div>
  <!-- /.content-wrapper -->
 <?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>