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)); }