public static function setProspectSale($campaign_id, $customer_id)
{
$db = SafeMySQL::getInstance();
$sql = "SELECT email_id\n FROM prospect_emails\n WHERE campaign_id = ?i\n\t\t\t\tAND customer_id = ?i";
$result = $db->getOne($sql, $campaign_id, $customer_id);
if (!empty($result)) {
// We've got a prospect email order
$prospectEmailModel = ProspectEmail::model()->fillFromDbPk($result);
// did this customer actually use the link in the email
if ($prospectEmailModel->isFlag('click')) {
$prospectEmailModel->addFlags('sale');
$prospectEmailModel->save();
//$prospectEmailModel->removeProspect(); // this is handled in the WS process
}
} else {
return false;
}
}
