def Add(self, company):
if session['user'] == 'ADMIN':
if request.method == 'POST':
Item_Name = request.form.get('Item_Name')
Price_Pi = request.form.get('Price_Pi')
Total_items = request.form.get('Total_items')
Total_Price = int(Price_Pi) * int(Total_items)
sold_items = request.form.get('sold_items')
available_items = int(Total_items) - int(sold_items)
sell_price = request.form.get('Sell')
Profit = (int(Total_items) *
int(sell_price)) - int(Total_Price)
DB_obj.add_item(company, Item_Name, Price_Pi, Total_Price,
Total_items, sold_items, available_items,
sell_price, Profit)
DB_obj.product_detail_view(St.T_Name1, company, 'Company_Name')
return render_template('t_stock_detail.html',
rows=DB_obj.Data,
company=company,
T_Name=St.T_Name1,
Data_update=St.Data_update)
DB_obj.product_detail_view(St.T_Name1, company, 'Company_Name')
return render_template('t_stock_detail.html',
rows=DB_obj.Data,
company=company,
T_Name=St.T_Name1)
else:
DB_obj.product_detail_view(St.T_Name1, company, 'Company_Name')
return render_template('t_stock_detail_local_user.html',
rows=DB_obj.Data,
company=company)
def Home(self):
if session['user'] == 'ADMIN':
if request.method == 'POST':
N_User = request.form.get('User')
N_Password = request.form.get('Password')
DB_obj.new_user(N_User, N_Password)
return render_template('Admin_home.html')
elif session['user'] == 'LOCAL':
return render_template('local_home.html')
def view(self):
if request.method == 'POST':
Name = request.form.get('Name')
# Adding New Company
DB_obj.Add_new(Name, St.T_Name)
# Collecting all Data
DB_obj.view(St.T_Name)
return render_template('t_stock.html',
rows=DB_obj.Data,
T_Name=St.T_Name)
DB_obj.view(St.T_Name)
return render_template('t_stock.html',
rows=DB_obj.Data,
T_Name=St.T_Name)
def view(self):
if session['user'] == 'ADMIN':
if request.method == 'POST':
Name = request.form.get('Name')
# Calling function for add new Local_store in the list
DB_obj.Add_new(Name, Local_store.T_Name)
DB_obj.view(Local_store.T_Name)
return render_template('local_store.html',
rows=DB_obj.Data,
T_Name=Local_store.T_Name)
DB_obj.view(Local_store.T_Name)
return render_template('local_store.html',
rows=DB_obj.Data,
T_Name=Local_store.T_Name)
else:
DB_obj.view(Local_store.T_Name)
return render_template('local_store_local_user.html',
rows=DB_obj.Data)
def view(self, institute):
try:
DB_obj.product_detail_view('Pending', institute, 'Name')
B.rows = DB_obj.Data
B.Total_Pending_Amount = B.rows[0][1]
except:
B.Total_Pending_Amount = 0
DB_obj.product_detail_view(B.T_Name, institute, 'Name')
B.rows = DB_obj.Data
return render_template('bill.html',
school=institute,
rows=B.rows,
Total_Pending_Amount=B.Total_Pending_Amount,
USER=session['user'])
def Login(self):
try:
if session['user']:
return redirect(url_for('Home'))
except:
if request.method == 'POST':
User = request.form.get('User')
Password = request.form.get('Password')
DB_obj.view(Log_handel.T_Name)
for i in DB_obj.Data:
if User == i[0] and Password == i[1]:
if User == 'admin':
session['user'] = '******'
return redirect(url_for('Home'))
else:
session['user'] = '******'
return redirect(url_for('Home'))
return render_template('login_page.html')
def view_invoice(self, id, index):
DB_obj.product_detail_view('bills', id, 'id')
rows = DB_obj.Data
rows_A = pickle.loads(rows[0][9])
rendered = render_template('invoice.html',
index=index,
rows=rows_A,
customer=rows[0][6],
pending=rows[0][4],
total=rows[0][2])
css = 'App/static/invoice.css'
pdf_gen = pdfkit.from_string(rendered, False, css=css)
response = make_response(pdf_gen)
response.headers['content-type'] = 'application/pdf'
response.headers[
'content-Disposition'] = 'inline; filename= output.pdf' # inline can be attachment
response.close()
return response
def update(self, table, Name):
DB_obj.product_detail_view(table, Name, 'Name')
St.Data_update = DB_obj.Data
return render_template('Update_Stock.html', Data_update=St.Data_update)
def all_users(self):
DB_obj.view('login')
rows = DB_obj.Data
return render_template('Users.html', rows=rows)
