Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.70.1.lve.el8.x86_64

PHP Version:

8.1.33

User:

u998488001

Directory:

/home/u998488001/domains/grindustries.in/public_html/Admin

Free Space:

1.81 TB

🔧 Quick Actions

✏️ Editing: salesInc.php

<?php
include 'header.php';
include 'menu.php';

session_start();
$cid = $_SESSION['cid'];
?>
<link rel="stylesheet" href="plugins/toastr/toastr.min.css">
<script src="plugins/jquery/jquery.min.js"></script>
<script src="plugins/toastr/toastr.min.js"></script>
<?php
if ($_SESSION['qry'] == "ErrorPage") {
?>
    <script>
        toastr.error("Restriction to access page!!!", "My SHOP");
    </script>
<?php

$_SESSION['qry'] = "";
} else if ($_SESSION['qry'] == "InsSaleInc") {
?>
    <script>
        toastr.success("Sales Bill Inserted!!!", "My SHOP");
    </script>
<?php
    $_SESSION['qry'] = "";
} else if ($_SESSION['qry'] == "DeleteSaleInc") { ?>
    <script>
        toastr.success("Sales Bill Deleted!!!", "My SHOP");
    </script>
<?php
    $_SESSION['qry'] = "";
} else if ($_SESSION['qry'] == "DeleteSaleIncERR") { ?>
    <script>
        toastr.error("Something Wrong With Delete!!!", "My SHOP");
    </script>
<?php
    $_SESSION['qry'] = "";
}
?>
<script>
    $(document).ready(function() {
        var gnm, cnm, bd;

$("#selectGroup").change(function() {
            catnm = $(this).find("option:selected").val();
            gnm = catnm;

$.post(
                "select_cat.php", {
                    cat: catnm
                },
                function(data, status) {
                    $("#selectCat").empty();

$("#selectCat").append(data);

});
        });

$("#selectCat").change(function() {
            catnm = $(this).find("option:selected").val();
            cnm = catnm;
            $.post(
                "select_brand.php", {
                    cat: catnm,
                    gnm: gnm
                },
                function(data, status) {
                    $("#selectBrand").empty();
                    $("#selectBrand").append(data);

});
        });

$("#selectBrand").change(function() {
            brd = $(this).find("option:selected").val();
            bd = brd;
            $.post(
                "select_product.php", {
                    cat: cnm,
                    gnm: gnm,
                    brand: bd
                },
                function(data, status) {
                    $("#selectProduct").empty();
                    $("#selectProduct").append(data);

});
        });
        $("#selectProduct").change(function() {
            prd = $(this).find("option:selected").val();

$.post(
                "select_product.php", {
                    type: "Prd_data",
                    cat: cnm,
                    gnm: gnm,
                    brand: bd,
                    prd: prd
                },
                function(data, status) {
                    $("#txtAmt").empty();
                    $("#txtAmt").val(data);

});
            //alert(gnm+" "+cnm+" "+bd+" "+prd);
        });

});
</script>

<div class="content-wrapper">
    <div class="content-header">
        <div class="container-fluid">
            <div class="card">
                <div class="card-body">
                    <h1 class="m-0 text-center text-primary">Sale Invoice</h1>
                </div>
            </div>
        </div>
    </div>
    <section class="content">
        <div class="container-fluid">
            <form action="action_rec.php" method="POST" enctype="multipart/form-data">
                <input type="hidden" name="type" value="saleInsRec">
                <div class="card">
                    <div class="card-body">
                        <div class="row">
                            <div class="col-4 ">
                                <input type="date" name="slsDate" placeholder="Select Bill Date" class="form-control">
                            </div>
                            <div class="col-4 ">
                                <input type="text" name="slsno" placeholder="Enter Bill No" class="form-control">
                            </div>
                            <div class="col-4">

<select class="form-select form-control select2 " style="width:100%;" name="selectClient" id="selectClient">
                                    <option value="" selected>Select Client</option>
                                    <?php
                                    $cid = $_SESSION['cid'];
                                    $sql = "select * from cclient where cid='$cid' order by firstname ASC";
                                    $res = mysqli_query($conn, $sql);
                                    while ($row = mysqli_fetch_assoc($res)) {
                                    ?>
                                        <option value="<?php echo $row['id']; ?>"><?php echo $row['firstname'] . " " . $row['lastname'] . " ( " . $row['mobile'] . " )"; ?></option>
                                    <?php
                                    }
                                    ?>
                                </select>
                            </div>
                        </div>
                        <br>
                        <div class="row">
                            <div class="col-4 ">
                                <select class=" form-control select2 " style="width:100%;" name="selectGroup" id="selectGroup">
                                    <option value="" data-tokens="Select Product Group">Select Product Group</option>
                                    <?php
                                    $cid = $_SESSION['cid'];
                                    $sql = "select * from product_group where cid='$cid' order by group_name ASC";
                                    $res = mysqli_query($conn, $sql);
                                    while ($row = mysqli_fetch_assoc($res)) {
                                    ?>
                                        <option value="<?php echo $row['id']; ?>" data-tokens="<?php echo $row['group_name']; ?>"><?php echo $row['group_name']; ?></option>
                                    <?php
                                    }
                                    ?>
                                </select>
                            </div>

<div class="col-4 ">
                                <select class="form-control select2" style="width:100%;" name="selectCat" id="selectCat">
                                    <option value="" selected>Select Product Category</option>
                                </select>
                            </div>

<div class="col-4 ">
                                <select class=" form-control select2 " style="width:100%;" name="selectBrand" id="selectBrand">
                                    <option value="" selected>Select Product Brand</option>

</select>
                            </div>
                        </div>
                        </br>
                        <div class="row">
                            <div class="col-3 ">
                                <select class="form-control select2" style="width:100%;" name="selectProduct" id="selectProduct">
                                    <option value="" selected>Select Product</option>
                                </select>
                            </div>
                            <div class="col-2">
                                <input type="text" name="txtqnt" id="txtqnt" onkeyup="if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')" placeholder="Enter Quantity" class="form-control " />
                            </div>
                            <div class="col-2">
                                <input type="text" name="txtAmt" id="txtAmt" onkeyup="if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')" placeholder="Enter Amount" class="form-control" />
                            </div>

<div class="col-3">
                                <select class=" form-control select2 " style="width:100%;" name="selectRef" id="selectRef">
                                    <option value="" selected>Reference</option>
                                    <?php
                                    $cid = $_SESSION['cid'];
                                    $sql = "select * from cclient where cid='$cid' order by firstname ASC";
                                    $res = mysqli_query($conn, $sql);
                                    while ($row = mysqli_fetch_assoc($res)) {
                                    ?>
                                        <option value="<?php echo $row['id']; ?>"><?php echo $row['firstname'] . " " . $row['lastname'] . " ( " . $row['mobile'] . " )"; ?></option>
                                    <?php
                                    }
                                    ?>

</select>
                            </div>

<div class="col-2">
                                <select class="form-control select2" style="width:100%;" name="selectRefPoint" id="selectRefPoint">
                                    <option value="">Select Point</option>
                                    <option value="0.25">0.25</option>
                                    <option value="0.50">0.50</option>
                                    <option value="0.75">0.75</option>
                                    <option value="1.00">1.00</option>
                                    <option value="1.25">1.25</option>
                                    <option value="1.50">1.50</option>
                                    <option value="1.75">1.75</option>
                                    <option value="2.00">2.00</option>
                                </select>
                            </div>
                        </div><br>
                        <input type="submit" id="button1" class="btn btn-block btn-primary" value="Save" />
                    </div>
                </div>
                <div class="card">
                    <div class="card-body">
                        <table id="example1" style="width:100%;" class="table table-bordered table-sm table-striped">
                            <thead>
                                <tr>
                                    <th class="text-center" style="width:5%;">#</th>
                                    <th class="text-center" style="width:10%;">Bill No</th>
                                    <th class="text-center" style="width:13%;">Product Name</th>
                                    <th class="text-center" style="width:13%;">Customer Name</th>
                                    <th class="text-center" style="width:14%;">Reference</th>
                                    <th class="text-center" style="width:20%;">Sales Date</th>
                                    <th class="text-center" style="width:10%;">Final Amount</th>
                                    <th class="text-center" style="width:10%;">Action</th>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                $cid = $_SESSION['cid'];
                                $i = 0;
                                $sql = "select * from sales where cid='$cid'";
                                $res = mysqli_query($conn, $sql);
                                while ($row = mysqli_fetch_assoc($res)) {
                                    $pid = $row['prod_id'];
                                    $client = $row['cst_id'];
                                    $i++;
                                ?>
                                    <tr>
                                        <td class="text-center"><?php echo $i; ?></td>
                                        <td class="text-center"><?php echo $row['blno']; ?></td>
                                        <?php
                                        $sql1 = "select * from product where id='$pid'";
                                        $res1 = mysqli_query($conn, $sql1);
                                        $row1 = mysqli_fetch_assoc($res1);
                                        ?>
                                        <td class="text-center"><?php echo $row1['product_name']; ?></td>
                                        <?php
                                        $sql2 = "select * from cclient where id='$client'";
                                        $res2 = mysqli_query($conn, $sql2);
                                        $row2 = mysqli_fetch_assoc($res2);
                                        ?>
                                        <td class="text-center"><?php echo $row2['firstname'] . " " . $row2['lastname']; ?></td>
                                        <?php

if ($refid != 0) {
                                        ?>

<td class="text-center"><?php echo $row3['firstname'] . " " . $row3['lastname']; ?></td>
                                        <?php } else {
                                            $sql3 = "select * from cclient where `id`='$client' and `ref_id`='$refid'";
                                            $res3 = mysqli_query($conn, $sql3);

$row3 = mysqli_fetch_assoc($res3);

?>
                                            <td class="text-center">No Reference.</td>
                                        <?php } ?>
                                        <td class="text-center"><?php echo $row['Sale_date']; ?></td>

</form>
        </div>
    </section>
</div>
<?php
include 'footer.php';
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: salesInc.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation