Purch Report

[
//SRSReportQueryAttribute(queryStr(PurchQuery)),
SRSReportQueryAttribute(queryStr(PurchQuery)),
SRSReportParameterAttribute(classStr(PurchContract))
]
//public class PurchDP extends  SRSReportDataProviderBase
public class PurchDP extends  SrsReportDataProviderPreProcess
{
    PurchTem                purchTem;

    PurchContract                contract;

    DataAreaId              dataArearId;
    CurrencyCode            currencyCode;
    //PurchStatus             PurchStatus;

}

[SRSReportDataSetAttribute(tableStr(PurchTem))]
public purchTem GetPurchTem()
{
    select  purchTem;
    return  purchTem;
}



[SysEntryPointAttribute]
public void processReport()
{
    Query                       query;
    QueryRun                    queryRun;
    PurchTable                  purchTable;
    PurchLine                   purchLine;
    InventDim                   inventDim;
    InventSite                  inventsite;
    VendTable                   vendTable;
    VendTrans                   vendTrans;
    VendInvoiceJour             vendInvoiceJour;


    contract                = this.parmDataContract() as PurchContract;

    dataArearId             = contract.pramDataAreaId();
    currencyCode            = contract.pramCurrencyCode();
    //purchStatus             = contract.prampurchStatus();

    query                       = this.parmQuery();
    queryRun                    = new QueryRun(query);
    while(queryRun.next())
    {
    purchTable                  = queryRun.get(tableNum(PurchTable));
    purchLine                   = queryRun.get(tableNum(purchLine));
    inventDim                   = queryRun.get(tableNum(InventDim));
    inventsite                  = queryRun.get(tableNum(InventSite));
    vendTable                   = queryRun.get(tableNum(VendTable));
    vendTrans                   = queryRun.get(tableNum(VendTrans));
    //vendInvoiceJour             = queryRun.get(tableNum(VendInvoiceJour));
//breakpoint;
    purchTem.clear();

    purchTem.PurchId            = purchTable.PurchId;
    purchTem.PurchName          = purchTable.PurchName;
    purchTem.PurchStatus        = purchTable.PurchStatus;
    purchTem.InvoiceAccount     = purchTable.InvoiceAccount;
    purchTem.ItemId             = purchLine.ItemId;
    purchTem.Name               = purchLine.Name;
    purchTem.LineAmount         = purchLine.LineAmount;
    purchTem.PurchPrice         = purchLine.PurchPrice;
    purchTem.CurrencyCode       = purchLine.CurrencyCode;
    purchTem.PurchUnit          = purchLine.PurchUnit;
    purchTem.PurchQty           = purchLine.PurchQty;
    purchTem.QtyOrdered         = purchLine.QtyOrdered;
    purchTem.VendGroup          = purchLine.VendGroup;
    purchTem.InventDimId        = purchLine.InventDimId;
    purchTem.InventLocationId   = inventDim.InventLocationId;
    purchTem.InventSiteId       = inventDim.InventSiteId;
    purchTem.DefaultDimension   = inventsite.DefaultDimension;
    purchTem.InventColorId      = inventDim.InventColorId;
    purchTem.InventSizeId       = inventDim.InventSizeId;
    purchTem.DefaultInventStatusId = inventsite.DefaultInventStatusId;



     




        // add by pramod vendTable,vendTrans
    purchTem.AccountNum         = vendTable.AccountNum;
    purchTem.CashDisc           = vendTable.CashDisc;
    purchTem.PaymMode           = vendTable.PaymMode;
    purchTem.PaymSched          = vendTable.PaymSched;
    purchTem.AmountCur          = vendTrans.AmountCur;
    purchTem.AmountMST          = vendTrans.AmountMST;
    purchTem.PaymId             = vendTrans.PaymId;
    purchTem.PostingProfile     = vendTrans.PostingProfile;
    purchTem.SettleAmountCur    = vendTrans.SettleAmountCur;
    purchTem.SettleAmountMST    = vendTrans.SettleAmountMST;
    purchTem.TransDate          = vendTrans.TransDate;
    purchTem.TransType          = vendTrans.TransType;
    purchTem.Voucher            = vendTrans.Voucher;
    //purchTem.CountryRegionId    = vendInvoiceJour.CountryRegionId;
    //purchTem.DeliveryName       = vendInvoiceJour.DeliveryName;
    //purchTem.InvoiceAmount      = vendInvoiceJour.InvoiceAmount;
    //purchTem.InvoiceAmountMST   = vendInvoiceJour.InvoiceAmountMST;
    //purchTem.InvoiceId          = vendInvoiceJour.InvoiceId;
    //purchTem.InvoiceDate        = vendInvoiceJour.InvoiceDate;
    //purchTem.InvoiceType        = vendInvoiceJour.InvoiceType;
    //purchTem.LedgerVoucher      = vendInvoiceJour.LedgerVoucher;

    //purchTem


     purchTem.insert();
    }

}