source: ecoalba/apps/aranceles/views.py @ 96ed33b

# -*- coding: utf-8 -*-
from django.shortcuts import *
from django.contrib.auth.decorators import login_required
from comun.utilidades import dictfetchall, codigos_armonizados_con_longitud
from comun.constantes import IMPORTACIONES, EXPORTACIONES, \
                            ESTANDAR_CLASIFICACION, \
                            MAXIMO_PRINCIPALES_PRODUCTOS_ORIGEN, \
                            REPORTES_DISPONIBLES, MIL, MILLON
from comun.models import Pais
from django.utils.translation import ugettext_lazy as _l, ugettext as _

import os
import json

def dictfetchall(cursor):
        "Returns all rows from a cursor as a dict"
        desc = cursor.description
        return [
        dict(zip([col[0] for col in desc], row))
        for row in cursor.fetchall()
      ]

def miCursorSql():
        from django.db import  connection
        micuro = connection.cursor()
        micuro.execute("select id,iso3166_2,iso3166_3 from comun_pais where anyo_inclusion is not null")
        return dictfetchall(micuro)
        
def paisesjson(request):
    start = int(request.GET['jtStartIndex'])
    end = int(request.GET['jtStartIndex']) + int(request.GET['jtPageSize'])
    #paises =  Pais.objects.filter(anyo_inclusion__isnull=False)
    
    ttarea = miCursorSql()
    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
    
    return HttpResponse(json.dumps(jsota),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 = paises.split(",")[:-1]
        dpaises = Pais.objects.filter(iso3166_2__in = paises)
        
        return render_to_response('aranceles/aranceles.html', context_instance=RequestContext(request))
        
        
@login_required
def aranceles(request):
    """
    Vista inicial para filtros de aranceles
    """
    
    return render_to_response('aranceles/aranceles.html', context_instance=RequestContext(request))

@login_required
def aranceles_consulta(request):
    """
    Vista inicial para filtros consulta de aranceles
    """
    
    return render_to_response('aranceles/aranceles_consulta.html', context_instance=RequestContext(request))