gistfile1.txt

  public function getPickingArray ()
  {
    $dbi = SparkDBI::getInstance();

    $purchased = $dbi->fetchAllRows(
      'select products_id as id, products_quantity as qty
       from orders_products
       where orders_id = ' . $dbi->escape($this->id())
    );

    $picked = $dbi->fetchAllRows(
      'select products_id as id, adjustment_amount_physical * -1 as qty
       from products_stock_adjustments
       where adjustment_amount_physical < 0
       and orders_id = ' . $dbi->escape($this->id())
    );

    return array('picked' => $picked, 'purchased' => $purchased);
  }

  public function ensurePicked ()
  {
    $items = $this->getPickingArray();

    if (count($items['purchased']) != count($items['picked']))
      return false;

    return true;
  }

  public function ensureUnpicked ()
  {
    $items = $this->getPickingArray();

    if (count($items['picked']))
      return false;

    return true;
  }