PHP后台隔5分钟发送email邮件

1.5分钟发送email，并且邮件内容为由html模板生成的table
while(1)
{
//ten minute
var_dump("check task, please don't close");

//send email
processDBData($db);

//process inventory state
processInventoryState($db,$tasks);

sleep(5*60);
}

//read table data from database
function processDBData($db)
{
$testplan_id = '';
$temp = '';
$TotalCaseNum = 0;
$projectName = '';

//check finished testplan table->tasks
$sql="SELECT TK.id,TK.send_email,TK.user_id,TK.build_id,TK.case_ids,TK.testplan_id,TK.flag,TK.total
from tasks AS TK WHERE current=total and flag='2' and ISNULL(send_email)";
$controlInfor = $db->get_recordset($sql);

if(null== $controlInfor)
{
return;
}


foreach($controlInfor as $key =>$item)
{
//open model html
$fModel = fopen("report.model","r");
if(null == $fModel)
{
var_dump("no model");
}

$Modelhandle = fread($fModel,filesize("report.model"));

$test_cases = $item['case_ids'];

//get total Num
$TotalCaseNum = (int)$item['total'];

//testplan table->testplan
//$sql = "SELECT notes,testproject_id FROM testplans WHERE id='{$item['testplan_id']}'";
$sql = "SELECT name from nodes_hierarchy WHERE id='{$item['testplan_id']}'";
$result = $db->get_recordset($sql);
$temp = str_replace("MODEL_TESLPLANE",$result[0]['name'],$Modelhandle);
$Modelhandle = $temp;

//product table->testprojects
$sql = "SELECT notes FROM testprojects WHERE id='{$result[0]['testproject_id']}'";
var_dump($sql);
$result = $db->get_recordset($sql);

$temp = str_replace("MODEL_PRODUCTNAME",$result[0]['notes'],$Modelhandle);
$Modelhandle = $temp;

//build table->builds
$sql = "SELECT DB.name FROM builds AS DB WHERE testplan_id='{$item['testplan_id']}' and id='{$item['build_id']}'";
$result = $db->get_recordset($sql);
var_dump($sql);
$temp = str_replace("MODEL_BUILD",$result[0]['name'],$Modelhandle);
$projectName = $result[0]['name'];
$Modelhandle = $temp;

//test result table->executions
$cases = explode(',',$test_cases);
$case_infor = get_ts_name_details($db,$cases);

//var_dump(sizeof($case_infor));

//process html testcase content nl2br()
//after the content added(table,body,html end flag)
var_dump($case_infor);

$BeforSuiteNam = "";
$successNum = 0;
$TESTNUM = 0;

//var_dump($case_infor);
//var_dump($case_infor);
foreach($case_infor as $k=>$case)
{
$Modelhandle = $temp;

if($case['tsuite_name'] != $BeforSuiteNam)
{
$Modelhandle = $temp . "{$case['tsuite_name']}";
$temp = $Modelhandle;
}


//cese name + importance + result
//var_dump(Integer.parseInt('c'));
//get success number
$sql="SELECT TK.id,TK.send_email,TK.user_id,TK.case_ids,TK.testplan_id,TK.flag,TK.total,TK.user_id from tasks AS TK WHERE current=total and flag='2'";

$controlInfor = $db->get_recordset($sql);

//set pass/fail information
//var_dump($case['status']);
$pass = 'p';
$finish ='c';

if(($case['status'])== $finish)//$TotalCaseNum
{
//set case information
$Modelhandle = $temp. "

{$case['name']}
{$case['importance']}
FINISH
";
}
else if($case['status'] == $pass)//$TotalCaseNum
{
$successNum++;
//set case information
$Modelhandle = $temp. "

{$case['name']}
{$case['importance']}
PASS
";
}
else
{
$Modelhandle = $temp. "

{$case['name']}
{$case['importance']}
FAIL
";
}

$temp = $Modelhandle;
$BeforSuiteNam = $case['tsuite_name'];
}

//set success number
//var_dump($TotalCaseNum);
//$TotalCaseNum
$temp = str_replace("MODEL_SUCCESS","{$successNum}/{$TotalCaseNum}",$Modelhandle);
$Modelhandle = $temp;

$temp = str_replace("MODEL_FAIL",($TotalCaseNum-$successNum)."/".$TotalCaseNum,$Modelhandle);
$Modelhandle = $temp;

//added html end sign
$Modelhandle = $temp . "