def fix_schedule(request): if request.method == "POST": audit_company = request.POST.get('audit_company') schedule_title = request.POST.get('schedule_title', '') schedule_content = request.POST.get('schedule_content', '') schedule_feedback = request.POST.get('schedule_feedback', '') start_time = request.POST.get('start_time', '') end_time = request.POST.get('end_time', '') project_id = uncoding(request.POST.get('project_id')) schedule_id = uncoding(request.POST.get('schedule_id')) # return HttpResponse('开发中') try: a1 = ScheduleInifo.objects.filter(id=int(schedule_id)) a = a1[0] if int(audit_company) > 0: a.audit_company_id = int(audit_company) a.schedule_title = schedule_title a.schedule_content = schedule_content a.schedule_feedback = schedule_feedback a.start_time = datetime.datetime.strptime(start_time, '%Y-%m-%d') a.end_time = datetime.datetime.strptime(end_time, '%Y-%m-%d') a.save() return JsonResponse({'status': 'ok', 'msg': '提交成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '提交失败'})
def fix_problem(request): if request.method == "POST": problem_id = uncoding(request.POST.get('problem_id')) project_id = uncoding(request.POST.get("project_id")) audit_company = request.POST.get('audit_company') problem_title = request.POST.get('problem_title', '') problem_content = request.POST.get('problem_content', '') problem_feedback = request.POST.get('problem_feedback', '') problem_class = request.POST.get('problem_class', '') problem_type = request.POST.get('problem_type', '') problem_status = request.POST.get('problem_status', '') try: a1 = ProblemInfo.objects.filter(status=True, id=int(problem_id)) a = a1[0] if int(audit_company) > 0: a.audit_company_id = int(audit_company) a.project_name_id = int(project_id) a.problem_title = problem_title a.problem_content = problem_content a.problem_feedback = problem_feedback a.problem_class = problem_class a.problem_type = problem_type a.problem_status = problem_status a.save() # AllNoticeFileInfo.objects.create(company_id=int(company_id),notice_name=int(notice_id),notice_file=notice_file1) return JsonResponse({'status': 'ok', 'msg': '修改成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '修改失败'})
def problem_list(request, project_id): project_id = uncoding(project_id) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '编码错误' }) elif not project: return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '非外审项目' }) else: do_problem_list = ProblemInfo.objects.filter(status=True, project_name_id=int(project_id), problem_status='do',username_id=None).order_by('-add_time') co_sg_problem_list = ProblemInfo.objects.filter(status=True, project_name_id=int(project_id), problem_status='co',username_id=None, problem_type='sg').order_by('-add_time') co_re_problem_list = ProblemInfo.objects.filter(status=True, project_name_id=int(project_id), problem_status='co',username_id=None, problem_type='re').order_by('-add_time') el_problem_list = ProblemInfo.objects.filter(status=True, project_name_id=int(project_id), problem_status='el',username_id=None).order_by('-add_time') problem_file_list = ProblemFileInifo.objects.filter(status=True, project_name_id=int(project_id)) switch = 'open' project_id=coding(project_id) return render(request, 'exaudit/problem_list.html', { 'project_id': project_id, 'do_problem_list': do_problem_list, 'co_sg_problem_list': co_sg_problem_list, 'co_re_problem_list': co_re_problem_list, 'el_problem_list': el_problem_list, 'problem_file_list': problem_file_list, 'switch':switch, 'project':project })
def add_schedule(request): if request.method == "POST": project_id = uncoding(request.POST.get("project_id")) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return JsonResponse({'status': 'false', 'msg': '项目编码损坏请重新进入'}) elif not project: return JsonResponse({'status': 'false', 'msg': '项目已经结束'}) else: audit_company = request.POST.get('audit_company') schedule_title = request.POST.get('schedule_title', '') schedule_content = request.POST.get('schedule_content', '') schedule_feedback = request.POST.get('schedule_feedback', '') start_time = request.POST.get('start_time', '') end_time = request.POST.get('end_time', '') # return HttpResponse('开发中') try: a = ScheduleInifo() a.company_id_id = project.company_id_id a.project_name_id = int(project_id) a.username_id = None if int(audit_company) > 0: a.audit_company_id = int(audit_company) a.schedule_title = schedule_title a.schedule_content = schedule_content a.schedule_feedback = schedule_feedback a.start_time = datetime.datetime.strptime(start_time, '%Y-%m-%d') a.end_time = datetime.datetime.strptime(end_time, '%Y-%m-%d') a.save() return JsonResponse({'status': 'ok', 'msg': '提交成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '提交失败'})
def problem_detail(request, problem_id): problem_id=uncoding(problem_id) problem_info = ProblemInfo.objects.filter(status=True, id=int(problem_id)).first() if problem_id == '0': return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '编码错误' }) elif problem_info.project_name.project_status != 'ex' and problem_info.project_name.project_exaudit != True: return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '非外审项目' }) else: project_id = problem_info.project_name_id # user = AuditMemberInfo.objects.filter(status=True, project_name_id=project_id, username_id=request.user.id).first() switch = 'open' project_is = PlansInifo.objects.filter(status=True, id=int(project_id), project_status='ex').first() audit_company = AuditCompanyInfo.objects.filter(status=True, project_name_id=int(project_id)) problem_file_list = ProblemFileInifo.objects.filter(status=True, problem_id=int(problem_id)) project_id=coding(project_id) return render(request, 'exaudit/problem_detail.html', { 'project_id': project_id, 'problem_info': problem_info, # 'user': user, 'switch': switch, 'audit_company': audit_company, 'problem_file_list': problem_file_list })
def exaudit_feedback(request): if request.method=='POST': re_problem_id=uncoding(request.POST.get('re_problem_id')) if re_problem_id == '0': return render(request, 'exaudit/exaudit_return.html', { 're_problem_msg':'编码错误' }) else: re_problem = RectificationProblemInfo.objects.filter(status=True, id=int(re_problem_id)).first() re_project = RectificationPrjectInfo.objects.filter(status=True,id=re_problem.re_project_id,re_status='pr').first() if re_project: re_feedback_list = RectificationFeedbackInfo.objects.filter(status=True,re_project_name_id=re_problem_id).order_by('-add_time') re_feedback_nm = list(set(re_feedback.id for re_feedback in re_feedback_list)) today = datetime.datetime.now().today() re_feedback_file_list = RectificationFeedbackFileInfo.objects.filter(status=True, re_feedback_id__in=re_feedback_nm) return render(request,'exaudit/exaudit_feedback.html',{ 're_project':re_project, # 're_project_id':re_project_id, 're_problem':re_problem, 're_feedback_list':re_feedback_list, 'today':today, 're_feedback_file_list':re_feedback_file_list, 're_problem_id':coding(re_problem_id) }) else: return render(request, 'exaudit/exaudit_return.html', { 're_problem_msg':'项目已整改结束' })
def start_detail1(request,project_id): switch = 'open' # switch_stauts = PlansInifo.objects.filter(status=True, id=int(project_id), project_status='cp').first() # if switch_stauts: # switch = 'close' project_id = uncoding(project_id) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '编码错误' }) elif not project: return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '非外审项目' }) else: notice_info = AllNoticeInfo.objects.filter(status=True, company_id_id=project.company_id_id, project_name_id=int(project_id), notice_type='audit').first() if notice_info: notice_id_1 = notice_info.id notice_file = AllNoticeFileInfo.objects.filter(status=True, notice_name_id=int(notice_id_1)) else: notice_file = '' start_detail = StartInfo.objects.filter(status=True, company_id=project.company_id_id, project_name=int(project_id)).first() start_file = StartFieldInfo.objects.filter(status=True, project_name=int(project_id)) audit_company = AuditCompanyInfo.objects.filter(status=True, project_name_id=int(project_id)) project_member = AuditMemberInfo.objects.filter(status=True, project_name_id=int(project_id)) member_list_id = list(set(member.username.id for member in project_member)) user_list = UserProfile.objects.filter(is_active='1', company_name=project.company_id_id) except_member_list = list(set(member.id for member in user_list)) except_member = user_list.exclude(id__in=member_list_id) # member_list = project_member.filter(username_id=request.user.id) # if member_list: # member = member_list[0] # else: # member = '' project_name = PlansInifo.objects.filter(id=int(project_id), status=True).first() project_id = coding(int(project_id)) return render(request, 'exaudit/start_detail.html', { 'project_id': project_id, 'switch': switch, 'notice_info': notice_info, 'notice_file': notice_file, 'start_detail': start_detail, 'start_file': start_file, 'audit_company': audit_company, 'project_member': project_member, # 'member': member, 'except_members': except_member, 'project_name': project_name, 'project':project })
def schedule_detail(request, schedule_id): schedule_id = uncoding(schedule_id) schedule_info = ScheduleInifo.objects.filter(id=int(schedule_id),project_name__project_status='ex',project_name__project_exaudit=True) if schedule_id == '0': return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '编码错误' }) elif not schedule_info: return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '非外审项目' }) else: user = schedule_info.first() project_id = user.project_name.id audit_company = AuditCompanyInfo.objects.filter(status=True, project_name_id=project_id) sc_file_list = ScheduleFileInifo.objects.filter(status=True, project_name=project_id) member_name_list = AuditMemberInfo.objects.filter(project_name_id=int(project_id)) # member_user = member_name_list.filter(username_id=request.user.id).first() title = PlansInifo.objects.filter(id=int(project_id), status=True).first() switch = 'close' if title.project_status == 'ex' : switch = 'open' project_id=coding(project_id) schedule_id=coding(schedule_id) return render(request, 'exaudit/schedule_detail.html', { 'schedule_id': schedule_id, 'user': user, 'project_id': project_id, 'audit_company': audit_company, 'sc_file_list': sc_file_list, 'member_name':member_name_list, # 'member_user':member_user, 'title':title, 'switch':switch })
def start_file_del(request): project_id = uncoding(request.GET.get('project_id')) start_file = request.GET.get('start_file') try: start_file1 = StartFieldInfo.objects.filter(project_name_id=int(project_id),status=True,id=int(start_file)) a = start_file1[0] a.status = False a.save() return JsonResponse({'status': 'ok', 'msg': '附件删除成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '附件删除失败'})
def add_problem_file(request): if request.method == "POST": project_id = uncoding(request.POST.get('project_id')) problem_file = request.FILES.get('problem_file') problem_id = uncoding(request.POST.get('problem_id')) audit_company = request.POST.get('audit_company') try: a = ProblemFileInifo() a.project_name_id = int(project_id) project_info=PlansInifo.objects.filter(status=True,id=int(project_id)).first() a.company_id_id = project_info.company_id_id if int(audit_company) > 0: a.audit_company_id = int(audit_company) a.username_id = None a.problem_file = problem_file a.problem_id_id = int(problem_id) a.save() return JsonResponse({'status': 'ok', 'msg': '附件上传成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '附件上传失败'})
def start_info(request): if request.method == "POST": project_id = uncoding(request.POST.get('project_id')) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return JsonResponse({'status': 'false', 'msg': '项目编码损坏请重新进入'}) elif not project: return JsonResponse({'status': 'false', 'msg': '项目已经结束'}) else: start_name = request.POST.get('start_name') start_target = request.POST.get('start_target') start_range = request.POST.get('start_range') start_basis = request.POST.get('start_basis') start_content = request.POST.get('start_content') start_progress = request.POST.get('start_progress') start_date = request.POST.get('start_date') company_id=project.company_id_id start_info = StartInfo.objects.filter(project_name_id=int(project_id), status=True) if start_info: start_info1 = start_info[0] try: a = start_info1 a.company_id_id = company_id a.project_name_id = int(project_id) a.start_username_id = 1 a.start_name = start_name a.start_target = start_target a.start_range = start_range a.start_basis = start_basis a.start_content = start_content a.start_progress = start_progress a.start_date = datetime.datetime.strptime(start_date, '%Y-%m-%d') a.save() return JsonResponse({'status': 'ok', 'msg': '更新成功1'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '更新失败1'}) else: start_info = StartInfo() try: a = start_info a.company_id_id = company_id a.project_name_id = int(project_id) a.start_username_id = 1 a.start_name = start_name a.start_target = start_target a.start_range = start_range a.start_basis = start_basis a.start_content = start_content a.start_progress = start_progress a.start_date = datetime.datetime.strptime(start_date, '%Y-%m-%d') a.save() return JsonResponse({'status': 'ok', 'msg': '更新成功2'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '更新失败2'})
def del_feedback_file(request): feedback_file_id = uncoding(request.GET.get('feedback_file')) feedback_file_list1 = FeedbackFileInifo.objects.filter(status=True, id=int(feedback_file_id)) feedback_file1 = feedback_file_list1[0] try: a = feedback_file1 a.status = False a.save() return JsonResponse({'status': 'ok', 'msg': '删除成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '删除失败'})
def schedule_del(request): schedule_id = request.GET.get('schedule_id') project_id = uncoding(request.GET.get('project_id')) schedule_list = ScheduleInifo.objects.filter(status=True, id=int(schedule_id), project_name_id=int(project_id)) schedule = schedule_list[0] try: a = schedule a.status = False a.save() return JsonResponse({'status': 'ok', 'msg': '删除成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '删除失败'})
def del_problem_file(request): problem_file_id = request.GET.get('problem_file') problem_id = uncoding(request.GET.get('problem_id')) problem_file_list1 = ProblemFileInifo.objects.filter(status=True, id=int(problem_file_id)) problem_file1 = problem_file_list1[0] try: a = problem_file1 a.status = False a.save() return JsonResponse({'status': 'ok', 'msg': '删除成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '删除失败'})
def re_feedback_file(request): re_problem_id = int(uncoding(request.POST.get('re_problem_id'))) re_problem = RectificationProblemInfo.objects.filter(status=True, id=re_problem_id).first() re_feedback_id = request.POST.get('re_feedback_id') re_feedback_file = request.FILES.get('re_feedback_file') try: a=RectificationFeedbackFileInfo() a.company_id_id=re_problem.company_id_id a.re_feedback_id=int(re_feedback_id) a.re_file=re_feedback_file a.save() return JsonResponse({'status': 'ok', 'msg': '新增成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '新增失败'})
def audit_company_del(request): project_id = uncoding(request.GET.get('project_id')) audit_company_id=request.GET.get('audit_company_id') # audit_company_person=request.GET.get('audit_company_person') try: audit_company1 = AuditCompanyInfo.objects.filter(project_name_id=int(project_id),id=int(audit_company_id),status=True) a = audit_company1[0] # a.audit_company=audit_company # a.audit_person=audit_company_person a.status = False a.save() return JsonResponse({'status': 'ok', 'msg': '被审计人删除成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '被审计人删除失败'})
def clean_doubts(request): project_id=uncoding(request.POST.get('project_id')) problem_list=ProblemInfo.objects.filter(status=True,project_name_id=int(project_id),problem_status='do') if problem_list: try: for problem in problem_list: a=problem a.problem_status='co' a.save() return JsonResponse({'status': 'ok', 'msg': '更新成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '更新失败'}) else: return JsonResponse({'status': 'false', 'msg': '没有疑点需要确认'})
def auto_problem_class(request): problem_class = request.GET.get('problem_class') project_id = uncoding(request.GET.get('project_id')) if problem_class: project_info_list = PlansInifo.objects.filter(status=True, id=int(project_id)) project_info = project_info_list[0] result_list = ProblemInfo.objects.filter(company_id_id=project_info.company_id_id, problem_class__icontains=problem_class, status=True) result=list(set(result1.problem_class for result1 in result_list)) if len(result) == 1: result = result[0] return JsonResponse({'status': 'ok', 'msg': result}) elif result_list: result = '1' + str(result) return JsonResponse({'status': 'false', 'msg': result}) else: pass
def add_feedback_file(request): if request.method == "POST": project_id = uncoding(request.POST.get('project_id')) feedback_file = request.FILES.get('feedback_file') feedback_type = request.POST.get('feedback_type') project_info=PlansInifo.objects.filter(status=True,id=int(project_id)).first() try: a = FeedbackFileInifo() a.project_name_id = int(project_id) a.company_id_id = project_info.company_id_id a.username_id = None a.feedback_file = feedback_file a.feedback_type = feedback_type a.save() return JsonResponse({'status': 'ok', 'msg': '附件上传成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '附件上传失败'})
def add_feedback(request): if request.method == "POST": re_department=request.POST.get('re_department') re_person=request.POST.get('re_person') re_improve=request.POST.get('re_improve') re_date=request.POST.get('re_date') re_situation=request.POST.get('re_situation') accountability_is=request.POST.get('accountability_is') accountability_content=request.POST.get('accountability_content') announcement_is=request.POST.get('announcement_is') remarks=request.POST.get('remarks') re_problem_id=int(uncoding(request.POST.get('re_problem_id'))) re_problem = RectificationProblemInfo.objects.filter(status=True, id=re_problem_id).first() re_project = RectificationPrjectInfo.objects.filter(status=True, id=re_problem.re_project_id, re_status='pr').first() try: a=RectificationFeedbackInfo() a.re_project_name_id=re_problem_id a.company_id_id=re_project.company_id_id a.re_improve=re_improve a.re_department=re_department a.re_person=re_person a.re_date=datetime.datetime.strptime(re_date,'%Y-%m-%d') a.re_situation=re_situation a.accountability_is=accountability_is a.accountability_content=accountability_content a.announcement_is=announcement_is a.remarks=remarks a.save() re_problem=RectificationProblemInfo.objects.filter(status=True,id=int(re_problem_id)) b=re_problem[0] b.re_improve=re_improve b.re_department = re_department b.re_person = re_person b.re_date = datetime.datetime.strptime(re_date, '%Y-%m-%d') b.re_situation = re_situation b.accountability_is = accountability_is b.accountability_content = accountability_content b.announcement_is = announcement_is b.remarks = remarks b.username_id=None b.save() return JsonResponse({'status': 'ok', 'msg': '添加成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '添加失败'})
def start_file(request): start_file = request.FILES.get("start_file") project_id = uncoding(request.POST.get("project_id")) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return JsonResponse({'status': 'false', 'msg': '项目编码损坏请重新进入'}) elif not project: return JsonResponse({'status': 'false', 'msg': '项目已经结束'}) else: try: a = StartFieldInfo() a.project_name_id = int(project_id) a.start_file = start_file a.save() # AllNoticeFileInfo.objects.create(company_id=int(company_id),notice_name=int(notice_id),notice_file=notice_file1) return JsonResponse({'status': 'ok', 'msg': '方案附件上传成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '方案附件上传失败'})
def problem_add(request, project_id): project_id = uncoding(project_id) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '编码错误' }) elif not project: return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '非外审项目' }) else: audit_company = AuditCompanyInfo.objects.filter(project_name_id=int(project_id), status=True) project_id=coding(project_id) return render(request, 'exaudit/problem_add.html', { 'project_id': project_id, 'audit_company': audit_company })
def schedule_file_del(request): project_id = uncoding(request.GET.get("project_id")) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return JsonResponse({'status': 'false', 'msg': '项目编码损坏请重新进入'}) elif not project: return JsonResponse({'status': 'false', 'msg': '项目已经结束'}) else: schedule_file_id = request.GET.get('schedule_file_id') schedule_file_list1 = ScheduleFileInifo.objects.filter(status=True, id=int(schedule_file_id)) schedule_file1 = schedule_file_list1[0] try: a = schedule_file1 a.status = False a.save() return JsonResponse({'status': 'ok', 'msg': '删除成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '删除失败'})
def schedule_list(request, project_id): project_id = uncoding(project_id) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '编码错误' }) elif not project: return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '非外审项目' }) else: keyword = request.GET.get('keyword', '') sc_list = ScheduleInifo.objects.filter(project_name_id=int(project_id), status=True) user_list = sc_list.filter(username_id=None).order_by('-add_time') if keyword: user_list = sc_list.filter(username_id=None).order_by('-add_time').filter( Q(schedule_title__icontains=keyword) | Q(schedule_content__icontains=keyword) | Q( schedule_feedback__icontains=keyword) | Q(audit_company__audit_company__icontains=keyword) | Q( audit_company__audit_person__icontains=keyword)) title = PlansInifo.objects.filter(id=int(project_id), status=True).first() this_date = datetime.date.today() member_name_list = AuditMemberInfo.objects.filter(project_name_id=int(project_id)) # member_user = member_name_list.filter(username_id=request.user.id).first() sc_file_list = ScheduleFileInifo.objects.filter(status=True, project_name_id=int(project_id)) audit_company = AuditCompanyInfo.objects.filter(status=True, project_name_id=int(project_id)) project_id=coding(project_id) return render(request, 'exaudit/schedule_list.html', { 'project_id': project_id, 'sc_list': sc_list, 'user_list': user_list, 'title': title, 'this_date': this_date, 'member_name': member_name_list, 'sc_file_list': sc_file_list, 'audit_company': audit_company, # 'member_user': member_user })
def audit_company_info(request): if request.method == "POST": project_id = uncoding(request.POST.get("project_id")) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return JsonResponse({'status': 'false', 'msg': '项目编码损坏请重新进入'}) elif not project: return JsonResponse({'status': 'false', 'msg': '项目已经结束'}) else: audit_company = request.POST.get("audit_company") audit_company_person = request.POST.get("audit_company_person") try: a = AuditCompanyInfo() a.project_name_id = int(project_id) a.audit_company = audit_company a.audit_person = audit_company_person a.save() # AllNoticeFileInfo.objects.create(company_id=int(company_id),notice_name=int(notice_id),notice_file=notice_file1) return JsonResponse({'status': 'ok', 'msg': '被审计人更新成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '被审计人更新失败'})
def schedule_file(request): project_id = uncoding(request.POST.get("project_id")) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return JsonResponse({'status': 'false', 'msg': '项目编码损坏请重新进入'}) elif not project: return JsonResponse({'status': 'false', 'msg': '项目已经结束'}) else: schedule_file1 = request.FILES.get('schedule_file') audit_company = request.POST.get('audit_company') try: a = ScheduleFileInifo() a.project_name_id = int(project_id) a.company_id_id = project.company_id_id if int(audit_company) > 0: a.audit_company_id = int(audit_company) a.username_id = None a.schedule_file = schedule_file1 a.save() return JsonResponse({'status': 'ok', 'msg': '附件上传成功'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '附件上传失败'})
def notice_info(request): if request.method == "POST": project_id = uncoding(request.POST.get('project_id')) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0' or not project: return JsonResponse({'status': 'false', 'msg': '无法更新通知信息'}) else: notice_name = request.POST.get('notice_name') notice_info = AllNoticeInfo.objects.filter(status=True, company_id=project.company_id_id, project_name=int(project_id), notice_type='audit') if notice_info: notice_info1 = notice_info[0] try: a = notice_info1 a.notice_name = notice_name a.project_name_id = int(project_id) a.notice_type = 'audit' a.company_id_id = int(project.company_id_id) a.save() return JsonResponse({'status': 'ok', 'msg': '修改成功1'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '修改失败1'}) else: notice_info = AllNoticeInfo() try: a = notice_info a.notice_name = notice_name a.notice_NO = '请补充审计通知编号' a.project_name_id = int(project_id) a.notice_type = 'audit' a.company_id_id = int(project.company_id_id) a.save() return JsonResponse({'status': 'ok', 'msg': '修改成功2'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '修改失败2'})
def report_detail(request, project_id): project_id = uncoding(project_id) project = PlansInifo.objects.filter(status=True, id=int(project_id), project_exaudit=True,project_status='ex').first() if project_id == '0': return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '编码错误' }) elif not project: return render(request, 'exaudit/exaudit_return.html', { 'project_msg': '非外审项目' }) else: feedback_file_list = FeedbackFileInifo.objects.filter(status=True, project_name_id=int(project_id)).order_by( 'add_time') switch = 'close' project_info = PlansInifo.objects.filter(status=True, id=int(project_id),project_status='ex').first() if project_info: switch = 'open' # member = AuditMemberInfo.objects.filter(status=True, username_id=request.user.id,project_name_id=int(project_id)).first() notice_info = AllNoticeInfo.objects.filter(status=True, company_id_id=project.company_id_id, project_name_id=int(project_id), notice_type='report').first() report_type1=['fi','fifi'] report_fi_file=ReportFileInifo.objects.filter(status=True,project_name_id=int(project_id),report_type__in=report_type1).order_by('add_time') report_type2=['pr','prfi'] report_pr_file=ReportFileInifo.objects.filter(status=True,project_name_id=int(project_id),report_type__in=report_type2).order_by('add_time') project_id=coding(project_id) return render(request, 'exaudit/report_detail.html', { 'project_id': project_id, 'feedback_file_list': feedback_file_list, 'switch': switch, # 'member': member, 'notice_info': notice_info, 'report_fi_file':report_fi_file, 'report_pr_file':report_pr_file })
def notice_info1(request): if request.method == "POST": project_id = uncoding(request.POST.get('project_id')) project_info = PlansInifo.objects.filter(status=True,id=int(project_id)).first() notice_name = request.POST.get('notice_name') notice_NO = request.POST.get('notice_NO') notice_info = AllNoticeInfo.objects.filter(status=True, company_id=project_info.company_id_id, project_name=int(project_id), notice_type='report') if notice_info: notice_info1 = notice_info[0] try: a = notice_info1 a.notice_name = notice_name if not notice_info1.notice_NO: a.notice_NO = '请补充审计报告编号' a.notice_type = 'report' a.project_name_id = int(project_id) a.company_id_id = project_info.company_id_id a.save() return JsonResponse({'status': 'ok', 'msg': '修改成功1'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '修改失败1'}) else: notice_info = AllNoticeInfo() try: a = notice_info a.notice_name = notice_name a.notice_NO = '请补充审计报告编号' a.notice_type = 'report' a.project_name_id = int(project_id) a.company_id_id = project_info.company_id_id a.save() return JsonResponse({'status': 'ok', 'msg': '修改成功2'}) except Exception as e: return JsonResponse({'status': 'false', 'msg': '修改失败2'})