Changeset e29b474 in observatorio
- Timestamp:
- Jul 25, 2014, 1:49:57 PM (10 years ago)
- Branches:
- master
- Children:
- 8b1bc0a
- Parents:
- 99ea6e7
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
procesos/apps/sigesic/unidadecon/identifica/api.py
r4437adc re29b474 10 10 from django.db.models import Q 11 11 12 try: 13 from django.utils import simplejson 14 except ImportError: 15 import json as simplejson 12 import json 13 16 14 17 15 class UERecurso(ModelResource): … … 20 18 resource_name = 'unidades' 21 19 include_resource_uri = False 22 fields = ['rif', 'id','nombre','razon_social','ciudad']20 fields = ['rif', 'id', 'nombre', 'razon_social', 'ciudad'] 23 21 cache = SimpleCache(timeout=10) 24 22 default_format = "application/json" 25 authorization = Authorization()23 authorization = Authorization() 26 24 limit = 20 27 # serializer = Serializer()28 25 # serializer = Serializer() 26 29 27 def alter_list_data_to_serialize(self, request, data): 30 28 data['Result'] = "OK" 31 29 data["Records"] = data["objects"] 32 30 busca = request.GET['busca'] 33 seleccion = request.GET['seleccion'] 31 seleccion = request.GET['seleccion'] 34 32 q = '' 35 if busca != "":36 if seleccion=='1':37 38 39 if seleccion=='2':40 41 42 33 if busca != "": 34 if seleccion == '1': 35 q = Q(rif__startswith=busca.upper()) 36 else: 37 if seleccion == '2': 38 q = Q(nombre__contains=busca.upper()) 39 else: 40 q = Q(razon_social__contains=busca.upper()) 43 41 44 if q == '':45 data["TotalRecordCount"] = 42 if q == '': 43 data["TotalRecordCount"] = Unidad_Economica.objects.using('sigesic').all().__len__() 46 44 else: 47 data["TotalRecordCount"] = 45 data["TotalRecordCount"] = Unidad_Economica.objects.using('sigesic').filter(q).__len__() 48 46 del data["objects"] 49 47 return data 50 48 51 49 52 50 def get_object_list(self, request): … … 56 54 seleccion = request.GET['seleccion'] 57 55 q = '' 58 if busca != "":59 if seleccion=='1':60 61 62 if seleccion=='2':63 64 65 56 if busca != "": 57 if seleccion == '1': 58 q = Q(rif__startswith=busca.upper()) 59 else: 60 if seleccion == '2': 61 q = Q(nombre__contains=busca.upper()) 62 else: 63 q = Q(razon_social__contains=busca.upper()) 66 64 67 if request.GET.get('jtSorting') is None 68 if q == '':69 data =Unidad_Economica.objects.using('sigesic').all()[start:end]65 if request.GET.get('jtSorting') is None: 66 if q == '': 67 data = Unidad_Economica.objects.using('sigesic').all()[start:end] 70 68 else: 71 data =Unidad_Economica.objects.using('sigesic').filter(q)[start:end]69 data = Unidad_Economica.objects.using('sigesic').filter(q)[start:end] 72 70 else: 73 71 jtSorting = str(request.GET['jtSorting']) … … 75 73 if word[1] == "DESC": 76 74 if q == '': 77 data =Unidad_Economica.objects.using('sigesic').all().order_by('-' + word[0])[start:end]75 data = Unidad_Economica.objects.using('sigesic').all().order_by('-' + word[0])[start:end] 78 76 else: 79 data =Unidad_Economica.objects.using('sigesic').filter(q).order_by('-' + word[0])[start:end]77 data = Unidad_Economica.objects.using('sigesic').filter(q).order_by('-' + word[0])[start:end] 80 78 else: 81 if q == '':82 data = Unidad_Economica.objects.using('sigesic').all().order_by(word[0])[start:end]79 if q == '': 80 data = Unidad_Economica.objects.using('sigesic').all().order_by(word[0])[start:end] 83 81 else: 84 82 data = Unidad_Economica.objects.using('sigesic').filter(q).order_by(word[0])[start:end] 85 83 86 84 return data 87 85 86 88 87 class JsonResponse(HttpResponse): 89 88 def __init__(self, data): 90 content = simplejson.dumps(data,89 content = json.dumps(data, 91 90 indent=2, 92 91 ensure_ascii=False)
Note: See TracChangeset
for help on using the changeset viewer.