PHP MySQL Related Project

Tables General Opencart 3.2.0 and in addition tables = source_1,cat_a_1 , price_spec_a_1,status_a_1 Table "source_1" structure with example data 1: id,value 1;1 2;99 3;4 4;1.5 5;1.9 6;1 7;1 Table “price_spec_a_1” structure with example data 1: Id,value 1001;15.15 1002;16.90 Table "cat_a_1" Structure with example data 1: id, data, cat_id 1001;4005 1002;4006 1 = Category Calc 2 = Price last value 3 = Price Plus specific value (shipment costs) 4 = Chosen Buy price method times given value = Sell price (Special Price) 5 = Result of “4” times given value = Usual Price (Main Price) 6 = Price Buy from manufacterer 7 = Status Steps Step 1 Connect to database using supplied information Go to supplied database table (in this case it’s table “eug_co”) Table structure Id;data 1;[login to view URL] 2;[login to view URL] Go to supplied id (will be defined differently for each file (in this example id will be “2”)) Id=2 vale is [login to view URL] Download the given file and naming it by given id and current timestamp ([login to view URL]) Connect to another database (connection details will be also supplied) Import the data from the xlsx file into tables wich will be also supplied (for this example it will be source_1,cat_a_1 , price_spec_a_1,status_a_1) After the process is done I want it to run the steps 2,3 and 4 that are given after this step After the whole process is done I want it to give a text response (pure text) that is saying “success” I will need the configurable parts to be at the top of the file Config 1 Config 2 Config 3 Etc etc Code End file I need the whole process to be in just one php file that I can multiply as I want and make the necessary configurations from the code within Step 2 Price Calc 1 Tables related :source_1, price_spec_a_1, oc_product_special, oc_product If table “Source_1” column “id” 6 column “value” is = value “1” then go to Table “price_spec_a_1” and for every single id make the calculation as Column “value” first adds (+) value from Table “Source_1” id 3 then times the result in id 4 and changes the resulted values last (after character “.”) with value given in 2 and relay the resulted are to table “oc_product_special” by the given id in the column “price”, then go to Table “source_” and make the same calculation only excluding the id 3 and instead of using id “4” use id “5” If to give an example Table “oc_product_special” = 1001;52.60 Table “spec_a_1” = 1001;45.50 Table “source_1” id 6 = 1 Table “source_1” id 4 = 1.2 Table “source_1” id 3 = 4 Table “source_1” id 2 = 99 Table “source_1” id 5 = 1.4 Then 1001 id value 45.50 + 4 = 49.50 * 1.2 = 59.4 (trim) = 59.00 (add_last) = 59.99 * 1.4 = 83.986 (trim) = 83.00 (add_last) = 83.99 So the product id 1001 in table “oc_product_special” = 1001;59.99 instead of 1001;52.60 and the product id 1001 in table “oc_product” will be 83.99 (or if it makes it easier 1001;83.99) (also column”price”) Step 3 Category Calc Tables related :source_1, cat_a_1, oc_product_to_category, oc_product If table “source_1” id “1” = value “1” then relay given data in table “cat_a_1” to table “oc_product_to_category” but only the given id If to give an example Table “oc_product_to_category” = 1001;5000 Table “cat_a_1” = 1001;4005 Then table “oc_product_to_category” = 1001;4005 Step 4 Product close/open Tables related :source_1, status_a_1, oc_product If table “source_1” id “7” = value “1” then relay data from table “status_a_1” to table “oc_product” just like in step 2 but with a slight modification If to give an example Table “oc_product” = 1001;1 Table “status_a_1” = 1001;0 Then table “oc_product” = 1001;0 This is an important project, please read very carefully before asking any questions because I think I have explained the algorithm of the process as clearly as possible Regards