b1nary0mega
5/13/2016 - 1:25 PM

Generate JSON of employee schedule data

Generate JSON of employee schedule data

<cfset START_DATE = CreateODBCDate('2015,1,1')>
<cfset END_DATE = CreateODBCDate('2015,12,31')>

<cfquery name="getUnitTimes" 
  datasource="#application.datasrc_mss#" 
  dbtype="#application.dbtype_mss#">
SELECT UNIT_ID, 
  END_DTTM, 
  EMPLOYEE_ID, 
  TIME_CODE, 
  NP_TIME_CODE, 
  MODIFY_DT
FROM employee_times
WHERE END_DTTM >= #START_DATE#
AND END_DTTM   <= #END_DATE#
AND EMPLOYEE_ID = '228646'
order by END_DTTM ASC
</cfquery>

<!--- Generate a clean feed by suppressing white space and debugging info. --->
<cfprocessingdirective suppresswhitespace="yes">
  <cfcontent type="application/x-json">
  <cfscript>
    myJSON = SerializeJSON(getUnitTimes, true, false);
    writeOutput("onLoad("&myJSON&")");
  </cfscript>
</cfprocessingdirective>