Advanced Report Helpers

{{#filter FX5__Ticket_Items__r "RecordType.DeveloperName" is="Labor"}}
 {{#filter items "Billable__c" is=true}}
   >>{{#if ../../FX5__Category__c "==" "Callout"}}
       {{#each items}}

       {{/each}}
     {{/if}}
 {{/filter}}
{{/filter}}

{{#filter FX5__Ticket_Items__r "RecordType.DeveloperName" is="Labor"}}
 {{#filter items "Billable__c" is=true}}
   {{#filter items "Hide_from_Report__c" is=false}}
     >>{{#if ../../../FX5__Category__c "==" "Callout"}}
         {{#each items}}

         {{/each}}
       {{/if}}
     {{/filter}}
  {{/filter}}
{{/filter}}

<text>{{labels.FX5__Price_Book__c}}</text>

<text>{{labels.FX5__Job__r.FX5__CustomerAccount__c}}</text>

<text>{{userProfile "FullName"}}</text>

<text>{{formatCurrency Extended_Amount__c symbol="" precision="3" separator="," decimal="."}}</text>

<text>{{formatCurrency Extended_Amount__c symbol="" precision="2" separator="." decimal=","}}</text>

<text>{{formatCurrency Extended_Amount__c symbol="€" precision="2" separator="," decimal="."}}</text>

<text>{{CurrencyIsoCode}} {{formatCurrency FX5__Price__c symbol="" precision="2" separator="," decimal="."}}</text>

<text>{{formatCurrency Price__c symbol="" precision="2" separator="," decimal="." emptyValue=""}}</text>

<text>{{formatCurrency Price__c symbol="" precision="2" separator="," decimal="." emptyValue="0"}}</text>

<text>{{formatCurrency Geolocation__Latitude__s symbol="" precision="2" separator="," decimal="."}}{{formatCurrency Geolocation__Longitude__s symbol="" precision="2" separator="," decimal="."}}</text>

<text>{{formatCurrency (max FX5__Ticket_Items__r "FX5__Cost__c") precision="2" separator="," decimal="."}}</text>

{{formatPercent FX5__Discount_Percent__c decimalPlaces="2" emptyValue= "99.99%"}}

<text>{{formatDate FX5__Ticket_Date__c format="MMM Do YY"}}</text>

<text>{{formatDate FX5__Ticket_Date__c format="L" locale="de"}}</text>

<text>{{formatDate (min FX5__Ticket_Items__r "FX5__Date_Start__c")}} to {{formatDate (max FX5__Ticket_Items__r "FX5__Date_End__c")}}</text>

<text>{{formatDateTime FX5__Ticket_Date__c format="MMMM Do YYYY, h:mm A"}}</text>

<text>{{formatDateTime FX5__Ticket_Date__c format="MM/DD/YY h:mm"}}</text>

<text>{{formatDateTime FX5__Ticket_Date__c format="MM/DD/YYYY HH:mm"}}</text>

<text>{{formatDateTime FX5__Ticket_Date__c format="LLL" locale="de"}}</text>

<text>{{formatDateTime (min FX5__Ticket_Items__r "FX5__Date_Start__c")}} to {{formatDateTime (max FX5__Ticket_Items__r "FX5__Date_End__c")}}</text>

<text>{{formatPercent FX5__Discount_Percent__c decimalPlaces=0}}</text>

<text>{{formatPercent FX5__Discount_Percent__c decimalPlaces=2}}</text>

<text>{{formatDateTime (max FX5__Ticket_Items__r "FX5__Date_End__c")}}</text>

<td>{{formatTime Time__c format="h:mm A"}}</td>

 <text>{{avg FX5__Ticket_Items__r "Discounted_Price__c" precision="2" separator="," decimal="."}}</text>

 {{#collect FX5__Tickets__r "FX5__Ticket_Items__r"}}
   <text>${{avg items "FX5_Discount_Percent__c" precision="2" separator="," decimal="."}}</text>
 {{/collect}}

 <text>{{formula "round({0} * {1},2)" FX5__Price__c Qty__c}}</text>

<text>{{formatCurrency (formula "{0} / 10" (sum FX5__Ticket_Items__r "Extended_Amount__c" )) precision="2" separator="," decimal="."}}</text>

<text>${{formatCurrency (formula "{0} - {1}" (sum FX5__Ticket_Items__r "FX5__Price__c") (sum FX5__Ticket_Items__r "Discounted_Price__c")) precision="2" separator="," decimal="."}}</text>

{{#if (formula "!ISBLANK({0}) || !ISBLANK({1}) || !ISBLANK({2})" O2_ppmV_Outlet__c NH3_Ammonia_ppmV_Outlet__c Ethylbenzene_Outlet__c)}}
  <text>Special Readings</text>
  <text>SO2 ppmV: {{formatCurrency SO2_ppmV_Outlet__c precision="2" separator="," decimal="."}}</text>
  <text>NH3 / Ammonia ppmV: {{formatCurrency NH3_Ammonia_ppmV_Outlet__c precision="2" separator="," decimal="."}}</text>
  <text>Ethylbenzene ppmV: {{formatCurrency Ethylbenzene_Outlet__c precision="2" separator="," decimal="."}}</text>
{{/if}}

<text>{{sum FX5__Ticket_Items__r "Extended_Amount__c" precision="2" separator="," decimal="."}}</text>

{{#collect FX5__Tickets__r "FX5__Ticket_Items__r"}}
  <text>${{sum items "Extended_Amount__c" precision="2" separator="," decimal="."}}</text>
{{/collect}}

{{sum items "Total_Hours__c" precision="1" separator="," decimal="." roundEach="false" }}

{{#collect FX5__Tickets__r "FX5__Ticket_Items__r"}}
  <text>${{sum items "Extended_Amount__c" precision="2" separator="," decimal="."}}</text>
{{/collect}}

{{#collect FX5__Tickets__r "FX5__Ticket_Logs__r"}}
  {{#sort items "FX5__Start_Time__c"}}
    <text>{{Tracking_Number__c}}</text>
    <text>{{FX5__Category__c}}</text>
    <text>{{formatDateTime FX5__Start_Time__c format="MM/DD/YY h:mm A"}}</text>
    <text>{{formatDateTime FX5__Stop_Time__c format="MM/DD/YY h:mm A"}}</text>
    <text>{{FX5__Comments__c}}</text>
  {{/sort}}
{{/collect}}

{{#each FX5__Tickets__r}}
{{#each FX5__Tickets_Items__r}}

{{/each}}
{{/each}}

{{#filter FX5__Ticket_Items__r "RecordType.DeveloperName" is="Labor"}}
{{#each items}}

{{/each}}
{{/filter}}

{{#each items}}
  <row>
    <cell>{{@index}}</cell>
    <cell>{{FX5__Description__c}}</cell>
    <cell>{{Qty__c}}</cell>
    <cell>{{FX5__Price__c}}</cell>
    <cell>{{FX5__Discount_Percent__c}}</cell>
    <cell>{{Extended_Amount__c}}</cell>
  </row>
{{/each}}

{#each items}}
  <row>
    <cell>{{@position}}</cell>
    <cell>{{FX5__Description__c}}</cell>
    <cell>{{Qty__c}}</cell>
    <cell>{{FX5__Price__c}}</cell>
    <cell>{{FX5__Discount_Percent__c}}</cell>
    <cell>{{Extended_Amount__c}}</cell>
  </row>
{{/each}}

{{#each JSAs__r}}

{{/each}}

{{#each Pipe_Heads__r}}

{{/each}}

{{#each FX5__Crew_Planning__r}}

{{/each}}

{{#each FX5__Job_Equipment__r}}

{{/each}}

{{#filter FX5__Ticket_Items__r "RecordType.DeveloperName" is="Labor"}}
{{#each items}}

{{/each}}
{{/filter}}

{{#filter FX5__Ticket_Items__r "RecordType.DeveloperName" is="Labor"}}
  <text>Count: {{items.length}}</text>
{{/filter}}

{{#filter FX5__Ticket_Items__r "Extended_Amount__c" not=0}}
{{#sort items "FX5__Price__c" desc=true}}

{{/sort}}
{{/filter}}

{{#filter FX5__Ticket_Items__r "FX5__Parent_Ticket_Item__c" is=null}}
  {{#if items.length}}
    {{#each items}}

      {{#filter @root.FX5__Ticket_Items__r "FX5__Parent_Ticket_Item__c" is=Id}}
        {{#each items}}

        {{/each}}
      {{/filter}}
    {{/each}}
  {{/if}}
{{/filter}}

{{#filter FX5__Tickets__r "FX5__Status__r.Name" is="Ready for Signature"}}
  {{#collect items "FX5__Ticket_Items__r"}}
    {{#filter items "RecordType.DeveloperName" is="Equipment"}}
      {{#each items}}

      {{/each}}
    {{/filter}}
  {{/collect}}
{{/filter}}

{{#filterBy FX5__Ticket__Items__r "FX5__Price__c > 0"}}

{{/filterBy}}

{{#filterBy FX5__Ticket__Items__r "!ISBLANK(FX5__Notes__c)"}}

{{/filterBy}}

{{#filterBy FX5__Ticket__Items__r "!ISBLANK(FX5__Notes__c)" as="ticketitems"}}

{{/filterBy}}

{{#group FX5__Ticket_Items__r "RecordType.DeveloperName"}}
  {{#each items}}

  {{/each}}
{{/group}}

{{#group FX5__Ticket_Items__r "RecordType.DeveloperName" sortBy="RecordType_DeveloperName" desc=false}}
  {{#each items}}

  {{/each}}
{{/group}}

{{#filter FX5__Ticket_Items__r "RecordType.DeveloperName" is="Labor"}}
  {{#group items "FX5__Contact__r.Name"}}
    {{#each items}}

    {{/each}}
  {{/group}}
{{/filter}}

{#filter FX5__Ticket_Items__r "RecordType.DeveloperName" is="Labor"}}
  {{#group items "FX5__Contact__c Clock_In__c Clock_Out__c"}}
    {{#each items}}

    {{/each}}
  {{/group}}
{{/filter}}

{{#if FX5__Notes__c}}
  <text>Notes: {{FX5__Notes__c}}</text>
  {{else}}
    <text>There are no notes available.</text>
{{/if}}

<text>Fire Protection:</text>
<text>{{#if Fire_Protection__c}}<input type="checkbox" checked>{{else}}<input type="checkbox">{{/if}}</text>

{{#if Extended_Amount__c ">=" "1.00"}}
  <row>
    <cell>{{FX5__Description__c}}</cell>
    <cell>{{formatCurrency Qty__c symbol="" precision="2" separator="," decimal="."}}</cell>
    <cell>{{formatCurrency FX5__Price__c symbol="$" precision="2" separator="," decimal="."}}</cell>
    <cell>{{formatPercent FX5__Discount_Percent__c decimalPlaces="2"}}</cell>
    <cell>{{formatCurrency Extended_Amount__c symbol="$" precision="2" separator="," decimal="."}}</cell>
  </row>
{{/if}}

{{#if (sum items "Extended_Amount__c") ">" "10000.00"}}
  <text>Over Budget</text>
  {{else}}
    <text>Under Budget</text>
{{/if}}

{{#if (formula "!ISBLANK({0}) || !ISBLANK({1}) || !ISBLANK({2})" SO2_ppmV_Outlet__c NH3_Ammonia_ppmV_Outlet__c Ethylbenzene_Outlet__c)}}
  <text>SO2 ppmV: {{formatCurrency SO2_ppmV_Outlet__c precision="2" separator="," decimal="."}}</text>
  <text>NH3 / Ammonia ppmV: {{formatCurrency NH3_Ammonia_ppmV_Outlet__c precision="2" separator="," decimal="."}}</text>
  <text>Ethylbenzene ppmV: {{formatCurrency Ethylbenzene_Outlet__c precision="2" separator="," decimal="."}}</text>
{{/if}}

{{#filter FX5__Ticket_Items__r "Discounted__c" is=true}}
{{#if items.length}}
  <text>Total Discount:</text>
  <text>{{sum items "Discount_Amount__c" precision="2" separator"," decimal="."}}</text>
{{/if}}
{{/filter}}

{{#each items}}
  <text>{{formatDate FX5__Date_Start__c format="MM/DD/YYYY"}}{{#if FX5__Date_End__c}}-{{formatDate FX5__Date_End__c format="MM/DD/YYYY"}}{{/if}}{{#if @last "==" false}}, {{/if}}</text>
{{/each}}

{{#each items}}
  <text>{{#if formula="RecordType.DeveloperName == 'Labor'"}}Labor{{else}}NotLabor{{/if}}</text>
{{/each}}

{{#sort FX5__Ticket_Items__r "Extended_Amount__c" desc=true}}
  <row>
    <cell>{{FX5__Description__c}}</cell>
    <cell>{{formatCurrency Qty__c symbol="" precision="2" separator="," decimal="."}}</cell>
    <cell>{{formatCurrency FX5__Price__c symbol="$" precision="2" separator="," decimal="."}}</cell>
    <cell>{{formatCurrency Extended_Amount__c symbol="$" precision="2" separator="," decimal="."}}</cell>
  </row>
{{/sort}}

{{#sort items "FX5__Description__c" desc=true}}
  <row>
    <cell>{{@index}}</cell>
    <cell>{{FX5__Description__c}}</cell>
  </row>
{{/sort}}

{{#sort items "FX5__Description__c" desc=true}}
  <row>
    <cell>{{@position}}</cell>
    <cell>{{FX5__Description__c}}</cell>
  </row>
{{/sort}}

<text>{{#unless FX5__On_Standby__c}}{{FX5__Price__c}}{{/unless}}</text>

{{#with FX5__Job__r}}
  <text>Job: {{Name}}</text>
  <text>Customer: {{FX5__CustomerAccount__r.Name}}</text>
{{/with}}

{{#with FX5__Job__r}}
  {{#each FX5__Crew_Planning__r}}

  {{/each}}
{{/with}}

{{#with FX5__Job__r}}
  {{#each FX5__Job_Equipment__r}}

  {{/each}}
{{/with}}

<div style="width: 2in; height: 1in">{{{captureImage}}}</div>

<div style="width: 2in; height: 1in">{{{captureImage maxSize="500"}}}</div>

<div class="signature">{{{signatureBlock}}}</div>

.signature {
  page-break-inside: avoid;
  position: relative;
  display: inline-block;
  margin-top: .25in;
  height: 66px;
  width: 293px;
  background-image: url(data:image/png;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/2Q==);
}

<div class="signature">
  <div class="signature-watermark">{{FX5__Tracking_Number__c}}</div>
  {{{signatureBlock}}}
</div>

.signature {
  page-break-inside: avoid;
  position: relative;
  display: inline-block;
  margin-top: .25in;
  height: 66px;
  width: 293px;
  background-image: url(data:image/png;base64,/9j/4AAQSkZJRgABAQEAYABgAAD/2Q==);
}
.signature-watermark {
  position: absolute;
  line-height: 3em;
  opacity: 0.25;
  font-size: 2.5em;
  width: 100%;
  text-align: center;
  pointer-events: none;
}

<?xml version="1.0" encoding="UTF-8"?>
<template pageSize="LETTER" pageOrientation="portrait" pageMargins="72 72 72 72">
  <body>
    {{applyTemplate FX5__Notes__c}}
  </body>
</template>

<text bold="true">Here is a sample of a sub-template: {{FX5__Tracking_Number__c}}</text>

<?xml version="1.0" encoding="UTF-8"?>
<template pageSize="LETTER" pageOrientation="portrait" pageMargins="72 72 72 72">
  <body>
    <text>{{Language__r.Tracking_Number__c}}: {{FX5__Tracking_Number__c}}</text>
    <text>{{Language__r.Office__c}}: {{FX5__Office__r.Name}}</text>
    <text>{{Language__r.Customer__c}}: {{FX5__CustomerAccount__r.Name}}</text>
    <stack marginTop="32">
      {{applyTemplate Language__r.TandC__c}}
    </stack>
  </body>
</template>