Untethering The Queue


Introduction


Purpose

The purpose of this document is to describe how the Untethering the Queue System will function and how it relates to existing services and systems.

  • What is Untethering the Queue?

It is a web service that allows the person in the queue to leave the premises but retain their place in the queue. This document presents a design specification for the system to manage queues of people who want to avoid standing in line and return when their queue number is approaching the head of the queue. The system can use either a mobile phone or a web browser to register.

  • How to develop Untethering the Queue?

It is based on extensions of Joomla and uses some of the VotApedia audience response system logic. Scripting language of Joomla is PHP, and the database is MySQL. Both PHP and MySQL are open source softwares.

Proposal for the Untethering the Queue

Click this link to preview the Proposal for Untethering the Queue.


Database Design


Entity Relationship Diagram

  • This is the database design for Queuing System

  • This is the new database design for Queuing System

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:
  1. First, a customer calls a premium number of the company to request a queue number.
  2. After the system receives a call, the system will process the call in the Process Queue. The Queue Call (customer phone number, premium number and time of call) will be saved in the Incoming Call and SMS table and automatically define a Customer ID. The Phone number will be saved in Phone number field, premium call in the Call No field and the time of call in Time field.
  3. Data in the Call No field will be used to search for the Company ID in the Company table. Upon obtaining the Company ID, it will be used to get the Company Business Operation System / Rules(Time Process, etc) in the Queue Rules Table.
  4. The ID Customer and ID Rules will be saved in the Queue List Table and will automatically be given a Queue Number. Queue Status will be set as default value which is 0 (where 1 indicates that the customer has been served). The Queue Info (Queue No and estimated time) will be sent back to the customer.
  5. The customer will be able to check the Queue status by sending a text message. In order to view said status, the message should consist of the ID number given by the system. The system will process the Customer ID in the in the SMS table and then, with the Customer ID, the System will check the status in the Queue List table.

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
Comments