_menu(); SE_Layout::dol(); } private function _menu($selectedMonth) { $usersTodoList = $this->getUsersWithTooLongLogin(); ?>
Brak użytwkoników z loginem dłuższym niż 20 znaków
ADM_ACCOUNT, '.')) { $newLogin = explode('.', $user->ADM_ACCOUNT, 2); $newLogin = substr($newLogin[0], 0, 1) . ".{$newLogin[1]}"; if (strlen($newLogin) > 20) { $newLogin = substr($newLogin, 0, 20); } } else { $newLogin = substr($user->ADM_ACCOUNT, 0, 20); } $newLogin = strtolower($newLogin); ?>
Lp. Nr Login Poziom Uprawnień Status Data synch. Nowy login Update Login and Sync.
ID; ?> ADM_ACCOUNT, 0, 20); ?>ADM_ACCOUNT, 20); ?> ADM_ADMIN_LEVEL; ?> A_STATUS; ?> A_SYNC_LDAP_DATE; ?> Update and sync.
20 SQL; $res = $db->query($sql); while ($r = $db->fetch($res)) { $usersTodoList[$r->ADM_ACCOUNT] = $r; } return $usersTodoList; } public function getUserByLogin($login) { $user = null; $db = DB::getDB(); $sqlLogin = $db->_($login); $sql = <<query($sql); if ($r = $db->fetch($res)) { $user = $r; } return $user; } public function updateLoginAndSyncAction() { $currentLogin = V::get('currentLogin', '', $_REQUEST, 'word'); $newLogin = V::get('newLogin', '', $_REQUEST, 'word'); $user = $this->getUserByLogin($currentLogin); SE_Layout::gora(); ?>
Brak użytkownika z loginem
Zmiana loginu z na
updateLogin($user, $currentLogin, $newLogin); if ($affected == 2) { echo '
' . "Login został poprawnie zmieniony na '{$newLogin}'" . '
'; } else if ($affected == 1) { echo '
' . "Nie zapisano hist" . '
'; } else if ($affected == 0) { echo '
' . "Nic nie zmieniono" . '
'; } if ($affected) $this->updateDatabase($currentLogin, $newLogin); } catch (Exception $e) { ?>
getMessage(); ?>
Synchronizuj do LDAP ()
ADM_ACCOUNT) { throw new Exception("Error: User ADM_ACCOUNT != '{$currentLogin}'"); } $sqlObj = new stdClass(); $sqlObj->ID = $user->ID; $sqlObj->ADM_ACCOUNT = $newLogin; $affected = $db->UPDATE_OBJ('ADMIN_USERS', $sqlObj); if ($affected < 0) { if ($db->has_errors()) { $dsErrors = array(); $errorsSql = $db->get_errors(); foreach ($errorsSql as $vErr) { if ('SQL QUERY FAILED: ' == substr($vErr, 0, 18)) { $vErr = substr($vErr, 18); } $dsErrors[] = $vErr; } if (!empty($dsErrors)) { Lib::loadClass('StorageException'); throw new StorageException($dsErrors); } } else { throw new Exception("Error: nic nie zmieniono"); } } return $affected; } public function updateDatabase($currentLogin, $newLogin) { $db = DB::getDB(); $columns = Array("L_APPOITMENT_USER","A_RECORD_CREATE_AUTHOR","A_RECORD_UPDATE_AUTHOR"); $dbName = $db->getDatabaseName(); echo '"; } }