function down_grade()
{
//查询考卷成绩
$tb_tester = new IModel("tester");
$tb_paper = new IModel('paper');
$tb_exam = new IModel("exam");
$tb_group = new IModel('group');
$exam_info = $tb_exam->query("Eischeck <> 0");
$name = date('Ymd')."成绩汇总.xls";
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:attachment;filename=".$name);
$tx="姓名\t隶属部门\t试卷名称\t提交时间\t得分\t联系电话\n";
echo $tx;
foreach($exam_info as $exam)
{
$tester = $tb_tester->getObj('ID='.$exam['Etesterid']);
$paper = $tb_paper->getObj('ID='.$exam['Epaperid']);
$group = $tb_group->getObj('ID='.$tester['Tgroupid']);
echo $tester['Tname']."\t".$group['Ggroupname']."\t";
echo $paper['Ppapername']."\t";
echo $exam['Esubmittime']."\t".$exam['Egrades']."\t";
echo $tester['Tmobile']."\n";
}
}
php导出数据excel
最新推荐文章于 2024-06-26 13:16:08 发布