Dibatalkan

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

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!

Kemahiran: MySQL, PHP, SQL

Lihat lagi: insert today date form field mysql php, php example copy date mysql html, save excel date format mysql php, saving system date mysql php, date wise search mysql php ajax, php mysql scripts reports base date range, javascript date picker mysql php, mysql php form insert date, date example database mysql php midlet, mysql php display results date, compare date mysql php, mysql php register date, mysql php date range select, mysql query find saturday date php, save current date time mysql php, mysql php search dates, highcharts date mysql php

Tentang Majikan:
( 186 ulasan ) Palo Alto, United States

ID Projek: #20022761

13 pekerja bebas membida secara purata $57 untuk pekerjaan ini

brianconey

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 h Lagi

$40 USD dalam 7 hari
(184 Ulasan)
7.0
dynamitewebsol

Hello, I read your requirements and understand very-well and ready to start work from now. Thank you

$150 USD dalam 2 hari
(64 Ulasan)
6.3
jinxing4

Thanks for the job invite. It's a pleasure to meet you and I have read your description carefully and understood. As an web expert. i have strong skills and experiences in web development for 5 years. So i can do yo Lagi

$50 USD dalam sehari
(78 Ulasan)
5.6
fastestJohn

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 Lagi

$25 USD dalam sehari
(17 Ulasan)
4.8
mobileexpert1235

Hello, how are you? Thank you for your opportunity to bid on the project. I have developed web sites for five years, including web scraps, shopping sites, business web apps, and web API integration. So, I can help y Lagi

$25 USD dalam sehari
(3 Ulasan)
3.3
pandaios

Hi, Nice to meet you. :) I have already your description carefully and understood your whole requirements fully. With 6+ years of experience in Web development, I developed a lot of big and small websites using almost Lagi

$150 USD dalam 7 hari
(4 Ulasan)
3.1
MHassanBedor

Hi, I'm PHP/MySQL developer. I developed many applications. Looking forward to work with you. Regards

$30 USD dalam sehari
(8 Ulasan)
3.4
Abhiroy2122

Dear Hiring Manager! I have seen your job post and gone through your detail project plan. I am ready to work as a Web Developer and I am very much comfortable with theme. Please share complete requirements and best Lagi

$25 USD dalam sehari
(2 Ulasan)
1.7
hoang11222

Hello, I hope work with you because my skill set is very suitable to your Job and i can start now. I have been very sure that I can provide you the perfect result of it. As a professional web developer, I can compl Lagi

$25 USD dalam sehari
(1 Ulasan)
1.1
volleyballstar

Hello, there! I have thoroughly read your job post and I would like to apply for it. I have been working with PHP more than 5 years already and have extensive experience in developing several Framework I'm also exp Lagi

$30 USD dalam sehari
(2 Ulasan)
1.1
devatwork7

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 Lagi

$20 USD dalam sehari
(2 Ulasan)
1.1
wangzy840101

*** 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 sehari
(0 Ulasan)
0.0
chengxincode

Hello, I am a Senior Web developer having excellent experiences in web development. I have been developing many websites for 7+ years and have full experience in developing websites based on your required fields. My s Lagi

$20 USD dalam sehari
(0 Ulasan)
0.0