public function registerAction()
{
Zend_Layout::getMvcInstance()->disableLayout();
Zend_Dojo_View_Helper_Dojo::setUseDeclarative();
//$this->_helper->layout()->setLayout('notlogged');
$validator = new Zend_Validate_Db_RecordExists(array('table' => 'users', 'field' => 'email'));
$form = new Application_Form_RegisterForm();
$form->register->setAttrib('onClick', 'validateAndSubmitForm(\'' . $form->getName() . '\');');
$form->setAction('/account/register');
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
if ($form->isValid($this->getRequest()->getPost())) {
if (!$validator->isValid($form->email->getValue())) {
$user = new Application_Model_Register($form->getValues());
$mapper = new Application_Model_RegisterMapper();
$mapper->save($user);
$auth = new Application_Model_Base();
$auth->authUser($user->getEmail(), $user->getPassword());
$this->_redirect('/');
} else {
$this->view->existedRecordErrorMessage = 'This Email already registered';
}
} else {
return 'nevalidi';
}
}
}
function validateUser($email)
{
Zend_Loader::loadClass('AdminModel');
$result = preg_match("/(.)*@gome.vn/", trim($email));
if ($result) {
//check user is in user list or not
$model = new AdminModel();
$validator = new Zend_Validate_Db_RecordExists(array('table' => 'admin', 'field' => 'gome_email', 'exclude' => 'status=1'));
if ($validator->isValid(trim($email))) {
return true;
} else {
return false;
}
} else {
return false;
}
}
public function isValid($value)
{
$valid = parent::isValid($value);
if ($valid === false) {
$this->_error(self::EMAIL_NOT_EXISTS);
}
return $valid;
}
public function profilepluspreinsert()
{
$db = Zend_Db_Table::getDefaultAdapter();
if (empty($_POST)) {
$allPaySystem = $db->fetchAll("SELECT * FROM profileplus");
$allPaySystem['paysystem'] = TRUE;
return $allPaySystem;
} elseif ($_POST['liqpay'] || $_POST['wmr'] || $_POST['wmz'] && !empty($_POST['amount30']) && !empty($_POST['amount90']) && !empty($_POST['amount180'])) {
$this->addamount($_POST['amount30'], $_POST['amount90'], $_POST['amount180'], $_POST['paysystem'], $_POST['wallet'], $_POST['discount'], $_POST['stock_start'], $_POST['stock_end'], $_POST['description_stock']);
$allPaySystem = $db->fetchAll("SELECT * FROM profileplus");
$allPaySystem['paysystem'] = TRUE;
return $allPaySystem;
}
if ($_POST['find'] && !empty($_POST['userId'])) {
$user = $this->getuser($_POST['userId']);
$user['user'] = TRUE;
return $user;
}
if ($_POST['add']) {
if (isset($_POST['id'])) {
$uid = $_POST['id'];
}
if (isset($_POST['day'])) {
$day = $_POST['day'];
}
if (isset($_POST['active']) && $_POST['active'] === 'active') {
$active = 1;
} elseif (!isset($_POST['active'])) {
$active = 0;
}
$validator = new Zend_Validate_Db_RecordExists(array('adapter' => $db, 'table' => 'premium', 'field' => 'uid'));
if ($validator->isValid($uid)) {
$this->editPrem($uid, $day, $active);
} else {
$this->addPrem($uid, $day, $active);
}
$allPaySystem = $db->fetchAll("SELECT * FROM profileplus");
$allPaySystem['paysystem'] = TRUE;
return $allPaySystem;
}
}
public function init()
{
$dbValidator = new Zend_Validate_Db_RecordExists(array('table' => 'users', 'field' => 'login'));
$dbValidator->setMessage('Пользователя с таким именем нет в наших записях.');
$alnum = new Zend_Validate_Alnum();
$alnum->setMessage('Только буквы и цыфры!');
$notEmpty = new Zend_Validate_NotEmpty();
$notEmpty->setMessage('Поле обязательно для заполнения', 'isEmpty');
$stringLength = new Zend_Validate_StringLength(array('min' => 3));
$stringLength->setMessage('Длина поля должна быть больше трех символов.');
if (!empty($_GET['referer'])) {
$referer = $_GET['referer'];
} else {
$referer = '/';
}
$elementsForm = array('login' => array('type' => 'text', 'label' => 'Введите логин'), 'password' => array('type' => 'text', 'label' => 'Введите пароль', 'validators' => array('alnum' => $alnum, 'notEmpty' => $notEmpty, 'dbValidator' => $dbValidator, 'stringLength' => $stringLength)), 'redirect' => array('type' => 'hidden', 'attribs' => array('value' => $referer)));
// имя формы;
$this->setName('auth');
$this->setAttribs(array('method' => "post", "role" => "form", "class" => "form-horizontal"));
$this->createFormElements($this, $elementsForm, $this->elementDecorators, 'Войти', $this->buttonDecorators);
return $this;
}
/**
* Constructs the validator
*
* @param Zend_Config|array $config
* @access public
* @return void
*/
public function __construct($config)
{
parent::__construct($config);
if ($config instanceof Zend_Config) {
$config = $config->toArray();
}
if (isset($config['treatment'])) {
$this->setTreatment($config['treatment']);
}
if (isset($config['userPkField'])) {
$this->setUserPkField($config['userPkField']);
}
if (isset($config['userPkValue'])) {
$this->setUserPkValue($config['userPkValue']);
}
}
public function isValid($postData)
{
$contacts = new LettingAgents_Manager_Contacts();
$pageSession = new Zend_Session_Namespace('letting_agents_application');
if ($contacts->fetchByAgencyUid($this->_agent_uid)) {
switch ($this->_organisationId) {
case LettingAgents_Object_CompanyTypes::LimitedCompany:
$this->getSubForm('subform_limited-company-contacts')->getElement('contact_name')->setRequired(false);
break;
case LettingAgents_Object_CompanyTypes::LimitedLiabilityPartnership:
if ($postData['postcode'] != "") {
$this->getSubForm('subform_limited-liability-partnership')->getElement('contact_name')->setRequired(true);
} elseif ($postData['contact_name'] != "") {
$this->getSubForm('subform_address')->getElement('postcode')->setRequired(true);
} else {
$this->getSubForm('subform_limited-liability-partnership')->getElement('contact_name')->setRequired(false);
$this->getSubForm('subform_address')->getElement('postcode')->setRequired(false);
$this->getSubForm('subform_address')->getElement('address')->setRequired(false);
$this->getSubForm('subform_address')->getElement('address')->setRegisterInArrayValidator(false);
}
break;
case LettingAgents_Object_CompanyTypes::Partnership:
if ($postData['postcode'] != "" || $postData['contact_name'] != "") {
$this->getSubForm('subform_partnership')->getElement('contact_name')->setRequired(true);
} else {
$this->getSubForm('subform_partnership')->getElement('contact_name')->setRequired(false);
$this->getSubForm('subform_address')->getElement('postcode')->setRequired(false);
$this->getSubForm('subform_address')->getElement('address')->setRequired(false);
$this->getSubForm('subform_address')->getElement('address')->setRegisterInArrayValidator(false);
}
break;
}
} elseif ($postData['contact_name'] != '') {
$agent_id = $this->_agent_uid;
$db = Zend_Registry::get('db_letting_agents');
//die($clause);
$validator = new Zend_Validate_Db_RecordExists(array('table' => 'contact', 'field' => 'agency_id', 'value' => $agent_id, 'adapter' => $db));
$validator->setMessages(array(Zend_Validate_Db_RecordExists::ERROR_NO_RECORD_FOUND => 'Please Click Add Director'));
switch ($this->_organisationId) {
case LettingAgents_Object_CompanyTypes::LimitedCompany:
$this->getSubForm('subform_limited-company-contacts')->getElement('contact_name')->addValidator($validator);
$validator->setMessages(array(Zend_Validate_Db_RecordExists::ERROR_NO_RECORD_FOUND => 'Please Click Add Director'));
break;
case LettingAgents_Object_CompanyTypes::LimitedLiabilityPartnership:
$this->getSubForm('subform_limited-liability-partnership')->getElement('contact_name')->addValidator($validator);
$validator->setMessages(array(Zend_Validate_Db_RecordExists::ERROR_NO_RECORD_FOUND => 'Please Click Add Partner'));
break;
case LettingAgents_Object_CompanyTypes::Partnership:
$this->getSubForm('subform_partnership')->getElement('contact_name')->addValidator($validator);
$validator->setMessages(array(Zend_Validate_Db_RecordExists::ERROR_NO_RECORD_FOUND => 'Please Click Add Partner'));
break;
}
}
return parent::isValid($postData);
}
public function groupaccountAction()
{
$dbobj = new Groupmdefault_Model_Groupdefault();
$result = "";
$member_id = $_POST['member_id'];
$group_head = $_POST['memberhead'];
$representative_id = $_POST['representatives'];
// $latitude = $this->_request->getParam('latitude');
// $longitude = $this->_request->getParam('longitude');
$grouptypeid = $this->_request->getParam('grouptype');
$membertypeid = $grouptypeid;
$office_id = $this->_request->getParam('office');
$groupname = $this->_request->getParam('groupname');
$createddate = $this->_request->getParam('Created_Date');
$savingamt = $this->_request->getParam('savingamt');
$bank = $this->_request->getParam('bank');
$branch = $this->_request->getParam('branch');
$penaltyabsence = $this->_request->getParam('penaltyabsence');
$penaltylate = $this->_request->getParam('penaltylate');
$interest = $this->_request->getParam('interest');
$place = $this->_request->getParam('place');
$times = $this->_request->getParam('times');
$day = $this->_request->getParam('day');
$sessionName = new Zend_Session_Namespace('groupsession');
if ($grouptypeid) {
$sessionName->__set('grouptype', $grouptypeid);
}
if ($office_id) {
$sessionName->__set('office', $office_id);
}
if ($groupname) {
$sessionName->__set('groupname', $groupname);
}
if ($bank) {
$sessionName->__set('bank', $bank);
}
if ($createddate) {
$sessionName->__set('Created_Date', $createddate);
}
// if($latitude){
// $sessionName->__set('latitude',$latitude);
// // }
// if($longitude){
// $sessionName->__set('longitude',$longitude);
// }
if ($savingamt) {
$sessionName->__set('savingamt', $savingamt);
}
if ($penaltyabsence) {
$sessionName->__set('penaltyabsence', $penaltyabsence);
}
if ($penaltylate) {
$sessionName->__set('penaltylate', $penaltylate);
}
if ($interest) {
$sessionName->__set('interest', $interest);
}
if ($place) {
$sessionName->__set('place', $place);
}
if ($times) {
$sessionName->__set('times', $times);
}
if ($day) {
$sessionName->__set('day', $day);
}
$headers = array('Absense', 'Late');
$description = array('Penalty for absense', 'Penalty for late');
$countreps = count($representative_id);
$memberids = array();
$famid = array();
$memid = array();
$countvalues = array();
foreach ($member_id as $memberid) {
$memberids[] = explode('_', $memberid);
}
foreach ($memberids as $Memberids) {
$famid[] = $Memberids[0];
$memid[] = $Memberids[1];
}
$results = array_diff($representative_id, $memid);
$error = 0;
if (in_array($group_head, $memid)) {
$result = "ok";
if ($results) {
$error = "3";
$result = "not ok";
}
if ($countreps > 3) {
$error = "4";
$result = "not ok";
}
if (!$branch) {
$error = "5";
$result = "not ok";
} else {
$countvalues[] = array_count_values($famid);
foreach ($countvalues[0] as $key => $value) {
if ($value > 1) {
$result = "not ok";
$error = "2";
}
}
}
} else {
$error = "1";
}
if ($result == "ok" && $error == 0) {
$date = date("y/m/d H:i:s");
// // if ok get all input values
$penalglcode = $dbobj->getpenaltyglcode(4, 'recurring deposit');
if ($penalglcode->glcode == null) {
$this->view->adm->addRecord('ourbank_glcode', array('id' => '', 'glcode' => 'L01000', 'ledgertype_id' => 4, 'header' => 'recurring deposit', 'description' => 'recurring deposit', 'created_date' => $date, 'created_by' => $this->view->createdby));
}
$penalglcode = $dbobj->getpenaltyglcode(4, 'recurring deposit');
$bglcode = $penalglcode->glcode;
$glcodeid = $penalglcode->glcodeid;
$ini = substr($bglcode, 0, 1);
$mid = substr($bglcode, 1, 2);
$midportion = $ini . $mid;
$last = substr($bglcode, 3, 3);
$last += 1;
$last1 = str_pad($last, 3, 0, STR_PAD_LEFT);
$glsubcode[0] = $midportion . $last1;
$last += 1;
$last = str_pad($last, 3, 0, STR_PAD_LEFT);
$glsubcode[1] = $midportion . $last;
for ($l = 0; $l < 2; $l++) {
$penalglcodes = $dbobj->checkavailid($headers[$l]);
if (!$penalglcodes) {
$dbobj->insertGlsubcode(array('id' => '', 'office_id' => $office_id, 'glsubcode' => $glsubcode[$l], 'glcode_id' => $glcodeid, 'subledger_id' => 4, 'header' => $headers[$l], 'description' => $description[$l], 'created_date' => date('Y-m-d'), 'created_by' => $this->view->createdby));
}
}
$glidforabsense = $this->view->adm->getsingleRecord('ourbank_glsubcode', 'id', 'header', 'Absense');
$glidforlate = $this->view->adm->getsingleRecord('ourbank_glsubcode', 'id', 'header', 'Late');
$convertdate = new App_Model_dateConvertor();
$createddate = $convertdate->phpmysqlformat($createddate);
$date = date("y/m/d H:i:s");
// // validate the group name if name exists or not
$validator = new Zend_Validate_Db_RecordExists('ourbank_group', 'name');
if ($validator->isValid($groupname)) {
$messages = $validator->getMessages();
$this->view->errorgroupname = $groupname . 'Already Existed';
// if name exists display error message
} else {
$groupid = $this->view->adm->addRecord("ourbank_group", array('name' => $groupname, 'bank_id' => $bank, 'branch_id' => $branch, 'saving_perweek' => $savingamt, 'penalty_notcoming' => $penaltyabsence, 'penalty_latecoming' => $penaltylate, 'late_subglcode' => $glidforabsense, 'absent_subglcode' => $glidforlate, 'rateinterest' => $interest, 'place' => $place, 'time' => $times, 'days' => $day));
// Insert group name and get pk id
// // generate group code
$groupcode = str_pad($office_id, 3, "0", STR_PAD_LEFT) . "0" . $grouptypeid . str_pad($groupid, 6, "0", STR_PAD_LEFT);
// // update rest of group values
$this->view->adm->updateRecord("ourbank_group", $groupid, array('village_id' => $office_id, 'head' => $group_head, 'groupcode' => $groupcode, 'group_created_date' => $date, 'created_by' => $this->view->createdby, 'created_date' => $createddate));
/* Group created date -> Including timestamp , Created date should contain date only*/
foreach ($memid as $Memid) {
$this->view->adm->addRecord("ourbank_groupmembers", array('id' => '', 'group_id' => $groupid, 'member_id' => $Memid, 'groupmember_status' => 3));
////add groupmembers with its group id ->($groupid)
}
foreach ($representative_id as $representatives) {
$this->view->adm->addRecord("ourbank_group_representatives", array('id' => '', 'group_id' => $groupid, 'representative_id' => $representatives));
////add representatives with its group id ->($groupid)
}
// // $membertypeid = $this->view->adm->getsingleRecord('ourbank_master_membertypes','id','type','Group');
$account_id = $this->view->adm->addRecord("ourbank_accounts", array('id' => '', 'membertype_id' => $membertypeid, 'begin_date' => $date, 'accountcreated_date' => $date, 'created_date' => $createddate, 'created_by' => $this->view->createdby, 'status_id' => 1));
// insert some value to accounts table for group*/
$productid = $dbobj->getProductid();
$productcode = $productid . 'S';
// // // create account number <!--(3)office id--(2)individualtype--(3)productoffer with saving code(6)accountid!>
$accountNumber = str_pad($office_id, 3, "0", STR_PAD_LEFT) . str_pad($membertypeid, 2, "0", STR_PAD_LEFT) . str_pad($productcode, 3, "0", STR_PAD_LEFT) . str_pad($account_id, 6, "0", STR_PAD_LEFT);
$this->view->adm->updateRecord("ourbank_accounts", $account_id, array('account_number' => $accountNumber, 'member_id' => $groupid, 'product_id' => $productid, 'tag_account' => $account_id));
// // Group created date -> Including timestamp , Created date should contain date only
$individualtypeid = $this->view->adm->getsingleRecord('ourbank_master_membertypes', 'id', 'type', 'Individual');
// get individual type id
// // insert accounts value for group members
foreach ($memid as $Memid) {
$account_ids = $this->view->adm->addRecord("ourbank_accounts", array('id' => '', 'membertype_id' => $individualtypeid, 'begin_date' => $date, 'tag_account' => $account_id, 'accountcreated_date' => $date, 'created_date' => $createddate, 'created_by' => $this->view->createdby, 'status_id' => 1));
// insert some value to accounts table
// // create account number <!--(3)office id--(2)individualtype--(3)productoffer with saving code(6)accountid!>
$accountNumber = str_pad($office_id, 3, "0", STR_PAD_LEFT) . str_pad($individualtypeid, 2, "0", STR_PAD_LEFT) . str_pad($productcode, 3, "0", STR_PAD_LEFT) . str_pad($account_ids, 6, "0", STR_PAD_LEFT);
$this->view->adm->updateRecord("ourbank_accounts", $account_ids, array('account_number' => $accountNumber, 'member_id' => $Memid, 'product_id' => $productid));
}
// // if all the input's are satisfying all our requirements we can unset the session values
unset($sessionName->office);
unset($sessionName->groupname);
unset($sessionName->bank);
unset($sessionName->savingamt);
unset($sessionName->penaltylate);
unset($sessionName->penaltyabsence);
unset($sessionName->interest);
unset($sessionName->place);
unset($sessionName->times);
unset($sessionName->day);
unset($sessionName->Created_Date);
$this->_redirect('groupcommonview/index/commonview/id/' . $groupid);
}
} else {
// // //if not ok display errormessage
$this->_redirect('/groupmdefault/index/addgroup/error/' . $error);
}
}
public function registerAction()
{
$request = $this->getRequest();
$usersMapper = new Application_Model_UsersMapper();
$userWalletMapper = new Application_Model_UserWalletMapper();
$userWallet = new Application_Model_UserWallet();
$request_type = $request->getParam("request_type", FALSE);
$referred_by = $request->getParam("refer", FALSE);
if ($referred_by) {
$user = $usersMapper->getUserByEmail($referred_by);
$user_id = $user->__get("user_id");
} else {
$user_id = 0;
}
$this->view->user_id = $user_id;
$usersMapper = new Application_Model_UsersMapper();
$users = new Application_Model_Users();
if ($request_type) {
if ($request_type == "register") {
$user_fname = $request->getParam("user_fname");
$user_lname = $request->getParam("user_lname");
$user_email = $request->getParam("user_email");
$password = $request->getParam("hashed_password");
$cpassword = $request->getParam("cpassword");
$user_number = $request->getParam("user_number");
$user_address = $request->getParam("user_address");
$user_locality = $request->getParam("user_locality");
$user_landmark = $request->getParam("user_landmark");
$user_city = $request->getParam("user_city");
$user_state = $request->getParam("user_state");
$user_country = $request->getParam("user_country");
$reference_email = $request->getParam("refer");
$errors = array();
if (empty($user_fname)) {
$errors[] = "First Name Should Not Be Empty";
}
if (empty($user_lname)) {
$errors[] = "Last Name Should Not Be Empty";
}
if (empty($user_email)) {
$errors[] = "Email Should Not Be Empty";
}
if (empty($password)) {
$errors[] = "Password Should Not Be EMpty";
}
if (empty($cpassword)) {
$errors[] = "Confirm Password Should Not Be Empty";
}
if (empty($user_number)) {
$errors[] = "Number Should Not Be Empty";
}
if (empty($user_address)) {
$errors[] = "Address Should Not Be Empty";
}
if (empty($user_city)) {
$errors[] = "City Should Not Be Empty";
}
if (empty($user_state)) {
$errors[] = "State Should Not Be Empty";
}
if (empty($user_country)) {
$errors[] = "Country Should Not Be Empty";
}
if ($password != $cpassword) {
$errors[] = "Password Did Not Match";
}
if ($user_number < 10 && $user_number > 10) {
$errors[] = "Phone Number Should Be of 10 Digits";
}
$emailValidator = new Zend_Validate_EmailAddress();
if (!$emailValidator->isValid($user_email)) {
$errors[] = "Email address not valid";
}
$options = array("table" => "users", "field" => "user_email");
$recordValidation = new Zend_Validate_Db_RecordExists($options);
if ($recordValidation->isValid($user_email)) {
$errors[] = "Email address already in use";
}
$hashed_password = sha1($password);
if (count($errors) == 0) {
$users->__set("user_fname", $user_fname);
$users->__set("user_lname", $user_lname);
$users->__set("user_email", $user_email);
$users->__set("user_number", $user_number);
$users->__set("hashed_password", $hashed_password);
$users->__set("user_address", $user_address);
if ($user_locality) {
$users->__set("user_locality", $user_locality);
} else {
$users->__set("user_locality", "");
}
if ($user_landmark) {
$users->__set("user_landmark", $user_landmark);
} else {
$users->__set("user_landmark", "");
}
$users->__set("user_city", $user_city);
$users->__set("user_state", $user_state);
$users->__set("user_country", $user_country);
$users->__set("user_fb_id", "");
if ($reference_email) {
$new_user = $usersMapper->getUserByEmail($reference_email);
if ($new_user) {
$users->__set("referred_by", $new_user->__get("user_id"));
}
}
$user_id = $usersMapper->addNewUser($users);
if ($reference_email) {
$new_user = $usersMapper->getUserByEmail($reference_email);
if ($new_user) {
$reference_by = $new_user->__get("user_id");
$userWallet->__set("user_id", $reference_by);
$userWallet->__set("entry_type", "CREDIT");
$userWallet->__set("entry_amount", "100");
$userWalletMapper->addNewUserWallet($userWallet);
$userWallet->__set("user_id", $user_id);
$userWalletMapper->addNewUserWallet($userWallet);
}
}
$subject = "Hi " . $user_fname . " " . $user_lname . ", Welcome to Laundry Wala";
$message = "Dear " . $user_fname . " " . $user_lname . ",<br/><br/>\n Greetings From LaundryWala.<br/><br/>\n Thanks for registering with us and choosing us as your preferred laundry service.</strong><br/><br/>\n We offer affordable and professional laundry service at the convenience of your doorstep.<br/><br/>\n Do login to our website www.laundrywala.co.in for more details about us.<br/><br/>\n Look forward to being of service to you.<br/><br/>\n Best regards,<br/><br/>\n Customer Care Team<br/><br/>\n LaundryWala<br/><br/>";
$result = $this->_newForgotPasswordNotification($user_email, $subject, $message);
$result1 = $this->_newForgotPasswordNotification("*****@*****.**", $subject, $message);
$sms = "Dear " . $user_fname . ", Welcome to LaundryWala. Do login to our website www.laundrywala.co.in for more details. Look forward to being of service to you. Regards, LaundryWala";
$sms_result = $this->_smsNotification($user_number, $sms);
if ($user_id && $result && $result1) {
$this->view->hasMessage = true;
$this->view->messageType = "success";
$this->view->message = "User has been added successfully";
} else {
$this->view->hasMessage = true;
$this->view->messageType = "danger";
$this->view->message = "Error while adding user";
}
} else {
$errorString = "";
foreach ($errors as $error) {
$errorString .= $error . "<br/>";
}
$this->view->hasMessage = true;
$this->view->messageType = "danger";
$this->view->message = $errorString;
}
}
}
}
/**
*
* @group ZF-10705
*/
public function testCreatesQueryBasedOnNamedOrPositionalAvailablity()
{
Zend_Db_Table_Abstract::setDefaultAdapter(null);
$this->_adapterHasResult->setSupportsParametersValues(array('named' => false, 'positional' => true));
$validator = new Zend_Validate_Db_RecordExists('users', 'field1', null, $this->_adapterHasResult);
$wherePart = $validator->getSelect()->getPart('where');
$this->assertEquals($wherePart[0], '("field1" = ?)');
$this->_adapterHasResult->setSupportsParametersValues(array('named' => true, 'positional' => true));
$validator = new Zend_Validate_Db_RecordExists('users', 'field1', null, $this->_adapterHasResult);
$wherePart = $validator->getSelect()->getPart('where');
$this->assertEquals($wherePart[0], '("field1" = :value)');
}
/**
* @return ZF-8863
*/
public function testExcludeConstructor()
{
Zend_Db_Table_Abstract::setDefaultAdapter($this->_adapterHasResult);
$validator = new Zend_Validate_Db_RecordExists('users', 'field1', 'id != 1');
$this->assertTrue($validator->isValid('value3'));
}
private function existOnDbValidate($value, $field, $table)
{
$validator = new Zend_Validate_Db_RecordExists(array("field" => $field, "table" => $table));
return !$validator->isValid($value);
}
public function primaryAction()
{
$this->_controllerCache->clean(Zend_Cache::CLEANING_MODE_ALL);
$this->_helper->viewRenderer->setNoRender();
$this->_helper->layout->disableLayout();
$translator = Zend_Registry::get('translator');
$menu_id = $this->_request->getPost('menu_id');
$menu_name = $this->_request->getPost('menu_name');
//DB Connection
$conn = Zend_Registry::get('msqli_connection');
$conn->getConnection();
$validatorMenuLink = new Zend_Validate_Db_RecordExists(array('table' => Zend_Registry::get('dbPrefix') . 'menu_assign', 'field' => 'menu_id'));
if ($validatorMenuLink->isValid($menu_id)) {
try {
$conn->update(Zend_Registry::get('dbPrefix') . 'menu', array('menu_default' => '0'));
// Update Article status
$where = array();
$where[] = 'menu_id = ' . $conn->quote($menu_id);
try {
$conn->update(Zend_Registry::get('dbPrefix') . 'menu', array('menu_default' => '1'), $where);
$json_arr = array('status' => 'ok');
} catch (Exception $e) {
$msg = $translator->translator('menu_list_default_err', $menu_name);
$json_arr = array('status' => 'err', 'msg' => $msg . " " . $e->getMessage());
}
} catch (Exception $e) {
$msg = $translator->translator('menu_list_default_err', $menu_name);
$json_arr = array('status' => 'err', 'msg' => $msg . " " . $e->getMessage());
}
} else {
$msg = $translator->translator('menu_list_default_link_err', $menu_name);
$json_arr = array('status' => 'err', 'msg' => $msg);
}
//Convert To JSON ARRAY
$res_value = Zend_Json::encode($json_arr);
$this->_response->setBody($res_value);
}
public function isAdministrator($username)
{
$validator = new Zend_Validate_Db_RecordExists(array('table' => $this->_name, 'field' => 'username', 'exclude' => 'role_id <= 101'));
return $validator->isValid($username);
}
public function dataValidator($formData,$formType)
{
$errorMsg = null;
$trigger = 0;
if($formType == 0 )
{
$validatorPlateNo = new Zend_Validate_Db_RecordExists(
array(
'table' => 've_vehicles',
'field' => 'plateNo'
)
);
if($validatorPlateNo->isValid($formData['plateNo']))
{
$trigger = 1;
$errorMsg = General_Models_Text::$text_recordExists."<br/>".$errorMsg;
}
}
if($formData['contactId'] == null)
{
$trigger = 1;
$errorMsg = General_Models_Text::$text_vehicle_contact_notFound."<br/>".$errorMsg;
}
if($formData['pilot'] == null)
{
$trigger = 1;
$errorMsg = General_Models_Text::$text_vehicle_pilot_notFound."<br/>".$errorMsg;
}
$array['trigger'] = $trigger;
$array['errorMsg'] = $errorMsg;
return $array;
}
/** @brief Vérification de la présence d'une valeur.
* Méthode permettant de vérifier la présence d'une valeur dans un champ de la table.
* @param string $sField : nom du champ où réaliser la recherche.
* @param string|integer $sValue : valeur du champ à rechercher.
* @return bool résulat de la vérification.
*/
public function isRecordExists($sValue = null, $sField = 'ID')
{
// Initialisation du validateur
$oValidator = new Zend_Validate_Db_RecordExists($this->_name, $sField, null, $this->oAdapter);
// Recherche de la présence de la valeur
return $oValidator->isValid($sValue);
}
