<?php

die('{"code":998,"msg":"deprecated"}');

$__email = isset($_POST['e']) ? $_POST['e'] : '';
if(!$__email){
  die('{"code":999}');
}

require_once __DIR__.'/../wp-config.php';

$exam_link = '';
$gs_gid = isset($_POST['id']) ? get_post_meta($_POST['id']+0, 'gs_gid', true) : null; # might be '0' , '1093644638' and so on.
$IS_EXAM_LINK_V2 = strlen($gs_gid)>0; // version2: Every tester has different exam_link. (from 2019.05.30)

if($IS_EXAM_LINK_V2){ // get source
  $google_spreadsheet_tsv_url = 'https://docs.google.com/spreadsheets/d/14p9wmcmpvFfslUZTKdIdbhEB5mHPO_sDTUZ53OzLYaI/export?format=tsv&gid='.$gs_gid;
}else{ # version1 start....
$refer = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';

$HC_TECH_GID = '155346449';
$HC_MGR_GID = '527395722';
$TP_TECH_GID = '12564820';
$TP_MGR_GID = '';
$TC_TECH_GID = '2004076912';
$TC_MGR_GID = '';
$KH_TECH_GID = '';
$KH_MGR_GID = '';

$gid=strpos($refer, '/hc-tech-2-exam')!==false ? $HC_TECH_GID : $HC_MGR_GID;
$gid=$TC_TECH_GID;
$google_spreadsheet_tsv_url = 'https://docs.google.com/spreadsheets/d/1aLbB9GBuj5jylqfidh-FVDemtRPjThha-0VqnzaWfLU/export?format=tsv&gid='.$gid;

if(isset($_POST['id'])){
  $exam_link = get_post_meta($_POST['id']+0, 'exam_link', true);
}

} // end of IS_EXAM_LINK_V2


$output = array('data'=>null, 'code'=>1);

$s = file_get_contents($google_spreadsheet_tsv_url);
$a = preg_split("/(\r\n|\n|\r)/",$s);
$__email = trim(strtolower($__email));

if($IS_EXAM_LINK_V2){ // get exam_link
  foreach($a as$v){
    if(strpos($v,'@')===false){continue;}
    $v = explode("\t", $v);
    if($__email===trim(strtolower($v[0]))){
      $exam_link = trim($v[1]);
      $output = array('data'=>$exam_link, 'code'=>0, 'msg'=>'');
      break;
    }
  }
}else{ // version1
foreach($a as$v){
  $v = explode("\t", $v);
  $is_cancel = strpos($v[0],'取消')!==false;
  if(!$is_cancel && $__email===trim(strtolower($v[1]))){
    $output = array('data'=>$exam_link, 'code'=>0, 'msg'=>'');
    break;
  }
}
} // end of IS_EXAM_LINK_V2

$output['aia'] = $gid; #debug
$output['aia2'] = $refer; #debug
die(json_encode($output));