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:

u506365997

Directory:

/home/u506365997/domains/creativeink.in/public_html/creativeinkadmin

Free Space:

3.15 TB

🔧 Quick Actions

✏️ Editing: viewinvouce.php

<?php
session_start();
include 'sql/config.php';
	if(empty($_SESSION['username'])){

echo "<script>
            window.location = 'login.php';
          </script>";
    exit();
}
?>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<?php
	include 'include/header.php';
	include 'include/sidebar.php';
	include 'include/top_header.php';
?>

<style>
    table thead tr th{
        padding:8px 15px;
        font-size:13px!important;
    }
	table tbody tr td{
		text-align: left!important;
	}
	.change-status{
        margin-left: -50px;
		height: auto;
		padding-bottom: 15px;
		background-color: #fff;
		box-shadow: 0 1px 3px rgba(0, 0, 0, 0.12), 0 1px 2px rgba(0, 0, 0, 0.24); /* Optional: subtle shadow */
		position: relative; /* Ensures ::before and ::after pseudo-elements work correctly */
	}
	.change-status::before
        {
            content: "";
            position: absolute;
            left: 0;
            right: 0;
            height: 8px; /* Adjust height as needed */
            background: linear-gradient(to right, #4CAF50, #8BC34A); /* Green gradient */
            top: -10px; /* Positioning for the top border */
            z-index: -1;
            border-radius: 5px 5px 0px 0px;
        }
		.change-status select {
			height: 45px;
		}
		.change-status input[type="date"], input[type="text"]{
			height: 45px;
		}
		button{
			border: none;
			background-color: #e60965;
			color: #fff;
			padding: 6px 25px;
			border-radius: 5px;
            margin-top: 15px;
		}
        #bank, #upi, #payby{
            display: none;
            animation: fadeInUp 0.6s ease-in-out both;
        }
        @keyframes fadeInUp {
            0% {
                opacity: 0;
                transform: translateY(-50px);
            }
            100% {
                opacity: 1;
                transform: translateY(0);
            }
        }
        @media(max-width:600px){
            .change-status{
                margin-left: 0px;
            }
        }
</style>

<div class="container-fluid mt-5">
<form action="sql/genbill.php" method="POST">
<?php
    if(isset($_GET['id'])){
        $pid = $_GET['id'];
        $bill = mysqli_query($conn, "SELECT * FROM `bill` WHERE `p_id` = '$pid'") or mysqli_error($conn);
        if(mysqli_num_rows($bill) > 0){
            $rowbill = mysqli_fetch_array($bill);
            if($rowbill['status'] == 1){
    ?>
             <div class="row">
		        <div class="col-12">
				<?php
					include 'sql/config.php';
					$id = $_GET['id'];
					$sql = mysqli_query($conn, "SELECT * FROM product_order WHERE id = '$id'") or mysqli_error($conn);
					if(mysqli_num_rows($sql) > 0){
						$row = mysqli_fetch_array($sql);
					}
				?>
                <input type="hidden" name="pid" value="<?php echo $row['id']; ?>">
                <input type="hidden" name="c_id" value="<?php echo $row['c_id']; ?>">
                <input type="hidden" name="total" value="<?php echo $row['total']; ?>">
				<div class="change-status p-2">
					<h5>Generate Computerised Bill</h5>
					<div class="row">
                        <div class="col-12">
                            <table class="table table-bordered w-100">
                                <tbody>
                                    <tr>
                                        <td><b>Order Id</b> : <span class="ml-2"><?php echo $row['order_id']; ?></span></td>
                                        <td><b>Item</b> : <span class="ml-2"><?php echo $row['p_name']; ?></span></td>
                                        <td><b>Rate</b> : <span class="ml-2"><?php echo $row['price']; ?></span></td>
                                    </tr>
                                    <tr>
                                        <td><b>Quantity</b> : <span class="ml-2"><?php echo $row['quantity']; ?></span></td>
                                        <td colspan="2"><b>Total</b> : <span class="ml-2"><?php echo $row['total']; ?></span></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div><hr>
                    <div class="row">
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Shiping Charge</label>
                                <input type="text" name="shipingcharge" class="form-control" value="<?php echo $rowbill['shiping'];?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                            </div>
                        </div>
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Tax / Others</label>
                                <input type="text" name="tax" class="form-control" id="exampleInputEmail1" value="<?php echo $rowbill['tax'] ?>" aria-describedby="emailHelp" readonly>
                            </div>
                        </div>
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Paid By</label>
                                <?php
                                    if($rowbill['paidby'] == 'cash'){
                                ?>
                                    <select name="paidby" class="form-control" readonly>
                                        <option disabled selected value="">--Select One--</option>
                                        <option value="cash" selected>Cash</option>
                                    </select>
                                <?php
                                    }else if($rowbill['paidby'] == 'bank'){
                                ?>
                                    <select name="paidby" class="form-control" readonly>
                                        <option disabled selected value="">--Select One--</option>
                                        <option value="bank" selected>Bank</option>
                                    </select>
                                <?php
                                    }else if($rowbill['paidby'] == 'upi'){
                                ?>
                                    <select name="paidby" class="form-control" readonly>
                                        <option disabled selected value="">--Select One--</option>
                                        <option value="upi" selected>UPI</option>
                                    </select> 
                                <?php
                                    }else if($rowbill['paidby'] == 'other'){
                                ?>
                                    <select name="paidby" class="form-control" readonly>
                                        <option disabled selected value="">--Select One--</option>
                                        <option value="other" selected>Other</option>
                                    </select>
                                <?php
                                    }
                                ?>
                            </div>
                        </div>
                    </div>
                    <?php
                        if($rowbill['paidby'] == 'bank'){
                    ?>
                        <div>
                        <div class="row">
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Bank Name</label>
                                    <input type="text" name="bank" class="form-control" id="exampleInputEmail1" value="<?php echo $rowbill['bank'] ?>" aria-describedby="emailHelp" readonly>
                                </div>
                            </div>
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Branch</label>
                                    <input type="text" name="branch" class="form-control" value="<?php echo $rowbill['branch']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                </div>
                            </div>
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Account No.</label>
                                    <input type="text" name="account" class="form-control" value="<?php echo $rowbill['account']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                </div>
                            </div>
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">IFSC Code</label>
                                    <input type="text" name="ifsc" style="text-transform: uppercase;" value="<?php echo $rowbill['ifsc'] ?>" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                </div>
                            </div>
                        </div>
                        </div>
                    <?php
                        }else if($rowbill['paidby'] == 'upi'){
                    ?>
                        <div>
                            <div class="row">
                                <div class="col-12">
                                    <div class="form-group">
                                        <label for="exampleInputEmail1">UPI Number</label>
                                        <input type="text" name="upi" class="form-control" value="<?php echo $rowbill['upi']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php
                        }else if($rowbill['paidby'] == 'other'){
                    ?>
                        <div>
                            <div class="row">
                                <div class="col-12">
                                    <div class="form-group">
                                        <label for="exampleInputEmail1">Paid By</label>
                                        <input type="text" name="paidvia" class="form-control" value="<?php echo $rowbill['other']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php
                        }
                    ?>
                    <div class="row">
                        <div class="col-12">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Status</label>
                                <?php
                                    if($rowbill['status'] == 1){
                                ?>
                                    <select name="status" class="form-control" id="exampleFormControlSelect1" readonly>
                                        <option disabled selected value="">--Select One--</option>
                                        <option value="1" selected>Paid</option>
                                    </select>
                                <?php
                                    }
                                ?>
                            </div>
                        </div>
                    </div>
					
				</div>
		</div>
	</div>
    <?php
            }else if($rowbill['status'] == 0){
    ?>
         <div class="row">
		<div class="col-12">
				<?php
					include 'sql/config.php';
					$id = $_GET['id'];
					$sql = mysqli_query($conn, "SELECT * FROM product_order WHERE id = '$id'") or mysqli_error($conn);
					if(mysqli_num_rows($sql) > 0){
						$row = mysqli_fetch_array($sql);
					}
				?>
                <input type="hidden" name="pid" value="<?php echo $row['id']; ?>">
                <input type="hidden" name="c_id" value="<?php echo $row['c_id']; ?>">
                <input type="hidden" name="total" value="<?php echo $row['total']; ?>">
				<div class="change-status p-2">
					<h5>Generate Computerised Bill</h5>
					<div class="row">
                        <div class="col-12">
                            <table class="table table-bordered w-100">
                                <tbody>
                                    <tr>
                                        <td><b>Order Id</b> : <span class="ml-2"><?php echo $row['order_id']; ?></span></td>
                                        <td><b>Item</b> : <span class="ml-2"><?php echo $row['p_name']; ?></span></td>
                                        <td><b>Rate</b> : <span class="ml-2"><?php echo $row['price']; ?></span></td>
                                    </tr>
                                    <tr>
                                        <td><b>Quantity</b> : <span class="ml-2"><?php echo $row['quantity']; ?></span></td>
                                        <td colspan="2"><b>Total</b> : <span class="ml-2"><?php echo $row['total']; ?></span></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div><hr>
                    <div class="row">
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Shiping Charge</label>
                                <input type="text" name="shipingcharge" class="form-control" value="<?php echo $rowbill['shiping'];?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                            </div>
                        </div>
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Tax / Others</label>
                                <input type="text" name="tax" class="form-control" id="exampleInputEmail1" value="<?php echo $rowbill['tax'] ?>" aria-describedby="emailHelp" readonly>
                            </div>
                        </div>
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Paid By</label>
                                <select name="paidby" class="form-control" readonly>
                                    <option disabled selected value="">--Select One--</option>
                                    <option value="<?php echo $rowbill['paidby']; ?>" style="text-transform: uppercase;" selected><?php echo $rowbill['paidby']; ?></option>
                                </select>
                            </div>
                        </div>
                    </div>
                    <?php
                        if($rowbill['paidby'] == 'bank'){
                            $selectedBank = $rowbill['bank'] ? $rowbill['bank'] : '';
                    ?>
                        <div>
                        <div class="row">
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Bank Name</label>
                                    <select name="bank" class="form-control" id="exampleFormControlSelect1" readonly>
                                        <option value="<?php echo $rowbill['bank']; ?>" style="text-transform: uppercase;" selected><?php echo $rowbill['bank']; ?></option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Branch</label>
                                    <input type="text" name="branch" class="form-control" value="<?php echo $rowbill['branch']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                </div>
                            </div>
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Account No.</label>
                                    <input type="text" name="account" class="form-control" value="<?php echo $rowbill['account']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                </div>
                            </div>
                            <div class="col-12 col-md-3">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">IFSC Code</label>
                                    <input type="text" name="ifsc" style="text-transform: uppercase;" value="<?php echo $rowbill['ifsc'] ?>" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                </div>
                            </div>
                        </div>
                        </div>
                    <?php
                        }else if($rowbill['paidby'] == 'upi'){
                    ?>
                        <div>
                            <div class="row">
                                <div class="col-12">
                                    <div class="form-group">
                                        <label for="exampleInputEmail1">UPI Number</label>
                                        <input type="text" name="upi" class="form-control" value="<?php echo $rowbill['upi']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php
                        }else if($rowbill['paidby'] == 'other'){
                    ?>
                        <div>
                            <div class="row">
                                <div class="col-12">
                                    <div class="form-group">
                                        <label for="exampleInputEmail1">Paid By</label>
                                        <input type="text" name="paidvia" class="form-control" value="<?php echo $rowbill['other']; ?>" id="exampleInputEmail1" aria-describedby="emailHelp" readonly>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php
                        }
                    ?>
                    <div class="row">
                        <div class="col-12">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Status</label>
                                <?php
                                    if($rowbill['status'] == 0){
                                ?>
                                    <select name="status" class="form-control" id="exampleFormControlSelect1">
                                        <option disabled selected value="">--Select One--</option>
                                        <option value="1">Paid</option>
                                        <option value="0" selected>Dues</option>
                                    </select>
                                <?php
                                    }
                                ?>
                            </div>
                        </div>
                    </div>
					
				</div>
		</div>
	</div>
    <?php
            }
        }else{
    ?>
        <div class="row">
		<div class="col-12">
				<?php
					include 'sql/config.php';
					$id = $_GET['id'];
					$sql = mysqli_query($conn, "SELECT * FROM product_order WHERE id = '$id'") or mysqli_error($conn);
					if(mysqli_num_rows($sql) > 0){
						$row = mysqli_fetch_array($sql);
					}
				?>
                <input type="hidden" name="pid" value="<?php echo $row['id']; ?>">
                <input type="hidden" name="c_id" value="<?php echo $row['c_id']; ?>">
                <input type="hidden" name="total" value="<?php echo $row['total']; ?>">
				<div class="change-status p-2">
					<h5>Generate Computerised Bill</h5>
					<div class="row">
                        <div class="col-12">
                            <table class="table table-bordered w-100">
                                <tbody>
                                    <tr>
                                        <td><b>Order Id</b> : <span class="ml-2"><?php echo $row['order_id']; ?></span></td>
                                        <td><b>Item</b> : <span class="ml-2"><?php echo $row['p_name']; ?></span></td>
                                        <td><b>Rate</b> : <span class="ml-2"><?php echo $row['price']; ?></span></td>
                                    </tr>
                                    <tr>
                                        <td><b>Quantity</b> : <span class="ml-2"><?php echo $row['quantity']; ?></span></td>
                                        <td colspan="2"><b>Total</b> : <span class="ml-2"><?php echo $row['total']; ?></span></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div><hr>
                    <div class="row">
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Shiping Charge</label>
                                <input type="text" name="shipingcharge" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="Enter Shipping Charge">
                            </div>
                        </div>
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Tax / Others</label>
                                <input type="text" name="tax" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="Tax / Others">
                            </div>
                        </div>
                        <div class="col-12 col-md-4">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Paid By</label>
                                <select name="paidby" class="form-control" onchange="ShowPaid()" id="pay">
                                    <option disabled selected value="">--Select One--</option>
                                    <option value="cash">Cash</option>
                                    <option value="bank">Bank</option>
                                    <option value="upi">UPI</option>
                                    <option value="other">Other</option>
                                </select>
                            </div>
                        </div>
                    </div>
                    <div id="bank">
                    <div class="row">
                        <div class="col-12 col-md-3">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Bank Name</label>
                                <select name="bank" class="form-control" id="exampleFormControlSelect1">
                                    <option disabled selected value="">--Select Bank--</option>
                                    <option value="State Bank of India (SBI)">State Bank of India (SBI)</option>
                                    <option value="HDFC Bank">HDFC Bank</option>
                                    <option value="ICICI Bank">ICICI Bank</option>
                                    <option value="Punjab National Bank (PNB)">Punjab National Bank (PNB)</option>
                                    <option value="Bank of Baroda (BOB)">Bank of Baroda (BOB)</option>
                                    <option value="Canara Bank">Canara Bank</option>
                                    <option value="Axis Bank">Axis Bank</option>
                                    <option value="Kotak Mahindra Bank">Kotak Mahindra Bank</option>
                                    <option value="IDBI Bank">IDBI Bank</option>
                                    <option value="Union Bank of India">Union Bank of India</option>
                                    <option value="IndusInd Bank">IndusInd Bank</option>
                                    <option value="Yes Bank">Yes Bank</option>
                                    <option value="Central Bank of India">Central Bank of India</option>
                                    <option value="Indian Bank">Indian Bank</option>
                                    <option value="Bank of India">Bank of India</option>
                                    <option value="UCO Bank">UCO Bank</option>
                                    <option value="Indian Overseas Bank">Indian Overseas Bank</option>
                                    <option value="Federal Bank">Federal Bank</option>
                                    <option value="South Indian Bank">South Indian Bank</option>
                                    <option value="Bandhan Bank">Bandhan Bank</option>
                                    <option value="Dhanlaxmi Bank">Dhanlaxmi Bank</option>
                                    <option value="RBL Bank">RBL Bank</option>
                                    <option value="Karnataka Bank">Karnataka Bank</option>
                                    <option value="Syndicate Bank">Syndicate Bank</option>
                                    <option value="Corporation Bank">Corporation Bank</option>
                                    <option value="Andhra Bank">Andhra Bank</option>
                                </select>
                            </div>
                        </div>
                        <div class="col-12 col-md-3">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Branch</label>
                                <input type="text" name="branch" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="Branch...">
                            </div>
                        </div>
                        <div class="col-12 col-md-3">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Account No.</label>
                                <input type="text" name="account" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="A/c...">
                            </div>
                        </div>
                        <div class="col-12 col-md-3">
                            <div class="form-group">
                                <label for="exampleInputEmail1">IFSC Code</label>
                                <input type="text" name="ifsc" style="text-transform: uppercase;" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="IFSC...">
                            </div>
                        </div>
                    </div>
                    </div>
                    <div id="upi">
                        <div class="row">
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">UPI Number</label>
                                    <input type="text" name="upi" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="UPI Number...">
                                </div>
                            </div>
                        </div>
                    </div>
                    <div id="payby">
                        <div class="row">
                            <div class="col-12">
                                <div class="form-group">
                                    <label for="exampleInputEmail1">Paid By</label>
                                    <input type="text" name="paidvia" class="form-control" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="Write Payment Method...">
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="row">
                        <div class="col-12">
                            <div class="form-group">
                                <label for="exampleInputEmail1">Status</label>
                                <select name="status" class="form-control" id="exampleFormControlSelect1">
                                    <option disabled selected value="">--Select One--</option>
                                    <option value="0">Dues</option>
                                    <option value="1">Paid</option>
                                </select>
                            </div>
                        </div>
                    </div>
            </div>
        </div>
        </div>
    <?php
        }
    }
?>
    <div class="row">
		<div class="col-12">
			<div class="d-block float-right">
				<button type="submit" name="genbill">Generate Bill</button>
			</div>
		</div>
	</div>
</form>
</div>

<?php
	include 'include/footer.php';
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewinvouce.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation