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

<?php  
namespace Dompdf;
require_once 'dompdf/autoload.inc.php';
//include_once 'dompdf/lib/Cpdf.php';
ob_start();
include "top.php";
$insid=$_REQUEST['insid'];
$sqli=f(q("SELECT * FROM db_jobsheet WHERE j_no='$insid'"));
$getcusto=f(q("SELECT * FROM db_customer WHERE id='$sqli[cid]'"));

// echo "<script>

//     window.onload = function(){
//          window.open('getjobsheeto.php?insid=$insid', '_blank'); // will open new tab on window.onload
//     }
// </script>";

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

        
        
        <div class="page-wrapper">

<div class="container-fluid">
                
                
                
                <div class="row">
                    
                    
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <table style="width: 100%">
                                    <tr style="width: 100%;font-size: 12px;font-weight: bold;">
                                        <td style="width: 30%;border-bottom: 1px solid black;"></td>
                                        <td  style="width: 39%;text-align: center;border-bottom: 1px solid black;">ESTIMATE / SERVICE VOUCHER / JOB SHEET</td>
                                        <td style="width: 30%;text-align: right;border-bottom: 1px solid black;">CUSTOMER COPY</td>
                                        
                                    </tr>
                                </table>
                                <table style="width: 100%">
                                    <tr style="width: 100%;">
                                        <td>
                                            <table style="width: 100%;">
                                               
                                                
                                                <tr style="width: 100%;">
                                                    <td style="width: 50%;">
                                                           <table style="width: 100%;">
                                                                 <tr style="width: 100%;">
                                                                    <td colspan="3"><p style="font-size: 18px;"><?php echo $sqli['com_name']?></p></td>
                                                                </tr>
                                                                <tr style="width: 100%;">
                                                                    <td colspan="5" style="font-size: 12px;"><b>Address</b><?php echo $sqli['com_address']?></td>
                                                                </tr>
                                                                <tr style="width: 100%;">
                                                                       <td style="font-size: 12px;"><b>Contact No.:</b></td>
                                                                         <td style="font-size: 12px;"><?php echo $sqli['com_phone']?></td>  
                                                                </tr>
                                                                 <tr style="width: 100%;">
                                                                     <td style="font-size: 12px;">Email ID:</td>
                                                                    <td style="font-size: 12px;"><?php echo $sqli['com_email']?></td>

</tr>
                                                                 <tr style="width: 100%;">
                                                                    <td style="font-size: 12px;">GSTIN:</td>
                                                                    <td style="font-size: 12px;"><?php echo $sqli['com_gst']?></td>

</tr>

</table>

</td>
                                                    <td style="width: 50%;">
                                                        <table style="width: 100%;">
                                                        <tr style="width: 100%;">
                                                             <td style="padding-left: 100px;font-size: 12px;font-weight: bold;text-align: right;">Jobsheet No:</td>
                                                    <td style="font-size: 12px;"><?php echo $sqli['j_no']?></td>

</tr>
                                                        <tr style="width: 100%;">
                                                         <td style="padding-left: 100px;font-size: 12px;font-weight: bold;text-align: right;">Receiving Date:</td>
                                                          <td style="font-size: 12px;"><?php echo date("d-m-Y", strtotime($sqli['rcvdate']))?></td>

</tr>
                                                        <tr style="width: 100%;">
                                                         <td style="padding-left: 100px;font-size: 12px;font-weight: bold;text-align: right;">Expected Delivery Date:</td>
                                                          <td style="font-size: 12px;"><?php echo date("d-m-Y", strtotime($sqli['devdate']))?></td>

</tr>
                                                        <tr style="width: 100%;">
                                                         <td style="padding-left: 100px;font-size: 12px;font-weight: bold;text-align: right;">Received By</td>
                                                          <td style="font-size: 11px;"><?php echo $sqli['rcvd_by']?></td>

</tr>
                                                        <tr style="width: 100%;">
                                                         <td style="padding-left: 100px;font-size: 12px;font-weight: bold;text-align: right;">Receive Time</td>
                                                          <td style="font-size: 11px;"><?php echo $sqli['rcvd_time']?></td>

</tr>
                                                        <tr style="width: 100%;">
                                                         <td style="padding-left: 100px;font-size: 12px;font-weight: bold;text-align: right;">Customer Status:</td>
                                                         <?php 
                                                        $getcust=f(q("SELECT * FROM db_custstatus WHERE id='$sqli[handstat]'"));
                                                        
                                                         ?>
                                                          <td style="font-size: 11px;"><?php echo $getcust['unitname']?></td>

</tr>
                                                        <tr style="width: 100%;">
                                                         <td style="padding-left: 100px;font-size: 12px;font-weight: bold;text-align: right;">Handset Status:</td>
                                                         <?php 
                                                        $gethand=f(q("SELECT * FROM db_handstatus WHERE id='$sqli[custstat]'"));
                                                        
                                                         ?>
                                                          <td style="font-size: 11px;"><?php echo $gethand['unitname']?></td>

</tr>
                                                    </table>

</td>

</tr>
                                                
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                                            
                                    <div class="row" style=" border-style: solid; border-width: 1px;border-radius: 5px;">
                                        <div class="col-md-6">
                                            <p style="padding-left: 10px; font-size: 12px;">Received the following goods for estimate / repair from</p>
                                        </div>
                                        <div class="col-md-12">
                                             <table style="width: 100%">
                                        <tr style="width: 100%">
                                            <td style="width: 50%">
                                                    <table>
                                                           <tr>
                                                                <td colspan="3" style="font-size: 12px;">Mr./ Mrs. <?php echo $sqli['cname']?><br>
                                                                   <b>Address</b> <?php echo $sqli['address']?> <br>
                                                                    <?php  if($sqli['cgst']!=''){?> GSTN: <?php  echo $sqli['cgst']?><br> <?php  }?>
                                                                    Email: <?php echo $getcusto['cust_email']?>
                                                                 </td>
                                                           </tr>
                                                           
                                                           
                                                    </table>

</td>
                                            <td style="width: 50%">
                                                <table style="width: 100%;">
                                                   <tr>
                                                               <td style="font-size: 12px;text-align: right;"><b>Contact No:</b></td>
                                                                <td style="font-size: 12px;"><?php echo $sqli['cphone']?></td>

</tr> 
                                                           <tr>
                                                               <td style="font-size: 12px;text-align: right;"><b>Alt No</b></td>
                                                                <td style="font-size: 12px;"><?php echo $sqli['altno']?></td>
                                                           </tr>

</table>

</td>
                                            
                                        </tr>
                                        </table>

</td>
                                           
                                        </tr>
                                        
                                    </table>    
                                        </div>
                                    </div>
                                    
          <div class="row" style=" border-style: solid; border-width: 1px;border-radius: 5px;">
                             <table id="example" class="" style="width:100%">
                    <thead>
                        <tr>
                            <th style="border-bottom: 1px solid black;">QTY</th>
                            <th style="border-bottom: 1px solid black;">MODEL/MAKE</th>
                            <th style="border-bottom: 1px solid black;">IMEI/SERIAL</th>
                            <th style="border-bottom: 1px solid black;">ACCESSIORIES</th>
                            <th style="border-bottom: 1px solid black;">FAULTS REPORTED BY CUSTOMER</th>
                            <th style="border-bottom: 1px solid black;">ESTIMATE</th>
                            <th style="border-bottom: 1px solid black;">ADVANCE</th>
                            
                            
                        </tr>
                    </thead>
                            <tbody>
                                <?php 
                                    $jql=mysqli_query($con,"SELECT * FROM db_jobsheet WHERE j_no='$insid'");
                                    $i=0;
                                    while($arrql=mysqli_fetch_array($jql)){
                                        $i=$i+1;

?>
                                <tr style="font-size: 12px;">
                                    <td style="text-align: center;font-size: 11px;border-bottom: 1px solid black"><?php echo $i?></td>
                                   
                                    <td style="text-align: center;font-size: 11px;border-bottom: 1px solid black"><?php echo $arrql['make']?><br><?php echo $arrql['mmodel']?></td>
                                    <td style="text-align: center;font-size: 11px;border-bottom: 1px solid black"><?php echo $arrql['imei']?></td>
                                     <td style="text-align: left;font-size: 11px;border-bottom: 1px solid black">
                                         <b>Charger</b>&nbsp;<?php if($arrql['charger']==1){ echo 'Yes';}else{ echo 'No';}?> <br>
                                         <b>Battery</b>&nbsp;<?php if($arrql['battery']==1){ echo 'Yes';}else{ echo 'No';}?> <br>
                                         <b>SIM Card</b>&nbsp;<?php if($arrql['stylus']==1){ echo 'Yes';}else{ echo 'No';}?> <br>
                                         <b>MMC</b>&nbsp;<?php if($arrql['mmc']==1){ echo 'Yes';}else{ echo 'No';}?> <br>
                                         <b>Back Cover</b>&nbsp;<?php if($arrql['backcover']==1){ echo 'Yes';}else{ echo 'No';}?> <br>  
                                         <b>Hard Disc</b>&nbsp;<?php if($arrql['harddisk']==1){ echo 'Yes';}else{ echo 'No';}?> <br>

</td>
                                     <td style="text-align: left;font-size: 11px;border-bottom: 1px solid black;padding-left:12%;">
                                        1 <?php echo $arrql['f1']?><br>
                                        2 <?php echo $arrql['f2']?><br>
                                        3 <?php echo $arrql['f3']?><br>
                                        4 <?php echo $arrql['f4']?><br>

</td>
                                    <td style="text-align: center;font-size: 11px;border-bottom: 1px solid black"><?php echo $arrql['ecost']?></td>
                                   
                                    <td style="text-align: center;font-size: 11px;border-bottom: 1px solid black">
                                            <b>Amount Rs</b><?php echo $arrql['ad_amt']?><br>
                                            <b>Card No</b><?php echo $arrql['crdno']?><br>
                                            <b>Mode</b><?php echo $arrql['mode']?>

</td>
                                    
                                  
                                </tr>
                               
                            <?php } ?>

</tbody>
                    </table>

</div>
                 <div class="row" style="font-size: 12px;margin-bottom: 5px;padding-top: 2px;border:1px solid black;border-radius: 5px;padding:6px;min-height: 40px;">
                     <b>Remarks: </b><?php echo $sqli['remrks']?>
                     
                 </div>
                 <div class="row" style="font-size: 12px;">
                     <b>Notes: </b><?php echo $sqli['com_notes']?>

</div>

<br>
     <p style="text-align: center;">**** THIS IS A COMPUTER GENEREATED JOBSHEET DOESN'T REQUIRE SIGNATURE ****</p>
    <!-- <div class="row" style="border-style: solid; border-width: 1px;border-radius: 5px;">
            <table style="width: 100%;">
                <tr style="width: 100%;">
                    <td style="width: 50%;text-align: center;">
                        <i>Received For</i> <?php echo $sqli['cname']?><br><br><br><br><br>

Date:&nbsp;&nbsp;&nbsp;&nbsp; <small>Signature of the customer</small>
                        
                    </td>
                    <td style="width: 50%;text-align: center;">
                        <i>For The Techno Zone</i> <br><br><br><br><br>

<i>Authorised Signatory</i>

</td>
                    
                    
                </tr>
            </table>

</div> -->
                                
    
    
                            </div>
                        </div>
                        
                    </div>
                </div>
                
                
                
                
                
                
                
                
                
                
                
                
            </div>
            </div>
            
            
            
          
            <?php 
            $jshetn=$sqli['j_no'];
$html = ob_get_clean();
$dompdf = new Dompdf();
$dompdf->setPaper('A4', 'portrait');
$dompdf->load_html($html);
$dompdf->render();
$filename='billpdf/'.$jshetn."-customer.pdf";
//For view
//$dompdf->stream("",array("Attachment" => false));
// for download
$output = $dompdf->output();
//$dompdf->stream($filename);
file_put_contents($filename, $output);

header("Location:sendjpdf.php?insid=$jshetn");

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: downcjobsheet.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation