/**
* Return all valid campaign member codes
* the field campaignMemberCode in mmforetag and startdatum > today - 5 weeks
* see: pages/foretag_kampanj.php
* Krillo 12-07-24
*
* @global type $db
* @return array of valid codes and their companyid
*/
public static function getValidCampaignMemberCodes()
{
global $db;
$jDate = new JDate();
$validDate = $jDate->subWeeks(self::DEFAULT_NO_WEEKS)->getDate();
$sql = "SELECT id, campaignMemberCode FROM mm_foretag WHERE campaignMemberCode IS NOT NULL AND campaignMemberCode != '' AND startdatum >= '{$validDate}'";
return $db->allValuesAsArray($sql);
}
