public async Task Test10vSchedule()
{
var api = new TimetableParser(new SESCWebSiteParser());
var schedule = await api.GetStaticClassTimetablePage("10в");
Assert.AreEqual(6, schedule.Days.Count);
}
public static async Task RefreshTimetables(DateTime date)
{
var timetables = await TimetableParser.GetTimetables(date);
if (timetables == null)
{
throw new Exception();
}
Timetables = timetables;
KeywordDictionary = new Dictionary <string, string>();
TeamsLiterPossibleNumbers = new Dictionary <String, List <String> >();
foreach (var pair in Timetables[$"{date:ddMMyyyy}"].Teams)
{
var shortTeamName = pair.Key.Split()[0];
KeywordDictionary[shortTeamName] = pair.Key;
var liter = shortTeamName[0].ToString();
var number = shortTeamName.Substring(1);
if (TeamsLiterPossibleNumbers.ContainsKey(liter))
{
TeamsLiterPossibleNumbers[liter].Add(number);
}
else
{
TeamsLiterPossibleNumbers[liter] = new List <string> {
number
}
};
}
RefreshComplited?.Invoke(null, EventArgs.Empty);
}
protected override void load()
{
var studyLevels = TimetableParser.getStudyLevels();
Loom.QueueOnMainThread(() => {
showReadyToSelect();
selectionBox.listItems = studyLevels.ToArray();
selectionBox.Setup();
selectionBox.ItemPicked += OnSelect;
});
}
private async Task OnTimetableAsync(long chatId, TimetableType timetableType)
{
try
{
var timetable = await TimetableParser.GetAsync(this.configuration.Login, this.configuration.Password, timetableType);
timetable = TimetableFormatter.Format(timetable, timetableType);
await this.ReplyAsync(chatId, (timetable.Length > 0)?timetable : "Расписание для студенческой группы отсутствует", timetableType);
}
catch (Exception e)
{
this.logger.LogError($"{nameof(WebhookClient)} OnTimetableAsync {e.Message}");
await this.ReplyAsync(chatId, "Не удалось получить информацию о расписании для студенческой группы", timetableType);
}
}
protected override void load()
{
yearLinks = TimetableParser.getProgramYears(level, program);
var studyYears = new List <string> ();
foreach (var l in yearLinks)
{
studyYears.Add(l.name);
}
Loom.QueueOnMainThread(() => {
showReadyToSelect();
selectionBox.listItems = studyYears.ToArray();
selectionBox.Setup();
selectionBox.ItemPicked += OnSelect;
});
}
protected override void OnSelect(int id)
{
Loom.QueueOnMainThread(() => {
ConfigStorage.set("tt_study_group", selectionBox.listItems [id]);
ConfigStorage.set("tt_study_group_link", groupLinks [id].url);
try {
var timetable_link = TimetableParser.getPrimaryTimetableLink(groupLinks [id].url);
ConfigStorage.set("tt_study_timetable_link", timetable_link);
canGoNext();
} catch (Exception e) {
selectionBox.ItemPicked = null;
}
base.OnSelect(id);
}, 0.6f);
}
protected override void load()
{
groupLinks = TimetableParser.getGroups(year_link);
var groups = new List <string> ();
foreach (var l in groupLinks)
{
groups.Add(l.name);
}
Loom.QueueOnMainThread(() => {
showReadyToSelect();
selectionBox.listItems = groups.ToArray();
selectionBox.Setup();
selectionBox.ItemPicked += OnSelect;
});
}
public bool getTimetableFromInternet(bool preserveEdits, string _timetable_link = null)
{
Debug.LogWarning("Getting timetable from Internet...");
var timetable_url = _timetable_link == null?ConfigStorage.getSting("tt_study_timetable_link") : _timetable_link;
var currentWeekStart = DateTime.Today.AddDays(-(int)(DateTime.Today.DayOfWeek - 1)).Date;
var nw = DateTime.Now.AddDays(7).Date;
var nextWeekStart = nw.AddDays(-(int)(nw.DayOfWeek - 1)).Date;
try{
var current_week_tt = TimetableParser.getTimetable(timetable_url, currentWeekStart);
var next_week_tt = TimetableParser.getTimetable(timetable_url, nextWeekStart);
return(saveTimetableToDatabase(current_week_tt, next_week_tt, preserveEdits)); // returns true if anuthing changed
}catch (Exception e) {
Debug.LogError("Cant get timetable from " + timetable_url + ": " + e.Message);
Debug.LogError(e.StackTrace);
return(false);
}
}
public static void addPair(string title, WeekTimetable week, Action <Pair> yesAction, string okButtonTitle = "ДОБАВИТЬ", string cancelButtonTitle = "ОТМЕНА")
{
hideAll();
current.overlay.gameObject.SetActive(true);
current.editPairDialog.gameObject.SetActive(true);
current.editPairDialog.wrongInput.text = "заполните все поля со *";
current.editPairDialog.selectedDayOfWeek = DayOfWeek.Sunday;
current.editPairDialog.selectionBox.Setup();
Loom.QueueOnMainThread(() => {
current.editPairDialog.title.text = title;
current.editPairDialog.startTime.text = "";
current.editPairDialog.startTime.GetComponent <InputFieldConfig>().Refresh();
current.editPairDialog.endTime.text = "";
current.editPairDialog.endTime.GetComponent <InputFieldConfig>().Refresh();
current.editPairDialog.name.text = "";
current.editPairDialog.name.GetComponent <InputFieldConfig>().Refresh();
current.editPairDialog.location.text = "";
current.editPairDialog.location.GetComponent <InputFieldConfig>().Refresh();
current.editPairDialog.lecturer.text = "";
current.editPairDialog.lecturer.GetComponent <InputFieldConfig>().Refresh();
current.editPairDialog.okButtonTitle.text = okButtonTitle;
current.editPairDialog.cancelButtonTitle.text = cancelButtonTitle;
});
current.editPairDialog.okButton.onClick.RemoveAllListeners();
current.editPairDialog.cancelButton.onClick.RemoveAllListeners();
current.editPairDialog.cancelButton.onClick.AddListener(() => { hideAll(); });
current.editPairDialog.okButton.onClick.AddListener(() => {
// first validate
current.editPairDialog.wrongInput.text = "";
if (current.editPairDialog.selectedDayOfWeek == DayOfWeek.Sunday)
{
current.editPairDialog.wrongInput.text = "выберите день недели";
return;
}
var provider = System.Globalization.CultureInfo.GetCultureInfo("ru-RU");
var dateTimeStyle = System.Globalization.DateTimeStyles.AssumeLocal;
DateTime tryParseDateTimeResult;
if (!DateTime.TryParseExact(current.editPairDialog.startTime.text, "HH:mm", provider, dateTimeStyle, out tryParseDateTimeResult))
{
current.editPairDialog.wrongInput.text = "неверный формат начального времени, пример: 09:30";
return;
}
if (!DateTime.TryParseExact(current.editPairDialog.endTime.text, "HH:mm", provider, dateTimeStyle, out tryParseDateTimeResult))
{
current.editPairDialog.wrongInput.text = "неверный формат конечного времени, пример: 09:30";
return;
}
if (current.editPairDialog.name.text.Length < 3)
{
current.editPairDialog.wrongInput.text = "плохое нзвание пары";
return;
}
if (current.editPairDialog.location.text.Length == 0)
{
current.editPairDialog.wrongInput.text = "введите место или кабинет";
return;
}
Debug.LogWarning("week̉̉ " + week + " is nulL: " + (week == null?"YES":"NO"));
Debug.LogWarning("weekStartDay " + week.weekStartDay + " is nulL: " + (week.weekStartDay == null?"YES":"NO"));
Debug.LogWarning("selected day " + current.editPairDialog.selectedDayOfWeek + " is nulL: " + (current.editPairDialog.selectedDayOfWeek == null?"YES":"NO"));
var day_t = week.weekStartDay.AddDays((int)current.editPairDialog.selectedDayOfWeek - 1).Date;
var name_t = current.editPairDialog.name.text.Trim();
var time_t = current.editPairDialog.startTime.text + "–" + current.editPairDialog.endTime.text.Trim();
var location_t = current.editPairDialog.location.text.Trim();
var lecturer_t = current.editPairDialog.lecturer.text.Trim();
var newPair = new Pair(
day_t,
name_t,
time_t,
location_t,
lecturer_t,
true,
false,
TimetableParser.GetPairMD5(day_t.DayOfWeek, time_t, name_t, location_t, lecturer_t, week.weekType)
);
// location
var app = AppScript.getSharedInstance();
if (newPair.room == "" || newPair.room == null)
{
if (app.facilities.hasRoom(newPair.location.Trim()))
{
newPair.room = newPair.location.Trim();
}
else
{
Debug.LogWarning("BBB");
}
}
else
{
Debug.LogWarning("AAA");
}
yesAction(newPair);
hideAll();
});
}
private bool saveTimetableToDatabase(WeekTimetable w1, WeekTimetable w2, bool preserveEdits = false)
{
bool anyChanges = false;
// var start_t = Time.realtimeSinceStartup;
if (!preserveEdits)
{
anyChanges = true;
// simply remove all pairs from db and add provided
clearDb();
using (var db = new SQLiteConnection(db_path)) {
foreach (var w in new List <WeekTimetable>()
{
w1, w2
})
{
Debug.LogWarning("Saving week of type " + w.weekType);
foreach (var d in w.days)
{
foreach (var p in d.pairs)
{
var pair = new TimetableRecord();
pair.weekType = w.weekType;
pair.day = d.day.DayOfWeek;
pair.startTime = p.startTime;
pair.endTime = p.endTime;
pair.name = p.name;
pair.lecturer = p.lecturer;
pair.location = p.location;
pair.room = p.room;
pair.edited = p.edited ? 1 : 0;
pair.deleted = p.deleted ? 1 : 0;
pair.initial_hash = p.initial_hash;
pair.hash = p.hash;
db.Insert(pair);
}
}
}
db.Close();
//Debug.LogWarning ("Timetable saved to database ("+(Time.renderedFrameCount-start_t)+"s)");
}
}
else
{
// foreach exisiting pair check for similar (with hash) in new pairs
// if found - dont add new pair
// if not found remove (real remove) existing pair
// Then add other new pairs
var old_weeks = new List <WeekTimetable>()
{
currentWeek, nextWeek
};
var new_weeks = new List <WeekTimetable>()
{
w1, w2
};
// create one list with all existing pairs
var exisitingPairs = new List <Pair>();
foreach (var ex_w in old_weeks)
{
foreach (var d in ex_w.days)
{
foreach (var p in d.pairs)
{
exisitingPairs.Add(p);
}
}
}
// create another list with all new pairs
var newPairs = new List <Pair>();
foreach (var new_w in new_weeks)
{
foreach (var d in new_w.days)
{
foreach (var new_p in d.pairs)
{
newPairs.Add(new_p);
}
}
}
// v1.3 hash migration
if (exisitingPairs.Where(x => x.hash == null).Count() > 0)
{
// needs migration
//Debug.LogError ("Needs v1.3 pair migration");
for (int i = 0; i < 2; i++)
{
var old_w = old_weeks [i]; var new_w = new_weeks [i];
var old_w_pairs = new List <Pair>();
foreach (var d in old_w.days)
{
foreach (var p in d.pairs)
{
old_w_pairs.Add(p);
}
}
var new_w_pairs = new List <Pair>();
foreach (var d in new_w.days)
{
foreach (var new_p in d.pairs)
{
new_w_pairs.Add(new_p);
}
}
foreach (var ex_p in old_w_pairs)
{
if (ex_p.hash == null)
{
//Debug.LogError ("Found null hash");
// pair needs migration
if (ex_p.edited)
{
// than needs more work:
// if its the only pair on this week with such hash
if (old_w_pairs.Where(x => x.initial_hash == ex_p.initial_hash).Count() == 1)
{
// try to find in new pairs pair with same initial_hash
var new_pairs_with_same_initial_hash = new_w_pairs.Where(
x => ex_p.initial_hash == x.initial_hash
).ToList();
if (new_pairs_with_same_initial_hash.Count > 0)
{
//Debug.LogWarning ("Found similar pair in new data for migration");
// than take this new pair and calculate old pair's hash using it
var new_pair = new_pairs_with_same_initial_hash [0];
ex_p.hash = new_pair.hash;
}
else
{
//Debug.LogError ("Cant find similar (initila_hash) pair in new data");
// in this case cant restore
// than replace it with new pairs on update
}
}
else
{
//Debug.LogError ("Pair is not single on this week");
// cant restore - replace on update
}
}
else
{
// just calculate new hash
if (ex_p.deleted)
{
//Debug.LogWarning ("Set new hash for deleted pair");
}
ex_p.hash = TimetableParser.GetPairMD5(ex_p.day.DayOfWeek, ex_p.time, ex_p.name, ex_p.location, ex_p.lecturer, old_w.weekType);
}
}
else
{
//Debug.LogError ("HASH IS NOT NULL!");
}
}
}
}
// foreach existing pair check if it stays or not
foreach (var ex_p in exisitingPairs)
{
if (ex_p.hash == null)
{
Debug.LogError("Exisiting pair hash is null!");
}
if (newPairs.FindAll(x => x.hash == ex_p.hash).Count == 0)
{
// no such pair in new data - delete it from our local data
removePair(ex_p, immediateSaveToDB: false);
anyChanges = true;
}
else
{
// found such pair in new data
// remove it from list of new data
newPairs.RemoveAll(x => x.hash == ex_p.hash);
}
}
// save our removals to DB
saveTimetableToDatabase(currentWeek, nextWeek);
// add rest of new data
foreach (var new_p in newPairs)
{
addPair(new_p, saveState: false); // adds directly to db
anyChanges = true;
}
// done saving new data
}
return(anyChanges);
}
