JQuery/Ajax One Way Instant Message Script

This job is for the front end of a simple JQuery and CFML based instant messaging script. This is a one way messaging only. It will NOT be a dialog where the the person getting the message is able to type back (which will make this job way easier.) This job will NOT involve an interface to enter a message to someone. It is only the part that checks a server side CFML file from a web page every few seconds using JQuery. The CFML file checks a table based on the UserID of the personal logged in. If it finds a record, then JQuery pops up the message box to the user. That's really it. Attached is a DOC with more detailed specs. ## Deliverables I have a CFML based custom CRM used by several agents in a call center environment. I need someone to program me a small script based off of any JQuery library. 1. Ping (check or run) a CFM server file every five seconds (need parameter to change this time frame) to see if there is a "instant message" record in the database table for the particular user that has a CRM page open in a browser. 2. Display a CSS layer popup prominently to the user with the message from the table record (along with a close button and an X in the upper corner to close it out.) 3. When record for the message is queried for the display window, that record must be updated (a bit set to true) that the message has been displayed (so it isn't displayed agin. 4. This code should run "silently" in the page and cannot disrupt any other JavaScript functions on the page (mostly form validation scripts.) 5. Even after a message has popped and been closed on one page load, another message needs to be able to come up. In other words I want to make sure the script won't just function one time per page load. 6. Also the message must popup front and center in the browser regardless of where their scroller is on the long page. In other words, if they are scrolled down to the bottom of a long page, the message box can't show up at the top where they can't see it (I have seen that kind of thing before with CSS layer boxes.) **Example Senerio for Script:** *"An agent in a call center has been sitting around a while not making any calls and is just staring at his CRM screen in his IE browser. Instead of the supervisor getting up and walking to his desk, he is going to drop a message record in a table with that agent's UserID to tell him to 'Get Back to Work.' Even though the agent has his browser screen dormant for several minutes, a message gets displayed to him to 'Get Back to Work.' He closes the message box and gets back to work"* The only part this job bid will be for is the JQuery part that pings or polls the CFML server file and that displays the message. I have provided with table structure and the only two queries it will need to run. The CFML part should only be a hand full of lines of code, very small and easy. I will be doing the admin interface myself that inserts the records. Your JQuery "ping" script that I put in the CRM page will need to have a place where I can pass in the "UserID" that will be used to query the table: SELECT AgentAlertID, Message FROM AgentAlert WHERE DisplayToUserID = #UserID# AND Displayed = 0 When that returns you a record you need to popup the "Message" to the user. At some point it will run an update using the primary key returned from the above query "AgentAlertID" UPDATE AgentAlert SET Displayed = 1 WHERE AgentAlertID = # AgentAlertID # It is that easy. Below is a MS SQL create statement of the table I will be using. If you don't have access to MS SQL, your database can be MySQL or Access. CREATE TABLE [dbo].[AgentAlert]( [AgentAlertID] [int] IDENTITY(1,1) NOT NULL, [DisplayToUserID] [int] NOT NULL, [MessageFromUserID] [int] NOT NULL, [Message] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [EnterDate] [datetime] NULL, [Displayed] [bit] NOT NULL CONSTRAINT [DF_AgentAlert_Displayed] DEFAULT ((0)), CONSTRAINT [PK_AgentAlert] PRIMARY KEY CLUSTERED ( [AgentAlertID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]