def post(self):
args = eld_post_parser.parse_args()
data = str(datetime.datetime.today().day) + "" + str(
datetime.datetime.today().month) + "" + str(
datetime.datetime.today().year)
thisdate_ = int(data)
previousmax = db.engine.execute(
'select max("Event_Code") from events where events.todays_log = %s and user_id = %s',
[int(data), args['user_id']])
try:
for i in previousmax:
data = i
data = data[0]
if (int(data) > 8):
eventrecord = 9
else:
eventrecord = data + 1
except Exception as e:
eventrecord = 1
event = Events(Event_Record_Status=1,
Event_Record_Origin=2,
Event_Type=4,
Event_Code=int(eventrecord),
Event_Date=datetime.datetime.now(),
Event_Time=datetime.datetime.now(),
user_id=args['user_id'],
todays_log=thisdate_)
db.session.add(event)
db.session.commit()
update = "Logs Have Been Certified for the " + str(
eventrecord) + "time"
return {"result": update}
def driving():
a = request.args.get('a', 0, type=int)
b = request.args.get('b', 0, type=int)
print("Driving")
if(datetime.datetime.today().day) < 10:
today_ = "0" + str(datetime.datetime.today().day)
else:
today_ = str(datetime.datetime.today().day)
todaysdate_ = str(today_) + "" + str(datetime.datetime.today().month) + "" + str(datetime.datetime.today().year)
db.engine.execute('update drivers set "Current_Status" = %s where user_id = %s', [1, current_user.get_id()])
db.session.commit()
event = Events(Event_Record_Status = 1, Event_Record_Origin = 2, Event_Type = 1, Event_Code = 3, Event_Date = datetime.datetime.now(), Event_Time = datetime.datetime.now(), todays_log = todaysdate_)
db.session.add(event)
db.session.commit()
#db.engine.execute('update drivers set "Current_Status" = %s where user_id = %s', [1, 1])
return jsonify(result="Driving")
def cleared():
a = request.args.get('a', 0, type=int)
b = request.args.get('b', 0, type=int)
try:
driverid_1 = db.engine.execute('select uid from drivers where user_id = %s', [current_user.get_id()])
for i in driverid_1 :
driver_id = i[0]
if (datetime.datetime.today().day) < 10:
today_ = "0" + str(datetime.datetime.today().day)
else:
today_ = str(datetime.datetime.today().day)
todaysdate_ = str(today_) + "" + str(datetime.datetime.today().month) + "" + str(datetime.datetime.today().year)
event = Events(Event_Record_Status = 1, Event_Record_Origin = 2, Event_Type = 3, Event_Code = 0, Event_Date = datetime.datetime.now(), Event_Time = datetime.datetime.now(), user_id = current_user.get_id(), todays_log = todaysdate_)
db.session.add(event)
db.session.commit()
except Exception as e:
print(e)
print("off duty")
return jsonify(result="Indication for PC, YM, and WT Cleared")
def post(self):
args = eld_post_parser.parse_args()
db.engine.execute(
'update drivers set "Current_Status" = %s where user_id = %s',
[int(args['status']), int(args['user_id'])])
todaysdate_ = str(str(datetime.datetime.today().day)) + "" + str(
datetime.datetime.today().month) + "" + str(
datetime.datetime.today().year)
event = Events(Event_Record_Status=1,
Event_Record_Origin=2,
Event_Type=3,
Event_Code=int(args['status']),
Event_Date=datetime.datetime.now(),
Event_Time=datetime.datetime.now(),
user_id=int(args['user_id']),
todays_log=todaysdate_)
db.session.add(event)
db.session.commit()
return {"result": "Success"}
def authorized():
"""Add two numbers server side, ridiculous but well..."""
a = request.args.get('a', 0, type=int)
b = request.args.get('b', 0, type=int)
try:
driverid_1 = db.engine.execute('select uid from drivers where user_id = %s', [current_user.get_id()])
for i in driverid_1 :
driver_id = i[0]
if (datetime.datetime.today().day) < 10:
today_ = "0" + str(datetime.datetime.today().day)
else:
today_ = str(datetime.datetime.today().day)
todaysdate_ = str(today_) + "" + str(datetime.datetime.today().month) + "" + str(datetime.datetime.today().year)
db.engine.execute('update drivers set "Current_Status" = %s where user_id = %s', [4, current_user.get_id()])
db.session.commit()
event = Events(Event_Record_Status = 1, Event_Record_Origin = 2, Event_Type = 3, Event_Code = 1, Event_Date = datetime.datetime.now(), Event_Time = datetime.datetime.now(), user_id = current_user.get_id(), device_id = driver_id, todays_log = todaysdate_)
db.session.add(event)
db.session.commit()
except Exception as e:
print(e)
return jsonify(result="Authorized Personal Use of CMV")
def certifylogscomplete():
certify = CertifyForm(request.form)
data =str(datetime.datetime.today().day) + "" + str(datetime.datetime.today().month) + "" + str(datetime.datetime.today().year)
thisdate_ = int(data)
previousmax = db.engine.execute('select max("Event_Code") from events where events.todays_log = %s and user_id = %s',[int(data), current_user.get_id()])
try:
for i in previousmax:
data = i
data = data[0]
if(int(data) > 8):
eventrecord = 9
else:
eventrecord = data + 1
except Exception as e:
eventrecord = 1
event = Events(Event_Record_Status = 1, Event_Record_Origin = 2, Event_Type = 4, Event_Code = int(eventrecord), Event_Date = datetime.datetime.now(), Event_Time = datetime.datetime.now(), user_id = current_user.get_id(), todays_log = thisdate_)
db.session.add(event)
db.session.commit()
#form = DriverForm(request.form)
return render_template('certifylogs.html', role = 1, certify = certify)
def log(msg):
event = Events(Event_Record_Status = 1, Event_Record_Origin = 2, Event_Type = 1, Event_Code = 3, Event_Date = datetime.datetime.now(), Event_Time = datetime.datetime.now())
db.session.add(event)
db.session.commit()
return msg
#This is the background daemon that constantly updates the database with the data that the ELD is streaming
import time
from webapp1.models import drivers, db, RPM, User, Events
driverstatuses = db.engine.execute("select * from drivers")
for i in driverstatuses:
print(i)
#Not sure why this is not working
#Seems to be broken because of UID,
newstatus = RPM(driver_id=i[0], status=i[7])
print(db.session.add(newstatus))
db.session.commit()
print(newstatus)
event = Events(Event_Record_Status=1,
Event_Record_Origin=2,
Event_Type=1,
Event_Code=3,
Event_Date=1,
Event_Time=datetime.datetime.now())
time.sleep(15)