Changeset f8f2094 in ecoalba for apps/aranceles/views.py

Timestamp:

Jan 25, 2016, 5:06:52 PM (8 years ago)

Author:

eparedes <eparedes@…>

Branches:

master

Children:

8c55734

Parents:

c7b411c

Message:

funcionalidad aranceles

File:

• apps/aranceles/views.py (modified) (4 diffs)

apps/aranceles/views.py

@@ -9 +9 @@
 from comun.models import Pais
 from django.utils.translation import ugettext_lazy as _l, ugettext as _
+from aranceles.models import consolidados
 
 import os
@@ -25 +26 @@
         micuro = connection.cursor()
         micuro.execute("select id,iso3166_2,iso3166_3 from comun_pais where anyo_inclusion is not null")
+        return dictfetchall(micuro)
+
+def miCursorSql2():
+        from django.db import  connection
+        micuro = connection.cursor()
+        micuro.execute("select * from aranceles_consolidados")
         return dictfetchall(micuro)
         
@@ -53 +60 @@
     
     return HttpResponse(json.dumps(jsota),content_type="application/json")
+
+from decimal import Decimal
+
+class fakefloat(float):
+    def __init__(self, value):
+        self._value = value
+    def __repr__(self):
+        return str(self._value)
+
+def defaultencode(o):
+    if isinstance(o, Decimal):
+        # Subclass float with custom repr?
+        return fakefloat(o)
+    raise TypeError(repr(o) + " is not JSON serializable")
+
+
+def consolidadosjson(request):
+    start = int(request.GET['jtStartIndex'])
+    end = int(request.GET['jtStartIndex']) + int(request.GET['jtPageSize'])
+    idpaises = [1]
+#    ttarea = consolidados.objects.filter(pais__in =  idpaises)
+ 
+    ttarea = miCursorSql2()
+
+#    for row in ttarea:
+#       row['iso3166_3']=_(row['iso3166_3'])
+        
+    cuantos = ttarea.__len__()
+
+    ltarea = ttarea[start:end]
+    
+    jsota = {}
+    registros = []
+    if (cuantos/10>1):
+        proximo = True
+    else: 
+        proximo = None
+    
+    jsota["meta"]= {"limit": 10, "next": proximo, "offset": 0, "previous": None, "total_count": cuantos}
+    jsota["Result"]= "OK"
+    jsota["TotalRecordCount"] = cuantos
+    
+    
+    jsota["Records"]=ltarea
+    print jsota
+    return HttpResponse(json.dumps(jsota, default=defaultencode),content_type="application/json")
     
 
 def codigos_arancelarios(request):
-        paises = request.POST['paises']
-        if paises == '':
-                return render_to_response('aranceles/aranceles_consulta.html', context_instance=RequestContext(request))
+    paises = request.POST['paises']
+    if paises == '':          
+        return render_to_response('aranceles/aranceles_consulta.html', context_instance=RequestContext(request))
                 
-        paises = paises.split(",")[:-1]
-        dpaises = Pais.objects.filter(iso3166_2__in = paises)
-        
-        return render_to_response('aranceles/aranceles.html', context_instance=RequestContext(request))
+    paises = paises.split(",")[:-1]
+    dpaises = Pais.objects.filter(iso3166_2__in = paises)
+    idpaises = [e.id for e in dpaises]
+    return render_to_response('aranceles/aranceles.html', context_instance=RequestContext(request))
         
         
@@ -81 +134 @@
     
     return render_to_response('aranceles/aranceles_consulta.html', context_instance=RequestContext(request))
+
+@login_required
+def aranceles_resultados(request):
+    """
+    Vista inicial para filtros consulta de aranceles
+    """
+    
+    return render_to_response('aranceles/aranceles_resultados.html', context_instance=RequestContext(request))