Ticket System

We are looking to create a support ticket system (similar to a helpdesk system) to be used by various support groups in the organization. We would like the system to have a web-based UI (using PHP) and the scheduling service to be written in Java (this would need to run as a windows service using a wrapper). All components will need to run on a Windows 2008 Server using IIS.

Attached is an informal class diagram which includes the types of information required to be stored by the system, their attributes and their relationships. This class diagram was put together to support the following requirements:

Basic functionality:

- All functionality in the application should be split between "scopes". Each scope should appear like a separate instance of the application (separate ticket submission screen, separate ticket management screens, separate category configuration, separate tags, separate user permissions, separate search scope, etc.)

- Web-based form for end user to submit a support ticket.

- Screen to view tickets submitted by the logged in user (read-only)

- Search by category, tags, submission date, client, owner, and full text on subject, comments, and request text.

- Submission of tickets by email (can make use of Microsoft Exchange infrastructure)

- Allow updates to tickets by email (ticket identifier parsed from subject line)

- Ticket management screen. Would allow the support staff to browse/list tickets for which they are the owner, tickets which have been recently submitted (not assigned to anyone), tickets currently open (all users), and tickets recently closed (all users).

- Ticket update screen. This screen would be used by the support staff to view/edit the ticket and add comments to the support request. When adding a comment to the support request, there should be the option to have the comment emailed to the ticket customer and any other recipients required. The support staff would also have the ability to change the owner of the ticket and the customer assigned to the ticket. The support staff would have the ability to close or re-open the ticket from this screen as well.

- Tickets should be able to be linked to another ticket in a parent-child relationship. Tickets having children tickets should list those tickets when the support staff is view the request. Tickets with a parent ticket should list their parent ticket as well.

- Any number of tags should be able to be added to a ticket. Tags are used to categorize tickets in an ad-hoc fashion. Tags can not be added on the fly by all users, they must select from a pre-existing list of tags available. Ideally, the tags should be added to a ticket using a textbox with auto-complete.

- A fixed number of catgory fields should be available in each scope. These categories provide fixed choice and controlled categorization of the ticket.


- Add/change/delete tags.

- Add/change/delete category fields and the categories in each field.

- Manage user roles/permissions within the scope.


- All user authentication should be performed through pass-through IIS authentication if available and if not the application should prompt for a username/password using in-application authentication.

- User management screen to add/change/remove user accounts. Should integrate with pre-existing XML webservice to lookup user information from Active Directory.

- Should have one super-user account which has the abliity to manage user accounts and add/change/delete "scopes".

- User accounts should be auto-created when using pass-through authentication. A default user role would be used for all auto-created accounts.

This is a reasonably high-level description of what is required, so it is expected that there will be some additional discussion around the details of the solution.

The "Java scheduling service" I refered to in the original details was not well explained. The java service would only be required if a continuously running server side process is required by the solution you are proposing to meet our needs. If no continous server side process is required by your design, then no java service is required.

Additional requirements which were not included in the original post:
- High quality code and good in-code documentation is required, we will be reviewing a sample of code from a past project to ensure it meets our quality standards. We will then require that all code developed during this project meet that same standard.
- Developer documentation, system design document(s), and an installation guide (hand-over documents package) should be included in final deliverable. End-user documentation (how to use the system) is not required.
- For each "scope" in the system, the theme (very simple themes) and site title should be customizable from the front end. There should be 3 themes to select from. The graphics/design should be simple, clean, and modern looking.
- All configuration of the system (other than database connection info) should be specified through the front-end of the application.

If any of these changes affect your bid, please adjust your bid or let us know by private message. In any case, we will be contacting those bidders that we are interested in working with to discuss details prior to awarding the project.

Skills: HTML, Java, Javascript, Oracle, PHP

See more: java ticket system, java ticket, wrapper application, what is system ui, what is ad hoc administration, web directory submission service, ticket fly, scope application form, pre-written email, microsoft support number, it support role, hoc administration, functionality diagram, components of class diagram, comment system in php, class diagram xml, class diagram user, catgory, application wrapper, a level system, ad hoc administration, ad exchange server, active ui, 3 line diagram, ticket system java

About the Employer:
( 0 reviews ) Calgary, Canada

Project ID: #1152085

58 freelancers are bidding on average $7682 for this job


Greetings! My price quote is cheaper and cost-effective, much lower than the average on the project board. The fact being that we would like to develop this Ticketing System in PHP with MySQL as database. But that depe More

$5000 CAD in 60 days
(193 Reviews)

Please accept our bid to assign 2 dedicated developers to develop your Helpdesk Ticket System. These developers will communicate you daily through skype and msn messenger. Over 11 years We have been developing Social N More

$7500 CAD in 60 days
(75 Reviews)

Hi, please check PMB.

$7750 CAD in 45 days
(99 Reviews)

Please check INBOX, Thanks

$5500 CAD in 60 days
(298 Reviews)

Check your PMB for details!!!

$5885 CAD in 60 days
(61 Reviews)

Please check your PM for more details. Thanks

$5000 CAD in 40 days
(26 Reviews)

Please check PMB

$7869 CAD in 75 days
(367 Reviews)

Hi, We are CMMI Level 3 Certified Company. Please check inbox for more details. Regards, Harini from Changepond Team

$6500 CAD in 40 days
(24 Reviews)

Hi, Please check pmb for details. Thanks Anushree

$8500 CAD in 65 days
(41 Reviews)

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$5000 CAD in 60 days
(49 Reviews)

Please check PMB for more details !! Thanks !!

$5000 CAD in 60 days
(31 Reviews)

Dear Sir, Please see my personnel message. Thanks

$6000 CAD in 70 days
(4 Reviews)

Hello, 10+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.

$6000 CAD in 60 days
(49 Reviews)

Hi, We are expert in designing and we have good team of graphic designers. We assure you for quality services. Please see our recent feedback. See pmb for more details. Regards,

$5000 CAD in 50 days
(40 Reviews)

I'm quite interested in your project. We need more discussion before to give you my final Quotation and move on this project.

$28500 CAD in 120 days
(16 Reviews)

Hello, Please view PMB. Ashwin

$5000 CAD in 40 days
(41 Reviews)

We are a professionally managed IS0 9001:2008 certified web development company. Our team has extensive experience and we have provided services to reputed companies in US, UK, CANADA & Europe. Currently we have around More

$5000 CAD in 45 days
(7 Reviews)

Hai,I am ready to work with you right now. Please refer PMB. Regards, Kirthiga.

$5050 CAD in 45 days
(13 Reviews)

i m looking for work with [url removed, login to view] [url removed, login to view] see pmb.

$5000 CAD in 30 days
(10 Reviews)

Hi, We are group of two freelancer have 6+ years of experience in web developments. We would be able to this project with higher quality and within time frame.

$5000 CAD in 45 days
(1 Review)