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: saleslist.php

<?php  include "header.php"; 
    $action=$_REQUEST['action'];
    $page = $_REQUEST["page"];
    $comid=$_SESSION['cavinmilkshake'];
    if($action=='delete'){
    
    $insid=$_REQUEST['cid'];
    $check=f(q("SELECT * FROM db_sales WHERE id='$insid' AND company_id='$comid'"));
    if($check['bill_no']!=''){

$res=mysqli_query($con,"DELETE FROM db_sales  WHERE 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)";
     $check=f(q("SELECT * FROM db_sales WHERE id='$insid' AND company_id='$comid'"));
     if($check['bill_no']!=''){
            $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)");
        }

}
if($action=='tsearch'){
    
    
    $srcbox=$_POST['srcbox'];
    $srcb="%".$srcbox."%";
    
    
}
if($action=='sphone'){
    
    
    $srcbox=$_POST['srcboxphone'];
    $srcb="%".$srcbox."%";
    
    
}
if($action=='sbill'){
    
    
    $srcbox=$_POST['srcboxbill'];
    $srcb="%".$srcbox."%";
    
    
}
if($action=='smod'){
    
    
    $srcbox=$_POST['srcboxmod'];
    $srcb="%".$srcbox."%";
    
    
}

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

color:BLACK;
    }
    th{
        color:WHITE;
        font-size: 10px;
    }
    td{
        color:aqua;
    }
    td{
        font-size:9px;
    }
</style>
<style>
/* Pagination with Rounded Borders */
.pagination {
  display: inline-block;
}

.pagination a {
  color: white;
  float: left;
  padding: 8px 16px;
  text-decoration: none;
  border: 1px solid #fff;
}

.pagination a.active {
  background-color: #4CAF50;
  color: white;
  border: 1px solid #4CAF50;
}

.pagination a:hover:not(.active) {background-color: #fff;color: #000;}

.pagination a:first-child {
  border-top-left-radius: 5px;
  border-bottom-left-radius: 5px;
}

.pagination a:last-child {
  border-top-right-radius: 5px;
  border-bottom-right-radius: 5px;
}

</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">
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <form action="<?php echo $_SERVER['PHP_SELF']?>?action=tsearch" class="text-right" method="POST">
                                    <label>Search By Name</label>
                                <input type="text" class="form-control" name="srcbox"><br>
                                <button type="submit" class="btn btn-primary">Search</button>
                                </form>
                                </div>
                                
                                </div>
                        
                        
                    </div>
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <form action="<?php echo $_SERVER['PHP_SELF']?>?action=sphone" class="text-right" method="POST">
                                    <label>Search By Phone</label>
                                <input type="text" class="form-control" name="srcboxphone"><br>
                                <button type="submit" class="btn btn-primary">Search</button>
                                </form>
                                </div>
                                
                                </div>
                        
                        
                    </div>
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <form action="<?php echo $_SERVER['PHP_SELF']?>?action=sbill" class="text-right" method="POST">
                                    <label>Search By Bill No</label>
                                <input type="text" class="form-control" name="srcboxbill"><br>
                                <button type="submit" class="btn btn-primary">Search</button>
                                </form>
                                </div>
                                
                                </div>
                        
                        
                    </div>
                    <div class="col-md-3">
                        <div class="card">
                            <div class="card-body">
                                <form action="<?php echo $_SERVER['PHP_SELF']?>?action=smod" class="text-right" method="POST">
                                    <label>Search By Model</label>
                                <input type="text" class="form-control" name="srcboxmod"><br>
                                <button type="submit" class="btn btn-primary">Search</button>
                                </form>
                                </div>
                                
                                </div>
                        
                        
                    </div>
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                
                        <?php
                        $arrc = f(q("SELECT COUNT(*) AS total FROM `db_sales` WHERE company_id='$comid'"));
                        $total_pages = $arrc['total'];
                        $total_pages = ceil($total_pages / 200);
                        
                        if ($page == "")
                        {
                            $page = 1;
                        }
                        
                        $prev_page = $page - 1;
                        $next_page = $page + 1;                     
                        
                        ?>
                        <p class="pagination">
                            <a href="saleslist.php?page=<?php if($page == 1){ echo '1'; }else{ echo $prev_page; } ?>">&laquo;</a>
                        <?php 
                        
                        
                        for ($i = 1; $i <= $total_pages; $i++)
                        {
                            ?>
                            <a href="saleslist.php?page=<?php echo  $i ?>" <?php if($page==$i){?> class="active" <?php } ?>><?php echo  $i ?></a>
                            <?php 
                        }
                        ?>
                            <a href="saleslist.php?page=<?php if($page == $total_pages){ echo $total_pages; }else{ echo $next_page  ; } ?>">&raquo;</a>
                        </p>

</div>
                        </div>
                    </div>

<?php  include "javas.php"; ?>    
                   
                    <div class="col-md-12"  style="max-height:500px;overflow-y: scroll;">
                        <div class="card">
                            <div class="card-body">
                                <div class="table-responsive">
                                <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 & Phone</th>
                <th>Jobsheet</th>
                <th>Product Details</th>
                <th>Net Amt</th>
                <th>Advance Amt</th>
                <th>Amt Paid</th>
                <th>Delivered By</th>
                <th>Added By</th>
                <th>Action</th>
            </tr>
        </thead>
        <tbody>
            <?php      $start_limit = 0;
                $end_limit = 200 ;

if ($page != '' && floatval($page) > 1)
                {
                    $start_limit = ($page - 1) * 200;
                    $end_limit=($page)*200;
                }
                
                //$cq = mysqli_query($con,"SELECT * FROM nm_artist WHERE name != '' ORDER BY name LIMIT $start_limit, $end_limit");
                //echo "SELECT * FROM db_sales ORDER BY id DESC LIMIT $start_limit, $end_limit";
                    if($action=='tsearch'){
                        
                        $cq=mysqli_query($con,"SELECT * FROM db_sales WHERE company_id='$comid' AND  customer_name LIKE '$srcb'");
                    }elseif($action=='sbill'){
                        
                        $cq=mysqli_query($con,"SELECT * FROM db_sales WHERE company_id='$comid' AND bill_no LIKE '$srcb'");
                    }elseif($action=='sphone'){
                        
                        $cq=mysqli_query($con,"SELECT * FROM db_sales WHERE company_id='$comid' AND mobile_no LIKE '$srcb'");
                    }elseif($action=='smod'){
                        
                        $cq=mysqli_query($con,"SELECT * FROM db_sales WHERE company_id='$comid' AND prod_model LIKE '$srcb'");
                    }else{
                        
                         $cq=mysqli_query($con,"SELECT * FROM db_sales WHERE company_id='$comid' ORDER BY id DESC LIMIT $start_limit, $end_limit");
                    }
                   
                    //$cq=mysqli_query($con,"SELECT * FROM db_sales");
                    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");

$getcust=f(q("SELECT * FROM db_customer WHERE mob_no='$arrc[mobile_no]'"));
                        
            ?>
            <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']?><br><?php echo $arrc['mobile_no']?><br>Alt:<?php echo $getcust['cust_alt']?></td>
                <td><?php echo $arrc['jobsheet']?></td>
                <td><?php echo $arrc['prod_name']?><br>Model:<?php echo $arrc['prod_model']?><br>IMEI:<?php echo $arrc['prod_bp']?></td>
                <td><?php echo $arrc['bill_net']?></td>
                
                <td><?php echo $arrc['advpaym']?></td>
                <td><?php echo $arrc['amt_paid']?></td>
                <td><?php echo $arrc['del_by']?></td>
                <td><?php echo $arrc['added_by']?></td>
                <?php /*?><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>
                    <?php  if($_SESSION['bigapple']=='admin'){?>
                        <a class="lhp" href="sale.php?action=edit&cid=<?php echo $arrc['id']?>"><i class="fa fa-edit"></i></a><br>
                    <a class="lhp" onclick="return confirm('Are you sure you want Delete?')" href="saleslist.php?action=delete&cid=<?php echo $arrc['id']?>"><i class="fa fa-trash"></i></a><?php }?>

<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="<?php 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" href="sales-print.php?saleid=<?php echo $arrc[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 & Phone</th>
                <th>Jobsheet</th>
                <th>Product Details</th>
                <th>Grand Total</th>
                <th>Disc</th>
                <th>Net Amt</th>
                <th>Delivered By</th>
                
                <th>Added By</th>
                <th>Action</th>
            </tr>
        </tfoot>
    </table>
                                </div>
                            </div>
                        </div>
                        
                    </div>
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: saleslist.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation