wyoj-raw/app/controllers/index.php

<?php
$blogs = DB::selectAll("select blogs.id, title, poster, post_time from important_blogs, blogs where is_hidden = 0 and important_blogs.blog_id = blogs.id order by level desc, important_blogs.blog_id desc limit 8");
$activateusers = DB::selectAll("select submitter, count(*) as cnt from submissions where datediff(now(), submit_time) <= 30 group by submitter order by cnt desc limit 12;");
$topusers = DB::selectAll("select u.username, u.rating, u.rating_rd, u.rating_vol, u.motto, u.qq, count(*) cnt from user_info u inner join contests_registrants c on u.username = c.username inner join contests s on s.id = c.contest_id where datediff(now(), s.start_time) <= 180 group by c.username having cnt >= 3 order by rating desc, username asc limit 12;");
$hotusers = DB::selectAll("select username, rating, rating_rd, rating_vol, qq, motto from user_info order by rating_vol desc, username asc limit 12;");
$topblogs = DB::selectAll("select id from blogs order by zan desc limit 10;");
$songs_data = htmlspecialchars(json_encode(DB::selectAll("select * from songs;")), ENT_QUOTES, 'UTF-8');

// 服务器数据看板
$today_submit_num = DB::selectCount("select count(*) from submissions where date(submit_time) = date(now())");
$today_ac_num = DB::selectCount("select count(*) from submissions where date(submit_time) = date(now()) and score = 100");
$month_submit_num = DB::selectCount("select count(*) from submissions where year(submit_time) = year(now()) and month(submit_time) = month(now())");
$month_ac_num = DB::selectCount("select count(*) from submissions where year(submit_time) = year(now()) and month(submit_time) = month(now()) and score = 100");
$total_submit_num = DB::selectCount("select count(*) from submissions");
$total_ac_num = DB::selectCount("select count(*) from submissions where score = 100");
$total_problem_num = DB::selectCount("select count(*) from problems where is_hidden = 0");
$total_user_num = DB::selectCount("select count(*) from user_info");

// 最近比赛：未结束的按开始时间升序取，不足 5 场时补最近结束的
$recent_contests = array();
$result = DB::selectAll("select * from contests where status != 'finished' order by start_time asc, id asc limit 5");
foreach ($result as $contest) {
	genMoreContestInfo($contest);
	$recent_contests[] = $contest;
}
if (count($recent_contests) < 5) {
	$need = 5 - count($recent_contests);
	$result = DB::selectAll("select * from contests where status = 'finished' order by start_time desc, id desc limit $need");
	foreach ($result as $contest) {
		genMoreContestInfo($contest);
		$recent_contests[] = $contest;
	}
}
?>
<?php echoUOJPageHeader(UOJConfig::$data['profile']['oj-name-short']) ?>
<div id="songs-data" data-songs='<?php echo $songs_data; ?>'></div>

<div class="row shadow my-4 wyoj-topcard">
	<div class="card-body">
		<div class="row">
<!--			<div class="col-xs-6 col-sm-4 col-md-3">
				<img class="media-object img-thumbnail" src="/images/logo.png" alt="Logo" />
			</div>-->
			<div class="col-sm-12 col-md-9">
				<table class="table table-sm">
<!--					<thead>
						<tr>
							<th style="width:60%"><?= UOJLocale::get('announcements') ?></th>
							<th style="width:20%"></th>
							<th style="width:20%"></th>
						</tr>
					</thead>-->
				  	<tbody>
					<?php $now_cnt = 0; ?>
					<?php foreach ($blogs as $blog): ?>
						<?php
							$now_cnt++;
							$new_tag = '';
							if ((time() - strtotime($blog['post_time'])) / 3600 / 24 <= 7) {
								$new_tag = '<sup style="color:red">&nbsp;new</sup>';
							}
						?>
						<tr>
							<td><a href="/blogs/<?= $blog['id'] ?>"><?= $blog['title'] ?></a><?= $new_tag ?></td>
							<td>by <?= getUserLink($blog['poster']) ?></td>
							<td><small><?= $blog['post_time'] ?></small></td>
						</tr>
					<?php endforeach ?>
					<?php for ($i = $now_cnt + 1; $i <= 8; $i++): ?>
						<tr><td colspan="233">&nbsp;</td></tr>
					<?php endfor ?>
						<tr><td class="text-right" colspan="233">
							<span>本歌曲由 </span><span id="recommender"></span><span> 推荐</span>
						</td></tr>
						<tr><td class="text-right" colspan="233">
							<a href="https://git.ryp.org.cn/wyoj/" class="text-info font-weight-bold">WyOJ 以及所有相关项目均为自由软件。</a>
							<a href="/announcements"><?= UOJLocale::get('all the announcements') ?></a>
						</td></tr>
						<tr>
							<td class="text-right" colspan="233">
								<span class="text-danger font-weight-bold">声明：本网站属个人非经营性网站，仅用于学习交流，无任何盈利目的，与任何组织无关</span>
								<a href="/certs-manage/songs">我要推歌</a>
							</td>
						</tr>
					</tbody>
				</table>
			</div>
			<div class="col-xs-6 col-sm-4 col-md-3">


    
	<div class="card" style="max-width:300px; width:100%; border-radius:0; ">
        <div class="image-frame" style="aspect-ratio:1/1; position:relative;">
            <img id="photo" src="" alt="" style="width:100%; height:100%; object-fit:cover; display:block; cursor:pointer; -webkit-tap-highlight-color:transparent;">
        </div>
        <div class="intro" style="padding:1.6rem 1.8rem 1.2rem; text-align:center; background:#ffffff;">
            <p id="name" style="font-size:1.0rem; font-weight:800; letter-spacing:1px; margin-bottom:0.5rem; line-height:1.2; margin-block:0;"></p>
            <p id="amb" style="font-size:0.7rem; font-weight:400; color:#4f5d69; margin-bottom:0.25rem; line-height:1.5; border-top:1px dashed #cdd9e3; padding-top:0.8rem; white-space:pre-wrap; margin-block:0;"></p>
            <p id="writer" style="font-size:0.7rem; font-weight:400; color:#4f5d69; margin-bottom:0.25rem; line-height:1.5; white-space:pre-wrap; margin-block:0;"></p>
        </div>
        <div class="button-wrapper" style="padding:0.2rem 1.8rem 2rem 1.8rem; background:#ffffff;">
            <style>
                #randomBtn{
                    display: inline-flex;
                    align-items: center;
                    justify-content: center;
                    gap: 0.6rem;
                    width: 100%;
                    background: #1f2f3b;
                    color: white;
                    padding: 0.7rem 0;
                    cursor: pointer;
                    transition: all 0.2s ease;
                    letter-spacing: 0.5px;
                    border: 1px solid rgba(255, 255, 255, 0.2);
                    backdrop-filter: blur(4px);
                    font-family: inherit;
                    line-height: 1;
                }
            </style>
            <button id="randomBtn">换一首</button>
        </div>
    </div>
    <script>
        (function() {
            let dataDiv = document.getElementById('songs-data');
	    let library = JSON.parse(dataDiv.dataset.songs);

            const photoImg = document.getElementById('photo');
            const nameEl = document.getElementById('name');
            const ambEl = document.getElementById('amb');
            const writerEl = document.getElementById('writer');
            const randomBtn = document.getElementById('randomBtn');
            const recommenderEl = document.getElementById('recommender');

            let lastIndex = -1;
            let currentMusicLink = library[0].musiclink; 

            photoImg.addEventListener('mousedown', function(e) {
                this.style.opacity = '0.8';
            });
            photoImg.addEventListener('mouseup', function(e) {
                this.style.opacity = '';
            });
            photoImg.addEventListener('mouseleave', function(e) {
                this.style.opacity = '';
            });
            photoImg.addEventListener('touchstart', function(e) {
                this.style.opacity = '0.8';
            });
            photoImg.addEventListener('touchend', function(e) {
                this.style.opacity = '';
            });
            photoImg.addEventListener('touchcancel', function(e) {
                this.style.opacity = '';
            });
            function setBtnActive() {
                randomBtn.style.background = '#17242e';
                randomBtn.style.transform = 'scale(0.98)';
                randomBtn.style.boxShadow = '0 4px 8px rgba(0,0,0,0.2)';
            }
            function setBtnNormal() {
                randomBtn.style.background = '#1f2f3b';
                randomBtn.style.transform = 'scale(1)';
                randomBtn.style.boxShadow = 'none';
            }
            randomBtn.addEventListener('mousedown', setBtnActive);
            randomBtn.addEventListener('mouseup', setBtnNormal);
            randomBtn.addEventListener('mouseleave', setBtnNormal);
            randomBtn.addEventListener('touchstart', setBtnActive);
            randomBtn.addEventListener('touchend', setBtnNormal);
            randomBtn.addEventListener('touchcancel', setBtnNormal);

            photoImg.addEventListener('click', function() {
                if (currentMusicLink) {
                    window.open(currentMusicLink, '_blank');
                }
            });
	    function randmusic() {
	        let randid = lastIndex;
	        while (randid === lastIndex) {
	            randid = Math.floor(Math.random() * library.length);
		}

		if (lastIndex == -1) randid = 3;

		lastIndex = randid;
                const ys = library[randid];
                photoImg.src = ys.cover;
                photoImg.alt = ys.name;
                nameEl.textContent = ys.name;
                ambEl.textContent = ys.album;
		writerEl.textContent = ys.writer;
		recommenderEl.textContent = ys.user;
                currentMusicLink = ys.click;
            }

            randmusic();

            randomBtn.addEventListener('click', function() {
                randmusic();
            });

        })();
    </script>
</div>



		</div>
	</div>
</div>

<div class="row shadow my-4 wyoj-topcard">
	<div class="col-lg-6 p-4">
		<h3>服务器数据</h3>
		<div class="row">
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-flash"></span></div>
					<div class="stat-num"><?= $today_submit_num ?></div>
					<div class="stat-label">今日提交</div>
				</div>
			</div>
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-ok"></span></div>
					<div class="stat-num"><?= $today_ac_num ?></div>
					<div class="stat-label">今日通过</div>
				</div>
			</div>
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-send"></span></div>
					<div class="stat-num"><?= $month_submit_num ?></div>
					<div class="stat-label">本月提交</div>
				</div>
			</div>
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-check"></span></div>
					<div class="stat-num"><?= $month_ac_num ?></div>
					<div class="stat-label">本月通过</div>
				</div>
			</div>
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-tasks"></span></div>
					<div class="stat-num"><?= $total_submit_num ?></div>
					<div class="stat-label">总提交</div>
				</div>
			</div>
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-star"></span></div>
					<div class="stat-num"><?= $total_ac_num ?></div>
					<div class="stat-label">总通过</div>
				</div>
			</div>
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-list-alt"></span></div>
					<div class="stat-num"><?= $total_problem_num ?></div>
					<div class="stat-label">题目总数</div>
				</div>
			</div>
			<div class="col-6 col-lg-3 mb-3">
				<div class="card h-100 p-3 text-center stat-card">
					<div class="stat-icon"><span class="glyphicon glyphicon-user"></span></div>
					<div class="stat-num"><?= $total_user_num ?></div>
					<div class="stat-label">注册用户</div>
				</div>
			</div>
		</div>
	</div>
	<div class="col-lg-6 p-4">
		<h3>最近比赛</h3>
		<?php if (empty($recent_contests)): ?>
		<p class="text-muted">暂无比赛</p>
		<?php else: ?>
		<table class="table contest-table">
			<tbody>
			<?php foreach ($recent_contests as $contest): ?>
				<tr>
					<td class="contest-name">
						<a href="<?= HTML::url('/contest/' . $contest['id']) ?>"><?= $contest['name'] ?></a>
						<?php if ($contest['cur_progress'] == CONTEST_NOT_STARTED): ?>
						<span class="badge badge-info">即将开始</span>
						<span class="contest-countdown" id="recent-contest-countdown-<?= $contest['id'] ?>"></span>
						<?php elseif ($contest['cur_progress'] == CONTEST_IN_PROGRESS): ?>
						<span class="badge badge-success">进行中</span>
						<?php elseif ($contest['cur_progress'] == CONTEST_PENDING_FINAL_TEST): ?>
						<span class="badge badge-warning">等待出分</span>
						<?php elseif ($contest['cur_progress'] == CONTEST_TESTING): ?>
						<span class="badge badge-warning">最终评测中</span>
						<?php else: ?>
						<span class="badge badge-secondary">已结束</span>
						<?php endif ?>
					</td>
					<td class="contest-info"><?= $contest['start_time_str'] ?></td>
					<td class="contest-info"><?= round($contest['last_min'] / 60, 2) ?>h</td>
				</tr>
			<?php endforeach ?>
			</tbody>
		</table>
		<?php endif ?>
	</div>
</div>
<script type="text/javascript">
<?php foreach ($recent_contests as $contest): ?>
<?php if ($contest['cur_progress'] == CONTEST_NOT_STARTED): ?>
$('#recent-contest-countdown-<?= $contest['id'] ?>').countdown(<?= $contest['start_time']->getTimestamp() - UOJTime::$time_now->getTimestamp() ?>);
<?php endif ?>
<?php endforeach ?>
</script>
<div class="row shadow my-4 wyoj-topcard">
	<div class="col-12 p-4">
		<h3>活跃排行榜</h3>
	</div>
	<?php foreach($activateusers as $username): ?>
		<?php $user = queryUser($username['submitter']); ?>
		<div class="col-md-3 mb-4">
			<div class="card h-100 p-3 text-center">
				<img class="uoj-avatar mx-auto mb-2" src=<?= "https://q.qlogo.cn/g?b=qq&nk=" . $user['qq'] . "&s=100" ?> alt="...">
				<span class="mb-2"><?= getUserLink($user['username']) ?></span>
				<span class="text-center text-bottom"><?= $user['motto'] ?></span>
			</div>
		</div>
	<?php endforeach ?>
</div>
<div class="row shadow my-4 wyoj-topcard">
	<div class="col-12 p-4">
		<h3>比赛排行榜（180天内三场及以上比赛）</h3>
		<a href="/ranklist">全部排名</a>
	</div>
	<?php foreach($topusers as $user): ?>
		<div class="col-md-3 mb-4">
			<div class="card h-100 p-3 text-center">
				<img class="uoj-avatar mx-auto mb-2" src=<?= "https://q.qlogo.cn/g?b=qq&nk=" . $user['qq'] . "&s=100" ?> alt="...">
				<span class="mb-2"><?= getUserLink($user['username']) ?></span>
				<strong style="color: red" class="mb-2"><?= $user['rating'] ?> (±<?= round($user['rating_rd']) * 2 ?>)</strong>
				<span class="text-center text-bottom"><?= $user['motto'] ?></span>
			</div>
		</div>
	<?php endforeach ?>
</div>
<div class="row shadow my-4 wyoj-topcard">
	<div class="col-12 p-4">
		<h3>黑马 / 爆冷榜</h3>
	</div>
	<?php foreach($hotusers as $user): ?>
		<div class="col-md-3 mb-4">
			<div class="card h-100 p-3 text-center">
				<img class="uoj-avatar mx-auto mb-2" src=<?= "https://q.qlogo.cn/g?b=qq&nk=" . $user['qq'] . "&s=100" ?> alt="...">
				<span class="mb-2"><?= getUserLink($user['username']) ?></span>
				<strong style="color: red" class="mb-2">Vol <?= round(1000 * $user['rating_vol']) / 1000 ?>, <?= $user['rating'] ?> (±<?= round($user['rating_rd']) * 2 ?>)</strong>
				<span class="text-center text-bottom"><?= $user['motto'] ?></span>
			</div>
		</div>
	<?php endforeach ?>
</div>
<div class="row shadow my-4 wyoj-topcard">
	<div class="col-12 p-4">
		<h3>博客广场</h3>
	</div>

	<?php 
		foreach ($topblogs as $id) echo echoBlogCard(queryBlog($id['id']));
	?>
</div>
<?php echoUOJPageFooter() ?>