zgq
2021-01-26 ca334af0775c9e5df55dfc38b99e91bcbf9fa1b7
WebTM/views/¹¤Ðò»ã±¨/MES_StationInBillList.html
@@ -1,7 +1,7 @@
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>工序进站接收单列表</title>
    <meta name="renderer" content="webkit">
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
@@ -9,7 +9,11 @@
    <link rel="stylesheet" href="../../layuiadmin/layui/css/layui.css" media="all">
    <link rel="stylesheet" href="../../layuiadmin/style/admin.css" media="all">
    <script src="../../layuiadmin/layui/layui.js"></script>
    <script src="../../layuiadmin/layui/lay/modules/util.js"></script>
    <script src="../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../layuiadmin/Scripts/webConfig.js"></script>
</head>
<body>
    <div class="layui-fluid">
@@ -25,28 +29,28 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <label class="layui-form-label">进站时间</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HDate">
                                        <input type="date" class="layui-input" id="进站时间">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">结束日期</label>
                                    <label class="layui-form-label">任务单</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input" id="HDate1">
                                        <input type="text" class="layui-input" name="任务单" id="任务单">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">订单跟踪号</label>
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HOrderProcNO" id="HOrderProcNO">
                                        <input type="text" class="layui-input" name="单据号" id="单据号">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                    <i class="layui-icon layui-icon-search layuiadmin-button-btn"></i>
                                </button>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">重置</button>
                                <div class="layui-colla-content">
                                    <div class="layui-inline">
                                        <div class="layui-inline">
@@ -54,21 +58,21 @@
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">工作中心</label>
                                        <label class="layui-form-label">工序流转卡号</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="WorkCenter" id="WorkCenter">
                                            <input type="text" class="layui-input" name="工序流转卡号" id="工序流转卡号">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">流转卡号</label>
                                        <label class="layui-form-label">产品名称</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HProcExchBillNo" id="HProcExchBillNo">
                                            <input type="text" class="layui-input" name="产品名称" id="产品名称">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">制单人</label>
                                        <label class="layui-form-label">生产班组</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HMaker" id="HMaker">
                                            <input type="text" class="layui-input" name="生产班组" id="生产班组">
                                        </div>
                                    </div>
                                </div>
@@ -79,21 +83,21 @@
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">产品名称</label>
                                        <label class="layui-form-label">操作员</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="hname" id="hname">
                                            <input type="text" class="layui-input" name="操作员" id="操作员">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">产品代码</label>
                                        <label class="layui-form-label">客户信息</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="hnumber" id="hnumber">
                                            <input type="text" class="layui-input" name="客户信息" id="客户信息">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">规格型号</label>
                                        <label class="layui-form-label">联系人信息</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="hmodel" id="hmodel">
                                            <input type="text" class="layui-input" name="联系人信息" id="联系人信息">
                                        </div>
                                    </div>
                                </div>
@@ -117,31 +121,32 @@
            </div>
        </div>
    </div>
    <script src="../../layuiadmin/layui/layui.js"></script>
    <script src="../../layuiadmin/Scripts/json2.js"></script>
    <script src="../../layuiadmin/Scripts/jquery-1.4.1.js"></script>
    <script src="../../layuiadmin/Scripts/webConfig.js"></script>
    <script type="text/html" id="toolBar">
        <a class="layui-btn layui-btn-xs" lay-event="del" style="background-color: red;">删除</a>
    </script>
    <script>
        layui.config({
            base: '../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () {
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','util'], function () {
            var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , element = layui.element
            , laypage = layui.laypage
            , laydate = layui.laydate
                , admin = layui.admin
                , layer = layui.layer
                , table = layui.table
                , form = layui.form
                , element = layui.element
                , laypage = layui.laypage
                , laydate = layui.laydate
                , util = layui.util
            //var sWhere = " äº§å“ä»£ç  = 'BX0002'";
            var sWhere = "";
            var option = {
                elem: '#mainTable'
                //, toolbar: '#toolbarDemo'
                ,height: 'full-50'
                , height: 'full-50'
                , page: true
                , cols: [[
                    //{ field: 'HEmpID', title: 'HEmpID', sort: true, width: 110 }
@@ -149,31 +154,59 @@
                    //, { field: 'HMaterID', title: 'HMaterID', sort: true, width: 165 }
                    //, { field: 'HProcID', title: 'HProcID', width: 175 }
                    //, { field: 'HSourceID', title: 'HSourceID', width: 170 }
                    { field: '进站时间', title: '进站时间', width: 120 }
                    , { field: '任务单', title: '任务单', width: 80 }
                    , { field: '工序流转卡号', title: '工序流转卡号', width: 165 }
                    , { field: '产品代码', title: '产品代码', width: 100 }
                    , { field: '产品名称', title: '产品名称', width: 100 }
                    , { field: '规格型号', title: '规格型号', width: 100 }
                    , { field: '当前工序', title: '当前工序', width: 100 }
                    , { field: 'LOT数量', title: '订单数量', width: 100 }
                    , { field: '接收数量', title: '接收数量', width: 100 }
                    , { field: '生产班组', title: '生产班组', width: 100 }
                    {
                        field: '进站时间', title: '进站时间', width: 105, templet: function (d) {
                            if (d.进站时间 == null) {
                                return "";
                            }
                            return util.toDateString(d.进站时间, "yyyy-MM-dd");
                        }
                    }
                    , { field: '任务单', title: '任务单', width: 100 }
                    , { field: '单据号', title: '单据号', width: 140 }
                    , { field: '工序流转卡号', title: '工序流转卡号', width: 145 }
                    , { field: '产品代码', title: '产品代码', width: 145 }
                    , { field: '产品名称', title: '产品名称', width: 160 }
                    , { field: '规格型号', title: '规格型号', width: 90 }
                    , { field: '当前工序', title: '当前工序', width: 90 }
                    , { field: 'LOT数量', title: '订单数量', width: 90 }
                    , { field: '接收数量', title: '接收数量', width: 90 }
                    , { field: '生产班组', title: '生产班组', width: 90 }
                    , { field: '生产资源', title: '生产资源', width: 100 }
                    , { field: '操作员', title: '操作员', width: 100 }
                    , { field: '操作员', title: '操作员', width: 80 }
                    , { field: '客户信息', title: '客户信息', width: 250 }
                    , { field: '联系人信息', title: '联系人信息', width: 100 }
                    , { toolbar: '#toolBar', width: 65, fixed: 'right' }
                    //, { field: 'hmainid', title: 'hmainid', width: 160 }
                    //, { field: '当前工序代码', title: '当前工序代码', width: 80 }
                    //, { field: '操作员代码', title: '操作员代码', width: 80 }
                    //, { field: '生产班组代码', title: '生产班组代码', width: 80 }
                    //, { field: '生产资源代码', title: '生产资源代码', width: 105 }
                ]]
            };
            //监听表格中行工具事件
            table.on('tool(mainTable)', function (obj) { //注:tool æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„å±žæ€§ lay-filter="对应的值"
                var data = obj.data //获得当前行数据
                    , layEvent = obj.event; //获得 lay-event å¯¹åº”的值
                if (layEvent === 'detail') {
                    layer.msg('查看操作');
                } else if (layEvent === 'del') {
                    layer.confirm('真的删除行么', function (index) {
                        layer.msg(JSON.stringify(obj.data), { icon: 1, btn: ['确认'], time: 100000, offset: 't', skin: 'layui-layer-lan', title: "温馨提示" });
                        obj.del(); //删除对应行(tr)的DOM结构
                        layer.close(index);
                        //向服务端发送删除指令
                    });
                } else if (layEvent === 'edit') {
                    layer.msg('编辑操作');
                }
            });
            //进入页面显示的缓存列表
            $.ajax({
                //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
                url: GetWEBURL1() + '/api/newBill/getStationInBillList',
                url: GetWEBURL() + '/api/newBill/getStationInBillList',
                type: "GET",
                data: { "sWhere": sWhere },
                success: function (data1) {
@@ -189,63 +222,63 @@
                        skin: 'layui-layer-lan', title: "温馨提示"
                    });
                }
            });
            });
            //重置按钮
            form.on('submit(btnReSearch)', function (data) {
                $("#HDate").val("");//开始日期
                $("#HDate1").val("");//结束日期
                $("#HOrderProcNO").val("");//订单跟踪号
                $("#WorkCenter").val("");//工作中心
                $("#HProcExchBillNo").val("");//流转卡号
                $("#HMaker").val("");//制单人
                $("#hname").val("");//产品名称
                $("#hnumber").val("");//产品代码
                $("#hmodel").val("");//规格型号
                $("#进站时间").val("");//进站时间
                $("#任务单").val("");//任务单
                $("#单据号").val("");//单据号
                $("#工序流转卡号").val("");//工序流转卡号
                $("#产品名称").val("");//产品名称
                $("#生产班组").val("");//生产班组
                $("#操作员").val("");//操作员
                $("#客户信息").val("");//客户信息
                $("#联系人信息").val("");//联系人信息
                $("#btnSearch").click();
            });
            //查询按钮
            form.on('submit(btnSearch)', function (data) {//选择仓位
                var HDate = $("#HDate").val();//开始日期
                var HDate1 = $("#HDate1").val();//结束日期
                var HOrderProcNO = $("#HOrderProcNO").val();//订单跟踪号
                var WorkCenter = $("#WorkCenter").val();//工作中心
                var HProcExchBillNo = $("#HProcExchBillNo").val();//流转卡号
                var HMaker = $("#HMaker").val();//制单人
                var hname = $("#hname").val();//产品名称
                var hnumber = $("#hnumber").val();//产品代码
                var hmodel = $("#hmodel").val();//规格型号
                if (HDate) {
                    sWhere += " and æ—¥æœŸ >= '" + HDate + "'";
                var è¿›ç«™æ—¶é—´ = $("#进站时间").val();//进站时间
                var ä»»åŠ¡å• = $("#任务单").val();//任务单
                var å•据号 = $("#单据号").val();//单据号
                var å·¥åºæµè½¬å¡å· = $("#工序流转卡号").val();//工序流转卡号
                var äº§å“åç§° = $("#产品名称").val();//产品名称
                var ç”Ÿäº§ç­ç»„ = $("#生产班组").val();//生产班组
                var æ“ä½œå‘˜ = $("#操作员").val();//操作员
                var å®¢æˆ·ä¿¡æ¯ = $("#客户信息").val();//客户信息
                var è”系人信息 = $("#联系人信息").val();//联系人信息
                if (进站时间) {
                    sWhere += " and CONVERT(varchar(100),进站时间, 23) = '" + è¿›ç«™æ—¶é—´ + "'";
                }
                if (HDate1) {
                    sWhere += " and æ—¥æœŸ <= '" + HDate1 + "'";
                if (任务单) {
                    sWhere += " and ä»»åŠ¡å• like '%" + ä»»åŠ¡å• + "%'";
                }
                if (HOrderProcNO) {
                    sWhere += " and è®¢å•跟踪号 like '%" + HOrderProcNO + "%'";
                if (单据号) {
                    sWhere += " and å•据号 like '%" + å•据号 + "%'";
                }
                if (WorkCenter) {
                    sWhere += " and å·¥ä½œä¸­å¿ƒ like '%" + WorkCenter + "%'";
                if (工序流转卡号) {
                    sWhere += " and å·¥åºæµè½¬å¡å· like '%" + å·¥åºæµè½¬å¡å· + "%'";
                }
                if (HProcExchBillNo) {
                    sWhere += " and æµè½¬å¡å· like '%" + HProcExchBillNo + "%'";
                if (产品名称) {
                    sWhere += " and äº§å“åç§° like '%" + äº§å“åç§° + "%'";
                }
                if (HMaker) {
                    sWhere += " and åˆ¶å•人 like '%" + HMaker + "%'";
                if (生产班组) {
                    sWhere += " and ç”Ÿäº§ç­ç»„ like '%" + ç”Ÿäº§ç­ç»„ + "%'";
                }
                if (hname) {
                    sWhere += " and äº§å“åç§° like '%" + hname + "%'";
                if (操作员) {
                    sWhere += " and æ“ä½œå‘˜ like '%" + æ“ä½œå‘˜ + "%'";
                }
                if (hnumber) {
                    sWhere += " and äº§å“ä»£ç  like '%" + hnumber + "%'";
                if (客户信息) {
                    sWhere += " and å®¢æˆ·ä¿¡æ¯ like '%" + å®¢æˆ·ä¿¡æ¯ + "%'";
                }
                if (hmodel) {
                    sWhere += " and è§„格型号 like '%" + hmodel + "%'";
                if (联系人信息) {
                    sWhere += " and è”系人信息 like '%" + è”系人信息 + "%'";
                }
                $.ajax({
                    //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
                    url: GetWEBURL1() + '/api/newBill/getStationInBillList',
                    url: GetWEBURL() + '/api/newBill/getStationInBillList',
                    type: "GET",
                    data: { "sWhere": sWhere },
                    success: function (data1) {
@@ -275,7 +308,7 @@
            //以上是layui模块
        });
    </script>