public ActionResult Index(int deviceNumber)
{
Device device = AppData.DeviceList[deviceNumber];
// Show ranking list only from round 2 onwards, if applicable
if (device.RoundNumber > 1 && Settings.ShowRanking == 1)
{
RankingList rankingList = new RankingList(deviceNumber);
// Only show the ranking list if it contains something meaningful
if (rankingList != null && rankingList.Count != 0 && rankingList[0].ScoreDecimal != 0 && rankingList[0].ScoreDecimal != 50)
{
if (device.TableNumber == 0)
{
ViewData["Header"] = $"Table {device.SectionTableString} - Round {device.RoundNumber}";
ViewData["Title"] = $"Ranking List - {device.SectionTableString}";
}
else
{
ViewData["Header"] = $"Table {device.SectionTableString}:{device.Direction} - Round {device.RoundNumber}";
ViewData["Title"] = $"Ranking List - {device.SectionTableString}:{device.Direction}";
}
ViewData["Buttons"] = ButtonOptions.OKVisible;
if (rankingList.TwoWinners)
{
return(View("TwoWinners", rankingList));
}
else
{
return(View("OneWinner", rankingList));
}
}
}
return(RedirectToAction("Index", "Move", new { deviceNumber }));
}
public ActionResult Final(int deviceNumber)
{
RankingList rankingList = new RankingList(deviceNumber);
// Don't show the ranking list if it doesn't contain anything useful
if (rankingList == null || rankingList.Count == 0 || rankingList[0].ScoreDecimal == 0 || rankingList[0].ScoreDecimal == 50)
{
return(RedirectToAction("Index", "EndScreen", new { deviceNumber }));
}
else
{
Device device = AppData.DeviceList[deviceNumber];
rankingList.FinalRankingList = true;
ViewData["Buttons"] = ButtonOptions.OKVisible;
ViewData["Header"] = $"Table {device.SectionTableString}:{device.Direction} - Round {device.RoundNumber}";
ViewData["Title"] = $"Ranking List - {device.SectionTableString}:{device.Direction}";
if (rankingList.TwoWinners)
{
return(View("TwoWinners", rankingList));
}
else
{
return(View("OneWinner", rankingList));
}
}
}
public void showRankList(RankingList rankingList)
{
maleGroups.Clear();
femaleGroups.Clear();
updateMale(rankingList);
updateFemale(rankingList);
}
public bool PunchClock(Model.RankingList rankingList, out string msg, out int rankingID)
{
// 是否满足打卡时间
int hour = rankingList.SendTime.Hour;
if (!(hour > 4 && hour < 7))
{
msg = "请在每日4.00 -- 7.00内打卡";
rankingID = -1;
return(false);
}
// 查询是否当日已打卡
if (IsToDayPunchClock(rankingList.SenderIP))
{
msg = "今日已经打卡啦，明日继续保持哦";
rankingID = GetTodayRankingID(rankingList.SenderIP);
return(false);
}
// 正常打卡
RankingList addModel = this.CurrentDal.AddEntity(rankingList);
// 会话层同一执行保存
// 注意：这里必须先于rankingID获取，不然不先保存就无法获取 此次添加的实体的主键RID
bool isSuccess = this.CurrentDbSession.SaveChanges();
// 获取此次打卡在当天的排名名次
rankingID = GetTodayRankingID(addModel.RID);
msg = $"成功早起打卡，你的 今日早起打卡排名： 第{rankingID}名";
return(isSuccess);
}
public JsonResult PollRanking(int tabletDeviceNumber)
{
HttpContext.Response.AppendHeader("Connection", "close");
RankingList rankingList = new RankingList(tabletDeviceNumber);
return(Json(rankingList, JsonRequestBehavior.AllowGet));
}
public ActionResult Final(int tabletDeviceNumber)
{
TabletDeviceStatus tabletDeviceStatus = AppData.TabletDeviceStatusList[tabletDeviceNumber];
RankingList rankingList = new RankingList(tabletDeviceNumber);
// Only show the ranking list if it contains something meaningful
if (rankingList == null || rankingList.Count == 0 || rankingList[0].ScoreDecimal == 0 || rankingList[0].ScoreDecimal == 50)
{
return(RedirectToAction("Index", "EndScreen", new { tabletDeviceNumber }));
}
else
{
rankingList.FinalRankingList = true;
ViewData["Header"] = $"Table {tabletDeviceStatus.Location} - Round {tabletDeviceStatus.RoundNumber}";
ViewData["Title"] = $"Final Ranking List - {tabletDeviceStatus.Location}";
ViewData["ButtonOptions"] = ButtonOptions.OKEnabled;
if (AppData.IsIndividual)
{
return(View("Individual", rankingList));
}
else if (rankingList.Exists(x => x.Orientation == "E"))
{
return(View("TwoWinners", rankingList));
}
else
{
return(View("OneWinner", rankingList));
}
}
}
public ActionResult Index(int tabletDeviceNumber)
{
TabletDeviceStatus tabletDeviceStatus = AppData.TabletDeviceStatusList[tabletDeviceNumber];
if (tabletDeviceStatus.RoundNumber > 1) // Show ranking list only from round 2 onwards
{
if (Settings.ShowRanking == 1)
{
RankingList rankingList = new RankingList(tabletDeviceNumber);
// Only show the ranking list if it contains something meaningful
if (rankingList != null && rankingList.Count != 0 && rankingList[0].ScoreDecimal != 0 && rankingList[0].ScoreDecimal != 50)
{
ViewData["Header"] = $"{tabletDeviceStatus.Location} - Round {tabletDeviceStatus.RoundNumber}";
ViewData["Title"] = $"Ranking List - {tabletDeviceStatus.Location}";
ViewData["ButtonOptions"] = ButtonOptions.OKEnabled;
if (AppData.IsIndividual)
{
return(View("Individual", rankingList));
}
else if (rankingList.Exists(x => x.Orientation == "E"))
{
return(View("TwoWinners", rankingList));
}
else
{
return(View("OneWinner", rankingList));
}
}
}
}
return(RedirectToAction("Index", "ShowMove", new { tabletDeviceNumber, newRoundNumber = tabletDeviceStatus.RoundNumber + 1 }));
}
private static List <RankingList> GetRankings(List <int> years, List <string> rankStrings)
{
List <RankingList> result = new List <RankingList>();
for (int i = 0; i < years.Count; i++)
{
RankingList list = new RankingList();
list.Year = years[i];
int nextStop = rankStrings.Count();
if (i < years.Count - 1)
{
nextStop = rankStrings.IndexOf(years[i + 1].ToString());
}
var oneYearRank = rankStrings
.Skip(rankStrings.IndexOf(years[i].ToString()) + 1)
.Take(
nextStop -
rankStrings.IndexOf(years[i].ToString())
- 1);
foreach (string rank in oneYearRank.Where(s => !string.IsNullOrWhiteSpace(s) && !s.Contains("(tie)")))
{
var split = rank.IndexOf('.');
list.Ranking.Add(new Ranking()
{
Rank = Convert.ToInt32(rank.Substring(0, split)),
Team = rank.Substring(split + 2, rank.Length - split - 2).Trim()
});
}
result.Add(list);
}
return(result);
}
public RankingContract(RankingList poll)
{
ParamIs.NotNull(() => poll);
CreateDate = poll.CreateDate;
Description = poll.Description;
Id = poll.Id;
Name = poll.Name;
NicoId = poll.NicoId;
Songs = poll.Songs.Select(m => new SongInRankingContract(m)).ToArray();
}
public (string TeamName, string ClubName) GetSelectedTeam()
{
var rankRow = RankingList.FirstOrDefault(rl => rl.TeamId == SelectedTeamId);
if (rankRow == null)
{
return(string.Empty, string.Empty);
}
return(rankRow.TeamName, rankRow.ClubName);
}
public ActionResult OnGetFriendList(GrimRequest request)
{
if (!request.TryGetParameterByKey("board_id", out var boardIdParam))
{
_logger.LogWarning("Got ranking getCount request without 'board_id'");
return(BadRequest());
}
var rankingList = new RankingList();
return(Ok(rankingList));
}
private RankingList LoadRanking()
{
if (File.Exists(path))
{
var json = File.ReadAllText(path);
return(JsonUtility.FromJson <RankingList>(json));
}
else
{
RankingList rankingList = new RankingList
{
Ranking = new List <Ranking>()
};
return(rankingList);
}
}
public void ShowRankingList()
{
// 播放音效
AudioClip clip = Resources.Load <AudioClip>("Sounds/Button");
AudioSource.PlayClipAtPoint(clip, Vector3.zero);
// 播放动画
Transform rlTrans = m_result.Find("RankingList");
Tweener tweener = rlTrans.DOScale(0.2f, 0);
tweener.OnComplete(() => {
// 显示排行榜
RankingList rankingList = rlTrans.GetComponent <RankingList>();
rankingList.gameObject.SetActive(true);
rankingList.UpdateRankingList(m_patternType);
// 显示
rlTrans.DOScale(1, 0.3f);
});
}
public static RankingList Get()
{
RankingList res = new RankingList();
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = "SELECT * FROM Ranking";
try
{
cmd = Methods.CreateBasicCommand(query);
dr = Methods.ExecuteDataReaderCommand(cmd);
while (dr.Read())
{
int idRanking = dr.GetInt32(0);
Ranking ranking = RankingDal.Get(idRanking);
res.Add(new Ranking()
{
RankingId = ranking.RankingId,
Puntuacion = ranking.Puntuacion,
});
}
}
catch (SqlException ex)
{
//Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace);
throw ex;
}
catch (Exception ex)
{
//Methods.GenerateLogsRelease("KeyValuePacienteListDal", "Obtener", ex.Message + " " + ex.StackTrace);
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(res);
}
public void GetRankingList(string rankingUrl)
{
//string RankingUrl = "http://www.hltv.org/ranking/teams/2017/january/2/";
//string RankingUrl = "http://www.hltv.org/ranking/teams/2017/january/9/";
//string RankingUrl = "http://www.hltv.org/ranking/teams/2017/january/16/";
//string RankingUrl = "http://www.hltv.org/ranking/teams/2017/january/23/";
var dateTime = GetDateTime(rankingUrl);
HtmlDocument rankingHtmlDocument = HWeb.Load(rankingUrl);
if (!db.RankingList.Any(s => s.DateOfRank == dateTime))
{
var rankingListId = Guid.NewGuid();
var rankingList = new RankingList
{
RankingListId = rankingListId,
DateOfRank = dateTime
};
db.RankingList.Add(rankingList);
var tablesHtml = "//*[@class='ranked-team standard-box']";
var results = rankingHtmlDocument.DocumentNode.SelectNodes(tablesHtml);
for (int i = 0; i < results.Count; i++)
{
var sTeamId = results[i].SelectNodes(".//*[@class='name js-link']");
var teamID = GetTeamIDs(sTeamId[0].OuterHtml);
var points = GetPoints(results[i].SelectNodes(".//*[@class='points']")[0].InnerHtml);
var ranking = new Rank
{
RankPosition = i + 1,
Points = points,
TeamId = teamID,
RankingListId = rankingListId
};
db.Rank.Add(ranking);
}
db.SaveChanges();
}
}
public void CreateWVRPoll(RankingContract contract)
{
HandleTransaction(session => {
var poll = new RankingList(contract);
foreach (var songContract in contract.Songs)
{
var c = songContract;
var song = session.Query <Song>().FirstOrDefault(s => s.NicoId == c.NicoId);
if (song == null)
{
song = new Song(songContract);
session.Save(song);
}
poll.AddSong(song, songContract.SortIndex);
session.Save(poll);
}
});
}
private void updateFemale(RankingList rankingList)
{
List <RankingList.MaleBean> list = rankingList.female;
List <RankingList.MaleBean> collapse = new List <RankingList.MaleBean>();
foreach (RankingList.MaleBean bean in list)
{
if (bean.collapse)
{ // 折叠
collapse.Add(bean);
}
else
{
femaleGroups.Add(bean);
femaleChilds.Add(new List <RankingList.MaleBean>());
}
}
if (collapse.Count() > 0)
{
femaleGroups.Add(new RankingList.MaleBean("别人家的排行榜"));
femaleChilds.Add(collapse);
}
femaleAdapter.NotifyDataSetChanged();
}
//ranking page
public ActionResult Ranking()
{
RankingList rankingList = SQLConnection.getRankingByAll();
return(View(rankingList));
}
private static void DailyCheck()
{
while (true)
{
if (ActualDay != DateTime.Now.Day)
{
ActualDay = DateTime.Now.Day;
DB.RunQuery("DELETE FROM users_events WHERE permanent = '0'");
DB.RunQuery("UPDATE users SET todaycoupon = '0', coupontime = '0', killcount='0', randombox = '0', loginEventToday = '0'");
DB.RunQuery("UPDATE users SET loginEventProgress = '0' WHERE loginEventProgress = '7'");
List <int> loginEventResetUsers = new List <int>();
foreach (User u in UserManager.ServerUsers.Values)
{
u.dailystats = false;
u.todaycoupons = 0;
u.coupontime = 0;
u.eventcount = 0;
u.rewardEvent.doneToday = false;
if (u.rewardEvent.progress >= 7)
{
u.rewardEvent.progress = 0;
loginEventResetUsers.Add(u.userId);
DB.RunQuery("UPDATE users SET loginEventProgress = '0' WHERE id = '" + u.userId + "'");
}
/*if(u.room != null && u.room.HasChristmasMap && u.IsAlive())
* {
* u.send(new SP_KillCount(SP_KillCount.ActionType.Show, 0));
* }*/
u.RandomBoxToday = false;
}
if (loginEventResetUsers.Count > 0)
{
string querystr = string.Join(",", users.Select(x => x.ToString()).ToArray());
DB.RunQuery("UPDATE users SET loginEventProgress = '0' WHERE id IN (" + querystr + ")");
}
Log.WriteError("Daily reset done at " + DateTime.Now.ToString("HH:mm:ss - dd/MM/yyyy"));
}
if (RankingList.hour != DateTime.Now.Hour)
{
RankingList.Load();
}
GC.Collect();
if (LastTick >= 10)
{
LastTick = 0;
DateTime current = DateTime.Now;
int ActualTime = int.Parse(String.Format("{0:yyMMddHH}", current));
lock (obj)
{
foreach (User usr in UserManager.ServerUsers.Values)
{
users.Add(usr.userId);
}
string querystr = "";
if (users.Count > 0)
{
querystr = string.Join(",", users.Select(x => x.ToString()).ToArray());
DB.RunQuery("UPDATE users SET online = '0', serverid = '-1' WHERE id NOT IN (" + querystr + ") AND serverid = '" + Configs.Server.serverId + "'");
}
users.Clear();
}
DB.RunQuery("UPDATE users SET banned = '0', bantime = '-1' WHERE banned = '1' AND bantime <= " + ActualTime + " AND bantime != '-1'");
BanManager.Load();
Log.WriteLine("10 minute routine done.");
}
LastTick++;
DB.RunQuery("UPDATE serverinfo SET value = '" + Generic.runningSinceWeb + "' WHERE name = 'uptime'");
DB.RunQuery("UPDATE serverinfo SET value = '" + Generic.timestamp + "' WHERE name = 'Lastupdate'");
DB.RunQuery("UPDATE users SET premium = '0' WHERE premiumExpire < " + Generic.timestamp);
Thread.Sleep(60000);
}
}
public virtual async Task SaveAsync(RankingList rankingList, long roundId, CancellationToken cancellationToken)
{
var rankingColl = new EntityCollection <RankingEntity>(new RankingEntityFactory());
var da = _dbContext.GetNewAdapter();
var transactionName = nameof(SaveAsync) + Guid.NewGuid().ToString("N");
try
{
// Todo: TournamentId is defined via the Round - remove TournamentId from the Ranking table. View RankingList does not depend on TournamentId already.
var tournamentId = await GetTournamentIdOfRoundAsync(roundId, cancellationToken);
// Fetch existing ranking entities for the round for deletion
var existingEntities = new EntityCollection <RankingEntity>
{
RemovedEntitiesTracker = new EntityCollection()
};
var qp = new QueryParameters
{
CollectionToFetch = existingEntities,
FilterToUse = RankingFields.RoundId == roundId,
ExcludedIncludedFields = new IncludeFieldsList(RankingFields.Id)
};
await da.FetchEntityCollectionAsync(qp, cancellationToken);
// Create ranking entities
foreach (var rank in rankingList)
{
rankingColl.Add(new RankingEntity
{
TournamentId = tournamentId,
RoundId = roundId,
Rank = rank.Number,
ValuationDate = rankingList.UpperDateLimit,
TeamId = rank.TeamId,
MatchPointsWon = rank.MatchPoints.Home,
MatchPointsLost = rank.MatchPoints.Guest,
SetPointsWon = rank.SetPoints.Home,
SetPointsLost = rank.SetPoints.Guest,
BallPointsWon = rank.BallPoints.Home,
BallPointsLost = rank.BallPoints.Guest,
MatchesPlayed = rank.MatchesPlayed,
MatchesToPlay = rank.MatchesToPlay,
CreatedOn = DateTime.UtcNow,
ModifiedOn = rankingList.LastUpdatedOn
});
}
// Start a transaction to store in the database
await da.StartTransactionAsync(IsolationLevel.ReadCommitted, transactionName, cancellationToken);
// Remove all existing ranking entities for the round
//existingEntities.RemoveRange(existingEntities);
await da.DeleteEntityCollectionAsync(existingEntities, cancellationToken);
// Save the new ranking entities
await da.SaveEntityCollectionAsync(rankingColl, false, false, cancellationToken);
da.Commit();
}
catch (Exception e)
{
_logger.LogCritical(e, $"Ranking for round id {roundId}");
if (da.IsTransactionInProgress)
{
da.Rollback();
}
throw;
}
finally
{
da.CloseConnection();
da.Dispose();
}
}
public void Initialize()
{
RankingInstance = new NicoNicoRanking(Period, Target);
RankingList.Clear();
if (Settings.Instance.RankingCategoryTotal)
{
RankingList.Add(new RankingResultViewModel(this, "カテゴリ合算", "all", RankingInstance));
}
if (Settings.Instance.RankingEntameMusic)
{
RankingList.Add(new RankingResultViewModel(this, "エンタメ・音楽", "g_ent2", RankingInstance));
}
if (Settings.Instance.RankingEntertainment)
{
RankingList.Add(new RankingResultViewModel(this, "エンターテイメント", "ent", RankingInstance));
}
if (Settings.Instance.RankingMusic)
{
RankingList.Add(new RankingResultViewModel(this, "音楽", "music", RankingInstance));
}
if (Settings.Instance.RankingSingaSong)
{
RankingList.Add(new RankingResultViewModel(this, "歌ってみた", "sing", RankingInstance));
}
if (Settings.Instance.RankingPlayaMusic)
{
RankingList.Add(new RankingResultViewModel(this, "演奏してみた", "play", RankingInstance));
}
if (Settings.Instance.RankingDancing)
{
RankingList.Add(new RankingResultViewModel(this, "踊ってみた", "dance", RankingInstance));
}
if (Settings.Instance.RankingVOCALOID)
{
RankingList.Add(new RankingResultViewModel(this, "VOCALOID", "vocaloid", RankingInstance));
}
if (Settings.Instance.RankingIndies)
{
RankingList.Add(new RankingResultViewModel(this, "ニコニコインディーズ", "nicoindies", RankingInstance));
}
if (Settings.Instance.RankingLifeSports)
{
RankingList.Add(new RankingResultViewModel(this, "生活・一般・スポ", "g_life2", RankingInstance));
}
if (Settings.Instance.RankingAnimal)
{
RankingList.Add(new RankingResultViewModel(this, "動物", "animal", RankingInstance));
}
if (Settings.Instance.RankingCooking)
{
RankingList.Add(new RankingResultViewModel(this, "料理", "cooking", RankingInstance));
}
if (Settings.Instance.RankingNature)
{
RankingList.Add(new RankingResultViewModel(this, "自然", "nature", RankingInstance));
}
if (Settings.Instance.RankingTravel)
{
RankingList.Add(new RankingResultViewModel(this, "旅行", "travel", RankingInstance));
}
if (Settings.Instance.RankingSports)
{
RankingList.Add(new RankingResultViewModel(this, "スポーツ", "sport", RankingInstance));
}
if (Settings.Instance.RankingNicoNicoDougaLecture)
{
RankingList.Add(new RankingResultViewModel(this, "ニコニコ動画講座", "lecture", RankingInstance));
}
if (Settings.Instance.RankingDriveVideo)
{
RankingList.Add(new RankingResultViewModel(this, "車載動画", "drive", RankingInstance));
}
if (Settings.Instance.RankingHistory)
{
RankingList.Add(new RankingResultViewModel(this, "歴史", "history", RankingInstance));
}
if (Settings.Instance.RankingPolitics)
{
RankingList.Add(new RankingResultViewModel(this, "政治", "g_politics", RankingInstance));
}
if (Settings.Instance.RankingScienceTech)
{
RankingList.Add(new RankingResultViewModel(this, "科学・技術", "g_tech", RankingInstance));
}
if (Settings.Instance.RankingScience)
{
RankingList.Add(new RankingResultViewModel(this, "科学", "science", RankingInstance));
}
if (Settings.Instance.RankingNicoNicoTech)
{
RankingList.Add(new RankingResultViewModel(this, "ニコニコ技術部", "tech", RankingInstance));
}
if (Settings.Instance.RankingHandicraft)
{
RankingList.Add(new RankingResultViewModel(this, "ニコニコ手芸部", "handcraft", RankingInstance));
}
if (Settings.Instance.RankingMaking)
{
RankingList.Add(new RankingResultViewModel(this, "作ってみた", "make", RankingInstance));
}
if (Settings.Instance.RankingAnimeGameIllust)
{
RankingList.Add(new RankingResultViewModel(this, "アニメ・ゲーム・絵", "g_culture2", RankingInstance));
}
if (Settings.Instance.RankingAnime)
{
RankingList.Add(new RankingResultViewModel(this, "アニメ", "anime", RankingInstance));
}
if (Settings.Instance.RankingGame)
{
RankingList.Add(new RankingResultViewModel(this, "ゲーム", "game", RankingInstance));
}
if (Settings.Instance.RankingJikkyo)
{
RankingList.Add(new RankingResultViewModel(this, "実況プレイ動画", "jikkyo", RankingInstance));
}
if (Settings.Instance.RankingTouhou)
{
RankingList.Add(new RankingResultViewModel(this, "東方", "toho", RankingInstance));
}
if (Settings.Instance.RankingIdolmaster)
{
RankingList.Add(new RankingResultViewModel(this, "アイドルマスター", "imas", RankingInstance));
}
if (Settings.Instance.RankingRadio)
{
RankingList.Add(new RankingResultViewModel(this, "ラジオ", "radio", RankingInstance));
}
if (Settings.Instance.RankingDrawing)
{
RankingList.Add(new RankingResultViewModel(this, "描いてみた", "draw", RankingInstance));
}
if (Settings.Instance.RankingOtherTotal)
{
RankingList.Add(new RankingResultViewModel(this, "その他合算", "g_other", RankingInstance));
}
if (Settings.Instance.RankingReinoAre)
{
RankingList.Add(new RankingResultViewModel(this, "例のアレ", "are", RankingInstance));
}
if (Settings.Instance.RankingDiary)
{
RankingList.Add(new RankingResultViewModel(this, "日記", "diary", RankingInstance));
}
if (Settings.Instance.RankingOther)
{
RankingList.Add(new RankingResultViewModel(this, "その他", "other", RankingInstance));
}
SelectedIndex = 0;
}
public static void RefreshRankingList()
{
RankingList?.StopLoading();
RankingList = new RankingIllustsCollection();
}
