Calculation/app/public/report/js/rpt_signature.js

/**
 * Created by Tony on 2019/9/25.
 */

'use strict'

const DFT_ROLE_NAME = '';

let rptSignatureHelper = {
    currentSelectedESignAccDom: null,
    currentSelectedESignAccIdx: -1,
    currentSelectedESignAccName: null,
    originalRoleRelList: [],
    buildSelectableAccount: function () {
        //PRJ_ACCOUNT_LIST
        //1. 清理所有选择项
        // $("#project_account_select_div").empty();
        let accDiv = $('#project_account_select_div');
        let accSelect = $('#project_account_select_dom'); //绑定成员
        accDiv.empty();
        accSelect.empty();
        //2. 一个个加可选用户项
        const prj_accounts = [];
        const prj_sel_option_accounts = [];
        const acc_role_keys = [];
        for (let accIdx = 0; accIdx < PRJ_ACCOUNT_LIST.length; accIdx++) {
            const prjAccount = PRJ_ACCOUNT_LIST[accIdx];
            let companyKey = prjAccount.account_group;
            let roleKey = prjAccount.role;
            if (companyKey === '') {
                companyKey = '其他单位';
            }
            if (roleKey === '') {
                roleKey = DFT_ROLE_NAME;
            }
            let keyIdx = acc_role_keys.indexOf(companyKey);
            if (keyIdx < 0) {
                acc_role_keys.push(companyKey);
                prj_accounts.push([]);
                prj_sel_option_accounts.push([]);
                keyIdx = prj_accounts.length - 1;
                //这里先push一些 html prefix，在后面统一在push html suffix
                prj_accounts[keyIdx].push('<ul class="list-group">');
                prj_accounts[keyIdx].push('<li class="px-2 text-muted"><i class="fa fa-caret-down"></i> ' + companyKey + '</li>');
                prj_sel_option_accounts[keyIdx].push('<optgroup label=" ' + companyKey + '">');
            }
            //push item
            prj_accounts[keyIdx].push('<li class="add-sign-list-item"><a href="javascript:void(0)" onclick="rptSignatureHelper.createEsignatureByAccIdx(' + accIdx + ')" class="btn-link pull-right" title="添加" data-dismiss="modal"><i class="fa fa-plus"></i></a>' +
                prjAccount.name + '-<small class="text-muted">' + roleKey + '</small></li>');
            prj_sel_option_accounts[keyIdx].push('<option value="' + accIdx + '">' + prjAccount.name + '-' + roleKey + '</option>');
        }
        for (const prjAccList of prj_accounts) {
            prjAccList.push('</ul>');
        }
        for (const prjAccList of prj_sel_option_accounts) {
            prjAccList.push('</optgroup>');
        }
        for (let idx = 0; idx < prj_accounts.length; idx++) {
            prj_accounts[idx] = prj_accounts[idx].join('');
            prj_sel_option_accounts[idx] = prj_sel_option_accounts[idx].join('');
        }
        accDiv.append(prj_accounts.join(''));
        accSelect.append(prj_sel_option_accounts.join(''));
    },
    createEsignatureByAccIdx: function (accIdx) {
        rptSignatureHelper.createPreSelectedSignature(PRJ_ACCOUNT_LIST[accIdx], null);
    },
    createEsignatureByRoleIdx: function (roleIdx) {
        rptSignatureHelper.createPreSelectedSignature(null, ROLE_LIST[roleIdx]);
    },
    createPreSelectedSignature: function (directAcc, roleAcc) {
        let dftSignSrc = '/public/upload/sign/user-sign.PNG';
        let userAcc = directAcc;
        if (roleAcc) {
            userAcc = rptSignatureHelper.getUserAccount(roleAcc.bind_acc_id);
        }
        if (userAcc.sign_path !== '') {
            dftSignSrc = '/public/upload/sign/' + userAcc.sign_path;
        }
        if (rptSignatureHelper.currentSelectedESignAccName !== null) {
            for (const page of zTreeOprObj.currentRptPageRst.items) {
                if (page.signature_cells) {
                    for (const sCell of page.signature_cells) {
                        if (sCell.signature_name === rptSignatureHelper.currentSelectedESignAccName) {
                            sCell.pre_path = dftSignSrc;
                        }
                    }
                }
            }
            // 1. 删除不需要的child dom
            $(rptSignatureHelper.currentSelectedESignAccDom).empty();
            // 2. 创建已选择签名相关 dom
            rptSignatureHelper.cleanOldSignature(rptSignatureHelper.currentSelectedESignAccName);
            // 2.1 dom element
            const elementsStrArr = [];
            if (directAcc) {
                rptSignatureHelper.pushDomElementByUser(elementsStrArr, userAcc.name, userAcc.role);
                // 还有ROLE_REL_LIST
                let roleRelObj = {};
                roleRelObj.signature_name = rptSignatureHelper.currentSelectedESignAccName;
                roleRelObj.sign_path = dftSignSrc;
                roleRelObj.sign_date = '';
                roleRelObj.sign_date_format = 'yyyy年M月d日';
                roleRelObj.user_name = userAcc.name;
                roleRelObj.acc_id = userAcc.id;
                roleRelObj.type = '用户';
                roleRelObj.role = (userAcc.role === '')?DFT_ROLE_NAME:userAcc.role;
                ROLE_REL_LIST.push(roleRelObj);
            } else if (roleAcc) {
                // 创建相关dom元素
                rptSignatureHelper.pushDomElementByRole(elementsStrArr, roleAcc.name, userAcc.name);
                // 还有ROLE_REL_LIST
                let roleRelObj = {};
                roleRelObj.signature_name = rptSignatureHelper.currentSelectedESignAccName;
                roleRelObj.sign_path = dftSignSrc;
                roleRelObj.sign_date = '';
                roleRelObj.sign_date_format = 'yyyy年M月d日';
                roleRelObj.user_name = userAcc.name;
                roleRelObj.acc_id = userAcc.id;
                roleRelObj.type = '角色';
                roleRelObj.role = (userAcc.role === '')?DFT_ROLE_NAME:userAcc.role;
                roleRelObj.role_name = roleAcc.name;
                ROLE_REL_LIST.push(roleRelObj);
            }
            // elementsStrArr.push('');
            rptSignatureHelper.pushDatePickerDom(elementsStrArr);
            $(rptSignatureHelper.currentSelectedESignAccDom).append(elementsStrArr.join(' '));
            //.appendChild(pNode);
            //*/
            // 2.2 date-picker
        }
    },
    cleanOldSignature: function (signature_name) {
        // 清掉ROLE_REL_LIST原有的签名
        for (let idx = ROLE_REL_LIST.length - 1; idx >= 0 ; idx--) {
            if (ROLE_REL_LIST[idx].signature_name === signature_name) {
                ROLE_REL_LIST.splice(idx, 1);
            }
        }
    },
    resetESignature: function (pageRst) {
        let body = $('#eSignatureBodyDiv');
        body.empty();
        const signature_cells = [];
        const singatureNameArr = [];
        for (const page of pageRst.items) {
            if (page.signature_cells) {
                for (const sCell of page.signature_cells) {
                    if (singatureNameArr.indexOf(sCell.signature_name) < 0) {
                        signature_cells.push(sCell);
                        singatureNameArr.push(sCell.signature_name);
                    }
                }
            }
        }
        if (signature_cells.length > 0) {
            const elementsStrArr = [];
            const elementsDateStrArr = [];
            for (let scIdx = 0; scIdx < signature_cells.length; scIdx++) {
                const sCell = signature_cells[scIdx];
                elementsStrArr.push('<div class="form-group row">');
                elementsStrArr.push('<label for="staticEmail" class="col-sm-3 col-form-label pr-0">' + sCell.signature_name + '</label>');
                elementsStrArr.push('<div class="col-sm-9">');
                elementsStrArr.push('<ul class="list-group">');
                elementsStrArr.push('<li class="list-group-item">');
                if (sCell.path || sCell.pic) {
                    let hasPic = false;
                    for (let idx = 0; idx < ROLE_REL_LIST.length; idx++) {
                        const role_rel = ROLE_REL_LIST[idx];
                        if (role_rel.signature_name === sCell.signature_name) {
                            if (role_rel.type === '用户') {
                                rptSignatureHelper.pushDomElementByUser(elementsStrArr, role_rel.user_name, role_rel.role);
                            } else {
                                //角色
                                rptSignatureHelper.pushDomElementByRole(elementsStrArr, role_rel.role_name, role_rel.user_name);
                            }
                            const idSuffixStr = 'dtp_' + role_rel.signature_name;
                            /*
                            elementsStrArr.push('<div class="dropdown">');
                            if (role_rel.sign_date !== '') {
                                //elementsStrArr.push('<a href="" data-toggle="dropdown">' + (new Date(role_rel.sign_date)).Format('yyyy-M-d') + '</a>');
                                elementsStrArr.push('<a href="" data-toggle="dropdown"><i class="fa fa-calendar" title="添加签名日期"></i></a>');
                            } else {
                                elementsStrArr.push('<a href="" data-toggle="dropdown"><i class="fa fa-calendar" title="添加签名日期"></i></a>');
                            }
                            elementsStrArr.push('<form class="dropdown-menu p-2">');
                            elementsStrArr.push('<div class="form-group">');
                            elementsStrArr.push('<label for="exampleDropdownFormEmail2">签名日期</label>');
                            if (role_rel.sign_date !== '') {
                                //elementsStrArr.push('<input class="datepicker-here form-control form-control-sm mt-0" placeholder="选择签名日期" data-language="zh" type="text" value="' + (new Date(role_rel.sign_date)).Format('yyyy-M-d') + '">');
                                elementsStrArr.push('<input id="' + idSuffixStr + '" class="datepicker-here form-control form-control-sm mt-0" placeholder="选择签名日期" data-language="zh" type="text">');
                            } else {
                                elementsStrArr.push('<input id="' + idSuffixStr + '" class="datepicker-here form-control form-control-sm mt-0" placeholder="选择签名日期" data-language="zh" type="text">');
                            }
                            elementsStrArr.push('</div>');
                            if (role_rel.sign_date !== '') {
                                //elementsStrArr.push('<button type="submit" class="btn btn-sm btn-outline-danger">移除日期</button> <button type="submit" class="btn btn-sm btn-primary">确认</button>');
                                elementsStrArr.push('<button type="submit" class="btn btn-sm btn-primary">确认</button>');
                            } else {
                                elementsStrArr.push('<button type="submit" class="btn btn-sm btn-primary">确认</button>');
                            }
                            elementsStrArr.push('</form>');
                            elementsStrArr.push('</div>');
                            /*/
                            elementsStrArr.push('<div class="">');
                            if (role_rel.sign_date !== '') {
                                const dt = new Date(role_rel.sign_date);
                                const dtVal = dt.Format('yyyy-M-dd');
                                //elementsStrArr.push('<input class="datepicker-here form-control form-control-sm mt-0" placeholder="选择签名日期" data-language="zh" type="text" value="' + (new Date(role_rel.sign_date)).Format('yyyy-M-d') + '">');
                                elementsStrArr.push('<input id="' + idSuffixStr + '" class="datepicker-here form-control form-control-sm mt-0" placeholder="选择签名日期" data-language="zh" type="text" readonly="true" value="' + dtVal + '"');
                            } else {
                                elementsStrArr.push('<input id="' + idSuffixStr + '" class="datepicker-here form-control form-control-sm mt-0" placeholder="选择签名日期" data-language="zh" type="text" readonly="true"');
                            }
                            elementsStrArr.push('</div>');
                            //*/

                            hasPic = true;
                            break;
                        }
                        if (!hasPic) {
                            // 在交互操作中，有可能实际上是没有
                            // elementsStrArr.push('<a href="#add-sign" onclick="rptSignatureHelper.currentSelectedESignAccDom = this.parentNode; rptSignatureHelper.currentSelectedESignAccName = \'' + sCell.signature_name + '\'" data-toggle="modal" data-target="#add-sign"><i class="fa fa-plus"></i> 添加签名</a>');
                        }
                    }
                } else {
                    elementsStrArr.push('<a href="#add-sign" onclick="rptSignatureHelper.currentSelectedESignAccDom = this.parentNode; rptSignatureHelper.currentSelectedESignAccName = \'' + sCell.signature_name + '\'" data-toggle="modal" data-target="#add-sign"><i class="fa fa-plus"></i> 添加签名</a>');
                }
                elementsStrArr.push('</li>');
                elementsStrArr.push('</ul>');
                elementsStrArr.push('</div>');
                elementsStrArr.push('</div>');
                //还有签名日期(用不用得上不管，先放上去再说)
            }
            body.append(elementsStrArr.join(' '));
        }
    },
    pushDomElementByUser: function (elementsStrArr, userName, userRole) {
        elementsStrArr.push('<p class=" d-flex justify-content-between m-0"><span>' + userName +
            '-<small class="text-muted">' + ((userRole === '')?DFT_ROLE_NAME:userRole) +
            '</small></span><a onclick="rptSignatureHelper.removeSignature(this)" class="text-danger"><i class="fa fa-remove" title="移除签名"></i></a></p>');
        // rptSignatureHelper.pushDatePickerDom(elementsStrArr);
    },
    pushDomElementByRole: function (elementsStrArr, roleName, userName) {
        elementsStrArr.push('<p class=" d-flex justify-content-between m-0"><span><i class="fa fa-user" title="角色"> ' + roleName +
            '</i>-<small class="text-muted">' + userName +
            '</small></span><a onclick="rptSignatureHelper.removeSignature(this)" class="text-danger"><i class="fa fa-remove" title="移除签名"></i></a></p>');
        // rptSignatureHelper.pushDatePickerDom(elementsStrArr);
    },
    pushDatePickerDom: function (elementsStrArr) {
        let idSuffixStr = 'dtp_' + rptSignatureHelper.currentSelectedESignAccName;
        elementsStrArr.push('<div class="">');
        elementsStrArr.push('<input id="' + idSuffixStr + '" class="datepicker-here form-control form-control-sm mt-0" placeholder="选择签名日期" data-language="zh" type="text" readonly="true"');
        elementsStrArr.push('</div>');
    },
    removeSignature: function (dom) {
        let accTxtName = $(dom.parentNode.parentNode.parentNode.parentNode.parentNode).find('label')[0].innerText;
        let jDom = $(dom.parentNode.parentNode);
        jDom.empty();
        jDom.append('<a href="#add-sign" onclick="rptSignatureHelper.currentSelectedESignAccDom = this.parentNode; rptSignatureHelper.currentSelectedESignAccName = \'' +
            accTxtName + '\'" data-toggle="modal" data-target="#add-sign"><i class="fa fa-plus"></i> 添加签名</a>');
        // 要记得清空相关pre_path属性
        for (const page of zTreeOprObj.currentRptPageRst.items) {
            if (page.signature_cells) {
                for (const sCell of page.signature_cells) {
                    if (sCell.signature_name === accTxtName) {
                        sCell.pre_path = '';
                    }
                }
            }
        }
        // 还有ROLE_REL_LIST
        rptSignatureHelper.cleanOldSignature(accTxtName);
    },
    removeSelectSignature: function () {
        for (const page of zTreeOprObj.currentRptPageRst.items) {
            if (page.signature_cells) {
                for (const sCell of page.signature_cells) {
                    if (sCell.hasOwnProperty('pre_path')) {
                        delete sCell.pre_path;
                    }
                }
            }
        }
        // ROLE_REL_LIST = [];
        // ROLE_REL_LIST = ROLE_REL_LIST.concat(rptSignatureHelper.originalRoleRelList);
        ROLE_REL_LIST = JSON.parse(JSON.stringify(rptSignatureHelper.originalRoleRelList));
        zTreeOprObj.showPage(zTreeOprObj.currentPage, zTreeOprObj.canvas);
    },
    resetSignDate: function() {
        // for (let idx = 0; idx < ROLE_REL_LIST.length; idx++) {
        //     const role_rel = ROLE_REL_LIST[idx];
        //     const idSuffixStr = 'dtp_' + role_rel.signature_name;
        //     let dtDom = $('#' + idSuffixStr);
        //     if (dtDom.length === 1) {
        //         const dtStr = dtDom[0].value;
        //         if (dtStr && dtStr !== '' && dtStr.length >= 8 && dtStr.length <= 10) {
        //             // const tmpDt = new Date(dtStr);
        //             // const year = parseInt(tmpDt.getFullYear());
        //             // const month = parseInt(tmpDt.getMonth());
        //             // const dt = parseInt(tmpDt.getDate());
        //             // role_rel.sign_date = new Date(year, month, dt);
        //             role_rel.sign_date = new Date(dtStr);
        //         } else {
        //             role_rel.sign_date = '';
        //         }
        //         // 要处理相关签名Cell属性（默认跟普通cell一样，就多了个signature_name）
        //         for (const page of zTreeOprObj.currentRptPageRst.items) {
        //             if (page.signature_date_cells) {
        //                 for (const sCell of page.signature_date_cells) {
        //                     sCell.Value = _getSignDateDftName();
        //                     if (sCell.signature_name === role_rel.signature_name + '_签字日期') {
        //                         if (role_rel.sign_date !== '') {
        //                             sCell.Value = role_rel.sign_date.Format(role_rel.sign_date_format);
        //                         } else {
        //                         }
        //                     }
        //                 }
        //             }
        //         }
        //     }
        // }
        for (const page of zTreeOprObj.currentRptPageRst.items) {
            if (page.signature_date_cells) {
                for (const sCell of page.signature_date_cells) {
                    sCell.Value = _getSignDateDftName();
                    for (let idx = 0; idx < ROLE_REL_LIST.length; idx++) {
                        const role_rel = ROLE_REL_LIST[idx];
                        const idSuffixStr = 'dtp_' + role_rel.signature_name;
                        let dtDom = $('#' + idSuffixStr);
                        if (dtDom.length === 1) {
                            const dtStr = dtDom[0].value;
                            if (dtStr && dtStr !== '' && dtStr.length >= 8 && dtStr.length <= 10) {
                                // const tmpDt = new Date(dtStr);
                                // const year = parseInt(tmpDt.getFullYear());
                                // const month = parseInt(tmpDt.getMonth());
                                // const dt = parseInt(tmpDt.getDate());
                                // role_rel.sign_date = new Date(year, month, dt);
                                role_rel.sign_date = new Date(dtStr);
                            } else {
                                role_rel.sign_date = '';
                            }
                            // 要处理相关签名Cell属性（默认跟普通cell一样，就多了个signature_name）
                            if (sCell.signature_name === role_rel.signature_name + '_签字日期') {
                                if (role_rel.sign_date !== '') {
                                    sCell.Value = role_rel.sign_date.Format(role_rel.sign_date_format);
                                }
                            }
                        }
                    }
                }
            }
        }

    },
    setupAfterSelectSignature: function () {
        //0. 签名日期
        rptSignatureHelper.resetSignDate();
        //1. 重刷page
        for (const page of zTreeOprObj.currentRptPageRst.items) {
            if (page.signature_cells) {
                for (const sCell of page.signature_cells) {
                    if (sCell.hasOwnProperty('pre_path')) {
                        sCell.path = sCell.pre_path;
                        delete sCell.pre_path;
                    }
                }
            }
        }
        zTreeOprObj.showPage(zTreeOprObj.currentPage, zTreeOprObj.canvas);
        //2. 更新数据
        const params = {};
        params.id = CURRENT_ROLE_REL_ID;
        params.tender_id = TENDER_ID;
        params.rpt_id = zTreeOprObj.currentNode.refId;
        params.rel_content = ROLE_REL_LIST;
        // rptSignatureHelper.originalRoleRelList = [];
        // rptSignatureHelper.originalRoleRelList = rptSignatureHelper.originalRoleRelList.concat(ROLE_REL_LIST);
        rptSignatureHelper.originalRoleRelList = JSON.parse(JSON.stringify(ROLE_REL_LIST));
        CommonAjax.postXsrfEx("/tender/report_api/updateRoleRelationship", params, 10000, true, getCookie('csrfToken'),
            function(result){
                console.log(result);
                if (result.data && result.data.insertId > 0) {
                    CURRENT_ROLE_REL_ID = result.data.insertId;
                }
            }, function(err){
                // hintBox.unWaitBox();
            }, function(ex){
                // hintBox.unWaitBox();
            }
        );
    },
    switchAddRoleDiv: function (dom) {
        if (dom.nextElementSibling.children[0].style.display === 'none') {
            dom.nextElementSibling.children[0].style.display = '';
        } else {
            dom.nextElementSibling.children[0].style.display = 'none';
        }
    },
    createNewRole: function (dom) {
        if ($('#acc_role_name')[0].value !== '') {
            const params = {};
            params.name = $('#acc_role_name')[0].value;
            const selectedAcc = PRJ_ACCOUNT_LIST[$('#project_account_select_dom')[0].selectedOptions[0].value];
            const roleName = (selectedAcc.role === '')?DFT_ROLE_NAME:selectedAcc.role;
            params.bind_acc_id = selectedAcc.id;
            params.prj_id = PROJECT_ID;
            params.tender_id = TENDER_ID;
            CommonAjax.postXsrfEx("/tender/report_api/createSignatureRole", params, 10000, true, getCookie('csrfToken'),
                function(result){
                    console.log(result);
                    const newRole = {};
                    newRole.name = params.name;
                    newRole.bind_acc_id = selectedAcc.id;
                    newRole.prj_id = PROJECT_ID;
                    newRole.tender_id = TENDER_ID;
                    ROLE_LIST.push(newRole);
                    const domArr = [];
                    domArr.push('<li class="add-sign-list-item">');
                    //1. apply签名
                    domArr.push('<a href="javascript:void(0)" onclick="rptSignatureHelper.createEsignatureByRoleIdx(' + (ROLE_LIST.length - 1) +')" class="btn-link pull-right" title="添加" data-dismiss="modal">');
                    domArr.push('<i class="fa fa-plus"></i>');
                    domArr.push('</a>');
                    //2. 编辑角色(暂缓处理click事件)
                    domArr.push('<a href="javascript:void(0)" onclick="" class="btn-link pull-right mr-1" title="编辑">');
                    domArr.push('<i class="fa fa-pencil-square-o"></i>');
                    domArr.push('</a>');
                    //3. 显示名称
                    domArr.push('<i class="fa fa-user"></i> ' + $('#acc_role_name')[0].value + '<p>' + selectedAcc.name + '-<small class="text-muted">' + roleName + '</small></p>');
                    $('#existed_roles_ul').append(domArr.join(' '));
                }, function(err){
                    // hintBox.unWaitBox();
                }, function(ex){
                    // hintBox.unWaitBox();
                }
            );
        } else {
            alert('请输入合适的名称！');
        }
    },
    buildRoleDom: function (roleList) {
        const ulDom = $('#existed_roles_ul');
        ulDom.empty();
        for (let domIdx = 0; domIdx < roleList.length; domIdx++) {
            const role = roleList[domIdx];
            const domArr = [];
            domArr.push('<li class="add-sign-list-item">');
            //1. apply签名
            domArr.push('<a href="javascript:void(0)" onclick="rptSignatureHelper.createEsignatureByRoleIdx(' + domIdx + ')" class="btn-link pull-right" title="添加" data-dismiss="modal">');
            domArr.push('<i class="fa fa-plus"></i>');
            domArr.push('</a>');
            //2. 编辑角色(暂缓)
            domArr.push('<a href="javascript:void(0)" onclick="" class="btn-link pull-right mr-1" title="编辑">');
            domArr.push('<i class="fa fa-pencil-square-o"></i>');
            domArr.push('</a>');
            //3. 显示名称
            let acc = rptSignatureHelper.getUserAccount(role.bind_acc_id);
            domArr.push('<i class="fa fa-user"></i> ' + role.name + '<p>' + acc.name + '-<small class="text-muted">' + ((acc.role === '')?DFT_ROLE_NAME:acc.role) + '</small></p>');
            ulDom.append(domArr.join(' '));
        }
    },
    getUserAccount: function (accId) {
        let rst = null;
        for (const acc of PRJ_ACCOUNT_LIST) {
            if (acc.id === accId) {
                rst = acc;
                break;
            }
        }
        return rst;
    },
    mergeSignature: function (pageData) {
        for (const page of pageData.items) {
            if (page.signature_cells) {
                for (const sCell of page.signature_cells) {
                    for (const role_rel of ROLE_REL_LIST) {
                        if (role_rel.signature_name === sCell.signature_name) {
                            sCell.path = role_rel.sign_path;
                            sCell.pre_path = role_rel.sign_path;
                        }
                    }
                }
            }
        }
    },
    mergeSignDate: function (pageData) {
        if (ROLE_REL_LIST && ROLE_REL_LIST.length > 0 && STAGE_AUDIT && STAGE_AUDIT.length > 0) {
            for (let rridx = 0; rridx < ROLE_REL_LIST.length; rridx++) {
                const role_rel = ROLE_REL_LIST[rridx];
                if (role_rel.sign_date === undefined || role_rel.sign_date ===  null || role_rel.sign_date ===  '') {
                    for (const stg_audit of STAGE_AUDIT) {
                        if (role_rel.acc_id === stg_audit.aid) {
                            role_rel.sign_date = stg_audit.end_time;
                            rptSignatureHelper.originalRoleRelList[rridx].sign_date = stg_audit.end_time;
                            break;
                        }
                    }
                }
            }
        }
        for (const page of pageData.items) {
            if (page.signature_date_cells) {
                for (const sCell of page.signature_date_cells) {
                    sCell.Value = _getSignDateDftName();
                    for (const role_rel of ROLE_REL_LIST) {
                        if (sCell.signature_name === role_rel.signature_name + '_签字日期') {
                            if (role_rel.sign_date !== '') {
                                sCell.Value = role_rel.sign_date.Format(role_rel.sign_date_format);
                            }
                        }
                    }
                }
            }
        }
    }
}

function _getSignDateDftName() {
    return '    年  月  日';
}