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();
     }
     $eventHistorys = array();
     while ($row = $result->fetchRow()) {
         $eventHistory = new EventHistory();
         $value = $row[0];
         $eventHistory->setId($value);
         $value = $row[1];
         $eventHistory->setPid($value);
         $value = $row[2];
         $eventHistory->setCid($value);
         $value = $row[3];
         $eventHistory->setSid($value);
         $value = $row[4];
         $eventHistory->setEid($value);
         $value = $row[5];
         $eventHistory->setValid_date($value);
         $value = $row[6];
         $eventHistory->setReminde_date($value);
         $value = $row[7];
         $eventHistory->setAmount($value);
         $value = $row[8];
         $eventHistory->setState($value);
         $value = $row[9];
         $eventHistory->setComment($value);
         $value = $row[10];
         $eventHistory->setBalance($value);
         $value = $row[11];
         $eventHistory->setR_date($value);
         $value = $row[12];
         $eventHistory->setDescription($value);
         if ($order != null) {
             array_push($eventHistorys, $eventHistory);
         } else {
             $eventHistorys[$eventHistory->getId()] = $eventHistory;
         }
     }
     return $eventHistorys;
 }
Esempio n. 2
0
 function actionSaveEvent($currentProject)
 {
     $backUrl = $this->context->getFlowScopeAttr("backUrl");
     $arUzbaigtas = $this->context->getRequestAttr("uzbaigtas");
     $renderNew = $this->context->getRequestAttr("rendernew");
     $renderNew = $renderNew == "1" ? $renderNew : "0";
     $timeZone = new DateTimeZone("Europe/Vilnius");
     $time = new DateTime("now", $timeZone);
     $eventErrs = array();
     $eventID = $this->context->getRequestAttr("id");
     $state = $this->context->getRequestAttr("state");
     if (is_null($eventID)) {
         $this->context->setRequestScopeAttr("errortxt", "stage.error.notfound");
         if (!is_null($backUrl)) {
             header("Location: " . $backUrl);
             return true;
         }
         return false;
     }
     $event = $this->eventDao->get($eventID);
     if (is_null($event)) {
         $this->context->setRequestScopeAttr("error", "stage.error.notfound");
         $this->cancelEditEvent();
         return false;
     } else {
         if (is_string($event)) {
             $this->context->setRequestScopeAttr("error", "error.dberror");
             $this->context->setRequestScopeAttr("errortxt", $event);
             $event = null;
             $this->cancelEditEvent();
             return false;
         }
     }
     $stage = $this->stageDao->get($event->getSid());
     if (!is_object($stage)) {
         $this->context->setRequestScopeAttr("error", "stage.error.notfound");
         $this->cancelEditEvent();
         return false;
     }
     $client = $this->clientDaol->get($event->getCid());
     if (!is_object($client)) {
         $this->context->setRequestScopeAttr("error", "client.error.notfound");
         $this->cancelEditEvent();
         return false;
     }
     $event->setR_date($time->format("Y-m-d H:i:s"));
     $event->setComment($this->context->getRequestAttr("comment"));
     if (!is_null($event->getComment())) {
         $event->setComment(trim($event->getComment()));
         if (strlen($event->getComment()) < 1) {
             $event->setComment(null);
         }
     }
     #region BALANCE
     $eventCopy = clone $event;
     $event->setIncome($this->context->getRequestAttr("income"));
     if (!is_null($event->getIncome())) {
         $event->setIncome(trim($event->getIncome()));
         if (strlen($event->getIncome()) < 1) {
             $event->setIncome(null);
         }
     }
     if (!is_null($event->getIncome()) && !is_numeric($event->getIncome())) {
         $eventErrs['balanse'] = true;
     }
     $event->setCost($this->context->getRequestAttr("cost"));
     if (!is_null($event->getCost())) {
         $event->setCost(trim($event->getCost()));
         if (strlen($event->getCost()) < 1) {
             $event->setCost(null);
         }
     }
     if (!is_null($event->getCost()) && !is_numeric($event->getCost())) {
         $eventErrs['balanse'] = true;
     }
     $event->setWasted_time($this->context->getRequestAttr("wasted_time"));
     if (!is_null($event->getWasted_time())) {
         $event->setWasted_time(trim($event->getWasted_time()));
         if (strlen($event->getWasted_time()) < 1) {
             $event->setWasted_time(null);
         }
     }
     if (!is_null($event->getWasted_time()) && !is_numeric($event->getWasted_time())) {
         $eventErrs['balanse'] = true;
     }
     $this->context->setFlashScopeAttr("event", $event);
     $this->context->setFlashScopeAttr("eventErrs", $eventErrs);
     if (count($eventErrs) >= 1) {
         if (!is_null($backUrl)) {
             header("Location: " . $backUrl);
             return true;
         }
         return false;
     }
     $event->setState(2);
     /* PELNAS */
     $income = !is_null($event->getIncome()) ? $event->getIncome() : 0;
     $cost = !is_null($event->getCost()) ? $event->getCost() : 0;
     if ($income != 0 || $cost != 0) {
         $profit = $income - $cost;
     }
     if ($profit) {
         $event->setProfit($profit);
     }
     if (!is_null($eventCopy->getIncome())) {
         if (!is_null($event->getIncome())) {
             $event->setIncome($eventCopy->getIncome() + $event->getIncome());
         } else {
             $event->setIncome($eventCopy->getIncome());
         }
     }
     if (!is_null($eventCopy->getCost())) {
         if (!is_null($event->getCost())) {
             $event->setCost($eventCopy->getCost() + $event->getCost());
         } else {
             $event->setCost($eventCopy->getCost());
         }
     }
     if (!is_null($eventCopy->getProfit())) {
         if (!is_null($event->getProfit())) {
             $event->setProfit($eventCopy->getProfit() + $event->getProfit());
         } else {
             $event->setProfit($eventCopy->getProfit());
         }
     }
     if (!is_null($eventCopy->getWasted_time())) {
         if (!is_null($event->getWasted_time())) {
             $event->setWasted_time($eventCopy->getWasted_time() + $event->getWasted_time());
         } else {
             $event->setWasted_time($eventCopy->getWasted_time());
         }
     }
     #endregion
     $store = $this->storeEvent($event, $stage, $renderNew);
     if (!$store) {
         if (!is_null($backUrl)) {
             header("Location: " . $backUrl);
             return true;
         }
         return false;
     }
     $eventHistory = new EventHistory();
     $eventHistory->setDescription("Etapo užbaigimas");
     $eventHistory->setPid($event->getPid());
     $eventHistory->setCid($event->getCid());
     $eventHistory->setSid($event->getSid());
     $eventHistory->setEid($event->getId());
     $eventHistory->setValid_date($event->getValid_date());
     $eventHistory->setReminde_date($event->getReminde_date());
     $eventHistory->setState($event->getState());
     $eventHistory->setComment($event->getComment());
     $eventHistory->setR_date($event->getR_date());
     $balance = "";
     if (!is_null($event->getIncome())) {
         $balance .= (!empty($balance) ? "<br />" : "") . 'Pajamos - ' . $event->getIncome() . '€';
     }
     if (!is_null($event->getCost())) {
         $balance .= (!empty($balance) ? "<br />" : "") . 'Išlaidos - ' . $event->getCost() . '€';
     }
     if (!is_null($event->getProfit())) {
         $balance .= (!empty($balance) ? "<br />" : "") . 'Pelnas (nuostolis) - ' . $event->getProfit() . '€';
     }
     if (!is_null($event->getWasted_time())) {
         $balance .= (!empty($balance) ? "<br />" : "") . 'Sugaištas laikas - ' . $event->getWasted_time() . 'min.';
     }
     if (!empty($balance)) {
         $eventHistory->setBalance($balance);
     }
     $this->storeEventHistory($eventHistory);
     if ($stage->getEnded_stage() != 0) {
         $action = $stage->getEnded_stage() == 1 ? "copy" : "move";
         $projects = explode(",", $stage->getEnded_stage_pid());
         foreach ($projects as $projectId) {
             $this->moveCopyClient($client, $projectId, $action);
         }
     }
     $this->cancelEditEvent();
     if (!is_null($backUrl)) {
         header("Location: " . $backUrl);
         return true;
     }
     return false;
 }