public function UpdateResOwnerProfile($formData) { try { $restOwn = new User_Model_Manager(); $restOwn->setId($formData->resownerId); $restOwn->setFristName(trim($formData->firstName)); $restOwn->setLastName(trim($formData->lastName)); $restOwn->setRestaurantname(trim($formData->restaurantName)); $restOwn->setPhonenumber(trim($formData->phone)); $restOwn->setCountryCode($formData->rescodetext); $restOwn->setTechfirstName($formData->techfirstName); $restOwn->setTechlastname($formData->techlastName); $restOwn->setTechemail($formData->techemail); $restOwn->setTechphone($formData->techphone); $restOwn->setTechcountrycode($formData->techrescodetext); $restOwn->setBilfirstName($formData->bilfirstName); $restOwn->setBillastname($formData->billastName); $restOwn->setbilemail($formData->bilemail); $restOwn->setBilphone($formData->bilphone); $restOwn->setBilcountrycode($formData->bilrescodetext); $mapper = new User_Model_ManagerDataMapper(); $status = $mapper->update($restOwn); if ($status) { $result = array('status' => true); } return $result; } catch (Exception $ex) { Rdine_Logger_FileLogger::info($ex->getMessage()); throw new Exception($ex->getMessage()); } }
public function createsubscribedfirmAction() { try { $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $storage = new Zend_Auth_Storage_Session(); $data = $storage->read(); $this->_helper->layout()->setLayout('adminlayout'); $request = $this->getRequest(); /* Populating Restaurant owners */ $resownerMapper = new User_Model_ManagerDataMapper(); $resOwners = $resownerMapper->fetchAll(); $this->view->resowners = $resOwners; $userservice = new Application_Service_Client(); $form = $userservice->getRestaurantOwnerForm(); $this->view->form = $form; // $CountryCodeMapper = new Application_Model_CountryCodeDataMapper(); // $CountryCode = $CountryCodeMapper->fetchAll(); // $CodeList = array(); // $CodeList[] = array('key'=>'','value'=>'Select Country Flag'); // foreach($CountryCode as $listcode){ // $CodeList[] = array('key'=>$listcode->getCountry_dial_code(),'value'=>$listcode->getCountry_flag()); // } // $this->view->codelist = $CodeList; if (isset($request->userid)) { $data['restownerId'] = $request->userid; $rsoMapper = new User_Model_ManagerDataMapper(); $table = $rsoMapper->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from($table, array('rsofk_salution', 'rsofirst_name', 'rsolast_name', 'rsophone', 'rsostateid', 'rsocityid', 'rsoregionid', 'rso_companyid', 'presid', 'defaultview'))->join(array('rd.restaurant_details'), 'resfk_user = rsofk_user', array('resid'))->where('rsofk_user = ?', $request->userid)->where('resstatus = ?', 1); $row = $table->fetchRow($select); if ($row->resid != null) { if ($row->presid != null) { $data['RestId'] = $row->presid; } else { $data['RestId'] = $row->resid; } $restNameByOwnObj = new FirmManagement_Model_FirmNamesByOwnerId(); $restNameByOwnObj->setRestOwnerId($request->userid); $restMapper = new FirmManagement_Model_FirmDataMapper(); $restList = $restMapper->getRestaurantNamesByOwnerId($restNameByOwnObj); $data['restList'] = $restList; } else { $data['RestId'] = ""; $data['restList'] = ""; } $storage->write($data); if ($data['companyid'] != 6) { return $this->_helper->redirector('addfirm', 'Firm', 'FirmManagement'); } else { return $this->_helper->redirector('addroundmenufirm', 'Firm', 'FirmManagement'); } } else { if ($this->getRequest()->isPost()) { $result = $userservice->RegisterRestaurantOwner($this->getRequest()->getPost()); if ($result['status']) { $data['restownerId'] = $result['userid']; $storage->write($data); if ($data['companyid'] != 6) { return $this->_helper->redirector('addfirm', 'Firm', 'FirmManagement'); } else { return $this->_helper->redirector('addroundmenufirm', 'Firm', 'FirmManagement'); } } else { if ($result['form']) { $this->view->form = $result['form']; $this->view->errors = $form; } } } } } else { $this->_redirect($this->view->url(array('module' => 'User', 'controller' => 'Login', 'action' => 'signin'), 'login', true)); } } catch (Exception $ex) { throw new Exception($ex->getMessage()); } }
public function manageLoginProfileWidget($userDet) { $db = Zend_Db_Table::getDefaultAdapter(); try { $db->beginTransaction(); $table = $this->getDbTable(); $select = $table->select(); $select->setIntegrityCheck(false); $select->from(array('usr' => 'rd.user'), array('usrid', 'usremail', 'usrregistered_date', 'usruser_status_id', 'usrusertype_id', 'usrlast_login_date'))->where('usremail = ?', $userDet['email']); $usrRes = $table->fetchRow($select); $userTable = new User_Model_ClientDataMapper(); if (!$usrRes) { $email = $userDet['email']; $length = 8; $characters = '0123456789abcdefghijklmnopqrstuvwxyz'; $password = ""; for ($p = 0; $p < $length; $p++) { $password .= $characters[mt_rand(0, strlen($characters))]; } $randomdata = ""; for ($p = 0; $p < $length; $p++) { $randomdata .= $characters[mt_rand(0, strlen($characters))]; } $passSha = sha1($password . $randomdata); $update = date('Y-m-d H:i:s'); $user = array('usremail' => $userDet['email'], 'usrpassword' => $passSha, 'usrusertype_id' => 2, 'usrrole_id' => 4, 'usrregistered_date' => date('Y-m-d'), 'usruser_status_id' => 1, 'usrpassphrase' => $randomdata, 'usrcreateddatetime' => $update); $user_id = $userTable->getDbTable()->insert($user); //$cusMapper = new User_Model_GuestDataMapper(); $customerTable = $this->getDbTable(); $data = array('cusfk_user' => $user_id, 'cusfirst_name' => $userDet['first_name'], 'cuslast_name' => $userDet['last_name']); $customer_id = $customerTable->insert($data); $db->commit(); /*$mailmapper = new Application_Service_Communication(); $mailObj = new Communication_Model_Mail(); $mailObj->setMsgCode('Customer_Confirmation'); $name = $userDet->name; $data = array('UserName' => $name, 'pass' => $password, 'SenTo' => $email); $mailObj->setData($data); $mailStatus = $mailmapper->SendMail($mailObj); */ $usertype_Id = 2; } else { $user_id = $usrRes->usrid; $usertype_Id = $usrRes->usrusertype_id; $email = $usrRes->usremail; } /* Get Usertype from Usertype BaseData */ $signupdate = null; $lastlogindate = null; /* Updating Users Last Login Date */ if ($user_id) { $userTable->UpdateUserLoggedInDate($user_id); } if ($usrRes->usrregistered_date) { $signupdate = $usrRes->usrregistered_date; } else { $signupdate = date('Y-m-d'); } if ($usrRes->usrlast_login_date) { $lastlogindate = $usrRes->usrlast_login_date; } else { $lastlogindate = ''; } $userType = $userTable->getUsertype($usertype_Id); switch ($userType->code) { case 'CUS': //$cusMapper = new User_Model_GuestDataMapper(); $table = $this->getDbTable(); $select = $table->select(); $select->from($table, array('cussalution', 'cusfirst_name', 'cuslast_name', 'custimezone', 'cusphone', 'cusmobile', 'cuscity_id', 'cusstate_id', 'cusregion_id'))->where('cusfk_user = ?', $user_id); $row = $table->fetchRow($select); $result = array('Email' => $email, 'Salution' => $row->cussalution, 'Firstname' => $row->cusfirst_name, 'LastName' => $row->cuslast_name, 'User_Id' => $user_id, 'Usertype' => $userType->code, 'Timezone' => $row->custimezone, 'State_Id' => $row->cusstate_id, 'City_Id' => $row->cuscity_id, 'Region_Id' => $row->cusregion_id, 'Phone' => $row->cusphone, 'cusmobile' => $row->cusmobile, 'companyid' => '', 'SignUpdate' => $signupdate, 'LastLoginDate' => $lastlogindate); return $result; break; case 'RSO': $rsoMapper = new User_Model_ManagerDataMapper(); $table = $rsoMapper->getDbTable(); $select = $table->select(); $select->from($table, array('rsofk_salution', 'rsofirst_name', 'rsolast_name', 'rsophone', 'rsostateid', 'rsocityid', 'rsoregionid', 'rso_companyid', 'presid', 'defaultview'))->where('rsofk_user = ?', $user_id); $row = $table->fetchRow($select); if ($row->presid == null) { $resMapper = new Restaurant_Model_RestaurantMapper(); $table = $resMapper->getDbTable(); $selectres = $table->select(); $selectres->from(array('rest' => 'rd.restaurant_details'), array('resid', 'resname', 'rescapacity', 'resreservation_system', 'res_status'))->where('resfk_user = ?', $user_id); $newrow = $table->fetchRow($selectres); $presid = $newrow->resid; $mapper = new User_Model_ManagerDataMapper(); } else { $presid = $row->presid; $resMapper = new Restaurant_Model_RestaurantMapper(); $table = $resMapper->getDbTable(); $selectres = $table->select(); $selectres->from(array('rest' => 'rd.restaurant_details'), array('resid', 'resname', 'rescapacity', 'resreservation_system', 'res_status'))->where('resid = ?', $presid); $newrow = $table->fetchRow($selectres); } $restNameByOwnObj = new Restaurant_Model_RestNamesByOwnerId(); $restNameByOwnObj->setRestOwnerId($user_id); $restMapper = new Restaurant_Model_RestaurantMapper(); $restList = $restMapper->getRestaurantNamesByOwnerId($restNameByOwnObj); /* Reterieve Restaurant Owner Permission's */ // $permTypMapp = new Application_Model_PermissionsTypeDataMapper(); // $Permissions = $permTypMapp->getRestUserMenuBD(); $result = array('Email' => $email, 'User_Id' => $user_id, 'Usertype' => $userType->code, 'Salution' => $row->rsofk_salution, 'Firstname' => $row->rsofirst_name, 'LastName' => $row->rsolast_name, 'State_Id' => $row->rsostateid, 'City_Id' => $row->rsocityid, 'Region_Id' => $row->rsoregionid, 'SignUpdate' => $signupdate, 'LastLoginDate' => $lastlogindate, 'Phone' => $row->rsophone, 'companyid' => $row->rso_companyid, 'RestId' => $presid, 'DefaultView' => $row->defaultview, 'restList' => $restList); return $result; break; case 'ADM': // $adminPermMapper = new Application_Model_AdminPermissionsTypeDataMapper(); // $permRowSet = $adminPermMapper->getAdminMenuBD(); $result = array('User_Id' => $user_id, 'Usertype' => $userType->code, 'companyid' => 1, 'restownerId' => "", 'RestId' => ""); return $result; break; } } catch (Exception $e) { throw new Exception($e->getMessage()); } }
public function getLoginProfile($data) { try { /* Get Usertype from Usertype BaseData */ $user_id = $data->usrid; $usertype_Id = $data->usrusertype_id; $email = $data->usremail; $signupdate = null; $lastlogindate = null; /* Updating Users Last Login Date */ if ($user_id) { $this->UpdateUserLoggedInDate($user_id); } if ($data->usrregistered_date) { $signupdate = $data->usrregistered_date; } if ($data->usrlast_login_date) { $lastlogindate = $data->usrlast_login_date; } $userType = $this->getUsertype($usertype_Id); switch ($userType->code) { case 'CUS': $cusMapper = new User_Model_GuestDataMapper(); $table = $cusMapper->getDbTable(); $select = $table->select(); $select->from($table, array('cussalution', 'cusfirst_name', 'cuslast_name', 'custimezone', 'cusphone', 'cusmobile', 'cuscity_id', 'cusstate_id', 'cusregion_id'))->where('cusfk_user = ?', $user_id); $row = $table->fetchRow($select); $result = array('Email' => $email, 'Salution' => $row->cussalution, 'Firstname' => $row->cusfirst_name, 'LastName' => $row->cuslast_name, 'User_Id' => $user_id, 'Usertype' => $userType->code, 'Timezone' => $row->custimezone, 'State_Id' => $row->cusstate_id, 'City_Id' => $row->cuscity_id, 'Region_Id' => $row->cusregion_id, 'Phone' => $row->cusphone, 'cusmobile' => $row->cusmobile, 'companyid' => '', 'SignUpdate' => $signupdate, 'LastLoginDate' => $lastlogindate); return $result; break; case 'RSO': $rsoMapper = new User_Model_ManagerDataMapper(); $table = $rsoMapper->getDbTable(); $select = $table->select(); $select->from($table, array('rsofk_salution', 'rsofirst_name', 'rsolast_name', 'rsophone', 'rsostateid', 'rsocityid', 'rsoregionid', 'rso_companyid', 'presid', 'defaultview'))->where('rsofk_user = ?', $user_id); $row = $table->fetchRow($select); if ($row->presid == null) { $resMapper = new Restaurant_Model_RestaurantMapper(); $table = $resMapper->getDbTable(); $selectres = $table->select(); $selectres->from(array('rest' => 'rd.restaurant_details'), array('resid', 'resname', 'rescapacity', 'resreservation_system', 'res_status'))->where('resfk_user = ?', $user_id); $newrow = $table->fetchRow($selectres); $presid = $newrow->resid; $mapper = new User_Model_ManagerDataMapper(); } else { $presid = $row->presid; $resMapper = new Restaurant_Model_RestaurantMapper(); $table = $resMapper->getDbTable(); $selectres = $table->select(); $selectres->from(array('rest' => 'rd.restaurant_details'), array('resid', 'resname', 'rescapacity', 'resreservation_system', 'res_status'))->where('resid = ?', $presid); $newrow = $table->fetchRow($selectres); } $restNameByOwnObj = new Restaurant_Model_RestNamesByOwnerId(); $restNameByOwnObj->setRestOwnerId($user_id); $restMapper = new Restaurant_Model_RestaurantMapper(); $restList = $restMapper->getRestaurantNamesByOwnerId($restNameByOwnObj); /* Reterieve Restaurant Owner Permission's */ // $permTypMapp = new Application_Model_PermissionsTypeDataMapper(); // $Permissions = $permTypMapp->getRestUserMenuBD(); $result = array('Email' => $email, 'User_Id' => $user_id, 'Usertype' => $userType->code, 'Salution' => $row->rsofk_salution, 'Firstname' => $row->rsofirst_name, 'LastName' => $row->rsolast_name, 'State_Id' => $row->rsostateid, 'City_Id' => $row->rsocityid, 'Region_Id' => $row->rsoregionid, 'SignUpdate' => $signupdate, 'LastLoginDate' => $lastlogindate, 'Phone' => $row->rsophone, 'companyid' => $row->rso_companyid, 'RestId' => $presid, 'DefaultView' => $row->defaultview, 'restList' => $restList); return $result; break; case 'ADM': // $adminPermMapper = new Application_Model_AdminPermissionsTypeDataMapper(); // $permRowSet = $adminPermMapper->getAdminMenuBD(); $result = array('User_Id' => $user_id, 'Usertype' => $userType->code, 'companyid' => 1, 'restownerId' => "", 'RestId' => ""); return $result; break; } } catch (Exception $ex) { throw new Exception($ex->getMessage()); } }
public function EditSourceofRestaurant($request) { try { $obj = new User_Model_Manager(); $source2 = $request->source_list; $obj->setSourceid($source2); $userid = $request->uid; $obj->setId($userid); $sourcedesc = $request->sourcedescription; $obj->setSourcedescription($sourcedesc); $rsetownerMapper = new User_Model_ManagerDataMapper(); $status = $rsetownerMapper->EditSourceofRestaurant($obj); return $status; } catch (Exception $ex) { Rdine_Logger_FileLogger::info($ex->getMessage()); throw new Exception($ex->getMessage()); } }
/** * registration of Restaurant Owner * * @param owner registration form data * @return status of registration completed or not */ public function RegisterRestaurantOwner(array $data, $source = 'DD') { try { $form = $this->getRestaurantOwnerForm(); $stateid = null; $regionid = null; $cityid = null; $regionBd = array(); $cityBd = array(); $ngbhBd = array(); $restService = new Application_Service_Restaurant(); if ($form->isValid($data)) { $storage = new Zend_Auth_Storage_Session(); $userdata = $storage->read(); $formData = $form->getValues(); $restaurantowner = new User_Model_Manager(); $restaurantowner->setFristName($formData['firstName'])->setLastName($formData['lastName'])->setEmail(strtolower($formData['emailAddress']))->setPassword($formData['password'])->setUsertypeid(3)->setRole(2)->setRegistereddate(date('Y-m-d H:i:s'))->setRestaurantname($formData['restaurantName'])->setPhonenumber($formData['phone'])->setCountryCode($formData['countryCode'])->setcity($formData['resownercity'])->setzipCode($formData['resownerzipcode'])->setSourceid($formData['source'])->setWebsite($formData['website'])->setSourcedescription($formData['sourcedescription'])->setDescription($formData['description'])->setDateofbirth($formData['dateofbirth']); if ($userdata['Usertype'] == "ADM" || $userdata['Usertype'] == "ADU" || $source == 'WIX') { $restaurantowner->setUserstatisid(1); } else { $restaurantowner->setUserstatisid(3); } if (isset($userdata['companyid'])) { $restaurantowner->setCompanyid($userdata['companyid']); } else { $restaurantowner->setCompanyid(1); } $mapper = new User_Model_ManagerDataMapper(); $res_own_id = $mapper->save($restaurantowner, $source); if ($res_own_id) { // $mailmapper = new Application_Service_Communication(); /* for E-mail $mailObj = new Communication_Model_Mail(); //$mailObj->setMsgCode('ResOwnConf'); $mailObj->setMsgCode('New Registration email'); $name = $formData['firstName'].' '.$formData['lastName']; $data = array('name'=> $name, 'restname'=> $formData['restaurantName'], 'phone' => $formData['countryCode'].$formData['phone'], 'email' => strtolower($formData['emailAddress']), // 'state' => $state, 'city' => $city, 'userid' => $formData['userid'], 'approval'=> $approval, 'uId' => $res_own_id, 'disapproval'=>$disapproval, 'state' => $formData['resownercountry'], 'city' => $formData['resownercity'], 'desc' => $formData['description']); $mailObj->setData($data); $mailStatus = $mailmapper->SendMail($mailObj); */ $result = array('status' => true, 'userid' => $res_own_id); if ($source == 'DD') { return $result; } else { return array('status' => true, 'result' => $res_own_id); } } } else { $formData = $form->getValues(); $form->populate($data); $result = array('status' => false, 'form' => $form); return $result; } } catch (Exception $ex) { Rdine_Logger_FileLogger::info($ex->getMessage()); throw new Exception($ex->getMessage()); } }