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); $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) {
include "../../../database/DatabaseUtils.php"; include "../../../utils/TimeUtils.php"; 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 {
include "../../../utils/TimeUtils.php"; 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); $enWordID = $obj["enWordID"]; $db_utils = new DatabaseUtils(); $start_time = TimeUtils::getNowTime(); $user_link = $db_utils->initUserDatabase(); if (mysql_select_db(DBName::getUserDB)) { $select_enWord = array("enWordID" => $enWordID); $select_obj = $db_utils->selectTableAnd($user_link, TableName::getENWordTable, $select_enWord); if (!$select_obj) { $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link); } $record = mysql_fetch_array($select_obj); $get["enWord"] = $record['enWord']; $get["enWordID"] = $record['enWordID']; $get["enTypeID"] = $record['enTypeID']; $get["create_time"] = $record['create_time']; $get["update_time"] = $record['update_time']; $definitionList = array(); $translateList = array(); $exampleList = array(); $definitionDiry = $db_utils->selectTableAnd($user_link, TableName::getWordDefinitionTable, $select_enWord); while ($definitionRecord = mysql_fetch_array($definitionDiry)) { $getDefinition["enDefinitionID"] = $definitionRecord['enDefinitionID'];
if (get_magic_quotes_gpc()) { $data = stripslashes($_POST['data']); } else { $data = $_POST['data']; } $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);
$data = $_POST['data']; } $obj = json_decode($data, true); $orderID = $obj["orderID"]; if (!$orderID) { $db_utils->responseError($start_time, "get not found", 302, $user_link); } $showTranslate = $obj["showTranslate"]; $db_utils = new DatabaseUtils(); $update_time = TimeUtils::getNowTime(); $start_time = TimeUtils::getNowTime(); $user_link = $db_utils->initUserDatabase(); if (mysql_select_db(DBName::getUserDB)) { $res = array(); $select_array = array("orderID" => $orderID); $selectOrder = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array); $orderRecord = mysql_fetch_array($selectOrder); $res["orderID"] = $orderRecord['orderID']; $res["deviceAddress"] = $orderRecord['deviceAddress']; $res["userName"] = $orderRecord['userName']; $res["userYearOld"] = (int) $orderRecord['userYearOld']; $res["testTime"] = (int) $orderRecord['testTime']; $res["status"] = (int) $orderRecord['status']; $res["testResult"] = (int) $orderRecord['testResult']; $res["wordNum"] = (int) $orderRecord['wordNum']; $res["create_time"] = $orderRecord['create_time']; $res["update_time"] = $orderRecord['update_time']; $selectDetail = $db_utils->selectTableAnd($user_link, TableName::getOrderDetailTable, $select_array); if (!$selectDetail) { $db_utils->responseError($start_time, mysql_error(), mysql_errno(), $user_link); }
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); $status = $obj["status"]; $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("status" => $status); $selectOrder = $db_utils->selectTableAnd($user_link, TableName::getOrderTable, $select_array); $list = array(); while ($orderRecord = mysql_fetch_array($selectOrder)) { $res["orderID"] = $orderRecord['orderID']; $res["deviceAddress"] = $orderRecord['deviceAddress']; $res["userName"] = $orderRecord['userName']; $res["userYearOld"] = (int) $orderRecord['userYearOld']; $res["testTime"] = (int) $orderRecord['testTime']; $res["status"] = (int) $orderRecord['status']; $res["testResult"] = (int) $orderRecord['testResult']; $res["wordNum"] = (int) $orderRecord['wordNum']; $res["create_time"] = $orderRecord['create_time']; $res["update_time"] = $orderRecord['update_time']; array_push($list, $res); } $over["list"] = $list;