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)