<?xml version="1.0" encoding="UTF-8"?>
<action-sequence>
  <title>Run report for yesterday</title>
  <version>1</version>
  <logging-level>DEBUG</logging-level>
  <documentation>
    <author>Brandon Jackson</author>
    <description>This action simply executes the prpt file for one facility_sk for yesterday.</description>
    <help/>
    <result-type>report</result-type>
    <icon/>
  </documentation>

  <inputs/>

  <outputs>
    <finishedReport type="content">
      <destinations>
        <contentrepo>finishedReport</contentrepo>
      </destinations>
    </finishedReport>
  </outputs>

  <resources>
    <report-definition>
      <solution-file>
        <location>Daily_Labor_Control_v1.7.prpt</location>
        <mime-type>application/zip</mime-type>
      </solution-file>
    </report-definition>
  </resources>

  <actions>
    <action-definition>
      <component-name>JavascriptRule</component-name>
      <action-type>JavaScript</action-type>
      <action-inputs/>
      <action-outputs>
        <date_init type="string"/>
      </action-outputs>
      <component-definition>
        <script><![CDATA[var yesterday = java.util.Calendar.getInstance();
yesterday.add(java.util.Calendar.DAY_OF_MONTH, -1);
yesterday.set(java.util.Calendar.HOUR_OF_DAY , 0);
yesterday.set(java.util.Calendar.MINUTE, 0);
yesterday.set(java.util.Calendar.SECOND , 0);
yesterday.set(java.util.Calendar.MILLISECOND , 0);
p_report_period = yesterday.getTimeInMillis();

var formatter = new java.text.SimpleDateFormat("yyyy-MM-dd");
date_init = formatter.format(yesterday.getTime());]]></script>
      </component-definition>
    </action-definition>

    <action-definition>
      <component-name>SQLLookupRule</component-name>
      <action-type>Get active facilities and email addresses</action-type>
      <action-outputs>
        <query-result type="result-set" mapping="query_result"/>
        <facility_list type="long"/>
        <Facility type="string"/>
        <adminemail type="string"/>
        <RDOemail type="string"/>
        <execemail type="string"/>
      </action-outputs>
      <component-definition>
        <jndi><![CDATA[production]]></jndi>
        <query><![CDATA[SELECT facility_sk as "facility_list", Facility, adminemail, execemail, RDOemail FROM dim_facility WHERE Facility IS NOT NULL AND facility_sk NOT IN (15,18,19,20,21,22,23,25,28,38,34,36,42,32)
ORDER BY Facility]]></query>
        <live><![CDATA[false]]></live>
      </component-definition>
    </action-definition>

    <actions loop-on="query_result">
      <action-definition>
        <component-name>TemplateComponent</component-name>
        <action-type>Message Template</action-type>
        <action-inputs>
          <date_init type="string"/>
          <Facility type="string"/>
        </action-inputs>
        <action-resources/>
        <action-outputs>
          <output-message type="string" mapping="messagebodytext"/>
        </action-outputs>
        <component-definition>
          <template><![CDATA[Greetings {Facility},

Attached is your Daily Labor Control Report for {date_init}.
Please review it with Adobe Acrobat and add comments as requested by your Regional Director.

Latest news from the analysis front:

We are close to our next release of the Labor Control Report.  We are making an effort to improve the understandabilty of the PPD calculations along with other enhancements.

To make feedback extra easy, if you reply to this email, the response will go immediately to both David and Brandon.  We thank you again for helping us make this a wonderful tool for you.  Thank you for your feedback.  We are always listening and contemplating how to improve our service.

Have a great day,

The Stonegate Business Analysis Team


---------------------------------------------------------
Change log:

Current version April 20, 2010
* AHT Census pulls are now fully automated.

Version April 6, 2010
* Budgeted census numbers restored
   - now shows budget for the day & ADC for the year
* Average daily census for the current period is shown.
* Formatting / answers presented in a unified fashion from top to bottom

Version Wednesday March 31, 2010
* Budgeted census removed for revision
   - Through review and feedback we learned that it would be more helpful
      to show the budgeted census for the day and period, as opposed to just
      showing the average daily census for the year
      (ie: Total annual census days/365).  We will bring this feature back soon.

Version released Monday March 29, 2010:
* Budgeted census days shown at the top of the page.
   = Total Annual Days / 365
* Facility totals shown on last page.]]></template>
        </component-definition>
      </action-definition>

      <action-definition>
        <component-name>TemplateComponent</component-name>
        <action-type>Send To: Admin + Executive Dir</action-type>
        <action-inputs>
          <adminemail type="string"/>
          <execemail type="string"/>
        </action-inputs>
        <action-outputs>
          <output-message type="string" mapping="adminandexec"/>
        </action-outputs>
        <component-definition>
          <template><![CDATA[{adminemail}, {execemail}]]></template>
        </component-definition>
      </action-definition>

      <action-definition>
        <component-name>SimpleReportingComponent</component-name>
        <action-type>Run the daily labor control with paramters</action-type>
        <action-inputs>
          <facility_list type="long"/>
          <date_init type="string"/>
        </action-inputs>
        <action-resources>
          <report-definition type="resource"/>
        </action-resources>
        <action-outputs>
          <outputstream type="content" mapping="finishedReport"/>
        </action-outputs>
        <component-definition>
          <useContentRepository><![CDATA[true]]></useContentRepository>
          <outputType><![CDATA[application/pdf]]></outputType>
        </component-definition>
      </action-definition>

      <action-definition>
        <component-name>EmailComponent</component-name>
        <action-type>E-Mail reports to administrators</action-type>
        <action-inputs>
          <finishedReport type="content"/>
          <message-plain type="string" mapping="messagebodytext"/>
          <cc type="string" mapping="RDOemail"/>
          <to type="string" mapping="adminandexec"/>
          <subject type="string" mapping="Facility"/>
        </action-inputs>
        <component-definition>
          <from><![CDATA[biserver@stonegateseniorcare.com]]></from>
          <attachment-ref name-param="attach_name_1" input-param="finishedReport"/>
          <attach_name_1><![CDATA[DLC.pdf]]></attach_name_1>
          <bcc><![CDATA[bjackson@stonegateseniorcare.com, dtruty@stonegateseniorcare.com]]></bcc>
        </component-definition>
      </action-definition>

    </actions>

  </actions>
</action-sequence>