def find_employees():
first_name = request.args.get('first_name')
last_name = request.args.get('last_name')
orderCriteria = request.args.get('order_by')
queryBuilder = EmployeeQueryBuilder()
query = queryBuilder \
.first_name(first_name) \
.last_name(last_name) \
.order_by_last_name(orderCriteria == 'last_name') \
.build()
employeeRepo = BaseRepo()
customers = employeeRepo.find_all(query)
return customers
def find_customers():
first_name = request.args.get('first_name')
last_name = request.args.get('last_name')
orderCriteria = request.args.get('order_by')
queryBuilder = CustomerQueryBuilder()
query = queryBuilder \
.first_name(first_name) \
.last_name(last_name) \
.order_by_credit_limit(orderCriteria == 'credit_limit') \
.build()
customerRepo = BaseRepo()
customers = customerRepo.find_all(query)
return customers
def find_orders():
cust_first_name = request.args.get('first_name')
cust_last_name = request.args.get('last_name')
orderCriteria = request.args.get('order_by')
queryBuilder = OrderQueryBuilder()
query = queryBuilder \
.cust_first_name(cust_first_name) \
.cust_last_name(cust_last_name) \
.order_by_date(orderCriteria == 'date') \
.order_by_cust_last_name(orderCriteria == 'last_name') \
.build()
orderRepo = BaseRepo()
customers = orderRepo.find_all(query)
return customers
