<?php 
header('location://mgr.aiacademy.tw/mgr/');exit;


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

define('TBL_MGR_STUDENTS','mgr_students');

class MgrStudents{
  static function encode_pwd($pwd_plaintext){
    return md5('@Students'.$pwd_plaintext.'AIA');
  }
  static function insert($school_no, $pwd_plaintext){
    global$wpdb;
    $pwd = self::encode_pwd($pwd_plaintext);
    $wpdb->insert(TBL_MGR_STUDENTS, array('school_no'=>$school_no, 'pwd'=>$pwd));
  }
  static function login_result($school_no,$pwd){
    global$wpdb;
    $pwd_encode = self::encode_pwd($pwd);
    $school_no=strtolower($school_no);
    $sql='SELECT * FROM '.TBL_MGR_STUDENTS.' WHERE school_no="'.$school_no.'" AND `pwd`="'.$pwd_encode.'"';
    return $wpdb->get_row($sql);
  }
  static function get($school_no){
    global$wpdb;
    return $wpdb->get_row('SELECT * FROM '.TBL_MGR_STUDENTS.' WHERE school_no="'.$school_no.'"');
  }
  static function delete($school_no){
    global$wpdb;
    $wpdb->delete(TBL_MGR_STUDENTS, array('school_no'=>$school_no));
  }
  static function update_pwd($school_no, $new_pwd){
    global$wpdb;
    $wpdb->update(TBL_MGR_STUDENTS, array('pwd'=>self::encode_pwd($new_pwd)), array('school_no'=>$school_no));
  }
}