working shifts schedule

Freelancer2003

CREATE TABLE members (

ID INT UNSIGNED AUTO_INCREMENT NOT NULL,
username VARCHAR (15) NOT NULL,
UNIQUE KEY username (username),
PRIMARY KEY (ID),
) TYPE=MyISAM;

INSERT INTO 'members' ('username') VALUES ('tony');
INSERT INTO 'members' ('username') VALUES ('tina');

CREATE TABLE schedule (

ID INT UNSIGNED AUTO_INCREMENT NOT NULL,
memberID VARCHAR (15) NOT NULL,
status SMALLINT (1) enum('1', '2', '3') NOT NULL DEFAULT '1', 
start DATE (10),
end DATE (10),
PRIMARY KEY (ID),
)TYPE=MyISAM;

INSERT INTO 'schedule' ('memberID', 'status', 'start', 'end') VALUES ('1', '1', '2003-05-15', '2003-05-18');
INSERT INTO 'schedule' ('memberID', 'status', 'start', 'end') VALUES ('2', '3', '2003-05-28', '2003-05-30');


1 = free; 
2 = day; 
3 = night; 

function backround_color($var){ 
    $colors = array( 1 => "white", "yellow", "red" ); 
    return($colors[$var]); 
} 

bgcolor="<?=backround_color($var); ?>"

How integrate this in the calendar ?

maniac1aw

thats a pretty general question...

well you could either

a) code a calendar

b) get a calendar and add your dates into it....

Freelancer2003

What is the best solution?

Freelancer2003

Can anybody help me ?

wayang_mbeling

I am about to start working on similar project like the one you have, Freelance and I wonder if you have solved/finished your project.

If not maybe someone in this forum can give us some enlightment?

I am assigned to create an employee availability database so the employers can track whether or not the employee is in.

What I have in mind is a database with one table with this info:

EMP_AVAIL_TABLE
EmpID or EmpName
LeaveInfo --> Vacation, Sick or Others
StartDate
EndDate

where those information will be entered by Admin via Admin page with PHP form.

And I want it to be displayed like this: (01, 02, 03 ... are the dates of month)

+-----------+----+----+----+----+----+
|EmpName | 01 | 02 | 03 | 04 | .... |
+-----------+----+----+----+----+----+
| EmpA | V | V | V | V | |
+-----------+----+----+----+----+----+
| EmpB | S | S | S | | |
+-----------+----+----+----+----+----+
| EmpC | | | V | | |
+-----------+----+----+----+----+----+

I know how to create a calendar.

Now, since I only have StartDate and EndDate, how can I 'explode' the StartDate and EndDate into single dates between those two dates so that I can insert LeaveInfo into each of those related dates in my calendar? I believe "BETWEEN" in MySQL is not what I want.

What I have in mind to do this is using either temporary table or an array that will store the dates between after some 'dates-exploding' process. But, I am not pretty sure about it. There must be a better solution for this.

Well, I will really appreciate any info that will lead to the solution of this.

wayang_mbeling

i finished mine, part of the code is here:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10249630&highlight=calendar

hope it can help...