def coursenopage(self,shifttype):
#result = config.dbcon.db.query("select a.* from sus_course as a LEFT JOIN sus_course_shift as b on a.csid=b.csid where b.shifttype=$shifttype",vars={"shifttype": shifttype})
lists = config.dbcon.db.query(
"SELECT FROM_UNIXTIME(a.coursetime, '%Y-%m-%d') as coursetimeformat,a.coursetime,a.ccid,a.csid FROM sus_course as a LEFT JOIN sus_course_shift as b on a.csid=b.csid where b.shifttype=$shifttype group by coursetime,ccid",vars={"shifttype": shifttype})
results_list = []
print lists
for i in lists:
sub_list=config.dbcon.db.query("select * from sus_course where coursetime=$coursetime and ccid=$ccid",vars={"coursetime":i.coursetime,"ccid":i.ccid})
i.setdefault('week',func.get_week_day(datetime.date.fromtimestamp(i.coursetime)))
sub_temp_list=[]
for j in sub_list:
del j['ccid'];
del j['csid'];
del j['createtime'];
del j['edittime'];
del j['coursetime'];
del j['tid'];
sub_temp_list.append(j)
del i['coursetime'];
i.setdefault('sublist',sub_temp_list)
results_list.append(i)
return results_list
def courseteacherlist(self,tid,page):
if page==None:
page=tid
totalrst = config.dbcon.db.query(
"SELECT count(cid) as total FROM sus_course")
total = totalrst[0].total
totaldata=0
results_list = []
if total>0:
total_results = config.dbcon.db.query(
"SELECT count(cid) as total FROM sus_course group by coursetime")
totaldata = total_results[0].total
lists = config.dbcon.db.query(
"SELECT * FROM sus_course group by coursetime limit $start,$pagesize",
vars={"start": pagesupport.PageSupport().startpage(page),
"pagesize": pagesupport.PageSupport.pagesize})
for i in lists:
#i.setdefault('sublist',config.dbcon.db.query("select * from sus_course where coursetime=$coursetime",vars={"coursetime":i.coursetime}))
sub_list=config.dbcon.db.query("select * from sus_course where coursetime=$coursetime",vars={"coursetime":i.coursetime})
i.setdefault('week',func.get_week_day(datetime.date.fromtimestamp(i.coursetime)))
sub_temp_list=[]
for j in sub_list:
sub_temp_list.append(j)
sub_temp_list_len= len(sub_temp_list)
tmp_dict={'intervaltime':''}
if sub_temp_list_len==1:
sub_temp_list.append( web.storage(tmp_dict))
sub_temp_list.append( web.storage(tmp_dict))
if sub_temp_list_len==2:
sub_temp_list.append( web.storage(tmp_dict))
i.setdefault('sublist',sub_temp_list)
results_list.append(i)
else:
totalrst = config.dbcon.db.query(
"SELECT count(cid) as total FROM sus_course")
total = totalrst[0].total
totaldata=0
results_list = []
if total>0:
total_results = config.dbcon.db.query(
"SELECT count(cid) as total FROM sus_course where tid=$tid group by coursetime",vars={"tid":tid})
totaldata = total_results[0].total
lists = config.dbcon.db.query(
"SELECT * FROM sus_course where tid=$tid group by coursetime limit $start,$pagesize",
vars={"tid":tid,"start": pagesupport.PageSupport().startpage(page),
"pagesize": pagesupport.PageSupport.pagesize})
for i in lists:
sub_list=config.dbcon.db.query("select * from sus_course where coursetime=$coursetime",vars={"coursetime":i.coursetime})
i.setdefault('week',func.get_week_day(datetime.date.fromtimestamp(i.coursetime)))
sub_temp_list=[]
for j in sub_list:
sub_temp_list.append(j)
sub_temp_list_len= len(sub_temp_list)
tmp_dict={'intervaltime':''}
if sub_temp_list_len==1:
sub_temp_list.append( web.storage(tmp_dict))
sub_temp_list.append( web.storage(tmp_dict))
if sub_temp_list_len==2:
sub_temp_list.append( web.storage(tmp_dict))
i.setdefault('sublist',sub_temp_list)
results_list.append(i)
pagehtml = pagesupport.PageSupport().getpagehtml(page, totaldata)
results = {"results_list": results_list, "pagehtml": pagehtml}
return results
