public function defaultAction()
{
$pageSize = 50;
// 获取参数
$page = Pager::get();
$contestId = (int) Request::getGET('contest-id');
$status = (int) Request::getGET('status', -1);
$contestInfo = OjContestInterface::getById(array('id' => $contestId));
if (empty($contestInfo) || $contestInfo['hidden'] || $contestInfo['type'] != ContestVars::TYPE_APPLY) {
$this->renderError('竞赛不存在，或者竞赛不需要报名！');
}
// 构建where
$where = array();
$where[] = array('contest_id', '=', $contestId);
if ($status != -1) {
$where[] = array('status', '=', $status);
}
// 获取数据
$offset = ($page - 1) * $pageSize;
$applyList = OjContestApplyInterface::getList(array('where' => $where, 'limit' => $pageSize, 'offset' => $offset));
$allCount = OjContestApplyInterface::getCount($where);
// userHash
$userIds = array_unique(array_column($applyList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
$this->renderFramework(array('html' => $html, 'applyList' => $applyList, 'contestInfo' => $contestInfo, 'userHash' => $userHash), 'contest/apply_list.php');
}
public function defaultAction()
{
$pageSize = 20;
// 获取参数
$page = Pager::get();
$status = (int) Request::getGET('status', -1);
$contestId = (int) Request::getGET('contest-id', 0);
$where = array();
$where[] = array('is_diy', '=', 0);
if (!empty($contestId)) {
$where[] = array('contest_id', '=', $contestId);
}
if ($status != -1) {
$where[] = array('status', '=', $status);
}
// 获取数据
$offset = ($page - 1) * $pageSize;
$applyList = OjContestApplyInterface::getList(array('where' => $where, 'limit' => $pageSize, 'offset' => $offset));
$allCount = 0;
$userHash = array();
$contestHash = array();
if (!empty($applyList)) {
$allCount = OjContestApplyInterface::getCount($where);
$userIds = array_column($applyList, 'user_id');
$userHash = UserCommonInterface::getById(array('id' => $userIds));
$contestIds = array_unique(array_column($applyList, 'contest_id'));
$contestHash = OjContestInterface::getById(array('id' => $contestIds));
}
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
$this->renderFramework(array('html' => $html, 'applyList' => $applyList, 'contestHash' => $contestHash, 'userHash' => $userHash), 'contest/apply_list.php');
}
public function defaultAction()
{
$pageSize = 15;
$problemId = Request::getGET('problem-id');
$language = (int) Request::getGET('language', -1);
$result = (int) Request::getGET('result', -1);
// 获取id
$maxId = (int) Request::getGET('max-id', -1);
$minId = (int) Request::getGET('min-id', -1);
// 获取用户创建的所有题目
$where = array(array('remote', '=', StatusVars::REMOTE_HQU), array('user_id', '=', $this->loginUserInfo['id']));
$problemList = OjProblemInterface::getList(array('field' => 'problem_id', 'where' => $where));
$problemIds = array_column($problemList, 'problem_id');
// 构建where
$where = array(array('user_id', '=', $this->loginUserInfo['id']), array('solution_id', '=', 0), array('problem_id', 'IN', $problemIds));
if (!empty($problemId)) {
// HQOJ上的题目，problem_code和problem_id相同
$where[] = array('problem_id', '=', $problemId);
}
if ($language != -1) {
$where[] = array('language', '=', $language);
}
if ($result != -1) {
$where[] = array('result', '=', $result);
}
// 获取judgeList
if ($maxId != -1) {
$where[] = array('id', '<=', $maxId);
$judgeList = OjJudgeInterface::getList(array('where' => $where, 'order' => array('id' => 'DESC'), 'limit' => $pageSize));
} else {
if ($minId != -1) {
$where[] = array('id', '>=', $minId);
$judgeList = OjJudgeInterface::getList(array('where' => $where, 'order' => array('id' => 'ASC'), 'limit' => $pageSize));
$judgeList = array_reverse($judgeList, true);
} else {
$judgeList = OjJudgeInterface::getList(array('where' => $where, 'order' => array('id' => 'DESC'), 'limit' => $pageSize));
}
}
// 获取userHash
$userIds = array_unique(array_column($judgeList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 格式化solution
foreach ($judgeList as &$judgeInfo) {
$text = StatusVars::$RESULT_FORMAT[$judgeInfo['result']];
$class = StatusVars::$RESULT_CLASS[$judgeInfo['result']];
$judgeInfo['result_html'] = sprintf('<span class="%s">%s</span>', $class, $text);
}
// 计算minId, maxId
$minId = $maxId = 0;
if (!empty($judgeList)) {
$judgeIds = array_keys($judgeList);
$maxId = $judgeIds[0];
$minId = end($judgeIds);
}
// 缓存html
$html = array();
$html['pager'] = $this->view->fetch(array('renderMaxId' => $maxId, 'renderMinId' => $minId), 'widget/pager_status.php');
// render
$this->renderFramework(array('userHash' => $userHash, 'judgeList' => $judgeList, 'html' => $html), 'setup/problem/judge_list.php');
}
public function defaultAction()
{
$pageSize = 20;
// 获取参数
$page = Pager::get();
$title = Request::getGET('title');
$status = (int) Request::getGET('status');
// 构建where
$where = array(array('user_id', '=', $this->loginUserInfo['id']), array('is_diy', '=', 1));
if (!empty($status) && $status != -1) {
$where[] = array('hidden', '=', $status - 1);
}
if (!empty($title)) {
$where[] = array('title', 'LIKE', "%{$title}%");
}
// 获取数据
$offset = ($page - 1) * $pageSize;
$contestList = OjContestInterface::getList(array('where' => $where, 'limit' => $pageSize, 'offset' => $offset));
$allCount = 0;
if (!empty($contestList)) {
$allCount = OjContestInterface::getCount($where);
}
$userIds = array_unique(array_column($contestList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
// 输出
$this->renderFramework(array('contestList' => $contestList, 'userHash' => $userHash, 'html' => $html), 'setup/contest/list.php');
}
public function defaultAction()
{
$pageSize = 50;
$page = Pager::get();
$category = (int) Request::getGET('category', -1);
$title = trim(Request::getGET('title', ''));
$username = trim(Request::getGET('username', ''));
$where = array();
if ($category != -1) {
$where[] = array('category', '=', $category);
}
if (!empty($username)) {
$userInfo = UserCommonInterface::getByLoginName(array('login_name' => $username));
$where[] = array('user_id', '=', Arr::get('id', $userInfo, 0));
}
if (!empty($title)) {
$where[] = array('title', 'LIKE', "%{$title}%");
}
if ($category != -1) {
$order = array('hidden' => 'ASC', 'title' => 'ASC', 'id' => 'DESC');
} else {
$order = array('id' => 'DESC');
}
$offset = ($page - 1) * $pageSize;
$docList = DocInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'offset' => $offset));
$allCount = empty($docList) ? 0 : DocInterface::getCount($where);
$userIds = array_unique(array_column($docList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 7), 'widget/pager.php');
$this->renderFramework(array('html' => $html, 'docList' => $docList, 'userHash' => $userHash), 'doc/list.php');
}
public function defaultAction()
{
$pageSize = 20;
// 获取参数
$page = Pager::get();
$status = (int) Request::getGET('status');
// 构建where
$where = array();
$where[] = array('remote', '=', StatusVars::REMOTE_HQU);
$where[] = array('user_id', '=', $this->loginUserInfo['id']);
if (!empty($status) && $status != -1) {
$where[] = array('hidden', '=', $status - 1);
}
// 获取数据
$offset = ($page - 1) * $pageSize;
$problemList = OjProblemInterface::getList(array('where' => $where, 'limit' => $pageSize, 'offset' => $offset));
$allCount = OjProblemInterface::getCount($where);
$userIds = array_unique(array_column($problemList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 5), 'widget/pager.php');
// 输出
$this->renderFramework(array('problemList' => $problemList, 'userHash' => $userHash, 'html' => $html), 'setup/problem/list.php');
}
public function iframeChangeAction()
{
$docId = (int) Request::getGET('doc-id');
$docInfo = DocInterface::getById(array('id' => $docId));
if (empty($docInfo)) {
$this->renderError('文章不存在！');
}
$userInfo = UserCommonInterface::getById(array('id' => $docInfo['user_id']));
$this->renderIframe(array('userInfo' => $userInfo, 'docInfo' => $docInfo), 'doc/iframe/change.php');
}
public function defaultAction()
{
$docId = (int) Request::getGET('doc-id');
$docInfo = DocInterface::getById(array('id' => $docId));
if (empty($docInfo)) {
$this->renderError();
}
$userInfo = UserCommonInterface::getById(array('id' => $docInfo['user_id']));
$this->renderFramework(array('docInfo' => $docInfo, 'userInfo' => $userInfo), 'doc/detail.php');
}
public function iframeRemoveAction()
{
$managerId = Request::getGET('manager-id', 0);
$managerInfo = RootManagerInterface::getById(array('id' => $managerId));
if (empty($managerInfo)) {
$this->renderIframeError('管理员不存在！');
}
$userInfo = UserCommonInterface::getById(array('id' => $managerInfo['user_id']));
$this->renderIframe(array('userInfo' => $userInfo), 'manager/iframe/remove_path.php');
}
public function defaultAction()
{
$pageSize = 100;
// 获取参数
$page = Pager::get();
$remote = (int) Request::getGET('remote', 0);
$keyword = Request::getGET('keyword');
$searchType = (int) Request::getGET('search-type', 1);
// 构建where
$where = array();
$where[] = array('remote', '=', $remote);
$where[] = array('hidden', '=', 0);
if (!empty($keyword)) {
if ($searchType == 1) {
$where[] = array('OR' => array(array('problem_code', '=', $keyword), array('title', 'LIKE', "%{$keyword}%")));
} else {
if ($searchType == 2) {
$where[] = array('OR' => array(array('problem_code', '=', $keyword), array('source', 'LIKE', "%{$keyword}%")));
}
}
}
// 获取数据
$order = array('problem_code' => 'ASC');
$offset = ($page - 1) * $pageSize;
$problemList = OjProblemInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'offset' => $offset));
$allCount = OjProblemInterface::getCount($where);
// 获取用户解决的题目
$userSolution = array();
if ($this->loginUserInfo) {
$globalIds = array_column($problemList, 'id');
$where = array(array('user_id', '=', $this->loginUserInfo['id']), array('contest_id', '=', 0), array('problem_global_id', 'IN', $globalIds));
$solutionList = OjSolutionInterface::getList(array('where' => $where));
foreach ($solutionList as $solutionId => $solutionInfo) {
$globalId = $solutionInfo['problem_global_id'];
if (!array_key_exists($globalId, $userSolution) || $solutionInfo['result'] == StatusVars::ACCEPTED) {
$userSolution[$globalId] = $solutionInfo;
}
}
}
$userHash = array();
if ($allCount > 0) {
$userIds = array_unique(array_column($problemList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
}
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 10), 'widget/pager.php');
$tpl = $remote ? 'problem/list_remote.php' : 'problem/list.php';
// 输出
$this->renderFramework(array('html' => $html, 'problemList' => $problemList, 'userSolution' => $userSolution, 'userHash' => $userHash), $tpl);
}
public function defaultAction()
{
$pageSize = 50;
// 获取参数
$page = Pager::get();
$title = Request::getGET('title');
$status = (int) Request::getGET('status');
$username = Request::getGET('username');
// userInfo
$userInfo = array();
if (!empty($username)) {
$userInfo = UserCommonInterface::getByLoginName(array('login_name' => $username));
}
// 构建where
if (!empty($username) && empty($userInfo)) {
$where = false;
} else {
$where = array();
if (!empty($userInfo)) {
$where[] = array('user_id', '=', $userInfo['id']);
}
if (!empty($status) && $status != -1) {
$where[] = array('hidden', '=', $status - 1);
}
if (!empty($title)) {
$where[] = array('title', 'LIKE', "%{$title}%");
}
}
$order = array('listing_status' => 'DESC', 'refresh_at' => 'DESC', 'id' => 'DESC');
$offset = ($page - 1) * $pageSize;
$setList = OjProblemSetInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'offset' => $offset));
$allCount = 0;
if (!empty($setList)) {
$allCount = OjProblemSetInterface::getCount($where);
}
foreach ($setList as &$setInfo) {
$globalIds = (array) json_decode($setInfo['problem_set'], true);
$setInfo['count'] = count($globalIds);
}
// 获取用户
$userIds = array_unique(array_column($setList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
// 输出
$this->renderFramework(array('html' => $html, 'setList' => $setList, 'userHash' => $userHash), 'set/list.php');
}
public function defaultAction()
{
// 如果已经选定专题，那么跳转
if (Request::getGET('from') == 'nav') {
$setId = (int) Cookie::get('current_set');
if ($setId) {
$url = '/set_problem/?set-id=' . $setId;
Url::redirect($url);
}
}
Cookie::delete('current_set');
$pageSize = 50;
// 获取参数
$page = Pager::get();
$title = Request::getGET('title');
$username = Request::getGET('username');
// 构建where
$where = array();
$where[] = array('hidden', '=', 0);
if (!empty($title)) {
$where[] = array('title', 'LIKE', "%{$title}%");
}
if (!empty($username)) {
$userInfo = UserCommonInterface::getByLoginName(array('login_name' => $username));
$where[] = array('user_id', '=', Arr::get('id', $userInfo, 0));
}
// 获取列表
$order = array('listing_status' => 'DESC', 'refresh_at' => 'DESC', 'id' => 'DESC');
$offset = ($page - 1) * $pageSize;
$setList = OjProblemSetInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'offset' => $offset));
$allCount = OjProblemSetInterface::getCount($where);
foreach ($setList as &$setInfo) {
$problemJson = $setInfo['problem_set'];
$globalIds = json_decode($problemJson, true);
$setInfo['count'] = count($globalIds);
}
// 获取用户
$userHash = array();
if (!empty($setList)) {
$userIds = array_unique(array_column($setList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
}
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
// 输出
$this->renderFramework(array('html' => $html, 'setList' => $setList, 'userHash' => $userHash), 'set/list.php');
}
public function iframeShowAction()
{
$solutionId = (int) Request::getGET('solution-id');
$solutionInfo = OjSolutionInterface::getDetail(array('id' => $solutionId));
if (empty($solutionInfo) || false == OjSolutionHelper::hasLog($solutionInfo)) {
$this->renderError();
}
// 获取属主
$userId = $solutionInfo['user_id'];
$userInfo = UserCommonInterface::getById(array('id' => $userId));
// 是否有权限查看，竞赛管理员，自己的solution
if (!$this->isContestAdmin && $solutionInfo['user_id'] != $this->loginUserInfo['id']) {
$this->renderError('您没有权限查看！');
}
$this->renderIframe(array('solutionInfo' => $solutionInfo), 'status/iframe/judge_log.php');
}
public function iframeShowAction()
{
$solutionId = (int) Request::getGET('solution-id');
$solutionInfo = OjSolutionInterface::getDetail(array('id' => $solutionId));
if (empty($solutionInfo) || false == OjSolutionHelper::hasLog($solutionInfo)) {
$this->renderError();
}
// 获取属主
$userId = $solutionInfo['user_id'];
$userInfo = UserCommonInterface::getById(array('id' => $userId));
// solution level
list($solutionInfo['level'], $solutionInfo['permission']) = OjSolutionHelper::solutionPermission($solutionInfo, $userInfo['share'], Arr::get('id', $this->loginUserInfo, 0), $this->isOjAdmin);
if (!$solutionInfo['permission']) {
$this->renderError('您没有权限查看！');
}
$this->renderIframe(array('solutionInfo' => $solutionInfo), 'status/iframe/judge_log.php');
}
public function defaultAction()
{
$pageSize = 20;
// 获取参数
$page = Pager::get();
$status = (int) Request::getGET('status', -1);
$contestId = (int) Request::getGET('contest-id', 0);
// 获取属于用户的竞赛
$where = array(array('user_id', '=', $this->loginUserInfo['id']), array('is_diy', '=', 1));
$contestHash = OjContestInterface::getList(array('where' => $where));
$contestHash = Arr::listToHash('id', $contestHash);
$contestIds = array_keys($contestHash);
$userHash = array();
$applyList = array();
$allCount = 0;
if (!empty($contestIds)) {
if ($contestId > 0 && !in_array($contestId, $contestIds)) {
$where = false;
} else {
if ($contestId > 0 && in_array($contestId, $contestIds)) {
$where = array(array('contest_id', '=', $contestId));
} else {
$where = array(array('contest_id', 'IN', $contestIds));
}
}
if (false !== $where) {
if ($status != -1) {
$where[] = array('status', '=', $status);
}
$offset = ($page - 1) * $pageSize;
$applyList = OjContestApplyInterface::getList(array('where' => $where, 'limit' => $pageSize, 'offset' => $offset));
if (!empty($applyList)) {
$allCount = OjContestApplyInterface::getCount($where);
$userIds = array_column($applyList, 'user_id');
$userHash = UserCommonInterface::getById(array('id' => $userIds));
}
}
}
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
$this->renderFramework(array('html' => $html, 'applyList' => $applyList, 'contestHash' => $contestHash, 'userHash' => $userHash), 'setup/contest/apply_list.php');
}
public function defaultAction()
{
$solutionId = (int) Request::getGET('solution-id');
// 获取solutionInfo
$solutionInfo = OjSolutionInterface::getDetail(array('id' => $solutionId));
if (empty($solutionInfo)) {
$this->renderError();
}
// 获取属主
$userId = $solutionInfo['user_id'];
$userInfo = UserCommonInterface::getById(array('id' => $userId));
if (empty($userInfo)) {
$this->renderError();
}
// 是否有权限查看，竞赛管理员，自己的solution
if (!$this->isContestAdmin && $solutionInfo['user_id'] != $this->loginUserInfo['id']) {
$this->renderError('您没有权限查看！');
}
$this->renderFramework(array('solutionInfo' => $solutionInfo), 'status/code.php');
}
public function defaultAction()
{
$solutionId = (int) Request::getGET('solution-id');
// 获取solutionInfo
$solutionInfo = OjSolutionInterface::getDetail(array('id' => $solutionId));
if (empty($solutionInfo)) {
$this->renderError();
}
// 获取属主
$userId = $solutionInfo['user_id'];
$userInfo = UserCommonInterface::getById(array('id' => $userId));
if (empty($userInfo)) {
$this->renderError();
}
// solution level
list($solutionInfo['level'], $solutionInfo['permission']) = OjSolutionHelper::solutionPermission($solutionInfo, $userInfo['share'], Arr::get('id', $this->loginUserInfo, 0), $this->isOjAdmin);
if (!$solutionInfo['permission']) {
$this->renderError('您没有权限查看！');
}
$this->renderFramework(array('solutionInfo' => $solutionInfo), 'status/code.php');
}
public static function save($data, $id = 0, $trans = null)
{
if (!empty($trans)) {
$model = new OjProblemModel($trans);
} else {
$model = new OjProblemModel();
}
if (0 == $id) {
$userInfo = UserCommonInterface::getById(array('id' => $data['user_id']));
if (empty($userInfo)) {
throw new InterfaceException('用户不存在！');
}
$history = '';
if ($data['remote'] == StatusVars::REMOTE_HQU) {
$dataTime = date('Y-m-d H:i:s', time());
$history = "<p>{$dataTime} 用户{$userInfo['username']}新建了题目</p>";
}
$insertData = array('user_id' => $data['user_id'], 'remote' => $data['remote'], 'time_limit' => Arr::get('time_limit', $data, 1000), 'memory_limit' => Arr::get('memory_limit', $data, 32768), 'hidden' => $data['remote'] == StatusVars::REMOTE_HQU ? 1 : 0, 'audit_history' => $history);
if ($data['remote'] == StatusVars::REMOTE_HQU) {
// 如果添加是华大题目
if (!isset($data['problem_id'])) {
$where = array(array('remote', '=', $data['remote']));
$lastInfo = self::getRow('MAX(problem_id) AS max_problem_id', $where);
$lastId = Arr::get('max_problem_id', $lastInfo, 999);
$insertData['problem_id'] = $lastId + 1;
$insertData['problem_code'] = $lastId + 1;
}
} else {
$insertData['problem_id'] = $data['problem_id'];
$insertData['problem_code'] = $data['problem_code'];
}
$id = $model->insert($insertData);
return $id;
} else {
// 对某些字段特殊处理
$updateData = $data;
$affects = $model->updateById($id, $updateData);
return $affects;
}
}
public function defaultAction()
{
$setId = (int) Request::getGET('set-id');
if (empty($setId)) {
$this->renderError();
}
$setInfo = OjProblemSetInterface::getById(array('id' => $setId));
if (empty($setInfo)) {
$this->renderError();
}
if (!$this->isOjAdmin && $setInfo['hidden'] && $this->loginUserInfo['id'] != $setInfo['user_id']) {
Cookie::delete('current_set');
$this->renderError('您没有权限查看！');
}
// 设置当前的set
Cookie::set('current_set', $setId);
$problemJson = $setInfo['problem_set'];
$globalIds = (array) json_decode($problemJson, true);
// 按照$globalIds顺序
$problemList = OjProblemInterface::getById(array('id' => $globalIds));
// 获取用户解决的题目
$userSolution = array();
if ($this->loginUserInfo) {
$where = array(array('problem_global_id', 'IN', $globalIds), array('user_id', '=', $this->loginUserInfo['id']));
$solutionList = OjSolutionInterface::getList(array('where' => $where));
foreach ($solutionList as $solutionInfo) {
$globalId = $solutionInfo['problem_global_id'];
if (!array_key_exists($globalId, $userSolution) || $solutionInfo['result'] == StatusVars::ACCEPTED) {
$userSolution[$globalId] = $solutionInfo;
}
}
}
// userInfo
$userInfo = UserCommonInterface::getById(array('id' => $setInfo['user_id']));
$this->renderFramework(array('setInfo' => $setInfo, 'problemList' => $problemList, 'userSolution' => $userSolution, 'userInfo' => $userInfo), 'set/set_problem.php');
}
public function defaultAction()
{
$pageSize = 15;
// 获取参数
$username = Request::getGET('username');
$language = (int) Request::getGET('language', -1);
$result = (int) Request::getGET('result', -1);
$problemHash = Request::getGET('problem-hash');
$maxId = (int) Request::getGET('max-id', -1);
$minId = (int) Request::getGET('min-id', -1);
$globalId = array_search($problemHash, $this->contestInfo['problem_hash']);
// 获取userInfo，username转换为userId
$userInfo = array();
if (!empty($username)) {
$userInfo = UserCommonInterface::getByLoginName(array('login_name' => $username));
}
// 构建where
$where = array();
$where[] = array('contest_id', '=', $this->contestInfo['id']);
$where[] = array('hidden', '=', 0);
$where[] = array('problem_global_id', 'IN', $this->contestInfo['global_ids']);
if (!empty($username)) {
$where[] = array('user_id', '=', Arr::get('id', $userInfo, 0));
}
if (!empty($globalId)) {
$where[] = array('problem_global_id', '=', $globalId);
}
if ($language != -1) {
$where[] = array('language', '=', $language);
}
if ($result != -1) {
$where[] = array('result', '=', $result);
}
// 获取solutionList
if ($maxId != -1) {
$where[] = array('solution_id', '<=', $maxId);
$solutionList = OjSolutionInterface::getList(array('where' => $where, 'order' => array('id' => 'DESC'), 'limit' => $pageSize, 'include_contest' => true));
} else {
if ($minId != -1) {
$where[] = array('solution_id', '>=', $minId);
$solutionList = OjSolutionInterface::getList(array('where' => $where, 'order' => array('id' => 'ASC'), 'limit' => $pageSize, 'include_contest' => true));
$solutionList = array_reverse($solutionList, true);
} else {
$solutionList = OjSolutionInterface::getList(array('where' => $where, 'order' => array('id' => 'DESC'), 'limit' => $pageSize, 'include_contest' => true));
}
}
// 获取userHash
$userIds = array_unique(array_column($solutionList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 格式化solution
foreach ($solutionList as &$solutionInfo) {
$solutionInfo['permission'] = false;
if ($this->isContestAdmin || $solutionInfo['user_id'] == $this->loginUserInfo['id']) {
$solutionInfo['permission'] = true;
}
$solutionInfo['has_log'] = OjSolutionHelper::hasLog($solutionInfo);
}
// 如果是报名，获取报名列表
$applyHash = array();
if ($this->contestInfo['type'] == ContestVars::TYPE_APPLY) {
$where = array(array('contest_id', '=', $this->contestInfo['id']));
$applyHash = OjContestApplyInterface::getList(array('where' => $where));
$applyHash = Arr::listToHash('user_id', $applyHash);
}
// 计算minId, maxId
$minId = $maxId = 0;
if (!empty($solutionList)) {
$solutionIds = array_keys($solutionList);
$maxId = $solutionIds[0];
$minId = end($solutionIds);
}
// 缓存html
$html = array();
$html['pager'] = $this->view->fetch(array('renderMaxId' => $maxId, 'renderMinId' => $minId), 'widget/pager_status.php');
// render
$this->renderFramework(array('userHash' => $userHash, 'solutionList' => $solutionList, 'html' => $html, 'applyHash' => $applyHash), 'status/list.php');
}
private static function updateResult($id, $result, $trans = null)
{
$solutionInfo = self::getById($id);
if (empty($solutionInfo)) {
throw new InterfaceException('solution不存在！');
}
$innerTrans = $trans;
if (null == $trans) {
$innerTrans = new Trans(DbConfig::$SERVER_TRANS);
$innerTrans->begin();
}
$solutionModel = new OjSolutionModel($innerTrans);
$remote = $solutionInfo['remote'];
$globalId = $solutionInfo['problem_global_id'];
$userId = $solutionInfo['user_id'];
$contestId = $solutionInfo['contest_id'];
// 如果状态从 非AC -> AC，那么修改user表和problem表，竞赛状态下不改变
if (0 == $contestId && $result == StatusVars::ACCEPTED && $solutionInfo['result'] != StatusVars::ACCEPTED) {
// 判断是否没有AC过
$where = array(array('problem_global_id', '=', $globalId), array('user_id', '=', $userId), array('result', '=', StatusVars::ACCEPTED), array('contest_id', '=', 0));
$count = self::getCount($where);
if (0 == $count) {
$userInfo = UserCommonInterface::getById(array('id' => $userId));
$problemInfo = OjProblemInterface::getById(array('id' => $globalId));
$remoteStr = strtolower(StatusVars::$REMOTE_SCHOOL[$remote]);
UserCommonInterface::save(array('trans' => $innerTrans, 'id' => $userId, 'solved_all' => $userInfo['solved_all'] + 1, "solved_{$remoteStr}" => $userInfo["solved_{$remoteStr}"] + 1));
OjProblemInterface::save(array('trans' => $innerTrans, 'id' => $globalId, 'solved' => $problemInfo['solved'] + 1));
}
}
// 如果状态从 AC -> 非AC，那么修改user表和problem表，竞赛状态下不改变
if (0 == $contestId && $result != StatusVars::ACCEPTED && $solutionInfo['result'] == StatusVars::ACCEPTED) {
// 判断是否只AC过一次
$where = array(array('problem_global_id', '=', $globalId), array('user_id', '=', $userId), array('result', '=', StatusVars::ACCEPTED), array('contest_id', '=', 0));
$count = self::getCount($where);
if (1 == $count) {
$userInfo = UserCommonInterface::getById(array('id' => $userId));
$problemInfo = OjProblemInterface::getById(array('id' => $globalId));
$remoteStr = strtolower(StatusVars::$REMOTE_SCHOOL[$remote]);
UserCommonInterface::save(array('trans' => $innerTrans, 'id' => $userId, 'solved_all' => $userInfo['solved_all'] - 1, "solved_{$remoteStr}" => $userInfo["solved_{$remoteStr}"] - 1));
OjProblemInterface::save(array('trans' => $innerTrans, 'id' => $globalId, 'solved' => $problemInfo['solved'] - 1));
}
}
// 更新solution
$affects = $solutionModel->updateById($id, array('result' => $result));
if (null == $trans && null != $innerTrans) {
// 没有外部事务，并且存在内部事务
$innerTrans->commit();
}
return $affects;
}
public static function getRankBoard($id)
{
$contestInfo = self::getDetail($id);
if (empty($contestInfo)) {
throw new InterfaceException('专题不存在！');
}
// 取出提交记录
$where = array(array('contest_id', '=', $id), array('result', '>=', 4), array('problem_global_id', 'IN', $contestInfo['global_ids']));
$order = array('id' => 'ASC');
$solutionList = OjSolutionInterface::getList(array('field' => 'id,user_id,problem_global_id,result,contest_submit_second', 'where' => $where, 'order' => $order, 'include_contest' => true));
// 计算$rankHash
$rankHash = array();
$mat = array();
$firstBlood = array();
// 标记第一滴血
foreach ($solutionList as $solutionInfo) {
$globalId = $solutionInfo['problem_global_id'];
$userId = $solutionInfo['user_id'];
$result = $solutionInfo['result'];
if (!isset($rankHash[$userId])) {
$rankHash[$userId]['solved'] = 0;
$rankHash[$userId]['cost_second'] = 0;
}
if (!isset($mat[$userId][$globalId])) {
$mat[$userId][$globalId] = array('accepted' => 0, 'first_blood' => 0, 'fail_count' => 0, 'pass_second' => 0);
}
// 已经通过的，直接continue
if ($mat[$userId][$globalId]['accepted']) {
continue;
}
// 如果这条solution是accepted
if ($result == StatusVars::ACCEPTED) {
// 记录到mat
$mat[$userId][$globalId]['accepted'] = 1;
$mat[$userId][$globalId]['pass_second'] = $solutionInfo['contest_submit_second'];
if (!isset($firstBlood[$globalId])) {
$mat[$userId][$globalId]['first_blood'] = 1;
$firstBlood[$globalId] = 1;
}
// 记录到rankHash
$rankHash[$userId]['solved']++;
$rankHash[$userId]['cost_second'] += $mat[$userId][$globalId]['pass_second'] + $mat[$userId][$globalId]['fail_count'] * 20 * 60;
continue;
} else {
$mat[$userId][$globalId]['fail_count']++;
}
}
uasort($rankHash, array('OjContestLogic', 'cmp'));
// 获取用户信息
$userIds = array_unique(array_column($solutionList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
return array($rankHash, $mat, $userHash);
}
public function defaultAction()
{
$pageSize = 15;
$username = Request::getGET('username');
$remote = (int) Request::getGET('remote', -1);
$problemCode = Request::getGET('problem-code');
// 因为ZOJ的题号是code
$language = (int) Request::getGET('language', -1);
$result = (int) Request::getGET('result', -1);
$contestId = (int) Request::getGET('contest-id');
$globalId = (int) Request::getGET('global-id');
// 获取id
$maxId = (int) Request::getGET('max-id', -1);
$minId = (int) Request::getGET('min-id', -1);
// 获取userInfo，username转换为userId
$userInfo = array();
if (!empty($username)) {
$userInfo = UserCommonInterface::getByLoginName(array('login_name' => $username));
}
// 构建where
$where = array();
if ($this->isOjAdmin) {
if ($contestId) {
$where[] = array('contest_id', '=', $contestId);
}
}
if (!empty($username)) {
$where[] = array('user_id', '=', Arr::get('id', $userInfo, 0));
}
if ($remote != -1) {
$where[] = array('remote', '=', $remote);
}
if (!empty($problemCode)) {
$where[] = array('problem_code', '=', $problemCode);
}
if (!empty($globalId)) {
$where[] = array('problem_global_id', '=', $globalId);
}
if ($language != -1) {
$where[] = array('language', '=', $language);
}
if ($result != -1) {
$where[] = array('result', '=', $result);
}
// 获取solutionList
if ($maxId != -1) {
$where[] = array('id', '<=', $maxId);
$order = array('id' => 'DESC');
$solutionList = OjSolutionInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'include_contest' => $this->isOjAdmin));
} else {
if ($minId != -1) {
$where[] = array('id', '>=', $minId);
$order = array('id' => 'ASC');
$solutionList = OjSolutionInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'include_contest' => $this->isOjAdmin));
$solutionList = array_reverse($solutionList, true);
} else {
$order = array('id' => 'DESC');
$solutionList = OjSolutionInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'include_contest' => $this->isOjAdmin));
}
}
// 获取userHash
$userIds = array_unique(array_column($solutionList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 格式化solution
foreach ($solutionList as &$solutionInfo) {
// level
$userInfo = $userHash[$solutionInfo['user_id']];
list($solutionInfo['level'], $solutionInfo['permission']) = OjSolutionHelper::solutionPermission($solutionInfo, $userInfo['share'], Arr::get('id', $this->loginUserInfo, 0), $this->isOjAdmin);
$solutionInfo['has_log'] = OjSolutionHelper::hasLog($solutionInfo);
}
// 计算minId, maxId
$minId = $maxId = 0;
if (!empty($solutionList)) {
$n = count($solutionList);
$maxId = $solutionList[0]['id'];
$minId = $solutionList[$n - 1]['id'];
}
// 缓存html
$html = array();
$html['pager'] = $this->view->fetch(array('renderMaxId' => $maxId, 'renderMinId' => $minId), 'widget/pager_status.php');
$tpl = $this->isOjAdmin ? 'status/list_admin.php' : 'status/list.php';
// render
$this->renderFramework(array('userHash' => $userHash, 'solutionList' => $solutionList, 'html' => $html), $tpl);
}
public function defaultAction()
{
$pageSize = 20;
// 获取参数
$page = Pager::get();
$title = Request::getGET('title');
$passed = (int) Request::getGET('passed', 0);
$diy = (int) Request::getGET('diy', 0);
// 构建where
$where = array();
$where[] = array('hidden', '=', 0);
if ($passed) {
$where[] = array('end_time', '<=', time());
} else {
$where[] = array('end_time', '>', time());
}
if ($diy) {
$where[] = array('is_diy', '=', 1);
} else {
$where[] = array('is_diy', '=', 0);
}
if (!empty($title)) {
$where[] = array('title', 'LIKE', "%{$title}%");
}
if ($passed) {
$order = array('end_time' => 'DESC');
} else {
$order = array('end_time' => 'ASC');
}
// 获取数据
$offset = ($page - 1) * $pageSize;
$tmpContestList = OjContestInterface::getList(array('where' => $where, 'order' => $order, 'limit' => $pageSize, 'offset' => $offset));
$allCount = OjContestInterface::getCount($where);
// 将进行中的比赛提前
$contestList = array();
if (!$passed) {
foreach ($tmpContestList as $i => $contestInfo) {
if ($contestInfo['begin_time'] < time()) {
$contestList[] = $contestInfo;
unset($tmpContestList[$i]);
}
}
foreach ($tmpContestList as $i => $contestInfo) {
$contestList[] = $contestInfo;
unset($tmpContestList[$i]);
}
} else {
$contestList = $tmpContestList;
}
$userIds = array_unique(array_column($contestList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
// 格式化
foreach ($contestList as &$contestInfo) {
// row_class
$now = time();
if ($contestInfo['end_time'] < $now) {
$contestInfo['row_css'] = 'passed';
} else {
if ($contestInfo['begin_time'] > $now) {
$contestInfo['row_css'] = 'pending';
} else {
$contestInfo['row_css'] = 'running';
}
}
// type_format
$type = $contestInfo['type'];
if ($type == ContestVars::TYPE_PUBLIC) {
$contestInfo['type_format'] = '<p class="red">公开</p>';
} else {
if ($type == ContestVars::TYPE_APPLY) {
$contestInfo['type_format'] = '<p class="orange">报名</p>';
} else {
if ($type == ContestVars::TYPE_PASSWORD) {
$contestInfo['type_format'] = '<p class="green">密码</p>';
} else {
$contestInfo['type_format'] = '<p class="gray">未定义</p>';
}
}
}
}
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
// 输出
$this->renderFramework(array('contestList' => $contestList, 'userHash' => $userHash, 'html' => $html), 'contest/list.php');
}
public static function getRankBoard($id)
{
$setInfo = self::getById($id);
if (empty($setInfo)) {
throw new InterfaceException('专题不存在！');
}
$globalIds = json_decode($setInfo['problem_set'], true);
if (empty($globalIds)) {
return array(array(), array(), array());
}
// 取出提交记录
$where = array(array('problem_global_id', 'IN', $globalIds), array('result', '>=', 4));
$order = array('id' => 'ASC');
$solutionList = OjSolutionInterface::getList(array('field' => 'id,user_id,problem_global_id,result', 'where' => $where, 'order' => $order));
// 计算$rankHash
$rankHash = array();
$mat = array();
$firstBlood = array();
// 标记第一滴血
foreach ($solutionList as $solutionInfo) {
$globalId = $solutionInfo['problem_global_id'];
$userId = $solutionInfo['user_id'];
$result = $solutionInfo['result'];
if (!isset($rankHash[$userId])) {
$rankHash[$userId]['solved'] = 0;
$rankHash[$userId]['all_fail_count'] = 0;
}
if (!isset($mat[$userId][$globalId])) {
$mat[$userId][$globalId] = array();
$mat[$userId][$globalId]['fail_count'] = 0;
}
// 已经通过的，直接continue
if (isset($mat[$userId][$globalId]['accepted'])) {
continue;
}
// 如果这条solution是accepted
if ($result == StatusVars::ACCEPTED) {
$mat[$userId][$globalId]['accepted'] = 1;
$rankHash[$userId]['solved']++;
// 标记1血
if (!isset($firstBlood[$globalId])) {
$mat[$userId][$globalId]['first_blood'] = 1;
$firstBlood[$globalId] = 1;
}
continue;
} else {
$mat[$userId][$globalId]['fail_count']++;
$rankHash[$userId]['all_fail_count']++;
}
}
uasort($rankHash, array('OjProblemSetLogic', 'cmp'));
// 获取用户信息
$userIds = array_unique(array_column($solutionList, 'user_id'));
$userHash = UserCommonInterface::getById(array('id' => $userIds));
return array($rankHash, $mat, $userHash);
}
public function defaultAction()
{
$pageSize = 20;
$page = Pager::get();
$loginName = Request::getGET('login-name', '');
$path = Request::getGET('path', '');
$includePath = Request::getGET('include-path', '');
// 路径非法提示
if (!empty($path)) {
if (!RootPermissionInterface::isValidPath(array('path' => $path))) {
$this->setNotice(FrameworkVars::NOTICE_ERROR, "路径{$path}格式不正确！");
$url = Url::getCurrentUrl(array('path' => null));
Url::redirect($url);
}
}
// 路径非法提示
if (!empty($includePath)) {
if (!RootPermissionInterface::isValidPath(array('path' => $includePath))) {
$this->setNotice(FrameworkVars::NOTICE_ERROR, "路径{$includePath}格式不正确！");
$url = Url::getCurrentUrl(array('include-path' => null));
Url::redirect($url);
}
}
// 用户不存在提示
if (!empty($loginName)) {
$userInfo = UserCommonInterface::getByLoginName(array('login_name' => $loginName));
if (empty($userInfo)) {
$this->setNotice(FrameworkVars::NOTICE_ERROR, '用户不存在！');
$url = Url::getCurrentUrl(array('login-name' => null));
Url::redirect($url);
}
}
// 构建where
$where = array();
if (!empty($userInfo)) {
$where[] = array('user_id', '=', $userInfo['id']);
}
if (!empty($path)) {
$managerIds = RootManagerInterface::getAllowedManagerIds(array('path' => $path));
$where[] = array('id', 'IN', $managerIds);
}
if (!empty($includePath)) {
$managerIds = RootManagerInterface::getIncludeManagerIds(array('path' => $includePath));
$where[] = array('id', 'IN', $managerIds);
}
$offset = ($page - 1) * $pageSize;
$managerList = RootManagerInterface::getList(array('where' => $where, 'limit' => $pageSize, 'offset' => $offset));
$allCount = RootManagerInterface::getCount($where);
$userList = array();
$pathHash = array();
if (!empty($managerList)) {
$userIds = array_column($managerList, 'user_id');
$userList = UserCommonInterface::getById(array('id' => $userIds));
$userList = Arr::listToHash('id', $userList);
// 获取权限列表
$managerIds = array_column($managerList, 'id');
$pathHash = RootManagerInterface::getPaths(array('id' => $managerIds));
}
// 找出invalid path
$invalidHash = array();
foreach ($pathHash as $id => $pathSet) {
foreach ($pathSet as $tmpPath) {
if (array_key_exists($tmpPath, $invalidHash)) {
continue;
}
$invalidHash[$tmpPath] = RootPermissionInterface::findPath(array('path' => $tmpPath)) ? 0 : 1;
}
}
// 缓存部分的html
$html = array();
$html['pager'] = $this->view->fetch(array('renderAllCount' => $allCount, 'renderPageSize' => $pageSize, 'renderRadius' => 8), 'widget/pager.php');
$this->renderFramework(array('html' => $html, 'managerList' => $managerList, 'userList' => $userList, 'pathHash' => $pathHash, 'invalidHash' => $invalidHash), 'manager/list.php');
}
