Are you ok for a small app for logging work completed by some of our staff?
Simple PHP/ASP db, very simple |
Request for Question Clarification by
joseleon-ga
on
15 Jul 2004 15:03 PDT
Hello, bmcompany:
Yes, I'm ready, thanks for this new opportunity.
In any case, there is something you must know before we start, I have
been contacted by Google Editors regarding "development" jobs being
done through Google Answers, and it's ok to do it, but the full code
of the resulting application must be posted here, for example, using a
link to a .zip file.
If that's ok with you, we can go ahead with this question, just tell me.
Regards and thanks again.
|
Clarification of Question by
bmcompany-ga
on
16 Jul 2004 01:30 PDT
Hi, and the link to the zip file is fine.
Here are the access details to the domain
www.bowmactools.co.uk/access.txt
Please post back once you have downloaded and so that i can remove the link.
I'll get the full question to you within the next hour.
Cheers
BM
|
Clarification of Question by
bmcompany-ga
on
16 Jul 2004 04:10 PDT
The prog needs to log the amount of 'sites' completed by each member
of staff at the end of each day. The work is split into
2 parts.
Site Prep work
site build
One member of staff is responsible for one of those jobs.
The DB needs to store the following information.
STAFF
Member of staff's name
job title (either prep or build)
WORK LOG
Date and time (UK or long date format please)
Site name (typed into a text box is fine)
Number of phrases for site
Staff Member (drop down box)
That's it!
At the end of each day (or at the end of each site), the member of
staff will bring up the input page, and enter the site name of the
site, and it is logged into the DB.
The back end (behind a password) needs to be able to bring up the data
using filters of:
List of all sites done
day/week/month average sites done
We need to be able to narrow down by daterange, job (prep/build), and
staff member. Also, if we would click the column headings to sort,
that would help.
I hope this makes sense, as usual please confirm back here before you go ahead.
BM
|
Request for Question Clarification by
joseleon-ga
on
16 Jul 2004 07:37 PDT
Hello, bmcompany:
You can safely remove the access info, I have stored it. I will
check your requeriments and I will confirm before start.
Regards.
|
Request for Question Clarification by
joseleon-ga
on
17 Jul 2004 10:33 PDT
Hello, bmcompany:
This is what I understand from your requeriments:
-New application to be executed on your server, PHP+MySQL
-Two tables needed, one for staff members and another to log work done by them
-A front end to allow staff members enter what they have done, to be logged
-A back end, password protected, to allow you get reports from that log information
-You will be able to get a list of all sites done, or average of sites
done (day, week, month) and narrow the results by date rage, job type
and staff member.
-The result list will have sorting capabilities.
And now some questions:
-Does the front end, needs to be password protected?
-Is a job type directly linked to a staff member, or does a staff
member must be able to perform several types of job?
-Do you need to manage the staff table on the back end, to add/edit/delete members?
I will start as soon as you solve these questions.
Regards.
|
Clarification of Question by
bmcompany-ga
on
19 Jul 2004 01:04 PDT
joseleon-ga
Thanks for confirming.
- The front end does not need to be password protected.
- No staff member is responsible for more than one job. There are 2
job types and one person is responsible for no more than 1 of the
tasks.
- We would like to be able to add/edit/delete staff members, yes
Please proceed
|
Request for Question Clarification by
joseleon-ga
on
19 Jul 2004 08:40 PDT
Hello, bmcompany:
Ok, I start with it, I will keep you informed.
Regards.
|
Request for Question Clarification by
joseleon-ga
on
20 Jul 2004 09:42 PDT
Hello, bmcompany:
The first phase for the tool is finished and working on your
website, you can access here:
http://www.bowmactools.co.uk/worklog.php
I have used the same interface of the previous tool, so it's familiar to you.
Right now it's only able to add logs, the next step is to manage the
tool to get reports and manage staff.
Full sources (without real database access info) can be found here:
http://www.qadram.com/answers/374357/worklog.zip
I will keep on working on it and I will send you an update.
Regards.
|
,
0 Comments
)