// ==UserScript==
// @name         腾讯文档 - 快递工具合集（优化版）
// @namespace    http://tampermonkey.net/
// @version      3.7
// @description  快递CSV单号匹配 + 智能文本解析 + 格式化填入 + 数量拆分
// @author       Codex
// @match        https://docs.qq.com/sheet/*
// @icon         https://docs.qq.com/favicon.ico
// @grant        GM_notification
// @license      MIT
// ==/UserScript==

(function(){"use strict";
var D=document;

// CSS注入
(function(){var s=D.createElement("style");s.textContent=".co{position:fixed;top:0;left:0;right:0;bottom:0;background:rgba(0,0,0,.35);z-index:999999;display:flex;align-items:center;justify-content:center;font-family:Microsoft YaHei,sans-serif}.cd{background:#fff;border-radius:12px;padding:0;width:760px;max-width:92vw;max-height:88vh;box-shadow:0 8px 32px rgba(0,0,0,.2);display:flex;flex-direction:column;font-size:14px;color:#1d2129;overflow:hidden}.ct{display:flex;background:#f7f8fa;border-bottom:1px solid #e5e6e8}.ct button{padding:12px 24px;border:none;background:transparent;font-size:14px;cursor:pointer;color:#4e5969;border-bottom:2px solid transparent}.ct button:hover{background:#eef0f4}.ct button.on{color:#2468f2;border-bottom-color:#2468f2;background:#fff;font-weight:600}.cb{padding:20px 24px 16px;overflow-y:auto;flex:1}.cb .hint{color:#86909c;font-size:13px;margin-bottom:8px}.cb textarea{width:100%;height:130px;padding:10px 12px;border:1px solid #e5e6e8;border-radius:6px;font-size:13px;font-family:Consolas,monospace;resize:vertical;box-sizing:border-box;outline:none;margin-bottom:8px}.cb textarea:focus{border-color:#2468f2}.cb label{font-size:13px;color:#4e5969;display:inline-flex;align-items:center;gap:4px;margin-right:10px}.cb label input[type=text]{width:50px;padding:4px 6px;border:1px solid #e5e6e8;border-radius:4px;font-size:13px;text-align:center;outline:none}.cb label input[type=text]:focus{border-color:#2468f2}.cb .br{display:flex;gap:10px;justify-content:flex-end;margin-top:8px;flex-wrap:wrap}.cb .br button{padding:8px 20px;border-radius:6px;border:none;font-size:14px;cursor:pointer}.cb .br button:hover{opacity:.85}.bp{background:#2468f2;color:#fff}.bs{background:#f2f3f5;color:#4e5969}.bp:disabled{opacity:.5;cursor:not-allowed}.cl{background:#f7f8fa;border-radius:6px;padding:10px 12px;margin-top:8px;max-height:200px;overflow:auto;font-size:12px;font-family:Consolas,monospace;line-height:1.6;white-space:pre-wrap}.cl .ok{color:#00b42a}.cl .skip{color:#86909c}.cl .err{color:#f53f3f}.cr{border:1px solid #e5e6e8;border-radius:6px;margin-top:8px;max-height:200px;overflow:auto;font-size:12px}.cr table{width:100%;border-collapse:collapse}.cr th{background:#f7f8fa;padding:5px 7px;text-align:left;font-weight:600;border-bottom:1px solid #e5e6e8;font-size:11px}.cr td{padding:4px 7px;border-bottom:1px solid #f2f3f5;max-width:140px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;font-size:11px}.cf,.cm{position:fixed;right:32px;z-index:999999;width:48px;height:48px;border-radius:50%;color:#fff;border:none;box-shadow:0 4px 12px rgba(36,104,242,.4);font-size:22px;cursor:pointer;display:flex;align-items:center;justify-content:center;transition:.2s}.cf:hover,.cm:hover{transform:scale(1.08)}.cf{bottom:32px;background:#2468f2}.cm{bottom:92px;background:#00b42a}";D.head.appendChild(s)})();

// 按钮
D.body.appendChild(function(b){b.className="cf";b.textContent="CSV";b.title="CSV单号匹配";b.onclick=function(){showDialog("csv")};return b}(D.createElement("button")));
D.body.appendChild(function(b){b.className="cm";b.textContent="AI";b.title="智能解析文本";b.onclick=function(){showDialog("parse")};return b}(D.createElement("button")));

function sl(t){return new Promise(function(r){setTimeout(r,t)})}
function L(el,t,c){var d=D.createElement("div");d.textContent=t;if(c)d.className=c;el.appendChild(d);el.scrollTop=el.scrollHeight}

async function wc(cell,val){
  var lb=D.querySelector(".bar-label"),ed=D.querySelector("#alloy-simple-text-editor");
  if(!lb||!ed)return false;
  var v=String(val||"");lb.focus();lb.value=cell;
  lb.dispatchEvent(new Event("input",{bubbles:true}));
  ["keydown","keypress","keyup"].forEach(function(t){lb.dispatchEvent(new KeyboardEvent(t,{key:"Enter",keyCode:13,bubbles:true}))});
  lb.dispatchEvent(new Event("change",{bubbles:true}));await sl(200);
  ed.focus();window.getSelection().selectAllChildren(ed);document.execCommand("delete",false);
  await sl(30);document.execCommand("insertText",false,v);await sl(30);
  ed.dispatchEvent(new Event("input",{bubbles:true}));ed.dispatchEvent(new Event("change",{bubbles:true}));
  await sl(50);ed.blur();await sl(100);return true
}

async function rc(cell){var lb=D.querySelector(".bar-label"),ed=D.querySelector("#alloy-simple-text-editor");if(!lb||!ed)return"";lb.focus();lb.value=cell;lb.dispatchEvent(new Event("input",{bubbles:true}));["keydown","keypress","keyup"].forEach(function(t){lb.dispatchEvent(new KeyboardEvent(t,{key:"Enter",keyCode:13,bubbles:true}))});lb.dispatchEvent(new Event("change",{bubbles:true}));await sl(250);return(ed.textContent||"").trim()}

async function fr(f){for(var r=f||2;r<=Math.min((f||2)+20,500);r++){var v=await rc("A"+r);if(!v)return r}return f||2}

async function fill(r,s,cl){var o=0,f=0;for(var i=0;i<r.length;i++){for(var c in cl){var v=r[i][cl[c]];if(v){if(await wc(c+(s+i),v))o++;else f++;await sl(15)}}}return{ok:o,fail:f}}

// CSV映射
function csvMap(t){
  var L=t.split(/\r?\n/).map(function(l){return l.trim()}).filter(Boolean);
  if(!L.length)return{};
  var M={};
  // 检测是否有逗号/制表符分隔（标准CSV）
  var hasSep=L[0].includes(",")||L[0].includes("\t")||(L[1]&&(L[1].includes(",")||L[1].includes("\t")));
  if(hasSep&&L.length>=2){
    var S=function(s){return s.split(L[0].includes("\t")||L[1]&&L[1].includes("\t")?"\t":",").map(function(v){return v.replace(/^"|"$/g,"").trim()})};
    var H=S(L[0]),ni=-1,ti=-1;
    for(var i=0;i<H.length;i++){
      if(H[i].includes("收件人姓名")||H[i].includes("收件人")&&!H[i].includes("手机")&&!H[i].includes("地址"))ni=i;
      if(H[i].includes("运单号")||H[i].includes("快递单号"))ti=i
    }
    if(ni>=0&&ti>=0){for(var i=1;i<L.length;i++){var v=S(L[i]),n=v[ni]||"",tn=v[ti]||"";if(n){(M[n]=M[n]||[]).push(tn)}}if(Object.keys(M).length)return M}
    for(var i=1;i<L.length;i++){var v=S(L[i]);if(v.length<7)continue;var n=(v[2]||"").trim(),tn=(v[0]||"").trim();if(n){(M[n]=M[n]||[]).push(tn)}}return M
  }
  // 单行模式：整行只有空格分隔，按14位单号拆分
  if(L.length===1){
    var parts=L[0].split(/\s+/).filter(Boolean);
    // 用单号(14位数字)做分割点
    var cur=[];
    for(var i=0;i<parts.length;i++){
      if(/^\d{14}$/.test(parts[i])){
        // parts[i]是单号，前面收集到的cur就是姓名+省+市
        var name=cur[0]||"",tn=parts[i];
        if(name){(M[name]=M[name]||[]).push(tn)}
        cur=[];
      }else{
        // 非数字，合并到姓名（省市区信息丢弃，因为只用作姓名→单号匹配）
        if(cur.length===0)cur.push(parts[i])
      }
    }
    if(Object.keys(M).length)return M
  }
  // 多行无分隔符：数字+中文连写
  for(var i=0;i<L.length;i++){
    var m=L[i].match(/^(\d+)(\D+)$/);
    if(m&&m[1].length>=10){var n=m[2].trim(),tn=m[1];(M[n]=M[n]||[]).push(tn)}
  }
  return M
}var _qtyRe=/^([\u4e00-\u4e8c\u4e24\u4e09\u56db\u4e94\u516d\u4e03\u516b\u4e5d\u5341\d]+)(?:\u7bb1|\u76d2|\u5305|\u888b|\u6761|\u7f50|\u74f6|\u6876|\u4e2a|\u4efd|\u5757|\u5377|\u5bf9|\u53cc|\u5957|\u6253|\u4ef6|\u6346|\u63d0)\s*/;
var _num={一:1,二:2,两:2,三:3,四:4,五:5,六:6,七:7,八:8,九:9,十:10,俩:2};
var _mod=new Set(["送","赠送","附送","加送","免费","赠品","配件","备件","电话","手机","tel","联系电话","固话","座机"]);
function parseQty(s){var m=s.match(_qtyRe);if(!m)return[1,s];var n=/^\d+$/.test(m[1])?parseInt(m[1]):(_num[m[1]]||1);return[n,s.slice(m[0].length).trim()]}
function isBad(w){if(/^[\u4e00-\u4e8c\u4e24\u4e09\u56db\u4e94\u516d\u4e03\u516b\u4e5d\u5341\d]+[\u7bb1\u76d2\u5305\u888b\u6761\u7f50\u74f6\u6876\u4e2a\u4efd\u5757\u5377\u5bf9\u53cc\u5957\u6253\u4ef6\u6346\u63d0]$/.test(w))return true;if(_mod.has(w))return true;if(/^\d+$/.test(w))return true;return false}
function splItems(t){return t.split(/[、，,;；\s]+/).map(function(s){return s.trim()}).filter(Boolean)}
var _notName=/^(?:电话|手机|手机号码|手机号|联系电话|固话|座机|地址|收货地址|收件人|收件人姓名|姓名|名字|联系人|物品|商品|货品|产品|内容|省市区|所在地区|区县|省份|城市|邮编)$/;
function isName(s){return /^[\u4e00-\u9fa5]{1,4}$/.test(s)&&!/[市区县镇乡街道路弄号巷村组楼]/.test(s)&&!_notName.test(s)}
function parseOrder(text){
  var t=text.trim();if(!t)return null;var r={name:"",phone:"",landline:"",address:"",items:[],_qty:1};
  // 识别末尾数量标记，如（5箱）（2箱）或(5箱)(2箱)，设置数量并移除
  var qtyMatch=t.match(/[（(]\s*(\d+)\s*(?:箱|盒|包|袋|条|罐|瓶|桶|个|份|块|卷|对|双|套|打|件|捆|提)\s*[）)]$/);
  if(qtyMatch){r._qty=parseInt(qtyMatch[1]);t=t.replace(qtyMatch[0],"").trim()}
  // 去掉序号前缀
  t=t.replace(/^\d+[、．.．]\s*/,"");
  // *标签最高优先级
  var sn=t.match(/[＊*]\s*收件人姓名[：:]?(.+?)(?:\n|$)/);
  if(sn){r.name=sn[1].trim().replace(/(?:先生|女士|小姐|师傅|小哥|同学|老师|收)\s*$/,"");t=t.replace(sn[0],"")}
  var sa=t.match(/[＊*]\s*省市区（县）详细地址[：:]?(.+?)(?:\n|$)/);
  if(sa){r.address=sa[1].trim();t=t.replace(sa[0],"")}
  var sp=t.match(/[＊*]\s*收件人手机[：:]?(1[3-9]\d{9})/);
  if(sp&&!r.phone){r.phone=sp[1];t=t.replace(sp[0],"")}
  var pm=t.match(/1\s*[3-9]\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d/);
  if(pm){r.phone=pm[0].replace(/\s+/g,"");t=t.replace(pm[0],"").replace(/收件人手机[：:]?/,"").replace(/电话[：:]?\s*/,"").replace(/手机号码[：:]?\s*/,"").replace(/手机[：:]?\s*/,"")}
  var lm=t.match(/0\d{2,3}[- ]?\d{7,8}/);if(lm){r.landline=lm[0];t=t.replace(lm[0],"").replace(/固话[：:]?\s*/,"")}
  while(true){
    var addrMatch=t.match(/(?:地址|收货地址|省市区|所在地|所在地区|详细地址)[：:]\s*(.+?)(?=\n|$|(?:地址|收货地址|省市区|所在地|所在地区|详细地址)[：:])/);
    if(!addrMatch)break;
    var addrPart=addrMatch[1].trim();
    if(r.address&&addrPart.indexOf(r.address.slice(-4))>=0&&r.address.indexOf(addrPart.slice(0,4))>=0){t=t.replace(addrMatch[0],"");continue}
    r.address=(r.address||"")+addrPart;
    t=t.replace(addrMatch[0],"")
  }
  var nameMatch=t.match(/(?:姓名|收件人|收货人|联系人|名字)[：:]\s*(.+?)(?:\n|$)/);
  if(nameMatch&&!r.name){r.name=nameMatch[1].trim().replace(/(?:先生|女士|小姐|师傅|小哥|同学|老师|收)\s*$/,"");t=t.replace(nameMatch[0],"")}
  var itemMatch=t.match(/(?:物品|商品|货品|产品|内容)[：:]\s*(.+?)(?:\n|$)/);
  if(itemMatch){r.items=splItems(itemMatch[1]);t=t.replace(itemMatch[0],"")}
  t=t.replace(/(?:收件人|收货人|联系人|姓名|手机号码|手机|电话|固话|地址|详细地址|所在地区|省市区|物品|商品|产品|内容)[：:]/gi,"");
  t=t.replace(/,+\s*,+/g,",").replace(/^[,\s]+/,"").replace(/[,\s]+$/,"");
  t=t.replace(/[。，]/g," ");
  var segs=t.split(/[\s,；;\n\r]+/).map(function(s){return s.trim()}).filter(Boolean);
  if(!r.name&&r.phone){
    var searchText=text.replace(/^\d+[、．.．]\s*/,"");
    var pi=searchText.indexOf(r.phone);
    if(pi<0){var cp=t.indexOf(r.phone);pi=cp>=0?cp:0}
    var bp=searchText.substring(0,pi).split(/[\s,，、；;:\n\r]+/).filter(Boolean);
    var afterPart=searchText.substring(pi+r.phone.length).trim();
    var afterWords=afterPart.split(/[\s,，、；;:\n\r]+/).filter(Boolean);
    // 判断手机号前面的词是否像地址（以省市开头）
    var isAddrBefore=bp.some(function(w){return /^(?:北京|天津|上海|重庆|河北|山西|辽宁|吉林|黑龙江|江苏|浙江|安徽|福建|江西|山东|河南|湖北|湖南|广东|海南|四川|贵州|云南|陕西|甘肃|青海|台湾|内蒙古|广西|西藏|宁夏|新疆)/.test(w)});
    if(isAddrBefore&&afterWords.length){
      // 地址在前 → 取手机号后面的词作为姓名
      for(var i=0;i<afterWords.length;i++){
        var w=afterWords[i].trim();
        if(w.length>=1&&!/^\d+$/.test(w)&&!/^1[3-9]/.test(w)&&!/电话|手机|固话/.test(w)){r.name=w;break}
      }
    }
    if(!r.name){
      // 姓名在前 → 取手机号前面最近的词
      for(var i=bp.length-1;i>=0;i--){
        var w=bp[i].trim();
        if(w.length>=1&&!/^\d+$/.test(w)&&!/^1[3-9]/.test(w)&&!/电话|手机|固话/.test(w)){r.name=w;break}
      }
    }
  }var pRe=/^(?:北京|天津|上海|重庆|河北|山西|辽宁|吉林|黑龙江|江苏|浙江|安徽|福建|江西|山东|河南|湖北|湖南|广东|海南|四川|贵州|云南|陕西|甘肃|青海|台湾|内蒙古|广西|西藏|宁夏|新疆)/;
  if(r.name){var ni=-1;for(var i=0;i<segs.length;i++){if(segs[i]===r.name){ni=i;break}}if(ni>=0){r.address=(r.address||"")+segs.slice(0,ni).join("");segs=segs.slice(ni+1)}}
  if(!r.address){var aS=[],oS=[];for(var i=0;i<segs.length;i++){if(pRe.test(segs[i])||/[市区县镇乡街道路弄号巷村组楼]/.test(segs[i]))aS.push(segs[i]);else oS.push(segs[i])}if(aS.length)r.address=aS.join("");segs=oS}
  if(r.address){r.address=r.address.replace(/(?:收件人|收货人|联系人|姓名|手机号码|电话号码|电话|地址|详细地址|所在地区|省市区)/gi,"").replace(/^\d+[、．.]\s*/,"").replace(/,+/g," ").replace(/\s+/g,"").trim()}
  if(r.name){r.name=r.name.replace(/^[,\s]+|[,\s]+$/g,"").trim()}
  if(r.items.length===0){for(var i=0;i<segs.length;i++){if(segs[i].length>=1){var ss=splItems(segs[i]);for(var j=0;j<ss.length;j++)r.items.push(ss[j])}}r.items=filterUnique(r.items)}
  var mq=1;var ci=[];for(var i=0;i<r.items.length;i++){var _p=parseQty(r.items[i]);mq=Math.max(mq,_p[0]);if(_p[1]&&!isBad(_p[1]))ci.push(_p[1])}
  r.items=ci.length?ci:(mq>1?[""]:[]);
  // 用末尾数量标记覆盖物品数量
  if(r._qty>1&&r.items.length===0){r.items=[""]}
  return r;
  function filterUnique(a){var seen={};return a.filter(function(x){if(seen[x])return false;seen[x]=true;return true})}
}
function parseMultipleOrders(text,startLine){
  if(startLine>1){var _ls=text.split("\n");text=_ls.slice(startLine-1).join("\n")}
  // 自动分行：遇到"手机号（数量）→ 下条地址开头"插入空行
  var _ln=text.split("\n");var _nf=[];
  for(var _i=0;_i<_ln.length;_i++){
    _nf.push(_ln[_i]);
    if(_i<_ln.length-1){
      var _cu=_ln[_i].trim(),_nx=_ln[_i+1].trim();
      // 手机号后跟商品名
      if(_cu&&_nx&&/1[3-9]\d{9}$/.test(_cu.replace(/\s+/g,""))&&/^[一二两三四五六七八九十\d]+(?:箱|盒|包|袋|条|罐|瓶|桶|个|份|块|卷|对|双|套|打|件|捆|提)/.test(_nx)){
        _nf.push("");
      }
      // 序号开头
      if(_cu&&_nx&&/^\d+[、．.]/.test(_nx)){
        _nf.push("");
      }
      // 手机号+(数量)结尾 → 下一行非空且不以序号/空白开头
      if(_cu&&_nx&&/1[3-9]\d{9}（\d+[箱盒包袋条罐瓶桶个份块卷对双套打件捆提]）$/.test(_cu)&&!/^\d+[、．.]/.test(_nx)){
        _nf.push("");
      }
    }
  }
  text=_nf.join("\n");
  // 预处理手机号空格
  text=text.replace(/1\s*[3-9]\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d\s*\d/g,function(m){return m.replace(/\s+/g,"")});
var _pc=(text.match(/1[3-9]\d{9}/g)||[]);
  if(_pc.length<=1){
    var _single=parseOrder(text);
    if(_single&&_single.name&&_single.phone){
    var _si=_single.items.length?_single.items:[""];var _sr=[];
    for(var _j=0;_j<_si.length;_j++){for(var _k=0;_k<_single._qty;_k++){_sr.push({name:_single.name,phone:_single.phone,landline:_single.landline,address:_single.address,item:_si[_j]})}}
    return{rows:_sr,errors:[]}
  }
  }
  var blocks=text.split(/\n\s*\n/).map(function(b){return b.trim()}).filter(Boolean);
  var allRows=[],errs=[];
  for(var i=0;i<blocks.length;i++){var order=parseOrder(blocks[i]);if(!order||!order.name||!order.phone){errs.push("第"+(i+1)+"单信息不全，跳过");continue}var items=order.items.length?order.items:[""];for(var j=0;j<items.length;j++){for(var k=0;k<order._qty;k++){allRows.push({name:order.name,phone:order.phone,landline:order.landline,address:order.address,item:items[j]})}}}
  return{rows:allRows,errors:errs}
}
function getStandardFormatText(rowList){
  var header = "*收件人姓名\t*收件人手机\t收件人固话\t*省市区（县）详细地址";
  var lines = [header];
  rowList.forEach(function(item){
    var name = item.name || "";
    var phone = item.phone || "";
    var land = item.landline || "";
    var addr = item.address || "";
    lines.push(name+"\t"+phone+"\t"+land+"\t"+addr);
  })
  return lines.join("\n");
}
function copyText(text){
  var temp = document.createElement("textarea");
  temp.value = text;
  document.body.appendChild(temp);
  temp.select();
  document.execCommand("copy");
  temp.remove();
  GM_notification({text:"已复制标准格式文本！",timeout:2000})
}


// 格式化为：收件人姓名 *收件人手机 收件人固话 *省市区（县）详细地址
function formatOrderLine(r){
  var parts=[];
  parts.push(r.name||"");
  if(r.phone)parts.push(" *"+r.phone);
  if(r.landline)parts.push(" "+r.landline);
  if(r.address)parts.push(" *"+r.address);
  return parts.join("");
}


function showDialog(def){
  var o=D.querySelector(".co");if(o)o.remove();
  var ov=D.createElement("div");ov.className="co";
  ov.innerHTML='<div class="cd"><div class="ct"><button class="tab-btn on" data-tab="csv">CSV单号匹配</button><button class="tab-btn" data-tab="parse">智能解析</button></div><div class="cb" id="tab-csv"></div><div class="cb" id="tab-parse" style="display:none"></div></div>';
  D.body.appendChild(ov);
  ov.onclick=function(e){if(e.target===ov)ov.remove()};
  var btns=ov.querySelectorAll(".tab-btn");
  [].forEach.call(btns,function(b){b.onclick=function(){btns.forEach(function(x){x.classList.remove("on")});b.classList.add("on");var t=ov.querySelectorAll(".cb");t.forEach(function(x){x.style.display="none"});var p=ov.querySelector("#tab-"+b.dataset.tab);if(p)p.style.display="block"}});
  buildCSV(ov);buildParse(ov);
  if(def==="parse")ov.querySelector('[data-tab="parse"]').click()
}

function buildCSV(ov){
  var t=ov.querySelector("#tab-csv");
  t.innerHTML='<div class="hint">粘贴快递CSV记录，按收件人姓名匹配填入快递单号</div><textarea placeholder="粘贴CSV内容……"></textarea><div style="display:flex;align-items:center;gap:16px;margin-bottom:6px"><label>行号：<input type="text" class="zr" value="2-10" style="width:60px"></label><label><input type="checkbox" class="auto-row-csv"> 自动找空白行</label></div><div class="br"><button class="bs" id="zc">取消</button><button class="bp" id="zs" disabled>匹配</button></div><div class="cl" id="zl" style="display:none"></div>';
  var ta=t.querySelector("textarea"),ri=t.querySelector(".zr"),btn=t.querySelector("#zs"),log=t.querySelector("#zl");
  function ck(){btn.disabled=!ta.value.trim()||!ri.value.trim()}
  ta.oninput=ck;ri.oninput=ck;
  t.querySelector("#zc").onclick=function(){ov.remove()};
  btn.onclick=async function(){
    btn.disabled=true;btn.textContent="处理中";log.style.display="block";log.innerHTML="";
    try{
      var rng=ri.value.trim().split("-").map(Number);
      if(t.querySelector(".auto-row-csv").checked){var fr=await fr(rng[0]);rng=[fr,fr+9]}
      if(rng.length!==2||isNaN(rng[0])||isNaN(rng[1])||rng[0]<2){L(log,"行号格式错误","err");btn.disabled=false;btn.textContent="匹配";return}
      var rS=rng[0],rE=rng[1],m=csvMap(ta.value);
      if(!Object.keys(m).length){L(log,"CSV解析失败","err");btn.disabled=false;btn.textContent="匹配";return}
      L(log,"CSV共"+Object.keys(m).length+"人，正在读取表格…");
      var rows=[];
      for(var r=rS;r<=rE;r++){
        var tN=await rc("G"+r),n=await rc("A"+r),a=await rc("D"+r);
        await sl(20);rows.push({row:r,name:n,address:a,hasTrack:!!tN})
      }
      var used={};for(var k in m)used[k]=m[k].slice();
      var fill=0,skip=0,fail=0;
      for(var i=0;i<rows.length;i++){
        var rw=rows[i];
        if(rw.hasTrack){L(log,"第"+rw.row+"行已有单号","skip");skip++;continue}
        if(!rw.name){L(log,"第"+rw.row+"行空行跳过","skip");skip++;continue}
        var c=rw.name.replace(/^\*/,"").trim(),fk=null;
        if(used[c]&&used[c].length){fk=c}
        if(!fk){var b=c.replace(/\s*\[[\d]+\]\s*$/,"");for(var k in used){if(!used[k].length)continue;if(k.replace(/\s*\[[\d]+\]\s*$/,"")===b){fk=k;break}}}
        if(!fk){var nc=c.replace(/[[\]\d]/g,"");for(var k in used){if(!used[k].length)continue;if(k.indexOf(nc)>=0||nc.indexOf(k)>=0){fk=k;break}}}
        if(!fk||!used[fk]||!used[fk].length){L(log,"第"+rw.row+"行"+c+"→CSV未匹配","err");fail++;continue}
        var tn=used[fk].shift();
        if(!tn){L(log,"第"+rw.row+"行"+c+"→无单号","err");fail++;continue}
        (await wc("G"+rw.row,tn))?L(log,"第"+rw.row+"行"+c+" → "+tn,"ok"):L(log,"第"+rw.row+"行写入失败","err");
        await sl(30)
      }
      L(log,"\n完成：填充"+fill+"行，跳过"+skip+"行，失败"+fail+"行");
    }catch(e){L(log,"错误:"+e.message,"err")}
    btn.textContent="完成";btn.disabled=false;
    GM_notification({text:"单号匹配完成："+fill+"行",timeout:3000})
  }
}

function buildParse(ov){
  var t=ov.querySelector("#tab-parse");
  t.innerHTML='<div class="hint">粘贴快递文本，自动解析。支持多行/多单/数量标记如（5箱）</div><textarea placeholder="粘贴快递文本……"></textarea><div style="display:flex;align-items:center;gap:12px;flex-wrap:wrap;margin-bottom:6px"><label>起始行：<input type="text" class="prn" value="1" style="width:50px"></label><label><input type="checkbox" class="auto-row"> 自动找空白行</label><label><input type="checkbox" id="fmtMerge"> <strong style="color:#2468f2">格式化合并填入</strong><span style="font-size:11px;color:#86909c">（姓名 *手机 固话 *地址）</span></label></div><div class="br"><button class="bs" id="ppc">取消</button><button class="bp" id="ppp">解析预览</button></div><div id="ppv" style="display:none"></div><div id="ppl" style="display:none"></div><div id="ppb" style="display:none;margin-top:8px" class="br"><button class="bp" id="ppfill">填入表格</button></div>';
  var ta=t.querySelector("textarea"),pv=t.querySelector("#ppv"),pl=t.querySelector("#ppl"),pb=t.querySelector("#ppb"),cur=[];
  t.querySelector("#ppc").onclick=function(){ov.remove()};
  t.querySelector("#ppp").onclick=function(){
    var text=ta.value.trim();if(!text){alert("请先粘贴快递文本");return}
    var r=parseMultipleOrders(text,1);cur=r.rows;
    if(!cur.length){alert("未解析到有效信息");return}
    pv.style.display="block";
    var h='<div class="cr"><table><tr><th>姓名</th><th>手机</th><th>固话</th><th>地址</th><th style="color:#2468f2">格式化合并</th></tr>';
    for(var i=0;i<cur.length;i++){var x=cur[i];h+="<tr><td>"+x.name+"</td><td>"+x.phone+"</td><td>"+(x.landline||"")+"</td><td>"+x.address+"</td><td style='font-size:11px;color:#2468f2;white-space:normal;max-width:200px'>"+formatOrderLine(x)+"</td></tr>"}
    pv.innerHTML=h+"</table></div>";
    pl.style.display="block";pl.innerHTML="";L(pl,"解析"+cur.length+"条，失败"+r.errors.length+"条");r.errors.forEach(function(e){L(pl,"!"+e,"err")});
    pb.style.display="flex"
  };
  t.querySelector("#ppfill").onclick=async function(){
    if(!cur.length)return;
    var sr=parseInt(t.querySelector(".prn").value)||1;
    if(t.querySelector(".auto-row").checked)sr=await fr(sr);
    var fm=t.querySelector("#fmtMerge").checked,btn=t.querySelector("#ppfill");
    btn.disabled=true;btn.textContent="写入中…";
    var ok=0,fail=0;
    if(fm){
      for(var i=0;i<cur.length;i++){
        var l=formatOrderLine(cur[i]);
        if(l&&await wc("A"+(sr+i),l))ok++;else fail++;await sl(15)
      }
      L(pl,"格式化写入"+ok+"行，失败"+fail+"行")
    }else{
      var r=await fill(cur,sr,{A:"name",B:"phone",C:"landline",D:"address"});
      L(pl,"分列写入"+r.ok+"格，失败"+r.fail+"格")
    }
    btn.textContent="填入表格";btn.disabled=false;
    GM_notification({text:"已写入"+cur.length+"行",timeout:3000})
  }
}

console.log("快递工具v3.5已加载");
})();