function find($criteria = null, $order = null, $limit = 1000, $from = 0) { $result = $this->database->query($this->buildFindQuery($criteria, $order, $limit, $from)); if (!is_null($result->getError())) { return $result->getError(); } $events = array(); while ($row = $result->fetchRow()) { $event = new Event(); $value = $row[0]; $event->setId($value); $value = $row[1]; $event->setPid($value); $value = $row[2]; $event->setCid($value); $value = $row[3]; $event->setSid($value); $value = $row[4]; $event->setValid_date($value); $value = $row[5]; $event->setReminde_date($value); $value = $row[6]; $event->setAmount($value); $value = $row[7]; $event->setState($value); $value = $row[8]; $event->setMoved($value); $value = $row[9]; $value = $this->database->toBoolean($value); $event->setDelay($value); $value = $row[10]; $event->setDelays($value); $value = $row[11]; $event->setComment($value); $value = $row[12]; $event->setIncome($value); $value = $row[13]; $event->setCost($value); $value = $row[14]; $event->setProfit($value); $value = $row[15]; $event->setWasted_time($value); $value = $row[16]; $event->setR_date($value); $value = $row[17]; $event->setDate($value); if ($order != null) { array_push($events, $event); } else { $events[$event->getId()] = $event; } } return $events; }