<?php

session_start();

if(!(isset($_SESSION['wojiaonixue_internal_login_status']) AND $_SESSION['wojiaonixue_internal_login_status'] == 'active')){

header("Location:login.html");

exit();

}

header('Access-Control-Allow-Origin:*');

require_once("config.php");

require_once("processUtil.php");

require_once("globalData.php");

$codeParser = new CodeParser();

$conn = new mysqli($host, $user, $password, $database);

if($_GET&&$_GET["requestMethod"]){

$requestMethod = trim($_GET["requestMethod"]);

if($requestMethod == "getTransactions"){

echo getTransactions($conn);

}else if($requestMethod == "getTransactionsByStatus"){

getTransactionsByStatus($conn);

}else if($requestMethod == "myRecord"){

getMyRecord($conn);

}else if($requestMethod == "updateFollowStatus"){

updateFollowStatus($conn, $appid, $secret);

}else if($requestMethod == "manualCreateTransaction"){

manualCreateTransaction();

}

}

function manualCreateTransaction(){

}

function updateFollowStatus($conn, $appid, $secret){

}

function getUserDetails($openid, $appid, $secret){

}

function getTransactionsByStatus($conn){

}

function getTransactions($conn){

}

function getMyRecord($conn){

}

function endWith($haystack, $needle)

}

//处理POST数据

if($_POST){

$dataType = trim($_POST["dataType"]);

//老师注册

if($dataType == "teacherRegistration"){

$openid = trim($_POST["openid"]);

$name = trim($_POST["name"]);

$sex = trim($_POST["sex"]);

$school = trim($_POST["school"]);

$major = trim($_POST["major"]);

$studentNumber = trim($_POST["studentNumber"]);

$phone = trim($_POST["phone"]);

$desc = trim($_POST["desc"]);

$imgUrl = trim($_POST["imgUrl"]);

$options = $_POST["options"]; //array

$otheroptions = trim($_POST["otheroptions"]); //" " separated array

$price = trim($_POST["price"]);

$location = $_POST["location"]; //array

$location = implode(",",$location);

$highestGrade = trim($_POST["highestGrade"]);

//1，存入老师的基本信息，T_teacher，默认wechatAccount为空，extraDescription为空，rating为1，teacherStatus为R

$query = "set names utf8";

$result = $conn->query($query);

$query = "insert into T_teacher values('$openid','','$school','$major','$studentNumber','$name','$sex','$phone','$desc','',sysdate(),'1','$imgUrl','$price','$highestGrade','$location','I')";

$result = $conn->query($query);

//2，存入老师所有能教的科目，兴趣

$length = count($options);

$query = "set names utf8";

$result = $conn->query($query);

$query = "insert into T_offers(teacherOpenId,name,code,description,typeCode,typeName,status) values ";

for($i = 0;$i < $length;$i++){

$code = $options[$i];

$codeToName = array(

"A" => "舞蹈与音乐",

"B" => "体育运动",

"C" => "书法与美术",

"D" => "编程软件应用与棋类",

"E" => "演讲与播音主持",

"F" => "人文科学与小语种"

);

$typeCode = "";

$typeName = "";

$status = "R";

$localName = "";

if(stripos($code,"SU") !== false){

$typeCode = "SU";

$typeName = "科目";

if($code == "SU1"){

$localName = "语文";

}else if($code == "SU2"){

$localName = "数学";

}else if($code == "SU3"){

$localName = "英语";

}else{

$localName = "化学";

}

}else{

$queryString = "set names utf8";

$result = $conn->query($queryString);

$queryString = "select name from T_offers where code = '$code' limit 1";

$result = $conn->query($queryString);

$row = $result->fetch_assoc();

$localName = $row["name"];

$typeCode = substr($code,0,1);

$typeName = $codeToName[$typeCode];

}

if($i != 0){

$query = $query.",";

}

$query = $query."('$openid','$localName','$code','','$typeCode','$typeName','R')";

}

//3，存入其它的能教得科目，项目

if($otheroptions != ""){

$otheroptions = explode(" ",$otheroptions);

$length = count($otheroptions);

for($j = 0;$j < $length;$j++){

$localName = $otheroptions[$j];

$query = $query.",('$openid','$localName','','','','','R')";

}

}

$result = $conn->query($query);

$jsonArray = array(

'status' => "ok",

'dataType' => "teacherRegistration"

);

echo json_encode($jsonArray);

}

}

?>