﻿<?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/19/2015 09:26:46" 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
  {
    
    int decimalValue = 0;
    
    private void _StartReport(object sender, EventArgs e)
    {
      //Qty Column format      
      decimalValue = Convert.ToInt32(Report.GetColumnValue(&quot;programs_config.QtyDecimalValue&quot;));
      
      //Show Amount Due on Sales docs
      if (Report.GetColumnValue(&quot;programs_config.ShowAmountDueOnSalesDocs&quot;).ToString() == &quot;1&quot;)
      {
        lblAmountDue.Visible = true;
        txtAmountDue.Visible = true;
      }
      else
      {
        lblAmountDue.Visible = false;
        txtAmountDue.Visible = false;
      }
    }
    
    
    private void PageHeader1_AfterData(object sender, EventArgs e)
    {
      //Print the SalesRep
      if (Report.GetColumnValue(&quot;trans.SalesRep&quot;).ToString().Length == 0)
        txtSalesRep2.Visible = false;        
    }
    
    
    private void Data1_AfterData(object sender, EventArgs e)
    {
      //Include when items were sold with a zero qty
      decimal qty = Convert.ToDecimal(Report.GetColumnValue(&quot;trans_items.Qty&quot;));    
      decimal total = 0;
      if (qty != 0)
      {
        //Total          
        total = Convert.ToDecimal(Report.GetColumnValue(&quot;trans_items.TotalCost&quot;));
      }
      //exclude notes
      if (Report.GetColumnValue(&quot;trans_items.ProductCode&quot;).ToString().Length &gt; 0)
      {
        txtQty.Text = String.Format(&quot;{0:F&quot; + decimalValue + &quot;}&quot;, qty);
        txtItemTotal.Text = total.ToString(&quot;# ### ###.00&quot;);
      }
    }
    

    private void Data2_AfterData(object sender, EventArgs e)
    {
      //Print the Note
      if (Report.GetColumnValue(&quot;trans.SlipNote&quot;).ToString().Length == 0)
        Data2.Visible = false;
    }
    
    
  }
}
</ScriptText>
  <Dictionary>
    <MySqlDataConnection Name="Connection" ConnectionString="rijcmlqmUGi0DHzhik04BO5+uxHPNJg6XdWlo9sfl3oNLbLcC5ELgVy3yM4U7/vviW/yU/VlCYnkUjA+BNt9VEI/Ru/VhPouEQa0WRWWSsnXA3zuDY=">
      <TableDataSource Name="clients" DataType="System.Int32" Enabled="true" TableName="clients" SelectCommand="SELECT * FROM clients WHERE ID = 1">
        <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="ClientID" DataType="System.UInt32"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="LastCashTransDate" DataType="System.DateTime"/>
        <Column Name="LastCashInvoiceDate" DataType="System.DateTime"/>
        <Column Name="LastCashRefundDate" DataType="System.DateTime"/>
        <Column Name="LastAccountTransDate" DataType="System.DateTime"/>
        <Column Name="LastAccountInvoiceDate" DataType="System.DateTime"/>
        <Column Name="LastCreditNoteDate" DataType="System.DateTime"/>
        <Column Name="LastReceiptDate" DataType="System.DateTime"/>
        <Column Name="LastJournalDate" DataType="System.DateTime"/>
        <Column Name="TotalDue" DataType="System.Decimal"/>
        <Column Name="PriceOverrideRule" DataType="System.String"/>
        <Column Name="PriceOverrideValue" DataType="System.Decimal"/>
        <Column Name="Note" DataType="System.String"/>
        <Column Name="InterestOver" DataType="System.String"/>
        <Column Name="InterestValue" DataType="System.Decimal"/>
        <Column Name="Area" DataType="System.String"/>
        <Column Name="City" DataType="System.String"/>
        <Column Name="CreditLimit" DataType="System.Decimal"/>
        <Column Name="Status" DataType="System.String"/>
      </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="InvoiceSize" DataType="System.String"/>
        <Column Name="InvoiceStylePath" 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" SelectCommand="SELECT InvShowRetailPriceExcl, QtyDecimalValue, ShowAmountDueOnSalesDocs &#13;&#10;FROM programs_config WHERE CompanyID = @CompanyID">
        <Column Name="InvShowRetailPriceExcl" DataType="System.Byte"/>
        <Column Name="QtyDecimalValue" DataType="System.UInt32"/>
        <Column Name="ShowAmountDueOnSalesDocs" DataType="System.Byte"/>
        <CommandParameter Name="CompanyID" DataType="254" Expression="[CompanyID]"/>
      </TableDataSource>
      <TableDataSource Name="trans" DataType="System.Int32" PropName="cash_sales" Enabled="true" TableName="trans" SelectCommand="select * from ibt_returns">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="ComputerName" DataType="System.String"/>
        <Column Name="SalesRep" DataType="System.String"/>
        <Column Name="ClientID" DataType="System.UInt32"/>
        <Column Name="ClientName" DataType="System.String"/>
        <Column Name="SlipNote" DataType="System.String"/>
        <Column Name="TransID" DataType="System.UInt32"/>
        <Column Name="RelatedTransID" DataType="System.UInt32"/>
        <Column Name="TotalCost" DataType="System.Decimal"/>
      </TableDataSource>
      <TableDataSource Name="trans_items" DataType="System.Int32" PropName="cash_sales_items" Enabled="true" TableName="trans_items" SelectCommand="select * from ibt_returns_items where relatedID = 1 and companyid = 1">
        <Column Name="ID" DataType="System.UInt32"/>
        <Column Name="CompanyID" DataType="System.UInt32"/>
        <Column Name="ClientID" DataType="System.UInt32"/>
        <Column Name="ProductID" DataType="System.UInt32"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="IsProduct" DataType="System.Byte"/>
        <Column Name="ProductCode" DataType="System.String"/>
        <Column Name="Description" DataType="System.String"/>
        <Column Name="Qty" DataType="System.Decimal"/>
        <Column Name="TotalCost" DataType="System.Decimal"/>
        <Column Name="RelatedID" DataType="System.UInt32"/>
        <Column Name="SalesRep" DataType="System.String"/>
        <Column Name="Reason" DataType="System.String"/>
        <Column Name="QtyAvailable" DataType="System.Decimal"/>
        <Column Name="UnitCost" DataType="System.Int32" PropName="Column" Calculated="true" Expression="[trans_items.TotalCost]/[trans_items.Qty]"/>
      </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="CompanyID" DataType="System.Int32"/>
  </Dictionary>
  <ReportPage Name="Page1" PaperWidth="110" PaperHeight="1000" LeftMargin="3" RightMargin="3" FirstPageSource="15" OtherPagesSource="15">
    <PageHeaderBand Name="PageHeader1" Width="393.12" Height="425.25" CanGrow="true" CanShrink="true" AfterDataEvent="PageHeader1_AfterData">
      <TextObject Name="Text3" Left="18.9" Top="330.75" Width="302.4" Height="18.9" CanGrow="true" CanShrink="true" Text="[trans.ClientName]" Font="Courier New, 8pt"/>
      <TextObject Name="Text2" Top="47.25" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Date: [trans.Date]" Format="Custom" Format.Format="yyyy-MM-dd HH:mm" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text14" Top="122.85" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="[companies.Name]" HorzAlign="Center" WordWrap="false" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray" Clip="false"/>
      <TextObject Name="txtTrans" Top="9.45" Width="321.3" Height="18.9" Border.Shadow="true" Border.ShadowColor="Transparent" CanGrow="true" CanShrink="true" Text="IBT Return" HorzAlign="Center" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="Text20" Top="311.85" Width="151.2" Height="18.9" CanGrow="true" CanShrink="true" Text="Received From:" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="txtSalesRep2" Top="66.15" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Sales Rep: [trans.SalesRep]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text44" Top="217.35" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Reg. No: [companies.RegNo]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text45" Top="255.15" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Vat No: [companies.VATno]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text46" Top="274.05" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Alt. No: [companies.AltNo]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text52" Top="292.95" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Email: [companies.Email]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text55" Top="236.25" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Tel. No: [companies.ContactNo]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="txtTransNumber" Top="28.35" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="# [trans.TransID]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text1" Top="141.75" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text17" Text="[companies.Address]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text4" Left="18.9" Top="349.65" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text9" Text="[clients.BillingAddress]" Font="Courier New, 8pt"/>
      <TextObject Name="Text9" Left="18.9" Top="368.55" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text16" Font="Courier New, 8pt"/>
      <TextObject Name="Text16" Left="18.9" Top="387.45" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text21" Font="Courier New, 8pt"/>
      <TextObject Name="Text21" Left="18.9" Top="406.35" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" Font="Courier New, 8pt"/>
      <TextObject Name="Text17" Top="160.65" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text72" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text72" Top="179.55" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text73" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text73" Top="198.45" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text74" Top="85.05" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text="Related #: [trans.RelatedTransID]" HorzAlign="Center" Font="Courier New, 8pt"/>
      <TextObject Name="Text110" Top="103.95" Width="321.3" Height="18.9" CanGrow="true" CanShrink="true" Text=" " Font="Courier New, 8pt"/>
      <ChildBand Name="Child4" Top="429.25" Width="393.12" Height="75.6">
        <TextObject Name="Text63" Top="56.7" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
        <TextObject Name="Text10" Top="18.9" Width="274.05" Height="18.9" Text="Description" Font="Courier New, 8pt"/>
        <TextObject Name="Text65" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
        <TextObject Name="Text11" Left="66.15" Top="37.8" Width="122.85" Height="18.9" Text="Code" Font="Courier New, 8pt"/>
        <TextObject Name="txtItemTotallbl" Left="198.45" Top="37.8" Width="113.4" Height="18.9" Text="Total" HorzAlign="Right" Font="Courier New, 8pt"/>
        <TextObject Name="Text13" Top="37.8" Width="56.7" Height="18.9" Text="Qty" Font="Courier New, 8pt"/>
      </ChildBand>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="508.85" Width="393.12" Height="94.5" CanGrow="true" CanShrink="true" AfterDataEvent="Data1_AfterData" DataSource="trans_items" KeepTogether="true" KeepDetail="true">
      <TextObject Name="Text8" Left="66.15" Top="56.7" Width="122.85" Height="18.9" CanGrow="true" CanShrink="true" Text="[trans_items.ProductCode]" Font="Courier New, 8pt"/>
      <TextObject Name="Text12" Width="274.05" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text105" Text="[trans_items.Description]" Font="Courier New, 8pt"/>
      <TextObject Name="txtQty" Top="56.7" Width="56.7" Height="18.9" HideZeros="true" Format="Number" Format.UseLocale="false" Format.DecimalDigits="0" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" WordWrap="false" Font="Courier New, 8pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="txtItemTotal" Left="198.45" Top="56.7" Width="113.4" Height="18.9" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Courier New, 8pt" Trimming="EllipsisCharacter"/>
      <TextObject Name="Text71" Left="37.8" Top="75.6" Width="274.05" Height="18.9" CanGrow="true" CanShrink="true" Text="[trans_items.Reason]" Font="Courier New, 8pt"/>
      <TextObject Name="Text105" Top="18.9" Width="274.05" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text106" Font="Courier New, 8pt"/>
      <TextObject Name="Text106" Top="37.8" Width="274.05" Height="18.9" CanGrow="true" CanShrink="true" Font="Courier New, 8pt"/>
    </DataBand>
    <DataBand Name="Data2" Top="607.35" Width="393.12" Height="132.3" CanGrow="true" CanShrink="true" AfterDataEvent="Data2_AfterData">
      <TextObject Name="Text61" Top="18.9" Width="75.6" Height="18.9" CanGrow="true" CanShrink="true" Text="Note:" VertAlign="Center" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      <TextObject Name="Text62" Left="18.9" Top="37.8" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text23" Text="[trans.SlipNote]" Font="Courier New, 8pt"/>
      <TextObject Name="Text23" Left="18.9" Top="56.7" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text25" Font="Courier New, 8pt"/>
      <TextObject Name="Text25" Left="18.9" Top="75.6" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text69" Font="Courier New, 8pt"/>
      <TextObject Name="Text69" Left="18.9" Top="94.5" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" BreakTo="Text70" Font="Courier New, 8pt"/>
      <TextObject Name="Text70" Left="18.9" Top="113.4" Width="255.15" Height="18.9" CanGrow="true" CanShrink="true" Font="Courier New, 8pt"/>
      <TextObject Name="Text111" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
      <ChildBand Name="Child3" Top="743.65" Width="393.12" Height="217.35" CanShrink="true">
        <TextObject Name="Text7" Left="198.45" Top="28.35" Width="141.75" Height="18.9" Text="[trans.TotalCost]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Courier New, 8pt, style=Bold" Trimming="EllipsisCharacter"/>
        <TextObject Name="Text29" Left="56.7" Top="28.35" Width="94.5" Height="18.9" Text="Total:" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
        <TextObject Name="Text64" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
        <TextObject Name="Text67" Top="198.45" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
        <TextObject Name="Text68" Top="85.05" Width="274.05" Height="18.9" Text="--------------------------------------" Font="Courier New, 8pt"/>
        <TextObject Name="txtAmountDue" Left="198.45" Top="66.15" Width="141.75" Height="18.9" Text="[clients.TotalDue]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="." Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" WordWrap="false" Font="Courier New, 8pt, style=Bold" Trimming="EllipsisCharacter"/>
        <TextObject Name="lblAmountDue" Left="56.7" Top="66.15" Width="94.5" Height="18.9" Text="Balance Due:" Font="Courier New, 8pt, style=Bold" TextFill.Color="DimGray"/>
      </ChildBand>
    </DataBand>
  </ReportPage>
</Report>
