class LocalConveyanceClaim(db.Model): id = db.Column(db.Integer, primary_key=True) from_location = db.Column(db.String, nullable=False) to_location = db.Column(db.String, nullable=False) bill_amount = db.Column(db.Float, nullable=False) bill_date = db.Column(db.DateTime, nullable=False) bill_image = db.Column(db.String)
class ClientEntertainmentClaim(db.Model): id = db.Column(db.Integer, primary_key=True) client_name = db.Column(db.String, nullable=False) hotel_name = db.Column(db.String, nullable=False) bill_amount = db.Column(db.Float, nullable=False) bill_date = db.Column(db.DateTime, nullable=False) bill_image = db.Column(db.String)
class ExtendedHoursClaim(db.Model): id = db.Column(db.Integer, primary_key=True) from_time = db.Column(db.String, nullable=False) to_time = db.Column(db.String, nullable=False) bill_amount = db.Column(db.Float, nullable=False) bill_date = db.Column(db.DateTime, nullable=False) bill_image = db.Column(db.String)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(20), unique=True, nullable=False) first_name = db.Column(db.String(30), nullable=False) last_name = db.Column(db.String(30), nullable=False) password = db.Column(db.String(60), nullable=False) isAdmin = db.Column(db.Boolean, default=False) claims_made = db.relationship('Claims', backref='claims', lazy=True) def __repr__(self): return str({ 'email': self.email, 'name': self.first_name + " " + self.last_name, })
class Claims(db.Model): id = db.Column(db.Integer, primary_key=True) claim_type = db.Column(db.String) claim_id = db.Column(db.Integer) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) approved = db.Column(db.Integer, default=0) date_applied = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) def __repr__(self): return str({ 'email': self.user_id.email, 'Claim Type': self.claim_type, 'user_id': self.user_id, 'approved': self.approved, 'date_applied': self.date_applied })
class OfficeExpensesClaim(db.Model): id = db.Column(db.Integer, primary_key=True) bill_no = db.Column(db.Integer, nullable=False) bill_amount = db.Column(db.Float, nullable=False) bill_date = db.Column(db.DateTime) bill_image = db.Column(db.String)