Find Jobs
Hire Freelancers

Make a Mysql query for round all price with .99 at the end

€8-30 EUR

Selesai
Disiarkan hampir 7 tahun yang lalu

€8-30 EUR

Dibayar semasa penghantaran
I need to round all prices of my website done by opencart with .09 final, for example. The price like 5.50 will become 5.49, the price like 20 will become 19.99, the price like 21.56, will become 21.59 With this query update oc_product set price = ceil(price) - 0.01 i'm able to make it, but the problem is that the price stored in DB is wihout tax, so the query have to SUM the product price + tax, then round it, then substract the tax In attachment you can see the tables (products + taxs).
ID Projek: 14331700

Tentang projek

25 cadangan
Projek jarak jauh
Aktif 7 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
hi I am having good knowledge in MySQL. i can able to write query for your criteria. i will complete the task on time as per your requirement thanks
€23 EUR dalam 1 hari
5.0 (1 ulasan)
1.5
1.5
25 pekerja bebas membida secara purata €25 EUR untuk pekerjaan ini
Avatar Pengguna
***Hello! It can be done as required. Please revert back so that we can discuss and start working on the project as per your requirement. In most of the cases, it suffices my requirement
€34 EUR dalam 1 hari
5.0 (10 ulasan)
5.6
5.6
Avatar Pengguna
Hi, I have reviewed your requirement and I can do this job as per your requirement. We have huge expertise in WORDPRESS ,Payment gateway, Laravel, Node.Js , React.Js, CakePHP, Codeigniter, Angular.js, Bootstrap, API Integration, Plugins , MYSQL, JavaScript, HTML, Jquery, Magento, HTML 5 ,YII frame, PSD to HTML and CSS to name a few. We have built more than 200 website in Magento and WordPress including theme and customized theme as well. I am looking for long term work relationship from you. Looking forward for your positive response. For more reference please see portfolio herewith. Regards, Rajiv Sharma
€55 EUR dalam 1 hari
4.7 (10 ulasan)
4.8
4.8
Avatar Pengguna
Yes, I can surely help you out with your project. I have read your requirements and understand what exactly you want to do. I'm ready to start the work. Please inbox me for discussion. Looking forward for your response. Thanks, Arun
€34 EUR dalam 1 hari
4.9 (5 ulasan)
3.6
3.6
Avatar Pengguna
Hello sir/ma'am, I am a computer engineer and I have been working with MySQL for near about 3 years. I read the project description and I can complete this task successfully. I am unable to find the attachments mentioned here but if the bid is worth, do contact me. I'll help you with this for sure. Thank you very much..
€12 EUR dalam 1 hari
5.0 (7 ulasan)
3.7
3.7
Avatar Pengguna
I am a software developer in MNC and I can help you with your task. Please discuss.
€29 EUR dalam 1 hari
4.9 (3 ulasan)
3.1
3.1
Avatar Pengguna
A proposal has not yet been provided
€11 EUR dalam 1 hari
5.0 (5 ulasan)
3.1
3.1
Avatar Pengguna
Hi, I am very strong in opencart with 10 years of professinal experience and finished many issues surrender by top ranked freelancers. can I do number round to .09 by php script? Thanks & Regards, Ramesh Sharma
€34 EUR dalam 1 hari
5.0 (5 ulasan)
2.7
2.7
Avatar Pengguna
Hi, I'm a french software engineer, and I worked for 10 years for compagnies, as well as MySQL and SQL Server databases. Now I'm a freelancer. For your project, I am available from now, and for the time you want. Can you provide me the tables (there is no attachment) ? If you have any questions do not hesitate to contact me. Best Regards.
€25 EUR dalam 2 hari
5.0 (2 ulasan)
0.7
0.7
Avatar Pengguna
I'm going to help you make your SQL query that will make 3very price appear as .99 in less than twenty-four hours, feel free to message me I think you'll need to provide me wit the name of the table/columns
€16 EUR dalam 0 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
hi, i can create the sql update for you. i am an italian sql, .net, php developer. please contact me to start have a nice day Angelo
€19 EUR dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
A proposal has not yet been provided
€15 EUR dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
I can complete the task quick. I also will double check everything is right and make sure to meet what you want.
€17 EUR dalam 1 hari
0.0 (0 ulasan)
0.0
0.0
Avatar Pengguna
A proposal has not yet been provided
€18 EUR dalam 1 hari
0.0 (0 ulasan)
0.0
0.0

Tentang klien

Bendera ITALY
Villanova Mondovì, Italy
4.9
191
Kaedah pembayaran disahkan
Ahli sejak Jun 25, 2014

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.