DTAiLab/templates/admin/a_spornor_manage.html

{% extends 'admin/a_admindefault.html' %}

{% block mycss%}
<script src="/static/js/axios.min.js"></script>
<script type="text/javascript" src="/static/js/jquery-3.6.1.min.js"></script>
<script>
    function getSPDataInline(ptid) {
        axios.get('/getSPUnit/' + ptid).then(function (response) {
            console.log(response);
            $("#txt_SPID").val(response.data[0][0])
            $("#txt_SPCNname").val(response.data[0][1])
            $("#txt_SPENname").val(response.data[0][2])
            $("#txt_SPLink").val(response.data[0][3])
            $("#txt_SPOrder").val(response.data[0][4])
            $("#txt_SPStatus").val(response.data[0][5])
            $("#txt_SPCNname2").val(response.data[0][1])
            $("#txt_SPENname2").val(response.data[0][2])
            $("#txt_SPLink2").val(response.data[0][3])
            $("#txt_SPOrder2").val(response.data[0][4])
            $("#txt_SPStatus2").val(response.data[0][5])
        });
    }
</script>
{% endblock %}

{% block middle %}
<div class="content">
    <div class="page-inner">
        <div class="page-header">
            <h4 class="page-title">
                主页项目资助管理</h4>
        </div>

        <div class="row">
            <div class="col-md-12">
                {% with messages = get_flashed_messages() %}
                {% if messages %}
                {% for message in messages %}
                <p>{{ message }}</p>
                {% endfor %}
                {% endif %}
                {% endwith %}
                <div class="card">
                    <div class="card-header">
                        <div class="d-flex align-items-center">

                            <button class="btn btn-primary btn-round ml-auto" data-toggle="modal"
                                    data-target="#addsupportModal">
                                <i class="fa fa-plus"></i>添加新资助项
                            </button>
                        </div>
                    </div>
                    <div class="card-body">
                        <!-- Modal -->
                        <div class="modal fade" id="addsupportModal" tabindex="-1" role="dialog" aria-hidden="true">
                            <div class="modal-dialog" role="document">
                                <div class="modal-content">
                                    <div class="modal-header no-bd">
                                        <h5 class="modal-title">
                                            <span class="fw-mediumbold">新</span> <span class="fw-light">菜单项 </span>
                                        </h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <form action="/addSPUnit" method="post">
                                        <div class="modal-body">
                                            <p class="small">
                                                向数据库中添加一个新资助项。</p>
                                            <div class="row">
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            资助方中文名称: </label>
                                                        <input name="txt_CNname" type="text" class="form-control"
                                                               placeholder="填写中文名称">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            资助方英文名称: </label>
                                                        <input name="txt_ENname" type="text" class="form-control"
                                                               placeholder="填写英文名称">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            资助方图片(名称): </label>
                                                        <input name="txt_Link" type="text" class="form-control"
                                                               placeholder="填写图片链接">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            顺序: </label>
                                                        <input name="txt_Order" type="text" class="form-control"
                                                               placeholder="填写顺序">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            状态: </label>
                                                        <input name="txt_Status" type="text" class="form-control"
                                                               placeholder="填写状态">
                                                    </div>
                                                </div>
                                            </div>

                                        </div>
                                        <div class="modal-footer no-bd">
                                            <button type="submit" class="btn btn-primary">
                                                保存
                                            </button>
                                            <button type="button" class="btn btn-danger" data-dismiss="modal">
                                                关闭
                                            </button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                        <div class="modal fade" id="editsupportModal" tabindex="-1" role="dialog" aria-hidden="true">
                            <div class="modal-dialog" role="document">
                                <div class="modal-content">
                                    <div class="modal-header no-bd">
                                        <h5 class="modal-title">
                                            <span class="fw-mediumbold">编辑</span> <span class="fw-light">菜单项 </span>
                                        </h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <form action="/editSPUnit" method="post">
                                        <input id="txt_SPID" name="txt_SPID" type="hidden">
                                        <div class="modal-body">
                                            <p class="small">
                                                编辑一项资助方信息, 并保存到数据库中。</p>
                                            <div class="row">
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            中文名称: </label>
                                                        <input id="txt_SPCNname" name="txt_SPCNname" type="text"
                                                               class="form-control" placeholder="填写中文名称">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            英文名称: </label>
                                                        <input id="txt_SPENname" name="txt_SPENname" type="text"
                                                               class="form-control" placeholder="填写英文名称">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            图片(名称): </label>
                                                        <input id="txt_SPLink" name="txt_SPLink" type="text"
                                                               class="form-control" placeholder="填写图片链接">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            顺序: </label>
                                                        <input id="txt_SPOrder" name="txt_SPOrder" type="text"
                                                               class="form-control" placeholder="填写顺序">
                                                    </div>
                                                </div>
                                                <div class="col-sm-12">
                                                    <div class="form-group form-group-default">
                                                        <label>
                                                            状态: </label>
                                                        <input id="txt_SPStatus" name="txt_SPStatus" type="text"
                                                               class="form-control" placeholder="0：不显示/1：显示">
                                                    </div>
                                                </div>

                                            </div>

                                        </div>
                                        <div class="modal-footer no-bd">
                                            <button type="submit" class="btn btn-primary">
                                                保存编辑
                                            </button>
                                            <button type="button" class="btn btn-danger" data-dismiss="modal">
                                                关闭
                                            </button>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                        <div class="modal fade" id="viewsupportModal" tabindex="-1" role="dialog" aria-hidden="true">
                            <div class="modal-dialog" role="document">
                                <div class="modal-content">
                                    <div class="modal-header no-bd">
                                        <h5 class="modal-title">
                                            <span class="fw-mediumbold">查看</span> <span class="fw-light">菜单信息 </span>
                                        </h5>
                                        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                            <span aria-hidden="true">&times;</span>
                                        </button>
                                    </div>
                                    <div class="modal-body">

                                        <div class="row">
                                            <div class="col-sm-12">
                                                <div class="form-group form-group-default">
                                                    <label>
                                                        中文名称: </label><input id="txt_SPCNname2" name="text_SPCNname2"
                                                                             type="text" readonly="true">

                                                </div>
                                            </div>
                                            <div class="col-sm-12">
                                                <div class="form-group form-group-default">
                                                    <label>
                                                        英文名称: </label><input id="txt_SPENname2" name="text_SPENname2"
                                                                             type="text" readonly="true">

                                                </div>
                                            </div>
                                            <div class="col-sm-12">
                                                <div class="form-group form-group-default">
                                                    <label>
                                                        图片: </label><img src='txt_SPLink2'>
                                                </div>
                                            </div>

                                            <div class="col-sm-12">
                                                <div class="form-group form-group-default">
                                                    <label>
                                                        顺序: </label><input id="txt_SPOrder2" name="text_SPOrder2"
                                                                           type="text" readonly="true">
                                                </div>
                                            </div>
                                            <div class="col-sm-12">
                                                <div class="form-group form-group-default">
                                                    <label>
                                                        状态: </label><input id="txt_SPStatus2" name="text_SPStatus2"
                                                                           type="text" readonly="true">
                                                </div>
                                            </div>
                                        </div>

                                    </div>
                                    <div class="modal-footer no-bd">
                                        <button type="button" class="btn btn-danger" data-dismiss="modal">
                                            关闭
                                        </button>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="table-responsive">
                            <table id="add-row" class="display table table-striped table-hover">
                                <thead>
                                <tr>
                                    <th style="width: 20px">
                                        编号
                                    </th>
                                    <th style="width: 130px">
                                        资助方名称
                                    </th>
                                    <th style="width: 130px">
                                        name
                                    </th>
                                    <th style="width: 130px">
                                        资助方图片(名称)
                                    </th>
                                    <th>
                                        顺序
                                    </th>
                                    <th>
                                        状态
                                    </th>
                                    <th>
                                        操作
                                    </th>
                                </tr>
                                </thead>
                                {% for row in SPresults %}
                                <tbody>
                                <tr>
                                    <td>
                                        {{row[0]}}
                                    </td>
                                    <td>
                                        {{row[1]}}
                                    </td>
                                    <td>
                                        {{row[2]}}
                                    </td>
                                    <td>
                                        {{row[3]}}
                                    </td>
                                    <td>
                                        {{row[4]}}
                                    </td>
                                    <td>
                                        {{row[5]}}
                                    </td>
                                    <td>
                                        <div class="form-button-action">
                                            <button type="button" data-toggle="modal" title=""
                                                    class="btn btn-link btn-primary btn-lg"
                                                    data-original-title="查看详细信息" data-target="#viewsupportModal"
                                                    onclick="getSPDataInline({{row[0]}})">
                                                <i class="fa fa-search"></i>查看详细信息
                                            </button>
                                            <button type="submit" title="" class="btn btn-link btn-primary btn-lg"
                                                    data-original-title="编辑项" data-toggle="modal"
                                                    data-target="#editsupportModal"
                                                    onclick="getSPDataInline({{row[0]}})">
                                                <i class="fa fa-edit"></i>
                                            </button>
                                            <form name="delSPform" action="/delSPUnit/{{row[0]}}" method="post">
                                                <button type="submit" data-toggle="tooltip" title=""
                                                        class="btn btn-link btn-danger"
                                                        data-original-title="删除"
                                                        onclick="{if(confirm('确定要删除该项吗?')){delSPform.submit();return true;}return false;}">
                                                    <i class="fa fa-times"></i>
                                                </button>
                                            </form>
                                        </div>
                                    </td>
                                </tr>
                                {% endfor %}
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
{% endblock %}