public function findAllFieldsAnOptions()
{
$fields = $this->fieldRepository->findAll();
foreach ($fields as $k => $field) {
$fields[$k]['options'] = $this->optionRepository->findBy(['field_id' => $field->getId()], Sql::orderBy('id'));
}
return $fields;
}
public function get()
{
$limit = 10;
$start = filter_input(INPUT_GET, 'start') ?: 0;
$this->collection->setCondition(['id >' => $start]);
$products = $this->collection->fetchAll(Sql::orderBy('id')->limit($limit));
foreach ($products as $product) {
$product->url = $this->editProductRoute->createUri($product->id);
}
$response = ['product/productList' => true, 'productList' => $products, 'self' => $_SERVER['REQUEST_URI']];
if (count($products) == $limit) {
$response['next'] = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH) . "?start=" . end($products)->id;
}
if ($start >= 0) {
$response['prev'] = parse_url($_SERVER['REQUEST_URI'], PHP_URL_PATH) . "?start=" . max($start - $limit, 0);
}
return $response;
}
public function test_extra_sql_on_fetchAll_should_be_applied_on_mapper_sql()
{
$expectedComments = array_reverse($this->comments);
$fetchedComments = $this->mapper->comment->fetchAll(Sql::orderBy('id DESC'));
$this->assertEquals($expectedComments, $fetchedComments);
}
/**
* @param Object $field
* @param String $order
* @return ArrayObject Options of field
*/
public function getOptionsOfField($field, $order)
{
return $this->repository->findBy(['field_id' => $field->id], Sql::orderBy($order));
}
