{include file='common/head.html'}
<div class="layui-body">
    <div class="layui-tab layui-tab-brief" lay-filter="tab">
        <ul class="layui-tab-title">
            <li lay-id="t1" class="layui-this">图片清理<span class="layui-badge countimage">0</span></li>
            <li lay-id="t2">视频清理<span class="layui-badge countvideo">0</span></li>
            <li lay-id="t3">文档清理<span class="layui-badge countother">0</span></li>
            <li lay-id="t4">字段概况</li>
            {if(check_level('batchdel'))}
            <button type="button" onclick="material_deleteAll()" class="layui-btn layui-btn-danger layui-btn-sm" style="float: right;">一键清理</button>
            {/if}
            {if(check_level('batchmod'))}
            <button type="button" onclick="zipall()" class="layui-btn layui-btn-sm" style="float: right;margin-right: 10px;">一键备份</button>
            {/if}
            <a href="{url./admin/Material/index}" class="layui-btn layui-btn-warm layui-btn-sm" style="float: right;margin-right: 10px;">重新检测</a>
        </ul>
        <div class="layui-tab-content lxb">
            <div class="layui-tab-item layui-show">
                <blockquote class="layui-elem-quote">
                    此页面显示图片均为未使用图片，清理后可节省空间，备份文件保存位置：站点根目录/static/backup/下。
                </blockquote>
                <table class="layui-table">
                    <thead>
                        <tr>
                            <th width="30"><input type="checkbox" lay-ignore id="checkallimage" title="全选"></th>
                            <th width="30">序号</th>
                            <th>缩略图</th>
                            <th>文件路径</th>
                            <th>大小</th>
                            <th>尺寸</th>
                            <th>上传时间</th>
                            <th>操作</th>
                        </tr>
                    </thead>
                    <tbody class="tbodyimage"> </tbody>
                </table>
            </div>
            <div class="layui-tab-item">
                <blockquote class="layui-elem-quote">
                    此页面显示视频均为未使用视频，清理后可节省空间，备份文件保存位置：站点根目录/static/backup/下。
                </blockquote>
                <table class="layui-table">
                    <thead>
                        <tr>
                            <th width="30"><input type="checkbox" lay-ignore id="checkallvideo" title="全选"></th>
                            <th width="30">序号</th>
                            <th>文件路径</th>
                            <th>大小</th>
                            <th>上传时间</th>
                            <th>操作</th>
                        </tr>
                    </thead>
                    <tbody class="tbodyvideo"> </tbody>
                </table>
            </div>
            <div class="layui-tab-item">
                <blockquote class="layui-elem-quote">
                    此页面显示文件均为未使用文件，清理后可节省空间，备份文件保存位置：站点根目录/static/backup/下。
                </blockquote>
                <table class="layui-table">
                    <thead>
                        <tr>
                            <th width="30"><input type="checkbox" lay-ignore id="checkallother" title="全选"></th>
                            <th width="30">序号</th>
                            <th>文件路径</th>
                            <th>大小</th>
                            <th>上传时间</th>
                            <th>操作</th>
                        </tr>
                    </thead>
                    <tbody class="tbodyother"> </tbody>
                </table>
            </div>
            <div class="layui-tab-item">
                <blockquote class="layui-elem-quote">
                    此页面显示信息均为根据当前站点数据智能提取所有包含图片/附件的数据表以及相关字段
                </blockquote>
                <table class="layui-table">
                    <thead>
                        <tr>
                            <th width="30">序号</th>
                            <th width='120'>检测数据表</th>
                            <th>检测字段</th>
                            <th width='50'>数量</th>
                        </tr>
                    </thead>
                    <tbody>
                        {foreach $tables(key,value,num)}
                        <tr>
                            <td>[num]</td>
                            <td class="left">[key]</td>
                            <td class="left"> {php} echo '【'.str_replace(['-hbh','-xlh','-text'], '', implode('】【', $value)).'】'; {/php} </td>
                            <td> {php} echo count($value); {/php} </td>
                        </tr>
                        {/foreach}
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
{include file='common/foot.html'}
{$tables_json}
<script type="text/javascript">
    var formcheck = '{$formcheck}';
    var num1 = num2 = 0;
    var table = '';
    var tableUrl = [];
    // 启用扫描
    $(document).ready(function() {
        layui.use("layer", function() {
            var layer = layui.layer;
            layer.ready(function() {
                layer.confirm('此功能为高负载功能，建议非高峰时段执行，避免影响系统的正常运行和用户体验！<br>当前异步请求量设定为每组扫描{php}echo get("limit")?get("limit"):"100";{/php}条数据，确定要现在执行数据扫描吗？', {
                    icon: 0
                }, function() {
                    layer.closeAll();
                    layer.open({
                        type: 1,
                        title: '数据扫描',
                        closeBtn: 0,
                        content: '<div style="padding:20px 10px;"><img src="{APP_THEME_DIR}/images/loading.gif"><span id="layer-content">正在分析数据表，请稍等...</span></div>'
                    });
                    scanNextTable();
                }, function() {
                    layer.msg('不会吧，不会吧，不会真有人从心了吧？', {
                        icon: 3
                    });
                });
            });
        });
    });

    function scanNextTable() {
        if (num1 < Object.keys(tables).length) {
            var index = Object.keys(tables)[num1];
            $('#layer-content').text("正在扫描数据表" + index + "，请稍等...");
            table = index;
            tableUrl = tables[index];
            scanNextField();
        } else {
            $('#layer-content').text("扫描完成，列表加载中...");
            getRedundantFiles();
        }
    };

    function scanNextField() {
        if (num2 < tableUrl.length) {
            var index = tableUrl[num2];
            num2++;
            // console.log(index);
            let url = '{url./admin/Material/ScanDatabase}' + index + '{php}echo get("limit")?"/limit/".get("limit"):"/limit/100";{/php}';
            let parts = url.split('/');
            let FieldIndex = parts.indexOf('field');
            let offsetIndex = parts.indexOf('offset');
            let startIndex = parts[offsetIndex + 1];
            let field = parts[FieldIndex + 1].replace(/-(hbh|xlh|text)/g, '');
            let endIndex = Number(startIndex) + Number('{php}echo get("limit")?:100;{/php}');
            $('#layer-content').text("正在扫描数据表 " + table + " [" + field + "] " + startIndex + "-" + endIndex + " ，请稍等...");
            $.ajax({
                url: url,
                type: 'POST',
                data: {
                    formcheck: formcheck,
                },
                dataType: 'json',
                success: function(response) {
                    if (response.code == 1) {
                        setTimeout(scanNextField, 10);
                    } else {
                        layer.closeAll();
                        layer.msg(response.data, {
                            icon: 5
                        });
                        return;
                    }
                },
                error: function() {
                    layer.closeAll();
                    layer.msg('扫描过程中发生错误，请稍后再试。', {
                        icon: 5
                    });
                    return;
                }
            });
        } else {
            num2 = 0;
            num1++;
            setTimeout(scanNextTable, 10);
        }
    }

    // 加载列表数据
    function getRedundantFiles() {
        $.ajax({
            url: '{url./admin/Material/getRedundantFiles}',
            type: 'POST',
            data: {
                formcheck: formcheck,
            },
            dataType: 'json',
            success: function(response) {
                if (response.code == 1) {
                    if (response.data.image.length == 0 && response.data.video.length == 0 && response.data.other.length == 0) {
                        layer.closeAll();
                        layer.msg('扫描完成，未扫描到冗余素材！', {
                            icon: 1
                        });
                        return;
                    }
                    $.each(response.data, function(index, value) {
                        let html = '';
                        if (value) {
                            $('.count' + index).text(value.length);
                            $.each(value, function(index2, value2) {
                                let num = index2 + 1;
                                html += `<tr id="` + index + `_tr` + num + `">
                                        <td> <input type="checkbox" class="checkitem` + index + `" lay-ignore name="list" value="` + value2.src + `" data-id="` + index + `_tr` + num + `"> </td>
                                        <td>` + num + `</td>`;

                                if (index == 'image') {
                                    html += ` <td><a href='` + value2.src + `' target="_blank" title="查看"><img lay-src="` + value2.src + `"></a></td>`;
                                }

                                html += `<td>` + value2.src + `</td>
                                        <td>` + value2.size + `</td>`;

                                if (index == 'image') {
                                    html += `<td>` + value2.dimensions + `</td>`;
                                }

                                html += `<td>` + value2.last_modified + `</td>
                                        <td>
                                            <a href='` + value2.src + `' target="_blank" class="layui-btn layui-btn-xs layui-btn-primary" title="查看">查看</a>
                                            {if(check_level('mod'))}
                                            <a href='#' onclick="zipone(this,'` + value2.src + `')" class="layui-btn layui-btn-xs" title="备份">备份</a>
                                            {/if}
                                            {if(check_level('del'))}
                                            <a href='#' onclick="material_delete(this,'` + value2.src + `')" class="layui-btn layui-btn-xs layui-btn-danger" title="删除">删除</a>
                                            {/if}
                                        </td>
                                    </tr>`;
                            });
                        }
                        $('.tbody' + index).html(html);
                    });
                    // 图片懒加载
                    layui.use('flow', function() {
                        layui.flow.lazyimg({
                            elem: 'img',
                        });
                    });
                    layer.closeAll();
                    layer.msg('扫描完成，请选择需要清理的素材！', {
                        icon: 1
                    });
                }
            }
        });
    }

    //勾选方式选择全部
    $("#checkallimage").on("click", function() {
        if ($(this).prop("checked")) {
            $(".checkitemimage:enabled").prop("checked", true);
        } else {
            $(".checkitemimage").prop("checked", false);
        }
    })
    $("#checkallvideo").on("click", function() {
        if ($(this).prop("checked")) {
            $(".checkitemvideo:enabled").prop("checked", true);
        } else {
            $(".checkitemvideo").prop("checked", false);
        }
    })
    $("#checkallother").on("click", function() {
        if ($(this).prop("checked")) {
            $(".checkitemother:enabled").prop("checked", true);
        } else {
            $(".checkitemother").prop("checked", false);
        }
    })

    function material_delete(obj, src) {
        layer.confirm('该操作不可逆！确定要清理该文件吗？', {
            icon: 3
        }, function() {
            _this = $(obj);
            $.post('{url./admin/Material/del/action/subdel}', {
                src: src,
                formcheck: formcheck
            }, function(data) {
                // console.log(res);
                if (data.code == 1) {
                    layer.msg(data.data, {
                        icon: 1
                    });
                    _this.parents('tr').remove();
                    $(".countimage").text($('.tbodyimage').children('tr').length);
                    $(".countvideo").text($('.tbodyvideo').children('tr').length);
                    $(".countother").text($('.tbodyother').children('tr').length);
                } else {
                    layer.msg(data.data, {
                        icon: 2
                    });
                }
            }, 'json');
        });
    }

    function material_deleteAll() {
        var chk_value = [];
        var chk_ids = [];
        $('input[name="list"]:checked').each(function() {
            chk_value.push($(this).val());
            chk_ids.push($(this).data('id'));
        });
        if (chk_value.length === 0) {
            layer.msg("你还未选中任何文件，无需执行清理操作!", {
                icon: 0
            });
            return false;
        }
        layer.confirm('该操作不可逆！确定要清理选中文件吗？', {
            icon: 0
        }, function() {
            if (chk_value.length > 100) {
                let groupSize = 100;
                let groupsval = [];
                let groupsids = [];
                for (var i = 0; i < chk_value.length; i += groupSize) {
                    groupsval.push(chk_value.slice(i, i + groupSize));
                    groupsids.push(chk_ids.slice(i, i + groupSize));
                }
                $(groupsval).each(function(index, element) {
                    setTimeout(function() { //延迟执行、避免文件太多卡死问题
                        $.post('{url./admin/Material/del}', {
                            chk_value: element,
                            formcheck: formcheck
                        }, function(data) {
                            if (data.code == 1) {
                                layer.msg('第' + (index + 1) + '次' + data.data, {
                                    icon: 1
                                });
                                $.each(groupsids[index], function(index, value) {
                                    $('#' + value).remove();
                                });
                                $(".countimage").text($('.tbodyimage').children('tr').length);
                                $(".countvideo").text($('.tbodyvideo').children('tr').length);
                                $(".countother").text($('.tbodyother').children('tr').length);
                            } else {
                                layer.msg(data.data, {
                                    icon: 2
                                });
                            }
                        }, 'json');
                    }, index * 1000);
                });
            } else {
                $.post('{url./admin/Material/del}', {
                    chk_value: chk_value,
                    formcheck: formcheck
                }, function(data) {
                    if (data.code == 1) {
                        layer.msg(data.data, {
                            icon: 1
                        });
                        $.each(chk_ids, function(index, value) {
                            $('#' + value).remove();
                        });
                        $(".countimage").text($('.tbodyimage').children('tr').length);
                        $(".countvideo").text($('.tbodyvideo').children('tr').length);
                        $(".countother").text($('.tbodyother').children('tr').length);
                    } else {
                        layer.msg(data.data, {
                            icon: 2
                        });
                    }
                }, 'json');
            }
        });
    }

    function zipone(obj, src) {
        layer.confirm('确定要备份该文件吗？', {
            icon: 3
        }, function() {
            $.post('{url./admin/Material/mod/action/submod}', {
                src: src,
                formcheck: formcheck
            }, function(data) {
                // console.log(res);
                if (data.code == 1) {
                    layer.msg(data.data, {
                        icon: 1
                    });
                } else {
                    layer.msg(data.data, {
                        icon: 2
                    });
                }
            }, 'json');
        });
    }

    function zipall() {
        var chk_value = [];
        $('input[name="list"]:checked').each(function() {
            chk_value.push($(this).val());
        });
        if (chk_value.length === 0) {
            layer.msg("你还未选中任何文件，无需执行清理操作!", {
                icon: 0
            });
            return false;
        }
        layer.confirm('确定要备份选中文件吗？', {
            icon: 3
        }, function() {
            $.post('{url./admin/Material/mod}', {
                chk_value: chk_value,
                formcheck: formcheck
            }, function(data) {
                // console.log(res);
                if (data.code == 1) {
                    layer.msg(data.data, {
                        icon: 1
                    });
                } else {
                    layer.msg(data.data, {
                        icon: 2
                    });
                }
            }, 'json');
        });
    }
</script>