calculate the price came from Json file and Array

[tonton]

Hi,

 

I have a json data, below which contains an item with tax:

   "date": "2015-05-05 12:41",
   "shop": "Toto",
   "products": [
      {
         "price": "2.00",
         "quantity": "1",
         "description": "chocolat",
         "tax": [
            {
               "price": "1.00",
               "quantity": "1",
               "description": "tax1"
            },
            {
               "price": "2.00",
               "quantity": "1",
               "description": "tax2"
            }
         ]
      }
   ]
}

I am able to calculate the price ($amountAll) with the following code:

$datajs = "myJsonSimple2.json";



$datajs = file_get_contents($datajs);

$decodageDatajs = json_decode($datajs);



$dateBiling = $decodageDatajs->date;
$shopName = $decodageDatajs->shop;

	foreach ($decodageDatajs->products as $obj)
		{
			$ItemPrice = $obj->price;			
			$ItemQuantity = $obj->quantity;
			$ItemDescription = $obj->description;
			
			
			
			$taxes = (array)$obj->tax;
			
			$taxesPrice1 = !empty($taxes[0]) ? $taxes[0]->price : 0.00;
			$taxesPrice2 = !empty($taxes[1]) ? $taxes[1]->price : 0.00; 
			
			$taxesQuantity1 = !empty($taxes[0]) ? $taxes[0]->quantity : 0;
			$taxesQuantity2 = !empty($taxes[1]) ? $taxes[1]->quantity : 0;
			
			$taxesDescription1 = !empty($taxes[0]) ? $taxes[0]->description : '1er tax null';
			$taxesDescription2 = !empty($taxes[1]) ? $taxes[1]->description : '2e tax null';
			
			
			$amountAll  = $ItemPrice * $ItemQuantity + $taxesPrice1 + $taxesPrice2;
			
		}

 But how I calculate if there are several items (2 or 3 or 5...)

{
   "date": "2015-05-05 12:41",
   "shop": "Toto",
   "products": [
      {
         "price": "2.00",
         "quantity": "1",
         "description": "chocolat",
         "tax": [
            {
               "price": "1.00",
               "quantity": "1",
               "description": "tax1"
            },
            {
               "price": "2.00",
               "quantity": "1",
               "description": "tax2"
            }
         ]
      },
      {
         "price": "3.00",
         "quantity": "1",
         "description": "bonbon",
         "tax": [
            {
               "price": "2.00",
               "quantity": "1",
               "description": "tax1"
            },
            {
               "price": "3.00",
               "quantity": "1",
               "description": "tax2"
            }
         ]
      },
      {
         "price": "2.00",
         "quantity": "1",
         "description": "gateaux",
         "tax": [
            {
               "price": "1.00",
               "quantity": "1",
               "description": "tax1"
            },
            {
               "price": "2.00",
               "quantity": "1",
               "description": "tax2"
            }
         ]
      }
   ]
} 

 

I need like as : 

$amountAll  = $ItemPrice1 * $ItemQuantity1   + 
			$ItemPrice2 * $ItemQuantity2 + 
			$ItemPrice3 * $ItemQuantity3  + 
			$taxesPrice1a + $taxesPrice2a  +
			 $taxesPrice1b + $taxesPrice2b  +
			 $taxesPrice1c + $taxesPrice2c; 

but this is wrong : 

 

I must counter and use while statement but I don,t know how I can write ?

$calculeItems = count($decodageDatajs->products);
$i = 0;
while ($i < $calculeItems)
	{



	foreach ($decodageDatajs->products as $obj)
		{
			$ItemPrice = $obj->price;			
			$ItemQuantity = $obj->quantity;
			$ItemDescription = $obj->description;
			
			
			
			$taxes = (array)$obj->tax;
			
			$taxesPrice1 = !empty($taxes[0]) ? $taxes[0]->price : 0.00;
			$taxesPrice2 = !empty($taxes[1]) ? $taxes[1]->price : 0.00; 
			
			$taxesQuantity1 = !empty($taxes[0]) ? $taxes[0]->quantity : 0;
			$taxesQuantity2 = !empty($taxes[1]) ? $taxes[1]->quantity : 0;
			
			$taxesDescription1 = !empty($taxes[0]) ? $taxes[0]->description : '1er tax null';
			$taxesDescription2 = !empty($taxes[1]) ? $taxes[1]->description : '2e tax null';
			
			
			$amountAll  = $ItemPrice * $ItemQuantity + $taxesPrice1 + $taxesPrice2;
			
/* this si wrong !!!!!			
$amountAll  = $ItemPrice1 * $ItemQuantity1   + 
			$ItemPrice2 * $ItemQuantity2 + 
			$ItemPrice3 * $ItemQuantity3  + 
			$taxesPrice1a + $taxesPrice2a  +
			 $taxesPrice1b + $taxesPrice2b  +
			 $taxesPrice1c + $taxesPrice2c;
			
*/			
			
		}
$i++;			
}
 

can you help me please

 

Thanks

 

 

 

 

 

 

 

 

 

 

[Barand]

try

$data = json_decode($datajs, 1);  // decode as an array
echo '<pre>',print_r($data, true),'</pre>';

$amountAll = 0;
foreach ($data['products'] as $product) {
    foreach ($product['tax'] as $item) {
        $amountAll += $item['quantity'] * $item['price'];
    }
    
}
echo number_format($amountAll, 2);

Edited May 8, 2015 by Barand

[Psycho]

FYI: You should never use pricing data passed from the client. Anyone can manipulate the data sent to your server. You should pass product IDs and quantities and then calculate on the back end only

[tonton]

 

try

$data = json_decode($datajs, 1);  // decode as an array
echo '<pre>',print_r($data, true),'</pre>';

$amountAll = 0;
foreach ($data['products'] as $product) {
    foreach ($product['tax'] as $item) {
        $amountAll += $item['quantity'] * $item['price'];
    }
    
}
echo number_format($amountAll, 2);

Hi Brand,

 

I try it but I have a Fatal error afther Print_r

 

 

 

Fatal error: Cannot use object of type stdClass as array  ... on line 22

 

 

and here is line 22 :

foreach ($decodageDatajs['products'] as $product) {

What is wrong ?

 

Thanks

[Barand]

My code decodes the json data as an array

 

$data = json_decode($datajs, 1);  // decode as an array

[tonton]

Hi Barand, Many thanks

This great, it works.

But I change little bit, I don't know if It is correct or not.

 

What do you say ?

-------------------------------------------------------------------

price of chocolat 

2.00 and tax : 1.00 +2.00 = 5.00

 

Price of bonbon 3.00 with tax =

3.00 + 2.00 + 3.00 = 8.00

 

and gateaux = 2.00

2.00 + 1.00 +2.00 = 5.00

 

so

 

5.00+8.00+5.00 = 18.00

 

 

So 

 

$allOfPrice + $$amountAl = 18

-------------------------------------------------------------------

 

like this :

 

$amountAll = 0;
$price_product  = 0;

foreach ($data['products'] as $product) {
	
	$price_product+= $product['price'] * $product['quantity'];       // price without tax   New
	
	  }
  
foreach ($data['products'] as $product) {
	
	
    foreach ($product['tax'] as $item) {
        $amountAll += $item['quantity'] * $item['price'];
		//$amountAll += $item['quantity'] * $item['price'];  // with this is it double 
		
		
    }
    
}


$allOfPrice = $price_product;
echo number_format( $allOfPrice, 2) . '<br>'; //it get 7.00 amount without tax



echo number_format($amountAll, 2). '<br>'; // it get 11.00  all of tax

echo  number_format($allOfPrice + $amountAll, 2). '<br>';  // it get 18.00  price with tax  IT S FUNY

So what do you think : is it correct or I must change it ?

 

Thanks

[Barand]

You don't need to loop twice

echo '<pre>';

$data = json_decode($datajs, 1);  // decode as an array
$amountAll = 0;
foreach ($data['products'] as $product) {
    $totalPrice = $product['price'];                 //get product price
    foreach ($product['tax'] as $tax) {
        $totalPrice += $tax['price'];                //add in the tax
    }
    printf('%-12s %5d x %8.2f<br>', $product['description'], $product['quantity'], $totalPrice);
    $amountAll += $product['quantity'] * $totalPrice;
}
printf('%-12s %5s   %8.2f<br>', '','Total', $amountAll);

echo '</pre>';

gives

chocolat         1 x     5.00
bonbon           1 x     8.00
gateaux          1 x     5.00
             Total      18.00

Edited May 10, 2015 by Barand

[tonton]

Hi Barand, Many thanks.