Find Jobs
Hire Freelancers

Some MySQL/ php fun with dates/ date modification no external code needed beyond description below

$10-30 USD

Dibatalkan
Disiarkan hampir 5 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran
I have this table: [login to view URL] Go through each item line per line and select matching deals using airport code fromCode and toCode (there are three, use all three 'ANY' please). Example fromCode SFO toCode LAX,SAN,JFK The deals come from a table like this: [login to view URL] Look for any deal that has a fromCode SFO and a toCode LAX OR SAN OR JFK in that table. Each line in table above has one of these three modes. Mode 1 - Weekends (is_weekend =1): [login to view URL] Find all Thursdays - Sunday date combinations that are after 'start' and before 'end'. If 'start' is '0000-00-00' use any start date. If end is '0000-00-00' use one year from now. Insert each matching airportCode combinations and multiply with each Date combination into table mightyDeals. i.e. insert SFO-LAX 2019-09-09 - 2019-09-12 (doe the same for each combination of route and dates) Mode 2 - Holidays (is_holiday=1) Find all holiday dates for the country and current plus year +1. i.e. 2019 and 2020 Use this table: [login to view URL] Insert each matching airportCode combinations and multiply with each Date combination into table mightyDeals. Save into related_dates and add travel_assistant_id. Mode 3 - Fixed Dates (is_specific_date=1) Only look for specific dates in start and end in table [login to view URL] Insert each matching airportCode combinations and using the only one Date combination into table mightyDeals. Voila!
ID Projek: 20022761

Tentang projek

8 cadangan
Projek jarak jauh
Aktif 5 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
8 freelancers are bidding on average $61 USD for this job
Avatar Pengguna
Hello, I read your requirements and understand very-well and ready to start work from now. Thank you
$150 USD dalam 2 hari
4.8 (142 ulasan)
7.0
7.0
Avatar Pengguna
i there I read the job description with interest. Now I am using godaddy and aws hosting . I have skills in HTML5 / CSS3, PHP, javaScpript/ JQuery, PhotoShop and other programming languages and software. I'll be happy to work on your project I have a good experience in this job. if you award me, I will fix your website. I am available at full time and can start immediately. If you award me, I can complete quickly. Best Regard. Thanks.
$40 USD dalam 7 hari
4.9 (207 ulasan)
7.1
7.1
Avatar Pengguna
Hello! I read your description carefully. I've always done my project as the fastest and highest quality. I think your project is best for me. The reason is that I am a Mysql query expert. If you want to check my skill, you can sure from my profile. To confirm this, please see the link below. https://www.freelancer.com/u/fastestJohn?w=f If you choose me, I will do my best. Thanks.
$25 USD dalam 1 hari
4.9 (29 ulasan)
5.5
5.5
Avatar Pengguna
Hi, I'm PHP/MySQL developer. I developed many applications. Looking forward to work with you. Regards
$30 USD dalam 1 hari
4.9 (23 ulasan)
4.7
4.7
Avatar Pengguna
Hi, The requirement seems to involving MySQL manipulations primarily which is something I am good at and is clear. My experience lies in MySQL database related works and I am confident to fulfil this requirement to your satisfaction. Hope to hear from you soon Thanks and regards, Hanna
$20 USD dalam 1 hari
5.0 (4 ulasan)
1.6
1.6
Avatar Pengguna
*** I have checked your description. I can do your project asap and as well. I want to discuss with you this project. Thanks.
$150 USD dalam 1 hari
4.6 (1 ulasan)
0.6
0.6

Tentang klien

Bendera UNITED STATES
San Francisco, United States
5.0
219
Kaedah pembayaran disahkan
Ahli sejak Apr 4, 2010

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.