PHP - Problems Sorting By Price

the php web video script that I'm trying to modify allows Users to purchase videos successfully, however, the video price that is reflected in the db ('u_paid_videos') table (where transaction info is stored) appears to show the default video price (video_play_price from the 'config' db table) every time, instead of the accurate video price. I'm not sure if this code needs to be tweaked so that the actual price will show in the 'video_play_price' column (in 'u_paid_videos' table):

// get cost video // get the default video price, to use if there is no per video play price
	$db->where('name', 'video_play_price');
	$db_cost = $db->getOne('config');
	$video_cost = (float)$db_cost->value;

	// the number of submitted videos - used to determine if all records were inserted
	$count_video = count($id_array);
	$user_id = $user->id;

	$wallet = (float)str_replace(',', '', $user->wallet);
	$balance = (float)str_replace(',', '', $user->balance);

	// add up the video prices
	$amount = 0;
	foreach ($id_array as $id) {

	$video_id = (int)PT_Secure($id);

	// get video data
	$video = $db->where('id', $id)->getOne(T_VIDEOS);

	// add the video play price if any, or the default price
	$amount += $video->video_play_price?$video->video_play_price:$video_cost;
	}

	// determine if the user has enough credits
	if( ($wallet >= $amount) OR ($balance + $wallet >= $amount) ) {

		$db->startTransaction();

		$inserted_records = 0;
		foreach ($id_array as $id){

			$video_id = (int)PT_Secure($id);

			// get video data
			$video = $db->where('id', $id)->getOne(T_VIDEOS);

			// use the video play price if any, or the default price
			$video_cost_new = $video->video_play_price?$video->video_play_price:$video_cost;

			$uploader_amount = $video_cost_new *0.50;

			// add data to paid table
			$insert_buy = $db->insert('u_paid_videos', [
				'id_user' => $user_id,
				'id_video' => $video_id,
				'session_key' => $_SESSION['session_key'],
				'video_play_price' => (string)$video_cost,
				'video_title' => $video->title, 
				'user_id_uploaded' => $video->user_id, 
				'earned_amount' => $uploader_amount
				]);

<!--
var discnt = 0; // no default percent discount

var coupons = new Array ( // place to put coupon codes
"MavrkHD", "TheFUTBucks", "TOTW", "Mega", "LL"
);
var coupdc = new Array ( // place to put discounts for coupon vals
"10", "15", "7", "10", "20"
);

var coupval = "(blanket)"; // what user entered as coupon code

function ChkCoup () { // check user coupon entry
var i;
discnt = 0; // assume the worst
for (i=0; i<coupons.length; i++) {
if (coupval == coupons[i]) {
discnt = coupdc[i]; // remember the discount amt
alert ("This is a valid promo code! \n\n" + discnt + "%" +
" discount now in effect.");
return;
}
}
alert ("'" + coupval + "' is not a valid promo code!");
}

function Sterling (val) { // force to valid dollar amount
var str,pos,rnd=0;
if (val < .995) rnd = 1; // for old Netscape browsers
str = escape (val*1.0 + 0.005001 + rnd); // float, round, escape
pos = str.indexOf (".");
if (pos > 0) str = str.substring (rnd, pos + 3);
return str;
}

function ReadForm (obj1) { // apply the discount
var amt,des;
amt = obj1.amount.value*1.0; // base amount
des = obj1.basedes.value; // base description

if (discnt > 0) { // only if discount is active
amt = Sterling (amt - (amt * discnt/100.0));
des = des + " - " + discnt + "% off - COUP = " + coupval;
}

obj1.baseamt.value = Sterling (amt);
obj1.item_name.value = des;
}
//-->

<form action="https://www.paypal.com/cgi-bin/webscr" method="post" onsubmit="this.target = 'paypal'; return ReadForm (this);">

<input type="hidden" name="cmd" value="_xclick" />
<input type="hidden" name="add" value="1" />
<input type="hidden" name="business" value="<?=$functions->getPayPal();?>" />
<input type="hidden" name="item_name" value="Online Coin Currency" />
<input type="hidden" name="amount" id="amount" value="0.00" />
<input type="hidden" name="currency_code" value="GBP" />
<input type="hidden" name="baseamt" id="amount" value="0.00" />
<input type="hidden" name="basedes" value="Online Coin Currency (FUT)" />
<input type="hidden" name="custom" id="custom" value="">
<input type="hidden" name="return" value="RETURN LINK HERE";?>
<input type="hidden" name="notify_url" value="<?=HOST.'files/payments/paypal.php';?>">
<input type="hidden" name="cancel_return" value="<?=HOST.'cancelled';?>">
Enter Coupon code
<input type = "text" size = "10" name = "coupcode"; />
<input type="button" value="Apply code" onclick="coupval =this.form.coupcode.value; ChkCoup();" /><br/><br/>
<input type="image" id="xx" src="https://www.paypalobjects.com/WEBSCR-640-20110306-1/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" onclick="CalculateOrder(this.form)" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/WEBSCR-640-20110306-1/en_US/i/scr/pixel.gif" width="1" height="1">
</form>

Hi, could you please help me with an issue? 

I want to hide the price for one product in the WooCommerce emails that I send to the clients Only If the quantity of a product is over 50. For all the other items I want the price to be shown. For example, the order has 2 products, one with 30pcs quantity that displays price, and the other with 120pcs quantity but with a text 'some text' instead of the price.

I modified the email-order-items.php, <?PHP echo $order->get_formatted_line_subtotal($item); ?>  But, It's not working. I'm sure is this line but I don't know how to continue and I'm stuck. 

Thank you so much.

I am getting ready to code my e-commerce module, and could use some helping figuring out how to submit the product price.

On the product details page, if I have a button called "Add to Cart", would I want to use a hidden HTML field to submit the "product_price"?

Hi All, Long long long time lurker here! 

A little background to understand how this fits in

So I am building a local directory for my local area as part of a community project. Part of this there is the ability for local stores to sell online locally for people to have delivered or collect. So in the UK we have postcodes in the formats:

AB12 3CD,

A1 2BC

A12 3CD,

A1B 2CD

Most delivery pricing solutions only care about the full postcode as they are all about national delivery or at best only care about the first half. Due to the local nature we need more granularity to it so we have some rules: 

Delivery Available

EH => Price

EH3 => Price

EH3 1 => Price

EH3 1-4 => Price

Exceptions - No Delivery allowed

EH => null

EH3 => null

EH3 1 => null

EH3 1-4 => null

Can mix and match for example:

EH3 = £2.00

EH3 2 => £2.25

EH3 5 => null

This means that ALL EH3 address the delivery cost is £2 BUT If they are in EH3 2 then its £2.25 or if the are in EH3 5 then no delivery is possible.

I have came up with this monstrosity of code that for the most part works but also can throw the wrong delivery prices out due to bugs and issues that I can't seem to work out!  

Main Function:

function isDeliverable($postcode, $rules){
		
		$canDeliver = false;
		$deliveryValue = 0.00;
		$found = false;
			
		list($outward, $inward) = explode(' ', $postcode);
		$area = substr($outward, 0, 2);
		$district = substr($outward, 2);
		$sector = substr($inward, 0, 1);
		$unit = substr($inward, 1,1);
		
		$rulez = json_decode($rules, true);
		
		
		//RULE START - EH10 9RJ
		$pcFound = inRule($rulez, $postcode);
		
		if($pcFound){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
		}
		//RULE END - EH10 9RJ
		
		
		
		
		
		
		//RULE START - EH10 9R
		$pcFound = inRule($rulez, $area.$district.' '.$sector.$unit);
		
		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
		}
		//RULE END - EH10 9R
		
		
		
		
		
		
		//RULE START - EH10 9A-F
		$pcFound = inRule($rulez, $area.$district.' '.$sector.$unit, 1);
				
		if($pcFound){
			
			$postArray = postcodeExploder($pcFound, 1);
			
			$pcFound = inRule($postArray, $area.$district.' '.$sector.$unit);
		
			if($pcFound){
				return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
			}			
		}
		//RULE END - EH10 9A-F
		
		
		
		
		
		
		//RULE START - EH10 9
		$pcFound = inRule($rulez, $area.$district.' '.$sector);
				
		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];			
		}
		//RULE END - EH10 9
		
		
		
		
		
		//RULE START - EH10 1-4
		$pcFound = inRule($rulez, $area.$district.' '.$sector, 2);

		if($pcFound){
			$postArray = postcodeExploder($pcFound, 2);

			$pcFound = inRule($postArray, $area.$district.' '.$sector);
			
			if($pcFound){
				return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
			}			
		}
		//RULE END - EH10 1-4
		
		
		
		
		
		//RULE START - EH10
		$pcFound = inRule($rulez, $area.$district);

		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];			
		}
		//RULE END - EH20
		
		
		
		
		
		//RULE START - EH1-20
		$pcFound = inRule($rulez, $area.$district, 3);
		
		if($pcFound){

			$postArray = postcodeExploder($pcFound, 3);

			$pcFound = inRule($postArray, $area.$district);
		
			if($pcFound){
				return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
			}			
		}
		//RULE END - EH1-20
		
		
		
		
		
		//RULE START - EH
		$pcFound = inRule($rulez, $area);
		
		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];			
		}
		//RULE END - EH
		
	
		return ['canDeliver' => $canDeliver, 'deliveryValue' => $deliveryValue]; 
	}

Helper Functions:

function inRule($rules, $postcode, $type = null){
		
		foreach($rules as $key => $rule){
			
			if(substr_count($rule['postcode'], '-') !== 0 && strlen($postcode) > 2){
				$pEX = postcodeExploder($rule, $type);

				foreach($pEX as $r){
					
					if($r['postcode'] == $postcode){
						return $rules[$key];
					}
					//$rule['postcode'] = trim(substr($rule['postcode'], 0, strpos($rule['postcode'], "-")-1));
				}
			}		
			
		   
			if ( $rule['postcode'] == $postcode )
		    	return $rules[$key];
		}
		
		return false;
	}
	
	function postcodeExploder($rule, $type){
		$out = [];
		
		$r = explode(' ', $rule['postcode']);
    	$count = count($r);
    					    	
    	//It must be in the form AB1 1C
    	//$first = AB1
    	//$last = 1C-G
    	if($count == 2){
    		list($first, $last) = $r;
    	} else {
	    	$last = $r[0];
    	}
		
		list($left, $right) = explode('-', $last);
			   	
	    $sec = $left[0];

    	$leftInward = substr($last, strpos($last, '-')-1,1);
    	$rightInward = substr($last, strpos($last, '-')+1,1);
    	
		$range = range($leftInward, $rightInward);	

		foreach($range as $key => $ra){
			
			if($type == 1){
			
				$out['a'.$key] = [
					'postcode' => $first.' '.$sec.$ra,
					'deliverable' => $rule['deliverable'],
					'price' => $rule['price']
				];
				
			} else if($type == 2){
				
				$out['a'.$key] = [
					'postcode' => $first.' '.$ra,
					'deliverable' => $rule['deliverable'],
					'price' => $rule['price']
				];
				
			} else {
				
				$out['a'.$key] = [
					'postcode' => preg_replace('/\PL/u', '', $left).$ra,
					'deliverable' => $rule['deliverable'],
					'price' => $rule['price']
				];
				
			}
		}
		
		return $out;
		
	}

Stores Rules:

	$rules = '{"a1":{"postcode":"EH9","deliverable":true,"price":"1.50"},"a2":{"postcode":"EH9 7","deliverable":true,"price":"1.60"},"a3":{"postcode":"EH9 7A","deliverable":true,"price":"1.70"},"a4":{"postcode":"EH9 7AY","deliverable":true,"price":"1.80"},"a5":{"postcode":"EH1-2","deliverable":true,"price":"1.90"},"a6":{"postcode":"EH1 2-3","deliverable":true,"price":"2.00"},"a7":{"postcode":"EH4 5A-N","deliverable":true,"price":"2.10"},"a8":{"postcode":"EH","deliverable":true,"price":"1.40"},"a9":{"postcode":"TD14","deliverable":true,"price":"2.00"},"a10":{"postcode":"TD14 5DC","deliverable":false,"price":null}}';