1
yxj
2024-01-25 c9d0da28b32debada8d015ab1e2cdc4502cd6708
WebTM/views/Éú²ú¹¤Ðò¹ÜÀí/¹¤Ðò»ã±¨µ¥/Sc_ProcessReportOverList.html
@@ -2,7 +2,7 @@
<html>
<head>
    <meta charset="utf-8" />
    <title>工序汇报入库列表</title>
    <title>首道工序汇报入库列表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
@@ -12,6 +12,7 @@
    <script src="../../../layuiadmin/zgqCustom/zgqCustom.js"></script>
    <script src="../../../layuiadmin/Scripts/webConfig.js"></script>
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
</head>
<body>
    <div class="layui-fluid">
@@ -40,6 +41,33 @@
                                            <option value="2">已同步</option>
                                            <option value="3">未同步</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-row" style=" margin-top: 10px; margin-left: 80px;">
                                    <div class="layui-inline">
                                        <label class="layui-form-label">过滤</label>
                                        <div class="layui-input-block">
                                            <select name="ColName" id="ColName" lay-filter="ColName" style="width:190px;">
                                            </select>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <select name="Comparator" id="Comparator" lay-filter="Comparator" style="width:190px;">
                                            <option value="0" selected="selected"></option>
                                            <option value="=">=</option>
                                            <option value=">=">>=</option>
                                            <option value=">">></option>
                                            <option value="<="><=</option>
                                            <option value="<"><</option>
                                            <option value="<>"><></option>
                                            <option value="7">包含</option>
                                            <option value="8">左包含</option>
                                            <option value="9">右包含</option>
                                            <option value="10">不包含</option>
                                        </select>
                                    </div>
                                    <div class="layui-inline">
                                        <input type="text" class="layui-input" value="" name="ColContent" id="ColContent">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
@@ -77,6 +105,7 @@
                        <script type="text/html" id="toolbarDemo">
                            <div class="layui-btn-container">
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-InStorage" id="btn-InStorage"><i class="layui-icon layui-icon-ok-circle"></i>入库</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn_InStorage_Batch" id="btn_InStorage_Batch"><i class="layui-icon layui-icon-ok-circle"></i>批量入库</button>
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="btn-Exit" id="btn-Exit">退出</button>
                            </div>
                        </script>
@@ -95,7 +124,7 @@
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable'], function () {
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
@@ -105,6 +134,7 @@
                , laypage = layui.laypage
                , laydate = layui.laydate
                , util = layui.util
                , soulTable = layui.soulTable
            //公用变量
            var sWhere = "";
            var option = [];
@@ -165,39 +195,42 @@
                    , cellMinWidth: 90
                    , limit: 50
                    , limits: [50, 500, 5000, 20000]
                    , done: function (res, curr, count) {
                        soulTable.render(this);
                    }
                    , cols: [[
                        { type: 'checkbox', fixed: 'left' }
                        , { field: 'hmainid', title: 'hmainid', sort: true, hide: true }
                        , { field: '任务单', title: '任务单', width: 125 }
                        , { field: '单据号', title: '单据号', width: 190 }
                        , { field: '工序流转卡号', title: '工序流转卡号', width: 125 }
                        , { field: '同步状态', title: '同步状态' }
                        , { field: 'HProcID', title: 'HProcID', hide: true }
                        , { field: '当前工序代码', title: '当前工序代码', width: 125 }
                        , { field: '当前工序', title: '当前工序' }
                        , { field: 'HMaterID', title: 'HMaterID', hide: true }
                        , { field: '产品代码', title: '产品代码' }
                        , { field: '产品名称', title: '产品名称', width: 125 }
                        , { field: '规格型号', title: '规格型号' }
                        , { field: '任务单', title: '任务单', width: 125, sort: true }
                        , { field: '单据号', title: '单据号', width: 190, sort: true }
                        , { field: '工序流转卡号', title: '工序流转卡号', width: 125, sort: true }
                        , { field: '同步状态', title: '同步状态', sort: true }
                        , { field: 'HProcID', title: 'HProcID', hide: true, sort: true }
                        , { field: '当前工序代码', title: '当前工序代码', width: 125, sort: true }
                        , { field: '当前工序', title: '当前工序', sort: true }
                        , { field: 'HMaterID', title: 'HMaterID', hide: true, sort: true }
                        , { field: '产品代码', title: '产品代码', sort: true }
                        , { field: '产品名称', title: '产品名称', width: 125, sort: true }
                        , { field: '规格型号', title: '规格型号', sort: true }
                        , {
                            field: '出站时间', title: '出站时间', width: 160, templet: function (d) {
                            field: '出站时间', title: '出站时间', width: 160, sort: true, templet: function (d) {
                                if (d.出站时间 == null) {
                                    return "";
                                }
                                return util.toDateString(d.出站时间, "yyyy-MM-dd HH:mm:ss");
                            }
                        }
                        , { field: 'HEmpID', title: 'HEmpID', hide: true }
                        , { field: '操作员代码', title: '操作员代码', width: 190 }
                        , { field: '操作员', title: '操作员' }
                        , { field: 'HSourceID', title: 'HSourceID', hide: true }
                        , { field: '生产资源代码', title: '生产资源代码', width: 125 }
                        , { field: '生产资源', title: '生产资源' }
                        , { field: 'HGroupID', title: 'HGroupID', hide: true }
                        , { field: '生产班组代码', title: '生产班组代码', width: 125 }
                        , { field: '生产班组', title: '生产班组' }
                        , { field: 'LOT数量', title: 'LOT数量' }
                        , { field: '接收数量', title: '出站数量' }
                        , { field: 'HEmpID', title: 'HEmpID', hide: true, sort: true }
                        , { field: '操作员代码', title: '操作员代码', width: 190, sort: true }
                        , { field: '操作员', title: '操作员', sort: true }
                        , { field: 'HSourceID', title: 'HSourceID', hide: true, sort: true }
                        , { field: '生产资源代码', title: '生产资源代码', width: 125, sort: true }
                        , { field: '生产资源', title: '生产资源', sort: true }
                        , { field: 'HGroupID', title: 'HGroupID', hide: true, sort: true }
                        , { field: '生产班组代码', title: '生产班组代码', width: 125, sort: true }
                        , { field: '生产班组', title: '生产班组', sort: true }
                        , { field: 'LOT数量', title: 'LOT数量', sort: true }
                        , { field: '接收数量', title: '出站数量', sort: true }
                    ]]
                    , text: {
                        none: '无数据!'
@@ -207,13 +240,16 @@
                get_FastQuery();
            }
            //头工具栏事件
            table.on('toolbar(mainTable)', function (obj) {
                switch (obj.event) {
                    //入库
                    case 'btn-InStorage': get_InStorage();
                        break;
                    //批量入库
                    case 'btn_InStorage_Batch': get_InStorage_Batch();
                        break;
                    //退出
                    case 'btn-Exit': get_Exit();
@@ -229,7 +265,10 @@
                $("#HBillNo").val("");
                $("#HDate").val(Format(new Date(new Date() - 1000 * 60 * 60 * 24 * 30), "yyyy-MM-dd"));
                $("#HProcExchBillNo").val("");
                $("#HRelationQty").val("1")
                $("#HRelationQty").val("1");
                $("#ColContent").val("");
                $("#ColName").val("0");
                $("#Comparator").val("0");
                form.render("select");
            }
@@ -240,6 +279,9 @@
                var HBillNo = $("#HBillNo").val();
                var HProcExchBillNo = $("#HProcExchBillNo").val();
                var HRelationQty = $("#HRelationQty").val();
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
                var ColContent = $("#ColContent").val();
                switch (HRelationQty) {
                    case "1":
                        sWhere += "";
@@ -250,6 +292,27 @@
                    case "3":
                        sWhere += " and åŒæ­¥çŠ¶æ€ = ''";
                        break;
                }
                if (ColName != 0 && Comparator != 0) {
                    var com = "";
                    switch (Comparator) {
                        case "7":
                            com = "like'%" + ColContent + "%'";
                            break;
                        case "8":
                            com = "like'%" + ColContent + "'";
                            break;
                        case "9":
                            com = "like'" + ColContent + "%'";
                            break;
                        case "10":
                            com = "not like'%" + ColContent + "%'";
                            break;
                        default:
                            com = "" + Comparator + "'" + ColContent + "'";
                            break;
                    }
                    sWhere += " and " + ColName + " " + com;
                }
                if (HDate) {
                    sWhere += " and CONVERT(varchar(100),出站时间, 23) = '" + HDate + "'";
@@ -285,6 +348,9 @@
                        }
                        table.render(option);
                        layer.close(wait);
                        if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            ColFilter();
                        }
                    }, error: function () {
                        layer.close(wait);
                        layer.alert("接口请求失败!", { icon: 5 });
@@ -292,6 +358,42 @@
                });
            }
            //批量入库
            function get_InStorage_Batch() {
                var checkStatus = table.checkStatus('mainTable')
                    , data = checkStatus.data;
                if (checkStatus.data.length > 0) {
                    var InterID = [];
                    var BillNo = [];
                    for (var i = 0; i < data.length; i++) {
                        InterID.push(data[i].hmainid.toString());
                        BillNo.push(data[i].单据号.toString());
                    }
                    var msg = InterID + ';' + sessionStorage["HUserName"] + ';' + BillNo + ";" + sessionStorage["OrganizationID"];
                    $.ajax({
                        type: "POST",
                        url: GetWEBURL() + "/Sc_ProcessMangement/SaveICMOReportBill_Batch", //方法所在页面和方法名
                        async: true,
                        data: { "msg": msg },
                        dataType: "json",
                        success: function (data) {
                            if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                                layer.alert(data.Message, { icon: 1 });
                            }
                            else {
                                layer.alert(data.Message, { icon: 5 });
                            }
                        },
                        error: function (err) {
                            layer.alert(err.responseText, { icon: 5 });
                        }
                    });
                }
                else {
                    layer.msg('请选择至少一行数据!');
                }
            }
            //入库
            function get_InStorage() {
                var checkStatus = table.checkStatus('mainTable')
@@ -303,7 +405,7 @@
                        type: "GET",
                        url: GetWEBURL() + "/Sc_ProcessMangement/SaveICMOReportBill", //方法所在页面和方法名
                        async: true,
                        data: { "InterID": InterID, "user": sessionStorage["HUserName"], "BillNo": BillNo, "OrganizationID": sessionStorage["OrganizationID"]},
                        data: { "InterID": InterID, "user": sessionStorage["HUserName"], "BillNo": BillNo, "OrganizationID": sessionStorage["OrganizationID"] },
                        dataType: "json",
                        success: function (data) {
                            if (data.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
@@ -325,7 +427,18 @@
                    layer.msg('请选择一行数据入库!');
                }
            }
            //列明显示下拉框
            function ColFilter() {
                var Organization = '<option  value="0" selected="selected" ></option>';
                for (var i = 1; i < option.cols[0].length; i++) {
                    if (option.cols[0][i].hide != true) {
                        Organization += '<option  style="color:blue;" value="' + option.cols[0][i].field + '">' + option.cols[0][i].field + '</option>';
                    }
                }
                $("#ColName").empty();
                $("#ColName").append(Organization);
                form.render('select');
            }
            //退出
            function get_Exit() {
                Pub_Close(2);