from django.contrib import admin
from blog.models import Blog
 
#Blog模型的管理器
class BlogAdmin(admin.ModelAdmin):
    list_display=(\'id\', \'caption\', \'author\', \'publish_time\')
    
#在admin中注册绑定
admin.site.register(Blog, BlogAdmin)

from django.contrib import admin
from blog.models import Blog
 
#Blog模型的管理器
@admin.register(Blog)
class BlogAdmin(admin.ModelAdmin):
    list_display=(\'id\', \'caption\', \'author\', \'publish_time\')

from django.contrib import admin
from blog.models import Blog
 
#Blog模型的管理器
@admin.register(Blog)
class BlogAdmin(admin.ModelAdmin):    
    #设置哪些字段可以点击进入编辑界面
    list_display_links = (\'id\', \'caption\')

from django.contrib import admin
from blog.models import Blog
 
#Blog模型的管理器
@admin.register(Blog)
class BlogAdmin(admin.ModelAdmin):
    list_display = (\'id\', \'caption\', \'author\', \'publish_time\')
    
    #筛选器
    list_filter =(\'trouble\', \'go_time\', \'act_man__user_name\', \'machine_room_id__machine_room_name\') #过滤器 
    search_fields =(\'server\', \'net\', \'mark\') #搜索字段
    date_hierarchy = \'go_time\'    # 详细时间分层筛选　

class MachineInfoAdmin(admin.ModelAdmin):

    def get_readonly_fields(self, request, obj=None):
        """  重新定义此函数，限制普通用户所能修改的字段  """
        if request.user.is_superuser:
            self.readonly_fields = []
        return self.readonly_fields
    
    readonly_fields = (\'machine_ip\', \'status\', \'user\', \'machine_model\', \'cache\',
                       \'cpu\', \'hard_disk\', \'machine_os\', \'idc\', \'machine_group\')

    def save_model(self, request, obj, form, change):
        """  重新定义此函数，提交时自动添加申请人和备案号  """

        def make_paper_num():
            """ 生成随机备案号 """
            import datetime
            import random
            CurrentTime = datetime.datetime.now().strftime("%Y%m%d%H%M%S")  # 生成当前时间
            RandomNum = random.randint(0, 100)  # 生成的随机整数n，其中0<=n<=100
            UniqueNum = str(CurrentTime) + str(RandomNum)
            return UniqueNum

        obj.proposer = request.user
        obj.paper_num = make_paper_num()
        super(DataPaperStoreAdmin, self).save_model(request, obj, form, change)

    def save_model(self, request, obj, form, change):
        if change:  # 更改的时候
            machine_code = self.model.objects.get(pk=obj.pk).machine
            disk_id = self.model.objects.get(pk=obj.pk).disk_id
            disk_code = self.model.objects.get(pk=obj.pk).disk
            machine.Device.objects.filter(pk=disk_id).update(device_status=\'待报废\')
            data = {\'server_code\': machine_code,
                    \'device_type\': \'硬盘\',
                    \'original_code\': disk_code,
                    \'way\': \'变更\',
                    \'current_code\': obj.disk}
            common.DeLog.objects.create(**data)  # 创建日志
        else:  # 新增的时候
            data = {\'server_code\': obj.machine,
                    \'device_type\': \'硬盘\',
                    \'original_code\': \'\',
                    \'way\': \'新增\',
                    \'current_code\': obj.disk}
            common.DeLog.objects.create(**data)  # 创建日志
        super(MachineExDiskAdmin, self).save_model(request, obj, form, change)

    def delete_model(self, request, obj):
        machine.Device.objects.filter(pk=obj.pk).update(device_status=\'待报废\')
        data = {\'server_code\': obj.machine,
                \'device_type\': \'硬盘\',
                \'original_code\': obj.disk,
                \'way\': \'删除\',
                \'current_code\': \'\',
                \'user_name\': request.user}
        common.DeLog.objects.create(**data)  # 创建日志
        super(MachineExDiskAdmin, self).delete_model(request, obj)

    def get_readonly_fields(self, request, obj=None):
        """  重新定义此函数，限制普通用户所能修改的字段  """
        if request.user.is_superuser:
            self.readonly_fields = [\'commit_date\', \'paper_num\']
        elif hasattr(obj, \'is_sure\'):
            if obj.is_sure:
                self.readonly_fields = (\'project_name\', \'to_mail\', \'data_selected\', \'frequency\', \'start_date\',
                                        \'end_date\')
        else:
            self.readonly_fields = (\'paper_num\', \'is_sure\', \'proposer\', \'sql\', \'commit_date\')

        return self.readonly_fields

    def change_view(self, request, object_id, form_url=\'\', extra_context=None):
        change_obj = DataPaperStore.objects.filter(pk=object_id)
        self.get_readonly_fields(request, obj=change_obj)
        return super(DataPaperStoreAdmin, self).change_view(request, object_id, form_url, extra_context=extra_context)

from django.apps import AppConfig
import os


default_app_config = \'hys_operation.PrimaryBlogConfig\'

VERBOSE_APP_NAME = u"1-本地服务器资源"


def get_current_app_name(_file):
    return os.path.split(os.path.dirname(_file))[-1]


class PrimaryBlogConfig(AppConfig):
    name = get_current_app_name(__file__)
    verbose_name = VERBOSE_APP_NAME

    def expired(self, ps):
        """自定义列表字段, 根据数据单截止日期和当前日期判断是否过期,并对数据库进行更新"""
        import datetime
        from django.utils.html import format_html
        end_date = ps.end_date
        if end_date >= datetime.date.today():
            ret = \'未过期\'
            color_code = \'green\'
        else:
            ret = \'已过期\'
            color_code = \'red\'
        DataPaperStore.objects.filter(pk=ps.pk).update(is_expired=ret)
        return format_html(
                    \'<span style="color: {};">{}</span>\',
                    color_code,
                    ret,
                )
    expired.short_description = \'是否已过期\'

def copy_one(self, request, queryset):
    # 定义actions函数
    # 判断用户选择了几条数据，如果是一条以上，则报错
    if queryset.count() == 1:
        old_data = queryset.values()[0]
        old_data.pop(\'id\')
        # 将原数据复制并去掉id字段后，插入数据库，以实现复制数据功能，返回值即新数据的id（这是在model里__str__中定义的）
        r_pk = Record.objects.create(**old_data)
        # 修改数据后重定向url到新加数据页面
        return HttpResponseRedirect(\'{}{}/change\'.format(request.path, r_pk))
    else:
        self.message_user(request, "只能选取一条数据！")
copy_one.short_description = "复制所选数据"

class DailyReportDbaAdmin(admin.ModelAdmin):

    def copy_current_data(self, obj):
        """自定义一个a标签，跳转到实现复制数据功能的url"""
        dest = \'{}copy/\'.format(obj.pk)
        title = \'复制\'
        return \'<a href="{}">{}</a>\'.format(dest, title)
    copy_current_data.short_description = \'复制\'
    copy_current_data.allow_tags = True

    def get_urls(self):
        """添加一个url，指向实现复制功能的函数copy_one"""
        from django.conf.urls import url
        urls = [
            url(\'^(?P<pk>\d+)copy/?$\',
                self.admin_site.admin_view(self.copy_one),
                name=\'copy_data\'),
        ]
        return urls + super(DailyReportDbaAdmin, self).get_urls()

    def copy_one(self, request, *args, **kwargs):
        """函数实现复制本条数据，并跳转到新复制的数据的修改页面"""
        obj = get_object_or_404(DailyReportDba, pk=kwargs[\'pk\'])
        old_data = {\'create_date\': obj.create_date,
                    \'db_server\': obj.db_server,
                    \'db_user\': obj.db_user,
                    \'request_type\': obj.request_type,
                    \'request\': obj.request,
                    \'scripts\': obj.scripts,
                    \'de_proposer\': obj.de_proposer,
                    \'fde_proposer\': obj.fde_proposer,
                    \'operator\': obj.operator,
                    \'is_complete\': obj.is_complete,
                    \'remark\': obj.remark,
                    }

        r_pk = DailyReportDba.objects.create(**old_data)
        co_path = request.path.split(\'/\')
        co_path[-2] = "{}/change".format(r_pk)
        new_path = \'/\'.join(co_path)
        return redirect(new_path)

    # actions = [\'copy_one\']
    fieldsets = [
        (\'时间和服务器*\', {\'fields\': [(\'create_date\', \'db_server\', \'db_user\')]}),
        (\'需求和脚本*\', {\'fields\': [\'request_type\', \'request\', \'scripts\']}),
        (\'申请人和操作人*\', {\'fields\': [(\'de_proposer\', \'fde_proposer\', \'operator\', \'is_complete\'), \'remark\']})
    ]
    list_display = (\'create_date\', \'db_server\', \'db_user\', \'request\', \'request_type\',
                    \'de_proposer\', \'fde_proposer\', \'operator\', \'is_complete\', \'copy_current_data\', )

class RecordAdmin(admin.ModelAdmin):
    change_form_template = \'admin/extras/record_change_form.html\'
    ...

{% extends "admin/change_form.html" %}
{% load i18n admin_urls static admin_modify %}

{% block extrahead %}{{ block.super }}
<script type="text/javascript" src="{% url \'admin:jsi18n\' %}"></script>
    <script>
        django.jQuery(function() {
            var select = django.jQuery("#id_machine_room_id");
            console.log(select);
            select.change(function(){
{#                console.log("value change"+django.jQuery(this).val());#}
                var url = "/report/sub_servers/"+django.jQuery(this).val();//能够正确的访问到view的url
{#                console.log(url);#}
                django.jQuery.get(
                    url,
                    function(data){
                        var target = django.jQuery("#id_server_ip_id");
                        target.empty();//先要清空一下
                        data.forEach(function(e){
                            // 将从view得到的id和db_user名称赋值给db_server的select
                            console.log(e,e.id,e.name);
                            target.append("<option value=\'"+e.id+"\'>"+e.name+"<option>");
                            target.eq(0).attr(\'selected\', \'true\');
                        });
                })
            });

        });
    </script>
{#{{ media }}#}
{% endblock %}

from django.conf.urls import url
from hys_operation import views

urlpatterns = [
    # url(r\'^sub_users/(?P<obj_id>\d+)\', views.get_sub_users),
    url(r\'^sub_servers/(?P<obj_id>\d+)\', views.get_sub_servers),
]

def get_sub_servers(request, obj_id):
    # 查找此机房id下的ip
    servers = MachineInfo.objects.filter(idc=obj_id)
    result = []
    for i in servers:
        # 对应的id和ip组成一个字典
        result.append({\'id\': i.id, \'name\': i.machine_ip})
    # 返回json数据
    return HttpResponse(json.dumps(result), content_type="application/json")