User.php 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713
  1. <?php
  2. require_once dirname(__FILE__) . '/' . 'Lib.php';
  3. Lib::loadClass('V');
  4. Lib::loadClass('UserProfile');
  5. class User {
  6. public static function getLogin() {
  7. return V::get('ADM_ACCOUNT', '', $_SESSION);
  8. }
  9. public static function getName() {
  10. return V::get('ADM_ACCOUNT', '', $_SESSION);
  11. }
  12. public static function getID() {
  13. if (V::get('ADM_ID', 0, $_SESSION, 'int') <= 0) {
  14. self::_fetchMoreUserData();
  15. }
  16. return V::get('ADM_ID', '', $_SESSION);
  17. }
  18. public static function getType() {
  19. if (!empty($_SESSION['EMPLOYEE_TYPE'])) {
  20. self::_fetchMoreUserData();
  21. }
  22. return V::get('EMPLOYEE_TYPE', '', $_SESSION);
  23. }
  24. public static function getFullName() {
  25. return V::get('ADM_NAME', '', $_SESSION);
  26. }
  27. public static function getInicjaly() {
  28. if (!V::get('ADM_INICJALY_HANDLOWCA', '', $_SESSION)) {
  29. self::_fetchMoreUserData();
  30. }
  31. return $_SESSION['ADM_INICJALY_HANDLOWCA'];
  32. }
  33. public static function getDefaultAclGroup() {
  34. if (!V::get('DEFAULT_ACL_GROUP', '', $_SESSION)) {
  35. self::_fetchMoreUserData();
  36. }
  37. return $_SESSION['DEFAULT_ACL_GROUP'];
  38. }
  39. public static function _fetchMoreUserData() {
  40. $db = DB::getDB();
  41. $login = self::getLogin();
  42. if (empty($login)) return false;
  43. $sql = "select `ID`, `INICJALY_HANDLOWCA`, `EMPLOYEE_TYPE`
  44. , `DEFAULT_ACL_GROUP`
  45. from `ADMIN_USERS`
  46. where `ADM_ACCOUNT`='{$login}'
  47. limit 1
  48. ";
  49. $res = $db->query($sql);
  50. if ($r = $db->fetch($res)) {
  51. $_SESSION['ADM_ID'] = $r->ID;
  52. $_SESSION['ADM_INICJALY_HANDLOWCA'] = $r->INICJALY_HANDLOWCA;
  53. $_SESSION['EMPLOYEE_TYPE'] = $r->EMPLOYEE_TYPE;
  54. $_SESSION['DEFAULT_ACL_GROUP'] = $r->DEFAULT_ACL_GROUP;
  55. }
  56. }
  57. public static function logged() {
  58. return (!empty($_SESSION['AUTHORIZE_USER']))? true : false;
  59. }
  60. public static function get( $key ) {
  61. return V::get($key, '', $_SESSION);
  62. }
  63. public static function getGroups() {
  64. $groups = User::_fetchGroups();
  65. return $groups;
  66. }
  67. public static function getGroupsIds() {
  68. $groups = User::_fetchGroups();
  69. return array_keys($groups);
  70. }
  71. public static function _fetchGroups() {
  72. static $_groups;
  73. if (!$_groups) {
  74. $user_id = User::getID();
  75. Lib::loadClass('UsersHelper');
  76. $_groups = UsersHelper::get_group_by_user($user_id);
  77. }
  78. return $_groups;
  79. }
  80. public static function loadProfile($force = false) {
  81. return UserProfile::load($force);
  82. }
  83. public static function saveProfile() {
  84. return UserProfile::save();
  85. }
  86. public static function getProfile($key) {
  87. return UserProfile::get($key);
  88. }
  89. public static function setProfile($key, $val) {
  90. UserProfile::set($key, $val);
  91. }
  92. public static function getProfileColumn($column_name, $key) {
  93. return UserProfile::getColumn($column_name, $key);
  94. }
  95. public static function setProfileColumn($column_name, $key, $value) {
  96. UserProfile::setColumn($column_name, $key, $value);
  97. }
  98. public static function removeProfileColumn($column_name, $key) {
  99. UserProfile::removeColumn($column_name, $key);
  100. }
  101. public static function isAdmin() {
  102. if (in_array(self::get('ADM_ADMIN_LEVEL'), array(0, 1))) {
  103. return true;
  104. }
  105. return false;
  106. }
  107. public static function getRawData() {
  108. $ret = array();
  109. if (self::logged()) {
  110. $ret['id'] = self::getID();
  111. $ret['login'] = self::getName();
  112. $ret['name'] = self::get('ADM_NAME');
  113. $ret['admin_level'] = self::get('ADM_ADMIN_LEVEL');
  114. $ret['opis'] = self::get('ADM_ADMIN_DESC');
  115. }
  116. return $ret;
  117. }
  118. public static function getAcl() {
  119. static $_acl;
  120. if (!$_acl) {
  121. Lib::loadClass('UserAcl');
  122. $_acl = new UserAcl(self::getID(), $use_cache = true);
  123. $_acl->fetchGroups();
  124. }
  125. return $_acl;
  126. }
  127. public static function reloadAcl() {
  128. IF('123'==V::get('DBG_ACL','',$_GET)){echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">$_SESSION keys (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r(array_keys($_SESSION));echo'</pre>';}
  129. /*
  130. * [3] => USER_PROFILE
  131. * [29] => CRM_PROCES_USERA_WYKONANE_TESTY-4517
  132. * [30] => TableAjax_Cache
  133. */
  134. IF('123'==V::get('DBG_ACL','',$_GET)){echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">CONFIG (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['CONFIG']);echo'</pre>';}
  135. IF('123'==V::get('DBG_ACL','',$_GET)){echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">TableAjax_Cache (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_SESSION['TableAjax_Cache']);echo'</pre>';}
  136. unset($_SESSION['UserAcl_cache']);
  137. unset($_SESSION['TableAcl_cache']);
  138. unset($_SESSION['Typespecial_Cache']);
  139. unset($_SESSION['ADM_INICJALY_HANDLOWCA']);
  140. unset($_SESSION['EMPLOYEE_TYPE']);
  141. unset($_SESSION['DEFAULT_ACL_GROUP']);
  142. $testySesKey = 'CRM_PROCES_USERA_WYKONANE_TESTY-' . User::getID();
  143. if (isset($_SESSION[$testySesKey])) unset($_SESSION[$testySesKey]);
  144. $userAcl = User::getAcl();
  145. $userAcl->fetchAllPerms(true);
  146. }
  147. public static function auth() {
  148. $task = V::get('LOGIN', '', $_REQUEST);
  149. $data = array();
  150. $data['errors'] = array();
  151. Lib::loadClass('Config');
  152. $data['ALLOW_GUEST_ACCOUNT'] = (int)Config::get('ALLOW_GUEST_ACCOUNT');
  153. switch ($task) {
  154. case 'LOGIN':
  155. if (!User::logged()) {
  156. $req_ADM_ACCOUNT = (isset($_REQUEST['ADM_ACCOUNT']))? $_REQUEST['ADM_ACCOUNT'] : '';
  157. $req_ADM_PASSWD = (isset($_REQUEST['ADM_PASSWD']))? $_REQUEST['ADM_PASSWD'] : '';
  158. if (empty($req_ADM_ACCOUNT) || empty($req_ADM_PASSWD)) {
  159. $data['errors'][] = "Proszę podać poprawny login i hasło!";
  160. } else {
  161. User::login($req_ADM_ACCOUNT, $req_ADM_PASSWD, $data['errors']);
  162. }
  163. }
  164. break;
  165. case 'LOGOUT':
  166. if (User::logged()) {
  167. session_destroy();
  168. unset($_SESSION['AUTHORIZE_USER']);
  169. unset($_SESSION['ADM_ACCOUNT']);
  170. Lib::loadClass('SE_Layout');
  171. SE_Layout::gora();
  172. SE_Layout::loadTemplate('logout', $data);
  173. SE_Layout::dol();
  174. exit;
  175. }
  176. break;
  177. case 'PERMS_RELOAD':
  178. if (User::logged()) {
  179. User::reloadAcl();
  180. $data = array();
  181. SE_Layout::gora();
  182. SE_Layout::menu();
  183. SE_Layout::loadTemplate('defaultPage', $data);
  184. SE_Layout::dol();
  185. exit;
  186. }
  187. break;
  188. case 'PASSEDIT':
  189. if (User::logged()) {
  190. $data = array();
  191. if (!empty($_POST)) {
  192. if (empty($_POST['ADM_PASSWD_NEW']) || empty($_POST['ADM_PASSWD'])) {
  193. $data['msg'] = "Proszę podać stare i nowe hasło.";
  194. }
  195. }
  196. if (!empty($_POST['ADM_PASSWD_NEW']) && !empty($_POST['ADM_PASSWD'])) {
  197. $ret = User::changePasswd($_POST['ADM_PASSWD'], $_POST['ADM_PASSWD_NEW']);
  198. if ($ret) {
  199. $data['info'] = "Hasło zostało zmienione";
  200. } else {
  201. $data['error'] = "Nie udało się zmienić hasła";
  202. }
  203. }
  204. SE_Layout::gora();
  205. SE_Layout::loadTemplate('passedit', $data);
  206. SE_Layout::dol();
  207. exit;
  208. }
  209. break;
  210. case 'ANONYMOUS_LOGIN':
  211. if (!User::logged()) {
  212. if ($data['ALLOW_GUEST_ACCOUNT'] != 1) {
  213. $data['errors'][] = "Zablokowane logowaniwe na konto gościa!";
  214. }
  215. else {
  216. $anonim = User::getAnonymousAccount();
  217. if (!$anonim) {
  218. $data['errors'][] = "Konto gościa nie istnieje!";
  219. } else {
  220. User::login($anonim->ADM_ACCOUNT, $anonim->ADM_PASSWD, $data['errors']);
  221. }
  222. }
  223. }
  224. break;
  225. default:
  226. }
  227. if (!User::logged()) {
  228. Lib::loadClass('SE_Layout');
  229. SE_Layout::gora();
  230. SE_Layout::loadTemplate('login', $data);
  231. SE_Layout::dol();
  232. exit;
  233. }
  234. }
  235. public static function kandydatLogin($kandydatId, &$errors = array()) {
  236. $user = self::kandydatLoginByDB($kandydatId, $errors);
  237. if ($user) {
  238. $_SESSION['ADM_ID'] = $user->ID;
  239. $_SESSION['AUTHORIZE_USER'] = $user->ADM_ACCOUNT;
  240. $_SESSION['ADM_ACCOUNT'] = $user->ADM_ACCOUNT;
  241. //$_SESSION['ADM_AREA'] = $user->ADM_AREA;
  242. $_SESSION['ADM_NAME'] = $user->ADM_NAME;
  243. $_SESSION['ADM_TECH_WORKER'] = $user->ADM_TECH_WORKER;
  244. $_SESSION['ADM_COMPANY'] = $user->ADM_COMPANY;
  245. $_SESSION['ADM_ADMIN_LEVEL'] = $user->ADM_ADMIN_LEVEL;
  246. $_SESSION['ADM_PHONE'] = $user->ADM_PHONE;
  247. $_SESSION['ADM_ADMIN_EXPIRE'] = $user->ADM_ADMIN_EXPIRE;
  248. $_SESSION['ADM_ADMIN_DESC'] = $user->ADM_ADMIN_DESC;
  249. $_SESSION['EMPLOYEE_TYPE'] = $user->EMPLOYEE_TYPE;
  250. // save user pass in encrypted form
  251. Lib::loadClass('Crypt');
  252. $_SESSION['ADM_PASS_HASH'] = Crypt::encrypt($pass);
  253. $_SESSION['EMAIL_IMAP_IMPORT_PASSWD_HASH'] = Crypt::encrypt($user->EMAIL_IMAP_IMPORT_PASSWD);
  254. $_SESSION['EMAIL_IMAP_IMPORT_HOST'] = $user->EMAIL_IMAP_IMPORT_HOST;
  255. $_SESSION['EMAIL_IMAP_IMPORT_USERNAME'] = $user->EMAIL_IMAP_IMPORT_USERNAME;
  256. //$keyFromHash = Crypt::decrypt($_SESSION['ADM_PASS_HASH']);
  257. $userAcl = User::getAcl();
  258. $userAcl->fetchAllPerms();
  259. return true;
  260. }
  261. return false;
  262. }
  263. public static function login($login, $pass, &$errors) {
  264. Lib::loadClass('LDAP');
  265. $ldap = LDAP::getInstance();
  266. if ($ldap != null && $ldap->isConnected()) {
  267. $user = self::loginByLDAP($login, $pass, $errors);
  268. } else {
  269. $user = self::loginByDB($login, $pass, $errors);
  270. }
  271. if ($user) {
  272. $_SESSION['ADM_ID'] = $user->ID;
  273. $_SESSION['AUTHORIZE_USER'] = $user->ADM_ACCOUNT;
  274. $_SESSION['ADM_ACCOUNT'] = $user->ADM_ACCOUNT;
  275. //$_SESSION['ADM_AREA'] = $user->ADM_AREA;
  276. $_SESSION['ADM_NAME'] = $user->ADM_NAME;
  277. $_SESSION['ADM_TECH_WORKER'] = $user->ADM_TECH_WORKER;
  278. $_SESSION['ADM_COMPANY'] = $user->ADM_COMPANY;
  279. $_SESSION['ADM_ADMIN_LEVEL'] = $user->ADM_ADMIN_LEVEL;
  280. $_SESSION['ADM_PHONE'] = $user->ADM_PHONE;
  281. $_SESSION['ADM_ADMIN_EXPIRE'] = $user->ADM_ADMIN_EXPIRE;
  282. $_SESSION['ADM_ADMIN_DESC'] = $user->ADM_ADMIN_DESC;
  283. $_SESSION['EMPLOYEE_TYPE'] = $user->EMPLOYEE_TYPE;
  284. // save user pass in encrypted form
  285. Lib::loadClass('Crypt');
  286. $_SESSION['ADM_PASS_HASH'] = Crypt::encrypt($pass);
  287. $_SESSION['EMAIL_IMAP_IMPORT_PASSWD_HASH'] = Crypt::encrypt($user->EMAIL_IMAP_IMPORT_PASSWD);
  288. $_SESSION['EMAIL_IMAP_IMPORT_HOST'] = $user->EMAIL_IMAP_IMPORT_HOST;
  289. $_SESSION['EMAIL_IMAP_IMPORT_USERNAME'] = $user->EMAIL_IMAP_IMPORT_USERNAME;
  290. //$keyFromHash = Crypt::decrypt($_SESSION['ADM_PASS_HASH']);
  291. $userAcl = User::getAcl();
  292. $userAcl->fetchAllPerms();
  293. return true;
  294. }
  295. return false;
  296. }
  297. public static function loginByLDAP($login, $pass, &$errors) {
  298. $ldapUser = array();
  299. $DBG = false;
  300. Lib::loadClass('LDAP');
  301. $ldap = LDAP::getInstance();
  302. if (!$ldap->isConnected()) {
  303. $errors[] = 'Error: Could not connect to LDAP server!';
  304. return false;
  305. }
  306. $filter = (false !== strpos($login, '@'))? "(mail={$login})" : "(uid={$login})";
  307. //$filter = "cn=*";// show all ldap accounts
  308. $justthese = array();//array("uid", "givenName", "mail", "*");
  309. if($DBG){echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">ldap_search (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r(array('ldaprdn'=>$ldap->getBaseDN(), 'filter'=>$filter, 'justthese'=>$justthese));echo'</pre>';}
  310. $res = $ldap->search($filter, 'cn=users', $justthese);
  311. if ($ldap->count_entries($res) > 0) {
  312. $entry = $ldap->first_entry($res);
  313. if ($entry) {
  314. $ldapUser['user_dn'] = $ldap->get_dn($entry);
  315. $val = $ldap->get_values($entry, 'uid');
  316. $ldapUser['uid'] = $val[0];
  317. $val = $ldap->get_values($entry, 'mail');
  318. $ldapUser['mail'] = $val[0];
  319. $val = $ldap->get_values($entry, 'cn');
  320. $ldapUser['cn'] = $val[0];
  321. } else {
  322. $errors[] = 'Login nie istnieje';
  323. return false;
  324. }
  325. if($DBG){// test
  326. echo'<pre style="overflow:auto;border:1px solid green;">';
  327. // print number of entries found
  328. echo "Number of entries found: " . $ldap->count_entries($res) . "\n";
  329. while ( $entry ) {
  330. $dn = $ldap->get_dn($entry);
  331. echo "<b>$dn</b>\n";
  332. $attrs = $ldap->get_attributes($entry);
  333. for ( $i=0; $i < $attrs['count']; $i++) {
  334. echo "$attrs[$i]: ";
  335. for ( $j=0; $j < $attrs[$attrs[$i]]['count']; $j++ ) {
  336. echo $attrs[$attrs[$i]][$j] . " ";
  337. }
  338. echo "\n";
  339. }
  340. echo "\n";
  341. $entry = $ldap->next_entry($entry);
  342. }
  343. $ldap->free_result($res);
  344. echo'</pre>';
  345. }// test
  346. }
  347. if (!$ldapUser['user_dn']) {
  348. $errors[] = 'Proszę podać poprawny login i hasło!';
  349. return false;
  350. }
  351. if($DBG){echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">LDAP user (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($ldapUser);echo'</pre>';}
  352. if($DBG){echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">ldap_bind (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r(array('ldaprdn'=>$ldapUser['user_dn'], 'pass'=>'***'));echo'</pre>';}
  353. $ldapbind = $ldap->bind($ldapUser['user_dn'], $pass, $errorMsg);
  354. if (!$ldapbind) {
  355. $errors[] = 'Error: LDAP authorization failed!' . '<p>' . $errorMsg . '</p>';
  356. return false;
  357. }
  358. $user = new stdClass();
  359. $user->AUTHORIZE_USER = $ldapUser['uid'];
  360. $user->ADM_ACCOUNT = $ldapUser['uid'];
  361. $user->ADM_NAME = $ldapUser['cn'];
  362. $user->OTHER_INFO = $ldapUser['mail'];
  363. // get ID, ... from DB
  364. $db = DB::getDB();
  365. $sql = "SELECT u.*
  366. from `ADMIN_USERS` as u
  367. where
  368. u.`ADM_ACCOUNT`='{$user->ADM_ACCOUNT}'
  369. and u.`A_STATUS` in('WAITING','NORMAL')
  370. ";
  371. // LIMIT 0, 1;
  372. $res = $db->query($sql);
  373. if (!$res) {
  374. die("Error SQL login!");
  375. }
  376. $num_rows = $db->num_rows($res);
  377. if ($num_rows == 0) {
  378. $errors[] = 'Error: brak uzytkownika w bazie danych!';
  379. return false;
  380. }
  381. else if ($num_rows == 1) {
  382. if ($r = $db->fetch($res)) {
  383. $user->ID = $r->ID;
  384. $user->ADM_TECH_WORKER = $r->ADM_TECH_WORKER;
  385. $user->ADM_COMPANY = $r->ADM_COMPANY;
  386. $user->ADM_ADMIN_LEVEL = $r->ADM_ADMIN_LEVEL;
  387. $user->ADM_PHONE = $r->ADM_PHONE;
  388. $user->ADM_ADMIN_EXPIRE = $r->ADM_ADMIN_EXPIRE;
  389. $user->ADM_ADMIN_DESC = $r->ADM_ADMIN_DESC;
  390. $user->EMAIL_IMAP_IMPORT_PASSWD = $r->EMAIL_IMAP_IMPORT_PASSWD;
  391. $user->EMAIL_IMAP_IMPORT_HOST = $r->EMAIL_IMAP_IMPORT_HOST;
  392. $user->EMAIL_IMAP_IMPORT_USERNAME = $r->EMAIL_IMAP_IMPORT_USERNAME;
  393. $user->EMPLOYEE_TYPE = $r->EMPLOYEE_TYPE;
  394. return $user;
  395. }
  396. }
  397. return $user;
  398. }
  399. public static function loginByDB($login, $pass, &$errors) {
  400. $db = DB::getDB();
  401. $login = $db->_($login);
  402. $pass = $db->_($pass);
  403. $sql = "SELECT u.*
  404. from `ADMIN_USERS` as u
  405. where
  406. u.`ADM_ACCOUNT`='{$login}'
  407. and ( u.`ADM_PASSWD`='{$pass}' or u.`ADM_PASSWD`=md5('{$pass}') )
  408. and u.`A_STATUS` in('WAITING','NORMAL')
  409. LIMIT 0, 1;
  410. ";
  411. $res = $db->query($sql);
  412. if (!$res) {
  413. die("Error SQL login!");
  414. }
  415. $num_rows = $db->num_rows($res);
  416. if ($num_rows == 0) {
  417. $errors[] = "Podales zlego uzytkownika lub/i haslo()";
  418. }
  419. else if ($num_rows == 1) {
  420. if ($r = $db->fetch($res)) {
  421. $user = new stdClass();
  422. $user->ID = $r->ID;
  423. $user->ADM_TECH_WORKER = $r->ADM_TECH_WORKER;
  424. $user->ADM_COMPANY = $r->ADM_COMPANY;
  425. $user->AUTHORIZE_USER = $r->ADM_ACCOUNT;
  426. $user->ADM_ACCOUNT = $r->ADM_ACCOUNT;
  427. $user->ADM_NAME = $r->ADM_NAME;
  428. $user->ADM_ADMIN_LEVEL = $r->ADM_ADMIN_LEVEL;
  429. $user->ADM_PHONE = $r->ADM_PHONE;
  430. $user->ADM_ADMIN_EXPIRE = $r->ADM_ADMIN_EXPIRE;
  431. $user->ADM_ADMIN_DESC = $r->ADM_ADMIN_DESC;
  432. $user->EMAIL_IMAP_IMPORT_PASSWD = $r->EMAIL_IMAP_IMPORT_PASSWD;
  433. $user->EMAIL_IMAP_IMPORT_HOST = $r->EMAIL_IMAP_IMPORT_HOST;
  434. $user->EMAIL_IMAP_IMPORT_USERNAME = $r->EMAIL_IMAP_IMPORT_USERNAME;
  435. $user->EMPLOYEE_TYPE = $r->EMPLOYEE_TYPE;
  436. //$user->ADM_AREA = "$r->ADM_AREA";
  437. //$_SESSION['ADM_PASSWD'] = $pass;
  438. return $user;
  439. }
  440. }
  441. return false;
  442. }
  443. public static function kandydatLoginByDB($kandydatId, &$errors) {
  444. $db = DB::getDB();
  445. $kandydatId = (int)$kandydatId;
  446. $sql = "SELECT u.*
  447. from `ADMIN_USERS` as u
  448. where
  449. u.`ID`='{$kandydatId}'
  450. and u.`A_STATUS` in('WAITING','NORMAL')
  451. LIMIT 0, 1;
  452. ";
  453. $res = $db->query($sql);
  454. if (!$res) {
  455. die("Error SQL login!");
  456. }
  457. $num_rows = $db->num_rows($res);
  458. if ($num_rows == 0) {
  459. $errors[] = "Podales zlego uzytkownika lub/i haslo()";
  460. }
  461. else if ($num_rows == 1) {
  462. if ($r = $db->fetch($res)) {
  463. $user = new stdClass();
  464. $user->ID = $r->ID;
  465. $user->ADM_TECH_WORKER = $r->ADM_TECH_WORKER;
  466. $user->ADM_COMPANY = $r->ADM_COMPANY;
  467. $user->AUTHORIZE_USER = $r->ADM_ACCOUNT;
  468. $user->ADM_ACCOUNT = $r->ADM_ACCOUNT;
  469. $user->ADM_NAME = $r->ADM_NAME;
  470. $user->ADM_ADMIN_LEVEL = $r->ADM_ADMIN_LEVEL;
  471. $user->ADM_PHONE = $r->ADM_PHONE;
  472. $user->ADM_ADMIN_EXPIRE = $r->ADM_ADMIN_EXPIRE;
  473. $user->ADM_ADMIN_DESC = $r->ADM_ADMIN_DESC;
  474. $user->EMAIL_IMAP_IMPORT_PASSWD = $r->EMAIL_IMAP_IMPORT_PASSWD;
  475. $user->EMAIL_IMAP_IMPORT_HOST = $r->EMAIL_IMAP_IMPORT_HOST;
  476. $user->EMAIL_IMAP_IMPORT_USERNAME = $r->EMAIL_IMAP_IMPORT_USERNAME;
  477. $user->EMPLOYEE_TYPE = $r->EMPLOYEE_TYPE;
  478. //$user->ADM_AREA = "$r->ADM_AREA";
  479. //$_SESSION['ADM_PASSWD'] = $pass;
  480. return $user;
  481. }
  482. }
  483. return false;
  484. }
  485. public static function changePasswd($oldPass, $newPass) {
  486. $db = DB::getDB();
  487. $newPass = $db->_($newPass);
  488. $oldPass = $db->_($oldPass);
  489. $username = $db->_(self::getName());
  490. $sql = "update `ADMIN_USERS` set
  491. `ADM_PASSWD`=md5('{$newPass}')
  492. where
  493. `ADM_ACCOUNT`='{$username}' and
  494. (`ADM_PASSWD`='{$oldPass}' or `ADM_PASSWD`=md5('{$oldPass}'))
  495. limit 1;
  496. ";
  497. $db->query($sql);
  498. return ($db->affected_rows() > 0);
  499. }
  500. /**
  501. * Check user access.
  502. * @param string $name
  503. * 'menu' - access to view menu
  504. *
  505. * @from [4101] ADM_ADMIN_LEVEL
  506. * Poziom uprawnień - każdy powinien mieć poziom o numerze 3
  507. * kierownicy powinni mieć 2
  508. * a administratorzy 0
  509. * kandydaci poziom 6.
  510. * Poziom 1 umożliwia edycje procesów i zasobów
  511. * poziom 2 umożliwia ocenę testów
  512. * poziom 3 umożliwia widzenie systemu jakości.
  513. */
  514. public static function hasAccess($name) {
  515. switch ($name) {
  516. case 'menu': {
  517. if (User::get('ADM_ADMIN_LEVEL') < 6) {
  518. return true;
  519. }
  520. else {
  521. Lib::loadClass('Config');
  522. $ALLOW_GUEST_ACCOUNT = (int)Config::get('ALLOW_GUEST_ACCOUNT');
  523. if ($ALLOW_GUEST_ACCOUNT && User::getLogin() == 'anonymous') {
  524. return true;
  525. }
  526. }
  527. break;
  528. }
  529. case 'dbg': {
  530. return (0 == User::get('ADM_ADMIN_LEVEL'));
  531. break;
  532. }
  533. case 'procesy': {
  534. if (User::get('ADM_ADMIN_LEVEL') < 4) return true;
  535. break;
  536. }
  537. case 'procesy_admin': {
  538. if (User::get('ADM_ADMIN_LEVEL') < 2) return true;
  539. break;
  540. }
  541. case 'testy': {
  542. if (User::get('ADM_ADMIN_LEVEL') <= 6) return true;
  543. break;
  544. }
  545. case 'testy_wyniki': {
  546. if (User::get('ADM_ADMIN_LEVEL') < 3) return true;
  547. break;
  548. }
  549. case 'testy_wyniki_edit': {
  550. if (User::get('ADM_ADMIN_LEVEL') < 3) return true;
  551. break;
  552. }
  553. case 'testy_wyniki_read': {
  554. if (User::get('ADM_ADMIN_LEVEL') < 3) return true;
  555. break;
  556. }
  557. case 'user_add_group': {
  558. if (User::get('ADM_ADMIN_LEVEL') < 1) return true;
  559. break;
  560. }
  561. default:
  562. }
  563. return false;
  564. }
  565. public static function hasGroup($groupName) {
  566. // TODO: find group by name @see self::getGroups() @used in SchemaReaderProcess
  567. return false;
  568. }
  569. public static function getAnonymousAccount() {
  570. $db = DB::getDB();
  571. if (!$db) die("Error DB connection!");
  572. $sql = "select u.*
  573. from `ADMIN_USERS` as u
  574. where
  575. u.`ADM_ACCOUNT`='anonymous'
  576. and u.`EMPLOYEE_TYPE`='Anonymous'
  577. and u.`A_STATUS` in('NORMAL')
  578. order by u.`ID` asc
  579. limit 1
  580. ";
  581. $res = $db->query($sql);
  582. if (!$res) die("Error SQL login!");
  583. $num_rows = $db->num_rows($res);
  584. if ($r = $db->fetch($res)) {
  585. //$_SESSION['ADM_PASSWD'] = $pass;
  586. $user = new stdClass();
  587. $user->ID = "$r->ID";
  588. $user->AUTHORIZE_USER = "$r->ADM_ACCOUNT";
  589. $user->ADM_ACCOUNT = "$r->ADM_ACCOUNT";
  590. $user->ADM_PASSWD = "$r->ADM_PASSWD";
  591. //$user->ADM_AREA = "$r->ADM_AREA";
  592. $user->ADM_NAME = "$r->ADM_NAME";
  593. $user->ADM_TECH_WORKER = "$r->ADM_TECH_WORKER";
  594. $user->ADM_COMPANY = "$r->ADM_COMPANY";
  595. $user->ADM_ADMIN_LEVEL = "$r->ADM_ADMIN_LEVEL";
  596. $user->ADM_PHONE = "$r->ADM_PHONE";
  597. $user->ADM_ADMIN_EXPIRE = "$r->ADM_ADMIN_EXPIRE";
  598. $user->ADM_ADMIN_DESC = "$r->ADM_ADMIN_DESC";
  599. return $user;
  600. }
  601. return false;
  602. }
  603. public static function getLdapGroups() {
  604. $ldapGroups = User::_fetchLdapGroups();
  605. return $ldapGroups;
  606. }
  607. public static function getLdapGroupsNames() {
  608. $ldapGroupsNames = array();
  609. $ldapGroups = User::_fetchLdapGroups();
  610. foreach ($ldapGroups as $kID => $vLDAPGroup) {
  611. $ldapGroupsNames[$kID] = $vLDAPGroup->cn;
  612. }
  613. return $ldapGroupsNames;
  614. }
  615. public static function getLdapGroupsIds() {
  616. $ldapGroups = User::_fetchLdapGroups();
  617. $gidNumbers = array();
  618. if (!empty($ldapGroups)) {
  619. foreach ($ldapGroups as $vLdapGroup) {
  620. $gidNumbers[] = $vLdapGroup->gidNumber;
  621. }
  622. }
  623. return $gidNumbers;
  624. }
  625. public static function _fetchLdapGroups() {
  626. static $_groups;
  627. if (!$_groups) {
  628. $login = User::getLogin();
  629. Lib::loadClass('UsersLdapHelper');
  630. $_groups = UsersLdapHelper::getUserGroups($login, 3);
  631. //echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">getLDAPGroupByUserName (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($_groups);echo'</pre>';
  632. }
  633. return $_groups;
  634. }
  635. }