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)
def import_data(request):
rb = xlrd.open_workbook('D:\pydata\prepod_goda.xlsx')
sheet = rb.sheet_by_index(0)
ins = Institute.objects.all()[0]
n = sheet.nrows
s = 'sdads'
for rownum in range(sheet.nrows):
row = sheet.row_values(rownum)
d = row[0].strip()
t = row[1].strip()
g = row[2].strip()
dep = Department()
tech = Teacher()
group = Group()
db_d = Department.objects.filter(name=d)
if (db_d.count() == 0):
dep.name = d
dep.institute = ins
dep.save()
else:
dep = db_d[0]
db_t = Teacher.objects.filter(last_name=t)
if (db_t.count() == 0):
tech.last_name = t
tech.department = dep
tech.save()
else:
tech = db_t[0]
db_g = Group.objects.filter(name=g)
if (db_g.count() == 0):
group.name = g
group.department = dep
group.save()
else:
group = db_g[0]
group.teachers.add(tech)
group.save()
return HttpResponse("OK " + s)
from app.models import Department, Person, Project, ProjectGrp, TaskTime, ProjectType
# using unicode as the password coding
yun_hua = User(username='******', email='*****@*****.**', password=make_password('hello'))
yonghua_xu = User(username='******', email='*****@*****.**', password=make_password('hello'))
yinye_fan = User(username='******', email='*****@*****.**', password=make_password('hello'))
admin = User(username='******', email='*****@*****.**', password=make_password('hello'))
yun_hua.save()
yonghua_xu.save()
yinye_fan.save()
admin.save()
# yun_hua = User.objects.get(username='******')
engineering = Department(dept_id=600800, name='技术工程部', summary='Engineering')
engineering.save()
admin_dept = Department(dept_id=600310, name='行政部', summary='Admin')
admin_dept.save()
# engineering = Department.objects.get(dept_id='600800')
person1 = Person(user=yun_hua, employee_id=149, privilege=1, department=engineering)
person1.save()
person2 = Person(user=yonghua_xu, employee_id=61, privilege=1, department=engineering)
person2.save()
person3 = Person(user=yinye_fan, employee_id=99, privilege=1, department=engineering)
person3.save()
person_admin = Person(user=admin, employee_id=0, privilege=1, department=engineering)
person_admin.save()
type1 = ProjectType(typename='FA', summary='客户项目')
