Recurring Event Stored Procedure

I need a MYSQL stored procedure(s) that returns a list of dates given a start date, end date or both and the events returned are based on a recurrence rule (i.e. an iCalendar recurrence rule [url removed, login to view]). This SP will be used to enhance an php calendar application to support recurring events.

We will already have an events table which is joined with the rrule, exdate and rdate tables via the event_id. It may be beneficial to have multiple stored procedures that call one another for organizational purposes.

For DAILY recurrence:

1. Every x days

2. Every weekday

For WEEKLY recurrence:

1. Recur every x weeks on (Sun, Mon, Tue, Wed, Thu, Fri, Sat)

For MONTHLY recurrence:

1. Day x of every y months

2. The (1st-4th,last) (Sun-Sat,day,weekday,weekend day) of every x months

For YEARLY recurrence:

1. Every (Jan-Dec) Day

2. The (1st-4th,last) (Sun-Sat,day,weekday,weekend day) of (Jan-Dec)

Included Date Table:

1. If extra dates are included return those date as well.

Excluded Date Table:

2. Exclude dates in this table if date returned in recurrence.

The start date is specified as well as an end date of:

1. No end date (this should go out 3 years)

2. End after x occurrences

3. End by date

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

MYSQL Stored Procedure(s)

Taidot: MySQL, PHP, tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: call ssis package stored procedure, stored procedure recurring events, joomla install sql stored procedure, how to create event in mysql workbench, mysql create event every day, mysql event scheduler examples, mysql stored procedure schedule, mssql schedule stored procedure, mysql events definer, mysql view events, mysql check if event scheduler running, php, mysql, sql, software architecture, convert ms stored procedure oracle package, convert sql stored procedure oracle stored procedure, sql 2005 stored procedure, convert stored procedure sql oracle, stored procedure convert function

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #16091484

15 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello, The link is not working on my side however I've got the basic requirement of Stored Procedures and have full command on MySQL and, will do research on iCalendar recurrence rule. Let me know when we can start Lisää

$882 USD 3 päivässä
(142 arvostelua)

Hello, for this we would have to combine a few stored procedures with cron jobs in order to get the desired results. Best way is to hire hourly and give access so that we can work on a query at a time and test t Lisää

$2117 USD 23 päivässä
(121 arvostelua)

IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 10+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networking, real-es Lisää

$705 USD 15 päivässä
(213 arvostelua)

Hello, This is Raman from "Hire WordPress Experts" and I am here to help you with Recurring Event Stored Procedur . We have gone through the information provided by you. and I can assure you that we are expert with Lisää

$200 USD 3 päivässä
(234 arvostelua)

HI My Notion : "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews to determine the quality of our work.: can u show me events table? in which platform Lisää

$248 USD 3 päivässä
(112 arvostelua)

A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. I can start your important project right away. Let's start! To achieve goal with Lisää

$258 USD 5 päivässä
(138 arvostelua)

Dear Sir, Our skilled and experienced team will easily handle your project and complete it within given time and cost. Kindly check our freelancer profile for more. Below are few recent android and iphone apps deve Lisää

$264 USD 9 päivässä
(99 arvostelua)
vpnsolution ★ 100% Positive Rating ★ 180+ Five Star Reviews ★ Accepted 200+ Jobs On Freelancer ★ We Sucessfully Delieverd 1000+ Web & Mobile Application. We provide web design and d Lisää

$941 USD 3 päivässä
(150 arvostelua)

Hi There, Thank you for this wonderful opportunity:) Today Your job posting has caught my attention. I’m keenly considering your job post including all the required skills to accomplish this job successfully and Lisää

$1176 USD 15 päivässä
(89 arvostelua)

Hello, First of all, its my pleasure to bid on your project, I have gone through your requirements. We are a highly skilled team to provide you the best experience. We are ready to work on it as soon as you will awa Lisää

$250 USD 10 päivässä
(43 arvostelua)

Hello, I assure I will help you develop the recurring events app. I have created a similar app [login to view URL] I have 6+ years of experience in PHP, WordPress, Laravel, CodeIgniter, Photosh Lisää

$870 USD 10 päivässä
(47 arvostelua)
$250 USD 3 päivässä
(15 arvostelua)

Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. Please feel free to discuss the project with me so that I can wrap Lisää

$300 USD 5 päivässä
(8 arvostelua)

hey there, Yes I am aware of Recurring Event Stored Procedure. Yes I am ready to create a MYSQL stored procedure(s) that returns a list of dates given a start date, end date or both and the events returned are ba Lisää

$277 USD 7 päivässä
(9 arvostelua)

Are you planning to call a cron job in which you want to call the stored procedure? Will be good to know your expectation in more details

$222 USD 7 päivässä
(7 arvostelua)