class temp_tool_costs(db.Model): id = db.Column(db.Integer(), primary_key=True) Service = db.Column(db.String(length=30), nullable=False, unique=True) UnitPrice = db.Column(db.Integer(), nullable=False) RentalMode = db.Column(db.String(), nullable=False) RentalPeriod = db.Column(db.String(), nullable=False) Remark = db.Column(db.String(length=60), nullable=False) Sum = db.Column(db.Integer(), nullable=False)
class static_lead_times(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) plant_type = db.Column(db.String()) team = db.Column(db.String()) group_scope_of_work = db.Column(db.String()) scope_of_work = db.Column(db.String()) work_time = db.Column(db.Integer()) work_time_unit = db.Column(db.String())
class temp_staff_costs(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) Service = db.Column(db.String(length=30), nullable=False, unique=True) UnitPrice = db.Column(db.Integer(), nullable=False) RentalMode = db.Column(db.String(), nullable=False) RentalUnits = db.Column(db.String(), nullable=False) Remark = db.Column(db.String(length=60), nullable=False) Sum = db.Column(db.Integer(), nullable=False)
class gantt(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) Task = db.Column(db.String()) Start = db.Column(db.String()) Finish = db.Column(db.String()) Resource = db.Column(db.String())
class static_costs_staff(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) service = db.Column(db.String()) price_reg_inquiry_RC = db.Column(db.String()) price_reg_inquiry_OE = db.Column(db.String()) price_reg_inquiry_RC_DE = db.Column(db.String())
class project_info(db.Model): id = db.Column(db.Integer(), primary_key=True) project_name = db.Column(db.String(), unique=True) project_manager_dept = db.Column(db.String()) order_indicator = db.Column(db.String()) site = db.Column(db.String()) customer = db.Column(db.String()) ## further info calc_for = db.Column(db.String()) date = db.Column(db.String()) cost_determination = db.Column(db.String()) editor = db.Column(db.String()) project_id = db.Column(db.String()) ## plant info plant_type = db.Column(db.String()) busbar = db.Column(db.String()) number_of_bays = db.Column(db.Integer())
class dropdown_elements(db.Model): id = db.Column(db.Integer(), primary_key=True) plant_type = db.Column(db.String()) busbar = db.Column(db.String()) calc_for = db.Column(db.String()) yes_no = db.Column(db.String()) languages = db.Column(db.String()) #check database rental_mode = db.Column(db.String())
class temp_project_info(db.Model): __bind_key__ = 'local' ### inquiry info id = db.Column(db.Integer(), primary_key=True) first_name = db.Column(db.String()) last_name = db.Column(db.String()) department = db.Column(db.String()) project_name = db.Column(db.String()) country = db.Column(db.String()) city = db.Column(db.String()) inquiry_date = db.Column(db.String()) plant_type = db.Column(db.String()) validity = db.Column(db.String()) protection_class_indoor = db.Column(db.String()) protection_class_outdoor = db.Column(db.String()) calc_for = db.Column(db.String()) busbar = db.Column(db.String()) number_of_bays = db.Column(db.String()) supervision = db.Column(db.String()) commissioning = db.Column(db.String()) mpd = db.Column(db.String()) language = db.Column(db.String()) tools = db.Column(db.String()) hv_test_equipment = db.Column(db.String()) transport = db.Column(db.String()) sec_works = db.Column(db.String()) sec_works_no_of_bays = db.Column(db.String()) earthing = db.Column(db.String()) pd_measurement = db.Column(db.String()) psd = db.Column(db.String()) actas = db.Column(db.String()) libo = db.Column(db.String()) customer_training = db.Column(db.String()) indoor_crane = db.Column(db.String()) dc_supply = db.Column(db.String()) hv_plugs = db.Column(db.String()) hv_plug_size = db.Column(db.String()) remark = db.Column(db.String()) offer_until = db.Column(db.String()) kick_off_meeting = db.Column(db.String()) ### project page info project_id = db.Column(db.String()) order_indicator = db.Column(db.String()) customer = db.Column(db.String()) date_of_editing = db.Column(db.String()) editor = db.Column(db.String()) def __repr__(self): return f'project_info {self.name}'
class dropdown_elements(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) plant_type = db.Column(db.String()) busbar = db.Column(db.String()) calc_for = db.Column(db.String()) yes_no = db.Column(db.String()) languages = db.Column(db.String()) hvt_pd_check = db.Column(db.String()) sec_wiring = db.Column(db.String()) protect_class_indoor = db.Column(db.String()) protect_class_outdoor = db.Column(db.String()) rental_mode = db.Column(db.String()) rental_mode_day = db.Column(db.String()) rental_mode_week = db.Column(db.String()) hv_plugs = db.Column(db.String()) hv_plug_size = db.Column(db.String()) actas = db.Column(db.String()) years = db.Column(db.String())
class User(db.Model, UserMixin): id = db.Column(db.Integer(), primary_key=True) username = db.Column(db.String(length=30), nullable=False, unique=True) email_address = db.Column(db.String(length=50), nullable=False, unique=True) password_hash = db.Column(db.String(length=60), nullable=False) @property def password(self): return self.password @password.setter def password(self, plain_text_password): self.password_hash = bcrypt.generate_password_hash( plain_text_password).decode('utf-8') def check_password_correction(self, attempted_password): return bcrypt.check_password_hash(self.password_hash, attempted_password)
class static_costs_commissioning_tools(db.Model): id = db.Column(db.Integer(), primary_key=True) service = db.Column(db.String())
class static_costs_staff(db.Model): id = db.Column(db.Integer(), primary_key=True) service = db.Column(db.String())
class temp_group_scope_of_work(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) team = db.Column(db.String()) group_scope_of_work = db.Column(db.String())
class collected_projects(db.Model): __bind_key__ = 'shared' ### inquiry info id = db.Column(db.Integer(), primary_key=True) first_name = db.Column(db.String()) last_name = db.Column(db.String()) department = db.Column(db.String()) project_name = db.Column(db.String(), unique=True) country = db.Column(db.String()) city = db.Column(db.String()) inquiry_date = db.Column(db.String()) plant_type = db.Column(db.String()) validity = db.Column(db.String()) protection_class_indoor = db.Column(db.String()) protection_class_outdoor = db.Column(db.String()) calc_for = db.Column(db.String()) busbar = db.Column(db.String()) number_of_bays = db.Column(db.String()) supervision = db.Column(db.String()) commissioning = db.Column(db.String()) mpd = db.Column(db.String()) language = db.Column(db.String()) tools = db.Column(db.String()) hv_test_equipment = db.Column(db.String()) transport = db.Column(db.String()) sec_works = db.Column(db.String()) sec_works_no_of_bays = db.Column(db.String()) earthing = db.Column(db.String()) pd_measurement = db.Column(db.String()) psd = db.Column(db.String()) actas = db.Column(db.String()) libo = db.Column(db.String()) customer_training = db.Column(db.String()) indoor_crane = db.Column(db.String()) dc_supply = db.Column(db.String()) hv_plugs = db.Column(db.String()) hv_plug_size = db.Column(db.String()) remark = db.Column(db.String()) offer_until = db.Column(db.String()) kick_off_meeting = db.Column(db.String()) ### project page info project_id = db.Column(db.String(), unique=True) order_indicator = db.Column(db.String()) customer = db.Column(db.String()) date_of_editing = db.Column(db.String()) editor = db.Column(db.String()) # gascomp_empty = StringField(label='Gas compartments (empty)') # gascomp_pref = StringField(label='Gas compartments (prefilled)') # assembly_indoor = StringField(label='Assembly (indoor)') # assembly_outdoor = StringField(label='Assembly (outdoor)') # harting_plugs = StringField(label='Harting plugs') # ditec_seals = StringField(label='Ditec seals') # steel_supp_s = StringField(label='Steel support (small)') # steel_supp_m = StringField(label='Steel support (medium)') # steel_supp_l = StringField(label='Steel support (large)') # drives = StringField(label='Drives') # core_drilling = StringField(label='Core drillings') # converter = StringField(label='Converters') # outdoor_bushing= StringField(label='Outdoor bushings') # ## general info # workdays_per_week = IntegerField(label='Workdays per week') # hours_per_day = IntegerField(label='Hours per day') # number_of_site_manager = IntegerField(label='Number of site managers') # number_of_commissioning_engineers = IntegerField(label='Number of commissioning engineers') # transport_weeks_tools = IntegerField(label='Transport weeks for tools') # transport_weeks_HVTE = IntegerField(label='Transport weeks for HV-Test equipment') # arrival_departure_days = IntegerField(label='Arrival and departure days') # country_factor = IntegerField(label='Country factor') # customer_training_days = IntegerField(label='Customer training days') # # inquiry info # site_management = SelectField(u'Site management', coerce=str) # commissioning = SelectField(u'Commissioning', coerce=str) # manpower = SelectField(u'Manpower diagramm', coerce=str) # manpower_language = SelectField(u'Language', coerce=str) # tools = SelectField(u'Tools', coerce=str) def __repr__(self): return f'project_info {self.name}'
class static_costs_travel_accommodation(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) service = db.Column(db.String())
class static_costs_testing_tools(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) service = db.Column(db.String())
class static_costs_installation_tools(db.Model): id = db.Column(db.Integer(), primary_key=True) service = db.Column(db.String())
class static_costs_site_equipment(db.Model): __bind_key__ = 'local' id = db.Column(db.Integer(), primary_key=True) service = db.Column(db.String())