def Profile(request):
if request.user.is_staff:
shift_manager = ShiftManager()
usernamequery = (str(request.user), )
name = shift_manager.getname(usernamequery)
totalgoal = shift_manager.totalgoal()
totaldid = shift_manager.totaldid()
remain = float(totalgoal) - float(totaldid)
args = {
'name': name,
'totalgoal': totalgoal,
'totaldid': totaldid,
'remain': remain
}
return render(request, 'base/managerpage.html', args)
else:
username = str(request.user)
usernamequery = (str(request.user), )
mydb = mysql.connector.connect(host="localhost",
user="******",
password='******',
database='flight_manager',
auth_plugin='mysql_native_password')
mycursor = mydb.cursor()
query = """
SELECT goal FROM flight_manager.air_crew WHERE personal_number = %s
"""
mycursor.execute(query, usernamequery)
results = mycursor.fetchall()
mydb.commit()
for row in results:
shift = str(row[0])
new_shift = Shift()
all_shifts = new_shift.ShowAllShifts()
if len(shift) == 0:
shift = '0'
air_crew = AirCrew()
future_shifts = air_crew.ShowFutureShifts(username)
name = air_crew.getname(usernamequery)
howmanydid = air_crew.howmanydid(username)
howmanytot = air_crew.howmanytot(usernamequery)
name = air_crew.getname(usernamequery)
try:
left = int(shift) - int(howmanydid[0])
except:
left = str('0')
finally:
args = {
'user': name,
'shifts': shift,
'all_shifts': all_shifts,
'howmanydid': howmanydid[0],
'left': left,
'shift': shift
}
return render(request, 'base/profile.html', args)
def airgoalsinfo(request):
air_crew = AirCrew()
username = request.GET.get('personal_num')
usernamequery = (str(username),)
name = air_crew.getname(usernamequery)
air_info = air_crew.ShowMyShifts(username)
args = {'air_info' : air_info, 'name':name}
return render(request, 'base/airgoalinfo1.html', args)
def contact(request):
aircrew = AirCrew()
user = aircrew.getname((str(request.user),))
if request.method == "POST":
form = ContactMe(request.POST)
if form.is_valid():
contact = Contact()
contact.personal_num = str(request.user)
contact.content = form.cleaned_data['content']
contact.insertcontent(contact.personal_num, contact.content)
return redirect('/profile')
else:
form = ContactMe()
args = {'form': form, 'user': user}
return render(request,'base/contact1.html',args)
def getletters(self):
mydb = mysql.connector.connect(host="us-cdbr-iron-east-01.cleardb.net", user="******",
password='******', database='heroku_947e29c06a5b4a3')
mycursor = mydb.cursor()
query = """
select * from contact
"""
mycursor.execute(query)
results = mycursor.fetchall()
mydb.commit()
mycursor.close()
letters = []
for row in results:
contact = Contact()
air_crew = AirCrew()
contact.personal_num = str(row[0])
personal_num = str(row[0]).capitalize()
contact.date = str(row[1])
contact.content = str(row[2])
contact.name = air_crew.getname((personal_num,))
letters.append(contact)
return letters
def getletters(self):
mydb = mysql.connector.connect(host="localhost",
user="******",
password='******',
database='flight_manager',
auth_plugin='mysql_native_password')
mycursor = mydb.cursor()
query = """
select * from flight_manager.contact
"""
mycursor.execute(query)
results = mycursor.fetchall()
mydb.commit()
letters = []
for row in results:
contact = Contact()
air_crew = AirCrew()
contact.personal_num = str(row[0])
personal_num = str(row[0]).capitalize()
contact.date = str(row[1])
contact.content = str(row[2])
contact.name = air_crew.getname((personal_num, ))
letters.append(contact)
return letters
