// Usecase 1: alert will be triggered if voltage is higher than 118V
// Check if the voltage value exceeds 118 and trigger the appropriate action.
if (events["Me_DataChange_useCase1_Voltage"].eventData.newValue.value > 118){
    logger.warn("Use-Case 1 subscription has been triggered");
}

// Usecase 2: alert will be triggered if voltage is higher than 118V and current is lower than 2A

//********************** Default initialization ****************************************
if (thisSub.JSONState.Voltage === undefined)
    thisSub.JSONState.Voltage = me.useCase2_Voltage; // default value from VTQ
if (thisSub.JSONState.Current === undefined)
    thisSub.JSONState.Current = 0; // default value 0
//*************************************************************************************
//************************* storing the values in JSONState from eventData ***************
var aliasArray = Object.keys(events.dataShape.fields);
for (var i=0; i < aliasArray.length; i ++ ){
  	if (aliasArray[i] === "Me_DataChange_useCase2_Current")
    // Assign the new current value to the state
    	thisSub.JSONState.Current = events["Me_DataChange_useCase2_Current"].eventData.newValue.value;
	if (aliasArray[i] === "Me_DataChange_useCase2_Voltage") {
    // Assign the new voltage value to the state
    	thisSub.JSONState.Voltage = events["Me_DataChange_useCase2_Voltage"].eventData.newValue.value;
	}
}
//******************************************************************************************
  // Check if both voltage and current meet the conditions - voltage is higher than 118V and current is lower than 2A
if (thisSub.JSONState.Voltage > 118 &&
    thisSub.JSONState.Current < 2) {
    logger.warn("Use-Case 2 alert !!!, Voltage is: "+thisSub.JSONState.Voltage+" and Current is: "+thisSub.JSONState.Current);
  }
else
    logger.warn("Use-Case 2 NO alert, Voltage is: "+thisSub.JSONState.Voltage+" and Current is: "+thisSub.JSONState.Current);

// Usecase 3: alert will be triggered if voltage is higher than 118V and it has last more than 3 minutes.
// Timer will tick every X seconds 

/*
When the DataChange event causing the subscription to run,
The value of Voltage will be checked:
1. If it would be above 118, timer would start running in case its undefined.
2. If it would be below or equal to 118, timer would back to undefined.
In case time has gotten to 3 minutes (180000MS), subscription would be triggered.
*/
// Getting the name of the event that triggered the subscription
let aliasArray = Object.keys(events.dataShape.fields);
if (aliasArray[0] === "Me_DataChange_useCase3_Voltage") {
    // Valtage was changed
    // We want to manage thisSub.JSONState.StartTime only. We don't save the Valtage in state
    
   var Voltage = events[aliasArray[0]].eventData.newValue.value;
    
  if( thisSub.JSONState.StartTime === undefined ) {  
      if( Voltage > 118 ){
          thisSub.JSONState.StartTime = Date.now();
          logger.warn("Voltage = " + Voltage + " Start time was set");
      }
  }	else{
      if( Voltage <= 118 ){
          delete thisSub.JSONState.StartTime; // this will set to undefine
          logger.warn("Voltage = " + Voltage + " Start time was unset");
      }
  }
}
else{
    // We are in timer event
    if( thisSub.JSONState.StartTime !== undefined && Date.now() - thisSub.JSONState.StartTime > 40000 )
        logger.warn("Use-Case 3 timer was triggered - Alert !!! thisSub.JSONState.StartTime = " + thisSub.JSONState.StartTime);
    else
        logger.warn("Use-Case 3 timer was triggered - no Alert. thisSub.JSONState.StartTime = " + thisSub.JSONState.StartTime);
}
    

// Usecase 4: Input 32 bit integer will be translated into 32 status properties if there is any change,
// and alert on status property potentially will be triggered.

logger.warn("Use-Case 4 subscription has been triggered");

// Usecase 5: Alert will be triggered only on Error code which has severity level 1 or 2,
// where Error severity is defined in a relational table
// Get reference to the data table
var dataTable = Things["useCase5_DataTable"];
// Get the new value of ErrorCode from the event
var ErrorCodeValue = events["Me_DataChange_useCase5_ErrorCode"].eventData.newValue.value;
// Set parameters for querying the data table
var params = {
  maxItems: 100, // Maximum number of entries to retrieve
  source: undefined, // Filter entries by a specific source if needed
  values: undefined, // Filter entries by specific column values if needed
  orderBy: undefined // Order the retrieved entries by a specific column if needed
};
// Query the data table entries
var queryResult = dataTable.QueryDataTableEntries(params);
var rows = queryResult.rows;
// Iterate through the rows and check for matching ErrorCode and severity level
for (var i = 0; i < rows.length; i++) {
  var thisRow = rows[i];
  
  // Check if the ErrorCode matches the given ErrorCodeValue
  if (thisRow.ErrorCode == ErrorCodeValue) {
    // Check if the Severity is either 1 or 2
    if (thisRow.Severity == 1 || thisRow.Severity == 2) {
      // Log a warning message indicating the matched ErrorCode and its Severity
      logger.warn("Error code: " + thisRow.ErrorCode + " has a severity of: " + thisRow.Severity + ". Use-Case 5 subscription has been triggered.");
    }
  }
}

// Usecase 6: Alert will be trigged if sum of product count is less than 10 in past 10 minutes
// Timer will tick every 1 seconds (1000MS)

// Getting the name of the event that triggered the subscription
var alias = events.dataShape.fields;
// Check if the alias matches "Me_DataChange_useCase6_ProductCount"
if (alias == "Me_DataChange_useCase6_ProductCount") {
  // Check if the productCountDict exists in the state
  if (thisSub.JSONState.productCountDict != undefined) {
    // Delete entries older than 10 minutes
    deleteOlderThan10Minutes();
    // Add a new entry with the current timestamp and the new value from the event
    thisSub.JSONState.productCountDict[Date.now().toString()] = events[alias].eventData.newValue.value;
  } else {
    // Initialize the productCountDict as an empty object and add a new entry
    thisSub.JSONState.productCountDict = {};
    thisSub.JSONState.productCountDict[Date.now().toString()] = events[alias].eventData.newValue.value;
  }
} else {
  // Check if the startTime is undefined and set it to the current time
  if (thisSub.JSONState.startTime == undefined) {
    thisSub.JSONState.startTime = Date.now();
  }
  // Check if the productCountDict exists in the state
  if (thisSub.JSONState.productCountDict != undefined) {
    // Delete entries older than 10 minutes
    deleteOlderThan10Minutes();
    // Check if an alert should be triggered and log a warning message
    if (shouldTriggerAlert()) {
      logger.warn("Use-Case 6 subscription has been triggered");
    }
  }
}
// Function to delete entries older than 10 minutes from productCountDict
function deleteOlderThan10Minutes() {
  var keys = Object.keys(thisSub.JSONState.productCountDict);
  for (var i = 0; i < keys.length; i++) {
    var key = keys[i];
    // Check if the time difference is greater than 10 minutes (600,000 milliseconds)
    if (Date.now() - parseInt(key) > 600000) {
      delete thisSub.JSONState.productCountDict[key];
    }
  }
}
// Function to check if an alert should be triggered
function shouldTriggerAlert() {
  // Check if the sum of product count is less than 10 and if the time difference is greater than 10 minutes
  if (productCountDictSUM() < 10 && Date.now() - thisSub.JSONState.startTime > 600000) {
    return true;
  } else {
    return false;
  }
}
// Function to calculate the sum of values in productCountDict
function productCountDictSUM() {
  var keys = Object.keys(thisSub.JSONState.productCountDict);
  var sum = 0;
  for (var i = 0; i < keys.length; i++) {
    var key = keys[i];
    var value = thisSub.JSONState.productCountDict[key];
    sum += value;
  }
  return sum;
}

// Usecase 7: alert will be triggered if average current (5 minutes window) is higher than 2.5A,
// and it will be checked very 30 seconds.
// Timer will tick every 30 seconds (30000MS)
// Getting the name of the event that triggered the subscription
var alias = events.dataShape.fields;
// Checking if the data alias matches the expected value
if (alias == "Me_DataChange_useCase7_Current") {
  // If the data dictionary exists, update it with the new current value
  if (thisSub.JSONState.currentDict != undefined) {
    deleteOlderThan5Minutes();
    thisSub.JSONState.currentDict[Date.now().toString()] = events[alias].eventData.newValue.value;
  } else {
    // If the data dictionary doesn't exist, create it and set the start time
    thisSub.JSONState.currentDict = {};
    thisSub.JSONState.currentDict[Date.now().toString()] = events[alias].eventData.newValue.value;
  }
} else {
    if(thisSub.JSONState.startTime == undefined){
        thisSub.JSONState.startTime = Date.now();
    }
  // If the data alias doesn't match, perform data management and potential alert triggering
    if (thisSub.JSONState.currentDict != undefined) {
    // Delete entries in the data dictionary older than 5 minutes
    deleteOlderThan5Minutes();
    // Check if conditions for triggering the alert are met
    if (shouldTriggerAlert()) {
      logger.warn("Use-Case 7 subscription has been triggered");
    }
  }
}
// Function to delete data entries older than 5 minutes
function deleteOlderThan5Minutes() {
  var keys = Object.keys(thisSub.JSONState.currentDict);
  for (var i = 0; i < keys.length; i++) {
    var key = keys[i];
    if (Date.now() - parseInt(key) > 300000) {
      delete thisSub.JSONState.currentDict[key];
    }
  }
}
// Function to determine if the alert should be triggered
// Only in case 5 minutes has been passed, and AVG is higher then 2.5
function shouldTriggerAlert() {
  if (currentDictAVG() > 2.5 && Date.now() - thisSub.JSONState.startTime > 300000) {
    return true;
  } else {
    return false;
  }
}
// Function to calculate the average of currentDict
function currentDictAVG() {
  var keys = Object.keys(thisSub.JSONState.currentDict);
  var sum = 0;
  var count = 0;
  for (var i = 0; i < keys.length; i++) {
    var key = keys[i];
    var value = thisSub.JSONState.currentDict[key];
    sum += value;
    count++;
  }
  var average = sum / count;
  return average;
}
////at any data change i sum the current
////when 30 seconds has been passed i calculate AVG
//
//
//
////change property event:
////	check if there is any value older then 5, if so - delete. (can implement by get keys)
////	add the value to the dict with key of timestamp
////timer event:
////	check if there is any value older then 5, if so - delete. (can implement by get keys)
////	AVG calculation, and condition check. - not only per 30 seconds, but for all the data at 5 minutes
//
//// build function to: change if there is any value older then 5, if so - delete. (can implement by get keys)
//
// ** the first timer event will be the startTime point of the algorithm

// Usecase 8: the alert will be triggered when most recent value is greater than the previous 10 values
// Check if valuesArray state is undefined and initialize it
if (thisSub.JSONState.valuesArray === undefined) {
  thisSub.JSONState.valuesArray = {};
}
// Check if valuesArray length is less than 10
let indexCounter = Object.keys(thisSub.JSONState.valuesArray).length;
if ( indexCounter < 3) {
  // Add the new value to valuesArray
  thisSub.JSONState.valuesArray["i" + indexCounter] = events["Me_DataChange_useCase8_prop"].eventData.newValue.value;
} else {
  // The valuesArray is full
    
  var max = 0;
  // Find the maximum value in valuesArray
  for (let i = 0; i < Object.keys(thisSub.JSONState.valuesArray).length; i++) {
    if (thisSub.JSONState.valuesArray["i" + i] > max)
      max = thisSub.JSONState.valuesArray["i" + i];
  }
    
  // Check if the new value is greater than the maximum value
  if (events["Me_DataChange_useCase8_prop"].eventData.newValue.value > max)
    logger.warn("Use-Case 8 Alert!!! max is " + events["Me_DataChange_useCase8_prop"].eventData.newValue.value);
  // Shift the values in valuesArray by one position
  for (var j = 0; j < parseInt((Object.keys(thisSub.JSONState.valuesArray)).length) - 1; j++) {
    thisSub.JSONState.valuesArray["i" + j] = thisSub.JSONState.valuesArray["i" + (j + 1)];
  }
  // Add the new value to valuesArray using the current indexCounter
  thisSub.JSONState.valuesArray["i" + (indexCounter - 1)] = events["Me_DataChange_useCase8_prop"].eventData.newValue.value;
}
logger.warn("Use-Case 8 End. valuesArray = " +  thisSub.JSONState.valuesArray);