<?php
/**
 * WP eCommerce AJAX and Init functions
 *
 * These are the WPSC AJAX and Init functions
 *
 * @package wp-e-commerce
 * @since 3.7
 */
 
 function wpsc_special_widget(){
 	global $wpdb; 

 	wpsc_add_to_cart();
 	//exit();
 }
if($_REQUEST['wpsc_ajax_action'] == 'special_widget' || $_REQUEST['wpsc_ajax_action'] == 'donations_widget') {
	add_action('init', 'wpsc_special_widget');
}


// function wpsc_api_key_finder(){
//  	global $wpdb; 
//  	$transactid = $wpdb->escape($_POST['wpsc_transaction_id']);
//  	$sql = 'SELECT `id` FROM `'.WPSC_TABLE_PURCHASE_LOGS.'` WHERE `transactid`='.$transactid;
//  	$id = $wpdb->get_var($sql);
//  	$sql = 'SELECT `name`, `key`, `first_name` FROM `'.$wpdb->prefix.'api_keys` WHERE `purchase_id`='.$id;
//  	$api_info = $wpdb->get_results($sql);
//  	$_SESSION['api_info'] = $api_info;
// 	//exit('ID<pre>'.print_r($id, true).'</pre>');
//  	exit();
// }
// 
// if($_REQUEST['wpsc_ajax_action'] == 'api_key_finder') {
// 	add_action('init', 'wpsc_api_key_finder');
// }

/**
	* add_to_cart function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_add_to_cart() {
  global $wpdb, $wpsc_cart, $wpsc_theme_path;
  /// default values
	$default_parameters['variation_values'] = null;
	$default_parameters['quantity'] = 1;
	$default_parameters['provided_price'] = null;
	$default_parameters['comment'] =null;
	$default_parameters['time_requested']= null;
	$default_parameters['custom_message'] = null;
	$default_parameters['file_data'] = null;
	$default_parameters['is_customisable'] = false;
	$default_parameters['meta'] = null;
  
  
  /// sanitise submitted values
  $product_id = (int)$_POST['product_id'];
  foreach((array)$_POST['variation'] as $key => $variation) {
    $provided_parameters['variation_values'][(int)$key] = (int)$variation;
  }
  if($_POST['quantity'] > 0 && (!isset($_POST['wpsc_quantity_update']))) {
		$provided_parameters['quantity'] = (int)$_POST['quantity'];
  } else if (isset($_POST['wpsc_quantity_update'])) {
		$wpsc_cart->remove_item($_POST['key']);
		$provided_parameters['quantity'] = (int)$_POST['wpsc_quantity_update'];
  }
//  exit('<pre>'.print_r($_POST, true).'</pre>');
  if($_POST['is_customisable'] == 'true') {
		$provided_parameters['is_customisable'] = true;
		
		if(isset($_POST['custom_text'])) {
			$provided_parameters['custom_message'] = $_POST['custom_text'];
		}
		if(isset($_FILES['custom_file'])) {
			$provided_parameters['file_data'] = $_FILES['custom_file'];
		}
	}
	if(((float)$_POST['donation_price'] > 0)) {
		$provided_parameters['provided_price'] = (float)$_POST['donation_price'];
	}
 
  $parameters = array_merge($default_parameters, (array)$provided_parameters);
  //echo "/*\n\r".print_r($parameters,true)."*/\n\r";
	$state = $wpsc_cart->set_item($product_id,$parameters); 
	
	$product = $wpdb->get_row("SELECT * FROM `".WPSC_TABLE_PRODUCT_LIST."` WHERE `id`='".$product_id."' LIMIT 1",ARRAY_A);
   
  if($state == true) {
		$cart_messages[] = str_replace("[product_name]", stripslashes($product['name']), TXT_WPSC_YOU_JUST_ADDED);
	} else {
	  if($parameters['quantity'] <= 0) {
	    $cart_messages[] = TXT_WPSC_ZERO_QUANTITY_REQUESTED;
	  } else if($wpsc_cart->get_remaining_quantity($product_id,$parameters['variation_values'], $parameters['quantity']) > 0) {
			$cart_messages[] = str_replace("[number]", $wpsc_cart->get_remaining_quantity($product_id,$parameters['variation_values'], $parameters['quantity']), TXT_WPSC_INSUFFICIENT_REMAINING);
	  } else {
	    $cart_messages[] = str_replace("[product_name]", $product['name'], TXT_WPSC_SORRY_NONE_LEFT);
	  }
	}
	
  if($_GET['ajax'] == 'true') {
		if(($product_id != null) &&(get_option('fancy_notifications') == 1)) {
			echo "if(jQuery('#fancy_notification_content')) {\n\r";
			echo "  jQuery('#fancy_notification_content').html(\"".str_replace(array("\n","\r") , array('\n','\r'), addslashes(fancy_notification_content($cart_messages))). "\");\n\r";
			echo "  jQuery('#loading_animation').css('display', 'none');\n\r";
			echo "  jQuery('#fancy_notification_content').css('display', 'block');\n\r";
			echo "}\n\r";
			$error_messages = array();
		}
		ob_start();
		$cur_wpsc_theme_folder = apply_filters('wpsc_theme_folder',$wpsc_theme_path.WPSC_THEME_DIR);
		include_once($cur_wpsc_theme_folder."/cart_widget.php");
	  $output = ob_get_contents();
		ob_end_clean();
		//exit("/*<pre>".print_r($wpsc_cart,true)."</pre>*/");
		$output = str_replace(Array("\n","\r") , Array("\\n","\\r"),addslashes($output));
		//echo '<pre>'.print_r($parameters,true).'</pre>';
    echo "jQuery('div.shopping-cart-wrapper').html('$output');\n";
		//  echo "jQuery('#wpsc_quantity_update').val('".$provided_parameters['quantity']."');\n";

    
		if(get_option('show_sliding_cart') == 1)	{
			if((wpsc_cart_item_count() > 0) || (count($cart_messages) > 0)) {
				$_SESSION['slider_state'] = 1;
				echo "
					jQuery('#sliding_cart').slideDown('fast',function(){
						jQuery('#fancy_collapser').attr('src', (WPSC_URL+'/images/minus.png'));
					});
			";
			} else {
				$_SESSION['slider_state'] = 0;
				echo "
					jQuery('#sliding_cart').slideUp('fast',function(){
						jQuery('#fancy_collapser').attr('src', (WPSC_URL+'/images/plus.png'));
					});
			";
			}
		}

		do_action('wpsc_alternate_cart_html', $cart_messages);
		exit();
  }
}

// execute on POST and GET
if($_REQUEST['wpsc_ajax_action'] == 'add_to_cart') {
	add_action('init', 'wpsc_add_to_cart');
}


function wpsc_get_cart() {
  global $wpdb, $wpsc_cart, $wpsc_theme_path;
	ob_start();
	$cur_wpsc_theme_folder = apply_filters('wpsc_theme_folder',$wpsc_theme_path.WPSC_THEME_DIR);
	include_once($cur_wpsc_theme_folder."/cart_widget.php");
	$output = ob_get_contents();
	ob_end_clean();
	$output = str_replace(Array("\n","\r") , Array("\\n","\\r"),addslashes($output));
	echo "jQuery('div.shopping-cart-wrapper').html('$output');\n";

	
	if(get_option('show_sliding_cart') == 1)	{
		if((wpsc_cart_item_count() > 0) || (count($cart_messages) > 0)) {
			$_SESSION['slider_state'] = 1;
			echo "
				jQuery('#sliding_cart').slideDown('fast',function(){
					jQuery('#fancy_collapser').attr('src', (WPSC_URL+'/images/minus.png'));
				});
		";

		} else {
			$_SESSION['slider_state'] = 0;
			echo "
				jQuery('#sliding_cart').slideUp('fast',function(){
					jQuery('#fancy_collapser').attr('src', (WPSC_URL+'/images/plus.png'));
				});
		";
		}
	}

	
	do_action('wpsc_alternate_cart_html', '');
	exit();
}

if($_REQUEST['wpsc_ajax_action'] == 'get_cart') {
	add_action('init', 'wpsc_get_cart');
}

function wpsc_cart_html_page() {
	require_once(WPSC_FILE_PATH."/wpsc-includes/shopping_cart_container.php");
	exit();
}

// execute on POST and GET
if($_REQUEST['wpsc_action'] == 'cart_html_page') {
	add_action('init', 'wpsc_cart_html_page', 10000);
}

/**
	* empty cart function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_empty_cart() {
  global $wpdb, $wpsc_cart, $wpsc_theme_path;
  $wpsc_cart->empty_cart(false);
  
  if($_REQUEST['ajax'] == 'true') {
		ob_start();
		$cur_wpsc_theme_folder = apply_filters('wpsc_theme_folder',$wpsc_theme_path.WPSC_THEME_DIR);
		include_once($cur_wpsc_theme_folder."/cart_widget.php");

		$output = ob_get_contents();
		ob_end_clean();
		$output = str_replace(Array("\n","\r") , Array("\\n","\\r"),addslashes($output));
    echo "jQuery('div.shopping-cart-wrapper').html('$output');";
		do_action('wpsc_alternate_cart_html');
		
		if(get_option('show_sliding_cart') == 1)	{
			$_SESSION['slider_state'] = 0;
			echo "
				jQuery('#sliding_cart').slideUp('fast',function(){
					jQuery('#fancy_collapser').attr('src', (WPSC_URL+'/images/plus.png'));
				});
		";
		}
		exit();
  }

  // this if statement is needed, as this function also runs on returning from the gateway
  if($_REQUEST['wpsc_ajax_action'] == 'empty_cart') { 
		wp_redirect(remove_query_arg(array('wpsc_ajax_action','ajax')));
		exit();
	}
}


// execute on POST and GET
if(($_REQUEST['wpsc_ajax_action'] == 'empty_cart') || ($_GET['sessionid'] > 0)) {
	add_action('init', 'wpsc_empty_cart');
}


/**
	* coupons price, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_coupon_price($currCoupon = '') {
  global $wpdb, $wpsc_cart, $wpsc_coupons;
  if(isset($_POST['coupon_num']) && $_POST['coupon_num'] != ''){
  	  $coupon = $wpdb->escape($_POST['coupon_num']);
	  $_SESSION['coupon_numbers'] = $coupon;
	  $wpsc_coupons = new wpsc_coupons($coupon);
	  
	  if ($wpsc_coupons->validate_coupon()){
	  	$discountAmount = $wpsc_coupons->calculate_discount();
	  	$wpsc_cart->apply_coupons($discountAmount, $coupon);
	  	$wpsc_coupons->errormsg = false;
	  } else {
	  	$wpsc_coupons->errormsg = true;
	  	$wpsc_cart->coupons_amount = 0;
	  	$wpsc_cart->coupons_name = '';
	  }

  } else if ($_POST['coupon_num'] == '' && $currCoupon == ''){
   		$wpsc_cart->coupons_amount = 0;
  		$wpsc_cart->coupons_name = '';
  } else if ($currCoupon != '') {
  	  $coupon = $wpdb->escape($currCoupon);
	  $_SESSION['coupon_numbers'] = $coupon;
	  $wpsc_coupons = new wpsc_coupons($coupon);
	  
	  if($wpsc_coupons->validate_coupon()){
		 
	  	$discountAmount = $wpsc_coupons->calculate_discount();
	  	$wpsc_cart->apply_coupons($discountAmount, $coupon);
	  	$wpsc_coupons->errormsg = false;
	  }	
  }
  
	
 }
// execute on POST and GET
if(isset($_POST['coupon_num'])) {
	add_action('init', 'wpsc_coupon_price');
}


/**
	* update quantity function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_update_item_quantity() {
  global $wpdb, $wpsc_cart, $wpsc_theme_path;
 
  if(is_numeric($_POST['key'])) {
    $key = (int)$_POST['key'];
		if($_POST['quantity'] > 0) {
		  // if the quantity is greater than 0, update the item;
		  $parameters['quantity'] = (int)$_POST['quantity'];
			$wpsc_cart->edit_item($key, $parameters);
		} else {
		  // if the quantity is 0, remove the item.
			$wpsc_cart->remove_item($key);
		}
		wpsc_coupon_price($_SESSION['coupon_numbers']);
  }
  
 if($_REQUEST['ajax'] == 'true') {
	ob_start();
	$cur_wpsc_theme_folder = apply_filters('wpsc_theme_folder',$wpsc_theme_path.WPSC_THEME_DIR);
	include_once($cur_wpsc_theme_folder."/cart_widget.php");
	$output = ob_get_contents();
	ob_end_clean();
	$output = str_replace(Array("\n","\r") , Array("\\n","\\r"),addslashes($output));
		
	echo "jQuery('div.shopping-cart-wrapper').html('$output');\n";
	do_action('wpsc_alternate_cart_html');
	
	
	exit();
 }
	
}
  
// execute on POST and GET
if($_REQUEST['wpsc_update_quantity'] == 'true') {
	add_action('init', 'wpsc_update_item_quantity');
}


/**
	* update_shipping_price function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_update_shipping_price() {
  global $wpdb, $wpsc_cart;
 	$quote_shipping_method = $_POST['key1'];
 	$quote_shipping_option = $_POST['key'];
	$wpsc_cart->update_shipping($quote_shipping_method, $quote_shipping_option);
	echo "jQuery('.pricedisplay.checkout-shipping').html('".wpsc_cart_shipping()."');\n\r";
	echo "jQuery('.pricedisplay.checkout-total').html('".wpsc_cart_total()."');\n\r";
	exit();
}
// execute on POST and GET
if($_REQUEST['wpsc_ajax_action'] == 'update_shipping_price') {
	add_action('init', 'wpsc_update_shipping_price');
}


/**
	* update_shipping_price function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_get_rating_count() {
  global $wpdb, $wpsc_cart;
  $prodid = $_POST['product_id'];
	$data = $wpdb->get_results("SELECT COUNT(*) AS `count` FROM `".WPSC_TABLE_PRODUCT_RATING."` WHERE `productid` = '".$prodid."'",ARRAY_A) ;
	echo $data[0]['count'].",".$prodid;
	exit();
}
// execute on POST and GET
if(($_REQUEST['get_rating_count'] == 'true') && is_numeric($_POST['product_id'])) {
	add_action('init', 'wpsc_get_rating_count');
}


/**
	* update_product_page_price function, used through ajax with variations
	* No parameters, returns nothing
*/
function wpsc_update_product_price() {
  global $wpdb, $wpsc_cart;
	foreach((array)$_POST['variation'] as $variation) {
		if(is_numeric($variation)) {
			$variations[] = (int)$variation;
		}
	}
	$pm=$_POST['pm'];
	echo "product_id=".(int)$_POST['product_id'].";\n";
	
	echo "price=\"".nzshpcrt_currency_display(calculate_product_price((int)$_POST['product_id'], $variations,'stay',$extras), $notax, true)."\";\n";
	echo "numeric_price=\"".number_format(calculate_product_price((int)$_POST['product_id'], $variations,'stay',$extras), 2)."\";\n";
	exit();
}
// execute on POST and GET
if(($_REQUEST['update_product_price'] == 'true') && is_numeric($_POST['product_id'])) {
	add_action('init', 'wpsc_update_product_price');
}


/**
	* update location function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_update_location() {
  global $wpdb, $wpsc_cart;
	if($_POST['country'] != null) {
		$_SESSION['wpsc_delivery_country'] = $_POST['country'];
		if($_SESSION['wpsc_selected_country'] == null) {
			$_SESSION['wpsc_selected_country'] = $_POST['country'];
		}
		if($_POST['region'] != null) {
			$_SESSION['wpsc_delivery_region'] = $_POST['region'];
			if($_SESSION['wpsc_selected_region'] == null) {
				$_SESSION['wpsc_selected_region'] = $_POST['region'];
			}
		} else if($_SESSION['wpsc_selected_region'] == '') {
			$_SESSION['wpsc_delivery_region'] = get_option('base_region');
			$_SESSION['wpsc_selected_region'] = get_option('base_region');
		}
		
		
		if($_SESSION['wpsc_delivery_region'] == '') {
			$_SESSION['wpsc_delivery_region'] = $_SESSION['wpsc_selected_region'];
		}
	}
	
	if($_POST['zipcode'] != '') {
		$_SESSION['wpsc_zipcode'] = $_POST['zipcode'];
	}

	$delivery_region_count = $wpdb->get_var("SELECT COUNT(`regions`.`id`) FROM `".WPSC_TABLE_REGION_TAX."` AS `regions` INNER JOIN `".WPSC_TABLE_CURRENCY_LIST."` AS `country` ON `country`.`id` = `regions`.`country_id` WHERE `country`.`isocode` IN('".$wpdb->escape($_SESSION['wpsc_delivery_country'])."')");
	if($delivery_region_count < 1) {
		$_SESSION['wpsc_delivery_region'] = null;
	}
	
	$selected_region_count = $wpdb->get_var("SELECT COUNT(`regions`.`id`) FROM `".WPSC_TABLE_REGION_TAX."` AS `regions` INNER JOIN `".WPSC_TABLE_CURRENCY_LIST."` AS `country` ON `country`.`id` = `regions`.`country_id` WHERE `country`.`isocode` IN('".$wpdb->escape($_SESSION['wpsc_selected_country'])."')");
	if($selected_region_count < 1) {
		$_SESSION['wpsc_selected_region'] = null;
	}
	
	$wpsc_cart->update_location();
	$wpsc_cart->get_shipping_method();
	$wpsc_cart->get_shipping_option();
	
	
	if($_GET['ajax'] == 'true') {
		exit();
	}
}
  
// execute on POST and GET
if($_REQUEST['wpsc_ajax_actions'] == 'update_location') {
	add_action('init', 'wpsc_update_location');
}


/**
	* submit checkout function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_submit_checkout() {
  global $wpdb, $wpsc_cart, $user_ID,$nzshpcrt_gateways, $wpsc_shipping_modules, $user_email;
	$_SESSION['wpsc_checkout_misc_error_messages'] = array();
	$wpsc_checkout = new wpsc_checkout();
	//exit('coupons:'.$wpsc_cart->coupons_name);
	$selected_gateways = get_option('custom_gateway_options');
	$submitted_gateway = $_POST['custom_gateway'];
	
	
	//tlu rida
	$sum=$_POST['sum'];

	
	$options = get_option('custom_shipping_options');
	$form_validity = $wpsc_checkout->validate_forms();
	
	//exit('<pre>'.print_r($_POST, true).'</pre>');

	//	exit('2<pre>'.print_r($_SESSION['wpsc_zipcode'], true).'</pre>');
	extract($form_validity); // extracts $is_valid and $error_messages
 	//	exit('<pre>'.print_r($results, true).'</pre>');
	if (get_option('do_not_use_shipping') == 0 && ($wpsc_cart->selected_shipping_method == null || $wpsc_cart->selected_shipping_option == null)) {
		$_SESSION['wpsc_checkout_misc_error_messages'][] = TXT_WPSC_PLEASEASELECTSHIPPINGMETHOD;
		$is_valid = false;
   	}
		
	if($_POST['agree'] != 'yes') {
		$_SESSION['wpsc_checkout_misc_error_messages'][] = TXT_WPSC_PLEASEAGREETERMSANDCONDITIONS;
		$is_valid = false;		
	}
	

   //exit('<pre>'.print_r($_POST, true).'</pre>');
	
	$selectedCountry = $wpdb->get_results("SELECT id, country FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE isocode='".$wpdb->escape($_SESSION['wpsc_delivery_country'])."'", ARRAY_A);

//  exit('valid >'.$is_valid.'\r\n'.$_SESSION['wpsc_delivery_country']);

	foreach($wpsc_cart->cart_items as $cartitem){
		//	exit('<pre>'.print_r($cartitem, true).'</pre>');
		$categoriesIDs = $wpdb->get_col("SELECT category_id FROM `".WPSC_TABLE_ITEM_CATEGORY_ASSOC."` WHERE product_id=".$cartitem->product_id);
		
		foreach((array)$categoriesIDs as $catid){
			if(is_array($catid)){
				$sql ="SELECT `countryid` FROM `".WPSC_TABLE_CATEGORY_TM."` WHERE `visible`=0 AND `categoryid`=".$catid[0];
			}else{
				$sql ="SELECT `countryid` FROM `".WPSC_TABLE_CATEGORY_TM."` WHERE `visible`=0 AND `categoryid`=".$catid;
			}
			$countries = $wpdb->get_col($sql);
			if(in_array($selectedCountry[0]['id'], (array)$countries)){
				$errormessage =sprintf(TXT_WPSC_CATEGORY_TARGETMARKET, $cartitem->product_name, $selectedCountry[0]['country']);
				$_SESSION['categoryAndShippingCountryConflict']= $errormessage;
				$is_valid = false;
			}
		}
		//count number of items, and number of items using shipping
		$num_items ++;
		if($cartitem->uses_shipping != 1){
				$disregard_shipping ++;
		}else{
				$use_shipping ++;
		}
	}
  
 // exit('valid >'.$is_valid);
  if(array_search($submitted_gateway,$selected_gateways) !== false) {
		$_SESSION['wpsc_previous_selected_gateway'] = $submitted_gateway;
  } else {
		$is_valid = false;
  }
  	if((get_option('do_not_use_shipping') != 1) && (in_array('ups', (array)$options)) && $_SESSION['wpsc_zipcode'] == '')	{
		//exit('Not being called');
		if($num_items != $disregard_shipping){  //<-- new line of code
			$_SESSION['categoryAndShippingCountryConflict'] = __('Please enter a Zipcode and click calculate to proceed');
			$is_valid = false;		
		}
	}
	if($is_valid == true || $_GET['gateway'] == 'noca') {
		$_SESSION['categoryAndShippingCountryConflict']= '';
		// check that the submitted gateway is in the list of selected ones
		$sessionid = (mt_rand(100,999).time());
		$_SESSION['wpsc_sessionid'] = $sessionid;
		$subtotal = $wpsc_cart->calculate_subtotal();
		if($wpsc_cart->has_total_shipping_discount() == false) {
			$base_shipping= $wpsc_cart->calculate_base_shipping();
		} else {
			$base_shipping = 0;
		}
		if(isset($_POST['how_find_us'])){
			$find_us = $_POST['how_find_us'];
		}else{
			$find_us = '';
		}

		$tax = $wpsc_cart->calculate_total_tax();
		$total = $wpsc_cart->calculate_total_price();
		
		
		/*tlu osa algus*/
		$query = mysql_query('SELECT user_id FROM '.WPSC_TABLE_HAS_ORDERED.' WHERE user_id="'.$user_ID.'" LIMIT 1') or die(mysql_error());
		$row = mysql_fetch_array($query);
		
		if($row['user_id']!=(int)$user_ID){
			/*$totalquantity=0;
			$query = mysql_query('SELECT wwpl.weight, wwcc.quantity FROM '.WPSC_TABLE_PURCHASE_LOGS.' AS wtpl INNER JOIN wp_wpsc_cart_contents AS wwcc ON wtpl.id=wwcc.purchaseid INNER JOIN wp_wpsc_product_list AS wwpl ON wwcc.prodid=wwpl.id WHERE wtpl.user_id="'.$user_ID.'"') or die(mysql_error());
			while($row = mysql_fetch_array($query)){
				$totalquantity=$totalquantity+($row['weight']*$row['quantity']);
			}*/
			$to = $user_email;
			$subject = 'Esimene ost';
			$message = 'Täname teid esimese ostu eest! Külastage ka meie Facebook rakendusi.';
			wp_mail($to, $subject, $message);
			//$sql2 = "INSERT INTO `".WPSC_TABLE_HAS_ORDERED."` (`user_id`) VALUES ('".$user_ID."')";
			$query = mysql_query('SELECT * FROM wp_wpsc_purchase_logs WHERE user_ID="'.$user_ID.'" ORDER BY date DESC LIMIT 1') or die(mysql_error());
			$row = mysql_fetch_array($query);
			$query2 = mysql_query('SELECT * FROM wp_wpsc_cart_contents WHERE purchaseid="'.$row['id'].'"') or die(mysql_error());
			while($row2 = mysql_fetch_array($query2)){
				$weighttotrim=explode('(',$row2['name']);
				if(!preg_match("/Oral/i", $weighttotrim[0])){
					$weight=substr($weighttotrim[1], 0, -4);
					$weight=str_replace(',','.',$weight);
					$weighttotal=$weighttotal+($row2['quantity']*$weight);
				}
			}
			if($weighttotal>=5){
				$total=$total-100;
			}
			if($weighttotal>=15){
				$total=$total-300;
			}
			$sql2 = "INSERT INTO `".WPSC_TABLE_HAS_ORDERED."` (`user_id`) VALUES ('".$user_ID."')";
		} else {
			$query = mysql_query('SELECT * FROM `'.WPSC_TABLE_HAS_ORDERED.'` WHERE user_ID="'.$user_ID.'" LIMIT 1') or die(mysql_error());
			$row3 = mysql_fetch_array($query);
			$bonus = $row3['money_on_account'];
			$totalsum=0;
			if($sum!=''){
				$sum=str_replace(',','.',$sum);
				if($sum<=$bonus){
					if(is_numeric($sum)){
						if($sum<=$total*0.5){
							$totalsum=$sum;
						}
					}
				}
			}
			//if($sum==''){
				$query = mysql_query('SELECT * FROM wp_wpsc_purchase_logs WHERE user_ID="'.$user_ID.'" ORDER BY date DESC LIMIT 1') or die(mysql_error());
				$row = mysql_fetch_array($query);
				$query2 = mysql_query('SELECT * FROM wp_wpsc_cart_contents WHERE purchaseid="'.$row['id'].'"') or die(mysql_error());
				while($row2 = mysql_fetch_array($query2)){
					$weighttotrim=explode('(',$row2['name']);
					if(!preg_match("/Oral/i", $weighttotrim[0])){
						$weight=substr($weighttotrim[1], 0, -4);
						$weight=str_replace(',','.',$weight);
						if($weight>=5){
							$query3 = mysql_query('SELECT * FROM wp_wpsc_product_list WHERE id="'.$row2['prodid'].'"') or die(mysql_error());
							$row3 = mysql_fetch_array($query3);
							//$bonus=$bonus+($row2['price']*$row2['quantity'])*0.05;
							if($row3['discount']!='' && $row3['discount']>0){
								$bonus=$bonus+($row2['price']*$row2['quantity'])*($row3['discount']/100);
							}
						}
					}
				}
				$total=$total-$totalsum;
				$bonus=$bonus-$totalsum;
				$sql2 = "UPDATE `".WPSC_TABLE_HAS_ORDERED."` SET `money_on_account`='".$bonus."', `last_bonus`='".$totalsum."' WHERE `user_id`='".$user_ID."'";
			/*} else {
				$total=$total-$totalsum;
				$bonus=$bonus-$totalsum;
				$sql2 = "UPDATE `".WPSC_TABLE_HAS_ORDERED."` SET `money_on_account`='".$bonus."', `last_bonus`='".$totalsum."' WHERE `user_id`='".$user_ID."'";
			}*/
		}
		$wpdb->query($sql2);
		/*tlu osa lopp*/
		
		
		$sql = "INSERT INTO `".WPSC_TABLE_PURCHASE_LOGS."` (`totalprice`,`statusno`, `sessionid`, `user_ID`, `date`, `gateway`, `billing_country`,`shipping_country`, `billing_region`, `shipping_region`, `base_shipping`,`shipping_method`, `shipping_option`, `plugin_version`, `discount_value`, `discount_data`,`find_us`) VALUES ('$total' ,'0', '{$sessionid}', '".(int)$user_ID."', UNIX_TIMESTAMP(), '{$submitted_gateway}', '{$wpsc_cart->delivery_country}', '{$wpsc_cart->selected_country}','{$wpsc_cart->selected_region}', '{$wpsc_cart->delivery_region}', '{$base_shipping}', '{$wpsc_cart->selected_shipping_method}', '{$wpsc_cart->selected_shipping_option}', '".WPSC_VERSION."', '{$wpsc_cart->coupons_amount}','{$wpsc_cart->coupons_name}', '{$find_us}')";
		
		//exit($sql);
		$wpdb->query($sql);
		
		$purchase_log_id = $wpdb->get_var("SELECT `id` FROM `".WPSC_TABLE_PURCHASE_LOGS."` WHERE `sessionid` IN('{$sessionid}') LIMIT 1") ;
		//exit('PurchLog id'.$purchase_log_id);
		$wpsc_checkout->save_forms_to_db($purchase_log_id);
		$wpsc_cart->save_to_db($purchase_log_id);
		$wpsc_cart->submit_stock_claims($purchase_log_id);

		if(get_option('wpsc_also_bought') == 1) {
			wpsc_populate_also_bought_list();
		}
		
		do_action('wpsc_submit_checkout', array("purchase_log_id" => $purchase_log_id, "our_user_id" => $our_user_id));
	
		if(get_option('permalink_structure') != '') {
			$seperator = "?";
		} else {
			$seperator = "&";
		}
		 		
		// submit to gateway
		foreach($nzshpcrt_gateways as $gateway) {
			if($gateway['internalname'] == $submitted_gateway && $gateway['internalname'] != 'google') {

				$gateway_used = $gateway['internalname'];
				$wpdb->query("UPDATE `".WPSC_TABLE_PURCHASE_LOGS."` SET `gateway` = '".$gateway_used."' WHERE `id` = '".$log_id."' LIMIT 1 ;");
				$gateway['function']($seperator, $sessionid);
				break;
			}elseif($gateway['internalname'] == 'google' && $gateway['internalname'] == $submitted_gateway){
				$gateway_used = $gateway['internalname'];
				$wpdb->query("UPDATE `".WPSC_TABLE_PURCHASE_LOGS."` SET `gateway` = '".$gateway_used."' WHERE `id` = '".$log_id."' LIMIT 1 ;");
				$_SESSION['gateway'] = 'google';
				header('Location: '.get_option('shopping_cart_url'));
				break;
			}
		}

		if(isset($_GET['gateway']) && $_GET['gateway'] == 'noca'){
			//exit('HERE2');
			echo transaction_results($sessionid, true);
		}else{
			//exit('HERE');
		}
} else {
	
	}
}

// execute on POST and GET
if($_REQUEST['wpsc_action'] == 'submit_checkout') {
	add_action('init', 'wpsc_submit_checkout');
}


/**
	* wpsc_change_tax function, used through ajax and in normal page loading.
	* No parameters, returns nothing
*/
function wpsc_change_tax() {
  global $wpdb, $wpsc_cart, $wpsc_theme_path;
  $form_id = absint($_POST['form_id']);
	//exit('Shipping<pre>'.print_r($_SESSION,true).'</pre>');
  $previous_country = $_SESSION['wpsc_selected_country'];
	if(isset($_POST['billing_country'])){ 
	$_SESSION['wpsc_selected_country'] =$_POST['billing_country'];
	}
	if(isset($_POST['billing_region'])){	
	$_SESSION['wpsc_selected_region'] = absint($_POST['billing_region']);
	}

	$check_country_code = $wpdb->get_var(" SELECT `country`.`isocode` FROM `".WPSC_TABLE_REGION_TAX."` AS `region` INNER JOIN `".WPSC_TABLE_CURRENCY_LIST."` AS `country` ON `region`.`country_id` = `country`.`id` WHERE `region`.`id` = '".$_SESSION['wpsc_selected_region']."' LIMIT 1");
	
	if($_SESSION['wpsc_selected_country'] != $check_country_code) {
		$_SESSION['wpsc_selected_region'] = null;
	}
	if(isset($_POST['shipping_country'])){
	$_SESSION['wpsc_delivery_country'] = $_POST['shipping_country'];
	}
	if(isset($_POST['shipping_region'])){
	$_SESSION['wpsc_delivery_region'] = $_POST['shipping_region'];
	}
	//exit('1<pre>'.print_r($_POST,true).'</pre>');
  $wpsc_cart->update_location();
  $tax = $wpsc_cart->calculate_total_tax();
  $total = wpsc_cart_total();
	ob_start();
	$cur_wpsc_theme_folder = apply_filters('wpsc_theme_folder',$wpsc_theme_path.WPSC_THEME_DIR);
	include_once($cur_wpsc_theme_folder."/cart_widget.php");
	$output = ob_get_contents();
	ob_end_clean();
	//exit("/*<pre>".print_r($wpsc_cart,true)."</pre>*/");
	$output = str_replace(Array("\n","\r") , Array("\\n","\\r"),addslashes($output));
	if(get_option('lock_tax') == 1){
		//echo "jQuery('#region').val(".$_SESSION['wpsc_delivery_region']."); \n";	
		echo "jQuery('#current_country').val('".$_SESSION['wpsc_delivery_country']."'); \n";
		if($_SESSION['wpsc_delivery_country']== 'US' && get_option('lock_tax') == 1){
			//exit('<pre>'.print_r($_SESSION, true).'</pre>');
			$output = wpsc_shipping_region_list($_SESSION['wpsc_delivery_country'], $_SESSION['wpsc_delivery_region']);
			//	echo 'jQuery("#change_country").append(\''.$output.'\');\n\r';
			$output = str_replace(Array("\n","\r") , Array("\\n","\\r"),addslashes($output));
			echo "jQuery('#region').remove();\n\r";
			echo "jQuery('#change_country').append(\"".$output."\");\n\r";
		}
	}
	
	echo "jQuery('div.shopping-cart-wrapper').html('$output');\n";
	if(get_option('lock_tax') == 1){
		echo "jQuery('.shipping_country').val('".$_SESSION['wpsc_delivery_country']."') \n";  
		$sql ="SELECT `country` FROM `".WPSC_TABLE_CURRENCY_LIST."` WHERE `isocode`='".$_SESSION['wpsc_selected_country']."'";
		//exit($sql);
		$country_name = $wpdb->get_var($sql);
		echo "jQuery('.shipping_country_name').html('".$country_name."') \n";
	}	  
// 	echo "\n/*
// 	{$_POST['billing_country']}
// 	{$previous_country}
// 	*/\n";
	  

	if(($_POST['billing_country'] != 'undefined') || !isset($_POST['shipping_country'])) {
//exit('<pre>'.print_r($_POST, true).'</pre>');	
		if(isset($_POST['billing_country'])){
			$isocode = $_POST['billing_country'];
			$compare = $_SESSION['wpsc_selected_region'];
		}else{
			$isocode = $_POST['shipping_country'];
			$compare = $_SESSION['wpsc_delivery_region'];
		}
		if(($isocode == 'undefined') && !isset($_POST['billing_country'])){
//		 exit('<pre>'.print_r($_SESSION, true).'</pre>');
			$isshipping = true;
			$isocode = $_SESSION['wpsc_selected_country'];
		}
		//exit("SELECT `".WPSC_TABLE_REGION_TAX."`.* FROM `".WPSC_TABLE_REGION_TAX."`, `".WPSC_TABLE_CURRENCY_LIST."`  WHERE `".WPSC_TABLE_CURRENCY_LIST."`.`isocode` IN('".$isocode."') AND `".WPSC_TABLE_CURRENCY_LIST."`.`id` = `".WPSC_TABLE_REGION_TAX."`.`country_id`");
		$region_list = $wpdb->get_results("SELECT `".WPSC_TABLE_REGION_TAX."`.* FROM `".WPSC_TABLE_REGION_TAX."`, `".WPSC_TABLE_CURRENCY_LIST."`  WHERE `".WPSC_TABLE_CURRENCY_LIST."`.`isocode` IN('".$isocode."') AND `".WPSC_TABLE_CURRENCY_LIST."`.`id` = `".WPSC_TABLE_REGION_TAX."`.`country_id`",ARRAY_A) ;
		if($region_list != null) {
			if($isshipping){
				$title = 'title="shippingregion"';
				$compare = $_SESSION['wpsc_selected_region'];
			}else{
				$title = '';
			}
			$output = "<select name='collected_data[".$form_id."][1]' class='current_region' onchange='set_billing_country(\"region_country_form_$form_id\", \"$form_id\");' $title>\n\r";
			//$output .= "<option value=''>None</option>";
		
			foreach($region_list as $region) {
					//exit($_SESSION['wpsc_selected_region'].' '.$region['id']);
				if($compare == $region['id']) {
					$selected = "selected='selected'";
				} else {
					$selected = "";
				}
				$output .= "  <option value='".$region['id']."' $selected>".htmlspecialchars($region['name'])."</option>\n\r";
			}
			$output .= "</select>\n\r";
			
			$output = str_replace(Array("\n","\r") , Array("\\n","\\r"),addslashes($output));
			echo  "jQuery('#region_select_$form_id').html(\"".$output."\");\n\r";
		
		} else {
			if(get_option('lock_tax') == 1){
				echo "jQuery('#region').hide();";
			}
			echo  "jQuery('#region_select_$form_id').html('');\n\r";
		}
 	}
	
	
	if($tax > 0) {
		echo  "jQuery(\"tr.total_tax\").show();\n\r";
	} else {
		echo  "jQuery(\"tr.total_tax\").hide();\n\r";
	}
	echo  "jQuery('#checkout_tax').html(\"<span class='pricedisplay'>".wpsc_cart_tax()."</span>\");\n\r";
	echo  "jQuery('#checkout_total').html(\"<span class='pricedisplay'>{$total}</span><input id='shopping_cart_total_price' type='hidden' value='{$total}' />\");\n\r";
	//echo "\n\r/*\n\r{$wpsc_cart->tax_percentage}\n\r*/\n\r";
	exit();
}

// execute on POST and GET
if(($_REQUEST['wpsc_ajax_action'] == 'change_tax')) {
	add_action('init', 'wpsc_change_tax');
}
?>