Complaint Tracker Upgraded

by Venkat January 14, 2010

written by Venkat January 14, 2010

Dear Users,

We have upgraded one of the most used Applications in ApartmentAdda – The Complaint Tracker.

Here is a brief summary of the upgrades that went in this release.

1. Register “On-behalf of” Complaints

The complaints that are raised by phone, or verbally – can now be registered in ApartmentAdda’s complaint tracking system by the helpdesk operator/estate manager. This enables the association members to track all the complaints online – in one place and get updates of the complaints in their Email Inbox. Also the residents themselves can track the complaint’s status online and also subscribe to the complaint update emails.

2. Granular SMS control

We have now given more granular mapping of SMS alerts to the complaint category owners. Also the text of complaint alert SMS now includes the flat details including intercom number – this enables the plumber, electricians etc. to attend to the complaints quickly without having to get back to the Maintenance Office.

3. Introducing Complaint Escalation

For each Complaint Category, the Association can set 3 levels of complaint escalation and the transition rules for the Escalation Levels. Complaint Escalation can be used effectively to monitor the efficiency of the staff and also to ensure that all complaints get serviced.

4. UI changes for viewing complaints

Now the Admin can filter complaints based on the category. Also with this release paging has been introduced for viewing closed complaints.

Enjoy!
ApartmentAdda Team

ALTER

ITABLE `adda_complaint_category`

ADD `cocategory_esc_no1` SMALLINT NOT NULL ,

ADD `cocategory_owner_id2` MEDIUMINT NOT NULL ,

ADD `cocategory_esc_no2` SMALLINT NOT NULL ,

ADD `cocategory_owner_id3` MEDIUMINT NOT NULL ,

ADD `cocategory_sms1` SMALLINT NOT NULL,

ADD `cocategory_sms2` SMALLINT NOT NULL ,

ADD `cocategory_sms3` SMALLINT NOT NULL;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 491 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 136 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 590 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 591 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1627 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1629 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1631 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1633 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1635 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1637 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1639 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1641 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1643 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1647 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1651 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1653 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1655 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1645 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1649 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1947 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1948 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1949 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1950 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1951 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1952 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 1953 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 5670 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 5549 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 5663 LIMIT 1;

DELETE FROM `adda_watch` WHERE `adda_watch`.`watch_id` = 5832 LIMIT 1;

Complaint Tracker Upgraded

You may also like