﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" DoublePass="true" StartReportEvent="_StartReport" ReportInfo.Created="09/27/2013 16:01:23" ReportInfo.Modified="08/07/2015 11:47:17" ReportInfo.CreatorVersion="1.6.57.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)
    {
      //Style      
      string stylePath = Report.GetParameterValue(&quot;MainAppPath&quot;).ToString() + &quot;\\Resources\\DocStyles\\Styles\\&quot; +
        Report.GetColumnValue(&quot;companies.InvoiceStylePath&quot;).ToString();
      if (stylePath.Length &gt; 0)
      {
        picStyle.ImageLocation = stylePath;
      }
                  
      //Logo
      string logoPath = Report.GetColumnValue(&quot;companies.LogoPath&quot;).ToString();
      if (logoPath.Length &gt; 0)
      {         
        picLogo.ImageLocation = Report.GetParameterValue(&quot;MainAppPath&quot;).ToString() + &quot;\\Resources\\Logos\\&quot; + logoPath;
        picLogo.Printable = true; 
      }
      else
      {
        picLogo.Printable = false;
      }
    }

   
    private void PageHeader1_AfterData(object sender, EventArgs e)
    {
      //Print the User
      if (Report.GetColumnValue(&quot;trans.User&quot;).ToString().Length == 0)
      {
        lblUser.Visible = false;
        txtUser.Visible = false;  
      }
    }
    
    
    
  }
}
</ScriptText>
  <Dictionary>
    <MySqlDataConnection Name="Connection" ConnectionString="rijcmlqvHU7gJfSuBQWLYh0DOGH3+Qi6ukYxcxpZPbTzhS1gWY2znM045239pVyhdFvZLSh9rUUZxOR6xchBWStN/gwd5iV5mn8ZJ4OE3NSWudQES8=">
      <TableDataSource Name="suppliers" DataType="System.Int32" PropName="clients" Enabled="true" TableName="suppliers" SelectCommand="SELECT * FROM suppliers">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="Email" DataType="System.String"/>
        <Column Name="BillingAddress" DataType="System.String"/>
        <Column Name="ContactNo" DataType="System.String"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="TotalDue" DataType="System.Decimal"/>
        <Column Name="LastJournalDate" DataType="System.DateTime"/>
        <Column Name="SupplierID" DataType="System.UInt32"/>
        <Column Name="BankingDetails" DataType="System.String"/>
        <Column Name="TaxOnInvoice" DataType="System.String"/>
        <Column Name="LastCashPurchaseDate" DataType="System.DateTime"/>
        <Column Name="LastCashPurchaseReturnDate" DataType="System.DateTime"/>
        <Column Name="LastAccountPurchaseDate" DataType="System.DateTime"/>
        <Column Name="LastDebitNoteDate" DataType="System.DateTime"/>
        <Column Name="LastPaymentDate" DataType="System.DateTime"/>
      </TableDataSource>
      <TableDataSource Name="companies" DataType="System.Int32" Enabled="true" TableName="companies" SelectCommand="select * from companies where ID = 4">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="Email" DataType="System.String"/>
        <Column Name="Address" DataType="System.String"/>
        <Column Name="RegNo" DataType="System.String"/>
        <Column Name="VATno" DataType="System.String"/>
        <Column Name="ContactNo" DataType="System.String"/>
        <Column Name="AltNo" DataType="System.String"/>
        <Column Name="FaxNo" DataType="System.String"/>
        <Column Name="CellNo" DataType="System.String"/>
        <Column Name="LogoPath" DataType="System.String"/>
        <Column Name="InvoiceStylePath" DataType="System.String"/>
        <Column Name="InvoiceSize" DataType="System.String"/>
        <Column Name="VATrate" DataType="System.String"/>
        <Column Name="BankingDetails" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="programs_config" DataType="System.Int32" Enabled="true" TableName="programs_config">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="SalesReps" DataType="System.String"/>
        <Column Name="PaymentMethods" DataType="System.String"/>
        <Column Name="InvSlipNote" DataType="System.String"/>
        <Column Name="InvCustomLabel1" DataType="System.String"/>
        <Column Name="InvCustomLabel2" DataType="System.String"/>
        <Column Name="InvCustomLabel3" DataType="System.String"/>
        <Column Name="InvCustomLabel4" DataType="System.String"/>
        <Column Name="InvCustomLabel5" DataType="System.String"/>
        <Column Name="InvCustomLabel6" DataType="System.String"/>
        <Column Name="InvShowRetailPriceExcl" DataType="System.Byte"/>
        <Column Name="PrintSlipTo" DataType="System.String"/>
        <Column Name="SaveAsPDFTo" DataType="System.String"/>
        <Column Name="EmailAddress" DataType="System.String"/>
        <Column Name="EmailUserName" DataType="System.String"/>
        <Column Name="EmailPassword" DataType="System.String"/>
        <Column Name="EmailSMTPAddress" DataType="System.String"/>
        <Column Name="EmailSMTPPort" DataType="System.String"/>
        <Column Name="AfterTransAction1" DataType="System.String"/>
        <Column Name="AfterTransAction2" DataType="System.String"/>
        <Column Name="ExportLocation" DataType="System.String"/>
        <Column Name="PayOutReasons" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="trans" DataType="System.Int32" PropName="receipts" Enabled="true" TableName="trans" SelectCommand="SELECT * FROM payments WHERE ID &gt; 0">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="AmountPaid" DataType="System.Decimal"/>
        <Column Name="PaymentMethod" DataType="System.String"/>
        <Column Name="IsForAccount" DataType="System.Byte"/>
        <Column Name="StatementNote" DataType="System.String"/>
        <Column Name="TransID" DataType="System.UInt32"/>
        <Column Name="PurchasesID" DataType="System.UInt32"/>
        <Column Name="SupplierID" DataType="System.UInt32"/>
        <Column Name="SupplierName" DataType="System.String"/>
        <Column Name="User" DataType="System.String"/>
      </TableDataSource>
    </MySqlDataConnection>
    <Relation Name="sales_sales_items" ParentDataSource="null" ChildDataSource="null" ParentColumns="ID" ChildColumns="SalesID" Enabled="true"/>
    <Relation Name="sales_companies" ParentDataSource="null" ChildDataSource="null" ParentColumns="CompanyID" ChildColumns="ID" Enabled="true"/>
    <Parameter Name="MainAppPath" DataType="System.String"/>
    <Parameter Name="CompanyID" DataType="System.Int32"/>
  </Dictionary>
  <ReportPage Name="Page1" PaperWidth="148.1" PaperHeight="210.1" RawPaperSize="11" LeftMargin="5" TopMargin="5" RightMargin="5" BottomMargin="5">
    <PageHeaderBand Name="PageHeader1" Width="522.02" Height="179.55" AfterDataEvent="PageHeader1_AfterData">
      <TextObject Name="Text78" Left="434.7" Top="141.75" Width="85.05" Height="37.8" Text="[trans.PaymentMethod]" Font="Segoe UI, 8pt"/>
      <TextObject Name="Text79" Left="359.1" Top="141.75" Width="75.6" Height="18.9" Text="Paid via:" HorzAlign="Right" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
      <PictureObject Name="picStyle" Width="510.95" Height="74.55" SizeMode="StretchImage"/>
      <TextObject Name="Text2" Left="264.6" Top="56.7" Width="236.25" Height="18.9" Text="Date: [trans.Date]" Format="Custom" Format.Format="yyyy-MM-dd HH:mm" HorzAlign="Center" Font="Segoe UI, 9pt"/>
      <TextObject Name="Text14" Top="75.6" Width="491.4" Height="28.35" Text="[companies.Name]" WordWrap="false" Font="Segoe UI Light, 12pt, style=Bold" TextFill.Color="DimGray" Clip="false"/>
      <TextObject Name="Text18" Left="9.45" Top="103.95" Width="151.2" Height="56.7" CanGrow="true" CanShrink="true" Text="[companies.Address]" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
      <TextObject Name="txtInvoice" Left="264.6" Top="9.45" Width="141.75" Height="28.35" Border.Shadow="true" Border.ShadowColor="Transparent" Text="Payment" HorzAlign="Right" Font="Segoe UI Light, 12pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="txtUser" Left="434.7" Top="103.95" Width="85.05" Height="18.9" CanGrow="true" CanShrink="true" Text="[trans.User]" Font="Segoe UI, 8pt"/>
      <TextObject Name="lblUser" Left="359.1" Top="103.95" Width="75.6" Height="18.9" CanGrow="true" CanShrink="true" Text="User:" HorzAlign="Right" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text44" Left="255.15" Top="103.95" Width="94.5" Height="18.9" CanGrow="true" CanShrink="true" Text="[companies.RegNo]" Font="Segoe UI, 8pt"/>
      <TextObject Name="txtVatNo" Left="255.15" Top="122.85" Width="94.5" Height="18.9" CanGrow="true" CanShrink="true" Text="[companies.VATno]" Font="Segoe UI, 8pt"/>
      <TextObject Name="Text46" Left="255.15" Top="160.65" Width="94.5" Height="18.9" CanGrow="true" CanShrink="true" Text="[companies.AltNo]" Font="Segoe UI, 8pt"/>
      <TextObject Name="Text48" Left="170.1" Top="103.95" Width="85.05" Height="18.9" CanGrow="true" CanShrink="true" Text="Reg. No:" HorzAlign="Right" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text49" Left="170.1" Top="122.85" Width="85.05" Height="18.9" CanGrow="true" CanShrink="true" Text="VAT No:" HorzAlign="Right" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text50" Left="170.1" Top="160.65" Width="85.05" Height="18.9" CanGrow="true" CanShrink="true" Text="Alt. / Fax. No:" HorzAlign="Right" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
      <PictureObject Name="picLogo" Left="18.9" Width="226.8" Height="66.15" Printable="false"/>
      <TextObject Name="Text55" Left="255.15" Top="141.75" Width="94.5" Height="18.9" CanGrow="true" CanShrink="true" Text="[companies.ContactNo]" Font="Segoe UI, 8pt"/>
      <TextObject Name="Text56" Left="170.1" Top="141.75" Width="85.05" Height="18.9" CanGrow="true" CanShrink="true" Text="Tel. No:" HorzAlign="Right" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
      <TextObject Name="txtInvoiceNumber" Left="406.35" Top="9.45" Width="94.5" Height="28.35" Text="# [trans.TransID]" Font="Segoe UI Light, 12pt"/>
      <TextObject Name="Text81" Left="9.45" Top="160.65" Width="151.2" Height="18.9" CanGrow="true" CanShrink="true" Text="[companies.Email]" Font="Segoe UI, 8pt"/>
      <ChildBand Name="Child1" Top="183.55" Width="522.02" Height="103.95">
        <ShapeObject Name="Shape2" Width="255.15" Height="103.95" Border.Color="LightGray" Border.Width="2" Shape="RoundRectangle"/>
        <TextObject Name="Text9" Left="18.9" Top="47.25" Width="226.8" Height="47.25" Text="[suppliers.BillingAddress]" Font="Segoe UI, 8pt" TextFill.Color="DimGray"/>
        <TextObject Name="Text3" Left="18.9" Top="28.35" Width="226.8" Height="18.9" Text="[trans.SupplierName]" Font="Segoe UI, 8pt"/>
        <TextObject Name="Text20" Left="12.45" Top="9.45" Width="103.95" Height="18.9" Text="Paid To:" Font="Segoe UI, 8pt, style=Bold" TextFill.Color="DimGray"/>
        <ChildBand Name="Child2" Top="291.5" Width="522.02" Height="85.05">
          <ShapeObject Name="Shape1" Width="510.3" Height="28.35" Border.Color="Silver" Shape="RoundRectangle"/>
          <TextObject Name="Text11" Left="9.45" Top="5.45" Width="359.1" Height="18.9" Text="Payment for Account" Font="Segoe UI, 8pt"/>
          <TextObject Name="Text15" Left="425.25" Top="5.45" Width="75.6" Height="18.9" Text="Total" HorzAlign="Right" Font="Segoe UI, 8pt"/>
          <TextObject Name="txtItemTotal" Left="425.25" Top="37.8" Width="75.6" Height="18.9" Text="[trans.AmountPaid]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Segoe UI, 8pt" Trimming="EllipsisCharacter"/>
          <TextObject Name="Text4" Left="9.45" Top="37.8" Width="359.1" Height="18.9" Text="[trans.StatementNote]" Font="Segoe UI, 8pt"/>
        </ChildBand>
      </ChildBand>
    </PageHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="380.55" Width="522.02" Height="94.5">
      <LineObject Name="Line1" Left="9.45" Top="9.45" Width="491.4" Border.Color="DimGray" Border.Style="Dash" Border.Width="0.25"/>
      <TextObject Name="Text30" Left="425.25" Top="28.35" Width="75.6" Height="18.9" Text="[trans.AmountPaid]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Segoe UI, 9pt, style=Bold" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text32" Left="311.85" Top="28.35" Width="103.95" Height="18.9" Text="Total Paid:" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="Text22" Left="18.9" Top="28.35" Width="94.5" Height="18.9" Text="[PageNofM]" Font="Segoe UI, 9pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text1" Left="425.25" Top="66.15" Width="75.6" Height="18.9" Text="[suppliers.TotalDue]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Segoe UI, 9pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text57" Left="311.85" Top="66.15" Width="103.95" Height="18.9" Text="Balance Due:" Font="Segoe UI, 9pt, style=Bold" TextFill.Color="DimGray"/>
    </PageFooterBand>
  </ReportPage>
</Report>
