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;
}