<?php
include("include/connection.php");
if($_POST['submit']!='')
 {
  $bannertupe= $_POST['bname'];
  $Status= $_POST['Status'];
   function clean($string) {
  $string = str_replace(' ', '-', $string); // Replaces all spaces with hyphens.
  return preg_replace('/[^A-Za-z0-9\-]/', '', $string); // Removes special chars.
}
$slug=clean($bannertupe);
  

        date_default_timezone_set("Asia/Kolkata");
        $brand_creation_date = Date('Y-m-d H:i:s');
             $sql1 = "INSERT INTO category(cat_name,status,create_date,slug) VALUES('$bannertupe','$Status','$brand_creation_date','$slug')";
            if(mysqli_query($con,$sql1)){
               // echo 'dfffjk';
                $_SESSION['status'] = "Add Banner Successfully";
                $_SESSION['status_code'] = "success";
                header("location:category.php");
            }
        }

if($_POST['Update']!='')
 {
    $sub_cat_arr=$_POST['cat']; //exit;
    //print_r($sub_cat_arr);exit;
    foreach($sub_cat_arr as $sub_cat_id=>$sub_cat_det)
    {
       
        $cat_name=addslashes(trim($sub_cat_det['cat_name'])); //exit;
        $slug=addslashes(trim($sub_cat_det['slug'])); //exit;
        $status=trim($sub_cat_det['status']);
        
     
     $upd ="update category set cat_name='$cat_name',status='$status',slug='$slug' where id='$sub_cat_id'";
     
     $rsc_upd=mysqli_query($con,$upd);
    }
    
 }    

 $qry_all="SELECT * FROM category ";
	                            $rsc_all=mysqli_query($con,$qry_all);
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <?php include("element/css_js.php"); ?>
</head>

<body class="hold-transition dark-mode sidebar-mini layout-fixed layout-navbar-fixed layout-footer-fixed">
    <div class="wrapper">
        <!-- Preloader -->
        <?php include("element/header.php"); ?>
        <!-- Main Sidebar Container -->
        <?php include("element/menu.php"); ?>
        <!-- Content Wrapper. Contains page content -->
        <div class="content-wrapper">
            <!-- Content Header (Page header) -->
            <section class="content-header">
                <div class="container-fluid">
                    <div class="row mb-2">
                        <div class="col-sm-6">
                            <h1>Manage  Service</h1>
                        </div>
                        <div class="col-sm-6">
                            <ol class="breadcrumb float-sm-right">
                                <li class="breadcrumb-item"><a href="#">Home</a></li>
                                <li class="breadcrumb-item active"> Menu</li>
                            </ol>
                        </div>
                    </div>
                </div><!-- /.container-fluid -->
            </section>
            <!-- Main content -->
            <section class="content">
                <div class="container-fluid">
                    <div class="row">
                        <!-- left column -->
                        <div class="col-md-12">
                            <!-- general form elements -->
                            <div class="card card-primary">
                                <div class="card-header">
                                    <h3 class="card-title">Service</h3>
                                </div>
                                <!-- /.card-header -->
                                <!-- form start -->
                                <form method="post" enctype="multipart/form-data">
                                    <div class="card-body">

                                        <div class="row">
                                            <div class="col-md-12">
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-md-3">
                          <div class="form-group">
                            <label for="exampleInputEmail1"> Service Name</label>
                            <input type="text" class="form-control" id="bname" name="bname" placeholder="service Name">
                          </div>
                     </div>
                                            
                                            <div class="col-md-3">
                                                <div class="form-group">
                                                    <label for="exampleInputEmail1">Status</label>
                                                    <select class="form-control" id="Status" name="Status">
                                                        <option value="">Select</option>

                                                        <option value="1"> Active</option>
                                                        <option value="0"> Deactive</option>

                                                    </select>
                                                </div>
                                            </div>
                                            <!-- /.card-body -->

                                            <div class="card-footer">
                                                <input type="submit" value="Submit" name="submit" class="btn btn-primary">
                                            </div>






                                        </div>

                                        <div class="filter-container p-0 row">
                                            <div class="filtr-item col-sm-2" data-category="1" data-sort="white sample">

                                                <img src="" id="thumb" src="" width="150px" class="img-fluid mb-2" />

                                            </div>



                                        </div>

                                    </div>
                                </form>
                                <?php if (mysqli_num_rows($rsc_all) > 0) { ?>
                                    <form method="post">
                <div class="card-body">
                    View Sub Category
                    <table class="table">
                        <tr>
                            <th>Sr. No. </th>
                            <th>Category</th>
                            <th>Slug</th>
                            <th>Status </th>
                            <th>Delete </th>
                        </tr>
                    <?php $i=1;
                    while($record = mysqli_fetch_assoc($rsc_all)) { ?>
                    <tr>
                            <th><?php echo $i++; ?> </th>
                            <th>
                            <input type="text" class="form-control" id="sub_cat_name<?php echo $record['id']; ?>" name="cat[<?php echo $record['id']; ?>][cat_name]" placeholder="Category name" value="<?php echo $record['cat_name']; ?>">
                            </select>
                            </th>
                            <th><input type="text" class="form-control" id="sub_cat_name<?php echo $record['id']; ?>" name="cat[<?php echo $record['id']; ?>][slug]" placeholder="Sub Category Name" value="<?php echo $record['slug']; ?>"> </th>         
                            
                            <th>
                                <select name="cat[<?php echo $record['id']; ?>][status]" id="sub_cat_active<?php echo $record['id']; ?>" class="form-control">
                                <option value="1" <?php if($record['status']=='1') { echo "selected";} ?>>Active</option>
                                <option value="0" <?php if($record['status']=='0') { echo "selected";} ?>>De-Active</option>
                                </select>
                           </th>
                            <th class="Officer"><a href="delete_cat.php?id=<?php echo $record['id']; ?>" class="btn btn-danger"><i class="fa-solid fas fa-trash"></i></a></th>
                        </tr>
                    <?php } ?>
                    </table>
                    <button type="submit" name="Update" value="update" class="mt-2 btn btn-primary">Update</button>
                    </div>
              </form>
                                <?php } ?>
                            </div>
                        </div>
                    </div>
                </div>
            </section>
        </div>
        <!-- /.content-wrapper -->
        <footer class="main-footer">
            <strong>Copyright &copy; 2021-2022 <a href="#">Admin Koscove</a>.</strong>
            All rights reserved.
            <div class="float-right d-none d-sm-inline-block">
                <!--<b>Version</b> 3.1.0-->
            </div>
        </footer>

        <!-- Control Sidebar -->
        <aside class="control-sidebar control-sidebar-dark">
            <!-- Control sidebar content goes here -->
        </aside>
        <!-- /.control-sidebar -->
    </div>
    <!-- ./wrapper -->

    <!-- jQuery -->
    <script src="plugins/jquery/jquery.min.js"></script>
    <!-- jQuery UI 1.11.4 -->
    <script src="plugins/jquery-ui/jquery-ui.min.js"></script>
    <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip -->
    <script>
        $.widget.bridge('uibutton', $.ui.button)
    </script>
    <!-- Bootstrap 4 -->
    <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
    <!-- ChartJS -->
    <script src="plugins/chart.js/Chart.min.js"></script>
    <!-- Sparkline -->
    <script src="plugins/sparklines/sparkline.js"></script>
    <!-- JQVMap -->
    <script src="plugins/jqvmap/jquery.vmap.min.js"></script>
    <script src="plugins/jqvmap/maps/jquery.vmap.usa.js"></script>
    <!-- jQuery Knob Chart -->
    <script src="plugins/jquery-knob/jquery.knob.min.js"></script>
    <!-- daterangepicker -->
    <script src="plugins/moment/moment.min.js"></script>
    <script src="plugins/daterangepicker/daterangepicker.js"></script>
    <!-- Tempusdominus Bootstrap 4 -->
    <script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
    <!-- Summernote -->
    <script src="plugins/summernote/summernote-bs4.min.js"></script>
    <!-- overlayScrollbars -->
    <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script>
    <!-- AdminLTE App -->
    <script src="dist/js/adminlte.js"></script>
    <!-- AdminLTE for demo purposes -->
    <script src="dist/js/demo.js"></script>
    <!-- AdminLTE dashboard demo (This is only for demo purposes) -->
    <script src="dist/js/pages/dashboard.js"></script>
</body>

</html>