$emailObj = new Email();

$defaults = $emailObj->getSystemDefaultEmail();

$mail = new SugarPHPMailer();

$mail->setMailerForSystem();

$mail->From = $defaults['email'];

$mail->FromName = $defaults['name'];

$mail->ClearAllRecipients();

$mail->ClearReplyTos();

$mail->Subject=from_html($emailSubject);

$mail->Body=$emailBody;

$mail->AltBody=from_html($emailBody);

$mail->prepForOutbound();

foreach($emailsTo as &$value){

$mail->AddAddress($value);

}

if(@$mail->Send()){

}

global $sugar_config, $db;

$timeDate = new TimeDate();

$timeDateNow = $timeDate->getNow(true)->asDb();

$days_offset = 15;

$GLOBALS['log']->fatal("Checking Opportunities...");

$query = "select opportunities.id from opportunities

where opportunities.sales_stage != 'Closed Won'

and DATEDIFF(opportunities.date_modified,'".$timeDateNow."') < ".$days_offset."

and !opportunities.deleted";

$GLOBALS['log']->fatal("Query: ".$query);

$res = $db->query($query, true, 'Error: ');

while($row = $db->fetchByAssoc($res)){

$opportunity = new Opportunity();

if(!is_null($opportunity->retrieve($row['id']))){

$user = new User();

if(!is_null($user->retrieve($opportunity->assigned_user_id))){

$emailsTo = array();

$emailSubject = "Opportunity Alert";

$emailBody = "The following Opportunity has ".$days_offset." days without changes.<br /><br />

Name: ".$opportunity->name."<br />

Account: ".$opportunity->account_name."<br />

Amount: ".$opportunity->amount."<br />

Sales Stage: ".$opportunity->sales_stage."<br />

Date Close: ".$opportunity->date_closed."<br /><br />

You can see the opportunity here:<br />

<a href=\"".$sugar_config['site_url']."/index.php?module=Opportunities&action=DetailView&record=".$opportunity->id."\">".$opportunity->name."</a>";

$emailsTo[] = $user->email1;

SendEmail($emailsTo, $emailSubject, $emailBody);

}

}

}

$GLOBALS['log']->fatal("Opportunities checked");

return true;