﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <JSON Ref="2" type="Stimulsoft.Report.Dictionary.StiJsonDatabase" isKey="true">
        <Alias>JSON</Alias>
        <Key>de978f51bbb4436f914eb9581410c858</Key>
        <Name>JSON</Name>
        <PathData>F:\Work\TimeAttendance\PrimoTime\angular\PrimoTimeDesign\src\reports\crossdaysreport.json</PathData>
      </JSON>
    </Databases>
    <DataSources isList="true" count="2">
      <days Ref="3" type="DataTableSource" isKey="true">
        <Alias>days</Alias>
        <Columns isList="true" count="58">
          <value>dayId,System.Decimal</value>
          <value>employeeId,System.Decimal</value>
          <value>attDate,System.DateTime</value>
          <value>attDateHJ,System.String</value>
          <value>dayOfWeek,System.Decimal</value>
          <value>checkIn,System.String</value>
          <value>checkOut,System.String</value>
          <value>checkIn2,System.String</value>
          <value>checkOut2,System.String</value>
          <value>delay,System.String</value>
          <value>delay2,System.String</value>
          <value>overtime,System.String</value>
          <value>overtime2,System.String</value>
          <value>totalVacationHours,System.String</value>
          <value>earlyLeave,System.String</value>
          <value>earlyLeave2,System.String</value>
          <value>vacationHours,System.String</value>
          <value>deductedVacationHours,System.String</value>
          <value>actualWorkInMinutes,System.String</value>
          <value>actualWorkInMinutes2,System.String</value>
          <value>shiftHours,System.String</value>
          <value>shiftHours2,System.String</value>
          <value>isHoliday,System.Boolean</value>
          <value>isWeeklyOff,System.Boolean</value>
          <value>isWorkingDay,System.Boolean</value>
          <value>isSickLeave,System.Boolean</value>
          <value>isVacationDay,System.Boolean</value>
          <value>isDeducted,System.Boolean</value>
          <value>isAbsence,System.Boolean</value>
          <value>isWorkMission,System.Boolean</value>
          <value>shiftStart,System.String</value>
          <value>shiftEnd,System.String</value>
          <value>shiftStart2,System.String</value>
          <value>shiftEnd2,System.String</value>
          <value>totalDelays,System.String</value>
          <value>totalEarlyLeave,System.String</value>
          <value>totalOvertime,System.String</value>
          <value>totalActualWork,System.String</value>
          <value>totalVacationDays,System.Decimal</value>
          <value>totalAbsencesDays,System.Decimal</value>
          <value>isRotation,System.Boolean</value>
          <value>isRotationRest,System.Boolean</value>
          <value>id,System.Decimal</value>
          <value>name,System.String</value>
          <value>code,System.Decimal</value>
          <value>institutionId,System.Decimal</value>
          <value>institutionName,System.String</value>
          <value>institutionLogoFileId,System.Decimal</value>
          <value>branchId,System.Decimal</value>
          <value>branchName,System.String</value>
          <value>departmentId,System.Decimal</value>
          <value>departmentName,System.String</value>
          <value>positionId,System.Decimal</value>
          <value>positionName,System.String</value>
          <value>positionCategoryId,System.String</value>
          <value>positionCategoryName,System.String</value>
          <value>generalDepartmentId,System.Decimal</value>
          <value>generalDepartmentName,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>d16aac213530442ea057f14b811e078d</Key>
        <Name>days</Name>
        <NameInSource>JSON.days</NameInSource>
      </days>
      <employees Ref="4" type="DataTableSource" isKey="true">
        <Alias>employees</Alias>
        <Columns isList="true" count="10">
          <value>id,System.Decimal</value>
          <value>name,System.String</value>
          <value>code,System.Decimal</value>
          <value>photoFileId,System.String</value>
          <value>positionName,System.String</value>
          <value>departmentName,System.String</value>
          <value>branchName,System.String</value>
          <value>shiftName,System.String</value>
          <value>departmentId,System.Decimal</value>
          <value>locationsCount,System.Decimal</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>b7b6cdf13531490f915e8428d6cc6004</Key>
        <Name>employees</Name>
        <NameInSource>JSON.employees</NameInSource>
      </employees>
    </DataSources>
    <Relations isList="true" count="1">
      <Employees Ref="5" type="DataRelation" isKey="true">
        <Active>True</Active>
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>employeeId</value>
        </ChildColumns>
        <ChildSource isRef="3" />
        <Dictionary isRef="1" />
        <Key>cc4bff8b637b423db94a958174f3f2d5</Key>
        <Name>Employees</Name>
        <NameInSource>Relation</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>id</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Employees>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="3">
      <value>,apiUrl,apiUrl,,System.String,http:_x002F__x002F_localhost:44353,True,False,False,False,,_x0037_e496ac69726478a8bd39433eab114b6,True</value>
      <value>,From,From,,System.DateTime,,True,False,False,False,,,True</value>
      <value>,To,To,,System.DateTime,,True,False,False,False,,,True</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>1bf4753b082541ec87e141b27c14f9eb</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="6" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <CrossTab1 Ref="7" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
          <Brush>Transparent</Brush>
          <CanBreak>True</CanBreak>
          <ClientRectangle>0,1.4,19,2.6</ClientRectangle>
          <Components isList="true" count="16">
            <CrossTab1_RowTotal1 Ref="8" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0,1.7,1.6,0</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Enabled>False</Enabled>
              <Font>Arial,8</Font>
              <Guid>d4617b6cb4b045a38ec9ae67a34d3b1e</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal1>
            <CrossTab1_Row1_Title Ref="9" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0.45,0.8,1.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>f5581f52038a49ecb8ef7c028d5f106f</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1_Title</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>code</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row1</TypeOfComponent>
            </CrossTab1_Row1_Title>
            <CrossTab1_RowTotal2 Ref="10" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>0.8,1.7,0,0</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Enabled>False</Enabled>
              <Font>Arial,8</Font>
              <Guid>3d58ba77134d42028cd04aaa1b985665</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal2</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal2>
            <CrossTab1_Row2_Title Ref="11" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0.8,0.45,0.8,1.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>1d0074ff15f043e8b96cd29fd6fb78ac</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row2_Title</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>name</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row2</TypeOfComponent>
            </CrossTab1_Row2_Title>
            <CrossTab1_LeftTitle Ref="12" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,0,4,0.4</ClientRectangle>
              <Enabled>False</Enabled>
              <Font>Arial,8</Font>
              <Guid>91c9f6fe5ee9459da9ad3d15a5f0e614</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_LeftTitle</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>days</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>LeftTitle</TypeOfComponent>
            </CrossTab1_LeftTitle>
            <CrossTab1_ColTotal1 Ref="13" type="CrossColumnTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>4.05,0.85,0,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Enabled>False</Enabled>
              <Font>Arial,8</Font>
              <Guid>a264ef2cd6374f32b9a4d5d82a7cccf4</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_ColTotal1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_ColTotal1>
            <CrossTab1_ColTotal2 Ref="14" type="CrossColumnTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>3.25,1.25,0,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Enabled>False</Enabled>
              <Font>Arial,8</Font>
              <Guid>6e489e832279435b85c567af4822c1a3</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_ColTotal2</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_ColTotal2>
            <CrossTab1_RowTotal3 Ref="15" type="CrossRowTotal" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>1.6,2.3,2.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>bee13c233f1549f2bf924842cffad3f6</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RowTotal3</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
            </CrossTab1_RowTotal3>
            <CrossTab1_Row3_Title Ref="16" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>1.6,0.45,2.4,1.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>695d01a939ca4e909a004584b6d43702</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row3_Title</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>departmentName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>Row:CrossTab1_Row3</TypeOfComponent>
            </CrossTab1_Row3_Title>
            <CrossTab1_RightTitle Ref="17" type="CrossTitle" isKey="true">
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>4.05,0,2.8,0.4</ClientRectangle>
              <Font>Arial,8</Font>
              <Guid>06a6b0b212394b5699eff9caabbc895d</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_RightTitle</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>attDate, dayOfWeek</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TypeOfComponent>RightTitle</TypeOfComponent>
            </CrossTab1_RightTitle>
            <CrossTab1_Row1 Ref="18" type="CrossRow" isKey="true">
              <Alias>code</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0,1.9,0.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{days.Employees.code}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>229b21170aca49efa6a70653c039cf94</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>code</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>d4617b6cb4b045a38ec9ae67a34d3b1e</TotalGuid>
              <Value>{days.Employees.code}</Value>
            </CrossTab1_Row1>
            <CrossTab1_Row2 Ref="19" type="CrossRow" isKey="true">
              <Alias>name</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>0.8,1.9,0.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{days.Employees.name}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>f7796aa8232640e8a36a00be35916dc3</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row2</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Text>name</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>3d58ba77134d42028cd04aaa1b985665</TotalGuid>
              <Value>{days.Employees.name}</Value>
            </CrossTab1_Row2>
            <CrossTab1_Row3 Ref="20" type="CrossRow" isKey="true">
              <Alias>departmentName</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>1.6,1.9,2.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{days.Employees.departmentName}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>5530ff10426b442ebd3c5375f4d7ffde</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Row3</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>departmentName</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>bee13c233f1549f2bf924842cffad3f6</TotalGuid>
              <Value>{days.Employees.departmentName}</Value>
            </CrossTab1_Row3>
            <CrossTab1_Column1 Ref="21" type="CrossColumn" isKey="true">
              <Alias>attDate</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>4.05,0.45,2.8,1</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{days.attDate}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>b1e5491e55dc42d2bf5cf1917afa010a</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Column1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>attDate</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TextFormat Ref="22" type="DateFormat" isKey="true" />
              <TextOptions>,,,,,Angle=90</TextOptions>
              <TotalGuid>a264ef2cd6374f32b9a4d5d82a7cccf4</TotalGuid>
              <Value>{days.attDate}</Value>
            </CrossTab1_Column1>
            <CrossTab1_Column2 Ref="23" type="CrossColumn" isKey="true">
              <Alias>dayOfWeek</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>White</Brush>
              <ClientRectangle>4.05,1.45,2.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DisplayValue>{days.dayOfWeek}</DisplayValue>
              <Font>Arial,8</Font>
              <Guid>dfee77e37232452a98129afaa2821eb0</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Column2</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <ShowTotal>False</ShowTotal>
              <Text>dayOfWeek</Text>
              <TextBrush>[105:105:105]</TextBrush>
              <TotalGuid>6e489e832279435b85c567af4822c1a3</TotalGuid>
              <Value>{days.dayOfWeek}</Value>
            </CrossTab1_Column2>
            <CrossTab1_Sum1 Ref="24" type="CrossSummary" isKey="true">
              <Alias>delay</Alias>
              <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
              <Brush>[255:255:255]</Brush>
              <ClientRectangle>4.05,1.9,2.8,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>e586bfab8fd7400dbbd2ca4bf95aefc9</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>CrossTab1_Sum1</Name>
              <Page isRef="6" />
              <Parent isRef="7" />
              <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
              <Summary>None</Summary>
              <Text>0</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="25" type="TimeFormat" isKey="true" />
              <Value>{
IIF(days.isWorkingDay , "w", "n")
}</Value>
            </CrossTab1_Sum1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName />
          <DataSourceName>days</DataSourceName>
          <EmptyValue />
          <Filters isList="true" count="0" />
          <Name>CrossTab1</Name>
          <Page isRef="6" />
          <Parent isRef="6" />
          <Sort isList="true" count="0" />
        </CrossTab1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>fa79b6f2e687476ea321f36d91b124d3</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
    </Page1>
  </Pages>
  <ReferencedAssemblies isList="true" count="8">
    <value>System.Dll</value>
    <value>System.Drawing.Dll</value>
    <value>System.Windows.Forms.Dll</value>
    <value>System.Data.Dll</value>
    <value>System.Xml.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Base.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>9/16/2023 4:00:47 PM</ReportChanged>
  <ReportCreated>12/29/2022 2:41:02 PM</ReportCreated>
  <ReportFile>F:\Work\TimeAttendance\PrimoTime\api\Attendance\LogicSolutions.Attendance.WebAPI\Reports\crossdaysreport.mrt</ReportFile>
  <ReportGuid>950dec55665f4a6bac579512082b8661</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2020.4.1.0</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }

        #region StiReport Designer generated code - do not modify
		#endregion StiReport Designer generated code - do not modify
    }
}
</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>