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()
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()
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()
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()
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()
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()
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()
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()
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()
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()
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()
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()
class Access(BaseModel):
choices = (0, 1, 2)
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()
def widgets_list(self, to_add=None, to_del=None):
if self.widgets:
data = self.widgets.split(', ')
else:
data = []
if to_add:
data.append(to_add)
elif to_del:
if to_del in data:
data.remove(to_del)
else:
return tuple(data)
self.widgets = ', '.join(data)
def reports_list(self, to_add=None, to_del=None):
if self.reports:
data = self.reports.split(', ')
else:
data = []
if to_add:
data.append(to_add)
elif to_del:
if to_del in data:
data.remove(to_del)
else:
return tuple(data)
self.reports = ', '.join(data)
def load_from_web(self, form):
try:
self.access_control = int(form['access_control'])
self.curricula = int(form['curricula'])
self.departments = int(form['departments'])
self.disciplinary_sanctions = int(form['disciplinary_sanctions'])
self.employees = int(form['employees'])
self.enterprises = int(form['enterprises'])
self.roles = int(form['roles'])
self.salary = int(form['salary'])
self.users = int(form['users'])
if 'is_admin' in form:
self.admin = True
else:
self.admin = False
except BadRequestKeyError:
abort(403)
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()
class Access(BaseModel):
choices = (0, 1, 2)
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()
def widgets_list(self, to_add=None, to_del=None):
if self.widgets:
data = self.widgets.split(', ')
else:
data = []
if to_add:
data.append(to_add)
elif to_del:
if to_del in data:
data.remove(to_del)
else:
return tuple(data)
self.widgets = ', '.join(data)
def reports_list(self, to_add=None, to_del=None):
if self.reports:
data = self.reports.split(', ')
else:
data = []
if to_add:
data.append(to_add)
elif to_del:
if to_del in data:
data.remove(to_del)
else:
return tuple(data)
self.reports = ', '.join(data)
def load_from_web(self, form):
try:
self.access_control = int(form['access_control'])
self.curricula = int(form['curricula'])
self.departments = int(form['departments'])
self.disciplinary_sanctions = int(form['disciplinary_sanctions'])
self.employees = int(form['employees'])
self.enterprises = int(form['enterprises'])
self.roles = int(form['roles'])
self.salary = int(form['salary'])
self.users = int(form['users'])
if 'is_admin' in form:
self.admin = True
else:
self.admin = False
except BadRequestKeyError:
abort(403)