Post by boredmind » Sun Nov 05, 2017 5:52 am

Hello,


I would like a mod that can calculate the price from a table in mysql.


To be more specific. I want the product to have a minimum price and to order the user has to complete two boxes. ( length and height). Then according to these dimensions the mod needs to find from a table in the database the price and change it pressing a button that would say calculate the price.

example.

the user wants the length to be 1025mm and the height 2256MM

the table in the database is as follow:

horizontal is the length
vertical is the height.

1000 1100 1200
2000 100 115 125
2100 110 117 129
2300 125 128 132
2400 129 132 152
2500 131 137 159

for this example the mods needs to change the price to 125$.

this mod needs to work in the last version of OC 3

New member

Posts

Joined
Sat Jul 12, 2014 4:26 pm
Location - Metamorfosi,Athens,Greece

Post by IP_CAM » Sun Nov 05, 2017 5:59 am

Well, what's wrong with this ? :D
Ernie
---
Product Size Option for OpenCart 3
https://www.opencart.com/index.php?rout ... n_id=31938
---
https://www.opencart.com/index.php?rout ... uct%20size
Image

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by boredmind » Sun Nov 05, 2017 6:04 am

thenk you for the reply. I want to find the price in a grid and not to calculate according to dimensions and a fixed price per square meter.

New member

Posts

Joined
Sat Jul 12, 2014 4:26 pm
Location - Metamorfosi,Athens,Greece
Who is online

Users browsing this forum: No registered users and 157 guests