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

<?php

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

$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
    
    $pdf->SetCreator(PDF_CREATOR);
    $pdf->SetAuthor('');
    $pdf->SetTitle('Eternal Seasoning - Invoice Order');
    $pdf->SetSubject('Invoice Order');
    $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(false);
    
    
    $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);
    }

$id   = $_GET['invno'];
	$sql  =  mysqli_query($con,"select * from orders_table where order_id='".$id."' and is_active='1'");
	 
    while($row=mysqli_fetch_array($sql))
    {
    
    $customers_row  = mysqli_fetch_array(mysqli_query($con,"select * from customers where id='".$row['customer_id']."' 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'"));  
        
    $user_id   = $row['order_id'];
  
    $invdate   = date('d-m-Y',strtotime($row['created_at']));
   
    $rev_name      =   $row['first_name'];
    $last_name     =   $row['last_name'];
    $address1      =   $row['cust_address'];
    $address2      =   '';
    $rev_pin       =   $row['postal_code'];
    $rev_country   =   $row['cust_country'];
    $rev_email     =   $row['cust_email'];
    $rev_phone     =   $row['phone_num'];
    
    $delivery_date =date('d-m-Y',strtotime($row['delivered_date']));
    
    $shipping_amont  = $row['ship_amount'];
    $total           = $row['total_price'];
    // $amount_paid     = $row['amount_paid'];
    // $balance         = $row['balance'];
    $discount        = $row['discount'];
    $refund          = $row['amount_refund'];
    // $send_id=$row['send_id'];
    // $item_desc=$row['item_desc'];
   
        
    $pdf->SetFont('dejavusans', '', 10);
    
    $pdf->AddPage();

$html = '
    <table style="table-layout: fixed; width: 100%;">
        <tbody>
            <tr>
                <td>
                    <div class="col-md-7">
                        <img src="images/logo.png">
                    </div>
                </td>
                <td>    
                    <div class="col-md-5">
						<table>
						    <tr>
						        <td><strong>Order ID</strong></td>
						        <td>: '.$user_id.'</td>
						    </tr>
						    <tr>
						        <td><strong>Order Date</strong></td>
						        <td>: '.$invdate.'</td>
						    </tr>
						</table>
					</div>
                </td>
            </tr>
        </tbody>
    </table>
        
    <div style="padding-top: 1cm; padding-bottom: 1cm;">
        <table style="table-layout: fixed; width: 100%;">
            <tbody>
                <tr>
                    <td width="38%">
                        <table>';
                            $sender_details=mysqli_query($con,"select * from sender_details where id='1' and is_active='1'");
					        while($row_sender=mysqli_fetch_array($sender_details)){
                                $sen_name=$row_sender['name'];
                                $sen_address=$row_sender['address'];
                                $sen_address2=$row_sender['address2'];
                                $sen_address3=$row_sender['address3'];
                                $sen_pincode=$row_sender['pincode'];
                                $sen_country=$row_sender['country'];
                                $sen_email=$row_sender['email'];
								$sen_phone=$row_sender['phone'];
								$business_name  = $row_sender['name'];
    						    $html.='
    						    <tr>
    						        <td><strong><u>Sold By</u></strong></td>
    						    </tr>
    						    <tr>
    						        <td></td>
    						    </tr>';
    						    if($sen_name!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_name.'</td>
        						    </tr>';
					            }
    						    if($sen_address!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_address.'</td>
        						    </tr>';
					            }
    						    if($sen_address2!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_address2.'</td>
        						    </tr>';
					            }
					            if($sen_address3!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_address3.'</td>
        						    </tr>';
					            }
					            if($sen_pincode!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_pincode.'</td>
        						    </tr>';
					            }
					            if($sen_country!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_country.'</td>
        						    </tr>';
					            }
					            if($sen_email!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_email.'</td>
        						    </tr>';
					            }
					            if($sen_phone!='')
    						    {
        						    $html.='
        						    <tr>
        						        <td>'.$sen_phone.'</td>
        						    </tr>';
					            }
					        }
    						$html.='</table>
					   
                    </td>
                    
                    <td width="35%">
    						<table>
    						    <tr>
    						        <td><strong><u>Shipping To</u></strong></td>
    						    </tr>
    						    <tr>
    						        <td></td>
    						    </tr>';
    						    if($rev_name!='')
    						    {
    						    $html.='<tr>
    						        <td>'.$rev_name.' '.$last_name.'</td>
    						    </tr>';
    						    }
    						    if($address1!='')
    						    {
    						    $html.='<tr>
    						        <td>'.$address1.'</td>
    						    </tr>';
    						    }
    						    if($address2!='')
    						    {
    						    $html.='<tr>
    						        <td>'.$address2.'</td>
    						    </tr>';
    						    }
    						   
    						    if($rev_pin!='')
    						    {
    						    $html.='<tr>
    						        <td>'.$rev_pin.'</td>
    						    </tr>';
    						    }
    						    if($rev_country!='')
    						    {
    						    $html.='<tr>
    						        <td>'.$rev_country.'</td>
    						    </tr>';
    						    }
    						    if($rev_email!='')
    						    {
    						    $html.='<tr>
    						        <td>'.$rev_email.'</td>
    						    </tr>';
    						    }
    						    if($rev_phone!='')
    						    {
    						    $html.='<tr>
    						        <td>'.$rev_phone.'</td>
    						    </tr>';
    						    }
    						$html.='</table>
					  
                    </td>
                    
                    <td width="27%">
                       
						<table>
						    <tr>
						        <td><strong><u>Delivery Details</u></strong></td>
						    </tr>
						    <tr>
						    <td></td>
						    </tr>
						    <tr>
						        <td><b>Date</b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: '.date('d-m-Y',strtotime($row['delivered_date'])).'</td>
						    </tr>
						    
						    <tr>
						        <td><b>Status</b> &nbsp;&nbsp;&nbsp;&nbsp; : '.$delivery_status_row['sts_option'].'</td>
						    </tr>
						    
						    </table>
					    
                    </td>
                    
                </tr>
            </tbody>
        </table>
    </div>
    
    <table align="left" style="width:100%;">
        <table border="1" cellpadding="3" style="padding-right:10px; width:100%;">
            <tbody>
                <tr>
                    <td style="font-weight: bold;" width="8%" align="center">S.No</td>
                    <td style="font-weight: bold;" width="33%" align="center">Item Name</td>
					<td style="font-weight: bold;" width="12%" align="center">Quantity</td>
					<td style="font-weight: bold;" width="12%" align="center">Total Weight</td>
                    <td style="font-weight: bold;" width="20%" align="center">Price</td>
                    <td style="font-weight: bold;" width="15%" align="center">Amount</td>
				</tr>';
				
                $sql2=mysqli_query($con,"select * from order_product where order_id='".$row['id']."' and is_active='1'");
                $i=1;
                $grand_tot='0';
                while($row2=mysqli_fetch_array($sql2))
                {

if($row2['product_id'])
					{
						$order_items = mysqli_query($con,"select * from our_products where id='".$row2['product_id']."' and is_active='1'");
						$order_item_product = mysqli_fetch_array($order_items);
						
						$item=$order_item_product['product_name'];
						$quantity=$row2['product_quantity'];
						$prize=$row2['product_price'];
						$total1=$row2['product_total'];
						$grand_tot=$grand_tot+$total1;
						$totalWeight = $row2['total_weight'];

} else {
						$order_items = mysqli_query($con,"select * from reacipies where id='".$row2['reacipie_id']."' ");
						$order_item_product = mysqli_fetch_array($order_items);
						
						$recID = $order_item_product['id']; 
						$item=$order_item_product['recipe_name'];
						$quantity=$row2['product_quantity'];
						$prize=$row2['product_price'];
						$total1=$row2['product_total'];
						$grand_tot=$grand_tot+$total1;
						$totalWeight = $order_item_product['total_weight'];
					}

// $item=$row2['product_name'];

// $prize=$row2['unit_price'];
                    // $quantity=$row2['quantity'];
                    // $total1=$row2['product_price'];
                    // $grand_tot=$grand_tot+$total1;
               
                    $html.=' <tr>
                        <td height="20" width="8%" align="center" valign="top">'.$i.'</td>
                        <td height="20" width="33%" align="left" valign="top">'.$item.'</td>
						<td height="20" width="12%" align="center" valign="top" >'.$quantity.'</td>
						<td height="20" width="12%" align="center" valign="top" >'.$totalWeight.' Gm</td>
                        <td height="20" width="20%" align="center" valign="top">£'.number_format($prize,2).'</td>
                        <td height="20" width="15%" align="center" valign="top">£'.number_format($total1,2).'</td>
                    </tr> ';
                    $i=$i+1;
                }
                
            $discount_reduce= ($grand_tot * ($row['discount'] / 100));
            		        
            $reduce_total= $grand_tot - $discount_reduce;    
                
                $html.='</tbody>
            <tfoot>
    		    <tr>
    		        <th colspan="4"></th>
    		        <th style="text-align:center;"><b>Sub Total (GBP)</b></th>
    		        <th style="text-align:center;"><b>£'.number_format($row['total_price'],2).'</b></th>
    		    </tr>
    		    
    		     <tr>
    		        <th colspan="4"></th>
    		        <th style="text-align:center;"><b>Discount</b></th>
    		        <th style="text-align:center;"><b>£'.number_format($row['discount'],2).'</b></th>
    		    </tr>
    		    
    		    <tr>
    		        <th colspan="4"></th>
    		        <th style="text-align:center;"><b>Vat (20%)</b></th>
    		        <th style="text-align:center;"><b>£'.number_format($row['vat_amt'],2).'</b></th>
    		    </tr>
    		    
		        <tr>
    		        <th colspan="4"></th>
    		        <th style="text-align:center;"><b>Shipping (GBP)</b></th>
    		        <th style="text-align:center;"><b>£'.number_format($row['ship_amount'],2).'</b></th>
    		    </tr>
    		    
    		    <tr>
    		        <th colspan="4"></th>
    		        <th style="text-align:center;"><b>Total (GBP)</b></th>
    		        <th style="text-align:center;"><b>£'.number_format($row['total_price'],2).'</b></th>
    		    </tr>
		    </tfoot>
        </table>
	</table>';

$isRecipe  = false;

$ordeDetails =  mysqli_query($con,"select * from order_product where order_id='".$row['id']."' and is_active='1'");
    
            while($details = mysqli_fetch_array($ordeDetails))
                {
                    if($details['reacipie_id']) {

} else {

$html.='<h3>Spices Details</h3>  <table align="left" style="width:100%;">
							<table border="1" cellpadding="3" style="padding-right:10px; width:100%;">
								
								<tbody>
									<tr>
										<td style="font-weight: bold;" width="35%" align="center">Product Name</td>
										<td style="font-weight: bold;" width="35%" align="center">Spice Name</td>
										<td style="font-weight: bold;" width="30%" align="center">Spice Quantity in Grams</td>
									</tr>';

$productQuery =  mysqli_query($con, "SELECT * FROM order_custom_items WHERE order_id='".$row['id']."' AND product_id='".$details['product_id']."' AND cart_id='".$details['cart_id']."' ");
						
						while ( $spices = mysqli_fetch_array($productQuery) ) {

$order_items        = mysqli_query($con,"select * from our_products where id='".$details['product_id']."' and is_active='1'");
							$order_item_product = mysqli_fetch_array($order_items);
							$item               = $order_item_product['product_name'];

# code...
							$html.=' <tr>
										<td height="20" width="35%" align="center" valign="top">'.$item.'</td>
										<td height="20" width="35%" align="center" valign="top">'.$spices['spice_name'].'</td>
										<td height="20" width="30%" align="left" valign="top">'.$spices['spice_quantity'].'</td>
									</tr> ';
						}

$html.='</tbody>
									</table>
								</table>';

}

$html.='</tbody>
				</table>
			</table>';

$ordeDetails =  mysqli_query($con,"select * from order_product where order_id='".$row['id']."' and is_active='1'");

while($details = mysqli_fetch_array($ordeDetails))
			{
				if($details['reacipie_id']) {

$recipeDetails = mysqli_fetch_array(mysqli_query($con, "SELECT * FROM reacipies WHERE id='".$details['reacipie_id']."'  "));
					$html.='<h3>Recipe Order</h3>  <table align="left" style="width:100%;">
							   <h4> Grinding Type	 :  '.$recipeDetails['grinding_type'].' </h4>
							   <h4> Customer Comment :  '.$recipeDetails['cust_own_desc'].' </h4>
							   <h4> Total Weight	 :  '.$recipeDetails['total_weight'].' </h4>
							   
							<table border="1" cellpadding="3" style="padding-right:10px; width:100%;">
								
								<tbody>
									<tr>
										<td style="font-weight: bold;" width="25%" align="center">Recipe  Name</td>
										<td style="font-weight: bold;" width="25%" align="center">Spice Name</td>
										<td style="font-weight: bold;" width="25%" align="center">Spice Quantity in Grams</td>
										<td style="font-weight: bold;" width="25%" align="center">Row/Roasted
										</td>
									</tr>';
					$spiceQ	= mysqli_query($con, "SELECT * FROM reacipie_items WHERE reacipie_id='".$recipeDetails['id']."' ");
					while ($spicesData = mysqli_fetch_array($spiceQ)  ) {
						# code...

$html.=' <tr>
										<td height="20" width="25%" align="center" valign="top">'.$recipeDetails['recipe_name'].'</td>
										<td height="20" width="25%" align="center" valign="top">'.$spicesData['product_name'].'</td>
										<td height="20" width="25%" align="left" valign="top">'.$spicesData['quantity'].'</td>
										<td height="20" width="25%" align="left" valign="top">'.$spicesData['spices_type'].'</td>

</tr> ';

}

$html.='</tbody>
									</table>
								</table>';

} else {

}

if($refund=='1')
    {
    $html.='<table align="left" style="width:100%;">
        <table cellpadding="3" style="padding-right:10px; width:100%;">
            <h3>Amount Refund Details</h3>
            <tbody>
                <tr>
                    <td style="font-weight: bold;" width="30%" align="center">Refund Date</td>
                    <td style="font-weight: bold;" width="35%" align="center">Refund Amount</td>
                    <td style="font-weight: bold;" width="35%" align="center">Refund Remarks</td>
                </tr>';
                $inv_refund=mysqli_query($con,"select * from invrefund_amount where user_id='".$row['order_id']."' and user_id!='' and is_active='1'");
                while($row_refund=mysqli_fetch_array($inv_refund))
                {
                    $refund_date=date('d-m-Y',strtotime($row_refund['refund_date']));
                    $refund_amount=$row_refund['refund_amount'];
                    $refund_remarks=$row_refund['refund_remarks'];
                $html.='<tr>
                    <td height="20" width="30%" align="center" valign="top">'.$refund_date.'</td>
                    <td height="20" width="35%" align="center" valign="top">'.$refund_amount.'</td>
                    <td height="20" width="35%" align="center" valign="top" >'.$refund_remarks.'</td>
                </tr>';
                }
            $html.='</tbody>
        </table>
    </table>';
    }
   
    
    }

$pdf->writeHTML($html, true, false, true, false, '');

$pdf->Output('invoice_viewpdf.pdf', 'I');

${this.title}

Code Editor : invoice_viewpdf.php