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; }
function saveNewEvent($event, $renderNew = null) { $pid = $event->getPid(); $cid = $event->getCid(); $sid = $this->getNextStage($pid, $event->getSid()); if (!$sid) { return false; } $timeZone = new DateTimeZone("Europe/Vilnius"); $time = new DateTime("now", $timeZone); $newValidDate = $this->countEventTime($sid->getPeriod_type(), $sid->getPeriod()); $eventNew = new Event(); $eventNew->setPid($pid); $eventNew->setCid($cid); $eventNew->setSid($sid->getId()); $eventNew->setState(1); $eventNew->setValid_date($newValidDate["validateDate"]); $eventNew->setReminde_date($newValidDate["remindeDate"]); $eventNew->setR_date($time->format("Y-m-d H:i:s")); $store = $this->storeEvent($eventNew, false, false); if (!$store) { return false; } if ($renderNew == "0") { $this->context->setFlashScopeAttr("eventNext", $eventNew); $eventErrs = array(); $this->context->setFlashScopeAttr("eventErrs", $eventErrs); } else { $this->context->setFlashScopeAttr("eventNext", null); $this->context->setFlashScopeAttr("event", null); } return true; }
function saveFirsEvent($client, $getResponse) { $projectID = $client->getPid(); $clientID = $client->getId(); $stage = $this->getStageID($projectID, 1, $getResponse); if (!$stage) { return false; } $stageID = $stage->getID(); $event = new Event(); $event->setPid($projectID); $event->setCid($clientID); $event->setSid($stageID); $event->setState(0); $event->setR_date(Date::getCurrentDatr()); $event->setDate(Date::getCurrentDatr()); $store = $this->storeEvent($event, $getResponse); if (!$store) { return false; } return true; }
function saveFirsEvent($client) { $projectID = $client->getPid(); $clientID = $client->getId(); $stage = $this->getStageID($projectID, 1); if (!$stage) { return false; } $stageID = $stage->getID(); $event = new Event(); $validDate = $this->countEventTime($stage->getPeriod_type(), $stage->getPeriod()); $event->setPid($projectID); $event->setCid($clientID); $event->setSid($stageID); $event->setState(1); $event->setValid_date($validDate["validateDate"]); $event->setReminde_date($validDate["remindeDate"]); $event->setR_date(Date::getCurrentDatr()); $event->setDate(Date::getCurrentDatr()); $store = $this->storeEvent($event, false, false); if (!$store) { return false; } return true; }