| Server IP : 144.76.124.212 / Your IP : 216.73.216.138 Web Server : LiteSpeed System : Linux l4cp.vnetindia.com 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : rakcha ( 1356) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home5/rakcha/public_html/admin/ |
Upload File : |
<?php error_reporting(0); ?>
<?php
session_start();
if (!isset($_SESSION['admin_name'])) {
header("location: index.php");
}
else {
include("includes/database.php");
$page_user = $_SESSION['admin_name'];
$year = date("Y");
$month = date("m");
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta content="width=device-width, initial-scale=1" name="viewport" />
<meta name="description" content="RAKCHA | Dashboard" />
<meta name="author" content="RAKCHA | Dashboard" />
<title>RAKCHA | Dashboard</title>
<!-- google font -->
<link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet" type="text/css" />
<!-- icons -->
<link href="assets/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css" />
<link href="assets/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
<link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
<!--bootstrap -->
<link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<!-- data tables -->
<link href="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css"/>
<!-- Material Design Lite CSS -->
<link rel="stylesheet" href="assets/plugins/material/material.min.css">
<link rel="stylesheet" href="assets/css/material_style.css">
<!-- animation -->
<link href="assets/css/pages/animate_page.css" rel="stylesheet">
<!-- Theme Styles -->
<link href="assets/css/style.css" rel="stylesheet" type="text/css" />
<link href="assets/css/plugins.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/responsive.css" rel="stylesheet" type="text/css" />
<link href="assets/css/theme-color.css" rel="stylesheet" type="text/css" />
<!-- favicon -->
<link rel="shortcut icon" href="assets/img/favicon.ico" />
</head>
<!-- END HEAD -->
<body class="page-header-fixed sidemenu-closed-hidelogo page-content-white page-md header-white dark-sidebar-color logo-dark">
<div class="page-wrapper">
<!-- start header -->
<div class="page-header navbar navbar-fixed-top">
<div class="page-header-inner ">
<!-- logo start -->
<div class="page-logo">
<a href="main_home.php">
<img src="../images/resources/logo.png">
</a>
</div>
<!-- logo end -->
<ul class="nav navbar-nav navbar-left in">
<li><a href="#" class="menu-toggler sidebar-toggler"><i class="icon-menu"></i></a></li>
</ul>
<!-- start mobile menu -->
<a href="javascript:;" class="menu-toggler responsive-toggler" data-toggle="collapse" data-target=".navbar-collapse">
<span></span>
</a>
<!-- end mobile menu -->
<!-- start header menu -->
<div class="top-menu">
<ul class="nav navbar-nav pull-right">
<!-- start manage user dropdown -->
<li class="dropdown dropdown-user">
<a href="javascript:;" class="dropdown-toggle" data-toggle="dropdown" data-hover="dropdown" data-close-others="true">
<i class="fa fa-user-o"></i>
<span class="username username-hide-on-mobile"> Admin </span>
<i class="fa fa-angle-down"></i>
</a>
<ul class="dropdown-menu dropdown-menu-default animated jello">
<li>
<a href="logout.php">
<i class="icon-logout"></i> Log Out </a>
</li>
</ul>
</li>
</ul>
</div>
</div>
</div>
<!-- end header -->
<!-- start page container -->
<div class="page-container">
<!-- start sidebar menu -->
<div class="sidebar-container">
<div class="sidemenu-container navbar-collapse collapse fixed-menu">
<div id="remove-scroll">
<ul class="sidemenu page-header-fixed" data-keep-expanded="false" data-auto-scroll="true" data-slide-speed="200" style="padding-top: 20px">
<li class="sidebar-toggler-wrapper hide">
<div class="sidebar-toggler">
<span></span>
</div>
</li>
<li class="nav-item start">
<a href="main_home.php" class="nav-link nav-toggle">
<i class="material-icons">dashboard</i>
<span class="title">Dashboard</span>
</a>
</li>
<li class="nav-item active">
<a href="stock_mangement.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Stock Management</span>
</a>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Members</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="member_roi.php" class="nav-link "> <span class="title">Member List</span>
</a>
</li>
<li class="nav-item">
<a href="member_company.php" class="nav-link "> <span class="title">Company Member List</span>
</a>
</li>
<li class="nav-item">
<a href="member_adv.php" class="nav-link "> <span class="title">Advance Registeration</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Payout</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="weekly_roi.php" class="nav-link "> <span class="title">Payout</span>
</a>
</li>
<li class="nav-item">
<a href="weekly_roi_history.php" class="nav-link "> <span class="title">Payout History</span>
</a>
</li>
<li class="nav-item">
<a href="weekly_roi_search.php" class="nav-link "> <span class="title">Report</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Kit Bank</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="eproduct_request_roi.php" class="nav-link "> <span class="title">KIT Request</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Product Management</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="new_kit.php" class="nav-link "> <span class="title">New Kit I</span>
</a>
</li>
<li class="nav-item">
<a href="new_kit_1.php" class="nav-link "> <span class="title">New Kit II</span>
</a>
</li>
<li class="nav-item">
<a href="invoice_address.php" class="nav-link "> <span class="title">Get Address</span>
</a>
</li>
<li class="nav-item">
<a href="invoice_address_1.php" class="nav-link "> <span class="title">Get Address I</span>
</a>
</li>
<li class="nav-item">
<a href="billing.php" class="nav-link "> <span class="title">New Billing</span>
</a>
</li>
<li class="nav-item">
<a href="company_binary.php" class="nav-link "> <span class="title">Product Details</span>
</a>
</li>
<li class="nav-item">
<a href="company_roi.php" class="nav-link "> <span class="title">New Orders</span>
</a>
</li>
<li class="nav-item">
<a href="company_roi_approve.php" class="nav-link "> <span class="title">Approved Orders</span>
</a>
</li>
<li class="nav-item">
<a href="company_roi_order.php" class="nav-link "> <span class="title">Orders History</span>
</a>
</li>
<li class="nav-item">
<a href="new_1_history.php" class="nav-link "> <span class="title">New Kit I History</span>
</a>
</li>
<li class="nav-item">
<a href="new_2_history.php" class="nav-link "> <span class="title">New Kit II History</span>
</a>
</li>
<li class="nav-item">
<a href="invoice_pay.php" class="nav-link "> <span class="title">Download Invoice</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="daily.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Daily Updates</span>
</a>
</li>
<li class="nav-item">
<a href="gallery.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Gallery</span>
</a>
</li>
<li class="nav-item">
<a href="reward_list.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Reward Eligible list</span>
</a>
</li>
<li class="nav-item">
<a href="kyc_documents.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">KYC Documents</span>
</a>
</li>
<li class="nav-item">
<a href="../control/" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">OLD DATA</span>
</a>
</li>
<li class="nav-item">
<a href="#" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">NETWORK TREE</span> <span class="arrow"></span>
</a>
<ul class="sub-menu">
<li class="nav-item">
<a href="network.php" class="nav-link "> <span class="title">Seniority List</span>
</a>
</li>
<li class="nav-item">
<a href="network_search.php" class="nav-link "> <span class="title">Level List</span>
</a>
</li>
<li class="nav-item">
<a href="../user/network_report.php" class="nav-link "> <span class="title">Get Report</span>
</a>
</li>
</ul>
</li>
<li class="nav-item">
<a href="coupon_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Coupon Update</span>
</a>
</li>
<li class="nav-item">
<a href="personal_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Personal Pv Update</span>
</a>
</li>
<li class="nav-item">
<a href="special_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Special Pv Update</span>
</a>
</li>
<li class="nav-item">
<a href="sms_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">SMS DETAILS</span>
</a>
</li>
<li class="nav-item">
<a href="comitee_update.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">COMMITTEE DETAILS</span>
</a>
</li>
<li class="nav-item">
<a href="nottice_letter.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Notice Letter</span>
</a>
</li>
<li class="nav-item">
<a href="change_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Change Password</span>
</a>
</li>
<li class="nav-item">
<a href="change_trans_password.php" class="nav-link nav-toggle"> <i class="material-icons">event</i>
<span class="title">Change Trans Password</span>
</a>
</li>
</ul>
</div>
</div>
</div>
<!-- end sidebar menu -->
<!-- start page content -->
<div class="page-content-wrapper">
<div class="page-content">
<div class="page-bar">
<div class="page-title-breadcrumb">
<div class=" pull-left">
<div class="page-title">Dashboard</div>
</div>
<ol class="breadcrumb page-breadcrumb pull-right">
<li><i class="fa fa-home"></i> <a class="parent-item" href="main_home.php">Home</a> <i class="fa fa-angle-right"></i>
</li>
<li class="active">Dashboard</li>
</ol>
</div>
</div>
<!-- start widget -->
<div class="row">
<div class="col-md-6">
<div class="card card-topline-aqua">
<div class="card-head">
<header>Update Product Qty</header>
</div>
<div class="card-body ">
<form class="form-horizontal" method="post" action="stock_mangement.php" enctype="multipart/form-data">
<div class="row">
<div class="col-sm-10">
<div class="form-group">
<select class="form-control select2" name="product_no" required>
<option value="">Select Product</option>
<?php
$select_query = "select * from products WHERE q_no='0' ORDER BY serial ASC";
$run = mysqli_query($con,$select_query);
while ($row = mysqli_fetch_array($run)) {
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$cp = $row['cp'];
$bv = $row['bv'];
$mrp = $row['mrp'];
$image = $row['image'];
$qty = $row['qty'];
?>
<option value="<?= $product_id; ?>"><?= $product_title; ?></option>
<?php } ?>
</select>
</div>
<br>
<div class="form-group">
<input type="number" name="qty" placeholder="Enter Product Qty" class="form-control">
</div>
</div>
</div>
<div class="form-group text-right">
<div class="">
<button class="btn btn-danger btn-block waves-effect waves-light" type="submit" style="max-width: 200px;" name="product">Submit</button>
</div>
</div>
</form>
</div>
</div>
</div>
<div class="col-md-12">
<div class="card card-topline-red">
<div class="card-head">
<header>Stock Management</header>
</div>
<div class="card-body ">
<table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example4">
<thead>
<tr>
<th> S.No </th>
<th> Product Title </th> <th> CP </th>
<th>BV</th>
<th> MRP </th>
<th>Total Product</th>
<th>Sale</th>
<th>Available</th>
</tr>
</thead>
<tbody>
<?php
$select_query = "select * from products WHERE q_no='0' ORDER BY serial ASC";
$run = mysqli_query($con,$select_query);
$serial = 1;
while ($row = mysqli_fetch_array($run)) {
$s_num = $serial++;
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$cp = $row['cp'];
$bv = $row['bv'];
$mrp = $row['mrp'];
$image = $row['image'];
$query_total_stock = "SELECT SUM(qty) FROM stock_list where product_id='$product_id'";
// Print out result
$result_total_stock = mysqli_query($con, $query_total_stock);
while($row_total_stock = mysqli_fetch_array($result_total_stock)){
$qty = $row_total_stock['SUM(qty)'];
}
$query_total_wallet = "SELECT SUM(qty) FROM final_order where product_code='$product_id' AND order_id > '6805'";
// Print out result
$result_total_wallet = mysqli_query($con, $query_total_wallet);
while($row_total_wallet = mysqli_fetch_array($result_total_wallet)){
$sale_products = $row_total_wallet['SUM(qty)'];
}
if ($qty > $sale_products) {
$available_products = $qty - $sale_products;
}
else {
$available_products = 0;
}
?>
<tr class="odd gradeX">
<td><?= $s_num; ?></td>
<td><?= $product_title; ?></td>
<td><?= $cp; ?></td>
<td><?= $bv; ?></td>
<td><?= $mrp; ?></td>
<td><?= $qty; ?></td>
<td><?= $sale_products; ?></td>
<td><?= $available_products; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="card card-topline-red">
<div class="card-head">
<header>Stock Update List</header>
</div>
<div class="card-body ">
<table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example1">
<thead>
<tr>
<th> S.No </th>
<th> Date </th>
<th> Product Title </th>
<th>Qty</th>
<th>Update</th>
</tr>
</thead>
<tbody>
<?php
$select_query = "select * from stock_list ORDER BY stock_id DESC";
$run = mysqli_query($con,$select_query);
$serial = 1;
while ($row = mysqli_fetch_array($run)) {
$s_num = $serial++;
$stock_id = $row['stock_id'];
$product_id = $row['product_id'];
$qty = $row['qty'];
$date = $row['date'];
$select_query_ss = "select * from products WHERE product_id='$product_id'";
$run_ss = mysqli_query($con,$select_query_ss);
while ($row_ss = mysqli_fetch_array($run_ss)) {
$product_id_ss = $row_ss['product_id'];
$product_title_ss = $row_ss['product_title'];
$cp_ss = $row_ss['cp'];
$bv_ss = $row_ss['bv'];
$mrp_ss = $row_ss['mrp'];
$image_ss = $row_ss['image'];
}
?>
<tr class="odd gradeX">
<td><?= $s_num; ?></td>
<td><?= $date; ?></td>
<td><?= $product_title_ss; ?></td>
<td><?= $qty; ?></td>
<td>
<button type="button" class="btn btn-primary btn-mini"
data-toggle="modal" data-target="#exampleModal<?= $stock_id; ?>">SUBMIT</button>
<div class="modal fade" id="exampleModal<?= $stock_id; ?>" tabindex="-1" role="dialog"
aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<form method="post" action="stock_mangement.php" enctype="multipart/form-data" >
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="exampleModalLabel">STOCK UPDATES</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="form-group row">
<label for="example-text-input" class="col-sm-4 col-form-label">PRODUCT QTY</label>
<div class="col-sm-8">
<div class="form-group">
<input type="number" name="qty" value="<?= $qty; ?>" class="form-control">
</div>
</div>
</div>
<input type="hidden" name="stock_id" value="<?= $stock_id; ?>">
</div>
<div class="modal-footer">
<button type="submit" name="submit_update" class="btn btn-primary">Update</button>
</div>
</div>
</form>
</div>
</div>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- end page content -->
</div>
<!-- end page container -->
<!-- start footer -->
<div class="page-footer">
<div class="page-footer-inner"> 2018 ©. All Rights Reserved.
</div>
<div class="scroll-to-top">
<i class="icon-arrow-up"></i>
</div>
</div>
<!-- end footer -->
</div>
<!-- start js include path -->
<script src="assets/plugins/jquery/jquery.min.js" ></script>
<script src="assets/plugins/popper/popper.min.js" ></script>
<script src="assets/plugins/jquery-blockui/jquery.blockui.min.js" ></script>
<script src="assets/plugins/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- bootstrap -->
<script src="assets/plugins/bootstrap/js/bootstrap.min.js" ></script>
<!-- data tables -->
<script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
<script src="assets/plugins/datatables/plugins/bootstrap/dataTables.bootstrap4.min.js" ></script>
<script src="assets/js/pages/table/table_data.js" ></script>
<!-- Common js-->
<script src="assets/js/app.js" ></script>
<script src="assets/js/layout.js" ></script>
<script src="assets/js/theme-color.js" ></script>
<!-- Material -->
<script src="assets/plugins/material/material.min.js"></script>
<!-- animation -->
<script src="assets/js/pages/ui/animations.js" ></script>
<!-- end js include path -->
</body>
</html>
<?php
if (isset($_POST['product'])) {
$product_no = $_POST['product_no'];
$select_query = "select * from products where product_id='$product_no'";
$run = mysqli_query($con,$select_query);
while ($row = mysqli_fetch_array($run)) {
$product_id = $row['product_id'];
$product_title = $row['product_title'];
$cp = $row['cp'];
$bv = $row['bv'];
$mrp = $row['mrp'];
$image = $row['image'];
$qty = $row['qty'];
}
$qty_1 = $_POST['qty'];
$date_of_join = date("Y-m-d H:i:s");
$insert_query = "insert into stock_list(product_id, qty, date) values('$product_id', '$qty_1', '$date_of_join')";
if (mysqli_query($con,$insert_query)) {
echo "<script>alert('Stock has been successfully Added...')</script>";
echo "<script>window.open('stock_mangement.php','_self')</script>";
}
}
?>
<?php
if (isset($_POST['submit_update'])) {
$stock_id = $_POST['stock_id'];
$qty_1 = $_POST['qty'];
$date_of_join = date("Y-m-d H:i:s");
$insert_query = "update stock_list set qty='$qty_1' where stock_id='$stock_id'";
if (mysqli_query($con,$insert_query)) {
echo "<script>alert('Stock has been successfully Updated...')</script>";
echo "<script>window.open('stock_mangement.php','_self')</script>";
}
}
?>
<?php } ?>