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 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 rank_amount_baobiao(self,s1): _result_count = result_contract_rank_amount_month() for m in range(len(self.field_permission_grant_scope)): _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[m]) print(self.field_permission_grant_scope[m]) for i in range(len(_result_count.date_list)): print(i) _result_count.check_data_user(i,s1, _users=self.user[m],)
def payments_amount_baobiao(self): _result_count = result_product_amount_year() for m in range(len(self.field_permission_grant_scope)): _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[m]) print(self.field_permission_grant_scope[m]) for i in range(len(_result_count.date_list)): print(self.title[i]) _result_count.check_data_user(i, _users=self.user[m])
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')