|
Shannon Graham
|
June 5, 2014 at 9:44 pm
I realized this is not currently an option for EE4 and that the hacks that were available for EE3 are not portable to the newest version. Having searched the forums, I have outstanding questions that I would like to ask.
Garth mentioned in other posts that a “deposit ticket” could be used and the final amount due could be changed manually. I had done something similar to this with a cron job and a few DB queries in EE3. Can you please tell me how I can manipulate the amount due via the DB. In EE3, there were several fields that needed to be changed in order to make this happen. How are the costs and payments of a registration recorded?
In EE3, the original_price , final_price, and amount_pd needed to be changed and the payment data columns emptied. The prices were also broken up strangely amongst the primary attendee and any additional attendees making it difficult to figure out who had paid what.
It would be helpful to get an understanding of this up front. Thank you for any input you can give me.
Tai Graham
|
|
Michael Nelson
|
June 6, 2014 at 11:07 am
The amount due is recorded in several places: the wp_esp_transaction.TXN_total (that’s the total for ALL registrations) and wp_esp_registraiton.REG_final_price (the price of each individual registration. The sum of which should equal the wp_esp_transaction.TXN_total provided there are no taxes or other modifiers).
But the information on the invoice is stored in the wp_esp_line_item table, which is a tree of all that goes together to make the final price (ie, there is a total line item, then it has children line items of tax-total and items-total, the items total has children of each item purchased and the tax-total has children of each tax applied, etc.). So if you want to change the order total as it appears in invoices etc, then you’d probably want to change all the totals and sub-totals (and possibly add another line item row) in the wp_esp_line_item table.
The amount total amount paid is stored on wp_esp_transaction.TXN_paid column, and each payment is stored in the wp_esp_payment table (note that currently all payments are assumed to be made by the primary registrant on the transcation).
Does that help shed some light on how amounts due and amounts paid are stored?
|
