ouwise-progressive-report.js

import sqlQueryBuilder from './sql-query-builder';
import api from 'dhis2api';
import excelBuilder from './excel-builder.js';

function ouWiseProgressiveReport(params,callback){

    const SQLVIEWPREFIX = "XL_REPORT_";
    var sourceIDQuery = __getSourceIDQuery(params);
    var sqlViewService = new api.sqlViewService();

    sqlViewService.dip(SQLVIEWPREFIX,sourceIDQuery, doMainQuery);
    
    function doMainQuery(error,response,body){
        if (error){
            console.log("Source Query Error : "+error)
            callback();
            return
        }
        
        if (body.rows[0] == ""){
            alert("No facility found for the parameters selected")
            callback();
            return;
        }
        
        var ouGroupWiseSourceIDs = JSON.parse(body.rows[0]);
        var mainQ = __getMainQuery(params,ouGroupWiseSourceIDs);

        sqlViewService.dip(SQLVIEWPREFIX,mainQ, function(error,response,body){
            if (error){

            }

            new excelBuilder(params.mapping,
                             body,
                             params.excelTemplate,
                             params.reportName,
                             params.selectedOUName,
                             params.startdateText,
                             params.enddateText,
                             callback)
        });

    }

}


function __getMainQuery(params,ouGroupWiseSourceIDs){
    
    ouGroupWiseSourceIDs = ouGroupWiseSourceIDs.reduce((map,obj)=>{
        map[obj.ougroup] = obj.sourceids;
        return map;
    },[])

    var qb = new (new sqlQueryBuilder()).
        ouWise.
        main(
            params.selectedOUUID,
            params.selectedOUName,
            params.selectedOULevel,
            params.selectedOUGroupUID,
            params.startdate,
            params.enddate,
            params.ptype,
            params.attributeOptionComboId,
            params.ouGroupWiseDecocStringMap,
            params.ouGroupUIDKeys,
            params.ouGroupWiseDeListCommaSeparated,
            ouGroupWiseSourceIDs,
            params.aggregationType
        );
    

    switch(params.selectedOUGroupUID){
        
    case "-1" : // no group
        if (params.aggregationType == "use_captured"){
            return qb.makeMainQuery(); 
        }
        else if (params.aggregationType == "agg_descendants" ||
                 params.aggregationType == "raw_report"){
            return qb.makeMainQuery();
        }
        break
        
    default : // group case
        if (params.aggregationType == "use_captured"){
            return qb.makeGroupMainQuery(); 
        }
        else if (params.aggregationType == "agg_descendants" ||
                 params.aggregationType == "raw_report"){
            return qb.makeGroupMainQuery(); 
        }
    }

    
}

function __getSourceIDQuery(params){
    var qb = new (new sqlQueryBuilder()).
        ouWise.
        sourceid(params.selectedOUUID,
                 params.ouGroupUIDKeys,
                 params.selectedOUGroupUID
                );
    

    switch(params.selectedOUGroupUID){
        
    case "-1" : // no group
        if (params.aggregationType == "use_captured" ||
            params.aggregationType == "raw_report"){
            return qb.
                makeUseCapturedQuery(); 
        }
        else if (params.aggregationType == "agg_descendants"){
            return qb.
                makeGenAggregatedQuery(); 
        }
        break
        
    default : // group case
        if (params.aggregationType == "use_captured" ||
            params.aggregationType == "raw_report"){
            return qb.
                makeOuGroupUseCapturedQuery()
        }
        else if (params.aggregationType == "agg_descendants"){
            return qb.
                makeOuGroupGenAgrgegatedQuery()
        }
    }


}

module.exports = ouWiseProgressiveReport;