def case_1(self, title, expected, data1, data2, dimension1):
#按用户查看1月合同金额
self.current_case = title
_Roles = testGetRoles.GetRole(self.cookie, self.csrf)
list = [
'organization_own', 'self_and_subordinate_department_own',
'self_department_own', 'self_own'
]
for i in range(4):
_Roles.ding_set_data_authority(list[i])
_result = result.result(self.cookie, self.csrf)
Actual_result = _result.gole_quarter(data1,
data2,
type='product_category_money',
dimension=dimension1)
# print (Actual_result)
test_result = operator.eq(expected[i], Actual_result)
print(test_result)
if test_result == True:
f = codecs.open('product_category_money_year.txt', 'a',
'utf-8')
a = str(self.current_case + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('product_category_money_year.txt', 'a',
'utf-8')
a = str(self.current_case + ': '
"is wrong, expected_result:'\n'" + str(expected[i]) +
"Actual_result:'\n'" + str(Actual_result) + ',' +
str(datetime.datetime.now()))
f.write(a + '\n')
def check_data_first(self, i=0):
current_case = self.title_list_first[i]
_login = login.Login()
_login.login(self.userinfo_super['username'],
self.userinfo_super['password'],
self.userinfo_super['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
# 只返回表格的排名
Actual_result = _result.sales_rank(
tpye="contract_money", scope_unit=self.date_list_first[i][0])
# 返回中间的统计值,表格的排名
Expected_result_all = _result.amount_get_user(self.month_list_first[i])
Expected_result = Expected_result_all[1]
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
print(test_result)
if test_result == True:
f = codecs.open('contract_amount.txt', 'a', 'utf-8')
a = str(
str(current_case) + '工作台对比' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_amount.txt', 'a', 'utf-8')
a = str(
str(current_case) + '工作台对比' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
def case_1(self,title,expected,data1,data2,dimension1):
#按用户查看1月合同金额
self.current_case =title
_login = login.Login()
_login.login(self.userinfo_super['username'], self.userinfo_super['password'], self.userinfo_super['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_Roles =testGetRoles.GetRole(self.cookie,self.csrf)
list=['organization_own','self_and_subordinate_department_own','self_department_own','self_own']
for i in range(4):
_Roles.ding_set_data_authority(list[i])
# print('==========')
# print (expected[i])
# print ('============')
_result=result.result(self.cookie,self.csrf)
Actual_result =_result.gole_quarter(data1,data2,type='contract_money',dimension=dimension1)
# print (Actual_result)
test_result=operator.eq(expected[i], Actual_result)
print (test_result)
if test_result== True:
f = codecs.open('contract_money_year.txt', 'a', 'utf-8')
a = str(self.current_case + ': ' "is right "+str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_money_year.txt', 'a', 'utf-8')
a = str(i)+str(self.current_case + ': ' "is wrong, expected_result:'\n'" + str(expected[i]) +"Actual_result:'\n'"+ str(Actual_result)+','+str(datetime.datetime.now()))
f.write(a + '\n')
def check_data_user(self,i =0):
current_case = self.title[i]
_login = login.Login()
_login.login(self.userinfo_super['username'], self.userinfo_super['password'], self.userinfo_super['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
# Actual_result输出三个值 图表，中间值，表格
# Actual_result_all = _result.golePayment(from_date=self.date_list[i][0],to_date=self.date_list[i][1],type = 'result_contract_rank',dimension ='user')
# Expected_result输出两个值 中间值，表格
Expected_result_all =_result.payments_amount_get_user_case1(self.month[i])
print(Expected_result_all[1])
def check_data_first(self, i, _users=['设计部-用户1', '销售部-用户5', '同部门下属-用户7']):
current_case = self.title_list_first[i]
time.sleep(2)
_login = login.Login()
_login.login(self.userinfo_['username'], self.userinfo_['password'],
self.userinfo_['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
## 业绩类型切换 合同数：contract_count 商机数：win_count 产品销量：product_count 产品分类销量：product_category_count s= 4
# print(self.date_list_first[i][0],self.title_list_first[i][0])
Actual_result = _result.sales_rank_completion(
type="product_category_count",
scope_unit=self.date_list_first[i][0],
Actual_result_month=self.title_list_first[i][0])
# Expected_result_all = _result.gongzuotai_contract_count_get_completion(_months=self.month_list_first[i],
# _users=_users,
# _month_view=self._month_view_first[
# i], s=4)
print(self.month[i], _users, self._month_view[i])
Expected_result_all = _result.count_get_completion(
_months=self.month[i],
_users=_users,
_month_view=self._month_view[i],
s=4)
print(self.month[i], _users, self._month_view[i])
print(u'1234')
print(Expected_result_all[1])
s = len(Expected_result_all[1])
for i in range(s):
test_result = operator.eq(Actual_result[i], Expected_result_all[i])
print(test_result)
if test_result == True:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(
str(current_case) + '工作台对比' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(
str(current_case) + '工作台对比' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result_all[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
def check_data_first(self,i=0):
current_case = self.title_list_first[i]
_login = login.Login()
_login.login(self.userinfo_super['username'], self.userinfo_super['password'], self.userinfo_super['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
# 只返回表格的排名
# Actual_result = _result.sales_rank(tpye="contract_count", scope_unit=self.date_list_first[i][0])
# print('========')
# print(Actual_result)
# print('===========')
# # 返回中间的统计值,表格的排名
# 个人荣誉榜
for i in range(len(self.date_type)):
for j in range(len(self.rank_type)):
_result.get_rank_by_user(self.rank_type[j], self.date_type[i])
# 部门荣誉榜
for i in range(len(self.date_type)):
for j in range(len(self.rank_type)):
_result.get_rank_by_dep(self.rank_type[j], self.date_type[i])
def check_data_user(self,
s1,
type1,
i=0,
_users=['设计部-用户1', '销售部-用户5', '同部门下属-用户7']):
current_case = self.title[i]
time.sleep(1)
_login = login.Login()
_login.login(self.userinfo_['username'], self.userinfo_['password'],
self.userinfo_['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
# Actual_result输出三个值 图表，中间值，表格
Actual_result_all = _result.gole_completion(
from_date=self.date_list[i][0],
to_date=self.date_list[i][1],
type=type1,
dimension='month',
data=self.date[i][0])
# print(Actual_result_all)
# Expected_result输出两个值 中间值，表格
Expected_result_all = _result.count_get_completion(
_months=self.month[i],
_users=_users,
_month_view=self._month_view[i],
s=s1)
# # # 比较图表的统计值是否相同
Actual_result = Actual_result_all[0]
# #图表的预期结果和表格的预期结果相同 所以取的是表格预期结果的值
Expected_result = Expected_result_all[0]
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '图表的排名' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '图表的排名' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
##比较实际中间的统计值和预期中间的统计值是否相同
Actual_result = Actual_result_all[1]
Expected_result = Expected_result_all[1]
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '中间统计排名' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '中间统计排名' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
#
#比较表格实际排名和预期排名是否相等
Actual_result = Actual_result_all[2]
Expected_result = Expected_result_all[0]
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '表格排名' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '表格排名' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
def check_data_department(self,i =0):
current_case = self.title[i]
_login = login.Login()
_login.login(self.userinfo_super['username'], self.userinfo_super['password'], self.userinfo_super['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
# Actual_result输出三个值 图表，中间值，表格
Actual_result_all = _result.gole_d(from_date=self.date_list[i][0],to_date=self.date_list[i][1],type = 'product_category_count',dimension ='department')
# Expected_result输出两个值 中间值，表格
Expected_result_all =_result.count_get_department(self.month[i],s=4)
# 比较图表的统计值是否相同
Actual_result = Actual_result_all[0]
#图表的预期结果和表格的预期结果相同 所以取的是表格预期结果的值
Expected_result = Expected_result_all[1]
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('product_category_count_d.txt', 'a', 'utf-8')
a =str(i)+ str(str(current_case)+'图表的排名' + ': ' "is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('product_category_count_d.txt', 'a', 'utf-8')
a = str(i)+str(str(current_case)+'图表的排名' + ': ' "is wrong, expected_result:'\n'" + str(
Expected_result[i]) + "Actual_result:'\n'" + str(Actual_result[i]) + ',' + str(
datetime.datetime.now()))
f.write(a + '\n')
#
#比较实际中间的统计值和预期中间的统计值是否相同
Actual_result=Actual_result_all[1]
Expected_result=Expected_result_all[0]
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True :
f = codecs.open('product_category_count_d.txt', 'a', 'utf-8')
a = str(str(current_case)+'中间统计排名' + ': ' "is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('product_category_count_d.txt', 'a', 'utf-8')
a = str(str(current_case)+'中间统计排名' + ': ' "is wrong, expected_result:'\n'" + str(
Expected_result[i]) + "Actual_result:'\n'" + str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
#
#比较表格的是否相等
Actual_result = Actual_result_all[2]
Expected_result = Expected_result_all[1]
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('product_category_count_d.txt', 'a', 'utf-8')
a = str(str(current_case) +'表格排名'+ ': ' "is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('product_category_count_d.txt', 'a', 'utf-8')
a = str(str(current_case) +'表格排名'+ ': ' "is wrong, expected_result:'\n'" + str(
Expected_result[i]) + "Actual_result:'\n'" + str(Actual_result[i]) + ',' + str(
datetime.datetime.now()))
f.write(a + '\n')
def check_data_first(self,
i=0,
_users=['设计部-用户1', '销售部-用户5', '同部门下属-用户7']):
current_case = self.title_list_first[i]
time.sleep(1)
_login = login.Login()
_login.login(self.userinfo_super['username'],
self.userinfo_super['password'],
self.userinfo_super['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_Roles = testGetRoles.GetRole(self.cookie, self.csrf)
for m in range(len(self.field_permission_grant_scope)):
### 设置用户的角色必须是普通管理员的角色
_Roles.ding_set_data_authority(
self.field_permission_grant_scope[m])
print(self.field_permission_grant_scope[m])
_login = login.Login()
_login.login(self.userinfo_['username'],
self.userinfo_['password'], self.userinfo_['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
Actual_result = _result.sales_rank_completion(
type="contract_money", scope_unit=self.date_list_first[i][0])
Actual_result[0]['month'] = self.title_list_first[i][0]
Actual_result_list = []
Actual_result_month = []
Actual_result_month.append(Actual_result[0]['month'])
Actual_result_new = {
'month': Actual_result_month,
'amount': Actual_result[0]['count'],
'goal_data': Actual_result[0]['goal_data'],
'percentage_data': Actual_result[0]['percentage_data']
}
Actual_result_list.append(Actual_result_new)
print(Actual_result_list)
Expected_result_all = _result.gongzuotai_contract_amount_get_completion(
_months=self.month_list_first[i],
_users=_users,
_month_view=self._month_view_first[i])
print(Expected_result_all)
s = len(Expected_result_all)
for i in range(s):
test_result = operator.eq(Actual_result_list[i],
Expected_result_all[i])
print(test_result)
if test_result == True:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(
str(current_case) + '工作台对比' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(
str(current_case) + '工作台对比' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result_all[i]) + "Actual_result:'\n'" +
str(Actual_result_list[i]) + ',' +
str(datetime.datetime.now()))
f.write(a + '\n')
def check_data_user(self,
s1,
type1,
i=0,
_users=['设计部-用户1', '销售部-用户5', '同部门下属-用户7'],
k=0):
current_case = self.title[i]
time.sleep(2)
_login = login.Login()
_login.login(self.userinfo_super['username'],
self.userinfo_super['password'],
self.userinfo_super['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_Roles = testGetRoles.GetRole(self.cookie, self.csrf)
### 设置用户的角色必须是普通管理员的角色
_Roles.ding_set_data_authority(self.field_permission_grant_scope[k])
print(self.field_permission_grant_scope[k])
_login = login.Login()
_login.login(self.userinfo_['username'], self.userinfo_['password'],
self.userinfo_['role'])
self.cookie = _login.cookie
self.csrf = _login.csrf
_result = result.result(self.cookie, self.csrf)
##Actual_result输出三个值 图表，中间值，表格
## 业绩类型切换 合同数：contract_count 商机数：win_count 产品销量：product_count 产品分类销量：product_category_count s= 4
Actual_result_all = _result.gole_completion(
from_date=self.date_list[i][0],
to_date=self.date_list[i][1],
type=type1,
dimension='year',
data=self.date[i][0])
# print(Actual_result_all[0])
# # # Expected_result输出两个值 中间值，表格
Expected_result_all = _result.count_get_completion_year(
_months=self.month[i],
_users=_users,
_month_view=self._month_view[i],
s=s1)
# # # # 比较图表的统计值是否相同
Actual_result = Actual_result_all[0]
# #图表的预期结果和表格的预期结果相同 所以取的是表格预期结果的值
Expected_result = Expected_result_all
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + str(
str(current_case) + '图表的排名' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '图表的排名' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
# ##比较实际中间的统计值和预期中间的统计值是否相同
Actual_result = Actual_result_all[1]
Expected_result = Expected_result_all
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('contract_number_y.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '中间统计排名' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number_y.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '中间统计排名' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
#
#比较表格实际排名和预期排名是否相等
Actual_result = Actual_result_all[2]
Expected_result = Expected_result_all
s = len(Actual_result)
for i in range(s):
test_result = operator.eq(Expected_result[i], Actual_result[i])
if test_result == True:
f = codecs.open('contract_number_y.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '表格排名' + ': '
"is right " + str(datetime.datetime.now()))
f.write(a + '\n')
else:
f = codecs.open('contract_number_y.txt', 'a', 'utf-8')
a = str(_users) + '\n' + str(
str(current_case) + '表格排名' + ': '
"is wrong, expected_result:'\n'" +
str(Expected_result[i]) + "Actual_result:'\n'" +
str(Actual_result[i]) + ',' + str(datetime.datetime.now()))
f.write(a + '\n')
