.-.-.-.-.-

<?php
include 'header.php';
include('../connection.php');
//include '../function_lib.php';
//include('imageresize.php');
?>

    <?php echo getMessage(); ?>

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Product Gallary</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Admin Setting</a></li>
                    <li class="breadcrumb-item active">Product Gallary</li>
                </ol>

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

<div class="row">
        <div class="col-12">
            <div class="card m-b-20">
                <div class="card-body">
                    <form name="form" id="form"  action="product_page_model.php" method="post" enctype="multipart/form-data">

<div class="form-group row">
                            
                            <label class="col-sm-2 col-form-label"  for="product_name">Product Category</label>

                            <div class="col-sm-10">
                                <select name="product_cat" id="product_cat" value="" required="required">
                                    <option value="">Select Product Category</option>
                                    <?php
                                    $result = mysqli_query($connection, "SELECT * FROM `product_cat` WHERE 1");
                                    while ($row = mysqli_fetch_object($result)) {
                                        ?>
                                        <option value="<?php echo $row->cat_id; ?>"><?php echo $row->name; ?></option>
                                        <?php
                                    }
                                    ?>
                                </select>
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="product_name">Product Name <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="text" name="product_name" id="product_name" value="" required="required" maxlength="250">

</div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="description">Description <span>*</span></label>

</div>

</div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="product_code">Product Code <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" <input type="text" name="product_code" id="product_code" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" or="product_cost">Product Cost<span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="number" name="product_cost" id="product_cost" value="" maxlength="50" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="mrp">MRP <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="number" name="mrp" id="mrp" value="" maxlength="50" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="quantity">Quantity <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="number" name="quantity" id="quantity" value="" maxlength="50" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="product_pv">Package PV <span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="number" name="product_pv" id="product_pv" value="" maxlength="50" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="file">Select File<span>*</span></label>
                            <div class="col-sm-10">
                                <input class="form-control" type="file" name="file" id="file" value="" maxlength="50" required="required">
                            </div>
                        </div>
                        <div class="form-group row">
                            <label class="col-sm-2 col-form-label" for="file">Is Active<span>*</span></label>
                            <div class="checkbox col-sm-10 ">
                                <input class="form-group checkbox" type="checkbox" name="is_active" id="is_active" value="1" checked="checked" maxlength="50" required="required" is_activeed>
                            </div>
                        </div>
                        <div class="form-group">
                            <div>

                                <button name="submit" type="submit" id="submit" value="Submit"class="btn btn-primary waves-effect waves-light">
                                    Submit
                                </button>
                                
                            </div>
                        </div>
                        
                        
                        
                    </form>
                </div>

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

</div> 
<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Product Detail's</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="#">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Admin Setting</a></li>
                    <li class="breadcrumb-item active"><a href="#">Product Detail</li>
                </ol>

<table class="table mb-0 datatable">
                        <thead>
                            <tr>
                                <th>S. No.</th>
                                <th>Name</th>
                                <th>Description</th>
                                <th>Code</th>
                                <th>Cost</th>
                                <th>MRP</th>
                                <th>PV</th>
                                <th>Active</th>
                                <th>Created Date</th>
                                <th>Image</th>
                                <th>Edit/Delete</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php
                            $query = "SELECT * FROM product_kit  ORDER BY pid DESC ";
                              $result = mysqli_query($connection, $query);
                            $i = 1;
                            if ($result) {
                                 while ($row = mysqli_fetch_object($result)) {
                                    ?>
                                    <tr>
                                        
                                        <td><?php echo $row->pid; ?></td>
                                        <td><?php echo $row->pname; ?></td>
                                        <td><?php echo $row->description; ?></td>

<td><?php echo $row->pcode; ?></td>
                                        <td><?php echo $row->pcost; ?></td>
                                        <td><?php echo $row->mrp; ?></td>

<td><?php echo $row->pv; ?></td>
                                        <td><?php echo $row->is_active ? "YES" : "NO"; ?></td>
                                        <td><?php echo empty($row->datetime) ? '-' : date("d/m/Y", strtotime($row->datetime)); ?></td>
                                        <td><a href="./images/product_gallary/<?php echo $row->filename; ?>" target="_blank">view</a></td>
                                        <td>
                                            <a href="./product_page_edit.php?product_id=<?php echo $row->pid; ?>">edit</a>
                                            <a href="./product_page_delete.php?product_id=<?php echo $row->pid . "&filename=$row->filename"; ?>">delete</a>
                                        </td>
                                    </tr>
                                    <?php
                                    $i++;
                                }
                            }
                            ?>
                        </tbody>
                    </table>
                    <?php //echo $pager->renderFullNav();  ?>  
                </div>
            </div>
        </div> 
    </div>
    
</div>
<?php include 'footer.php'; ?>

/home2/wtmwscom/www/themes5931.wtmwebshop.com/../admin/product_page.php