public void undo()
{
if (!historyHasPrevState())
{
Debug.LogError("Nothing to undo; only current state in history");
return;
}
currentWeek = history [history.Count - 2] ["currentWeek"].Clone();
nextWeek = history [history.Count - 2] ["nextWeek"].Clone();
history.RemoveAt(history.Count - 1);
sortEverything();
Debug.LogWarning("UNDO, history count: " + history.Count);
}
public void addPairClicked(WeekTimetable week)
{
if (!_editMode)
{
return;
}
Debug.LogWarning("ADD PAIR");
Alerts.addPair("Добавить пару", week, (Pair newPair) => {
Loom.QueueOnMainThread(() => {
app.timetableManager.addPair(newPair);
Loom.QueueOnMainThread(() => {
app.timetablePanel.UpdateContents(true);
});
});
});
}
public void addPair(Pair pair, bool saveState = true)
{
/*WeekTimetable week;
* var p_weekType = WeekTimetable.GetIso8601WeekNumber (pair.day.Date) % 2 == 0 ? WeekType.Even : WeekType.Odd;
* week = currentWeek.weekType == p_weekType ? currentWeek : nextWeek;
*
*/
using (var db = new SQLiteConnection(db_path)) {
var pr = new TimetableRecord();
pr.weekType = WeekTimetable.GetIso8601WeekNumber(pair.day.Date) % 2 == 0?WeekType.Even:WeekType.Odd;
pr.day = pair.day.DayOfWeek;
pr.startTime = pair.startTime;
pr.endTime = pair.endTime;
pr.name = pair.name;
pr.lecturer = pair.lecturer;
pr.location = pair.location;
pr.room = pair.room;
pr.edited = pair.edited?1:0;
pr.deleted = pair.deleted?1:0;
pr.initial_hash = pair.initial_hash;
pr.hash = pair.hash;
Debug.LogWarning("ADDING PAIR: " + pair.name + " DELETED: " + pr.deleted);
db.Insert(pr);
db.Close();
// NEW PAIR IN DB NOW
restoreTimetableFromDatabase();
if (saveState)
{
saveCurrentState();
}
}
}
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);
}
public void restoreTimetableFromDatabase(bool saveState = false)
{
// clear all
//PlayerPrefs.DeleteAll();
Debug.LogWarning("RESTORING TIMETABLE FROM DB");
using (var db = new SQLiteConnection(db_path)){
var pairRecords = db.Query <TimetableRecord>("SELECT * FROM timetable");
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;
var w1 = new WeekTimetable(currentWeekStart);
var w2 = new WeekTimetable(nextWeekStart);
foreach (TimetableRecord p in pairRecords)
{
var w = p.weekType == w1.weekType ? w1 : w2;
var date = w.weekStartDay.AddDays((int)p.day - 1).Date;
var pair = new Pair(
date,
p.name,
string.Format("{0}–{1}", p.startTime.ToString("HH:mm"), p.endTime.ToString("HH:mm")),
p.location,
p.lecturer,
p.edited == 1,
p.deleted == 1,
p.hash
);
// for capability
pair.initial_hash = p.initial_hash;
if (p.room != null && p.room != "")
{
pair.room = p.room;
}
if (!w.hasDayOfWeek(p.day))
{
w.days.Add(new DayTimetable(date));
}
w.getDayTimetable(p.day).pairs.Add(pair);
}
currentWeek = w1;
nextWeek = w2;
if (saveState)
{
saveCurrentState();
}
sortEverything();
db.Close();
}
}
