[Vtigercrm-developers] Fwd: Fwd: Re: getting invoice id and product id during event processing

[Vic Cekvenich]

-------- Original Message --------
Subject: [Vtigercrm-developers] Fwd: Re: getting invoice id and product id during event processing
Date: Sun, 17 Aug 2014 15:02:16 -0700
From: Vic Cekvenich <vic.cvc at gmx.com>
Reply-To: vtigercrm-developers at lists.vtigercrm.com
To: vtigercrm-developers at lists.vtigercrm.com



-------- Original Message --------
Subject: 	Re: [Vtigercrm-developers] getting invoice id and product id 
during event processing
Date: 	Tue, 22 Jul 2014 11:44:03 +0530
From: 	Rishab K <rishab.k at vtiger.com>
Reply-To: 	vtigercrm-developers at lists.vtigercrm.com
To: 	vtigercrm-developers at lists.vtigercrm.com



Chris,

You can find the information about the invoice which is being created in 
InvoiceHandler.php(handleEvent Api).
Products related to to the invoice are stored in separate 
table(vtiger_inventoryproductrel)

example query to fetch the products related to invoice will be

SELECT productid FROM vtiger_inventoryproductrel INNER JOIN 
vtiger_crmentity ON vtiger_crmentity.crmid = 
vtiger_inventoryproductrel.productid AND vtiger_crmentity.deleted=0 
WHERE id = '?';

id will be the invoiceid on which the event is getting triggered.


On Tue, Jul 22, 2014 at 7:04 AM, Hamono, Chris (DPC) 
<Chris.Hamono at sa.gov.au <mailto:Chris.Hamono at sa.gov.au>> wrote:

    I need to do some post processing when a new invoice is created.
    It appears that when a new invoice is created and the onaftersave
    event is fired there is neither a productid nor an invoiceid in the
    invoice object sent to the event.
    1/ When are they created?
    2/ How do I find this information?
    The invoice is being created programmatically if that makes a difference
    Chris

    _______________________________________________
    http://www.vtiger.com/



-------------- next part --------------
_______________________________________________
http://www.vtiger.com/
-------------- next part --------------
_______________________________________________
http://www.vtiger.com/