<?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> Service</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="ser" method="POST"  ">
                        <div class="row">
                          <div class="mb-3 col-md-6">
                             
                            <label for="defaultSelect" class="form-label">Category select</label>
                                 <select id="cate" 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="ser" value="ser"> 
                          </div>
                          <div class="mb-3 col-md-6">
                          <label for="defaultSelect" class="form-label">Sub Category select</label>
                                 <select id="show2" name="sub" class="form-select">
                                 <?php

                                    $result = mysqli_query($conn,"SELECT * FROM sub_category");
                                    while($data = mysqli_fetch_array($result))
                                    {
                                    ?>
                                <option hidden >Sub Category select</option>
                                <option value="<?php echo $data['id']; ?>"><?php echo $data['name']; ?></option>
                                <?php
                                }
                                ?>
                                 </select>
                            
                          </div>
                         </div>  
                         <div class="row">
                          <div class="mb-3 col-md-6">
                          
                            <label for="">Title</label>
                                <input
                                class="form-control"
                                type="text"
                                id="firstName"
                                name="title"
                                value=" "
                                autofocus
                                />
                          
                             
                          </div>
                          <div class="mb-3 col-md-6">
                          
                            <label for="">Upload Image</label>
                                <input
                                class="form-control"
                                type="file"
                                id="firstName"
                                name="files"
                                value=" "
                                autofocus
                                />
                          
                             
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                                <label for="">Description</label>
                                 <textarea name="dis" class="form-control"></textarea>
                            </div>
                          </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 Service</h5>
                    <div class="card-body">
                    <div class="table-responsive text-nowrap">
                  <table class="table">
                    <thead>
                      <tr>
                        <th>Id</th>
                        <th>Sub_Category Name</th>
                        <th>Category Name</th>
                        <th>Title</th>
                        <th>Image</th>
                        <th>Description</th>
                        <!-- <th>Status</th> -->
                        <th>Actions</th>
                      </tr>
                    </thead>
                    <tbody class="table-border-bottom-0">
                        <?php
                              $count=1;
                        $result = mysqli_query($conn,"SELECT * FROM service");
                        while($data = mysqli_fetch_array($result))
                        {
                         ?>
                      <td><?php echo  $count;   ?></td>
                      <td><?php 

                        $ids= $data['sub'];
                        $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><?php 

                        $ids= $data['cat'];
                        $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>   
                         <span class="badge bg-success"><?php echo $data['title']  ?></span>
                        </td>
                      <td> 
                        <img src="<?php echo $data['image'];   ?>" alt="Avatar" height="60px" class="rounded-circle" />
                        </td>
                     <td><textarea class="form-control" id="w3review" name="w3review">
                     <?php echo $data['dis'];   ?>
                    </textarea>
                        </td>
                        <td>
                               <a class="dropdown-item" href="edit_service.php?id=<?php echo $data['id']  ?>"
                                ><i class="bx bx-edit-alt  "></i> Edit</a
                              >
                              <a onclick="dle('<?php echo $data['id']  ?>')" class="dropdown-item" href="javascript:void(0);"
                                ><i class="bx bx-trash  "></i> Delete</a
                              >
                            
                          </div>
                        </td>
                      </tr>
                      <?php
 $count++;
                        }
                    ?>
                    </tbody>
                  </table>
                </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
            <!-- / Content -->
<?php include 'comman/footer.php'; ?>
<script>
  function dle(id)
  {
    swal({
  title: "Are You Want To Delete?",
//   text: "Are you want to delete!",
  icon: "warning",
  buttons: true,
  dangerMode: true,
})
.then((willDelete) => {
  if (willDelete) {
            window.location = "service_dl.php?id="+id;
    swal("Poof! Your imaginary file has been deleted!", {
      icon: "success",
    });
  } else {
    swal("Your imaginary file is safe!");
  }
});
    
    
        
  }
</script>
<script type="text/javascript">
      $(document).ready(function(){
            $('#cate').change(function(){
                var id=$(this).val();
               
           $.ajax({
                      url:'sub_cate.php',
                      type: "POST",
                      data:{ id:id},
                      cache: false,
                      success: function(data)
                      {
                        // alert(data);
                           $("#show2").html(data);
                      }
                  });
            })
        });
    </script>
<script>
	   $(document).ready(function(){
		   $('#ser').unbind().submit(function(e){
			   e.preventDefault();
			   var data=document.getElementById('ser');
				var formdata= new FormData(data);
  				$.ajax({
					   type: "POST",
					   url: "lp.php",
					   data: formdata,
					   processData: false,
					   contentType: false,
					   cache: false,
					   success: function (data) 
					   {
						   if(data==1)
						   {
                swal({
                title: "Good job!",
                text: "Service Added!",
                icon: "success",
              }).then(function() {
                                    window.location = "service.php";
                                });
                                                
							 
						   }
						   else
						   {
								 alert(data);
						   }
					 
					   }
				   });
		   })
	   })
    </script>