from django.db import models
from django.contrib.auth.models import User
from django.http import *
from django.shortcuts import *

from django.core.context_processors import csrf
from django.views.decorators.csrf import csrf_exempt

import json

from Directorio.models import cat_persona

from django.db.models import Q


@csrf_exempt
def ajaxautocompletable(request):	
	if request.is_ajax():
		# recuperamos el campo
		q = request.GET.get('term', '').lower()

		# cosultamos 
		drugs = cat_persona.objects.distinct('nombre','apellido_paterno','apellido_materno').extra(where=[" LOWER((trim(nombre) || ' ' || trim(apellido_paterno) || ' ' || trim(apellido_materno))) like %s "], params=['%'+q+'%'])
		results = []
	        for drug in drugs:
        	    drug_json = {}
	            drug_json['id'] = drug.id
        	    drug_json['label'] = drug.nombre+' '+drug.apellido_paterno+' '+drug.apellido_materno
	            drug_json['value'] = drug.nombre+' '+drug.apellido_paterno+' '+drug.apellido_materno
        	    results.append(drug_json)
	        data = json.dumps(results)
	else:
		 data = 'fail'
	mimetype = 'application/json'
	return HttpResponse(data, mimetype)