"0") {
$result = mysql_query($sql);
while ($getthis <= $getrow)
{
$baseid = mysql_result($result,$getthis,"baseid");
$id = mysql_result($result,$getthis,"id");
$first = mysql_result($result,$getthis,"first_name");
$last = mysql_result($result,$getthis,"last_name");
$account_type = mysql_result($result,$getthis,"account_type");
$agreement_date = mysql_result($result,$getthis,"agreement_date");
$fee_paid = mysql_result($result,$getthis,"fee_paid");
$last_value = mysql_result($result,$getthis,"last_value");
$next_bill = mysql_result($result,$getthis,"next_bill");
$received = mysql_result($result,$getthis,"received");
$account_number = mysql_result($result,$getthis,"account_number");
$current_bill = mysql_result($result,$getthis,"current_bill");
$account_name = mysql_result($result,$getthis,"account_name");
$solicitor = mysql_result($result,$getthis,"solicitor");
$eq = mysql_result($result,$getthis,"eq");
# echo "ACT: $account_number $first $last
";
$account_number = ereg_replace("[^A-Za-z0-9]", "", $account_number);
$getthis++;
# I NOW HAVE THE ACT NUMBER AND ALL THE CLIENT DATA, NEXT LETS SEE IF THEY HAVE MONEY TO INVEST.
# NOW YOU MUST HAVE A | DELIMITED FILE WITH 6 columns 1 = act #, 2= | 3 = shares to buy 4=| 5 = rounded dollars to buy 6 = | in the first 6 columns
# you do this by creating your memoranda as normal but having the first 6 hidden columns have a formula that copies the aropriate data
# to each of them so that you endup with ACT NUM then | then SHARES TO BUY then | then ROUNDED DOWN DOLLARS (to nearest 100) to buy thyen |
# then copy those 6 columns (starting at the row of the viry first act number) to a plain text file. (the data file)
$lines = file($datafile);
$lastline= count($lines);
# echo "LAST LINE $lastline
";;
foreach ($lines as $line_num => $line) {
$line = ereg_replace("[^A-Za-z0-9 |]", "", $line);
$pieces = explode("|", $line);
#echo $pieces[0]; // piece1
#echo "
SYMBOL!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!";
#echo $pieces[1]; // piece2
#echo "
";
#echo $pieces[2]; // piece2
#echo "
";
if($pieces[0] == $account_number && $pieces[2] > 0)
{
if ($currentclnum != $id)
{
#SEND THE EMAIL TO THE PREVIOUSE CLIENT
if ($currentclnum != "0")
{
echo "EMAILING client $currentlname This
$store
";
}
$account_show = $account_number;
$account_show = substr($account_show, 5, 4);
#echo "@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
";
#echo $account_show;
#echo "@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
";
$account_show = "#####$account_show";
$part3=number_format($pieces[3]);
$store = "";
$br="\r\n";
$br2="
";
$store = "In account number $account_number ($account_name) buy $pieces[2] shares of $pieces[1] for about $$part3 dollars assuming a price of $$cprice (this is an actively traded security and your purchase price may vary). This will be a limit order at $$tprice therefore we will not buy shares if the share price is above $$tprice.";
$store = "$store$br$br2$br2";
$currentclnum = $id;
$currentlname = $last;
//echo $store;
//echo "NEW!!!!!!!!!!!!!!!!!
";
}
else
{
$part3=number_format($pieces[3]);
$br="\r\n";
$store = "$store In account number $account_number ($account_name) buy $pieces[2] shares of $pieces[1] for about $$part3 dollars assuming a price of $$cprice (this is an actively traded security and your purchase price may vary). This will be a limit order at $$tprice therefore we will not buy shares if the share price is above $$tprice.";
$store = "$store$br$br2$br2";
//echo $store;
//echo "SAME!!!!!!!!!!!!!!!!!
";
}
# echo "BUY $pieces[2] shares for about $$part3 dollars
";
} # end if($pieces[0] == $account_number)
} # end foreach ($lines as $line_num => $line)
} # wend of while ($getthis <= $getrow)
echo "EMAILING client $currentlname This
$store
";
}
else
{
echo "No records found";
} # end of main loop
} # end of if ($control == 1)
?>