SOURCE

console 命令行工具 X clear

                    
>
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>
  // 人员数据(文件4~45行,已做脱敏处理,仅部分展示,实际请替换为完整data)
  const data = [
  // [序号, 公司, 部门/办事处, 具体部门, 姓名, 性别, 年龄, 电话, 身份证, 入职时间, 员工状态, Base地, 婚姻状况, 套餐名称, 预计体检地区, 体检方式]
  [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", "在岗", "天津市和平区", "已婚", "", "", ""]
];


  // 套餐、体检方式、体检城市(可根据Sheet2补充)
  const 套餐 = [
    "A套餐(35周岁以下)-男",
    "A套餐(35周岁以下)-女未婚",
    "A套餐(35周岁以下)-女已婚",
    "B套餐(35周岁以上)-男",
    "B套餐(35周岁以上)-女未婚",
    "B套餐(35周岁以上)-女已婚"
  ];
  const 体检方式 = [
    "美年大健康",
    "心血管病医院",
    "自费核销方式"
  ];
  // 体检城市列表(可补充完整,以下为示例)
  const 体检城市 = [
    "北京地区","上海地区","石家庄地区","广州地区","深圳地区","成都地区","长沙地区","武汉地区",
    "佛山(含奥亚)地区","湛江地区","海口地区","昆明地区","重庆地区","贵阳地区","南宁地区"
    // ...完整列表可参考Sheet2
  ];

  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>