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/systemuniq

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: editproductsp.php

<?php
ob_start();
session_start();
include("includes/inall.php");

$eid = isset($_REQUEST['eid']) ? $_REQUEST['eid'] : '';
$action = "Update"; // Explicitly set for the update form

if (isset($_POST['submitin']) && $_POST['submitin'] == "Update") {
    $eid = $_POST['eid'];

// 1. Prepare Main Product Data
    // These match the 'name' attributes in your HTML form
    $update_array = array(
        'pro_name'    => addslashes($_POST['pro_name']),
        'pro_setting' => $_POST['pro_setting'],
        'pro_srate'   => $_POST['pro_srate'],
        'pro_hook'    => $_POST['pro_hook'],
        'pro_hrate'   => $_POST['pro_hrate'],
        'pro_setting2'=> $_POST['pro_setting2'],
        'pro_srate2'  => $_POST['pro_srate2'],
        'pro_wtw'     => $_POST['pro_wtw'],
        'pro_wrate'   => $_POST['pro_wrate'],
        'pro_plsh'    => $_POST['pro_plsh'],
        'pro_prate'   => $_POST['pro_prate'],
        'pro_rodi'    => $_POST['pro_rodi'],
        'pro_rrate'   => $_POST['pro_rrate'],
        'pro_chelai'  => $_POST['pro_chelai'],
        'pro_total'   => $_POST['pro_total'],
        'pro_gst'     => $_POST['pro_gst'],
        'cost'        => $_POST['cost']
    );

// 2. Handle Image Upload (Optional Update)
    if ($_FILES['pro_image']['name'] != "") {
        $img_name = time() . "_" . $_FILES['pro_image']['name'];
        if (move_uploaded_file($_FILES['pro_image']['tmp_name'], "uimages/" . $img_name)) {
            $update_array['pro_image'] = $img_name;
        }
    }

// 3. Execute Main Update
    // Assuming your tep_db_perform or similar function handles the query
    tep_db_perform("product_mastersp", $update_array, "update", "pro_id = '$eid'");

// 4. Update Stone Details (The "Delete and Re-insert" Strategy)
    // First, clear old stone data for this specific product
    mysqli_query($con, "DELETE FROM `product_msspdt` WHERE `pro_ref` = '$eid'");

// Loop through the rows based on the 'norows' counter from your form
    $norows = $_POST['norows'];
    for ($i = 1; $i <= $norows; $i++) {
        $stone_code = $_POST["proref" . $i];
        
        // Only insert if a stone code/name is provided
        if (!empty($stone_code)) {
            $stone_array = array(
                'pro_ref'    => $eid,
                'pro_code'   => $stone_code,
                'pro_size'   => $_POST["size" . $i],
                'pro_shape'  => $_POST["shape" . $i],
                'pro_color'  => $_POST["color" . $i],
                'pro_qty'    => $_POST["bqty" . $i],
                'pro_rate'   => $_POST["rate" . $i],
                'pro_stotal' => $_POST["stotal" . $i]
            );
            tep_db_perform("product_msspdt", $stone_array, "insert");
        }
    }

$_SESSION['msg'] = "Product and Stones updated successfully!";
    header("Location: viewproductssp.php");
    exit();
}

// --- FETCH MAIN DATA ---
$sql_m = "SELECT * FROM `product_mastersp` WHERE `pro_id`='$eid'";
$res_m = mysqli_query($con, $sql_m);
$rowm = mysqli_fetch_array($res_m);

// Fetch the existing stone details for this product
$res_stones = mysqli_query($con, "SELECT * FROM `product_msspdt` WHERE `pro_ref`='$eid' ORDER BY pdt_id ASC");
$num_stones = mysqli_num_rows($res_stones);

// If no stones found, we still want 1 blank row for the form
$display_rows = ($num_stones > 0) ? $num_stones : 1;

include("includes/headermain.php"); 
?>

// 2. Calculate Labor Rows (Chain, Hook, Polish, etc.)
    var laborItems = [
        { q: 'pro_setting', r: 'pro_srate', t: 'pro_stot' }, // Chain
        { q: 'pro_hook',    r: 'pro_hrate', t: 'pro_htot' }, // Hook
        { q: 'pro_setting2',r: 'pro_srate2',t: 'pro_s2tot'}, // Kacha
        { q: 'pro_wtw',     r: 'pro_wrate', t: 'pro_wtot' }, // Weight
        { q: 'pro_plsh',    r: 'pro_prate', t: 'pro_ptot' }, // Polish
        { q: 'pro_rodi',    r: 'pro_rrate', t: 'pro_rtot' }  // Rhodium
    ];

laborItems.forEach(function(item) {
        var qVal = parseFloat(document.getElementById(item.q).value) || 0;
        var rVal = parseFloat(document.getElementById(item.r).value) || 0;
        var total = qVal * rVal;
        document.getElementById(item.t).value = total.toFixed(2);
        grandTotal += total;
    });

// 3. Add Chelai and Update Grand Total
    var chelai = parseFloat(document.getElementById('pro_chelai').value) || 0;
    grandTotal += chelai;
    document.getElementById('pro_total').value = grandTotal.toFixed(2);
}

function addRow(tableID) {
    var table = document.getElementById(tableID);
    var rowCount = table.rows.length;
    var nextId = parseInt(document.getElementById("norows").value) + 1;
    var row = table.insertRow(rowCount);

row.innerHTML = `
        <td width="6%" class="pd0"><input type="checkbox" name="chk${nextId}"></td>
        <td width="21%" class="pd0"><input type="text" name="proref${nextId}" id="proref${nextId}" class="form-control" style="width: 200px;"></td>
        <td width="12%" class="pd0"><input type="text" name="size${nextId}" id="size${nextId}" class="form-control" style="width: 50px;"></td>
        <td width="12%" class="pd0"><input type="text" name="shape${nextId}" id="shape${nextId}" class="form-control" style="width: 50px;"></td>
        <td width="12%" class="pd0"><input type="text" name="color${nextId}" id="color${nextId}" class="form-control" style="width: 50px;"></td>
        <td width="13%" class="pd0"><input type="text" name="bqty${nextId}" id="bqty${nextId}" class="form-control" style="width: 50px;" onKeyUp="calculateprotot();"></td>
        <td width="12%" class="pd0"><input type="text" name="rate${nextId}" id="rate${nextId}" class="form-control" style="width: 50px;" onKeyUp="calculateprotot();"></td>
        <td width="12%" class="pd0"><input type="text" name="stotal${nextId}" id="stotal${nextId}" class="form-control" style="width: 50px;"></td>
    `;
    document.getElementById("norows").value = nextId;
}
</script>
<body>


<div id="preloader">
	<div class="loader"></div>
</div>


<div class="page-container">

<?php include("includes/leftmenu.php"); ?>


<div class="main-content">

<?php include("includes/header.php"); ?>

<div class="main-content-inner">
    <div class="card">
        <div class="card-body">
            <form action="#" method="post" name="rform" enctype="multipart/form-data">
                <input type="hidden" name="submitin" value="Update">
                <input type="hidden" name="eid" value="<?php print $eid; ?>">
                
                <div class="form-group">
                    <label>*Product Name</label>
                    <input class="form-control" type="text" name="pro_name" id="pro_name" value="<?php print stripslashes($rowm['pro_name']); ?>" required>
                </div>

<div class="cleaner"></div>
                
                <table width="100%" border="0">
                    <tr>
                        <td colspan="9" align="center">
                            <input type="button" class="btn btn-primary" value="+" onClick="addRow('dataTable')">
                        </td>
                    </tr>
                    <tr>
                        <th width="6%" class="pd0">Chk</th>
                        <th width="21%" class="pd0">Stone</th>
                        <th width="12%" class="pd0">Size</th>
                        <th width="12%" class="pd0">Shape</th>
                        <th width="12%" class="pd0">Color</th>
                        <th width="13%" class="pd0">Qty/Pc.</th>
                        <th width="12%" class="pd0">Rate</th>
                        <th width="12%" class="pd0">Total</th>
                    </tr>
                </table>

<table id="dataTable" width="100%" border="0">
                    <?php 
                    $i = 1;
                    if($num_stones > 0) {
                        // --- LOOP THROUGH EXISTING STONES ---
                        while($st = mysqli_fetch_array($res_stones)) { 
                    ?>
                        <tr>
                            <td width="6%" class="pd0"><input type="checkbox" name="chk<?php echo $i; ?>"></td>
                            <td width="21%" class="pd0">
                                <input type="text" name="proref<?php echo $i; ?>" id="proref<?php echo $i; ?>" class="form-control" style="width: 200px;" value="<?php echo $st['pro_code']; ?>" onKeyUp="fetchproductad(this.name);">
                            </td>
                            <td width="12%" class="pd0">
                                <input type="text" name="size<?php echo $i; ?>" id="size<?php echo $i; ?>" class="form-control" style="width: 50px;" value="<?php echo $st['pro_size']; ?>">
                            </td>
                            <td width="12%" class="pd0">
                                <input type="text" name="shape<?php echo $i; ?>" id="shape<?php echo $i; ?>" class="form-control" style="width: 50px;" value="<?php echo $st['pro_shape']; ?>">
                            </td> 
                            <td width="12%" class="pd0">
                                <input type="text" name="color<?php echo $i; ?>" id="color<?php echo $i; ?>" class="form-control" style="width: 50px;" value="<?php echo $st['pro_color']; ?>">
                            </td> 
                            <td width="13%" class="pd0">
                                <input type="text" name="bqty<?php echo $i; ?>" id="bqty<?php echo $i; ?>" class="form-control" style="width: 50px;" value="<?php echo $st['pro_qty']; ?>" onKeyUp="totamountsp(this.name,4);calculateprotot();">
                            </td>
                            <td width="12%" class="pd0">
                                <input type="text" name="rate<?php echo $i; ?>" id="rate<?php echo $i; ?>" class="form-control" style="width: 50px;" value="<?php echo $st['pro_rate']; ?>" onKeyUp="totamountsp(this.name,4);calculateprotot();">
                            </td>
                            <td width="12%" class="pd0">
                                <input type="text" name="stotal<?php echo $i; ?>" id="stotal<?php echo $i; ?>" class="form-control" style="width: 50px;" value="<?php echo $st['pro_stotal']; ?>">
                            </td>
                        </tr>
                    <?php 
                            $i++; 
                        } 
                    } else { 
                        // --- SHOW 1 BLANK ROW IF NO STONES EXIST ---
                    ?>
                        <tr>
                            <td width="6%" class="pd0"><input type="checkbox" name="chk1"></td>
                            <td width="21%" class="pd0"><input type="text" name="proref1" id="proref1" class="form-control" style="width: 200px;" onKeyUp="fetchproductad(this.name);"></td>
                            <td width="12%" class="pd0"><input type="text" name="size1" id="size1" class="form-control" style="width: 50px;"></td>
                            <td width="12%" class="pd0"><input type="text" name="shape1" id="shape1" class="form-control" style="width: 50px;"></td> 
                            <td width="12%" class="pd0"><input type="text" name="color1" id="color1" class="form-control" style="width: 50px;"></td> 
                            <td width="13%" class="pd0"><input type="text" name="bqty1" id="bqty1" class="form-control" style="width: 50px;" onKeyUp="totamountsp(this.name,4);calculateprotot();"></td>
                            <td width="12%" class="pd0"><input type="text" name="rate1" id="rate1" class="form-control" style="width: 50px;" onKeyUp="totamountsp(this.name,4);calculateprotot();"></td>
                            <td width="12%" class="pd0"><input type="text" name="stotal1" id="stotal1" class="form-control" style="width: 50px;"></td>
                        </tr>
                    <?php } ?>
                </table>

<?php 
                // Array to loop through all labor fields for scannability
                $labor_fields = [
                    ['label' => 'Chain', 'pre' => 'pro_s'], 
                    ['label' => 'Hook', 'pre' => 'pro_h'], 
                    ['label' => 'Kacha', 'pre' => 'pro_s2'], 
                    ['label' => 'Weight', 'pre' => 'pro_w'], 
                    ['label' => 'Pollish', 'pre' => 'pro_p'], 
                    ['label' => 'Rodium', 'pre' => 'pro_r']
                ];
                ?>

<div class="form-group col-md-4 floatleft">
                    <label>Chain</label>
                    <input class="form-control" type="text" name="pro_setting" id="pro_setting" value="<?php print $rowm['pro_setting']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Rate</label>
                    <input class="form-control" type="text" name="pro_srate" id="pro_srate" value="<?php print $rowm['pro_srate']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Total</label>
                    <input class="form-control" type="text" name="pro_stot" id="pro_stot" readonly value="<?php print $rowm['pro_setting']*$rowm['pro_srate']; ?>">
                </div>
                <div class="cleaner"></div>

<div class="form-group col-md-4 floatleft">
                    <label>Hook</label>
                    <input class="form-control" type="text" name="pro_hook" id="pro_hook" value="<?php print $rowm['pro_hook']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Rate</label>
                    <input class="form-control" type="text" name="pro_hrate" id="pro_hrate" value="<?php print $rowm['pro_hrate']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Total</label>
                    <input class="form-control" type="text" name="pro_htot" id="pro_htot" readonly value="<?php print $rowm['pro_hook']*$rowm['pro_hrate']; ?>">
                </div>
                <div class="cleaner"></div>
                <div class="form-group col-md-4 floatleft">
					<label for="example-text-input" class="col-form-label">Kacha</label>
					<input class="form-control" type="text" name="pro_setting2" id="pro_setting2" value="<?php print $rowm['pro_setting2']; ?>" onKeyUp="calculateprotot();" onKeyDown="calculateprotot();" onBlur="calculateprotot();">
				</div>
				<div class="form-group col-md-4 floatleft">
					<label for="example-text-input" class="col-form-label">Rate</label>
					<input class="form-control" type="text" name="pro_srate2" id="pro_srate2" value="<?php print $rowm['pro_srate2']; ?>" onKeyUp="calculateprotot();" onKeyDown="calculateprotot();" onBlur="calculateprotot();">
				</div>
				<div class="form-group col-md-4 floatleft">
					<label for="example-text-input" class="col-form-label">Total</label>
					<input class="form-control" type="text" name="pro_s2tot" id="pro_s2tot" value="<?php print $rowm['pro_setting2']*$rowm['pro_srate2']; ?>">
				</div>
				<div class="cleaner"></div>
				<div class="form-group col-md-4 floatleft">
					<label for="example-text-input" class="col-form-label">Weight</label>
					<input class="form-control" type="text" name="pro_wtw" id="pro_wtw" value="<?php print $rowm['pro_wtw']; ?>" onKeyUp="calculateprotot();" onKeyDown="calculateprotot();" onBlur="calculateprotot();">
				</div>
				<div class="form-group col-md-4 floatleft">
					<label for="example-text-input" class="col-form-label">Rate</label>
					<input class="form-control" type="text" name="pro_wrate" id="pro_wrate" value="<?php print $rowm['pro_wrate']; ?>" onKeyUp="calculateprotot();" onKeyDown="calculateprotot();" onBlur="calculateprotot();">
				</div>
				<div class="form-group col-md-4 floatleft">
					<label for="example-text-input" class="col-form-label">Total</label>
					<input class="form-control" type="text" name="pro_wtot" id="pro_wtot" value="<?php print $rowm['pro_wtw']*$rowm['pro_wrate']; ?>">
				</div>
				<div class="cleaner"></div>
                <div class="form-group col-md-4 floatleft">
                    <label>Pollish (Weight)</label>
                    <input class="form-control" type="text" name="pro_plsh" id="pro_plsh" value="<?php print $rowm['pro_plsh']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Rate</label>
                    <input class="form-control" type="text" name="pro_prate" id="pro_prate" value="<?php print $rowm['pro_prate']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Total</label>
                    <input class="form-control" type="text" name="pro_ptot" id="pro_ptot" readonly value="<?php print $rowm['pro_plsh']*$rowm['pro_prate']; ?>">
                </div>
                <div class="cleaner"></div>

<div class="form-group col-md-4 floatleft">
                    <label>Rodium (Weight)</label>
                    <input class="form-control" type="text" name="pro_rodi" id="pro_rodi" value="<?php print $rowm['pro_rodi']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Rate</label>
                    <input class="form-control" type="text" name="pro_rrate" id="pro_rrate" value="<?php print $rowm['pro_rrate']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>Total</label>
                    <input class="form-control" type="text" name="pro_rtot" id="pro_rtot" readonly value="<?php print $rowm['pro_rodi']*$rowm['pro_rrate']; ?>">
                </div>
                <div class="cleaner"></div>

<div class="form-group col-md-4 floatleft">
                    <label>Chelai</label>
                    <input class="form-control" type="text" name="pro_chelai" id="pro_chelai" value="<?php print $rowm['pro_chelai']; ?>" onKeyUp="calculateprotot();">
                </div>
                <div class="form-group col-md-4 floatleft">
                    <label>*Total</label>
                    <input class="form-control" type="text" name="pro_total" id="pro_total" value="<?php print $rowm['pro_total']; ?>">
                </div>

<div class="form-group col-md-12 floatleft">
                    <label>Image</label>
                    <input class="form-control" type="file" name="pro_image" id="pro_image">
                    <?php if($rowm['pro_image']) { ?>
                        <a href="uimages/<?php print $rowm['pro_image']; ?>" target="_new">View Existing Image</a>
                    <?php } ?>
                </div>

<div class="form-group col-md-12 floatleft">
                    <button type="submit" class="btn btn-primary mt-2">Update Product</button>
                </div>
            </form>	
        </div>
    </div>
</div>
</div>

<?php include("includes/footer.php"); ?>
</div>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: editproductsp.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation