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')
