var frontMax = null;
var frontAvg = null;
var backMax = null;
var backAvg = null;
var car_id = null;
var frontAlarmLevel = null;
var backAlarmLevel = null;
var image_time = null;
var location = null;
var Subject = null;
var sendEmail = 0;

var params = {
    oldDate: curDate /* DATETIME */,
    ImageID: ImageID /* STRING */
};

me.GenerateImages(params);


var params2 = {
	ImageID: ImageID /* STRING */
};

// result: INFOTABLE
var tempCalcs = Things["SQLServer"].getTempCalcs(params2);
try{
var tableLength = tempCalcs.rows.length;
if(tableLength > 0){
    var row = tempCalcs.getRow(0);
frontMax = row.front_max_temp.toFixed(2);
frontAvg = row.front_avg_temp.toFixed(2);
backMax = row.back_max_temp.toFixed(2);
backAvg = row.back_avg_temp.toFixed(2);
car_id = row.car_id;
frontAlarmLevel = row.back_level;
backAlarmLevel = row.front_level;   
    image_time = new Date(row.image_time);
    location = row.location;
    
    
}

if((backAlarmLevel >0) || (frontAlarmLevel >0 )){
    
Subject = "Bottle " + car_id + "Alarm Triggered";       
    sendEmail = 1;
}

  if(sendEmail == 1){
var params3 = {
	ImageID: ImageID /* STRING */,
	BackMax: backMax /* NUMBER */,
	BottleNum: car_id /* STRING */,
	FrontMax: frontMax /* NUMBER */,
	BackAvg: backAvg /* NUMBER */,
	FrontAvg: frontAvg /* NUMBER */,
    Subject: Subject,
    FrontAlarm: frontAlarmLevel,
    BackAlarm: backAlarmLevel,
    Location: location,
    ImageTime: image_time
};

// no return
me.sendAlertEmail(params3);

}
}
catch(err){
}
result = sendEmail