On the hook_entity_insert and hook_entity_update I generate an invoice of the order status is changed to success.

To generate part of that invoice I use: 

$view = entity_view('commerce_order', array($commerce_order->order_id => $commerce_order), $view_mode='full', NULL, TRUE);

Where $commerce_order is the commerce_order entity.

The line items give when an No line items found when a payment is completed, BUT the strange thing, this code works fine when drupal is in maintenance mode. However when i put the drupal site online entity_view start returning No line items found instead of the products.

I checked the $commerce_order entity to make sure the products are in the in object. They are there, however entity_view in maintenance mode give the expected result, but when online it always gives No line items found.

This doesn't happen when the order is created manually or when the order gets updated, the scripts and entity_view works as it should.

I tried to:
- flush cache before calling the view
- Use commerce_order_ui_order_view to call the order.
- Use different view modes, like full, administrator, invoice.

I've run out of idea's I can't figure out why this doesn't work in the online version of drupal.

Comments

redsd’s picture

redsd commented

Used a quickfix to get around this bug, by building my own product list.

  $line_item_ids = array();
  foreach($commerce_order->commerce_line_items['und'] as $line_item){
    $line_item_ids[] = $line_item["line_item_id"];
  }
  
  $line_items_info = commerce_line_item_load_multiple($line_item_ids);
  $rows = array();
  foreach($line_items_info as $line_item_info){
    
    if($line_item_info->type == 'product'){
      $row = array();
      
      $product = commerce_product_load_by_sku($line_item_info->line_item_label);
      $row['sku'] = $product->sku;
      $row['titel'] = $product->title;
      $row['aantal'] = $line_item_info->quantity;
      $row['stuk_prijs'] = commerce_currency_format($line_item_info->commerce_unit_price["und"][0]["amount"], $line_item_info->commerce_unit_price["und"][0]["currency_code"]);
      $row['totaal_prijs'] =  commerce_currency_format($line_item_info->commerce_total["und"][0]["amount"], $line_item_info->commerce_total["und"][0]["currency_code"]);
      
      $rows[] = $row;
    }
  }
  //Create table
  $header = array('Artikelnummer', 'Product', 'Aantal', 'Prijs', 'Totaal');
  $table_attributes = array( 'class' => array('views-table'),'id' => 'producten-tabel',); 
  $producten_tabel = theme('table', array('header' => $header, 'rows' => $rows, 'attributes' => $table_attributes));

$producten_tabel gives the product list that is in the order.
Some of the code is dutch, sorry for not translating ;)