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