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