SS3_report

<?php
class OrdersWithLineItems extends SS_Report
{
  public function title()
  {
    return 'Orders with Line Items';
  }

  public function sourceRecords($params, $sort, $limit)
  {
    $ordersAL = new ArrayList();

    $OrderHeaders = OrderHeader::get();

    foreach ($OrderHeaders as $OrderHeader) {
      foreach ($OrderHeader->OrderItems() as $OrderItem) {
        $OrderHeaderArr = new DataObject($OrderHeader->toMap());

        $OrderHeaderArr->ProductCode     = $OrderItem->Product()->PartNumber;
        $OrderHeaderArr->ProductQuantity = $OrderItem->Quantity;

        $ordersAL->push($OrderHeaderArr);
      }
    }

    return $ordersAL;
  }


  public function columns()
  {
    $fields = array(
      'StripeID' => array(
        'title' => 'Stripe ID'
      ),
      'OrderTotal' => array(
        'title' => 'Order Total'
      ),
      'SalesTax' => array(
        'title' => 'Sales Tax'
      ),
      'SalesTaxCity' => array(
        'title' => 'Sales Tax City'
      ),
      'SalesTaxState' => array(
        'title' => 'Sales Tax State'
      ),
      'SalesTaxZip' => array(
        'title' => 'Sales Tax Zip'
      ),
      'OrderComplete' => array(
        'title' => 'Order Complete'
      ),
      'Email' => array(
        'title' => 'Email'
      ),
      'PromoCode' => array(
        'title' => 'Promo Code'
      ),
      'ProductCode' => array(
        'title' => 'Product Code'
      ),
      'ProductQuantity' => array(
        'title' => 'Product Quantity'
      ),
    );

    return $fields;
  }
}