﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="01/22/2024 15:38:54" ReportInfo.Modified="02/05/2024 13:24:52" 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
  {
    

    private void _StartReport(object sender, EventArgs e)
    {
      if( ((Double)Report.GetColumnValue(&quot;OpExtra_Report.Value&quot;)) ==0)
             Memo37.Visible=false;
      if(((Double)Report.GetColumnValue(&quot;OpExtra_Report.Rate&quot;)) ==0)
           Memo39.Visible=false;
        if(((Double)Report.GetColumnValue(&quot;OpExtra_Report.DayCount&quot;))==0)
           Memo41.Visible=false;  
      
    }
  }
}
/*void Page1OnBeforePrint(TfrxComponent Sender)
{
  if((&lt;OpExtra_Report.&quot;Value&quot;&gt;) == 0)                      
   { 
    Memo37.visible=false;                 
   }
}    
void Memo39OnBeforePrint(TfrxComponent Sender)
{
   if((&lt;OpExtra_Report.&quot;Rate&quot;&gt;) == 0)                      
   { 
    Memo39.visible=false;      
   }  
}

void Memo41OnBeforePrint(TfrxComponent Sender)
{
     if((&lt;OpExtra_Report.&quot;DayCount&quot;&gt;) == 0)                      
   { 
    Memo41.visible=false;      
   }  
}
void Memo43OnBeforePrint(TfrxComponent Sender)
{
 if((&lt;OpExtra_Report.&quot;Rate&quot;&gt;) == 0)                      
   { 
    Memo43.visible=false;      
   }  
}

void Memo45OnBeforePrint(TfrxComponent Sender)
{
  if((&lt;OpExtra_Report.&quot;DayCount&quot;&gt;) == 0)                      
   { 
    Memo45.visible=false;      
   }  
}

void Memo46OnAfterPrint(TfrxComponent Sender)
{
 if((&lt;OpExtra_Report.&quot;DayCount&quot;&gt;) == 0)                      
   { 
    Memo46.visible=false;      
   }  
}

void Memo44OnAfterPrint(TfrxComponent Sender)
{
 if((&lt;OpExtra_Report.&quot;Rate&quot;&gt;) == 0)                      
   { 
    Memo44.visible=false;      
   }  
}
  
{

}
*/</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/kvHSO/3l4MuSAkGoZLzXxA==" CommandTimeout="1200">
      <TableDataSource Name="OpExtra_Report" DataType="System.Int32" Enabled="true" TableName="OpExtra_Report" SelectCommand=" SELECT E.EmpCode , E.EmpFullName , E.EmpLFullName , C.Name  AS CName, C.LatinName AS CLName ,   O.*   FROM 	mnrHrOpExtDisc	O   INNER JOIN mnrHrVWEmployee	E	ON E.EmpID	= O.ParentID     INNER JOIN mnrCurrency		C	ON C.ID		= O.CurrencyID   WHERE  O.ID ='{8F238D4B-291F-497a-B2A1-B7A11EAC81C8}'">
        <Column Name="EmpCode" DataType="System.String"/>
        <Column Name="EmpFullName" DataType="System.String"/>
        <Column Name="EmpLFullName" DataType="System.String"/>
        <Column Name="CName" DataType="System.String"/>
        <Column Name="CLName" DataType="System.String"/>
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="DiscTypeID" DataType="System.Guid"/>
        <Column Name="EntryID" DataType="System.Guid"/>
        <Column Name="InNum" DataType="System.String"/>
        <Column Name="Value" DataType="System.Double"/>
        <Column Name="Rate" DataType="System.Double"/>
        <Column Name="DayCount" DataType="System.Double"/>
        <Column Name="BSalary" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="SpeSalary" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="SpareSalary" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="SalaryType" DataType="System.Int32"/>
        <Column Name="CurrencyID" DataType="System.Guid"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="DueDate" DataType="System.DateTime"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="CDate" DataType="System.DateTime"/>
        <Column Name="UDate" DataType="System.DateTime"/>
        <Column Name="IsPosted" DataType="System.Int32"/>
        <Column Name="SectorID" DataType="System.Guid"/>
      </TableDataSource>
      <TableDataSource Name="Table" Alias="ADOQuery1" DataType="System.Int32" Enabled="true" SelectCommand=" select S.Name ,s.Code, S.FName , S.FamName , S.LatinName , S.LFName , S.LFamName&#13;&#10;FROM &#13;&#10; mnrHrEmployee E&#13;&#10;INNER JOIN mnrHrEmployee S ON E.SupervisorID = S.ID &#13;&#10; where E.ID = @ID">
        <Column Name="Name" DataType="System.String"/>
        <Column Name="Code" DataType="System.String"/>
        <Column Name="FName" DataType="System.String"/>
        <Column Name="FamName" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="LFName" DataType="System.String"/>
        <Column Name="LFamName" DataType="System.String"/>
        <CommandParameter Name="ID" DataType="14" Expression="[OpExtra_Report.ParentID]" DefaultValue="00000000-0000-0000-0000-000000000000"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{46329CDF-FD98-41f2-AA26-1F5456A21552}&quot;"/>
    <Parameter Name="CurrencyName" DataType="System.String" Expression="&quot;&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" RawPaperSize="9" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle2" Width="718.2" Height="200.32">
      <TextObject Name="Memo11" Left="7.56" Top="104.61" Width="706.77" Height="26.46" Text="الترفيعات" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Memo21" Left="105.83" Top="154.4" Width="69.92" Height="18.9" Text=":العملة" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo22" Left="43.47" Top="154.4" Width="86.93" Height="18.9" Text="[OpExtra_Report.CName]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <PictureObject Name="COMPANY_LOGO" Left="25.68" Top="3.78" Width="657.63" Height="98.27" Fill.Color="White" SizeMode="StretchImage"/>
    </ReportTitleBand>
    <ReportSummaryBand Name="ReportSummary1" Top="204.81" Width="718.2" Height="682.76">
      <TextObject Name="Memo24" Left="568.61" Top="149.61" Width="94.49" Height="18.9" Text=": الرقم الداخلي " Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo25" Left="445.1" Top="149.61" Width="124.72" Height="18.9" Text="[OpExtra_Report.InNum]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo26" Left="270.14" Top="149.4" Width="94.49" Height="18.9" Text=": اسم الموظف" Padding="2, 1, 2, 1" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo28" Left="33.25" Top="149.4" Width="238.11" Height="18.9" Text="[OpExtra_Report.EmpCode] - [OpExtra_Report.EmpFullName]" Padding="2, 1, 2, 1" RightToLeft="true" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo29" Left="568.61" Top="226.42" Width="94.49" Height="18.9" Text=": اسم المشرف" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo33" Left="562.59" Top="38.59" Width="98.27" Height="18.9" Text=": تاريخ العملية" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo34" Left="411.21" Top="38.59" Width="154.96" Height="18.9" Text="[OpExtra_Report.Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo35" Left="562.59" Top="68.83" Width="98.27" Height="18.9" Text=": تاريخ الإستحقاق" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo36" Left="411.21" Top="68.83" Width="151.18" Height="18.9" Text="[OpExtra_Report.DueDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo37" Left="464.66" Top="184.94" Width="94.49" Height="18.9" Text=": قيمة" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo38" Left="439.44" Top="184.17" Width="83.14" Height="18.9" Text="[IIf([OpExtra_Report.Value]==0,&quot;&quot;,[OpExtra_Report.Value]/[OpExtra_Report.CurrencyVal])]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo39" Left="568.61" Top="184.17" Width="94.49" Height="18.9" Text=": النسبة" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo40" Left="539.6" Top="186.15" Width="68.03" Height="18.9" Text="[IIf([OpExtra_Report.Rate]==0,&quot;&quot;,&quot;%&quot;)][IIf([OpExtra_Report.Rate]==0,&quot;&quot;,[OpExtra_Report.Rate])]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo41" Left="332.36" Top="184.84" Width="94.49" Height="18.9" Text=": عدد الأيام" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo42" Left="293.9" Top="186.64" Width="68.03" Height="18.9" Text="[IIf([OpExtra_Report.DayCount]==0,&quot;&quot;,[OpExtra_Report.DayCount])]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo44" Left="51.05" Top="184.84" Width="143.62" Height="18.9" Text="[IIf([OpExtra_Report.SalaryType]==-1,&quot;راتب أساسي&quot;,IIf([OpExtra_Report.SalaryType]==1,&quot;راتب مقطوع&quot;,&quot;راتب احتياطي&quot;))]&#13;&#10;" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo45" Left="196.17" Top="184.84" Width="94.49" Height="18.9" Text=": حسب راتب" Padding="2, 1, 2, 1" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo3" Left="606.3" Top="271.63" Width="79.37" Height="18.9" Text=": الملاحظات" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo4" Left="65.04" Top="311.32" Width="604.72" Height="68.03" CanGrow="true" CanShrink="true" Text="[OpExtra_Report.Notes]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 12pt"/>
      <TextObject Name="Memo6" Left="312.82" Top="226.42" Width="257.01" Height="18.9" Text="[ADOQuery1.Code] [IIf([ADOQuery1.Name]==&quot;&quot;,&quot;&quot;,&quot;-&quot;)] [ADOQuery1.Name] [ADOQuery1.FName][ADOQuery1.FamName]" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 12pt"/>
      <LineObject Name="Line2" Left="26.46" Top="15.34" Height="94.49" Diagonal="true"/>
      <LineObject Name="Line3" Left="26.46" Top="108.5" Width="665.2" Diagonal="true"/>
      <LineObject Name="Line4" Left="691.65" Top="15.02" Height="94.49" Diagonal="true"/>
      <LineObject Name="Line5" Left="26.46" Top="15.02" Width="597.17" Diagonal="true"/>
      <LineObject Name="Line6" Left="27.13" Top="131.47" Height="124.72" Diagonal="true"/>
      <LineObject Name="Line7" Left="27.13" Top="256.67" Width="665.2" Diagonal="true"/>
      <LineObject Name="Line8" Left="691.33" Top="131.15" Height="124.72" Diagonal="true"/>
      <LineObject Name="Line9" Left="27.13" Top="131.15" Width="559.37" Diagonal="true"/>
      <LineObject Name="Line10" Left="27.13" Top="281.33" Height="94.49" Diagonal="true"/>
      <LineObject Name="Line11" Left="27.13" Top="375.53" Width="665.2" Diagonal="true"/>
      <LineObject Name="Line12" Left="691.33" Top="281.01" Height="94.49" Diagonal="true"/>
      <LineObject Name="Line13" Left="27.13" Top="281.01" Width="582.05" Diagonal="true"/>
      <TextObject Name="Memo7" Left="585.83" Top="120.84" Width="105.83" Height="18.9" Text="معلومات الترفيعة" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 12pt, style=Bold"/>
      <TextObject Name="Memo8" Left="627.4" Top="3.68" Width="64.25" Height="22.68" Text="التاريخ" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 12pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="892.07" Width="718.2" Height="46.5">
      <TextObject Name="Memo140" Left="66.81" Top="10" Width="83.15" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo141" Left="7.56" Top="10" Width="56.69" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo142" Left="156.3" Top="10" Width="39.69" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo5" Left="631.18" Top="7.56" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo2" Left="570.71" Top="30.24" Width="136.07" Height="15.12" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Text1" Left="198.45" Top="10" 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>
