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

<?phpinclude "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]'"));

$billno=$sqli['bill_no'];

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

</tr> 
                                                           <tr>
                                                               <td style='font-size: 12px;'>GSTN:</td>
                                                                <td style='font-size: 12px;'>".$sqli['cust_gst']."</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;'>".$sqli['prod_name']."</td>
                                        </tr>
                                        <tr style='width: 100%'>
                                            
                                            <td style='font-size: 12px;'>Model:</td>
                                            <td style='font-size: 12px;'>".$sqli['prod_model']."</td>
                                        </tr>
                                        <tr style='width: 100%'>
                                            
                                            <td style='font-size: 12px;'>Serial No.:</td>
                                            <td style='font-size: 12px;'>".$sqli['prod_serial']."</td>
                                        </tr>
                                        <tr style='width: 100%'>
                                            
                                            <td style='font-size: 12px;'>IMEI:</td>
                                            <td style='font-size: 12px;'>".$sqli['prod_bp']."</td>
                                        </tr>
                                        <tr style='width: 100%'>
                                            
                                            <td style='font-size: 12px;'>Job Sheet:</td>
                                            <td style='font-size: 12px;'>".$sqli['j_no']."</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: 14px;font-weight: bold;'>Details Of Services
                                        </div>
                                    </div><br>
                                <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>Code</th>
                <th>Price</th>
                <th>Discount</th>
                <th>Sub Total</th>
                <th>CGST Rate</th>
                <th>SGST Rate</th>
                <th>IGST Rate</th>
                <th>Tax Amount</th>
                <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");

?>
            <?$head=$head."<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;'>".$arr['se_name']."</td>
                <td style='text-align: center;font-size: 12px;'>".$arr['se_sac']."</td>
                 <td style='text-align: center;font-size: 12px;'>".$arr['se_price']."</td>
                 <td style='text-align: center;font-size: 12px;'>@".$arr['se_disc']."</td>
                <td style='text-align: center;font-size: 12px;'>".$arr['se_sub']."</td>
               
                <td style='text-align: center;font-size: 12px;'>@".$arr['se_cgst']."%<br>Rs.".$arr['se_cgstamt']."</td>
                <td style='text-align: center;font-size: 12px;'>@".$arr['se_sgst']."%<br>Rs.".$arr['se_sgstamt']."</td>
                <td style='text-align: center;font-size: 12px;'>@".$arr['se_igst']."%<br>Rs.".$arr['se_igstamt']."</td>
                <td style='text-align: center;font-size: 12px;'>".$arr['se_taxamt']."</td>
                <td style='text-align: center;font-size: 12px;'>".$arr['se_total']."</td>
               
                
                
              
            </tr>" ; ?>

<?}?>
            <?$head=$head."<tr style='font-size: 12px;'>
                 <td colspan='5' style='text-align:right;'><strong>TOTAL</strong></td>
                <td style='text-align:center;'>".$netamt."</td>
               
                <td style='text-align:center;'>
                    ".$cgstrate."
                   </td>
                <td style='text-align:center;'>
                    ".$sgstrate."
                </td>
                <td style='text-align:center;'>
                    ".$igstrate."
                </td>
                <td style='text-align:center;'>
                    ".$taxamt."

</td>
                <td style='text-align:center;'>
                    ".$gtamt."</td>
                
              
                
                
              
            </tr>
        </tbody>
    </table>
    <br>
    <table class='row' style='background-color: #e1e1d0; border-style: solid; border-width: 1px;width:100%;'>
                                        
        <tr style='width:100%';><td style='padding: 5px;font-size: 14px;font-weight: bold;width:100%;'> Details Of Spares </td>

</tr>
                                    
    </table>
                                <table id='example' class='table table-striped table-bordered' style='width:100%' border='1'>
        <thead>
            <tr>
                <th>SL No.</th>
                <th>Item Description</th>
                <th>HSN/SSD</th>
                <th>QTY/UNIT</th>
                <th>Rate Per Item</th>
                <th>Disc(Rs.)</th>
                <th>Sub Total</th>
                
                <th>CGST Rate And Amount</th>
                <th>SGST Rate And Amount</th>
                <th>IGST Rate And Amount</th>
                <th>Tax Amount</th>
                <th>Total</th>
                
            </tr>
        </thead>
        <tbody>"; ?>
            <?php
              $query="SELECT * FROM db_saleitems WHERE sale_id='$saleid'";
              $i=0;
                 $brandi=mysqli_query($con,$query);
                while($arri=mysqli_fetch_array($brandi))
                {$i=$i+1;
                      $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']);
            ?>
            <?$head=$head."<tr style='font-size: 11px;'>
                <td style='text-align: center;'>".$i."</td>
               
                <td style='text-align: center;'>".$arri['med_name']."<br>".$arri['descrip']."</td>
                <td style='text-align: center;'>".$arri['hsn']."</td>
                 <td style='text-align: center;'>".$arri['quan']."".$arri['unit']."</td>
                 <td style='text-align: center;'>".$arri['price']."</td>
                <td style='text-align: center;'>".$arri['disc_amt']."</td>
               <td style='text-align: center;'>".$arri['sub_total']."</td>
                
                <td style='text-align: center;'>
                    @".$arri['cgst']."%&nbsp;&nbsp;=".$arri['cgst_amt']."
                </td>
                <td style='text-align: center;'>
                    @".$arri['sgst']."%&nbsp;&nbsp;=".$arri['sgst_amt']."
                </td>
                <td style='text-align: center;'>
                    @".$arri['igst']."%&nbsp;&nbsp;=".$arri['igst_amt']."
                </td>
                <td style='text-align: center;'>".round($arri['taxable'],2)."</td>
                <td style='text-align: center;'>".$arri['totalv']."</td>

</tr>
" ; ?>
            <?}?>
            <?php $head=$head."<tr style='font-size: 12px;'>
                 <td colspan='6' style='text-align:right;'><strong>TOTAL</strong></td>
                <td style='text-align:center;'>".$psubamt."</td>
               
                <td style='text-align:center;'>
                    ".$pcgstrate."
                   </td>
                <td style='text-align:center;'>
                    ".$psgstrate."
                </td>
                <td style='text-align:center;'>
                    ".$pigstrate."
                </td>
                <td style='text-align:center;'>
                    ".$ptaxamt."

</td>
                <td>".$pnetamt."</td>
                
                
              
            </tr>
        </tbody>
    </table>"; ?>
    <?php
        $gndtot=round(floatval($gtamt)+floatval($pnetamt));

?>
    <?php $head=$head."<br>
    <p style='text-align: right;font-size: 12px;'><b>Total amount to be received:</b> Rs. ".$gndtot."</p>
    <hr>
    <p style='text-align: left;font-size: 12px;'><b>Total amount to be received in words :</b> ".getIndianCurrency($gndtot)."</p>
    <hr>
    <table>
        <tr>
            <th style='text-align: left;'>Terms</th>
            <th style='text-align: left; padding-left: 200px;'>Notes</th>
        </tr>
        <tr>
            <td style='font-size: 11px;'>".$sqli['com_notes']."</td>
            <td style='padding-left: 200px;font-size: 11px;'>".$sqli['com_terms']."</td>
        </tr>
    </table>
    <br><br><br>
    <p style='text-align: right;'>____________________________________</p>
    <p style='text-align: right;'>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>

</body></html>";

<?php
//echo $head;
// include autoloader
require_once 'dompdf/autoload.inc.php';

// reference the Dompdf namespace
use Dompdf\Dompdf;

// instantiate and use the dompdf class
$dompdf = new Dompdf();

$dompdf->loadHtml(html_entity_decode($head));

// (Optional) Setup the paper size and orientation
$dompdf->setPaper('A4', 'portrait');

// Render the HTML as PDF
$dompdf->render();

// $output = $dompdf->output();
// file_put_contents($ids.".pdf", $output);
$filename=$billno.".pdf";
// Output the generated PDF to Browser
///$dompdf->stream($filename,array("Attachment"=>0));

// Output the generated PDF to Browser
$dompdf->stream($filename);

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: print-pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation