Guest User

Untitled

a guest
Oct 20th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.93 KB | None | 0 0
  1. from django.shortcuts import render
  2. from sqlalchemy import create_engine
  3. import pandas as ps
  4. from xml.etree import ElementTree as et
  5.  
  6.  
  7. def tabla(request):
  8. lista = ['Sub Estado','Grupo Resolutor ','Bandeja Resolutor']
  9. engine = create_engine('postgresql://postgres:alphabeta@localhost:5432/escaladas')
  10. t='escalado 07/2017'
  11. sqltable = ps.read_sql_table(t,engine,columns=lista)
  12. sqltable.columns = sqltable.columns.str.replace(' ', '_')
  13. sqltable.columns = sqltable.columns.str.replace('*', '')
  14. sqltable.columns = sqltable.columns.str.replace('+', '')
  15. sqltable.columns = sqltable.columns.str.replace('?', '')
  16. sqltable.columns = sqltable.columns.str.replace('-', '')
  17. sqltable.columns = sqltable.columns.str.replace('/', '_')
  18. sqltable.columns = sqltable.columns.str.replace('.', '')
  19. print(sqltable.info(memory_usage='deep'))
  20. sqltable = sqltable.groupby([ 'Grupo_Resolutor_','Bandeja_Resolutor', 'Sub_Estado']).size().to_frame()
  21. table = et.fromstring(sqltable.to_html(classes="highchart"))
  22. table.set('data-graph-container-before', '1')
  23. table.set('data-graph-type', 'column')
  24. et.tostring(table)
  25. return render(request,'escalamiento.html',{'table':et.tostring(table)})
  26.  
  27. #!python
  28. # log/urls.py
  29. from django.conf.urls import url, include
  30. from . import views
  31. from escaladas.views import tabla
  32. import escaladas
  33.  
  34. # We are adding a URL called /home
  35. urlpatterns = [
  36. url(r'^$', views.home, name='home'),
  37. url(r'^resolutividad/', views.resolutividad, name='resolutividad'),
  38. url(r'^reincidencias/', views.reincidencias, name='reincidencias'),
  39. url(r'^malescalado/', views.malescalado, name='malescalado'),
  40. url(r'^noprocede/', views.noprocede, name='noprocede'),
  41. url(r'^escalamiento/', tabla, name='escalamiento'),
  42.  
  43. Codigo HTML que usa esa pagina
  44.  
  45. <div class="jumbotron" style='margin:0px 0px 0px -45px' >
  46. Escalamiento
  47.  
  48. <div class="col-lg-12">
  49. <div class="panel panel-default" style='margin:48px -76px 0px -76px'>
  50. <div class="panel-heading">
  51. Tabla
  52.  
  53. </div>
  54. <!-- /.panel-heading -->
  55. <div class="panel-body">
  56. <div class="flot-chart">
  57. <form>{{table|safe}}</form>
  58. <div id="my-chart"></div>
  59.  
  60. </div>
  61. </div>
  62. <!-- /.panel-body -->
  63. </div>
  64. </div>
  65. </div>
  66.  
  67. <link href="{% static 'highcharts/highcharts.css' %}" rel="stylesheet"
  68. type="text/css">
  69. <script src="{% static 'highcharts/jquery.highchartTable.js' %}"></script>
  70. <script src="{% static 'highcharts/highcharts.js' %}"></script>
  71. <script src="{% static 'highcharts/exporting.js' %}"></script>
  72.  
  73.  
  74. <script>
  75. $(document).ready(function()
  76. {
  77. $('table.highchart').highchartTable();
  78. });
  79.  
  80. </script>
Add Comment
Please, Sign In to add comment