console
<!DOCTYPE html>
<html lang="zh">
<head>
<meta charset="UTF-8">
<title>抗肿瘤药事业部2025体检信息填报</title>
<style>
table { border-collapse: collapse; width: 100%; font-size: 15px;}
th, td { border: 1px solid #ccc; padding: 4px 8px; }
th { background: #e6f7ff; }
.self { background: #fffbe6; }
select,input { width: 98%; }
@media (max-width: 600px) {
table, thead, tbody, th, td, tr { font-size: 12px; }
}
</style>
<script src="https://cdn.sheetjs.com/xlsx-0.20.3/package/dist/xlsx.full.min.js"></script>
</head>
<body>
<h2>抗肿瘤药事业部2025体检信息填报</h2>
<p>
当前登录人姓名:
<select id="userSelect"></select>
<button onclick="exportExcel()">导出全体名单</button>
</p>
<div id="tableDiv"></div>
<script>
const data = [
[668, "多恩达销售公司", "市场部-代小静", "区域市场", "卢格娇", "女", 31, "13570232089", "441225199308072927", "2022-07-01", "在岗", "广东省广州市", "未婚", "", "", ""],
[725, "多恩达销售公司", "南部大区-刘永", "南部大区-刘永", "刘永", "男", 43, "18927503508", "320322198111105952", "2015-10-14", "在岗", "广东省广州市", "已婚", "", "", ""],
[726, "多恩达销售公司", "南部大区-刘永", "广东一办-林妙坤", "陈志燕", "女", 33, "15057943553", "362323199110166569", "2021-11-15", "在岗", "广东省佛山市", "已婚", "", "", ""],
[727, "多恩达销售公司", "南部大区-刘永", "广东一办-林妙坤", "袁大彪", "男", 35, "18789278744", "421023199004207514", "2022-08-05", "在岗", "海南省海口市", "已婚", "", "", ""],
[728, "多恩达销售公司", "南部大区-刘永", "广东一办-林妙坤", "黄嘉欣", "女", 25, "18307634821", "441882199911235727", "2022-09-07", "在岗", "广东省广州市", "未婚", "", "", ""],
[729, "多恩达销售公司", "南部大区-刘永", "广东一办-林妙坤", "赖焕明", "男", 33, "13823808764", "441421199203051113", "2023-07-15", "在岗", "广东省广州市", "未婚", "", "", ""],
[730, "多恩达销售公司", "南部大区-刘永", "广东一办-林妙坤", "于海洋", "男", 34, "18813295096", "341222199007282952", "2023-11-09", "在岗", "广东省广州市", "已婚", "", "", ""],
[731, "多恩达销售公司", "南部大区-刘永", "广东一办-林妙坤", "袁令", "女", 23, "18883515344", "500235200204106946", "2024-04-30", "在岗", "广东省广州市", "未婚", "", "", ""],
[732, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "杨文超", "男", 36, "13250172140", "445222198808243358", "2018-08-01", "在岗", "广东省广州市", "已婚", "", "", ""],
[733, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "缪飞", "女", 23, "13907991493", "36032220010718056X", "2024-07-09", "在岗", "广东省广州市", "未婚", "", "", ""],
[734, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "杨学柳", "女", 36, "13922272030", "440923198808061247", "2021-10-01", "在岗", "广东省广州市", "已婚", "", "", ""],
[735, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "包海瑞", "男", 31, "13960825891", "371322199306300015", "2023-11-17", "在岗", "广东省深圳市", "已婚", "", "", ""],
[736, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "梁翠珍", "女", 30, "18688088755", "440881199505241649", "2024-06-18", "在岗", "广东省湛江市", "未婚", "", "", ""],
[737, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "叶丽冰", "女", 29, "18244941102", "445221199512234581", "2024-02-04", "在岗", "广东省广州市", "未婚", "", "", ""],
[738, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "严晨蕾", "女", 25, "19129210052", "440903200005240027", "2024-07-01", "在岗", "广东省广州市", "未婚", "", "", ""],
[739, "多恩达销售公司", "南部大区-刘永", "广东二办-杨学柳", "洪伟强", "男", 29, "15626233647", "450481199507181053", "2024-07-22", "在岗", "广东省广州市", "已婚", "", "", ""],
[740, "多恩达销售公司", "南部大区-刘永", "四川办事处-冯佩轩", "吴小青", "女", 29, "18213070671", "622722199508022046", "2024-02-01", "在岗", "云南省昆明市", "未婚", "", "", ""],
[741, "多恩达销售公司", "南部大区-刘永", "四川办事处-冯佩轩", "张佳睿", "男", 25, "15142617433", "210702200005160019", "2024-06-20", "在岗", "四川省成都市", "未婚", "", "", ""],
[742, "多恩达销售公司", "南部大区-刘永", "四川办事处-冯佩轩", "高超", "男", 38, "13568926062", "51302119861213743X", "2022-08-01", "在岗", "四川省成都市", "已婚", "", "", ""],
[743, "多恩达销售公司", "南部大区-刘永", "重庆办事处-郑甘泉", "郑甘泉", "男", 38, "18723826767", "500110198704061614", "2019-12-09", "在岗", "重庆市", "未婚", "", "", ""],
[744, "多恩达销售公司", "南部大区-刘永", "重庆办事处-郑甘泉", "黎明", "男", 33, "13012323339", "500382199109023813", "2018-05-11", "在岗", "重庆市", "已婚", "", "", ""],
[745, "多恩达销售公司", "南部大区-刘永", "重庆办事处-郑甘泉", "程真", "男", 30, "18725833120", "511602199412278293", "2023-03-06", "在岗", "重庆市", "未婚", "", "", ""],
[746, "多恩达销售公司", "南部大区-刘永", "重庆办事处-郑甘泉", "吕林洪", "男", 27, "18375640265", "500227199709246332", "2023-07-06", "在岗", "重庆市", "已婚", "", "", ""],
[747, "多恩达销售公司", "南部大区-刘永", "重庆办事处-郑甘泉", "董博", "男", 30, "18886083635", "420921199411255113", "2024-01-25", "在岗", "贵州省贵阳市", "已婚", "", "", ""],
[748, "多恩达销售公司", "南部大区-刘永", "重庆办事处-郑甘泉", "顾霜", "女", 30, "18381147824", "51162319950306572X", "2024-02-06", "在岗", "重庆市", "未婚", "", "", ""],
[749, "多恩达销售公司", "南部大区-刘永", "湖南办事处-李清华", "李清华", "女", 39, "13755157585", "430524198601190028", "2016-11-14", "在岗", "湖南省长沙市", "已婚", "", "", ""],
[750, "多恩达销售公司", "南部大区-刘永", "湖南办事处-李清华", "吴佳思", "女", 32, "15717512189", "430624199211041625", "2021-09-01", "在岗", "湖南省长沙市", "已婚", "", "", ""],
[751, "多恩达销售公司", "南部大区-刘永", "湖南办事处-李清华", "彭超", "男", 37, "15111486336", "430721198801026152", "2021-09-01", "在岗", "湖南省长沙市", "已婚", "", "", ""],
[752, "多恩达销售公司", "南部大区-刘永", "湖南办事处-李清华", "刘云", "女", 35, "13549665151", "430903199006012723", "2024-01-08", "在岗", "湖南省长沙市", "已婚", "", "", ""],
[753, "多恩达销售公司", "南部大区-刘永", "湖南办事处-李清华", "吴赐龙", "男", 35, "18613991900", "430626198910093916", "2019-05-20", "在岗", "湖南省长沙市", "未婚", "", "", ""],
[754, "多恩达销售公司", "南部大区-刘永", "湖南办事处-李清华", "张天宝", "男", 30, "18607411510", "430211199505300019", "2025-01-02", "在岗", "湖南省长沙市", "已婚", "", "", ""],
[755, "多恩达销售公司", "南部大区-刘永", "湖南办事处-李清华", "欧阳千慧", "女", 28, "18229159721", "432522199701300021", "2019-05-20", "在岗", "湖南省长沙市", "未婚", "", "", ""],
[800, "多恩达销售公司", "分管领导-张丹", "河北办事处-王炜晨", "王炜晨", "男", 27, "15531102733", "130102199708092114", "2019-07-01", "在岗", "河北省石家庄市", "未婚", "", "", ""],
[801, "多恩达销售公司", "分管领导-张丹", "河北办事处-王炜晨", "王杰东", "男", 33, "15130676736", "130126199112092712", "2016-03-10", "在岗", "河北省石家庄市", "已婚", "", "", ""],
[802, "多恩达销售公司", "分管领导-张丹", "河北办事处-王炜晨", "刘云杰", "男", 27, "13131929605", "130522199806111419", "2018-07-16", "在岗", "河北省石家庄市", "已婚", "", "", ""],
[803, "多恩达销售公司", "分管领导-张丹", "河北办事处-王炜晨", "李晨朔", "男", 25, "17692730554", "130928199911055412", "2024-06-07", "在岗", "河北省石家庄市", "未婚", "", "", ""],
[804, "多恩达销售公司", "分管领导-张丹", "河北办事处-王炜晨", "张鑫", "男", 25, "18733908535", "130521199912192017", "2024-11-19", "在岗", "河北省石家庄市", "未婚", "", "", ""],
[805, "多恩达销售公司", "分管领导-张丹", "天津办事处-戴鑫鹏", "赵禹铎", "男", 28, "15802264393", "120101199702233010", "2021-08-24", "在岗", "天津市", "未婚", "", "", ""],
[806, "多恩达销售公司", "分管领导-张丹", "天津办事处-戴鑫鹏", "戴鑫鹏", "男", 31, "15227886165", "131182199403034434", "2022-04-20", "在岗", "天津市", "未婚", "", "", ""],
[807, "多恩达销售公司", "分管领导-张丹", "天津办事处-戴鑫鹏", "李鑫月", "女", 24, "15713023509", "130623200012062122", "2023-06-05", "在岗", "天津市", "未婚", "", "", ""],
[808, "多恩达销售公司", "分管领导-张丹", "天津办事处-戴鑫鹏", "崔乐", "女", 27, "13011373908", "120113199802234024", "2024-01-09", "在岗", "天津市", "未婚", "", "", ""],
[809, "多恩达销售公司", "分管领导-张丹", "天津办事处-戴鑫鹏", "高鹏", "男", 30, "18132664632", "130631199411241616", "2025-03-18", "在岗", "天津市和平区", "已婚", "", "", ""]
];
const 套餐 = [
"A套餐(35周岁以下)-男",
"A套餐(35周岁以下)-女未婚",
"A套餐(35周岁以下)-女已婚",
"B套餐(35周岁以上)-男",
"B套餐(35周岁以上)-女未婚",
"B套餐(35周岁以上)-女已婚"
];
const 体检方式 = [
"美年大健康",
"心血管病医院",
"自费核销方式"
];
const 体检城市 = [
"北京地区","上海地区","石家庄地区","广州地区","深圳地区","成都地区","长沙地区","武汉地区",
"佛山(含奥亚)地区","湛江地区","海口地区","昆明地区","重庆地区","贵阳地区","南宁地区"
];
let currentUser = data[0][4];
function renderUserSelect() {
let sel = document.getElementById('userSelect');
sel.innerHTML = data.map(row=>`<option value="${row[4]}">${row[4]}</option>`).join('');
sel.value = currentUser;
sel.onchange = function(){
currentUser = this.value;
renderTable();
}
}
function renderTable() {
let html = '<table><tr>' +
'<th>序号</th><th>公司</th><th>部门/办事处</th><th>具体部门</th><th>姓名</th>' +
'<th>性别</th><th>年龄</th><th>电话</th><th>身份证</th><th>入职时间</th><th>员工状态</th><th>Base地</th><th>婚姻状况</th>' +
'<th>套餐名称</th><th>预计体检地区</th><th>体检方式</th></tr>';
data.forEach((row,i)=>{
let isSelf = (row[4]===currentUser);
html += `<tr${isSelf?' class="self"':''}>` +
row.slice(0,13).map((v,j)=>j<5||isSelf?`<td>${v}</td>`:`<td>***</td>`).join('');
html += '<td>';
if(isSelf){
html += `<select onchange="data[${i}][13]=this.value; renderTable();"><option value=""></option>${套餐.map(opt=>`<option${row[13]===opt?' selected':''}>${opt}</option>`)}</select>`;
}else{
html += row[13]||'';
}
html += '</td>';
html += '<td>';
if(isSelf){
html += `<select onchange="data[${i}][14]=this.value; renderTable();"><option value=""></option>${体检城市.map(opt=>`<option${row[14]===opt?' selected':''}>${opt}</option>`)}</select>`;
}else{
html += row[14]||'';
}
html += '</td>';
html += '<td>';
if(isSelf){
html += `<select onchange="data[${i}][15]=this.value; renderTable();"><option value=""></option>${体检方式.map(opt=>`<option${row[15]===opt?' selected':''}>${opt}</option>`)}</select>`;
}else{
html += row[15]||'';
}
html += '</td>';
html += '</tr>';
});
html += '</table>';
document.getElementById('tableDiv').innerHTML = html;
}
renderUserSelect();
renderTable();
function exportExcel() {
let pwd = prompt("请输入导出密码:");
if(pwd === null) return;
if(pwd !== "202412") {
alert("密码错误,无法导出!");
return;
}
const header = [
"序号","公司","部门/办事处","具体部门","姓名","性别","年龄","电话","身份证","入职时间","员工状态","Base地","婚姻状况",
"套餐名称","预计体检地区","体检方式"
];
const exportData = [header, ...data];
const ws = XLSX.utils.aoa_to_sheet(exportData);
const wb = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(wb, ws, "体检名单");
XLSX.writeFile(wb, "抗肿瘤药事业部体检名单.xlsx");
}
</script>
<p style="color:#888;font-size:13px;">(如需导出,请输入密码。此页面可直接在手机或电脑浏览器打开,无需安装任何软件。)</p>
</body>
</html>