def exportCSV(request): customer_ids = Reservation.objects.filter(service_provider=request.user.service_provider).exclude(customer__isnull=True).values_list('customer_id', flat=True).distinct(); # Find customers who have not reserved anything yet and were added by service provider customers_nonr = Customer.objects.filter(service_provider=request.user.service_provider) customers = Customer.objects.filter(pk__in=customer_ids) # Merge two QuerySets together customers = customers | customers_nonr qc = request.GET.get('qc', '') # Search by name if qc: customers = customers.filter(full_name__contains=qc) customers = customers.order_by('last_name') # Construct HTTP response response = HttpResponse(content_type="text/csv") response['Content-Disposition'] = 'attachment; filename="customers.csv"' writer = csv.writer(response, csv.excel) response.write(u'\ufeff'.encode('utf8')) # for excel writer.writerow([ smart_str(u"First_Name"), smart_str(u"Last_Name"), smart_str(u"Phone"), smart_str(u"Email"), ]) for customer in customers: writer.writerow([ smart_str(customer.name), smart_str(customer.last_name), smart_str(customer.phone), smart_str(customer.email), ]) return response
def export(request): ''' 导出巡检报告 ''' response = HttpResponse(content_type='text/plain') response['Content-Disposition'] = 'attachment; filename=data.txt' report_list = Report.objects.all() logger.info(u'获得所有报告') parser = Parser(logger) i = 1 seperator = '#' for report in report_list: pass_rate = float(report.pass_num) / float(report.total_num) str_pass_rate = str(int(pass_rate * 100)) + '%' #获得巡检报告在服务器的目录 report_dir = settings.MEDIA_ROOT + report.system + os.path.sep + report.province + os.path.sep + report.reporter time_str = os.path.dirname(report.report_path)[-17:] time_str.replace('\\',os.path.sep) report_dir = report_dir + os.path.sep + time_str detail_info = parser.parse_outputxml(report_dir + os.path.sep + 'output.xml') if detail_info == '': #确少详细信息的记录不导出 continue response.write(str(i) + seperator + report.system + seperator \ + report.province + seperator + report.city + seperator \ + str(report.total_num) + seperator + str(report.pass_num) + seperator \ + str_pass_rate + seperator + report.sub_time.strftime("%Y-%m-%d") \ + seperator + report.reporter + seperator + ' ' + seperator + ' ' + detail_info + seperator) i += 1 return response
def _http_auth_helper(self, request): # At this point, the user is either not logged in, or must log # in using http auth. If they have a header that indicates a # login attempt, then use this to try to login. if 'HTTP_AUTHORIZATION' in request.META: auth = request.META['HTTP_AUTHORIZATION'].split() if len(auth) == 2: if auth[0].lower() == 'basic': # Currently, only basic http auth is used. uname, passwd = base64.b64decode(auth[1]).split(':') user = authenticate(username=uname, password=passwd) if user and user.is_staff: request.session['moat_username'] = uname return # The username/password combo was incorrect, or not provided. # Challenge the user for a username/password. resp = HttpResponse() resp.status_code = 401 try: # If we have a realm in our settings, use this for the # challenge. realm = settings.HTTP_AUTH_REALM except AttributeError: realm = "" resp['WWW-Authenticate'] = 'Basic realm="%s"' % realm return resp
def attach(request, app_name): '''View function to attach facebook/twitter account to user. If a twitter account is to be attached, the incoming request is simply an indicator. This function then call twitter request_token api to ask for a temporary twitter token and twitter secret token, save it to database and send back to the client. Args: request: Incoming request. app_name: The name of social network to be attached. Returns: Token string if twitter token is successfully received. Error message if network is not supported. ''' response = HttpResponse() if app_name == 'facebook': success(request, 'facebook account attached') elif app_name == 'twitter': request_token_url = 'https://api.twitter.com/oauth/request_token' oauth = OAuth1(client_key, client_secret=client_secret) r = requests.post(url=request_token_url, auth=oauth, data={'oauth_callback': 'http://ec2-54-173-9-169.compute-1.amazonaws.com:9090/twitter'}) twitter_query = QueryDict(r.content) UserProfile.insert_twitter_token(twitter_query, request.user) return HttpResponse(twitter_query['oauth_token']) else: error(request, 'Unsupported social network') response.status_code = 400 response.write(''.join([item.message for item in get_messages(request)])) return response
def log_in(request): '''View function corresponding to url /login. The purpose of this function vary with http method. If method is GET it behaves as unauthorize redirect destination; If method is POST it accepts request's form data, validates it and adds session to authorize the user. Args: request: Incoming request Returns: When GET, indicate the page has been redirected here; When POST, return either message that user is logged in or error that form invalid or user name/password error. ''' response = HttpResponse() if request.method == 'GET': info(request, 'Indicator') else: form = UserForm(request.POST) if form.is_valid(): user = authenticate(username=form.cleaned_data['name'], password=form.cleaned_data['passwd']) if user != None: login(request, user) success(request, 'User exists.') else: error(request, 'User does not exist.') response.status_code = 400 else: error(request, 'Invalid input data') response.status_code = 400 response.write(''.join([item.message for item in get_messages(request)])) return response
def register(request): '''View function handling user registration. This function parse and validate incoming request's form data and check table auth_user for authenticity before storing user record in table or output error message. Args: request: Incoming request. Returns: Indicator that user is successfully created or error message that either form data is invalid or user exists. ''' form = UserForm(request.POST) response = HttpResponse() if form.is_valid(): try: user = User.objects.create_user(form.cleaned_data['name'], password=form.cleaned_data['passwd']) success(request, 'Successfully create user.') except IntegrityError: error(request, 'User name exists.') response.status_code = 400 else: error(request, 'Invalid input data') response.status_code = 400 response.write(''.join([item.message for item in get_messages(request)])) return response
def download_theme(self, request, pk): theme = Theme.objects.get(pk=pk) s = io.BytesIO() with zipfile.ZipFile(s, 'w', compression=zipfile.ZIP_DEFLATED) as z: templates = [] for template in theme.template_set.filter(enabled=True): filename = "templates/{path}".format( path=template.path, pk=template.pk, position=template.position, enabled=template.enabled) if template not in templates: z.writestr(filename, template.source.encode(settings.FILE_CHARSET)) templates.append(template) static_files = [] for static_file in theme.staticfile_set.filter(enabled=True): filename = "static/{path}".format( path=static_file.path, pk=static_file.pk, enabled=static_file.enabled) content = static_file.file.read() if static_file not in static_files: z.writestr(filename, content) static_files.append(static_file) response = HttpResponse(content_type="application/x-zip-compressed") response['Content-Disposition'] = 'attachment; filename=%s_theme.zip' % theme.name.lower() response.write(s.getvalue()) return response
def some_view(request,id): envio=Envio.objects.get(pk=id) if envio.distribuidor_id == None: query_cliente="select c.nombre from cliente c join envio_producto ep on ep.cliente_id = c.id_cliente "\ " join envio e on e.id_envio = ep.envio_id where e.id_envio="+str(id) cliente_nombre=execute_query(query_cliente)[0] else: cliente_nombre=Distribuidor.objects.get(pk=envio.distribuidor_id).nombre query_ep="select count(*),p.codigo,ep.lote, p.nombre,p.precio from envio_producto ep"\ " join producto p on p.id_producto = ep.producto_id where ep.envio_id= "+str(id)+""\ " group by p.codigo,ep.lote,p.nombre, p.precio" envios_productos=execute_all_query(query_ep) # Create the HttpResponse object with the appropriate PDF headers. response = HttpResponse(content_type='application/pdf') response['Content-Disposition'] = 'attachment; filename="Nota de Envio Nro. '+str(envio.nro_talonario)+'.pdf"' buffer = BytesIO() # Create the PDF object, using the BytesIO object as its "file." p = canvas.Canvas(buffer,pagesize=A4) encabezado(p,envio.nro_talonario) cuerpo(p=p,envio=envio,envios_productos=envios_productos,cliente_nombre=cliente_nombre) encabezado(canvas=p, nro=envio.nro_talonario, copia=True) cuerpo(p=p, envio=envio, envios_productos=envios_productos, copia=True, cliente_nombre=cliente_nombre) # Get the value of the BytesIO buffer and write it to the response. pdf = buffer.getvalue() buffer.close() response.write(pdf) return response
def process_request(self, request): """ Parse the session id from the 'Session-Id: ' header when using the api. """ if self.is_api_request(request): try: parsed_session_uri = parse_session_id(request) if parsed_session_uri is not None: domain = get_domain(request) if parsed_session_uri['realm'] != domain: raise exceptions.PermissionDenied( _('Can not accept cookie with realm %s on realm %s') % ( parsed_session_uri['realm'], domain ) ) session_id = session_id_from_parsed_session_uri( parsed_session_uri) request.session = start_or_resume( session_id, session_type=parsed_session_uri['type']) request.parsed_session_uri = parsed_session_uri # since the session id is assigned by the CLIENT, there is # no point in having csrf_protection. Session id's read # from cookies, still need csrf! request.csrf_processing_done = True return None except exceptions.APIException as e: response = HttpResponse('{"reason": "%s"}' % e.detail, content_type='application/json') response.status_code = e.status_code return response return super(HeaderSessionMiddleware, self).process_request(request)
def run(self): if self.input_Request.GET.get("unlogin")!=None: return self.unlogin() beijing={"id":1,"name":"北京"} shanghai={"id":2,"name":"上海"} userAreas=[beijing,shanghai] dataset={"result":"","areas":userAreas} if self.input_Request.method=="POST": getUserName=self.input_Request.POST.get("txtUserName") getUserPass=self.input_Request.POST.get("txtUserPass") Login_result=self.login(getUserName,getUserPass) if Login_result: myResponse=HttpResponse("<script>self.location='/index/index'</script>") myResponse.set_cookie("userlogin_username",getUserName,3600) return myResponse else: dataset["result"]="用户名和密码错误" myResponse=render_to_response("userlogin.html",dataset) return render_to_response("userlogin.html",dataset)
def response_for_download(report, cd_value='attachment'): """ Preparing response for downloading file Content-Disposition header field from http://tools.ietf.org/html/rfc2183 :param: report - instance of Report model :param: cd_value - Content Disposition Value: "attachment" - for download "inline" - for preview :return: HttpResponse with report.file and some parameters """ path = report.file.path fileExt = os.path.splitext(report.filename)[1] # [0] returns path+filename ct = get_mimeType().get(fileExt.lower(), "application/octet-stream") filename = report.filename cdv = '%s; ' % cd_value fn = 'filename="%s"; ' % transliterate(filename) fns = "filename*=utf-8''%s; " % urlquote(filename) md = 'modification-date="%s"; ' % report.uploaded_on response = HttpResponse(content_type=ct) # content = report.file.read() with open(path, 'rb') as file: content = file.read() # читаємо файл незалежно від report # (інакше при тестуванні не завжди # вдається видалити тимчасовий файл) response.write(content) response['Content-Disposition'] = cdv + fn + fns + md response['Content-Length'] = report.file.size return response
def process_cache_response(self, view_instance, view_method, request, args, kwargs): key = self.calculate_key( view_instance=view_instance, view_method=view_method, request=request, args=args, kwargs=kwargs ) response = self.cache.get(key) if not response: response = view_method(view_instance, request, *args, **kwargs) response = view_instance.finalize_response(request, response, *args, **kwargs) response.render() # should be rendered, before picklining while storing to cache if not response.status_code >= 400 or self.cache_errors: response_dict = ( response.rendered_content, response.status_code, response._headers ) self.cache.set(key, response_dict, self.timeout) else: content, status, headers = response response = HttpResponse(content=content, status=status) response._headers = headers if not hasattr(response, '_closable_objects'): response._closable_objects = [] return response
def postImageContent(request): userId = request.session.get(KEY_USER_ID, '') if not userId: return HttpResponse('你还未登录或登录已过期') print(str(request.POST)) images = request.POST.getlist('images[]') texts = request.POST.getlist('texts[]') title = request.POST.get('title') category = request.POST.get('category') author = request.POST.get('author') print("分类:", category) articleType = 3 # 图文 contentType = 3 # 图文 if articleService.addImageArticle(userId, title, category, contentType, articleType, images, texts, author): return HttpResponse(SUCCESS) else: response = HttpResponse(ERROR) response.status_code = 500 return response
def render_pdf( self, html, filename = None ): response = HttpResponse( content_type = self.PDF_CNT_TYPE ) w = Watch( "BaseView.render_pdf" ) w.start() if filename == None: filename = datetime.now().strftime( "%Y%m%d" ) + '-export.pdf' pdf_path = settings.MEDIA_ROOT + '/pdf/contracts/' + filename pdf_file = open( pdf_path, "w+b" ) try: pisa.CreatePDF( html, dest = pdf_file ) except Exception as e : print ( traceback.format_exc() ) pdf_file.seek( 0 ) pdf = pdf_file.read() pdf_file.close() response['Content-Disposition'] = filename response["Cache-Control"] = "max-age=0" response["Accept-Ranges"] = "none" response.content = pdf print( "Rendering PDF took :" ) print( w.display() ) return response
def export_csv_photo(modeladmin, request, queryset): response = HttpResponse(mimetype='text/csv') response['Content-Disposition'] = 'attachment; filename=tigatrapp_photos.csv' writer = csv.writer(response, csv.excel) response.write(u'\ufeff'.encode('utf8')) # BOM (optional...Excel needs it to open UTF-8 file properly) writer.writerow([ smart_str(u"id"), smart_str(u"url"), smart_str(u"user"), smart_str(u"report"), smart_str(u"date"), smart_str(u"report_lat"), smart_str(u"report_lon"), smart_str(u"report_note"), smart_str(u"report_type"), smart_str(u"report_responses"), ]) for obj in queryset: writer.writerow([ smart_str(obj.id), smart_str("http://%s%s" % (request.get_host(), obj.photo.url)), smart_str(obj.user), smart_str(obj.report), smart_str(obj.date), smart_str(obj.report.lat), smart_str(obj.report.lon), smart_str(obj.report.note), smart_str(obj.report.type), smart_str(obj.report.response_string), ]) return response
def generar_pdf(request, message): # message = '' # Create the HttpResponse object with the appropriate PDF headers. response = HttpResponse(content_type='application/pdf') response['Content-Disposition'] = 'attachment; filename="somefilename.pdf"' buffer = BytesIO() # Create the PDF object, using the BytesIO object as its "file." p = canvas.Canvas(buffer, pagesize=A4) p.setLineWidth(.30) p.setFont('Helvetica', 22) # Draw things on the PDF. Here's where the PDF generation happens. # See the ReportLab documentation for the full list of functionality. p.drawString(30, 750, "Hello world. " + message) p.drawImage('static/nao.png',440,720,100,100) # Close the PDF object cleanly. p.showPage() p.save() # Get the value of the BytesIO buffer and write it to the response. pdf = buffer.getvalue() buffer.close() #startfile(pdf) response.write(pdf) # context = {'message' : message} #render(request , 'prueba.html',context) return response
def get(self, request, *args, **kwargs): response = HttpResponse(content_type="application/svg") response['Content-Disposition'] = 'attachment; filename="planner2015.pdf"' svg = output_svg_planner(output_format="buffer", file_format="pdf") response.write(svg) return response
def get(self, request, *args, **kwargs): importer = request.GET.get("importer") file_name = request.GET.get("file_name") if not importer or not file_name: return HttpResponseBadRequest(_("Invalid parameters")) importer_cls = get_importer(importer) if not importer_cls or not importer_cls.has_example_file(): raise Http404(_("Invalid importer")) example_file = importer_cls.get_example_file(file_name) if not example_file: raise Http404(_("Invalid file name")) response = HttpResponse(content_type=example_file.content_type) response['Content-Disposition'] = 'attachment; filename=%s' % example_file.file_name data = importer_cls.get_example_file_content(example_file, request) if not data: raise Http404(_("File not found")) data.seek(0) response.write(data.getvalue()) return response
def export_response(self): response = HttpResponse(content_type=self.export.get_content_type()) response['Content-Disposition'] = 'attachment; filename="{0}"'.format( self.filename ) response.write(self.export_bytes()) return response
def post(self, request, *args, **kwargs): payload = json.loads(request.body.decode('utf-8')) if request.META.get('HTTP_X_GITHUB_EVENT') == "ping": return HttpResponse('Hi!') if False: if request.META.get('HTTP_X_GITHUB_EVENT') != "push": response = HttpResponse() response.status_code = 403 return response signature = request.META.get('HTTP_X_HUB_SIGNATURE').split('=')[1] secret = settings.GITHUB_HOOK_SECRET if isinstance(secret, str): secret = secret.encode('utf-8') mac = hmac.new(secret, msg=request.body, digestmod=sha1) if not hmac.compare_digest(mac.hexdigest(), signature): response = HttpResponse() response.status_code = 403 return response handle_push_hook_request(payload) return HttpResponse("OK")
def post(self, request, *args, **kwargs): """ Doesn't allow requests from localhost. If form data is correct, function adds new Note object. If not, returns form with errors. Allows CORS. """ response = HttpResponse() response['Content-Type'] = 'application/json' response['Access-Control-Allow-Origin'] = '*' response['Access-Control-Allow-Credentials'] = 'true' response['Access-Control-Allow-Methods'] = ', '.join(self.default_methods) response['Access-Control-Allow-Headers'] = ', '.join(self.default_headers) if request.META['REMOTE_ADDR'] == '127.0.0.1': content = {'result': 'error', 'msg': 'POST is not allowed from localhost.'} else: form = AddNoteForm(request.POST, request.FILES) if form.is_valid(): text = form.cleaned_data['text'] img = form.cleaned_data['img'] Note.objects.create(text=text, img=img) content = {'result': 'success', 'redirect': reverse('note_list')} else: t = loader.get_template('add_note_form.html') ctx = RequestContext(request, {'form': form}) form_with_errors = t.render(ctx) content = {'result': 'success', 'form': unicode(form_with_errors)} response.content = json.dumps(content) return response
def render_data_to_response(self, table_data, **kwargs): f = StringIO() f.write(os.linesep.join([self.delimiter.join(map(str, row)) for row in table_data])) response = HttpResponse(content_type="application/octet-stream") response["Content-Disposition"] = "attachment; filename=%s" % urlquote(self.full_file_name) response.write(f.getvalue()) return response
def get(self, request, *args, **kwargs): self.args = args self.kwargs = kwargs build = self.get_object() response = HttpResponse(content_type="text/plain") response.write(build.get_log()) return response
def get(self, request, *args, **kwargs): super(BulkLicenceRenewalPDFView, self).get(request, *args, **kwargs) licences = [] if self.qs: licences = self.qs response = HttpResponse(content_type='application/pdf') response.write(bulk_licence_renewal_pdf_bytes(licences, request.build_absolute_uri(reverse('home')))) return response
def index(request): response_data = {} response_data['server'] = 'oauth2_server.com' response_data['version'] = 'django {0}'.format(get_version()) resp = HttpResponse(json.dumps(response_data), content_type="application/json") resp.status_code = 200 return resp
def get_finance_file(request): path = request.GET.get('path') name = path.split('/')[-1] c = open(path, 'rb').read() response = HttpResponse() response['Content-Disposition'] = 'attachment;filename="%s"' % name response.write(c) return response
def make_response(status=200, content=None): if content is None: content = {} response = HttpResponse() response.status_code = status response['Content-Type'] = "application/json" response.content = json.dumps(content) return response
def object_to_json_response(obj, status=200): """ Given an object, returns an HttpResponse object with a JSON serialized version of that object """ data = json.dumps(obj, ensure_ascii=False) response = HttpResponse(content_type='application/json', status=status) response.write(data) return response
def is_logged(request): if request.user.is_authenticated(): res = HttpResponse("") res.status_code = 200 return res else: res = HttpResponse("Unauthorized") res.status_code = 401 return res
def process_output(request, book_id=0): response = HttpResponse() start_line = int(request.GET.get('start_line', 0)) log_file = get_log_file(book_id) with open(log_file, 'r') as fp: for i, line in enumerate(fp): if i >= start_line: response.write(line) return response
def sourcecodesubmit(request): user = request.user if user.groups.filter(name='sourcecode').exists(): gamestatus = SourcecodeUser.objects.filter(user=user)[0] answersAll = Sourcecode.objects.filter(user=user) #if gamestatus.gameover == 1: # return HttpResponseRedirect('/Sourcecode/done') playstart = SourcecodeUser.objects.filter(user=user)[0] bidded = Sourcecode.objects.filter(user=user)[0] if len(answersAll) == 0: if request.method == "POST": v = request.POST.get('number') points = request.POST.get('points') bidded_points = int(bidded.points) newpoints = bidded_points - int(points) if 0: return redirect('https://www.codechef.com/') else: if v == '1': if playstart.last_played > timezone.now() - timedelta( minutes=30): timeremain = timezone.now() - playstart.last_played minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid1: return redirect('https://www.codechef.com/') Sourcecodeanswer = Sourcecode(user=user, question1=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid1=1) Sourcecodeanswer.save() return render( request, 'sourcecodestart1.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '2': if playstart.last_played2 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played2 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid2: return redirect('https://www.codechef.com/') Sourcecodeanswer = Sourcecode(user=user, question2=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid2=1) Sourcecodeanswer.save() return render( request, 'sourcecodestart2.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '3': if playstart.last_played3 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played3 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid3: return redirect('https://www.google.com/') Sourcecodeanswer = Sourcecode(user=user, question3=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid3=1) Sourcecodeanswer.save() return render( request, 'sourcecodestart3.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '4': if playstart.last_played4 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played4 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid4: return redirect('https://www.google.com/') Sourcecodeanswer = Sourcecode(user=user, question4=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid4=1) Sourcecodeanswer.save() return render( request, 'sourcecodestart4.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '5': if playstart.last_played5 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played5 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid5: return redirect('https://www.google.com/') Sourcecodeanswer = Sourcecode(user=user, question5=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid5=1) Sourcecodeanswer.save() return render( request, 'sourcecodestart5.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '6': if playstart.last_played6 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played6 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid6: return redirect('https://www.google.com/') Sourcecodeanswer = Sourcecode(user=user, question6=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid6=1) Sourcecodeanswer.save() return render( request, 'sourcecodestart6.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) else: if request.method == "POST": v = request.POST.get('number') points = request.POST.get('points') bidded_points = int(bidded.points) newpoints = bidded_points - int(points) if 0: return redirect('https://www.codechef.com/') else: if v == '1': if playstart.last_played > timezone.now() - timedelta( minutes=30): timeremain = timezone.now() - playstart.last_played minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid1: return redirect('https://www.codechef.com/') Sourcecodeanswer = Sourcecode(user=user, question1=points) Sourcecode.objects.filter(user=user).update( question1=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid1=1) return render( request, 'sourcecodestart1.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '2': if playstart.last_played2 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played2 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid2: return redirect('https://www.codechef.com/') Sourcecodeanswer = Sourcecode(user=user, question2=points) Sourcecode.objects.filter(user=user).update( question2=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid2=1) return render( request, 'sourcecodestart2.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '3': if playstart.last_played3 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played3 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid3: return redirect('https://www.codechef.com/') Sourcecodeanswer = Sourcecode(user=user, question3=points) Sourcecode.objects.filter(user=user).update( question3=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid3=1) return render( request, 'sourcecodestart3.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '4': if playstart.last_played4 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played4 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid4: return redirect('https://www.google.com/') Sourcecodeanswer = Sourcecode(user=user, question4=points) Sourcecode.objects.filter(user=user).update( question4=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid4=1) return render( request, 'sourcecodestart4.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '5': if playstart.last_played5 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played5 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid5: return redirect('https://www.google.com/') Sourcecode.objects.filter(user=user).update( question5=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid5=1) return render( request, 'sourcecodestart5.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) elif v == '6': if playstart.last_played6 > timezone.now() - timedelta( minutes=30): timeremain = timezone.now( ) - playstart.last_played6 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) else: minremain = 0 secremain = 0 if bidded.bid6: return redirect('https://www.google.com/') Sourcecode.objects.filter(user=user).update( question6=points) Sourcecode.objects.filter(user=user).update( points=newpoints, bid6=1) return render( request, 'sourcecodestart6.html', { 'minremain': minremain, 'points': bidded.points, 'secremain': secremain, 'start': 1 }) else: return HttpResponse("Not authorised to view the page")
def basic_one(request): view = "basic_one" html = "<html><body>This is %s view</html></body>" % view return HttpResponse(html)
def oleg(request): return HttpResponse("Hello, Oleg")
def export_coupon_excel(request): user = request.user item_list = UserEvent.objects startTime = request.GET.get("startTime", None) endTime = request.GET.get("endTime", None) startTime2 = request.GET.get("startTime2", None) endTime2 = request.GET.get("endTime2", None) state = request.GET.get("state", '1') projecttype = request.GET.get("projecttype", '0') if startTime and endTime: s = datetime.datetime.strptime(startTime, '%Y-%m-%dT%H:%M') e = datetime.datetime.strptime(endTime, '%Y-%m-%dT%H:%M') item_list = item_list.filter(time__range=(s, e)) if startTime2 and endTime2: s = datetime.datetime.strptime(startTime2, '%Y-%m-%dT%H:%M') e = datetime.datetime.strptime(endTime2, '%Y-%m-%dT%H:%M') item_list = item_list.filter(audit_time__range=(s, e)) username = request.GET.get("username", None) if username: item_list = item_list.filter(user__username=username) mobile = request.GET.get("mobile", None) if mobile: item_list = item_list.filter(user__mobile=mobile) mobile_sub = request.GET.get("mobile_sub", None) if mobile_sub: item_list = item_list.filter(invest_account=mobile_sub) companyname = request.GET.get("companyname", None) if companyname: item_list = item_list.filter( coupon__project__provider__contains=companyname) projectname = request.GET.get("projectname", None) if projectname: item_list = item_list.filter( coupon__project__title__contains=projectname) adminname = request.GET.get("adminname", None) if adminname: item_list = item_list.filter(audited_logs__user__username=adminname) if projecttype == '1': item_list = item_list.filter(coupon__project__ctype='0') if projecttype == '2': item_list = item_list.filter(coupon__project__ctype='1') item_list = item_list.filter( event_type='4', audit_state=state).select_related('user').order_by('time') data = [] for con in item_list: coupon = con.content_object id = str(con.id) user_type = u"普通用户" if not con.user.is_channel else u"渠道:" + con.user.channel.level user_mobile = con.user.mobile if not con.user.is_channel else con.user.channel.qq_number time_sub = con.time.strftime("%Y-%m-%d %H:%M") title = coupon.project.title zhifubao = con.user.zhifubao mobile_sub = con.invest_account term = con.invest_term invest_amount = con.invest_amount remark = con.remark result = '' return_amount = '' reason = '' if con.audit_state == '0': result = u'是' if con.translist.exists(): return_amount = str(con.translist.first().transAmount / 100.0) elif con.audit_state == '2': result = u'否' if con.audited_logs.exists(): reason = con.audited_logs.first().reason data.append([ id, user_type, user_mobile, time_sub, title, zhifubao, mobile_sub, term, invest_amount, remark, result, return_amount, reason ]) w = Workbook() #创建一个工作簿 ws = w.add_sheet(u'待审核记录') #创建一个工作表 title_row = [ u'记录ID', u'用户类型', u'挖福利账号', u'提交时间', u'项目名称', u'支付宝', u'注册手机号', u'投资期限', u'投资金额', u'备注', u'审核结果(0通过,1待审核,2拒绝)', u'返现金额', u'拒绝原因' ] for i in range(len(title_row)): ws.write(0, i, title_row[i]) row = len(data) style1 = easyxf(num_format_str='YY/MM/DD') for i in range(row): lis = data[i] col = len(lis) for j in range(col): if j == 3: ws.write(i + 1, j, lis[j], style1) else: ws.write(i + 1, j, lis[j]) sio = StringIO.StringIO() w.save(sio) sio.seek(0) response = HttpResponse(sio.getvalue(), content_type='application/vnd.ms-excel') response['Content-Disposition'] = 'attachment; filename=优惠券待审核记录.xls' response.write(sio.getvalue()) return response
def get(self, request, *args, **kwargs): query = TiempoMuertoEnc.objects.all() wb = Workbook() ws = wb.active ws.tittle = 'Tiempos Muertos' #Establer el nombre del archivo nombre_archivo = "Reporte Tiempos Muertosw.xlsx" ws['B1'].alignment = Alignment(horizontal='left', vertical='center') ws['B1'].border = Border(left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws['B1'].fill = PatternFill(start_color='66FFCC', end_color='66FFCC', fill_type='solid') ws['B1'].font = Font(name='calibri', size=12, bold=True) ws['B1'] = 'Company' ws.merge_cells('B1:F1') ws['B2'].alignment = Alignment(horizontal='left', vertical='center') ws['B2'].border = Border(left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws['B2'].fill = PatternFill(start_color='66FFCC', end_color='66FFCC', fill_type='solid') ws['B2'].font = Font(name='calibri', size=12, bold=True) ws['B2'] = 'Department' ws.merge_cells('B2:F2') ws['B3'].alignment = Alignment(horizontal='left', vertical='center') ws['B3'].border = Border(left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws['B3'].fill = PatternFill(start_color='66FFCC', end_color='66FFCC', fill_type='solid') ws['B3'].font = Font(name='calibri', size=12, bold=True) ws['B3'] = 'Reporte de Tiempos Muertos' ws.merge_cells('B3:F3') ws.row_dimensions[1].height = 20 ws.row_dimensions[2].height = 20 ws.row_dimensions[3].height = 20 ws.column_dimensions['B'].width = 20 ws.column_dimensions['C'].width = 20 ws.column_dimensions['D'].width = 20 ws.column_dimensions['E'].width = 20 ws['B6'].alignment = Alignment(horizontal='center', vertical='center') ws['B6'].border = Border(left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws['B6'].fill = PatternFill(start_color='66CFCC', end_color='66CFCC', fill_type='solid') ws['B6'].font = Font(name='calibri', size=11, bold=True) ws['B6'] = 'Fecha' ws['C6'].alignment = Alignment(horizontal='center', vertical='center') ws['C6'].border = Border(left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws['C6'].fill = PatternFill(start_color='66CFCC', end_color='66CFCC', fill_type='solid') ws['C6'].font = Font(name='calibri', size=11, bold=True) ws['C6'] = 'Planta' controlador = 7 for q in query: ws.cell(row=controlador, column=2).alignment = Alignment(horizontal='center', vertical='center') ws.cell(row=controlador, column=2).border = Border(left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws.cell(row=controlador, column=2).fill = PatternFill(start_color='66CFCC', end_color='66CFCC', fill_type='solid') ws.cell(row=controlador, column=2).font = Font(name='calibri', size=11, bold=True) ws.cell(row=controlador, column=2).value = q.fecha_produccion ws.cell(row=controlador, column=3).alignment = Alignment(horizontal='center', vertical='center') ws.cell(row=controlador, column=3).border = Border(left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws.cell(row=controlador, column=3).fill = PatternFill(start_color='66CFCC', end_color='66CFCC', fill_type='solid') ws.cell(row=controlador, column=3).font = Font(name='calibri', size=11, bold=True) ws.cell(row=controlador, column=3).value = str(q.linea) for det in q.tiempo_muerto: ws.cell(row=controlador, column=4).alignment = Alignment(horizontal='center', vertical='center') ws.cell(row=controlador, column=4).border = Border( left=Side(border_style='thin'), right=Side(border_style='thin'), top=Side(border_style='thin'), bottom=Side(border_style='thin')) ws.cell(row=controlador, column=4).fill = PatternFill(start_color='66CFCC', end_color='66CFCC', fill_type='solid') ws.cell(row=controlador, column=4).font = Font(name='calibri', size=11, bold=True) ws.cell(row=controlador, column=4).value = str(det) #contador+=1 controlador += 1 response = HttpResponse(content_type='application/ms-excel') contenido = "attachment; filename = {0}".format(nombre_archivo) response["Content-Disposition"] = contenido wb.save(response) return response
def status(request): return HttpResponse("ok")
def process(self, request, ids): request.session["mass_action_ids"] = ids return HttpResponse("ok")
def can_view_courses_list(request): if not request.user.is_staff: return None, HttpResponse('Unauthorized', status=401) else: courses = Course.objects.filter(is_draft=False,is_archived=False).order_by('title') return courses, None
def setcookie(request): """设置cookie""" res = HttpResponse() res.set_cookie("ldc","123456") return HttpResponse("Cookie设置成功")
def post1(request): """post获取浏览器提交数据实例""" name = request.POST['name'] hobby = request.POST.getlist('hobby') return HttpResponse(name+hobby[0])
def login1(request): res = HttpResponse() cookie = res.set_cookie("ldc","123456") # cookie1 = res.delete_cookie("ldc") return HttpResponse("aaa")
def get1(request): """get获取浏览器传递的参数""" a = request.GET.get('a') b = request.GET['b'] c = request.GET.get('c') return HttpResponse("get1页面"+"参数a:"+a+"参数b"+b+"参数c"+c)
from django.contrib.staticfiles.urls import staticfiles_urlpatterns from django.http.response import HttpResponse from django.views.static import serve as static_serve # from wiki.compat import include, url from django_nyt.urls import get_pattern as get_notify_pattern from wiki.urls import get_pattern as get_wiki_pattern from django.conf import settings from django.conf.urls import include, url from django.views.generic.base import RedirectView admin.autodiscover() urlpatterns = [ url(r'^admin/clearcache/', include('clearcache.urls')), url(r'^admin/', admin.site.urls), url(r'^robots.txt', lambda _: HttpResponse('User-agent: *\nDisallow: /')), # url(r'^silk/', include('silk.urls', namespace='silk')), url(r'^favicon\.ico$', RedirectView.as_view(url='/media/wiki/images/favicon.ico')), # need this to tell Chrome where to find the favicon. Note that png doesnt work. ] urlpatterns += [ url(r'^notify/', include('django_nyt.urls')), url(r'', include('wiki.urls')), ] handler500 = 'xp.views.server_error' handler404 = 'xp.views.page_not_found'
def get(self, request, *args, **kwargs): if self.request.GET.get(u'hub.verify_token') == SECRET_KEY: return HttpResponse(self.request.GET['hub.challenge']) else: return HttpResponse('Error, invalid token')
def revenue(request): user = request.user frui = fruits.objects.filter(farmer_id=user.id) print(frui) return HttpResponse('<h1>Revenue</h1>')
def approve_course_preference(request): """ Bu view katilimci bir kursa kabul edilip edilmedigini görüntülemesi ve katilimcidan katılıp katılmayacağına dair son bir teyit alınır. :param request: HttpRequest :return: """ message = "" status = "1" data = {"note": "Başvuru Durumunuz"} now = datetime.now() try: data["approve_is_open"] = False trainess_course_records = TrainessCourseRecord.objects.filter(trainess=request.user.userprofile, course__site=request.site) first_start_date_inst, last_end_date_inst = get_approve_first_start_last_end_dates_for_inst(request.site, request.log_extra) if not trainess_course_records: data['note'] = "Henüz herhangi bir kursa başvuru yapmadınız!" elif request.site.application_start_date <= datetime.date(now) < request.site.application_end_date: data['note'] = "Başvurunuz için teşekkürler. Değerlendirme sürecinin başlaması için " \ "tüm başvuruların tamamlanması beklenmektedir." else: recordapprovedbyinst = TrainessCourseRecord.objects.filter(trainess=request.user.userprofile, approved=True, consentemailsent=True, course__site=request.site) if not recordapprovedbyinst: if first_start_date_inst.start_date <= now < last_end_date_inst.end_date: data['note'] = "Başvurular değerlendirilmektedir. En geç %s tarihine kadar sonuçları burada" \ " görebilirsiniz." % last_end_date_inst.end_date.strftime("%d-%m-%Y") elif request.site.event_start_date - 1 > now > last_end_date_inst.end_date: data['note'] = "Kurslara kabul dönemi bitmiş olup başvurularınıza kabul edilmediniz ancak" \ " kurs başlangıç tarihine kadar kabul edilme şansınız hala devam ediyor." \ " Takip etmeye devam edin." elif request.site.event_start_date - 1 <= now: data['note'] = "Başvurularınız kabul edilmemiştir. Bir sonraki etkinlikte görüşmek dileğiyle." else: data["note"] = "Aşağıdaki Kursa Kabul Edildiniz" data['trainess_course_record'] = recordapprovedbyinst[0] if REQUIRE_TRAINESS_APPROVE: recordapprovedbytra = recordapprovedbyinst.filter(trainess_approved=True) if not recordapprovedbytra: tra_approvaldate = ApprovalDate.objects.get(site=request.site, for_trainess=True, preference_order=recordapprovedbyinst[ 0].preference_order) if tra_approvaldate.start_date <= now <= tra_approvaldate.end_date: data['note'] = "Aşağıdaki kursa kabul edildiniz" data["approve_is_open"] = True else: data[ "note"] = "Aşağıdaki kursa kabul edildiniz ancak teyit etmediniz. Kursa katılamazsınız." data["approve_is_open"] = False except Exception as e: log.error('Error on line {}'.format(sys.exc_info()[-1].tb_lineno), extra=request.log_extra) log.error(e.message, extra=request.log_extra) data['note'] = "Hata oluştu" if request.POST: try: log.debug(request.POST.get("courseRecordId"), extra=request.log_extra) if request.POST.get("courseRecordId") and data['trainess_course_record']: data['trainess_course_record'].trainess_approved = True data['trainess_course_record'].save() message = "İşleminiz başarılı bir şekilde gerçekleştirildi" status = "0" log.debug("kursu onayladi " + data['trainess_course_record'].course.name, extra=request.log_extra) except Exception as e: log.error('Error on line {}'.format(sys.exc_info()[-1].tb_lineno), extra=request.log_extra) log.error(e.message, extra=request.log_extra) message = "İşleminiz Sırasında Hata Oluştu" status = "-1" return HttpResponse(json.dumps({'status': status, 'message': message}), content_type="application/json") return render(request, "training/confirm_course_preference.html", data)
# TODO: is this of any use? (yaml inside xml!) if (case.start_log_line is not None and case.end_log_line is not None): logs = read_logs( self.get_object().output_dir, case.start_log_line, case.end_log_line, ) tc.add_error_info("failed", output=logs) elif case.result == TestCase.RESULT_SKIP: tc.add_skipped_info("skipped") cases.append(tc) suites.append(junit_xml.TestSuite(suite.name, test_cases=cases)) data = junit_xml.TestSuite.to_xml_string(suites, encoding="utf-8") response = HttpResponse(data, content_type="application/xml") response["Content-Disposition"] = ("attachment; filename=job_%d.xml" % self.get_object().id) return response @detail_route(methods=["get"], suffix="logs") def logs(self, request, **kwargs): start = safe_str2int(request.query_params.get("start", 0)) end = safe_str2int(request.query_params.get("end", None)) try: data = read_logs(self.get_object().output_dir, start, end) if not data: raise NotFound() response = HttpResponse(data, content_type="application/yaml") response["Content-Disposition"] = ( "attachment; filename=job_%d.yaml" % self.get_object().id)
def post(self, request, *args, **kwargs): # Converts the text payload into a python dictionary incoming_message = json.loads(self.request.body.decode('utf-8')) # Facebook recommends going through every entry since they might send # multiple messages in a single call during high load for entry in incoming_message['entry']: for message in entry['messaging']: # Check to make sure the received call is a message call # This might be delivery, optin, postback for other events if 'message' in message: # Print the message to the terminal recieved_messsage = message['message']['text'] print(recieved_messsage) # ================================== # integrate Wit.ai bot here # ================================== wit_response = client.message(recieved_messsage) pprint(wit_response) characteristics = get_xter(wit_response) #GEt user details fbid = message['sender']['id'] user_details_url = "https://graph.facebook.com/v2.6/{}".format( fbid) user_details_params = { 'fields': 'first_name,last_name,profile_pic', 'access_token': '{}'.format(PAGE_ACCESS_TOKEN) } user_details = requests.get(user_details_url, user_details_params).json() message_to_be_sent = generate_response( characteristics, user_details) print(message_to_be_sent) #print user details pprint(user_details) #Do model actions do_actions(characteristics, user_details, fbid) #Send Message post_facebook_message(fbid, message_to_be_sent) return HttpResponse() # def debugview(request): # present_date_time=datetime.now() # present_date_time_hours=present_date_time-timedelta( # minutes=present_date_time.minute, # seconds=present_date_time.second, # microseconds=present_date_time.microsecond) # all_users=our_user.objects.all() # for user in all_users: # notify_times=user.get_notify_times() # print(present_date_time_hours) # print(notify_times) # if present_date_time_hours in notify_times: # print('Yass!! go ahead and send notificatons') # else: # print('no date_time matches') # return HttpResponse('Hello')
def ueditor_uploadfile(request): """ 上传文件 """ fileObj = request.FILES.get('upfile', None) response = upload_file(fileObj, 'file') return HttpResponse(response)
def get(self, request, *args, **kwargs): if self.request.GET['hub.verify_token'] == '123456789': return HttpResponse(self.request.GET['hub.challenge']) else: return HttpResponse('Error, invalid token')
def report(request): return HttpResponse('test')
def result(request): """ Обработчик результата оплаты """ data = request.POST urlencoded = data.urlencode().replace('&', '\n') # log data Log.objects.create( inv_id=data.get('x_invoice_num'), status=Log.STATUS_MESSAGE, request=urlencoded, ) form = AuthorizeNetResultForm(data) if form.is_valid(): invoice = form.cleaned_data['x_invoice_num'] try: invoice = int(invoice) except (TypeError, ValueError): invoice = None response_code = form.cleaned_data['x_response_code'] if response_code == AuthorizeNetResultForm.RESPONSE_CODE_APPROVED: # ------------------------------ # Approved # ------------------------------ try: authorizenet_success.send( sender=Log, invoice=invoice, request=request, ) except Exception as e: # log exception Log.objects.create(inv_id=invoice, status=Log.STATUS_EXCEPTION, request=urlencoded, message='Signal exception:\n{}: {}'.format( e.__class__.__name__, ', '.join(e.args), )) else: # log success Log.objects.create( inv_id=invoice, status=Log.STATUS_SUCCESS, request=urlencoded, ) else: # ------------------------------ # Declined или Error # ------------------------------ reason = form.cleaned_data['x_response_reason_text'] try: authorizenet_error.send( sender=Log, invoice=invoice, request=request, code=response_code, reason=reason, subreason=form.cleaned_data.get('EXact_Message'), ) except Exception as e: # log exception Log.objects.create(inv_id=invoice, status=Log.STATUS_EXCEPTION, request=urlencoded, message='Signal exception:\n{}: {}'.format( e.__class__.__name__, ', '.join(e.args), )) else: # log fail Log.objects.create( inv_id=invoice, status=Log.STATUS_ERROR, request=urlencoded, message=reason, ) return HttpResponse() else: # log form error Log.objects.create(inv_id=data.get('x_invoice_num'), status=Log.STATUS_ERROR, request=urlencoded, message='Invalid form:\n{}'.format( _log_errors(form.errors), )) return HttpResponse()
def template_two(request): view = "template_two" t = get_template('myview.html') html = t.render({'name': view}) return HttpResponse(html)
def bbs_remove(request,bbs_id): if request.method=='GET': models.BBS.objects.filter(id=bbs_id).delete() return HttpResponse('success') return HttpResponse('error')
def clients_report(request): # OPEN WORKBOOK AND HEADER DETAILS wb = Workbook() ws = wb.active ws['A1'] = f'REPORTE DE CLIENTES - {format_date()}' ws.merge_cells('A1:C1') # HEADERS ws['A2'] = 'ID CLIENTE' ws['B2'] = 'CORPORACIÓN' ws['C2'] = 'RAZÓN SOCIAL' ws['D2'] = 'RFC' ws['E2'] = 'ID AGENTE VENTA' ws['F2'] = 'FECHA ALTA' ws['G2'] = 'ESTATUS' ws['H2'] = 'BASE DE DATOS' # FILTERS FullRange = "A2:" + get_column_letter(ws.max_column) + str(ws.max_row) ws.auto_filter.ref = FullRange # ALIGNMENTS, COLORS AND DIMENSIONS dimensions = [13.71, 23.86, 65, 16.43, 23, 15.43, 11.29, 34] ws.row_dimensions[1].height = 26.25 ws.row_dimensions[2].height = 42.75 ws['A1'].alignment = Alignment(horizontal="center", vertical="center") ws['A1'].font = Font(size="20", color="FF0000") for col in range(8): ws.cell(row=2, column=col + 1).alignment = Alignment(horizontal="center", vertical="center") ws.cell(row=2, column=col + 1).fill = PatternFill(start_color="2F75B5", end_color="2F75B5", fill_type="solid") ws.cell(row=2, column=col + 1).font = Font(size="16", color="FFFFFF") ws.cell(row=2, column=col + 1).border = thin_border # Column size for i, column_width in enumerate(dimensions): ws.column_dimensions[get_column_letter(i + 1)].width = column_width + 1 global query_cache counter = 3 # CREATE EXCEL if len(query_cache) > 0: print("\nCREATING EXCEL\n") for enterprise in query_cache: for data in enterprise: # ID Cliente ws.cell(row=counter, column=1).value = data[2] ws.cell(row=counter, column=1).font = Font(size="12") ws.cell(row=counter, column=1).border = thin_border # Corporación ws.cell(row=counter, column=2).value = data[1] ws.cell(row=counter, column=2).font = Font(size="12") ws.cell(row=counter, column=2).border = thin_border # Razón Social ws.cell(row=counter, column=3).value = data[3] ws.cell(row=counter, column=3).font = Font(size="12") ws.cell(row=counter, column=3).border = thin_border # RFC ws.cell(row=counter, column=4).value = data[4] ws.cell(row=counter, column=4).font = Font(size="12") ws.cell(row=counter, column=4).border = thin_border # ID Agente Venta ws.cell(row=counter, column=5).value = data[7] ws.cell(row=counter, column=5).font = Font(size="12") ws.cell(row=counter, column=5).border = thin_border # Fecha Alta ws.cell(row=counter, column=6).value = str(data[5]).split(' ')[0] ws.cell(row=counter, column=6).font = Font(size="12") ws.cell(row=counter, column=6).border = thin_border # Estatus ws.cell(row=counter, column=7).value = data[6] ws.cell(row=counter, column=7).font = Font(size="12") ws.cell(row=counter, column=7).border = thin_border # Base de datos ws.cell(row=counter, column=8).value = data[0] ws.cell(row=counter, column=8).font = Font(size="12") ws.cell(row=counter, column=8).border = thin_border counter += 1 else: print("\nCACHE EMPTY\n") # FILE DETAILS AND FORMAT filename = 'Reporte_Clientes.xlsx' response = HttpResponse(content_type='application/ms-excel') content = 'attachment; filename = {0}'.format(filename) response['Content-Disposition'] = content wb.save(response) return response
def getchatcontent(request,args=None): return HttpResponse(chatcontent(request))
def sourcecodestart6(request): user = request.user if user.groups.filter(name='sourcecode').exists(): answersAll = Sourcecode.objects.filter(user=user) bid = Sourcecode.objects.filter(user=user)[0] gamestatus = SourcecodeUser.objects.filter(user=user)[0] if bid.clickquestion6 == 0: firstclick = datetime.now() minremain = 00 secremain = 00 Sourcecode.objects.filter(user=user).update(clickquestion6=1) SourcecodeUser.objects.filter(user=user).update( last_played6=firstclick) #if len(answersAll)>0: #return HttpResponseRedirect('/sourcecode/start1') if gamestatus.gameover6 == 1: return HttpResponseRedirect('/sourcecode/done') if len(SourcecodeUser.objects.filter(user=user)) > 0: playstart = SourcecodeUser.objects.filter(user=user)[0] if playstart.last_played6 > timezone.now() - timedelta(minutes=30): timeremain = timezone.now() - playstart.last_played6 minremain = int((timeremain.seconds) / 60) secremain = int((timeremain.seconds) % 60) if (bid.bid6 == 1): return render( request, 'sourcecodestart6.html', { 'minremain': minremain, 'points': bid.points, 'secremain': secremain, 'start': 1 }) else: return render( request, 'sourcecodestart6.html', { 'minremain': minremain, 'points': bid.points, 'secremain': secremain, 'start': 0 }) else: playstart.gameover6 = 1 playstart.save() return HttpResponseRedirect('/sourcecode/success') gamestatus.gameover6 = 1 gamestatus.save() if (bid.bid6 == 1): return render( request, 'sourcecodestart6.html', { 'minremain': minremain, 'points': bid.points, 'secremain': secremain, 'start': 1 }) else: return render( request, 'sourcecodestart6.html', { 'minremain': minremain, 'points': bid.points, 'secremain': secremain, 'start': 0 }) else: return HttpResponse("Not authorised to view the page")
def getonlineusers(request,args=None): return HttpResponse(getonlineuser(request))
def index(request): list = t_api.apiQuery1.all() return HttpResponse("这是首页!%s"%list[0])
def response_authenticate(): """Return 401 response with authenticate header.""" response = HttpResponse(status=401) response['WWW-Authenticate'] = 'Basic realm="Weblate Git access"' return response