// ==UserScript==
// @name         腾讯文档 - 快递工具合集
// @namespace    http://tampermonkey.net/
// @version      3.0
// @description  功能1：CSV单号匹配G列 | 功能2：杂乱文本智能解析+多物品分行填充
// @author       Codex
// @match        https://docs.qq.com/sheet/*
// @icon         https://docs.qq.com/favicon.ico
// @grant        GM_addStyle
// @grant        GM_notification
// @license      MIT
// ==/UserScript==
(function(){"use strict";
function sleep(ms){return new Promise(function(r){setTimeout(r,ms)})}
function L(el,text,cls){var d=document.createElement("div");d.textContent=text;if(cls)d.className=cls;el.appendChild(d);el.scrollTop=el.scrollHeight}
async function writeCell(cell,value){
  var lb=document.querySelector(".bar-label"),ed=document.querySelector("#alloy-simple-text-editor");
  if(!lb||!ed)return false;
  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,which:13,code:"Enter",bubbles:true}))});
  lb.dispatchEvent(new Event("change",{bubbles:true}));
  await sleep(200);
  ed.focus();ed.textContent="";document.execCommand("selectAll",false);document.execCommand("delete",false);
  await sleep(30);
  ed.textContent=String(value||"");ed.dispatchEvent(new Event("input",{bubbles:true}));
  ed.dispatchEvent(new Event("change",{bubbles:true}));
  await sleep(50);ed.blur();await sleep(100);return true
}
async function fillRows(rows,sr,cols){var ok=0,fail=0;for(var i=0;i<rows.length;i++){for(var c in cols){var v=rows[i][cols[c]];if(v){if(await writeCell(c+(sr+i),v))ok++;else fail++;await sleep(15)}}}return{ok,fail}}
async function readCell(cell){var lb=document.querySelector(".bar-label"),ed=document.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,which:13,code:"Enter",bubbles:true}))});await sleep(250);return(ed.textContent||"").trim()}
async function findFirstEmptyRow(f){for(var r=f||2;r<=500;r++){var v=await readCell("A"+r);if(!v)return r}return f||2}
function buildCSVMap(txt){var L=txt.split(/\r?\n/).map(function(l){return l.trim()}).filter(Boolean);var M={};if(L.length<2)return M;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]);var ni=H.indexOf("收件人"),ti=H.indexOf("运单号/订单号");if(ni>=0&&ti>=0){for(var i=1;i<L.length;i++){var v=S(L[i]);var n=v[ni]||"",t=v[ti]||"";if(n){if(!M[n])M[n]=[];M[n].push(t)}}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[6]||"").trim(),t=(v[0]||"").trim();if(n){if(!M[n])M[n]=[];M[n].push(t)}}return M}
var _qtyRe=/^([一二两三四五六七八九十\d]+)(?:箱|盒|包|袋|条|罐|瓶|桶|个|份|块|卷|对|双|套|打|件|捆|提|箱子|盒子)\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(/^[一二两三四五六七八九十\d]+[箱盒包袋条罐瓶桶个份块卷对双套打件捆提]$/.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};
  // *标签最高优先级
  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[3-9]\d{9}/);
  if(pm){r.phone=pm[0];t=t.replace(pm[0],"").replace(/收件人手机[：:]?/,"").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*/,"")}
  // 标签提取（在原文上做，不拆段）
  var lrRe=/^(?:姓名|收件人|联系人|名字)[：:]\s*(.+)$/m;
  var arRe=/^(?:地址|收货地址|省市区|所在地|所在地区|详细地址)[：:]\s*(.+)$/gm;
  var irRe=/^(?:物品|商品|货品|产品|内容)[：:]\s*(.+)$/m;
  var mLR=t.match(lrRe);if(mLR&&!r.name){r.name=mLR[1].trim().replace(/(?:先生|女士|小姐|师傅|小哥|同学|老师|收)\s*$/,"");t=t.replace(mLR[0],"")}
  var _tmp=t;while(true){var mAR=arRe.exec(_tmp);if(!mAR)break;if(mAR[1]){r.address=(r.address||"")+mAR[1].trim();t=t.replace(mAR[0],"")}}
  var mIR=t.match(irRe);if(mIR){r.items=splItems(mIR[1]);t=t.replace(mIR[0],"")}
  // 拆段
  var segs=t.replace(/[。，]/g," ").split(/[\s,；;\n\r]+/).map(function(s){return s.trim()}).filter(Boolean);
  // 用手机位置猜姓名
  if(!r.name&&r.phone){var pi=text.indexOf(r.phone);if(pi<0)pi=0;var bp=text.substring(0,pi).split(/[\s,，、；;:：\n\r]+/).filter(Boolean);for(var i=bp.length-1;i>=0;i--){if(isName(bp[i].trim())){r.name=bp[i].trim();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){var aqr=/\s+[一二两三四五六七八九十\d]+(?:箱|盒|包|袋|条|罐|瓶|桶|个|份|块|卷|对|双|套|打|件|捆|提)/;var ai=r.address.search(aqr);if(ai>=0){var lf=r.address.substring(ai).trim();r.address=r.address.substring(0,ai).trim();var ips=splItems(lf);for(var ip=0;ip<ips.length;ip++)r.items.push(ips[ip])}}
  // 物品
  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?[""]:[]);r._qty=mq;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 _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){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}
}
GM_addStyle(".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:-apple-system,'Microsoft YaHei',sans-serif}.cd{background:#fff;border-radius:12px;padding:0;width:720px;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;transition:all .2s;border-bottom:2px solid transparent;font-family:inherit}.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;line-height:1.5}.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;transition:border-color .2s;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;line-height:1.8}.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;transition:border-color .2s}.cb label input[type=text]:focus{border-color:#2468f2}.cb label input[type=checkbox]{margin:0}.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;transition:opacity .2s;font-family:inherit}.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-y: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:120px;overflow:hidden;text-overflow:ellipsis;white-space:nowrap;font-size:11px}.cf{position:fixed;bottom:32px;right:32px;z-index:999999;width:48px;height:48px;border-radius:50%;background:#2468f2;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:transform .2s,box-shadow .2s}.cf:hover{transform:scale(1.08);box-shadow:0 6px 16px rgba(36,104,242,.5)}.cm{position:fixed;bottom:92px;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:transform .2s,box-shadow .2s;background:#00b42a}.cm:hover{transform:scale(1.08);box-shadow:0 6px 16px rgba(36,104,242,.5)}");
var f1=document.createElement("button");f1.className="cf";f1.textContent="CSV";f1.title="CSV单号匹配";f1.addEventListener("click",function(){showDialog("csv")});document.body.appendChild(f1);
var f2=document.createElement("button");f2.className="cm";f2.textContent="AI";f2.title="智能解析文本";f2.addEventListener("click",function(){showDialog("parse")});document.body.appendChild(f2);
function showDialog(def){
  var old=document.querySelector(".co");if(old)old.remove();
  var ov=document.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>';
  document.body.appendChild(ov);
  ov.addEventListener("click",function(e){if(e.target===ov)ov.remove()});
  var btns=ov.querySelectorAll(".tab-btn");
  for(var i=0;i<btns.length;i++){(function(btn){btn.addEventListener("click",function(){for(var j=0;j<btns.length;j++)btns[j].classList.remove("on");btn.classList.add("on");var tabs=ov.querySelectorAll(".cb");for(var j=0;j<tabs.length;j++)tabs[j].style.display="none";var t=ov.querySelector("#tab-"+btn.dataset.tab);if(t)t.style.display="block"})})(btns[i])}
  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记录，按收件人姓名匹配填入G列(快递单号)。已有单号跳过不覆盖。</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"></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.addEventListener("input",ck);ri.addEventListener("input",ck);
  t.querySelector("#zc").addEventListener("click",function(){ov.remove()});
  btn.addEventListener("click",async function(){
    btn.disabled=true;btn.textContent="处理中";log.style.display="block";log.innerHTML="";
    var rng=ri.value.trim().split("-").map(Number);
    if(t.querySelector(".auto-row-csv").checked){var fr=await findFirstEmptyRow(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];L(log,"行号"+rS+"-"+rE);
    var m=buildCSVMap(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 fill=0,skip=0,fail=0;
    for(var r=rS;r<=rE;r++){
      var track=await readCell("G"+r);if(track){L(log,"第"+r+"行已有单号","skip");skip++;continue}
      var name=await readCell("A"+r);if(!name){L(log,"第"+r+"行空行跳过","skip");skip++;continue}
      var clean=name.replace(/^\*/,"").trim();var c=m[clean];if(!c||!c.length){L(log,"第"+r+"行"+clean+"未找到","err");fail++;continue}
      var t=c.shift();if(!t){L(log,"第"+r+"行无单号","err");fail++;continue}
      var ok=await writeCell("G"+r,t);if(ok){L(log,"第"+r+"行"+clean+"->"+t,"ok");fill++}else{L(log,"第"+r+"行写入失败","err");fail++}
      await sleep(30)
    }
    L(log,"\n完成：填充"+fill+"行，跳过"+skip+"行，失败"+fail+"行");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">粘贴杂乱快递文本，逐行解析，多物品拆分行，可选字段填入表格（起始行默认1不从开头跳过）。</div><textarea placeholder="粘贴快递文本……"></textarea><div style="display:flex;align-items:center;gap:16px;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" class="pcb" checked> 姓名</label><label><input type="checkbox" class="pcb" checked> 手机</label><label><input type="checkbox" class="pcb"> 固话</label><label><input type="checkbox" class="pcb" checked> 地址</label><label><input type="checkbox" class="pcb" checked> 物品</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");
  var curRows=[];
  t.querySelector("#ppc").addEventListener("click",function(){ov.remove()});
  t.querySelector("#ppp").addEventListener("click",function(){
    var text=ta.value.trim();if(!text){alert("请先粘贴文本");return}
    var sl=parseInt(t.querySelector(".prn").value)||1;
    var result=parseMultipleOrders(text,1);curRows=result.rows;
    if(!curRows.length){var _em=result.errors&&result.errors.length?"\n错误: "+result.errors.join("; "):"";alert("解析失败，0行结果"+_em+"\n\n检查:\n1. 文本格式是否正确\n2. 是否有手机号\n(起始行"+sl+"仅控制填入表格位置)");return}
    pv.style.display="block";var h='<div class="cr"><table><tr><th>姓名</th><th>手机</th><th>固话</th><th>地址</th><th>物品</th></tr>';
    for(var i=0;i<curRows.length;i++){var r=curRows[i];h+="<tr><td>"+r.name+"</td><td>"+r.phone+"</td><td>"+(r.landline||"")+"</td><td>"+r.address+"</td><td>"+r.item+"</td></tr>"}
    h+="</table></div>";pv.innerHTML=h;
    pl.style.display="block";pl.innerHTML="";L(pl,"共"+curRows.length+"行数据");L(pl,"共"+result.errors.length+"个错误");if(result.errors.length)result.errors.forEach(function(e){L(pl,"!"+e,"err")});
    pb.style.display="flex"
  });
  t.querySelector("#ppfill").addEventListener("click",async function(){
    if(!curRows.length)return;var sr=parseInt(t.querySelector(".prn").value)||1;
    if(t.querySelector(".auto-row").checked)sr=await findFirstEmptyRow(sr);
    var cbs=t.querySelectorAll(".pcb"),cols={};if(cbs[0].checked)cols["A"]="name";if(cbs[1].checked)cols["B"]="phone";if(cbs[2].checked)cols["C"]="landline";if(cbs[3].checked)cols["D"]="address";if(cbs[4].checked)cols["E"]="item";
    var btn=t.querySelector("#ppfill");btn.disabled=true;btn.textContent="写入中...";
    var r=await fillRows(curRows,sr,cols);btn.textContent="填入表格";btn.disabled=false;
    L(pl,"成功"+r.ok+"格，失败"+r.fail+"格");GM_notification({text:"已写入"+curRows.length+"行",timeout:3000})
  })
}
})();