class TestCase80DevManageSearchCustomer(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_search_customer(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 循环点击5次
for n in range(5):
self.driver.click_element(
'x,//*[@id="treeDemo_deviceManage_%s_span"]' % str(n + 2))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text(
'x,//*[@id="treeDemo_deviceManage_%s_span"]' % str(n + 2))
number = get_account_dev_number.split('(')[1].split('/')[0]
dev_number = self.dev_manage_page.get_dev_number()
self.assertEqual(number, str(dev_number))
# 搜索无数据
self.dev_manage_page.search_customer('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text()
self.assertIn(self.assert_text.account_center_page_no_data_text(),
get_text)
class TestCase108GlobSearchUserDetail(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.global_dev_search_page = GlobalDevSearchPage(
self.driver, self.base_url)
self.account_center_page_navi_bar = AccountCenterNaviBarPages(
self.driver, self.base_url)
self.driver.set_window_max()
self.global_account_search_page = GlobalAccountSearchPage(
self.driver, self.base_url)
self.log_in_base = LogInBase(self.driver, self.base_url)
self.global_search_page_read_csv = GlobleSearchPageReadCsv()
self.search_sql = SearchSql()
self.driver.wait(1)
self.connect_sql = ConnectSql()
self.assert_text = AssertText()
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_global_search_user_detail(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
self.log_in_base.log_in()
self.log_in_base.click_account_center_button()
self.global_dev_search_page.click_easy_search()
# 关闭
self.global_dev_search_page.close_search()
sleep(2)
self.global_dev_search_page.click_easy_search()
# 选择用户搜索
self.global_dev_search_page.click_account_search()
# self.global_dev_search_page.click_search_buttons()
user_name = self.global_dev_search_page.get_user_name_in_user_search()
user_type = self.global_dev_search_page.get_user_type_in_user_search()
user_account = self.global_dev_search_page.get_user_account_in_user_search(
)
# 点用户详情
self.global_dev_search_page.click_detail_in_user_search()
# 用户信息
self.global_dev_search_page.click_user_info_in_user_detail()
# 获取用户信息中用户名称，用户类型、用户账号、上级用户
user_name_in_detail = self.global_dev_search_page.get_user_name_in_detail(
)
self.assertIn(user_name, user_name_in_detail)
# user_type_in_detail = self.global_dev_search_page.get_user_type_in_detail()
# self.assertEqual(user_type, user_type_in_detail)
uesr_account_in_detail = self.global_dev_search_page.get_user_account_in_detail(
)
self.assertEqual(user_account, uesr_account_in_detail)
user_account_input_value = self.global_dev_search_page.get_user_account_input_value_in_detail(
)
self.assertEqual('true', user_account_input_value)
get_up_user_name = self.global_dev_search_page.get_up_user_name_in_detail(
)
get_up_user_input_value = self.global_dev_search_page.get_up_user_input_value_in_detail(
)
self.assertEqual('true', get_up_user_input_value)
# 查询选中用户的上级
connect = self.connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
get_up_account_sql = "select parentId from user_info where account = '%s';" % user_account
cursor.execute(get_up_account_sql)
get_up_account = cursor.fetchall()
up_account_id = get_up_account[0][0]
get_up_name_sql = "select nickName from user_info where userId = '%s';" % up_account_id
cursor.execute(get_up_name_sql)
get_up_name = cursor.fetchall()
up_account = get_up_name[0][0]
cursor.close()
connect.close()
self.assertEqual(get_up_user_name, up_account)
# 验证右侧的客户数是否可以搜索
# 搜索没有的数据
text = self.global_dev_search_page.search_user_in_user_info('无数据')
self.assertIn(self.assert_text.account_center_page_no_data_text(),
text)
# 循环点击五次
for n in range(5):
self.global_dev_search_page.swith_to_search_frame()
self.driver.click_element(
'x,//*[@id="complex_userInfo_tree_complexUpdate_%s_a"]' %
str(n + 15))
get_up_user_name = self.global_dev_search_page.get_up_user_name_in_details(
)
select_up_name = self.driver.get_text(
'x,//*[@id="complex_userInfo_tree_complexUpdate_%s_span"]' %
str(n + 15))
# self.assertEqual(get_up_user_name, select_up_name)
sleep(2)
self.driver.default_frame()
# 点击销售设备
self.global_dev_search_page.click_sale_dev_in_user_info()
# 获取销售的对象
sale_user_name = self.global_dev_search_page.get_sale_user_name()
self.assertEqual(user_name, sale_user_name)
# 点击新增客户
self.global_dev_search_page.click_add_user_in_user_info()
# 获取新增客户默认的上级
up_user_in_add_user = self.global_dev_search_page.get_up_user_in_add_user(
)
self.assertIn(user_name, up_user_in_add_user)
# 验证账号
# 为空
self.global_dev_search_page.check_add_user_account_input_in_user_info(
'')
self.global_dev_search_page.click_save_add_user()
text = self.global_dev_search_page.get_text_account_input_expertion()
self.assertEqual(self.assert_text.cust_page_user_account_not_null(),
text)
# 小于3位
self.global_dev_search_page.check_add_user_account_input_in_user_info(
'12')
self.global_dev_search_page.click_save_add_user()
text = self.global_dev_search_page.get_text_account_input_expertion()
self.assertEqual(self.assert_text.cust_page_user_account_len(), text)
# 验证最大长度
get_user_account_input_max_len = self.global_dev_search_page.get_user_account_input_max_len(
)
self.assertEqual('30', get_user_account_input_max_len)
# 验证客户名称
# 为空
self.global_dev_search_page.check_add_user_name_input_in_user_info('')
self.global_dev_search_page.click_save_add_user()
text = self.global_dev_search_page.get_text_name_input_expertion()
self.assertEqual(self.assert_text.cust_page_user_name_not_null(), text)
# 小于3位
self.global_dev_search_page.check_add_user_name_input_in_user_info(
'12')
self.global_dev_search_page.click_save_add_user()
text = self.global_dev_search_page.get_text_name_input_expertion()
self.assertEqual(self.assert_text.cust_page_user_name_more_than_3s(),
text)
# 密码
# 为空
self.global_dev_search_page.click_add_user_password_first_input_in_user_info(
'')
self.global_dev_search_page.click_save_add_user()
get_first_password_text = self.global_dev_search_page.get_first_password_text(
)
self.assertEqual(self.assert_text.cust_page_user_password_not_nulls(),
get_first_password_text)
# 小于6位
self.global_dev_search_page.click_add_user_password_first_input_in_user_info(
'12qw')
self.global_dev_search_page.click_add_user_password_second_input_in_user_info(
'12qw')
self.global_dev_search_page.click_save_add_user()
get_first_password_text = self.global_dev_search_page.get_first_password_text(
)
self.assertEqual(self.assert_text.cust_page_user_password_len(),
get_first_password_text)
# 全数字
self.global_dev_search_page.click_add_user_password_first_input_in_user_info(
'121212')
self.global_dev_search_page.click_add_user_password_second_input_in_user_info(
'121212')
self.global_dev_search_page.click_save_add_user()
get_first_password_text = self.global_dev_search_page.get_first_password_text(
)
self.assertEqual(
self.assert_text.account_center_page_password_formart_text(),
get_first_password_text)
# 全字母
self.global_dev_search_page.click_add_user_password_first_input_in_user_info(
'qwerqw')
self.global_dev_search_page.click_add_user_password_second_input_in_user_info(
'qwerqw')
self.global_dev_search_page.click_save_add_user()
get_first_password_text = self.global_dev_search_page.get_first_password_text(
)
self.assertEqual(
self.assert_text.account_center_page_password_formart_text(),
get_first_password_text)
# 两次密码不一致
self.global_dev_search_page.click_add_user_password_first_input_in_user_info(
'qwerqw123')
self.global_dev_search_page.click_add_user_password_second_input_in_user_info(
'qwerqw2324')
self.global_dev_search_page.click_save_add_user()
get_second_password_text = self.global_dev_search_page.get_second_password_text(
)
self.assertEqual(self.assert_text.cust_page_password_unlike(),
get_second_password_text)
class TestCase88DevManageSaleInList(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.connect_sql = ConnectSql()
self.assert_text = AssertText()
self.driver.wait(1)
self.driver.clear_cookies()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_sale_in_list(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
# 登录
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
imei_in_list = self.dev_manage_page.get_imei_in_list()
dev_type_in_list = self.dev_manage_page.get_dev_type_in_list()
# 点击批量
self.dev_manage_page.click_sale_in_list_button()
self.dev_manage_page.click_close_sale_in_list_button()
self.dev_manage_page.click_sale_in_list_button()
# 点击销售
self.dev_manage_page.click_sale_button()
# 获取打开销售之后的imei和设备类型
imei_in_sale = self.dev_manage_page.get_imei_in_sale()
self.assertEqual(imei_in_list, imei_in_sale)
dev_type_in_sale = self.dev_manage_page.get_dev_type_in_sale()
self.assertEqual(dev_type_in_list, dev_type_in_sale)
dev_account_name = self.dev_manage_page.get_dev_account_name()
connect = self.connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
get_account_sql = "select o.account from equipment_mostly e inner join user_info o on e.userId = o.userId where e.imei = '%s';" % imei_in_list
cursor.execute(get_account_sql)
account_data = cursor.fetchall()
account = account_data[0][0]
cursor.close()
connect.close()
self.assertEqual(dev_account_name, account)
# 搜索右侧客户树
# 循环点击5次
for n in range(5):
self.driver.click_element(
'x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text(
'x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
name = self.dev_manage_page.get_select_account_name()
self.assertEqual(get_account_dev_number, name)
# 搜索无数据
self.dev_manage_page.search_customer_after_click_batch_sale_dev('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text_after_batch_sale_dev(
)
self.assertIn(self.assert_text.account_center_page_no_data_text(),
get_text)
# 获取选中设备的数量
dev_number = self.dev_manage_page.get_select_dev_number()
# 获取抬头设备统计的数量
dev_numbers_count = self.dev_manage_page.get_dev_numbers()
self.assertEqual(str(dev_number), dev_numbers_count)
# 删除设备后 点击销售
self.dev_manage_page.click_detele_dev()
self.dev_manage_page.click_sale_button()
### 添加设备
# 成功添加的
self.dev_manage_page.add_dev_to_sale(imei_in_list)
# 添加重复的
self.dev_manage_page.add_dev_to_sale(imei_in_list)
# 获取失败后的imei
imei_after_add_fail = self.dev_manage_page.get_imei_after_add_fail()
self.assertEqual(imei_in_list, imei_after_add_fail)
status = self.dev_manage_page.get_status_after_add_fail()
self.assertEqual(self.assert_text.dev_page_fail_text(), status)
fail_reason = self.dev_manage_page.get_fail_reason()
self.assertEqual(self.assert_text.dev_page_repetition_text(),
fail_reason)
self.dev_manage_page.click_close_fails()
# 添加不存在的imei
self.dev_manage_page.add_dev_to_sale('我就是要添加不存在的')
# 获取失败后的imei
imei_after_add_fail = self.dev_manage_page.get_imei_after_add_fail()
self.assertEqual('我就是要添加不存在的', imei_after_add_fail)
status = self.dev_manage_page.get_status_after_add_fail()
self.assertEqual(self.assert_text.dev_page_fail_text(), status)
fail_reason = self.dev_manage_page.get_fail_reason()
self.assertEqual(self.assert_text.dev_page_inexistence_text(),
fail_reason)
self.dev_manage_page.click_close_fails()
class TestCase82DevManageBatchSale(unittest.TestCase):
def setUp(self):
self.driver = AutomateDriver()
self.base_url = self.driver.base_url
self.base_page = BasePage(self.driver, self.base_url)
self.dev_manage_page = DevManagePages(self.driver, self.base_url)
self.driver.set_window_max()
self.log_in_base = LogInBase(self.driver, self.base_url)
self.dev_manage_page_read_csv = DevManagePageReadCsv()
self.driver.wait(1)
self.driver.clear_cookies()
self.assert_text = AssertText()
self.driver.wait(1)
def tearDown(self):
self.driver.quit_browser()
def test_case_dev_manage_batch_sale(self):
# 打开途强在线首页-登录页
self.base_page.open_page()
self.log_in_base.log_in()
# 点击进入设备管理
self.dev_manage_page.enter_dev_manage()
# 选择一个设备点击批量销售
self.dev_manage_page.choose_one_dev_to_search()
get_first_imei = self.dev_manage_page.get_first_imei_in_list()
get_dev_type = self.dev_manage_page.get_dev_type_in_list()
# 点击批量
self.dev_manage_page.click_batch_sale_button()
self.dev_manage_page.click_close_batch_sale_button()
self.dev_manage_page.click_batch_sale_button()
'''# 搜索右侧客户树
# 循环点击5次
for n in range(5):
self.driver.click_element('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
name = self.dev_manage_page.get_select_account_name()
self.assertEqual(get_account_dev_number, name)
# 搜索无数据
self.dev_manage_page.search_customer_after_click_batch_sale_dev('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text_after_batch_sale_dev()
self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text)
# 获取选中设备的数量
dev_number = self.dev_manage_page.get_select_dev_number()
# 获取抬头设备统计的数量
dev_numbers_count = self.dev_manage_page.get_dev_numbers()
self.assertEqual(str(dev_number), dev_numbers_count)'''
# 验证界面
get_sale_title = self.dev_manage_page.get_sale_title_text_in_sale_dev()
self.assertEqual(self.assert_text.batch_sale_text(), get_sale_title)
get_imei_in_sale = self.dev_manage_page.get_batch_sale_imei_in_sale_dev()
self.assertEqual(get_first_imei, get_imei_in_sale)
get_dev_type_in_sale = self.dev_manage_page.get_dev_type_in_sale()
self.assertEqual(get_dev_type, get_dev_type_in_sale)
get_dev_number = self.dev_manage_page.get_dev_number_in_sale_dev()
self.assertEqual('1', get_dev_number)
get_dev_account = self.dev_manage_page.get_dev_account_name()
connect_sql = ConnectSql()
connect = connect_sql.connect_tuqiang_sql()
cursor = connect.cursor()
sql = "select m.account from equipment_mostly m where m.imei = '%s';" % get_first_imei
cursor.execute(sql)
data = cursor.fetchall()
cursor.close()
connect.close()
sql_account = data[0][0]
self.assertEqual(get_dev_account, sql_account)
# 输入不存在的IMEI号进行添加
self.dev_manage_page.add_imei_in_sale_dev_page('bucunzai')
add_dev_state = self.dev_manage_page.add_dev_after_fail_state()
self.assertEqual(self.assert_text.dev_page_fail_text(), add_dev_state)
add_dev_reason = self.dev_manage_page.add_dev_after_fail_reason()
self.assertEqual(self.assert_text.dev_page_inexistence_text(), add_dev_reason)
self.dev_manage_page.click_close_fails()
# 添加不属于当前登陆账号设备总进货数中的设备
self.dev_manage_page.add_imei_in_sale_dev_page('863666010079196')
add_dev_state = self.dev_manage_page.add_dev_after_fail_state()
self.assertEqual(self.assert_text.dev_page_fail_text(), add_dev_state)
add_dev_reason = self.dev_manage_page.add_dev_after_fail_reason()
self.assertEqual(self.assert_text.dev_page_inexistence_text(), add_dev_reason)
self.dev_manage_page.click_close_fails()
# 添加与设备列表中重复的设备
self.dev_manage_page.add_imei_in_sale_dev_page(get_first_imei)
add_dev_state = self.dev_manage_page.add_dev_after_fail_state()
self.assertEqual(self.assert_text.dev_page_fail_text(), add_dev_state)
add_dev_reason = self.dev_manage_page.add_dev_after_fail_reason()
self.assertEqual(self.assert_text.dev_page_repetition_text(), add_dev_reason)
self.dev_manage_page.click_close_fails()
# 搜索右侧客户树
# 循环点击5次
for n in range(5):
self.driver.click_element('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
sleep(2)
# 判断数量
get_account_dev_number = self.driver.get_text('x,//*[@id="treeDemo_device_sale_id_%s_span"]' % str(n + 1))
name = self.dev_manage_page.get_select_account_name()
self.assertEqual(get_account_dev_number, name)
# 搜索无数据
self.dev_manage_page.search_customer_after_click_batch_sale_dev('无数据')
get_text = self.dev_manage_page.get_search_customer_no_data_text_after_batch_sale_dev()
self.assertIn(self.assert_text.account_center_page_no_data_text(), get_text)
# 获取选中设备的数量
dev_number = self.dev_manage_page.get_select_dev_number()
# 获取抬头设备统计的数量
dev_numbers_count = self.dev_manage_page.get_dev_numbers()
self.assertEqual(str(dev_number), dev_numbers_count)
