<?php
require_once '../service/StudentInfoService.class.php';
require_once '../phpbean/StudentInfo.class.php';
require_once '../service/NationService.class.php';
$nationService = new NationService();
$zkzh = $_GET['zkzh'];
$studentInfoService = new StudentInfoService();
$studentInfo = $studentInfoService->GetStudentInfo($zkzh);
/*使用 JSON数据格式返回*/
header('Content-type: text/json;charset=utf-8');
echo "{zkzh:\"" . $studentInfo->getZkzh() . "\"";
echo ",name:\"" . $studentInfo->getName() . "\"";
echo ",sex:\"" . $studentInfo->getSex() . "\"";
echo ",kslb:\"" . $studentInfo->getKslb() . "\"";
echo ",zzmm:\"" . $studentInfo->getZzmm() . "\"";
echo ",nation:\"" . $nationService->GetNation($studentInfo->getNation())->getNationName() . "\"";
echo ",byxx:\"" . $studentInfo->getByxx() . "\"";
echo ",hkszd:\"" . $studentInfo->getHkszd() . "\"";
echo ",address:\"" . $studentInfo->getAddress() . "\"";
echo ",telephone:\"" . $studentInfo->getTelephone() . "\"";
echo ",zcxx:\"" . $studentInfo->getZcxx() . "\"";
echo ",cardNumber:\"" . $studentInfo->getCardNumber() . "\"";
echo ",xjh:\"" . $studentInfo->getXjh() . "\"";
echo ",gysznj:\"" . $studentInfo->getGysznj() . "\"";
echo ",gesznj:\"" . $studentInfo->getGesznj() . "\"";
echo ",gssznj:\"" . $studentInfo->getGssznj() . "\"";
echo ",memo:\"" . $studentInfo->getMemo() . "\"";
echo ",photo:\"" . $studentInfo->getPhoto() . "\"";
echo "}";
$objPHPExcel->getActiveSheet()->getStyle($i . '2')->getFont()->setBold(true);
// 加粗
}
//获取查询参数
$zkzh = !empty($_POST['zkzh']) ? $_POST['zkzh'] : "";
$name = !empty($_POST['name']) ? $_POST['name'] : "";
$kslb = !empty($_POST['kslb']) ? $_POST['kslb'] : "";
$nation = !empty($_POST['nation']) ? $_POST['nation'] : 0;
$byxx = !empty($_POST['byxx']) ? $_POST['byxx'] : "";
$hkszd = !empty($_POST['hkszd']) ? $_POST['hkszd'] : "";
$address = !empty($_POST['address']) ? $_POST['address'] : "";
$telephone = !empty($_POST['telephone']) ? $_POST['telephone'] : "";
$cardNumber = !empty($_POST['cardNumber']) ? $_POST['cardNumber'] : "";
$xjh = !empty($_POST['xjh']) ? $_POST['xjh'] : "";
//创建StudentInfoService实例
$studentInfoService = new StudentInfoService();
$studentInfoArray = $studentInfoService->QueryPrintStudentInfoInfo($zkzh, $name, $kslb, $nation, $byxx, $hkszd, $address, $telephone, $cardNumber, $xjh);
for ($i = 0; $i < count($studentInfoArray); $i++) {
$objPHPExcel->getActiveSheet()->getRowDimension($i + 3)->setRowHeight(50);
$studentInfo = $studentInfoArray[$i];
$objPHPExcel->getActiveSheet()->setCellValue('A' . ($i + 3), $studentInfo['zkzh']);
$objPHPExcel->getActiveSheet()->setCellValue('B' . ($i + 3), $studentInfo['name']);
$objPHPExcel->getActiveSheet()->setCellValue('C' . ($i + 3), $studentInfo['sex']);
$objPHPExcel->getActiveSheet()->setCellValue('D' . ($i + 3), $studentInfo['kslb']);
$objPHPExcel->getActiveSheet()->setCellValue('E' . ($i + 3), $studentInfo['zzmm']);
require_once '../service/NationService.class.php';
$nationService = new NationService();
$objPHPExcel->getActiveSheet()->setCellValue('F' . ($i + 3), $nationService->GetNation($studentInfo['nation'])->getnationName());
$objPHPExcel->getActiveSheet()->setCellValue('G' . ($i + 3), $studentInfo['byxx']);
$objPHPExcel->getActiveSheet()->setCellValue('H' . ($i + 3), $studentInfo['hkszd']);
$objPHPExcel->getActiveSheet()->setCellValue('I' . ($i + 3), $studentInfo['address']);