﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="01/29/2024 10:46:52" ReportInfo.Modified="01/29/2024 11:02:31" ReportInfo.CreatorVersion="2021.4.3.0">
  <ScriptText>using System;                       
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
    string GetHourMin (double hours )       
    {
      int h ;
      double m ;
      h = ToInt32(hours);
             
      m =  hours-h;        
      m = m * 60 ;  
      return ToString(h)+&quot;:&quot;+ToString(Round(m)) ;                                        
    }
  }
}
/*string GetHourMin (float hours )       
{
 int h ;
 float m ;
 h = int(hours);
             
 m =  hours-h;        
 m = m * 60 ;  
 return IntToStr(h)+&quot;:&quot;+floatToStr(round(m)) ;                                        
}
{
}                    
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiZhcXFATBChTemTMrfyZPbS7Z5DOED9FIewlGCNYJF9NMXkz7LGAvprNk4oaUPAYKypfBGdQJ2vt2VCk/7c2fQtdP/Bi2lmbgfNLo8HVNA55g5+aENf0MAveU2GYShTgZDnGKZKlJqYeumcoDDHhf/PKKdW6ncm7ZG+FmCZVySEa8g6XWufW8ISNtACXL6bXm5MPf0HI55d3rV5NEidb0LoY1RnEMl7xQD2d5TnidWSiTMPgOKIClPx7l7MMEzKzEsWVgtKLesHH/m32+YgqPhHO3ACbzLVEedGyZRSUrO8r7ZWzpMyEnJPmBuLdu6pyClI5Wmt/EqjQKtGhLSGH4Ic/9qqX6XWav+l0AZBcrfPVFuWtYtJBY1AwI210l0+s3vbNxIFv3XZTMFejbbPds/ltPVkvus9jHawjjfTl0rleo5zOGcWzIsKXI+4dRM2NaTEaZsajO70NsClO4cVireWz9yZWzZXfakX8dttfBsSVa1Lg3K5gFwOXv9mtnwDaOd2F7M1qEbEH2F9xEF1lTV0xjknWRDEyyFYZeGzTCwqVXg8pA0/JS7LYUh5JWpItDTp2V7OxjpTD+kHWZJmnpEx5uNIc8KIOl2ZMsWdEJ24TW5nJFw6VySskJd+bAzGM/HKPzYbawXWUMFpEZwia66Q==" CommandTimeout="1200">
      <TableDataSource Name="DailyWorkSummry_Report" DataType="System.Int32" Enabled="true" TableName="DailyWorkSummry_Report" SelectCommand="SELECT DATENAME(DW, Date) As DayDateName  , *  FROM mnrHrWorkItem WI INNER JOIN mnrHrWork W ON W.ID = WI.ParentID WHERE (W.Date BETWEEN '1-29-2024' AND '1-29-2024') AND WI.EmpID = '{B8A4D516-14CC-41F5-85CE-9A20BCEB0B68}' ORDER BY DATE">
        <Column Name="DayDateName" DataType="System.String"/>
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="EmpID" DataType="System.Guid"/>
        <Column Name="EmpCodeName" DataType="System.String"/>
        <Column Name="TSysID" DataType="System.Guid"/>
        <Column Name="Status" DataType="System.Int32"/>
        <Column Name="PeriodCnt" DataType="System.Int32"/>
        <Column Name="PeriodID" DataType="System.Guid"/>
        <Column Name="InID1" DataType="System.Guid"/>
        <Column Name="In1" DataType="System.DateTime"/>
        <Column Name="OutID1" DataType="System.Guid"/>
        <Column Name="Out1" DataType="System.DateTime"/>
        <Column Name="InID2" DataType="System.Guid"/>
        <Column Name="In2" DataType="System.DateTime"/>
        <Column Name="OutID2" DataType="System.Guid"/>
        <Column Name="Out2" DataType="System.DateTime"/>
        <Column Name="MovCnt" DataType="System.Int32"/>
        <Column Name="DueHours" DataType="System.Double"/>
        <Column Name="NetHours" DataType="System.Double"/>
        <Column Name="AbsHours" DataType="System.Double"/>
        <Column Name="AbsHoursType" DataType="System.Int32"/>
        <Column Name="SickAbsHours" DataType="System.Double"/>
        <Column Name="MissHour" DataType="System.Double"/>
        <Column Name="VacHour" DataType="System.Double"/>
        <Column Name="EAdd" DataType="System.Double"/>
        <Column Name="NAdd" DataType="System.Double"/>
        <Column Name="NAddType" DataType="System.Int32"/>
        <Column Name="Late" DataType="System.Double"/>
        <Column Name="LateValue" DataType="System.Double"/>
        <Column Name="LateRate" DataType="System.Double"/>
        <Column Name="EarExt" DataType="System.Double"/>
        <Column Name="EarExtValue" DataType="System.Double"/>
        <Column Name="EarExtRate" DataType="System.Double"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="SectorID" DataType="System.Guid"/>
        <Column Name="BranchID" DataType="System.Guid"/>
        <Column Name="ID1" DataType="System.Guid"/>
        <Column Name="Number1" DataType="System.Double"/>
        <Column Name="BranchID1" DataType="System.Guid"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="CDate" DataType="System.DateTime"/>
        <Column Name="UDate" DataType="System.DateTime"/>
        <Column Name="Notes1" DataType="System.String"/>
        <Column Name="IsPosted" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{46329CDF-FD98-41f2-AA26-1F5456A21552}&quot;"/>
    <Parameter Name="EmpName" DataType="System.String" Expression="&quot;1002-مزنة حجي البقمي&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;29/01/2024&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;29/01/2024&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="211.43">
      <TextObject Name="Memo32" Left="608.5" Top="173.96" Width="94.49" Height="18.9" Text=":التاريخ  اعتباراً من" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo33" Left="519.02" Top="173.96" Width="94.49" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo34" Left="468.66" Top="173.96" Width="37.8" Height="18.9" Text=":لغاية" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo35" Left="384.95" Top="173.96" Width="90.71" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo36" Left="608.5" Top="149.42" Width="94.49" Height="18.9" Text=":الموظف " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo37" Left="298.57" Top="149.42" Width="347.73" Height="18.9" Text="[DailyWorkSummry_Report.EmpCodeName]" Padding="2, 1, 2, 1" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo38" Top="116.05" Width="759.69" Height="22.68" Text="ملخص الدوام اليومي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Top="1" Width="718.11" Height="94.49" Fill.Color="White" ImageLocation="\\server\Manara Tools\2019.bmp" SizeMode="StretchImage"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="215.92" Width="718.2" Height="35.89">
      <TextObject Name="Memo2" Left="690.13" Top="0.89" Width="27.45" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="الرقم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo14" Top="0.89" Width="39.66" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="صافي الساعات" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo9" Left="211.68" Top="0.89" Width="44" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="خروج مبكر (د)" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo16" Left="454.22" Top="0.89" Width="58.69" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="دخول1" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo29" Left="399.75" Top="0.89" Width="56.69" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="خروج1" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo6" Left="349.69" Top="0.89" Width="50.9" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="إضافي مبكر(س)" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo7" Left="298.01" Top="0.89" Width="50.9" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="إضافي(س)" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo8" Left="255.68" Top="0.89" Width="42.33" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="تأخر(د)" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo10" Left="170.78" Top="0.89" Width="40.89" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="(س) الغياب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo11" Left="121.94" Top="0.89" Width="49.13" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="(س)&#13;&#10;غياب مرضي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo12" Left="80.37" Top="0.89" Width="41.57" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="ساعات مهمة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo13" Left="38.88" Top="0.89" Width="41.49" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="ساعات إجازة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo5" Left="513.69" Top="0.89" Width="59.2" Height="35" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Text="الحالة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo4" Left="573.46" Top="0.89" Width="46.78" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="اليوم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo3" Left="620.24" Top="0.89" Width="70.33" Height="35" Border.Lines="All" Fill.Color="186, 211, 254" Text="التاريخ" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="MasterData1" Top="256.31" Width="718.2" Height="28.84" DataSource="DailyWorkSummry_Report">
      <TextObject Name="Memo17" Left="690.13" Width="27.45" Height="28.84" Border.Lines="Right, Bottom" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo18" Left="620.24" Width="70.33" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[DailyWorkSummry_Report.Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo19" Left="573.46" Width="46.78" Height="28.84" Border.Lines="Left, Right, Bottom" Text=" [IIf(DayOfWeek([DailyWorkSummry_Report.Date])==&quot;1&quot;,&quot;الأحد&quot;,IIf(DayOfWeek([DailyWorkSummry_Report.Date])==&quot;2&quot;,&quot;الإثنين&quot;,IIf(DayOfWeek([DailyWorkSummry_Report.Date])==&quot;3&quot;,&quot;الثلاثاء&quot;,IIf(DayOfWeek([DailyWorkSummry_Report.Date])==&quot;4&quot;,&quot;الأربعاء&quot;,IIf(DayOfWeek([DailyWorkSummry_Report.Date])==&quot;5&quot;,&quot;الخميس&quot;,IIf(DayOfWeek([DailyWorkSummry_Report.Date])==&quot;6&quot;,&quot;الجمعة&quot;,IIf(DayOfWeek([DailyWorkSummry_Report.Date])==&quot;7&quot;,&quot;السبت&quot;,&quot;&quot;)))))))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo20" Left="513.69" Width="59.2" Height="28.84" Border.Lines="Right, Bottom" Text="[IIf([DailyWorkSummry_Report.Status]==0,&quot;غياب غير مبرر&quot;,IIf([DailyWorkSummry_Report.Status]==1,&quot;غياب مبرر&quot;,IIf([DailyWorkSummry_Report.Status]==2,&quot;غياب مرضي&quot;,IIf([DailyWorkSummry_Report.Status]==3,&quot;حضور&quot;,IIf([DailyWorkSummry_Report.Status]==4,&quot;عطلة أسبوعية&quot;,IIf([DailyWorkSummry_Report.Status]==5,&quot;عطلة رسمية&quot;,IIf([DailyWorkSummry_Report.Status]==6,&quot;مهمة&quot;,IIf([DailyWorkSummry_Report.Status]==7,&quot;إجازة&quot;,&quot;&quot;))))))))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo21" Left="349.69" Width="50.9" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.EAdd]==0,null,GetHourMin([DailyWorkSummry_Report.EAdd]))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo22" Left="298.01" Width="50.9" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.NAdd]==0,null, GetHourMin([DailyWorkSummry_Report.NAdd]))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo23" Left="255.68" Width="42.33" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.Late]==0,null,[DailyWorkSummry_Report.Late])]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo24" Left="211.68" Width="44" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.EarExt]==0,null,[DailyWorkSummry_Report.EarExt])]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo25" Left="171.08" Width="40.6" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.AbsHours]==0,null,GetHourMin([DailyWorkSummry_Report.AbsHours]))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo26" Left="121.94" Width="49.13" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.SickAbsHours]==0,null,GetHourMin([DailyWorkSummry_Report.SickAbsHours]))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo27" Left="80.37" Width="41.57" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.MissHour]==0,null,GetHourMin([DailyWorkSummry_Report.MissHour]))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo28" Left="38.88" Width="41.49" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.VacHour]==0,&quot;&quot;,GetHourMin([DailyWorkSummry_Report.VacHour]))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo15" Width="39.66" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.NetHours]==0,&quot;&quot;,GetHourMin([DailyWorkSummry_Report.NetHours]))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo44" Left="456.22" Width="56.69" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.In1]==ToDateTime(&quot;1/1/1980&quot;),&quot;&quot;,[DailyWorkSummry_Report.In1])]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
      <TextObject Name="Memo45" Left="399.75" Width="56.69" Height="28.84" Border.Lines="Left, Right, Bottom" Text="[IIf([DailyWorkSummry_Report.Out1]==ToDateTime(&quot;1/1/1980&quot;),&quot;&quot;,[DailyWorkSummry_Report.Out1])]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
    </DataBand>
    <PageFooterBand Name="PageFooter1" Top="289.64" Width="718.2" Height="45.35">
      <TextObject Name="Memo1" Left="37.88" Width="83.15" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo39" Left="3.24" Width="56.69" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo40" Left="135.09" Width="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo42" Left="589.7" Top="26.42" Width="119.02" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Memo43" Left="632.59" Width="75.59" Height="15.12" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text1" Left="170.1" Width="83.15" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
    </PageFooterBand>
  </ReportPage>
</Report>
