Gecko [ eternalseasoning.com ]

Name	Size	Permission
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
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_edit_process.php

<?php

include('includes/config.php');
 
error_reporting(0);
session_start();

if(isset($_POST['savetodb']))
{
    
        $itemName=array();
        $quantity=array();
        $price =array();
        
        $invid=mysqli_real_escape_string($con,$_POST['invid']);
        $invno=mysqli_real_escape_string($con,$_POST['invno']);
        $invdate = date('Y-m-d',strtotime($_POST["inv_date"])); 
        
        
        //Invoice To
        $rev_name= mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['rev_name']);
        $last_name= mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['last_name']);
        
        $address1_txt= mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['add_line1']);
        $address1=nl2br($address1_txt);
        $address2_txt= mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['add_line2']);
        $address2=nl2br($address2_txt);
        
        $rev_country=mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['rev_country']);
        $rev_pin= mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['rev_pin']);
        $rev_phone= mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['rev_phone']);
        $rev_email= mysqli_real_escape_string($con,$_SESSION['add_customer'][0]['rev_email']);
        
        //Delivery Details
        $delivery_date = date('Y-m-d',strtotime($_POST["delivery_date"])); 
        $delivery_status= mysqli_real_escape_string($con,$_POST['delivery_status']);
        
        $prd_id= $_POST["prd_id"];
        $itemName= $_POST["item_name"];
        $quantity= $_POST["quantity"];
        $price= $_POST["price"];
        
        $subtotal= mysqli_real_escape_string($con,$_POST["subtotal"]);
        $amt_discount= mysqli_real_escape_string($con,$_POST["amt_discount"]);
        $shipping_amt= mysqli_real_escape_string($con,$_POST["shipping_amt"]);
        $amt_total= mysqli_real_escape_string($con,$_POST["amt_total"]);
    
        $get_invoiceinfo=mysqli_fetch_array(mysqli_query($con,"select * from orders where order_id='".$invno."' and is_active='1'"));
        
        $customer_id='';
    
        $check_customer_email=mysqli_num_rows(mysqli_query($con,"select * from customers where email_id='".$rev_email."' and is_active='1'"));
        
        if($check_customer_email > 0) {
            
            $update_customer_details=mysqli_query($con,"update `customers`  set `first_name`='".$rev_name."', `last_name`='".$last_name."', `phone`='".$rev_phone."', `address`='".$address1."', `address2`='".$address2."', 
            `postal_code`='".$rev_pin."', `country`='".$rev_country."' where email_id='".$rev_email."' and is_active='1'");
            
             $check_customer_id=mysqli_fetch_array(mysqli_query($con,"select * from customers where email_id='".$rev_email."' and is_active='1'"));
             
             $customer_id=$check_customer_id['id'];
    
        
        } else {
            
            
            $add_customer_details=mysqli_query($con,"INSERT INTO `customers` (`first_name`, `last_name`, `email_id`, `phone`, `address`, `address2`, `postal_code`, `country`,  `create_date`) 
            VALUES ('$rev_name', '$last_name', '$rev_email', '$rev_phone', '$address1', '$address2', '$rev_pin', '$rev_country', CURDATE())");
            
            $customer_id=$con->insert_id;    
        
        }   
        
        $update_order = mysqli_query($con,"update `orders` set `customer_id`='".$customer_id."', `order_date`='".$invdate."', `delivery_date`='".$delivery_date."',
        `subtotal`='".$subtotal."', `discount`='".$amt_discount."', `ship_amount`='".$shipping_amt."', `total_price`='".$amt_total."',status='".$delivery_status."' where order_id='".$invno."' and is_active='1'");
    
        for($i=0;$i<count($itemName); $i++)
         {  
            $get_num_records=mysqli_query($con,"select * from order_items where order_id='".$invno."' and is_active='1'");
            $num_rec=mysqli_num_rows($get_num_records);
          
          if($itemName[$i]!="" && $quantity[$i]!="" && $price[$i]!="")
           { 
               $resp_itemname=mysqli_real_escape_string($con,$itemName[$i]);
               $resp_quanity=mysqli_real_escape_string($con,$quantity[$i]);
               $resp_price=mysqli_real_escape_string($con,$price[$i]);
               $resp_amount=$resp_quanity * $resp_price;
                if($i<$num_rec)
                {
                    
                   $query = mysqli_query($con,"Update order_items set product_name='".$resp_itemname."', quantity='".$resp_quanity."', unit_price='".$resp_price."', product_price='".$resp_amount."' where order_id='".$invno."' and is_active='1'");

} else{
                    
                    $query = mysqli_query($con,"INSERT INTO order_items(order_id ,product_name, quantity, unit_price, product_price) VALUES ('".$invno."', '".$resp_itemname."', '".$resp_quanity."', '".$resp_price."', '".$resp_amount."'");
                }
           }
        
         }
       
 
      if($update_order==true)
      {
        
          
          echo "<script>alert('Success! Invoice Updated Successfully.');location.href='invoice_edit.php?invno=$invno';</script>";     
      
      }
      else
      {
          
       echo "<script>alert('Oops! Something went wrong.');location.href='invoice_edit.php?invno=$invno';</script>";
       
      }
}

${this.title}

Code Editor : invoice_edit_process.php