/** * Get city by id */ public function getSource($userid) { try { $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('srbd' => 'rd.source_of_restaurant_bd', 'ron' => 'rd.restaurant_owner'), array('srbd.description as code', 'ron.rsosourcedescription as description', 'id as sourceid'))->join(array('ron' => 'rd.restaurant_owner'), 'srbd.id = ron.rsosourceid')->where('ron.rsofk_user = ?', $userid)->order(array('srbd.description')); $records = $table->fetchAll($select); $id = ''; foreach ($records as $value) { $id = $value->sourceid; $description = $value->description; } $sourceofrestaurantMapper = new Application_Model_SourceofRestaurantDataMapper(); $sources = $sourceofrestaurantMapper->fetchAll(); $sourceList[] = array('key' => '', 'value' => 'Select Source'); foreach ($sources as $source) { $sourceList[] = array('key' => $source->getId(), 'value' => $source->getDescription()); //} } if ($id == null) { $result = array('sourcelist' => $sourceList); } else { $result = array('sourcelist' => $sourceList, 'id' => $id, 'description' => $description); } return $result; } catch (Exception $ex) { throw new Exception($ex->getMessage()); } }
public function init() { $stateMapper = new Application_Model_CountrybdMapper(); $states = $stateMapper->fetchAll(); $stateList = array(); $stateList[] = array('key' => '', 'value' => 'Select Country'); foreach ($states as $state) { $stateList[] = array('key' => $state->getId(), 'value' => $state->getDescription()); } $stateList[] = array('key' => 'find', 'value' => 'cant find your Country'); $sourceofrestaurantMapper = new Application_Model_SourceofRestaurantDataMapper(); $sources = $sourceofrestaurantMapper->fetchAll(); $sourceList = array(); $sourceList[] = array('key' => '', 'value' => 'Select Source'); foreach ($sources as $source) { $sourceList[] = array('key' => $source->getId(), 'value' => $source->getDescription()); } $passwordConfirm = new Rdine_Validate_PasswordConfirmation(); // $confirmEmail = new Rdine_Validate_EMailConfirmation(); $emailAddress = $this->createElement('text', 'emailAddress'); $emailAddress->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '40')->setAttrib('title', 'Email Address')->setAttrib('placeholder', 'Email Address*')->addValidator('NotEmpty', true, array('messages' => 'Please enter your EmailAddress.'))->addValidator('EmailAddress', false, array('messages' => array(Zend_Validate_EmailAddress::INVALID => 'Please enter a valid Host Name')))->addErrorMessage('Pleaes Enter Valid Email Address')->addFilters(array('StringTrim'))->setValue('')->addFilter('StringToLower')->setRequired(true); // $confirmEmailAdd = $this->createElement('text', 'confirmEmailAddress'); // $confirmEmailAdd->removeDecorator('Label') // ->removeDecorator('HtmlTag') // ->setAttrib('class','inp1') // ->setAttrib('maxlength', '40') // ->setAttrib('title', 'Confirm Email Address') // ->setAttrib('placeholder', 'Confirm Email Address*') // ->addValidators(array($confirmEmail, // array('NotEmpty', true, array('messages' => 'Please confirm your EmailAddress.')) // )) // ->setValue('') // ->addFilters(array('StringTrim')) // ->addFilter('StringToLower') // ->setRequired(true); $password = $this->createElement('password', 'password'); $password->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '20')->setAttrib('title', 'Password')->setAttrib('placeholder', 'Password*')->addValidators(array($passwordConfirm, array('NotEmpty', true, array('messages' => 'Please enter your Password.')), array('StringLength', false, array(6, 20, 'messages' => array(Zend_Validate_StringLength::TOO_SHORT => 'Your password is too short(>6).', Zend_Validate_StringLength::TOO_LONG => 'Your password is too long(<20).')))))->setRequired(true)->setValue(''); $confirmPassword = $this->createElement('password', 'password_confirm'); $confirmPassword->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '20')->setAttrib('title', 'Confirm Password')->setAttrib('placeholder', 'Confirm Password*')->addValidators(array($passwordConfirm, array('NotEmpty', true, array('messages' => 'Please Confirm your password.'))))->setRequired(true)->setValue(''); $firstName = $this->createElement('text', 'firstName'); $firstName->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '30')->setAttrib('title', 'First Name')->setAttrib('placeholder', 'First Name*')->addFilters(array('StringTrim'))->addValidators(array(array('NotEmpty', true, array('messages' => 'Please enter FirstName.')), array('StringLength', false, array(0, 30))))->setValue('')->setRequired(true); $lastName = $this->createElement('text', 'lastName'); $lastName->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('maxlength', '30')->addFilters(array('StringTrim'))->setAttrib('title', 'Last Name')->setAttrib('placeholder', 'Last Name')->addValidators(array(array('StringLength', false, array(0, 30))))->setAttrib('class', 'inp1')->setValue('')->setRequired(false); $countryCode = $this->createElement('text', 'countryCode'); $countryCode->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('style', 'width:116px; float:left')->setAttrib('readonly', 'readonly')->setAttrib('placeholder', 'Code')->setAttrib('title', 'Country Code')->addFilters(array('StringTrim'))->addValidators(array(array('NotEmpty', true, array('messages' => 'Please select country code.'))))->setValue('')->setAttrib('maxlength', '5')->setRequired(false); $phone = $this->createElement('text', 'phone'); $phone->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '10')->setAttrib('title', 'Phone')->setAttrib('style', 'width:325px; float:right;')->setAttrib('placeholder', 'Phone*')->addFilters(array('StringTrim'))->addValidators(array(array('NotEmpty', true, array('messages' => 'Please enter Your Phone Number.'))))->addValidator('regex', false, array('pattern' => '/^[0-9 ]+$/', 'messages' => 'Enter a valid Phone Number'))->setValue('')->setRequired(false); $rastaurantname = $this->createElement('text', 'restaurantName'); $rastaurantname->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '225')->setAttrib('title', 'Restaurant/Group')->setAttrib('placeholder', 'Restaurant/Group*')->addFilters(array('StringTrim'))->addValidators(array(array('NotEmpty', true, array('messages' => 'Please enter RestaurantName.'))))->setvalue('')->setrequired(true); $resownercountry = $this->createElement('text', 'resownercountry'); $resownercountry->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '30')->setAttrib('title', 'Country')->setAttrib('placeholder', 'Country*')->addFilters(array('StringTrim'))->addValidators(array(array('NotEmpty', true, array('messages' => 'Please enter Country.')), array('StringLength', false, array(0, 30)), array('Alnum')))->setValue('')->setRequired(false); $resownercity = $this->createElement('text', 'resownercity'); $resownercity->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '30')->setAttrib('title', 'City')->setAttrib('placeholder', 'City*')->addFilters(array('StringTrim'))->addValidators(array(array('NotEmpty', true, array('messages' => 'Please enter City.')), array('StringLength', false, array(0, 30))))->setValue('')->setRequired(false); $resownerzipcode = $this->createElement('text', 'resownerzipcode'); $resownerzipcode->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '10')->setAttrib('title', 'Zipcode')->setAttrib('placeholder', 'Zipcode')->addFilters(array('StringTrim'))->addValidators(array(array('NotEmpty', true, array('messages' => 'Please enter Zipcode.')), array('StringLength', false, array(0, 10)), array('Alnum')))->setValue('')->setRequired(false); $region = $this->createElement('select', 'region'); $region->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'sel1')->setAttrib('title', 'State')->addValidators(array(array('NotEmpty', true, array('messages' => 'Please select Region.'))))->setRegisterInArrayValidator(false)->setRequired(true); $state = $this->createElement('select', 'state'); $state->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'sel1')->setAttrib('title', 'Country')->addValidators(array(array('NotEmpty', true, array('messages' => 'Please select State.'))))->addMultiOptions($stateList)->setRequired(true); $source = $this->createElement('select', 'source'); $source->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'sel1')->setAttrib('title', 'How did you hear about us?')->addValidators(array(array('NotEmpty', true, array('messages' => 'Please select source.'))))->addMultiOptions($sourceList)->setRequired(false); $sourcedescription = $this->createElement('textarea', 'sourcedescription'); $sourcedescription->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('maxlength', '5000')->setAttrib('cols', '40')->setAttrib('rows', '4')->setAttrib('class', 'inp1')->setAttrib('title', 'Source Description')->setAttrib('placeholder', 'Would you like to provide more information')->setValue('')->addValidators(array(array('StringLength', false, array(1, 200, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Description is too long(>5000).')))))->setRequired(false); $city = $this->createElement('select', 'city'); $city->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'sel1')->setAttrib('title', 'City')->addValidators(array(array('NotEmpty', true, array('messages' => 'Please select City.'))))->setRegisterInArrayValidator(false)->setRequired(true); $cantfind = $this->createElement('hidden', 'cantfind'); $cantfind->removeDecorator('HtmlTag')->removeDecorator('Label'); $cantfindcity = $this->createElement('text', 'cantfindcity'); $cantfindcity->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '30')->setAttrib('title', 'Cant Find City')->setAttrib('placeholder', 'Enter Your City')->addValidators(array(array('StringLength', false, array(0, 30))))->setValue('')->setRequired(false); $cantfindstate = $this->createElement('text', 'cantfindstate'); $cantfindstate->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '30')->setAttrib('title', 'Cant Find Country')->setAttrib('placeholder', 'Enter Your Country')->addValidators(array(array('StringLength', false, array(0, 30))))->setValue('')->setRequired(false); $cantfindregion = $this->createElement('text', 'cantfindregion'); $cantfindregion->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '30')->setAttrib('title', 'Cant Find State')->setAttrib('placeholder', 'Enter Your State')->addValidators(array(array('StringLength', false, array(0, 30))))->setValue('')->setRequired(false); $description = $this->createElement('textarea', 'description'); $description->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('maxlength', '5000')->setAttrib('cols', '40')->setAttrib('rows', '4')->setAttrib('class', 'inp1')->setAttrib('title', 'Description')->setAttrib('placeholder', 'Enter your comments')->setValue('')->addValidators(array(array('StringLength', false, array(1, 5000, 'messages' => array(Zend_Validate_StringLength::TOO_LONG => 'Description is too long(>5000).')))))->setRequired(false); $website = $this->createElement('text', 'website'); $website->removeDecorator('Label')->removeDecorator('HtmlTag')->setAttrib('class', 'inp1')->setAttrib('maxlength', '30')->setAttrib('title', 'Website')->setAttrib('placeholder', 'Website')->addValidators(array(array('StringLength', false, array(0, 30))))->setValue('')->setRequired(false); $dateofbirth = $this->createElement('text', 'dateofbirth'); $dateofbirth->removeDecorator('Label')->setAttrib('class', 'inp1 datepicker')->removeDecorator('HtmlTag')->setAttrib('title', 'Date of Birth')->setAttrib('placeholder', 'Date of Birth')->addFilters(array('StringTrim'))->setValue(''); $imageCaptcha = new Zend_Captcha_Image(); $imageCaptcha->setWidth(200)->setWordlen(4)->setHeight(50)->setTimeout(900)->setFontSize(20)->setGcFreq(5)->setFont('Fonts/tahoma.ttf')->setImgDir('images/captcha/')->setImgUrl('/images/captcha/')->setDotNoiseLevel(0)->setLineNoiseLevel(0); $captcha = new Zend_Form_Element_Captcha('captcha', array('captcha' => $imageCaptcha)); $captcha->removeDecorator('DtDdWrapper')->removeDecorator('HtmlTag')->setAttrib('title', 'Captcha')->setAttrib('placeholder', 'Enter characters as shown in box *')->setAttrib('style', 'position:relative;margin-top:-10px;width:182px;'); $register = $this->createElement('submit', 'register'); $register->setLabel("Register")->removeDecorator('DtDdWrapper')->setAttrib('class', 'submitBtn')->setIgnore(true); $reset = $this->createElement('reset', 'reset'); $reset->removeDecorator('Label')->removeDecorator('DtDdWrapper')->setLabel("Reset")->setAttrib('class', 'submitBtn')->setIgnore(true); $comapnyid = $this->createElement('hidden', 'comapnyid'); $comapnyid->removeDecorator('HtmlTag')->removeDecorator('Label')->removeDecorator('DtDdWrapper'); $this->addElements(array($firstName, $lastName, $emailAddress, $password, $confirmPassword, $rastaurantname, $description, $phone, $source, $sourcedescription, $website, $dateofbirth, $register, $reset, $captcha, $comapnyid, $countryCode, $resownercity, $resownerzipcode)); }
public function getrestaurantownerdetailsbyUserid($userid) { try { $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('rso' => 'rd.restaurant_owner'), array('rsofk_user', 'rsorestaurant_name as restaurant_name', 'rsofirst_name as first_name', 'rsolast_name as last_name', 'rsophone as phone', 'rsodescription as owndescription', 'rsosourceid as sourceid', 'rsosourcedescription as sourcedescription', 'rsowebsite as website', 'rsostateid as stateid', 'rsocityid as cityid', 'rsoregionid as regionid', 'rsocantfind', 'rsoyourstate', 'rsoyourregion', 'rsoyourcity'))->joinLeft(array('srbd' => 'rd.source_of_restaurant_bd'), 'srbd.id=rso.rsosourceid', array('srbd.description as description'))->joinLeft(array('usr' => 'rd.user'), 'usr.usrid=rso.rsofk_user', array('usremail as email', 'usrpassword as password'))->joinLeft(array('st' => 'rd.country_bd'), 'st.id=rso.rsostateid', array('st.description as statename'))->joinLeft(array('cty' => 'rd.city_bd'), 'cty.id=rso.rsocityid', array('cty.description as cityname'))->joinLeft(array('rgn' => 'rd.state_bd'), 'rgn.id=rso.rsoregionid', array('rgn.description as regionname'))->where('rso.rsofk_user = ?', $userid); $records = $table->fetchAll($select); $resowner = array(); $RestPrf = array(); foreach ($records as $value) { $id = $value->sourceid; $description = $value->sourcedescription; $emailaddress = $value->email; $password = $value->password; $result = array('First Name' => $value->first_name, 'Last Name' => $value->last_name, 'Restaurant Name / Group Name' => $value->restaurant_name, 'Email Address' => $value->email, 'Phone' => $value->phone, 'State' => $value->statename, 'Region' => $value->regionname, 'City' => $value->cityname, 'Description' => $value->owndescription, 'Website' => $value->website, 'id' => $id, 'description' => $description, 'NewState' => $value->rsoyourstate, 'NewRegion' => $value->rsoyourregion, 'NewCity' => $value->rsoyourcity, 'cantfind' => $value->rsocantfind, 'stateid' => $value->stateid, 'regionid' => $value->regionid, 'cityid' => $value->cityid); if ($value->website == null) { $result['Website'] = ''; } } $sourceofrestaurantMapper = new Application_Model_SourceofRestaurantDataMapper(); $sources = $sourceofrestaurantMapper->fetchAll(); $sourceList[] = array('key' => '', 'value' => 'Select Source'); foreach ($sources as $source) { $sourceList[] = array('key' => $source->getId(), 'value' => $source->getDescription()); } if ($id == null) { $RestPrf = array('resowner' => $result, 'sourcelist' => $sourceList); } else { $RestPrf = array('resowner' => $result, 'sourcelist' => $sourceList, 'id' => $id, 'description' => $description); } return $RestPrf; } catch (Exception $ex) { throw new Exception($ex->getMessage()); } }