Ghost Exploiter Team Official
/
home
/
ramdevpcb
/
public_html
/
admin.ramdevpcb.com
/
Nama File / Folder
Size
Action
.well-known
--
NONE
Data_
--
NONE
assets
--
NONE
cgi-bin
--
NONE
include
--
NONE
uploads
--
NONE
.htaccess
0.274KB
Hapus
Edit
Rename
8Products.php
15.674KB
Hapus
Edit
Rename
AvailableStock.php
9.525KB
Hapus
Edit
Rename
Enquiry.php
8.806KB
Hapus
Edit
Rename
MonthlyProducts.php
15.686KB
Hapus
Edit
Rename
NewArrival.php
12.277KB
Hapus
Edit
Rename
add-brand.php
27.782KB
Hapus
Edit
Rename
add-vendor.php
42.001KB
Hapus
Edit
Rename
b-bclients.php
12.086KB
Hapus
Edit
Rename
b-bclients1.php
9.329KB
Hapus
Edit
Rename
b-cclients.php
13.998KB
Hapus
Edit
Rename
category.php
13.583KB
Hapus
Edit
Rename
challan.php
15.391KB
Hapus
Edit
Rename
client.php
16.926KB
Hapus
Edit
Rename
color.php
11.327KB
Hapus
Edit
Rename
company.php
14.712KB
Hapus
Edit
Rename
courier.php
16.539KB
Hapus
Edit
Rename
customerreport.php
11.684KB
Hapus
Edit
Rename
delete_product_pdf.php
0.618KB
Hapus
Edit
Rename
discount-b2b.php
9.862KB
Hapus
Edit
Rename
discount-b2c.php
8.333KB
Hapus
Edit
Rename
discount-list.php
10.272KB
Hapus
Edit
Rename
discount-server.php
1.206KB
Hapus
Edit
Rename
error_log
276.584KB
Hapus
Edit
Rename
generate-invoice-server.php
3.183KB
Hapus
Edit
Rename
generate-invoice.php
15.014KB
Hapus
Edit
Rename
index.php
0KB
Hapus
Edit
Rename
invoice-list.php
10.6KB
Hapus
Edit
Rename
invoice.php
29.772KB
Hapus
Edit
Rename
invoice2.php
29.551KB
Hapus
Edit
Rename
invoice22222.php
31.864KB
Hapus
Edit
Rename
invoicenew1.php
17.683KB
Hapus
Edit
Rename
invoicereport.php
31.128KB
Hapus
Edit
Rename
login.php
0KB
Hapus
Edit
Rename
logout.php
0.091KB
Hapus
Edit
Rename
newstock.php
15.827KB
Hapus
Edit
Rename
offline-order-add.php
2.254KB
Hapus
Edit
Rename
offline-order-delete.php
0.338KB
Hapus
Edit
Rename
offline-order-server.php
1.695KB
Hapus
Edit
Rename
offline-order.php
30.544KB
Hapus
Edit
Rename
order-details.php
14.237KB
Hapus
Edit
Rename
order-item-details.php
7.875KB
Hapus
Edit
Rename
ordersreport.php
21.602KB
Hapus
Edit
Rename
paidd.png
27.518KB
Hapus
Edit
Rename
php.ini
0.567KB
Hapus
Edit
Rename
product-list.php
8.904KB
Hapus
Edit
Rename
product.php
35.78KB
Hapus
Edit
Rename
productreport.php
28.885KB
Hapus
Edit
Rename
save_image_order.php
1.284KB
Hapus
Edit
Rename
slider.php
18.567KB
Hapus
Edit
Rename
sms.js
2.603KB
Hapus
Edit
Rename
stock.php
14.202KB
Hapus
Edit
Rename
stockreport.php
24.525KB
Hapus
Edit
Rename
subcategory.php
13.671KB
Hapus
Edit
Rename
update-order-status.php
2.562KB
Hapus
Edit
Rename
update-user-role.php
0.306KB
Hapus
Edit
Rename
vijayinvoice.php
17.683KB
Hapus
Edit
Rename
<?php require_once 'include/db.php'; ?> <!doctype html> <html lang="en" dir="ltr"> <head> <!-- META DATA --> <meta charset="UTF-8"> <meta name='viewport' content='width=device-width, initial-scale=1.0, user-scalable=0'> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content="Ramdev PCB Admin"> <meta name="author" content="Ramdev PCB Admin"> <meta name="keywords" content="Ramdev PCB"> <!-- FAVICON --> <link rel="shortcut icon" type="image/x-icon" href="assets/images/brand/favicon.ico" /> <!-- TITLE --> <title>Stocks Ramdev PCB </title> <!-- BOOTSTRAP CSS --> <link id="style" href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" /> <!-- STYLE CSS --> <link href="assets/css/style.css" rel="stylesheet" /> <link href="assets/css/dark-style.css" rel="stylesheet" /> <link href="assets/css/transparent-style.css" rel="stylesheet"> <link href="assets/css/skin-modes.css" rel="stylesheet" /> <!--- FONT-ICONS CSS --> <link href="assets/css/icons.css" rel="stylesheet" /> <!-- COLOR SKIN CSS --> <link id="theme" rel="stylesheet" type="text/css" media="all" href="assets/colors/color1.css" /> <style> .dark-mode .table tr{ background:#2d274a !important; } </style> </head> <body class="app sidebar-mini ltr light-mode"> <!-- PAGE --> <div class="page"> <div class="page-main"> <!-- app-Header --> <?php include('include/header.php');?> <!--APP-SIDEBAR--> <?php include('include/sidebarmenu.php');?> <!--app-content open--> <div class="main-content app-content mt-0"> <div class="side-app"> <?php // if ($color_added > 0) { ?> <!--<div class="alert alert-success" role="alert">Color Added Successfully</div>--> <?php // } ?> <!-- CONTAINER --> <div class="main-container container-fluid"> <!-- PAGE-HEADER --> <div class="page-header"> <h1 class="page-title">Stock List</h1> <div> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li> <li class="breadcrumb-item active" aria-current="page">Stock List</li> </ol> </div> </div> <!-- PAGE-HEADER END --> <!-- ROW-1 --> <div class="row"> <div class="col-xl-12 col-lg-12"> <div class="card"> <div class="card-header"> <h3 class="card-title">Stock List</h3> </div> <div class="card-body"> <div class="table-responsive"> <table id="responsive-datatable" class="table table-bordered text-nowrap key-buttons border-bottom"> <thead> <th>Sr<br>No.</th> <th>RD<br>No.</th> <th>Color</th> <th>Total<br>Stock</th> <th>Minimum <br>Quantity</th> <th>Location</th> <th>Action</th> </thead> <tbody> <?php $sql = "SELECT DISTINCT(A.ProductNumber),A.TotalStock,A.ProductColorID,B.ColorName,A.StockLocation FROM productdetails A INNER JOIN ProductColors B ON A.ProductColorID = B.ColorID where A.is_deleted='0' ORDER BY A.TotalStock"; $result = mysqli_query($conn, $sql) or die(mysqli_error($conn)); $redRows = []; // For rows with negative stock $orangeRows = []; // For rows with stock below the minimum $greenRows = []; // For rows with stock above the minimum while ($row = mysqli_fetch_assoc($result)) { $rd = $row['ProductNumber']; $query = "SELECT MAX(minqty) AS minqty FROM productdetails WHERE ProductNumber = '$rd' LIMIT 1"; $r = mysqli_query($conn, $query); $min = 0; if ($rs = mysqli_fetch_assoc($r)) { $min = $rs['minqty']; } // Categorize the rows based on stock levels if ($row['TotalStock'] < 0) { $redRows[] = array_merge($row, ['min' => $min]); } elseif ($row['TotalStock'] < $min) { $orangeRows[] = array_merge($row, ['min' => $min]); } else { $greenRows[] = array_merge($row, ['min' => $min]); } } // Helper function to display rows function displayRows($rows, $color, &$i) { foreach ($rows as $row) { echo "<tr style='background:$color'>"; echo "<td>" . $i++ . "</td>"; echo "<td>" . $row['ProductNumber'] . "</td>"; echo "<td>" . $row['ColorName'] . "</td>"; echo "<td>" . $row['TotalStock'] . "</td>"; echo "<td>" . $row['min'] . "</td>"; echo "<td>" . $row['StockLocation'] . "</td>"; echo "<td> <a href='newstock.php?rdno=" . $row['ProductNumber'] . "&cid=" . $row['ProductColorID'] . "' class='btn btn-primary edit-color' data-product_id='" . $row['ProductNumber'] . "'> <i class='fa fa-edit' aria-hidden='true'></i> </a> </td>"; echo "</tr>"; } } $i = 1; // Initialize row index // Display rows in the order: red (negative stock), orange (below min), green (above min) displayRows($redRows, '#ff5a57', $i); displayRows($orangeRows, '#fcbf5b', $i); displayRows($greenRows, '#7ffdab', $i); ?> </tbody> </table> </div> </div> </div> </div> </div> </div> <!-- CONTAINER END --> </div> </div> <!--app-content close--> </div> <!-- FOOTER --> <?php include('include/footer.php');?> <!-- FOOTER END --> </div> <!-- BACK-TO-TOP --> <a href="#top" id="back-to-top"><i class="fa fa-angle-up"></i></a> <!-- JQUERY JS --> <script src="assets/js/jquery.min.js"></script> <!-- BOOTSTRAP JS --> <script src="assets/plugins/bootstrap/js/popper.min.js"></script> <script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script> <!-- SPARKLINE JS--> <script src="assets/js/jquery.sparkline.min.js"></script> <!-- Sticky js --> <script src="assets/js/sticky.js"></script> <!-- CHART-CIRCLE JS--> <script src="assets/js/circle-progress.min.js"></script> <!-- PIETY CHART JS--> <script src="assets/plugins/peitychart/jquery.peity.min.js"></script> <script src="assets/plugins/peitychart/peitychart.init.js"></script> <!-- SIDEBAR JS --> <script src="assets/plugins/sidebar/sidebar.js"></script> <!-- Perfect SCROLLBAR JS--> <script src="assets/plugins/p-scroll/perfect-scrollbar.js"></script> <script src="assets/plugins/p-scroll/pscroll.js"></script> <script src="assets/plugins/p-scroll/pscroll-1.js"></script> <!-- INTERNAL CHARTJS CHART JS--> <script src="assets/plugins/chart/Chart.bundle.js"></script> <script src="assets/plugins/chart/rounded-barchart.js"></script> <script src="assets/plugins/chart/utils.js"></script> <!-- INTERNAL SELECT2 JS --> <script src="assets/plugins/select2/select2.full.min.js"></script> <!-- INTERNAL Data tables js--> <script src="assets/plugins/datatable/js/jquery.dataTables.min.js"></script> <script src="assets/plugins/datatable/js/dataTables.bootstrap5.js"></script> <script src="assets/plugins/datatable/js/dataTables.buttons.min.js"></script> <script src="assets/plugins/datatable/js/buttons.bootstrap5.min.js"></script> <script src="assets/plugins/datatable/js/jszip.min.js"></script> <script src="assets/plugins/datatable/pdfmake/pdfmake.min.js"></script> <script src="assets/plugins/datatable/pdfmake/vfs_fonts.js"></script> <script src="assets/plugins/datatable/js/buttons.html5.min.js"></script> <script src="assets/plugins/datatable/js/buttons.print.min.js"></script> <script src="assets/plugins/datatable/js/buttons.colVis.min.js"></script> <script src="assets/plugins/datatable/dataTables.responsive.min.js"></script> <script src="assets/plugins/datatable/responsive.bootstrap5.min.js"></script> <script src="assets/js/table-data.js"></script> <!-- INTERNAL APEXCHART JS --> <script src="assets/js/apexcharts.js"></script> <script src="assets/plugins/apexchart/irregular-data-series.js"></script> <!-- C3 CHART JS --> <script src="assets/plugins/charts-c3/d3.v5.min.js"></script> <script src="assets/plugins/charts-c3/c3-chart.js"></script> <!-- CHART-DONUT JS --> <script src="assets/js/charts.js"></script> <!-- INTERNAL Flot JS --> <script src="assets/plugins/flot/jquery.flot.js"></script> <script src="assets/plugins/flot/jquery.flot.fillbetween.js"></script> <script src="assets/plugins/flot/chart.flot.sampledata.js"></script> <script src="assets/plugins/flot/dashboard.sampledata.js"></script> <!-- INTERNAL Vector js --> <script src="assets/plugins/jvectormap/jquery-jvectormap-2.0.2.min.js"></script> <script src="assets/plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script> <!-- SIDE-MENU JS--> <script src="assets/plugins/sidemenu/sidemenu.js"></script> <!-- INTERNAL INDEX JS --> <script src="assets/js/index1.js"></script> <!-- Color Theme js --> <script src="assets/js/themeColors.js"></script> <!-- CUSTOM JS --> <script src="assets/js/custom.js"></script> <script type="text/javascript"> $('.delete-product').on('click',function(){ var product_id = $(this).attr('data-product_id'); var action = 'deleteProduct'; $.ajax({ url:'<?php echo "include/ajax-common.php"; ?>', type:'POST', data: {product_id : product_id,action:action}, success:function(response) { // $('#subcategory').append(response); alert('Product Deleted Successfully.'); window.location.reload(); }, error: function (error) { console.log('No subcategories found'); } }); }) </script> </body> </html>
