﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="08/09/2022 13:53:06" ReportInfo.Modified="10/11/2024 07:47:40" 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="rijcmlqKjSU40dlxFMmorDfgW0xWghLfHh9It0YM419tI3EqnDwCQRhxmoCe6bhrhjTzx2Y0F0RTONUmYAGZ6dlXfrK+aaLoV3VCX81Ee/g9bTWGPLv0zbl5s2dOBVHvBKLS+Kdw1xelblGqTVepGfVY2zk+Y23WFm9hnxIT4nk8bJ+3+/0bRvr5TEDiVcIhN2qBJ2H8kT5g8c4LUiFC0IebojO5zuiQ2q0itFGH/zR/n6SlQtPw9EmA4j0TqdPVc9CViU3FoctYq33BMJQr4mApyOEZ+zUiLVrRGdC7IRe0Jv23xeB93phov6pBgoAlZNWXpXsRd9fMEEJOacMxba5FGFjr8jxfWrbJaNhePfuIFafSNbtCAF11VXnFztmtzGgVgjlrc3/FiyfRscPkj4cTi4T3oasx79+c1RzHxwxMJUp0TJNDAN3Ficp31azRHBAcCqjvLVuYrEnxQt5HqAGZBmk/tjwQ63TdEYRP4wlGCpJJU26TReRvv8+4CarkbUL8RH1c4bJxd04gXyCmhGxv/0FUbVK/PD02VwwOnxt+GdcdenQyeyM8udqi6L+58IcEYWczclyTb2JVkTVD9r6zY7NDDr1HuZQJCJ7UwhVIiwKHZ9ZfND153yfv5eo/CjltDnhvL0ntRfk+7Jnsc4Zs7/pphij4HYnZ8t+jczZl+B4rNRswSLFy96CK27twewF1MneRrImWiat1PmxgfP8lU6l4w==" CommandTimeout="1200">
      <TableDataSource Name="BillMove_Report" DataType="System.Int32" Enabled="true" TableName="BillMove_Report" SelectCommand="exec mnrPrcRepBillMove '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '' , '' , '{71F39711-6E44-483e-A3EE-CC9A2F35BF6F}' , '{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}' , '12-31-2023' , '10-11-2024' , 1 , 0 , 1 , 1 , 0, '', '', 0.000, 0.000, 0.000, 0.000, -1,0.000,1, 0 , 0 , 0, '{00000000-0000-0000-0000-000000000000}','{00000000-0000-0000-0000-000000000000}',0,0,'12-31-2023 0:0:0','10-11-2024 0:0:0',0,0,'' , 0">
        <Column Name="BT_ID" DataType="System.Guid"/>
        <Column Name="BT_Code" DataType="System.String"/>
        <Column Name="BT_Name" DataType="System.String"/>
        <Column Name="BT_LaName" DataType="System.String"/>
        <Column Name="BT_Type" DataType="System.Int32"/>
        <Column Name="B_ID" DataType="System.Guid"/>
        <Column Name="B_Number" DataType="System.Double"/>
        <Column Name="B_Notes" DataType="System.String"/>
        <Column Name="B_Vendor" DataType="System.String"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="AccID" DataType="System.Guid"/>
        <Column Name="accCode" DataType="System.String"/>
        <Column Name="accName" DataType="System.String"/>
        <Column Name="accLaName" DataType="System.String"/>
        <Column Name="CustID" DataType="System.Guid"/>
        <Column Name="CostID" DataType="System.Guid"/>
        <Column Name="coCode" DataType="System.String"/>
        <Column Name="coName" DataType="System.String"/>
        <Column Name="coLaName" DataType="System.String"/>
        <Column Name="SalesManID" DataType="System.Guid"/>
        <Column Name="smCode" DataType="System.String"/>
        <Column Name="smName" DataType="System.String"/>
        <Column Name="smLaName" DataType="System.String"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="stCode" DataType="System.String"/>
        <Column Name="stName" DataType="System.String"/>
        <Column Name="stLaName" DataType="System.String"/>
        <Column Name="BrID" DataType="System.Guid"/>
        <Column Name="BrCode" DataType="System.String"/>
        <Column Name="BrName" DataType="System.String"/>
        <Column Name="BrLaName" DataType="System.String"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="UserName" DataType="System.String"/>
        <Column Name="UserLaName" DataType="System.String"/>
        <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="Qty" DataType="System.Double"/>
        <Column Name="PayType" DataType="System.Int32"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="OrderFld" DataType="System.Int32"/>
        <Column Name="CheckItem" DataType="System.Int32"/>
        <Column Name="BtermType" DataType="System.Int32"/>
        <Column Name="MaturityDate" DataType="System.DateTime"/>
        <Column Name="BonusQty" DataType="System.Double"/>
        <Column Name="BonusValue" DataType="System.Double"/>
        <Column Name="Str1" DataType="System.String"/>
        <Column Name="Str2" DataType="System.String"/>
        <Column Name="Str3" DataType="System.String"/>
        <Column Name="Str4" DataType="System.String"/>
        <Column Name="Str5" DataType="System.String"/>
        <Column Name="Str6" DataType="System.String"/>
        <Column Name="Date1" DataType="System.DateTime"/>
        <Column Name="Date2" DataType="System.DateTime"/>
        <Column Name="Date3" DataType="System.DateTime"/>
        <Column Name="Vat1" DataType="System.Double"/>
        <Column Name="Vat2" DataType="System.Double"/>
        <Column Name="Vat3" DataType="System.Double"/>
        <Column Name="VatType" DataType="System.Int32"/>
        <Column Name="bCheck" DataType="System.Int32"/>
        <Column Name="DateIn" DataType="System.DateTime"/>
        <Column Name="BillOrigin" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="PaymentMethods" DataType="System.Int32" Enabled="true" TableName="PaymentMethods" SelectCommand="exec mnrFrxPaymentMethod '12-31-2023' , '10-11-2024' , '{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}' , '{71F39711-6E44-483e-A3EE-CC9A2F35BF6F}' , 0 , '{00000000-0000-0000-0000-000000000000}'">
        <Column Name="BillID" DataType="System.Guid"/>
        <Column Name="BNumber" DataType="System.Int32"/>
        <Column Name="BDate" DataType="System.DateTime"/>
        <Column Name="BTotal" DataType="System.Double"/>
        <Column Name="BFixTotal" DataType="System.Double"/>
        <Column Name="BTotalItem" DataType="System.Double"/>
        <Column Name="BFixTotalItem" DataType="System.Double"/>
        <Column Name="BtID" DataType="System.Guid"/>
        <Column Name="BtCode" DataType="System.String"/>
        <Column Name="BtName" DataType="System.String"/>
        <Column Name="BtLaName" DataType="System.String"/>
        <Column Name="BType" DataType="System.Int32"/>
        <Column Name="PayTypeID" DataType="System.Guid"/>
        <Column Name="PayVal" DataType="System.Double"/>
        <Column Name="FixPayVal" DataType="System.Double"/>
        <Column Name="InOut" DataType="System.Int32"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="UserNumber" DataType="System.Double"/>
        <Column Name="UserName" DataType="System.String"/>
        <Column Name="PayType" DataType="System.Int32"/>
        <Column Name="MethodName" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="BillTypePaymentMethods" DataType="System.Int32" Enabled="true" TableName="BillTypePaymentMethods" SelectCommand="exec mnrFrxBillTypePaymentMethod '12-31-2023' , '10-11-2024' , '{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}' , '{71F39711-6E44-483e-A3EE-CC9A2F35BF6F}' , 0 , '{00000000-0000-0000-0000-000000000000}'">
        <Column Name="BtID" DataType="System.Guid"/>
        <Column Name="BtNumber" DataType="System.Double"/>
        <Column Name="BtName" DataType="System.String"/>
        <Column Name="BtLaName" DataType="System.String"/>
        <Column Name="PayTypeID" DataType="System.Guid"/>
        <Column Name="PayVal" DataType="System.Double"/>
        <Column Name="FixPayVal" DataType="System.Double"/>
        <Column Name="MethodName" DataType="System.String"/>
        <Column Name="InOut" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;31/12/2023&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;11/10/2024&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{6CCA4800-C4E7-4c35-A2D8-FC4F74F6199B}&quot;"/>
    <Parameter Name="Currency" DataType="System.String" Expression="&quot;ليرة سورية&quot;"/>
    <Parameter Name="CurrencyID" DataType="System.String" Expression="&quot;{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}&quot;"/>
    <Parameter Name="ShowDiscExtra" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="SmName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="StoreName" DataType="System.String" Expression="&quot;&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="215.43">
      <PictureObject Name="Company_Logo" Left="4.84" Top="0.56" Width="708.43" Height="147.4" Fill.Color="White" ImageLocation="C:\Program Files (x86)\Almanara Business Solutions\Bin\Res\Logo.bmp" SizeMode="StretchImage" ImageFormat="Bmp"/>
      <TextObject Name="Memo17" Left="639.64" Top="185.2" Width="75.59" Height="18.9" Text=": إعتباراً من" Padding="2, 1, 2, 1" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo18" Left="564.07" Top="185.2" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo25" Left="510.25" Top="185.2" Width="51.02" Height="18.9" Text=": ولغاية " Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo27" Left="428.22" Top="185.2" Width="79.37" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo1" Left="4.76" Top="185.2" Width="162.52" Height="18.9" Text=" [Currency] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo2" Left="166.3" Top="185.2" Width="51.02" Height="18.9" Text=": العملة " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo3" Left="20.79" Top="136.84" Width="676.54" Height="26.46" Text="حركة الفواتير حسب المستخدم وطريقة الدفع" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 16pt, style=Bold"/>
    </ReportTitleBand>
    <DataBand Name="MasterData1" Top="219.43" Width="718.2" CanGrow="true" CanShrink="true" CanBreak="true" DataSource="PaymentMethods"/>
    <DataBand Name="MasterData2" Top="223.43" Width="718.2" CanGrow="true" CanShrink="true" CanBreak="true" DataSource="BillTypePaymentMethods"/>
    <ReportSummaryBand Name="ReportSummary1" Top="227.43" Width="718.2" Height="87.03" Guides="75.6">
      <MatrixObject Name="Matrix3" Left="12.35" Top="5" Width="294.73" Height="70.6" FixedRows="1" FixedColumns="1" AutoSize="false" DataSource="PaymentMethods">
        <MatrixColumns>
          <Header Expression="[PaymentMethods.MethodName]"/>
        </MatrixColumns>
        <MatrixRows>
          <Header Expression="[PaymentMethods.UserName]"/>
        </MatrixRows>
        <MatrixCells>
          <Cell Expression="ToDouble(IIf([PaymentMethods.InOut]==-1,[PaymentMethods.FixPayVal],0))-ToDouble(IIf([PaymentMethods.InOut]==1,[PaymentMethods.FixPayVal],0))"/>
        </MatrixCells>
        <TableColumn Name="Column6" Width="86.52"/>
        <TableColumn Name="Column7" Width="118.71"/>
        <TableColumn Name="Column8" Width="89.5"/>
        <TableRow Name="Row6" Height="20">
          <TableCell Name="Cell13" Border.Lines="All" Fill.Color="151, 189, 253" Text="اسم المستخدم" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell14" Border.Lines="All" Fill.Color="151, 189, 253" Text="[MethodName]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell19" Border.Lines="All" Fill.Color="151, 189, 253" Text="Total" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        </TableRow>
        <TableRow Name="Row7" Height="30.6">
          <TableCell Name="Cell15" Border.Lines="All" Fill.Color="151, 189, 253" Text="[UserName]" HorzAlign="Center" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
          <TableCell Name="Cell16" Border.Lines="All" Text="[ToDouble(IIf([PaymentMethods.InOut]==-1,[PaymentMethods.FixPayVal],0))-ToDouble(IIf([PaymentMethods.InOut]==1,[PaymentMethods.FixPayVal],0))]" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt" TabWidth="20" Wysiwyg="true"/>
          <TableCell Name="Cell20" Border.Lines="All" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
        </TableRow>
        <TableRow Name="Row8" Height="20">
          <TableCell Name="Cell17" Border.Lines="All" Fill.Color="DarkRed" Text="الاجمالي" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold" TextFill.Color="White" TabWidth="70"/>
          <TableCell Name="Cell18" Border.Lines="All" Fill.Color="DarkRed" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt" TextFill.Color="White"/>
          <TableCell Name="Cell21" Border.Lines="All" Fill.Color="DarkRed" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Arial, 8pt"/>
        </TableRow>
      </MatrixObject>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="318.46" Width="718.2" Height="41.57">
      <TextObject Name="Memo6" Left="637.36" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo21" Left="63.03" 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="Memo28" Left="3.78" 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="Memo29" Left="152.52" Width="39.69" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo30" Left="204.44" 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, style=Bold"/>
      <TextObject Name="Memo24" Left="592.04" Top="26.05" Width="120.91" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
