月度汇报统计表 添加 超链接 根据超链接打开任务汇报列表根据传递的数据查找对应职员在指定范围内的汇报任务
2个文件已添加
6个文件已修改
157 ■■■■ 已修改文件
WebTM/WebTM.csproj 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/WebTM.csproj.user 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/layuiadmin/Scripts/webConfig.js 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/仓存管理/组托单/Sc_PackUnionBillMain_Setto.html 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/仓存管理/装箱单/Sc_PackUnionBillMain_Packing.html 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/项目管理/工作任务/PM_WorkTaskBillList.html 2 ●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/项目管理/工作任务/PM_WorkTaskReportBillList.html 25 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/views/项目管理/报表分析/PM_WorkTaskReportMonthSumReport.html 102 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebTM/WebTM.csproj
@@ -421,6 +421,8 @@
    <Content Include="views\人事管理\职员异动单\HR_EmpChangeBillList.html" />
    <Content Include="views\仓存管理\条码报表\Kf_ICInvBalList.html" />
    <Content Include="views\仓存管理\生产入库单\Kf_ProductInBillList.html" />
    <Content Include="views\仓存管理\组托单\Sc_PackUnionBillMain_Setto.html" />
    <Content Include="views\仓存管理\装箱单\Sc_PackUnionBillMain_Packing.html" />
    <Content Include="views\公共页面\Kf_ChaoBaoEditDlg.html" />
    <Content Include="views\公共页面\Kf_SourceBillEditDlg_PDA.html" />
    <Content Include="views\品质管理\客诉处理\QC_CustomerAppealReport_BadClass.html" />
WebTM/WebTM.csproj.user
@@ -4,7 +4,7 @@
    <NameOfLastUsedPublishProfile>D:\智云迈思\MES\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <NameOfLastUsedPublishProfile>D:\WorkBench\MES-WEB-LayUI\WebTM\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile>
    <ProjectView>ShowAllFiles</ProjectView>
    <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig>
    <LastActiveSolutionConfig>Release|Any CPU</LastActiveSolutionConfig>
    <UseIISExpress>true</UseIISExpress>
    <Use64BitIISExpress />
    <IISExpressSSLPort />
WebTM/layuiadmin/Scripts/webConfig.js
@@ -6,7 +6,7 @@
    /*var WEBURL = "http://localhost/API/";             //颜晓军本地配置*/
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //杨乐本地配置
    //var WEBURL = "http://localhost:8082/API/";    //杜贺本地配置
    var WEBURL = "http://localhost:8082/API/";    //张瑞广本地配置
    //var WEBURL = "http://localhost:8082/API/";    //张瑞广本地配置
    //var WEBURL = "http://localhost:81/API/"    //翁涛涛本地配置
    //var WEBURL = "http://localhost:8082/LuBaoAPI/";    //杨乐本地配置
    //var WEBURL = "http://localhost:8082/API/";    //杜贺本地配置
@@ -31,7 +31,7 @@
    //var WEBURL = "http://192.168.60.12/API";          //中控
    //var WEBURL = "http://192.168.6.5:8082/API/";    //舜成
    /*var WEBURL = "http://121.36.199.126:8181/API/";    //三升*/
/*    var WEBURL = "http://localhost:81/API";*/
    var WEBURL = "http://localhost:81/API";
    return WEBURL
}
WebTM/views/²Ö´æ¹ÜÀí/×éÍе¥/Sc_PackUnionBillMain_Setto.html
New file
@@ -0,0 +1,10 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title></title>
</head>
<body>
</body>
</html>
WebTM/views/²Ö´æ¹ÜÀí/×°Ïäµ¥/Sc_PackUnionBillMain_Packing.html
New file
@@ -0,0 +1,10 @@
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <title></title>
</head>
<body>
</body>
</html>
WebTM/views/ÏîÄ¿¹ÜÀí/¹¤×÷ÈÎÎñ/PM_WorkTaskBillList.html
@@ -1560,7 +1560,7 @@
                if (openType == 2) {
                    sWhere += " and HBillStatus=2 ";
                    $("#HOrgID").val(HOrgID);
                    form.render("select");
                    form.render("select");zz
                    return true;
                }
                return false;
WebTM/views/ÏîÄ¿¹ÜÀí/¹¤×÷ÈÎÎñ/PM_WorkTaskReportBillList.html
@@ -21,6 +21,7 @@
    <script src="../../../layuiadmin/PubCustom.js"></script>
    <script src="../../../layuiadmin/soulTable.slim.js"></script>
    <script src="../../../layuiadmin/PageTitle.js"></script>
    <script src="../../../layuiadmin/common.js"></script>
</head>
@@ -410,11 +411,6 @@
                //初始化组织
                Organ();
                //查询
                if (addSWhereByOpenType()) {                        //addSWhereByOpenType()方法判断是否其它页面打开本页面,若是则处理过滤条件,并返回true
                    get_FastQuery(2);
                } else {
                    get_FastQuery(1);
                }
                //查询当前登录用户有没有在当前模块设置默认过滤方案
                get_DefaultModule();
            }
@@ -620,11 +616,14 @@
            //#region å¿«é€Ÿè¿‡æ»¤
            function get_FastQuery(number) {
                ////获取登录账户对应职员名称
                let openType = addSWhereByOpenType()
                var HUserName = getHEmpByHUserName();
                if (HUserName != "" && HUserName != null) {
                    sWhere = " and æ±‡æŠ¥äºº = N'" + HUserName + "' OR æŽ¥æ”¶äºº = N'" + HUserName + "' OR æŠ„送人 like N'%"
                    sWhere += " and æ±‡æŠ¥äºº = N'" + HUserName + "' OR æŽ¥æ”¶äºº = N'" + HUserName + "' OR æŠ„送人 like N'%"
                        + HUserName + "%'";
                }
                var HOrgID = "";
                var HBillNo = $("#HBillNo").val();  //单据号
@@ -707,7 +706,7 @@
                    }
                    sWhere += " and " + ColName2 + " " + com2;
                }
                if (number == 1) {
                if (openType == false) {
                    HOrgID = sessionStorage["OrganizationID"];
                }
                else {
@@ -1245,6 +1244,18 @@
                var params = getUrlVars();
                var openType = params[params[0]]; //从参数中获取 æ‰“开方式  1直接打开 2其它页面通过选择按钮打开
                var HOrgID = params[params[1]];
                var Employee = params[params[2]]; // èŒå‘˜
                var DateInfo = params[params[3]]; // æ—¥æœŸä¿¡æ¯
                if (isEmpty(Employee) === false && isEmpty(DateInfo) === false) {
                    let EmployeeDecode = decodeURIComponent(Employee)
                    debugger
                    $('#HReportEmp').val(EmployeeDecode)
                    if (DateInfo.length == 7) { //年月
                        sWhere += " and æ—¥æœŸ >= CAST(N'" + DateInfo + "' + '-01' AS DATE) and æ—¥æœŸ < DATEADD(MONTH, 1, CAST(N'" + DateInfo + "' + '-01' AS DATE))"
                    } else if (DateInfo.length == 10) { //年月日
                        sWhere += " and æ—¥æœŸ >= CAST(N'" + DateInfo + "' AS DATE) and æ—¥æœŸ < DATEADD(DAY, 1, CAST(N'" + DateInfo + "' AS DATE))"
                    }
                }
                if (openType == 2) {
                    sWhere += " and ISNULL(关闭人,'') = '' and ISNULL(作废人,'') = '' ";
                    $("#HOrgID").val(HOrgID);
WebTM/views/ÏîÄ¿¹ÜÀí/±¨±í·ÖÎö/PM_WorkTaskReportMonthSumReport.html
@@ -1,5 +1,6 @@
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>月度汇报统计报表</title>
@@ -22,6 +23,7 @@
        }
    </style>
</head>
<body>
    <div class="layui-fluid">
        <div class="layui-col-md12">
@@ -39,7 +41,8 @@
                                <div class="layui-inline">
                                    <label class="layui-form-label">职员</label>
                                    <div class="layui-input-block">
                                        <input type="text" class="layui-input" name="HEmpName" id="HEmpName" style="width:190px;">
                                        <input type="text" class="layui-input" name="HEmpName" id="HEmpName"
                                            style="width:190px;">
                                    </div>
                                </div>
                                <div class="layui-inline">
@@ -50,7 +53,8 @@
                                        </select>
                                    </div>
                                </div>
                                <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>
                        </div>
                        <table class="" id="mainTable" lay-filter="mainTable"></table>
@@ -69,6 +73,8 @@
            </div>
        </div>
    </div>
    </script>
    <script>
        //#region æŠ˜å æ³¨é‡Š
        //#endregion
@@ -76,9 +82,9 @@
            base: '../../../layuiadmin/' //静态资源所在路径
        }).extend({
            index: 'lib/index', //主入口模块
        }).use(['index', 'form', 'table', 'element', 'laypage','laydate'], function () {
        //#region å…¬å…±å˜é‡
        }).use(['index', 'form', 'table', 'element', 'laypage', 'laydate'], function () {
            //#region å…¬å…±å˜é‡
            var $ = layui.$
                , admin = layui.admin
                , layer = layui.layer
@@ -87,6 +93,7 @@
                , element = layui.element
                , laypage = layui.laypage
                , laydate = layui.laydate
                , util = layui.util
            var sDate = Format(new Date(), "yyyy-MM-dd")
            var sWhere = "";
            var option = [];
@@ -94,9 +101,9 @@
            var columns = "";
            var HModName = "PM_ProjectWorkDaysSumReport";
            var titleData = [];     //不需要显示的字段
        //#endregion
            //#endregion
        //#region è¿›å…¥é¡µé¢å³åŠ è½½
            //#region è¿›å…¥é¡µé¢å³åŠ è½½
            //初始化界面
            set_ClearBill();
@@ -106,7 +113,7 @@
                //获取组织
                Organ();
                //初始化表单时间
                set_InitDate();
                set_InitDate();
                //初始化表格
                set_InitGrid();
                //查询
@@ -129,7 +136,7 @@
                        });
                    }
                    //选择月份即选中关闭  å¹´ä»½æ‰”可以左右点击选择
                    ,change: function (value, date, endDate) { //监听日期被切换
                    , change: function (value, date, endDate) { //监听日期被切换
                        lay('#HDate').val(value);
                        sDate = Format($("#HDate").val() + "-01", "yyyy-MM-dd");
                        $('.laydate-month-list').on('click', 'li', function () {//利用的事件委托
@@ -285,9 +292,9 @@
            }
            //#endregion
        //#endregion
            //#endregion
        //#region æœ¬é¡µé¢æ‰€æœ‰è¢«è°ƒç”¨çš„æ–¹æ³•
            //#region æœ¬é¡µé¢æ‰€æœ‰è¢«è°ƒç”¨çš„æ–¹æ³•
            //#region å·¥å…·æ äº‹ä»¶
            table.on('toolbar(mainTable)', function (obj) {
@@ -314,11 +321,45 @@
            });
            //#endregion
            //#region å•元格单击事件
            table.on('tool(mainTable)', function (obj) {
                let index = obj.index
                let $elem = $(this) // èŽ·å–ç‚¹å‡»çš„å…ƒç´ 
                if (obj.event === "workTimeClickHandler") {
                    debugger
                    let dateInfo = $elem.data('value')
                    get_WorkTaskList(obj.data['职员'], dateInfo)
                }
            })
            //#endregion
            //#region å¯¼å‡ºExecel
            function get_Export() {
                table.exportFile(ins.config.id, option.data, "xls");
            }
            //#endregion
            function get_WorkTaskList(Employee, DateInfo) {
                let EmployeeEncode = encodeURIComponent(Employee)
                layer.open({
                    type: 2
                    , skin: "layui-layer-rim" //加上边框
                    , title: "工作任务"  //标题
                    , closeBtn: 1  //窗体右上角关闭 çš„ æ ·å¼
                    , shift: 2 //弹出动画
                    , area: ["90%", "90%"] //窗体大小
                    , maxmin: true //设置最大最小按钮是否显示
                    , content: ['../../项目管理/工作任务/PM_WorkTaskReportBillList.html?openType=&HOrgID=' + sessionStorage["OrganizationID"] + '&Employee=' + EmployeeEncode + '&DateInfo=' + DateInfo, "yes"]
                    , btn: ["确定", "取消"]
                    , btn1: function (index, laero) {
                        //刷新表格数据
                        get_Display();
                        //更新表格缓存的数据
                        layer.close(index);//关闭弹窗
                    }
                })
            }
            //#region æŸ¥è¯¢
            function get_Display() {
@@ -326,7 +367,6 @@
                var HEmpName = $("#HEmpName").val();    //职员
                sWhere = "'" + HDate + "','" + HEmpName + "'";
                var ajaxLoad = layer.load();
                $.ajax({
                    type: "GET",
@@ -358,8 +398,38 @@
                                    switch (data[i].Type) {
                                        //int
                                        case 'DateTime':
                                            col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: "<div>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + 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'>{{d." + data[i].name + " ==null ?'':layui.util.toDateString(d." + data[i].name + ", 'yyyy-MM-dd')}}</div>", width: 200 });
                                            break;
                                        //每日工作时长
                                        case 'Decimal':
                                            let date = util.toDateString(HDate, "yyyy-MM")
                                            let prefix = data[i].name.split("_").reverse()[1]
                                            console.log(typeof prefix)
                                            if (typeof prefix == "undefined") {
                                            }
                                            else if (prefix.length < 2) {
                                                prefix = '-0' + prefix
                                            }
                                            else {
                                                prefix = '-' + prefix
                                            }
                                            prefix = prefix || ''
                                            col.push({
                                                field: data[i].id, title: data[i].name, align: 'center', sort: true, templet: ((d) => {
                                                    let node = document.createElement("div")
                                                    let node_sub = document.createElement("div")
                                                    node_sub.setAttribute("data-value", date + prefix)
                                                    node_sub.setAttribute("lay-event", "workTimeClickHandler")
                                                    node_sub.style.color = "blue";
                                                    node_sub.innerHTML = "{{= d['" + data[i].name + "']==0? '0' : d['" + data[i].name + "'] }}"
                                                    node.appendChild(node_sub)
                                                    return node.outerHTML
                                                })()
                                                , width: 200
                                            });
                                            break
                                        default:
                                            if (data[i].name == '本月合计') {
                                                col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true });
@@ -533,8 +603,7 @@
            }
            //#endregion
        //#endregion
            //#endregion
        });
@@ -544,4 +613,5 @@
    </script>
</body>
</html>
</html>