[SOLVED] Update VAT

[Schlo_50]

Hi guys,

 

I need to update a price list to comply with the VAT rate at 15%. Unfortunately for me the price list is stored in a flat file database so updating it isn't as easy as a MySQL one.

 

Could someone point me in the right direction to updating the price using the code I have so far please?

 

<?php
$Lines = file("priceList.DAT");

foreach($Lines as $Key => $Val) { 

  $Data[$Key] = explode("|", $Val);
  
	 $one = $Data[$Key][0];
 $two = $Data[$Key][1];
 $three = $Data[$Key][2];
 $four = $Data[$Key][3];
 $five = $Data[$Key][4];
 $six = $Data[$Key][5];
   
   $newVAT = $five / 47 * 46;
   round($newVAT, 2);
   
//Need to replace $five with $newVAT here..

}
?>

 

Thanks in advance!

[johnsmith153]

Don't reduce your VAT. You'll make more profit!

 

Then when it goes back up in Jan 2010 (UK), complain to your customers how you have had to put prices up because the government have just put VAT back up.

 

They'll never remember that you never dropped it in the first place.

 

At least this is what a lot of companies are doing!

 

Although if you deal B2B then this is irrelevant.

[Schlo_50]

..So yeah, can anybody help me with my PHP question please?

 

Thanks

[JNorman]

What sort of flat file is it?

 

You could just produce a discount at the checkout and work out what the difference in VAT change would be. Its going to go back up so it would be a much simpler method than changing the whole script.

 

 

[Schlo_50]

$Lines = file("priceList.DAT");

 

Thanks for the input, that would be my way of doing this but my client would like for me to change the pricelist itself.

 

Can anybody else help me please?

 

[unkwntech]

what is the format of the file, can you give an example with any private data *** out.

[Schlo_50]

Heres an example of two lines within the file.

 

one|two|three|four|five|six
one2|two2|three2|four2|five2|six2

 

etc etc

[Mchl]

<?php
$Lines = file("priceList.DAT");

foreach($Lines as $Key => $Val) { 

  $Data[$Key] = explode("|", $Val);
  
   $newVAT = $Data[$Key][4] / 47 * 46;
   round($newVAT, 2);

$Data[$Key][4] = $newVAT;   //I forgot about this 
$newline = implode("|",$Data[$Key]);
$newData[] = $newline;
echo $newline;
}

// now you just need to save $newData to a file

?>

 

[edit]

 

Forgot one important line

[Schlo_50]

Thanks