bill of materials

29KB

library.zip

archive

add delete button

28KB

library.zip

archive

https://chat.openai.com/share/99cb92bf-404a-42f2-8346-fc87a89a4bba

settings.py

STATIC_URL = 'static/'
STATICFILES_DIRS = [
    BASE_DIR / 'static',
]
STATIC_ROOT=(BASE_DIR/ "assets/")

MEDIA_URL = '/media/'
MEDIA_ROOT = os.path.join(BASE_DIR, 'assets/media/')

models.py

class BillOfMaterials(models.Model):
    code = models.CharField(max_length=20)
    name = models.CharField(max_length=100)
    bomtype = models.CharField(max_length=20)
    quantity = models.DecimalField(max_digits=10, decimal_places=4)

class ChildComponent(models.Model):
    bill_of_materials = models.ForeignKey(BillOfMaterials, on_delete=models.CASCADE, related_name='child_components')
    code = models.CharField(max_length=20)
    name = models.CharField(max_length=100)
    uom = models.CharField(max_length=20)
    quantity = models.DecimalField(max_digits=10, decimal_places=4)


class Production(models.Model):
    name = models.CharField(max_length=100)
    quantity = models.DecimalField(max_digits=10, decimal_places=4)

    def __str__(self):
        return self.name

class ProductionComponent(models.Model):
    production = models.ForeignKey(Production, on_delete=models.CASCADE, related_name='production_components')
    code = models.CharField(max_length=20)
    name = models.CharField(max_length=100)
    uom = models.CharField(max_length=20)
    quantity = models.DecimalField(max_digits=10, decimal_places=4)

    def __str__(self):
        return self.name

admin.py

from django.contrib import admin
from django.forms import inlineformset_factory
from .models import (
    BillOfMaterials,
    ChildComponent,
    Production, 
    ProductionComponent
)

# Bill Of Materials 
class ChildComponentInline(admin.TabularInline):
    model = ChildComponent
class BillOfMaterialsAdmin(admin.ModelAdmin):
    inlines = [ChildComponentInline]
admin.site.register(BillOfMaterials, BillOfMaterialsAdmin)


# Production Order
class ProductionComponentInline(admin.TabularInline):
    model = ProductionComponent
class ProductionAdmin(admin.ModelAdmin):
    inlines = [ProductionComponentInline]
    class Media:
        js = ('js/fetch_sales_order_info.js',)
        defer = True  # Add the defer attribute
admin.site.register(Production, ProductionAdmin)

create static/js folder and store fetch_sales_order_info.js

(function ($) {
    $(document).ready(function(){
        $('#id_name, #id_quantity').on('change',function(){
            var initialname = $('#id_name').val();
            var initialquantity = $('#id_quantity').val();
            if (initialname.trim() !== '' && initialquantity.trim() !== '') {
                $.ajax({
                    type: 'POST',
                    url: '/library/ajax/',
                    data: {
                        'name': initialname,
                        'quantity': initialquantity
                    },
                    dataType: 'json',
                    success: function(response){
                        updateFormset(response);
                        // $('#id_production_components-0-quantity').val(response.quantity);

                    }
                });
            }

        });
function updateFormset(data) {
  var formsetTable = $('table');
  formsetTable.empty();
    // Add table header
    var tableHeader = $('<thead>').appendTo(formsetTable);
    var headerRow = $('<tr>').appendTo(tableHeader);
    $('<th>').addClass('column-code required').text('Code').appendTo(headerRow);
    $('<th>').addClass('column-name required').text('Name').appendTo(headerRow);
    $('<th>').addClass('column-uom required').text('Uom').appendTo(headerRow);
    $('<th>').addClass('column-quantity required').text('Quantity').appendTo(headerRow);
    $('<th>').text('Delete?').appendTo(headerRow);
  
    // Add table body
    var tableBody = $('<tbody>').appendTo(formsetTable);
  data.forEach(function (component, index) {
    var row = $('<tr>');
    var codeCell = $('<td>');
    var codeInput = $('<input type="text" maxlength="20" class="vTextField">');
    codeInput.attr('name', 'production_components-' + index + '-code');
    codeInput.val(component.code);
    codeCell.append(codeInput);
    var nameCell = $('<td>');
    var nameInput = $('<input type="text" maxlength="100" class="vTextField">');
    nameInput.attr('name', 'production_components-' + index + '-name');
    nameInput.val(component.name);
    nameCell.append(nameInput);
    var uomCell = $('<td>');
    var uomInput = $('<input type="text" maxlength="20" class="vTextField">');
    uomInput.attr('name', 'production_components-' + index + '-uom');
    uomInput.val(component.uom);
    uomCell.append(uomInput);
    var quantityCell = $('<td>');
    var quantityInput = $('<input type="number" min="0" step="0.0001" required>');
    quantityInput.attr('name', 'production_components-' + index + '-quantity');
    quantityInput.val(component.quantity);
    quantityCell.append(quantityInput);

    var deleteCell = $('<td>');
    var deleteButton = $('<button>').text('Delete');
    deleteButton.addClass('delete-button');
    deleteButton.on('click', function() {
      // Handle delete button click
      row.remove();
    });
    deleteCell.append(deleteButton);   


    
    row.append(codeCell, nameCell, uomCell, quantityCell,deleteCell);
    formsetTable.append(row);
  });
  
}

          
          
    });
})(jQuery);

views.py

from django.http import JsonResponse
from django.views.decorators.csrf import csrf_exempt
from .models import BillOfMaterials
@csrf_exempt
def ajax_view(request):
    if request.method == 'POST':
        production_name  = request.POST.get('name')
        production_quantity  = request.POST.get('quantity')
        bill_of_materials = BillOfMaterials.objects.filter(name=production_name).first()
        if bill_of_materials:
            child_components = bill_of_materials.child_components.all()
            updated_components = []



            for component in child_components:
                if bill_of_materials.quantity == production_quantity:
                    updated_quantity = float(component.quantity)
                else:
                    updated_quantity = float(component.quantity) * (float(production_quantity) / float(bill_of_materials.quantity))
                updated_quantity = format(updated_quantity, '.4f')
                updated_components.append({
                    'id': component.id,
                    'code': component.code,
                    'name': component.name,
                    'uom': component.uom,
                    'quantity': updated_quantity
                })
                    

        return JsonResponse(updated_components, safe=False)

    return JsonResponse([], safe=False)

urls.py

from django.urls import path
from .views import ajax_view

urlpatterns = [

    path('ajax/', ajax_view, name='ajax_view'),

]