import java.util.List;
import java.util.LinkedList;
import java.util.Date;
import java.lang.Long;
import java.text.SimpleDateFormat;
import java.util.*; 
import java.text.*;  
import groovy.json.JsonSlurper
 
dest = [:];

// Safely evaluates a Gpath expression. If the expression cannot be evaluated it returns null
Object evalGpathOrNull(String gPathExpression) {
	try {
		return Eval.me("payload", payload, gPathExpression);
	} catch (Exception e) {
		println ('error: evalGpathOrNull:' + gPathExpression + ' - ' + e.getMessage());
		return null;
	}
}

// Safely evaluates a Gpath expression.
// If the first expression is null or throws an error, it evaluates the second one 
// If neither expression can be evaluated it returns null
Object evalGpathsOrNull(String gPathExpression, String gPathAlternative) {
	Object result = "";

	try {
		result = Eval.me("payload", payload, gPathExpression);
	} catch (Exception e) {
		result = null;
	}

	if (result != null) return result;
	
	try {
		result = Eval.me("payload", payload, gPathAlternative);
	} catch (Exception e) {
		result = null;
	}
	return result;
}

String evalNumberToDecimal(String stringNumber) {
	NumberFormat format = NumberFormat.getIntegerInstance(Locale.US);         
	String parsed = 0;
	try {
		parsed = format.parse(stringNumber);
	} catch (Exception ex) {
		System.out.println (ex.Message)
	}
	//println ("Converted ${stringNumber} to ${parsed}");
	return parsed;
}   

// Removes all null values from a Map
Map removeNulls(Map<String, Object> map) {
	myMap = map.findAll { it.value != null }
}

// Map a value into a field in the destination map if it isn't null
// Also handle specific field transform logic
void map(destination, fieldName, value, replace) {
	//println ("Pre Map - ${fieldName} : ${value}");
	if (value != null && value != '') {
		switch (fieldName.toLowerCase())
		{			
			case 'hiredate'.toLowerCase(): 
				fromFormat = new SimpleDateFormat("MM/dd/yyyy"); 
				fromFormat.setLenient(false); 
				toFormat = new SimpleDateFormat("yyyy-MM-dd"); 
				toFormat.setLenient(false); 
				Date date = fromFormat.parse(value); 
				value = toFormat.format(date);
   				break;	
			case 'frequency'.toLowerCase(): 
   				if (value.startsWith('Annual')) value = 'Annual';
   				break
			case 'payPlanName'.toLowerCase():
				if (value.startsWith('Annual')) value = 'Salary_Plan';
   				break
			case 'region'.toLowerCase():
				// If Invalid Country_Region_ID replace with default
				println ("region: ${value} ${value.length()}/ replace: ${replace}");
				if (value.length() < 5) value = replace;
				break;			
			case 'salary.type':
				if (value.startsWith('Annual')) value = 'Salary_Plan';
				if (value.startsWith('Hourly')) value = 'Hourly_Plan';
				break;
			case 'salary.amt':
			case 'allowance.car.amt':
			case 'sales.plan.amt':
			case 'ote.amt':
				//Convert bad number string to a decimal
				value = evalNumberToDecimal(value);
				break;						
			case 'startdate':
				long startDate = Long.valueOf(value);
				Date date = new Date();				
				date.setTime(dateString);
				println "startDate:" + date;
				break;			
   			default:
				//println ("${fieldName} : ${value}");
				break;
   		} 						
	} else {
		//When value is null or empty string / """
		switch (fieldName.toLowerCase())
		{			
			case 'country'.toLowerCase():
				if (value.length() == 0) value = replace;
				break;
			case 'hiredate'.toLowerCase():
				format = new SimpleDateFormat("yyyy-MM-dd");     			
				Calendar cal = Calendar.getInstance();         	
				cal.add(Calendar.DATE, 7);
				value =  format.format(cal.getTime());
   				break;			
   			default: 
				//if value is null or empty string and not one of the above fields, then replace with the default.
				value = replace;
				//println (fieldName + ':' + value + ' (default)');
				break;
   		} 						
	}		
	destination[fieldName] = value;
}


// Example Response Data
def restResponse  = '[{"uid":10512213, "name":"Bob"},{"uid":7208201, "name":"John"},{"uid":10570, "name":"Jim"},{"uid":1799657, "name":"Sally"}]'

// Parse the response
dest = new JsonSlurper().parseText( restResponse )


// ---- Fields mapping
//map (dest, 'address', evalGpathOrNull("payload.address"),"Address");

dest = dest.sort { it.key.toLowerCase() };
println ('PreWorkday JSON---------------');
println (new groovy.json.JsonBuilder(dest).toPrettyString());
println ('jobvite2workday-newhire-mapping.groovy completed');