ConstructionCost/modules/reports/rpt_component/Jpc_Data.js

let JV = require('./jpc_value_define');
let JpcData = {
    createNew: function() {
        let JpcDataRst = {};
        JpcDataRst.dataSeq = [];
        JpcDataRst.analyzeData = function(rptTpl, dataObj) {
            let me = this;
            if ((rptTpl) && (dataObj)) {
                //1. get ID fields
                let masterIDs = [];
                for (let i = 0; i < rptTpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS].length; i++) {
                    let mstFieldObj = rptTpl[JV.NODE_FIELD_MAP][JV.NODE_MASTER_FIELDS][i];
                    if ((mstFieldObj[JV.PROP_IS_ID]) && (mstFieldObj[JV.PROP_IS_ID] === 'T')) {
                        masterIDs.push({"idx": i, "seq": mstFieldObj[JV.PROP_ID_SEQ]});
                    }
                }
                let detailIDs = [];
                for (let i = 0; i < rptTpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS].length; i++) {
                    let dtlFieldObj = rptTpl[JV.NODE_FIELD_MAP][JV.NODE_DETAIL_FIELDS][i];
                    if ((dtlFieldObj[JV.PROP_IS_ID]) && (dtlFieldObj[JV.PROP_IS_ID] === 'T')) {
                        detailIDs.push({"idx": i, "seq": dtlFieldObj[JV.PROP_ID_SEQ]});
                    }
                }
                //2. sort the ID fields
                if (masterIDs.length > 1) {
                    masterIDs.sort(function(a, b) {
                        return 1*a["seq"] - 1*b["seq"];
                    })
                }
                if (detailIDs.length > 1) {
                    detailIDs.sort(function(a, b) {
                        return 1*a["seq"] - 1*b["seq"];
                    })
                }
                //3. prepare data sequence
                if (masterIDs.length > 0) {
                    let mst_dt_len = 0, dtl_dt_len = 0, mst_fields = [];
                    for (let i = 0; i < masterIDs.length; i++) {
                        mst_fields.push(dataObj[JV.DATA_MASTER_DATA][masterIDs[i]["idx"]]);
                        mst_dt_len = dataObj[JV.DATA_MASTER_DATA][masterIDs[i]["idx"]].length;
                    }
                    let dtl_fields = [];
                    for (let i = 0; i < detailIDs.length; i++) {
                        dtl_fields.push(dataObj[JV.DATA_DETAIL_DATA][detailIDs[i]["idx"]]);
                        dtl_dt_len = dataObj[JV.DATA_DETAIL_DATA][detailIDs[i]["idx"]].length;
                    }
                    let sIdx = 0;
                    let isEqual = true;
                    for (let i = 0; i < mst_dt_len; i++) {
                        me.dataSeq.push([]);
                        //then compare the master/detail ID-field value
                        for (let j = sIdx; j < dtl_dt_len; j++) {
                            isEqual = true;
                            for (let k = 0; k < mst_fields.length; k++) {
                                if (!(mst_fields[k][i] === dtl_fields[k][j])) {
                                    isEqual = false;
                                    break;
                                }
                            }
                            if (isEqual) {
                                me.dataSeq[i].push(j);
                            } else {
                                sIdx = j;
                                //below logic is for the data robustness purpose, to avoid those strange record(detail level) which could not match even one of the master record!
                                if (i < mst_dt_len - 1 && j < dtl_dt_len - 1) {
                                    for (let j1 = j; j1 < dtl_dt_len; j1++) {
                                        isEqual = true;
                                        for (let k = 0; k < mst_fields.length; k++) {
                                            if (!(mst_fields[k][i + 1] === dtl_fields[k][j1])) {
                                                isEqual = false;
                                                break;
                                            }
                                        }
                                        if (isEqual) {
                                            sIdx = j1;
                                            break;
                                        }
                                    }
                                }
                                break;
                            }
                        }
                    }
                } else { //if no master data
                    let field = dataObj[JV.DATA_DETAIL_DATA][0];
                    me.dataSeq = [[]];
                    for (let i = 0; i < field.length; i++) {
                        me.dataSeq[0].push(i);
                    }
                }
            }
            //alert(3);
        };
        return JpcDataRst;
    }
}

module.exports = JpcData;