def wm_import_suppliers(self):
for supplier in Supplier.objects.all():
supplier.delete()
wm_suppliers = WorkflowmaxSupplier.objects.all()
for wm_supplier in wm_suppliers:
supplier = Supplier()
supplier.wm_import(wm_supplier)
def save_new_supplier(self, billing_form, delivery_form):
contact = Contact()
billing_address = billing_form.save()
delivery_address = delivery_form.save()
contact.billing_address = billing_address
contact.delivery_address = delivery_address
contact.save()
supplier = Supplier()
supplier.contact = contact
supplier.save()
def test_gecko_num_registered_supplier_correct():
Supplier.objects.bulk_create([
Supplier(sso_id=1, company_email='*****@*****.**', mobile_number='1'),
Supplier(sso_id=2, company_email='*****@*****.**', mobile_number='2'),
Supplier(sso_id=3, company_email='*****@*****.**', mobile_number='3'),
])
gecko_json = gecko.total_registered_suppliers()
expected = {"item": [{"value": 3, "text": "Total registered suppliers"}]}
assert gecko_json == expected
def import_suppliers(request):
context_vars = dict()
context_vars['header'] = capfirst(_('import suppliers from workflowmax'))
context_vars['comment'] = capfirst(_('this will destroy all your local suppliers, please confirm your decision.'))
if request.method == "POST":
for supplier in Supplier.objects.all():
supplier.delete()
wm_suppliers = WorkflowmaxSupplier.objects.all()
for wm_supplier in wm_suppliers:
supplier = Supplier()
supplier.wm_import(wm_supplier)
return HttpResponseRedirect(reverse('supplier-list'))
return direct_to_template(request, template='supplier/import.html', extra_context=context_vars)
def add_supplier_details(request):
if request.method == 'POST':
customer = Supplier()
name = request.POST.get('name')
mail = request.POST.get('email')
phone_number = request.POST.get('contact')
address = request.POST.get('comment')
customer.name = name
customer.mail = mail
customer.phone_number = phone_number
customer.address = address
customer.save()
return render(request, 'add_supplier_details.html', {})
def test_supplier_model_str():
supplier = Supplier(**VALID_REQUEST_DATA)
assert supplier.company_email == str(supplier)
os.environ.setdefault("DJANGO_SETTINGS_MODULE",
"bookstore_management_system.settings")
import django
django.setup()
from book.models import Book
from supplier.models import Supplier, SupplierStack
from db_tools.data.book_data import raw_data
# 先创建书库，将book_data中的所有书添加到这个书库中
book_stack = SupplierStack()
book_stack.stack_name = "中国卖书有限公司书库"
supplier = Supplier()
supplier.supplier_name = "中国卖书有限公司"
supplier.id = 1
book_stack.supplier = supplier
supplier.save()
book_stack.save()
print("书库信息录入成功!")
for book_detail in raw_data:
book = Book()
book.book_name = book_detail["book_name"]
book.publisher = book_detail["publisher"]
book.writer = book_detail["writer"]
book.price = book_detail["price"]
def fill_db(self):
now = datetime.datetime.now(tz=pytz.utc)
last_week = now - datetime.timedelta(days=7)
last_month = now - datetime.timedelta(days=31)
c1 = Category(pk=1, name='Электроника')
c1.save()
c2 = Category(pk=2, name='Бытовая техника', parent=c1)
c2.save()
c3 = Category(pk=3, name='Телевизоры', parent=c1)
c3.save()
c4 = Category(pk=4, name='Телефоны', parent=c1)
c4.save()
c5 = Category(pk=5, name='Смартфоны', parent=c4)
c5.save()
c6 = Category(pk=6, name='Холодильники', parent=c2)
c6.save()
c7 = Category(pk=7, name='Стиральные машины', parent=c2)
c7.save()
c8 = Category(pk=8, name='Посудомоечные машины', parent=c2)
c8.save()
categories = (
c1,
c2,
c3,
c4,
c5,
c6,
c7,
c8,
)
stocks = (
Stock(pk=1,
article=100,
category=categories[2],
name='Телевизор LG',
price=10000,
number=10),
Stock(pk=2,
article=101,
category=categories[2],
name='Телевизор Samsung',
price=11000,
number=9),
Stock(pk=3,
article=102,
category=categories[2],
name='Телевизор Sony',
price=12000,
number=20),
Stock(pk=4,
article=103,
category=categories[6],
name='Стиральная машина LG',
price=10500,
number=5),
Stock(pk=5,
article=104,
category=categories[4],
name='Смартфон Samsung Galaxy Note 8',
price=13000,
number=18),
Stock(pk=6,
article=105,
category=categories[5],
name='Холодильник LG',
price=10000,
number=12),
Stock(pk=7,
article=106,
category=categories[5],
name='Холодильник Samsung',
price=15000,
number=0),
)
Stock.objects.bulk_create(stocks)
suppliers = (
Supplier(pk=1,
organization='LG',
address='680000, Хабаровск, ул. Большая, 1-1',
phone_number='111111',
email='*****@*****.**',
legal_details='ИНН: 9909111111',
contact_info=('Контактное лицо: ' +
'Сергей Иванович Сидоров')),
Supplier(pk=2,
organization='Samsung',
address='680000, Хабаровск, ул. Большая, 1-2',
phone_number='111112',
email='*****@*****.**',
legal_details='ИНН: 9909111112',
contact_info=('Контактное лицо: ' +
'Сергей Иванович Семенов')),
Supplier(pk=3,
organization='Sony',
address='680000, Хабаровск, ул. Большая, 1-3',
phone_number='111113',
email='*****@*****.**',
legal_details='ИНН: 9909111113',
contact_info=('Контактное лицо: ' +
'Сергей Иванович Петров')),
)
Supplier.objects.bulk_create(suppliers)
for i in range(7):
sc = SupplierCategory(supplier=suppliers[0],
category=categories[i])
sc.save()
sc = SupplierCategory(supplier=suppliers[1],
category=categories[i])
sc.save()
for i in range(6):
sc = SupplierCategory(supplier=suppliers[2],
category=categories[i])
sc.save()
customers = (
Customer(pk=1,
full_name='Иван Иванович Иванов',
phone_number='222222',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Иван Иванович Иванов')),
Customer(pk=2,
full_name='Петр Петрович Петров',
phone_number='222223',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Петр Петрович Петров')),
Customer(pk=3,
full_name='Светлана Семеновна Семенова',
phone_number='222224',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Светлана Семеновна Семенова')),
Customer(pk=4,
full_name='Анна Николаевна Николаева',
phone_number='222225',
email=settings.CLIENT_EMAIL,
contact_info=('Контактное лицо: ' +
'Анна Николаевна Николаева')),
)
Customer.objects.bulk_create(customers)
cargo = (
Cargo(pk=1, supplier=suppliers[0], date=last_week),
Cargo(pk=2, supplier=suppliers[0], date=last_month),
Cargo(pk=3, supplier=suppliers[1], date=last_week),
Cargo(pk=4, supplier=suppliers[1], date=last_week),
Cargo(pk=5, supplier=suppliers[0], date=last_week),
)
Cargo.objects.bulk_create(cargo)
CargoStock.objects.create(cargo=cargo[0], stock=stocks[0], number=10)
CargoStock.objects.create(cargo=cargo[1], stock=stocks[3], number=5)
CargoStock.objects.create(cargo=cargo[1], stock=stocks[5], number=15)
CargoStock.objects.create(cargo=cargo[2], stock=stocks[0], number=10)
CargoStock.objects.create(cargo=cargo[2], stock=stocks[4], number=20)
CargoStock.objects.create(cargo=cargo[3], stock=stocks[6], number=10)
CargoStock.objects.create(cargo=cargo[4], stock=stocks[6], number=10)
shipments = (
Shipment(pk=1, customer=customers[0], date=now),
Shipment(pk=2, customer=customers[0], date=now),
Shipment(pk=3, customer=customers[0], date=now),
Shipment(pk=4, customer=customers[1], date=now),
Shipment(pk=5, customer=customers[2], date=now),
Shipment(pk=6, customer=customers[0], date=now),
Shipment(pk=7, customer=customers[1], date=now),
Shipment(pk=8, customer=customers[2], date=now),
)
Shipment.objects.bulk_create(shipments)
ShipmentStock.objects.create(shipment=shipments[0],
stock=stocks[6],
number=10)
ShipmentStock.objects.create(shipment=shipments[1],
stock=stocks[4],
number=1)
ShipmentStock.objects.create(shipment=shipments[2],
stock=stocks[5],
number=1)
ShipmentStock.objects.create(shipment=shipments[3],
stock=stocks[5],
number=2)
ShipmentStock.objects.create(shipment=shipments[4],
stock=stocks[0],
number=1)
ShipmentStock.objects.create(shipment=shipments[0],
stock=stocks[4],
number=1)
ShipmentStock.objects.create(shipment=shipments[6],
stock=stocks[5],
number=5)
ShipmentStock.objects.create(shipment=shipments[4],
stock=stocks[5],
number=4)
ShipmentStock.objects.create(shipment=shipments[5],
stock=stocks[4],
number=3)
ShipmentStock.objects.create(shipment=shipments[7],
stock=stocks[2],
number=7)