partner.py
2.76 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
from sqlalchemy import (
Column,
Integer,
ForeignKey,
UniqueConstraint,
String,
SmallInteger,
DateTime
)
from sqlalchemy.orm import (
relationship,
backref
)
from ..models import (Base, TABLE_ARGS, KodeModel, DefaultModel)
from ..models import (NamaModel, User, Departemen)
class PartnerModel(NamaModel):
status = Column(Integer, default=1) # 0 Inaktif - 1 Aktif
# no_urut = Column(Integer)
alamat_1 = Column(String(128))
alamat_2 = Column(String(128))
email = Column(String(40))
phone = Column(String(16))
fax = Column(String(16))
mobile = Column(String(16))
website = Column(String(64))
pic = Column(String(16))
pic_mobile = Column(String(16))
pic_email = Column(String(16))
pic_jabatan = Column(String(16))
@classmethod
def query_email(cls, email):
return cls.query().filter_by(email=email)
@classmethod
def query_mobile(cls, mobile):
return cls.query().filter_by(mobile=mobile)
class Partner(Base, PartnerModel):
__tablename__ = 'partner'
kelurahan = Column(String(128))
kecamatan = Column(String(128))
kota = Column(String(128))
provinsi = Column(String(128))
is_vendor = Column(SmallInteger, nullable=False, )
is_customer = Column(SmallInteger, nullable=False, )
bank = Column(String(16))
bank_accnt = Column(String(16))
user_id = Column(Integer, ForeignKey(User.id), nullable=True) # referensi ke login
departemen_id = Column(Integer, ForeignKey(Departemen.id)) # referensi ke default skpd
users = relationship("User", backref=backref('partner'))
departemen = relationship('Departemen', backref=backref('partner'))
rt = Column(String(3))
rw = Column(String(3))
tempat_lahir = Column(String(128))
tgl_lahir = Column(DateTime(timezone=False))
jenis_kelamin = Column(String(1))
gol_darah = Column(String(2))
agama = Column(String(32))
perkawinan = Column(String(2))
pekerjaan = Column(String(32))
kewarganegaraan = Column(String(10))
# npwp = Column(String(16))
# npwpd = Column(String(16))
@classmethod
def query_user_id(cls, user_id):
return cls.query().filter_by(user_id=user_id)
@classmethod
def query_user(cls, user):
return cls.query_user_id(user.id)
@classmethod
def query_identity(cls, ident):
row = cls.query().filter_by(kode=ident).first()
if not row:
row = cls.query().filter_by(email=ident).first()
if not row:
row = cls.query().filter_by(mobile=ident).first()
return row
class PartnerUserModel(Base, DefaultModel):
__tablename__ = 'partner_user'
partner_id = Column(Integer, ForeignKey(Partner.id))
user_id = Column(Integer, ForeignKey(User.id))