+# Generated by Django 3.2.6 on 2021-08-09 14:23

+

+from django.db import migrations

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('fruit', '0025_vendorproduct'),

+    ]

+

+    operations = [

+        migrations.RemoveField(

+            model_name='vendor',

+            name='products',

+        ),

+    ]

+# Generated by Django 3.2.6 on 2021-08-09 14:29

+

+from django.db import migrations, models

+import django.db.models.deletion

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('fruit', '0026_remove_vendor_products'),

+    ]

+

+    operations = [

+        migrations.AlterField(

+            model_name='inbox',

+            name='product',

+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='fruit.product'),

+        ),

+        migrations.AlterField(

+            model_name='inbox',

+            name='store',

+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='fruit.store'),

+        ),

+    ]

+# Generated by Django 3.2.6 on 2021-08-09 14:30

+

+from django.db import migrations, models

+import django.db.models.deletion

+

+

+class Migration(migrations.Migration):

+

+    dependencies = [

+        ('fruit', '0027_auto_20210809_2129'),

+    ]

+

+    operations = [

+        migrations.AlterField(

+            model_name='inbox',

+            name='buyer',

+            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='fruit.buyer'),

+        ),

+        migrations.AlterField(

+            model_name='inbox',

+            name='product',

+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='fruit.product'),

+        ),

+        migrations.AlterField(

+            model_name='inbox',

+            name='store',

+            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, to='fruit.store'),

+        ),

+    ]

+    store = models.ForeignKey('Store', on_delete=models.SET_NULL, null=True, blank=False)

+    product = models.ForeignKey('Product', on_delete=models.SET_NULL, null=True, blank=False)

+    buyer = models.ForeignKey('Buyer', on_delete=models.SET_NULL, null=True, blank=True)

+    store = models.ForeignKey('Store', on_delete=models.CASCADE, null=True, blank=True)

+

+class VendorProduct(GenericModel, models.Model):

+    product = models.ForeignKey('Product', on_delete=models.CASCADE)

+    vendor = models.ForeignKey('Vendor', on_delete=models.CASCADE)

+    price = models.DecimalField(null=True, blank=True, decimal_places=2, max_digits=7)

+    n_unit = models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True)

+    unit_name = models.CharField(max_length=200, null=True)

+

+    #product = models.ForeignKey('Product', on_delete=models.CASCADE)

+    #products = models.ManyToManyField('Product',)

+class VendorOrder(GenericModel, models.Model):

+    vendor = models.ForeignKey('Vendor', on_delete=models.CASCADE,  null=False, blank=False)

+    product = ChainedForeignKey(

+        "Product",

+        chained_field="vendor",

+        chained_model_field="vendor",

+        show_all=False,

+        auto_choose=True,

+        null=True

+    )

+    store = models.ForeignKey('Store', on_delete=models.CASCADE, null=False, blank=False)

+

+    price = models.DecimalField(null=True, blank=True, decimal_places=2, max_digits=10)

+    n_unit = models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True)

+    unit_name = models.CharField(max_length=200, null=True)

+

+    sub_total = models.DecimalField(null=True, blank=True, decimal_places=2, max_digits=10)

+    vat = models.DecimalField(null=True, blank=True, decimal_places=2, max_digits=10)

+    total = models.DecimalField(null=True, blank=True, decimal_places=2, max_digits=10)

+

+    def save(self, *args, **kwargs):

+        self.sub_total = self.price * self.n_unit

+        self.vat  = self.sub_total * decimal.Decimal(VAT)

+        self.total = self.sub_total + self.vat

+        super(VendorOrder, self).save(*args, **kwargs)

+

+    <a class="nav-link" id="v-pills-vendor-tab" href="{% url "fruit:vendor_index" %}" type="button" role="tab" aria-controls="v-pills-vendor" aria-selected="false">Vendors</a>

+    <a class="nav-link" id="v-pills-vendororder-tab" href="{% url "fruit:vendororder_index" %}" type="button" role="tab" aria-controls="v-pills-vendororder" aria-selected="false">Vendor Order</a>

+    {% if obj %}

+    {% endif %}

+{% extends "fruit/vendor_index.html" %}

+{% load static %}

+{% load crispy_forms_tags %}

+{% load django_bootstrap_breadcrumbs %}

+

+{% block header %}            

+{{ form.media  }}

+{{ form2.media }}

+{% endblock %}

+

+{% block breadcrumbs %}

+    {{ block.super }}

+    {% breadcrumb "Vendor Edit" "fruit:vendor_edit" vendor.pk %}

+{% endblock %}

+

+{% block store_main %}

+<h2>Vendor Form</h2>

+<form  method="post" enctype="multipart/form-data">

+    {% csrf_token %}

+    {{ form | crispy  }}

+    <hr>

+    <a href="{% url "fruit:vendorproduct_create" pk=obj.id %}" class='btn btn-primary'>Create Product</a>

+    <h2>Products</h2>

+    <table class='table table-borded table-striped'>

+    <thead>

+        <tr>

+            <th>ID</th>

+            <th>Product</th>

+            <th>Created At</th>

+        </tr>

+    </thead>   

+    <tbody>

+        {% for p in obj.vendorproduct_set.all %}

+        <tr>

+            <td><a href="{% url "fruit:vendorproduct_edit" pk=p.id %}">{{ p.id }}</a></td>

+            <td>{{ p.product }}</td>

+            <td>{{ p.created_at }}</td>

+        </tr>

+        {% endfor %}

+    </tbody>

+    </table>

+    <br>

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

+

+</form>

+

+{% endblock %}

+{% extends "fruit/mystore.html" %}

+{% load static %}

+{% load crispy_forms_tags %}

+

+{% block header %}            

+{% endblock %}

+

+{% load django_bootstrap_breadcrumbs %}

+{% block breadcrumbs %}

+    {{ block.super }}

+    {% breadcrumb "Vendors" "fruit:vendor_index" %}

+{% endblock %}

+

+{% block store_main %}

+

+<a  class='btn btn-primary' href="{% url "fruit:vendor_create" %}">Create Vendor</a>

+<hr>

+<h2>

+    Vendor Index</h2>

+{% include "fruit/_searchcenter.html" %}

+<hr>

+<table class='table table-borded table-striped'>

+    <thead>

+        <tr>

+            <th>ID</th>

+            <th>Name</th>

+            <th>Products</th>

+            <th>Price</th>

+            <th>Detail</th>

+            <th>Tel</th>

+            <th>Email</th>

+            <th>LineId</th>

+            <th>Created At</th></tr>

+    </thead>

+    <tbody>

+{% for p in page_obj %}

+        <tr>

+            <td><a href="{% url "fruit:vendor_edit" pk=p.pk %}">{{ p.id }}</a></td><td>{{ p.product }}</td>

+            <td>{{ p.name }}</td>

+            <td>{{ p.products }}</td>

+            <td>{{ p.price }}</td>

+            <td>{{ p.detail }}</td>

+            <td>{{ p.tel }}</td>

+            <td>{{ p.email }}</td>

+            <td>{{ p.line_id }}</td>

+            <td>{{ p.created_at }}</td>

+        </tr>

+{% endfor %}

+    </tbody>

+</table>

+{% include "fruit/_paging.html" %}

+{% endblock %}

+{% extends "fruit/vendororder_index.html" %}

+{% load static %}

+{% load crispy_forms_tags %}

+{% load django_bootstrap_breadcrumbs %}

+

+{% block header %}            

+{{ form.media  }}

+{% endblock %}

+

+{% block breadcrumbs %}

+    {{ block.super }}

+    {% breadcrumb "Vendor Order Form" "fruit:vendororder_edit" form.instance.pk %}

+{% endblock %}

+

+{% block store_main %}

+<h2>Vendor Order Form</h2>

+<form  method="post" enctype="multipart/form-data">

+    {% csrf_token %}

+    {{ form | crispy  }}

+    <br>

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

+

+</form>

+

+{% endblock %}

+{% extends "fruit/mystore.html" %}

+{% load static %}

+{% load crispy_forms_tags %}

+

+{% block header %}            

+{% endblock %}

+

+{% load django_bootstrap_breadcrumbs %}

+{% block breadcrumbs %}

+    {{ block.super }}

+    {% breadcrumb "Vendor Orders" "fruit:vendororder_index" %}

+{% endblock %}

+

+{% block store_main %}

+

+<a  class='btn btn-primary' href="{% url "fruit:vendororder_create" %}">Create Vendor Order</a>

+<hr>

+<h2>

+    Vendor Order Index</h2>

+{% include "fruit/_searchcenter.html" %}

+<hr>

+<table class='table table-borded table-striped'>

+    <thead>

+        <tr>

+            <th>ID</th>

+            <th>Vendor</th>

+            <th>Product</th>

+            <th>Price</th>

+            <th>Unit</th>

+            <th>Total</th>

+            <th>Created At</th></tr>

+    </thead>

+    <tbody>

+{% for p in page_obj %}

+        <tr>

+            <td><a href="{% url "fruit:vendororder_edit" pk=p.pk %}">{{ p.id }}</a></td><td>{{ p.vendor }}</td>

+            <td>{{ p.product }}</td>

+            <td>{{ p.price }}</td>

+            <td>{{ p.unit }}</td>

+            <td>{{ p.total }}</td>

+            <td>{{ p.created_at }}</td>

+        </tr>

+{% endfor %}

+    </tbody>

+</table>

+{% include "fruit/_paging.html" %}

+{% endblock %}

+{% extends "fruit/vendor_form.html" %}

+{% load static %}

+{% load crispy_forms_tags %}

+{% load django_bootstrap_breadcrumbs %}

+

+{% block header %}            

+{{ form.media  }}

+{{ form2.media }}

+{% endblock %}

+

+{% block breadcrumbs %}

+    {{ block.super }}

+    {% breadcrumb "Vendor Product Form" "fruit:vendorproduct_edit" form.instance.pk %}

+{% endblock %}

+

+{% block store_main %}

+<h2>Vendor Product  Form</h2>

+<form  method="post" enctype="multipart/form-data">

+    {% csrf_token %}

+    {{ form | crispy  }}

+    <hr>

+    <br>

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

+

+</form>

+

+{% endblock %}

+    path('vendor/', views.vendor_index, name='vendor_index'),

+    path('vendor/create', views.vendor_create, name='vendor_create'),

+    path('vendor/<pk>', views.vendor_edit, name='vendor_edit'),

+    path('vendor/<pk>/product/create', views.vendorproduct_create, name='vendorproduct_create'),

+    path('vendorproduct/<pk>', views.vendorproduct_edit, name='vendorproduct_edit'),

+    path('vendororder/', views.vendororder_index, name='vendororder_index'),

+    path('vendororder/create', views.vendororder_create, name='vendororder_create'),

+    path('vendororder/<pk>', views.vendororder_edit, name='vendororder_edit'),

+from fruit.models import Store, Product, Photo, ProductSKU, Sale, Inbox, Vendor, VendorProduct

+

+from .forms import StoreForm, ProductForm, InboxForm, SaleForm,  PhotoFormSet,VendorFilter,  InlinePhotoFormset, ProductSKUForm, ProductFilter, SaleFilter, InboxFilter, VendorForm, VendorOrderForm, VendorOrderFilter, VendorOrder, InlineVendorProductFormset, VendorProductForm

+            messages.error(request, form.errors)

+@login_required

+def vendor_index(request):

+    stores = request.user.store_created.all().order_by("-created_at")

+    o_qs = stores[0].vendor_set.all().order_by("-created_at")

+

+    f = VendorFilter(request.GET, queryset=o_qs)

+

+    paginator = Paginator(f.qs, 25)

+    page_number = request.GET.get('page')

+    page_obj = paginator.get_page(page_number)

+

+    return render(request, 'fruit/vendor_index.html', {'o_qs': o_qs, 'vendor_active': True, 'page_obj': page_obj, 'filter': f})

+

+@login_required

+def vendor_edit(request, pk):

+    stores = request.user.store_created.all().order_by("-created_at")

+

+    obj = Vendor.objects.get(pk=pk)

+    form = VendorForm(instance = obj)

+    form2 = InlineVendorProductFormset(instance = obj)

+    for f in form2:

+        f.fields['product'].queryset = stores[0].product_set.all().order_by("-created_at")

+

+    if request.method == "POST":

+        form = VendorForm(request.POST)

+        form2 = InlineVendorProductFormset(request.POST, instance = obj)

+        if form.is_valid() and form2.is_valid():

+            instance1 = form.save()

+            instance2 = form2.save(commit=False)

+

+            for i in instance2:

+                i.created_by = request.user

+                i.save()

+

+            '''

+            print(instances)

+            for s in instances:

+                s.product = instance1

+                s.save()

+            '''

+            messages.success(request, "Vendor Save")

+        else:

+            print("Invalid ")

+            if form.errors:

+                messages.error(request, form.errors)

+            if form2.errors:

+                messages.error(request, form2.errors)

+

+        return redirect("fruit:vendor_edit", pk =  int(pk))

+

+    return render(request, 'fruit/vendor_form.html', {'vendor_active': True, 'form': form, 'obj': obj, 'form2': form2})

+

+@login_required

+def vendor_create(request):

+    stores = request.user.store_created.all().order_by("-created_at")

+

+    form = VendorForm()

+

+    form.fields['products'].queryset = stores[0].product_set.all().order_by("-created_at")

+

+    if request.method == "POST":

+        form = VendorForm(request.POST)

+        if form.is_valid():

+

+            instance1 = form.save(commit=False)

+            instance1.store = stores[0]

+            instance1.created_by = request.user

+            instance1.save()

+            '''

+            print(instances)

+            for s in instances:

+                s.product = instance1

+                s.save()

+            '''

+            messages.success(request, "Sale Save")

+        else:

+            print("Invalid ")

+            if form.errors:

+                messages.error(request, form.errors)

+

+        return redirect("fruit:vendor_edit", pk =  instance1.pk)

+

+    return render(request, 'fruit/vendor_form.html', {'vendor_active': True, 'form': form})

+

+@login_required

+def vendorproduct_create(request, pk):

+    stores = request.user.store_created.all().order_by("-created_at")

+    print(pk)

+    vendor = Vendor.objects.get(pk=pk)

+

+    form = VendorProductForm()

+

+    form.fields['product'].queryset = stores[0].product_set.all().order_by("-created_at")

+

+    if request.method == "POST":

+        form = VendorProductForm(request.POST)

+        if form.is_valid():

+

+            instance1 = form.save(commit=False)

+            instance1.store = stores[0]

+            instance1.vendor = vendor

+            instance1.created_by = request.user

+            instance1.save()

+            '''

+            print(instances)

+            for s in instances:

+                s.product = instance1

+                s.save()

+            '''

+            messages.success(request, "Sale Save")

+        else:

+            print("Invalid ")

+            if form.errors:

+                messages.error(request, form.errors)

+

+        return redirect("fruit:vendorproduct_edit", pk =  instance1.pk)

+

+    return render(request, 'fruit/vendorproduct_form.html', {'vendor_active': True, 'form': form, 'vendor': vendor})

+

+@login_required

+def vendorproduct_edit(request, pk):

+    stores = request.user.store_created.all().order_by("-created_at")

+

+    obj = VendorProduct.objects.get(pk=pk)

+    form = VendorProductForm(instance = obj)

+    vendor = obj.vendor

+

+    form.fields['product'].queryset = stores[0].product_set.all().order_by("-created_at")

+

+    if request.method == "POST":

+        form = VendorProductForm(request.POST)

+        if form.is_valid():

+            instance1 = form.save()

+

+            '''

+            print(instances)

+            for s in instances:

+                s.product = instance1

+                s.save()

+            '''

+            messages.success(request, "Vendor Product Save")

+        else:

+            print("Invalid ")

+            if form.errors:

+                messages.error(request, form.errors)

+

+        return redirect("fruit:vendorproduct_edit", pk =  int(pk))

+

+    return render(request, 'fruit/vendorproduct_form.html', {'vendor_active': True, 'form': form, 'obj': obj, 'vendor': vendor})

+

+#vendor order

+@login_required

+def vendororder_index(request):

+    stores = request.user.store_created.all().order_by("-created_at")

+    o_qs = stores[0].vendororder_set.all().order_by("-created_at")

+

+    f = VendorOrderFilter(request.GET, queryset=o_qs)

+

+    paginator = Paginator(f.qs, 25)

+    page_number = request.GET.get('page')

+    page_obj = paginator.get_page(page_number)

+

+    return render(request, 'fruit/vendororder_index.html', {'o_qs': o_qs, 'vendor_active': True, 'page_obj': page_obj, 'filter': f})

+

+

+@login_required

+def vendororder_edit(request, pk):

+    stores = request.user.store_created.all().order_by("-created_at")

+

+    obj = VendorOrder.objects.get(pk=pk)

+    form = VendorOrderForm(instance = obj)

+

+    #form.fields['product'].queryset = stores[0].product_set.all().order_by("-created_at")

+

+    if request.method == "POST":

+        form = VendorOrderForm(request.POST)

+        if form.is_valid():

+            instance1 = form.save()

+            '''

+            print(instances)

+            for s in instances:

+                s.product = instance1

+                s.save()

+            '''

+            messages.success(request, "Sale Save")

+        else:

+            print("Invalid ")

+            if form.errors:

+                messages.error(request, form.errors)

+

+        return redirect("fruit:vendororder_edit", pk =  int(pk))

+

+    return render(request, 'fruit/vendororder_form.html', {'vendor_active': True, 'form': form, 'object': obj})

+

+@login_required

+def vendororder_create(request):

+    stores = request.user.store_created.all().order_by("-created_at")

+

+    form = VendorOrderForm()

+

+

+    if request.method == "POST":

+        form = VendorOrderForm(request.POST)

+        if form.is_valid():

+

+            instance1 = form.save(commit=False)

+            instance1.store = stores[0]

+            instance1.save()

+            '''

+            print(instances)

+            for s in instances:

+                s.product = instance1

+                s.save()

+            '''

+            messages.success(request, "Vendor Order Save")

+            return redirect("fruit:vendororder_edit", pk =  instance1.pk)

+        else:

+            print("Invalid ")

+            if form.errors:

+                messages.error(request, form.errors)

+

+

+    return render(request, 'fruit/vendororder_form.html', {'vendororder_active': True, 'form': form})

+