def index(): vehicles = setConnection(["read_vehicles"]) drivers = setConnection(["read_drivers"]) customers = setConnection(["read_customers"]) return render_template('Mainboot.html', vehicles=vehicles, drivers=drivers, customers=customers)
def Expenditure(): data = setConnection(["expenseView"]) dataList = [] index = [] for x in data: index.append(x[0]) dataList.append(list(x)) for x in dataList: x.remove(x[0]) dataListNum = [] for x in dataList: col = [] for y in x: col.append(int(y)) dataListNum.append(col) # dataframe created with # the above data array df = pd.DataFrame( dataListNum, columns=['Insurance_Amt', 'Tax_Amt', 'Permit_Amt', 'Maintenance_Amt'], index=index) df.plot.bar() plt.show()
def driver_on_vehicle(): if request.method == 'POST': lis = [ "write_driverOnVehicle", request.form["veh_no"], request.form["driver_name"] ] flash(setConnection(lis)) return redirect(url_for('index'))
def add_dependent(driver_id): if request.method == 'POST': lis = [ "write_dependents", driver_id, request.form["nm"], request.form["rel"], request.form["cnt"] ] flash(setConnection(lis)) return redirect(url_for('driver', driver_id=driver_id))
def add_driver(): if request.method == 'POST': lis = [ "write_drivers", request.form["driver_name"], request.form["License_no"], request.form["contact_no"] ] flash(setConnection(lis)) return redirect(url_for('index'))
def tax(veh_no): if request.method == 'POST': lis = [ "write_taxes", veh_no, request.form["tno"], request.form["validf"], request.form["validu"], request.form["cost"] ] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def loan(veh_no): if request.method == 'POST': lis = [ "write_loans", veh_no, request.form["lno"], request.form["costt"], request.form["lcomp"], request.form["dur"], request.form["intr"] ] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def add_vehicle(): if request.method == 'POST': lis = [ "write_vehicles", request.form["veh_no"], request.form["chassis_no"], request.form["vehicle_class"], request.form["vehicle_capacity"] ] flash(setConnection(lis)) return redirect(url_for('index'))
def add_customer(): if request.method == 'POST': lis = [ "write_customers", request.form["Cus_name"], request.form["Comp_name"], request.form["Cus_contact"], request.form["Cus_address"] ] flash(setConnection(lis)) return redirect(url_for('index'))
def maintenance(veh_no): if request.method == 'POST': lis = [ "write_maintenance", veh_no, request.form["rmk"], request.form["plc"], request.form["cost"], request.form["vend"], request.form["dom"] ] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def add_trip_details(veh_no, trip_id): if request.method == 'POST': lis = [ "write_trip_details", trip_id, request.form["amt"], request.form["date_of_tran"], request.form["place"], request.form["reason"] ] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def insurance(veh_no): if request.method == 'POST': lis = [ "write_insurances", veh_no, request.form["ins_no"], request.form["validf"], request.form["validu"], request.form["cost"], request.form["icomp"] ] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def start_trip(veh_no): if request.method == 'POST': lis = [ "write_trips", veh_no, request.form["customer_name"], request.form["source"], request.form["destination"], request.form["cost"], request.form["freight"] ] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def liabilityasset(): dataT = setConnection(["profitloss"]) labels = [] Income_of_all_trips = [] Expenditure_of_the_year = [] data = [] for x in dataT: data.append(list(x)) for x in data: for n, i in enumerate(x): if i == None: x[n] = 0 print("##########", x) labels.append(x[0]) Income_of_all_trips.append(int(x[1])) Expenditure_of_the_year.append(int(x[2])) x = np.arange(len(labels)) # the label locations width = 0.35 # the width of the bars fig, ax = plt.subplots() rects1 = ax.bar(x - width / 2, Income_of_all_trips, width, label='Yearly Income') rects2 = ax.bar(x + width / 2, Expenditure_of_the_year, width, label='Yearly Expenditure') # Add some text for labels, title and custom x-axis tick labels, etc. ax.set_ylabel('Amount in Rs') ax.set_title('LIABILITY OR ASSET', bbox={'facecolor': '0.8', 'pad': 5}) ax.set_xticks(x) ax.set_xticklabels(labels) ax.legend() def autolabel(rects): """Attach a text label above each bar in *rects*, displaying its height.""" for rect in rects: height = rect.get_height() ax.annotate( '{}'.format(height), xy=(rect.get_x() + rect.get_width() / 2, height), xytext=(0, 3), # 3 points vertical offset textcoords="offset points", ha='center', va='bottom') autolabel(rects1) autolabel(rects2) fig.tight_layout() plt.show()
def Maintenance(): data = setConnection(["maintenanceCategory"]) Maintenance = [] amount = [] for x in data: Maintenance.append(x[0]) amount.append(x[1]) colors = ["#1f77b4", "#ff7f0e", "#2ca02c", "#d62728", "#9467bd", "#8c564b"] plt.pie(amount, labels=Maintenance, colors=colors, autopct='%1.1f%%', shadow=True, startangle=90) plt.title("MAINTENANCE", bbox={'facecolor': '0.8', 'pad': 5}) plt.show()
def vehicle(veh_no): vehicle = setConnection(["read_vehicle", veh_no]) customers = setConnection(["read_customers"]) tripDetail = setConnection(["read_tripDetails", veh_no]) loanProgress = setConnection(["read_loans", veh_no]) loanStatus = setConnection(["read_loanStatus", veh_no]) status = setConnection(["read_trips", veh_no]) status.append(0) loanProgress.append(0) return render_template('Vehicle.html', loanStatus=loanStatus, loanProgress=loanProgress, vehicle=vehicle, customers=customers, tripDetail=tripDetail, status=status)
def deleteDriver(driver_id): if request.method == 'POST': flash(setConnection(["delete_drivers", driver_id])) return redirect(url_for('index'))
def deleteVehicle(veh_no): if request.method == 'POST': flash(setConnection(["delete_vehicles", veh_no])) return redirect(url_for('index'))
def stop_trip(veh_no, trip_id): if request.method == 'POST': lis = ["update_trip", trip_id] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def invoice(trip_id): trip = setConnection(["read_tripByID", trip_id]) return render_template('invoice.html', trip=trip)
def add_salary(driver_id): if request.method == 'POST': lis = ["write_salary", driver_id, request.form["salary"]] flash(setConnection(lis)) return redirect(url_for('driver', driver_id=driver_id))
def pay_loan(veh_no, loan_no): if request.method == 'POST': lis = ["write_loanPayRegister", loan_no, request.form["emi"]] flash(setConnection(lis)) return redirect(url_for('vehicle', veh_no=veh_no))
def driver(driver_id): driver = setConnection(["read_driver", driver_id]) dependents = setConnection(["read_dependents", driver_id]) return render_template('Driver.html', driver=driver, dependents=dependents)
def logout(): flash(setConnection(["stop"])) return render_template('bye.html')