WebTM/views/²É¹º¹ÜÀí/²É¹º¶©µ¥/Cg_POOrderBillQuery.html
@@ -1,5 +1,6 @@
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>采购订单查询</title>
@@ -18,12 +19,13 @@
    <script src="../../../layuiadmin/HideButton.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/layui-common-custom.js"></script>
    <script src="../../../layuiadmin/setColumn.js"></script>
    <style type="text/css">
        .layui-table-click {
            background: #ceedfa;
            color: black
        }
    </style>
</head>
@@ -43,77 +45,111 @@
                                <div class="layui-inline">
                                    <label class="layui-form-label">日期间隔</label>
                                    <div class="layui-input-block">
                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes" lay-filter="HInitTimeCycle" style="width:190px;">
                                        <select name="HInitTimeCycle" id="HInitTimeCycle" class="ForFilteringSchemes"
                                                lay-filter="HInitTimeCycle" style="width:190px;">
                                        </select>
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">开始日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate" style="width:190px;">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HBeginDate"
                                               style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">结束日期</label>
                                    <div class="layui-input-block">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate" style="width:190px;">
                                        <input type="date" class="layui-input ForFilteringSchemes" id="HEndDate"
                                               style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
                                    <label class="layui-form-label">单据号</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBillNo" id="HBillNo" style="width:190px;">
                                        <input type="text" class="layui-input ForFilteringSchemes" name="HBillNo"
                                               id="HBillNo" style="width:190px;">
                                    </div>
                                </div>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnSearch" id="btnSearch">
                                <div class="layui-inline">
                                    <label class="layui-form-label">组织</label>
                                    <div class="layui-input-block" style="margin-left: 120px;">
                                        <select name="HUSEORGID" id="HUSEORGID" class=" ForFilteringSchemes" lay-verify="HUSEORGID">
                                            <!--动态渲染组织-->
                                        </select>
                                    </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>
                                <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit=""
                                        lay-filter="btnReSearch" id="btnReSearch" style="padding:0 5px">
                                    é‡ç½®
                                </button>
                                <!--显示当前过滤方案-->
                                <div class="layui-inline" style="margin-left:5px;">
                                    <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393" id="HFilterScheme_Now"></div>
                                    <div style="text-align:center;font-size:15px;font-weight:bold;color:#fc9393"
                                         id="HFilterScheme_Now"></div>
                                </div>
                                <div class="layui-colla-content">
                                    <div class="layui-row" style="margin-top:5px">
                                        <div class="layui-inline">
                                            <label class="layui-form-label">业务员</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HEmpName" id="HEmpName" style="width:190px;">
                                                <input type="text" class="layui-input ForFilteringSchemes"
                                                       name="HEmpName" id="HEmpName" style="width:190px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">供应商</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HSupName" id="HSupName" style="width:190px;">
                                                <input type="text" class="layui-input ForFilteringSchemes"
                                                       name="HSupName" id="HSupName" style="width:190px;">
                                            </div>
                                        </div>
                                        <div class="layui-inline">
                                            <label class="layui-form-label">单据号</label>
                                            <div class="layui-input-block">
                                                <input type="text" class="layui-input ForFilteringSchemes" name="HBillno2" id="HBillno2" style="width:190px;">
                                                <input type="text" class="layui-input ForFilteringSchemes"
                                                       name="HBillno2" id="HBillno2" style="width:190px;">
                                            </div>
                                        </div>
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit="" lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">重新同步</button>
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit=""
                                                lay-filter="btnResCnz" id="btnReSearch" style="padding:0 5px">
                                            é‡æ–°åŒæ­¥
                                        </button>
                                        <button class="layui-btn layuiadmin-btn-order" type="button" lay-submit=""
                                                lay-filter="btnResCnzManual" id="btnResCnzManual"
                                                style="padding:0 5px">
                                            æ‰‹å·¥åŒæ­¥
                                        </button>
                                    </div>
                                    <div class="layui-inline">
                                        <div class="layui-row" style="margin-top:5px">
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block">
                                                    <select name="ColName" id="ColName" class="ForFilteringSchemes" lay-filter="ColName" style="width:190px;">
                                                    <select name="ColName" id="ColName" class="ForFilteringSchemes"
                                                            lay-filter="ColName" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator" id="Comparator" class="ForFilteringSchemes" lay-filter="Comparator" style="width:190px;">
                                                <select name="Comparator" id="Comparator" class="ForFilteringSchemes"
                                                        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="<=">
                                                        <=< /option>
                                                    <option value="<">
                                                        << /option>
                                                    <option value="<>">
                                                        <>
                                                    </option>
                                                    <option value="7">包含</option>
                                                    <option value="8">左包含</option>
                                                    <option value="9">右包含</option>
@@ -121,7 +157,8 @@
                                                </select>
                                            </div>
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent" id="ColContent">
                                                <input type="text" class="layui-input ForFilteringSchemes" value=""
                                                       name="ColContent" id="ColContent">
                                            </div>
                                        </div>
@@ -129,19 +166,25 @@
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block">
                                                    <select name="ColName1" id="ColName1" class="ForFilteringSchemes" lay-filter="ColName1" style="width:190px;">
                                                    <select name="ColName1" id="ColName1" class="ForFilteringSchemes"
                                                            lay-filter="ColName1" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator1" id="Comparator1" lay-filter="Comparator1" class="ForFilteringSchemes" style="width:190px;">
                                                <select name="Comparator1" id="Comparator1" lay-filter="Comparator1"
                                                        class="ForFilteringSchemes" 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="<=">
                                                        <=< /option>
                                                    <option value="<">
                                                        << /option>
                                                    <option value="<>">
                                                        <>
                                                    </option>
                                                    <option value="7">包含</option>
                                                    <option value="8">左包含</option>
                                                    <option value="9">右包含</option>
@@ -149,7 +192,8 @@
                                                </select>
                                            </div>
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent1" id="ColContent1">
                                                <input type="text" class="layui-input ForFilteringSchemes" value=""
                                                       name="ColContent1" id="ColContent1">
                                            </div>
                                        </div>
@@ -157,19 +201,25 @@
                                            <div class="layui-inline">
                                                <label class="layui-form-label">过滤</label>
                                                <div class="layui-input-block">
                                                    <select name="ColName2" id="ColName2" class="ForFilteringSchemes" lay-filter="ColName2" style="width:190px;">
                                                    <select name="ColName2" id="ColName2" class="ForFilteringSchemes"
                                                            lay-filter="ColName2" style="width:190px;">
                                                    </select>
                                                </div>
                                            </div>
                                            <div class="layui-inline">
                                                <select name="Comparator2" id="Comparator2" lay-filter="Comparator2" class="ForFilteringSchemes" style="width:190px;">
                                                <select name="Comparator2" id="Comparator2" lay-filter="Comparator2"
                                                        class="ForFilteringSchemes" 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="<=">
                                                        <=< /option>
                                                    <option value="<">
                                                        << /option>
                                                    <option value="<>">
                                                        <>
                                                    </option>
                                                    <option value="7">包含</option>
                                                    <option value="8">左包含</option>
                                                    <option value="9">右包含</option>
@@ -177,7 +227,8 @@
                                                </select>
                                            </div>
                                            <div class="layui-inline">
                                                <input type="text" class="layui-input ForFilteringSchemes" value="" name="ColContent2" id="ColContent2">
                                                <input type="text" class="layui-input ForFilteringSchemes" value=""
                                                       name="ColContent2" id="ColContent2">
                                            </div>
                                        </div>
                                    </div>
@@ -209,6 +260,7 @@
                                <button type="button" class="layui-btn layui-btn-sm" lay-event="get_Exit" id="Exit"><i class="layui-icon layui-icon-logout"></i>退出</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_SaveScheme" id="set_SaveScheme"><i class="layui-icon layui-icon-template"></i>保存方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="set_ReadScheme" id="set_ReadScheme"><i class="layui-icon layui-icon-set"></i>读取方案</button>
                                <button type="button" class="layui-btn layui-btn-sm" style="display:none;" lay-event="push_POStockInCheckBill" id="push_POStockInCheckBill"><i class="layui-icon layui-icon-set"></i>下推(来料检验单)</button>
                            </div>
                        </script>
                        <table class="" id="mainTableSub" lay-filter="mainTableSub" style="margin-top:35px"></table>
@@ -229,7 +281,7 @@
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate','soulTable'], function () {
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate', 'soulTable'], function () {
            //#region å…¬å…±å˜é‡
            var $ = layui.$
                , admin = layui.admin
@@ -251,7 +303,7 @@
            //#region ã€åŠ¨æ€èŽ·å–æ¨¡å—åç§°ã€‘
            var HModuleType = "1102";
            //通过单据类型,从数据库动态获取单据模块命名,引用js文件 PageTitle.js
            var HPageTitle = get_PageTitle(HModuleType) == "" ? document.title : get_PageTitle(HModuleType);
            var HPageTitle = get_PageTitle(HModuleType) || document.title;
            //#endregion
            ////不需要显示的字段 å¯æ‰©å±•
@@ -384,7 +436,17 @@
                set_ClearQuery();
            });
            table.on('tool(mainTable)' , function (obj) {
            //手工同步按钮
            form.on('submit(btnResCnzManual)', function (data) {
                get_ResCnzManual(layer, HBillType, get_FastQuery)
            })
            //下推来料检验单
            form.on("submit(push_POStockInCheckBill)", function(data){
                push_POStockInCheckBill()
            })
            table.on('tool(mainTable)', function (obj) {
                var data = obj.data;
                if (obj.event == '单据号') {
                    var linterid = data.hmainid.toString();
@@ -411,7 +473,7 @@
            //查询按钮
            form.on('submit(btnSearch)', function (data) {
                get_FastQuery(table, option,2);
                get_FastQuery(table, option, 2);
            });
            //日期间隔下拉列表监听
@@ -454,10 +516,12 @@
                //初始化表格
                set_InitGrid();
                ////直接执行列表筛选 åŠ è½½æ•°æ®åˆ°ç½‘æ ¼
                get_FastQuery(table, option,1)
                get_FastQuery(table, option, 1)
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
                Organ();
            }
            //初始化表格
            function set_InitGrid() {
@@ -485,7 +549,7 @@
                    , totalRow: true
                    , cellMinWidth: 90
                    , limit: 50
                    , cols:[[]]
                    , cols: [[]]
                    , limits: [50, 500, 5000, 20000]
                    , done: function (res, curr, count) {
                        soulTable.render(this);
@@ -500,7 +564,7 @@
                    url: GetWEBURL() + '/Cg_POOrderBill/QueryList',
                    type: "GET",
                    async: false,
                    data: { "sWhere": sWhere  , "user": sessionStorage["HUserName"]},
                    data: { "sWhere": sWhere, "user": sessionStorage["HUserName"] },
                    success: function (data1) {
                        if (data1.count == 1) {
                            var data = [];//列字段数据
@@ -518,7 +582,7 @@
                                }
                            }
                            //在列表左边添加勾选框
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计'});
                            col.push({ type: 'checkbox', fixed: 'left', totalRowText: '合计' });
                            for (var i = 0; i < data.length; i++) {
                                // if (data[i].name == 'HInterID' || data[i].name == 'HBillType' || data[i].name == 'hmainid') {
                                if ($.inArray(data[i].name, titleData) > -1) {
@@ -538,11 +602,11 @@
                                            return '<span style="color: blue;">' + d.当前审核项目 + '</span>'
                                        }, style: 'cursor: pointer;'
                                    });
                                }else {
                                } else {
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{layui.util.toDateString(d." + (data[i].name != "日期" ? data[i].name + ", 'yyyy-MM-dd HH:mm:ss'" : data[i].name +", 'yyyy-MM-dd'")+")}}</div>", width: 200 });
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{layui.util.toDateString(d." + (data[i].name != "日期" ? data[i].name + ", 'yyyy-MM-dd HH:mm:ss'" : data[i].name + ", 'yyyy-MM-dd'") + ")}}</div>", width: 200 });
                                            break;
                                        default:
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 });
@@ -557,9 +621,9 @@
                            //刷新表格数据
                            DisPlay_HideColumn();
                            if ($("#Comparator").val() == 0 && $("#ColContent").val() == "") {
                            if ($("#ColName option").length < 1) {
                                ColFilter();
                                // get_DefaultModule();//加载方案
                            }
                            layer.close(ajaxLoad);
                            //layer.alert("查询成功", { icon: 1 });
@@ -573,7 +637,28 @@
                    }
                });
            }
            //#region èŽ·å–ç»„ç»‡
            function Organ() {
                //获取登录页组织列
                $.ajax({
                    type: "get",
                    async: false,
                    url: GetWEBURL() + "/Web/GetOrganizations",
                    success: function (result) {
                        var Organization = "";
                        if (result.count == 1) { // è¯´æ˜ŽéªŒè¯æˆåŠŸäº†ï¼Œ
                            var data = result.data;
                            for (var i = 0; i < data.length; i++) {
                                Organization += '<option  style="color:blue;" value="' + data[i].ID + '">' + data[i].Name + '</option>';
                            }
                            $("#HUSEORGID").append(Organization);
                            $("#HUSEORGID").val(sessionStorage["OrganizationID"])
                            form.render('select');
                        }
                        layer.closeAll("loading");
                    }
                })
            }
            //查询子表数据
            function get_DisplaySub(obj) {
                var datas = obj; //获得当前行数据
@@ -588,7 +673,7 @@
                        if (data1.count == 1) {
                            var data = [];//列字段数据
                            var col = [];
                            var totalArray = ["数量", "关联数量", "未关联数量","入库数量", "金额"];
                            var totalArray = ["数量", "关联数量", "未关联数量", "入库数量", "金额"];
                            titleData = [];
                            //给空的数组赋值
                            for (var key in data1.list) {
@@ -708,30 +793,30 @@
                    layer.confirm("确认要删除吗,删除后不能恢复", { title: "删除确认" }, function (index) {
                        /*if (data[0].状态 == "创建") {*/
                            $.ajax({
                                type: "GET",
                                url: GetWEBURL() + "/Cg_POOrderBill/DeltetCg_POOrderBill", //方法所在页面和方法名
                                data: { "HInterID": InterID, "user": sessionStorage["HUserName"] },
                                success: function (result) {
                                    if (result.count == 1) {
                                        layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                            // å¾—到frame索引
                                            var index = layer.getFrameIndex(window.name);
                                            //关闭当前frame
                                            layer.close(index);
                                            //修改为功后刷新界面
                                            window.location.reload();
                                        });
                        $.ajax({
                            type: "GET",
                            url: GetWEBURL() + "/Cg_POOrderBill/DeltetCg_POOrderBill", //方法所在页面和方法名
                            data: { "HInterID": InterID, "user": sessionStorage["HUserName"] },
                            success: function (result) {
                                if (result.count == 1) {
                                    layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
                                        // å¾—到frame索引
                                        var index = layer.getFrameIndex(window.name);
                                        //关闭当前frame
                                        layer.close(index);
                                        //修改为功后刷新界面
                                        window.location.reload();
                                    });
                                    } else {
                                        layer.alert(result.code + result.Message, { icon: 5 });
                                    }
                                }, error: function () {
                                    layer.alert("接口请求失败!", { icon: 5 });
                                } else {
                                    layer.alert(result.code + result.Message, { icon: 5 });
                                }
                            });
                            }, error: function () {
                                layer.alert("接口请求失败!", { icon: 5 });
                            }
                        });
                        //} else {
                        //    layer.msg('该条数据不是创建状态,无法删除!');
@@ -1066,12 +1151,13 @@
            //快速过滤
            function get_FastQuery(table, option,number) {
            function get_FastQuery(table, option, number) {
                var HBeginDate = $("#HBeginDate").val();//开始日期
                var HEndDate = $("#HEndDate").val();//结束日期
                var HBillNo = $("#HBillNo").val(); //单据号
                var HEmpName = $("#HEmpName").val();
                var HSupName = $("#HSupName").val();//供应商
                var HUSEORGID = $("#HUSEORGID").val();//zuzhi
                //任意字段过滤
                var ColName = $("#ColName").val();//复选框
                var Comparator = $("#Comparator").val()
@@ -1168,7 +1254,9 @@
                    sWhere += " and ä¾›åº”商 like '%" + HSupName + "%'";
                }
                if (HUSEORGID) {
                    sWhere += " and ç»„织 like '%" + HUSEORGID + "%'";
                }
                sWhere += addSWhereByOpenType();
                //添加查询条件,根据当前登录用户关联职员返回数据
@@ -1210,7 +1298,7 @@
                $.ajax({
                    url: GetWEBURL() + '/Cg_POOrderBill/Cg_POOrderBillViewApi',
                    type: "GET",
                    data: { "BillNo": HBillno2,"BillType":1102 },
                    data: { "BillNo": HBillno2, "BillType": 1102 },
                    success: function (result) {
                        if (result.count == 1) {
                            layer.msg(result.Message, { time: 1 * 1000, icon: 1 }, function () {
@@ -1231,7 +1319,6 @@
                    }
                });
            }
            //#endregion
            //刷新
            function set_Refresh() {
@@ -1281,7 +1368,9 @@
                            dataCol = data1.data[0].HGridString.split(',');
                            for (var i = 0; i < option.cols[0].length - 1; i++) {
                                var dataCols = dataCol[i].split('|');
                                if (dataCol[i]) {
                                    var dataCols = dataCol[i].split('|');
                                }
                                //隐藏列
                                if (dataCols[1] == 1) {
                                    option.cols[0][i + 1]["hide"] = true;
@@ -1501,7 +1590,7 @@
                });
                //显示子表
                get_DisplaySub(obj.data);
            })
            //子表单选
            table.on('row(mainTableSub)', function (obj) {
@@ -1513,6 +1602,22 @@
            })
            //#endregion
            //#region æŽ’序后选择
            table.on('sort(mainTable)', function (obj) { //注:sort æ˜¯å·¥å…·æ¡äº‹ä»¶åï¼Œtest æ˜¯ table åŽŸå§‹å®¹å™¨çš„å±žæ€§ lay-filter="对应的值"
                table.reload('mainTable', {
                    initSort: obj //记录初始排序,如果不设的话,将无法标记表头的排序状态。 layui 2.1.1 æ–°å¢žå‚æ•°
                    , where: { //请求参数(注意:这里面的参数可任意定义,并非下面固定的格式)
                        field: obj.field //排序字段   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                        , order: obj.type //排序方式   åœ¨æŽ¥å£ä½œä¸ºå‚数字段  field order
                    }
                });
                option.data = layui.table.cache["mainTable"];
                table.render(option);
                //刷新按钮显示
                var btns = document.getElementsByTagName("button");     //获取本页所有按钮对象
                Display_HideButton(btns, HBillType, HModName, sessionStorage["HUserName"]);
            });
            //#endregion
            //#region åˆå§‹æ—¥æœŸé—´éš” ä¸‹æ‹‰åˆ—表
            function setSelect_HInitTimeCycle() {
@@ -1607,8 +1712,8 @@
                            //当前用户没有设置默认的过滤方案
                            //隐藏显示过滤方案的标签信息
                            document.getElementById("HFilterScheme_Now").style.display = "none";
                            ////执行查询方法
                            get_FastQuery()
                            //执行查询方法
                            //get_FastQuery()
                            //form.render("select");
                        }
                    }, error: function () {
@@ -1851,4 +1956,5 @@
        //#endregion
    </script>
</body>
</html>