<?php include 'comman/links.php'; ?>
     <!-- Layout wrapper -->
    <div class="layout-wrapper layout-content-navbar">
      <div class="layout-container">
        <!-- Menu -->
  <?php  include 'comman/sidebar.php'; ?>

        <!-- Layout container -->
        <div class="layout-page">
         <?php include 'comman/header.php';   ?>

          <!-- Content wrapper -->
          <div class="content-wrapper">
            <!-- Content -->

            <div class="container-xxl flex-grow-1 container-p-y">
              <h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">Admin /</span> Product</h4>

              <div class="row">
                <div class="col-md-12">
                  <ul class="nav nav-pills flex-column flex-md-row mb-3">
                    <!-- <li class="nav-item">
                      <a class="nav-link active" href="javascript:void(0);"><i class="bx bx-user me-1"></i> Account</a>
                    </li> -->
                    <!-- <li class="nav-item">
                      <a class="nav-link" href="pages-account-settings-notifications.html"
                        ><i class="bx bx-bell me-1"></i> Notifications</a
                      >
                    </li> -->
                    <!-- <li class="nav-item">
                      <a class="nav-link" href="pages-account-settings-connections.html"
                        ><i class="bx bx-link-alt me-1"></i> Connections</a
                      >
                    </li> -->
                  </ul>
                  <div class="card mb-4">
                    <!-- <h5 class="card-header">Profile Details</h5> -->
                    <!-- Account -->
                    <!-- <div class="card-body">
                      <div class="d-flex align-items-start align-items-sm-center gap-4">
                         <div class="button-wrapper">
                          <label for="upload" class="btn btn-primary me-2 mb-4" tabindex="0">
                            <span class="d-none d-sm-block">Upload new photo</span>
                            <i class="bx bx-upload d-block d-sm-none"></i>
                            <input
                              type="file"
                              id="upload"
                              class="account-file-input"
                              hidden
                              accept="image/png, image/jpeg"
                            />
                          </label>
                          

                          <p class="text-muted mb-0">Allowed JPG, GIF or PNG. Max size of 800K</p>
                        </div>
                      </div>
                    </div> -->
                    <!-- <hr class="my-0" /> -->
                    <!-- <div class="card-body">
                      <form id="pro" method="POST"  ">
                        <div class="row">
                          <div class="mb-3 col-md-6">
                            <label for="firstName" class="form-label">Category select</label>
                            <select id="defaultSelect" name="cat" class="form-select">
                                 <?php

                                    $result = mysqli_query($conn,"SELECT * FROM category");
                                    while($data = mysqli_fetch_array($result))
                                    {
                                    ?>
                                <option hidden >Category select</option>
                                <option value="<?php echo $data['id']; ?>"><?php echo $data['name']; ?></option>
                                <?php
                                }
                                ?>
                                 </select>
                            <input type="text" hidden name="pro" value="pro"> 
                          </div>
                          
                          <div class="mb-3 col-md-6">
                             <div class="mb-3">
                                <label for="defaultSelect" class="form-label"> Sub Category select</label>
                                 <select id="defaultSelect" name="sub" class="form-select">
                                 <?php

                                    $result = mysqli_query($conn,"SELECT * FROM sub_category");
                                    while($data = mysqli_fetch_array($result))
                                    {
                                    ?>
                                <option hidden >Category select</option>
                                <option value="<?php echo $data['id']; ?>"><?php echo $data['name']; ?></option>
                                <?php
                                }
                                ?>
                                 </select>
                          </div>
                             
                          </div>
                         </div>  
                         <div class="row">
                         <div class="mb-3 col-md-12">
                            <label for="">Upload Image</label>
                            <input
                              class="form-control"
                              type="file"
                              id="firstName"
                              name="files"
                              value=" "
                              autofocus
                            />
                          </div>
                          </div> 
                          <div class="row">
                          <div class="mb-3 col-md-6">
                            <label for="defaultSelect" class="form-label">Product Name</label>
                                <input type="text" name="name" class="form-control"  autofocus>
                           </div>
                          
                          <div class="mb-3 col-md-6">
                                 <label for="defaultSelect" class="form-label"> Price</label>
                                 <input type="text" name="price" class="form-control"  autofocus>
                          </div>
                         </div>  
                         <div class="row">
                          <div class="mb-3 col-md-6">
                            <label for="defaultSelect" class="form-label">Product Quantity:</label>
                                <input type="text" name="qty" class="form-control"  autofocus>
                           </div>
                          
                          <div class="mb-3 col-md-6">
                                 <label for="defaultSelect" class="form-label"> Discription</label>
                                 <input type="text" name="dis" class="form-control"  autofocus>
                          </div>
                         </div>  
                         <div class="mt-2">
                          <button type="submit" class="btn btn-primary me-2">Upload</button>
                          <button type="reset" class="btn btn-outline-secondary">Cancel</button>
                        </div>
                      </form>
                    </div> -->
                    <!-- /Account -->
                  </div>
                  <hr>
                    <div class="card">
                    <h5 class="card-header">View Product</h5>
                    <div class="card-body">
                    <div class="table-responsive text-nowrap">
                    <table class="table">
                    <thead>
                    <tr>
                    <th>Id</th>
                    <th>Name</th>
                    <th>Category</th>
                    <th>Sub Category</th>
                    <th>Price</th>
                    <th>Qty</th>
                    <th>Image</th>
                    <!-- <th>Discription</th> -->
                    <th>show on Latest</th>
                    <th>show on Upcomming</th>
                    <th>Actions</th>
                    </tr>
                    </thead>
                    <tbody class="table-border-bottom-0">
                    <?php

                    $result = mysqli_query($conn,"SELECT * FROM product");
                    while($data = mysqli_fetch_array($result))
                    {
                    ?>
                    <td><?php echo $data['id'];   ?></td>
                    <td><?php echo $data['name'];   ?></td>
                    <td><?php 
                    $ids= $data['category'];
                    $sql="SELECT * FROM `category` WHERE  id='$ids' LIMIT 1";
                    $recordss = mysqli_query($conn,$sql);
                    $cat = mysqli_fetch_array($recordss);
                    if(!empty($cat))
                    {
                    echo $cat['name'];
                    }
                    ?></td>
                    <td><?php 
                    $ids= $data['sub_category'];
                    $sql="SELECT * FROM `sub_category` WHERE  id='$ids' LIMIT 1";
                    $recordss = mysqli_query($conn,$sql);
                    $cat = mysqli_fetch_array($recordss);
                    if(!empty($cat))
                    {
                    echo $cat['name'];
                    }
                    ?></td>
                    <td><i class="fas fa-rupee-sign"></i> <?php echo $data['price'];   ?></td>
                    <td><?php echo $data['qty'];   ?></td>
                    <td> 
                    <img src="<?php echo $baseurl.$data['image'];   ?>" alt="Avatar" height="60px" class="rounded-circle" />
                    </td>
                    <!-- <td><?php echo $data['dis'];   ?></td> -->
                    <td> <?php
                    if($data['up']==1)
                    {
                    echo '<a href="comming.php?id='.$data['id'].'&up=0" style="text-decoration:none;"><button type="button" class="btn btn-warning">Added</button> </a> ';
                    }
                    else {
                    echo ' <a href="comming.php?id='.$data['id'].'&up=1"><button type="button" class="btn btn-danger">Remove</button> </a>';
                    }

                    ?>
                    </td></td>
                    <td>
                    <?php
                    if($data['status']==1)
                    {
                    echo '<a href="latest.php?id='.$data['id'].'&status=0" style="text-decoration:none;"><button type="button" class="btn btn-warning">Added</button> </a> ';
                    }
                    else {
                    echo ' <a href="latest.php?id='.$data['id'].'&status=1"><button type="button" class="btn btn-danger">Remove</button> </a>';
                    }

                    ?>
                    </td>
                    <td>
                    <a class="dropdown-item" href="edit_cat.php"
                    ><i class="bx bx-edit-alt  "></i> Edit</a
                    >
                    <a class="dropdown-item" href="javascript:void(0);"
                    ><i class="bx bx-trash  "></i> Delete</a
                    >

                    </div>
                    </td>
                    </tr>
                    <?php

                    }
                    ?>
                    </tbody>
                    </table>
                    </div>
                    </div>
                    </div>
                </div>
              </div>
            </div>
            <!-- / Content -->
<?php include 'comman/footer.php'; ?>