swiftadmin/app/admin/view/pdm_partitem_relation/index.html

<include file="/public/header" />
<!--partmanage-->
<div class="layui-fluid">
    <div class="layui-card">
        <!-- // 默认操作按钮 -->
        <div class="layui-card-header layadmin-card-header-auto ">
            <div class="layui-form">
                <!-- // 自定义搜索参数 -->
                <div id="laytable-search" class="layui-form-item">
                    <!-- <div class="layui-inline">
                        <div class="layui-form-label">{:__('ID')}</div>
                        <div class="layui-input-inline ">
                            <input name="id" class="layui-input" type="text" placeholder="{:__('ID')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('父ID')}</div>
                        <div class="layui-input-inline ">
                            <input name="pid" class="layui-input" type="text" placeholder="{:__('父ID')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('排序')}</div>
                        <div class="layui-input-inline ">
                            <input name="sort" class="layui-input" type="text" placeholder="{:__('排序')}" />
                        </div>
                    </div> -->

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('SymbolID')}</div>
                        <div class="layui-input-inline ">
                            <input name="symbolid" class="layui-input" type="text" placeholder="{:__('SymbolID')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('FootprintID')}</div>
                        <div class="layui-input-inline ">
                            <input name="footprintid" class="layui-input" type="text"
                                placeholder="{:__('FootprintID')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('创建者ID')}</div>
                        <div class="layui-input-inline ">
                            <input name="creatorid" class="layui-input" type="text" placeholder="{:__('创建者ID')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('部门ID')}</div>
                        <div class="layui-input-inline ">
                            <input name="departmentid" class="layui-input" type="text" placeholder="{:__('部门ID')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('注释')}</div>
                        <div class="layui-input-inline ">
                            <input name="content" class="layui-input" type="text" placeholder="{:__('注释')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('更新时间')}</div>
                        <div class="layui-input-inline ">
                            <input name="update_time" lay-datetime data-range="true" data-type="date"
                                data-dateformat="yyyy/MM/dd" class="layui-input" type="text"
                                placeholder="{:__('更新时间')}" />
                        </div>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('创建时间')}</div>
                        <div class="layui-input-inline ">
                            <input name="create_time" lay-datetime data-range="true" data-type="date"
                                data-dateformat="yyyy/MM/dd" class="layui-input" type="text"
                                placeholder="{:__('创建时间')}" />
                        </div>
                    </div>
                </div>
                <div class="layui-form-item">
                    <div class="layui-inline">
                        <select name="status">
                            <option value="">{:__('按状态查询')}</option>
                            <option value="2">{:__('正常')}</option>
                            <option value="1">{:__('关闭')}</option>
                        </select>
                    </div>

                    <div class="layui-inline">
                        <div class="layui-form-label">{:__('PartNumber')}</div>
                        <div class="layui-input-inline ">
                            <input name="partnumber" class="layui-input" type="text"
                                placeholder="{:__('PartNumber')}" />
                        </div>
                    </div>
                    <div class="layui-inline">
                        <!-- // 默认搜索 -->
                        <button class="layui-btn icon-btn" lay-filter="formSearch" lay-submit><i
                                class="layui-icon layui-icon-search"></i>{:__('搜索')}</button>
                        <!--formBegin-->
                        <button class="layui-btn icon-btn" lay-open="" data-title="{:__('添加')}" data-area="1100px,750px"
                            data-maxmin="true" data-url="{:url('/PdmPartitemRelation/add')}">
                            <i class="layui-icon layui-icon-add-1"></i>{:__('添加')}
                        </button>


                        <!-- 自定义功能按钮 -->
                        <button id="updataAll" class="layui-btn layui-btn-primary">
                            <i class="layui-icon layui-icon-refresh"></i>{:__('更新CIS数据')} 
                        </button>

                        <!--formEnd-->
                    </div>
                </div>
            </div>
        </div>
        <!-- // 创建数据实例 -->
        <table id="lay-tableList" lay-filter="lay-tableList"></table>
    </div>
</div>

<!-- // 列表状态栏 -->
<script type="text/html" id="columnStatus">
    <input type="checkbox" lay-filter="switchStatus" data-url="{:url('/PdmPartitemRelation/status')}" value="{{d.id}}" lay-skin="switch" {{d.status==1?'checked':''}}  />
</script>

<!-- // 列表工具栏 -->
<script type="text/html" id="tableBar">
    <!--formBegin-->
<a class="layui-table-text" data-title="{:__('编辑')}" data-area="1100px,750px" data-maxmin="true"
    data-url="{:url('/PdmPartitemRelation/edit')}?id={{d.id}}" lay-event="edit">{:__('编辑')}</a>
<div class="layui-divider layui-divider-vertical"></div>
<!--formEnd-->
<a class="layui-table-text" data-url="{:url('/PdmPartitemRelation/del')}?id={{d.id}}" lay-event="del">{:__('删除')}</a>

<div class="layui-divider layui-divider-vertical"></div>
<!-- <a class="layui-table-text" data-title="{:__('更新')}" 
    callback="test"   data-url="{:url('/PdmPartitemRelation/update')}?id={{d.id}}" lay-event="test" >{:__('更新')}</a> -->
    <a class="layui-table-text" data-title="{:__('更新')}" 
      data-url="{:url('/PdmPartitemRelation/updata')}?id={{d.id}}" lay-event="userdf" >{:__('更新')}</a>

</script>



<script type="text/html" id="tableButton"></script>

<include file="/public/footer" />
<script>
    layui.use(['jquery','admin', 'table' ,'show' ,'i18n'], function () {
        let $ = layui.jquery;
        var admin = layui.admin;
        var table = layui.table;
        let i18n = layui.i18n;

        // 自定义消息通知
        let show = layui.show;

        /*
         * 初始化表格
        */
        var isTable = table.render({
            elem: "#lay-tableList"
            , url: "{:url('/PdmPartitemRelation/index')}"
            , toolbar: '#tableButton'
            , defaultToolbar: ['filter', 'exports', 'print', 'search']
            , cellMinWidth: 80
            , page: true
            , limit: 18
            , cols: [[
                //{ type: 'checkbox', width: 50 },
                { field: 'id', align: 'center', sort: true, width: 80, title: 'ID' },
                { field: 'partnumber', width: 180, title: '{:__("PartNumber")}' },
                //{ field: 'symbolid', title: '{:__("SymbolID")}' },
                { field: 'symbolname', width: 180,title: '{:__("Symbol")}' },
                //{ field: 'footprintid', title: '{:__("FootprintID")}' },
                { field: 'footprint', width: 180,title: '{:__("Footprint")}' },
                { field: 'manufacture', width: 120,title: '{:__("Manufacture")}' },
                //{ field: 'creatorid', title: '{:__("创建者ID")}' },
                { field: 'creator', width: 120,title: '{:__("创建者")}' },
                //{ field: 'departmentid', title: '{:__("部门ID")}' },
                { field: 'departmenttitle',width: 120, title: '{:__("部门")}' },
                { field: 'status', templet: '#columnStatus', title: '{:__("状态")}' },
                { align: 'center', toolbar: '#tableBar', width: 220, fixed: 'right', title: '{:__("操作")}' },
            ]]
        })


        /**
         * 监听表格事件
         */
        table.on("tool(lay-tableList)", function (obj) {

            let data = obj.data
                , reqData = {}
                , selector = $(this).parents('table').find('tbody tr')
                , callback = {
                    success: function (res) {
                        obj.del();
                        if ((selector.length - 1) === 0 ||
                            typeof selector.length === 'undefined') {
                            table.reloadData("lay-tableList");
                        }

                        show.msg(res.msg);
                    },
                    error: function (res) {
                        show.error(res.msg);
                    }
                }
                , userdfcallback = {
                    success: function (res) {
                        // obj.del();
                        // if ((selector.length - 1) === 0 ||
                        //     typeof selector.length === 'undefined') {
                        //     table.reloadData("lay-tableList");
                        // }

                        show.msg(res.msg);
                    },
                    error: function (res) {
                        show.error(res.msg);
                    }
                }
                , othis = $(this)
                , title = othis.data("title") || undefined
                , field = $(this).data('field');
            if (typeof (field) === "undefined") {
                reqData = {
                    id: data.id
                }
            } else {
                var array = field.split(",");
                for (let d in array) {
                    reqData[d] = data[d];
                }
            }

            if (obj.event === "edit") {
                admin.event.open(othis, obj);
            } else if (obj.event === "del") {
                var tips = i18n.prop('确定要删除吗');
                if (typeof title !== "undefined") {
                    tips += ' ' + title + ' ';
                }
                layer.confirm(tips, function (index) {
                    admin.event.request(othis, reqData, callback);
                    layer.close(index);
                })

            } else if (obj.event === "ajax") {
                admin.event.request(othis, reqData, callback);
            }else if(obj.event === "userdf"){
                var tips = i18n.prop('确定要删除吗');
                if (typeof title !== "undefined") {
                    tips += ' ' + title + ' ';
                }
                layer.confirm(tips, function (index) {
                    admin.event.request(othis, reqData, userdfcallback);
                    layer.close(index);
                })
            } else {
                admin.event.open(othis, obj);
            }
        })

        // // 添加 / 编辑用户
        // admin.callback.updata = function(clickthis,colletction,config) {

        //     // 获取表格对象
        //     var tableThis = colletction.tableThis,
        //         status = typeof(tableThis) === "undefined" ? true : false;    

        //     layui.msg("dddddd");

        //     // // 监听权限提交
        //     // form.on("submit(submitPage)",function(post){

        //     //     // 获取用户id
        //     //     var pageThat = layui.$(this),
        //     //     _pageUrl = !status ? pageThat.attr('lay-edit') : pageThat.attr('lay-add');

        //     //     // 开始POST提交数据
        //     //     layui.$.post(_pageUrl,
        //     //         post.field, function(res){
        //     //             if (res.code === 200) {
        //     //                 layer.msg(res.msg);
        //     //                 // 关闭当前窗口
        //     //                 table.reload('lay-tableList');
        //     //                 layer.close(colletction.index);
        //     //                 pageThat.attr("disabled",true);
        //     //             }
        //     //             else {
        //     //                 layui.show.error(res.msg);
        //     //             }

        //     //     }, 'json');

        //     //     return false;
        //     // })
        // }



        // 自定义更新数据按钮点击事件
        document.getElementById('updataAll').addEventListener('click', function () {
            // 确认用户希望导出全部数据
            layer.confirm('确定更新所有数据到 CIS数据表 吗？', { icon: 3, title: '更新确认' }, function(index){
                layer.close(index);
                updataAllCis();
            });
        });

        // 自定义导出功能
        function updataAllCis(){
            // 获取当前的过滤条件（例如，pid）
            // let selectedData = table.checkStatus('lay-tableGroup').data;
            // let pid = selectedData.length ? selectedData[0].id : 0;

            let url = "{:url('/PdmPartitemRelation/updataAll')}";

            // 异步获取所有数据（不分页）
            layer.msg('异步获取所有数据（不分页），超时限制：30s');
            $.ajax({
                url: url ,// 后端需要根据 'export=1' 返回所有数据
                // method: 'GET',
                type: 'POST',
                dataType: 'json',
                timeout: 30000,
                success: function(res){
                    if(res.code === 200){
                        layer.msg('更新数据成功:'+ res.msg);     
                    }        
                },
                error: function(jqXHR, textStatus, errorThrown){
                    if(textStatus === 'timeout') {
                        layer.msg('请求超时，请稍后重试。');
                    } else {
                        layer.msg('数据获取失败，请稍后重试: ' + errorThrown);
                    }
                }
            });
        }


    })
</script>