Find Jobs
Hire Freelancers

Calendar Application

$100-500 USD

Anulowano
Opublikowano prawie 14 lat temu

$100-500 USD

Płatne przy odbiorze
I need a flexible calendar system designed using PHP and MySQL or PostgreSQL. The database needs to be structured such that repeating events can be added. Additionally, the ability to delete single events from a repeating event should be available. The database also needs to be structured in such a way that it can be efficiently queried for all events occurring on a specific date. I don't need the forms and views to enter the data made just the database structure and a class with methods like add_event, update_event, etc that will enable me to easily link my views to the database. ## Deliverables Just to be clear I'll need code that can: Add an event - both a single event and repeating event Retrieve an event based on id Update an event Delete an event Search the database for all events occurring on a day I'd also like the ability for repeating events to be modified. So if you have an event that repeats every Tuesday and Thursday but don't want it to happen on a certain day you can delete that one event but the rest of the events will occur as normal. Events should be defined with a start and ending date and time. * * *This broadcast message was sent to all bidders on Sunday Jun 27, 2010 2:22:41 PM: Thank you for your interest in this project. Since this is a core component of the larger project I’m working on I want to be certain that it will do everything that I need. I need it to be able to: 1. Add an event a. An event that only occurs once b. An event that repeats i. Daily (need to be able to specify interval like every 2 days) ii. Weekly (need to be able to specify interval and what days to repeat on) iii. Monthly (need to be able to specify interval and whether to repeat based on the day of the month or day of the week) iv. Yearly (need to be able to specify interval) c. Events should have a starting and ending time and date. 2. Retrieve an event 3. Update an event 4. Delete an event a. Delete all occurrences of the event b. If the event is repeating the ability to delete occurrences of this event (i.e. if I have an event that repeats every day for a month but don’t want it to occur on the 12th 18th and 30th of the month I can delete those individual occurrences). c. NOTE: Since events can be set to never ending you can’t just compute all the days the event will occur so you’ll need to have a separate table or column in the database that lists the exceptions or you could duplicate the row and change the end time and start time of the two rows to skip the event that you’ve deleted. This is the point where I get stuck when trying to think this through. The rest of the system I could create but I’m just not sure how to structure the database to handle deleting events in such a way that it can be efficiently queried and searched. 5. Ability to retrieve all the events that occur on a specific day. I think this is an important for how you structure the database since certain structures will make filtering out the deleted events more difficult. So I essentially need a calendar system that replicates the functionality of existing calendar applications like Google Calendar, iCal, etc. I posted this job late last night and after reviewing it a this morning thought I could have done a better job detailing my needs. So once again thank you for your interest in the project and please let me know if you have any questions. Thanks, Ian * * *This broadcast message was sent to all bidders on Sunday Jun 27, 2010 2:29:24 PM: Some have asked if they can use MySQL instead of PostgreSQL. Since the two databases are similar enough using MySQL is fine since I can always alter the code later myself to use PostgreSQL.
Identyfikator projektu: 3531943

Informację o projekcie

28 ofert
Zdalny projekt
Aktywny 14 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
28 freelancerzy składają oferty o średniej wysokości $313 USD dla tej pracy
Awatar Użytkownika
See private message.
$340 USD w 14 dni
4,9 (71 opinii)
7,4
7,4
Awatar Użytkownika
See private message.
$722,50 USD w 14 dni
4,8 (97 opinii)
7,2
7,2
Awatar Użytkownika
See private message.
$998,75 USD w 14 dni
4,8 (115 opinii)
6,8
6,8
Awatar Użytkownika
See private message.
$85 USD w 14 dni
4,8 (68 opinii)
6,4
6,4
Awatar Użytkownika
See private message.
$297,50 USD w 14 dni
4,8 (57 opinii)
6,0
6,0
Awatar Użytkownika
See private message.
$212,50 USD w 14 dni
4,9 (81 opinii)
5,9
5,9
Awatar Użytkownika
See private message.
$153 USD w 14 dni
5,0 (70 opinii)
5,9
5,9
Awatar Użytkownika
See private message.
$361,25 USD w 14 dni
4,7 (63 opinii)
5,6
5,6
Awatar Użytkownika
See private message.
$374 USD w 14 dni
4,7 (12 opinii)
5,8
5,8
Awatar Użytkownika
See private message.
$255 USD w 14 dni
4,8 (15 opinii)
5,0
5,0
Awatar Użytkownika
See private message.
$102 USD w 14 dni
4,9 (26 opinii)
4,8
4,8
Awatar Użytkownika
See private message.
$170 USD w 14 dni
4,4 (17 opinii)
5,1
5,1
Awatar Użytkownika
See private message.
$119 USD w 14 dni
4,9 (27 opinii)
4,7
4,7
Awatar Użytkownika
See private message.
$255 USD w 14 dni
5,0 (10 opinii)
4,0
4,0
Awatar Użytkownika
See private message.
$212,50 USD w 14 dni
5,0 (23 opinii)
3,8
3,8
Awatar Użytkownika
See private message.
$127,50 USD w 14 dni
4,7 (6 opinii)
3,4
3,4
Awatar Użytkownika
See private message.
$85 USD w 14 dni
4,5 (7 opinii)
3,6
3,6
Awatar Użytkownika
See private message.
$102 USD w 14 dni
5,0 (18 opinii)
3,4
3,4
Awatar Użytkownika
See private message.
$187 USD w 14 dni
4,0 (23 opinii)
4,1
4,1
Awatar Użytkownika
See private message.
$85 USD w 14 dni
5,0 (3 opinii)
2,9
2,9

O kliencie

Flaga UNITED STATES
United States
0,0
0
Członek od wrz 6, 2007

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.