public function updatePresident($presidentRow, $data)
{
$hasntEmail = isset($data['hasnt_email']) ? $data['hasnt_email'] : 0;
$this->validateEmail($presidentRow->getId(), $data['email'], $hasntEmail);
$this->validatePhoneNumbers($data);
$data = $this->_filterInputPresident($data)->getUnescaped();
$presidentRow->setEnterpriseId(isset($data['enterprise_id']) ? $data['enterprise_id'] : $presidentRow->getEnterpriseId())->setEducationId(isset($data['education_id']) ? $data['education_id'] : $presidentRow->getEducationId())->setPositionId(isset($data['position_id']) ? $data['position_id'] : $presidentRow->getPositionId())->setFindUsId(isset($data['find_us_id']) ? $data['find_us_id'] : $presidentRow->getFindUsId())->setName(isset($data['name']) ? $data['name'] : $presidentRow->getName())->setNickName(isset($data['nick_name']) ? $data['nick_name'] : $presidentRow->getNickName())->setCpf(isset($data['cpf']) ? $data['cpf'] : $presidentRow->getCpf())->setPhone(isset($data['phone']) ? $data['phone'] : $presidentRow->getPhone())->setCellphone(isset($data['cellphone']) ? $data['cellphone'] : $presidentRow->getCellphone())->setEmail(isset($data['email']) ? $data['email'] : $presidentRow->getEmail())->setBornDate(isset($data['born_date']) ? Vtx_Util_Date::format_iso($data['born_date']) : $presidentRow->getBornDate())->setGender(isset($data['gender']) ? $data['gender'] : $presidentRow->getGender())->setNewsletterEmail(isset($data['newsletter_email']) ? $data['newsletter_email'] : 0)->setNewsletterMail(isset($data['newsletter_mail']) ? $data['newsletter_mail'] : 0)->setNewsletterSms(isset($data['newsletter_sms']) ? $data['newsletter_sms'] : 0)->setAgree(isset($data['agree']) ? $data['agree'] : 0);
$presidentRow->save();
return array('status' => true);
}
public function updateRoleQuestionnaire($rqRowData, $data)
{
$data = $this->_filterInputRoleQuestionnaire($data)->getUnescaped();
$questionnaireId = $data['questionnaire_id'];
$startDate = Vtx_Util_Date::format_iso($data['start_date']);
$endDate = Vtx_Util_Date::format_iso($data['end_date']);
if (!$this->modelQuestionnaire->verifyQuestionnaireOperation($questionnaireId, $startDate, $endDate)) {
return array('status' => false, 'messageError' => 'Período de configuração inválido.');
}
$rqRowData->setStartDate($startDate)->setEndDate($endDate);
$rqRowData->save();
return array('status' => true);
}
function updateUser($userRowData, $data)
{
$verifylogin = DbTable_User::getInstance()->fetchRow(array('Login = ?' => $data['login'], 'Id != ?' => $userRowData->getId()));
if ($verifylogin) {
return array('status' => false, 'messageError' => 'Nome de usuário (login) em uso.');
}
if (isset($data['change_password'])) {
unset($data['change_password']);
$data['password'] = $data['keypass'];
}
if (isset($data['password'])) {
if ($data['keypass'] != $data['keypass_confirm'] or empty($data['keypass'])) {
return array('status' => false, 'messageError' => 'Senha não confere.');
}
$pass = Vtx_Util_String::hashMe(md5($data['password']));
}
$data = $this->_filterInputUser($data)->getUnescaped();
$userRowData->setPositionId(isset($data['position_id']) ? $data['position_id'] : $userRowData->getPositionId())->setEducationId(isset($data['education_id']) ? $data['education_id'] : $userRowData->getEducationId())->setBornDate(isset($data['born_date']) ? Vtx_Util_Date::format_iso($data['born_date']) : $userRowData->getBornDate())->setGender(isset($data['gender']) ? $data['gender'] : $userRowData->getGender())->setCpf(isset($data['cpf']) ? $data['cpf'] : $userRowData->getCpf())->setKeypass(isset($data['password']) ? $pass['sha'] : $userRowData->getKeypass())->setSalt(isset($data['password']) ? $pass['salt'] : $userRowData->getSalt())->setFirstName(isset($data['first_name']) ? $data['first_name'] : $userRowData->getFirstName())->setSurname(isset($data['surname']) ? $data['surname'] : $userRowData->getSurname())->setEmail(isset($data['email']) ? $data['email'] : $userRowData->getEmail())->setLogin(isset($data['login']) ? $data['login'] : $userRowData->getLogin())->setPasswordHint(isset($data['password_hint']) ? $data['password_hint'] : $userRowData->getPasswordHint())->setStatus(isset($data['status']) ? $data['status'] : $userRowData->getLogin());
//'13302', NULL, NULL, 'VANESSA ZULIAN', '', '000.001.340-40', '*****@*****.**', '40ef7e139a734b368975ca4eb01bbb80b224e4dc241f5a767bb57d593d9e65128dfb7f97ba198bbcce89183d925f6a9e0927487cc1c8cfd1a5bfc80d58c06bef', 'deaaf66b0e537f2', '', NULL, NULL, NULL, '123 teste'
$userRowData->save();
return array('status' => true);
}
public function updateEnterprise($enterpriseRowData, $data)
{
$data['status'] = isset($data['status']) ? $data['status'] : $enterpriseRowData->getStatus();
$data = $this->_filterInputEnterprise($data)->getUnescaped();
$verifyCnpj = DbTable_Enterprise::getInstance()->fetchRow(array('Cnpj = ?' => $data['cnpj'], 'IdKey != ?' => $enterpriseRowData->getIdKey()));
if ($verifyCnpj and !empty($data['cnpj'])) {
return array('status' => false, 'messageError' => 'CNPJ (' . $data['cnpj'] . ') já em uso.');
}
$enterpriseRowData->setCategoryAwardId(isset($data['category_award_id']) ? $data['category_award_id'] : $enterpriseRowData->getCategoryAwardId())->setCategorySectorId(isset($data['category_sector_id']) ? $data['category_sector_id'] : $enterpriseRowData->getCategorySectorId())->setSocialName(isset($data['social_name']) ? $data['social_name'] : $enterpriseRowData->getSocialName())->setFantasyName(isset($data['fantasy_name']) ? $data['fantasy_name'] : $enterpriseRowData->getFantasyName())->setStatus(isset($data['status']) ? $data['status'] : $enterpriseRowData->getStatus())->setCnpj(isset($data['cnpj']) ? $data['cnpj'] : $enterpriseRowData->getCnpj())->setStateRegistration(isset($data['state_registration']) ? $data['state_registration'] : $enterpriseRowData->getStateRegistration())->setDap(isset($data['dap']) ? $data['dap'] : $enterpriseRowData->getDap())->setRegisterMinistryFisher(isset($data['register_ministry_fisher']) ? $data['register_ministry_fisher'] : $enterpriseRowData->getRegisterMinistryFisher())->setCreationDate(isset($data['creation_date']) ? Vtx_Util_Date::format_iso($data['creation_date']) : $enterpriseRowData->getCreationDate())->setEmployeesQuantity(isset($data['employees_quantity']) ? $data['employees_quantity'] : $enterpriseRowData->getEmployeesQuantity())->setAnnualRevenue(isset($data['annual_revenue']) ? Vtx_Util_Formatting::realToDecimal($data['annual_revenue']) : $enterpriseRowData->getAnnualRevenue())->setCnae(isset($data['cnae']) ? $data['cnae'] : $enterpriseRowData->getCnae())->setEmailDefault(isset($data['email_default']) ? $data['email_default'] : $enterpriseRowData->getEmailDefault())->setPhone(isset($data['phone']) ? $data['phone'] : $enterpriseRowData->getPhone())->setSite(isset($data['site']) ? $data['site'] : $enterpriseRowData->getSite())->setCompanyHistory(isset($data['company_history']) ? $data['company_history'] : $enterpriseRowData->getCompanyHistory())->setNirf(isset($data['nirf']) ? $data['nirf'] : $enterpriseRowData->getNirf())->setHasntEmail(isset($data['hasnt_email']) ? $data['hasnt_email'] : 0)->setFarmSize(isset($data['farm_size']) ? $data['farm_size'] : $enterpriseRowData->getFarmSize());
$enterpriseRowData->save();
return array('status' => true, 'row' => $enterpriseRowData);
}
public function updateQuestionnaire($questionnaireRow, $data)
{
DbTable_Questionnaire::getInstance()->getAdapter()->beginTransaction();
try {
$data = $this->_filterInputIdentify($data)->getUnescaped();
$verifyQuestionnaire = DbTable_Questionnaire::getInstance()->fetchRow(array('Title = ?' => $data['title'], 'Id <> ?' => $questionnaireRow->getId()));
if ($verifyQuestionnaire) {
return array('status' => false, 'messageError' => $this->_messagesError['questionnaireExistsReg']);
}
$questionnaireRow->setTitle($data['title'])->setDescription($data['description'])->setLongDescription($data['long_description'])->setOperationBeginning(Vtx_Util_Date::format_iso($data['operation_beginning']))->setOperationEnding(Vtx_Util_Date::format_iso($data['operation_ending']))->setPublicSubscriptionEndsAt(Vtx_Util_Date::format_iso($data['public_subscription_ends_at']))->setInternalSubscriptionEndsAt(Vtx_Util_Date::format_iso($data['internal_subscription_ends_at']))->setDevolutiveCalcId($data['devolutive_id']);
$questionnaireRow->save();
DbTable_Question::getInstance()->getAdapter()->commit();
return array('status' => true);
} catch (Vtx_UserException $e) {
DbTable_Questionnaire::getInstance()->getAdapter()->rollBack();
return array('status' => false, 'messageError' => $e->getMessage());
} catch (Exception $e) {
DbTable_Questionnaire::getInstance()->getAdapter()->rollBack();
throw new Exception($e);
}
}
