OK, this is CLOSE and it may even work....maybe someone else can correct
it, because I may have category/product backwards, and I put a filter in
there so you can search for a product by attribute, but you'll have to
tweak it...
category_view.html
{% extends "base.html" %}
{% block content %}
<h3 align="center"> Products in a Category </h3>
<form method="get">
{{ object_list.form.as_p }}
<button type="submit">Search</button>
</form>
{% for object in object_list.qs%}
{% include 'category-inline.html'%}
{% endfor %}
{% endblock %}
category_inline.html
<div class='col-80 col-md-100 mb-1 mx-auto'>
<div class='card'>
<div class='card-body'>
<h5 class = 'card-title'>
<p>{{object.name}}-{{object.slug}}</p>
{% for product in object.category.category.all %}
{{product.name}}--{{product.slug}}--{{product.brand}}--
{{product.available}}{{product.stock}}
{% endfor %}
views.py
from .filters import ProductFilter
def category_view(request):
my_title = "Products"
qs = Category.objects.prefetch_related('category__category')
category_list = ProductFilter(request.GET, queryset=qs)
template_name = 'category_view.html'
context = {'object_list': category_list,"title":my_title}
return render (request, template_name, context)
filters.py
class ProductFilter(django_filters.FilterSet):
category__name =
django_filters.CharFilter(lookup_expr='icontains',label='Product Name
contains')
class Meta:
model = Product
fields = {
}
Charlotte Wood, MEd
Educator
(405) 578-5701
Zoom Meeting ID#: 4055785701
*Zoom URL:* https://epiccharterschools.zoom.us/j/2970513912
Classroom Google Site:
https://sites.google.com/epiccharterschools.org/charlottewoodclassroom/home
Epic Technical Support: (405) 652-0935
Jordan McKesson Principal
405-749-4550 ext. 309
[email protected]
<http://facebook.com/epiccharterschools> <https://twitter.com/epiccharter>
<https://www.instagram.com/epiccharterschools/>
<https://www.youtube.com/user/EpicCharterSchools>
On Wed, Jul 3, 2019 at 6:37 PM Tosin Ayoola <[email protected]> wrote:
> this' my model
> from django.db import models
> from django.shortcuts import reverse
>
> class Category(models.Model):
> name = models.CharField(max_length = 100, db_index = True)
> slug = models.SlugField(max_length = 130, db_index= True, unique = True)
> class Meta:
> db_table = 'categories'
> verbose_name = 'catergories'
>
> def __str__(self):
> return self.name
>
> def get_absolute_url(self):
> return reverse("category-detail", args=[self.slug])
>
> def get_product(self):
> return Product.objects.filter(category= self.name)
>
>
> class Product(models.Model):
> name = models.CharField(max_length = 100, db_index = True)
> slug = models.SlugField(max_length= 100, db_index= True)
> brand = models.CharField(max_length = 100)
> available = models.BooleanField(default= True)
> meta_keywords = models.CharField(max_length = 150, blank = True)
> stock = models.PositiveIntegerField()
> updated = models.DateTimeField(auto_now= True)
> price = models.DecimalField(max_digits = 10, decimal_places = 2, default =
> 0.00)
> image = models.ImageField(upload_to = 'product_imgs', blank = True)
> best_seller = models.BooleanField(default=False)
> category = models.ForeignKey(Category, on_delete = 'MODEL.CASCADE',
> related_name='product')
> description = models.TextField()
> created = models.DateTimeField()
>
> class meta:
> db_name = 'Product'
> ordering = [' -created']
> index_together = (('id', 'slug'),)
>
> def __str__(self):
> return self.name
>
> def get_absolute_url(self):
> return reverse("product-detail", args= [self.slug,
> self.created.year,
> self.created.strftime('%m'),
> self.created.strftime('%d')])
>
> On Thu, Jul 4, 2019 at 12:33 AM Charlotte Wood <
> [email protected]> wrote:
>
>> and, are you using a base.html? and a form.html? then customizing the
>> template for the product_view?
>>
>>
>>
>> Charlotte Wood, MEd
>>
>> Educator
>>
>> (405) 578-5701
>>
>> Zoom Meeting ID#: 4055785701
>>
>> *Zoom URL:* https://epiccharterschools.zoom.us/j/2970513912
>>
>> Classroom Google Site:
>> https://sites.google.com/epiccharterschools.org/charlottewoodclassroom/home
>>
>> Epic Technical Support: (405) 652-0935
>>
>>
>>
>> Jordan McKesson Principal
>>
>> 405-749-4550 ext. 309
>>
>> [email protected]
>>
>> <http://facebook.com/epiccharterschools>
>> <https://twitter.com/epiccharter>
>> <https://www.instagram.com/epiccharterschools/>
>> <https://www.youtube.com/user/EpicCharterSchools>
>>
>>
>>
>>
>> On Wed, Jul 3, 2019 at 6:32 PM Charlotte Wood <
>> [email protected]> wrote:
>>
>>> What is the name of the field in your model? ie: Title, Name, etc....
>>> so one option would be product.title or product.name....
>>>
>>> can you just put your model in here?
>>>
>>>
>>> Charlotte Wood, MEd
>>>
>>> Educator
>>>
>>> (405) 578-5701
>>>
>>> Zoom Meeting ID#: 4055785701
>>>
>>> *Zoom URL:* https://epiccharterschools.zoom.us/j/2970513912
>>>
>>> Classroom Google Site:
>>> https://sites.google.com/epiccharterschools.org/charlottewoodclassroom/home
>>>
>>> Epic Technical Support: (405) 652-0935
>>>
>>>
>>>
>>> Jordan McKesson Principal
>>>
>>> 405-749-4550 ext. 309
>>>
>>> [email protected]
>>>
>>> <http://facebook.com/epiccharterschools>
>>> <https://twitter.com/epiccharter>
>>> <https://www.instagram.com/epiccharterschools/>
>>> <https://www.youtube.com/user/EpicCharterSchools>
>>>
>>>
>>>
>>>
>>> On Wed, Jul 3, 2019 at 6:25 PM Tosin Ayoola <[email protected]>
>>> wrote:
>>>
>>>> Good day guyz
>>>> sorry i'm working on a django e-commerce project which i am new to, and
>>>> i'm stuck, i wan have a page that will display the list of all for the list
>>>> of all products under a particular category, which i have checked out on
>>>> stackoverflow, i tried every suggestion and yet since not working below is
>>>> my code hoping anyone can lead mr in d right direction
>>>>
>>>> ##View
>>>>
>>>> def index(request):
>>>> products = Product.objects.all()
>>>> category = get_list_or_404(Category)
>>>> cat = Category.objects.filter(pk = id)
>>>> return render(request, 'shop/index.html', locals())
>>>>
>>>> ##product_list Page
>>>> <h2>Categories</h2>
>>>> {% if cat %}
>>>> <ul>
>>>> {% for c in cat %}
>>>> <li>
>>>> <a href="{% url 'product-list' %}"> {{c.name}}</a>
>>>> </li>
>>>> {% for product in cat.get_product %}
>>>> <p> {(product.name}}</p>
>>>> {% endfor %}
>>>> {% endfor %}
>>>> </ul>
>>>> {% else %}
>>>> <p> There's no item category yet
>>>> {% endif %}
>>>> </div>
>>>>
>>>>
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Django users" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to [email protected].
>>>> To post to this group, send email to [email protected].
>>>> Visit this group at https://groups.google.com/group/django-users.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/django-users/CAHLKn70PDKYwv30LhTsRaQEJ5V9mwE0xri-EdmwPp8ZoAC5nng%40mail.gmail.com
>>>> <https://groups.google.com/d/msgid/django-users/CAHLKn70PDKYwv30LhTsRaQEJ5V9mwE0xri-EdmwPp8ZoAC5nng%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>>> .
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Django users" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected].
>> To post to this group, send email to [email protected].
>> Visit this group at https://groups.google.com/group/django-users.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/django-users/CAPZR0N4xhpP0JLmFTQn_ogOztTAhj%2BKrP2kF-9DkxXK3NxXq8A%40mail.gmail.com
>> <https://groups.google.com/d/msgid/django-users/CAPZR0N4xhpP0JLmFTQn_ogOztTAhj%2BKrP2kF-9DkxXK3NxXq8A%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To post to this group, send email to [email protected].
> Visit this group at https://groups.google.com/group/django-users.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAHLKn70XcOkAWT-%2BgBpG-m6Agh65AVXfU%3DsErY8iSvUF9Y0iaA%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAHLKn70XcOkAWT-%2BgBpG-m6Agh65AVXfU%3DsErY8iSvUF9Y0iaA%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAPZR0N6s5WGH6KPU3mt7QnH%2B2QsC0t1CsaZHixXt%2B1ifzW2d2A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
