try {
$sn_array = array();
for ($row = 1; $row <= $highestRow; $row++) {
$ary["sn"] = $sheet->getCellByColumnAndRow(0, $row)->getValue();
if (!empty($ary["sn"])) {
array_push($sn_array, $ary);
} else {
echo "<script>alert('第" . $row . "行資料不齊全'); location.href='index.php?page=award/edit';</script>";
exit;
}
}
} catch (Exception $e) {
// 若有錯誤就要回覆
echo "<script>alert('上傳文件格式不符'); location.href='index.php?page=award/edit';</script>";
exit;
}
include_once LIB_PATH . "Table/AwardSn.class.php";
$tb_award_sn = new AwardSn();
if (!empty($sn_array)) {
foreach ($sn_array as $key => $value) {
$affectedRow = $tb_award_sn->addAwardSn($param['stage'], $value["sn"], $param['account']);
if (empty($affectedRow)) {
echo "<script>alert('訊息儲存發生錯誤'); location.href='index.php?page=award/edit';</script>";
exit;
}
}
}
// 取得目前數量
$counts = $tb_award_sn->countAwardSnByStage($param['stage']);
echo "<script>alert('資料儲存完成，共" . $counts . "筆。'); location.href='index.php?page=award/list';</script>";
exit;
