ForecastUtility.gs

var ForecastUtility=new function(){


    /**
     * gets the historical columns number
	 * @param {Object} sheet the sheeet
     * @return {object} object with the columns number {first, last}
	 * @throws {InvalidArgument}
     * @throws {SheetNotFound} if the given sheet is not found
     */
    this.getHistoricalColNumBySheet=function(sheet){
        var commodity;
        
        if (!sheet) {
            throw "InvalidArgument";
        }
                

        commodity=FirebaseConnector.getCommodityName(sheet);
        
        return ForecastUtility.getHistoricalColNum(commodity);

    };

    /**
     * gets the historical columns number
	 * @param {string} commodityName the commodity name
     * @return {object} object with the columns number {first, last}
	 * @throws {InvalidArgument}
     * @throws {SheetNotFound} if the given sheet is not found
     */
    this.getHistoricalColNum=function(commodityName){
        var config, firstCol, lastCol, previousForecast;

        if (!commodityName) {
            throw "InvalidArgument";
        }

        config = AmisNamedRanges.getCommodityNamedRanges(commodityName);

        if (!config) {
            throw "SheetNotFound";
        }

        previousForecast=config.previousForecast;

        firstCol=ConvertA1.colA1ToIndex(previousForecast.first.split(":")[0],1);
        lastCol=ConvertA1.colA1ToIndex(previousForecast.last.split(":")[0],1);

        return {first:firstCol, last:lastCol};
    };


    /**
     * check if the activeRange is in the first column of a period
     * @param  {string} activeRangeA1 the active range in A1A1Notation
	 * @param {string} commodityName (optional) the commodity name
     * @return {bool}               true if edited, false otherwise
	 * @throws {InvalidArgument}
     */
    this.editedWrongForecast=function(activeRangeA1, commodity){
        var blockedRanges=[], isCell=false, isRange=false;

        if (!activeRangeA1) {
            throw "InvalidArgument";
        }

        commodity=(commodity || FirebaseConnector.getCommodityName());

        blockedRanges=[].concat(
            ForecastUtility.getFirstFcOfPeriod(0),
            ForecastUtility.getFirstFcOfPeriod(1)
        );

        isRange=Utility.isRange(activeRangeA1);
        isCell=Utility.isCell(activeRangeA1);

        for (var i = 0, blockedRanges_length=blockedRanges.length, r; r=blockedRanges[i], i<blockedRanges_length; i++) {
            if (isRange && Utility.isRangesOverlap(r, activeRangeA1)) {
                return true;
            }else if (isCell && Utility.isInRange(r, activeRangeA1)) {
                return true;
            }
        }

        return false;

    };



    /**
     * get the first forecast of a period
     * @param  {int} periodIndex period you want (EG.  0 for periodA , 1 periodB )
     * @param {string} commodityName (optional) the commodity name
     * @return {[string]}             array of ranges of the column
     */
    this.getFirstFcOfPeriod = function( periodIndex, commodity ) {
       if ( !periodIndex && periodIndex!==0 ) {
          throw "InvalidArgument";
       }

       var periodNR = Config.addNewForecastNamedRange[ periodIndex ];

       if ( !periodNR ) {
          throw "InvalidPeriod";
       }

       return AmisNamedRanges.getCommodityNamedRanges(commodity)[ periodNR[ 0 ] ];
    };
  /**
  * ADD A NEW FORECAST on the google sheet
  * @param  {int} the period you want (EG.  0 for periodA , 1 periodB )
  */
  this.addNewForecast= function(zeroOrOne){

    //get from config the named ranges
    var addNewForecastNamedRanges= Config.addNewForecastNamedRange[zeroOrOne];
    //range 'where to copy'
    var rangesTo =AmisNamedRanges.getCommodityNamedRanges()[addNewForecastNamedRanges[0]];
    //range that contains values to be copied
    var rangesFrom =AmisNamedRanges.getCommodityNamedRanges()[addNewForecastNamedRanges[1]];

    ForecastUtility.copyValuesBetweenForecasts(rangesFrom,rangesTo);
    ForecastUtility.blankForecast(rangesFrom);

  };

  /**
  * copy values of the last forecast
  * @param  {Range}
  */
  this.copyValuesBetweenForecasts= function(rangesFrom,rangesTo){

    var length = rangesTo.length;
    for (var i=0; i<length; i++){
      SpreadSheetCache.getActiveSheet().getRange(rangesTo[i]).setValues(
        SpreadSheetCache.getActiveSheet().getRange(rangesFrom[i]).getValues()
      );
    }
  };

  /**
  * blank a forecast
  * @param  {Range}
  */
  this.blankForecast= function(rangesToBeBlanked){

    var length = rangesToBeBlanked.length;
    for (var i=0; i<length; i++){
      SpreadSheetCache.getActiveSheet().getRange(rangesToBeBlanked[i]).setValue('');
    }
  };

  /**
   * get all the namedRanges for the Forecasting notes
   * @return {[string]} array of ranges in A1Notation
   */
  this.getForecastingNotesRanges = function() {
  	var ranges = [],
  		cnr;
  	cnr = AmisNamedRanges.getCommodityNamedRanges();
  	ranges = [].concat(
  		cnr[ Config.notesNamedRanges[ 0 ] ],
  		cnr[ Config.notesNamedRanges[ 1 ] ]
  	);
  	return ranges;
  };

  /**
   * check if a cell is in a ForecastMetodology of ForecastingNote range
   * @param  {string} cell  the cell to check in A1Notation for better performance
   * @return {bool}       true if the cell is in a ForecastMetodology of ForecastingNote range, false otherwise
   * @throws {InvalidArgument}
   */
  this.isFMorFN=function(cell){
      var ranges=[];

      if(!cell){
          throw "InvalidArgument";
      }

      ranges=ranges.concat(
          this.getForecastingNotesRanges(),
          ForecastingMethodologies.getFMRanges()
      );

      return Utility.isInAnyRange(ranges, cell);
  };


  /**
  * ADD A NEW FORECAST on the google sheet
  * @param  {string} the period you want
  */
  this.addForecastByPeriod= function(period){
    SpreadSheetCache.getActiveSheet().getRange('V10:V31').copyTo( SpreadSheetCache.getActiveSheet().getRange('U10:U31'), {contentsOnly:true});

  };
  // END --   ADD A NEW FORECAST on the google sheet

  /**
  * TODO_ delete... DEPRECATED! ADD A NEW FORECAST on the google sheet
  * @param  {string} auth token
  */
  this.addForecast16_17= function(userToken){
    var period = '16-17';
    ForecastUtility.addForecast(period,userToken);
  };
  // END --   ADD A NEW FORECAST on the google sheet

  /**
  * TODO_ delete... DEPRECATED! ADD A NEW FORECAST 17-18
  * @param  {string} auth token
  */
  this.addForecast17_18= function(userToken){
    var period = '17-18';
    ForecastUtility.addForecast(period,userToken);
  };
  // END --   ADD A NEW FORECAST on the google sheet

  /**
  * ADD A NEW FORECAST on the google sheet FOR SECRETARIET
  * @param  {string} auth token
  */
  this.addForecast16_17_Secretariet= function(userToken,chosenCountry){
    chosenCountry = getSecretariatCountry();
    var period = '16-17';
    ForecastUtility.addForecastSecretariet(period,userToken,chosenCountry);
  };
  // END --   ADD A NEW FORECAST on the google sheet FOR SECRETARIET

  /**
  * ADD A NEW FORECAST 17-18 FOR SECRETARIET
  * @param  {string} auth token
  */
  this.addForecast17_18_Secretariet= function(userToken, chosenCountry){
    chosenCountry = getSecretariatCountry();
    var period = '17-18';
    ForecastUtility.addForecastSecretariet(period,userToken,chosenCountry);
  };
  // END --   ADD A NEW FORECAST on the google sheet FOR SECRETARIET

  /**
   * hide period's unactive columns for ALL period
   * @param  {string} userToken firebase token
   */
  this.hideAllPeriodUnactiveColumns=function(userToken) {
      var allPeriodConf, allPeriodConfNode, commodity, countryName, period;

      countryName = FirebaseConnector.getCountryNameFromSheet(userToken);
      commodity = FirebaseConnector.getCommodityName();
      allPeriodConfNode = 'config/addForecast/' + countryName + '/' + commodity;
      allPeriodConf = JSON.parse(FirebaseConnector.getFireBaseData(allPeriodConfNode, userToken));

      for (var _i in allPeriodConf) {
        if (allPeriodConf[_i]) {
            period=allPeriodConf[_i];
            ForecastUtility.hidePeriodUnactiveColumns(period);
        }
      }
  };

  /**
   * hide period's unactive columns for ALL period FOR SECRETARIAT
   * @param  {string} userToken firebase token
   */
  this.hideAllPeriodUnactiveColumnsSecretariat=function(userToken) {
      var allPeriodConf, allPeriodConfNode, commodity, countryName, period;

      countryName = getSecretariatCountry();
      commodity = FirebaseConnector.getCommodityName();
      allPeriodConfNode = 'config/addForecast/' + countryName + '/' + commodity;
      allPeriodConf = JSON.parse(FirebaseConnector.getFireBaseData(allPeriodConfNode, userToken));

      for (var _i in allPeriodConf) {
        if (allPeriodConf[_i]) {
            period=allPeriodConf[_i];
            ForecastUtility.hidePeriodUnactiveColumns(period);
        }
      }
  };

  /**
   * hide period's unactive columns for ALL period FOR SECRETARIAT
   * @param  {string} userToken firebase token
   */
  this.hideAllPeriodUnactiveColumnsSecretariatWithChosenCommodityName=function(userToken,sheetChosenCommodityName) {
      var allPeriodConf, allPeriodConfNode, commodity, countryName, period;

      countryName = getSecretariatCountry();
      commodity = FirebaseConnector.getCommodityNameSecretariat(sheetChosenCommodityName);
      allPeriodConfNode = 'config/addForecast/' + countryName + '/' + commodity;
      allPeriodConf = JSON.parse(FirebaseConnector.getFireBaseData(allPeriodConfNode, userToken));

      for (var _i in allPeriodConf) {
        if (allPeriodConf[_i]) {
            period=allPeriodConf[_i];
            ForecastUtility.hidePeriodUnactiveColumnsWithChosenCommodityName(period,sheetChosenCommodityName);
        }
      }
  };

  /**
   * hide period's unactive columns
   * @param  {object} periodConf configuration of the period from the db
   */
  this.hidePeriodUnactiveColumns=function(periodConf){
      //last frc
      var lastForecastColumnPosition = periodConf.lastForecast;
      lastForecastColumnPosition = Utility.letterToColumn(lastForecastColumnPosition);

      //first frc
      var firstForecastColumnPosition = periodConf.firstForecast;
      firstForecastColumnPosition = Utility.letterToColumn(firstForecastColumnPosition);

      //actual frc
      var actualForecastColumnPosition = periodConf.actualPosition;
      actualForecastColumnPosition = Utility.letterToColumn(actualForecastColumnPosition);

      //hide correctly the new column
      ForecastUtility.hideColumnForNewForecasts(firstForecastColumnPosition,lastForecastColumnPosition, actualForecastColumnPosition);
  };


  /**
   * hide period's unactive columns FOR SECRETARIAT WITH SHEET
   * @param  {object} periodConf configuration of the period from the db
   * @param  {sheet} the sheet chosen
   */
  this.hidePeriodUnactiveColumnsWithChosenCommodityName=function(periodConf,sheetChosenCommodityName){
      //last frc
      var lastForecastColumnPosition = periodConf.lastForecast;
      lastForecastColumnPosition = Utility.letterToColumn(lastForecastColumnPosition);

      //first frc
      var firstForecastColumnPosition = periodConf.firstForecast;
      firstForecastColumnPosition = Utility.letterToColumn(firstForecastColumnPosition);

      //actual frc
      var actualForecastColumnPosition = periodConf.actualPosition;
      actualForecastColumnPosition = Utility.letterToColumn(actualForecastColumnPosition);

      //hide correctly the new column
      ForecastUtility.hideColumnForNewForecastsWithChosenCommodityName(firstForecastColumnPosition,lastForecastColumnPosition, actualForecastColumnPosition,sheetChosenCommodityName);
  };


  /**
	 * ADD A NEW FORECAST on the google sheet
     * @param  {string} auth token
	 */
  this.addForecast= function(period,userToken){

    var countryName =  FirebaseConnector.getCountryNameFromSheet(userToken);
    var sheet = SpreadsheetApp.getActiveSpreadsheet();
    var commodity = FirebaseConnector.getCommodityName();

    //read config from firebase
    var periodConfNode = 'config/addForecast/'+countryName+'/'+commodity +'/'+period;

    var periodConf = JSON.parse(FirebaseConnector.getFireBaseData(periodConfNode,userToken));

    //last frc
    var lastForecastColumnPosition = periodConf.lastForecast;
    lastForecastColumnPosition = Utility.letterToColumn(lastForecastColumnPosition);

    //first frc
    var firstForecastColumnPosition = periodConf.firstForecast;
    firstForecastColumnPosition = Utility.letterToColumn(firstForecastColumnPosition);

    //actual frc
    var actualForecastColumnPosition = periodConf.actualPosition;
    actualForecastColumnPosition = Utility.letterToColumn(actualForecastColumnPosition);

    //if we cannot add new FRC.. break the script
    if(actualForecastColumnPosition == lastForecastColumnPosition)
      return 0;

    //increase actual position
    actualForecastColumnPosition = actualForecastColumnPosition +1;

    var actualForecastColumnPositionNode = periodConfNode + '/actualPosition';

    //update the actualPositon in FIREBASE
    FirebaseConnector.writeOnFirebase(Utility.numToChar(actualForecastColumnPosition), actualForecastColumnPositionNode, userToken);

    //hide correctly the new column
    ForecastUtility.hideColumnForNewForecasts(firstForecastColumnPosition,lastForecastColumnPosition, actualForecastColumnPosition);

  };
  // END --   ADD A NEW FORECAST on the google sheet

  /**
	 * ADD A NEW FORECAST on the google sheet FOR SECRETARIET
     * @param  {string} auth token
	 */
  this.addForecastSecretariet = function(period,userToken,chosenCountry){

    var countryName =  chosenCountry;
    var sheet = SpreadsheetApp.getActiveSpreadsheet();
    var commodity = FirebaseConnector.getCommodityName();

    //read config from firebase
    var periodConfNode = 'config/addForecast/'+countryName+'/'+commodity +'/'+period;

    var periodConf = JSON.parse(FirebaseConnector.getFireBaseData(periodConfNode,userToken));

    //last frc
    var lastForecastColumnPosition = periodConf.lastForecast;
    lastForecastColumnPosition = Utility.letterToColumn(lastForecastColumnPosition);

    //first frc
    var firstForecastColumnPosition = periodConf.firstForecast;
    firstForecastColumnPosition = Utility.letterToColumn(firstForecastColumnPosition);

    //actual frc
    var actualForecastColumnPosition = periodConf.actualPosition;
    actualForecastColumnPosition = Utility.letterToColumn(actualForecastColumnPosition);

    //if we cannot add new FRC.. break the script
    if(actualForecastColumnPosition == lastForecastColumnPosition)
      return 0;

    //increase actual position
    actualForecastColumnPosition = actualForecastColumnPosition +1;

    var actualForecastColumnPositionNode = periodConfNode + '/actualPosition';

    //update the actualPositon in FIREBASE
    FirebaseConnector.writeOnFirebase(Utility.numToChar(actualForecastColumnPosition), actualForecastColumnPositionNode, userToken);

    //hide correctly the new column
    ForecastUtility.hideColumnForNewForecasts(firstForecastColumnPosition,lastForecastColumnPosition, actualForecastColumnPosition);

  };

  /**
	 * hide old forecast except the last 2
     * @param  {number} beginingPosition forecast position
     * @param  {number} lastPosition forecast position
     * @param  {number} numberOfColumnVisibleInTheRange of column you want to be shown
     * @param {object} sheet [optional] the sheet
  */
  this.hideOldForecasts = function( beginingPosition, lastPosition, numberOfColumnVisibleInTheRange, sheet ) {

  	sheet = sheet || SpreadSheetCache.getActiveSheet();

  	var columnToBeHidden = lastPosition - beginingPosition - numberOfColumnVisibleInTheRange;

  	if ( columnToBeHidden > -1 ) {
  		sheet.hideColumns( beginingPosition, columnToBeHidden + 1 );
  	}
  };


  /**
	 * hide old forecast except the last 2 FOR SECRETARIAT WithChosenCommodityName
     * @param  {number} beginingPosition forecast position
     * @param  {number} lastPosition forecast position
     * @param  {number} numberOfColumnVisibleInTheRange of column you want to be shown
  */
  this.hideOldForecastsWithChosenCommodityName= function (beginingPosition, lastPosition, numberOfColumnVisibleInTheRange, sheetChosenCommodityName){

    var sheet = sheetChosenCommodityName;

    var columnToBeHidden = lastPosition - beginingPosition - numberOfColumnVisibleInTheRange;

    if(columnToBeHidden >-1)
      sheet.hideColumns(beginingPosition, columnToBeHidden+1);
  };

  /**
	 * show old forecast
  */
  this.showOldForecasts= function (){
    var config, firstCol, lastCol;
    var sheet = SpreadSheetCache.getActiveSheet();
    //var userToken=FirebaseConnector.getToken();

    config = AmisNamedRanges.getCommodityNamedRanges().previousForecast;

    firstCol=ConvertA1.colA1ToIndex(config.first.split(":")[0],1);
    lastCol=ConvertA1.colA1ToIndex(config.last.split(":")[0],1);

    //ForecastUtility.hideAllPeriodUnactiveColumns(userToken);

    sheet.showColumns(firstCol, lastCol-firstCol);

  };


   /**
	 * show old forecast FOR SECRETARIAT
  */
  this.showOldForecastsSecretariat= function (){

    var config, firstCol, lastCol;
    var sheet = SpreadSheetCache.getActiveSheet();
    var userToken=FirebaseConnector.getToken();

    config = AmisNamedRanges.getCommodityNamedRanges().previousForecast;

    firstCol=ConvertA1.colA1ToIndex(config.first.split(":")[0],1);
    lastCol=ConvertA1.colA1ToIndex(config.last.split(":")[0],1);

    ForecastUtility.hideAllPeriodUnactiveColumnsSecretariat(userToken);

    sheet.showColumns(firstCol, lastCol-firstCol);

  };


  /**
	 * Solve CTRL+Z problems for 'add new forecast'
     * @param  {string} new forecast column index
     * @param  {string} last forecast position
     * @param  {string} user token
     * @return  {string} new Forecast Column Position after fixing CTRL problems
 	 * @deprecated not needed anymore
	 */
  this.preventUndoConflictForNewForecast = function (newForecastColumnPosition,lastForeCastNode, userToken, orderInTheSheet,firstForecastColumnPosition,beginForeCastNode){

    var countryName =  FirebaseConnector.getCountryNameFromSheet(userToken);

    //datanode from firebase
    var labelRowNumber = 'config/addForecast/labelRowNumber';
    //retrive the row containing 'Forecasting  Methodology'. IT MUST BE next the last forecast.
    var forecastingMethodologyRange = FirebaseConnector.getFireBaseData(labelRowNumber,userToken);

    //orderInTheSheet choose what result must be consider
    var forecastingMethodologyColumn = Utility.findValueIntoRowMultipeResult('Forecasting  Methodology', JSON.parse(forecastingMethodologyRange))[orderInTheSheet];

    //IF THERE ARE CRTL+Z PROBLEMS (the firebase index for newForecastProblem is bigger then forecasting meth column)
    if(newForecastColumnPosition >= forecastingMethodologyColumn){

      //in this case we have also to update firstForecast position
        if(orderInTheSheet!=0){
          FirebaseConnector.writeOnFirebase(Utility.numToChar(forecastingMethodologyColumn-1), lastForeCastNode, userToken);
          FirebaseConnector.writeOnFirebase(Utility.numToChar(firstForecastColumnPosition-1), beginForeCastNode, userToken);
        }else{
          //change the value of lastForecast config on database
          FirebaseConnector.writeOnFirebase(Utility.numToChar(forecastingMethodologyColumn-1), lastForeCastNode, userToken);
        }


      //get the A1 notation for the column
      var columnLetter = Utility.numToChar(forecastingMethodologyColumn-1);

      //move forecastMetodology column position on firebase (range as input)
      ForecastingMethodologies.moveFMCols(columnLetter+':'+columnLetter,-1);

      //refetch from firebase the configuration for forecastmetodologies
      ForecastingMethodologies.getConfig(true);

      return forecastingMethodologyColumn-1;

    }else{

      return newForecastColumnPosition;

    }
  };

/**
 * function called to hide all the forecast for previus year except the last one
 * @param {object} sheet [optional] the sheet
 * @return {void}
 */
 this.hideAllPreviousForecasts = function( sheet ) {
 	sheet = sheet || SpreadSheetCache.getActiveSheet();
 	var config = AmisNamedRanges.getCommodityNamedRanges().previousForecast;

 	ForecastUtility.hideOldForecasts( sheet.getRange( config.first ).getColumn(), sheet.getRange( config.last ).getColumn(), 1, sheet );

 };



  /**
	 * function called to hide all the forecast for previus year except the last one FOR SECRETARIAT
	 */
  this.hideAllPreviousForecastsSecretariat = function (userToken, isNeedingCommodityName, sheetChosenCommodityName){
    var sheet;
    var config=AmisNamedRanges.getCommodityNamedRanges().previousForecast;

    if(isNeedingCommodityName){
      sheet = sheetChosenCommodityName;
    }else{
      //get the google sheet
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      sheet = ss.getActiveSheet();
    }



    if(isNeedingCommodityName){
      //with charToNum(letterOfTheColumn) I get the column number
      ForecastUtility.hideOldForecastsWithChosenCommodityName(sheet.getRange(config.first).getColumn(),sheet.getRange(config.last).getColumn(),1,sheet);
    }else{
      //with charToNum(letterOfTheColumn) I get the column number
      ForecastUtility.hideOldForecasts(sheet.getRange(config.first).getColumn(),sheet.getRange(config.last).getColumn(),1);
    }

  };
  // END -- function called to hide all the forecast for previus year except the last one FOR SECRETARIAT

  this.hideColumnForNewForecasts= function (firstForecastColumnPosition,lastForecastColumnPosition, actualForecastColumnPosition){
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

    //in this case just simple hide every thing after the actual position
    if(actualForecastColumnPosition - firstForecastColumnPosition <2 ) {
      ForecastUtility.hideOldForecasts(actualForecastColumnPosition+1, lastForecastColumnPosition,0 );

    }else {

      var letterClm = Utility.numToChar(actualForecastColumnPosition);
      letterClm = letterClm+':'+letterClm;
      //unhide the new actualPosition column. the function TAKES RANGE as paramaeter!
      sheet.unhideColumn(sheet.getRange(letterClm));

      //hide the previus frc
      ForecastUtility.hideOldForecasts(firstForecastColumnPosition, actualForecastColumnPosition,2 );
      //hide the still to much new forecast
      ForecastUtility.hideOldForecasts(actualForecastColumnPosition+1, lastForecastColumnPosition,0 );
    }
  };


  this.hideColumnForNewForecastsWithChosenCommodityName= function (firstForecastColumnPosition,lastForecastColumnPosition, actualForecastColumnPosition,sheetChosenCommodityName){
    var sheet = sheetChosenCommodityName;

    //in this case just simple hide every thing after the actual position
    if(actualForecastColumnPosition - firstForecastColumnPosition <2 ) {
      ForecastUtility.hideOldForecastsWithChosenCommodityName(actualForecastColumnPosition+1, lastForecastColumnPosition,0, sheet );

    }else {

      var letterClm = Utility.numToChar(actualForecastColumnPosition);
      letterClm = letterClm+':'+letterClm;
      //unhide the new actualPosition column. the function TAKES RANGE as paramaeter!
      sheet.unhideColumn(sheet.getRange(letterClm));

      //hide the previus frc
      ForecastUtility.hideOldForecastsWithChosenCommodityName(firstForecastColumnPosition, actualForecastColumnPosition,2,sheet );
      //hide the still to much new forecast
      ForecastUtility.hideOldForecastsWithChosenCommodityName(actualForecastColumnPosition+1, lastForecastColumnPosition,0,sheet );
    }
  };

  /**
   * hide all the forecast for previus year except the last one and all unactive columns of all periods
   */
  this.hideOldAndUnactiveForecast = function() {
    //ForecastUtility.hideAllPeriodUnactiveColumns(userToken)

    ForecastUtility.hideAllPreviousForecasts();
  };

  /**
   * hide all the forecast for previus year except the last one and all unactive columns of all periods FOR SECRETARIAT
   * @param {string} userToken firebase token FOR SECRETARIAT
   */
  this.hideOldAndUnactiveForecastSecretariat = function(userToken) {
    ForecastUtility.hideAllPeriodUnactiveColumnsSecretariat(userToken)

    ForecastUtility.hideAllPreviousForecastsSecretariat(userToken);
  };


};