function doGet(e){
  var action=e.parameter.action;
  if(action==='ping')return json_({ok:true,v:4});
  if(action==='getPicks')return json_({picks:readAll_()});
  if(action==='getTeamDB')return json_(readTeamDB_());
  if(action==='getKbo')return json_(readKbo_());
  if(action==='getNpb')return json_(readNpb_());
  if(action==='getCloseOdds')return json_(readCloseOdds_());
  return json_({ok:false,error:'unknown action'});
}

function doPost(e){
  var lock=LockService.getScriptLock();
  lock.waitLock(20000);
  try{
    var body=JSON.parse(e.postData.contents);
    if(body.action==='appendPicks'||body.action==='upsertPicks'){upsertPicks_(body.picks||[],false);return json_({ok:true,v:3});}
    if(body.action==='syncFinalPicks'){upsertPicks_(body.picks||[],true);return json_({ok:true,v:3});}
    if(body.action==='deletePicks'){deletePicks_(body.keys||[]);return json_({ok:true,v:3});}
    if(body.action==='saveTeamDB'){var t=saveTeamDB_(body.teamDB||{});return json_({ok:true,v:2,savedAt:t});}
    if(body.action==='saveKbo'){var tk=saveKbo_(String(body.text||''));return json_({ok:true,savedAt:tk});}
    if(body.action==='saveNpb'){var tn=saveNpb_(String(body.text||''));return json_({ok:true,savedAt:tn});}
    if(body.action==='saveCloseOdds'){var tc=saveCloseOdds_(String(body.league||''),String(body.text||''));return json_({ok:true,savedAt:tc});}
    return json_({ok:false,error:'unknown action'});
  }finally{lock.releaseLock();}
}

// 새 열은 반드시 배열 '끝'에만 추가 — 중간 삽입 시 기존 시트의 데이터 행과 열 위치가 어긋남
var HEADERS=['savedAt','date','league','match','market','pick','P','fair','ev','odds','stake','score','tier','expTotal','expMargin','actHome','actAway','actH1Home','actH1Away','hFIP','aFIP','hWRC','aWRC','hBP','aBP','hGB','aGB','PF','weather','wWeight','edge','result','archived','closeOdds','staked','closeLine'];

function sheet_(){
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sh=ss.getSheetByName('Picks');
  if(!sh){ sh=ss.insertSheet('Picks'); sh.appendRow(HEADERS); }
  if(sh.getMaxColumns()<HEADERS.length)sh.insertColumnsAfter(sh.getMaxColumns(),HEADERS.length-sh.getMaxColumns());
  if(sh.getRange(1,HEADERS.length).getValue()!==HEADERS[HEADERS.length-1])sh.getRange(1,1,1,HEADERS.length).setValues([HEADERS]);
  return sh;
}

var TEAMDB_HEADERS=['team','wrc','wrcR','slg','avg','savedAt'];

function teamDbSheet_(){
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sh=ss.getSheetByName('TeamDB');
  if(!sh){ sh=ss.insertSheet('TeamDB'); sh.appendRow(TEAMDB_HEADERS); }
  return sh;
}

function saveTeamDB_(teamDB){
  var sh=teamDbSheet_();
  var savedAt=new Date().toISOString(); // 저장 시각은 서버가 찍음 — 기기 시계가 어긋나도 순서 보장
  sh.clearContents();
  sh.appendRow(TEAMDB_HEADERS);
  Object.keys(teamDB).forEach(function(team){
    var t=teamDB[team]||{};
    sh.appendRow([team, t.wrc==null?'':t.wrc, t.wrcR==null?'':t.wrcR, t.slg==null?'':t.slg, t.avg==null?'':t.avg, savedAt]);
  });
  return savedAt;
}

function readTeamDB_(){
  var sh=teamDbSheet_();
  var data=sh.getDataRange().getValues();
  var db={}, savedAt='';
  for(var i=1;i<data.length;i++){
    var row=data[i]; if(!row[0])continue;
    db[row[0]]={wrc:row[1]===''?null:row[1], wrcR:row[2]===''?null:row[2], slg:row[3]===''?null:row[3], avg:row[4]===''?null:row[4]};
    if(row[5])savedAt=row[5] instanceof Date?row[5].toISOString():String(row[5]);
  }
  return {teamDB:db, savedAt:savedAt};
}

// KBO 하루치 스탯 텍스트(경기·팀타격·선발 블록)를 한 칸에 통째로 저장 — 집에서 올리고 폰에서 그대로 불러옴
function kboSheet_(){
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sh=ss.getSheetByName('KBO');
  if(!sh){ sh=ss.insertSheet('KBO'); sh.appendRow(['text','savedAt']); }
  return sh;
}
function saveKbo_(text){
  var sh=kboSheet_();
  var savedAt=new Date().toISOString(); // 저장 시각은 서버가 찍음
  sh.clearContents();
  sh.appendRow(['text','savedAt']);
  sh.appendRow([text, savedAt]);
  return savedAt;
}
function readKbo_(){
  var sh=kboSheet_();
  var data=sh.getDataRange().getValues();
  if(data.length<2)return {text:'',savedAt:''};
  var row=data[1];
  var savedAt=row[1] instanceof Date?row[1].toISOString():String(row[1]||'');
  return {text:String(row[0]||''), savedAt:savedAt};
}

// NPB 하루치 스탯 텍스트([경기N] 블록)를 한 칸에 통째로 저장 — KBO와 같은 방식, 시트만 분리
function npbSheet_(){
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sh=ss.getSheetByName('NPB');
  if(!sh){ sh=ss.insertSheet('NPB'); sh.appendRow(['text','savedAt']); }
  return sh;
}
function saveNpb_(text){
  var sh=npbSheet_();
  var savedAt=new Date().toISOString(); // 저장 시각은 서버가 찍음
  sh.clearContents();
  sh.appendRow(['text','savedAt']);
  sh.appendRow([text, savedAt]);
  return savedAt;
}
function readNpb_(){
  var sh=npbSheet_();
  var data=sh.getDataRange().getValues();
  if(data.length<2)return {text:'',savedAt:''};
  var row=data[1];
  var savedAt=row[1] instanceof Date?row[1].toISOString():String(row[1]||'');
  return {text:String(row[0]||''), savedAt:savedAt};
}

// 마감배당(배트맨 고정배당) 텍스트 — 리그마다 한 행. 리그별로 나눠야 MLB 수집이 KBO 값을 지우지 않는다.
function closeOddsSheet_(){
  var ss=SpreadsheetApp.getActiveSpreadsheet();
  var sh=ss.getSheetByName('CloseOdds');
  if(!sh){ sh=ss.insertSheet('CloseOdds'); sh.appendRow(['league','text','savedAt']); }
  return sh;
}
function saveCloseOdds_(league,text){
  var sh=closeOddsSheet_();
  var savedAt=new Date().toISOString(); // 저장 시각은 서버가 찍음
  var data=sh.getDataRange().getValues();
  for(var i=1;i<data.length;i++){
    if(String(data[i][0])===league){ sh.getRange(i+1,1,1,3).setValues([[league,text,savedAt]]); return savedAt; }
  }
  sh.appendRow([league,text,savedAt]);
  return savedAt;
}
function readCloseOdds_(){
  var sh=closeOddsSheet_();
  var data=sh.getDataRange().getValues();
  var out=[];
  for(var i=1;i<data.length;i++){
    if(!data[i][0])continue;
    var savedAt=data[i][2] instanceof Date?data[i][2].toISOString():String(data[i][2]||'');
    out.push({league:String(data[i][0]), text:String(data[i][1]||''), savedAt:savedAt});
  }
  return {entries:out};
}

function json_(obj){
  return ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(ContentService.MimeType.JSON);
}

// 픽 식별키: 저장시각(초 단위 정규화)|리그|경기|마켓|픽 — 사이트 쪽 pickKey와 동일 규칙.
// v3: league·match를 키에 추가(이전엔 savedAt|market|pick뿐이라, 같은 배치 저장(=savedAt 동일)에
// 여러 경기가 "승패/기준팀승"처럼 같은 마켓·픽 문구를 공유하면 서로 다른 경기인데도 같은 행으로 겹쳐써졌음).
function keyOf_(savedAt,date,league,match,market,pick){
  var s=savedAt instanceof Date?savedAt.toISOString():String(savedAt||date||'');
  var t=Date.parse(s);
  var norm=isNaN(t)?s:new Date(t).toISOString().slice(0,19);
  return norm+'|'+(league||'')+'|'+(match||'')+'|'+market+'|'+pick;
}

// 같은 키의 픽이 있으면 그 행을 갱신, 없으면 추가. finalize=true면 아카이브 표시(모든 기기 목록에서 제외)
function upsertPicks_(picks,finalize){
  var sh=sheet_();
  var data=sh.getDataRange().getValues();
  var rowByKey={};
  for(var i=1;i<data.length;i++){rowByKey[keyOf_(data[i][0],data[i][1],data[i][2],data[i][3],data[i][4],data[i][5])]=i;}
  picks.forEach(function(p){
    if(finalize)p.archived='1';
    var key=keyOf_(p.savedAt,p.date,p.league,p.match,p.market,p.pick);
    var i=rowByKey[key];
    if(i===-1)return;
    if(i!==undefined){
      var row=HEADERS.map(function(h,c){ var v=p[h]!==undefined?p[h]:data[i][c]; return v===undefined?'':v; });
      sh.getRange(i+1,1,1,HEADERS.length).setValues([row]);
      data[i]=row;
    } else {
      sh.appendRow(HEADERS.map(function(h){ return p[h]!==undefined?p[h]:''; }));
      rowByKey[key]=-1;
    }
  });
}

function deletePicks_(keys){
  var sh=sheet_();
  var data=sh.getDataRange().getValues();
  var set={}; keys.forEach(function(k){set[k]=true;});
  for(var i=data.length-1;i>=1;i--){
    if(set[keyOf_(data[i][0],data[i][1],data[i][2],data[i][3],data[i][4],data[i][5])])sh.deleteRow(i+1);
  }
}

function readAll_(){
  var sh=sheet_();
  var data=sh.getDataRange().getValues();
  var picks=[];
  for(var i=1;i<data.length;i++){
    var row=data[i]; if(!row[0]&&!row[1])continue;
    var obj={}; HEADERS.forEach(function(h,idx){ obj[h]=row[idx]!==undefined?row[idx]:''; });
    picks.push(obj);
  }
  return picks;
}