Google Answers Logo
View Question
Q: for joseleon-ga only please ( Answered 5 out of 5 stars,   0 Comments )
Subject: for joseleon-ga only please
Category: Computers > Programming
Asked by: bmcompany-ga
List Price: $200.00
Posted: 15 Jul 2004 01:55 PDT
Expires: 14 Aug 2004 01:55 PDT
Question ID: 374357
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

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.



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.


Member of staff's name
job title (either prep or build)


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.


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.


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.


Clarification of Question by bmcompany-ga on 19 Jul 2004 01:04 PDT

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
- 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.


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:

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:

I will keep on working on it and I will send you an update.

Subject: Re: for joseleon-ga only please
Answered By: joseleon-ga on 21 Jul 2004 14:59 PDT
Rated:5 out of 5 stars
Hello, bmcompany:

I have finished the tool, you can find it here:

To login, use "admin" as user and your FTP password as password.

Now you are able to manage staff (add/delete/modify) and to show the
logs, narrow them by date range, job type and staff member, and also,
on the bottom of the listing you get the average statistics by day,
week and month.

Full sources (without real database access info) can be found here:

Please, check it out and don't hesitate to request for any
clarification, I will continue working on it until you are 100%


Request for Answer Clarification by bmcompany-ga on 30 Jul 2004 04:37 PDT
QID: 381236 (if you have timne)
bmcompany-ga rated this answer:5 out of 5 stars and gave an additional tip of: $100.00
Excellent answer, exactly as specified in the question. nice guy too!

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy