Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/skjewel

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: addkbill.php

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
session_start();
include("includes/inall.php");

$action = $_REQUEST['action'] ?? 'Add';
$editid = $_REQUEST['editid'] ?? '';
$table = "sales_kheader";

if (isset($_POST['submitin']) && $_POST['submitin'] == "Add") {
    $dc = date("Y-m-d");
    $totalitemval = 0;

$so_no = addslashes($_POST['so_no'] ?? '');
    $doc_date = addslashes($_POST['doc_date'] ?? '');
    $kr_pay = addslashes($_POST['kr_pay'] ?? '');
    $kr_id = addslashes($_POST['kr_id'] ?? '');
    $path = "";

if (isset($_FILES['doc_file']['name']) && $_FILES['doc_file']['name'] != "") {
        $userfile_name = $_FILES['doc_file']['name'];
        $userfile_tmp = $_FILES['doc_file']['tmp_name'];
        $path = time() . "_" . basename($userfile_name);
        $uppath = "uimages/" . $path;
        move_uploaded_file($userfile_tmp, $uppath);
    }

$norows = $_POST['norows'];
    for ($i = 1; $i <= $norows; $i++) {
        $proname = $_POST["proname$i"] ?? '';
        $prorefarr = explode(" -*- ", $proname);
        $proname = $prorefarr[1] ?? $proname;
        $qty = $_POST["bqty$i"] ?? 0;
        $rate = $_POST["rate$i"] ?? 0;
        $itemtot = round($qty * $rate, 2);
        $totalitemval += $itemtot;
    }

$sl_total = isset($_POST['sl_total']) && $_POST['sl_total'] !== '' ? floatval($_POST['sl_total']) : $totalitemval;

$insert_sql_data = array(
        'sl_date' => $dc,
        'kr_pay' => $kr_pay,
        'kr_id' => $kr_id,
        'sl_st' => "1",
        'sl_unid' => $so_no,
        'sl_docdate' => $doc_date,
        'doc_file' => $path,
'sl_total' => $sl_total
    );

$ins_query = tep_db_perform("sales_kheader", $insert_sql_data, "insert");
    $ref = mysqli_insert_id($con);

for ($i = 1; $i <= $norows; $i++) {
        $proname = $_POST["proname$i"] ?? '';
        $prorefarr = explode(" -*- ", $proname);
        $proname = $prorefarr[1] ?? $proname;
        $qty = $_POST["bqty$i"] ?? 0;
        $rate = $_POST["rate$i"] ?? 0;
        $itemtot = round($qty * $rate, 2);

if ($proname != "" && $qty != "" && $rate != "") {
            $item_data = array(
                'sl_id' => $ref,
                'pro_name' => $proname,
                'sales_qty' => $qty,
                'sales_rate' => $rate,
                'sales_tval' => $itemtot
            );
            tep_db_perform("sales_kitem", $item_data, "insert");
        }
    }

$totalitemval = round($totalitemval, 2);
    mysqli_query($con, "UPDATE `sales_kheader` SET `sl_total`='$totalitemval' WHERE `sl_id`='$ref'");

mysqli_query($con, "INSERT INTO khata_dpwt (pdate, karigar, deposit, note, date, status) 
        VALUES ('$dc', '$kr_id', '$totalitemval', '$so_no', '$dc', '1')");

if ($ins_query) {
        $_SESSION['msg'] = "Successfully Added.";
        header("location:addkbill.php");
        exit();
    } else {
        $_SESSION['msgerr'] = "Some Error Occurred.";
        header("location:addkbill.php");
        exit();
    }
}

if (isset($_POST['submitin']) && $_POST['submitin'] == "Edit") {
    $totalitemval = 0;
    $doc_date = addslashes($_POST['doc_date'] ?? '');
    $kr_pay = addslashes($_POST['kr_pay'] ?? '');
    $kr_id = addslashes($_POST['kr_id'] ?? '');
    $path = "";

$norows = $_POST['norows'];
    for ($i = 1; $i <= $norows; $i++) {
        $qty = $_POST["bqty$i"] ?? 0;
        $rate = $_POST["rate$i"] ?? 0;
        $itemtot = round($qty * $rate, 2);
        $totalitemval += $itemtot;
    }

$sl_total = isset($_POST['sl_total']) && $_POST['sl_total'] !== '' ? floatval($_POST['sl_total']) : $totalitemval;

$update_data = array(
        'kr_pay' => $kr_pay,
        'kr_id' => $kr_id,
        'sl_docdate' => $doc_date,
'sl_total' => $sl_total
    );
    if ($path != "") {
        $update_data['doc_file'] = $path;
    }

tep_db_perform("sales_kheader", $update_data, "update", "sl_id=" . $editid);

mysqli_query($con, "DELETE FROM `sales_kitem` WHERE `sl_id`='$editid'");

$ref = $editid;
    for ($i = 1; $i <= $norows; $i++) {
        $proname = $_POST["proname$i"] ?? '';
        $prorefarr = explode(" -*- ", $proname);
        $proname = $prorefarr[1] ?? $proname;
        $qty = $_POST["bqty$i"] ?? 0;
        $rate = $_POST["rate$i"] ?? 0;
        $itemtot = round($qty * $rate, 2);

$totalitemval = round($totalitemval, 2);
    mysqli_query($con, "UPDATE `sales_kheader` SET `sl_total`='$totalitemval' WHERE `sl_id`='$ref'");

$rowk = mysqli_fetch_array(mysqli_query($con, "SELECT sl_unid FROM sales_kheader WHERE sl_id = '$editid'"));
    $note = $rowk['sl_unid'];

mysqli_query($con, "DELETE FROM khata_dpwt WHERE note = '$note' AND karigar = '$kr_id'");

mysqli_query($con, "INSERT INTO khata_dpwt (pdate, karigar, deposit, note, date, status) 
        VALUES ('$doc_date', '$kr_id', '$totalitemval', '$note', '$doc_date', '1')");

$_SESSION['msg'] = "Successfully Updated.";
    header("location:billk.php?id=" . $editid);
    exit();
}

if ($_POST['submitin'] == "" && $action == "Edit") {
    $rowm = mysqli_fetch_array(mysqli_query($con, "SELECT * FROM `sales_kheader` WHERE `sl_id`='$editid'"));
    $newid = $rowm['sl_unid'];
    $dt = $rowm['sl_docdate'];
    $newgtotal = $rowm['gtotal'];
}

if ($dt == "") {
    $dt = date("Y-m-d");
}

if ($action == "Add") {
    $newid = "";
    $res = mysqli_query($con, "SELECT * FROM `sales_kheader` ORDER BY `sl_id` DESC");
    if (mysqli_num_rows($res) < 1) {
        $newid = "1";
    } else {
        $row = mysqli_fetch_array($res);
        $last_id = $row['sl_unid'];
        $newid = $last_id + 1;
    }
}

include("includes/headermain.php");
?>
<script>
function updateTotal() {
    let total = 0;
    let norows = document.getElementById("norows").value;
    for (let i = 1; i <= norows; i++) {
        let qty = parseFloat(document.getElementById("bqty" + i)?.value || 0);
        let rate = parseFloat(document.getElementById("rate" + i)?.value || 0);
        total += qty * rate;
    }
    document.getElementById("sl_total").value = total.toFixed(2);
}

document.addEventListener("DOMContentLoaded", function () {
    const norows = document.getElementById("norows")?.value || 0;
    for (let i = 1; i <= norows; i++) {
        document.getElementById("bqty" + i)?.addEventListener("input", updateTotal);
        document.getElementById("rate" + i)?.addEventListener("input", updateTotal);
    }
});
</script>

<div class="cleaner"></div>
								<div class="form-group col-md-12 floatleft">
									<label for="example-text-input" class="col-form-label">Image</label>
									<input class="form-control" type="file" name="doc_file" id="doc_file" value="<?php print $rowm['doc_file']; ?>">
									<?php if($rowm['doc_file']) { ?>
									 	<a href="uimages/<?php print $rowm['doc_file']; ?>" target="_new">View Image</a>
                               		<?php } ?>
								</div>
								<div class="cleaner"></div>
								<button type="submit" class="btn btn-primary mt-4 pr-4 pl-4">Submit</button>
							</form>	
						</div>
					</div>
				</div>
			</div>
			
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addkbill.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation