def get(self, request):
# Search
strval = request.GET.get("search", False)
if strval:
# Simple title-only search
# objects = Post.objects.filter(title__contains=strval).select_related().order_by('-updated_at')[:10]
# Multi-field search
# __icontains for case-insensitive search
query = Q(title__icontains=strval)
query.add(Q(text__icontains=strval), Q.OR)
objects = Ad.objects.filter(query).select_related().order_by(
'-updated_at')[:10]
else:
objects = Ad.objects.all().order_by('-updated_at')[:10]
# Augment the post_list
for obj in objects:
obj.natural_updated = naturaltime(obj.updated_at)
ad_list = objects # Old: ad_list = Ad.objects.all()
favorites = list()
if request.user.is_authenticated:
# rows = [{'id': 2}, {'id': 4} ... ] (A list of rows)
rows = request.user.favorite_ads.values('id')
# favorites = [2, 4, ...] using list comprehension
favorites = [row['id'] for row in rows]
ctx = {'ad_list': ad_list, 'favorites': favorites, 'search': strval}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
def get(self, request):
# ad_list = Ad.objects.all() --> no longer used in version 4.0
strval = request.GET.get("search", False)
if strval:
# Simple title-only search
# objects = Post.objects.filter(title__contains=strval).select_related().order_by('-updated_at')[:10]
# Multi-field search
query = Q(title__contains=strval)
query.add(Q(text__contains=strval), Q.OR)
objects = Ad.objects.filter(query).select_related().order_by(
'-updated_at')[:10]
else:
# try both versions with > 4 posts and watch the queries that happen
objects = Ad.objects.all().order_by('-updated_at')[:10]
# objects = Post.objects.select_related().all().order_by('-updated_at')[:10]
# Augment the ad_list
for obj in objects:
obj.natural_updated = naturaltime(obj.updated_at)
favorites = list()
if request.user.is_authenticated:
# rows = [{'id': 2}, {'id': 4} ... ] (A list of rows)
rows = request.user.favorite_ads.values('id')
# favorites = [2, 4, ...] using list comprehension
favorites = [row['id'] for row in rows]
ctx = {'ad_list': objects, 'search': strval, 'favorites': favorites}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
def get(self, request):
strval = request.GET.get("search", False)
if strval:
# Simple title-only search
# objects = Post.objects.filter(title__contains=strval).select_related().order_by('-updated_at')[:10]
# Multi-field search
query = Q(title__contains=strval)
query.add(Q(text__contains=strval), Q.OR)
objects = Ad.objects.filter(query).select_related().order_by(
'-updated_at')[:10]
else:
# try both versions with > 4 posts and watch the queries that happen
objects = Ad.objects.all().order_by('-updated_at')[:10]
# objects = Post.objects.select_related().all().order_by('-updated_at')[:10]
# Augment the post_list
for obj in objects:
obj.natural_updated = naturaltime(obj.updated_at)
ctx = {'ad_list': objects, 'search': strval}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
def get(self, request):
strval = request.GET.get("search", False)
ad_list = Ad.objects.all()
favorites = list()
if request.user.is_authenticated:
rows = request.user.favorite_ads.values('id')
favorites = [row['id'] for row in rows]
if strval:
#For simple title-only search
#objects = Post.objects.filter(title_contains=strval).select_related().order_by('-updated_at')[:10]
#For multi-field search
query = Q(title__contains=strval)
query.add(Q(text__contains=strval), Q.OR)
objects = Ad.objects.filter(query).select_related().order_by(
'-updated_at')[:10]
else:
objects = Ad.objects.all().order_by('-updated_at')[:10]
#objects = Post.objects.select_related().all().order_by('-updated_at').[:10]
for obj in objects:
obj.natural_updated = naturaltime(obj.updated_at)
ctx = {'ad_list': objects, 'search': strval, 'favorites': favorites}
retval = render(request, 'ads/ad_list.html', ctx)
dump_queries()
return retval
def get(self, request) :
favorites = list()
#ad_list = Ad.objects.all()
#Nuevo
strval = request.GET.get("search", False)
if strval :
query = Q(title__contains=strval)
query.add(Q(text__contains=strval), Q.OR)
ad_list = Ad.objects.filter(query).select_related().order_by('-updated_at')[:10]
#rows = request.user.favorite_ads.values('id')
#favorites = [ row['id'] for row in rows ]
#
else:
ad_list = Ad.objects.all().order_by('-updated_at')[:10]
#rows = request.user.favorite_ads.values('id')
#favorites = [ row['id'] for row in rows ]
#Antiguo
"""if request.user.is_authenticated:
# rows = [{'id': 2}, {'id': 4} ... ] (A list of rows)
rows = request.user.favorite_ads.values('id')
# favorites = [2, 4, ...] using list comprehension
favorites = [ row['id'] for row in rows ]"""
#Antiguo
for obj in ad_list:
obj.natural_updated = naturaltime(obj.updated_at)
ctx = {'ad_list' : ad_list, 'favorites': favorites}
retval=render(request, self.template_name, ctx)
dump_queries()
return retval;
def get(self, request):
strval = request.GET.get("search", False)
ad_list = list()
favorites = list()
if strval:
query = Q(title__icontains=strval)
query.add(Q(text__icontains=strval), Q.OR)
ad_list = Ad.objects.filter(query).select_related().order_by(
'-updated_at')[:10]
else:
ad_list = Ad.objects.all()
for ad in ad_list:
ad.natural_updated = naturaltime(ad.updated_at)
if request.user.is_authenticated:
rows = request.user.favorite_ads.values('id')
fav_ids = [row['id'] for row in rows]
favorites = [Ad.objects.get(pk=fav_id) for fav_id in fav_ids]
ctx = {
'ad_list': ad_list,
'favorites': favorites,
'fav_ids': fav_ids,
'search': strval
}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
def get(self, request):
strval = request.GET.get("search", False)
if strval:
query = Q(nombre_producto_control__icontains=strval) | Q(
ICA__icontains=strval)
productocontrolplaga_list = ProductoControlPlaga.objects.filter(
query).select_related()
else:
productocontrolplaga_list = ProductoControlPlaga.objects.all()
ctx = {'productocontrolplaga_list': productocontrolplaga_list}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
def get(self, request):
strval = request.GET.get("search", False)
if strval:
query = Q(IdAs__nombre_vivero__icontains=strval) | Q(
producto_hongo__nombre_producto_control__icontains=strval) | Q(
producto_plaga__nombre_producto_control__icontains=strval
) | Q(producto_fertilizante__nombre_producto_control__icontains
=strval)
labor_list = Labor.objects.filter(query).select_related()
else:
labor_list = Labor.objects.all() #.order_by('-fecha')[:10]
ctx = {'labor_list': labor_list}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
def get(self, request):
strval = request.GET.get("search", False)
if strval:
query = Q(cedula__icontains=strval) | Q(
nombre_1__icontains=strval) | Q(
nombre_2__icontains=strval) | Q(
apellido_1__icontains=strval) | Q(
apellido_2__icontains=strval) | Q(
correo__icontains=strval)
productor_list = Productor.objects.filter(
query).select_related() #.values_list()
#resp = exporte_productores_csv(query)
else:
productor_list = Productor.objects.all()
ctx = {'productor_list': productor_list}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval #resp
def get(self, request):
strval = request.GET.get("search", False)
if strval:
query = Q(IdAs__icontains=strval) | Q(
nombre_vivero__icontains=strval
) | Q(municipio__icontains=strval) | Q(
departamento__icontains=strval
) | Q(planta__icontains=strval) | Q(
productor__nombre_1__icontains=strval) | Q(
productor__nombre_2__icontains=strval) | Q(
productor__apellido_1__icontains=strval) | Q(
productor__apellido_2__icontains=strval) | Q(
productor__correo__icontains=strval)
vivero_list = Vivero.objects.filter(query).select_related()
else:
vivero_list = Vivero.objects.all()
ctx = {'vivero_list': vivero_list}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
def get(self, request):
ad_list = Ad.objects.all()
favorites = list()
strval = request.GET.get("search", False)
if request.user.is_authenticated:
rows = request.user.favorite_ads.values('id')
favorites = [row['id'] for row in rows]
if strval:
query = Q(title__contains=strval)
query.add(Q(text__contains=strval), Q.OR)
objects = Ad.objects.filter(query).select_related().order_by(
'-updated_at')[:10]
else:
objects = Ad.objects.all().order_by('-updated_at')[:10]
for obj in objects:
obj.natural_updated = naturaltime(obj.updated_at)
ctx = {'ad_list': objects, 'favorites': favorites, 'search': strval}
retval = render(request, self.template_name, ctx)
dump_queries()
return retval
