def add_password(self, name, password_string):
password = Password()
password.username = name
password.password = self.hash_password(password_string)
qry = db_session()
qry.add(password)
qry.commit()
def archive(self, form):
dt = datetime.datetime.now()
barcode = form.part_number.data
self.due_date = self.preprocess_date(form.due_date.data) # Manual
self.job_number = self.get_job_number(barcode).upper() # Manual
self.work_number = self.get_work_order(barcode) # Manual
self.part_number = self.get_part_number()
self.part_description = self.get_description() # Jobscope
try:
self.part_quantity = self.get_quantity() # Jobscope
except Exception as e:
print(str(e))
self.part_quantity = 0
self.part_location = request.cookies.get('location').upper() # Auto
self.entry_time = dt.strftime("%H:%M:%S") # Auto
self.entry_date = datetime.date.today() # Auto
self.comments = form.comments.data.upper() # Manual
if form.revision.data == '':
self.revision = self.get_revision().upper()
else:
self.revision = form.revision.data.upper() # Manual
self.machine_center = self.get_machine_center(
) # schedule.get_machine_center() # Manual
self.original_estimated_time = form.original_estimated_time.data.upper(
) # Time Estimate ( Manual )
self.quantity_complete = form.quantity_complete.data # Manual
self.actual_time = self.get_actual_time() # Jobscope
self.priority = request.form['priority']
self.material_status = request.form['status'].upper()
if self.quantity_complete != self.part_quantity:
self.archived = 0
else:
self.archived = 1
self.finish = request.form['finish']
self.pdf = self.get_pdf()
try:
self.location_deleted = request.cookies.get('location').upper()
except Exception as e:
print(e)
self.date_deleted = datetime.date.today()
qry = db_session()
qry.add(self)
qry.commit()
if self.quantity_complete != self.part_quantity:
# Archive all other entries with the same info
con = sqlite3.connect("scheduler.db")
cur = con.cursor()
sql = "UPDATE schedule SET archived=1 " \
"WHERE part_number = '" + str(self.part_number) + \
"' AND job_number = '" + str(self.job_number) + \
"' AND work_number = '" + str(self.work_number) + "'"
cur.execute(sql)
con.commit()
def archive(self):
self.archived = 1
self.date_deleted = datetime.date.today()
try:
self.location_deleted = request.cookies.get('location').upper()
except Exception as e:
self.location_deleted = 'Not set'
print(e)
qry = db_session()
qry.add(self)
qry.commit()
def register():
try:
if request.method == 'POST':
user = User()
username = request.form['username']
email = request.form['email']
password = request.form['pass']
confirm_password = request.form['confirm_pass']
qry = db_session.query(User).filter(User.username == username)
qry_email = db_session.query(User).filter(User.email == email)
qry = qry.first()
qry_email = qry_email.first()
if qry is not None or qry_email is not None:
flash(
'Username/email is already taken, please choose another.')
return render_template('register.html')
if not validate_email(email):
flash("Invalid email address.")
return render_template('register.html')
if email[-17:] != '@cvdequipment.com':
flash('Please enter a valid CVD email address')
return render_template('register.html')
if password != confirm_password:
flash('Passwords do not match.')
return render_template('register.html')
user.username = username
user.email = email
user.password = user.hash_password(password)
qry = db_session()
qry.add(user)
qry.commit()
flash("Registration Successful")
session['logged_in'] = True
session['username'] = username
user.set_permission_level()
return redirect(url_for('index'))
except Exception as e:
return str(e)
return render_template('register.html')
def edit_entry(self, form, schedule):
schedule.due_date = self.preprocess_date(form.due_date.data) # Manual
schedule.comments = form.comments.data.upper() # Manual
schedule.revision = form.revision.data.upper() # Manual
schedule.original_estimated_time = form.original_estimated_time.data.upper(
) # Time Estimate ( Manual )
schedule.quantity_complete = form.quantity_complete.data # Manual
schedule.priority = request.form['priority']
schedule.material_status = request.form['material_status'].upper()
schedule.machine_center = request.form['work_center']
qry = db_session()
qry.add(schedule)
qry.commit()
def save_changes(self, form):
dt = datetime.datetime.now()
barcode = form.part_number.data
self.due_date = self.preprocess_date(form.due_date.data) # Manual
self.job_number = self.get_job_number(barcode).upper() # Manual
self.work_number = self.get_work_order(barcode) # Manual
self.part_number = self.get_part_number()
self.part_description = self.get_description() # Jobscope
try:
self.part_quantity = self.get_quantity() # Jobscope
except Exception as e:
print(str(e))
self.part_quantity = 0
self.part_location = "MSO" # request.cookies.get('location').upper() # Auto
self.entry_time = dt.strftime("%H:%M:%S") # Auto
self.entry_date = datetime.date.today() # Auto
self.comments = form.comments.data.upper() # Manual
if form.revision.data == '':
self.revision = self.get_revision().upper()
else:
self.revision = form.revision.data.upper() # Manual
self.machine_center = form.work_center.data.upper(
) # schedule.get_machine_center() # Manual
self.original_estimated_time = form.original_estimated_time.data.upper(
) # Time Estimate ( Manual )
self.quantity_complete = form.quantity_complete.data # Manual
self.actual_time = self.get_actual_time() # Jobscope
if request.form['priority']:
self.priority = request.form['priority']
else:
self.priority = '99'
self.material_status = request.form['status'].upper()
self.archived = 0
self.finish = request.form['finish']
self.pdf = self.get_pdf()
qry = db_session()
qry.add(self)
qry.commit()
dt = datetime.datetime.now()
barcode = df.iloc[i].values[0]
schedule.due_date = datetime.date(2019, 8, 6)
schedule.job_number = schedule.get_job_number(
barcode).upper() # Manual
schedule.work_number = schedule.get_work_order(barcode) # Manual
schedule.part_number = schedule.get_part_number()
schedule.part_description = schedule.get_description() # Jobscope
try:
schedule.part_quantity = schedule.get_quantity() # Jobscope
except Exception as e:
print(str(e))
schedule.part_quantity = 0
schedule.part_location = 'Machine Shop' # Auto
schedule.entry_time = dt.strftime("%H:%M:%S") # Auto
schedule.entry_date = datetime.date.today() # Auto
schedule.machine_center = schedule.get_machine_center(
) # schedule.get_machine_center() # Manual
schedule.actual_time = schedule.get_actual_time() # Jobscope
schedule.archived = 0
schedule.pdf = schedule.get_pdf()
qry = db_session()
qry.add(schedule)
qry.commit()
except:
print('failed ' + df.iloc[i].values[0])