Need to call a sync function in a bridge i made, after a sale completes, help

[ibanez0r]

Hey guys, greetings from Melbourne, Australia o/

I recently created a bridge for PHPPOS and VirtueMart,surprisingly it was pretty easy to do, the only one last thing im struggling to figure out is how to make a final call to my script when a virtuemart sale has been completed, could anyone tell me, once a sale has been processed and comes back from paypal as confirmed, is there some where in the structure of virtuemarts php files i could add a quick call to my sync script? 

Ive had a good look around and cant seem to find the ideal place, which doesnt surprise me i dont have alot of virtuemart exp, having said that tho the bridge is 99% complete i just need to update a stock level in PHPPOS after a virtuemart sale is completed, anyone who could point me in the right direction?

Thankyou in advance!

Cheers,
Cam

[GJC Web Design]

when a payment plugin confirms a payment it triggers the function plgVmOnUpdateOrderPayment ($data,$old_order_status)   function in any plugin  from orders.php  updateStatusForOneOrder()

easiest is to write a custom vm plugin with that function and filter by status

e.g.
function plgVmOnUpdateOrderPayment ($data,$old_order_status) {

if($data->order_status=='C'){

  //do your stock update
}
}

[ibanez0r]

Ah ha, thanks ill try this and see how it goes,

Thank-you so much
Cheers

[ibanez0r]

Hey there, the store im working on will only be using paypal std so i figured i might as well have a look in there, i found this function you spoke of GJC Web Design,

public function plgVmOnUpdateOrderPayment(&$order, $old_order_status) {

in paypal.php, I think i can just insert my call in here, do you know if there is any documentation regarding the $order object? i need to pull some fields relating to the items being sold also.

Cheers

[GJC Web Design]

You'll be better off making your own custom vmplugin using the same plgVmOnUpdateOrderPayment otherwise every time u update VM your code is gone

jusT

print 'Debug Line '.__LINE__.' $order <pre>'; print_r ($order); print "</pre><br />\n";

to see what's in it

[ibanez0r]

I totally figured it out,  and got it all going, thank-you so much for your help, sadly tho, lol, heres the amusing part, the sync, updates quantities between the 2 sites, and as it turns out, ive just deducted to myself, (powerful mind) that obviously quantities dont get set until an order is marked as shipped, *sigh* so although the call to do this from within the paypal vmpayment plugin was working as expected it was just not well placed heh! So i guess i need to find where the item quantity is set/updated in virtuemart when the item is marked, shipped, if u know id appreciate a pointer thanks again.

Cheers

[AH]

administrator/components/com_virtuemart/models/product.php

I think this is where to look, as it is the function that updates the dbase.

2313:

Code Select Expand

public function updateStockInDB ($product, $amount, $signInStock, $signOrderedStock) {



You may want to consider how the order status change function handles the Reserved order statuses

For any status that is considered "reserved" the field 'product_ordered' is populated and the 'product_in_stock' is left alone, if you have long lead times for dispatch, this might cause an issue with stock being "called for" but not yet adjusted

See
administrator/components/com_virtuemart/models/orders.php

979:

Code Select Expand

function handleStockAfterStatusChangedPerProduct($newState, $oldState,$tableOrderItems, $quantity) {

Let me know if you get it functioning, this facility would be very useful for anyone running 2 sites with one warehouse!!

[Milbo]

Interesting idea, but my preferred solution for this is to use two different ST addresses of the vendor as warehouse address.

[AH]

Hmm Milbo

Milbo, how do you then get an "immediate" update to the external dbase

Are you suggesting using the order e-mail as a syncing data source?

[ibanez0r]

administrator/components/com_virtuemart/models/product.php

I think this is where to look, as it is the function that updates the dbase.

2313:

Code Select Expand

public function updateStockInDB ($product, $amount, $signInStock, $signOrderedStock) {



You may want to consider how the order status change function handles the Reserved order statuses

For any status that is considered "reserved" the field 'product_ordered' is populated and the 'product_in_stock' is left alone, if you have long lead times for dispatch, this might cause an issue with stock being "called for" but not yet adjusted

See
administrator/components/com_virtuemart/models/orders.php

979:

Code Select Expand

function handleStockAfterStatusChangedPerProduct($newState, $oldState,$tableOrderItems, $quantity) {

Let me know if you get it functioning, this facility would be very useful for anyone running 2 sites with one warehouse!!

Thanks for the info, I did see this function and made a mental note to go back to it as a last resort i really wanted to find the code that calls it and got a little lost, im yet to attack this issue but i will jump back in soon and let you know how it goes,

Thanks again i appreciate any help i can get

Cheers

[ibanez0r]

well this is weird, i had a good play with updateStockInDB in the admin model, and could not get it to fire!  after adding exit(); on line 2 of this function the products still update when say editing quantity in the product admin, which tells me this function isnt doing the database update at all, its really frustrating i just want to call a func when a quantity changes, i think the only way im goin to figure this out will be with xdebug *sigh*

[Milbo]

I am still not sure I understand, what you want todo.

[ibanez0r]

I want to call a function everytime a product quantity changes in virtuemart.

[Milbo]

Write a plugin with the trigger

[ibanez0r]

At the start of the thread we were chatting about the trigger that occurs when a payment is processed which makes sence however i need to be able to monitor if say, someone were to modify a products quantity in the vm admin area too, and catch all instances of a product quantity being changed not just when a sale occurs, i guess this is where the issue is for me now, i found the  updateStockInDB in the product model but even when adding exit(0) onto line 2 of this function, and then updating a quantity in the admin area, it still updates, rendering this  updateStockInDB  method suggested useless, if i knew of a trigger or an event i could extend on i would def use it :/