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