The background sends emails every 5 minutes, and the email content is html.

";
$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. "




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




";
}
else
{
$Modelhandle = $temp. "




";
}

$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 . "

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']}
{$case['name']}	{$case['importance']}	FINISH
{$case['name']}	{$case['importance']}	PASS
{$case['name']}	{$case['importance']}	FAIL