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