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_email.php

<?php

if(isset($_POST['email_send']))	
    {

$message = '';
        
        $connect = new PDO("mysql:host=localhost;dbname=lagpat_invdemo", "lagpat_invdemo", "uFn1y3ti2NQw");

<br/>
    <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="10%" align="center" bgcolor="#f9fcfd" valign="middle">S.No</td>
                    <td style="font-weight: bold;" width="49%" align="center" bgcolor="#f9fcfd" valign="middle">Item Name</td>
                    <td style="font-weight: bold;" width="16%" align="center" bgcolor="#f9fcfd" valign="middle">Quantity</td>
                    <td style="font-weight: bold;" width="15%" align="center" bgcolor="#f9fcfd" valign="middle">Price</td>
                    <td style="font-weight: bold;" width="15%" align="center" bgcolor="#f9fcfd" valign="middle">Amount</td>
                </tr>';
                $query2 = "select * from itemtable_clb where user_id='".$user_id."' and is_active='1'";
                $statement2 = $connect->prepare($query2);
                $statement2->execute();
                $result2 = $statement2->fetchAll();      
        	 
                $k=1;
                $grand_tot='0';
                foreach($result2 as $row2)
                {
              
                    $item=$row2['description'];
                    $prize=$row2['prize'];
                    $quantity=$row2['quantity'];
                    $total1=$row2['total'];
                    $grand_tot=$grand_tot+$total1;
               
                    $output.=' <tr>
                    <td height="20" width="10%" align="center" valign="top">'.$k.'</td>
                    <td height="20" width="49%" align="left" valign="top">&nbsp;'.$item.'</td>
                    <td height="20" width="16%" align="center" valign="top">'.$quantity.'</td>
                    <td height="20" width="15%" align="center" valign="top">'.$prize.'</td>
                    <td height="20" width="15%" align="center" valign="top">'.$total1.'</td>
                    </tr> ';
                    $k++;
                }
                
	        $discount_reduce= ($grand_tot * ($row['discount'] / 100));
            		        
            $reduce_total= $grand_tot - $discount_reduce;  
	            
            $output.='</tbody>
            <tfoot>
    		    <tr>
    		        <th colspan="3"></th>
    		        <th style="text-align:center;"><b>Sub Total ('.$currency.')</b></th>
    		        <th style="text-align:center;"><b>'.$symbols.''.number_format($grand_tot,2).'</b></th>
    		    </tr>
    		    <tr>
		        <th colspan="3"></th>';
		        
		        if($row['discount']!='0')
		        {
		        
		            $output.='<th style="text-align:center;"><b>Discount '.$row['discount'].'%</b></th>';
		        
		        } else {
		            
		            $output.='<th style="text-align:center;"><b>Discount %</b></th>';
		        }
		        
		        $output.='<th style="text-align:center;"><b>'.number_format($discount_reduce,2).'</b></th>
		        
		     </tr>
    		    <tr>
    		        <th colspan="3"></th>
    		        <th style="text-align:center;"><b>Total ('.$currency.')</b></th>
    		        <th style="text-align:center;"><b>'.$symbols.''.number_format($reduce_total,2).'</b></th>
    		    </tr>
		    </tfoot>
        </table>
    </table>';
    
    if($refund=='1')
    {
    $output.='<br/><table align="left" style="width:100%;">
        <table cellpadding="3" style="padding-right:10px; width:100%;">
            <tbody>
                <tr>
                    <td><h3>Amount Refund Details</h3></td>
                </tr>
                <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 = "select * from invrefund_amount where user_id='".$user_id."' and user_id!='' and is_active='1'";
                $row_refund = $connect->prepare($inv_refund);
                $row_refund->execute();
                $result3 = $row_refund->fetchAll();
                foreach($result3 as $row3)
                {
                    $refund_date=date('d-m-Y',strtotime($row3['refund_date']));
                    $refund_amount=$row3['refund_amount'];
                    $refund_remarks=$row3['refund_remarks'];
                $output.='<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>';
                }
            $output.='</tbody>
        </table>
    </table>';
    }
    
    $bank_details="select * from bank_details where is_active='1'";
    $bank_datas=$connect->prepare($bank_details);
    $bank_datas->execute();
    $bank_row=$bank_datas->fetchAll();
    
    foreach($bank_row as $row_value){
        $account_name=$row_value['account_name'];
        $account_no=$row_value['account_no'];
        $bank_name=$row_value['bank_name'];
        $swift_code=$row_value['swift_code'];
        $country=$row_value['country'];
    }
    
    $output.='
    <br/>
    <table style="table-layout: fixed; width: 100%;">
        <tbody>
            <tr>
                <td>
                    <div class="col-md-5">
                        <table>
                            <tr>
                                <td></td>
                            </tr>
						    <tr>
						        <td><strong>Account Name</strong></td>
						        <td>: '.$account_name.'</td>
						    </tr>
						    <tr>
						        <td><strong>Account No</strong></td>
						        <td>: '.$account_no.'</td>
						    </tr>
						    <tr>
						        <td><strong>Bank Name</strong></td>
						        <td>: '.$bank_name.'</td>
						    </tr>
						    <tr>
						        <td><strong>Swift Code</strong></td>
						        <td>: '.$swift_code.'</td>
						    </tr>
						    <tr>
						        <td><strong>Country</strong></td>
						        <td>: '.$country.'</td>
						    </tr>
						</table>
                    </div>
                </td>
                <td>    
                    <div class="col-md-7">
						<table>';
						    if($workorder!='')
						    {
						    $output.='<tr>
						        <td><strong>Shipping Company</strong></td>
						        <td>: '.$workorder.'</td>
						    </tr>';
						    }
						    if($hs_code!='')
						    {
						    $output.='<tr>
						        <td><strong>Hs Code</strong></td>
						        <td>: '.$hs_code.'</td>
						    </tr>';
						    }
						    if($quoterefno!='')
						    {
						    $output.='<tr>
						        <td><strong>Bill Tax & Duties</strong></td>
						        <td>: '.$quoterefno.'</td>
						    </tr>';
						    }
						    if($transchg!='')
						    {
						    $output.='<tr>
						        <td><strong>Bill Transport Charges</strong></td>
						        <td>: '.$transchg.'</td>
						    </tr>';
						    }
						    if($air_way!='')
						    {
						    $output.='<tr>
						        <td><strong>Air Waybill</strong></td>
						        <td>: '.$air_way.'</td>
						    </tr>';
						    }
						    if($paypal_id!='')
						    {
						    $output.='<tr>
						        <td><strong>Paypal Id</strong></td>
						        <td>: '.$paypal_id.'</td>
						    </tr>';
	                        }
	                        if($paypal_paid_date!='')
	                        {
						    $output.='<tr>
						        <td><strong>Paypal Paid Date</strong></td>
						        <td>: '.$paypal_paid_date.'</td>
						    </tr>';
	                        }
						$output.='</table>
					</div>
                </td>
            </tr>
        </tbody>
    </table>';

}
	
	return $output;
}

$email=$_POST['use_email'];
   
    $arrway_file=$_POST['arrway_file'];

include('pdf.php');
	
	$file_name = md5(rand()) . '.pdf';
	
	$html_code = '<link rel="stylesheet" href="assets/css/bootstrap.min.css">';
	$html_code .= fetch_customer_data($connect);
	$pdf = new Pdf();
	$pdf->load_html($html_code);
	$pdf->render();
	$file = $pdf->output();
	file_put_contents($file_name, $file);
	
	require 'class/class.phpmailer.php';
	$mail = new PHPMailer;
	$mail->Host = 'www.lagpat.com';
	$mail->Port = $_SERVER['SERVER_PORT'];
	$mail->SMTPDebug  = 1;                            
	$mail->SMTPAuth = true;							
	$mail->SetFrom("anbu@lagpat.com","www.lagpat.com");
	$mail->SMTPSecure = 'ssl';							
	$mail->From = 'anbu@lagpat.com';		
	$mail->FromName = 'www.lagpat.com';		
	$mail->AddAddress($email, 'Lagpat - Invoice');	
	$mail->IsHTML(true);									
	$mail->AddAttachment($file_name); 
	$mail->Subject = 'Lagpat Invoice Report PDF';
	$mail->Body = 'Please Collect Your Invoice Report.';

if($mail->Send())						
	{
    
    	echo "<script>alert('Your Invoice has been sent successfully...');window.location= 'reportsall.php';</script>";

} else {
	     
	     echo "<script>alert('something went wrong...');window.location= 'reportsall.php';</script>";
    }
	 
	unlink($file_name);

}

${this.title}

Code Editor : invoice_email.php