def parse_bg_ele_xls_file(xls_file,db,pricelist_name, wizard_obj):
user = wizard_obj.postgres_config_id.db_user
host = wizard_obj.postgres_config_id.host_name
password = wizard_obj.postgres_config_id.db_user_pass
utility_type = wizard_obj.categ_id and wizard_obj.categ_id.name or False
rb = xlrd.open_workbook(xls_file,formatting_info=False)
final_lst = []
for sheet in ['Range 1','Range 2','Range 3']:
product_values = {
'ELECTRICITY 1 YEAR CONTRACT': {'start_col': 0,'end_col':7},
'ELECTRICITY 2 YEAR CONTRACT': {'start_col': 8,'end_col':15},
'ELECTRICITY 3 YEAR CONTRACT': {'start_col': 16,'end_col':23}
}
if sheet == 'Range 1':
min = 0.0
max = 11999.00
elif sheet == 'Range 2':
min = 12000.00
max = 50999.00
elif sheet == 'Range 3':
min = 51000.00
max = 51000.00
worksheet = rb.sheet_by_name(sheet)
col_values = worksheet.row_values(1,start_colx=0, end_colx=7)
# print "________col_values______________",col_values
data_lst = []
file_gas = addons.get_module_resource('import_xls/csv_data', 'master_bg_ele.csv')
sheet_1_data_gas,product_lst = first_sheet.sheet_1_bg_ele_price(file_gas,col_values,worksheet,pricelist_name,product_values,min,max)
# product_import = pricelist.import_pricelist_bg_gas_product(db,user,host,password,product_lst,utility_type)
pricelist.import_pricelist_bg_gas(db,user,host,password,sheet_1_data_gas,utility_type)
final_lst += sheet_1_data_gas
return final_lst
def parse_bg_gas_xls_file(xls_file,db,pricelist_name, wizard_obj):
user = wizard_obj.postgres_config_id.db_user
host = wizard_obj.postgres_config_id.host_name
password = wizard_obj.postgres_config_id.db_user_pass
utility_type = wizard_obj.categ_id and wizard_obj.categ_id.name or False
rb = xlrd.open_workbook(xls_file,formatting_info=False)
final_lst = []
worksheet = rb.sheet_by_name('Sheet1')
col_values = worksheet.row_values(1,start_colx=0, end_colx=6)
# print "________col_values______________",col_values
data_lst = []
file_gas = addons.get_module_resource('import_xls/csv_data', 'master_sheet_cng_gas.csv')
sheet_1_data_gas,product_lst = first_sheet.sheet_1_bg_gas_price(file_gas,col_values,worksheet,pricelist_name)
product_import = pricelist.import_pricelist_bg_gas_product(db,user,host,password,product_lst,utility_type)
pricelist.import_pricelist_bg_gas(db,user,host,password,sheet_1_data_gas,utility_type)
final_lst += sheet_1_data_gas
return final_lst
