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