7 replies to this topic

[cjrose77]

I have created a calendar for a customer like outlook for scheduling equipment in a rental business. the calendar lists the equip that is supposed to go out on that day. On the calendar with the month view i would like the equipment that is out for a week to line up with it self each day, there can be some single day rentals and other rentals each day and they won't line up. I want them to line up if they continue from the day before and day after, but i can't seem to come up with the logic in my head to make this happen. you can view it here maybe to get a better understanding of what i am talking about

http://173.167.65.19...=&calview=month

[grisha]

Well I would recommend checking out the Fullcallendar jQuery plugin for that (I'm using it in a CRM application and it's a very good and easy to work with solution).

[cjrose77]

that looks so much sweeter thanks for the input, cuts down on my thinking process, lol thanks

---------- Post added at 12:57 PM ---------- Previous post was at 11:18 AM ----------

ok this looks nice and all, but is anyone willing to help me through some of this, i have no idea where to start, got your suggested calendar up but i have no idea how to get mysql data into it, is there a good starting point someone could point me to the documentation doesn't make a whole lotta sense to me

[Vaielab]

What does your database look like right now?

How do you insert event?

And what do you have so far?

[grisha]

So. Check the source code of one of the examples:

http://arshaw.com/js...enda-views.html

You'll find the 'events' property witch is an array that consists of smaller objects called events - this is the place where you need to put your own events.
The details of the Event Object can be found on the corresponding documentation page:

FullCalendar Documentation - Event Object

You can either write a typical PHP file that echo'es the example code but filling the 'events' property in a loop using the data pulled out from the MySQL database, or you can use some JavaScript and AJAX in order to do it dynamically.

Feel free to ask more questions if something's not going right :)

[cjrose77]

i don't know why my last post didn't get in here, but anyhow, thanks for a starting point, also, i would be willing to email you with other information to view current progress and maybe suggestions, otherwise, thanks again:)

---------- Post added at 01:33 PM ---------- Previous post was at 01:25 PM ----------

ok so i find where the events happen in the fullcalendar.js file and make a call to a php file it will execute that code independantly and go back to the calendar?

---------- Post added at 01:33 PM ---------- Previous post was at 01:33 PM ----------

sorry, some of these posts you can consider me thinking out loud

---------- Post added at 01:36 PM ---------- Previous post was at 01:33 PM ----------

nvm after viewing the source, i found my starting point, thanks again

[cjrose77]

Just wanted to say thanks again and check out the link if you got time. I think its turning out well.

[Vaielab]

Pretty nice, everything seem to be working perfectly
Congrats!