class marketing(db.Model, UserMixin):
sr_no = db.Column(db.Integer, primary_key=True)
customer_id = db.Column(db.String(50), nullable=False)
customer_name = db.Column(db.String(50), nullable=False)
is_auto_billing = db.Column(db.Integer, nullable=False, default=0)
is_paytm_first = db.Column(db.Integer, nullable=False, default=0)
is_postpaid_given = db.Column(db.Integer, nullable=False, default=0)
postpaid_amount_given = db.Column(db.Float, nullable=False, default=0)
postpaid_outstanding = db.Column(db.Float, nullable=False, default=0)
# timeStamp = db.Column(db.DateTime, default=datetime.utcnow)
timeStamp = db.Column(db.Integer, default=0) #
def __repr__(self):
return f"MarketiToUser('{self.sr_no}', '{self.customer_id}', '{self.customer_name}')"
class order(db.Model, UserMixin):
sr_no = db.Column(db.Integer, primary_key=True)
customer_id = db.Column(db.String(50), nullable=False)
customer_name = db.Column(db.String(50), nullable=False)
pdt_id = db.Column(db.Integer, nullable=False)
pdt_amount = db.Column(db.Float, nullable=False)
is_COD = db.Column(db.Integer, nullable=False, default=0)
is_EPay = db.Column(db.Integer, nullable=False, default=0)
is_Travel = db.Column(db.Integer, nullable=False, default=0)
is_Paytm_Mall = db.Column(db.Integer, nullable=False, default=0)
is_Movie = db.Column(db.Integer, nullable=False, default=0)
timeStamp = db.Column(db.Integer, default=0) #
def __repr__(self):
return f"OrderByUser('{self.sr_no}', '{self.customer_id}', '{self.customer_name}')"
class shippingData(db.Model, UserMixin):
sr_no = db.Column(db.Integer, primary_key=True)
customer_id = db.Column(db.String(50), nullable=False)
customer_name = db.Column(db.String(50), nullable=False)
pdt_id = db.Column(db.Integer, nullable=False)
pdt_amount = db.Column(db.Float, nullable=False)
is_COD = db.Column(db.Integer, nullable=False, default=0)
is_EPay = db.Column(db.Integer, nullable=False, default=0)
is_Cancelled = db.Column(db.Integer, nullable=False, default=0)
is_Delivered = db.Column(db.Integer, nullable=False, default=0)
# timeStamp = db.Column(db.DateTime, default=datetime.utcnow)
timeStamp = db.Column(db.Integer, default=0) #
def __repr__(self):
return f"ShippingForUser('{self.sr_no}', '{self.customer_id}', '{self.customer_name}')"
class masterData(db.Model, UserMixin):
id = db.Column(db.String(20), primary_key=True)
age = db.Column(db.Integer, nullable=False)
is_auto_billing = db.Column(db.Integer, nullable=False, default=0)
is_paytm_first = db.Column(db.Integer, nullable=False, default=0)
is_postpaid = db.Column(db.Integer, nullable=False, default=0)
postpaid_outstanding = db.Column(db.Integer, nullable=False, default=0)
orders_placed_in_6months = db.Column(db.Integer, nullable=False)
orders_placed_in_6months_via_epay = db.Column(db.Integer, nullable=False)
orders_placed_in_6months_via_cod = db.Column(db.Integer, nullable=False)
orders_placed_in_6months_via_emi = db.Column(db.Integer, nullable=False)
orders_delivered_in_6months = db.Column(db.Integer, nullable=False)
total_money_on_order_from_mall_6months = db.Column(db.Integer, nullable=False)
total_money_on_order_on_travel_6months = db.Column(db.Integer, nullable=False)
total_money_on_order_on_movie_6months = db.Column(db.Integer, nullable=False)
total_money_spent = db.Column(db.Integer, nullable=False)
total_money_added_on_wallet = db.Column(db.Integer, nullable=False)
CODorNot = db.Column(db.Integer, nullable=False)
EMIorNot = db.Column(db.Integer, nullable=False)
RatioDvP = db.Column(db.Float, nullable=False)