Simple JSP/JAVA project. Minimal servlets, almost completed - repost

This project is a simple project. Currently the website consists of 12 jsp's and 15 java servlets. The system is a service-request/ticket system for a mock tech support company.

** Currently implemented:

"technicians", "clients", and "managers" can login to the system. New service requests (requests for work to be performed FOR the clients BY the technicians) can be created by clients. Technicians can claim a service request to assign it to themselves indicating that they will perform the work requested. Service requests have a status field with 5 potential state values: new, in progress, hold, problem, resolved.

Requests are automatically "new" upon their creation. "in progress" is a the state indicating a technician is currently assigned that service request. "resolved" indicates that the service request is complete, all necessary work has been performed.

Technicians can view all "new" service requests in the system([url removed, login to view]), (because "new" indicates that no tech has claimed them yet). Technicians can also view ALL service requests currently claimed by them ([url removed, login to view]). ("in progress")

A service request can selected from the list of service requests ([url removed, login to view]) and information pertaining to that service request is displayed. ([url removed, login to view]) The information shown includes: date reported, client who made the request, a problem description, client id.

** Not yet implemented (REQUIRED WORK to Complete project):

1.) Modify [url removed, login to view] to allow technicians to add "work records" to a service request. A work record will be a documentation of work performed on the service request. Service requests can have many work records, performed by a number of technicians. The work record is to contain: work record id, technician name who performed work, work description, work date, start time and stop time (enterable by tech for billing reasons) and equipment id (enterable by tech).

2.) A jsp is needed to show a clean view of the work performed by the tech (note that "work description" is just one large text field.) and all other work record information so that it can be printed as a receipt for the client upon completion of the work.

3.) Technicians need to be able to change the already implemented status field of a service request from "in progress" to either "resolved", "hold", or "problem".

4.) Managers that are logged in need to be able to view a list of service requests with "problem" status (almost identical to [url removed, login to view]). Managers need to select a particular service request from that list to see all of the information about the service request (almost identical to [url removed, login to view]) including a list of all work records attached to that service request. From here the manager will be able to change a "problem" request to a "hold" status. (i.e. waiting on a component or authorization from client to perform work)

5.) Managers need to be able to view a report all ServReq not completed, grouped by client, then by status. (The SQL statement no be used for this report is (select [url removed, login to view], [url removed, login to view], [url removed, login to view], count(*) as NumOpen from servicerequest s inner join client c on [url removed, login to view] = [url removed, login to view] where [url removed, login to view] 'Resolved' group by [url removed, login to view], [url removed, login to view], [url removed, login to view] order by [url removed, login to view], [url removed, login to view];)



The database schema is already defined and the database is already hosted with some sample data. Data can be added to this database or modified for testing purposes. This is, however, a shared database with many people and the schema shall not be modified in any way because it would compromise the compatibility with their own projects.

Any questions that arise during your work will be answer quickly. I have a total understanding of what is required and I can articulate it without any problem if you run into complications. This project must be complete no later than Dec 11th, 2011 @ 9:00pm EST.

Skills: Java, JSP, SQL

See more: project java servlets jsp, jsp simple projects, jsp servlets, completed projects java, website creation in java, tech support service, tech support company, technician website, technicians needed, statement of problem sample, service technician, project status manager, problem statement sample, jsp service, java project work, it project managers required, i need a technician, id tech, field technician, field service technician, est java, authorization java, a sample problem statement, servlets in java, project articulate

About the Employer:
( 0 reviews ) Ramallah, Palestinian Territory

Project ID: #4534802

38 freelancers are bidding on average $193 for this job


Java Expert! Let me do this job.

$147 USD in 3 days
(345 Reviews)

Please check your inbox. Thanks

$253 USD in 7 days
(72 Reviews)

Dear, Will be done as per requirements

$231 USD in 10 days
(36 Reviews)

java jsp servlets... that what i can say. let me do your project. waiting to discuss and proceed.

$200 USD in 3 days
(8 Reviews)

Hello, please check PMB.

$400 USD in 14 days
(14 Reviews)

Kindly check your pmb. Thanks!

$200 USD in 7 days
(4 Reviews)

Hello, I can do this.

$255 USD in 30 days
(1 Review)

Hello, I'm very interested your project. Please check your inbox for more details, thanks!

$144 USD in 3 days
(2 Reviews)

Hi I am confident to handle your requirement. Please check your inbox for details. Thanks

$188 USD in 15 days
(4 Reviews)

I will do it as per your requirment.

$277 USD in 3 days
(1 Review)

Hi, I'm a Java professional from the United States. I can complete the project easily and quickly. If you read my reviews you'll see why I'm just the man for the job. Cheers! Aaron

$200 USD in 3 days
(1 Review)

Hi Friend, I have gone through the Project Description. Requirements are clear and I am ready to start immediately. , I can complete this assignment with deadline. I have development many such web application using Jav More

$66 USD in 3 days
(1 Review)

Having 6 years of experience in developing projects using Java, JSP/Servlets, AJAX, Jquery with custom animations. I have got a National Level Project Competition Award by a reputed IT company (see private message). I More

$150 USD in 8 days
(0 Reviews)

let me know about the requirement

$155 USD in 3 days
(0 Reviews)

Hi, My name is Surya and having 7+ years of experience in Java/J2EE project development & Design. Design documents (HLD or LLD) related to already implemented phase will help to have quick understanding of project.

$188 USD in 20 days
(0 Reviews)

I already have worked project like this and i can simply do this project in a better way according to your requirement..

$166 USD in 10 days
(0 Reviews)

I have enough experience in java to do what you need.

$250 USD in 7 days
(0 Reviews)

Dear: We have experience in developing systems in web java with different database engines, we are ready to complete your project.

$277 USD in 6 days
(0 Reviews)

i want to be a part of this project.

$155 USD in 3 days
(0 Reviews)

We are good team of Java Developer having 6 year of experience

$111 USD in 20 days
(2 Reviews)