nikolasd
10/26/2017 - 4:47 PM

Add field on report

Pylon Script - Add field on report

function main() {
   	var arrivalDate = sc$Row.Item["heArrival"].ToString();
   	var departureDate = sc$Row.Item["heDeparture"].ToString();
   	var roomNumber = sc$Row.Item["RoomCode"];
   	var strSQL = "SELECT HEMEALPLANS.HECODE AS MEAL FROM HERESERVATIONS INNER JOIN HEMEALPLANS ON HEMEALPLANS.HEID = HERESERVATIONS.HEMLPLNID INNER JOIN HEHOTELROOMS ON HEHOTELROOMS.HEID = HERESERVATIONS.HERMID WHERE HERESERVATIONS.HEARRIVAL = '" + arrivalDate +"' AND HERESERVATIONS.HEDEPARTURE = '" + departureDate +"' AND HEHOTELROOMS.HECODE = '" + roomNumber + "'";
   	var mealPlan = sc$Db.ExecuteScalar(strSQL);
   	return mealPlan;
}

function main() {
   	var itemCode = sc$Row.Item["ItmsCode"];
   	var strSQL = "SELECT CITM.HENAME FROM HEITEMS ITM LEFT JOIN HECATEGORIESITEM CITM ON ITM.HECAT01ID = CITM.HEID WHERE ITM.HECODE = '" + itemCode + "'";
   	var CategoryName = sc$Db.ExecuteScalar(strSQL);
 	return CategoryName;
}