Hallo, Bruno
Maybe you can help me...
Please help, if it is possible to execute a script - can migx?
I have a price table - width and height of the price.
Problem for me is to add an additional table in the database by throwing just such a table for example in csv format (matrix base price)
I need to after loading the file obtained from the database results in the from of 5 tables:
id table, > width , < width , > height , < height , price
with all possible configurations ... that example:
a width of from 400 to 500 and the height of from 0 to 400 ---> price, next row
width from 600 to 700 and the height of 0 to 400 -> Price
width from 700 to 800 and the height of 0 to 400 -> Price
width from 800 to 900 and the height of 0 to 400 -> Price
width from 800 to 1000 and the height of 0 to 400 -> Price
....
width from 400 to 500 and the height from 400 to 500 -> Price
width from 500 to 600 and the height from 400 to 500 -> Price
width from 600 to 700 and the height from 400 to 500 -> Price
etc., etc., for all possible options
All width and height must be in a separate table.
I need to do with such a database export to json to format...
{
"rule": {
"condition": "AND",
"rules": [
{
"id": "width",
"field": "width",
"type": "integer",
"input": "text",
"operator": "greater",
"value": "400"
},
{
"id": "width",
"field": "width",
"type": "integer",
"input": "text",
"operator": "less_or_equal",
"value": "500"
},
{
"id": "height",
"field": "heigh",
"type": "integer",
"input": "text",
"operator": "greater",
"value": "0"
},
{
"id": "heigh",
"field": "heigh",
"type": "integer",
"input": "text",
"operator": "less_or_equal",
"value": "800"
}
]
},
"formula": "50"
}
My example table