+

+

+app_name = 'cms'

+from .models import SearchData

+

+

+@admin.register(SearchData)

+class SearchDataAdmin(admin.ModelAdmin):

+    list_display = ["q", "product_type",  "content_cat",   "created_at", "created_by"]

+from django.forms.models import inlineformset_factory, modelform_factory, modelformset_factory

+from django import forms

+from .models import SearchData

+from django.forms import ModelForm

+from django_google_maps import widgets as map_widgets

+from django_google_maps import fields as map_fields

+

+import django_filters

+

+

+GeneralWidgets = {

+    'startDate': forms.DateInput(format="%d/%m/%Y",attrs={'type': 'text', 'class': 'datepicker'}),

+    'address': map_widgets.GoogleMapsAddressWidget,

+    'photo': forms.FileInput,

+    'sub_total':  forms.TextInput(attrs={'readonly': 'readonly'}),

+    'vat': forms.TextInput(attrs={'readonly': 'readonly'}),

+    'total': forms.TextInput(attrs={'readonly': 'readonly'}),

+

+}

+

+SearchForm = modelform_factory(

+    SearchData,

+    fields="__all__",

+    widgets = GeneralWidgets,

+    )

+# Generated by Django 3.2.6 on 2021-08-21 12:51

+

+from django.conf import settings

+from django.db import migrations, models

+import django.db.models.deletion

+import mptt.fields

+

+

+class Migration(migrations.Migration):

+

+    initial = True

+

+    dependencies = [

+        ('fruit', '0031_auto_20210816_1519'),

+        migrations.swappable_dependency(settings.AUTH_USER_MODEL),

+        ('cms', '0015_alter_post_cat'),

+    ]

+

+    operations = [

+        migrations.CreateModel(

+            name='SearchData',

+            fields=[

+                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),

+                ('created_at', models.DateTimeField(auto_now_add=True, null=True)),

+                ('updated_at', models.DateTimeField(auto_now=True)),

+                ('q', models.CharField(max_length=200)),

+                ('content_cat', mptt.fields.TreeForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='cms.postcat')),

+                ('created_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='searchdata_created', to=settings.AUTH_USER_MODEL)),

+                ('modified_by', models.ForeignKey(editable=False, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='searchdata_modified', to=settings.AUTH_USER_MODEL)),

+                ('product_type', mptt.fields.TreeForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='fruit.producttype')),

+            ],

+            options={

+                'abstract': False,

+            },

+        ),

+    ]

+# Generated by Django 3.2.6 on 2021-08-21 15:17

+

+from django.db import migrations, models

+import django.db.models.deletion

+import mptt.fields

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('fruit', '0031_auto_20210816_1519'),

+        ('cms', '0015_alter_post_cat'),

+        ('front', '0001_initial'),

+    ]

+

+    operations = [

+        migrations.AlterField(

+            model_name='searchdata',

+            name='content_cat',

+            field=mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='cms.postcat'),

+        ),

+        migrations.AlterField(

+            model_name='searchdata',

+            name='product_type',

+            field=mptt.fields.TreeForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='fruit.producttype'),

+        ),

+        migrations.AlterField(

+            model_name='searchdata',

+            name='q',

+            field=models.CharField(blank=True, default='', max_length=200),

+        ),

+    ]

+from smart_selects.db_fields import (

+    ChainedForeignKey,

+    ChainedManyToManyField,

+    GroupedForeignKey,

+)

+from django.contrib.auth.models import User

+from mptt.models import MPTTModel, TreeForeignKey

+from cms.models import PostCat, Post

+from fruit.models import  Product, ProductType

+

+class GenericModel(models.Model):

+    created_at = models.DateTimeField(auto_now_add=True, null=True)

+    updated_at = models.DateTimeField(auto_now=True)

+

+    created_by = models.ForeignKey(User, null=True, editable=False, related_name='%(class)s_created', on_delete=models.SET_NULL)

+    modified_by = models.ForeignKey(User, null=True, editable=False, related_name='%(class)s_modified', on_delete=models.SET_NULL)

+

+    class Meta:

+        abstract = True

+

+

+

+class SearchData(GenericModel, models.Model):

+    q = models.CharField(max_length=200, blank=True, default="")

+    product_type = TreeForeignKey(ProductType, on_delete=models.SET_NULL, null=True, blank=True)

+    content_cat = TreeForeignKey(PostCat, on_delete=models.SET_NULL, null=True, blank=True)

+.top-image {

+    height: 200px;

+    object-fit: contain;

+    width: 100%;

+    background-color: #888;

+}

+            <a class="text-muted" href="{% url "front:search" %}">

+        <a class="p-2 text-muted" href="{% url "front:stores" %}">Store</a>

+<hr>

+

+{% extends "front/base.html" %}

+

+{% load static %}

+{% load crispy_forms_tags %}

+

+{% block header %}            

+{{ form.media  }}

+{% endblock %}

+

+{% block top_slide %}

+{% endblock %}

+{% block content %}

+<h1>Search</h1>

+<div class='row'>

+    <div class="col-md-9">

+        <form>

+            {% csrf_token %}

+            <div class='row'>

+                <div class="col-md-4">{{ form.q| as_crispy_field }}</div>

+                <div class="col-md-4">{{ form.product_type | as_crispy_field }}</div>

+                <div class="col-md-4">{{ form.content_cat | as_crispy_field }}</div>

+            </div>

+            <br>

+            <input type='submit' class='btn btn-primary' value="Search" />

+        </form>

+        {{ results }}

+    </div>

+    <div class="col-md-3">

+        Recom

+    </div>

+</div>

+{% endblock %}

+

+

+{% extends "front/base.html" %}

+

+{% load static %}

+{% block top_slide %}

+{% endblock %}

+{% block content %}

+<h1>Top Stores</h1>

+<div class='row'>

+

+{% for s in top_stores %}

+<div class="col-md-3">

+    <img src="{{ s.feature_image.url }}" class="img-fluid top-image" />

+    <a href="{% url  "cms:view_post" post_id=s.id %}">{{ s.title }}</a>

+</div>

+{% endfor %}

+</div>

+{% for s in top_stores %}

+{% endfor %}

+{% endblock %}

+

+

+    path('stores', views.stores, name='stores'),

+    path('search', views.search, name='search'),

+from cms.models import Post

+from fruit.models import Product

+from .forms import SearchForm

+from itertools import chain, tee

+from operator import attrgetter

+from django.db.models import Q

+def stores(request):

+    top_stores = Post.objects.filter(cat__name="Top Stores", status="publish").order_by("-created_at")

+    return render(request, "front/stores.html", {'top_stores': top_stores})

+

+def search(request):

+    form = SearchForm(request.GET)

+

+    results = None

+    if form.is_valid():

+        o = form.save(commit = False)

+        o.created_by = request.user

+        o.save()

+

+        q = Q()

+        q2 = Q()

+        if o.content_cat != None:

+            q = q & Q(cat = o.content_cat)

+

+        if o.product_type != None:

+            q2 = q2 & Q(product_type = o.product_type)

+

+        q = q & ( Q(title__contains = o.q ) | Q(body__contains = o.q))

+        q2 = q2 & ( Q(name__contains = o.q ) | Q(description__contains = o.q))

+

+        r1 = Post.objects.filter(q)

+        r2 = Product.objects.filter(q2)

+        results = list(sorted(chain(r1, r2), key = lambda obj: obj.created_at, reverse = True))

+

+    return render(request, "front/search.html", {'form': form, 'results': results})