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: shsales-list.php

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

header("Location:company.php");
    
    }
    $action=$_REQUEST['action'];

if($action=='delete'){
    
    $insid=$_REQUEST['cid'];
    $res=mysqli_query($con,"DELETE FROM tbl_sales  WHERE p_id='$insid'");
$detq=mysqli_query($con," DELETE FROM tbl_s_details WHERE pd_p_id='$insid'");
$stq=mysqli_query($con,"DELETE FROM tbl_stock WHERE stk_inv_id='$insid' AND stk_trn_type='SALES'");
$spay=mysqli_query($con,"DELETE FROM tbl_salespay WHERE sp_sid='$insid'");
}

if($action=='deleteselected'){

$insid=$_POST['multirow'];
     $insid = ltrim($insid, ',');  
//echo "DELETE FROM tbl_sales  WHERE p_id IN($insid)";
$res=mysqli_query($con,"DELETE FROM tbl_sales  WHERE p_id IN($insid)");
$detq=mysqli_query($con," DELETE FROM tbl_s_details WHERE pd_p_id IN($insid)");
$stq=mysqli_query($con,"DELETE FROM tbl_stock WHERE stk_inv_id IN($insid) AND stk_trn_type='SALES'");
$spay=mysqli_query($con,"DELETE FROM tbl_salespay WHERE sp_sid IN($insid)");

}

?>
<style>
    body{
        color:white;
    }
    h4{

color:black;
    }
    th{
        color:white;
    }
    td{
        color:white;
    }
    td{
        font-size:14px;
    }
</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">Sales List Details</h4>
                        <div class="ml-auto text-right">
                            <nav aria-label="breadcrumb">
                                <ol class="breadcrumb">
                                    <li class="breadcrumb-item"><form action="shsales-list.php?action=deleteselected" method="post">  <input type="hidden" id="multirow" name="multirow"><button type="submit" class="btn btn-danger">DELETE ALL SELECTED</button></form></li>
                                    
                                </ol>
                            </nav>
                        </div>
                    </div>
                </div>
            </div>
            
            
            
            
            
            
            <div class="container-fluid">
                
                
                
                <script type="text/javascript">
                         function setids(idss){

var eids=document.getElementById('multirow').value;
                            var n = eids.search(idss);
                            //var array=eids.split(",");
                           // alert(array);
                            // var a = array.find(function(element) { 
                            //           return element = idss; 
                            //         }); 
                            // alert(a);
                            if(n=='-1'){

eids=eids+','+idss;
                                document.getElementById('multirow').value=eids;  
                            }else{

eids=eids.replace(idss, "");
                                     document.getElementById('multirow').value=eids;

}

</script>
                
                <div class="row">
                <?php  include "javas.php"; ?>    
                   
                    <div class="col-md-12"  style="max-height:500px;overflow-y: scroll;">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title m-b-0">Sales List</h5>
                                <table id="zero_config" class="table table-striped table-bordered" style="width:100%">
        <thead>
            <tr>
                <th>Select</th>
                <th>Bill No</th>
                <th>Bill Date</th>
                <th>Customer Name</th>
                <th>Net Amount</th>
                <th>GST</th>
                <th>Grand Total</th>
                <th>Due Amount</th>
                <th>Action</th>
            </tr>
        </thead>
        <tbody>
            <?php
                    $cq=mysqli_query($con,"SELECT * FROM db_sales ORDER BY id DESC");
                    while($arrc=mysqli_fetch_array($cq)){
                        //$vend=f(q("SELECT * FROM tbl_shops WHERE ag_id='$arrc[p_prov_id]'"));
                       // $dueq=f(q("SELECT SUM(sp_amt) as totpay FROM tbl_salespay WHERE sp_sid='$arrc[p_id]'"));
                       // $dueamt=floatval($arrc['p_grandtotal'])-floatval($dueq['totpay']);
                       // $str='';
                       // $p_bdate=date_create($arrc['p_bdate']);
                       //  $p_bdate=date_format($p_bdate,"d-m-y");
                        
            ?>
            <tr>
                <td><input type="checkbox" style="font-size: 20px;" onclick="setids(<?php echo $arrc['p_id']?>)"></td>
                <td><?php echo $arrc['bill_no']?></td>
                <td><?php echo $arrc['bill_date']?></td>
                <td><?php echo $arrc['customer_name']?></td>
                <td><?php echo $arrc['total']?></td>
                <td><?php echo $arrc['tax_rate']?></td>
                <td><?php echo $arrc['grand_total']?></td>
                <td><?php echo $arrc['due']?></td>
                <?/*?><td><? if($arrc['p_type']=='1'){?>Dine In<?php }elseif($arrc['p_type']=='2'){?>Take Away<?php }elseif($arrc['p_type']=='3'){ ?> Online Order<?php } ?></td>
                <td><?php echo $arrc['p_bill']?></td>
                <td><?php echo $arrc['p_user']?></td>
                <td><?php echo $p_bdate?></td>
                
                <td>&#8377;<?php echo $arrc['p_nettotal']?></td>
                 <td>@<?php echo $arrc['p_gstrate']?>%=<?php echo $arrc['p_gst']?></td>
                 <td><?php echo $arrc['p_grandtotal']?></td>
                <td>
                        <?php $prded=mysqli_query($con,"SELECT * FROM tbl_s_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 $dueamt?>
                </td><?*/?>
               
                <td><a class="lhp" onclick="return confirm('Are you sure you want Delete?')" href="shsales-list.php?action=delete&cid=<?php echo $arrc['p_id']?>"><i class="fa fa-trash"></i></a><br>
<a class="lhp" href="#" data-toggle="modal" data-target="#exampleModal<?php echo $arrc['p_id']?>"><i class="fab fa-cc-amazon-pay"></i></a>
                    <br>
                    <div class="modal fade" id="exampleModal<?php echo $arrc['p_id']?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
                                  <div class="modal-dialog" role="document">
                                    <div class="modal-content">
                                      <div class="modal-header">
                                        <h5 class="modal-title" id="exampleModalLabel">Add Payment</h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                          <span aria-hidden="true">&times;</span>
                                        </button>
                                      </div>
                                      <div class="modal-body">
                            <form action="shopsales.php?action=apsave" class="forms" method="POST">
                                        <div class="form-group row">
                                            <label for="fname" style="color:#000000;" class="col-sm-3 text-right control-label">Bill No.</label>
                                            <div class="col-sm-9">
                                                <input type="text" id="paybill<?php echo $arrc['p_id']?>" class="form-control" name="billno" value="<?php echo $arrc['p_bill']?>">
                                                <strong style="color:#000000;font-size: 10px;">Due Amt: <?php echo $dueamt?></strong>
                                                <input type="hidden" id="dueamt<?php echo $arrc['p_id']?>" value="<?php echo $dueamt?>">

</div>
                                        </div>
                                        <div class="form-group row">
                                            <label for="fname" style="color:#000000;" class="col-sm-3 text-right control-label">Date</label>
                                            <div class="col-sm-9">
                                                <input type="date"  class="form-control" id="paydate<?php echo $arrc['p_id']?>" name="date" placeholder="First Name Here" value="<? echo date('Y-m-d');?>">
                                            </div>
                                        </div>
                                        <div class="form-group row">
                                            <label for="lname" style="color:#000000;" class="col-sm-3 text-right control-label">Amount</label>
                                            <div class="col-sm-9">
                                                <input type="text" class="form-control" id="payamount<?php echo $arrc['p_id']?>" name="amount" placeholder="0.00" autofocus required  value="<?php echo $edit['sp_amt']?>" style="text-align: right;">
                                            </div>
                                        </div>
                                      </div>
                                      <div class="modal-footer">
                                        <label id="confMsg<?php echo $arrc['p_id']?>" style="color:#2B9111;"></label>
                                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                                        <button type="button" onclick="updateSinglepayment(<?php echo $arrc['p_id']?>)" class="btn btn-primary" name="apsave">Save</button>
                                      </div>
                            </form>
                                    </div>
                                  </div>
                                </div>

</div>

<a class="lhp" <?php if($arrc['p_type']=='1'){?>href="sales/shops_print.php?saleid=<?php echo $arrc['p_id']?>"<?}elseif($arrc['p_type']=='2'){?>href="sales/takeawayprint.php?saleid=<?php echo $arrc['p_id']?>"<?}elseif($arrc['p_type']=='2'){?> href="sales/takeawayprint.php?saleid=<?php echo $arrc['p_id']?>" <?}?> target="_blank"><i class="fa fa-print"></i></a>
                <br>
                
                
                </td>
              
            </tr>

<?php } ?>
            
        </tbody>
        <tfoot>
            <tr>
                <th>Select</th>
                <th>Bill No</th>
                <th>Bill Date</th>
                <th>Customer Name</th>
                <th>Net Amount</th>
                <th>GST</th>
                <th>Grand Total</th>
                <th>Due Amount</th>
                <th>Action</th>
            </tr>
        </tfoot>
    </table>
                            </div>
                        </div>
                        
                    </div>
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: shsales-list.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation