﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" DoublePass="true" StartReportEvent="_StartReport" ReportInfo.Created="09/27/2013 16:01:23" ReportInfo.Modified="05/26/2015 08:54:14" 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="rijcmlqomabmqtwD7y3BaVO988XrjoBefSoHBX+xGSDpo0d+ot8yrzL17EhRvx7tW87ZuxDTsXprPmiOj80ATh2Aow+2w==">
      <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="trans" DataType="System.Int32" PropName="receipts" Enabled="true" TableName="trans" SelectCommand="SELECT * FROM creditor_journals WHERE ID &gt; 0">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="StatementNote" DataType="System.String"/>
        <Column Name="TransID" DataType="System.UInt32"/>
        <Column Name="Amount" DataType="System.Decimal"/>
        <Column Name="Reason" DataType="System.String"/>
        <Column Name="TotalPaid" DataType="System.Decimal"/>
        <Column Name="SupplierID" DataType="System.UInt32"/>
        <Column Name="SupplierName" DataType="System.String"/>
        <Column Name="User" DataType="System.String"/>
        <Column Name="RelPaymentIDs" 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" RawPaperSize="9">
    <PageHeaderBand Name="PageHeader1" Width="718.2" Height="378" AfterDataEvent="PageHeader1_AfterData">
      <ShapeObject Name="Shape2" Left="9.45" Top="245.7" Width="453.6" Height="122.85" Border.Color="LightGray" Border.Width="2" Shape="RoundRectangle"/>
      <TextObject Name="Text3" Left="113.4" Top="255.15" Width="321.3" Height="28.35" Text="[trans.SupplierName]"/>
      <TextObject Name="Text2" Left="557.55" Top="151.2" Width="132.3" Height="18.9" Text="[trans.Date]" Format="Custom" Format.Format="yyyy-MM-dd HH:mm"/>
      <TextObject Name="Text17" Left="463.05" Top="151.2" Width="85.05" Height="18.9" Text="Date:" HorzAlign="Right" TextFill.Color="DimGray"/>
      <TextObject Name="Text9" Left="113.4" Top="283.5" Width="226.8" Height="75.6" Text="[suppliers.BillingAddress]" TextFill.Color="DimGray"/>
      <TextObject Name="Text20" Left="21.9" Top="255.15" Width="85.05" Height="66.15" Text="Journal For:" Font="Segoe UI Light, 11pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="txtUser" Left="557.55" Top="170.1" Width="132.3" Height="18.9" Text="[trans.User]"/>
      <TextObject Name="lblUser" Left="463.05" Top="170.1" Width="85.05" Height="18.9" Text="User:" HorzAlign="Right" TextFill.Color="DimGray"/>
      <PictureObject Name="picStyle" Left="9.45" Width="690.5" Height="112.35" SizeMode="StretchImage"/>
      <TextObject Name="Text14" Left="9.45" Top="113.4" Width="680.4" Height="37.8" Text="[companies.Name]" WordWrap="false" Font="Segoe UI Light, 16pt, style=Bold" TextFill.Color="DimGray" Clip="false"/>
      <TextObject Name="Text18" Left="18.9" Top="151.2" Width="170.1" Height="66.15" Text="[companies.Address]" TextFill.Color="DimGray"/>
      <TextObject Name="txtInvoice" Left="406.35" Top="37.8" Width="255.15" Height="47.25" Border.Shadow="true" Border.ShadowColor="Transparent" Text="Creditor Journal" HorzAlign="Center" Font="Segoe UI Light, 20pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="Text51" Left="18.9" Top="222.35" Width="47.25" Height="18.9" Text="Email:" HorzAlign="Right" Font="Arial, 8pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text52" Left="75.6" Top="222.35" Width="292.95" Height="18.9" Text="[companies.Email]" Font="Arial, 8pt"/>
      <PictureObject Name="picLogo" Left="28.35" Width="283.5" Height="75.6" Printable="false" AfterDataEvent="picLogo_AfterData"/>
      <TextObject Name="txtInvoiceNumber" Left="406.35" Top="75.6" Width="255.15" Height="18.9" Text="# [trans.TransID]" HorzAlign="Center" Font="Arial, 12pt"/>
      <TextObject Name="Text44" Left="292.95" Top="151.2" Width="160.65" Height="18.9" Text="[companies.RegNo]" Font="Arial, 9pt"/>
      <TextObject Name="Text45" Left="292.95" Top="170.1" Width="160.65" Height="18.9" Text="[companies.VATno]" Font="Arial, 9pt"/>
      <TextObject Name="Text46" Left="292.95" Top="207.9" Width="160.65" Height="18.9" Text="[companies.AltNo]" Font="Arial, 9pt"/>
      <TextObject Name="Text48" Left="198.45" Top="151.2" Width="85.05" Height="18.9" Text="Reg. No:" HorzAlign="Right" Font="Arial, 9pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text49" Left="198.45" Top="170.1" Width="85.05" Height="18.9" Text="VAT No:" HorzAlign="Right" Font="Arial, 9pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text50" Left="198.45" Top="207.9" Width="85.05" Height="18.9" Text="Alt. / Fax. No:" HorzAlign="Right" Font="Arial, 9pt" TextFill.Color="DimGray"/>
      <TextObject Name="Text55" Left="292.95" Top="189" Width="160.65" Height="18.9" Text="[companies.ContactNo]" Font="Arial, 9pt"/>
      <TextObject Name="Text56" Left="198.45" Top="189" Width="85.05" Height="18.9" Text="Tel. No:" HorzAlign="Right" Font="Arial, 9pt" TextFill.Color="DimGray"/>
      <ChildBand Name="Child2" Top="382" Width="718.2" Height="85.05" AfterDataEvent="Child2_AfterData">
        <ShapeObject Name="Shape1" Left="9.45" Top="9.45" Width="689.85" Height="37.8" Border.Color="Transparent" Fill.Color="Gainsboro" Shape="RoundRectangle"/>
        <TextObject Name="Text11" Left="18.9" Top="18.9" Width="359.1" Height="18.9" Text="Reason" Font="Segoe UI Light, 11pt"/>
        <TextObject Name="Text15" Left="595.35" Top="18.9" Width="94.5" Height="18.9" Text="Total" HorzAlign="Right" Font="Segoe UI Light, 11pt"/>
        <TextObject Name="txtItemTotal" Left="595.35" Top="56.7" Width="94.5" Height="18.9" Text="[trans.Amount]" Format="Number" Format.UseLocale="true" HorzAlign="Right" WordWrap="false" Trimming="EllipsisCharacter"/>
        <TextObject Name="Text4" Left="18.9" Top="56.7" Width="548.1" Height="18.9" CanGrow="true" Text="[trans.Reason]"/>
      </ChildBand>
    </PageHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="471.05" Width="718.2" Height="160.65">
      <LineObject Name="Line1" Left="9.45" Top="9.45" Width="689.85" Border.Color="DimGray" Border.Style="Dash" Border.Width="0.25"/>
      <TextObject Name="Text30" Left="595.35" Top="28.35" Width="94.5" Height="18.9" Text="[trans.Amount]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Arial, 10pt, style=Bold" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text32" Left="472.5" Top="28.35" Width="103.95" Height="18.9" Text="Total:" Font="Segoe UI Light, 10pt, 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="538.65" Top="66.15" Width="151.2" 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" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text57" Left="425.25" Top="66.15" Width="103.95" Height="18.9" Text="Balance Due:" Font="Segoe UI Light, 10pt, style=Bold" TextFill.Color="DimGray"/>
    </PageFooterBand>
  </ReportPage>
</Report>
