Delete a Order does not remove phoca invoice

[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.

[Jan]

Hi, thank you for the guide.

Jan