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

<?php include "top.php";
$saleid=$_REQUEST['saleid'];
$sqli=f(q("SELECT * FROM db_sales WHERE id='$saleid'"));
$sql=f(q("SELECT * FROM db_saleitems WHERE sale_id='$sqli[id]'"));
$sersql=f(q("SELECT * FROM db_servicebills WHERE sale_id='$saleid'"));
$jssql=f(q("SELECT * FROM db_jobsheet WHERE j_id='$sql[job_id]'"));
$getcomp=f(q("SELECT * FROM db_store WHERE id='$sqli[company_id]'"));
$isgst=$getcomp['isgst'];
//$getcusto=f(q("SELECT * FROM db_customer WHERE id='$sqli[cid]'"));

?>
<style type="text/css">
    th{
        font-size: 11px;
    }
</style>

        
        
        <div class="page-wrapper">

<div id="print-content">
            <div class="container-fluid">

<div class="row">
                    
                    
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <table>
                                    <tr>
                                        <td style="width:7%;">
                                            <img src="assets/images/print-icon.png" style="width: 100%;">
                                        </td>
                                        <td>
                                            <table>
                                                <tr>
                                                    <td colspan="3"><p style="font-size: 16px;"><?php echo $sqli['com_name']?></p></td>
                                                </tr>
                                                <tr>
                                                    <td colspan="5" style="font-size: 11px;"><?php echo $sqli['com_addr']?></td>
                                                </tr>
                                                <tr>
                                                    <td style="font-size: 11px;">Contact No.:</td>
                                                    <td style="font-size: 11px;"><?php echo $sqli['com_phone']?></td>
                                                    <td style="padding-left: 100px;font-size: 11px;">Invoice No.:</td>
                                                    <td style="font-size: 11px;"><?php echo $sqli['bill_no']?></td>
                                                </tr>
                                                <tr>
                                                    <td style="font-size: 11px;">Email ID:</td>
                                                    <td style="font-size: 11px;"><?php echo $sqli['com_email']?></td>
                                                    <td style="padding-left: 100px;font-size: 12px;">Invoice Date:</td>
                                                    <td style="font-size: 11px;"><?php echo date("d-m-Y", strtotime($sqli['bill_date']))?></td>
                                                </tr>
                                                <tr>
                                                    <td style="font-size: 11px;"><?php if($isgst=='1'){?>GSTIN:<?php }?></td>
                                                    <td style="font-size: 11px;"><?php if($isgst=='1'){?><?php echo $sqli['com_tax']?> <?php  } ?></td>
                                                    <td style="padding-left: 100px;font-size: 12px;">Invoice Time:</td>
                                                    <td style="font-size: 11px;"><?php echo $sqli['bill_time']?></td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                                            
                                    <div class="row" style="background-color: #e1e1d0; border-style: solid; border-width: 1px;">
                                        <div class="col-md-3" style="max-height: 20px;">
                                            <p style="padding-left: 10px; font-size: 11px;font-weight: bold;">Customer Details</p>
                                        </div>
                                    </div>
                                    <table style="width: 100%">
                                        <tr style="width: 100%">
                                            <td style="width: 50%">
                                                    <table>
                                                           <tr>
                                                                <td colspan="3" style="font-size: 12px;"><?php echo $sqli['customer_name']?><br>
                                                                    <?php echo $sqli['address']?> <br>
                                                                    Email: <?php echo $sqli['cust_email']?>

</td>
                                                           </tr>
                                                           
                                                           <tr>
                                                               <td style="font-size: 12px;">Contact No.:</td>
                                                                <td style="font-size: 12px;"><?php echo $sqli['mobile_no']?></td>

</tr> 
                                                           <tr>
                                                               <td style="font-size: 12px;"><?php if($isgst=='1'){?>GSTN:<?php } ?></td>
                                                            <td style="font-size: 12px;"><?php if($isgst=='1'){?><?php echo $sqli['cust_gst']?><?php }?></td>
                                                           </tr>

</table>

</td>
                                            <td style="width: 50%">
                                                <table>
                                                       <tr style="width: 100%">
                                            
                                            <td style="font-size: 12px;">Product Name:</td>
                                            <td style="font-size: 12px;"><?php echo $sqli['prod_name']?></td>
                                        </tr>
                                        <tr style="width: 100%">
                                            
                                            <td style="font-size: 12px;">Model:</td>
                                            <td style="font-size: 12px;"><?php echo $sqli['prod_model']?></td>
                                        </tr>
                                        <tr style="width: 100%">
                                            
                                            <td style="font-size: 12px;">Serial/IMEI:</td>
                                            <td style="font-size: 12px;"><?php echo $sqli['prod_bp']?></td>
                                        </tr>
                                        
                                        <tr style="width: 100%">
                                            
                                            <td style="font-size: 12px;">Job Sheet:</td>
                                            <td style="font-size: 12px;"><?php echo $sqli['jobsheet']?></td>
                                        </tr>

</table>

</td>
                                           
                                        </tr>
                                        
                                    </table> 
                                    <div class="row" style="background-color: #e1e1d0; border-style: solid; border-width: 1px;">
                                       <div class="col=md-12" style="padding: 5px;font-size: 11px;font-weight: bold;">Details Of Services
                                        </div>
                                    </div>
                                <table id="example" class="table table-striped table-bordered" style="width:100%" border="1">
        <thead>
            <tr>
                <th>SL No.</th>
                <th>Services Name</th>
                <th>SAC Code</th>
                <th>Price</th>
                <th>Discount</th>
                <th>Sub Total</th>
                <?php  if($isgst=='1'){?><th>CGST</th>
                <th>SGST</th>
                <th>IGST</th>
                <th>Tax Amount</th><?php } ?>
                <th>Total</th>
                
            </tr>
        </thead>
        <tbody>
            <?php
              $i=0;
              // $price=0;
              // $cgstrate=0;
              // $sgstrate=0;
              // $netamt=0;
              // $taxamt=0;
              $queri="SELECT * FROM db_servicebills WHERE sale_id='$saleid'";
                $brand=mysqli_query($con,$queri);
                while($arr=mysqli_fetch_array($brand))
                { $i=$i+1;

// $cgst=round(floatval($arr['p_gstrate'])/2,1);
                        // $sgst=$cgst;
                        // $cgstval=round(floatval($arr['p_gst'])/2,2);
                        // $sgstval=$cgstval;

// $price=floatval($price)+floatval($withouttax);

$cgstrate=floatval($cgstrate)+floatval($arr['se_cgstamt']);
                         $sgstrate=floatval($sgstrate)+floatval($arr['se_sgstamt']);
                         $igstrate=floatval($igstrate)+floatval($arr['se_igstamt']);

$netamt=floatval($netamt)+floatval($arr['se_sub']);
                        $taxamt=floatval($taxamt)+floatval($arr['se_taxamt']);
                        $gtamt=floatval($gtamt)+floatval($arr['se_total']);
                        // $p_bdate=date_create($arr['p_bdate']);
                        // $p_bdate=date_format($p_bdate,"d-m-y");

?>
            <tr style="font-size: 12px;">
                <td style="text-align: center;font-size: 12px;"><?php echo $i?></td>
               
                <td style="text-align: center;font-size: 12px;"><?php echo $arr['se_name']?></td>
                <td style="text-align: center;font-size: 12px;"><?php echo $arr['se_sac']?></td>
                 <td style="text-align: center;font-size: 12px;"><?php echo $arr['se_price']?></td>
                 <td style="text-align: center;font-size: 12px;">@<?php echo $arr['se_disc']?></td>
                <td style="text-align: center;font-size: 12px;"><?php echo $arr['se_sub']?></td>
               
               <?php  if($isgst=='1'){?> <td style="text-align: center;font-size: 12px;">Rs.<?php echo $arr['se_cgstamt']?></td>
                <td style="text-align: center;font-size: 12px;">Rs.<?php echo $arr['se_sgstamt']?></td>
                <td style="text-align: center;font-size: 12px;">Rs.<?php echo $arr['se_igstamt']?></td>
                <td style="text-align: center;font-size: 12px;"><?php echo $arr['se_taxamt']?></td><?php } ?>
                <td style="text-align: center;font-size: 12px;"><?php echo $arr['se_total']?></td>
               
                
                
              
            </tr>

<?php } ?>
            <tr style="font-size: 12px;">
                 <td colspan="5" style="text-align:right;"><strong>TOTAL</strong></td>
                <td style="text-align:center;"><?php echo $netamt?></td>
               
                <?php  if($isgst=='1'){?><td style="text-align:center;">
                    <?php echo $cgstrate?>
                   </td>
                <td style="text-align:center;">
                    <?php echo $sgstrate?>
                </td>
                <td style="text-align:center;">
                    <?php echo $igstrate?>
                </td>
                <td style="text-align:center;">
                    <?php echo $taxamt?>

</td><?php } ?>
                <td style="text-align:center;">
                    <?php echo $gtamt?></td>
                
               
                
                
              
            </tr>
        </tbody>
    </table>
    
    <div class="row" style="background-color: #e1e1d0; border-style: solid; border-width: 1px;">
                                        
                                         <div class="col=md-12" style="padding: 5px;font-size: 11px;font-weight: bold;"> Details Of Spares</div>
                                    
    </div>
                                <table id="example" class="table table-striped table-bordered" style="width:100%" border="1">
        <thead>
            <tr>
                <th>SL No.</th>
                <th  colspan="<?php if($isgst=='1'){?>0<?php  }else{?>5<?php  } ?>">Item Description</th>
                <th>HSN Code</th>
                <th>QTY/UNIT</th>
                <th>Rate Per Item</th>
                <th>Disc(Rs.)</th>
                <th>Sub Total</th>
                
                <?php  if($isgst=='1'){?><th>CGST</th>
                <th>SGST</th>
                <th>IGST</th>
                <th>Tax Amount</th><?php } ?>
                <th>Total</th>
                
            </tr>
        </thead>
        <tbody>
            <?php
              $query="SELECT * FROM db_saleitems WHERE sale_id='$saleid'";
              $i=0;
              // $price=0;
              // $cgstrate=0;
              // $sgstrate=0;
              // $netamt=0;
              // $taxamt=0;

$brandi=mysqli_query($con,$query);
                while($arri=mysqli_fetch_array($brandi))
                {$i=$i+1;

// $price=floatval($price)+floatval($withouttax);

$pcgstrate=floatval($pcgstrate)+floatval($arri['cgst_amt']);
                    $psgstrate=floatval($psgstrate)+floatval($arri['sgst_amt']);
                    $pigstrate=floatval($pigstrate)+floatval($arri['igst_amt']);
                        
                         $psubamt=floatval($psubamt)+floatval($arri['sub_total']);
                         $pnetamt=floatval($pnetamt)+floatval($arri['totalv']);
                         $ptaxamt=floatval($ptaxamt)+floatval($arri['taxable']);

// $p_bdate=date_create($arr['p_bdate']);
                        // $p_bdate=date_format($p_bdate,"d-m-y");

?>
            <tr style="font-size: 11px;">
                <td style="text-align: center;"><?php echo $i?></td>
               
                <td style="text-align: center;" colspan="<?php if($isgst=='1'){?>0<?php  }else{?>5<?php  } ?>"><?php echo $arri['med_name']?><br><?php echo $arri['descrip']?><br>Warranty: <?php echo $arri['warr']?></td>
                <td style="text-align: center;"><?php echo $arri['hsn']?></td>
                 <td style="text-align: center;"><?php echo $arri['quan']?><?//$arri['unit']?></td>
                 <td style="text-align: center;"><?php echo $arri['price']?></td>
                <td style="text-align: center;"><?php echo $arri['disc_amt']?></td>
               <td style="text-align: center;"><?php echo $arri['sub_total']?></td>
                
                <?php  if($isgst=='1'){?><td style="text-align: center;">
                    <?php echo $arri['cgst_amt']?>
                </td>
                <td style="text-align: center;">
                    <?php echo $arri['sgst_amt']?>
                </td>
                <td style="text-align: center;">
                   <?php echo $arri['igst_amt']?>
                </td>
                <td style="text-align: center;"><?php echo round($arri['taxable'],2)?></td><?php } ?>
                <td style="text-align: center;"><?php echo $arri['totalv']?></td>
               
                
                
              
            </tr>

<?php } ?>
            <tr style="font-size: 12px;">
                 <td colspan="<?php if($isgst=='1'){?>6<?php  }else{?>10<?php  } ?>" style="text-align:right;"><strong>TOTAL</strong></td>
                <td style="text-align:center;"><?php echo $psubamt?></td>
               
                <?php  if($isgst=='1'){?><td style="text-align:center;">
                    <?php echo $pcgstrate?>
                   </td>
                <td style="text-align:center;">
                    <?php echo $psgstrate?>
                </td>
                <td style="text-align:center;">
                    <?php echo $pigstrate?>
                </td>
                <td style="text-align:center;">
                    <?php echo $ptaxamt?>

</td><?php } ?>
                <td><?php echo $pnetamt?></td>
               
                
                
              
            </tr>
             <?php
        $gndtot=round(floatval($gtamt)+floatval($pnetamt));

?>
            <tr style="font-size: 12px;">
                 <td colspan="6" style="text-align:right;"></td>
                <td style="text-align:center;"></td>
               
                <td style="text-align:center;">
                   
                   </td>
                <td style="text-align:center;">
                   
                </td>
                <td style="text-align:center;">
                   
                </td>
                <td style="text-align:center;">
                    <small>Grand Total</small>

</td>
                <td><?php echo $gndtot?></td>
               
                
                
              
            </tr>
            
             <tr style="font-size: 12px;">
                 <td colspan="6" style="text-align:right;"></td>
                <td style="text-align:center;"></td>
               
                <td style="text-align:center;">
                   
                   </td>
                <td style="text-align:center;">
                   <small>Coupon Details</small>
                </td>
                <td style="text-align:center;">
                   <?php echo $sqli['coup_name']?> (<?php echo $sqli['coupval']?>)
                </td>
                <td style="text-align:center;">
                    <small>Coupon Discount</small>

</td>
                <td><?php echo $sqli['coup_disc']?></td>
               
                
                
              
            </tr>
             <tr style="font-size: 12px;">
                 <td colspan="6" style="text-align:right;"></td>
                <td style="text-align:center;"></td>
               
                <td style="text-align:center;">
                   
                   </td>
                <td style="text-align:center;">
                   
                </td>
                <td style="text-align:center;">
                   
                </td>
                <td style="text-align:center;">
                    <small>Net Amount</small>

</td>
                <td><?php echo $sqli['bill_net']?></td>
               
                
                
              
            </tr>
            <tr style="font-size: 12px;">
                 <td colspan="6" style="text-align:right;"></td>
                <td style="text-align:center;"></td>
               
                <td style="text-align:center;">
                   
                   </td>
                <td style="text-align:center;">
                   
                </td>
                <td style="text-align:center;">
                   
                </td>
                <td style="text-align:center;">
                    <small>Advance Payment</small>

</td>
                <td><?php echo $sqli['advpaym']?></td>
               
                
                
              
            </tr>
        </tbody>
    </table>
  
    <p style="text-align: right;font-size: 12px;"><b>Total amount to be received:</b> Rs. <?php echo $sqli['amtpayb']?></p>
    <hr>
      <p style="text-align: left;font-size: 12px;"><b>Delivered By:</b> <?php echo $sqli['prescribed_by']?></p>
    <hr>
    <p style="text-align: left;font-size: 12px;text-transform: uppercase;font-weight: 600;"><b>Total amount to be received in words :</b> <?php echo getIndianCurrency($sqli['amtpayb'])?></p>
    <table style="width: 100%;">
        <tr style="width: 100%;">
            <th style="text-align: center;width: 32%;font-size: 10px;font-weight: bold;">Terms</th>
            <th style="text-align: center;width: 32%;font-size: 10px;font-weight: bold;">Remarks</th>
            <th style="text-align: center;width: 32%;font-size: 10px;font-weight: bold;">Notes</th>
        </tr>
        <tr>
            <td style="font-size: 10px;border-right: 1px solid gray;padding: 1%;"><?php echo $sqli['com_terms']?></td>
            <td style="font-size: 10px;border-right: 1px solid gray;padding: 1%;text-align:center;"><?php echo $sqli['b_remarks']?></td>
            <td style="font-size: 10px;padding: 1%;"><?php echo $sqli['com_notes']?></td>
        </tr>
    </table><br><br><br><br><br><br>
    
    <p style="text-align: right;padding-right: 20px;">____________________________________</p>
    <p style="text-align: right;padding-right: 20px;">Signature &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>

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

<a href="getpdf.php?saleid=<?php echo $saleid?>" class="btn btn-success" target="_blank"><img src="assets/images/download-file.png" style="width:3%"></a>

<a href="emailpdf.php?saleid=<?php echo $saleid?>" class="btn btn-success" target="_blank"><img src="assets/images/message.png" style="width:3%"></a>

</div>

</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales-print.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation