def department_insert_data():
departments = {
u'管理中心': (None,''),
u'技术中心': (None, ''),
u'营销中心': (None, ''),
u'行政部': (Department.query.filter_by(name=u"管理中心").first(),''),
u'财务部': (Department.query.filter_by(name=u"管理中心").first(), ''),
u'运维部': (Department.query.filter_by(name=u"技术中心").first(), ''),
u'DBA部': (Department.query.filter_by(name=u"技术中心").first(), ''),
u'开发部': (Department.query.filter_by(name=u"技术中心").first(), ''),
u'测试部': (Department.query.filter_by(name=u"技术中心").first(), ''),
u'市场部': (Department.query.filter_by(name=u"营销中心").first(), ''),
u'活动部': (Department.query.filter_by(name=u"营销中心").first(), ''),
}
for r in departments:
department = Department.query.filter_by(name=r).first()
if department is None:
department = Department(name=r)
if isinstance(departments[r][0], int):
department.parent_id = departments[r][0]
else:
department.parent = departments[r][0]
department.description = departments[r][1]
db.session.add(department)
db.session.commit()
print "Insert department test data."
def dept_add(request):
"""
添加部门
:param request:
:return:
"""
if request.method == 'GET':
# 展示所有部门名称,用于显示上级部门下拉选择框
departments = Department.objects.filter(is_delete=0)
return render(request, 'dept/deptAdd.html', {'departments': departments})
if request.method == 'POST':
msg = {
'code': 0,
'msg': '请求成功'
}
data = request.POST.dict()
# 获取部门编号
d_id = data.get('d_id')
# 查询是否已存在此部门
department = Department.objects.filter(d_id=d_id)
# 如果存在, 则更改部门信息
if department:
department = department.first()
else:
# 不存在此部门,则新增一个部门
department = Department()
# 保存部门信息
department.department = data.get('department')
department.department_num = data.get('department_num')
department.higher_id = data.get('higher_id')
department.description = data.get('description')
department.save()
return JsonResponse(msg)
