BookingsAllEvents

<?xml version="1.0" encoding="utf-8"?>
<export>
	<configuration>
	<separator>;</separator>
	<textquote>"</textquote>
	<newline>\r\n</newline>
	<encoding>UTF8</encoding>
	</configuration>

	<contents>

		
		<variable name="ViewStartDate">ConvertUnixEpochTime(Convert("decimal",#Request.start) * 1000)</variable>
		<variable name="ViewEndDate">ConvertUnixEpochTime(Convert("decimal",#Request.end) * 1000)</variable>
		<variable name="mEvents">JSequence()</variable>


		<foreach table="booking" datacontext="query" classname="DataBO.ProcessMngt.BookingBO">
			<queryfilter>
				<![CDATA[
				"select pmBooking.BookingID, pmBooking.StartDate as BookingStartDate, pmBooking.EndDate as BookingEndDate, pmBooking.Description as BookingDescription, 
				pmBooking.Code as BookingCode,
				pmBooking.Cancelled as BookingCancelled, pmBooking.Confirmed as BookingConfirmed,
				pmAsset.Code as AssetCode from pmBooking 
				join pmBookingResource on pmBookingResource.BookingResourceID = pmBooking.MainResourceID
				join pmAsset on pmAsset.AssetID = pmBookingResource.AssetID
				where pmBooking.StartDate < " + SqlConv(#ViewEndDate) + "
				and pmBooking.EndDate > " + SqlConv(#ViewStartDate)
				]]>	
			</queryfilter>
			
			if(pmBooking.Cancelled,"Cancelled"
 ,if(pmBooking.Confirmed,"Confirmed","Provisional")
 )
 
			<variable name="allDay">if(datediff("DAY", BookingStartDate, BookingEndDate) >= 1, true, false)</variable>
			<data>
					(#mEvents).Add(
						JObject(
							"id", BookingID,
							"allDay", #allDay,
							"title", AssetCode  +  " | " + BookingCode + " | " + BookingDescription,
							"start", BookingStartDate,
							"end",  if(#allDay, (BookingEndDate).AddMinutes(-1), BookingEndDate),
							"url", FormUrl('AGBookingAdd_2',BookingID,"sxp","pmBooking"),
							"tooltip", translate(if(BookingCancelled, "Cancelled", if(BookingConfirmed, "Confirmed", "Accepted")) + " Booking Event"),
							"color", if(BookingCancelled, "#f2b2b2", if(BookingConfirmed, "green", "#3a87ad"))
						)
					) CONSTRAINS woJob (woJobTask.JobID, woJobTaskCraft.JobTaskID, woSchedule.JobTaskCraftID)
			</data>
		</foreach>
		<const>
			#mEvents
		</const>


	</contents>
</export>