验证销售部门的数据查看权限-脚本demo-优快云博客

 1 # coding:utf-8
 2 '''
 3 @file: run_old.py
 4 @author: jingsheng hong
 5 @ide: PyCharm
 6 @createTime: 2019年08月20日  17点16分
 7 @contactInformation: 727803257@qq.com
 8 '''
 9 
10 import sys
11 
12 from tableData.m_tp_account import M_tp_account
13 from tableData.m_tp_store import M_tp_store
14 
15 class Run:
16 
17     '''验证销售部门的数据查看权限'''
18 
19     def __init__(self,account_id:int):
20         '''
21         :param  account_id  登录后台的账号id/账号表单个主键id （模拟业务流程，从后台登录页面登录成功后，会传给该后台服务器接口一个登录账号id）
22         '''
23         self.account_id = account_id
24         self.account_information()
25         self.store_information()
26 
27     def account_information(self):
28         '''获取:账号A的单条账号表数据'''
29         # 校验account_id是否存在且是否有效
30         account_information = M_tp_account().mysql_account_information(self.account_id)
31         # 关联的员工id
32         self.staff_id = account_information["staff_id"]
33         # 可查看数据范围
34         self.viewable_data_range = account_information["viewable_data_range"]
35         # 数据权限类型
36         self.data_permission_type = account_information["data_permission_type"]
37         # 五种数据权限类型对应的可查看的部门清单
38         self.department_of_viewable = account_information["department_of_viewable"]
39 
40     def store_information(self):
41         '''返回：符合数据查看权限规则的销售部门数据'''
42         store_information = M_tp_store().mysql_store_information(self.account_id,self.staff_id,self.viewable_data_range,self.data_permission_type,self.department_of_viewable)
43         return store_information
44 
45 
46 
47 if __name__ == "__main__":
48     # 填写登录账号id即可
49     Run(sys.argv[1])