add data to a table after order is confirmed

I'd like to be able to add some data to fields in 1 table in my database whenever a payment is verified and order becomes confirmed. where can I do that?

Hi nicolas,

I attempted to create a plugin for that so when order is updated, a coupon is created. This is my first time and it doesn't work, would you be able to tell me what I did wrong? thank you!

I placed it in joomla/plugins/hikashop/
and already registered it in the jos_plugin.

sorry i thought i attached the file. here you go.

yes it is published, i can see it in the plugin manager as well.

Hi nicolas,

the reason y I only use static value such as 'testcode' for discount_code is because I wanted to see it working first before I put in any other things to complicate it. Also 'testcode' has never been created in discount before.
However, I've made the following changes, and the plugin still wouldn't create a discount entry for me. also attached php+xml files.

1. I've now included the xml file
2. I also fixed the $order_>order_full_price to $order->order_full_price
3. I've removed the discount_id line.
4. I use order_id + today's date&time as discount_code, so it's always unique
5. I've added the condition to check the order_status == 'confirmed'

I also tried with static values, still doesn't work. The plugin is called each time i change the order status (because if i have a syntax error in create_discount.php the order status will not change), but it never creates the discount entry.

sorry uploaded the wrong file.

Ahhh!!! you are right! it adds the entry now!
But there's one problem, it's not assigning the order_full_price to the discount amount. is there something wrong with the following line:

$discount->discount_flat_amount = $order->order_full_price;

in my order table, the order_full_price field is 60.00, so i expect the discount amount to be 60.00 as well. is it wrong?

brilliant! Thank you Nicolas! the best support on earth!

Bonjour,

I need to perform same task : execute code after order is confirm.
I created a plugin :
defined('_JEXEC') or die('Restricted access');
?>
<?php
class plgHikashopBuy_AUP extends JPlugin
{
function onAfterOrderUpdate(&$order,&$send_email){
if(!empty($order->order_id)){
if($order->order_status == 'confirmed'){
//insert code here

Payment is not implemented in my website, so I have to test it manually.
This is working properly when a user creates an order. Order is with status created, if I switch status to confirm, plugin is triggered.

I have added bank transfer payment (easy to test with this one I guess).
And I have modified this payment processor (in the properties of the plugin) to have status Confirmed (instead of Created).
So when a user buys something with this payment processor, the order is generated with status Confirmed.

But here the plugin is not triggered.

Could you please explain why ?

Many thanks.

Do you think I am so stupid to have forgotten function onAfterOrderCreate ?
hum.... I AM so stupid !!

So I added :
function onAfterOrderCreate(&$order,&$send_email){
return $this->onAfterOrderUpdate($order,$send_email);
}

which is what you mean (correct ?).

But still no way to trigger the code when bank transfer (and Confirmed is the default status).

btw, I've noticed when I create an order like said before, the history of the order shows me 2 entry : one with status Created, and a second one with status Confirmed.
So I guess the function onAfterOrderUpdate should be enough (anyway, I've implemented your suggestion, which makes sense to me).
Maybe what is wrong here is something else ?

(anyway, many thanks for your help)

I am using jdump to check.
And I confirm, when creating an order with confirmed status as default status on bank transfer, onAfterOrderCreate is triggered once, onAfterOrderUpdate is triggered twice.

But my sql DB is not updated this way, even if th code is working well when updating manually.
Something is wrong in my code, not same variable I guess when updating manually.

I will check.
Many thanks for your help.




edit :

OK, I can see why it is not working.
in the code, I need the userid.
I am using the following :
$orderClass = hikashop::get('class.order');
$dbOrder = $orderClass->get($order->order_id);
$orderClass=$orderClass->loadFullOrder($order->order_id, false, false);

Then $orderClass->customer->id is the userid.

This code works when manually changing the status.
But it does not work when the order is created the proper way (by the user, frontend side, bank transfer payment).

There is no customer property for $orderClass.

What do I miss here ?

Hello,

I tried your piece of code (just modified hikashop_get to hikasho::get).
But $userClass->get($orderClass->order_user_id) return null (even if $userClass seems to be correctly created before).

I think I need to learn a bit more about php before trying to understand all of this (totally noob regarding this language).