if (get_magic_quotes_gpc()) {
$data = stripslashes($_POST['data']);
} else {
$data = $_POST['data'];
}
$obj = json_decode($data, true);
$orderID = $obj["orderID"];
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
$select_array = array("orderID" => $orderID);
$selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array);
if (!$selectDetail) {
$db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
$detailNum = 0;
while ($record = mysql_fetch_array($selectDetail)) {
$detailNum++;
}
if ($detailNum > 0) {
$selectRoot = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array);
if (!$selectRoot) {
$db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
$rootfetch = mysql_fetch_array($selectRoot);
$wordNum = (int) $rootfetch["wordNum"];
if ($detailNum >= $wordNum) {
$db_utils->responseError($start_time, "無法加入，單字已經達上限！", 300, $user_link);
} else {
$data = $_POST['data'];
}
$obj = json_decode($data, true);
$orderID = $obj["orderID"];
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
$select_array = array("orderID" => $orderID);
$selectOrder = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array);
$orderRecord = mysql_fetch_array($selectOrder);
$wordNum = (int) $orderRecord['wordNum'];
$selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array);
if (!$selectDetail) {
$db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
$code = 0;
while ($record = mysql_fetch_array($selectDetail)) {
$code++;
}
if ($code != $wordNum) {
$db_utils->responseError($start_time, "單字尚未選滿！要選好選滿R！", 209, $user_link);
}
$obj["status"] = 2;
if (!$db_utils->updateData($user_link, TableName::getOrderTable, $obj, "orderID", $orderID)) {
$db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
$res["message"] = "更新資料成功！";
$db_utils->response($start_time, $res, $user_link);
} else {
include "../../../utils/tokenUtils.php";
$data = $_POST["data"];
if (get_magic_quotes_gpc()) {
$data = stripslashes($_POST['data']);
} else {
$data = $_POST['data'];
}
$obj = json_decode($data, true);
$db_utils = new DatabaseUtils();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
$select_array = array();
$select_obj = $db_utils->selectTableAnd($user_link, TableName::getENTypeTable, $select_array);
if (!$select_obj) {
$db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
$list = array();
while ($record = mysql_fetch_array($select_obj)) {
$get["enTypeID"] = $record['enTypeID'];
$get["enTypeName"] = $record['enTypeName'];
$get["create_time"] = $record['create_time'];
$get["update_time"] = $record['update_time'];
array_push($list, $get);
}
$res["list"] = $list;
$res["message"] = "取得資料成功！";
$db_utils->response($start_time, $res, $user_link);
} else {
$db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
$obj = json_decode($data, true);
$orderID = $obj["orderID"];
$isTest = $obj["isTest"];
/*1.測試模式0.英文模式*/
$db_utils = new DatabaseUtils();
$update_time = TimeUtils::getNowTime();
$start_time = TimeUtils::getNowTime();
$user_link = $db_utils->initUserDatabase();
if (mysql_select_db(DBName::getUserDB)) {
$select_array = array("orderID" => $orderID);
$selectOrder = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array);
$orderRecord = mysql_fetch_array($selectOrder);
$status = (int) $orderRecord['status'];
if ($isTest != 1) {
if ($status == 2) {
$db_utils->responseError($start_time, "尚未上傳成績！請點擊上傳按鈕！", 209, $user_link);
}
if ($status == 4) {
$db_utils->responseError($start_time, "已經結算過了！", 163, $user_link);
}
}
$wordNum = (int) $orderRecord['wordNum'];
$score = 100 / $wordNum;
$selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array);
if (!$selectDetail) {
$db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link);
}
$list = array();
$userScore = 100;
while ($detailRecord = mysql_fetch_array($selectDetail)) {
$enWordID = $detailRecord['enWordID'];
