public function updateGroupsRows($text, $id, $sportId)
{
if ($this->conn->checkAdmin()) {
$int = new Zend_Validate_Int();
if (!$int->isValid($id)) {
return $this->test;
}
if (!$int->isValid($sportId)) {
return $this->test;
}
$validator = new Zend_Validate_StringLength(2, 100);
if (!$validator->isValid($text)) {
return $this->test;
}
$query = "CALL updateGroups('" . $text . "','" . $id . "');";
$result = $this->conn->insert($query);
$query = "CALL selectGroups( '" . $sportId . "');CALL selectSports( )";
$result->message = $this->conn->multiresultbackArray($query);
return $result;
} else {
$this->test->type = "error";
$this->test->info = "nologin";
return $this->test;
}
}
/**
* @param array $value
* @return boolean indicating is any valid data of interest was passed
*/
protected function _isValid($value)
{
$partialHappened = false;
$isPost = 'post' == $this->getMethodContext();
// comment is set optional for put, required for post
if (isset($value['comment'])) {
$partialHappened = true;
$validate = new Zend_Validate_StringLength(array(1, 1000));
if (!$validate->isValid($value['comment'])) {
$this->_addValidateMessagesAndErrors($validate);
}
} elseif ($isPost) {
$this->_error(self::COMMENT_REQUIRED);
}
// creator_user_id required for post
// creator can't be changed for put, so if not post, then don't bother
// checking this, it will be ignored later
if (isset($value['creator_user_id']) && $isPost) {
$userTable = new Default_Model_DbTable_User();
if (false === current($userTable->find($value['creator_user_id']))) {
$this->_error(self::CREATOR_USER_ID_INVALID, $value['creator_user_id']);
}
} elseif ($isPost) {
$this->_error(self::CREATOR_USER_ID_REQUIRED);
}
return $partialHappened;
}
/**
* @param array $value
* @return boolean indicating is any valid data of interest was passed
*/
protected function _isValid($value)
{
$partialHappened = false;
$isPost = 'post' == $this->getMethodContext();
// validate that the title is set
if (isset($value['title'])) {
$partialHappened = true;
$validate = new Zend_Validate_StringLength(array(1, 100));
if (!$validate->isValid($value['title'])) {
$this->_addValidateMessagesAndErrors($validate);
}
$communityTable = new Default_Model_DbTable_Community();
if ($communityTable->fetchRow(array('title = ?' => $value['title']))) {
$this->_error(self::TITLE_ALREADY_EXISTS, $value['title']);
}
} elseif ($isPost) {
$this->_error(self::TITLE_REQUIRED);
}
// validate that the pic value is reasonable
if (isset($value['pic'])) {
$partialHappened = true;
$validate = new Zend_Validate_StringLength(array(0, 2083));
if (!$validate->isValid($value['pic'])) {
$this->_addValidateMessagesAndErrors($validate);
}
}
return $partialHappened;
}
/**
* Ensures that the getError() function returns an array of
* message key values corresponding to the messages.
*
* @return void
*/
public function testGetErrors()
{
$this->assertFalse($this->_validator->isValid('abcdefghij'));
$messages = $this->_validator->getMessages();
$this->assertEquals("'abcdefghij' is greater than 8 characters long", $messages[0]);
$errors = $this->_validator->getErrors();
$this->assertEquals(Zend_Validate_StringLength::TOO_LONG, $errors[0]);
}
public function validate($excludeFromValidation = array())
{
if (!in_array('house_name', $excludeFromValidation)) {
$bookhouseSizeValidator = new Zend_Validate_StringLength(3, 20);
if (!$bookhouseSizeValidator->isValid($this->getHouseName())) {
$this->setValidationError('house_name', "Bookhouse name size must bee between 3-20");
}
}
}
/**
* @param mixed|string $prepare
* @param string $requestKey
*
* @return bool
*/
protected function validatePrepare($prepare, $requestKey)
{
$stringLengthValidator = new StringLengthValidator(array('min' => 1, 'max' => 255));
if (!$stringLengthValidator->isValid(trim($prepare))) {
$messages = array_values($stringLengthValidator->getMessages());
$this->addError(new Error($requestKey, $prepare, $messages));
return false;
}
return true;
}
public function validatePassword($text, $name = 'example', $tab = 'common')
{
$validator = new Zend_Validate_StringLength(6, 32);
if ($validator->isValid($text)) {
return true;
}
$msg = Sanmax_MessageStack::getInstance($this->_namespace);
$msg->addMessage($name, $validator->getMessages(), $tab);
return false;
}
public function validateType($type)
{
$validator = new Zend_Validate_StringLength(2, 255);
if ($validator->isValid($type)) {
return true;
}
$msg = Sanmax_MessageStack::getInstance($this->_messagestack_name());
$msg->addMessage('pf_type', $validator->getMessages(), 'common');
return false;
}
protected function _validateIdentifier()
{
$validator = new Zend_Validate_StringLength(2, 255);
if ($validator->isValid($this->_group->getIdentifier())) {
return true;
}
$msg = Sanmax_MessageStack::getInstance('SxCms_Group');
$msg->addMessage('identifier', $validator->getMessages());
return false;
}
/**
* Validates job description
*
* @return boolean
*/
protected function _validateDescription()
{
$validator = new Zend_Validate_StringLength(2);
if ($validator->isValid($this->category->getDescription())) {
return true;
}
$msg = Sanmax_MessageStack::getInstance('SxCms_Job_Category');
$msg->addMessage('description', $validator->getMessages());
return false;
}
public function validateGroup()
{
$validator = new Zend_Validate_StringLength(2, 255);
$validator->setMessage($this->_tmx->_('error.verplicht.min'), Zend_Validate_StringLength::TOO_SHORT);
$validator->setMessage($this->_tmx->_('error.verplicht.max'), Zend_Validate_StringLength::TOO_LONG);
if ($validator->isValid($this->_group)) {
return true;
}
$msg = Sanmax_MessageStack::getInstance('SxModule_Securedocs_Group');
$msg->addMessage('group', $validator->getMessages(), 'settings');
return false;
}
/**
* @param string $name
* @return boolean
*/
private function validateName($name)
{
$stringLengthValidator = new StringLengthValidator(array('min' => 2, 'max' => 255));
$stringLengthValidator->setMessage('Album name zu kurz', StringLengthValidator::TOO_SHORT);
$stringLengthValidator->setMessage('Album name zu lang', StringLengthValidator::TOO_LONG);
if (!$stringLengthValidator->isValid(trim($name))) {
$messages = array_values($stringLengthValidator->getMessages());
$this->addError(new Error('name', $name, $messages));
return false;
}
return true;
}
public function setSettings($nImageId, $sUserName, $sDescr)
{
if (is_numeric($nImageId)) {
$aImageSettings = array();
$oStringLenght = new Zend_Validate_StringLength();
$oStringLenght->setMin(0);
$oStringLenght->setMax(50);
if ($oStringLenght->isValid($sUserName)) {
$aImageSettings["user_name"] = $sUserName;
}
$oStringLenght->setMax(100);
if ($oStringLenght->isValid($sDescr)) {
$aImageSettings["descr"] = $sDescr;
}
$oModelImage = new Admin_Model_Image();
if ($oModelImage->saveSettings($nImageId, $aImageSettings)) {
return true;
}
}
return null;
}
/**
* @param string $comment
* @return boolean
*/
private function validateComment($comment)
{
$stringLengthValidator = new StringLengthValidator(array('min' => 0, 'max' => self::MAX_ZIP_COMMENT_LENGTH));
$stringLengthValidator->setMessage('Build Kommentar zu kurz', StringLengthValidator::TOO_SHORT);
$stringLengthValidator->setMessage('Build Kommentar zu lang', StringLengthValidator::TOO_LONG);
if (!$stringLengthValidator->isValid(trim($comment))) {
$messages = array_values($stringLengthValidator->getMessages());
$this->addError(new Error('comment', $comment, $messages));
return false;
}
return true;
}
public function isValid($value)
{
if (!parent::isValid($value)) {
return false;
}
$validator = new \Zend_Validate_StringLength();
$validator->setMax(128);
if (!$validator->isValid($value)) {
$this->_messages = $validator->getMessages();
return false;
}
return true;
}
/**
* Ensures that getMessageVariables() returns an array of
* strings and that these strings that can be used as variables
* in a message.
*/
public function testGetMessageVariables()
{
$vars = $this->_validator->getMessageVariables();
$this->assertType('array', $vars);
$this->assertEquals(array('min', 'max'), $vars);
$message = 'variables: %notvar% ';
foreach ($vars as $var) {
$message .= "%{$var}% ";
}
$this->_validator->setMessage($message, Zend_Validate_StringLength::TOO_SHORT);
$this->assertFalse($this->_validator->isValid('abc'));
$messages = $this->_validator->getMessages();
$this->assertEquals('variables: %notvar% 4 8 ', current($messages));
}
protected function _validateUrl()
{
$val = new Zend_Validate_StringLength();
$val->setMin(1);
$val->setMax(255);
$val->setMessage('Dit is verplicht in te vullen', Zend_Validate_StringLength::TOO_SHORT);
$val->setMessage('Oops dit is te lang', Zend_Validate_StringLength::TOO_LONG);
if ($val->isValid($this->_agenda->getUrl())) {
return true;
}
$msg = Sanmax_MessageStack::getInstance('SxModule_Doctor_Agenda');
$msg->addMessage('url', $validator->getMessages());
return false;
}
/**
* Ensures that getMessageVariables() returns an array of
* strings and that these strings that can be used as variables
* in a message.
*/
public function testGetMessageVariables()
{
$vars = $this->_validator->getMessageVariables();
$this->assertType('array', $vars);
$this->assertEquals(array('min', 'max'), $vars);
$message = 'variables: %notvar% ';
foreach ($vars as $var) {
$message .= "%{$var}% ";
}
$this->_validator->setMessage($message);
$this->assertFalse($this->_validator->isValid('abc'));
$messages = $this->_validator->getMessages();
$this->assertEquals('variables: %notvar% 4 8 ', $messages[0]);
}
/**
* @param string $name
* @return boolean
*/
private function validateName($name)
{
$stringLengthValidator = new StringLengthValidator(array('min' => 1, 'max' => 255));
$tooShortMessage = sprintf("Name '%s' zu kurz", ucfirst($name));
$stringLengthValidator->setMessage($tooShortMessage, StringLengthValidator::TOO_SHORT);
$tooLongMessage = sprintf("Name '%s' zu lang", ucfirst($name));
$stringLengthValidator->setMessage($tooLongMessage, StringLengthValidator::TOO_LONG);
if (!$stringLengthValidator->isValid(trim($name))) {
$messages = array_values($stringLengthValidator->getMessages());
$this->addError(new Error('name', $name, $messages));
return false;
}
return true;
}
public function saveEmprestimo(\Core_Dto_Search $dto)
{
try {
$filter = new \Zend_Filter();
$filter->addFilter(new \Zend_Filter_StringTrim())->addFilter(new \Zend_Filter_StripTags());
$validate = new \Zend_Validate_StringLength(array('max' => 250, 'encoding' => 'UTF-8'));
$tipo = $dto->getDestinoInterno();
$txMotivo = $filter->filter($dto->getTxMotivo());
$noPessoaEntregue = $filter->filter($dto->getNoPessoaEntregue());
if (!$validate->isValid($txMotivo)) {
throw new \Core_Exception_ServiceLayer_Verification('Texto muito logo para o motivo');
}
if (!$validate->isValid($noPessoaEntregue)) {
throw new \Core_Exception_ServiceLayer_Verification('Texto muito logo para o nome da pessoa a quem será entregue o artefato');
}
$dtOperacao = \Zend_Date::now();
$sqTipoHistorico = \Core_Configuration::getSgdoceTipoHistoricoArquivoEmprestado();
if ($tipo == 'externo') {
$sqPessoa = $dto->getSqPessoa();
} else {
$sqPessoa = $dto->getSqPessoaIcmbioDestino();
}
foreach ($dto->getSqArtefato()->getApi() as $method) {
$entityArtefato = $this->_getRepository('app:Artefato')->find($dto->getSqArtefato()->{$method}());
$entityCaixaArtefato = $this->_getRepository('app:CaixaArtefato')->findOneBy(array('sqArtefato' => $entityArtefato->getSqArtefato()));
//gerar historico arquivo com o tipo 8 \Core_Configuration::getSgdoceTipoHistoricoArquivoEmprestado()
$entityCaixaHistorico = $this->getServiceLocator()->getService('CaixaArtefato')->insertHistorico($entityCaixaArtefato, $dtOperacao, $sqTipoHistorico);
//registrar o emprestimo
$entityEmprestimo = $this->_newEntity('app:Emprestimo');
$entityEmprestimo->setSqCaixaHistorico($entityCaixaHistorico)->setSqPessoaEmprestimo($this->getEntityManager()->getPartialReference('app:VwPessoa', $sqPessoa))->setTxMotivo($txMotivo)->setNoPessoaEntregue($noPessoaEntregue);
$this->getEntityManager()->persist($entityEmprestimo);
}
$this->getEntityManager()->flush();
} catch (\Exception $e) {
throw $e;
}
}
/**
* Seta o valor da coluna observacao
*
* @param string $value
* @return Wf_Model_WfTransacao_Crud_Mapper
*/
public function setObservacao($value, $options = array('required' => true))
{
$this->_data['observacao'] = new ZendT_Type_String($value);
if ($options['db']) {
$this->_data['observacao']->setValueFromDb($value);
}
if (!$options['db']) {
$valid = new Zend_Validate_StringLength(array('max' => 300));
$valueValid = $this->_data['observacao']->getValueToDb();
if ($valueValid && !$valid->isValid($valueValid)) {
throw new ZendT_Exception_Business(implode("\n", $valid->getMessages()));
}
}
return $this;
}
public function validateStr($str, $type, $len)
{
//Check each post variable for blanks or spaces
$str_validator = new Zend_Validate_StringLength($len);
$str_validator->setMessage($type . ', \'%value%\', is too short. It must be at least %min% ' . 'characters.', Zend_Validate_StringLength::TOO_SHORT);
if ($str == $type || $str == "" || $str == " ") {
$error = "Please enter " . strtolower($type) . ".";
array_push($this->messages, $error);
}
if (!$str_validator->isValid($str)) {
foreach ($str_validator->getMessages() as $error) {
array_push($this->messages, $error);
}
}
return $this->messages;
}
/**
* @param $password
* @param $passwordRepeat
* @return bool
*/
public function passwordValid($password, $passwordRepeat)
{
if ($password == "") {
$this->_error(self::EMPTYSTRING);
return false;
}
if (strlen($password) < $this->_min || strlen($password) > $this->_max) {
$this->_error(self::LENGTH);
return false;
} elseif ($password !== $passwordRepeat) {
$this->_error(self::MATCH);
return false;
} else {
return parent::isValid($password);
}
}
/**
* @param array $value
* @return boolean indicating is any valid data of interest was passed
*/
protected function _isValid($value)
{
$partialHappened = false;
$isPost = 'post' == $this->getMethodContext();
// validate that the community_id is valid
if (isset($value['community_id'])) {
$partialHappened = true;
$communityTable = new Default_Model_DbTable_Community();
if (!$communityTable->fetchRow(array('id = ?' => $value['community_id']))) {
$this->_error(self::COMMUNITY_ID_INVALID, $value['community_id']);
}
} elseif ($isPost) {
$this->_error(self::COMMUNITY_ID_REQUIRED);
}
// validate that the title is set
if (isset($value['title'])) {
$partialHappened = true;
$validate = new Zend_Validate_StringLength(array(1, 100));
if (!$validate->isValid($value['title'])) {
$this->_addValidateMessagesAndErrors($validate);
}
$discussionTable = new Default_Model_DbTable_Discussion();
if ($discussionTable->fetchRow(array('title = ?' => $value['title']))) {
$this->_error(self::TITLE_ALREADY_EXISTS, $value['title']);
}
} elseif ($isPost) {
$this->_error(self::TITLE_REQUIRED);
}
// validate that the comment is set, and doesn't already exist
if (isset($value['comment'])) {
$partialHappened = true;
$validate = new Zend_Validate_StringLength(array(0, 10000));
if (!$validate->isValid($value['comment'])) {
$this->_addValidateMessagesAndErrors($validate);
}
}
return $partialHappened;
}
/**
* Ensures that the validator follows expected behavior
*
* @return void
*/
public function testBasic()
{
/**
* The elements of each array are, in order:
* - minimum length
* - maximum length
* - expected validation result
* - array of test input values
*/
$valuesExpected = array(array(0, null, true, array('', 'a', 'ab')), array(-1, null, true, array('')), array(2, 2, true, array('ab', ' ')), array(2, 2, false, array('a', 'abc')), array(1, null, false, array('')), array(2, 3, true, array('ab', 'abc')), array(2, 3, false, array('a', 'abcd')));
foreach ($valuesExpected as $element) {
$validator = new Zend_Validate_StringLength($element[0], $element[1]);
foreach ($element[3] as $input) {
$this->assertEquals($element[2], $validator->isValid($input));
}
}
}
/**
* Validate "syntax" of this field
*
* @throws Setup_Exception_InvalidSchema if {@param $throwException} is set to true
*
* @param $throwException
* @return bool
*/
public function isValid($throwException = false)
{
$isValid = true;
$messages = array();
$nameValidator = new Zend_Validate_StringLength(1, 30);
if (!$nameValidator->isValid($this->name)) {
$isValid = false;
$messages = array_merge($messages, $nameValidator->getErrors());
}
if (!$isValid) {
Tinebase_Core::getLogger()->warn(__METHOD__ . '::' . __LINE__ . ' Invalid schema specified for field ' . $this->name . ': ' . print_r($messages, 1));
if ($throwException) {
throw new Setup_Exception_InvalidSchema('Invalid schema specified for field ' . $this->name . ': ' . print_r($messages, 1));
}
}
return $isValid;
}
public function createUser($email, $password)
{
$filter = new Zend_Validate_StringLength(array('min' => 5, 'max' => 25));
if (!$filter->isValid($password)) {
$this->setMessage('password', 'La lunghezza della password deve essere compresa fra 5 e 25 caratteri');
return false;
}
if ($this->_user_entity->findByEmail($email) !== false) {
$this->setMessage('email', 'E\' gia\' presente un utente con quella mail');
return false;
}
if (!($id = $this->_user_entity->create($email, $password))) {
$this->setMessage(null, 'Errore inaspettato. Contattare il team di supporto');
return false;
}
return $id;
}
/**
* Validate
*
* @param string $value
*/
public function isValid($value)
{
// Благодаря этому методу значение будет автоматически подставлено в текст ошибки при необходимости
$this->_setValue($value);
// Валидатор проверки длины
$validatorStringLength = new Zend_Validate_StringLength(5, 30);
// Проверка на допустимые символы
if (!preg_match("/^[~!@#\\\$%\\^&\\*\\(\\)\\-_\\+=\\\\\\/\\{\\}\\[\\].,\\?<>:;a-z0-9]*\$/i", $value)) {
// С помощью этого метода мы указываем какая именно ошибка произошла
$this->_error(self::INVALID);
return false;
} elseif (!$validatorStringLength->isValid($value)) {
$this->_error(self::INVALID_LENGTH);
return false;
}
return true;
}
function validate($txtInput)
{
$return_array = array();
$validator = new Zend_Validate_StringLength(3, 250);
//Validator messages
$validator->setMessages(array(Zend_Validate_StringLength::TOO_SHORT => 'The string value, \' %value% \' is too short', Zend_Validate_StringLength::TOO_LONG => 'You entered \' %max% \' characters, which is over 250.'));
// Looping through the text inputs
foreach ($txtInput as $key => $txtIn) {
if (!$validator->isValid($txtIn)) {
$error = $validator->getMessages();
foreach ($error as $e) {
$errorMessage = $key . ': ' . $e;
}
array_push($return_array, $errorMessage);
}
}
return $return_array;
}
/**
* Validate element value
*
* @param array $data
* @param mixed $context
* @return boolean
*/
public function isValid($value, $context = array())
{
// Optional?
if (empty($value) && $this->_optional) {
return true;
}
$lengthValidator = new Zend_Validate_StringLength(array('min' => 5, 'max' => 62));
if (!$lengthValidator->isValid($value)) {
$this->_messages = $lengthValidator->getMessages();
return false;
}
$regexValidator = new Zend_Validate_Regex(array('pattern' => '/^(?!(RAC|LAC|SGSN|RNC|\\.))(\\.?[0-9a-z]+(\\-[0-9a-z]+)*)+(?<!(\\.GPRS$))$/i'));
if (!$regexValidator->isValid($value)) {
$this->_messages = $regexValidator->getMessages();
return false;
}
return true;
}
