def view_dac_meeting_report_spreadsheet(request): if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) dac_kwargs = {} if request.method == 'GET' and request.GET.has_key('start_date'): dac_form = DacForm(request.GET) if dac_form.is_valid(): dac_kwargs.update(dac_form.get_dac_kwargs()) dac_meetings = get_dac_meetings(dac_kwargs) book = xlwt.Workbook(encoding="utf-8") # With a workbook object made we can now add some sheets. sheet1 = book.add_sheet(slugify('DAC')) date_obj = datetime.now() sheet1 = make_dac_report(sheet1, dac_meetings) # create response object response = HttpResponse(mimetype='application/ms-excel') response['Content-Disposition'] = 'attachment; filename=dac_%s.xls' % ( date_obj.strftime('%m%d-%I-%M%p-%S').lower()) # send .xls spreadsheet to response stream book.save(response) return response
def view_dac_meeting_report_spreadsheet(request): if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) dac_kwargs = {} if request.method=='GET' and request.GET.has_key('start_date'): dac_form = DacForm(request.GET) if dac_form.is_valid(): dac_kwargs.update(dac_form.get_dac_kwargs()) dac_meetings = get_dac_meetings(dac_kwargs) book = xlwt.Workbook(encoding="utf-8") # With a workbook object made we can now add some sheets. sheet1 = book.add_sheet(slugify('DAC')) date_obj = datetime.now() sheet1 = make_dac_report(sheet1, dac_meetings) # create response object response = HttpResponse(mimetype='application/ms-excel') response['Content-Disposition'] = 'attachment; filename=dac_%s.xls' % ( date_obj.strftime('%m%d-%I-%M%p-%S').lower()) # send .xls spreadsheet to response stream book.save(response) return response
def view_faculty_contacts(request): if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) lu = get_basic_view_dict(request) lu.update( { 'FACULTY_INFO_PAGE' : True \ , 'FACULTY_CONTACT_INFO' : True\ , 'page_title' : 'Faculty Contacts'\ }) faculty_member_kwargs = {} faculty_members = None num_faculty_members = 0 no_faculty_members_found = False if request.method == 'GET' and request.GET.has_key('faculty_status'): contact_form = ContactForm(request.GET) if contact_form.is_valid(): faculty_member_kwargs.update( contact_form.get_faculty_info_kwargs()) faculty_members = get_faculty_members(faculty_member_kwargs) num_faculty_members = len(faculty_members) if num_faculty_members == 0: no_faculty_members_found = True else: print 'NOT valid!' lu.update({'ERR_form_not_valid': True}) else: contact_form = ContactForm() lu.update({ 'faculty_members' : faculty_members\ , 'num_faculty_members' : num_faculty_members\ , 'no_faculty_members_found' : no_faculty_members_found , 'contact_form' : contact_form\ , 'QUERY_STRING' : request.META['QUERY_STRING'] }) return render_to_response('faculty_info/contact_info.html', lu, context_instance=RequestContext(request))
def view_faculty_contacts(request): if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) lu = get_basic_view_dict(request) lu.update( { 'FACULTY_INFO_PAGE' : True \ , 'FACULTY_CONTACT_INFO' : True\ , 'page_title' : 'Faculty Contacts'\ }) faculty_member_kwargs = {} faculty_members = None num_faculty_members = 0 no_faculty_members_found = False if request.method=='GET' and request.GET.has_key('faculty_status'): contact_form = ContactForm(request.GET) if contact_form.is_valid(): faculty_member_kwargs.update(contact_form.get_faculty_info_kwargs()) faculty_members = get_faculty_members(faculty_member_kwargs) num_faculty_members = len(faculty_members) if num_faculty_members == 0: no_faculty_members_found = True else: print 'NOT valid!' lu.update({ 'ERR_form_not_valid' : True }) else: contact_form = ContactForm() lu.update({ 'faculty_members' : faculty_members\ , 'num_faculty_members' : num_faculty_members\ , 'no_faculty_members_found' : no_faculty_members_found , 'contact_form' : contact_form\ , 'QUERY_STRING' : request.META['QUERY_STRING'] }) return render_to_response('faculty_info/contact_info.html', lu, context_instance=RequestContext(request))
def view_dac_meeting_report(request): if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) lu = get_basic_view_dict(request) lu.update( { 'DAC_MEETING_REPORT_PAGE' : True \ , 'IS_DAC_MEETING_PAGE' : True\ , 'page_title' : 'DAC Meeting Report'\ , 'RM_STATUS_SCHEDULED' : RM_STATUS_SCHEDULED , 'RM_FAIL_STATUSES' : RM_FAIL_STATUSES }) dac_kwargs = {} dac_meetings = None num_dac_meetings = 0 if request.method == 'GET' and request.GET.has_key('start_date'): dac_form = DacForm(request.GET) if dac_form.is_valid(): dac_kwargs.update(dac_form.get_dac_kwargs()) dac_meetings = get_dac_meetings(dac_kwargs) num_dac_meetings = len(dac_meetings) else: print 'NOT valid!' lu.update({'ERR_form_not_valid': True}) else: dac_form = DacForm() lu.update({ 'dac_meetings' : dac_meetings\ , 'num_dac_meetings' : num_dac_meetings\ , 'dac_form' : dac_form\ , 'QUERY_STRING' : request.META['QUERY_STRING'] }) return render_to_response('dac_meetings/dac_meetings.html', lu, context_instance=RequestContext(request))
def view_dac_meeting_report(request): if not (request.user.is_authenticated and request.user.is_staff): return HttpResponseRedirect(get_not_logged_in_page()) lu = get_basic_view_dict(request) lu.update( { 'DAC_MEETING_REPORT_PAGE' : True \ , 'IS_DAC_MEETING_PAGE' : True\ , 'page_title' : 'DAC Meeting Report'\ , 'RM_STATUS_SCHEDULED' : RM_STATUS_SCHEDULED , 'RM_FAIL_STATUSES' : RM_FAIL_STATUSES }) dac_kwargs = {} dac_meetings = None num_dac_meetings = 0 if request.method=='GET' and request.GET.has_key('start_date'): dac_form = DacForm(request.GET) if dac_form.is_valid(): dac_kwargs.update(dac_form.get_dac_kwargs()) dac_meetings = get_dac_meetings(dac_kwargs) num_dac_meetings = len(dac_meetings) else: print 'NOT valid!' lu.update({ 'ERR_form_not_valid' : True }) else: dac_form = DacForm() lu.update({ 'dac_meetings' : dac_meetings\ , 'num_dac_meetings' : num_dac_meetings\ , 'dac_form' : dac_form\ , 'QUERY_STRING' : request.META['QUERY_STRING'] }) return render_to_response('dac_meetings/dac_meetings.html', lu, context_instance=RequestContext(request))