<h2>File Contents: /home/u885320773/domains/sugatu.in/vendor/product-details.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/vendor/product-details.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php include 'includes/check-session.php'; ?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot;&gt;
    &lt;head&gt;
        &lt;meta charset=&quot;utf-8&quot; /&gt;
        &lt;title&gt;View / Edit Product - Sugatu&lt;/title&gt;
        &lt;meta http-equiv=&quot;x-ua-compatible&quot; content=&quot;ie=edge&quot; /&gt;
        &lt;meta name=&quot;description&quot; content=&quot;&quot; /&gt;
        &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1&quot; /&gt;
        &lt;meta property=&quot;og:title&quot; content=&quot;&quot; /&gt;
        &lt;meta property=&quot;og:type&quot; content=&quot;&quot; /&gt;
        &lt;meta property=&quot;og:url&quot; content=&quot;&quot; /&gt;
        &lt;meta property=&quot;og:image&quot; content=&quot;&quot; /&gt;
        &lt;!-- Favicon --&gt;
        &lt;link rel=&quot;shortcut icon&quot; type=&quot;image/x-icon&quot; href=&quot;assets/imgs/theme/favicon.png&quot; /&gt;
        &lt;!-- Template CSS --&gt;
        &lt;link href=&quot;assets/css/main.css?v=1.1&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot; /&gt;
        &lt;script src=&quot;https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js&quot;&gt;&lt;/script&gt;

    &lt;/head&gt;

    &lt;body&gt;
        &lt;div class=&quot;screen-overlay&quot;&gt;&lt;/div&gt;
        &lt;!--==========  SIDEBAR LOGO AND MENU  =============--&gt;
        &lt;?php include 'includes/sidebar.php'; ?&gt;
        &lt;main class=&quot;main-wrap&quot;&gt;
            &lt;!--==========  HEADER  =============--&gt;
            &lt;?php include 'includes/header.php'; ?&gt;
            &lt;section class=&quot;content-main&quot;&gt;
                &lt;div class=&quot;row&quot;&gt;
                    &lt;div class=&quot;col-12&quot;&gt;
                        &lt;div class=&quot;content-header&quot;&gt;
                            &lt;h2 class=&quot;content-title&quot;&gt;Vew / Edit Product&lt;/h2&gt;
                            &lt;div&gt;
                                
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;?php	if(isset($_GET['add'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Successfully Added&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
        &lt;?php	if(isset($_GET['edit'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Successfully Edited&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
				&lt;?php	if(isset($_GET['delete'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Successfully Deleted&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
								&lt;?php	if(isset($_GET['error'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Error While Adding Record&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
                    &lt;/div&gt;
                &lt;/div&gt;

                &lt;?php
                    if ($_SERVER[&quot;REQUEST_METHOD&quot;] == &quot;GET&quot;) {
  
                        $product_id = $_REQUEST['id'];
                    
                    }

                    include 'config.php';

                    $sql = &quot;SELECT * FROM products WHERE id = $product_id&quot;;
                    $result = $conn-&gt;query($sql);

                    if ($result-&gt;num_rows &gt; 0) {
                        $row = $result-&gt;fetch_assoc();
                        // Populate variables with product details
                        $pid = $row['id'];
                        $ptitle = $row['ptitle'];
                        $features = $row['features'];
                        $description = $row['description'];
                        $technical = $row['technical'];
                        $gmain = $row['gmain'];
                        $g1 = $row['g1'];
                        $g2 = $row['g2'];
                        $g3 = $row['g3'];
                        $g4 = $row['g4'];
                        $g5 = $row['g5'];
                        $g6 = $row['g6'];
                        $costprice = $row['costprice'];
                        $marginpercent = $row['marginpercent'];
                        $mrp = $row['mrp'];
                        $discountpercent = $row['discountpercent'];
                        $discounterprice = $row['discounterprice'];
                        $category_id = $row['parentCategory'];
                        $sub_category_id = $row['subCategory'];
                        $status = $row['status'];
                        $vendor_id = $row['vendor'];
                        $manufacturer = $row['manufacturer'];
                        $warehouse_id = $row['warehouse'];
                        $sku = $row['sku'];
                        $hsn = $row['hsn'];
                        $weight = $row['weight'];
                        $s1name = $row['s1name'];
                        $s1file = $row['s1file'];
                        $s2name = $row['s2name'];
                        $s2file = $row['s2file'];
                        $s3name = $row['s3name'];
                        $s3file = $row['s3file'];
                        $s4name = $row['s4name'];
                        $s4file = $row['s4file'];
                        $s5name = $row['s5name'];
                        $s5file = $row['s5file'];
                        $s6name = $row['s6name'];
                        $s6file = $row['s6file'];
                        $s7name = $row['s7name'];
                        $s7file = $row['s7file'];
                        $s8name = $row['s8name'];
                        $s8file = $row['s8file'];
                    } else {
                        echo &quot;Product not found&quot;;
                    }


                ?&gt;

                &lt;form method=&quot;post&quot; action=&quot;process/edit-product.php&quot; enctype=&quot;multipart/form-data&quot;&gt;
                    &lt;input type=&quot;hidden&quot; name=&quot;product_id&quot; value=&quot;&lt;?php echo $pid ?&gt;&quot;&gt;
                &lt;div class=&quot;row&quot;&gt;
                    &lt;div class=&quot;col-lg-8&quot;&gt;
                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div class=&quot;mb-4&quot;&gt;
                                    &lt;label for=&quot;product_title&quot; class=&quot;form-label&quot;&gt;Product Title&lt;/label&gt;
                                    &lt;input type=&quot;text&quot; name=&quot;ptitle&quot; placeholder=&quot;Type here&quot; value=&quot;&lt;?php echo $ptitle; ?&gt;&quot; required class=&quot;form-control&quot; id=&quot;product_title&quot; /&gt;
                                &lt;/div&gt;
                               
                            &lt;/div&gt;
                        &lt;/div&gt;

                        &lt;!-- card end// --&gt;
                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div&gt;
                                    &lt;label class=&quot;form-label&quot;&gt;Features&lt;/label&gt;
                                    &lt;textarea placeholder=&quot;Type here&quot; name=&quot;features&quot; class=&quot;form-control&quot; rows=&quot;4&quot;&gt;&lt;?php echo $features; ?&gt;&lt;/textarea&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;

                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div&gt;
                                    &lt;label class=&quot;form-label&quot;&gt;Description&lt;/label&gt;
                                    &lt;textarea placeholder=&quot;Type here&quot; name=&quot;description&quot; class=&quot;form-control&quot; rows=&quot;4&quot;&gt;&lt;?php echo $description; ?&gt;&lt;/textarea&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;
                        
                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div&gt;
                                    &lt;label class=&quot;form-label&quot;&gt;Technical Specification&lt;/label&gt;
                                    &lt;textarea placeholder=&quot;Type here&quot; name=&quot;technical&quot; class=&quot;form-control&quot; rows=&quot;4&quot;&gt;&lt;?php echo $technical; ?&gt;&lt;/textarea&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;

                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div&gt;
                                    &lt;label class=&quot;form-label&quot;&gt;Main Image&lt;/label&gt;&lt;br&gt;
                                    &lt;img src=&quot;assets/imgs/products/&lt;?php echo $gmain ?&gt;&quot; style=&quot;width:120px; height:120px;&quot;&gt;
                                    &lt;input class=&quot;form-control&quot; name=&quot;gmain&quot; type=&quot;file&quot; /&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;


                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div class=&quot;row&quot;&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Gallery Image 1&lt;/label&gt;&lt;br&gt;
                                    &lt;img src=&quot;assets/imgs/products/&lt;?php echo $g1 ?&gt;&quot; style=&quot;width:120px; height:120px;&quot;&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;g1&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Gallery Image 2&lt;/label&gt;&lt;br&gt;
                                    &lt;img src=&quot;assets/imgs/products/&lt;?php echo $g2 ?&gt;&quot; style=&quot;width:120px; height:120px;&quot;&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;g2&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Gallery Image 3&lt;/label&gt;&lt;br&gt;
                                    &lt;img src=&quot;assets/imgs/products/&lt;?php echo $g3 ?&gt;&quot; style=&quot;width:120px; height:120px;&quot;&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;g3&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Gallery Image 4&lt;/label&gt;&lt;br&gt;
                                    &lt;img src=&quot;assets/imgs/products/&lt;?php echo $g4 ?&gt;&quot; style=&quot;width:120px; height:120px;&quot;&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;g4&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Gallery Image 5&lt;/label&gt;&lt;br&gt;
                                    &lt;img src=&quot;assets/imgs/products/&lt;?php echo $g5 ?&gt;&quot; style=&quot;width:120px; height:120px;&quot;&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;g5&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Gallery Image 6&lt;/label&gt;&lt;br&gt;
                                    &lt;img src=&quot;assets/imgs/products/&lt;?php echo $g6 ?&gt;&quot; style=&quot;width:120px; height:120px;&quot;&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;g6&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;


                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div class=&quot;row&quot;&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 1 Name&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s1name;?&gt;&quot; name=&quot;s1name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 1 PDF File &lt;?php if($s1file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s1file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s1file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 2 Name&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s2name;?&gt;&quot; name=&quot;s2name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 2 PDF File &lt;?php if($s2file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s2file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s2file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 3 Name &lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s3name;?&gt;&quot; name=&quot;s3name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 3 PDF File &lt;?php if($s3file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s3file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s3file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 4 Name &lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s4name;?&gt;&quot; name=&quot;s4name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 4 PDF File &lt;?php if($s4file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s4file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s4file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 5 Name &lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s5name;?&gt;&quot; name=&quot;s5name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 5 PDF File &lt;?php if($s5file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s5file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s5file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 6 Name&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s6name;?&gt;&quot; name=&quot;s6name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 6 PDF File &lt;?php if($s6file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s6file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s6file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 7 Name &lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s7name;?&gt;&quot; name=&quot;s7name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 7 PDF File &lt;?php if($s7file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s7file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s7file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;

                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 8 Name&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; value=&quot;&lt;?php echo $s8name;?&gt;&quot; name=&quot;s8name&quot; type=&quot;text&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Standard 8 PDF File &lt;?php if($s8file != ''){echo '&lt;a href=&quot;assets/pdfs/standards/'.$s8file.'&quot; target=&quot;_blank&quot;&gt;Click Here&lt;/a&gt;';} ?&gt;&lt;/label&gt;
                                        &lt;input class=&quot;form-control&quot; name=&quot;s8file&quot; type=&quot;file&quot; /&gt;
                                    &lt;/div&gt;
                                    
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;


                    &lt;/div&gt;
                    &lt;div class=&quot;col-lg-4&quot;&gt;


                    &lt;script&gt;
    function calculateMRP() {
      var costPrice = parseFloat(document.getElementById('costPrice').value);
      var marginPercent = parseFloat(document.getElementById('marginPercent').value);

      if (!isNaN(costPrice) &amp;&amp; !isNaN(marginPercent)) {
        var mrp = costPrice * (1 + (marginPercent / 100));
        document.getElementById('mrp').value = mrp.toFixed(0);
        calculateDiscountedPrice(); // Calculate discounted price whenever MRP changes
      }
    }

    function calculateDiscountedPrice() {
      var mrp = parseFloat(document.getElementById('mrp').value);
      var discountPercent = parseFloat(document.getElementById('discountPercent').value);

      if (!isNaN(mrp) &amp;&amp; !isNaN(discountPercent)) {
        var discountedPrice = mrp * (1 - (discountPercent / 100));
        document.getElementById('discountedPrice').value = discountedPrice.toFixed(0);
      }
    }

    window.addEventListener('DOMContentLoaded', function() {
      var costPriceInput = document.getElementById('costPrice');
      var marginInput = document.getElementById('marginPercent');
      var discountPercentInput = document.getElementById('discountPercent');

      costPriceInput.addEventListener('input', function() {
        calculateMRP();
      });

      marginInput.addEventListener('input', function() {
        calculateMRP();
      });

      discountPercentInput.addEventListener('input', function() {
        calculateDiscountedPrice();
      });

      // Trigger MRP calculation initially
      calculateMRP();
    });
  &lt;/script&gt;

                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div class=&quot;row&quot;&gt;
                                    &lt;div class=&quot;col-sm-12 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Price&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; name=&quot;costprice&quot; id=&quot;costPrice&quot; required value=&quot;&lt;?php echo $costprice ?&gt;&quot; placeholder=&quot;Type here&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Margin %&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; required value=&quot;&lt;?php echo $marginpercent ?&gt;&quot; name=&quot;marginpercent&quot; id=&quot;marginPercent&quot; placeholder=&quot;%&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-8 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;MRP ₹&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; required value=&quot;&lt;?php echo $mrp ?&gt;&quot; name=&quot;mrp&quot; id=&quot;mrp&quot; readonly placeholder=&quot;&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-4 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Discount %&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; required value=&quot;&lt;?php echo $discountpercent ?&gt;&quot; name=&quot;discountpercent&quot; id=&quot;discountPercent&quot; placeholder=&quot;%&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-8 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Discounted Price ₹&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; required value=&quot;&lt;?php echo $discounterprice ?&gt;&quot; name=&quot;discounterprice&quot; id=&quot;discountedPrice&quot; readonly placeholder=&quot;&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                &lt;/div&gt;
                                &lt;div class=&quot;mb-4&quot;&gt;
                                    &lt;label class=&quot;form-label&quot;&gt;Status&lt;/label&gt;
                                    &lt;select name=&quot;status&quot; class=&quot;form-select&quot;&gt;
                                        &lt;option value=&quot;Published&quot; &lt;?php echo ($status === 'Published') ? 'selected' : ''; ?&gt;&gt;Published&lt;/option&gt;
                                        &lt;option value=&quot;Draft&quot; &lt;?php echo ($status === 'Draft') ? 'selected' : ''; ?&gt;&gt;Draft&lt;/option&gt;
                                    &lt;/select&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;

                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div class=&quot;mb-4&quot;&gt;
                                    &lt;label for=&quot;parentCategory&quot; class=&quot;form-label&quot;&gt;Categories&lt;/label&gt;
                                    &lt;label for=&quot;parentCategory&quot; class=&quot;form-label&quot;&gt;Categories&lt;/label&gt;
                                    &lt;select id=&quot;parentCategory&quot; name=&quot;parentCategory&quot; class=&quot;form-select&quot;&gt;
                                        &lt;option value=&quot;&quot;&gt;Select Category&lt;/option&gt;
                                        &lt;?php
                                        include 'config.php';
                                        $sql = &quot;SELECT * FROM productcategory WHERE parentid = '0'&quot;;
                                        $result = $conn-&gt;query($sql);
                                        if ($result-&gt;num_rows &gt; 0) {
                                            while ($row = $result-&gt;fetch_assoc()) {
                                                $selectedCategory = ($row['id'] == $category_id) ? 'selected' : ''; // Check if category ID matches the fetched ID
                                                echo &quot;&lt;option value='&quot; . $row['id'] . &quot;' $selectedCategory&gt;&quot; . $row['cname'] . &quot;&lt;/option&gt;&quot;;
                                            }
                                        }
                                        ?&gt;
                                    &lt;/select&gt;
                                &lt;/div&gt;
                                &lt;div class=&quot;mb-4&quot;&gt;
                                    &lt;label for=&quot;subCategory&quot; class=&quot;form-label&quot;&gt;Sub Category&lt;/label&gt;
                                    &lt;label for=&quot;subCategory&quot; class=&quot;form-label&quot;&gt;Sub Category&lt;/label&gt;
                                    &lt;select id=&quot;subCategory&quot; name=&quot;subCategory&quot; class=&quot;form-select&quot;&gt;
                                        &lt;option value=&quot;&quot;&gt;Select Sub Category&lt;/option&gt;
                                        &lt;?php
                                        if (!empty($category_id)) {
                                            $sql = &quot;SELECT * FROM productcategory WHERE parentid = '$category_id'&quot;;
                                            $result = $conn-&gt;query($sql);
                                            if ($result-&gt;num_rows &gt; 0) {
                                                while ($row = $result-&gt;fetch_assoc()) {
                                                    $selectedSubCategory = ($row['id'] == $sub_category_id) ? 'selected' : ''; // Check if sub-category ID matches the fetched ID
                                                    echo &quot;&lt;option value='&quot; . $row['id'] . &quot;' $selectedSubCategory&gt;&quot; . $row['cname'] . &quot;&lt;/option&gt;&quot;;
                                                }
                                            }
                                        }
                                        ?&gt;
                                    &lt;/select&gt;
                                    &lt;script&gt;
                                        $(document).ready(function () {
                                            $('#parentCategory').on('change', function () {
                                                var parentCategoryID = $(this).val();
                                                if (parentCategoryID) {
                                                    $.ajax({
                                                        type: 'POST',
                                                        url: 'process/get_subcategories.php',
                                                        data: 'parent_cat_id=' + parentCategoryID,
                                                        success: function (html) {
                                                            $('#subCategory').html(html);
                                                        }
                                                    });
                                                } else {
                                                    $('#subCategory').html('&lt;option value=&quot;&quot;&gt;Select Sub Category&lt;/option&gt;');
                                                }
                                            });
                                        });
                                    &lt;/script&gt;
                                &lt;/div&gt;
                                
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;

                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div class=&quot;mb-4&quot;&gt;
                                    &lt;label class=&quot;form-label&quot;&gt;Vendor&lt;/label&gt;
                                    &lt;select id=&quot;vendor&quot; name=&quot;vendor&quot; class=&quot;form-select&quot;&gt;
                                        &lt;option value=&quot;&quot;&gt;Select Vendor&lt;/option&gt;
                                        &lt;?php
                                        include 'config.php';
                                        $sql = &quot;SELECT * FROM vendor WHERE `status`='active'&quot;;
                                        $result = $conn-&gt;query($sql);
                                        if ($result-&gt;num_rows &gt; 0) {
                                            while ($row = $result-&gt;fetch_assoc()) {
                                                $selectedVendor = ($row['id'] == $vendor_id) ? 'selected' : ''; // Check if vendor ID matches the fetched ID
                                                echo &quot;&lt;option value='&quot; . $row['id'] . &quot;' $selectedVendor&gt;&quot; . $row['company'] . &quot;&lt;/option&gt;&quot;;
                                            }
                                        }
                                        ?&gt;
                                    &lt;/select&gt;
                                &lt;/div&gt;

                                &lt;div class=&quot;mb-4&quot;&gt;
                                    &lt;label class=&quot;form-label&quot;&gt;Manufacturer&lt;/label&gt;
                                    &lt;input type=&quot;text&quot; name=&quot;manufacturer&quot; value=&quot;&lt;?php echo $manufacturer;?&gt;&quot; placeholder=&quot;Type here&quot; class=&quot;form-control&quot; /&gt;
                                &lt;/div&gt;
                                
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;

                        

                        &lt;div class=&quot;card mb-4&quot;&gt;
                            &lt;div class=&quot;card-body&quot;&gt;
                                &lt;div class=&quot;row&quot;&gt;
                                    &lt;div class=&quot;col-sm-12 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;SKU&lt;/label&gt;
                                        &lt;input type=&quot;text&quot; name=&quot;sku&quot; value=&quot;&lt;?php echo $sku;?&gt;&quot; placeholder=&quot;Type here&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;HSN Code&lt;/label&gt;
                                        &lt;input type=&quot;text&quot; name=&quot;hsn&quot; value=&quot;&lt;?php echo $hsn;?&gt;&quot; placeholder=&quot;Type here&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;col-sm-6 mb-4&quot;&gt;
                                        &lt;label class=&quot;form-label&quot;&gt;Weight in Kg&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; name=&quot;weight&quot; value=&quot;&lt;?php echo $weight;?&gt;&quot; placeholder=&quot;Type here&quot; class=&quot;form-control&quot; /&gt;
                                    &lt;/div&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
                        &lt;!-- card end// --&gt;


                    &lt;/div&gt;
                    &lt;div class=&quot;col-sm-12 mb-5&quot;&gt;
                        &lt;input type=&quot;submit&quot; value=&quot;SAVE PRODUCT&quot; class=&quot;btn btn-primary rounded&quot;&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;/form&gt;
            &lt;/section&gt;
            &lt;!-- content-main end// --&gt;
            &lt;footer class=&quot;main-footer font-xs&quot;&gt;
                &lt;div class=&quot;row pb-30 pt-15&quot;&gt;
                    &lt;div class=&quot;col-sm-6&quot;&gt;
                        &lt;script&gt;
                            document.write(new Date().getFullYear());
                        &lt;/script&gt;
                        &amp;copy; Sugatu .
                    &lt;/div&gt;
                    &lt;div class=&quot;col-sm-6&quot;&gt;
                        &lt;div class=&quot;text-sm-end&quot;&gt;All rights reserved&lt;/div&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
            &lt;/footer&gt;
        &lt;/main&gt;
        &lt;script src=&quot;assets/js/vendors/jquery-3.6.0.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/select2.min.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/perfect-scrollbar.js&quot;&gt;&lt;/script&gt;
        &lt;script src=&quot;assets/js/vendors/jquery.fullscreen.min.js&quot;&gt;&lt;/script&gt;
        &lt;!-- Main Script --&gt;
        &lt;script src=&quot;assets/js/main.js?v=1.1&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
    &lt;/body&gt;
&lt;/html&gt;
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fu885320773%2Fdomains%2Fsugatu.in%2Fvendor'>⬅ Back to Directory</a>