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: salesreportservice-print.php

<?php include "top.php";

$action=$_REQUEST['action'];
       $comid=$_SESSION['cavinmilkshake'];
    if($action=='search'){
    
        $servnm=$_POST['servnm'];
        $sac=$_POST['sac'];
        $stotamt=$_POST['stotamt'];
        $etotamt=$_POST['etotamt'];
        $startdate=$_POST['sdate'];
        $stddate=date_create($startdate);
        $stdate=date_format($stddate,"d-m-y");
        $enddate=$_POST['edate'];
         $edddate=date_create($enddate);
        $eddate=date_format($edddate,"d-m-y");

$sws_area=$_POST['sws_area'];
    
        //$sql="SELECT * FROM tbl_purchase WHERE p_bdate BETWEEN '$startdate' AND '$enddate'";
        //echo $sql;
    
    //$vendshop=f(q("SELECT * FROM tbl_agents WHERE ag_id='$emp'"));
    //$vendarea=f(q("SELECT * FROM tbl_area WHERE u_id='$sws_area'"));
        $chk=0;
        if($stddate!='' && $edddate!=''){

$query="SELECT * FROM db_servicebills";

if($servnm!=''){

$query=$query." WHERE se_name='$servnm' ";
                    $chk=1;
                }

if($sac!=''){

if($chk==0){
                        $chk=1;
                        $query=$query." WHERE se_sac='$sac' ";
                    }else{

$query=$query." AND se_sac='$sac' ";
                    }

}

if($stotamt!='' && $etotamt!=''){

if($chk==0){
                        $chk=1;
                        $query=$query." WHERE se_total BETWEEN '$stotamt' AND '$etotamt' ";
                    }else{

$query=$query." AND se_total BETWEEN '$stotamt' AND '$etotamt'  ";
                    }

}

if($chk==0){
             $query=$query." WHERE se_billdate BETWEEN '$startdate' AND '$enddate' ORDER BY se_billdate ASC";
      }else{

$query=$query." AND se_billdate BETWEEN '$startdate' AND '$enddate' ORDER BY se_billdate ASC";
      }
        }
    
    
    }
?>
<style type="text/css">
    th{

font-size: 12px;
    }

td{

font-size: 10px;
         border-bottom: 1px solid gray !important;
    }
</style>

        
        
        <div class="page-wrapper">

<div class="container-fluid">
                
                
                
                <div class="row">
                    
                    
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <h2 class="card-title m-b-0">Sales Report (Services) from <?php echo $stdate?> to <?php echo $eddate?></h2>
                                <table id="example" class="table table-striped table-bordered" style="width:100%" border="1">
        <thead>
            <tr>
                <th>SL No.</th>
                <th>Service Name</th>
                <th>CODE</th>
                <th>Bill No. & Date</th>
                <th>Buyer Name/Contact</th>
               
                <th>Price</th>
                <th>Sub Tot</th>
                <th>Disc.</th>
                <th>CGST.</th>
                <th>SGST.</th>
                <th>IGST.</th>
                <th>Tax Amount</th>
                <th>Total</th>
                <th>Mode</th>
            </tr>
        </thead>
        <tbody>
            <?php
              //$query="SELECT * FROM tbl_sales WHERE p_bdate BETWEEN '$startdate' AND '$enddate' ORDER BY p_serial ASC";
              $i=0;
              $price=0;
              $cgst2=0;
              $cgst6=0;
              $cgst9=0;
              $cgst12=0;
              $sgst2=0;
              $sgst6=0;
              $sgst9=0;
              $sgst12=0;
              $igst2=0;
              $igst6=0;
              $igst9=0;
              $igst12=0;
              $taxamt=0;
              $grandtotal=0;
              $totaldue=0;
              $totalpayment=0;
              $subtot=0;
              $disctot=0;

$brand=mysqli_query($con,$query);
                while($arr=mysqli_fetch_array($brand))
                {$i=$i+1;
                      $getst=f(q("SELECT * FROM db_sales WHERE id='$arr[sale_id]'"));
                      $getcust=f(q("SELECT * FROM db_customer WHERE mob_no='$getst[mobile_no]'"));
                      if($getst['company_id']==$comid){
                    $dueq=f(q("SELECT SUM(sp_amt) as totpay FROM tbl_salespay WHERE sp_sid='$arr[p_id]'"));
                       $dueamt=floatval($arr['p_grandtotal'])-floatval($dueq['totpay']);
                       $amountpaid=floatval($dueq['totpay']);
                       $totaldue=floatval($totaldue)+floatval($dueamt);
                       $totalpayment=floatval($totalpayment)+floatval($amountpaid);

$gstrate=$arr['se_gstrate'];
                    $gstvals=$arr['se_taxamt'];
                
                        $cgst=round(floatval($gstrate)/2,1);
                        $sgst=$cgst;
                        $cgstval=round(floatval($gstvals)/2,2);
                        $sgstval=$cgstval;
                         $igstamt=$arr['se_igstamt'];
                        $igst=$arr['se_igst'];

if($igst=='5'){
                            $igst2=floatval($igst2)+floatval($igstamt);
                        }elseif($igst=='12'){
                             $igst6=floatval($igst6)+floatval($igstamt);
                        }elseif($igst=='18'){
                                 $igst9=floatval($igst9)+floatval($igstamt);
                        }elseif($igst=='28'){
                                 $igst12=floatval($igst12)+floatval($igstamt);
                        }

$sqliy=f(q("SELECT * FROM tbl_products WHERE prod_id='$arra[pd_prodid]'"));
                    $withouttax=$arr['p_nettotal'];
                        
                        $price=floatval($price)+floatval($withouttax);

if($gstrate=='5'){
                        $cgst2=floatval($cgst2)+floatval($cgstval);
                        $sgst2=floatval($sgst2)+floatval($sgstval);
                        }
                        elseif($gstrate=='12'){
                        $cgst6=floatval($cgst6)+floatval($cgstval);
                        $sgst6=floatval($sgst6)+floatval($sgstval);
                        }
                        elseif($gstrate=='18'){
                        $cgst9=floatval($cgst9)+floatval($cgstval);
                        $sgst9=floatval($sgst9)+floatval($sgstval);
                        }
                        elseif($gstrate=='28'){
                        $cgst12=floatval($cgst12)+floatval($cgstval);
                        $sgst12=floatval($sgst12)+floatval($sgstval);
                        }

$taxamt=floatval($taxamt)+floatval($arra['se_taxamt']);
                        $grandtotal=floatval($grandtotal)+floatval($arr['se_total']);
                        $p_bdate=date_create($arr['p_bdate']);
                        $p_bdate=date_format($p_bdate,"d-m-y");
                        $subtot=floatval($subtot)+floatval($arr['se_sub']);
                        $disctot=floatval($disctot)+floatval($arr['se_disc']);

?>
            <tr>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $sl?></td>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $arr['se_name']?></td>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $arr['se_sac']?></td>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $getst['bill_no']?><br><?php echo $getst['bill_date']?></td>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $getst['customer_name']?><br><?php echo $getst['mobile_no']?><br><?php if($getcust['GSTN']!=''){ echo 'GSTN: '.$getcust['GSTN']; } ?></td>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $arr['se_price']?></td>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $arr['se_sub']?></td>
                <td style="text-align: center;border-top:0px;border-bottom: 0px;border-left:0px;"><?php echo $arr['se_disc']?></td>

<?php  } } ?>
            <tr>
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;" colspan="4"></td>
               
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"></td>
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"><strong>TOTAL</strong></td>
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"><?php echo $subtot?></td>
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"><?php echo $disctot?></td>
                
                
                <td style="text-align: right;border-top:2px solid black;border-bottom: 0px;border-left:0px;font-size: 12px;">
                  <?php if(floatval($cgst2)>0){ ?> @2.5%=<?php echo $cgst2?><br><?php } ?>
                   <?php if(floatval($cgst6)>0){ ?>@6%=<?php echo $cgst6?><br><?php } ?>
                  <?php if(floatval($cgst9)>0){ ?> @9%=<?php echo $cgst9?><br><?php } ?>
                  <?php if(floatval($cgst12)>0){ ?> @14%=<?php echo $cgst12?><br><?php } ?>

</td>
                <td style="text-align: right;border-top:2px solid black;border-bottom: 0px;border-left:0px;font-size: 12px;">
                    <?php if(floatval($sgst2)>0){ ?>  @2.5%=<?php echo $sgst2?><br><?php } ?>
                   <?php if(floatval($sgst6)>0){ ?> @6%=<?php echo $sgst6?><br><?php } ?>
                   <?php if(floatval($sgst9)>0){ ?> @9%=<?php echo $sgst9?><br><?php } ?>
                   <?php if(floatval($sgst12)>0){ ?> @14%=<?php echo $sgst12?><br><?php } ?>
                </td>
                 <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"> 
                    <?php if(floatval($igst2)>0){ ?>@5%=<?php echo $igst2?><br><?php } ?>
                   <?php if(floatval($igst6)>0){ ?> @12%=<?php echo $igst6?><br><?php } ?>
                   <?php if(floatval($igst9)>0){ ?> @18%=<?php echo $igst9?><br><?php } ?>
                   <?php if(floatval($igst12)>0){ ?> @28%=<?php echo $igst12?><br><?php } ?>
               </td>
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"><?php echo $taxamt?></td>
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"><?php echo $grandtotal?></td>
                <td style="text-align: center;border-top:2px solid black;border-bottom: 0px;border-left:0px;"></td>
               
                
                
              
            </tr>
        </tbody>
        
    </table>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: salesreportservice-print.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation