class Student(mysql_db.Model):
__tablename__ = 'students'
id = mysql_db.Column(mysql_db.Integer, primary_key=True)
studentId = mysql_db.Column(mysql_db.String(20), unique=True)
fname = mysql_db.Column(mysql_db.String(20))
phone = mysql_db.Column(mysql_db.String(20))
email = mysql_db.Column(mysql_db.String(64))
fee = mysql_db.Column(mysql_db.Float)
def __init__(self, studentId, fname, phone="", email="", fee=0):
self.studentId = studentId
self.fname = fname
self.phone = phone
self.email = email
self.fee = fee
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def to_json(self):
return {
"fname": self.fname,
"phone": self.phone,
"email": self.email,
"studentId": self.studentId
}
def __repr__(self):
return '<Student %r, %r, %r, %r, %r, %r>' % (self.id, self.studentId,
self.fname, self.phone,
self.email, self.fee)
class His(mysql_db.Model):
__tablename__ = 'history'
id = mysql_db.Column(mysql_db.Integer, primary_key=True)
studentId = mysql_db.Column(mysql_db.String(20))
datetime = mysql_db.Column(mysql_db.String(20))
amount = mysql_db.Column(mysql_db.Float)
payment_user = mysql_db.Column(mysql_db.String(50))
paymentId = mysql_db.Column(mysql_db.String(20))
def __init__(self, studentId, datetime, payment_user, paymentId, amount=0):
self.studentId = studentId
self.datetime = datetime
self.amount = amount
self.payment_user = payment_user
self.paymentId = paymentId
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def __repr__(self):
return '<His %r, %r, %r, %r, %r, %r>' % (
self.id, self.studentId, self.datetime, self.amount,
self.payment_user, self.paymentId)
class User(UserMixin, mysql_db.Model):
__tablename__ = 'users'
id = mysql_db.Column(mysql_db.Integer, primary_key=True)
email = mysql_db.Column(mysql_db.String(64), unique=False, index=True)
username = mysql_db.Column(mysql_db.String(64), unique=False, index=True)
password_hash = mysql_db.Column(mysql_db.String(128))
balance = mysql_db.Column(mysql_db.Float)
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def __init__(self, username, email, password_hash, balance):
self.username = username
self.email = email
self.password_hash = password_hash
self.balance = balance
def __repr__(self):
return '<User %r,%r,%r,%r,%r>' % (self.username, self.email,
self.username, self.password_hash,
self.balance)
def verify(self, input_password):
return self.password_hash == input_password
class Product(mysql_db.Model):
__tablename__ = 'products'
p_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
p_name = mysql_db.Column(mysql_db.String(20))
p_price = mysql_db.Column(mysql_db.String(30))
p_description = mysql_db.Column(mysql_db.String(500))
p_location = mysql_db.Column(mysql_db.String(50))
c_id = mysql_db.Column(mysql_db.String(20))
img_url = mysql_db.Column(mysql_db.String(100))
catagory_code = mysql_db.Column(mysql_db.String(20))
shop_id = mysql_db.Column(mysql_db.String(20))
def __init__(self,
p_name="",
p_price=0,
p_description="",
p_location="",
c_id="",
img_url="",
catagory_code="",
shop_id=""):
self.p_name = p_name
self.p_price = p_price
self.p_description = p_description
self.p_location = p_location
self.c_id = c_id
self.catagory_code = catagory_code
self.shop_id = shop_id
self.img_url = img_url
def create(self):
now = datetime.datetime.now()
self.p_id = "pro" + now.strftime("%H%M%S%m%d%Y")
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def delete(self):
mysql_db.session.delete(self)
mysql_db.session.commit()
return self
def to_json(self):
return {
"p_id": self.p_id,
"p_name": self.p_name,
"p_price": self.p_price,
"p_description": self.p_description,
"p_location": self.p_location,
"c_id": self.c_id,
"img_url": self.img_url,
"catagory_id": self.catagory_code,
"shop_id": self.shop_id
}
def __repr__(self):
return '<Product %r, %r, %r, %r, %r, %r, %r, %r, %r>' % (
self.p_id, self.p_name, self.p_price, self.p_description,
self.p_location, self.c_id, self.img_url, self.catagory_code,
self.shop_id)
class Model(mysql_db.Model):
__tablename__ = 'models'
id = mysql_db.Column(mysql_db.String(20),primary_key = True)
create_date = mysql_db.Column(mysql_db.String(100))
def __init__(self,create_date):
x = datetime.datetime.now()
self.create_date = x.strftime("%H%M%S%d%m%Y")
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
class Cart(mysql_db.Model):
__tablename__ = 'carts'
c_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
quantity = mysql_db.Column(mysql_db.Integer())
total_cost = mysql_db.Column(mysql_db.Integer())
def __init__(self, c_id, quantity, total_cost):
self.c_id = c_id
self.quantity = quantity
self.total_cost = total_cost
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def to_json(self):
return {
"c_id": self.c_id,
"quantity": self.quantity,
"total_cost": self.total_cost
}
def __repr__(self):
return '<Cart %r, %r, %r>' % (self.c_id, self.quantity,
self.total_cost)
class Order(mysql_db.Model):
__tablename__ = 'orders'
order_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
status_shipping = mysql_db.Column(mysql_db.String(20))
status_payment = mysql_db.Column(mysql_db.String(20))
create_dt = mysql_db.Column(mysql_db.String(100))
user_do_order = mysql_db.Column(mysql_db.String(20))
ship_fee = mysql_db.Column(mysql_db.Float())
total_product = mysql_db.Column(mysql_db.Float())
def __init__(self, status_shipping, status_payment, user_do_order,
ship_fee, total_product):
self.status_shipping = status_shipping
self.status_payment = status_payment
self.user_do_order = user_do_order
self.ship_fee = ship_fee
self.total_product = total_product
def create(self):
now = datetime.datetime.now()
self.order_id = "order" + now.strftime("%H%M%S%d%m%Y")
self.create_dt = now
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def to_json(self):
return {
"order_id": self.order_id,
"status_shipping": self.status_shipping,
"status_payment": self.status_payment,
"create_dt": self.create_dt,
"user_do_order": self.user_do_order,
"ship_fee": self.ship_fee,
"total_product": self.total_product,
}
def __repr__(self):
return '<Order %r, %r, %r, %r, %r, %r, %r>' % (
self.order_id, self.status_shipping, self.status_payment,
self.create_dt, self.user_do_order, self.ship_fee,
self.total_product)
class Partner(mysql_db.Model):
__tablename__ = 'partners'
partner_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
user_id = mysql_db.Column(mysql_db.String(64))
status = mysql_db.Column(mysql_db.String(50))
def __init__(self, partner_id, user_id):
self.partner_id = partner_id
self.user_id = user_id
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def __repr__(self):
return '<Partner %r, %r, %r>' % (self.partner_id, self.user_id,
self.status)
class Shipping(mysql_db.Model):
__tablename__ = 'shippings'
shop_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
product_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
create_date = mysql_db.Column(mysql_db.String(30))
cost = mysql_db.Column(mysql_db.Integer())
def __init__(self, shop_id, product_id, cost):
self.shop_id = shop_id
self.product_id = product_id
self.cost = cost
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def __repr__(self):
return '<Shipping %r, %r, %r, %r>' % (self.shop_id, self.product_id,
self.create_date, self.cost)
class Bank_Account(mysql_db.Model):
__tablename__ = 'bank_accounts'
id = mysql_db.Column(mysql_db.Integer, primary_key=True)
student_id = mysql_db.Column(mysql_db.String(20))
balance = mysql_db.Column(mysql_db.Integer)
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def __repr__(self):
return '<Bank_Account %r>' % self.id
class Role(mysql_db.Model):
__tablename__ = 'roles'
id = mysql_db.Column(mysql_db.Integer, primary_key=True)
name = mysql_db.Column(mysql_db.String(64), unique=True)
role_value = mysql_db.Column(mysql_db.Integer)
def __init__(self,name,role_value):
self.name = name
self.role_value = role_value
def __repr__(self):
return '<Role %r>' % self.name
class Catagory(mysql_db.Model):
__tablename__ = 'catagories'
catagory_code = mysql_db.Column(mysql_db.String(20), primary_key=True)
catagory_name = mysql_db.Column(mysql_db.String(50))
catagory_des = mysql_db.Column(mysql_db.String(100))
def __init__(self, catagory_code, catagory_name, catagory_des):
self.catagory_code = catagory_code
self.catagory_name = catagory_name
self.catagory_des = catagory_des
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def to_json(self):
return {}
def __repr__(self):
return '<Catagory %r, %r, %r>' % (
self.catagory_code, self.catagory_name, self.catagory_des)
class Location(mysql_db.Model):
__tablename__ = 'locations'
loc_code = mysql_db.Column(mysql_db.String(20),primary_key = True)
loc_name = mysql_db.Column(mysql_db.String(50))
loc_des = mysql_db.Column(mysql_db.String(100))
def __init__(self,loc_code,loc_name,loc_des):
self.loc_code = loc_code
self.loc_name = loc_name
self.loc_des = loc_des
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def to_json(self):
return {
}
def __repr__(self):
return '<Location %r, %r, %r>' % (self.loc_code, self.loc_name, self.loc_des)
class Shop(mysql_db.Model):
__tablename__ = 'shops'
shop_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
owner_id = mysql_db.Column(mysql_db.String(64), unique=True)
shop_name = mysql_db.Column(mysql_db.String(100))
create_date = mysql_db.Column(mysql_db.String(100))
def __init__(self, owner_id, shop_name, create_date):
now = datetime.datetime.now()
self.shop_id = "pro" + now.strftime("%H%M%S%m%d%Y")
self.owner_id = owner_id
self.shop_name = shop_name
self.create_date = create_date
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def __repr__(self):
return '<Shop %r, %r, %r, %r>' % (self.shop_id, self.owner_id,
self.shop_name, self.create_date)
class Order_Detail(mysql_db.Model):
__tablename__ = 'order_detail'
p_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
order_id = mysql_db.Column(mysql_db.String(20), primary_key=True)
shop_id = mysql_db.Column(mysql_db.String(20), primary_key=False)
amount = mysql_db.Column(mysql_db.Integer())
status_shipping = mysql_db.Column(mysql_db.String(20),
server_default='wait')
order_user_email = mysql_db.Column(mysql_db.String(100))
ibanking_payment_email = mysql_db.Column(
mysql_db.String(100), server_default='COD'
) #thanh toán ibanking thì lưu mail, mặc định là COD: thu tiền tiền mặt
paymentId = mysql_db.Column(mysql_db.String(100))
def __init__(self, p_id, shop_id, amount, status_shipping,
order_user_email, ibanking_payment_email, paymentId):
self.p_id = p_id
self.shop_id = shop_id
self.amount = amount
self.status_shipping = status_shipping
self.order_user_email = order_user_email
self.ibanking_payment_email = ibanking_payment_email
self.paymentId = paymentId
def create(self):
now = datetime.datetime.now()
self.order_id = "order" + now.strftime("%H%M%S%d%m%Y")
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def to_json(self):
return {
"p_id": self.p_id,
"order_id": self.order_id,
"shop_id": self.shop_id,
"amount": self.amount,
"status_shipping": self.status_shipping,
"ibanking_payment_email": self.status_payment,
"paymentId": self.paymentId,
}
def __repr__(self):
return '<Order_Detail %r, %r, %r, %r, %r, %r, %r, %r>' % (
self.p_id, self.order_id, self.shop_id, self.amount,
self.status_shipping, self.order_user_email,
self.ibanking_payment_email, self.paymentId)
class Tution(mysql_db.Model):
__tablename__ = 'tutions'
id = mysql_db.Column(mysql_db.Integer, primary_key=True)
student_id = mysql_db.Column(mysql_db.String(20))
fee = mysql_db.Column(mysql_db.Integer)
def __init__(self,student_id,fee=0):
self.student_id = student_id
self.fee = fee
def create(self):
mysql_db.session.add(self)
mysql_db.session.commit()
return self
def __repr__(self):
return '<Tution %r>' % self.id
