@page
@model YBDevice.NWeb.Pages.Logger.AuditModel
@{
     ViewData["Title"] = "操作日志";
}
<div class="layui-card">
    <div class="layui-form layui-card-header layuiadmin-card-header-auto">
        <div class="layui-form-item">
               <div class="layui-inline">
                <div class="layui-input-inline">
                    <input type="text" class="layui-input" value="@Model.defaulttime" data-time="ysdatetime" autocomplete="off" name="time" id="time" placeholder="请选择时间" />
                </div>
            </div>
            <div class="layui-inline">
                <div class="layui-input-inline">
                    <input type="text" class="layui-input" placeholder="请输入操作" id="frominfo" />
                </div>
            </div>
            <div class="layui-inline">
                <div class="layui-input-inline">
                    <input type="text" class="layui-input" placeholder="请输入列名" id="info" />
                </div>
            </div>
            <div class="layui-inline">
                <button class="btn btn-primary btn-lg  js-search" type="button">查询</button>
            </div>
        </div>
    </div>
    <div class="layui-card-body">
        <table class="layui-table" id="list" lay-filter="list">
        </table>
    </div>
</div>
@section Scripts
{
    <script type="text/javascript">
        layui.use(['common', 'table', 'layer'], function () {
            var common = layui.common, table = layui.table, layer = layui.layer;
            var queryparam = [];
             var starttime = $("#time").val();
            if (starttime != "") {
                var times = starttime.split('~');
                queryparam.push({
                    "Name": 'creattime',
                    "Type": QueryCond.GreaterThanOrEqual,
                    "Value": times[0].trim()
                });
                queryparam.push({
                    "Name": 'creattime',
                    "Type": QueryCond.LessThanOrEqual,
                    "Value": times[1].trim()
                });
            }
            common.initTable({
                url: '/api/noticelogger/getauditlist',
                where: {
                    sort: "creattime",
                    order:"desc",
                    queryParam: queryparam
                }
                , method: 'post'
                , cols: [[
                    {
                        field: 'username', title: '操作人'
                    },
                    {
                        field: 'title', title: '操作'
                    },
                    {
                        field: 'tablename', title: '表名'
                    },
                    {
                        field: 'columnname', title: '列名'
                    },
                    {
                        field: 'oldvalue', title: '旧值'
                    },
                     {
                        field: 'newvalue', title: '新值'
                    },
                    {
                        field: 'creattime', title: '时间'
                    }
                ]]
            });
            $(".js-search").on("click", function () {
                var queryparam = [{
                            "Name": 'title',
                            "Type": QueryCond.Like,
                            "Value": $("#info").val()
                        }, {
                            "Name": 'columnname', 
                            "Type": QueryCond.Like,
                            "Value": $("#frominfo").val()
                        }];
                var starttime = $("#time").val();
                if (starttime != "") {
                    var times = starttime.split('~');
                    queryparam.push({
                        "Name": 'creattime',
                        "Type": QueryCond.GreaterThanOrEqual,
                        "Value": times[0].trim()
                    });
                    queryparam.push({
                        "Name": 'creattime',
                        "Type": QueryCond.LessThanOrEqual,
                        "Value": times[1].trim()
                    });
                }
                common.reloadtable("list", {
                    where: {
                        queryParam: queryparam
                    }
                });
            });
        });
    </script>
}