def viewComplete(jobID):
page = "JOB RECORD"
oplist = DB.getActiveOperators()
typeList = DB.getJobType()
workcellList = DB.getWorkCells()
result = DB.setUpdateForm(jobID)
endDate = result[0][15]
endDate = endDate[0:10]
job = {
'job ID': result[0][0],
'job name': result[0][1],
'work order': result[0][2],
'cell': result[0][3],
'cell ID': result[0][4],
'status': result[0][5],
'status ID': result[0][6],
'type': result[0][7],
'type ID': result[0][8],
'weight': result[0][9],
'activity ID': result[0][10],
'operator': result[0][11],
'operator ID': result[0][12],
'last op': result[0][13],
'notes': result[0][14],
'last activity': endDate
}
if request.method == 'POST':
now = datetime.now()
time = now.strftime('%I:%M %p')
date = now.strftime('%Y-%m-%d')
dbNotes = job['notes']
pageNotes = request.form['notes']
if (util.textHasChanged(dbNotes, pageNotes)):
alias = "SYS"
notes = pageNotes
addNote = util.appendTimeStamp(alias, notes)
else:
addNote = dbNotes
details = {'jobID': job['job ID'], 'notes': addNote}
DB.updateJobNotes(details)
return redirect(url_for('completedJobs'))
else:
return render_template('job_record.html',
job=job,
oplist=oplist,
page=page)
return render_template('job_record.html',
job=job,
oplist=oplist,
page=page)
def updateJob(jobID):
page = "UPDATE WORK IN PROCESS"
oplist = DB.getActiveOperators()
typeList = DB.getJobType()
workcellList = DB.getWorkCells()
result = DB.setUpdateForm(jobID)
job = {
'job ID': result[0][0],
'job name': result[0][1],
'work order': result[0][2],
'cell': result[0][3],
'cell ID': result[0][4],
'status': result[0][5],
'status ID': result[0][6],
'type': result[0][7],
'type ID': result[0][8],
'weight': result[0][9],
'activity ID': result[0][10],
'operator': result[0][11],
'operator ID': result[0][12],
'last op': result[0][13],
'notes': result[0][14],
'last activity': result[0][15],
}
operationValues = util.getAvailableOperationValues(job['last op'])
# #to be passed to the next operation combo box
errors = True
if request.method == 'POST':
errors = False
if not request.form['action']:
errors = True
if not request.form['operator']:
errors = True
if not request.form['next-operation']:
errors = True
if not errors:
now = datetime.now()
time = now.strftime('%I:%M %p')
date = now.strftime('%Y-%m-%d')
dbNotes = job['notes']
pageNotes = request.form['notes']
OperatorID = request.form['operator']
nextOperation = request.form['next-operation']
action = request.form['action']
status = action
if action == "7":
status = 1
if action == "2":
nextOperation = DB.getFinalOperationByID(job['job ID'])
alias = util.getUserAlias(OperatorID)
notes = pageNotes
addNote = util.appendTimeStamp(alias, notes, 'Job Completed')
# Note Handling
if (util.textHasChanged(dbNotes, pageNotes)):
alias = util.getUserAlias(OperatorID)
notes = pageNotes
if action == "2":
addNote = util.appendTimeStamp(alias, notes,
'Job Completed')
else:
addNote = util.appendTimeStamp(alias, notes)
else:
if action == "2":
alias = util.getUserAlias(OperatorID)
addNote = util.appendTimeStamp(alias, dbNotes,
'Job Completed')
else:
addNote = dbNotes
details = {
'jobID': job['job ID'],
'status': status,
'activity': action,
'notes': addNote,
'time': time,
'date': date,
'operation': nextOperation,
'operator': request.form['operator']
}
DB.logActivity(details)
if not (request.form['action']
== '2') and not (request.form['action'] == '5'):
time = ''
date = ''
DB.updateJobRecord(details)
details['job'] = job['job name']
details['work order'] = job['work order']
details['operator'] = DB.getOperatorByID(details['operator'])
details['status'] = DB.getStatusByID(details['status'])
page = "UPDATE SUCCESS"
return render_template('update_job_success.html',
details=details,
page=page)
#return redirect(url_for('index'))
else:
return render_template('update_job.html',
job=job,
oplist=oplist,
page=page,
operationValues=operationValues)
return render_template('update_job.html',
job=job,
oplist=oplist,
page=page,
operationValues=operationValues)
