The question is divided into 2 parts.
1. How to structure the data in the json array
2. How to calculate the price from the json array
I need to store the price data inline in HTML as JSON, as AJAX requests to the server are too slow/heavy.
The data are stored as serialized strings in a database. This is added to the database from CSV file uploads. The CSV files looks like below.
50 100 150 200 250
20 70 90 110 130 150
30 90 110 130 150 170
40 110 130 150 170 190
50 130 150 170 190 210
60 150 170 190 210 230
If you enter 100
in width and 40
in height, the price should be 130
.
If you enter 170
in width and 52
in height the price should be 210
.
If column or row is not found, it should round up to next column or row.
-
What is the best way to store this as JSON inline, if you need to calculate the price based on width and heigth?
-
How would you calculate the price, based on user input
width
andheight
?
I am not looking for specific code, just suggestions on the JSON structure and how to calculate from this.