| 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/app/ |
Upload File : |
<?php
session_start();
if (!isset($_SESSION['distributor_id'])) {
header("location: login.php");
}
else {
include("includes/database.php");
$page_user = $_SESSION['distributor_id'];
$select_query = "select * from member where user_id='$page_user'";
$run = mysqli_query($con,$select_query);
$serial = 1;
while ($row = mysqli_fetch_array($run)) {
$s_num = $serial++;
$member_id = $row['member_id'];
$profile = $row['profile'];
$title = $row['title'];
$dob = $row['dob'];
$name = $row['name'];
$gender = $row['gender'];
$address_1 = $row['address_1'];
$address_2 = $row['address_2'];
$town_area = $row['town_area'];
$city_district = $row['city_district'];
$state = $row['state'];
$country = $row['country'];
$pincode = $row['pincode'];
$mobile_number = $row['mobile_number'];
$email = $row['email'];
$aadhaar_card = $row['aadhaar_card'];
$pan_card = $row['pan_card'];
$nominee_name = $row['nominee_name'];
$nominee_relationship = $row['nominee_relationship'];
$account_name = $row['account_name'];
$account_number = $row['account_number'];
$ifsc_code = $row['ifsc_code'];
$bank_name = $row['bank_name'];
$branch_name = $row['branch_name'];
$member_no = $row['member_no'];
$user_id = $row['user_id'];
$password = $row['password'];
$aadhaar_card_image = $row['aadhaar_card_image'];
$pan_card_image = $row['pan_card_image'];
$bank_proof_image = $row['bank_proof_image'];
$document_status = $row['document_status'];
$member_fess = $row['member_fess'];
$activity_level = $row['activity_level'];
$activity_referral = $row['activity_referral'];
$activity_date = $row['activity_date'];
$activity_month = $row['activity_month'];
$elite_board = $row['elite_board'];
$aadhaar_card_image = $row['aadhaar_card_image'];
$pan_card_image = $row['pan_card_image'];
$bank_proof_image = $row['bank_proof_image'];
$document_status = $row['document_status'];
$date_of_join_1 =$row['date_of_join'];
$eproduct_password = $row['eproduct_password'];
$date_of_join = date('d-m-Y', strtotime($date_of_join_1));
$select_query_direct_level = "select * from eproduct_details_roi where receiver_no = '$member_no' AND eproduct_status <> 'used'";
$run_direct_level = mysqli_query($con,$select_query_direct_level);
$numrows_m_2 = mysqli_num_rows($run_direct_level);
?><!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no" name="viewport">
<title>RAKCHABLOOMING</title>
<!-- General CSS Files -->
<link rel="stylesheet" href="assets/css/app.min.css">
<!-- Template CSS -->
<link rel="stylesheet" href="assets/bundles/datatables/datatables.min.css">
<link rel="stylesheet" href="assets/bundles/datatables/DataTables-1.10.16/css/dataTables.bootstrap4.min.css">
<link rel="stylesheet" href="assets/css/style.css">
<link rel="stylesheet" href="assets/css/components.css">
<!-- Custom style CSS -->
<link rel="stylesheet" href="assets/css/custom.css">
<link rel='shortcut icon' type='image/x-icon' href='assets/img/favicon.ico' />
<style type="text/css">
td {
text-transform: uppercase;
}
</style>
</head>
<body>
<div class="loader"></div>
<div id="app">
<div class="main-wrapper main-wrapper-1">
<div class="navbar-bg"></div>
<?php include("includes/header.php"); ?>
<!-- Main Content -->
<div class="main-content">
<section class="section">
<div class="section-body">
<?php
if ($eproduct_password == '') {
?>
<div class="row">
<div class="col-xl-8">
<div class="card card-default">
<div class="card-header with-border">
<h3 class="card-title">Product purchase</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<div class="row">
<div class="col-xl-12">
<form class="form-horizontal" method="post" action="billing_amount.php" enctype="multipart/form-data">
<div class="row">
<div class="col-sm-4">
<div class="form-group">
<label>Enter RC ID</label>
<select class="form-control select2" name="member_no" required onchange="fetch_select(this.value);">
<?php
$select_query = "select * from member WHERE user_id='$page_user'";
$run = mysqli_query($con,$select_query);
while ($row = mysqli_fetch_array($run)) {
$s_num = $serial++;
$name = $row['name'];
$user_id = $row['user_id'];
$member_no = $row['member_no'];
?>
<option value="<?= $user_id; ?>"><?= $user_id; ?> - <?= $name; ?></option>
<?php } ?>
</select>
</div>
<div id="fetch">
</div>
</div>
</div>
<div class="col-sm-12">
<table class="table table-striped table-bordered table-hover table-checkable order-column" style="width: 100%" id="example">
<thead>
<tr>
<th> S.No </th>
<th> Product Title </th> <th> CP </th>
<th>PV</th>
<th> MRP </th>
<th>Available</th>
<th>QTY</th>
</tr>
</thead>
<tbody>
<?php
$select_query = "select * from products WHERE view='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'];
$q_no = $row['q_no'];
if ($q_no == 0) {
$prodcut_new = "NEW";
}
else {
$prodcut_new = "OLD";
}
$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;
}
?>
<?php
if ($available_products <= 14) {
?>
<tr class="odd gradeX" style="background-color:yellow !important;">
<?php
}else {
?>
<tr class="odd gradeX">
<?php
}
?>
<td><?= $s_num; ?></td>
<td style="text-transform: uppercase;"><?= $product_title; ?> - <?= $prodcut_new; ?></td>
<td><?= $cp; ?></td>
<td><?= $bv; ?></td>
<td><?= $mrp; ?></td>
<td><?= $available_products; ?></td>
<td>
<input type="number" name="<?= $product_id; ?>" class="form-control" value="0">
<input type="hidden" name="cp<?= $product_id; ?>" class="form-control" value="<?= $cp; ?>">
<input type="hidden" name="bv<?= $product_id; ?>" class="form-control" value="<?= $bv; ?>">
<input type="hidden" name="mrp<?= $product_id; ?>" class="form-control" value="<?= $mrp; ?>">
</td>
</tr>
<?php } ?>
</tbody>
</table>
</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>
<!-- /.col -->
</div>
<!-- /.row -->
</div>
<!-- /.card-body -->
</div>
</div>
<div class="col-xl-4"></div>
</div>
<?php
}else {
?>
<div class="row">
<div class="col-xl-4"></div>
<div class="col-xl-4">
<div class="card card-default">
<div class="card-header with-border">
<h3 class="card-title">KIT Login</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<div class="row">
<div class="col-xl-12">
<form method="post" action="eproduct_login.php" enctype="multipart/form-data">
<input type="hidden" name="member_no" value="<?= $member_no; ?>">
<div class="form-group row">
<div class="col-sm-12">
<input class="form-control" type="password" name="eproduct_password" placeholder="Enter Your KIT Password">
</div>
</div>
<div class="card-footer">
<button type="submit" name="submit" class="btn btn-primary pull-right">Submit</button>
</div>
</form>
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</div>
<!-- /.card-body -->
</div>
</div>
<div class="col-xl-4"></div>
</div>
<?php } ?>
</div>
</section>
</div>
<footer class="main-footer">
<div class="footer-left">
Copyright © 2021 <div class="bullet"></div> All Rights Reserved.
</div>
<div class="footer-right">
</div>
</footer>
</div>
</div>
<!-- General JS Scripts -->
<script src="assets/js/app.min.js"></script>
<!-- JS Libraies -->
<!-- Page Specific JS File -->
<script src="assets/bundles/datatables/datatables.min.js"></script>
<script src="assets/bundles/datatables/DataTables-1.10.16/js/dataTables.bootstrap4.min.js"></script>
<script src="assets/bundles/datatables/export-tables/dataTables.buttons.min.js"></script>
<script src="assets/bundles/datatables/export-tables/buttons.flash.min.js"></script>
<script src="assets/bundles/datatables/export-tables/jszip.min.js"></script>
<script src="assets/bundles/datatables/export-tables/pdfmake.min.js"></script>
<script src="assets/bundles/datatables/export-tables/vfs_fonts.js"></script>
<script src="assets/bundles/datatables/export-tables/buttons.print.min.js"></script>
<script src="assets/js/page/datatables.js"></script>
<!-- Template JS File -->
<script src="assets/js/scripts.js"></script>
<!-- Custom JS File -->
<script src="assets/js/custom.js"></script>
<script type="text/javascript">
function goBack() {
window.history.back();
}
</script>
</body>
</html>
<?php
if (isset($_POST['submit'])) {
$member_no = $_POST['member_no'];
$eproduct_password = $_POST['eproduct_password'];
$admin_query = "select * from member where member_no = '$member_no' AND eproduct_password = '$eproduct_password'";
$run = mysqli_query($con,$admin_query);
if (mysqli_num_rows($run)>0) {
$_SESSION['eproduct_password'] = $eproduct_password;
session_write_close();
echo "<script>window.open('eproduct_details.php','_self')</script>";
}
else {
echo "<script>alert('please enter correct Eproduct password')</script>";
exit;
}
}
if (isset($_POST['create'])) {
$member_no = $_POST['member_no'];
$eproduct_password = $_POST['eproduct_password'];
$confirm_password = $_POST['confirm_password'];
if ($eproduct_password == $confirm_password) {
mysqli_query($con,"update member set eproduct_password='$eproduct_password' where member_no = '$member_no'");
$_SESSION['eproduct_password'] = $eproduct_password;
echo "<script>window.open('eproduct_details.php','_self')</script>";
}
else {
echo "<script>alert('Miss Match Password and Conform Password')</script>";
exit;
}
}
?>
<?php } } ?>