Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from django.shortcuts import render
- from sqlalchemy import create_engine
- import pandas as ps
- from xml.etree import ElementTree as et
- def tabla(request):
- lista = ['Sub Estado','Grupo Resolutor ','Bandeja Resolutor']
- engine = create_engine('postgresql://postgres:alphabeta@localhost:5432/escaladas')
- t='escalado 07/2017'
- sqltable = ps.read_sql_table(t,engine,columns=lista)
- sqltable.columns = sqltable.columns.str.replace(' ', '_')
- sqltable.columns = sqltable.columns.str.replace('*', '')
- sqltable.columns = sqltable.columns.str.replace('+', '')
- sqltable.columns = sqltable.columns.str.replace('?', '')
- sqltable.columns = sqltable.columns.str.replace('-', '')
- sqltable.columns = sqltable.columns.str.replace('/', '_')
- sqltable.columns = sqltable.columns.str.replace('.', '')
- print(sqltable.info(memory_usage='deep'))
- sqltable = sqltable.groupby([ 'Grupo_Resolutor_','Bandeja_Resolutor', 'Sub_Estado']).size().to_frame()
- table = et.fromstring(sqltable.to_html(classes="highchart"))
- table.set('data-graph-container-before', '1')
- table.set('data-graph-type', 'column')
- et.tostring(table)
- return render(request,'escalamiento.html',{'table':et.tostring(table)})
- #!python
- # log/urls.py
- from django.conf.urls import url, include
- from . import views
- from escaladas.views import tabla
- import escaladas
- # We are adding a URL called /home
- urlpatterns = [
- url(r'^$', views.home, name='home'),
- url(r'^resolutividad/', views.resolutividad, name='resolutividad'),
- url(r'^reincidencias/', views.reincidencias, name='reincidencias'),
- url(r'^malescalado/', views.malescalado, name='malescalado'),
- url(r'^noprocede/', views.noprocede, name='noprocede'),
- url(r'^escalamiento/', tabla, name='escalamiento'),
- Codigo HTML que usa esa pagina
- <div class="jumbotron" style='margin:0px 0px 0px -45px' >
- Escalamiento
- <div class="col-lg-12">
- <div class="panel panel-default" style='margin:48px -76px 0px -76px'>
- <div class="panel-heading">
- Tabla
- </div>
- <!-- /.panel-heading -->
- <div class="panel-body">
- <div class="flot-chart">
- <form>{{table|safe}}</form>
- <div id="my-chart"></div>
- </div>
- </div>
- <!-- /.panel-body -->
- </div>
- </div>
- </div>
- <link href="{% static 'highcharts/highcharts.css' %}" rel="stylesheet"
- type="text/css">
- <script src="{% static 'highcharts/jquery.highchartTable.js' %}"></script>
- <script src="{% static 'highcharts/highcharts.js' %}"></script>
- <script src="{% static 'highcharts/exporting.js' %}"></script>
- <script>
- $(document).ready(function()
- {
- $('table.highchart').highchartTable();
- });
- </script>
Add Comment
Please, Sign In to add comment