user_login,array('vansindata'))){
die('not allow, please login or contact Web Developer.');
}
if($_POST){
$t = isset($_POST['t']) ? $_POST['t'] : '';
$now = now();
foreach(preg_split("/(\r\n|\n|\r)/",$t) as$k=>$v){
if(strpos($v,"\t")===false){
echo$v.'未含tab鍵分隔符號
';
continue;
}
$a = explode("\t", $v);
// $doc_id = $a[0]; # my doc which could be viewed by anyone
// $gid = $a[1]; # my doc which could be viewed by anyone
$xlass = $a[0];
if(strpos($a[1], '@no-email.tw')!==false){ // first used at https://aiacademy.tw/admission-ai-campaign-st/
list($__username, $__) = explode('@',$a[1]);
$a[1] = md5($__username).'@no-email.tw';
}
$temp = normalize_aia_email($a[1],false);
if(!trim($temp)){$temp = 'laksdjflkajsfasllasdf@gmail.com';}
$email = normalize_aia_email($temp);
$name = $a[2];
$name_public = $name;
// $name_public_prefix = mb_substr($name, 0, 1);
// $name_public_suffix = mb_substr($name, -1);
// $name_public = $name_public_prefix . str_repeat('●',mb_strlen($name)-2) . $name_public_suffix;
if($tmp = $wpdb->get_row('SELECT * FROM '.TBL_AM_I_STUDENT.' WHERE name_public="'.$name_public
.'" AND row_position="'.($k+1)
.'" AND xlass="'.$xlass.'"')
){
echo'Already existed '.$name_public.' @ '.$tmp->create_datetime.'
';
}else{
$wpdb->insert(TBL_AM_I_STUDENT,array(
'xlass'=>$xlass,
'name_hashed'=>AmIStudent::get_username_encodehash($name),
'email_hashed'=>AmIStudent::get_email_encodehash($email),
'row_position'=>$k+1,
'create_datetime'=>$now,
'name_public'=>$name_public,
));
echo 'Done insert for '.$name_public.'
';
}
}
}
?>
Classes:
$v){
echo $k.'='.$v['txt'].'#'.$v['doc'].'#'.$v['gid'].'
';
} ?>
班級代號有如:
匯入格式:
班級代號見上{tab鍵}Email{tab鍵}姓名
如:
a{tab鍵}ming@gmail.com{tab鍵}王小明
c{tab鍵}huang@gmail.com{tab鍵}王小華