def edit_user(request, pk):
user = User.objects.get(id=pk)
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
if request.method == 'POST':
form = UserUpdateForm(request.POST, instance=user)
if form.is_valid():
form.save()
messages.success(request, f'User Profile has been updated!')
return redirect('user-list')
else:
form = UserUpdateForm(instance=user)
return render(
request, 'user/edit_user.html', {
'form': form,
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser
})
def delete_item(request, pk):
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
item = item_avaliable(pk)
if item == True:
messages.add_message(request, messages.SUCCESS, "Item Deleted")
return redirect('item-stock')
else:
messages.add_message(request, messages.ERROR,
"You cannot delete this item, it is refrenced")
return redirect('item-stock')
def new_item_stock(request):
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
return render(
request, 'inventory/new_item_stock.html', {
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser
})
def user_list(request):
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
all_user = User.objects.all()
return render(
request, 'user/users.html', {
'all_user': all_user,
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser
})
def categories(request):
permission = inventory_form_roles(request.user)
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
main_categories = Category.objects.all()
sub_categories = SubCategory.objects.all()
return render(
request, 'inventory/category_and_type.html', {
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser,
'main_categories': main_categories,
'sub_categories': sub_categories
})
def edit_item(request, pk):
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
all_detail = Add_products.objects.filter(id=pk).first()
main_categories = Category.objects.all()
sub_categories = SubCategory.objects.filter(
main_category_id=all_detail.main_category_id)
if request.method == "POST":
main_category = request.POST.get('main_category')
sub_category = request.POST.get('sub_category')
size = request.POST.get('size')
product_desc = request.POST.get('product_desc')
select_unit = request.POST['unit']
opening_stock = request.POST.get('opening_stock')
main = Category.objects.filter(id=main_category).first()
sub = SubCategory.objects.filter(id=sub_category).first()
product_name = main.main + " " + sub.sub + " " + size
all_detail.sub_category_id = sub
all_detail.sub_category = sub.sub
all_detail.size = size
all_detail.product_name = product_name
all_detail.product_desc = product_desc
all_detail.unit = select_unit
all_detail.opening_stock = opening_stock
all_detail.save()
return render(
request, 'inventory/edit_item.html', {
'all_detail': all_detail,
'pk': pk,
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser,
'main_categories': main_categories,
'sub_categories': sub_categories
})
def item_stock(request):
permission = inventory_form_roles(request.user)
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
cursor = connection.cursor()
cursor.execute(
'''Select itemID,Size,item_code, item_name,Item_description,Unit,Size,SUM(quantity) As qty, main_category, sub_category From (
Select 'Opening Stock' As TranType,ID As ItemID, Size,Product_Code As Item_Code,Product_Name As Item_name,Product_desc As Item_description,Unit As unit,Opening_Stock as Quantity, main_category, sub_category
From inventory_add_products
union all
Select 'Purchase' As TranType,P.ID As ItemID,P.Size,P.Product_Code,P.Product_name,P.Product_desc,P.unit,Quantity,P.main_category, P.sub_category
From transaction_purchasedetail H Inner join inventory_add_products P On H.item_id_id = P.id
union All
Select 'Purchase Return' As TranType,P.ID As ItemID,P.Size,P.Product_Code,P.Product_name,P.Product_desc,P.unit,Quantity * -1,P.main_category, P.sub_category
From transaction_purchasereturndetail H Inner join inventory_add_products P On H.item_id_id = P.id
union all
Select 'Sale' As TranType,P.ID AS ItemID,P.Size,P.Product_Code,P.Product_name,P.Product_desc,P.unit,Quantity * -1,P.main_category, P.sub_category
From transaction_saledetail H Inner join inventory_add_products P On H.item_id_id = P.id
union all
Select 'Sale Return' As TranType,P.ID AS ItemID,P.Size,P.Product_Code,P.Product_name,P.Product_desc,P.unit,Quantity,P.main_category, P.sub_category
From transaction_salereturndetail H Inner join inventory_add_products P On H.item_id_id = P.id
) As tblTemp
Group by Item_Code
''')
row = cursor.fetchall()
return render(
request, 'inventory/item_stock.html', {
'row': row,
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'permission': permission,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser
})
def register(request):
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
if request.method == 'POST':
form = RegistrationFrom(request.POST)
if form.is_valid():
form.save()
username = request.POST.getlist('username')[0]
user = User.objects.get(username=username)
for i in range(11, 16):
roles = UserRoles.objects.create(user_id=user,
form_name="Customer",
form_id=0,
child_form=i)
roles.save()
for i in range(21, 26):
roles = UserRoles.objects.create(user_id=user,
form_name="Supplier",
form_id=0,
child_form=i)
roles.save()
for i in range(31, 41):
if i == 40:
roles = UserRoles.objects.create(user_id=user,
form_name="Transaction",
form_id=0,
child_form=310)
roles.save()
else:
roles = UserRoles.objects.create(user_id=user,
form_name="Transaction",
form_id=0,
child_form=i)
roles.save()
roles = UserRoles.objects.create(user_id=user,
form_name="Inventory",
form_id=0,
child_form=41)
roles.save()
roles = UserRoles.objects.create(user_id=user,
form_name="Reports",
form_id=0,
child_form=0)
roles.save()
messages.success(
request,
f'Your account has been created! You are now able to log in')
return redirect('login')
else:
form = RegistrationFrom
return render(
request, 'user/register.html', {
'form': form,
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser
})
def user_roles(request, pk):
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
user = User.objects.filter(id=pk)
user_id = User.objects.get(id=pk)
user_id = Q(user_id=pk)
form_name = Q(form_name="Customer")
allow_role = UserRoles.objects.filter(user_id, form_name).all()
form_name_supplier = Q(form_name="Supplier")
allow_role_supplier = UserRoles.objects.filter(user_id,
form_name_supplier).all()
form_name_transaction = Q(form_name="Transaction")
allow_role_transaction = UserRoles.objects.filter(
user_id, form_name_transaction).all()
form_name_inventory = Q(form_name="Inventory")
allow_role_inventory = UserRoles.objects.filter(user_id,
form_name_inventory).all()
form_name_reports = Q(form_name="Reports")
allow_role_reports = UserRoles.objects.filter(user_id,
form_name_reports).all()
if request.method == "POST":
form_id = request.POST.getlist('customer')
if form_id:
form_id = 1
else:
form_id = 0
form_id_reports = request.POST.getlist('Reports')
if form_id_reports:
form_id_reports = 5
else:
form_id_reports = 0
for i, value in enumerate(allow_role_reports):
value.form_id = form_id_reports
value.save()
display = request.POST.getlist('display[]')
add = request.POST.getlist('add[]')
edit = request.POST.getlist('edit[]')
delete = request.POST.getlist('delete[]')
c_print = request.POST.getlist('c_print[]')
s_display = request.POST.getlist('s_display[]')
s_add = request.POST.getlist('s_add[]')
s_edit = request.POST.getlist('s_edit[]')
s_delete = request.POST.getlist('s_delete[]')
s_print = request.POST.getlist('s_print[]')
t_display = request.POST.getlist('t_display[]')
t_add = request.POST.getlist('t_add[]')
t_edit = request.POST.getlist('t_edit[]')
t_delete = request.POST.getlist('t_delete[]')
t_print = request.POST.getlist('t_print[]')
t_return = request.POST.getlist('t_return[]')
i_display = request.POST.getlist('i_display[]')
i_add = request.POST.getlist('i_add[]')
i_edit = request.POST.getlist('i_edit[]')
i_delete = request.POST.getlist('i_delete[]')
i_shop = request.POST.getlist('i_shop[]')
form_id_i = request.POST.getlist('Inventory')
if form_id_i:
form_id_i = 4
else:
form_id_i = 0
for i, value in enumerate(allow_role_inventory):
if i == 0:
i_matching_display = [
c for c in i_display if "i_inventory_display" in c
]
i_matching_add = [c for c in i_add if "i_inventory_add" in c]
i_matching_edit = [
c for c in i_edit if "i_inventory_edit" in c
]
i_matching_delete = [
c for c in i_delete if "i_inventory_delete" in c
]
i_matching_shop = [
c for c in i_shop if "i_inventory_shop" in c
]
if i_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if i_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if i_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if i_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if i_matching_shop:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
value.form_id = form_id_i
value.save()
for i, value in enumerate(allow_role):
value.form_id = form_id
value.save()
if i == 0:
matching_display = [c for c in display if "c_rfq_display" in c]
matching_add = [c for c in add if "c_rfq_add" in c]
matching_edit = [c for c in edit if "c_rfq_edit" in c]
matching_delete = [c for c in delete if "c_rfq_delete" in c]
matching_print = [c for c in c_print if "c_rfq_print" in c]
if matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 1:
matching_display = [
c for c in display if "c_quotation_display" in c
]
matching_add = [c for c in add if "c_quotation_add" in c]
matching_edit = [c for c in edit if "c_quotation_edit" in c]
matching_delete = [
c for c in delete if "c_quotation_delete" in c
]
matching_print = [
c for c in c_print if "c_quotation_print" in c
]
if matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 2:
matching_display = [c for c in display if "c_po_display" in c]
matching_add = [c for c in add if "c_po_add" in c]
matching_edit = [c for c in edit if "c_po_edit" in c]
matching_delete = [c for c in delete if "c_po_delete" in c]
matching_print = [c for c in c_print if "c_po_print" in c]
if matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 3:
matching_display = [c for c in display if "c_dc_display" in c]
matching_add = [c for c in add if "c_dc_add" in c]
matching_edit = [c for c in edit if "c_dc_edit" in c]
matching_delete = [c for c in delete if "c_dc_delete" in c]
matching_print = [c for c in c_print if "c_dc_print" in c]
if matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 4:
matching_display = [c for c in display if "c_mrn_display" in c]
matching_add = [c for c in add if "c_mrn_add" in c]
matching_edit = [c for c in edit if "c_mrn_edit" in c]
matching_delete = [c for c in delete if "c_mrn_delete" in c]
matching_print = [c for c in c_print if "c_mrn_print" in c]
if matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
value.r_print = 0
value.save()
value.form_id = form_id
value.save()
form_id_s = request.POST.getlist('Supplier')
if form_id_s:
form_id_s = 2
else:
form_id_s = 0
for i, value in enumerate(allow_role_supplier):
if i == 0:
s_matching_display = [
c for c in s_display if "s_rfq_display" in c
]
s_matching_add = [c for c in s_add if "s_rfq_add" in c]
s_matching_edit = [c for c in s_edit if "s_rfq_edit" in c]
s_matching_delete = [
c for c in s_delete if "s_rfq_delete" in c
]
s_matching_print = [c for c in s_print if "s_rfq_print" in c]
if s_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if s_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if s_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if s_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if s_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 1:
s_matching_display = [
c for c in s_display if "s_quotation_display" in c
]
s_matching_add = [c for c in s_add if "s_quotation_add" in c]
s_matching_edit = [
c for c in s_edit if "s_quotation_edit" in c
]
s_matching_delete = [
c for c in s_delete if "s_quotation_delete" in c
]
s_matching_print = [
c for c in s_print if "s_quotation_print" in c
]
if s_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if s_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if s_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if s_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if s_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 2:
s_matching_display = [
c for c in s_display if "s_po_display" in c
]
s_matching_add = [c for c in s_add if "s_po_add" in c]
s_matching_edit = [c for c in s_edit if "s_po_edit" in c]
s_matching_delete = [c for c in s_delete if "s_po_delete" in c]
s_matching_print = [c for c in s_print if "s_po_print" in c]
if s_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if s_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if s_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if s_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if s_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 3:
s_matching_display = [
c for c in s_display if "s_dc_display" in c
]
s_matching_add = [c for c in s_add if "s_dc_add" in c]
s_matching_edit = [c for c in s_edit if "s_dc_edit" in c]
s_matching_delete = [c for c in s_delete if "s_dc_delete" in c]
s_matching_print = [c for c in s_print if "s_dc_print" in c]
if s_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if s_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if s_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if s_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if s_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 4:
s_matching_display = [
c for c in s_display if "s_mrn_display" in c
]
s_matching_add = [c for c in s_add if "s_mrn_add" in c]
s_matching_edit = [c for c in s_edit if "s_mrn_edit" in c]
s_matching_delete = [
c for c in s_delete if "s_mrn_delete" in c
]
s_matching_print = [c for c in s_print if "s_mrn_print" in c]
if s_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if s_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if s_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if s_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
value.r_print = 0
value.save()
value.form_id = form_id_s
value.save()
form_id_t = request.POST.getlist('Transaction')
if form_id_t:
form_id_t = 3
else:
form_id_t = 0
for i, value in enumerate(allow_role_transaction):
if i == 0:
t_matching_display = [
c for c in t_display if "t_coa_display" in c
]
t_matching_add = [c for c in t_add if "t_coa_add" in c]
t_matching_edit = [c for c in t_edit if "t_coa_edit" in c]
t_matching_delete = [
c for c in t_delete if "t_coa_delete" in c
]
t_matching_print = [c for c in t_print if "t_coa_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 1:
t_matching_display = [
c for c in t_display if "t_purchase_display" in c
]
t_matching_add = [c for c in t_add if "t_purchase_add" in c]
t_matching_edit = [c for c in t_edit if "t_purchase_edit" in c]
t_matching_delete = [
c for c in t_delete if "t_purchase_delete" in c
]
t_matching_print = [
c for c in t_print if "t_purchase_print" in c
]
t_matching_return = [
c for c in t_return if "t_purchase_return" in c
]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
if t_matching_return:
value.r_return = 1
value.save()
else:
value.r_return = 0
value.save()
elif i == 2:
t_matching_display = [
c for c in t_display if "t_pr_display" in c
]
t_matching_add = [c for c in t_add if "t_pr_add" in c]
t_matching_edit = [c for c in t_edit if "t_pr_edit" in c]
t_matching_delete = [c for c in t_delete if "t_pr_delete" in c]
t_matching_print = [c for c in t_print if "t_pr_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 3:
t_matching_display = [
c for c in t_display if "t_sale_display" in c
]
t_matching_add = [c for c in t_add if "t_sale_add" in c]
t_matching_edit = [c for c in t_edit if "t_sale_edit" in c]
t_matching_delete = [
c for c in t_delete if "t_sale_delete" in c
]
t_matching_print = [c for c in t_print if "t_sale_print" in c]
t_matching_return = [
c for c in t_return if "t_sale_return" in c
]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
if t_matching_return:
value.r_return = 1
value.save()
else:
value.r_return = 0
value.save()
elif i == 4:
t_matching_display = [
c for c in t_display if "t_sr_display" in c
]
t_matching_add = [c for c in t_add if "t_sr_add" in c]
t_matching_edit = [c for c in t_edit if "t_sr_edit" in c]
t_matching_delete = [c for c in t_delete if "t_sr_delete" in c]
t_matching_print = [c for c in t_print if "t_sr_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
if i == 5:
t_matching_display = [
c for c in t_display if "t_jv_display" in c
]
t_matching_add = [c for c in t_add if "t_jv_add" in c]
t_matching_edit = [c for c in t_edit if "t_jv_edit" in c]
t_matching_delete = [c for c in t_delete if "t_jv_delete" in c]
t_matching_print = [c for c in t_print if "t_jv_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 6:
t_matching_display = [
c for c in t_display if "t_brv_display" in c
]
t_matching_add = [c for c in t_add if "t_brv_add" in c]
t_matching_edit = [c for c in t_edit if "t_brv_edit" in c]
t_matching_delete = [
c for c in t_delete if "t_brv_delete" in c
]
t_matching_print = [c for c in t_print if "t_brv_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 7:
t_matching_display = [
c for c in t_display if "t_crv_display" in c
]
t_matching_add = [c for c in t_add if "t_crv_add" in c]
t_matching_edit = [c for c in t_edit if "t_crv_edit" in c]
t_matching_delete = [
c for c in t_delete if "t_crv_delete" in c
]
t_matching_print = [c for c in t_print if "t_crv_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 8:
t_matching_display = [
c for c in t_display if "t_bpv_display" in c
]
t_matching_add = [c for c in t_add if "t_bpv_add" in c]
t_matching_edit = [c for c in t_edit if "t_bpv_edit" in c]
t_matching_delete = [
c for c in t_delete if "t_bpv_delete" in c
]
t_matching_print = [c for c in t_print if "t_bpv_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
elif i == 9:
t_matching_display = [
c for c in t_display if "t_cpv_display" in c
]
t_matching_add = [c for c in t_add if "t_cpv_add" in c]
t_matching_edit = [c for c in t_edit if "t_cpv_edit" in c]
t_matching_delete = [
c for c in t_delete if "t_cpv_delete" in c
]
t_matching_print = [c for c in t_print if "t_cpv_print" in c]
if t_matching_display:
value.display = 1
value.save()
else:
value.display = 0
value.save()
if t_matching_add:
value.add = 1
value.save()
else:
value.add = 0
value.save()
if t_matching_edit:
value.edit = 1
value.save()
else:
value.edit = 0
value.save()
if t_matching_delete:
value.delete = 1
value.save()
else:
value.delete = 0
value.save()
if t_matching_print:
value.r_print = 1
value.save()
else:
value.r_print = 0
value.save()
value.form_id = form_id_t
value.save()
return render(
request, 'user/user_roles.html', {
'user': user,
'allow_role': allow_role,
'allow_role_supplier': allow_role_supplier,
'allow_role_transaction': allow_role_transaction,
'allow_role_inventory': allow_role_inventory,
'allow_role_reports': allow_role_reports,
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser
})
def add_product(request):
id = request.POST.get('id', False)
if id:
sub_categories_list = SubCategory.objects.filter(
main_category_id=id).all()
list = serializers.serialize('json', sub_categories_list)
print("Hamza")
return JsonResponse({"list": list})
serial_no = 0
allow_customer_roles = customer_roles(request.user)
allow_supplier_roles = supplier_roles(request.user)
allow_transaction_roles = transaction_roles(request.user)
allow_inventory_roles = inventory_roles(request.user)
get_item_code = Add_products.objects.last()
main_categories = Category.objects.all()
sub_categories = SubCategory.objects.all()
if get_item_code:
get_item_code = get_item_code.product_code
serial_no = int(get_item_code) + 1
else:
serial_no = '1001'
product_name = request.POST.get('product_name', False)
product_desc = request.POST.get('product_desc', False)
type = request.POST.get('type', False)
size = request.POST.get('size', False)
if product_name and product_desc and type and size:
type = request.POST.get('type', False)
size = request.POST.get('size', False)
product_name = request.POST.get('product_name', False)
product_desc = request.POST.get('product_desc', False)
opening_stock = request.POST.get('opening_stock', False)
unit = request.POST.get('unit', False)
main_category_id = Category.objects.filter(main=type).first()
sub_category_id = SubCategory.objects.filter(sub=size).first()
return JsonResponse({
"product_name": product_name,
"type": type,
"size": size,
"product_desc": product_desc,
'unit': unit,
'opening_stock': opening_stock,
'main_category_id': main_category_id.id,
'sub_category_id': sub_category_id.id
})
if request.method == 'POST':
items = json.loads(request.POST.get('items'))
for value in items:
item_code = str(serial_no)
main_category_id = Category.objects.get(
id=value["main_category_id"])
sub_category_id = SubCategory.objects.get(
id=value["sub_category_id"])
new_products = Add_products(product_code=item_code,
product_name=value["item_name"],
product_desc=value["item_description"],
unit=value["unit"],
size=value["size"],
type="",
opening_stock=value["opening_stock"],
user_id=request.user,
main_category_id=main_category_id,
sub_category_id=sub_category_id,
main_category=main_category_id.main,
sub_category=sub_category_id.sub)
new_products.save()
serial_no = int(serial_no) + 1
return JsonResponse({"result": "success"})
return render(
request, 'inventory/add_product.html', {
'main_categories': main_categories,
'sub_categories': sub_categories,
'allow_customer_roles': allow_customer_roles,
'allow_supplier_roles': allow_supplier_roles,
'allow_transaction_roles': allow_transaction_roles,
'allow_inventory_roles': allow_inventory_roles,
'allow_report_roles': report_roles(request.user),
'is_superuser': request.user.is_superuser
})
