def populate_comm_list(): func_type = "remap" start = time.time() c_csv = csv.reader(open(_DATA_FILE,"rb")) count = 0 _cid = 0 for col in c_csv: #skip the first row if count == 0: count+= 1 continue ##Initialization of fields _cid += 1 _tid = col[0].strip() _dateline = str(int(custom_time.unix_time(col[1].strip()))) _paytime = str(int(custom_time.unix_time(col[1].strip()))) _salesperson = col[6] _price = col[15] _first_tier_name = col[26] _first_tier_amount = col[28] _second_tier_name = col[29] _second_tier_amount = col[31] _third_tier_name = col[32] _third_tier_amount = col[34] ##Creating Commission object and add to list c_object = Commission(_cid, _tid,_dateline,_paytime,_salesperson,_price, _first_tier_name,_first_tier_amount, _second_tier_name, _second_tier_amount,_third_tier_name, _third_tier_amount ) comm_list.append(c_object) _cid = c_object.cid + c_object.cid_counter
def populate_ta_list(): func_type = "remap" start = time.time() hr_csv = csv.reader(open("HR.csv","rb")); t_csv = csv.reader(open(_DATA_FILE,"rb")) count = 0 for row in t_csv: #skip the first row if count == 0: count+= 1 continue ##Initialization of fields _tid = row[0].strip() _dateline = str(int(custom_time.unix_time(row[1].strip()))) _start_time = str(int(custom_time.unix_time(row[2].strip()))) _end_time = str(int(custom_time.unix_time(row[3].strip()))) _type = row[4] _option = str(int(custom_time.unix_time(row[5].strip()))) _salesperson = row[6] _block_no = row[7] _street_name = row[8] _level = "" _unit_no = "" _zipcode = row[11] _client = row[12] _cea_no = "" _uid = "" #Mapping type with their type number _type = str(_TYPE_DICT[_type]) ##Mapping name with CEA_NO in HR.CSV for inner_row in hr_csv: if _salesperson == inner_row[0]: _cea_no = inner_row[1] break ##Split Unit and Level by hyphen if row[9] != "": temp_unit = row[9].split("-") if(len(temp_unit) < 2): _level = "0" _unit_no = "0" else: _level = temp_unit[0] _unit_no = temp_unit[1] _uid = str(_get_uid_from_name(_salesperson)) _commission = row[25] _agency = row[16] ##Creating Transaction object and add to list t_object = Transaction(_tid, _start_time, _end_time, _type, _option, _salesperson, _cea_no, _block_no, _street_name, _level, _unit_no, _zipcode, _client, _uid, _commission, _agency) ta_list.append(t_object)
def populate_ta_list(): func_type = "remap" start = time.time() hr_csv = csv.reader(open("HR.csv","rb")); t_csv = csv.reader(open(_DATA_FILE,"rb")) count = 0 for col in t_csv: #skip the first row if count == 0: count+= 1 continue ##Initialization of fields _tid = col[0].strip() _addtime = str(int(custom_time.unix_time(col[3].strip()))) _billing_date = str(int(custom_time.unix_time(col[1].strip()))) _type = str(get_type(col[4],col[46])) _option = str(int(custom_time.unix_time(col[5].strip()))) _salesperson = col[6] _block_no = col[7] _street_name = col[8] _level = "" _unit_no = "" _zipcode = col[11] _client = col[12] _cea_no = "" _uid = "" _license = "L3010008E" _cea_no = "sp.cea_no" ##Split Unit and Level by hyphen if col[9] != "": temp_unit = col[9].split("-") if(len(temp_unit) < 2): _level = "0" _unit_no = "0" else: _level = temp_unit[0] _unit_no = temp_unit[1] ##_uid = str(_get_uid_from_name(_salesperson)) ## not in use _uid = 'user.uid' ##CLOSING AGENT($) _closing_agent_money = col[25] ##Net Amount to Bill _received = col[15] _agency = col[16] ##AMOUNT _gross_commission = col[20] ##Creating Transaction object and add to list t_object = Transaction(_tid, _addtime, _billing_date, _type, _option, _salesperson, _cea_no, _block_no, _street_name, _level, _unit_no, _zipcode, _client, _uid, _received, _agency, _gross_commission, _closing_agent_money, _license) ta_list.append(t_object)
def populate_comm_list(): commission_list = [] func_type = "remap" start = time.time() c_csv = csv.reader(open(_DATA_FILE, "rb")) count = 0 _cid = 0 for col in c_csv: # skip the first row if count == 0: count += 1 continue ##Initialization of fields _cid += 1 _tid = col[0].strip() _dateline = str(int(custom_time.unix_time(col[1].strip()))) _paytime = str(int(custom_time.unix_time(col[1].strip()))) _salesperson = col[6] # amount is closing agent _amount = col[25] # price is co-broker invoice _price = col[19] _first_tier_name = col[26] _first_tier_amount = col[28] _second_tier_name = col[29] _second_tier_amount = col[31] _third_tier_name = col[32] _third_tier_amount = col[34] _gm1_value = col[36] _gm2_value = col[38] _resale_bonus = col[40] _project_bonus = col[42] _marketing_budget = col[44] ##Creating Commission object and add to list c_object = Commission( _cid, _tid, _dateline, _paytime, _salesperson, _amount, _price, _first_tier_name, _first_tier_amount, _second_tier_name, _second_tier_amount, _third_tier_name, _third_tier_amount, _gm1_value, _gm2_value, _resale_bonus, _project_bonus, _marketing_budget, ) commission_list.append(c_object) _cid = c_object.cid + c_object.cid_counter return commission_list
def remap_generate_transaction_script(): func_type = "remap" start = time.time() hr_csv = csv.reader(open("HR.csv","rb")); t_csv = csv.reader(open(_DATA_FILE,"rb")) f = open(_REMAP_EXPORT_FILE,'wb') f.write(_use_db(func_type)) f.write(_create_cdb_transaction_statement(func_type)) f.write("\n\n") f.write(_delete_records_statement()) count = 0 for row in t_csv: #skip the first row if count == 0: count+= 1 continue ##Initialization of fields temp_string = _get_init_insert_string(_REMAP_FIELD_LIST) _tid = row[0] _dateline = str(int(custom_time.unix_time(row[1].strip()))) _addtime = str(int(custom_time.unix_time(row[2].strip()))) _end_time = str(int(custom_time.unix_time(row[3].strip()))) _type = row[4] _option = str(int(custom_time.unix_time(row[5].strip()))) _salesperson = row[6] _block_no = row[7] _street_name = row[8] _level = "" _unit_no = "" _zipcode = row[11] _client = row[12] _cea_no = "" _uid = "" #Mapping type with their type number _type = str(_TYPE_DICT[_type]) ##Mapping name with CEA_NO in HR.CSV for inner_row in hr_csv: if _salesperson == inner_row[0]: _cea_no = inner_row[1] break ##Split Unit and Level by hyphen if row[9] != "": temp_unit = row[9].split("-") if(len(temp_unit) < 2): _level = "0" _unit_no = "0" else: _level = temp_unit[0] _unit_no = temp_unit[1] _uid = str(_get_uid_from_name(_salesperson)) temp_string += '"'+ _tid +'","' + _dateline + '","' + _addtime + '","' + _end_time + '","' + _type + '","' + _option + '","' + _salesperson + '","' + _cea_no + '","' + _block_no + '","' + _street_name + '","' + _level + '","' + _unit_no + '","' + _zipcode + '","'+_client + '","' + _uid + '");\n' f.write(temp_string) f.close() ##f = open(_REMAP_EXPORT_FILE,'r') #_print_out(f,_REMAP_EXPORT_FILE) print "Migration completed.\nOperation took",time.time() - start,"seconds.\nPlease view",_REMAP_EXPORT_FILE
def populate_ta_list(): func_type = "remap" start = time.time() hr_csv = csv.reader(open("HR.csv", "rb")) t_csv = csv.reader(open(_DATA_FILE, "rb")) count = 0 for row in t_csv: # skip the first row if count == 0: count += 1 continue ##Initialization of fields _tid = row[0].strip() _addtime = str(int(custom_time.unix_time(row[3].strip()))) _type = str(get_type(row[4], row[46])) _option = str(int(custom_time.unix_time(row[5].strip()))) _salesperson = row[6] _block_no = row[7] _street_name = row[8] _level = "" _unit_no = "" _zipcode = row[11] _client = row[12] _cea_no = "" _uid = "" _license = "LL3010008H" ##Mapping name with CEA_NO in HR.CSV ## for inner_row in hr_csv: ## if _salesperson == inner_row[0]: ## _cea_no = inner_row[1] ## break ##Split Unit and Level by hyphen if row[9] != "": temp_unit = row[9].split("-") if len(temp_unit) < 2: _level = "0" _unit_no = "0" else: _level = temp_unit[0] _unit_no = temp_unit[1] ##_uid = str(_get_uid_from_name(_salesperson)) _uid = "user.uid" ##CLOSING AGENT($) _received = row[25] _agency = row[16] ##AMOUNT _gross_commission = row[20] ##Creating Transaction object and add to list t_object = Transaction( _tid, _addtime, _type, _option, _salesperson, _cea_no, _block_no, _street_name, _level, _unit_no, _zipcode, _client, _uid, _received, _agency, _gross_commission, _license, ) ta_list.append(t_object)