Пример #1
0
 function getEventList($date, $state)
 {
     $criteria = new AndStatement();
     $field = $this->eventDao->getQStateName();
     $criteria->addStatement($field . "='" . addslashes($state) . "'");
     $field = $this->eventDao->getQValid_DateName();
     if (is_array($date)) {
         $criteriaOr = new OrStatement();
         foreach ($date as $dt) {
             $criteriaOr->addStatement($field . " like'" . addslashes($dt) . "%'");
         }
         $criteria->addStatement($criteriaOr);
     } else {
         $criteria->addStatement($field . " like '" . addslashes($date) . "%'");
     }
     /*$criteriaOr = new OrStatement();
       $criteriaOr->addStatement($field ."='". addslashes($date) ."'");
       $criteriaOr->addStatement($field ."='". addslashes($this->minusDaysFromGetDate(1)) ."'");
       $criteriaOr->addStatement($field ."='". addslashes($this->minusDaysFromGetDate(2)) ."'");
       $criteria->addStatement($criteriaOr);*/
     $eventList = $this->eventDao->find($criteria, null, 1000);
     if (is_string($eventList)) {
         return false;
     } else {
         if (!is_array($eventList)) {
             return false;
         }
     }
     return $eventList;
 }
Пример #2
0
 function moveClientHistory($oldClient, $newClient)
 {
     $criteria = new AndStatement();
     $field = $this->eventHistoryDao->getQCidName();
     $criteria->addStatement($field . "='" . addslashes($oldClient->getId()) . "'");
     $order = new OrderBys();
     $sortField = $this->eventHistoryDao->getQIdName();
     $order->addField($sortField, true);
     $clientHistorys = $this->eventHistoryDao->find($criteria, $order, 1000);
     if (is_null($clientHistorys)) {
         $this->context->setRequestScopeAttr("error", "Nepavyko nuskaityti kliento istorijos");
         return false;
     } else {
         if (is_string($clientHistorys)) {
             $this->context->setRequestScopeAttr("error", "error.dberror");
             $this->context->setRequestScopeAttr("errortxt", $clientHistorys);
             $clientHistorys = null;
             return false;
         }
     }
     foreach ($clientHistorys as $history) {
         $history->setId(null);
         $history->setCid($newClient->getId());
         $this->eventHistoryDao->insert($history, true);
     }
     return true;
 }
Пример #3
0
 function actionSave($currentUser)
 {
     $backUrl = $this->context->getFlowScopeAttr("backUrl");
     $pass = null;
     $user = new User();
     $userErrs = array();
     $user->setId($this->context->getRequestAttr("id"));
     $user->setUser($this->context->getRequestAttr("email"));
     if (!is_null($user->getUser())) {
         $user->setUser(trim($user->getUser()));
         if (strlen($user->getUser()) < 1) {
             $user->setUser(null);
         }
     }
     if (is_null($user->getUser())) {
         $userErrs["email"] = "field.error.empty";
     } else {
         if (is_null($user->getId())) {
             $field = $this->userDao->getQUserName();
             $criteria = new AndStatement();
             $criteria->addStatement($field . "='" . htmlspecialchars($user->getUser()) . "'");
             $exUsers = $this->userDao->find($criteria, null, 1000);
             if (is_array($exUsers) and count($exUsers) > 0) {
                 $userErrs["email"] = "field.error.userExists";
             }
         }
     }
     $active = $this->context->getRequestAttr("active");
     $user->setActive($active == 1 ? true : false);
     if (is_null($user->getId())) {
         $pass = $this->generatePass();
         $user->setPassword($pass);
     }
     $timeZone = new DateTimeZone("Europe/Vilnius");
     $time = new DateTime("now", $timeZone);
     $user->setR_date($time->format("Y-m-d H:i:s"));
     $user->setR_user($currentUser->getId());
     $this->context->setFlashScopeAttr("user", $user);
     $this->context->setFlashScopeAttr("userErrs", $userErrs);
     if (count($userErrs) >= 1) {
         if (!is_null($backUrl)) {
             header("Location: " . $backUrl);
             return true;
         }
         return false;
     }
     $store = $this->storeUser($user);
     if (!$store) {
         if (!is_null($backUrl)) {
             header("Location: " . $backUrl);
             return true;
         }
         return false;
     }
     if (!is_null($pass)) {
         $this->sendNotification($user);
     }
     $this->cancelEdit();
     if (!is_null($backUrl)) {
         header("Location: " . $backUrl);
         return true;
     }
     return false;
 }
Пример #4
0
 private function getReport($code)
 {
     $criteria = new AndStatement();
     $field = $this->reportsDao->getQCodeName();
     $criteria->addStatement($field . "='" . htmlspecialchars($code) . "'");
     $reports = $this->reportsDao->find($criteria, null);
     if (is_null($reports) || is_string($reports) || count($reports) < 1) {
         return false;
     }
     return reset($reports);
 }
Пример #5
0
 function renderHistoryList($currentUser)
 {
     $user_id = $currentUser->getId();
     $userP = $this->context->getRequestAttr("user");
     $projectP = $this->context->getRequestAttr("project");
     $userProjects = null;
     $this->context->setFlowScopeAttr("currentUser", $currentUser);
     $order = new OrderBys();
     $sortField = $this->eventHistoryDao->getQR_dateName();
     $order->addField($sortField, false);
     if (!is_null($userP) && $userP != "0") {
         $criteriaUsr = new AndStatement();
         $field = $this->projectDao->getQOwnerName();
         $criteriaUsr->addStatement($field . "='" . addslashes($userP) . "'");
         $userProjects = $this->projectDao->find($criteriaUsr, null, 1000);
         if (!is_array($userProjects)) {
             $this->context->setRequestScopeAttr("error", "error.dberror");
             $this->context->setRequestScopeAttr("errortxt", $userProjects);
             $userProjects = null;
         }
         if (!is_null($userProjects)) {
             $criteriaIn = new InStatement();
             $field = $this->eventHistoryDao->getQPidName();
             $criteriaIn->setField($field);
             foreach ($userProjects as $userProject) {
                 $criteriaIn->addValue($userProject->getId());
             }
         }
     }
     $criteria = new AndStatement();
     if (!empty($criteriaIn)) {
         $criteria->addStatement($criteriaIn);
     }
     if (!is_null($projectP) && $projectP != "0") {
         $field = $this->eventHistoryDao->getQPidName();
         $criteria->addStatement($field . "='" . addslashes($projectP) . "'");
     }
     $history = $this->eventHistoryDao->find($criteria, $order, 1000);
     //$history = $this->eventHistoryDao->find((empty($criteriaIn) ? null : $criteriaIn), $order, 1000);
     $users = $this->userDao->find(null, null, 1000);
     if (!is_array($users)) {
         $this->context->setRequestScopeAttr("error", "error.dberror");
         $this->context->setRequestScopeAttr("errortxt", $users);
         $users = array();
     }
     if (!is_array($history)) {
         $this->context->setRequestScopeAttr("error", "error.dberror");
         $this->context->setRequestScopeAttr("errortxt", $history);
         $history = array();
     }
     $this->context->setRequestScopeAttr("history", $history);
     $projects = $this->projectDao->find(null, null, 1000);
     if (!is_array($projects)) {
         $this->context->setRequestScopeAttr("error", "error.dberror");
         $this->context->setRequestScopeAttr("errortxt", $projects);
         $projects = array();
     }
     $this->context->setRequestScopeAttr("projects", $projects);
     $stages = $this->stageDao->find(null, null, 1000);
     if (!is_array($stages)) {
         $this->context->setRequestScopeAttr("error", "error.dberror");
         $this->context->setRequestScopeAttr("errortxt", $stages);
         $stages = array();
     }
     $this->context->setRequestScopeAttr("stages", $stages);
     $clients = $this->clientDaol->find(null, null, 1000);
     if (!is_array($clients)) {
         $this->context->setRequestScopeAttr("error", "error.dberror");
         $this->context->setRequestScopeAttr("errortxt", $clients);
         $clients = array();
     }
     $this->context->setRequestScopeAttr("clients", $clients);
     $users = $this->userDao->find(null, null, 1000);
     if (!is_array($users)) {
         $this->context->setRequestScopeAttr("error", "error.dberror");
         $this->context->setRequestScopeAttr("errortxt", $users);
         $users = array();
     }
     $this->context->setFlowScopeAttr("users", $users);
     $rurls = array();
     $rurls["refresh"] = new SimpleUrl();
     $this->context->setFlowScopeAttr("backUrl", $rurls["refresh"]->getGetUrl());
     $aurls = $this->actionUrls;
     $texts = $this->texts;
     $model = $this->context->getModel();
     include "./view/historyList.php";
 }
Пример #6
0
 function getStageID($projectID, $stageNr, $getResponse)
 {
     $field = $this->stageDao->getQPidName();
     $criteria = new AndStatement();
     $criteria->addStatement($field . "=" . $projectID . "");
     $order = new OrderBys();
     $sortField = $this->stageDao->getQOrderisName();
     $order->addField($sortField, true);
     $stages = $this->stageDao->find($criteria, $order, 1000);
     if (is_null($stages)) {
         $stages = null;
     } else {
         if (is_string($stages)) {
             $stages = NULL;
         } else {
             if (!is_array($stages)) {
                 $stages = null;
             } else {
                 if (count($stages) == 0) {
                     $stages = null;
                 } else {
                     if (!isset($stages[$stageNr - 1])) {
                         $stages = null;
                     }
                 }
             }
         }
     }
     if (is_null($stages)) {
         $this->setParamPoz($getResponse->getId(), 2, "[09] Nepavyko rasti pirminio etapo");
         return false;
     }
     return $stages[$stageNr - 1];
 }
Пример #7
0
 function getLastStage($projectID)
 {
     $criteria = new AndStatement();
     $field = $this->stageDao->getQPidName();
     $criteria->addStatement($field . "='" . addslashes($projectID) . "'");
     $order = new OrderBys();
     $sortField = $this->stageDao->getQOrderisName();
     $order->addField($sortField, false);
     $stages = $this->stageDao->find($criteria, $order, 1000);
     if (!is_array($stages)) {
         $this->context->setRequestScopeAttr("error", "error.dberror");
         $this->context->setRequestScopeAttr("errortxt", $stages);
         $stages = null;
     } else {
         if (count($stages) == 0) {
             $stages = null;
         }
     }
     if (is_null($stages)) {
         return false;
     }
     return reset($stages);
 }
Пример #8
0
 function generateEventsForView($clients)
 {
     $eventsArray = array();
     $IDfield = $this->eventDao->getQIdName();
     $Pfield = $this->eventDao->getQPidName();
     $Cfield = $this->eventDao->getQCidName();
     foreach ($clients as $client) {
         $criteria = new AndStatement();
         $criteria->addStatement($Pfield . "=" . addslashes($client->getPid()));
         $criteria->addStatement($Cfield . "=" . addslashes($client->getId()));
         $order = new OrderBys();
         $order->addField($IDfield, true);
         $events = $this->eventDao->find($criteria, $order, 1000);
         if (!is_array($events)) {
             $events = null;
         } else {
             if (count($events) == 0) {
                 $events = null;
             }
         }
         if (!is_null($events)) {
             foreach ($events as $event) {
                 if (!isset($eventsArray[$client->getId()])) {
                     $eventsArray[$client->getId()] = array();
                 }
                 array_push($eventsArray[$client->getId()], $event);
             }
         }
     }
     return $eventsArray;
 }
Пример #9
0
 function loginAction()
 {
     $username = $this->context->getRequestAttr("user");
     $passwd = $this->context->getRequestAttr("password");
     $currentUser = null;
     $usernameField = $this->userDao->getQUserName();
     $passwdField = $this->userDao->getQPasswordName();
     $criteria = new AndStatement();
     $criteria->addStatement($usernameField . "='" . addslashes($username) . "'");
     $criteria->addStatement($passwdField . "='" . addslashes($passwd) . "'");
     $users = $this->userDao->find($criteria);
     if (is_array($users)) {
         foreach ($users as $user) {
             $currentUser = $user;
             break;
         }
     }
     if (is_null($currentUser)) {
         $this->context->setRequestScopeAttr("error", "user.error.badlogin");
     } else {
         if (!$currentUser->isActive()) {
             $currentUser = null;
             $this->context->setRequestScopeAttr("error", "user.error.suspended");
         }
     }
     if (is_null($currentUser)) {
         $this->context->setFlowScopeAttr("currentUser", $currentUser);
         $this->context->setRequestScopeAttr("login", true);
         return false;
     }
     $this->context->setFlowScopeAttr("currentUser", $currentUser);
     $this->context->setRequestScopeAttr("login", true);
     return false;
 }
Пример #10
0
 function chechProjectCruid()
 {
     $projectCruid = $this->context->getRequestAttr("project");
     if (is_null($projectCruid) || !isset($projectCruid)) {
         return false;
     }
     $field = $this->projectDao->getQCruidName();
     $criteria = new AndStatement();
     $criteria->addStatement($field . "='" . addslashes($projectCruid) . "'");
     $projects = $this->projectDao->find($criteria, null, 1000);
     if (is_null($projects)) {
         return false;
     } else {
         if (is_string($projects)) {
             return false;
         } else {
             if (!is_array($projects)) {
                 return false;
             } else {
                 if (count($projects) == 0) {
                     return false;
                 }
             }
         }
     }
     $project = reset($projects);
     $this->context->setFlowScopeAttr("currentProject", $project);
     return true;
 }