Beispiel #1
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_Employees'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.account = CharField(null=True, max_length=10)
     self.active = BoolField(default_value=True)
     self.address = CharField(null=True, max_length=150)
     self.address_adjunct = CharField(null=True, max_length=150)
     self.admission_date = DateField(display=DATE)
     self.agency = CharField(null=True, max_length=10)
     self.bank = CharField(null=True, max_length=50)
     self.born_date = DateField(null=True, display=DATE)
     self.cellphone = CharField(null=True, max_length=13, display=PHONE)
     self.city = CharField(null=True, max_length=50)
     self.civil_state = CharField(default_value='S', max_length=1)
     self.cnh = CharField(null=True, max_length=20)
     self.cnh_category = CharField(null=True, max_length=10)
     self.cpf = IntField(display=CPF)
     self.ctps = CharField(null=True, max_length=15)
     self.ctps_date = DateField(null=True, display=DATE)
     self.ctps_fu = CharField(null=True, max_length=2)
     self.ctps_series = CharField(null=True, max_length=10)
     self.demission_date = DateField(null=True, display=DATE)
     self.department = ForeignField(Department)
     self.enterprise = ForeignField(Enterprise)
     self.father_name = CharField(null=True, max_length=100)
     self.fu = CharField(null=True, max_length=2)
     self.graduation = CharField(null=True)
     self.meal_on_enterprise = BoolField(default_value=False)
     self.mother_name = CharField(null=True, max_length=100)
     self.nacionality = CharField(null=True, max_length=55)
     self.name = CharField(max_length=100)
     self.name_tag = IntField(null=True)
     self.neighborhood = CharField(null=True, max_length=50)
     self.phone = CharField(null=True, max_length=13, display=PHONE)
     self.photo = BytesField(null=True)
     self.pis_date = DateField(null=True, display=DATE)
     self.pis_number = IntField()
     self.place_of_birth = CharField(null=True, max_length=55)
     self.post_graduation = CharField(null=True)
     self.registry = IntField()
     self.reservist = CharField(null=True, max_length=30)
     self.rg = CharField(
         null=True,
         max_length=12,
     )
     self.rg_date = DateField(null=True, display=DATE)
     self.rg_issuing = CharField(null=True, max_length=10)
     self.role = ForeignField(Role)
     self.salary = DecimalField(null=True, display=CURRENCY)
     self.scholarity = IntField(null=True)
     self.scholarity_complete = BoolField(default_value=False)
     self.sex = CharField(default_value='M', max_length=1)
     self.spouse = CharField(null=True, max_length=100)
     self.transport_voucher = BoolField(default_value=False)
     self.winthor_registry = IntField(null=True)
     self.zipcode = IntField(null=True, display=CEP)
     self.bf_prepare()
Beispiel #2
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_roles'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField(max_length=100)
     self.active = BoolField(default_value=True)
     self.bf_prepare()
Beispiel #3
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_meal_checks'
     self.create_connection = create_sige
     self.date = DateField(display=DATE)
     self.registry = IntField()
     self.has_meal = BoolField(default_value=False)
     self.bf_prepare()
Beispiel #4
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_meal_checks'
     self.create_connection = create_sige
     self.date = DateField(display=DATE)
     self.registry = IntField()
     self.has_meal = BoolField(default_value=False)
     self.bf_prepare()
Beispiel #5
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_roles'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField(max_length=100)
     self.active = BoolField(default_value=True)
     self.bf_prepare()
Beispiel #6
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_Employees'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.account = CharField(null=True, max_length=10)
     self.active = BoolField(default_value=True)
     self.address = CharField(null=True, max_length=150)
     self.address_adjunct = CharField(null=True, max_length=150)
     self.admission_date = DateField(display=DATE)
     self.agency = CharField(null=True, max_length=10)
     self.bank = CharField(null=True, max_length=50)
     self.born_date = DateField(null=True, display=DATE)
     self.cellphone = CharField(null=True, max_length=13, display=PHONE)
     self.city = CharField(null=True, max_length=50)
     self.civil_state = CharField(default_value='S', max_length=1)
     self.cnh = CharField(null=True, max_length=20)
     self.cnh_category = CharField(null=True, max_length=10)
     self.cpf = IntField(display=CPF)
     self.ctps = CharField(null=True, max_length=15)
     self.ctps_date = DateField(null=True, display=DATE)
     self.ctps_fu = CharField(null=True, max_length=2)
     self.ctps_series = CharField(null=True, max_length=10)
     self.demission_date = DateField(null=True, display=DATE)
     self.department = ForeignField(Department)
     self.enterprise = ForeignField(Enterprise)
     self.father_name = CharField(null=True, max_length=100)
     self.fu = CharField(null=True, max_length=2)
     self.graduation = CharField(null=True)
     self.meal_on_enterprise = BoolField(default_value=False)
     self.mother_name = CharField(null=True, max_length=100)
     self.nacionality = CharField(null=True, max_length=55)
     self.name = CharField(max_length=100)
     self.name_tag = IntField(null=True)
     self.neighborhood = CharField(null=True, max_length=50)
     self.phone = CharField(null=True, max_length=13, display=PHONE)
     self.photo = BytesField(null=True)
     self.pis_date = DateField(null=True, display=DATE)
     self.pis_number = IntField()
     self.place_of_birth = CharField(null=True, max_length=55)
     self.post_graduation = CharField(null=True)
     self.registry = IntField()
     self.reservist = CharField(null=True, max_length=30)
     self.rg = CharField(null=True, max_length=12, )
     self.rg_date = DateField(null=True, display=DATE)
     self.rg_issuing = CharField(null=True, max_length=10)
     self.role = ForeignField(Role)
     self.salary = DecimalField(null=True, display=CURRENCY)
     self.scholarity = IntField(null=True)
     self.scholarity_complete = BoolField(default_value=False)
     self.sex = CharField(default_value='M', max_length=1)
     self.spouse = CharField(null=True, max_length=100)
     self.transport_voucher = BoolField(default_value=False)
     self.winthor_registry = IntField(null=True)
     self.zipcode = IntField(null=True, display=CEP)
     self.bf_prepare()
Beispiel #7
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_widgets_data'
     self.create_connection = create_sige
     self.widget = ForeignField(Report, field_name='wid')
     self.last_update = DateTimeField(default_value=datetime(1900, 1, 1),
                                      display=DATETIME)
     self.rows_count = IntField(default_value=0)
     self.data = CharField(max_length=999999999)
     self.bf_prepare()
Beispiel #8
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_enterprises'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField(max_length=150)
     self.cnpj = IntField(display=CNPJ)
     self.phone = CharField(max_length=13, null=True, display=PHONE)
     self.active = BoolField(default_value=True)
     self.bf_prepare()
Beispiel #9
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_enterprises'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField(max_length=150)
     self.cnpj = IntField(display=CNPJ)
     self.phone = CharField(max_length=13, null=True, display=PHONE)
     self.active = BoolField(default_value=True)
     self.bf_prepare()
Beispiel #10
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_widgets_data'
     self.create_connection = create_sige
     self.widget = ForeignField(Report, field_name='wid')
     self.last_update = DateTimeField(default_value=datetime(1900, 1, 1),
                                      display=DATETIME)
     self.rows_count = IntField(default_value=0)
     self.data = CharField(max_length=999999999)
     self.bf_prepare()
Beispiel #11
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_dependents'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField()
     self.born_date = DateField(display=DATE)
     self.kinship = CharField()
     self.employee = ForeignField(Employee, field_name='eid')
     self.active = BoolField(default_value=True)
     self.bf_prepare()
Beispiel #12
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_dependents'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField()
     self.born_date = DateField(display=DATE)
     self.kinship = CharField()
     self.employee = ForeignField(Employee, field_name='eid')
     self.active = BoolField(default_value=True)
     self.bf_prepare()
Beispiel #13
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_report_parameters'
     self.create_connection = create_sige
     self.report = ForeignField(Report, field_name='rid')
     self.name = CharField(max_length=100)
     self.type = CharField(max_length=1, choices=self.choices,
                           default_value='S')
     self.default_value = CharField(null=True)
     self.legend = CharField(max_length=100, null=True)
     self.bf_prepare()
Beispiel #14
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_report_parameters'
     self.create_connection = create_sige
     self.report = ForeignField(Report, field_name='rid')
     self.name = CharField(max_length=100)
     self.type = CharField(max_length=1,
                           choices=self.choices,
                           default_value='S')
     self.default_value = CharField(null=True)
     self.legend = CharField(max_length=100, null=True)
     self.bf_prepare()
Beispiel #15
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_users'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField()
     self.user = CharField()
     self.email = CharField(null=True)
     self.password = CharField(default_value=sha256(b'padrao').hexdigest())
     self.active = BoolField(default_value=True)
     self.xmpp_user = CharField(null=True)
     self.access = ForeignField(Access)
     self.bf_prepare()
Beispiel #16
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_asos'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.date = DateField(display=DATE)
     self.type = CharField()
     self.employee = ForeignField(Employee, field_name='eid')
     self.document = BytesField(null=True)
     self.document_ext = CharField(max_length=5, null=True)
     self.conclusion = BoolField(default_value=True)
     self.observations = CharField(max_length=1024, null=True)
     self.bf_prepare()
Beispiel #17
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_asos'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.date = DateField(display=DATE)
     self.type = CharField()
     self.employee = ForeignField(Employee, field_name='eid')
     self.document = BytesField(null=True)
     self.document_ext = CharField(max_length=5, null=True)
     self.conclusion = BoolField(default_value=True)
     self.observations = CharField(max_length=1024, null=True)
     self.bf_prepare()
Beispiel #18
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_users'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.name = CharField()
     self.user = CharField()
     self.email = CharField(null=True)
     self.password = CharField(default_value=sha256(b'padrao').hexdigest())
     self.active = BoolField(default_value=True)
     self.xmpp_user = CharField(null=True)
     self.access = ForeignField(Access)
     self.bf_prepare()
Beispiel #19
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_reports'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.title = CharField(max_length=150)
     self.script = CharField(max_length=999999999)
     self.type = CharField(max_length=1, default_value='B',
                           choices=self.choices)
     self.recipients = CharField(max_length=1024, null=True)
     self.execution_start = TimeField(null=True, display=TIME)
     self.is_widget = BoolField(default_value=False)
     self.group = CharField(null=True)
     self.bf_prepare()
Beispiel #20
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_reports'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.title = CharField(max_length=150)
     self.script = CharField(max_length=999999999)
     self.type = CharField(max_length=1,
                           default_value='B',
                           choices=self.choices)
     self.recipients = CharField(max_length=1024, null=True)
     self.execution_start = TimeField(null=True, display=TIME)
     self.is_widget = BoolField(default_value=False)
     self.group = CharField(null=True)
     self.bf_prepare()
Beispiel #21
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_vacancys'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.relative_start = DateField(display=DATE)
     self.relative_end = DateField(display=DATE)
     self.use_start = DateField(display=DATE)
     self.use_end = DateField(display=DATE)
     self.allowance_start = DateField(null=True, display=DATE)
     self.allowance_end = DateField(null=True, display=DATE)
     self.employee = ForeignField(Employee, field_name='eid')
     self.observations = CharField(max_length=1024, null=True)
     self.document = BytesField(null=True)
     self.document_ext = CharField(max_length=5, null=True)
     self.bf_prepare()
Beispiel #22
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_disciplinary_sanctions'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.employee = ForeignField(Employee, field_name='eid')
     self.type = IntField(choices=self.type_choices, default_value=1)
     self.date = DateField(display=DATE)
     self.reason = IntField(choices=self.reason_choices, default_value=1)
     self.requester = CharField()
     self.witness1 = CharField(null=True)
     self.witness2 = CharField(null=True)
     self.observations = CharField(null=True)
     self.document = BytesField(null=True)
     self.document_ext = CharField(null=True)
     self.bf_prepare()
Beispiel #23
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_vacancys'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.relative_start = DateField(display=DATE)
     self.relative_end = DateField(display=DATE)
     self.use_start = DateField(display=DATE)
     self.use_end = DateField(display=DATE)
     self.allowance_start = DateField(null=True, display=DATE)
     self.allowance_end = DateField(null=True, display=DATE)
     self.employee = ForeignField(Employee, field_name='eid')
     self.observations = CharField(max_length=1024, null=True)
     self.document = BytesField(null=True)
     self.document_ext = CharField(max_length=5, null=True)
     self.bf_prepare()
Beispiel #24
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_disciplinary_sanctions'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.employee = ForeignField(Employee, field_name='eid')
     self.type = IntField(choices=self.type_choices, default_value=1)
     self.date = DateField(display=DATE)
     self.reason = IntField(choices=self.reason_choices, default_value=1)
     self.requester = CharField()
     self.witness1 = CharField(null=True)
     self.witness2 = CharField(null=True)
     self.observations = CharField(null=True)
     self.document = BytesField(null=True)
     self.document_ext = CharField(null=True)
     self.bf_prepare()
Beispiel #25
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_access'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.admin = BoolField(default_value=False)
     self.access_control = IntField(default_value=0, choices=self.choices)
     self.curricula = IntField(default_value=0, choices=self.choices)
     self.departments = IntField(default_value=0, choices=self.choices)
     self.disciplinary_sanctions = IntField(default_value=0,
                                            choices=self.choices)
     self.employees = IntField(default_value=0, choices=self.choices)
     self.enterprises = IntField(default_value=0, choices=self.choices)
     self.roles = IntField(default_value=0, choices=self.choices)
     self.salary = IntField(default_value=0, choices=self.choices)
     self.users = IntField(default_value=0, choices=self.choices)
     self.reports = CharField(null=True, default_value=None)
     self.widgets = CharField(null=True, default_value=None)
     self.bf_prepare()
Beispiel #26
0
 def __init__(self):
     BaseModel.__init__(self)
     self._bf_table_name = 'bf_access'
     self.create_connection = create_sige
     self.id = IntField(primary_key=True)
     self.admin = BoolField(default_value=False)
     self.access_control = IntField(default_value=0, choices=self.choices)
     self.curricula = IntField(default_value=0, choices=self.choices)
     self.departments = IntField(default_value=0, choices=self.choices)
     self.disciplinary_sanctions = IntField(default_value=0,
                                            choices=self.choices)
     self.employees = IntField(default_value=0, choices=self.choices)
     self.enterprises = IntField(default_value=0, choices=self.choices)
     self.roles = IntField(default_value=0, choices=self.choices)
     self.salary = IntField(default_value=0, choices=self.choices)
     self.users = IntField(default_value=0, choices=self.choices)
     self.reports = CharField(null=True, default_value=None)
     self.widgets = CharField(null=True, default_value=None)
     self.bf_prepare()