Example #1
0
 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;
 }