Peruttu

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, 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, t_sql stored procedure, update stored procedure, sql stored procedure check expiry date, xml path stored procedure, sql database schema stored procedure, windows applications create stored procedure page, stored procedure dump phpmyadmin, return info stored procedure tsql, sql xml stored procedure, sql stored procedure return table

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #16091484

15 freelanceria on tarjonnut keskimäärin 597 $ tähän työhön

arhamsoftltd

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)
8.7
bhawanbaweja

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)
8.1
shivmirthyusl

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)
8.1
OutsourceMan

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)
7.8
usatechsoft

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)
7.3
latatestTech

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)
7.5
ominfowave

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)
7.3
vpnsolution

https://www.freelancer.com/u/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)
6.8
forcitCample

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)
6.5
technovicinity

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)
6.4
tarunmehan

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

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

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)
4.6
ritwebtech

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)
3.9
Lultu

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)
2.4