private function addUserInCommissionGroup($commissionGroupId, $userId, $status) {
$userInCommissionGroup = new Pap_Db_UserInCommissionGroup();
$userInCommissionGroup->setCommissionGroupId($commissionGroupId);
$userInCommissionGroup->setUserId($userId);
$userInCommissionGroup->setStatus($status);
$userInCommissionGroup->setDateAdded(Gpf_Common_DateUtils::getDateTime(time()));
$userInCommissionGroup->save();
}
protected function migrateUsersInCampaigns() {
Pap3Compatibility_Migration_OutputWriter::log(" Migrating users in campaigns.....");
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('*');
$selectBuilder->from->add('wd_pa_affiliatescampaigns');
$count = 0;
foreach($selectBuilder->getAllRowsIterator() as $record) {
if($record->get('affiliateid') == '' || $record->get('campcategoryid') == '') {
continue;
}
$count++;
try {
$obj = new Pap_Db_UserInCommissionGroup();
$obj->setUserId($record->get('affiliateid'));
$obj->setCommissionGroupId($record->get('campcategoryid'));
$obj->setStatus(Pap3Compatibility_Migration_Pap3Constants::translateStatus($record->get('rstatus')));
$obj->setDateAdded(Gpf_Common_DateUtils::now());
$obj->save();
} catch(Gpf_Exception $e) {
// non important error, don't display it
}
}
Pap3Compatibility_Migration_OutputWriter::log(" ($count) ..... DONE<br/>");
}