class Transaction(db.Model):
__tablename__ = "transaction"
id = db.Column(db.Integer(), primary_key=True)
transaction_no = db.Column(db.String(100), unique=True)
transaction_type = db.relationship('ConfigTransactionType')
transaction_type_id = db.Column(db.Integer,
db.ForeignKey('configtransactiontype.id'))
account = db.relationship('Account')
account_id = db.Column(db.Integer, db.ForeignKey('account.id'))
reversing_transaction = db.relationship('Transaction',
remote_side=[id],
backref='reversal',
uselist=False)
reversing_transaction_id = db.Column(db.Integer,
db.ForeignKey('transaction.id'),
nullable=True)
currency_id = db.Column(db.Integer, db.ForeignKey('configcurrency.id'))
currency = db.relationship('ConfigCurrency')
amount = db.Column(db.Numeric(18, 2), default=D('0.0'))
details = db.Column(db.String(255), nullable=True)
notified = db.Column(db.Boolean, default=False)
date_created = db.Column(db.DateTime())
def __unicode__(self):
return '%s' % self.transaction_no
class PaypalTransaction(db.Model):
__tablename__ = "paypaltransaction"
id = db.Column(db.Integer(), primary_key=True)
paypal_transaction_type_code = db.Column(db.String(50), nullable=False)
paypal_payer_id = db.Column(db.String(50), nullable=True)
payer_id = db.Column(db.Integer(),
db.ForeignKey('paypalprofile.id'),
nullable=True)
payer = db.relationship('PaypalProfile', backref='transactions')
mpesa_recipient = db.Column(db.String(25))
transaction = db.relationship(
'Transaction',
backref='paypal_transactions',
uselist=False,
primaryjoin=
"Transaction.transaction_no==PaypalTransaction.paypal_transaction_id")
paypal_transaction_id = db.Column(
db.String(50),
db.ForeignKey('transaction.transaction_no'),
unique=True)
sale_id = db.Column(db.String(50), nullable=True)
invoice_number = db.Column(db.String(50), nullable=True)
parent_transaction_id = db.Column(
db.String(50),
db.ForeignKey('transaction.transaction_no'),
nullable=True)
parent_transaction = db.relationship(
'Transaction',
backref='child_transactions',
uselist=False,
primaryjoin=
"PaypalTransaction.parent_transaction_id==Transaction.transaction_no")
create_time = db.Column(db.DateTime(timezone=True), nullable=False)
update_time = db.Column(db.DateTime(timezone=True), nullable=True)
state = db.Column(db.String(50), nullable=False)
intent = db.Column(db.String(20), nullable=True)
payment_method = db.Column(db.String(20), nullable=True)
date_created = db.Column(db.DateTime(), nullable=False)
def __unicode__(self):
return '%s' % self.paypal_transaction_id
class TransactionStatus(db.Model):
__tablename__ = "transactionstatus"
id = db.Column(db.Integer(), primary_key=True)
transaction = db.relationship('Transaction',
backref='transaction_statuses')
transaction_id = db.Column(db.Integer, db.ForeignKey('transaction.id'))
status = db.relationship('ConfigTransactionStatus',
backref='transaction_statuses')
status_id = db.Column(db.Integer,
db.ForeignKey('configtransactionstatus.id'))
details = db.Column(db.String(400), nullable=True)
date_created = db.Column(db.DateTime())
class MPesaTransaction(db.Model):
__tablename__ = "mpesatransaction"
id = db.Column(db.Integer(), primary_key=True)
mpesa_transaction_no = db.Column(db.String(50))
mpesa_txn_id = db.Column(db.String(50))
recipient = db.relationship(
'MPesaProfile',
backref='transactions',
primaryjoin=
"MPesaProfile.mobile_phone_no==MPesaTransaction.recipient_phone_no")
recipient_phone_no = db.Column(
db.String(50),
db.ForeignKey('mpesaprofile.mobile_phone_no'),
nullable=False)
total_amount = db.Column(db.String(50), nullable=False)
total_amount_currency = db.Column(db.String(4),
nullable=False,
default='KES')
reference_id = db.Column(db.String(50), nullable=True)
transaction = db.relationship(
'Transaction',
backref='mpesa_transactions',
uselist=False,
primaryjoin=
"Transaction.transaction_no==MPesaTransaction.merchant_transaction_id")
merchant_transaction_id = db.Column(
db.String(50),
db.ForeignKey('transaction.transaction_no'),
nullable=False)
date_created = db.Column(db.DateTime())
date_approved = db.Column(db.DateTime())
def __unicode__(self):
return '%s' % self.mpesa_transaction_no
class ConfigLedgerAccountingRule(db.Model):
__tablename__ = "configledgeraccountingrule"
id = db.Column(db.Integer(), primary_key=True)
product = db.relationship('Product')
product_id = db.Column(db.Integer, db.ForeignKey('product.id'))
transaction_type = db.relationship('ConfigTransactionType', backref='accounting_rules')
transaction_type_id = db.Column(db.Integer, db.ForeignKey('configtransactiontype.id'))
debit_account_id = db.Column(db.Integer, db.ForeignKey('configledgeraccount.id'))
debit_account = db.relationship('ConfigLedgerAccount', backref='debits', foreign_keys=[debit_account_id])
credit_account_id = db.Column(db.Integer, db.ForeignKey('configledgeraccount.id'))
credit_account = db.relationship('ConfigLedgerAccount', backref='credits', foreign_keys=[credit_account_id])
date_created = db.Column(db.DateTime())
def __unicode__(self):
return self.transaction_type.name
class SMSMessage(db.Model):
__tablename__ = "smsmessage"
INCOMING = 0
OUTGOING = 1
id = db.Column(db.Integer(), primary_key=True)
notification_type_id = db.Column(db.Integer, db.ForeignKey('confignotificationtype.id'), nullable=False)
notification_type = db.relationship('ConfigNotificationType')
message_type = db.Column(db.Integer(), default=INCOMING)
message_sender = db.Column(db.String(15), nullable=True)
message = db.Column(db.String(320))
message_recipient_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
message_recipient = db.relationship("User")
delivered = db.Column(db.Boolean, default=False)
date_delivered = db.Column(db.DateTime())
date_created = db.Column(db.DateTime())
class TransactionEntry(db.Model):
__tablename__ = "transactionentry"
(DEBIT, CREDIT) = (0, 1)
(ITEM_TYPES) = ((DEBIT, 'Debit'), (CREDIT, 'Credit'))
id = db.Column(db.Integer(), primary_key=True)
transaction = db.relationship('Transaction', backref='transaction_entries')
transaction_id = db.Column(db.Integer, db.ForeignKey('transaction.id'))
account = db.relationship('Account', backref='account_entries')
account_id = db.Column(db.Integer, db.ForeignKey('account.id'))
ledger_account = db.relationship('ConfigLedgerAccount')
ledger_account_id = db.Column(db.Integer,
db.ForeignKey('configledgeraccount.id'))
item_type = db.Column(db.Integer())
balance_increment = db.Column(db.Numeric(6, 2), default=D('0.0'))
date_created = db.Column(db.DateTime())
class AccountVerification(db.Model):
__tablename__ = "accountverification"
__table_args__ = (db.UniqueConstraint('mobile_code', 'email_code'), )
id = db.Column(db.Integer(), primary_key=True)
email_code = db.Column(db.String(15), nullable=False)
mobile_code = db.Column(db.String(10), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
user = db.relationship('User')
expiry_date = db.Column(db.DateTime, nullable=False)
date_created = db.Column(db.DateTime, nullable=False)
class PaypalAddress(db.Model):
__tablename__ = "paypaladdress"
id = db.Column(db.Integer(), primary_key=True)
paypal_profile = db.relationship('PaypalProfile', backref='addresses')
paypal_profile_id = db.Column(db.Integer,
db.ForeignKey('paypalprofile.id'),
nullable=False)
street_address = db.Column(db.String(100), nullable=False)
locality = db.Column(db.String(50), nullable=False)
region = db.Column(db.String(50), nullable=False)
postal_code = db.Column(db.String(15), nullable=True)
country = db.Column(db.String(3), nullable=False)
date_created = db.Column(db.DateTime(), nullable=False)
class PaypalProfile(db.Model):
__tablename__ = "paypalprofile"
id = db.Column(db.Integer(), primary_key=True)
user = db.relationship('User',
backref='paypal_profile',
uselist=False,
primaryjoin='User.email==PaypalProfile.email')
email = db.Column(db.String(100),
db.ForeignKey('user.email'),
unique=True,
nullable=False)
address = db.relationship('PaypalAddress',
backref='paypal_addresses',
uselist=False)
paypal_user_id = name = db.Column(db.String(100),
unique=True,
nullable=False)
name = db.Column(db.String(100), nullable=False)
given_name = db.Column(db.String(100), nullable=False)
family_name = db.Column(db.String(100), nullable=False)
middle_name = db.Column(db.String(100), nullable=True)
gender = db.Column(db.String(10), nullable=True)
phone_number = db.Column(db.String(100), nullable=False)
birthday = db.Column(db.Date(), nullable=False)
email_verified = db.Column(db.Boolean, default=False, nullable=True)
verified_account = db.Column(db.Boolean, default=False, nullable=False)
account_type = db.Column(db.String(10), nullable=False)
account_creation_date = db.Column(db.DateTime(), nullable=False)
date_created = db.Column(db.DateTime(), nullable=False)
date_updated = db.Column(db.DateTime(), nullable=False)
def __unicode__(self):
return '[%s] %s' % (self.paypal_user_id, self.email)
class ConfigLedgerAccount(db.Model):
__tablename__ = "configledgeraccount"
NORMAL = 'NORMAL'
CONTRA = 'CONTRA'
id = db.Column(db.Integer(), primary_key=True)
name = db.Column(db.String(100), unique=True)
code = db.Column(db.String(100), unique=True)
account_category = db.relationship('ConfigLedgerAccountCategory')
account_category_id = db.Column(db.Integer, db.ForeignKey('configledgeraccountcategory.id'))
#contra|normal
balance_direction = db.Column(db.String(10), default=NORMAL)
date_created = db.Column(db.DateTime())
def __unicode__(self):
return self.name
class MPesaProfile(db.Model):
__tablename__ = "mpesaprofile"
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(db.Integer(),
db.ForeignKey('user.id'),
nullable=False,
unique=True)
user = db.relationship(
'User', backref='mpesa_profile', uselist=False
) # primaryjoin='User.phone==MPesaProfile.mobile_phone_no')
mobile_phone_no = db.Column(db.String(25), unique=True, nullable=False)
registered_name = db.Column(db.String(100), nullable=True)
date_created = db.Column(db.DateTime(), nullable=False)
date_updated = db.Column(db.DateTime(), nullable=False)
def __unicode__(self):
return '[%s] %s' % (self.user_id, self.mobile_phone_no)
