i need you to write a new module for [login to view URL] .
the module is described here [login to view URL] = the ResolveAxis module.
**differences:**
**work flow for support personnel:**
client calls - suport personnel inserts client data into a new ticket.
suport personnel acceses the trouble shooter and resolves the issue. at the end of each issue will open a new ticket with the issue.
the ticket will contain all the steps the client walked trough the troubleshooter.
if the suport personnel does not open a ticket other ticket view or other ticket oppening must be forbidden for that user.
**work flow for clients:**
the client walks the troubleshooter with no login.
if he wants to open a tichet because he did not find a resolution to his problem,client logs in with the username and password, all the steps walked trough the troubleshooter at that session must be sent with his ticket.
## Deliverables
the project will be awarded to the coder that will provide a link to a OsTicket installation modified in this way:
the database will contain a new table ost_client with the following fields:
id
username
firstname
lastname
passwd
email
client_code
phone
mobile
created
lastlogin
updated
the password will be required when the client logs in to open a ticket afeter walking the troubleshooter.
the password will be inserted by a trigger ( this is out of scope)
client code must be a required field and i need to make searches by the client code (as i do by default with the e-mail address = more details on skype.)
please see the screenshot. - as is required to demonstrate that you have read the requirements and the project will be awarded only if you do this first.