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: vendor-purchase.php

<?php  include "header.php"; 
    if($compid==''){

header("Location:company.php");
    
    }

$action=$_REQUEST['action'];
if($action=='search'){

$emp=$_POST['empname'];
    $getsales=f(q("SELECT * FROM tbl_vendor WHERE v_id='$emp'"));
    $startdate=$_POST['startdate'];
    $enddate=$_POST['enddate'];

$sql="SELECT * FROM tbl_purchase WHERE p_prov_id='$emp' AND p_bdate BETWEEN '$startdate' AND '$enddate'";

}

?>

        
        
        <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">Sales User Report</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">Sales User Report</li>
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
            
            
            
            
            
            
            <div class="container-fluid">
                
                
                
                <div class="row">
                    
                    <div class="col-md-12">
                    <div class="card">
                            <div class="card-body">
                                <form action="vendor-purchase.php?action=search" method="POST">
                                    <h4 class="card-title">Vendor Info</h4>
                                    <div class="form-group row">
                                        <label for="fname" class="col-sm-3 text-right control-label col-form-label">Vendor Name</label>
                                        <div class="col-sm-9">
                                        <select class="form-control" name="empname">
                                            <optgroup label="Select Employee">
                                            <?php
                                                $emps=mysqli_query($con,"SELECT * FROM tbl_vendor");
                                                while($arrc=mysqli_fetch_array($emps)){
                                            
                                            
                                            ?>    
                                                <option value="<?php echo $arrc['v_id']?>"><?php echo $arrc['v_name']?></option>

<?php } ?>
                                            </optgroup>           
                                         </select>               
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <label for="email1" class="col-sm-3 text-right control-label col-form-label">Start Date</label>
                                        <div class="col-sm-9">
                                            <input type="date" class="form-control" name="startdate" id="email1" placeholder="join Date" value="">
                                        </div>
                                    </div>
                                    <div class="form-group row">
                                        <label for="email1" class="col-sm-3 text-right control-label col-form-label">End Date</label>
                                        <div class="col-sm-9">
                                            <input type="date" class="form-control" name="enddate" id="email1" placeholder="join Date" value="">
                                        </div>
                                    </div>
                                    <div class="border-top">
                                    <div class="card-body">
                                        <button type="submit" class="btn btn-primary">Search</button>
                                    </div>
                                </div>
                                 </form>    
                            </div>
                    </div>

</div>
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title m-b-0">Vendor Wise Report <?php if($getsales['ag_name']!=''){ echo "for ".$getsales['ag_name']; } ?> from <?php echo $startdate?> to <?php echo $enddate?></h5>
                                <table id="example" class="table table-striped table-bordered" style="width:100%">
        <thead>
            <tr>
            <th>Bill No</th>
                <th>Date</th>
                <th>Details</th>
                <th>Total Amount</th>
                <th>Paid</th>
                
                
                
                
            </tr>
        </thead>
        <tbody>
            <?php
                    $cq=mysqli_query($con,$sql);
                    $totpaid=0;
                    while($arrc=mysqli_fetch_array($cq)){
                       $str="";
                       
            
            ?>
            <tr>
                <td><?php echo $arrc['p_bill']?></td>
                    <td><?php echo $arrc['p_bdate']?></td>
                <td><? $prded=mysqli_query($con,"SELECT * FROM tbl_p_details WHERE pd_p_id='$arrc[p_id]'");
                            while($arrdet=mysqli_fetch_array($prded)){ 
                                $getprod=f(q("SELECT * FROM tbl_products WHERE prod_id='$arrdet[pd_prodid]'"));
                                $getunit=f(q("SELECT * FROM tbl_unit WHERE u_id='$arrdet[pd_unit]'"));
                                $unitid=$getunit['u_name'];
                                $str=$str." ".$getprod['prod_name']."(".$arrdet['pd_quan']." ".$unitid." )"."<br>" ;
                        
                        
                        
                        } echo $str;?></td>
                
               <td>&#8377; <?php echo $arrc['p_netamt']?></td>
               <td>

<?php      $totpay=f(q("SELECT SUM(sp_amt) as tots FROM tbl_purchasepay WHERE sp_sid='$arrc[p_id]'"));  ?>

&#8377; <?php echo $totpay['tots']?></td>
                
              
            </tr>

<?php $totamt=floatval($totamt)+floatval($arrc['p_netamt']); 
               $totpaid=floatval($totpaid) + floatval($totpay['tots']); 
             } ?>
            
        </tbody>
        <tfoot>
            <tr>
            <th></th>
                <th></th>
                <th></th>
                
                <th>Total Amount : &#8377;<?php echo $totamt?></th>
                <th>Total Paid : &#8377;<?php echo $totpaid?></th>
            </tr>
        </tfoot>
    </table>
                            </div>
                        </div>
                        
                    </div>
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: vendor-purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation