def add_notice_sheet():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
code = request.form.get('code')
warehouse_name = request.form.get('warehouse_name')
order_man_name = request.form.get('order_man_name')
delivery_date = request.form.get('delivery_date')
notice_date = request.form.get('notice_date')
statue = request.form.get('statue')
handler_name = request.form.get('handler_name')
# 用户验证
if (manager_validate(engine, username, password, department)):
# 获取模型
data_model = notice_sheet.NoticeSheet(engine)
statue = data_model.create_notice_sheet(
code=code,
warehouse_name=warehouse_name,
order_man_name=order_man_name,
delivery_date=delivery_date,
notice_date=notice_date,
statue=statue,
handler_name=handler_name)
if (statue == SUCCESS):
return successful(data_model, {'code': statue})
else:
return failed(data_model, data={'code': statue})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def add_order_sheet_detail():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
order_sheet_code = request.form.get('order_sheet_code')
commodity_code = request.form.get('commodity_code')
number = request.form.get('number')
price = request.form.get('price')
# 用户验证
if (storage_keeper_validate(engine, username, password, department)):
# 获取模型
data_model = order_sheet_details.OrderSheetDetail(engine)
result = data_model.create_order_sheet_detail(
order_sheet_code=order_sheet_code,
commodity_code=commodity_code,
number=number,
price=price)
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, data={'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def change_user():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
# 修改信息
origin_name = request.form.get('origin_name')
dest_name = request.form.get('dest_name')
dest_password = request.form.get('dest_password')
dest_contact = request.form.get('dest_contact')
dest_department = request.form.get('dest_department')
if (admin_validate(engine, username, password, department)):
data_model = user.User(engine)
statue = data_model.change_user(origin_name=origin_name,
dest_name=dest_name,
dest_password=dest_password,
dest_contact=dest_contact,
dest_department=dest_department)
if (statue == statue):
return successful(data_model, {'code': statue})
else:
return failed(data_model, {'code': statue})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def add_warehouse():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
warehouse_name = request.form.get('warehouse_name')
warehouse_location = request.form.get('warehouse_location')
warehouse_manager_name = request.form.get('warehouse_manager_name')
if (admin_validate(engine, username, password, department)):
data_model = warehouse.Warehouse(engine)
code = data_model.create_warehouse(
name=warehouse_name,
location=warehouse_location,
warehouse_manager_name=warehouse_manager_name)
if (code == SUCCESS):
return successful(data_model, {'code': code})
else:
return failed(data_model, {'code': code})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def add_user():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
add_username = request.form.get('add_username')
add_user_password = request.form.get('add_user_password')
add_user_contact = request.form.get('add_user_contact')
add_user_department = request.form.get('add_user_department')
if (admin_validate(engine, username, password, department)):
data_model = user.User(engine)
statue = data_model.create_user(name=add_username,
password=add_user_password,
contact=add_user_contact,
department=add_user_department)
if (statue == SUCCESS):
return successful(data_model, {'code': statue})
else:
return failed(data_model, {'code': statue})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def add_commodity():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department_name = request.form.get('department_name')
# 添加商品信息
commodity_code = request.form.get('commodity_code')
commodity_name = request.form.get('commodity_name')
commodity_type = request.form.get('commodity_type')
commodity_unit = request.form.get('commodity_unit')
commodity_specification = request.form.get('commodity_specification')
commodity_supplier_name = request.form.get('commodity_supplier_name')
if (admin_validate(engine, username, password, department_name)):
data_model = commodity.Commodity(engine)
code = data_model.create_commodity(
code=commodity_code,
name=commodity_name,
type=commodity_type,
unit=commodity_unit,
specification=commodity_specification,
supplier_name=commodity_supplier_name)
if (code == SUCCESS):
return successful(data_model, {'code': code})
else:
return failed(data_model, {'code': code})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def add_in_storage_sheet_detail():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
in_storage_sheet_code = request.form.get('in_storage_sheet_code')
commodity_code = request.form.get('commodity_code')
number = request.form.get('number')
# 用户验证
if (storage_keeper_validate(engine, username, password, department)):
# 获取模型
data_model = in_storage_sheet_details.InStorageSheetDetail(engine)
statue = data_model.create_in_storage_sheet_detail(
in_storage_sheet_code=in_storage_sheet_code,
commodity_code=commodity_code,
number=number)
if (statue == SUCCESS):
return successful(data_model, {'code': statue})
else:
return failed(data_model, data={'code': statue})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def change_warehouse():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
# 修改信息
origin_warehouse_name = request.form.get('origin_warehouse_name')
dest_warehouse_name = request.form.get('dest_warehouse_name')
dest_warehouse_location = request.form.get('dest_warehouse_location')
dest_warehouse_manager_name = request.form.get(
'dest_warehouse_manager_name')
if (admin_validate(engine, username, password, department)):
data_model = warehouse.Warehouse(engine)
statue = data_model.change_warehouse(
origin_name=origin_warehouse_name,
dest_name=dest_warehouse_name,
dest_location=dest_warehouse_location,
dest_warehouse_manager_name=dest_warehouse_manager_name)
if (statue == SUCCESS):
return successful(data_model, {'code': statue})
else:
return failed(data_model, {'code': statue})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def add_in_storage_sheet():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
code = request.form.get('code')
order_sheet_code = request.form.get('order_sheet_code')
warehouse_name = request.form.get('warehouse_name')
in_storage_date = request.form.get('in_storage_date')
handler_name = request.form.get('handler_name')
# 用户验证
if (storage_keeper_validate(engine, username, password, department)):
# 获取模型
data_model = in_storage_sheet.InStorageSheet(engine)
statue = data_model.create_in_storage_sheet(
code=code,
order_sheet_code=order_sheet_code,
warehouse_name=warehouse_name,
in_storage_date=in_storage_date,
handler_name=handler_name)
if (statue == SUCCESS):
return successful(data_model, {'code': statue})
else:
return failed(data_model, data={'code': statue})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def delete_supplier():
try:
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
delete_supplier_name = request.form.get('delete_supplier_name')
if (admin_validate(engine, username, password, department)):
data_model = supplier.Supplier(engine)
statue = data_model.delete_supplier(
delete_supplier_name=delete_supplier_name)
if (statue == SUCCESS):
return successful(data_model, {'code': statue})
return successful(data_model, {'code': statue})
else:
return failed(data_model, {'code': statue})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def validate():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
# 获取模型
data_model = user.User(engine)
if (data_model.validate_by_origin_password(
name=username, password=password, department_name=department)):
data = data_model.get_password(username)
return successful(data_model, data)
else:
return failed(data_model, {})
except Exception as e:
print(e)
return exception()
def get_all_commodities():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department_name = request.form.get('department_name')
if (admin_validate(engine, username, password, department_name)):
data_model = commodity.Commodity(engine)
result = data_model.get_all_commodities()
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, {'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def get_all_warehouses():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
if (manager_validate(engine, username, password, department)):
data_model = warehouse.Warehouse(engine)
result = data_model.get_all_warehouses()
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, {'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def delete_commodity():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department_name = request.form.get('department_name')
# 删除信息
delete_commodity_code = request.form.get('delete_commodity_code')
if (admin_validate(engine, username, password, department_name)):
data_model = commodity.Commodity(engine)
code = data_model.delete_commodity(code=delete_commodity_code)
if (code == SUCCESS):
return successful(data_model, {'code': code})
else:
return failed(data_model, {'code': code})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def get_all_user_in_department():
try:
# 认证信息
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
query_department = request.form.get('query_department')
# 获取模型
if (admin_validate(engine, username, password, department)):
data_model = user.User(engine)
result = data_model.get_all_user_in_department(query_department)
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, {'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def get_warehouse_by_manager_name():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
# 用户验证
if (storage_keeper_validate(engine, username, password, department)):
# 获取模型
data_model = warehouse.Warehouse(engine)
result = data_model.get_warehouse_by_manager_name(username)
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, data={'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def get_all_notice_sheets():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
# 用户验证
if (manager_validate(engine, username, password, department)):
# 获取模型
data_model = notice_sheet.NoticeSheet(engine)
result = data_model.get_all_notice_sheets()
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, data={'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def add_supplier():
try:
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
supplier_name = request.form.get('supplier_name')
supplier_contact = request.form.get('supplier_contact')
if (admin_validate(engine, username, password, department)):
data_model = supplier.Supplier(engine)
code = data_model.create_supplier(name=supplier_name,
contact=supplier_contact)
if (code == SUCCESS):
return successful(data_model, {'code': code})
else:
return failed(data_model, {'code': code})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def get_order_sheet_details():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department = request.form.get('department')
order_sheet_code = request.form.get('order_sheet_code')
# 用户验证
if (storage_keeper_validate(engine, username, password, department)):
# 获取模型
data_model = order_sheet_details.OrderSheetDetail(engine)
result = data_model.get_order_sheet_by_order_sheet_code(
order_sheet_code)
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, data={'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
def add_order_sheet():
try:
# 从客户端获取数据
username = request.form.get('username')
password = request.form.get('password')
department_name = request.form.get('department_name')
code = request.form.get('code')
notice_sheet_code = request.form.get('notice_sheet_code')
warehouse_name = request.form.get('warehouse_name')
order_man_name = request.form.get('order_man_name')
delivery_date = request.form.get('delivery_date')
order_date = request.form.get('order_date')
statue = request.form.get('statue')
handler_name = request.form.get('handler_name')
# 用户验证
if (storage_keeper_validate(engine, username, password,
department_name)):
# 获取模型
data_model = order_sheet.OrderSheet(engine)
result = data_model.create_order_sheet(
code=code,
notice_sheet_code=notice_sheet_code,
warehouse_name=warehouse_name,
order_man_name=order_man_name,
delivery_date=delivery_date,
order_date=order_date,
statue=statue,
handler_name=handler_name)
if (result != UNKNOWN_ERROR):
return successful(data_model, result)
else:
return failed(data_model, data={'code': result})
else:
return validate_not_pass()
except Exception as e:
print(e)
return exception()
def get_all_departments():
data_model = department.Department()
data = data_model.get_all_departments()
return successful(data_model, data)
