private LessonListElement getLessonFromCursor(Cursor c) {
LessonListElement lesson;
lesson = new LessonListElement();
lesson.setId(c.getLong(c.getColumnIndex(LessonTableModel.ID)));
lesson.setDayNumber(c.getInt(c.getColumnIndex(LessonTableModel.DAY)));
lesson.setLessonNumber(c.getInt(c.getColumnIndex(LessonTableModel.NUMBER)));
lesson.setInformation(getLessonInformation(c.getLong(c.getColumnIndex(LessonTableModel.ID))));
return lesson;
}
public ArrayList<LessonListElement> getLessonList(final Integer dayOfSemestr) {
ArrayList<LessonListElement> result = new ArrayList<LessonListElement>();
int weekState = CalendarManager.getWeekState(dayOfSemestr);
int dayOfWeek = CalendarManager.getDayOfWeek(dayOfSemestr);
String query =
TextUtils.concat(
"SELECT * FROM ",
LessonTableModel.TABLE_NAME,
" WHERE ",
LessonTableModel.GROUP_ID,
" ='",
PreferenceManager.getInstance().getGroupId().toString(),
"' AND ",
LessonTableModel.DAY,
"=? AND ",
"(",
LessonTableModel.WEEK_STATE,
"=? OR ",
LessonTableModel.WEEK_STATE,
"='2')",
" GROUP BY ",
LessonTableModel.NUMBER,
" ORDER BY ",
LessonTableModel.NUMBER)
.toString();
Cursor c =
mDb.rawQuery(
query, new String[] {Integer.toString(dayOfWeek), Integer.toString(weekState)});
LessonListElement lesson;
long date = CalendarManager.getDate(dayOfSemestr) / CalendarManager.MILISECONDS_PER_DAY;
while (c.moveToNext()) {
lesson = getLessonFromCursor(c);
lesson.setHasHomeWork(DataManager.getInstance().lessonHasHomeWork(lesson.getId(), date));
result.add(lesson);
}
return result;
}
public LessonListElement getLesson(Long lesonId) {
LessonListElement result = new LessonListElement();
Cursor c =
mDb.rawQuery(
TextUtils.concat(
"SELECT * FROM ",
LessonTableModel.TABLE_NAME,
" WHERE ",
LessonTableModel.ID,
"=?")
.toString(),
new String[] {lesonId.toString()});
c.moveToFirst();
if (c.getCount() != 0) {
result.setId(c.getLong(c.getColumnIndex(LessonTableModel.ID)));
result.setDayNumber(c.getInt(c.getColumnIndex(LessonTableModel.DAY)));
result.setLessonNumber(c.getInt(c.getColumnIndex(LessonTableModel.NUMBER)));
result.setInformation(getLessonInformation(lesonId));
}
return result;
}
