
<h1>Edit Work Schedule</h1>

<br>


<cfif isdefined("url.availableId") and url.availableId neq "">
<cfquery  name="GetAvilableData" datasource="#Application.DataSrc#">

SELECT * FROM #Request.prefix_db_agency#.Employee_Workschedule WHERE employeeworkschedule_ID=#url.availableId#;

</cfquery>
</cfif>

<cfset theStarthour=GetToken(TIMEFORMAT(GetAvilableData.ScheduleStart, "H:MM tt"),1,':')> 
<cfset theStartminute=GetToken(GetAvilableData.ScheduleStart,2,':')> 

<cfset theEndhour=GetToken(TIMEFORMAT(GetAvilableData.ScheduleEnd, "H:MM tt"),1,':')> 
<cfset theEndminute=GetToken(GetAvilableData.ScheduleEnd,2,':')> 
  
 

<cfoutput>
<form name=editworkschedule method=post action=''>
<table width="100%"  border="0" cellspacing="0" cellpadding="2" class="form-border">
<input type=hidden name=action value="EditSchedule">
<input type=hidden name=scheduledate value="#dateformat(ParseDatetime(url.d),'YYYY-MM-DD')#">
<input type=hidden name=scheduleAvailableId value="#url.availableId#">
<tr><Td>Date:</td><td><strong>#url.d#</strong></td></tr>
<tr><Td>Start Time:</td><td>

<select id=StartHour name=StartHour > 
<option value="00" <cfif theStarthour eq 0> selected</cfif>>00</option> 
<option value="01" <cfif theStarthour eq 1> selected</cfif>>1</option> 
<option value="02" <cfif theStarthour eq 2> selected</cfif>>2</option> 
<option value="03" <cfif theStarthour eq 3> selected</cfif>>3</option> 
<option value="04" <cfif theStarthour eq 4> selected</cfif>>4</option> 
<option value="05" <cfif theStarthour eq 5> selected</cfif>>5</option> 
<option value="06" <cfif theStarthour eq 6> selected</cfif>>6</option> 
<option value="07" <cfif theStarthour eq 7> selected</cfif>>7</option> 
<option value="08" <cfif theStarthour eq 8> selected</cfif>>8</option> 
<option value="09" <cfif theStarthour eq 9> selected</cfif>>9</option> 
<option value="10" <cfif theStarthour eq 10> selected</cfif>>10</option> 
<option value="11" <cfif theStarthour eq 11> selected</cfif>>11</option> 
<option value="12" <cfif theStarthour eq 12> selected</cfif>>12</option> 
<option value="13" <cfif theStarthour eq 13> selected</cfif>>13</option> 
<option value="14" <cfif theStarthour eq 14> selected</cfif>>14</option> 
<option value="15" <cfif theStarthour eq 15> selected</cfif>>15</option> 
<option value="16" <cfif theStarthour eq 16> selected</cfif>>16</option> 
<option value="17" <cfif theStarthour eq 17> selected</cfif>>17</option> 
<option value="18" <cfif theStarthour eq 18> selected</cfif>>18</option> 
<option value="19" <cfif theStarthour eq 19> selected</cfif>>19</option> 
<option value="20" <cfif theStarthour eq 20> selected</cfif>>20</option>
<option value="21" <cfif theStarthour eq 21> selected</cfif>>21</option>
<option value="22" <cfif theStarthour eq 22> selected</cfif>>22</option>
<option value="23" <cfif theStarthour eq 23> selected</cfif>>23</option>

</select> 

&nbsp;:&nbsp; 
<select id=StartMinute name=StartMinute > 
<option value="00"  <cfif theStartminute eq 0> selected</cfif>>00</option> 
<option value="05" <cfif theStartminute eq 5> selected</cfif>>05</option> 
<option value="10" <cfif theStartminute eq 10> selected</cfif>>10</option> 
<option value="15" <cfif theStartminute eq 15> selected</cfif>>15</option> 
<option value="20" <cfif theStartminute eq 20> selected</cfif>>20</option> 
<option value="25" <cfif theStartminute eq 25> selected</cfif>>25</option> 
<option value="30" <cfif theStartminute eq 30> selected</cfif>>30</option> 
<option value="35" <cfif theStartminute eq 35> selected</cfif>>35</option> 
<option value="40" <cfif theStartminute eq 40> selected</cfif>>40</option> 
<option value="45" <cfif theStartminute eq 45> selected</cfif>>45</option> 
<option value="50" <cfif theStartminute eq 50> selected</cfif>>50</option> 
<option value="55" <cfif theStartminute eq 55> selected</cfif>>55</option> 
</select> 

</td></tr>
<tr><Td>End Time:</td><td>
<select id=EndHour name=EndHour > 
<option value="00" <cfif theEndhour eq 0> selected</cfif>>00</option> 
<option value="01" <cfif theEndhour eq 1> selected</cfif>>1</option> 
<option value="02" <cfif theEndhour eq 2> selected</cfif>>2</option> 
<option value="03" <cfif theEndhour eq 3> selected</cfif>>3</option> 
<option value="04" <cfif theEndhour eq 4> selected</cfif>>4</option> 
<option value="05" <cfif theEndhour eq 5> selected</cfif>>5</option> 
<option value="06" <cfif theEndhour eq 6> selected</cfif>>6</option> 
<option value="07" <cfif theEndhour eq 7> selected</cfif>>7</option> 
<option value="08" <cfif theEndhour eq 8> selected</cfif>>8</option> 
<option value="09" <cfif theEndhour eq 9> selected</cfif>>9</option> 
<option value="10" <cfif theEndhour eq 10> selected</cfif>>10</option> 
<option value="11" <cfif theEndhour eq 11> selected</cfif>>11</option> 
<option value="12" <cfif theEndhour eq 12> selected</cfif>>12</option> 
<option value="13" <cfif theEndhour eq 13> selected</cfif>>13</option> 
<option value="14" <cfif theEndhour eq 14> selected</cfif>>14</option> 
<option value="15" <cfif theEndhour eq 15> selected</cfif>>15</option> 
<option value="16" <cfif theEndhour eq 16> selected</cfif>>16</option> 
<option value="17" <cfif theEndhour eq 17> selected</cfif>>17</option> 
<option value="18" <cfif theEndhour eq 18> selected</cfif>>18</option> 
<option value="19" <cfif theEndhour eq 19> selected</cfif>>19</option> 
<option value="20" <cfif theEndhour eq 20> selected</cfif>>20</option>
<option value="21" <cfif theEndhour eq 21> selected</cfif>>21</option>
<option value="22" <cfif theEndhour eq 22> selected</cfif>>22</option>
<option value="23" <cfif theEndhour eq 23> selected</cfif>>23</option>

</select> 

&nbsp;:&nbsp; 
<select id=EndMinute name=EndMinute > 
<option value="00"  <cfif theEndminute eq 0> selected</cfif>>00</option> 
<option value="05" <cfif theEndminute eq 5> selected</cfif>>05</option> 
<option value="10" <cfif theEndminute eq 10> selected</cfif>>10</option> 
<option value="15" <cfif theEndminute eq 15> selected</cfif>>15</option> 
<option value="20" <cfif theEndminute eq 20> selected</cfif>>20</option> 
<option value="25" <cfif theEndminute eq 25> selected</cfif>>25</option> 
<option value="30" <cfif theEndminute eq 30> selected</cfif>>30</option> 
<option value="35" <cfif theEndminute eq 35> selected</cfif>>35</option> 
<option value="40" <cfif theEndminute eq 40> selected</cfif>>40</option> 
<option value="45" <cfif theEndminute eq 45> selected</cfif>>45</option> 
<option value="50" <cfif theEndminute eq 50> selected</cfif>>50</option> 
<option value="55" <cfif theEndminute eq 55> selected</cfif>>55</option> 
</select> 


</td></tr>
<tr><Td>Type:</td><td><input type=radio id=scheduletype name=scheduletype value='available' <cfif GetAvilableData.ScheduleType eq "available">  checked</cfif>> Available
&nbsp;&nbsp;&nbsp;<input type=radio id=scheduletype name=scheduletype value='unavailable' <cfif GetAvilableData.ScheduleType neq "available">  checked</cfif>>Unavailable</td></tr>
<tr><Td>Reason:</td><td><input type=text id=schedulereason name=schedulereason size=30 value='#GetAvilableData.Reason#'></td></tr>
<tr><Td>&nbsp;</td><td><br><input type=submit name=submit value="Update"></td></tr>
</table>
</form>
</cfoutput>