1#@!#!123s

: / home3 / encodto1 / aviscollection.com / admin /
Filename : manage-sub-category.php
back
<?php 
include'config.php';
include'function.php';

$action = $_GET['action'];
$action_title = stringModify($action);

$item_name = '';
$item_gender = '';
$item_category = '';
$item_img = '';
$item_status = '';

if($action == 'delete_category'){
    $del_id = $_GET['id'];
    $del_cat = mysqli_query($conn, "DELETE FROM `product_sub_category` WHERE sub_category_id = '$del_id'") or mysqli_error($conn);
    if($del_cat){
        echo '<script>alert("Category data deleted.")</script>';
        echo '<script> window.location.href = "product_subCategory.php";</script>';
    }
}

if($action == 'edit_category'){
    $edit_id = $_GET['id'];

    $view_cat = mysqli_query($conn, "SELECT * FROM `product_sub_category` WHERE sub_category_id = '$edit_id'") or mysqli_error($conn);

    while($row = mysqli_fetch_assoc($view_cat)) {
        $item_id = $row['sub_category_id'];
        $item_name = $row['sub_category_name'];
        $item_gender = $row['sub_category_gender'];
        $item_category = $row['product_category'];
        $item_img = $row['sub_category_img'];
        $item_status = $row['sub_category_status'];
    }
}

?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Admin, Manage Product Sub Category| <?php echo $company; ?></title>
<?php include'style.php'; ?>
</head>

<body>
<div id="layout-wrapper">
<?php include'header.php'; ?>
    <div class="main-content">
        <div class="page-content">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0 font-size-18"><?php echo $action_title; ?></h4>

                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="./">Admin</a></li>
                                    <li class="breadcrumb-item active"><?php echo $action_title; ?></li>
                                </ol>
                            </div>

                        </div>
                    </div>
                </div>

                <div class="card">
                    <div class="card-body p-4">
                        <div class="row">
                            <div class="col-lg-8 col-sm-12 col-xs-12">
                                <form action="" method="POST" enctype="multipart/form-data" >
                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Sub(Wear) Category name:</label>
                                        <input class="form-control" type="text" value="<?php echo $item_name; ?>"  id="example-text-input" name="item_name" placeholder="Sub(Wear) Category name" required>
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Wearing for Related Gender:</label>
                                        
                                        <select class='form-control' name='item_gender'>
                                        <option value="">Select Gender</option>
                                        <?php if($item_gender == 'male') { 
                                        echo '<option value="male"  selected="selected">Male</option>
                                        <option value="female" >Female</option>
                                        <option value="kids" >Kids</option>';
                                        }
                                        elseif($item_gender == 'female'){
                                        echo '<option value="male">Male</option>
                                        <option value="female" selected="selected">Female</option>
                                        <option value="kids" >Kids</option>';
                                        }
                                        elseif($item_gender == 'kids'){
                                        echo '<option value="male">Male</option>
                                        <option value="female">Female</option>
                                        <option value="kids" selected="selected">Kids</option>';
                                        }
                                        else{
                                        echo '<option value="male">Male</option>
                                        <option value="female">Female</option>
                                        <option value="kids">Kids</option>'; 
                                        }
                                        ?>
                                        </select>
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">product category:</label>
                                        <?php
                                        $selected = $item_category;
                                        $catList = mysqli_query($conn, "SELECT * FROM product_category");
                                        
                                        echo "<select class='form-control' name='item_category'>
                                        <option value='' >Select Your Category</option>";
                                        if (mysqli_num_rows($catList) > 0) {
                                        while ($cats = mysqli_fetch_array($catList)) {
                                            $cname = $cats['category_name'];
                                            $cgender = $cats['category_gender'];
                                            $cid = $cats['category_id'];
                                            if ($selected == $cid) {
                                                echo '<option value="'.$cid.'" selected>'.$cname.' ('.$cgender.')</option>';
                                            }
                                            else{
                                                echo '<option value="'.$cid.'">'.$cname.' ('.$cgender.')</option>';
                                            }
                                            }
                                            
                                        }
                                            echo "</select>";
                                        ?>
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Category Image:</label>
                                        <input class="form-control" type="file" name="item_img" placeholder="Category Image">
                                    </div>

                                    <div class="mb-3">
                                        <label for="example-text-input" class="form-label">Category status:</label>
                                        <!-- <input type="text" class="form-control" name="item_status" placeholder="" value="<?php echo $item_status;?>"> -->
                                        <?php
                                        if($item_status == 1){
                                           echo '<div class="form-check">
                                            <input class="form-check-input" type="radio" name="item_status" id="flexRadioDefault1" value="1" checked>
                                            <label class="form-check-label" for="flexRadioDefault1">Active</label>
                                        </div>
                                        <div class="form-check">
                                            <input class="form-check-input" type="radio" name="item_status" id="flexRadioDefault2" value="0">
                                            <label class="form-check-label" for="flexRadioDefault2">Inactive</label>
                                        </div>';
                                        }
                                        elseif ($item_status === 0) {
                                            echo '<div class="form-check">
                                            <input class="form-check-input" type="radio" name="item_status" id="flexRadioDefault1" value="1" >
                                            <label class="form-check-label" for="flexRadioDefault1">Active</label>
                                        </div>
                                        <div class="form-check">
                                            <input class="form-check-input" type="radio" name="item_status" id="flexRadioDefault2" value="0" checked>
                                            <label class="form-check-label" for="flexRadioDefault2">Inactive</label>
                                        </div>';
                                        }
                                        else{
                                        echo '<div class="form-check">
                                            <input class="form-check-input" type="radio" name="item_status" id="flexRadioDefault1" value="1" checked>
                                            <label class="form-check-label" for="flexRadioDefault1">Active</label>
                                        </div>
                                        <div class="form-check">
                                            <input class="form-check-input" type="radio" name="item_status" id="flexRadioDefault2" value="0">
                                            <label class="form-check-label" for="flexRadioDefault2">Inactive</label>
                                        </div>';
                                        }?>
                                    </div>

                                    <div class="mt-4">
                                        <div class="btn_div">
                                            <button type="submit" name="<?php echo $action; ?>" class="btn btn-primary w-md btn_manage"><?php echo $action_title; ?></button>
                                        </div>
                                    </div>            
                                </form>
                            </div>
                            <div class="col-lg-4 col-sm-12 col-xs-12">
                                <div class="data_img">
                                    <img src="jewellery-category/<?php echo $item_img; ?>" style="height:200px;width: auto;" alt="<?php echo $item_img; ?>">
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                        
            </div>
        </div>

<?php include'right-sidebar.php'; ?>
<?php include'script.php'; ?>

</body>
</html>

<?php

if (isset($_POST['add_category'])) {
$item_name = $_POST['item_name'];
$item_category = $_POST['item_category'];
$item_gender = $_POST['item_gender'];
$item_status = $_POST['item_status'];
if ($_POST['item_status'] != '') {$item_status = $_POST['item_status'];}
else{ $item_status = 0;}

$uploaddir = 'product-sub-category';
    if(!is_dir($uploaddir)){
        mkdir($uploaddir);
    }
    $item_img = $_FILES['item_img']['name'];
    $item_tmp = $_FILES['item_img']['tmp_name'];
    $item_path = $uploaddir ."/". $item_img;

    if(move_uploaded_file($item_tmp, $item_path)){ echo '<script>alert("Category image uploaded.")</script>';}
    else{echo '<script>alert("Sub Category image not uploaded.")</script>';}

        echo $insrt_item = "insert into product_sub_category() values('', '$item_name', '$item_gender', '$item_category', '$item_img', '$item_status')";
        $run_query = mysqli_query($conn, $insrt_item) or die(mysqli_error($conn));

        if ($run_query){
            echo '<script>alert("Product Category data uploaded.")</script>';
            // echo '<script> window.location.href = "product_category.php";</script>';
        }
        else{
            echo '<script>alert("Product Category data not uploaded.")</script>';
        }
    

}

if (isset($_POST['edit_category'])) {
$item_name = $_POST['item_name'];
$item_category = $_POST['item_category'];
$item_gender = $_POST['item_gender'];
$item_status = $_POST['item_status'];
$itemImg_Condition = '';

    if ($_FILES['item_img']['name'] != '') {
        $item_img = $_FILES['item_img']['name'];
        $itemImg_path = 'product-sub-category/'.$item_img;
        move_uploaded_file($_FILES['item_img']['tmp_name'], $itemImg_path);
        $itemImg_Condition = ", sub_category_img='$item_img'";
    }

    $update_item = "UPDATE `product_sub_category` SET `sub_category_name`='$item_name', `sub_category_gender`='$item_gender', `product_category`='$item_category' $itemImg_Condition,`sub_category_status`='$item_status' WHERE `sub_category_id` = '$edit_id'";
    $run_query = mysqli_query($conn, $update_item) or die(mysqli_error($conn));

    if ($run_query){
        echo '<script>alert("Product Category data edited.")</script>';
        echo '<script> window.location.href = "product_sub_category.php";</script>';
    }
    else{
        echo '<script>alert("Process Failed.")</script>';
    }
}

?>