Subversion Repositories SmartDukaan

    returnQty = Field(Float, default=0)

class ReturnPickupRequest(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    logisticsProviderId = Field(Integer)

    pickupRequestNo = Field(String(50))

    confirmedAt = Field(DateTime)

    promised_pickup_timestamp = Field(DateTime)

    pickedUpAt = Field(DateTime)

    pickupStatus = Field(Enum('PENDING','PICKUP_REQUESTED','PICKUP_CONFIRMED','PICKUP_SCHEDULED','PICKUP_IN_TRANSIT','PICKUP_RECEIVED'))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ReturnOrderInfo(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    returnTransaction = ManyToOne("ReturnTransaction")

    masterOrderId = Field(String(100))

    orderId = Field(Integer)

    lineItemId = Field(Integer)

    logisticsRequestId = Field(Integer)

    returnQuantity = Field(Integer)

    receivedQuantity = Field(Integer)

    createdAt = Field(DateTime)

    processedAt = Field(DateTime)

    returnStatus = Field(String(256))

    reshippedAt = Field(DateTime)

    receivedAt = Field(DateTime)

    refundReason = Field(String(256))

    refundedBy = Field(String(256))

    refundedAt = Field(DateTime)

    warehouse_id = Field(Integer)

    refundAmount = Field(Float)

    refundType = Field(Integer, default=0)

    refundDescription = Field(String(256))

    returnPickupType = Field(Integer, default=0, server_default="0")

    shippingType = Field(Integer, default=0, server_default="0")

    replacementOrderId = Field(Integer)

    receivedReturnType = Field(Integer)

    freebieItemId = Field(Integer, default=0, server_default="0")

    returnAction = Field(Integer)

    returnTxnResolutionStatus = Field(Enum('PENDING','AWAITING_PICKUP','QUALITY_CHECK','REPLACEMENT_DONE'\

                              'REPLACEMENT_ORDER_CREATED','REFUND_IN_PROCESS','REFUND_DONE','CLOSED'))

    lineitem = ManyToOne("LineItem", field=lineItemId)

    returnPickUpRequest = ManyToOne("ReturnPickupRequest", field=logisticsRequestId)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class ReturnTransaction(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    status = Field(Enum('INITIATED','AUTHORIZED','INPROCESS','REJECTED','PROCESSED','COMPLETED','CLOSED'))

    customer_email = Field(String(50))

    customer_name = Field(String(50))

    customer_id = Field(Integer)

    address_id = Field(Integer)

    ticketId = Field(Integer)

    createdAt = Field(DateTime)

    processedAt = Field(DateTime)

    authorizedAt = Field(DateTime)

    closedAt = Field(DateTime)

    customerAddress = Field(String(512))

    pincode = Field(String(10))

    customerCity = Field(String(100))

    customerState = Field(String(50))

    customerPhone = Field(String(50))

    returnOrders = OneToMany("ReturnOrderInfo")

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")