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

<?php

include('includes/config.php');
    session_start();
    
    if(isset($_GET['status']))
    {
        $id=$_GET['invno'];
        
        $status=$_GET['status'];
        
        $del=mysqli_query($con,"update orders set status='".$status."' where order_id='".$id."' and is_active='1'");
        
        if($del)
        {
            echo "<script>alert('Success! Order status updated.');location.href='reportsall.php'</script>";
        }
            
        else {
            
            echo "<script>alert('Opps! Something went wrong.');location.href='reportsall.php'</script>";
        }
    }
    
    if(isset($_POST['shipping_order']))
    {
        $order_id=$_POST['order_id'];
        
        $ship_date=date('Y-m-d',strtotime($_POST['ship_date']));
        
        $del=mysqli_query($con,"update orders set status='4',delivery_date='".$ship_date."' where order_id='".$order_id."' and is_active='1'");
        
        if($del)
        {
            echo "<script>alert('Success! Order status updated.');location.href='reportsall.php'</script>";
        }
            
        else {
            
            echo "<script>alert('Opps! Something went wrong.');location.href='reportsall.php'</script>";
        }
    }
    
     if(isset($_POST['amount_refund']))
    {

$ref_date=array();
        $ref_amount=array();
        $ref_remarks =array();
        
        $ref_date= $_POST["ref_date"];
        $ref_amount= $_POST["ref_amount"];
        $ref_remarks= $_POST["ref_remarks"];
        
        $invno=mysqli_real_escape_string($con,$_POST['cus_invno']);
        $cus_invamount=mysqli_real_escape_string($con,$_POST['cus_invamount']);
        
            for($i=0;$i<count($ref_date);$i++)
            {
                
                $invoice_details=mysqli_fetch_array(mysqli_query($con,"select * from orders where order_id='".$invno."' and is_active='1'"));
           
                $ref_date_value = date('Y-m-d',strtotime($ref_date[$i])); 
                $ref_amount_value= mysqli_real_escape_string($con,$ref_amount[$i]);
                $ref_remarks_value =mysqli_real_escape_string($con,$ref_remarks[$i]);
            
                $refund_sql=mysqli_query($con,"INSERT INTO `invrefund_amount` (`user_id`, `refund_date`, `refund_amount`, `refund_remarks`, `create_date`) 
                VALUES ('$invno', '$ref_date_value', '$ref_amount_value', '$ref_remarks_value', CURDATE())");
                
                $refund_total=$invoice_details['total'] - $ref_amount[$i];
                
                $refund_status=mysqli_query($con,"update orders set total_price='".$refund_total."', refund='1', status='5' where user_id='".$invno."' and is_active='1'");

}
            
                if($refund_sql)
                {
                    
                    echo "<script>alert('Invoice Refund Amount Added Successfully..!!');location.href='reportsall.php'</script>";
               
                } else {
                  
                    echo "<script>alert('Oops! Something went Wrong.');location.href='reportsall.php'</script>";
                }
       
    }
?>
<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8">
		<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0">
		<title>Eternal Seasoning - Invoice Report</title>
		
		
		
		
		
		<link rel="stylesheet" href="assets/css/bootstrap.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/fontawesome.min.css">
		<link rel="stylesheet" href="assets/plugins/fontawesome/css/all.min.css">
		
		
		<link rel="stylesheet" href="assets/plugins/select2/css/select2.min.css">
		
		
		<link rel="stylesheet" href="assets/css/bootstrap-datetimepicker.min.css">
		
		
		<link rel="stylesheet" href="assets/css/style.css">
		
		
	</head>
	<body >
	
		
		<div class="main-wrapper">
		
			
			    <?php include('includes/header.php'); ?>
			
			
			
			<?php 
            if(isset($_GET['invno']))
            {
            ?>
			<div class="page-wrapper">
				<div class="content container-fluid">
				    <?php 
                        $id=$_GET['invno'];
                        $sql=mysqli_query($con,"select * from orders where order_id='".$id."' and is_active='1'");
                        $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'"));
						
						if(isset($row['delivery_company'])) {
							$delivery_compnay=mysqli_fetch_array(mysqli_query($con,"select * from delivery_company where id='".$row['delivery_company']."' and is_active='1'"));
						}
                        
                    ?>
					<div class="row">
						<div class="col-xl-12">
							<div class="card">
								<div class="card-body">
									<div class="invoice-item">
										<div class="row">
											<div class="col-md-8">
												<div class="invoice-logo">
													<img src="images/logo.png" alt="logo">
												</div>
											</div>
											<div class="col-md-4">
												<table align="">
												    <tr>
												        <td><strong>Invoice ID</strong></td>
												        <td>:</td>
												        <td>&nbsp;<?php echo $row['order_id'];?></td>
												    </tr>
												    <tr>
												        <td><strong>Invoice Date</strong></td>
												        <td>:</td>
												        <td>&nbsp;<?php echo date('d-m-Y',strtotime($row['order_date']));?></td>
												    </tr>
												</table>
											</div>
										</div>
									</div>
									<br>
									<div class="invoice-item">
									    <div class="row">
									        <div class="col-md-4">
												<div class="invoice-info">
												    <?php 
    											        $sender_details=mysqli_query($con,"select * from sender_details where id='1' and is_active='1'");
    											        $row_sender=mysqli_fetch_array($sender_details);
											        ?>
												    <strong class="customer-text"><u>Sold By</u></strong>
													<p><?php echo $row_sender['name'];?></p>
													<p><?php echo $row_sender['address'];?></p>
													<p><?php echo $row_sender['address2'];?></p>
													<p><?php echo $row_sender['address3'];?></p>
													<p><?php echo $row_sender['pincode'];?></p>
													<p><?php echo $row_sender['country'];?></p>
													<p><?php echo $row_sender['email'];?></p>
													<p><?php echo $row_sender['phone'];?></p>
												</div>
											</div>
											<div class="col-md-4">
												<div class="invoice-info">
													<strong class="customer-text"><u>Shipping To</u></strong>
													<p><?php echo $customers_row['first_name'].' '.$customers_row['last_name'];?></p>
													<p><?php echo $customers_row['address'];?></p>
													<p><?php echo $customers_row['address2'];?></p>
													<p><?php echo $customers_row['postal_code'];?></p>
													<p><?php echo $customers_row['country'];?></p>
													<p><?php echo $customers_row['email_id'];?></p>
													<p><?php echo $customers_row['phone'];?></p>
												</div>
											</div>
											
											<div class="col-md-4">
												<div class="invoice-info">
													<strong class="customer-text"><u>Delivery Details</u></strong>
													<p><b>Delivery Date</b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;<?php echo date('d-m-Y',strtotime($row['delivery_date']));?></p>
												    <p><b>Status</b> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;<?php echo $delivery_status_row['sts_option'];?></p><br>
											        <p style="color:#999;font-size: 14px;">( <?php echo $delivery_status_row['sts_desc'];?> )</p>    
												</div>
											</div>
											
									    </div>
									</div>
									
									
									<div class="invoice-item invoice-table-wrap">
										<div class="row">
											<div class="col-md-12">
												<div class="table-responsive">
													<table class="invoice-table table table-bordered" style="width:100%;">
														<thead>
															<tr>
															    <th style="width:10%;">S.No</th>
																<th style="width:55%;">Item Name</th>
																<th style="width:10%;">Quantity</th>
																<th style="width:10%;">Price</th>
																<th style="width:15%;">Amount</th>
															</tr>
														</thead>
														<tbody>
														    <?php 
                                                                $sql2=mysqli_query($con,"select * from order_items where order_id='".$id."' and is_active='1'");
                                                                $i=1;
                                                                $grand_tot='0';
                                                                while($row2=mysqli_fetch_array($sql2))
                                                                {
                                                                $item=$row2['product_name'];
                                                                $quantity=$row2['quantity'];
                                                                $prize=$row2['unit_price'];
                                                                $total1=$row2['product_price'];
                                                                $grand_tot=$grand_tot+$total1;
                                                            ?>
															<tr>
															    <td style="width:10%;"><?php echo $i; ?></td>
																<td style="width:55%;"><?php echo $item; ?></td>
																<td style="width:10%;"><?php echo $quantity; ?></td>
																<td style="width:10%;">£<?php echo number_format($prize,2); ?></td>
																<td style="width:15%;">£<?php echo number_format($total1,2); ?></td>
															</tr>
															<?php $i=$i+1;  } ?>
														</tbody>
														<tfoot>
														    <tr>
														        <th colspan="3"></th>
														        <th>Sub Total (GBP)</th>
														        <th>£<?php echo number_format($grand_tot,2); ?></th>
														    </tr>
														     <tr>
														        <th colspan="3"></th>
														        <th>Discount</th>
														        <th>£<?php echo number_format($row['discount'],2); ?></th>
														    </tr>
														     <tr>
														        <th colspan="3"></th>
														        <th>Vat (20%)</th>
														        <th>£<?php echo number_format($row['vat_amt'],2); ?></th>
														    </tr>
														    
														    <tr>
														        <th colspan="3"></th>
														        <th>Total (GBP)</th>
														        <th>£<?php echo number_format($row['total_price'],2); ?></th>
														    </tr>
														</tfoot>
													</table>
												</div>
											</div>
										</div>
									</div>
									
									<br/>
									
									<br/>
									<?php if( isset($row['refund']) && $row['refund']=='1') { ?>
									
    									<div class="col-lg-8">
    									    <div class="card">
        										<div class="card-header">
        											<h5 class="card-title">Amount Refund Details</h5>
        										</div>
        										<div class="card-body">
        											<ul class="activity-feed">
        											    <?php 
                                                            $inv_refund=mysqli_query($con,"select * from invrefund_amount where user_id='".$id."' and user_id!='' and is_active='1'");
                                                            while($row_refund=mysqli_fetch_array($inv_refund))
                                                            {
                                                        ?> 
        												<li class="feed-item">
        													<div class="feed-date"><?php echo date('d-m-Y',strtotime($row_refund['refund_date'])); ?></div>
        													<span class="feed-text">$<?php echo $row_refund['refund_amount']; ?></span><br/>
        													<span class="feed-text"><?php echo $row_refund['refund_remarks']; ?></span>
        												</li>
        												<?php
                                                            }
                                                        ?>
        											</ul>
        										</div>
    									    </div>
    								    </div>
								    
								    <?php } ?>
								    
								    <br>
									
									<div class="invoice-item">
										<div class="row">
										     <div class="col-lg-12">
									            <a class="btn btn-sm btn-info mr-2" href="invoice_viewpdf.php?invno=<?php echo $row['order_id']?>" target="_blank">
												<i class="fas fa-print mr-1"></i> Print PDF
											    </a>  
										    </div>
										</div>
									</div>
								</div>
							</div>
						</div>
					</div>
				</div>
			</div>
			
		    <?php }?>
		</div>
		
		
		<div class="modal fade bd-example-modal-lg" id="amountrefund" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
            <div class="modal-dialog modal-lg" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Amount Refund</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                          <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <form method="post" >
                        <div class="modal-body" id="view_refund_modal"></div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                            <button type="submit" name="amount_refund" class="btn btn-primary">Save</button>
                        </div>
                  </form>    
                </div>
            </div>
        </div>
        
        
        <div class="modal fade bd-example-modal-lg" id="order_shipment" tabindex="-1" role="dialog" aria-labelledby="myLargeModalLabel" aria-hidden="true">
            <div class="modal-dialog modal-lg" role="document">
                <div class="modal-content">
                    <div class="modal-header">
                        <h5 class="modal-title" id="exampleModalLabel">Ship Order</h5>
                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                          <span aria-hidden="true">&times;</span>
                        </button>
                    </div>
                    <form method="post" >
                        <div class="modal-body">
                        
                        <div class="row">
                            <div class="col-md-6">
                                <label>Order ID</label>
                                <div class="form-group">
                                    <input type="text" class="form-control" name="order_id" value="<?php echo $row['order_id']; ?>" readonly>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <label>Date of Shipping</label>
                                <div class="form-group">
                                    <input type="date" class="form-control" name="ship_date" id="ship_date" required>
                                </div>
                            </div>
                        </div>    
                            
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                            <button type="submit" name="shipping_order" class="btn btn-primary">Update</button>
                        </div>
                  </form>    
                </div>
            </div>
        </div>
		
		
		<script src="assets/js/jquery-3.5.1.min.js"></script>
		
		
		<script src="assets/js/popper.min.js"></script>
		<script src="assets/js/bootstrap.min.js"></script>
		
		
		<script src="assets/js/feather.min.js"></script>
		
		
		<script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script>
		
		
		<script src="assets/plugins/select2/js/select2.min.js"></script>

<script src="assets/plugins/moment/moment.min.js"></script>
		<script src="assets/js/bootstrap-datetimepicker.min.js"></script>
		
		
		<script src="assets/js/script.js"></script>
		
		<script>
		
            $(document).ready(function() {
                
              $(".delete").hide();
              
            }); 
            
          	$(document).on("click",".add",function() {	   
                  
                $(".delete").fadeIn("1500");
                //Append a new row of code to the "#items" div
                $("#items").append(
                  '<div class="next-referral"><div class="row"><div class="col-md-4"><div class="form-group"><label>Refund Date <i class="fa fa-star" style="color: red;font-size: 5px"; ></i></label><input name="ref_date[]" id="ref_date" type="date" class="form-control datetimepicker"></div></div><div class="col-md-4"><div class="form-group"><label>Refund Amount <i class="fa fa-star" style="color: red;font-size: 5px"; ></i></label><input name="ref_amount[]" id="ref_amount" type="text" class="form-control"></div></div><div class="col-md-4"><div class="form-group"><label>Remarks <i class="fa fa-star" style="color: red;font-size: 5px"; ></i></label><textarea rows="2" cols="2" class="form-control" name="ref_remarks[]" id="ref_remarks" placeholder="Enter Remarks" required></textarea></div></div></div></div>'
                );

});
          	
          	$(document).on("click",".delete",function() {	
          	    
          	      $(".next-referral").last().remove();
          	    
          	});
            
            function select_refund_modal(val)
        	{
        	   
        	    if(val!=''){
        	       
        	       $.ajax({  
                	    
                    url:"refund_modal.php",  
                    method:"POST",  
                    data:{ refund_id:val },  
                    success:function(data)  
                    { 
                        
                        $('#view_refund_modal').html(data);
                        
                        $('#amountrefund').modal('show');
                      
                    }  
                }); 
        	       
        	   } else {
        	       
        	       $('#view_refund_modal').html('');
        	       
        	   } 
        	   
        	    
        	}
            
		</script>

</body>
</html>

${this.title}

Code Editor : sales_invoice.php