def get_classroom(condition):
try:
if condition == u"博南" or condition == u"博学南楼":
bds = [u"博南A楼", u"博南B楼", u"博南C楼"]
bncond = "buildingName in ('" + "','".join(bds) + "')"
elif condition == u"博北" or condition == u"博学北楼":
bds = [u"博北A楼", u"博北B楼", u"博北C楼", u"博北D楼"]
bncond = "buildingName in ('" + "','".join(bds) + "')"
elif condition == u"":
bncond = "0 = 0"
else:
bncond = "buildingName = '" + condition + "'"
qweek = common.get_week_today()
tmplist = common.get_classindex(common.get_now_time(), common.get_next_time())
if tmplist:
jccondition = "courseTime in(" + ",".join(str(x) for x in tmplist) + ")"
else:
jccondition = "1=0"
sqlstr = (
"select * from classroomDB where %s and roomID not in(select roomID from scheduleDB where courseWeekday='%s' and fromWeek <= %s and endWeek >= %s and %s) limit 0,30"
% (bncond, common.get_weekday_today(), qweek, qweek, jccondition)
)
qresults = db.query(sqlstr)
retstr = ""
for result in qresults:
retstr = u"%s教室：%s 座位数：%s 类型：%s\n" % (retstr, result.roomName, result.seatCount, result.roomType)
except:
return None
else:
return retstr
def get_coursetable(roomName):
try:
qweek = common.get_week_today()
sqlstr = (
"select scheduleDB.courseTime,scheduleDB.courseID,courseDB.courseName,scheduleDB.teacherID,teacherDB.teacherName,scheduleDB.courseDept,scheduleDB.fromWeek,scheduleDB.endWeek from scheduleDB inner join courseDB inner join teacherDB inner join classroomDB on classroomDB.roomName = '%s' and classroomDB.roomID=scheduleDB.roomID and fromWeek<=%s and endWeek>=%s and courseWeekday='%s' and scheduleDB.courseID=courseDB.courseID and scheduleDB.teacherID=teacherDB.teacherID order by courseTime asc limit 0,11"
% (roomName, qweek, qweek, common.get_weekday_today())
)
qresults = db.query(sqlstr)
retstr = ""
for result in qresults:
retstr = u"%s第%s节：%s 教师：%s 班级：%s 起讫周：%s-%s\n" % (
retstr,
result.courseTime,
result.courseName,
result.teacherName,
result.courseDept if result.courseDept else "--",
result.fromWeek,
result.endWeek,
)
except:
return None
else:
return retstr[0:-2]
def get_classroom(condition):
try:
if condition == u"博南" or condition == u"博学南楼":
bds = [u'博南A楼',u'博南B楼',u'博南C楼']
bncond = "buildingName in ('"+"','".join(bds)+"')"
elif condition == u"博北" or condition == u"博学北楼":
bds = [u'博北A楼',u'博北B楼',u'博北C楼',u'博北D楼']
bncond = "buildingName in ('"+"','".join(bds)+"')"
elif condition == u"":
bncond = "0 = 0"
else:
bncond = "buildingName = '" + condition + "'"
qweek = common.get_week_today()
tmplist=common.get_classindex(common.get_now_time(),common.get_next_time())
if tmplist:
jccondition="courseTime in("+",".join(str(x) for x in tmplist)+")"
else:
jccondition="1=0"
sqlstr="select * from classroomDB where %s and roomID not in(select roomID from scheduleDB where courseWeekday='%s' and fromWeek <= %s and endWeek >= %s and %s) limit 0,30"%(bncond,common.get_weekday_today(),qweek,qweek,jccondition)
qresults = db.query(sqlstr)
retstr = ""
for result in qresults:
retstr = u"%s教室：%s 座位数：%s 类型：%s\n"%(retstr,result.roomName,result.seatCount,result.roomType)
except:
return None
else:
return retstr
def get_coursetable(roomName):
try:
qweek = common.get_week_today()
sqlstr = "select scheduleDB.courseTime,scheduleDB.courseID,courseDB.courseName,scheduleDB.teacherID,teacherDB.teacherName,scheduleDB.courseDept,scheduleDB.fromWeek,scheduleDB.endWeek from scheduleDB inner join courseDB inner join teacherDB inner join classroomDB on classroomDB.roomName = '%s' and classroomDB.roomID=scheduleDB.roomID and fromWeek<=%s and endWeek>=%s and courseWeekday='%s' and scheduleDB.courseID=courseDB.courseID and scheduleDB.teacherID=teacherDB.teacherID order by courseTime asc limit 0,11"%(roomName,qweek,qweek,common.get_weekday_today())
qresults = db.query(sqlstr)
retstr = ""
for result in qresults:
retstr = u"%s第%s节：%s 教师：%s 班级：%s 起讫周：%s-%s\n"%(retstr,result.courseTime,result.courseName,result.teacherName,result.courseDept if result.courseDept else "--",result.fromWeek,result.endWeek)
except:
return None
else:
return retstr[0:-2]