def maint_call_call(request):
if request.POST:
machinenum = request.POST.get("machine")
problem = request.POST.get("reason")
priority = request.POST.get("priority")
name_who = request.POST.get["whoisonit"]
# call external function to produce datetime.datetime.now()
t = vacation_temp()
# Select prodrptdb db located in views_db
db, cur = db_set(request)
cur.execute('''INSERT INTO pr_downtime1(machinenum,problem,priority,whoisonit,called4helptime) VALUES(%s,%s,%s,%s,%s)''', (machinenum,problem,priority,name_who,t))
db.commit()
db.close()
return done_maint_app(request)
else:
request.session["machinenum"] = "692"
form = sup_downForm()
args = {}
args.update(csrf(request))
args['form'] = form
rlist = machine_list_display()
request.session["refresh_maint"] = 3
return render(request,'maint_call.html', {'List':rlist,'args':args})
return render(request,'maint_call.html')
def maint_close_item(request): index=request.session["index"] db, cur = db_set(request) tc = "Closed by Maintenance" request.session["tech_comment"] = tc t = vacation_temp() sql =( 'update pr_downtime1 SET remedy="%s" WHERE idnumber="%s"' % (tc,index)) cur.execute(sql) db.commit() tql =( 'update pr_downtime1 SET completedtime="%s" WHERE idnumber="%s"' % (t,index)) cur.execute(tql) db.commit() db.close() return render(request,"redirect_maint.html")
def maintenance_close(request): index = request.session["index"] tc = "Closed by Maintenance Mgr" t = vacation_temp() db, cursor = db_set(request) cur = db.cursor() sql =( 'update pr_downtime1 SET remedy="%s" WHERE idnumber="%s"' % (tc,index)) cur.execute(sql) db.commit() tql =( 'update pr_downtime1 SET completedtime="%s" WHERE idnumber="%s"' % (t,index)) cur.execute(tql) db.commit() db.close() return render(request,'redirect_maint_mgmt.html')
def maint_job_history(request):
name = request.session["login_maint"]
db, cursor = db_set(request)
sql = "SELECT * FROM pr_downtime1 WHERE whoisonit_full LIKE '%s' ORDER BY called4helptime DESC limit 60" %("%" + name + "%")
cursor.execute(sql)
tmp = cursor.fetchall()
db.close
job_assn = []
job_date = []
job_diff = []
a = []
b = []
c = []
d = []
for x in tmp:
# assign job date and time to dt
dt = x[2]
dt_t = time.mktime(dt.timetuple())
# assign current date and time to dtemp
dtemp = vacation_temp()
dtemp_t = time.mktime(dtemp.timetuple())
# assign d_diff to difference in unix
d_dif = dtemp_t - dt_t
if d_dif < 86400:
job_assn.append(x[0])
job_date.append(x[2])
a.append(x[1])
b.append(x[4])
c.append(x[7])
d.append(x[9])
job_diff.append(str(d_dif))
job_history = zip(job_assn,a,job_date,b,c,d)
machine="Recent Machine Breakdowns"
request.session["machine_search"] = machine
request.session["maint_display"] = 1
return render(request,"maint_job_history_display.html",{'machine':job_history})
def forklift_close_item(request):
index = request.session["forklift_index"]
driver = request.session["forklift_login_name"]
db, cur = db_set(request)
t = vacation_temp()
tc = 1
sql = ('update tkb_forklift SET closed="%s" WHERE Id="%s"' % (tc, index))
cur.execute(sql)
db.commit()
tql = ('update tkb_forklift SET received_time="%s" WHERE Id="%s"' %
(t, index))
cur.execute(tql)
db.commit()
tql = ('update tkb_forklift SET driver="%s" WHERE Id="%s"' %
(driver, index))
cur.execute(tql)
db.commit()
db.close()
return render(request, "redirect_forklift.html")
def maint_job_entry(request):
if request.POST:
machinenum = request.POST.get("machine")
problem = request.POST.get("reason")
priority = request.POST.get("priority")
priority = 30000
whoisonit = 'Millwright'
# take comment into tx and ensure no "" exist. If they do change them to ''
tx = problem
tx = ' ' + tx
tps = list(tx)
# Genius appostrophe fix
problem = hyphon_fix(tx)
t = vacation_temp()
db, cur = db_set(request)
asset_test = machinenum[:4]
side1 = '0'
location1='G'
side2 = '0'
try:
asset3 = machinenum[:4]
asset2 = machinenum[:3]
try:
int(asset3)
asset4 = asset3
except:
asset4 = asset2
aql = "SELECT * FROM vw_asset_eam_lp where left(Asset,4) = '%s'" %(asset4)
cur.execute(aql)
tmp2 = cur.fetchall()
tmp3 = tmp2[0]
asset5 = tmp3[1] + " - " + tmp3[3]
location1 = tmp3[3]
except:
asset5 = machinenum
try:
bql = "SELECT priority FROM tkb_asset_priority where asset_num = '%s'" % (asset4)
cur.execute(bql)
tmp2 = cur.fetchall()
tmp3 = tmp2[0]
except:
tmp3 = 999
try:
priority = tmp3[0]
except:
priority = 999
if problem[-3:] == 'WFP':
priority = 10000
elif problem[-7:] == 'Project':
priority = 5000
# This will determine side of asset and put in breakdown
location_check = location1[:1]
if location_check < 'G':
side1 = '2'
elif location_check > 'G':
side1 = '1'
else:
side1 = '0'
try:
cur.execute('''INSERT INTO pr_downtime1(machinenum,problem,priority,whoisonit,called4helptime,side) VALUES(%s,%s,%s,%s,%s,%s)''', (asset5,problem,priority,whoisonit,t,side1))
db.commit()
db.close()
except:
cur.execute("Alter Table pr_downtime1 ADD Column side VARCHAR(100) DEFAULT '0'") #% (side2) # Add a Column
db.commit()
cur.execute('''INSERT INTO pr_downtime1(machinenum,problem,priority,whoisonit,called4helptime,side) VALUES(%s,%s,%s,%s,%s,%s)''', (asset5,problem,priority,whoisonit,t,side1))
db.commit()
db.close()
return render(request,'redirect_maint_mgmt.html')
else:
request.session["machinenum"] = "692"
form = sup_downForm()
args = {}
args.update(csrf(request))
args['form'] = form
rlist = machine_list_display()
return render(request,'maintenance_down.html', {'List':rlist,'args':args})