Page 1 of 1

Delete a Order does not remove phoca invoice

Posted: 08 Aug 2011, 19:54
by mrtsilva
Hello again,

Normally, no order will be deleted but if for some reason you need this functionality do this.

administrator/components/com_virtuemart/classes/ps_order.php

Code: Select all

function delete_record( $record_id, &$d ) {
......
  $q = "DELETE FROM #__{vm}_shipping_label where order_id=$record_id";
  $db->query($q);

  // Start MOD DELETE PHOCA INFO
  $q = "DELETE FROM #__{vm}_delivery_item where order_id=$record_id";
  $db->query($q);
  $q = "DELETE FROM #__{vm}_deliveries where order_id=$record_id";
  $db->query($q);
  $q = "DELETE FROM #__{vm}_bills where order_id=$record_id";
  $db->query($q);
  // ENDt MOD DELETE PHOCA INFO

  return True;
....
}
Hope this can help someone and be integrated in a next version.
Bye.

Re: Delete a Order does not remove phoca invoice

Posted: 12 Aug 2011, 22:48
by Jan
Hi, thank you for the guide.

Jan