1
yangle
2023-03-21 970e2e0e5b8210e3127382821ac3bb87fb368344
KB_EquipmentUtilizationRate.html
@@ -15,6 +15,7 @@
    <script src="js/jquery.SuperSlide.2.1.3.js"></script>
    <script src='js/template.js'></script>
    <script src="js/jquery.qrcode.min.js"></script>
    <script src="js/webConfig.js"></script>
    <style>
        .clock {
            font-family: 'BebasNeueRegular', Arial, Helvetica, sans-serif;
@@ -222,7 +223,7 @@
    </style>
    <script type="text/javascript">
        //参数配置
        var HouseCode = '509';
        var HouseCode = '509';
        var interval;//计时器
@@ -263,10 +264,11 @@
            var mychart3 = echarts.init(document.getElementById('mychart3'));
            Chart(mychart1, mychart2, mychart3);
            DataTable();
            DataTableCol(20);
            // 定时器
            interval = setInterval(function () {
                num = 0;
                NetQtys = [];     //开机
                SumQtys = [];     //开工
                WayQtys = [];     //维修
@@ -276,8 +278,8 @@
                Chart(mychart1, mychart2, mychart3);
            }, 20000);
            interval1 = setInterval(function () {
                $("#tb_order").bootstrapTable('refresh');
            }, 10000);
                DataTableCol(20);
            }, 20000);
            //根据浏览器大小改变大小
            window.onresize = () => {
                mychart1.resize();
@@ -288,7 +290,7 @@
        function Chart(mychart1, mychart2, mychart3) {
            $.ajax({
                url: "http://localhost:12298/api/loaddata/KB_EquipmentUtilizationRateData",
                url: GetWEBURL() +"loaddata/KB_EquipmentUtilizationRateData",
                dataType: "JSON",
                async: false,//使用同步的方式,true为异步方式
                type: "Get",
@@ -341,7 +343,7 @@
                }
            })
            const colorList = ['#47A2FF', '#ff9900', '#c0ffff','#ffffff']
            const colorList = ['#47A2FF', '#ff9900', '#c0ffff', '#ffffff']
            option1 = {
                title: [
                    {
@@ -525,6 +527,8 @@
                            }
                        },
                        axisLabel: {
                            interval: 0, //控制X轴刻度全部显示
                            rotate: 45, //倾斜角度
                            show: true,
                            textStyle: {
                                color: '#00c6ff', //坐标值得具体的颜色
@@ -570,15 +574,48 @@
            //mychart2.setOption(option2);
            mychart3.setOption(option3);
        }
        var col = [];
        var colTable = [];
        var option = [];
        //获取表格数据 的列名  数据 以及总数
        function DataTableCol(nums) {
            var params = queryParams(nums);
            $.ajax({
                url: GetWEBURL() + '/loaddata/KB_EquipmentUtilizationRateTableData'
                , type: "get"
                , data: {
                    HouseCode: params.HouseCode,
                    limit: params.limit,   //页面大小
                    offset: params.offset  //页码
                }
                , success: function (data) {
                    col = [];
                    var dataTable = JSON.parse(data);
                    //判断是否是最后一页
                    var num_total = (dataTable.data[0][0]["Column1"]) / nums
                    if (num >= num_total) {
                        num = 0
                    }
                    for (var i = 0; i < dataTable.ColName.length; i++) {
                        col.push({ field: dataTable.ColName[i].ColName, title: dataTable.ColName[i].ColName, align: "left" })
                    }
                    colTable = dataTable.data[1];
                    DataTable();
                    $('#tb_order').bootstrapTable('destroy');//先删除
                    $('#tb_order').bootstrapTable(option);//再重新渲染
                }
            })
        }
        function DataTable() {
            $('#tb_order').bootstrapTable({
                url: 'http://122.227.199.62:5058/HDKanBanApi/api/loaddata/LackMatsTableData',
                //data: dataJson,
                method: 'get',                      //请求方式(*)
                dataType: "json",
                queryParams: queryParams,
            //$('#tb_order').bootstrapTable();
            option = {
                //url: GetWEBURL() +'/loaddata/KB_EquipmentUtilizationRateTableData',
                data: colTable,
                //method: 'get',                      //请求方式(*)
                //dataType: "json",
                //queryParams: queryParams,
                striped: false,                      //是否显示行间隔色
                cache: false,                       //是否使用缓存,默认为true,所以一般情况下需要设置一下这个属性(*)
                pagination: true,                   //是否显示分页(*)
@@ -595,77 +632,7 @@
                uniqueId: "ID",                     //每一行的唯一标识,一般为主键列
                cardView: false,                    //是否显示详细视图
                detailView: false,                   //是否显示父子表
                columns: [
                    { field: 'PartNumber', title: '物料编码', align: "left" },
                    {
                        field: 'PartName', title: '物料名称', align: "left", cellStyle: function (value, row, index) {
                            return {
                                css: {
                                    "min-width": "100px",
                                    "white-space": "nowrap",
                                    "text-overflow": "ellipsis",
                                    "overflow": "hidden",
                                    "max-width": "120px"
                                }
                            }
                        }
                    },
                    {
                        field: 'PartSpec', title: '规格型号', align: "left", cellStyle: function (value, row, index) {
                            return {
                                css: {
                                    "min-width": "100px",
                                    "white-space": "nowrap",
                                    "text-overflow": "ellipsis",
                                    "overflow": "hidden",
                                    "max-width": "120px"
                                }
                            }
                        }
                    },
                    {
                        field: 'LackMastQty', title: '缺料数量', align: "left", formatter: function (value, row, index) {
                            return parseFloat(value).toFixed(2);
                        }
                    },
                    {
                        field: 'KQty', title: '库存数量', align: "left", formatter: function (value, row, index) {
                            return parseFloat(value).toFixed(2);
                        }
                    },
                    {
                        field: 'EmpQty', title: '占用数量', align: "left", formatter: function (value, row, index) {
                            return parseFloat(value).toFixed(2);
                        }
                    },
                    {
                        field: 'AVAILQTY', title: '剩余可用数量', align: "left", formatter: function (value, row, index) {
                            var res = row.KQty - row.EmpQty;
                            return parseFloat(res).toFixed(2);
                        }
                    },
                    {
                        field: 'PuchQty', title: '采购在途数量', align: "left", formatter: function (value, row, index) {
                            return parseFloat(value).toFixed(2);
                        }
                    },
                    {
                        field: 'SafeQty', title: '安全库存', align: "left", formatter: function (value, row, index) {
                            return parseFloat(value).toFixed(2);
                        }
                    },
                    {
                        field: 'SupQty', title: '需求量', align: "left", formatter: function (value, row, index) {
                            return parseFloat(value).toFixed(2);
                        }
                    },
                    {
                        field: 'ToDaySupQty', title: '本日求量', align: "left", formatter: function (value, row, index) {
                            return parseFloat(value).toFixed(2);
                        }
                    }
                ],
                columns: col,
                onClickRow: function (row, $element) {
                },
@@ -673,21 +640,19 @@
                },
                onLoadSuccess: function (row) {
                    var num_total = (row.total) / 20
                    if (num >= num_total) {
                        num = 0
                    }
                    //var a = $('#tb_order').bootstrapTable('getSelections');
                }
            })
            };
        }
        //得到查询的参数
        function queryParams(params) {
            num += 1;
            var temp = {   //这里的键的名字和控制器的变量名必须一直,这边改动,控制器也需要改成一样的
                HouseCode: HouseCode,
                limit: params.limit,   //页面大小
                //limit: params.limit,   //页面大小
                limit: params,   //页面大小
                offset: num,  //页码
            };
            return temp;