def supplyProducts():
# Redirected from unsuppliedproducts?
cust_id = request.args.get('cust_id')
data_to_populate = request.args.get('deliver_items_data')
# Yes, redirected from unsuppliedproducts
if cust_id:
cust_type_num = Customer.query.filter_by(id=cust_id).first().customer_type
if cust_type_num == CUSTOMER_TYPES['TYPE_AXM']:
custType = 'axm'
else:
custType = 'cust'
# No, redirected from newsupply
else:
if not session['new_supply']:
flash(gettext('No customer data!'))
return redirect(url_for("supplies"))
custType = session['new_supply'][0][1]
cust_id = session['new_supply'][1][1]
cust = Customer.query.filter_by(id=cust_id).first()
if not cust:
flash(gettext('Customer not found!'))
return redirect(url_for("supplies"))
if request.method == 'POST':
ids = {}
for attr in flask.request.form:
if attr.startswith("supp_qty-"):
key = attr.split('-')[1]
if flask.request.form[attr] != '0':
ids[key] = flask.request.form[attr]
if not ids:
flash(gettext('No product quantities!'))
return redirect(url_for("supplies"))
last_supply = Supply.query.filter_by(customer_id=cust_id).order_by(desc(Supply.created_dt)).first()
new_supply = Supply()
#TODO other date than now new_supply.created_dt =
new_supply.customer_id = cust_id
new_supply.user_id = g.user.id
db.session.add(new_supply)
db.session.commit()
#variable for reporting purposes
report = {'sender': g.user.nickname, 'customer': cust, 'date': new_supply.created_dt, 'order_no': cust.order_no, 'products': [],
'closed_requests': [], 'changed_requests': [], 'oversent_requests': False}
# For recommender notification mail
overall_product_value = 0
for id in ids:
new_quantity = int(ids[id])
if new_quantity > 0:
new_product = Product.query.filter_by(id=int(id)).first()
if new_product:
overall_product_value += new_product.price_retail * new_quantity
rp = SuppliedProducts(quantity=new_quantity)
rp.product = new_product
rp.supply_id = new_supply.id
new_supply.products.append(rp)
report_details = {'product': new_product, 'qty': new_quantity, 'over': 0}
temp_qty = new_quantity
#get requested products from current customer for product from oldest
all_products = new_product.request_assocs
requested_products = []
for p in all_products:
if p.request.customer_id == cust.id:
requested_products.append(p)
if not requested_products:
flash(gettext('No requested products!'))
return redirect(url_for("supplies"))
requested_products.sort(key=lambda x: x.request.created_dt, reverse=False)
for rp in requested_products:
#count requested products quantity - qty_supplied = delta qty
if rp.qty_supplied is None:
rp.qty_supplied = 0
delta_qty = rp.quantity - rp.qty_supplied
if delta_qty <= temp_qty:
if new_product.qty_stock is not None:
new_product.qty_stock -= (rp.quantity - rp.qty_supplied)
rp.qty_supplied = rp.quantity
#if request completely supplied add to report
if rp.request.active_flg:
if rp.request.check_completely_supplied():
while True:
if rp.request in report['changed_requests']:
report['changed_requests'].remove(rp.request)
else:
break
report['closed_requests'].append(rp.request)
else:
if rp.request not in report['changed_requests']:
report['changed_requests'].append(rp.request)
if delta_qty == temp_qty:
temp_qty = 0
break
else:
if new_product.qty_stock is not None:
new_product.qty_stock -= temp_qty
rp.qty_supplied += temp_qty
temp_qty -= rp.qty_supplied
if rp.request not in report['changed_requests']:
report['changed_requests'].append(rp.request)
break
temp_qty -= delta_qty
if temp_qty > 0:
if new_product.qty_stock is not None:
new_product.qty_stock -= temp_qty
report_details['over'] = temp_qty
report['oversent_requests'] = True
report['products'].append(report_details)
#set new nohinsho number if custType = customer
if cust.customer_type == CUSTOMER_TYPES['TYPE_CUSTOMER']:
if not cust.order_no:
cust.order_no = 1
else:
if last_supply:
date_old = datetime.datetime(*map(int, re.split('[^\d]', str(last_supply.created_dt))[:-1]))
date_new = datetime.datetime(*map(int, re.split('[^\d]', str(new_supply.created_dt))[:-1]))
if date_old.year == date_new.year:
if date_old.month == date_new.month:
cust.order_no += 1
else:
cust.order_no = 1
else:
cust.order_no = 1
db.session.add(cust)
#FINAL COMMIT
db.session.commit()
flash(gettext('New supply sent sucessfully.'))
print report
#prepare data for xls
product_ids=[]
for p in report['products']:
product_ids.append([p['product'].id, p['qty']])
session['new_supply_data'] = {'date': report['date'], 'customer': cust.id, 'products': product_ids}
# If this customer has a recommender-customer, send notification mail with supply price amount
if cust.recommender_id and cust.recommender_id is not '':
send_notification_mail_to_recommender(cust, overall_product_value)
return render_template('supplies/supplyReport.html',
title=gettext("Supply Report"),
custType=custType,
report=report)
requests = cust.requests.all()
products = []
for r in requests:
for rp in r.products:
if rp.product not in products:
rp.product.cust_request_qty = rp.product.customer_request_qty(cust.id)
if rp.product.cust_request_qty > 0:
products.append(rp.product)
products = sorted(products, key=lambda k: (k.maker_id, k.code))
for p in products:
urls = getImgUrls(p.id)
if urls:
p.img_url = urls[0]
# If AxM customer, check if the order is paid for
paid_for = True
if cust.customer_type == CUSTOMER_TYPES['TYPE_AXM']:
req = cust.requests.all()[0]
paid_for = req.paid_for_flg
return render_template('supplies/supplyProducts.html',
custType=custType,
customer=cust,
products=products,
paid_for=paid_for,
data_to_populate=data_to_populate)
