def index(request): ''' for index_new ''' news_announcement = News.objects.filter( news_category__category=NEWS_CATEGORY_ANNOUNCEMENT).order_by( '-news_date') # news_policy = News.objects.filter(news_category__category=NEWS_CATEGORY_POLICY).order_by('-news_date') news_dynamic = News.objects.filter( news_category__category=NEWS_CATEGORY_DYNAMIC).order_by('-news_date') news_outstanding = News.objects.filter( news_category__category=NEWS_CATEGORY_OUTSTANDING).order_by( '-news_date') news_others = News.objects.filter( news_category__category=NEWS_CATEGORY_OTHERS).order_by('-news_date') context = getContext(news_announcement, 1, "news_announcement", page_elems=8) # context.update(getContext(news_policy, 1, "news_policy", page_elems=8)) context.update(getContext(news_dynamic, 1, "news_dynamic", page_elems=8)) context.update( getContext(news_outstanding, 1, "news_outstanding", page_elems=8)) context.update(getContext(news_others, 1, "news_others", page_elems=8)) return context
def getUserListPagination(request, page, user): page = int(page) html = "" if user == "college": user_list = getCollegeListForHtml() context = getContext(user_list, page, "item2", 0) html = render_to_string( "widgets/notice_message_setting_select_college_table.html", context) elif user == "teacher": user_list = cnt_teacher_list context = getContext(user_list, page, "item3", 0) html = render_to_string( "widgets/notice_message_setting_select_teacher_table.html", context) else: user_list = cnt_expert_list context = getContext(user_list, page, "item4", 0) html = render_to_string( "widgets/notice_message_setting_select_expert_table.html", context) return simplejson.dumps({ "status": 1, "html": html, })
def getParam(pro_list, userauth, flag, page, page2): (pending_q, default_q, search_q) = get_qset(userauth) not_pass_apply_project_group = pro_list.filter(pending_q) if flag: pass_apply_project_group = pro_list.filter(default_q) else: pass_apply_project_group = pro_list.filter(search_q) if userauth['role'] == FINANCE_USER: if userauth['status'] == "budget": pass_apply_project_group = pass_apply_project_group.order_by( 'projectfundbudget__serial_number') else: pass_apply_project_group = pass_apply_project_group.order_by( 'projectfundsummary__serial_number') pass_apply_project_group = addURL(pass_apply_project_group) not_pass_apply_project_group = addURL(not_pass_apply_project_group) param = {} param.update( getContext(pass_apply_project_group, page2, "item2", 0, page_elems=10)) param.update( getContext(not_pass_apply_project_group, page, "item", 0, page_elems=10)) param.update({"pro_count": len(pass_apply_project_group)}) return param
def refresh_user_table(request,identity,search_form="",page=1): try: form = SearchForm(deserialize_form(search_form)) if form.is_valid(): name = form.cleaned_data['name'] except: name = "" if identity == SCHOOL_USER: school_users = SchoolProfile.objects.filter(Q(userid__first_name__contains = name)) context=getContext(school_users, page, "item") return render_to_string("widgets/dispatch/school_user_table.html", context) elif identity == COLLEGE_USER: college_users = CollegeProfile.objects.filter(Q(userid__first_name__contains = name)) context=getContext(college_users, page, "item2") return render_to_string("widgets/dispatch/college_user_table.html", context) elif identity == TEACHER_USER: colleges = getCollege(request) qset = reduce(lambda x,y:x|y,[Q(college = _college) for _college in colleges]) users = TeacherProfile.objects.filter(qset).filter(Q(userid__first_name__contains = name)).order_by('college') context=getContext(users, page, "item") return render_to_string("widgets/dispatch/teacher_user_table.html", context) elif identity == EXPERT_USER: users = ExpertProfile.objects.filter(Q(userid__first_name__contains = name)).order_by('college') context=getContext(users, page, "item3") return render_to_string("widgets/dispatch/expert_user_table.html", context)
def getPagination(request, special, college, page, is_first_round): message = "" expert = ExpertProfile.objects.get(userid = request.user) page = int(page) re_list = Re_Project_Expert.objects.filter(Q(expert = expert) & Q(is_first_round = is_first_round)) if special != "-1": re_list = re_list.filter(project__project_special = special) if college != "-1": re_list = re_list.filter(project__teacher__college = college) re_list = list(re_list) for re_obj in re_list: if is_first_round: re_obj.score = getScoreTable(re_obj.project).objects.get_or_create(re_obj = re_obj)[0].get_total_score() else: re_obj.score = getFinalScoreTable(re_obj.project).objects.get_or_create(re_obj = re_obj)[0].get_total_score() re_list.sort(key = lambda x: x.score) if is_first_round: context = getContext(re_list, page, "item", 0) html = render_to_string("expert/widgets/first_round_project_table.html", context) message = "first round" else: context = getContext(re_list, page, "item2", 0) html = render_to_string("expert/widgets/second_round_project_table.html", context) message = "second round" return simplejson.dumps({"message": message, "html": html, })
def noticeMessageSettingBase(request,userauth): notice_choice=NOTICE_CHOICE template_notice_message=TemplateNoticeMessage.objects.all() template_notice_message_form = TemplateNoticeMessageForm() template_notice_message_group=[] cnt=1 for item in template_notice_message: nv={ "id":item.id, "iid":cnt, "title":item.title, "message":item.message, } cnt+=1 template_notice_message_group.append(nv) notice_form=NoticeForm(request=request) context=getContext(template_notice_message_group,1,"item",0) context.update({ "template_notice_message_form":template_notice_message_form, "notice_choice":notice_choice, "notice_form":notice_form, "userauth":userauth, # "college_list":college_list_choice, }) context.update(getContext(getCollegeListForHtml(), 1, "item2", 0)) return render(request, userauth['role'] + "/notice_message_setting.html", context)
def allocView(request): expert_list = ExpertProfile.objects.all() unalloc_project_list = get_project_list(request).filter( project_status__status=PROJECT_STATUS_APPLICATION_SCHOOL_OVER) alloc_project_list = get_project_list(request).filter( project_status__status=PROJECT_STATUS_APPLICATION_EXPERT_SUBJECT) form = FilterForm(request=request) expert_form = FilterForm() context = { "form": form, "expert_form": expert_form, "page_info": "alloc", } context.update(getContext(unalloc_project_list, 1, "item", 0)) context.update(getContext(alloc_project_list, 1, "item2", 0)) context.update(getContext(expert_list, 1, "item3", 0)) for expert in context['item3_list']: expert.alloc_num = Re_Project_Expert.objects.filter( Q(expert=expert) & Q(is_first_round=True) & Q(project__project_status__status= PROJECT_STATUS_APPLICATION_EXPERT_SUBJECT)).count() for project in context['item2_list']: project.review_status = getProjectReviewStatus(project) return render(request, "school/alloc.html", context)
def homeView(request, is_submited=False): is_first_round = request.GET.get("is_first_round", "1") page = int(request.GET.get("page", "1")) page2 = int(request.GET.get("page2", "1")) expert = ExpertProfile.objects.get(userid = request.user) re_list_1 = list(Re_Project_Expert.objects.filter(Q(expert = expert) & \ Q(is_first_round = True) & \ Q(project__project_status__status = PROJECT_STATUS_APPLICATION_EXPERT_SUBJECT) & \ Q(project__project_special__alloc_status = True))) for re_obj in re_list_1: loginfo(re_obj.project) re_obj.score = getScoreTable(re_obj.project).objects.get_or_create(re_obj = re_obj)[0].get_total_score() re_list_2 = list(Re_Project_Expert.objects.filter(Q(expert = expert) & \ Q(is_first_round = False) & \ Q(project__project_status__status = PROJECT_STATUS_FINAL_EXPERT_SUBJECT) & \ Q(project__project_special__final_alloc_status = True))) for re_obj in re_list_2: loginfo(re_obj.project) re_obj.score = getFinalScoreTable(re_obj.project).objects.get_or_create(re_obj = re_obj)[0].get_total_score() context = {"is_first_round": is_first_round,} re_list_1.sort(key = lambda x: x.score) re_list_2.sort(key = lambda x: x.score) form = ScheduleBaseForm() context.update(getContext(re_list_1, page, "item", 0)) context.update(getContext(re_list_2, page2, "item2", 0)) context.update({"form": form, }) return render(request,"expert/home.html", context)
def getProjectList(request, college_id, special_id, path): if path == FIRST_ROUND_PATH: alloc_project_list = get_project_list(request).filter(project_status__status = PROJECT_STATUS_APPLICATION_EXPERT_SUBJECT) else: alloc_project_list = get_project_list(request).filter(project_status__status = PROJECT_STATUS_FINAL_EXPERT_SUBJECT) if college_id != "-1": alloc_project_list = alloc_project_list.filter(teacher__college = college_id) if special_id != "-1": alloc_project_list = alloc_project_list.filter(project_special = special_id) if path == FIRST_ROUND_PATH: unalloc_project_list = get_project_list(request).filter(project_status__status = PROJECT_STATUS_APPLICATION_SCHOOL_OVER) else: unalloc_project_list = get_project_list(request).filter(project_status__status = PROJECT_STATUS_FINAL_SCHOOL_OVER) if college_id != "-1": unalloc_project_list = unalloc_project_list.filter(teacher__college = college_id) if special_id != "-1": unalloc_project_list = unalloc_project_list.filter(project_special = special_id) for project in alloc_project_list: project.review_status = getProjectReviewStatus(project) context = getContext(unalloc_project_list, 1, "item", 0) context2 = getContext(alloc_project_list, 1, "item2", 0) html_alloc = render_to_string("school/widgets/alloc_project_table.html", context2) html_unalloc = render_to_string("school/widgets/unalloc_project_table.html", context) return simplejson.dumps({"html_alloc": html_alloc, "html_unalloc": html_unalloc, })
def noticeMessageSettingBase(request, userauth): notice_choice = NOTICE_CHOICE template_notice_message = TemplateNoticeMessage.objects.all() template_notice_message_form = TemplateNoticeMessageForm() template_notice_message_group = [] cnt = 1 for item in template_notice_message: nv = { "id": item.id, "iid": cnt, "title": item.title, "message": item.message, } cnt += 1 template_notice_message_group.append(nv) notice_form = NoticeForm(request=request) context = getContext(template_notice_message_group, 1, "item", 0) context.update({ "template_notice_message_form": template_notice_message_form, "notice_choice": notice_choice, "notice_form": notice_form, "userauth": userauth, # "college_list":college_list_choice, }) context.update(getContext(getCollegeListForHtml(), 1, "item2", 0)) return render(request, userauth['role'] + "/notice_message_setting.html", context)
def refresh_user_table(request, identity, search_form="", page=1): try: form = SearchForm(deserialize_form(search_form)) if form.is_valid(): name = form.cleaned_data['name'] except: name = "" if identity == SCHOOL_USER: school_users = SchoolProfile.objects.filter( Q(userid__first_name__contains=name)) context = getContext(school_users, page, "item") return render_to_string("widgets/dispatch/school_user_table.html", context) elif identity == COLLEGE_USER: college_users = CollegeProfile.objects.filter( Q(userid__first_name__contains=name)) context = getContext(college_users, page, "item2") return render_to_string("widgets/dispatch/college_user_table.html", context) elif identity == TEACHER_USER: colleges = getCollege(request) qset = reduce(lambda x, y: x | y, [Q(college=_college) for _college in colleges]) users = TeacherProfile.objects.filter(qset).filter( Q(userid__first_name__contains=name)).order_by('college') context = getContext(users, page, "item") return render_to_string("widgets/dispatch/teacher_user_table.html", context) elif identity == EXPERT_USER: users = ExpertProfile.objects.filter( Q(userid__first_name__contains=name)).order_by('college') context = getContext(users, page, "item3") return render_to_string("widgets/dispatch/expert_user_table.html", context)
def index_context(request): news_company_news = News.objects.filter(news_category__category = NEWS_CATEGORY_COMPANYNEWS).order_by('-news_date') news_import_info = News.objects.filter(news_category__category = NEWS_CATEGORY_IMPORTINFO).order_by('-news_date') homepage_docs = DocumentFile.objects.filter(news__isnull = False).order_by('-news__news_date') context = getContext(news_company_news, 1, "news_company_news") context.update(getContext(news_import_info, 1 , "news_import_info")) context.update(getContext(homepage_docs, 1, "homepage_docs")) return context
def list_news(request): news_list = News.objects.order_by('-news_date') news_page = request.GET.get('news_page') docs_list = news_list.exclude(news_document=u'') docs_page = request.GET.get('docs_page') context = getContext(news_list, news_page, 'news') context.update(getContext(docs_list, docs_page, 'docs')) return render(request, 'home/news-list.html', \ Context(context))
def index_context(request): news_company_news = News.objects.filter( news_category__category=NEWS_CATEGORY_COMPANYNEWS).order_by( '-news_date') news_import_info = News.objects.filter( news_category__category=NEWS_CATEGORY_IMPORTINFO).order_by( '-news_date') homepage_docs = DocumentFile.objects.filter( news__isnull=False).order_by('-news__news_date') context = getContext(news_company_news, 1, "news_company_news") context.update(getContext(news_import_info, 1, "news_import_info")) context.update(getContext(homepage_docs, 1, "homepage_docs")) return context
def dispatchView(request): dispatch_form = DispatchForm() dispatchAddCollege_form = DispatchAddCollegeForm() college_users = CollegeProfile.objects.all() expert_users = ExpertProfile.objects.all().order_by('college') school_users = SchoolProfile.objects.all() context = { "dispatch_form": dispatch_form, "dispatchAddCollege_form": dispatchAddCollege_form, "search_form": SearchForm(), } context.update(getContext(school_users, 1, "item")) context.update(getContext(college_users, 1, "item2")) context.update(getContext(expert_users, 1, "item3")) return render(request, "adminStaff/dispatch.html", context)
def index(request): ''' for index_new ''' news_announcement = News.objects.filter(news_category__category=NEWS_CATEGORY_ANNOUNCEMENT).order_by('-news_date') # news_policy = News.objects.filter(news_category__category=NEWS_CATEGORY_POLICY).order_by('-news_date') news_dynamic = News.objects.filter(news_category__category=NEWS_CATEGORY_DYNAMIC).order_by('-news_date') news_outstanding = News.objects.filter(news_category__category=NEWS_CATEGORY_OUTSTANDING).order_by('-news_date') news_others = News.objects.filter(news_category__category=NEWS_CATEGORY_OTHERS).order_by('-news_date') context = getContext(news_announcement, 1, "news_announcement", page_elems=8) # context.update(getContext(news_policy, 1, "news_policy", page_elems=8)) context.update(getContext(news_dynamic, 1, "news_dynamic", page_elems=8)) context.update(getContext(news_outstanding, 1, "news_outstanding", page_elems=8)) context.update(getContext(news_others, 1, "news_others", page_elems=8)) return context
def dispatchView(request): dispatch_form = DispatchForm() dispatchAddCollege_form=DispatchAddCollegeForm() college_users = CollegeProfile.objects.all() expert_users = ExpertProfile.objects.all().order_by('college') school_users = SchoolProfile.objects.all() context = { "dispatch_form":dispatch_form, "dispatchAddCollege_form":dispatchAddCollege_form, "search_form": SearchForm(), } context.update(getContext(school_users, 1, "item")) context.update(getContext(college_users, 1, "item2")) context.update(getContext(expert_users, 1, "item3")) return render(request, "adminStaff/dispatch.html", context)
def getAllocProjectPagination(request, page, college_id, special_id, path): message = "" page = int(page) if path == FIRST_ROUND_PATH: project_list = get_project_list(request).filter( project_status__status=PROJECT_STATUS_APPLICATION_EXPERT_SUBJECT) else: project_list = get_project_list(request).filter( project_status__status=PROJECT_STATUS_FINAL_EXPERT_SUBJECT) if college_id != "-1": project_list = project_list.filter(teacher__college=college_id) if special_id != "-1": project_list = project_list.filter(project_special=special_id) context = getContext(project_list, page, "item2", 0) for project in context["item2_list"]: project.review_status = getProjectReviewStatus(project) html = render_to_string("school/widgets/alloc_project_table.html", context) return simplejson.dumps({ "message": message, "html": html, })
def getNewsReleasePagination(request,page): message="" page =int(page) newsList = News.objects.all() context = getContext(newsList,page,"item",page_elems=7) html = render_to_string("adminStaff/widgets/newslist.html",context) return simplejson.dumps({"message":message,"html":html})
def getApplys(request, page): page = int(page) applys = ApplyInfo.objects.filter( innovation_grade=datetime.datetime.today().year) practice = PracticeProfile.objects.get(userid=request.user) applys = applys.filter( Q(wish_first=practice.id) | Q(wish_second=practice.id)) for apply in applys: apply.is_first_wish = "是" if apply.wish_first == practice else "否" try: apply.small_class = "已录入(%s)" % StudentProfile.objects.get( baseinfo_studentid=apply.student_id).small_class except: apply.small_class = "未录入" number, first_number = applys.count(), applys.filter( wish_first=practice.id).count() applys = sorted(list(applys), key=lambda x: x.is_first_wish, reverse=True) context = getContext(applys, page, "item", 0) context.update({ "number": number, "first_number": first_number, "practice": practice, }) return render_to_string("practice/widgets/applys.html", context)
def refresh_alloc_table(request, insitute): subject_list = get_current_project_query_set().filter(insitute_id=insitute) page = request.GET.get("page") context = getContext(subject_list, page, 'subject', 0) table_html = render_to_string("adminStaff/widgets/subjectalloc_table.html", context) return simplejson.dumps({"table": table_html})
def show_index_get_search_context(request, project_page, new_show=False): search_school = request.GET.get('search_school') or "" search_year = request.GET.get('search_year') or "" search_grade = request.GET.get('search_grade') or "" search_keywords = request.GET.get('search_keywords') or "" pro_type = ShowProjectSingle if new_show else ProjectSingle q1 = (search_year and Q(year=search_year)) or None q2 = (search_school and Q(school=search_school)) or None q3 = (search_grade and Q(project_grade=search_grade)) or None q4 = (search_keywords and (Q(keywords__icontains=search_keywords) | \ Q(title__icontains=search_keywords) | Q(background__icontains=search_keywords) \ | Q(result_overview__icontains=search_keywords))) or None qset = filter(lambda x: x != None, [q1, q2, q3, q4]) loginfo(p=q4, label="in q4") loginfo(p=qset, label="in qset") if qset: qset = reduce(lambda x, y: x & y, qset) project_list = pro_type.objects.filter(qset) else: project_list = pro_type.objects.all() context = getContext(project_list, project_page, 'project', page_elems=9) context["search_school"] = search_school context["search_year"] = search_year context["search_grade"] = search_grade return context
def show_index_get_search_context(request, project_page,new_show = False): search_school = request.GET.get('search_school') or "" search_year = request.GET.get('search_year') or "" search_grade = request.GET.get('search_grade') or "" search_keywords=request.GET.get('search_keywords') or "" pro_type = ShowProjectSingle if new_show else ProjectSingle q1 = (search_year and Q(year=search_year)) or None q2 = (search_school and Q(school=search_school)) or None q3 = (search_grade and Q(project_grade=search_grade)) or None q4 = (search_keywords and (Q(keywords__icontains=search_keywords) | \ Q(title__icontains=search_keywords) | Q(background__icontains=search_keywords) \ | Q(result_overview__icontains=search_keywords))) or None qset = filter(lambda x: x != None, [q1, q2, q3,q4]) loginfo(p=q4, label="in q4") loginfo(p=qset, label="in qset") if qset: qset = reduce(lambda x, y: x & y, qset) project_list = pro_type.objects.filter(qset) else: project_list = pro_type.objects.all() context = getContext(project_list, project_page, 'project', page_elems=9) context["search_school"] = search_school context["search_year"] = search_year context["search_grade"] = search_grade return context
def searchStudent(request, search_value): students = StudentProfile.objects.filter(Q(baseinfo_name = search_value) | Q(baseinfo_studentid = search_value)) if check_auth(request.user, TEACHER_USER): teacher = TeacherProfile.objects.get(userid = request.user) students = students.filter(small_class = teacher.small_class) context = getContext(students, 1, "item", 0) return render_to_string("teacher/widgets/student_set_table.html", context)
def getNewsReleasePagination(request, page): message = "" page = int(page) newsList = News.objects.all() context = getContext(newsList, page, "item", page_elems=7) html = render_to_string("adminStaff/widgets/newslist.html", context) return simplejson.dumps({"message": message, "html": html})
def getCourseMembers(request, course_id, page): page = int(page) selects = SelectCourse.objects.filter(course__id = course_id) context = getContext(selects, page, "item2", 1) context.update({"course_id": course_id, }) html = render_to_string("teacher/widgets/course_info_table.html", context) return simplejson.dumps({"html": html, })
def refresh_to_table(page, school_name): if school_name == "None": school_name = None # subject_list = AdminStaffService.GetSubject_list(school = school_name) subject_list = get_current_project_query_set().filter(school=school_name) context = getContext(subject_list, page, 'item', 0) context.update({"school_name": school_name}) return render_to_string("adminStaff/widgets/subjectrating_table.html", context)
def getUserListPagination(request, page, user): page = int(page) html = "" if user == "college": user_list = getCollegeListForHtml() context = getContext(user_list, page, "item2", 0) html = render_to_string("widgets/notice_message_setting_select_college_table.html", context) elif user == "teacher": user_list = cnt_teacher_list context = getContext(user_list, page, "item3", 0) html = render_to_string("widgets/notice_message_setting_select_teacher_table.html", context) else: user_list = cnt_expert_list context = getContext(user_list, page, "item4", 0) html = render_to_string("widgets/notice_message_setting_select_expert_table.html", context) return simplejson.dumps({"status":1, "html":html,})
def searchStudent(request, search_value): students = StudentProfile.objects.filter( Q(baseinfo_name=search_value) | Q(baseinfo_studentid=search_value)) if check_auth(request.user, TEACHER_USER): teacher = TeacherProfile.objects.get(userid=request.user) students = students.filter(small_class=teacher.small_class) context = getContext(students, 1, "item", 0) return render_to_string("teacher/widgets/student_set_table.html", context)
def ShowManage(request): show_list = ShowProjectSingle.objects.all() page = request.GET.get('page') context = getContext(show_list, page, 'show', 0) for show in context['show_list']: show.filenumber = ShowFiles.objects.filter(project_id = show).count() return render(request, "adminStaff/show_manage.html", context)
def getSearchStudentPagination(request,page,searchform): message = "" role = request.session.get('auth_role',"") searchform = StudentSearchForm(deserialize_form(searchform),request = request) stu_set = stuFilterList(request,searchform).order_by("small_class","innovation_grade") context = getContext(stu_set,page,"item",0) context.update({"role":role}) html = render_to_string("common/student/student_search_table.html",context) return simplejson.dumps({"message":message,"html":html})
def docs_search_page(request, docs_input): docs_list = News.objects.exclude(news_document=u""). \ filter(Q(news_document__icontains=docs_input)\ & Q(news_date__gte=datetime.date.today()-datetime.timedelta(365))) context = getContext(docs_list, 1, 'docs') html = render_to_string('home/ajax/_docs_list.html', context, context_instance=RequestContext(request)) return simplejson.dumps({'html': html})
def docs_search_page(request, docs_input): docs_list = News.objects.exclude(news_document=u""). \ filter(Q(news_document__icontains=docs_input)\ & Q(news_date__gte=datetime.date.today()-datetime.timedelta(365))) context = getContext(docs_list, 1, 'docs') html = render_to_string('home/ajax/_docs_list.html', context, context_instance=RequestContext(request)) return simplejson.dumps({'html':html})
def getParam(pro_list, userauth,flag,page,page2): (pending_q,default_q,search_q)=get_qset(userauth) not_pass_apply_project_group=pro_list.filter(pending_q) if flag: pass_apply_project_group=pro_list.filter(default_q) else: pass_apply_project_group=pro_list.filter(search_q) if userauth['role']==FINANCE_USER: if userauth['status']=="budget": pass_apply_project_group = pass_apply_project_group.order_by('projectfundbudget__serial_number') else: pass_apply_project_group = pass_apply_project_group.order_by('projectfundsummary__serial_number') pass_apply_project_group=addURL(pass_apply_project_group) not_pass_apply_project_group=addURL(not_pass_apply_project_group) param={} param.update(getContext(pass_apply_project_group,page2,"item2",0,page_elems=10)) param.update(getContext(not_pass_apply_project_group,page,"item",0,page_elems=10)) param.update({"pro_count":len(pass_apply_project_group)}) return param
def finalAllocView(request): expert_list = ExpertProfile.objects.all() unalloc_project_list = get_project_list(request).filter(project_status__status = PROJECT_STATUS_FINAL_SCHOOL_OVER) alloc_project_list = get_project_list(request).filter(project_status__status = PROJECT_STATUS_FINAL_EXPERT_SUBJECT) form = FilterForm(request = request) expert_form = FilterForm() context = {"form": form, "expert_form": expert_form, "page_info": "finalalloc",} context.update(getContext(unalloc_project_list, 1, "item", 0)) context.update(getContext(alloc_project_list, 1, "item2", 0)) context.update(getContext(expert_list, 1, "item3", 0)) for expert in context['item3_list']: expert.alloc_num = Re_Project_Expert.objects.filter(Q(expert = expert) & Q(is_first_round = True) & Q(project__project_status__status = PROJECT_STATUS_APPLICATION_EXPERT_SUBJECT)).count() for project in context['item2_list']: project.review_status = getProjectReviewStatus(project) return render(request, "school/alloc.html", context)
def news_search_page(request, news_input, news_cate): news_list = News.objects. \ filter(news_date__gte=datetime.date.today()-datetime.timedelta(365)). \ filter(news_category__category=news_cate). \ filter(Q(news_title__icontains=news_input) | Q(news_content__icontains=news_input)) context = getContext(news_list, 1, 'news') html = render_to_string('home/ajax/_news_list.html', context, context_instance=RequestContext(request)) return simplejson.dumps({'html': html})
def news_search_page(request, news_input, news_cate): news_list = News.objects. \ filter(news_date__gte=datetime.date.today()-datetime.timedelta(365)). \ filter(news_category__category=news_cate). \ filter(Q(news_title__icontains=news_input) | Q(news_content__icontains=news_input)) context = getContext(news_list, 1, 'news') html = render_to_string('home/ajax/_news_list.html', context, context_instance=RequestContext(request)) return simplejson.dumps({'html':html})
def ImportExpert(request): """ """ if request.method == "GET": expert_form = forms.ExpertDispatchForm() email_list = AdminStaffService.GetRegisterExpertList() page = request.GET.get('page') context = getContext(email_list, page, 'item', 0) context.update({'expert_form': expert_form}) return render(request, "adminStaff/ImportExpert.html", context)
def courseViews(request): filterForm = CourseFilterForm() courseForm = CourseForm() importDataForm = ImportDataForm() course_list = Course.objects.all() context = getContext(course_list, 1, "item") context['course_form'] = courseForm context['importDataForm'] = importDataForm context["show_delete"] = True context["filter_form"] = filterForm return render(request, "adminStaff/course/course_info.html", context)
def index(request): news_announcement = News.objects.filter(news_category__category=NEWS_CATEGORY_ANNOUNCEMENT).order_by('-news_date') news_docs = News.objects.exclude(news_document=u'').order_by('-news_date') context = getContext(news_announcement, 1, "news_announcement",page_elems=7) context.update(getContext(news_docs,1,"news_docs",page_elems = 7)) def convert_url(raw_url): return MEDIA_URL + raw_url[raw_url.find(MEDIA_URL)+len(MEDIA_URL):] homepage_pic = HomePagePic.objects.all() flag = True for pic in homepage_pic: pic.url = convert_url(pic.pic_obj.url) print pic.url if flag: pic.active = True flag = False else: pic.active = False context.update({ 'homepage_pic': homepage_pic, }) return render(request,"home/home.html",context)
def getCourseMembers(request, course_id, page): page = int(page) selects = SelectCourse.objects.filter(course__id=course_id) context = getContext(selects, page, "item2", 1) context.update({ "course_id": course_id, }) html = render_to_string("teacher/widgets/course_info_table.html", context) return simplejson.dumps({ "html": html, })
def dispatchView(request): dispatchAddCollege_form=DispatchAddCollegeForm() try: teacher_users = TeacherProfile.objects.all().order_by('college') except: teacher_users = TeacherProfile.objects.none() context = { "dispatchAddCollege_form":dispatchAddCollege_form, "search_form": SearchForm(), } context.update(getContext(teacher_users, 1, "item")) return render(request, "school/dispatch.html", context)
def dispatchView(request): dispatchAddCollege_form = DispatchAddCollegeForm() try: teacher_users = TeacherProfile.objects.all().order_by('college') except: teacher_users = TeacherProfile.objects.none() context = { "dispatchAddCollege_form": dispatchAddCollege_form, "search_form": SearchForm(), } context.update(getContext(teacher_users, 1, "item")) return render(request, "school/dispatch.html", context)
def newsRelease(request): if request.method == "GET": form = NewsForm() else: form = NewsForm(request.POST, request.FILES) if form.is_valid(): form.save() newsList = News.objects.all().order_by('-news_date') context = getContext(newsList,1,"item",page_elems=7) context.update({"newsform":NewsForm, }) return render(request,"adminStaff/news_release.html",context)
def getExpertList(request, id, path): message = "" is_first_round = (path == FIRST_ROUND_PATH) status = PROJECT_STATUS_APPLICATION_EXPERT_SUBJECT if is_first_round else PROJECT_STATUS_FINAL_EXPERT_SUBJECT if id == '-1': expert_list = ExpertProfile.objects.all() else: expert_list = ExpertProfile.objects.filter(college__id = id) context = getContext(expert_list, 1, "item3", 0) for expert in context['item3_list']: expert.alloc_num = Re_Project_Expert.objects.filter(Q(expert = expert) & Q(is_first_round = is_first_round) & Q(project__project_status__status = status)).count() html = render_to_string("school/widgets/alloc_expert_table.html", context) return simplejson.dumps({"message": message, "html": html, })
def getStudentList(request, year, page_numbers, cls, page): page = int(page) page_numbers = int(page_numbers) students = StudentProfile.objects.all() if year != "-1": students = students.filter(innovation_grade = year) if check_auth(request.user, TEACHER_USER): teacher = TeacherProfile.objects.get(userid = request.user) students = students.filter(small_class = teacher.small_class) elif cls != "-1": students = students.filter(small_class__practice_class__userid__username = cls) context = getContext(students, page, "item", 0, page_numbers) return render_to_string("teacher/widgets/student_set_table.html", context)
def getSearchStudentPagination(request, page, searchform): message = "" role = request.session.get('auth_role', "") searchform = StudentSearchForm(deserialize_form(searchform), request=request) stu_set = stuFilterList(request, searchform).order_by("small_class", "innovation_grade") context = getContext(stu_set, page, "item", 0) context.update({"role": role}) html = render_to_string("common/student/student_search_table.html", context) return simplejson.dumps({"message": message, "html": html})
def getNewsList(request, news_cate, page=1): """ mxl """ try: page = int(page) except: page = 1 news_list = News.objects.filter(news_category__category=news_cate).order_by('-news_date') context = getContext(news_list, page, "item", 0) html = render_to_string("management/widgets/news_table.html", context) # return html return simplejson.dumps({'html': html})
def dispatchView(request): dispatchAddCollege_form=DispatchAddCollegeForm(user=request.user) colleges = getCollege(request) try: qset = reduce(lambda x,y:x|y,[Q(college = _college) for _college in colleges]) teacher_users = TeacherProfile.objects.filter(qset) except: teacher_users = TeacherProfile.objects.none() context = { "dispatchAddCollege_form":dispatchAddCollege_form, } context.update(getContext(teacher_users, 1, "item")) return render(request, "college/dispatch.html", context)
def newsListByCate(request, news_cate): try: if news_cate == NEWS_CATEGORY_DOCUMENTS: news_list = News.objects.exclude(news_document=u'').order_by('-news_date') else: news_list = News.objects.filter(news_category__category=news_cate).order_by('-news_date') except: raise Http404 context = getContext(news_list,1, 'item') context["news_cate"] = news_cate context['%s_active' % news_cate] = 'active' return render(request, 'home/newsContentByCate.html', \ context)
def docs_turn_page(request, docs_page, docs_search): try: docs_page = int(docs_page) except: docs_page = 1 docs_list = (docs_search and \ News.objects.filter(news_document__icontains=docs_search)) \ or News.objects.exclude(news_document=u'') context = getContext(docs_list, docs_page, 'docs') html = render_to_string('home/ajax/_docs_list.html', context, context_instance=RequestContext(request)) return simplejson.dumps({'html':html})
def getCourseScores(request, course_id, page): page = int(page) selects = SelectCourse.objects.filter(course__id = course_id) for select in selects: tmp_score = Score.objects.filter(select_obj = select) if tmp_score: select.score = tmp_score[0] else : continue # select.score = Score.objects.get(select_obj = select) context = getContext(selects, page, "item2", 1) context.update({"course_id": course_id, }) html = render_to_string("teacher/widgets/score_info_table.html", context) return simplejson.dumps({"html": html, })
def common_studentsearchViews(request): role = request.session.get('auth_role', "") stu_set = "" if request.method == 'POST': searchform = StudentSearchForm(request.POST,request = request) stu_set = stuFilterList(request,searchform).order_by("small_class","innovation_grade") else: searchform = StudentSearchForm(request = request) context = getContext(stu_set,1,"item",0) context.update({ 'searchform':searchform, 'role':role, }) return context
def news_turn_page(request, news_page, news_search, news_cate): try: news_page = int(news_page) except: news_page = 1 news_list = (news_search and \ News.objects.filter(news_category__category=news_cate).filter(news_title__icontains=news_search)) \ or News.objects.filter(news_category__category=news_cate).order_by('-news_date') context = getContext(news_list, news_page, 'news') context["news_cate"] = NewsCategory.objects.get(category=news_cate) html = render_to_string('home/ajax/_news_list.html', context, context_instance=RequestContext(request)) return simplejson.dumps({'html':html})