def product_edit(product_id):
if request.method == 'GET' and session['usertype'] == 1:
obj = forms.Product()
data = obj.Product_select(product_id, '')
obj2 = forms.Provider()
data2 = obj2.Provider_name_select()
data2 = functions.group(data2, 2)
data = [[data], [data2]]
data.append(obj.Product_provider_id(product_id))
return render_template('product_Edit.html', data=data)
if request.method == 'POST' and session['usertype'] == 1:
if (request.form['submit_button'] == 'Submit'):
product_name = request.form.get('product_name')
product_brand = request.form.get('product_brand')
product_sellprice = request.form.get('product_sellprice')
provider_id = request.form.get('provider_id')
product_weight = request.form.get('product_weight')
obj = forms.Product()
obj.Product_edit(product_id, product_name, product_brand,
product_sellprice, provider_id, product_weight)
return redirect(url_for('product_list'))
elif (request.form['submit_button'] == 'Homepage'):
return redirect(url_for('home_page'))
else:
return redirect(url_for('home_page', error='You are not Authorized'))
def product_list():
if request.method == 'GET' and session['usertype'] == 1:
return render_template('product_list.html')
elif request.method == 'POST' and session['usertype'] == 1:
if (request.form['submit_button'] == 'Delete Selected'):
option = request.form['options']
obj = forms.Product()
obj.Product_delete(option)
return redirect(url_for('product_list'))
elif (request.form['submit_button'] == 'Edit Selected'):
option = request.form['options']
return redirect(url_for('product_edit', product_id=option))
elif (request.form['submit_button'] == 'Submit'):
product_id = request.form.get('product_id')
product_name = request.form.get('product_name')
obj = forms.Product()
data = obj.Product_select(product_id, product_name)
return render_template('product_list.html', data=data)
elif (request.form['submit_button'] == 'Homepage'):
return redirect(url_for('home_page'))
else:
return redirect(url_for('home_page', error='You are not Authorized'))
def order_information(product_id):
if request.method == 'GET':
obj = forms.Product()
data = obj.Product_select(product_id, '')
data = [data[0][0], data[0][1], data[0][2], data[0][3]]
obj2 = forms.MarketPlace()
data2 = obj2.MarketPlace_select('*', '')
obj3 = forms.CargoCompany()
data3 = obj3.cargo_select('*', '')
data = [[data], [data2], [data3]]
print(data)
return render_template('order_information.html', data=data)
elif request.method == 'POST':
if (request.form['submit_button'] == 'Order'):
market_id = request.form.get('market_id')
cargo_id = request.form.get('cargo_id')
order_address = request.form.get('order_address')
customer_name = request.form.get('customer_name')
order_quantity = request.form.get('order_quantity')
order_date = datetime.now().strftime("%d/%m/%Y")
order_time = str(
int(datetime.now().strftime("%H")) * 60 +
int(datetime.now().strftime("%M")))
order_week_day = datetime.today().weekday() + 1
obj1 = forms.Employee()
employee_id = obj1.Employee_select_id(order_week_day,
order_time)[0]
obj2 = forms.Order()
obj2.temp_order(market_id, order_address, order_date,
customer_name, cargo_id, product_id,
order_quantity, employee_id, order_time)
return redirect(url_for('home_page'))
def supply_add():
if request.method == 'GET' and session['usertype'] == 1:
obj = forms.Provider()
data = obj.Provider_name_select()
data = functions.group(data, 2)
obj2 = forms.Product()
data2 = obj2.Product_name_select()
data = [[data], [data2]]
return render_template('supply_add.html', data=data)
if request.method == 'POST' and session['usertype'] == 1:
if (request.form['submit_button'] == 'Submit'):
provider_id = request.form.get('provider_id')
supply_price = request.form.get('supply_price')
supply_quantity = request.form.get('supply_quantity')
supply_time = datetime.now().strftime("%d/%m/%Y - %H:%M")
product_id = request.form.get('product_id')
obj = forms.Supply()
obj.Supply_add(provider_id, supply_price, supply_quantity,
supply_time, product_id)
obj2 = forms.Stock()
obj2.update_quantity(supply_quantity,
obj2.get_ID(product_id)[0][0])
obj3 = forms.Finance()
obj3.weBoughtSmth(obj.get_supplyID())
return redirect(url_for('supply_add'))
elif (request.form['submit_button'] == 'Homepage'):
return redirect(url_for('home_page'))
else:
return redirect(url_for('home_page', error='You are not Authorized'))
def product_add():
if request.method == 'GET' and session['usertype'] == 1:
obj = forms.Provider()
data = obj.Provider_name_select()
data = functions.group(data, 2)
return render_template('product_add.html', data=data)
if request.method == 'POST' and session['usertype'] == 1:
if (request.form['submit_button'] == 'Submit'):
product_name = request.form.get('product_name')
product_brand = request.form.get('product_brand')
product_sellprice = request.form.get('product_sellprice')
provider_id = request.form.get('provider_id')
product_weight = request.form.get('product_weight')
obj = forms.Product()
obj.Product_add(product_name, product_brand, product_sellprice,
provider_id, product_weight)
product_id = obj.Product_select('', product_name)[0][0]
obj2 = forms.Stock()
obj2.add_to_stock(product_id)
return redirect(url_for('product_add'))
elif (request.form['submit_button'] == 'Homepage'):
return redirect(url_for('home_page'))
else:
return redirect(url_for('home_page', error='You are not Authorized'))
def supply_list():
if request.method == 'GET' and session['usertype'] == 1:
obj = forms.Provider()
data = obj.Provider_name_select()
data = functions.group(data, 2)
obj2 = forms.Product()
data2 = obj2.Product_name_select()
data2 = functions.group(data2, 3)
data = [[data], [data2]]
return render_template('supply_list.html', data=data)
elif request.method == 'POST' and session['usertype'] == 1:
if (request.form['submit_button'] == 'Delete Selected'):
option = request.form['options']
obj = forms.Supply()
obj.Supply_delete(option)
return redirect(url_for('supply_list'))
elif (request.form['submit_button'] == 'Edit Selected'):
option = request.form['options']
return redirect(url_for('supply_edit', supply_id=option))
elif (request.form['submit_button'] == 'Submit'):
supply_id = request.form.get('supply_id')
product_id = request.form.get('product_id')
provider_id = request.form.get('provider_id')
obj = forms.Provider()
data = obj.Provider_name_select()
data = functions.group(data, 2)
obj2 = forms.Product()
data2 = obj2.Product_name_select()
data2 = functions.group(data2, 3)
obj3 = forms.Supply()
data3 = obj3.Supply_select(supply_id, product_id, provider_id)
if (type(data3) is not list or not data3):
data = [[data], [data2]]
else:
data = [[data], [data2], [data3]]
return render_template('supply_list.html', data=data)
elif (request.form['submit_button'] == 'Homepage'):
return redirect(url_for('home_page'))
else:
return redirect(url_for('home_page', error='You are not Authorized'))
def create_order():
if request.method == 'GET':
return render_template('create_order.html')
elif request.method == 'POST':
if (request.form['submit_button'] == 'Order Selected'):
option = request.form['options']
return redirect(url_for('order_information', product_id=option))
elif (request.form['submit_button'] == 'Submit'):
item_id = request.form.get('item_id')
item_name = request.form.get('item_name')
obj = forms.Product()
data = obj.Product_select(item_id, item_name)
return render_template('create_order.html', data=data)
elif (request.form['submit_button'] == 'Homepage'):
return redirect(url_for('home_page'))