﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="12/31/2022 12:21:32" ReportInfo.Modified="02/14/2023 15:12:46" 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
  {
   
    
  }
}


</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiLeyYgzGsg8K0w/wV+uVJpRb9DC+IFtFJ1Ya+wGL6sGP+LlGmWCsZftl80X1OZU2OLg7Xmxnkp41Wl7LrNJHJ83vvlYpsJ+6DtFdt82j1thRJJ4BPMOXXQ/VznxXbVK4wYXEfc/GT9jRWt/AYscmVrEJOp4AS6pfF/zabOfAeUxnPCFZuNTTYf/Anqida2Bnq4wWsjYQk+bW2BLfUXiq65uF50V779GQRASHenAhYUkWSzDbA55v76C9I5KXmHcVFOiKZ+crBw0xzYGCLy1zA+5u2EhK1ncHnju8fsDtQSCKHPF/gcZOsPDlVLbNE0mfQthSkUwe+rOWG2wRpE+KPod4Fcxq3gunpXyR6lKHmlhZCpEl+DhWx7PfMSbDazPY+COK+/qGCXHLZyacBrpvSmak7r6CzLPw4+h0pwFa+tzSii0Zv9DN8UEf7Wbq03UkBiyGMlaM3mpkAwbcbFlMcfoVkaKlOuSDBdv7Zmh9anZplloQRffHv2Tv2GkEp72wdqH/k4XVmDCpyw2JLs0oHt2xIq29iX3qXEUhQeNJBjOCsK4r0Uq7hFWmN6TQWZjgt+9RJ4Sj9QH//KpbUlNjzRg==">
      <TableDataSource Name="RepPosOrderStatus_Report" DataType="System.Int32" Enabled="true" TableName="RepPosOrderStatus_Report" SelectCommand="exec mnrPrcRepPosOrdStatus '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '1-1-2022' , '2-14-2023' , '1-1-2022  0:0:0','2-14-2023  23:59:0','{00000000-0000-0000-0000-000000000000}' ,3,0,'{00000000-0000-0000-0000-000000000000}' ,0 ,1 ,'{00000000-0000-0000-0000-000000000000}' , '{5B1F9CA5-11FC-42cf-B5FF-70D8449C3EF4}' , '{452D9B5F-1CC9-4407-B937-7ACB53469411}' , 0">
        <Column Name="MatID" DataType="System.Guid"/>
        <Column Name="MatCode" DataType="System.String"/>
        <Column Name="MatName" DataType="System.String"/>
        <Column Name="MatLaName" DataType="System.String"/>
        <Column Name="SellManID" DataType="System.Guid"/>
        <Column Name="smCode" DataType="System.String"/>
        <Column Name="smName" DataType="System.String"/>
        <Column Name="smLaName" DataType="System.String"/>
        <Column Name="StationID" DataType="System.Guid"/>
        <Column Name="StationName" DataType="System.String"/>
        <Column Name="OrderID" DataType="System.Guid"/>
        <Column Name="OrderType" DataType="System.Int32"/>
        <Column Name="OrderNumber" DataType="System.Int32"/>
        <Column Name="SeNumber" DataType="System.Int32"/>
        <Column Name="CreateTime" DataType="System.DateTime"/>
        <Column Name="DeliveryTime" DataType="System.DateTime"/>
        <Column Name="CurTime" DataType="System.Int32"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="Status" DataType="System.Int32"/>
        <Column Name="CustName" DataType="System.String"/>
        <Column Name="Qty" DataType="System.Double"/>
        <Column Name="Price" DataType="System.Double"/>
        <Column Name="Disc" DataType="System.Double"/>
        <Column Name="Extra" DataType="System.Double"/>
        <Column Name="Vat" DataType="System.Double"/>
        <Column Name="tPrice" DataType="System.Double"/>
        <Column Name="totalItem" DataType="System.Double"/>
        <Column Name="tDisc" DataType="System.Double"/>
        <Column Name="tExtra" DataType="System.Double"/>
        <Column Name="tVat" DataType="System.Double"/>
        <Column Name="Delete" DataType="System.Int32"/>
        <Column Name="UsersName" DataType="System.String"/>
        <Column Name="Bill1ID" DataType="System.Guid"/>
        <Column Name="Bonus" DataType="System.Double"/>
        <Column Name="OrderTypeID" DataType="System.Guid"/>
        <Column Name="OrderTypeName" DataType="System.String"/>
        <Column Name="OrderTypeLatinName" DataType="System.String"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{452D9B5F-1CC9-4407-B937-7ACB53469411}&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;01/01/2022&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;14/02/2023&quot;"/>
    <Parameter Name="FromTime" DataType="System.String" Expression="&quot;0:0:0&quot;"/>
    <Parameter Name="ToTime" DataType="System.String" Expression="&quot;23:59:0&quot;"/>
    <Parameter Name="SectorID" DataType="System.String" Expression="&quot;{00000000-0000-0000-0000-000000000000}&quot;"/>
    <Parameter Name="CurrName" DataType="System.String" Expression="&quot;دولار أمريكي&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" RawPaperSize="9" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="200.32">
      <PictureObject Name="Company_Logo" Left="3.34" Width="710.55" Height="94.49" Fill.Color="White" ImageLocation="C:\Program Files (x86)\Al-Manara Accounting\Bin\Res\Logo.bmp" SizeMode="CenterImage"/>
      <TextObject Name="Memo2" Left="653.86" Top="158.4" Width="60.47" Height="18.9" Text=":اعتبارا من" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo3" Left="518.27" Top="158.4" Width="143.62" Height="18.9" Text="[FromDate]   [FromTime]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt">
        <Formats>
          <DateFormat/>
          <GeneralFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Memo4" Left="469.47" Top="158.4" Width="41.57" Height="18.9" Text=":لغاية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="340.97" Top="158.4" Width="139.84" Height="18.9" Text="[ToDate]   [ToTime]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt">
        <Formats>
          <DateFormat/>
          <GeneralFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Memo6" Top="90.71" Width="718.11" Height="41.57" Text="مجموع الطلبات حسب نوع الطلب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Memo7" Left="117.16" Top="158.4" Width="41.57" Height="18.9" Text="العملة :" Padding="2, 1, 2, 1" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo8" Left="41.58" Top="158.4" Width="132.28" Height="18.9" Text="  [CurrName]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
    </ReportTitleBand>
    <DataBand Name="MasterData1" Top="204.32" Width="718.2" CanGrow="true" CanShrink="true" DataSource="RepPosOrderStatus_Report"/>
    <ReportSummaryBand Name="ReportSummary1" Top="208.32" Width="718.2" Height="95.6">
      <MatrixObject Name="Matrix1" Left="85.05" Width="369.48" Height="86.15" FixedRows="1" FixedColumns="1" AutoSize="false" CellsSideBySide="true" DataSource="RepPosOrderStatus_Report" Style="Blue">
        <MatrixColumns>
          <Header Expression="IIf([RepPosOrderStatus_Report.OrderTypeName]==&quot;&quot;,&quot;بدون&quot;,[RepPosOrderStatus_Report.OrderTypeName])"/>
        </MatrixColumns>
        <MatrixRows>
          <Header Expression="IIf([RepPosOrderStatus_Report.OrderType]==1,&quot;مغلق&quot;,IIf([RepPosOrderStatus_Report.OrderType]==0,&quot;مفتوح&quot;,IIf([RepPosOrderStatus_Report.OrderType]==2,&quot;ملغى&quot;,&quot;&quot;)))"/>
        </MatrixRows>
        <MatrixCells>
          <Cell Expression="[RepPosOrderStatus_Report.Qty]*[RepPosOrderStatus_Report.Price]"/>
        </MatrixCells>
        <TableColumn Name="Column1" Width="152.13"/>
        <TableColumn Name="Column2" Width="103.95"/>
        <TableColumn Name="Column3" Width="113.4"/>
        <TableRow Name="Row1" Height="29.45">
          <TableCell Name="Cell1" Border.Lines="All" Fill.Color="151, 189, 253" Text="نوع الطلب" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell2" Border.Lines="All" Fill.Color="151, 189, 253" Text="[IIf([RepPosOrderStatus_Report.OrderTypeName]==&quot;&quot;,&quot;بدون&quot;,[RepPosOrderStatus_Report.OrderTypeName])]" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell7" Border.Lines="All" Fill.Color="151, 189, 253" Text="المجموع" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
        </TableRow>
        <TableRow Name="Row2" Height="28.35">
          <TableCell Name="Cell3" Border.Lines="All" Fill.Color="192, 255, 192" Text="[IIf([RepPosOrderStatus_Report.OrderType]==1,&quot;مغلق&quot;,IIf([RepPosOrderStatus_Report.OrderType]==0,&quot;مفتوح&quot;,IIf([RepPosOrderStatus_Report.OrderType]==2,&quot;ملغى&quot;,&quot;&quot;)))]" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell4" Border.Lines="All" Text="[RepPosOrderStatus_Report.Qty]*[RepPosOrderStatus_Report.Price]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold">
            <Formats>
              <NumberFormat/>
              <GeneralFormat/>
            </Formats>
          </TableCell>
          <TableCell Name="Cell8" Border.Lines="All" Fill.Color="255, 255, 128" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        </TableRow>
        <TableRow Name="Row3" Height="28.35">
          <TableCell Name="Cell5" Border.Lines="All" Fill.Color="128, 255, 255" Text="المجموع" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold" TextFill.Color="Brown"/>
          <TableCell Name="Cell6" Border.Lines="All" Fill.Color="255, 192, 128" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell9" Border.Lines="All" Fill.Color="255, 192, 128" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        </TableRow>
      </MatrixObject>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="307.92" Width="718.2" Height="41.57">
      <TextObject Name="Memo1" Left="632.89" Width="75.59" Height="15.12" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo49" Left="100.83" 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"/>
      <TextObject Name="Memo50" Left="41.57" Width="56.69" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo51" Left="194.09" Width="33.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo52" Left="234.67" Width="56.69" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo57" Left="585.57" Top="26.42" Width="120.91" 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"/>
    </PageFooterBand>
  </ReportPage>
</Report>
