<?xml version="1.0" encoding="utf-8"?>
<Templates xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://gpsgate.com/xml/">
  <Template>
    <Object>
      <TemplateGuid>e2244e6e-58cf-4f3b-b08a-17422c047456</TemplateGuid>
      <TemplateVersion>1</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.ReportDefinitionWriter</ObjectType>
      <ObjectData>
        <ReportDefinition>
          <Name>XML001 Offline Report</Name>
          <ScopeID>f88b5fd3-cb49-43a4-a4a2-7491af7a022d</ScopeID>
          <Description>Latest device activity with valid position by date and tag</Description>
          <AppTemplate>00000000-0000-0000-0000-000000000000</AppTemplate>
          <Query>d916cc90-8c62-42aa-b905-d4cf17c7c719</Query>
          <TableDefinition defaultStyles="false">
            <pageDefinition>
              <pageFormat>Auto</pageFormat>
              <columnWidths>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
                <double>0</double>
              </columnWidths>
            </pageDefinition>
            <Columns />
            <Regions>
              <Region repeatHeader="false" pageBreak="false" expression="" level="0" sortExpression="[LastValidPositionDeviceTime]" sortDirection="DESC">
                <Header kind="h">
                  <RegionRow id="h_0_0" VisibilityExpression="true">
                    <Column expression="Total Devices:" visibilityExpression="" action="" id="h_0_0_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 16px 0px" />
                    </Column>
                    <Column expression="$countunique([DeviceID])" visibilityExpression="" action="" id="h_0_0_1" cspan="3" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 16px 9px" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i">
                  <RegionRow id="i_0_0" VisibilityExpression="true">
                    <Column expression="[Name]" visibilityExpression="" action="" id="i_0_0_0" cspan="1" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-family:Arial, Helvetica, sans-serif;border:solid #DFE3EB;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="[Username]" visibilityExpression="" action="" id="i_0_0_1" cspan="1" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-family:Arial, Helvetica, sans-serif;border:solid #DFE3EB;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="[LastValidPositionDeviceTime]" visibilityExpression="" action="{&quot;name&quot;:&quot;Show Marker&quot;,&quot;action&quot;:&quot;showMarker&quot;,&quot;trigger&quot;:&quot;onclick&quot;,&quot;params&quot;:[&quot;[UserID]&quot;,&quot;[LastValidPositionDeviceTime]&quot;]}" id="i_0_0_2" cspan="1" unit="FULL_DATE_TIME" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-family:Arial, Helvetica, sans-serif;border:solid #DFE3EB;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="[Description]" visibilityExpression="" action="" id="i_0_0_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-family:Arial, Helvetica, sans-serif;border:solid #DFE3EB;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                  </RegionRow>
                </Item>
                <Footer kind="f">
                  <RegionRow id="f_0_0" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_0" cspan="1" escape="true">
                      <Layout style="padding:0px 0px 0px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_1" cspan="1" escape="true">
                      <Layout style="padding:0px 0px 0px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_2" cspan="1" unit="" escape="true">
                      <Layout style="padding:0px 0px 0px 0px" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_3" cspan="1" unit="" escape="true">
                      <Layout style="padding:0px 0px 0px 0px" />
                    </Column>
                  </RegionRow>
                </Footer>
              </Region>
              <Region repeatHeader="false" pageBreak="false" expression="[TagID]" level="1" sortExpression="[TagName]" sortDirection="ASC">
                <Header kind="h">
                  <RegionRow id="h_1_0" VisibilityExpression="true">
                    <Column expression="[TagName]" visibilityExpression="" action="" id="h_1_0_0" cspan="4" unit="" escape="true">
                      <Layout style="font-size:16pt;color:#051C2C;background-color:#fffff;font-family:Arial, Helvetica, sans-serif;padding:9px 0px 16px 0px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_1_1" VisibilityExpression="true">
                    <Column expression="Total Devices:" visibilityExpression="" action="" id="h_1_1_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;background-color:#fffff;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 0px" />
                    </Column>
                    <Column expression="$count([DeviceID])" visibilityExpression="" action="" id="h_1_1_1" cspan="3" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;background-color:#fffff;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 4px 9px" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i" />
                <Footer kind="f">
                  <RegionRow id="f_1_0" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_1_0_0" cspan="4" unit="" escape="true">
                      <Layout style="border:solid #DFE3EB;border-width:2px 0px 0px 0px;padding:0px 0px 16px 0px" />
                    </Column>
                  </RegionRow>
                </Footer>
              </Region>
              <Region repeatHeader="false" pageBreak="false" expression="[LastValidPositionDeviceDate]" level="2" sortExpression="[LastValidPositionDeviceTime]" sortDirection="DESC">
                <Header kind="h">
                  <RegionRow id="h_2_0" VisibilityExpression="true">
                    <Column expression="[LastValidPositionDeviceTime] :" visibilityExpression="" action="" id="h_2_0_0" cspan="1" unit="SHORT_DATE" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 16px 0px" />
                    </Column>
                    <Column expression="$count([DeviceID]) devices" visibilityExpression="" action="" id="h_2_0_1" cspan="3" unit="" escape="true">
                      <Layout style="font-size:10pt;color:#051C2C;font-weight:bold;font-family:Arial, Helvetica, sans-serif;padding:4px 0px 16px 9px" />
                    </Column>
                  </RegionRow>
                  <RegionRow id="h_2_1" VisibilityExpression="true">
                    <Column expression="Name" visibilityExpression="" action="" id="h_2_1_0" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#4E5867;background-color:#DFE3EB;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #9EA6B4;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Username" visibilityExpression="" action="" id="h_2_1_1" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#4E5867;background-color:#DFE3EB;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #9EA6B4;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Valid Position Time" visibilityExpression="" action="" id="h_2_1_2" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#4E5867;background-color:#DFE3EB;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #9EA6B4;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                    <Column expression="Description" visibilityExpression="" action="" id="h_2_1_3" cspan="1" unit="" escape="true">
                      <Layout style="font-size:8pt;color:#4E5867;background-color:#DFE3EB;font-weight:bold;font-family:Arial, Helvetica, sans-serif;border:solid #9EA6B4;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i" />
                <Footer kind="f">
                  <RegionRow id="f_2_0" VisibilityExpression="true">
                    <Column expression="" visibilityExpression="" action="" id="f_2_0_0" cspan="4" unit="" escape="true">
                      <Layout style="border:solid #9EA6B4;border-width:0px 0px 1px 0px;padding:9px 9px 9px 9px" />
                    </Column>
                  </RegionRow>
                </Footer>
              </Region>
            </Regions>
          </TableDefinition>
        </ReportDefinition>
      </ObjectData>
    </Object>
    <Object>
      <TemplateGuid>d916cc90-8c62-42aa-b905-d4cf17c7c719</TemplateGuid>
      <TemplateVersion>16</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.QueryWriter</ObjectType>
      <ObjectData>
        <Query>
          <Name>Q1DeviceAcitivityValidPos</Name>
          <ScopeID>f88b5fd3-cb49-43a4-a4a2-7491af7a022d</ScopeID>
          <QueryText>SELECT
	[ApplicationID] AS ApplicationID,
	Users.Name,
	Users.Username,
	Users.UserID,
	Users.Description,
	TagUsers.TagID,
	TagUsers.Name AS TagName,
	Device.DeviceID,
	Device.DeviceName,
	Device.OwnerID,
	Device.IMEI,
	Device.PhoneNumber,
	Device.Longitude,
	Device.Latitude,
	IFNULL(Device.LastDevicePositionTime, CAST('2000-01-01 12:00:00' AS DATETIME)) AS LastDevicePositionTime,
	IFNULL(Device.LastValidPositionDeviceTime, CAST('2000-01-01 12:00:00' AS DATETIME)) AS LastValidPositionDeviceTime,
	IFNULL(Device.LastValidPositionServerTime, CAST('2000-01-01 12:00:00' AS DATETIME)) AS LastValidPositionServerTime,
	Device.DevicePassword,
	Device.DeviceTypeName,
	Device.LastDeviceActivity,
	DATE(
		DATE_ADD(
			IFNULL(Device.LastValidPositionDeviceTime, CAST('2000-01-01 12:00:00' AS DATETIME)),
			INTERVAL [_UTCOFFSET] SECOND
		)
	) AS LastValidPositionDeviceDate
FROM Device
JOIN Users ON Device.OwnerID = Users.UserID
JOIN TagUsers ON Users.UserID = TagUsers.UserID
WHERE TagUsers.TagID IN [TagID] AND LastValidPositionDeviceTime &lt; DATE_SUB(UTC_TIMESTAMP(), INTERVAL [Offline Days] DAY)</QueryText>
          <QueryTextAlt1>SELECT
	[ApplicationID] AS ApplicationID,
	Users.Name,
	Users.Username,
	Users.UserID,
	TagUsers.TagID,
	TagUsers.Name AS TagName,
	Device.DeviceID,
	Device.DeviceName,
	Device.OwnerID,
	Device.IMEI,
	Device.PhoneNumber,
	Device.Longitude,
	Device.Latitude,
	ISNULL(Device.LastDevicePositionTime, CAST('2000-01-01 00:00:00' AS DATETIME)) AS LastDevicePositionTime,
	ISNULL(Device.LastValidPositionDeviceTime, CAST('2000-01-01 12:00:00' AS DATETIME)) AS LastValidPositionDeviceTime,
	ISNULL(Device.LastValidPositionServerTime, CAST('2000-01-01 12:00:00' AS DATETIME)) AS LastValidPositionServerTime,
	Device.DevicePassword,
	Device.DeviceTypeName,
	Device.LastDeviceActivity,
	DATEPART(DAY, 
		DATEADD(
			SECOND, 
			[_UTCOFFSET], 
			ISNULL(Device.LastValidPositionDeviceTime, CAST('2000-01-01 00:00:00' AS DATETIME))
		)
	) AS LastValidPositionDeviceDate
FROM Device
JOIN Users ON Device.OwnerID = Users.UserID
JOIN TagUsers ON Users.UserID = TagUsers.UserID
WHERE TagUsers.TagID IN [TagID]</QueryTextAlt1>
          <IsInternal>False</IsInternal>
          <Type>GpsGate.Reporting.v3.UserQuery</Type>
          <Parameters>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.QueryReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>ApplicationID</param_name>
              <multi>False</multi>
              <value_field>ApplicationID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Applications</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.QueryReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>TagID</param_name>
              <multi>True</multi>
              <value_field>TagID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Tags</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.NumberSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>Offline Days</param_name>
              <multi>False</multi>
              <data_type>System.Double</data_type>
              <default_value>5</default_value>
            </Parameter>
          </Parameters>
        </Query>
      </ObjectData>
    </Object>
  </Template>
</Templates>