var tc_event;
var errorMessage;

function changeValue(TC_Event) {

var mydata = JSON.parse(TC_Event);

var current = new Date();
var cDate = current.getFullYear() + '-' + (current.getMonth() + 1) + '-' + current.getDate();
var cTime = current.getHours() + ":" + current.getMinutes() + ":" + current.getSeconds();

var EMPLID = null;
var ENCODING = null;
var CLASSIFICATION = null;
var ISOPULL = null;
var CARDID = null;
var REASON = null;
var USER_ID = null;
var CAMPUS = null;
var PROJECT = null;
var MYPHOTOCODE = null;
var PRINTCOUNT = null;
var DATETIMENOW = cDate + " " + cTime;

for (var index in mydata) {

var field = mydata[index];

if (field.name == 'CustNumber') {
	EMPLID = field.value;
}

if (field.name == 'CLASS_CODE') {
	ENCODING = field.value;
}

if (field.name == 'Classification') {
	CLASSIFICATION = field.value;
}

if (field.name == 'PoolNumber1') {
	ISOPULL = field.value;
}

if (field.name == 'ISOLast4') {
	CARDID = field.value;
}

if (field.name == 'PrintReason') {
	REASON = field.value;
}

if (field.name == 'UserID') {
	USER_ID = field.value;
}

if (field.name == 'Campus') {
	CAMPUS = field.value;
}

if (field.name == 'Project') {
	PROJECT = field.value;
}

if (field.name == 'MyPhotoCode') {
	MYPHOTOCODE = field.value;
}

if (field.name == 'PrintCount') {
	PRINTCOUNT = field.value;
}
	
}

var sqlStatement = "INSERT INTO PRINT_LOG (EMPLID,ENCODING,CLASSIFICATION,ISOPULL,CARDID,REASON,USER_ID,CAMPUS,PROJECT,DATETIME,MYPHOTOCODE,PRINTCOUNT) VALUES ('"+EMPLID+"','"+ENCODING+"','"+CLASSIFICATION+"','"+ISOPULL+"','"+CARDID+"','"+REASON+"','"+USER_ID+"','"+CAMPUS+"','"+PROJECT+"','"+DATETIMENOW+"','"+MYPHOTOCODE+"','"+PRINTCOUNT+"')";

var response = service.write(sqlStatement);

if (response === 0) {
errorMessage = 'No records were updated.';
print(errorMessage);
}

tc_event = JSON.stringify(mydata);
return tc_event;
}

changeValue(TC_Event);