public function updateBasicInfo($id, $data) { $mstuser = new Application_Model_DbTable_Mstuser(); $uRowSet = $mstuser->find($id); $return = ""; if ($uRowSet) { //Get bootstrap $bootstrap = Zend_Controller_Front::getInstance()->getParam("bootstrap"); $db = $bootstrap->getPluginResource('db')->getDbAdapter(); $db->beginTransaction(); $mstUser = new Application_Model_DbTable_Mstuser(); $prevUser = $mstUser->getBasicInfo($id); $logObj = Zend_Json::encode($prevUser); try { $uRow = $uRowSet->getRow(0); $uRow->login = $data['login']; $uRow->role_id = $data['role_id']; $uRow->is_temporary_pwd = $data['is_temporary_pwd']; $uRow->remarks = $data['remarks']; $uRow->is_active = $data['is_active']; $uRow->is_blocked = $data['is_blocked']; $uRow->blocked_reason = $data['blocked_reason']; if ($data['is_blocked'] == 'Y') { $uRow->blocked_date = date('Y-m-d H:i:s'); } $uRow->dolm = date('Y-m-d H:i:s'); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $authArray = $auth->getIdentity(); $userid = $authArray['user_id']; $uRow->modi_by_uid = $userid; } $uRow->save(); //--------------Update The Devotee----------------- $d = new Application_Model_DbTable_Devotee(); $did = $uRow->did; $dRowSet = $d->find($did); if ($dRowSet) { $dRow = $dRowSet->getRow(0); $dRow->email = $data['email']; $dRow->mobile = $data['mobile']; $dRow->country_id = $data['country_id']; $dRow->dolm = date('Y-m-d H:i:s'); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $authArray = $auth->getIdentity(); $userid = $authArray['user_id']; $dRow->modibyuid = $userid; } $dRow->save(); } //--------------------UPDATE THE RESOURCES------------------------ //Check If the Role Has been changed and if changed reassign the resources as per role. if ($prevUser['role_id'] != $data['role_id']) { //MstUserVsDatabase.php //-Delete Database------------- $uVsDb = new Application_Model_DbTable_MstUserVsDatabase(); $where = $uVsDb->getAdapter()->quoteInto('user_id = ?', $id); $uVsDb->delete($where); //--------------------------------------------------------------- //MstUserMethodVsUser.php //-Delete prev methods $uVsMethod = new Application_Model_DbTable_MstUserMethodVsUser(); $where = $uVsMethod->getAdapter()->quoteInto('user_id = ?', $id); $uVsMethod->delete($where); //insert new actions from MstUserRoleVsMethod.php $rVsMethod = new Application_Model_DbTable_MstUserRoleVsMethod(); $select = $rVsMethod->select(); $select->from($rVsMethod, array('method_id'))->where('role_id = ?', $data['role_id']); $rows = $rVsMethod->fetchAll($select); foreach ($rows as $r) { $data = array('user_id' => $id, 'method_id' => $r->method_id); $uVsMethod->insert($data); } //------------------------------------------------------------------ //MstUserVsGuru.php.php //-Delete prev gures $uVsGuru = new Application_Model_DbTable_MstUserVsGuru(); $where = $uVsGuru->getAdapter()->quoteInto('user_id = ?', $id); $uVsGuru->delete($where); //MstUserVsDevotee.php //-Delete prev devotees $uVsDev = new Application_Model_DbTable_MstUserVsDevotee(); $where = $uVsDev->getAdapter()->quoteInto('user_id = ?', $id); $uVsDev->delete($where); //MstUserVsCounselor.php //-Delete prev counselors $uVsCon = new Application_Model_DbTable_MstUserVsCounselor(); $where = $uVsCon->getAdapter()->quoteInto('user_id = ?', $id); $uVsCon->delete($where); //MstUserVsCounselor.php //-Delete prev centers $uVsCen = new Application_Model_DbTable_MstUserVsCenter(); $where = $uVsCen->getAdapter()->quoteInto('user_id = ?', $id); $uVsCen->delete($where); //MstUserVsAstcounselor.php //-Delete prev mentors $uVsMen = new Application_Model_DbTable_MstUserVsAstcounselor(); $where = $uVsMen->getAdapter()->quoteInto('user_id = ?', $id); $uVsMen->delete($where); } Rgm_UserServices::log($id, 'mst_user', 'Primary Info Updated', $logObj); $db->commit(); } catch (Exception $e) { $db->rollBack(); $return = $e->getMessages(); } } else { $return = "User not found in the database."; } return $return; }
public function updatePreliminaryInfo($id, $data) { $row = $this->fetchRow($this->select()->where('id = ?', $id)); if ($row) { $this->_db->beginTransaction(); try { //-------Check for duplicate login-------------- $select = $this->_db->select()->from('mst_user', array('count' => new Zend_Db_Expr('COUNT(id)')))->where('login = ?', $data['login'])->where('id <> ?', $id); if ($this->_db->fetchOne($select) > 0) { $this->_db->rollBack(); return array('user' => null, 'result' => 'DUPLICATE_LOGIN'); } $row->login = $data['login']; $row->security_question_id01 = $data['security_question_id01']; $row->security_answer01 = $data['security_answer01']; $row->security_question_id02 = $data['security_question_id02']; $row->security_answer02 = $data['security_answer02']; $row->is_temporary_pwd = 'N'; $row->dolm = date('Y-m-d H:i:s'); $row->last_pwd_changed_date = date('Y-m-d H:i:s'); $auth = Zend_Auth::getInstance(); if ($auth->hasIdentity()) { $authArray = $auth->getIdentity(); $userid = $authArray['user_id']; $row->modi_by_uid = $userid; } $row->save(); //--------------Update The Devotee----------------- $d = new Application_Model_DbTable_Devotee(); $dRowSet = $d->find($row->did); if ($dRowSet) { $dRow = $dRowSet->getRow(0); $dRow->first_name = $data['fName']; $dRow->middle_name = $data['mName']; $dRow->last_name = $data['lName']; $dRow->country_id = $data['country_id']; $dRow->email = $data['email']; $dRow->mobile = $data['mobile']; $dRow->save(); } $this->_db->commit(); return array('user' => $row, 'result' => 'ok'); } catch (Exception $e) { $this->_db->rollBack(); return array('user' => null, 'result' => $e->getMessage()); } } }