For event $var_thisDescription, last send is: $var_LastSendDate
Period is $var_thisRecPeriodDays days.
This event comes due on $var_SendOn
Today is $var_Today";
*/
if($var_SendOn <= $var_Today)
{
// get the names and email addresses for this lot
$GetID_sql = "
select col_ID
from tb_Deal
where col_Centre = '$var_thisCentre'
and col_Phase = '$var_thisPhase'
and col_Lot = '$var_thisLot'
and col_ActiveYN = 'Yes'
and col_Status not in ($varCancelledDealStatuses)
";
$GetID_myrow = mysql_fetch_array(mysql_query($GetID_sql));
$var_ID = $GetID_myrow['col_ID'];
$GetNames_sql = "
select col_Name1,
col_Name2
from tb_Worksheet
where col_ID = '$var_ID'
";
$GetNames_myrow = mysql_fetch_array(mysql_query($GetNames_sql));
$var_Name1 = $GetNames_myrow['col_Name1'];
$var_Name2 = $GetNames_myrow['col_Name2'];
$GetEmail_sql = "
select col_Email,
col_Email2
from tb_Prospect
where col_ID = '$var_ID'
";
$GetEmail_myrow = mysql_fetch_array(mysql_query($GetEmail_sql));
$var_Email = $GetEmail_myrow['col_Email'];
$var_Email2 = $GetEmail_myrow['col_Email2'];
if($var_Name1 && $var_Name2)
$var_theNames = "$var_Name1 and $var_Name2";
elseif($var_Name1 && !$var_Name2)
$var_theNames = $var_Name1;
elseif(!$var_Name1 && $var_Name2)
$var_theNames = $var_Name2;
if($var_Email && $var_Email2)
$var_SendTo = "$var_Email, $var_Email2";
elseif($var_Email && !$var_Email2)
$var_SendTo = $var_Email;
elseif($var_Email2 && !$var_Email)
$var_SendTo = $var_Email2;
$var_F_SendOn = date("l, F jS", strtotime($var_SendOn));
$var_S_SendOn = date("dMy", strtotime($var_SendOn));
echo "
$var_thisType To $var_thisCentre - $var_thisPhase - $var_thisLot Due on $var_S_SendOn
To:
From:
";
$var_SendItemNo++;
} // closes if sendon > today
} // closes while getting events
} // closes while getting lot data
}
// if we didn't successfully send
else
{
}
}
?>
