Commissions Manager Release 1.1.0

Changelog

Type Description
New
Full support for automatic-commissions
New
Create and configure automatic-commissions for products or groups of products (preview)
New
Define your group of salespeople that are allowed to use automatic-commissions (preview)
New
The module doesn't allow salespeople to receive commissions for their own orders
New
You can let your clients choose their sales representative from a new dedicated page of the clientarea (preview)
New
When your clients choose their sales representative, you can list them in a dropdown or in a search box (preview)
New
Everytime there's a new order that has been successfully paid, the module automatically verifies if there's also a commission to pay
New
When there's a commission to pay, the client is automatically redirected to a page from which he must specify, if applicable, his sales representative
New
You can now suspend, unsuspend and terminate existing recurring automatic-commissions massivelly in one click
New
Filter commissions by insertion type (manual or automatic)
Improved
The code of the navbar (HTML/CSS/jQuery) has been improved
Improved
Improved navigation between pages of the module
Changed
The colors of buttons (suspend, terminate, unsuspend etc.) now better reflect their purpose
Changed
Dedicated success message displayed when checking out commissions without creating a credit note
Changed
Many changes have been made to several template files in order to fully support new features
Changed
All the existing action hooks have been updated to work with all the new features of the module properly
Changed
The Activation and Deactivation functions have been updated in line with the new structure of the module in the database
Fixed
Removed big blocks of HTML in Manage Commissions, Earnings and Checkout template files. They were completely useless
Fixed
Small issues with jQuery scripts

Upgrade instructions

Steps Description
1 This is a major release so please backup your database and files before upgrading and immediately report us any bug you may encounter
2 Run this query from PHPMyAdmin to your WHMCS database:

INSERT INTO `tbladdonmodules` (`module`, `setting`, `value`) VALUES ('CommissionsManager', 'automaticcommissions', 'Enabled');
INSERT INTO `tbladdonmodules` (`module`, `setting`, `value`) VALUES ('CommissionsManager', 'salesreppromttype', 'select');
ALTER TABLE `mod_cmcommissions` ADD `insertion` TEXT NOT NULL AFTER `id`;
UPDATE `mod_cmcommissions` SET `insertion`='manual';
CREATE TABLE IF NOT EXISTS `mod_cmsalespeople` (`id` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `mod_cmautomatic` (`id` int(11) NOT NULL AUTO_INCREMENT, `relid` int(11) NOT NULL, `type` varchar(255) CHARACTER SET utf8 NOT NULL, `percentage` decimal(10,2) NOT NULL, `fixed` decimal(10,2) NOT NULL, `cycle` int(11) NOT NULL, `autorecalculate` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `gid` (`relid`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `mod_cmreferrals` (`id` int(11) NOT NULL AUTO_INCREMENT, `client` int(11) NOT NULL, `salesperson` int(11) NOT NULL, `invoiceid` int(11) NOT NULL, `status` varchar(255) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;