function commerce_line_item_ui_orphans_count in Commerce Core 7

Returns the number of orphaned line items in the database.

2 calls to commerce_line_item_ui_orphans_count()

commerce_line_item_ui_delete_orphaned_line_items in modules/line_item/includes/commerce_line_item_ui.admin.inc

Batch callback: deletes 50 orphaned line items at a time.

commerce_line_item_ui_orphaned_line_items_form in modules/line_item/includes/commerce_line_item_ui.admin.inc

Form callback: builds the form to delete orphaned line items.

File

modules/line_item/includes/commerce_line_item_ui.admin.inc, line 47

Admin forms for line items.

Code

function commerce_line_item_ui_orphans_count() {
  $query = db_select('commerce_line_item', 'cli')
    ->fields('cli', array(
    'line_item_id',
  ));
  $order_alias = $query
    ->leftJoin('commerce_order', 'co', '%alias.order_id = cli.order_id');
  return $query
    ->isNull("{$order_alias}.order_id")
    ->countQuery()
    ->execute()
    ->fetchField();
}