医院科研管理系统

from django.db import models

from django.contrib.auth.models import User

class ResearchResult(models.Model):

title = models.CharField(max_length=200)

authors = models.TextField()

project = models.CharField(max_length=100)

publication_date = models.DateField()

abstract = models.TextField()

status = models.CharField(max_length=50, choices=[('pending', '待审核'), ('approved', '已批准'), ('rejected', '已驳回')])

def __str__(self):

return self.title

class UserProfile(models.Model):

user = models.OneToOneField(User, on_delete=models.CASCADE)

role = models.CharField(max_length=50, choices=[('researcher', '研究人员'), ('admin', '管理员')])

from django.contrib.auth.decorators import login_required, permission_required

from django.shortcuts import get_object_or_404

@login_required

@permission_required('research_app.can_approve', raise_exception=True)

def approve_result(request, result_id):

result = get_object_or_404(ResearchResult, id=result_id)

if request.method == 'POST':

result.status = 'approved'

result.save()

return redirect('results_list')

return render(request, 'approve.html', {'result': result})

import pandas as pd

from django.http import HttpResponse

def export_results(request):

results = ResearchResult.objects.all()

data = {

'标题': [r.title for r in results],

'作者': [r.authors for r in results],

'项目': [r.project for r in results],

'发表日期': [r.publication_date for r in results],

'摘要': [r.abstract for r in results],

'状态': [r.status for r in results]

}

df = pd.DataFrame(data)

response = HttpResponse(content_type='text/csv')

response['Content-Disposition'] = 'attachment; filename="research_results.csv"'

df.to_csv(response, index=False)

return response