Dibatalkan

Php MySQL Job

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;[url removed, login to view]

2;[url removed, login to view]

Go to supplied id (will be defined differently for each file (in this example id will be “2”))

Id=2 vale is [url removed, login to view]

Download the given file and naming it by given id and current timestamp ([url removed, login to view])

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

Kemahiran: HTML, MySQL, Kart Terbuka, PHP, Kejuruteraan Perisian

Lihat lagi: php mysql job, timesheet job code php mysql, php mysql job tracking, php mysql job recruitment site, php mysql job tracker, ratemyteacher clone easy php mysql job, php mysql calculated tables, php mysql clone tables, access php mysql job, php mysql compare tables, php mysql job board, php mysql job seeker employer job posting, php mysql job boards, php mysql loop tables rows, flex php mysql job description, php mysql job portal, simple php mysql job tracker, php mysql job site software, html php mysql interactive tables, php mysql job posting software products

Tentang Majikan:
( 2 ulasan ) İstanbul, Turkey

ID Projek: #16020916

21 pekerja bebas membida secara purata $172 untuk pekerjaan ini

gopalvora

Hi i can work for Php MySQL Job i am expert at ,HTML,MySQL,Open Cart,PHP,Software Architecture So send me Private message at PMB so we can discuss more about it Thanks

$123 USD dalam 3 hari
(510 Ulasan)
8.3
coolguyinus2004

I guess you want to change price,category and status on LIVE opencart tables using some temp tables to update them and do it correctly so it dont mess things up. Ok i have an idea anyway we need to do backup first but Lagi

$277 USD dalam 3 hari
(346 Ulasan)
7.6
sprextech

Sir, I Have read your project description. i have 8 year exp. in opencart. I am confident to handle your projects with good quality. i m the top of listing on php skill. I have exp. In opencart theme customization, m Lagi

$250 USD dalam 5 hari
(317 Ulasan)
7.6
trinkaljuneja

Hello, I am Trinkal Juneja worked on 3000+ Opencart Projects since 2011, from custom module to designing template, RTL integration, Payment Gateway integration, Shipping, Import and Export, Customized product modul Lagi

$300 USD dalam 5 hari
(222 Ulasan)
6.8
superwanchiu

Hello , how are you? I have just checked your project description carefully. I am very interested in your project. I have rich experience in PHP and mysql. I can start your project immediately. Please send your me Lagi

$155 USD dalam 3 hari
(118 Ulasan)
6.6
$150 USD dalam 8 hari
(293 Ulasan)
6.8
dmonco

Ready to solve issue, we have the great experience with developing on Opencart. Feel free to contact to discuss and it will be done quickly.

$250 USD dalam 3 hari
(78 Ulasan)
6.9
jagejobs

A proposal has not yet been provided

$155 USD dalam 3 hari
(78 Ulasan)
6.7
$100 USD dalam 3 hari
(92 Ulasan)
5.8
waqas193

Hello, I have read your project requirements and exuberant to work on it. I have extensive 9 years Experience in this kind of projects & I will do the best in class. IT solutions Expertise include .Net, Graphic d Lagi

$222 USD dalam 3 hari
(14 Ulasan)
5.4
protovosolutions

We're Opencart experts - [login to view URL] & would be happy to help you with your project. Opencart Portfolio => # [login to view URL] # [login to view URL] # [login to view URL] Lagi

$250 USD dalam 10 hari
(53 Ulasan)
5.6
OSMaster2008

I have gone through the description. I am really interested in this project as it is exactly within my scope of expertise. I am 7+ years experienced & expert in PHP & MySQL, OpenCart, Magento, Wordpress, Prestashop, Co Lagi

$166 USD dalam 2 hari
(39 Ulasan)
5.2
$200 USD dalam 3 hari
(51 Ulasan)
5.1
nileshbakotiya

Hi let me help you for Php MySQL Job i have skill ,HTML,MySQL,Open Cart,PHP,Software Architecture which is very suitable to your project So send me Private message at PMB so we can discuss more about it Thanks

$104 USD dalam 3 hari
(49 Ulasan)
5.4
AbubakarHashmi

Hello, i have read your job description and fully understand your requirements. It looks like I’ll be the perfect candidate for this job because I have hands on experience in this field. Could you provide us more Lagi

$222 USD dalam 3 hari
(20 Ulasan)
4.6
mayankinnovative

A proposal has not yet been provided

$100 USD dalam 3 hari
(53 Ulasan)
4.1
ashokraj18

A proposal has not yet been provided

$45 USD dalam sehari
(7 Ulasan)
2.9
VyacheslavG

A proposal has not yet been provided

$150 USD dalam 5 hari
(0 Ulasan)
0.0
aymenabdessalemd

A proposal has not yet been provided

$244 USD dalam 5 hari
(0 Ulasan)
0.0
ecostillo

I am very familiar with php and SQL, including using SQL commands in php. You did a very great job describing the process in which it needs to be complete and I can deliver.

$111 USD dalam 3 hari
(0 Ulasan)
0.0