def invest_start(self,driver,row):
file = common_config.datebase_path
data = Read_datebase.open_excel(file)
table = data.sheet_by_name('invest')
money=table.cell(row,Read_datebase.find_colum(file,'invest','money')).value
table = data.sheet_by_name('public')
mylogin.invest(table.cell(2,Read_datebase.find_colum(file,'public','url_vmdai')).value,money,driver)
def login_start(self,driver,row):
file = common_config.datebase_path
data = Read_datebase.open_excel(file)
table = data.sheet_by_name('financing')
user=table.cell(row,Read_datebase.find_colum(file,'financing','Login_user')).value
password=table.cell(row,Read_datebase.find_colum(file,'financing','Login_password')).value
table = data.sheet_by_name('public')
element_backstage_login.login(table.cell(2,Read_datebase.find_colum(file,'public','url_admin')).value,user,password,driver)
def financing(self,driver,row):
file = common_config.datebase_path
data = Read_datebase.open_excel(file)
table = data.sheet_by_name('financing')
uername = table.cell(row,Read_datebase.find_colum(file,'financing','username')).value
bank = table.cell(row,Read_datebase.find_colum(file,'financing','bank')).value
moneyf = table.cell(row,Read_datebase.find_colum(file,'financing','moneyf')).value
dayormauthtype = table.cell(row,Read_datebase.find_colum(file,'financing','dayormauthtype')).value
dayormauth = table.cell(row,Read_datebase.find_colum(file,'financing','dayormauth')).value
rate = table.cell(row,Read_datebase.find_colum(file,'financing','rate')).value
end_time = table.cell(row,Read_datebase.find_colum(file,'financing','end_time')).value
service_fee = table.cell(row,Read_datebase.find_colum(file,'financing','service_fee')).value
estate_name = table.cell(row,Read_datebase.find_colum(file,'financing','estate_name')).value
build_size = table.cell(row,Read_datebase.find_colum(file,'financing','build_size')).value
purpose = table.cell(row,Read_datebase.find_colum(file,'financing','purpose')).value
pro_type = table.cell(row,Read_datebase.find_colum(file,'financing','pro_type')).value
deposit = table.cell(row,Read_datebase.find_colum(file,'financing','deposit')).value
activity_a = table.cell(row,Read_datebase.find_colum(file,'financing','activity_a')).value
activity_b = table.cell(row,Read_datebase.find_colum(file,'financing','activity_b')).value
limit = table.cell(row,Read_datebase.find_colum(file,'financing','limit')).value
p_price = table.cell(row,Read_datebase.find_colum(file,'financing','p_price')).value
c_price = table.cell(row,Read_datebase.find_colum(file,'financing','c_price')).value
table = data.sheet_by_name('public')
url=table.cell(2,Read_datebase.find_colum(file,'public','url_admin')).value
activity_url = 'https://vtest.vmdai.com/default/active2'
#activity_url = table.cell(row,Read_datebase.find_colum(file,'financing','activity_url')).value
#print activity_url
if pro_type == 'z':
url = url+"lender/add"
element_financing.financing_z(url,uername,purpose,pro_type,bank,moneyf,dayormauthtype,dayormauth,rate,end_time,service_fee,deposit,activity_a,activity_b,estate_name,build_size,limit,p_price,c_price,activity_url,driver)
if pro_type == 't':
url = url + 'lender/add_tengfei'
element_financing.financing_t(url,uername,purpose,pro_type,bank,moneyf,dayormauthtype,dayormauth,rate,end_time,service_fee,deposit,activity_a,activity_b,estate_name,build_size,limit,p_price,c_price,activity_url,driver)
def logout_start(self,driver):
file = common_config.datebase_path
data = Read_datebase.open_excel(file)
table = data.sheet_by_name('public')
element_backstage_login.logout(driver,table.cell(2,Read_datebase.find_colum(file,'public','url_admin')).value)
def url_start(self,driver,otherurl):
file = common_config.datebase_path
data = Read_datebase.open_excel(file)
table = data.sheet_by_name('public')
urlall = table.cell(2,Read_datebase.find_colum(file,'public','url_vmdai')).value + '/'+otherurl
url.url(urlall,driver)
def browser_start(self):
file = common_config.datebase_path
data = Read_datebase.open_excel(file)
table = data.sheet_by_name('public')
return Browser.browser(table.cell(2,Read_datebase.find_colum(file,'public','browser')).value)