File: examples/productqueryBox.lib

<?php

// Gets the list of products of the category
// entry: min, num
// exit: list
// params: category of products

class productqueryBox extends Box
{
  public function __construct()
  {
    parent::__construct();

    $this->addInput('CATEGORY', Box::STRING);
    $this->addInput('min', Box::INTEGER);
    $this->addInput('num', Box::INTEGER);

    $this->addOutput('list', Box::VECTORRECORD);
  }

  public function run()
  {
    // Simulates a connection to a database and gets back
    // 5 products if 'main' category, 3 products if 'other' category
    $min = trim($this->getInputData('min'));
    $num = trim($this->getInputData('num'));

    $CATEGORY = trim($this->getInputData('CATEGORY'));
    if ($CATEGORY != 'main' && $CATEGORY != 'other')
    {
      $CATEGORY = 'main';
    }

    // Here we should make a query like
    // select count(*) from products where category = '$CATEGORY' limit $num offset $min;

    if ($CATEGORY == 'main')
    {
      $products = array(
        array('{key}' => 1, '{name}' => 'Trousers', '{price}' => 12.5),
        array('{key}' => 2, '{name}' => 'Skirt', '{price}' => 11.5),
        array('{key}' => 3, '{name}' => 'Bicycle', '{price}' => 99.9),
        array('{key}' => 4, '{name}' => 'Ball', '{price}' => 5),
        array('{key}' => 5, '{name}' => 'Jewel', '{price}' => 125)
      );
    }
    else
    {
      $products = array(
        array('{key}' => 1, '{name}' => 'Trousers', '{price}' => 12.5),
        array('{key}' => 2, '{name}' => 'Skirt', '{price}' => 11.5),
        array('{key}' => 6, '{name}' => 'Skateboard', '{price}' => 24.9)
      );
    }

    // we filter num, min if needed, to simulate limit and offset
    $npr = array();
    $item = 0;
    foreach($products as $p)
    {
      if ($item++ < $min)
        continue;
      $npr[] = $p;
      if ($item >= $min + $num)
        break;
    }
    $products = $npr;

    $this->setOutputData('list', $products);
  }

}

?>