def index(request): '''判断是否具备管理功能,如果具备则可以查看所有的申请单,如果不具备只能查看当前用户自己提交的申请单''' buttonlist = request.session["authority_list_button"] if 'applyonlinemanage' in buttonlist: applyonlines = ApplyOnline.objects.filter(flag=1).order_by('-id') else: applyonlines = ApplyOnline.objects.filter(flag=1, apply_user__iexact=request.user.username).order_by('-id') retdir = {} if 'applyid' in request.POST and request.POST['applyid']: applyid = request.POST['applyid'] retdir['applyid'] = applyid applyonlines = applyonlines.filter(applyid__icontains = applyid) if 'status' in request.POST and request.POST['status']: status = request.POST['status'] if status == 'all': retdir['status'] = status else: retdir['status'] = int(status) applyonlines = applyonlines.filter(status__iexact = int(status)) if 'dateStart' in request.POST and request.POST['dateStart']: dateStart = request.POST['dateStart'] retdir['dateStart'] = dateStart dateStart = time.strptime(dateStart, "%Y-%m-%d") dateStart = time.strftime("%Y-%m-%d %H:%M:%S", dateStart) dateStart = utils.secs2datestr(utils.datestr2secs(dateStart)) applyonlines = applyonlines.filter(Q(apply_time__gte = dateStart)) if 'dateEnd' in request.POST and request.POST['dateEnd']: dateEnd = request.POST['dateEnd'] retdir['dateEnd'] = dateEnd dateEnd = time.strptime(dateEnd, "%Y-%m-%d") dateEnd = time.strftime("%Y-%m-%d %H:%M:%S", dateEnd) dateEnd = utils.secs2datestr(utils.datestr2secs(dateEnd) + 23*60*60 + 59*60 + 59) applyonlines = applyonlines.filter(Q(apply_time__lte = dateEnd)) orderField = request.POST.get('orderField', None) orderDirection = request.POST.get('orderDirection', None) if orderField != None and orderField != '' and orderDirection != None and orderDirection != '': retdir['orderField'] = orderField retdir['orderDirection'] = orderDirection if orderDirection == 'asc': applyonlines = applyonlines.order_by(orderField) elif orderDirection == 'desc': applyonlines = applyonlines.order_by('-' + orderField) if 'numPerPage' in request.POST and request.POST['numPerPage']: numPerPage = request.POST['numPerPage'] else: numPerPage = 10 paginator = Paginator(applyonlines, numPerPage) page = request.POST.get('pageNum', 1) try: if int(page) > paginator.num_pages: page = str(paginator.num_pages) applyonlines = paginator.page(page) except (EmptyPage, InvalidPage): applyonlines = paginator.page(paginator.num_pages) tmpdir = {'applyonlines':applyonlines, 'currentPage':page, 'numPerPage':numPerPage, 'applyonline_status_dict':applyonline_status_dict} retdir.update(tmpdir) return render_to_response('applyonline/basepage.html', retdir, context_instance=RequestContext(request))
def index(request): retdir = {} logs = Log.objects.order_by('-start_time') if 'query' in request.POST and request.POST['query']: query = request.POST['query'] retdir['query'] = query logs = logs.filter(username__icontains=query) if 'dateStart' in request.POST and request.POST['dateStart']: dateStart = request.POST['dateStart'] retdir['dateStart'] = dateStart dateStart = time.strptime(dateStart, "%Y-%m-%d") dateStart = time.strftime("%Y-%m-%d %H:%M:%S", dateStart) dateStart = utils.secs2datestr(utils.datestr2secs(dateStart)) logs = logs.filter(start_time__gte=dateStart) if 'dateEnd' in request.POST and request.POST['dateEnd']: dateEnd = request.POST['dateEnd'] retdir['dateEnd'] = dateEnd dateEnd = time.strptime(dateEnd, "%Y-%m-%d") dateEnd = time.strftime("%Y-%m-%d %H:%M:%S", dateEnd) dateEnd = utils.secs2datestr( utils.datestr2secs(dateEnd) + 23 * 60 * 60 + 59 * 60 + 59) logs = logs.filter(start_time__lte=dateEnd) if 'numPerPage' in request.POST and request.POST['numPerPage']: numPerPage = request.POST['numPerPage'] else: numPerPage = 10 paginator = Paginator(logs, numPerPage) page = request.POST.get('pageNum', 1) try: if int(page) > paginator.num_pages: page = str(paginator.num_pages) logs = paginator.page(page) except (EmptyPage, InvalidPage): logs = paginator.page(paginator.num_pages) tmpdir = { 'logs': logs, 'currentPage': page, 'numPerPage': numPerPage, 'log_level_dict': log_level_dict } retdir.update(tmpdir) return render_to_response('log/basepage.html', retdir, context_instance=RequestContext(request))
def index(request): retdir = {} logs = Log.objects.order_by('-start_time') if 'query' in request.POST and request.POST['query']: query = request.POST['query'] retdir['query'] = query logs = logs.filter(username__icontains = query) if 'dateStart' in request.POST and request.POST['dateStart']: dateStart = request.POST['dateStart'] retdir['dateStart'] = dateStart dateStart = time.strptime(dateStart, "%Y-%m-%d") dateStart = time.strftime("%Y-%m-%d %H:%M:%S", dateStart) dateStart = utils.secs2datestr(utils.datestr2secs(dateStart)) logs = logs.filter(start_time__gte = dateStart) if 'dateEnd' in request.POST and request.POST['dateEnd']: dateEnd = request.POST['dateEnd'] retdir['dateEnd'] = dateEnd dateEnd = time.strptime(dateEnd, "%Y-%m-%d") dateEnd = time.strftime("%Y-%m-%d %H:%M:%S", dateEnd) dateEnd = utils.secs2datestr(utils.datestr2secs(dateEnd) + 23*60*60 + 59*60 + 59) logs = logs.filter(start_time__lte = dateEnd) if 'numPerPage' in request.POST and request.POST['numPerPage']: numPerPage = request.POST['numPerPage'] else: numPerPage = 10 paginator = Paginator(logs, numPerPage) page = request.POST.get('pageNum',1) try: if int(page) > paginator.num_pages: page = str(paginator.num_pages) logs = paginator.page(page) except (EmptyPage, InvalidPage): logs = paginator.page(paginator.num_pages) tmpdir = {'logs':logs, 'currentPage':page, 'numPerPage':numPerPage, 'log_level_dict':log_level_dict} retdir.update(tmpdir) return render_to_response('log/basepage.html', retdir, context_instance=RequestContext(request))