def test_a004_bmyg_add(self):
try:
conn = MySQL.connect_os()
cur = conn.cursor()
sql = "select a.role_id,b.dep_id from role a,department b where a.app_name='cp' and a.partner_id=" + cpComId + " and b.partner_id=a.partner_id and depart_name="+"'自动化';"
cur.execute(sql)
sql_result = cur.fetchone()[0:2]
roles = sql_result[0]
depId = sql_result[1]
empName = ''.join(random.sample(['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'x', 'j'], 6))
jobNo = ''.join(random.sample(['1', '2', '3', '4', '5', '6', '7', '8', '9', '0'], 6))
mobile_02 = ''.join(random.sample(['1', '2', '3', '4', '5', '6', '7', '8', '9', '0'], 8))
mobile_01 = '131'
mobile = mobile_01 + mobile_02
mail_01 = '@qq.com'
mail = mobile + mail_01
params = [
{"roles": [roles], "departments": [{"depId": depId, "position": 1}], "empName": empName, "jobNo": jobNo,
"email": mail, "phone": mobile, "status": 1,
"entryDate": "2018-05-02T16:00:00.000Z"}]
url = "http://cp.ejw.cn/cp/v1/partner/"+cpComId+"/employees"
result_act = requests.post(url, data=json.dumps(params), headers=headers)
result_exp = 200
self.assertEqual(result_exp, result_act.status_code)
log.info("企业设置-部门及员工管理, 新增员工结果如下：")
log_exp.info(result_exp)
log_act.info(result_act.text)
except TypeError:
log.info("数据库异常或角色、部门信息为空")
def test_a002_bmyg_serach(self):
try:
conn = MySQL.connect_os()
cur = conn.cursor()
sql = "select b.dep_id from employee a,department b where a.partner_id=b.partner_id and a.emp_id=" + cpEmpId
cur.execute(sql)
sql_result = cur.fetchone()[0:1]
dep_id = str(sql_result[0])
emp_name = "xxxxxxxxxxxxxxxxxxx"
url = "http://cp.ejw.cn/cp/v1/partner/" + cpComId + "/employees?depId=" + dep_id + "&pageNo=1&pageSize=10&sort=%7B%22gmtCreate%22%3A%22desc%22%7D&curEmpId=" + cpEmpId + "&jobNoOrEmpName=" + emp_name
result = requests.get(url, headers=headers)
result_act = result.text
self.assertNotIn(emp_name, result_act, msg="没有查询到该用户信息")
log.info("企业设置-部门员工管理, 不存在的员工信息查询如下：")
log_exp.info(emp_name)
log_act.info(result_act)
except TypeError:
log.info("该企业不存在用户信息")
def test_a001_bmyg_serach(self):
global log, log_exp, log_act
log_exp = Logger(logger="供应商平台_预期结果").getlog()
log_act = Logger(logger="供应商平台_实际结果").getlog()
log = Logger(logger="供应商平台").getlog()
try:
conn = MySQL.connect_os()
cur = conn.cursor()
sql = "select a.emp_name,b.dep_id from employee a,department b where a.partner_id=b.partner_id and a.emp_id=" + cpEmpId
cur.execute(sql)
sql_result = cur.fetchone()[0:2]
emp_name = sql_result[0]
dep_id = str(sql_result[1])
url = "http://cp.ejw.cn/cp/v1/partner/" + cpComId + "/employees?&pageNo=1&pageSize=10&sort=%7B%22gmtCreate%22%3A%22desc%22%7D&curEmpId=" + cpEmpId + "&jobNoOrEmpName=" + emp_name
result = requests.get(url, headers=headers)
result_act = result.text
self.assertIn(emp_name, result_act, msg="没有查询到该用户信息")
log.info("企业设置-部门员工管理, 已存在的员工信息查询信息如下：")
log_exp.info(emp_name)
log_act.info(result_act)
except TypeError:
log.info("该企业不存在用户信息")
