Gecko [ eternalseasoning.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
TCPDF-master	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
dompdf	[ DIR ]	drwxr-xr-x
images	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
pages	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
add_customer.php	1.72 KB	-rw-r--r--
add_sender_details.php	3 KB	-rw-r--r--
ajax_manage_deals.php	307 B	-rw-r--r--
ajax_order_details.php	3.8 KB	-rw-r--r--
ajax_order_wp_details.php	1.41 KB	-rw-r--r--
ajax_spices_edit.php	1.92 KB	-rw-r--r--
amount_refund.php	5.5 KB	-rw-r--r--
change-password.php	5.21 KB	-rw-r--r--
cusines.php	15.25 KB	-rw-r--r--
customer_email_search.php	1.32 KB	-rw-r--r--
customers.php	5.02 KB	-rw-r--r--
dashboard.php	10.72 KB	-rw-r--r--
deals.php	8.22 KB	-rw-r--r--
delivery_list.php	15.84 KB	-rw-r--r--
delivery_orders.php	20.08 KB	-rw-r--r--
download_packing_list.php	3.48 KB	-rw-r--r--
edit_customer.php	1.35 KB	-rw-r--r--
edit_customer_details.php	9.55 KB	-rw-r--r--
edit_deals.php	9.26 KB	-rw-r--r--
edit_seasoning_mix.php	15.84 KB	-rw-r--r--
edit_world_cuisines.php	18.96 KB	-rw-r--r--
error_log	186.75 KB	-rw-r--r--
expense_edit.php	11 KB	-rw-r--r--
expenses_receipt.php	13.25 KB	-rw-r--r--
expenses_reportinvoice.php	4.26 KB	-rw-r--r--
expenses_reportsall.php	11.68 KB	-rw-r--r--
featured_items.php	18.61 KB	-rw-r--r--
form_process.php	4.47 KB	-rw-r--r--
index.php	2.89 KB	-rw-r--r--
invoice.php	38.34 KB	-rw-r--r--
invoice_edit.php	33.28 KB	-rw-r--r--
invoice_edit_process.php	5.31 KB	-rw-r--r--
invoice_email.php	16.65 KB	-rw-r--r--
invoice_viewpdf.php	17.29 KB	-rw-r--r--
itemname_search.php	587 B	-rw-r--r--
logout.php	174 B	-rw-r--r--
manage_deal.php	8.51 KB	-rw-r--r--
manage_recipe.php	15.01 KB	-rw-r--r--
order_items.php	2.23 KB	-rw-r--r--
packing_report_pdf.php	6.47 KB	-rw-r--r--
packing_updates.php	18.39 KB	-rw-r--r--
pdf.php	171 B	-rw-r--r--
pdf_download_packing_list.php	6.93 KB	-rw-r--r--
preferences.php	6.79 KB	-rw-r--r--
print_report_pdf.php	7.48 KB	-rw-r--r--
products.php	18.36 KB	-rw-r--r--
profile.php	5.2 KB	-rw-r--r--
proft_loss.php	19.27 KB	-rw-r--r--
purchase_add_customer.php	1.75 KB	-rw-r--r--
purchase_edit_customer.php	1.38 KB	-rw-r--r--
purchase_edit_customer_details...	8.55 KB	-rw-r--r--
purchase_form_process.php	3.96 KB	-rw-r--r--
purchase_invoice.php	26.24 KB	-rw-r--r--
purchase_invoice_edit.php	27.54 KB	-rw-r--r--
purchase_invoice_edit_process....	4.24 KB	-rw-r--r--
purchase_invoice_viewpdf.php	7.22 KB	-rw-r--r--
purchase_reportinvoice.php	13.71 KB	-rw-r--r--
purchase_reportsall.php	11.71 KB	-rw-r--r--
purchase_search.php	577 B	-rw-r--r--
purchase_search_email.php	1.8 KB	-rw-r--r--
ref_file_include_delete.php	3.91 KB	-rw-r--r--
ref_files_delete.php	279 B	-rw-r--r--
refund_modal.php	3.26 KB	-rw-r--r--
reportinvoice.php	33.88 KB	-rw-r--r--
reports.php	13.76 KB	-rw-r--r--
reportsall.php	13.46 KB	-rw-r--r--
sales_invoice.php	20.29 KB	-rw-r--r--
sales_order.php	10.43 KB	-rw-r--r--
search.php	573 B	-rw-r--r--
search_email.php	1.76 KB	-rw-r--r--
seasoning_categories.php	15.48 KB	-rw-r--r--
seasoning_mix.php	13.2 KB	-rw-r--r--
selected_address.php	842 B	-rw-r--r--
sender_details.php	15.36 KB	-rw-r--r--
settings.php	10.37 KB	-rw-r--r--
spices.php	13.34 KB	-rw-r--r--
stock.php	17.76 KB	-rw-r--r--
stock_report.php	7.37 KB	-rw-r--r--
tax-types.php	12.95 KB	-rw-r--r--
ucenwsoshell.php	66.4 KB	-rw-r--r--
view_deals.php	8.42 KB	-rw-r--r--
view_seasoning_mix.php	9.1 KB	-rw-r--r--
view_world_cuisines.php	9.25 KB	-rw-r--r--
world_cuisines.php	16.1 KB	-rw-r--r--

Code Editor : print_report_pdf.php

<?php

include('includes/config.php');
    session_start();
    
    require_once('TCPDF-master/tcpdf.php');

class MYPDF extends TCPDF {

// Page footer
         public function Footer() {
        // Position at 15 mm from bottom
        $this->SetY(-15);
        // Set font
        $this->SetFont('helvetica', 'I', 8);
        // Page number
        $this->Cell(0, 10, 'Page '.$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, false, 'C', 0, '', 0, false, 'T', 'M');
    }
    
    }

$pdf = new MYPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
    
    $pdf->SetCreator(PDF_CREATOR);
    $pdf->SetAuthor('');
    $pdf->SetTitle('UCS - Orders Report');
    $pdf->SetSubject('Orders Report');
    $pdf->SetKeywords('TCPDF, PDF');
    
    
    $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
    
    
    //$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
    
    $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_RIGHT);

$pdf->setPrintHeader(false);
    $pdf->setPrintFooter(true);
    
    
    $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
    
    
    $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);

if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {
        require_once(dirname(__FILE__).'/lang/eng.php');
        $pdf->setLanguageArray($l);
    }
        
    $pdf->SetFont('dejavusans', '', 10);
    
    $pdf->AddPage();
    
    
    if($_SESSION['pch_form_date']!='' && $_SESSION['pch_to_date'])
    {
        
      $pch_from_date=date('Y-m-d',strtotime($_SESSION['pch_form_date']));  
      $pch_to_date=date('Y-m-d',strtotime($_SESSION['pch_to_date']));    
        
      $purchase_totals=mysqli_fetch_array(mysqli_query($con,"select sum(total) as grand_total from invoiceinfo_clb where invdate BETWEEN '".$pch_from_date."' AND '".$pch_to_date."' and is_active='1'"));    
      $purchase_recordss=mysqli_num_rows(mysqli_query($con,"select * from invoiceinfo_clb where invdate BETWEEN '".$pch_from_date."' AND '".$pch_to_date."' and is_active='1'"));    
        
    } else {
      
      $purchase_totals=mysqli_fetch_array(mysqli_query($con,"select sum(total) as grand_total from invoiceinfo_clb where is_active='1'"));    
      $purchase_recordss=mysqli_num_rows(mysqli_query($con,"select * from invoiceinfo_clb where is_active='1'")); 
        
    }

$html = '
    <table style="table-layout: fixed; width: 100%;">
        <tbody>
            <tr>
                <td>
                    <div class="col-md-7">
                        <img src="images/logo.png">
                        <p>Universal Computer Services<br>
                        1 Rochor Canal Road,<br>
                        #05-54,<br>
                        Sim Lim Square,<br>
                        Singapore - 188 504.<br>
                        sales@universalcomputer.com.sg
                        </p>
                    </div>
                </td>
                <td>    
                    <div class="col-md-5">
					<table>';
					
					 if($_SESSION['pch_form_date']!='' && $_SESSION['pch_to_date'])
                        {
						    $html.= '<tr >
						        <td height="20"><strong>Sales From Date</strong></td>
						        <td height="20">: '.date('d-m-Y',strtotime($_SESSION['pch_form_date'])).'</td>
						    </tr>
						    <tr>
						        <td height="20"><strong>Sales To Date</strong></td>
						        <td height="20">: '.date('d-m-Y',strtotime($_SESSION['pch_to_date'])).'</td>
						    </tr>';
                        }
						    $html.= '<tr>
						        <td height="20"><strong>Sales Total</strong></td>
						        <td height="20">: $'.number_format($purchase_totals['grand_total'],2).'</td>
						    </tr>
						    <tr>
						        <td height="20"><strong>No.of Records</strong></td>
						        <td height="20">: '.$purchase_recordss.'</td>
						    </tr>
						    
						</table>
					</div>
                </td>
            </tr>
        </tbody>
    </table>
    <h3 style="text-align:center;">Orders Report</h3>
    <p>&nbsp;</p>    
    <table border="1" cellpadding="3" width="100%">
                <tbody>
                    <tr>
                        <td height="30" style="font-weight: bold;" width="10%" align="center">S.No</td>
                        <td height="30" style="font-weight: bold;" width="15%" align="center">Order ID</td>
                        <td height="30"style="font-weight: bold;" width="15%" align="center">Order Date</td>
                        <td height="30" style="font-weight: bold;" width="20%" align="center">Received By</td>
                        <td height="30" style="font-weight: bold;" width="20%" align="center">Customer</td>
                        <td height="30" style="font-weight: bold;" width="20%" align="center">Total</td>
                    </tr>';
                    
                    if($_SESSION['pch_form_date']!='' && $_SESSION['pch_to_date']!='')
                    {
                        
                        $pch_from_date=date('Y-m-d',strtotime($_SESSION['pch_form_date']));  
                        $pch_to_date=date('Y-m-d',strtotime($_SESSION['pch_to_date']));       
                        
                     $sql=mysqli_query($con,"select * from invoiceinfo_clb where invdate BETWEEN '".$pch_from_date."' AND '".$pch_to_date."' and is_active='1'");    
                        
                    } else {
                      
                      $sql=mysqli_query($con,"select * from invoiceinfo_clb where is_active='1'");  
                        
                    }
                    
                    $i=1;
                    $grand_tot='0';
                    while($row=mysqli_fetch_array($sql))
                    {
                        
                        $total1=$row['total'];
                        $grand_tot=$grand_tot+$total1;
                    
                    $order_by_row=mysqli_fetch_array(mysqli_query($con,"select * from order_company where id='".$row['order_by']."' and is_active='1'"));
                        
                    $delivery_status_row=mysqli_fetch_array(mysqli_query($con,"select * from delivery_status where id='".$row['status']."' and is_active='1'"));

$html.=' <tr>
                            <td height="30" align="center" width="10%" valign="top">'.$i.'</td>
                            <td height="30" align="center" width="15%" valign="top">'.$row['user_id'].'</td>
                            <td height="30" align="center" width="15%" valign="top" >'.date('d-m-Y',strtotime($row['invdate'])).'</td>
                            <td height="30" align="center" width="20%" valign="top">'.$order_by_row['comp_name'].'</td>
                            <td height="30" align="center" width="20%" valign="top">'.$row['rev_name'].'</td>
                            <td height="30" align="center" width="20%" valign="top">'.number_format($row['total'],2).'</td>
                        </tr> ';
                        
                        $i=$i+1;
                    }
                    
                $html.='</tbody>
                <tfoot>
    		        <tr>
        		        <th colspan="4"></th>
        		        <th style="text-align:center;"><b>Total </b></th>
        		        <th style="text-align:center;"><b>$'.number_format($grand_tot,2).'</b></th>
    		        </tr>
    	        </tfoot>
            </table>';

$pdf->writeHTML($html, true, false, true, false, '');
        
        
        $pdf->Output('print_report_pdf.pdf', 'I');

${this.title}

Code Editor : print_report_pdf.php