/** * * @param string $psValue * @return \User\Entity\User */ public function setStUsername($psValue) { $psValue = trim($psValue); if (!empty($psValue)) { $this->stUsername = String::escapeString($psValue); } return $this; }
/** * * @param int $pnValue * @return \Person\Entity\Person */ public function setUser_id($pnValue) { $this->User_id = null; if (!empty($pnValue)) { $this->User_id = (int) String::escapeString($pnValue); } return $this; }
public function getList($paParams, $pbCache = false) { $paParams['col'] = String::escapeString($paParams['col']); $paParams['ord'] = String::escapeString($paParams['ord']); $paParams['page'] = String::escapeString($paParams['page']); $paParams['rows'] = String::escapeString($paParams['rows']); $loQB = $this->getEntityManager()->createQueryBuilder(); $loQB->from("{$this->_entityName}", 'a'); $loQB->where("1=1"); if (isset($paParams['status']) && is_numeric($paParams['status'])) { $loQB->andWhere("a.numStatus = {$paParams['status']}"); } if (isset($paParams['active']) && is_numeric($paParams['active'])) { $loQB->andWhere("a.isActive = '{$paParams['active']}'"); } if (!empty($paParams['dtPeriodInit']) && !empty($paParams['dtPeriodEnd'])) { $loQB->andWhere("(a.dtInsert BETWEEN '{$paParams['dtPeriodInit']}' AND '{$paParams['dtPeriodEnd']}')"); } else { if (!empty($paParams['dtPeriodInit'])) { $loQB->andWhere("a.dtInsert >= '{$paParams['dtPeriodInit']}'"); } elseif (!empty($paParams['dtPeriodEnd'])) { $loQB->andWhere("a.dtInsert <= '{$paParams['dtPeriodEnd']}'"); } } if (!empty($paParams['stIP'])) { $loQB->andWhere("a.stIP = '{$paParams['stIP']}'"); } if (!empty($paParams['User_id'])) { $loQB->andWhere("a.User_id = '{$paParams['User_id']}'"); } if (isset($paParams['where'])) { if (is_array($paParams['where'])) { foreach ($paParams['where'] as $lsWhere) { if (!empty($lsWhere)) { $loQB->andWhere("{$lsWhere}"); } } } else { if (!empty($paParams['where'])) { $loQB->andWhere("{$paParams['where']}"); } } } $loQB->select("count('a') AS qt"); $loQB->distinct(); //Debug::display($loQB->getDql()); $loQueryPaginator = $loQB->getQuery(); $loQB->select('a'); $lsOrderField = $paParams['col']; if (!preg_match("/^[a-z]+\\./", $lsOrderField)) { $lsOrderField = "a.{$lsOrderField}"; } $loQB->orderBy("{$lsOrderField}", "{$paParams['ord']}"); //Debug::display($loQB->getDql()); $loQuery = $loQB->getQuery(); if ($paParams['rows'] > 0) { $loQuery->setFirstResult($paParams['page']); $loQuery->setMaxResults($paParams['rows']); } if (!$pbCache) { $loQuery->expireResultCache(true); } else { $loQuery->setResultCacheDriver(new ApcCache()); $loQuery->useResultCache(true); $loQuery->setResultCacheLifeTime(3600); } $laObjectResults = $loQuery->getResult(); $laArrayResults = null; $lnTotalCount = 0; if (is_array($laObjectResults)) { foreach ($laObjectResults as $loRes) { $laArrayResults[] = $loRes->getFormatedData(); $lnTotalCount++; } } if ($paParams['rows'] > 0) { $laPaginatorResult = $loQueryPaginator->getResult(); if (isset($laPaginatorResult[0]['qt'])) { $lnTotalCount = $laPaginatorResult[0]['qt']; } } return array('resultSet' => $laArrayResults, 'totalCount' => $lnTotalCount); }
/** * * @return \Onion\View\Model\ViewModel */ public function forgottenPasswordAction() { $loForm = Application::factory($this->_sForgotten); $loForm->setObjectManager($this->getEntityManager()); $loForm->setActionType('forgotten'); $loForm->setEntity($this->_sEntity); $loForm->setForm(); $lsSecurity = $this->requestPost('security', null); if ($this->requestIsPost() && $lsSecurity !== null) { $loForm->setInputFilter($loForm->getInputFilter()); $loForm->setData($this->requestPost()); if ($loForm->isValid()) { $laData = $loForm->getDataForm(); $lsEmail = String::escapeString($laData['stEmail']); $loEntityManager = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default'); $loUser = $loEntityManager->getRepository($this->_sEntity)->findOneBy(array('stEmail' => $lsEmail)); $lsPassword = String::generatePassword(); if ($this->sendPasswordByEmail($lsEmail, $lsPassword)) { $loUser->setStPassword($lsPassword); $loEntityManager->persist($loUser); $loEntityManager->flush(); } } } return new ViewModel(array('lsTitle' => $this->_sForgottenTitle, 'lsRoute' => $this->_sRoute, 'loForm' => $loForm)); }
public function isValid() { $lbValid = parent::isValid(); if ($this->getActionType() == 'add') { $laFindBy = $this->getObjectManager()->getRepository($this->getEntity())->findBy(array('stName' => String::escapeString($this->data['stName']))); if (isset($laFindBy[0]) && is_object($laFindBy[0])) { $lbValid = false; $this->get('stName')->setMessages(array(Translator::i18n('Este nome de grupo já está sendo utilizado!'))); } } else { $this->data['stName'] = $this->getEntityData()->get('stName'); } return $lbValid; }
public function isValidx() { $lbValid = parent::isValid(); if ($this->getActionType() == 'add') { $loFound = $this->getObjectManager()->getRepository($this->_sEntity)->findOneBy(array('stUsername' => String::escapeString($this->data['stUsername']))); if (is_object($loFound)) { $lbValid = false; $this->get('stUsername')->setMessages(array(Translator::i18n('Este nome de usuário já está sendo utilizado!'))); } $loFound = $this->getObjectManager()->getRepository($this->_sEntity)->findOneBy(array('stEmail' => String::escapeString($this->data['stEmail']))); if (is_object($loFound)) { $lbValid = false; $this->get('stEmail')->setMessages(array(Translator::i18n('Este email de contato já está sendo utilizado!'))); } if ($this->data['stPassword'] != $this->data['stConfirmation']) { $lbValid = false; $this->get('stConfirmation')->setMessages(array(Translator::i18n('A confirmação da senha não confere!'))); } } else { $this->data['stUsername'] = $this->getEntityData()->get('stUsername'); $loFound = $this->getObjectManager()->getRepository($this->_sEntity)->findOneBy(array('stEmail' => String::escapeString($this->data['stEmail']))); if (is_object($loFound) && $loFound->get('id') != $this->data['id']) { $lbValid = false; $this->get('stEmail')->setMessages(array(Translator::i18n('Este email de contato já está sendo utilizado!'))); } if (!empty($this->data['stOldPassword'])) { $lsPasswordGiven = String::encriptPassword($this->data['stOldPassword'], $this->getEntityData()->get('stPasswordSalt')); if ($lsPasswordGiven == $this->getEntityData()->get('stPassword')) { if ($this->data['stOldPassword'] != $this->data['stPassword']) { if ($this->data['stPassword'] != $this->data['stConfirmation']) { $lbValid = false; $this->get('stConfirmation')->setMessages(array(Translator::i18n('A confirmação não confere com a senha!'))); } } else { $lbValid = false; $this->get('stPassword')->setMessages(array(Translator::i18n('A nova senha deve ser diferente da senha atual!'))); } } else { $lbValid = false; $this->get('stOldPassword')->setMessages(array(Translator::i18n('A senha atual não confere com a registrada!'))); } } else { $this->data['stPassword'] = $this->getEntityData()->get('stPassword'); } } return $lbValid; }
/** * Populate from an array. * * @param array $paData */ public function populate($paData = array()) { if (is_array($paData)) { foreach ($paData as $lsProperty => $lmValue) { if (property_exists($this, $lsProperty)) { $lsMethod = 'set' . ucfirst($lsProperty); if (method_exists($this, $lsMethod)) { $this->{$lsMethod}($lmValue); } else { $this->{$lsProperty} = String::escapeString($lmValue); } } } } }
public function search($paParams, $pbCache = false) { $paParams['col'] = String::escapeString($paParams['col']); $paParams['ord'] = String::escapeString($paParams['ord']); $paParams['rows'] = String::escapeString($paParams['rows']); $loQB = $this->getEntityManager()->createQueryBuilder(); $loQB->from("{$this->_entityName}", 'a'); $loQB->where("a.numStatus = {$paParams['status']}"); $loQB->andWhere("a.isActive = '{$paParams['active']}'"); if (isset($paParams['where'])) { if (is_array($paParams['where'])) { foreach ($paParams['where'] as $lsWhere) { if (!empty($lsWhere)) { $loQB->andWhere("{$lsWhere}"); } } } else { if (!empty($paParams['where'])) { $loQB->andWhere("{$paParams['where']}"); } } } $loQB->distinct(); $loQB->select('a'); $lsOrderField = $paParams['col']; if (!preg_match("/^[a-z]+\\./", $lsOrderField)) { $lsOrderField = "a.{$lsOrderField}"; } $loQB->orderBy("{$lsOrderField}", "{$paParams['ord']}"); //Debug::display($loQB->getDql()); $loQuery = $loQB->getQuery(); if ($paParams['rows'] > 0) { $loQuery->setMaxResults($paParams['rows']); } if (!$pbCache) { $loQuery->expireResultCache(true); } else { $loQuery->setResultCacheDriver(new ApcCache()); $loQuery->useResultCache(true); $loQuery->setResultCacheLifeTime(3600); } $laObjectResults = $loQuery->getResult(); $laArrayResults = null; $lnTotalCount = 0; if (is_array($laObjectResults)) { foreach ($laObjectResults as $loRes) { $laArrayResults[] = $loRes->getFormatedData(); $lnTotalCount++; } } return array('resultSet' => $laArrayResults, 'totalCount' => $lnTotalCount); }
/** * * @param string $psQuery * @param string $psOrder * @return boolean|string */ public function createFullTextQuery($psQuery, $psOrder = "r") { $this->startTime(); $this->_sOriginalQuery = trim(String::escapeString($psQuery)); $lsOrderBy = "relevance DESC, dtInsert DESC"; if ($psOrder == "d") { $lsOrderBy = "dtInsert DESC, relevance DESC"; } if (empty($this->_sOriginalQuery) && $psOrder == "r") { $this->_nError = '1'; return false; } elseif (!empty($this->_sOriginalQuery)) { $this->setSearchType(); // $this->stopWords(); $this->cutString(); $this->createRLikeTerm(); if ($this->_sSearchType != "expression") { $this->_sQuery = "'{$this->_sQuery}' IN BOOLEAN MODE"; } else { $this->_sQuery = "'{$this->_sQuery}'"; } $lsWhere = "AND MATCH ({$this->_sSearchFields}) AGAINST ({$this->_sQuery})"; $lsRelevancia = "MATCH ({$this->_sSearchFields}) AGAINST ({$this->_sQuery})"; if (is_array($this->_sSearchFields)) { $lsOr = ""; foreach ($this->_sSearchFields as $lsKey => $lsField) { $lsWhere .= $lsOr . "{$lsField} {$this->_sQuery}"; $lsOr = " OR "; } } elseif (!empty($this->_sSearchFields)) { $lsWhere .= "{$this->_sSearchFields} {$this->_sQuery}"; } } else { $lsWhere = ""; } return $this->_sWhere = $lsWhere; }