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_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 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 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_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_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_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 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_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 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 delete_warehouse(): try: username = request.form.get('username') password = request.form.get('password') department = request.form.get('department') delete_warehouse_name = request.form.get('delete_warehouse_name') if (admin_validate(engine, username, password, department)): data_model = warehouse.Warehouse(engine) statue = data_model.delete_warehouse(name=delete_warehouse_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 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 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 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 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 change_supplier(): try: username = request.form.get('username') password = request.form.get('password') department = request.form.get('department') origin_supplier_name = request.form.get('origin_supplier_name') dest_supplier_name = request.form.get('dest_supplier_name') dest_supplier_contact = request.form.get('dest_supplier_contact') if (admin_validate(engine, username, password, department)): data_model = supplier.Supplier(engine) statue = data_model.change_supplier(origin_supplier_name, dest_supplier_name, dest_supplier_contact) 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()