Subversion Repositories SmartDukaan

'''

Created on Jun 27, 2017

@author: amit

'''

from elixir import *

from shop2020.model.v1.order.impl.DataService import Seller, SellerWarehouse, \

    WarehouseAddressMaster, WarehouseAddressMapping, Organisation

import datetime

from shop2020.model.v1.order.impl import DataService

from shop2020.clients.TransactionClient import TransactionClient

from shop2020.clients.InventoryClient import InventoryClient

def create_delhi(company):

    # Create a seller for organisation which is specific to state - Delhi

    seller = Seller()

    #7537

    warehouseId = 7573

    # registered address

    seller.address = 'Khasra No-322, Second Floor, Opp.Purani Tel Mil, Neb Sarai, New Delhi-110068'

    # keep one of , seller.gstn = '' or

    seller.tin = ''

    seller.gstin = '07AAFCM7436G1ZD'

    # short for seller e.g. NSSPL-STATE

    seller.label = 'SOPL-DL'

    seller.organisation_id = company.id

    # 0 for delhi, 1 MH, 2 karnataka, 3 Haryana, 4 Rajasthan, 5 Telangana, 6 Gujarat, 7 UP, 8, Punjab

    seller.state_id = 0

    session.merge(seller)

    # Create one warehouse for this seller 

    sellerWarehouse = SellerWarehouse()

    sellerWarehouse.created_on = datetime.datetime.now()

    sellerWarehouse.is_active = True

    # 0-B2C, 1-B2B

    #This is no more valid as single invoice has to be generated

    sellerWarehouse.orderType = 0

    # Prefix that will be used during invoice generation at the time of billing.

    sellerWarehouse.prefix = 'SOPL'

    # This has to be created in old system and to be set accordingly

    sellerWarehouse.warehouse_id = warehouseId

    # The sequence of invoice in system is controlled from here.

    sellerWarehouse.id = 0

    sellerWarehouse.seller_id = seller.id

    session.merge(sellerWarehouse)

    # Lets Create one more warehouse for this seller for B2B purpose 

    #sellerWarehouse1 = SellerWarehouse()

    #sellerWarehouse1.created_on = datetime.datetime.now()

    #sellerWarehouse1.is_active = True

    # 0-B2C, 1-B2B

    #sellerWarehouse1.orderType = 1

    # Prefix that will be used during invoice generation at the time of billing.

    #sellerWarehouse1.prefix = 'NSDLBB'

    # This has to be created in old system and to be set accordingly

    #sellerWarehouse1.warehouse_id = warehouseId

    # The sequence of invoice in system is controlled from here.

    #sellerWarehouse1.id = 0

    #sellerWarehouse1.seller_id = seller.id

    #session.merge(sellerWarehouse1)

    # Create warehouse addresses

#    whm1 = WarehouseAddressMaster()

#    # complete address without pin

#    whm1.address = 'Khasra No-322, Second Floor, Opp.Purani Tel Mil, Neb Sarai, New Delhi'

#    whm1.pin = 110068

#    whm1.created = datetime.datetime.now()

#    # number of person responsible for warehouse

#    whm1.contact_number = '9990381569'

#    whm1.state_id = 0

#    session.merge(whm1)

    warehouseAddressMapping = WarehouseAddressMapping()

    #warehouseAddressMapping.address_id = whm1.id

    warehouseAddressMapping.address_id = 10

    warehouseAddressMapping.created = datetime.datetime.now()

    warehouseAddressMapping.updated = datetime.datetime.now()

    warehouseAddressMapping.warehouse_id = warehouseId

    session.merge(warehouseAddressMapping)

def create_haryana(company):

    # Create a seller for organisation which is specific to state - Delhi

    warehouseId = 7441

    seller = Seller()

    # registered address

    seller.address = 'B/363-365, 2nd Floor, Opp Post Office, Part-2, Nehru Ground, NIT , Faridabad, Haryana-121001'

    # keep one of , seller.gstn = '' or

    seller.tin = ''

    seller.gstin = 'HRGSTIN'

    # short for seller e.g. NSSPL-STATE

    seller.label = 'NSSPL-HR'

    seller.organisation_id = company.id

    # 0 for delhi, 1 MH, 2 karnataka, 3 Haryana, 4 Rajasthan, 5 Telangana, 6 Gujarat, 7 UP, 8, Punjab

    seller.state_id = 3

    session.merge(seller)

    # Create one warehouse for this seller 

    sellerWarehouse = SellerWarehouse()

    sellerWarehouse.created_on = datetime.datetime.now()

    sellerWarehouse.is_active = True

    # 0-B2C, 1-B2B

    sellerWarehouse.orderType = 0

    # Prefix that will be used during invoice generation at the time of billing.

    sellerWarehouse.prefix = 'NSHRBC'

    # This has to be created in old system and to be set accordingly

    sellerWarehouse.warehouse_id = warehouseId

    # The sequence of invoice in system is controlled from here.

    sellerWarehouse.id = 0

    sellerWarehouse.seller_id = seller.id

    session.merge(sellerWarehouse)

    # Lets Create one one warehouse for this seller for B2B purpose 

    sellerWarehouse1 = SellerWarehouse()

    sellerWarehouse1.created_on = datetime.datetime.now()

    sellerWarehouse1.is_active = True

    # 0-B2C, 1-B2B

    sellerWarehouse1.orderType = 1

    # Prefix that will be used during invoice generation at the time of billing.

    sellerWarehouse1.prefix = 'NSHRBB'

    # This has to be created in old system and to be set accordingly

    sellerWarehouse1.warehouse_id = warehouseId

    # The sequence of invoice in system is controlled from here.

    sellerWarehouse1.id = 0

    sellerWarehouse1.seller_id = seller.id

    session.merge(sellerWarehouse1)

    # Create warehouse addresses

    whm1 = WarehouseAddressMaster()

    # complete address without pin

    whm1.address = 'B/363-365, 2nd Floor, Opp Post Office, Part-2, Nehru Ground, NIT , Faridabad, Haryana'

    whm1.pin = 121001

    whm1.created = datetime.datetime.now()

    # number of person responsible for warehouse

    whm1.contact_number = '9990381569'

    whm1.state_id = 0

    session.merge(whm1)

    warehouseAddressMapping = WarehouseAddressMapping()

    warehouseAddressMapping.address_id = whm1.id

    warehouseAddressMapping.created = datetime.datetime.now()

    warehouseAddressMapping.updated = datetime.datetime.now()

    warehouseAddressMapping.warehouse_id = warehouseId

def main():

    company = Organisation()

    company.name = 'SPICE ONLINE PRIVATE LIMITED'

    company.address = '512-B, Modi Tower, 98, Nehru Place, New Delhi-110019'

    company.type = 'company'

    company.registered_id = 'U74140DL2008PTC183856'

    session.merge(company)

    create_delhi(company)

    #create_haryana(company)

    session.commit()

if __name__ == '__main__':

    DataService.initialize()

    main()

    tc = TransactionClient().get_client()

    #print tc.getSellerInfo(13)