Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/crm/backup

Free Space:

9.3 TB

🔧 Quick Actions

✏️ Editing: expense-entry.php

<?php  include "header.php";

$action=$_REQUEST['action'];
if($action=='save'){
$e_hid=$_POST['e_hid'];
$e_date=$_POST['e_date'];
$e_empid=$_POST['e_empid'];
$e_amt=$_POST['e_amt'];
$e_mode=$_POST['e_mode'];
$e_desc=$_POST['e_desc'];

$res=mysqli_query($con,"INSERT INTO `tbl_expense` SET `e_hid`='$e_hid',`e_date`='$e_date',`e_empid`='$e_empid',`e_amt`='$e_amt',`e_mode`='$e_mode',`e_desc`='$e_desc'");

}elseif($action=='update'){
    $insid=$_REQUEST['id'];
    $e_hid=$_POST['e_hid'];
$e_date=$_POST['e_date'];
$e_empid=$_POST['e_empid'];
$e_amt=$_POST['e_amt'];
$e_mode=$_POST['e_mode'];
$e_desc=$_POST['e_desc'];

$res=mysqli_query($con,"UPDATE `tbl_expense` SET `e_hid`='$e_hid',`e_date`='$e_date',`e_empid`='$e_empid',`e_amt`='$e_amt',`e_mode`='$e_mode',`e_desc`='$e_desc' WHERE e_id='$insid'");

}elseif($action=='edit'){
    $insid=$_REQUEST['id'];
    $edit=f(q("SELECT * FROM tbl_expense WHERE e_id='$insid'"));

}elseif($action=='delete'){
    $insid=$_REQUEST['id'];

$res=mysqli_query($con,"DELETE FROM tbl_expense WHERE e_id='$insid'");
}

?>
<style>
input[type=text] {
    font-size:20px;
}
td{
    font-size:18px;
}
</style>

<div class="page-wrapper">
            
            
            
            <div class="page-breadcrumb">
                <div class="row">
                    <div class="col-12 d-flex no-block align-items-center">
                        <h4 class="page-title">Add Head Details</h4>
                        <div class="ml-auto text-right">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><a href="#">Home</a></li>
                                    <li class="breadcrumb-item active" aria-current="page">Unit</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
            
            
            
            
            
            
            <div class="container-fluid">
                
                
                
                <div class="row">
                    <div class="col-md-6">
                        <div class="card">
<form class="form-horizontal" action="expense-entry.php?<?php if($action=='edit'){?>action=update&id=<?php echo $insid?><?}else{ ?>action=save<?php } ?>" method="POST">
                                <div class="card-body">
                                    <h4 class="card-title">Expense Entry</h4>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-right control-label col-form-label">Expense Head</label>
                                        <div class="col-sm-9">
                                            <select name="e_hid" class="select2 form-control">
                                                <?php
                                                    $q=mysqli_query($con,"SELECT * FROM tbl_expensehead ORDER BY h_name ASC");
                                                    while($arrq=mysqli_fetch_array($q)){
                                                ?>
                                                    <option value="<?php echo $arrq['h_id']?>" <?php if($edit['e_hid']==$arrq['h_id']){?> selected <?php }?> ><?php echo $arrq['h_name']?></option>
                                                 <?php } ?>

</select>
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-right control-label col-form-label">If Salary Select Employee</label>
                                        <div class="col-sm-9">
                                            <select name="e_empid" class="select2 form-control">
                                                <option value="0" <?php if($edit['e_empid']=='0'){?> selected <?php }?>>Not Salary</option>
                                                <?php
                                                    $q=mysqli_query($con,"SELECT * FROM tbl_agents ORDER BY ag_name ASC");
                                                    while($arrq=mysqli_fetch_array($q)){
                                                ?>
                                                    <option value="<?php echo $arrq['ag_id']?>" <?php if($edit['e_empid']==$arrq['ag_id']){?> selected <?php }?>><?php echo $arrq['ag_name']?></option>
                                                 <?php } ?>

</select>
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-right control-label col-form-label">Date</label>
                                        <div class="col-sm-9">
                                            <input type="date" class="form-control" name="e_date" value="<?php if($action!='edit'){ echo date("Y-m-d"); }else{ echo $edit['e_date']; ?><? }?>">
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-right control-label col-form-label">Amount</label>
                                        <div class="col-sm-9">
                                            <input type="text" class="form-control" name="e_amt" value="<?php echo $edit['e_amt']?>">
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-right control-label col-form-label">Payment Mode</label>
                                        <div class="col-sm-9">
                                            <select name="e_mode" class="select2 form-control">
                                                <option value="cash" <?php if($edit['e_empid']=='cash'){?> selected <?php }?>>Cash</option>
                                                 <option value="Cheque" <?php if($edit['e_empid']=='Cheque'){?> selected <?php }?>>Cheque</option>
                                                  <option value="Bank Transfer" <?php if($edit['e_empid']=='Bank Transfer'){?> selected <?php }?>>Bank Transfer</option>
                                                   <option value="Paytm" <?php if($edit['e_empid']=='Paytm'){?> selected <?php }?>>Paytm</option>

</select>
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-right control-label col-form-label">Payment Note</label>
                                        <div class="col-sm-9">
                                             <input type="text" class="form-control" name="e_desc" value="<?php echo $edit['e_desc']?>">
                                        </div>
                                    </div>
                                    
                                </div>
                                <div class="border-top">
                                    <div class="card-body">
                                        <button type="submit" class="btn btn-primary">Submit</button>
                                    </div>
                                </div>
                            </form>
                        </div>

</div>
                    
                    <div class="col-md-6">
                        <div class="card">
                            <div class="card-body" style="max-height:610px;min-height:610px;overflow:scroll;">
                                <h5 class="card-title m-b-0">Expense List</h5>
                                <table id="zero_config" class="table table-striped table-bordered" style="width:100%">
        <thead>
            <tr>
                <th style="color:#fff">Date</th>
                <th style="color:#fff">Head</th>
                <th style="color:#fff">Amount</th>
                
                <th style="color:#fff">Action</th>
                
            </tr>
        </thead>
        <tbody>
            <?php
                    $cq=mysqli_query($con,"SELECT * FROM tbl_expense ORDER BY e_id DESC");
                    while($arrc=mysqli_fetch_array($cq)){

$gethead=f(q("SELECT * FROM tbl_expensehead WHERE h_id='$arrc[e_hid]'"));
            
            ?>
            <tr>
                <td style="color:#fff"><?php echo $arrc['e_date']?></td>
                <td style="color:#fff"><?php echo $gethead['h_name']?></td>
                <td style="color:#fff"><?php echo $arrc['e_amt']?></td>
               
                <td><a  class="lhp" href="expense-entry.php?action=edit&id=<?php echo $arrc['e_id']?>"><i class="fa fa-edit"></i></a><br><a  class="lhp"  onclick="return confirm('Are you sure?')" href="expense-entry.php?action=delete&id=<?php echo $arrc['e_id']?>"><i class="fa fa-trash"></i></a></td>
              
            </tr>

<?php } ?>
            
        </tbody>
        <tfoot>
            <tr>
            <th style="color:#fff">Date</th>
                <th style="color:#fff">Head</th>
                <th style="color:#fff">Amount</th>
                
                <th style="color:#fff">Action</th>
               
            </tr>
        </tfoot>
    </table>
                            </div>
                        </div>
                        
                    </div>
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>

<?php  include "footer.php"; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: expense-entry.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation