Hi all,
I'm trying to write a program that works as a shift log. At the
moment, we have a piece of paper that has a number of items on it as a
check list and I want to create a similar thing.
My database looks like the following:
TABLE: Tasks
taskId
taskDescription
taskDueTime
taskAddedBy
taskAddedDate
TABLE: logs
logId
logDate
logStartedBy
TABLE: events
eventId
logId
eventCompletedTime
eventCompletedBy
eventComments
What I want the UI to look like is this:
---------------------------------------------------------------------------------------------------------
| <taskDescription> | <taskDueTime> | [ complete
task ] |
---------------------------------------------------------------------------------------------------------
Basically, I want the code to loop through the tasks, create the
controls above and then when the [ complete task ] button is pressed,
add the required data to the events table. I can get the currently
logged in user and the time the task was completed without any issues,
but I'm struggling to generate the UI as the number of tasks will
change and I don't want to have to re-code the UI everytime I add a
task!
I can do it in PHP, but we don't use that here, so if anyone can
help, that would be great!
Cheers,
M.
|