zgq
2021-03-10 1382e7f901677dce9db97ba25d9095668c1cb67f
WebTM/views/²Ö´æ¹ÜÀí/²Ö¿âµ÷²¦/Kf_LookingForBillList.html
File was renamed from WebTM/views/²Ö´æ¹ÜÀí/²Ö¿âµ÷²¦/Cc_LookingForBillList.html
@@ -2,14 +2,18 @@
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; 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">
    <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>
    <style type="text/css">
        input.layui-input.layui-unselect {
            padding-right: 0;
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
@@ -25,9 +29,10 @@
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label" style="width:60px;padding-left:0px;">单据类型</label>
                                    <label class="layui-form-label">单据类型</label>
                                    <div class="layui-input-block">
                                        <select name="HBillType" id="HBillType">
                                            <option value="">所有</option>
                                            <option value="ZHXJ">下架找货单</option>
                                            <option value="ZHSJ">上架归还单</option>
                                        </select>
@@ -40,26 +45,19 @@
                                    </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="HSourceBillNo" id="HSourceBillNo">
                                        <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy">
                                    </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">
                                            <span>其他条件></span>
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label">制单人</label>
                                        <div class="layui-input-block">
                                            <input type="text" class="layui-input" name="HCreateBy" id="HCreateBy">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
@@ -99,79 +97,54 @@
    <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 src="../../../layuiadmin/zgqCustom/zgqCustom.js"></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'], function () {
            var $ = layui.$
            , admin = layui.admin
            , layer = layui.layer
            , table = layui.table
            , form = layui.form
            , element = layui.element
            , laypage = layui.laypage
            , laydate = layui.laydate
            //var sWhere = " äº§å“ä»£ç  = 'BX0002'";
                , 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 = "";
            var option = {
                elem: '#mainTable'
                //, toolbar: '#toolbarDemo'
                ,height: 'full-50'
                , height: 'full-50'
                , page: true
                ,cellMinWidth: 90
                , cellMinWidth: 90
                , cols: [[
                    //{ field: 'hmainid', title: 'hmainid', width: 110 }
                    { field: '单据号', title: '单据号', sort: true, width: 165 }
                    , { field: '单据类型', title: '单据类型' }
                    , { field: '工艺名称', title: '工艺名称', width: 170 }
                    //, { field: 'hmaterid', title: 'hmaterid', width: 165 }
                    , { field: '物料代码', title: '物料代码', width: 160 }
                    , { field: '物料名称', title: '物料名称', width: 160 }
                    , { field: '规格型号', title: '规格型号', width: 215 }
                    , { field: '计量单位代码', title: '计量单位代码', width: 115 }
                    , { field: '计量单位', title: '计量单位' }
                    , { field: '默认工艺', title: '默认工艺' }
                    , { field: '表头备注', title: '表头备注' }
                    //, { field: 'hsubid', title: 'hsubid', width: 80 }
                    , { field: '工序号', title: '工序号' }
                    , { field: '委外标记', title: '委外标记' }
                    //, { field: 'hprocid', title: 'hprocid', width: 105 }
                    , { field: '工序代码', title: '工序代码' }
                    , { field: '工序', title: '工序' }
                    //, { field: 'HSupID', title: 'HSupID', width: 105 }
                    , { field: '供应商代码', title: '供应商代码' }
                    , { field: '供应商', title: '供应商' }
                    //, { field: 'HCenterID', title: 'HCenterID', width: 105 }
                    , { field: '工作中心代码', title: '工作中心代码', width: 115 }
                    , { field: '工作中心名称', title: '工作中心名称', width: 115 }
                    , { field: '时间单位', title: '时间单位' }
                    , { field: '运行时间', title: '运行时间' }
                    , { field: '加工数量', title: '加工数量' }
                    , { field: '准备时间', title: '准备时间' }
                    , { field: '排队时间', title: '排队时间' }
                    , { field: '转移时间', title: '转移时间' }
                    , { field: '良率', title: '良率' }
                    , { field: '累计良率', title: '累计良率' }
                    , { field: '表体备注', title: '表体备注' }
                    , { field: '制单人', title: '制单人' }
                    , { field: '制单日期', title: '制单日期' }
                    , { field: '审核人', title: '审核人' }
                    , { field: '审核日期', title: '审核日期' }
                    , { field: '修改人', title: '修改人' }
                    , { field: '修改日期', title: '修改日期' }
                    , { field: '作废人', title: '作废人' }
                    , { field: '作废日期', title: '作废日期' }
                    //, { field: 'HDayWorkQty', title: 'HDayWorkQty', width: 105 }
                    //, { field: 'HGroupID', title: 'HGroupID', width: 105 }
                    //, { field: 'HWorkerID', title: 'HWorkerID', width: 105 }
                    //, { field: 'HSourceID', title: 'HSourceID', width: 105 }
                    , { field: '加工单价', title: '加工单价' }
                    //, { field: 'HNextProcFlag', title: 'HNextProcFlag', width: 105 }
                    , { field: '下道流转工序', title: '下道流转工序'}
                    , { field: '流转工序', title: '流转工序' }
                    { field: 'HInterID', title: '单据ID', hide: true }
                    , { field: 'HBillNo', title: '单据号',width: 160 }
                    , { field: 'HStatus', title: '在库状态', width: 200 }
                    , { field: 'HGroupID', title: '班组ID', hide: true }
                    , { field: 'HGroup', title: '班组' }
                    , { field: 'HSourceID', title: '生产资源ID', hide: true }
                    , { field: 'HSource', title: '生产资源', width: 115 }
                    , { field: 'HCreateBy', title: '制单人' }
                    , {
                        field: 'HCreateDate', title: '制单时间', width: 110, templet: function (d) {
                            if (d.HCreateDate == null) {
                                return "";
                            }
                            return util.toDateString(d.HCreateDate, "yyyy-MM-dd");
                        }
                    }
                    , { field: 'HMaterID', title: '物料ID', hide: true }
                    , { field: 'HMaterNumber', title: '物料编码', width: 130 }
                    , { field: 'HMaterName', title: '物料名称', width: 120 }
                    , { field: 'HMaterModel', title: '规格型号' }
                    , { field: 'HBarCode', title: '条码', width: 175 }
                    , { field: 'HBarCodeType', title: '条码类型' }
                ]]
            };
@@ -179,9 +152,9 @@
            //进入页面显示的缓存列表
            $.ajax({
                //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
                url: GetWEBURL() + '/LEMS/MES_Gy_RoutingBillList_Json',
                url: GetWEBURL() + '/LookingFor/GetLookingForBillList',
                type: "GET",
                data: { "sWhere": sWhere },
                data: { "sWhere": sWhere, "HBillType": "" },
                success: function (data1) {
                    if (data1.count == 1) {
                        option.data = data1.data;
@@ -195,48 +168,72 @@
                    layer.close(index);
                    layer.alert("接口请求失败!", { icon: 5 });
                }
            });
            });
            //重置按钮
            form.on('submit(btnReSearch)', function (data) {
                $("#WorkCenter").val("");//单据号
                $("#hnumber").val("");//物料
                $("#HOrderProcNO").val("");//单据类型
                $("#HBillType").val("");//单据类型
                $("#HBillNo").val("");//单据号
                $("#HSourceBillNo").val("");//源单号
                $("#HCreateBy").val("");//制单人
                $("#BenginHCreateDate").val("");//开始制单时间
                $("#EndHCreateDate").val("");//结束制单时间
                $("#btnSearch").click();
            });
            //查询按钮
            form.on('submit(btnSearch)', function (data) {//选择仓位
                var HOrderProcNO = $("#HOrderProcNO").val();//单据类型
                var hnumber = $("#hnumber").val();//物料
                var WorkCenter = $("#WorkCenter").val();//单据号
                if (HOrderProcNO) {
                    sWhere += " and å•据类型 like '%" + HOrderProcNO + "%'";
                var HBillType = $("#HBillType").val();//单据类型
                var HBillNo = $("#HBillNo").val();//单据号
                var HCreateBy = $("#HCreateBy").val();//制单人
                var BenginHCreateDate = $("#BenginHCreateDate").val();//开始制单时间
                var EndHCreateDate = $("#EndHCreateDate").val();//结束制单时间
                if (HBillNo) {
                    sWhere += " and HBillNo like '%" + HBillNo + "%'";
                }
                if (hnumber) {
                    sWhere += " and ç‰©æ–™ä»£ç  like '%" + hnumber + "%' or ç‰©æ–™åç§° like '%" + hnumber + "%'"
                if (HCreateBy) {
                    sWhere += " and HCreateBy like '%" + HCreateBy + "%'";
                }
                if (WorkCenter) {
                    sWhere += " and å•据号 like '%" + WorkCenter + "%'";
                if (BenginHCreateDate) {
                    sWhere += " and CONVERT(varchar(100),HCreateDate, 23) >= '" + BenginHCreateDate + "'";
                }
                if (EndHCreateDate) {
                    sWhere += " and CONVERT(varchar(100),HCreateDate, 23) <= '" + EndHCreateDate + "'";
                }
                var index = layer.load(0);
                $.ajax({
                    //url: "http://61.130.49.162:9090/WMSAPI///Web/GetMAXNum",
                    url: GetWEBURL1() + '/LEMS/MES_Gy_RoutingBillList_Json',
                    url: GetWEBURL1() + '/LookingFor/GetLookingForBillList',
                    type: "GET",
                    data: { "sWhere": sWhere },
                    data: { "sWhere": sWhere, "HBillType": HBillType },
                    success: function (data1) {
                        if (data1.count == 1) {
                            option.data = data1.data;
                            table.render(option);
                            layer.close(index);
                            layer.alert("查询成功", { icon: 1 });
                        } else {
                            layer.close(index);
                            layer.alert(data1.code + data1.Message, { icon: 5 });
                        }
                    }, error: function () {
                        layer.close(index);
                        layer.alert("接口失效!", { icon: 5 });
                    }
                });
                sWhere = "";//调用接口后清空sWhere缓存
                //调用接口后清空sWhere缓存
                sWhere = "";
                //$("#HBillType").val("");//单据类型
                //$("#HBillNo").val("");//单据号
                //$("#HSourceBillNo").val("");//源单号
                //$("#HCreateBy").val("");//制单人
                //$("#BenginHCreateDate").val("");//开始制单时间
                //$("#EndHCreateDate").val("");//结束制单时间
            });
            //监听行双击事件
            table.on('rowDouble(mainTable)', function (obj) {
                layer.alert("双击事件", { icon: 1 });
            });
@@ -251,7 +248,7 @@
            //以上是layui模块
        });
    </script>