Detail for Each Table

• 'IncomingNumber' Table

Field	Type	Null	Default
CostumerID	Int(11)	Not Null
PhoneNumber	VarChar(20)		Null

• 'Company' Table
  

Field	Type	Null	Default
CompanyID	Int(11)	Not Null
CompanyName	VarChar(50)		Null
Adress	VarChar(100)		Null
PhoneNumberCompany	Varchar(20)		Null
CallID	Int(11)		Null
SMSID	Int(11)		Null

• 'QueueRule' Table

Field	Type	Null	Default
RuleID	Int(11)	Not Null
CompanyID	VarChar(50)		Null
Time Process	SmallInt		Null
RequiredSendSMS	TinyInt		0
SMSFormat	VarChar(10)		Null

• 'QueueList' Table

Field	Type	Null	Default
CustomerID	Int(11)	Not Null
RuleID	Int(11)		Null
QueueNo	Int(11)		Null
QueueStatus	TinyInt(4)		0
Time	TimeStamp		Null
QueueType	VarChar(5)		Null

• 'NumberCall' Table

Field	Type	Default
CallID	Int(11)	Null
CallNo	VarChar(20)	Null
Status	TinyInt	0

• 'NumberSMS' Table

Field	Type	Default
SMSID	Int(11)	Null
SMSNo	VarChar(20)	Null
Status	TinyInt	0

• 'IncomingCall_Log' Table

Field	Type	Default
ID	Int(11)	Null
PhoneNumber	VarChar(20)	Null
CallNo	VarChar(20)	Null
Time	Timestamp	Null

• 'IncomingSMS_Log' Table

Field	Type	Default
ID	Int(11)	Null
PhoneNumber	VarChar(20)	Null
SMSFormat	VarChar(20)	Null
Time	Timestamp	Null

• 'Registration' Table

Field	Type	Default
ID	Int(11)	Null
COmpanyName	VarChar(50)	Null
E-mail	VarChar(20)	Null
Reason	Text	Null

New Detail For Each Table

• company table
  

Field	Type	Null	Default
company_id	int(11)	Not Null
company_name	varchar(50)		Null
address	varchar(100)		Null
phone	varchar(20)		Null
time_zone	varchar(6)		Null
number_needed	tinyint(4)		Null
user_id	varchar(30)		Null

• numbercall table
  

Field	Type	Null	Default
call_id	int(11)	Not Null	Null
call_no	varchar(20)		Null

• numbersms table
  

Field	Type	Null	Default
sms_id	int(11)	Not Null	Null
sms_no	varchar(20)		Null

• queuelist table
  

Field	Type	Null	Default
id	int(11)	Not Null
rule_id	int(11)		Null
queue_number	int(11)		Null
queue_status	tinyint(4)		Null
date_time	timestamp		Null
queue_type	varchar(5)		Null
phone_number	varchar(32)		Null
ref_number	varchar(5)		Null

• queuerule table
  

Field	Type	Null	Default
rule_id	int(11)	Not Null
company_id	int(11)		Null
call_id	varchar(20)		Null
sms_id	varchar(20)		Null
sms_format	varchar(15)		Null
services	varchar(30)		Null
time_process	int(11)		Null
closequeuetime	time		Null
startqueuetime	time		Null
enc_id	varchar(50)		Null
enc_services	varchar(50)		Null
user_id	varchar(30)		Null

• errorcode table
  

Field	Type	Null	Default
error_code	tinyint(4)		Null
error_reason	varchar(100)		Null

• incomingcalllog table
  

Field	Type	Null	Default
id	int(11)	Not Null
phone_number	varchar(20)		Null
call_no	varchar(20)		Null
date_time	timestamp		Null
error_code	tinyint(4)		Null

• incomingsmslog table
  

Field	Type	Null	Default
id	int(11)	Not Null
phone_number	varchar(20)		Null
sms_format	varchar(20)		Null
sms_no	varchar(20)		Null
date_time	timestamp		Null
error_code	tinyint(4)		Null

• incomingweblog table
  

Field	Type	Null	Default
id	int(11)	Not Null
id_session	varchar(30)		Null
ip_address	varchar(15)		Null
date_time	timestamp		Null
error_code	tinyint(4)		Null

• m_time_zone table
  

Field	Type	Null	Default
time_zone	varchar(7)	Not Null	Null
desc_time	text	Not Null	Null

Data Flow Diagram

Design System

Diagram Context



Hierarchy Chart



Process to joining the Queue

Description:

1. First, the Company Administration files a request to the System Administrator in order to join the Queuing System. Subsequently, the System Administrator will give the password once the company has been allowed to join the system.
   
2. The company administrator must then fill in the company data and their business operation system so that it will support the queuing process.

Process Queue Management



Description:

Design Database

This is the first database design for the proposed Queuing System

Untethering the Queue Development Plan

The general development plan for the Untethering the Queue are as follows:

1. Making a DFD (data flow diagram), if required; a DFD is required if the main process of the software is complicated. For example: banking settlement is complicated, in this case DFD is required.
2. Making ERD; Target for this phase is database schema
3. User interface design for the company, the customer and the administrator.
4. Making CRC Modeling; Target for this phase is class construction and coding
5. Coding and integration for the whole component
6. Testing
7. Documentation: User’s guide, Technical guide
8. Maintenance

Discussion

• November, 6th 2008

1. Queue Up by Call can change into Premium Call (future development).

• November, 25th 2008

1. Make a button (with Flash/AS3) to access the queue from another site (not Queserv site). This button is embeddable, so it can be put on any company site.

• December, 4th 2008

1. Make a php file that produces an XML which include all of the services provided by a Company.

• December, 9th 2008

1. Do Complete testing on http://www.q.urremote.com.

• January, 20th 2008

1. Sometime failed/operation aborted , when we access http://www.q.urremote.com from Internet Explorer browser ver.7 or older.

• February, 5th 2009

Some issues with Queserv Services (from Jun Ma)

1. Maybe add a button that says “click to print queue ticket”. So I can print out a ticket with the queue number.

• February, 9th 2009

1. WEB Services link in Main Menu of www.q.urremote.com doesn't work perfectly.
2. Link icon for print and email on every articles doesn't work.
3. Make a page that able to display a person who already queue up by inputting their Reference Number. This is to give info to person who wants to see his condition in a queue e.g: Place of Queue Number and Estimation Time.

• February, 10th 2009

1. Function Add new company and Edit Company on Company Manager(Administrator Page) not working yet.

Done

• November, 4th 2008

1. Problem in queueprocess.php. Currently a new place in the queue is reserved every time the browser is refreshed. This will be stopped through the use of session cookies. - by baguz

• November, 5th 2008

1. Time estimation, for example : queue number 1, 2 and 3 calculate with time process each of company. For the next number 4, 5, 6, ... will calculate base on the time for serve queue number 1, 2 and 3. - by baguz

• November, 6th 2008

1. Make Administrator (of Queserv) able to edit the details of all Companies. - by baguz

• November, 11th 2008

1. Make Testuser, who has the same privileges as that of Knownuser, a default for all new accounts. - by baguz
2. Info queuing more detail with content : total queue, queue now in process and time estimation. - by baguz

• November, 12th 2008

1. Update sentence "sorry no enough number" be "sorry not enough phone numbers available" when the phone number on the system is not available. - by adis
2. A bug appeared in Phone Number on the Register Company page, char "space" become "+" (plus) - by adis
3. Change the information message and every message must have a reference number. - by gus arik

• November, 13th 2008

1. Company could create a new service (add service). - by baguz

• November, 14th 2008

1. Create delete function and button in the edit company details and service company details form page; can only be accessed by the administrator and the owner of the company. - by baguz
2. Add more service button in edit company form. - by baguz
3. Add information and photo on About Us Page - by adis
4. Set Company Detail page that is accessible only by the admin, owner, and services privilege event through the 'id' on url change manually. - by dodok
5. Change first paragraph on page About Queserv. - by adis
6. Copy Queserv file to SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by baguz
7. Fix message after next queue - by adi sukendra

• November, 17th 2008

1. Add 'Cancel' button on company's form and services form (edit, insert and detail form). - by baguz

• November, 18th 2008

1. Error in Close Queue Time when user add new service in Company Detail. - by baguz
2. Bug in list number of Service Registered. - by baguz

• November, 19th 2008

1. Repair flash on the page About Queserv. - by dodok

• November, 20th 2008

1. Add field time zone to database thequeue table company. - by adis
2. Repair position of article in front page of Queserv if there are more than one article. (currently, the article crosscut in the right). - by baguz
3. Add field time zone to company register form. - by baguz
4. Update database (add m_time_zone table).

• November, 24th 2008

1. Make a Service Manager page that can only be accessed by administrator. This page is used to add and remove which user can be an administrator of a service. - by Dodok

• November, 25th 2008

1. Add information about time zone company to info queuing on the web and replay sms. - by riza
2. Put the stable version of Queserv in www.vote.urremote.com. - by baguz

• November, 27th 2008

1. Manage time in information, check startqueuetime and closequeuetime in querule table according to the local time of a company, so the information provided will be in terms of the time zone of the customer. - by baguz
2. If we choose to update services, encoding services on table queuerule is not updated yet. by baguz

• December, 2nd 2008

1. In Edit Company Details, Cancel button is not effective if the result is coming back to home page. - by baguz
2. 'Back' button on browser is not effective in 'insert more company', there is still a change on database. - by baguz
3. Repair table M_Time_Zone on thequeue database - by baguz
4. There is a problem on insert a new company, to be exact on the time zone. An error occured on time zone display when we choose the 0000 zone. - by baguz

• December, 3rd 2008

1. Update new code to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by baguz

• December, 4th 2008

1. Currently it requires several actions to get next the number of queue for the same service. Change it to a single click so the ownner does not need to reset if the next queue is from the same service. - by baguz
2. Access company detail didn't run well when accessed by user who is not the owner of the company but had privilege of the service because in field user_id on queuerule table there is a comma (,). - by baguz
3. Update Queserv on www.vote.urremote.com - by adis

• December, 5th 2008

1. Make a specific next queue for those who are not the owner of a company but have privilege to make the next queue for the services. - by adi sukendra
2. Update new code (cbbox.php & nextqueue.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by adi sukendra
3. Update Queserv new code (cbbox.php & nextqueue.php) to www.vote.urremote.com - by adi sukendra
4. Under construction for Main Page of Queserv. - by adis

• December, 9th 2008

1. Modified the Save button on form Insert Service, so that after a user has finished inserting their company details and presses the button, he becomes a Registered User. - by adi sukendra

• December, 10th 2008

1. Make a specific queueprocess.php for queuing by call and by SMS and put the file in queserv directory. - by baguz
2. Update code (com_queserv & queserv) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by baguz

• December, 12rd 2008

1. Fix double time-zone in menu detail company. - by baguz
2. Change name Queue Register become Company Register. - by adi sukendra

• December, 15th 2008

1. Set one number of Votapedia's number to be used in Queserv's "queue up by SMS". Then make a script in Votapedia that can send all of the SMS (which come to the set number) to Queserv. In Queserv, a script will select the SMS by SMS rule for each company. - by riza
2. Add untethering the queue software to Linux machine(http://www.vote.urremote.com). - by riza
3. From now, Queserv just provide one SMS number for all company. If a company want to buy their own number, they must buy. - by riza
4. Send all SMS from VotApedia to Queserv, and filter them by SMS format that appear on Queserv's Database.
5. Update joomla (template for queserv system) version 1.54 to version 1.58 for security issue - by baguz

• December, 18th 2008

1. Make automatic refresh for module "Last 5 queues info" when database changes. - by baguz
2. Update Queserv new code (module mod_queueinfo) and add new file default.php on folder "Queserv" to www.vote.urremote.com - by baguz

• December, 24rd 2008

1. Make logic and add to "Company Register" form page to Give choice for a Company Owner to use service only by call or SMS or both of them. - by baguz
2. add New Field "service_by" on table thequeue.company.- by baguz
3. Update Queserv new code (QueueDAO.php, QueueVO.php, controler.php, folder regcompany, folder report) to www.vote.urremote.com - by baguz

• December, 26th 2008

1. fix on company update page to use service by call or SMS or both of them and add logic in order to automatically get the different number when company updates from by sms to by call or by sms to by sms and call .- by baguz
2. Update Queserv new code (QueueDAO.php, QueueVO.php, controler.php, folder detail, folder report) to www.vote.urremote.com - by baguz

• December, 31th 2008

1. In Edit Company Details, make a Confirm Message before deleting a company(controller.php,details.php,servicedetails.php).- by riza

• January, 12rd 2009

1. Fix Register Company in Queserv, (problem was fixed : If we choose service By call, we can't save the information about that service and we will see the message "SMS Format Already Exists, Please Choose different SMS Format"). - by baguz

• January, 13rd 2009

1. Update to the repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk). - by baguz

• January, 19th 2009

1. Fix error "Error: Sorry, the user was not found" if we sent an email to administrator to activate our account (change the the link in file companyform.php, from admin be queadmin08). - by adis
2. Change email content will send to our email if we create an account in www.vote.urremote.com (configuration.php($tmp_path, $ftp_user, $form_name, $sitename) and setting configuration for email in administrator site). - by adis

• January, 21st 2009

1. Fix Form Email Page to administrator and link on "Administrator" on Company Register (for usertype : registered only). - by baguz
2. Update Queserv new code (folder regcompany, folder com_messaging) to www.vote.urremote.com - by baguz
3. Update new code (folder regcompany, folder com_messaging) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by baguz
4. Change name of Super Administrator from Baguz Kerthyayana to be Administrator Of Queserv on database - by baguz
5. Update new database to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk). - by adi sukendra
6. Edit "New Detail For Each Table" and make new page for "Proposal for the Untethering the Queue" (on www.urremote.com). - by adi sukendra

• January, 30 2009

1. Change privilege configuration.php on www.vote.urremote.com in permission, so the owner, group and other can write. - by adis
2. Edit file sendmessage.php in mod_jms_support, so when user want to get information, they can click on 'admin' and go to chat. - by adis

• Febuary, 2nd 2009

1. DNS for vote.urremote.com changed into q.urremote.com. q.urremote.com will be the primary DNS for queue system henceforth. - by riza

• February, 3rd 2009

1. Edit configuration.php in www.q.urremote.com ($fromname, $sitename). - by adis
2. Remove AIM in Support Online on Queserv page. - by adis
3. Update web services server and client file (folder queserv) to make the host become dynamic. - by gus arik
4. Update QueueDAO and QueueVO files (folder queserv) for supporting webservice server and client files. - by gus arik
5. Upload both web service server and client files to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik
6. Make input form for web server client file (folder queserv) to make dynamic webservice client. - by gus arik

• February, 4th 2009

1. Upload form for web server client file to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik
2. Add "Contact Us" page to main menu of q.urremote.com. - by gus arik
3. Update new code (folder com_messaging) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik

• February, 5rd 2009

1. Update nextqueue module, adding encoding and decoding system for security reason. - by riza
2. Update new nextqueue module to repository SVN and to q.urremote.com. - by riza
3. Update QueueDAO file(folder queserv) to support 'Total Queue' and 'Queue No in Process' column in Queue Services Information. - gus arik
4. Changing the Queue Services Information page for column 'SMS No. For Queue' to 'SMS to Queue' and adding 'Total Queue', 'Queue No in Process' column. - by gus arik
5. Update new code (folder com_queserv) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik
6. Changing the queueprocess.php on (folder com_queserv\com_queserv\views\information\tmpl\queueprocess.php), if click “Queue Now” again, will display your queue number, date of queue, and reference number. - by adi sukendra
7. Update new code (folder com_queserv\com_queserv\views\information\tmpl\queueprocess.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by adi sukendra

• February, 6rd 2009

1. Change "About Queserv logo". note : When adding logo/banner, make sure the img width and height is as same as image size, that's one problem that make image doesn't look good (unjustified scaling). if we want to transform (scaling) "image's display", please transform the image first - by dodok
2. Update new code (folder modules/mod_jms_support/sendmessage.php) and database(joomla.sql and joomlaPHPmyadmin.sql) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by adis
3. Update database joomla for supporting the 'Contact Us' menu to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik
4. Changing the queueprocess.php on (folder com_queserv\com_queserv\views\information\tmpl\queueprocess.php). Explain the refrence number, Changed the time saved in the database so that it is according to the time zone of the company's choice. - by adi sukendra
5. Update new code (folder com_queserv\com_queserv\views\information\tmpl\queueprocess.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by adi sukendra
6. Explain about the Reference number in FAQ - by adi sukendra.

• February, 9th 2009

1. Insert new link (WEB Services) in Main Menu for support web services. - by gus arik
2. Reset queue time for call and SMS fix. - by baguz
3. Update new code (folder "com_queserv\com_queserv\views\information\tmpl\queueprocess.php" and "queserv\queueprocess.php") to www.q.urremote.com - by baguz

• February, 10th 2009

1. Edit directlink in Contact Us's page for submit button for guest to Contact Us's page. - by gus arik
2. Update new code (folder "\components\com_messaging\controllers\message.php") to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik
3. Hide icon print and email on article because not working yet. - by baguz
4. Update QueueDAO.php and QueueVO.php, adjust code within company time and create new function ( findQueueListByRuleID, findQueueListByRuleIDBaseDateNow, findQueueListByRefNum, GetDateTimeCompanyBaseGMT ). - by riza
5. Update sentence "Your place in the queue is Queue Number" be "Your position is Queue Number of Total Queue in the queue" (component\com_queserv\views\information\tmpl\queueprocess.php) and edit content message for queuing by call and SMS (folder queueserv\queueprocess.php) - by adis
6. Add New Component(com_company) on administrator page to manage company (add new, edit delete, search) - by baguz
7. modify configuration.php and Library and add all new code to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) and www.q.urremote.com - by baguz

• February, 11st 2009

1. Edit queueproccess.php(component\com_queserv\views\information\tmpl\queueprocess.php), queueproccess.php(/queuserv/queueproccess.php)and QueueDAO.php add "0" if hours below 10. - by riza

• February, 16th 2009

1. Fix the problem for the reset queueing on previous day. by baguz
2. Update script on queueproces.php(component\com_queserv\views\information\tmpl\queueprocess.php). add update queuelist reset script and add "0" if miniute below 10. - by baguz
3. Fix Offset value on queueproces.php(component\com_queserv\views\information\tmpl\queueprocess.php and queserv\queueprocess.php) with doing check "isset variable offset" - by baguz
4. Update queueproces.php(component\com_queserv\views\information\tmpl\queueprocess.php and queserv\queueprocess.php) to www.q.urremote.com - by baguz

• February, 17th 2009

1. Fix logic to get the date local company and date GMT to calculate the estimate time by web (queueproces.php(component\com_queserv\views\information\tmpl\queueprocess.php) - by baguz
2. Add new field "antri" on table "queuerule" to save the session value of variable "antri".
3. Change $_SESSION['antri'] to $hslrule['antri'] to set the constant variable "antri" to database, and add script update
4. Update queueproces.php(component\com_queserv\views\information\tmpl\queueprocess.php) - by baguz

• February, 20th 2009

1. Add Admin Company Manager Page fix - by baguz
2. add com_company (Administrator/components), edit index.php (administrator/), add folder queserv (administrator/), update QueDAO.php and QueVO.php (administrator/queserv) - by baguz
3. update queprocess.php for call and sms (queserv/) and queprocess.php for web (component\com_queserv\views\information\tmpl\) - by baguz
4. Add new field "date_registered" to table "company" that use to check date owned by testuser user previlages - by baguz

• February, 23rd 2009

1. Add module mod_refnum for check queue number by input the reference number on the website -by adis
2. Fix mod_refnum for reference number - by baguz
3. Create logic to delete company and service that own by testuser after pass two days from date on field "register_date" (queserv/testuser.php) - by baguz

• February, 24th 2009

1. Create Print button on Information Queuing page - by baguz
2. Add new file print.php on htdocs(queserv) to made new page before print the information - by baguz

• February, 25th 2009

1. Add new code for setting and getting value for encrypted ID in QueueVO.php(folder queserv). - by gus arik.
2. Update new code (folder queserv) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• March, 06th 2009

1. Update nusoapserver.php (folder queserv) fixing detail queues for each service. - by gus arik.
2. Update new code (folder queserv) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• March, 27th 2009

1. Change ID for YM and Skype in Module Support Online. - by adis

• April, 20th 2009

1. Change email address on Contact Us's page in www.q.urremote.com (folder components\com_messaging\views\message\tmpl\default.php) - by gus arik.
2. Update new code (folder components\com_messaging\views\message\tmpl\default.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.
3. Make exception process on WEBServices's page (folder queserv\helloclient.php) - by gus arik.
4. Update new code (folder queserv\helloclient.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• April, 21st 2009

1. Update new code for supporting web services (folder queserv\helloclient.php) - by gus arik.
2. Update new code (folder queserv\helloclient.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.
3. Create new folder named "webservices" (folder components\com_queserv\views) for supporting webservices - by gus arik.
4. Create new folder "webservices" (folder queserv\helloclient.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.
5. Update joomla's database for supporting webservices - by gus arik.
6. Update joomla's database (folder database) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• May, 19th 2009

1. Create new folder named "lib" (folder queserv) for supporting webservices - by gus arik.
2. Update new code (folder queserv\helloclient.php) and (folder queserv\nusoapserver.php) for supporting webservices - by gus arik.
3. Delete file nusoap.php (folder queserv) because it's the older version, the newer version located in folder "queserv\lib" - by gus arik.

• May, 20th 2009

1. Create new folder named "lib" (folder queserv) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.
2. Update new code (folder queserv\helloclient.php) and (folder queserv\nusoapserver.php)to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.
3. Delete file nusoap.php (folder queserv) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• May, 25th 2009

1. Update new code (folder queserv\nusoapserver.php) to show addition informations such as company name, company phone etc on webservices's page - by gus arik.
2. Update new code (folder queserv\nusoapserver.php)to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• May, 26th 2009

1. Update new code (folder queserv\nusoapserver.php) to show addition informations such as number of services (1,2,3 etc) on webservices's page - by gus arik.
2. Update new code (folder queserv\nusoapserver.php)to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• June, 03rd 2009

1. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) for new reference number pattern - by gus arik.
2. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• June, 04rd 2009

1. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) to remove '00' format in reference number's pattern - by gus arik.
2. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• June, 05rd 2009

1. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) for new pattern of reference number and adding function to validate reference number to avoid duplicated reference number. - by gus arik.
2. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• June, 10th 2009

1. Update new code (folder components\com_queserv\views\information\tmpl\queueprocess.php) to Customize Reference number's font size on web Display - by gus arik.
2. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

• June, 11th 2009

1. update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) to fix vowels problem in reference number pattern - by gus arik.
2. Update new code (folder queserv\queueprocess.php) and (folder components\com_queserv\views\information\tmpl\queueprocess.php) to repository SVN folder (https://svnserv.csiro.au/svn/VirtualWorldRockBreaker/queserv/trunk) - by gus arik.

Definitions, Acronyms, and Abbreviations

ERD Entity Relationship Diagram CRC Class Responsibility Collaborator DFD Data Flow Diagram

• CSIRO Commonwealth Science and Industry Research Organisation
• ICT CSIRO Information and Communication Technologies
• SMS Short Messaging Service
• IVR Interactive Voice Response
• PSTN Public Switched Telephone Network
• PABX Private Automated Branch Exchange
• SQL Structure Query Language
• COM Component Object Model
• VB Microsoft’s Visual Basic programming language