Commissions Manager Release 1.3.0

Changelog

Type Description
New
Dynamic commissions based on the available performance levels per client (preview)
New
Dynamic commissions based on the available performance levels globally (preview)
New
Fixed commissions based on the available levels per client (preview)
New
New page that can be used to assign the new type of commissions (preview)
New
Reassign earnings and recurring subscriptions to different salespeople (preview 1, preview 2)
New
You can now find all earnings related to any recurring commission and and vice versa
New
Lot of new features and informations in the clientarea page
Improved
Infoboxes in Statistics page are now displayed in a better way
Improved
The module now automatically removes, if present, the sidebar from the frontend page
Improved
Many new mouseover tooltips that show additional informations
Improved
Improvements to CSS/HTML/jQuery
Improved
Improvements to language files
Improved
Loading indicator below Subscriptions table doesn't stop spinning. Now it does.
Improved
Manage Commissions and Earnings pages have been redesigned. Now they're more compact
Improved
Consequently also the front-end page has been redesigned
Improved
The script that calculates recurring commissions for entire accounts has been improved
Improved
Font-awesome is now included in the module
Improved
We have re-tested all previously test components to ensure that they still operate with all the new features
Changed
Small imperfection in the tpl file of clientarea
Changed
After so many releases, we decided to change the look of mouseover tooltips
Changed
We replaced javascript-based expand/collapse boxes with bootstrap
Changed
We replaced many images/icons with Fontawesome icons
Changed
The structure of tables used by the module in the database has been changed in order to support new features
Fixed
A conflict between 2 jQuery scripts was preventing mouseover hints from appearing in the back-end

Upgrade instructions

Steps Description
1 In this release we added an enormous amount of new features and we have also changed and improved several parts of the module therefore before you start updating it, please backup your database and the entire modules/addons/CommissionsManager directory.
2 Run this query from PHPMyAdmin to your WHMCS database:

ALTER TABLE `mod_cmautomatic` ADD `category` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `id`, ADD INDEX (`category`);
UPDATE `mod_cmautomatic` SET `category`='automatic';
CREATE TABLE IF NOT EXISTS `mod_cmgroups` (`id` int(11) NOT NULL AUTO_INCREMENT, `name` text CHARACTER SET utf8 NOT NULL, `color` varchar(6) CHARACTER SET utf8 NOT NULL, `type` varchar(255) CHARACTER SET utf8 NOT NULL, `escalation` decimal(10,2) NOT NULL, `per` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `percentage` decimal(10,2) DEFAULT NULL, `fixed` decimal(10,2) DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
3 The Italian translation is not yet included in the release