ProcesMenu.php 44 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183
  1. <?php
  2. require_once dirname(__FILE__) . '/' . 'Lib.php';
  3. Lib::loadClass('V');
  4. Lib::loadClass('User');
  5. Lib::loadClass('ProcesTestyHelper');
  6. Lib::loadClass('TypespecialVariable');
  7. Lib::loadClass('UsersHelper');
  8. Lib::loadClass('DB');
  9. Lib::loadClass('UserBookmarks');
  10. class ProcesMenu {
  11. var $MENU_SELECT_PROCES;
  12. var $CRM_PROCES_USERA_UZYTY_MAP = null;
  13. var $CRM_PROCES_USERA_UZYTY_MAP_PROCES_INIT;
  14. var $CRM_PROCES_USERA_WYKONANE_TESTY;
  15. var $_wynik_testu;
  16. var $_wynik_testu_unactual;
  17. var $error;// errory niedopuszczajace do uruchomienia
  18. var $warning;// uwagi
  19. var $CRM_PROCES_USERA_UZYTY;
  20. var $_user_id;
  21. var $_acl;
  22. function __construct() {
  23. $this->MENU_SELECT_PROCES_DATA = V::get('MENU_SELECT_PROCES_DATA', null, $_SESSION);// URL
  24. $this->_user_id = User::getID();
  25. if (User::isAdmin()) {
  26. $this->_user_id = V::get('_user_id', 0, $_POST, 'int');
  27. if (!$this->_user_id) {
  28. $this->_user_id = User::getID();
  29. }
  30. }
  31. $this->_acl = UsersHelper::getUserAcl($this->_user_id);
  32. if (!$this->_acl) {
  33. die('Error Acl');
  34. }
  35. // TODO: TEST
  36. if ('' != V::get('DBG', '', $_GET)) {
  37. echo '<div style="background:#eeefef;border:2px solid blue;padding:10px;">';
  38. //$this->_acl->old();
  39. echo '</div>';
  40. echo '<div style="background:#eeefef;border:2px solid green;padding:10px;">';
  41. $this->_acl->old_fixed();
  42. echo '</div>';
  43. }
  44. $this->CRM_PROCES_USERA_UZYTY_MAP = $this->_acl->getUsedProcesMap();
  45. // TODO: run only if needed
  46. $this->_generate_wyniki_testow();
  47. }
  48. static function getInstance() {
  49. static $_instance = null;
  50. if (!$_instance) {
  51. $_instance = new ProcesMenu();
  52. }
  53. return $_instance;
  54. }
  55. function show() {
  56. static $_menu_showed = false;
  57. if (!$_menu_showed) {
  58. $actionName = V::get('_action', 'menu', $_REQUEST);
  59. // podglad testów pracownika
  60. if (User::isAdmin() && $this->_user_id != User::getID()) {
  61. $actionName = 'showMyTests';
  62. }
  63. $actionName .= 'Action';
  64. if (method_exists($this, $actionName)) {
  65. $this->{$actionName}();
  66. }
  67. //$this->show_menu_with_process();
  68. $_menu_showed = true;
  69. }
  70. }
  71. /**
  72. * @return Array
  73. */
  74. function get_wykonane_testy() {
  75. $testy_arr = array();
  76. if ($this->_user_id > 0) {
  77. $ses_cache_key = 'CRM_PROCES_USERA_WYKONANE_TESTY-' . $this->_user_id;
  78. if ('1' == V::get('_CLEAN_CACHE', '', $_GET)) unset($_SESSION[$ses_cache_key]);// TODO: DBG
  79. if (!isset($_SESSION[$ses_cache_key])) {
  80. $proces_map = $this->_acl->getUsedProcesMap();
  81. if (!empty($proces_map)) {
  82. $testy_arr = ProcesTestyHelper::get_tetsy_stats($this->_user_id, 0, array_keys($proces_map));// 30000000 => 0
  83. // check if tests are actual - proces steps may change
  84. if (!empty($testy_arr)) {
  85. $procesy_steps = array();
  86. foreach ($testy_arr as $v_test) {
  87. $procesy_steps[$v_test->ID_PROCES_INIT] = V::get($v_test->ID_PROCES_INIT, null, $proces_map);
  88. }
  89. foreach ($procesy_steps as $k_proces_id => $v_steps_arr) {
  90. $last_test = null;
  91. foreach ($testy_arr as $k_ind => $v_test) {
  92. if ($v_test->ID_PROCES_INIT == $k_proces_id) {
  93. $last_test = $v_test;
  94. $last_test->test_ind = $k_ind;
  95. break;
  96. }
  97. }
  98. if (!$last_test || $last_test->TEST_END == '0000-00-00') {
  99. continue;
  100. }
  101. $max_update_date = ProcesTestyHelper::get_max_update_date($v_steps_arr);
  102. if ($max_update_date) {
  103. $max_update_date = substr($max_update_date, 0, 10);
  104. $test_end = substr($last_test->TEST_END, 0, 10);
  105. if('1' == V::get('DBG_PM', '', $_GET)){echo'<pre style="max-height:200px;overflow:auto;border:1px solid red;text-align:left;">'."P_INIT({$k_proces_id}) max_update_date({$max_update_date}) TEST_END({$last_test->TEST_END}) not actual(" . ($max_update_date > $last_test->TEST_END) . ")".' (' . __CLASS__ . '::' . __FUNCTION__ . ':' . __LINE__ . '): ';print_r($last_test);echo'</pre>';}
  106. if ($max_update_date > $test_end) {
  107. $testy_arr[$last_test->test_ind]->unactual = $max_update_date;
  108. $testy_arr[$last_test->test_ind]->unactualId = $last_test->ID;
  109. }
  110. }
  111. }
  112. }
  113. }
  114. $_SESSION[$ses_cache_key] = $testy_arr;
  115. }
  116. return $_SESSION[$ses_cache_key];
  117. }
  118. return $testy_arr;
  119. }
  120. function setError($error) {
  121. $this->error[] = $error;
  122. }
  123. function ifError() {// TODO: RMME
  124. if (!empty($this->error)) {
  125. return true;
  126. }
  127. else {
  128. DEBUG_S(-1,'Wydarzyły się błędy uniemożliwiające kontynuacje pracy modułu',$this->error,__FILE__,__FUNCTION__,__LINE__);
  129. die();
  130. return false;
  131. }
  132. }
  133. function set_current_menu($new_menu) {
  134. $this->MENU_SELECT_PROCES = $new_menu;
  135. }
  136. /**
  137. * Set $_SESSION['MENU_SELECT_PROCES_DATA'] from $this->MENU_SELECT_PROCES_DATA
  138. */
  139. function set_current_menu_data() {
  140. $_SESSION['MENU_SELECT_PROCES_DATA'] = array();
  141. foreach ($this->MENU_SELECT_PROCES_DATA as $k_ind => $v_arr) {
  142. if (!empty($v_arr)) {
  143. $_SESSION['MENU_SELECT_PROCES_DATA'][$k_ind] = $v_arr;
  144. }
  145. }
  146. }
  147. function showMyTestsAction() {
  148. $this->menuAction();
  149. $userAcl = User::getAcl();
  150. $map = $this->_acl->getUsedProcesMap();
  151. $menu_to_show = array_keys($map);
  152. if (empty($menu_to_show)) {
  153. echo '<p>' . "Brak przypisanych procesów." . '</p>';
  154. return;
  155. }
  156. $procesy_init_ids = array();
  157. $db = DB::getDB();
  158. $sql = "select `ID`,`DESC` from `CRM_PROCES` where `TYPE`='PROCES_INIT' and `ID` in (".implode(",", $menu_to_show).") ";
  159. $res = $db->query($sql);
  160. while ($r = $db->fetch($res)) {
  161. $procesy_init_ids[$r->ID] = $r->DESC;
  162. }
  163. ?>
  164. <style type="text/css">
  165. .tbl-wyniki-testow {}
  166. .tbl-wyniki-testow td {vertical-align:top;font-size:small;}
  167. .tbl-wyniki-testow .proces-box {padding:0 6px;background:#f00;color:#fff;font-weight:bold;font-family:arial;text-decoration:none}
  168. .tbl-wyniki-testow .proces-desc {padding:0 3px;}
  169. .tbl-wyniki-testow .wynik-cell .wyniki-cell-header {height:56px;overflow:hidden;}
  170. .tbl-wyniki-testow .wynik-cell {padding:0 3px;background-color:#f7f7f7;}
  171. .tbl-wyniki-testow .wynik-BRAK_TESTU .proces-box {background-color:silver;}
  172. .tbl-wyniki-testow .wynik-BRAK_PYTAN .proces-box {background-color:#51B7D5;}
  173. .tbl-wyniki-testow .wynik-DOBRY .proces-box {background-color:lightgreen;}
  174. .tbl-wyniki-testow .wynik-DOSTATECZNY .proces-box {background-color:#FFFFB1; color:#777;}
  175. .tbl-wyniki-testow .wynik-NIEDOSTATECZNY .proces-box {background-color:#FC5151;}
  176. .tbl-wyniki-testow .wynik-IDEALNY .proces-box {background-color:gold;}
  177. .tbl-wyniki-testow .wynik-NIEAKTUALNY .proces-box {background-color:silver;}
  178. .tbl-wyniki-testow .row-fluid {margin-bottom:20px;}
  179. </style>
  180. <?php
  181. $userGroups = $this->_acl->fetchGroups();
  182. $idZasobowUsera = array_keys($userGroups);
  183. $idZasobowUsera = reset($idZasobowUsera);
  184. ?>
  185. <div class="container-fluid tbl-wyniki-testow">
  186. <div class="row-fluid">
  187. <?php $i = 0; foreach ($procesy_init_ids as $proces_id => $proces_desc) : ?>
  188. <?php
  189. $wynik_teoretyczny = $this->get_ocena_testu($proces_id, 'TEORETYCZNY');
  190. $wynik_teoretyczny_value = $this->get_ocena_testu_value($proces_id, 'TEORETYCZNY');
  191. if ($wynik_teoretyczny == 'BRAK_PYTAN') {
  192. $wynik_teoretyczny_value = '';
  193. }
  194. $wynik_praktyczny = $this->get_ocena_testu($proces_id, 'PRAKTYCZNY');
  195. $wynik_unactual = $this->isTestUnactual($proces_id, 'TEORETYCZNY');
  196. ?>
  197. <div class="span3 wynik-cell wynik-<?php echo $wynik_teoretyczny; ?>">
  198. <div class="wyniki-cell-header">
  199. <a class="proces-box" href="procesy5.php?task=PROCES_VIEW&id_proces=<?php echo $proces_id; ?>" title="zobacz instrukcję do procesu <?php echo $proces_id; ?>" target="_blank"><?php echo $proces_id; ?></a>
  200. <span class="proces-desc"><?php echo $proces_desc; ?></span>
  201. </div>
  202. <li>
  203. <?php if ($userAcl->getPermsProcesId() == $proces_id) : ?>
  204. <b><a href="index.php?FUNCTION_INIT=MENU_SELECT_PROCES&_action=setPermsAll"> Wyłącz filtr uprawnien dla </a></b>
  205. <?php else : ?>
  206. <a href="index.php?FUNCTION_INIT=MENU_SELECT_PROCES&_action=setPermsByProces&id_proces=<?php echo $proces_id; ?>"> Uruchom filtr uprawnien dla </a>
  207. <?php endif; ?>
  208. <?php echo $proces_id; ?>
  209. </li>
  210. <?php if (!in_array($wynik_teoretyczny, array('DOBRY', 'IDEALNY')) || $wynik_unactual) : ?>
  211. <li>
  212. <a href="procesy5.php?task=CRM_TESTY__ADD_TEST&function_init=fun_CRM_TESTY_ADD&stanowisko_id=<?php echo $idZasobowUsera; ?>&proces_id=<?php echo $proces_id; ?>&test_type=TEORETYCZNY"> Wykonaj test teoretyczny dla </a>
  213. <?php echo $proces_id; ?>
  214. </li>
  215. <?php endif; ?>
  216. <li>Test teoretyczny: <span class="proces-box"><?php echo $wynik_teoretyczny; ?>
  217. <?php if ($wynik_teoretyczny_value) : ?> <em>(<?php echo $wynik_teoretyczny_value; ?>)</em><?php endif; ?>
  218. </span>
  219. </li>
  220. <li class="wynik-<?php echo $wynik_praktyczny; ?>">Test praktyczny: <?php echo $wynik_praktyczny; ?></li>
  221. <?php if ($wynik_unactual) : ?>
  222. <div class="alert alert-error">
  223. <b>Uwaga! Test nieaktualny:</b>
  224. <?php if ($wynik_unactual->unactualId) : ?>
  225. <a class="btn btn-mini btn-primary" href="procesy5.php?task=CRM_TESTY__ADD_TEST&function_init=fun_CRM_TESTY__ADD_FIX&test_id=<?php echo $wynik_unactual->unactualId; ?>">popraw</a>
  226. <?php endif; ?>
  227. <br /><?php echo $wynik_unactual->TEST_END; ?> - zakończenie testu
  228. <br /><?php echo $wynik_unactual->unactual; ?> - ostatnia zmiana w procesie
  229. </div>
  230. <?php endif; ?>
  231. </div>
  232. <?php if (++$i >= 4) : $i = 0; ?>
  233. </div><div class="row-fluid">
  234. <?php endif; ?>
  235. <?php endforeach; ?>
  236. </div>
  237. </div>
  238. <?php
  239. }
  240. function menuAction() {
  241. $testy_teoretyczne = $this->get_actual_tests_count('TEORETYCZNY');
  242. $testy_praktyczne = $this->get_actual_tests_count('PRAKTYCZNY');
  243. $procesy_init_arr = $this->_acl->getUsedProcesInitIds();
  244. $proces_cnt = count($procesy_init_arr);
  245. $testy_ok = $this->get_actual_tests_count();
  246. $MojeTestyTitle = "Ilość Procesów: {$proces_cnt}, Aktualnych testów: {$testy_ok}, Teoretycznych: {$testy_teoretyczne}, Praktycznych: {$testy_praktyczne}";
  247. $userAcl = User::getAcl();
  248. $tbls = $userAcl->getTablesAcl();
  249. $urls = $userAcl->getUrls();
  250. $outMenus = array();
  251. $outBtnsMenus = array();
  252. if (!empty($tbls)) {
  253. foreach ($tbls as $kZasobID => $vTblAcl) {
  254. $outMenus[$kZasobID] = $vTblAcl->getLongLabel();
  255. if ($userAcl->getPermsProcesId()) {
  256. $outBtnsMenus[$kZasobID] = $vTblAcl->getRawLabel();
  257. }
  258. }
  259. }
  260. asort($outMenus);
  261. if ($userAcl->getPermsProcesId()) {
  262. asort($outBtnsMenus);
  263. }
  264. $outUrls = array();
  265. if (!empty($urls)) {
  266. /**
  267. * [147] => Array(
  268. * [TYPE] => URL
  269. * [DESC] => ?MENU_INIT=DODAJ_REKORDY_MIESZKAN_FUNC
  270. * [OPIS] => Narzedzie do wprowadzania zasobow mieszkan indywidualnych
  271. */
  272. foreach ($urls as $kZasobID => $vTitle) {
  273. $outUrls[$kZasobID] = $vTitle;
  274. }
  275. }
  276. asort($outUrls);
  277. $active = '';
  278. $script_name = V::get('SCRIPT_NAME', '', $_SERVER);
  279. if (false !== strpos($script_name, 'index.php')) {
  280. $menu_init = V::get('MENU_INIT', '', $_GET);
  281. switch ($menu_init) {
  282. case 'VIEWTABLE_AJAX': $active = 'menu'; break;
  283. case 'VIEWTABLE_KONTAKTY': $active = 'kontakty'; break;
  284. default: {
  285. $fun_init = V::get('FUNCTION_INIT', '', $_GET);
  286. switch ($fun_init) {
  287. case 'MENU_SELECT_PROCES': $active = 'testy_moje'; break;
  288. case 'PRZYPOMNIJ_FUNC': $active = 'przypomnij'; break;
  289. case 'PRZYPOMNIJ': $active = 'przypomnij'; break;
  290. default:
  291. }
  292. }
  293. }
  294. }
  295. else if (false !== strpos($script_name, 'procesy5.php')) {
  296. $task = V::get('task', '', $_GET);
  297. switch ($task) {
  298. case 'CRM_PROCES': $active = 'procesy'; break;
  299. case 'CRM_LISTA_ZASOBOW': $active = 'zasoby'; break;
  300. case 'CRM_WYSWIETL_OBOWIAZKI': $active = 'obowiazki'; break;
  301. case 'CRM_TESTY': $active = 'testy'; break;
  302. case 'CRM_TESTY_WYNIKI': $active = 'testy_wyniki'; break;
  303. case 'CRM_SEARCH': $active = 'search'; break;
  304. default:
  305. // testy_moje ?FUNCTION_INIT=MENU_SELECT_PROCES&MENU_SELECT_PROCES=show_menu_with_process => _action=showMyTests
  306. }
  307. }
  308. /*
  309. * $_SESSION['USER_PROFILE'][section][key] = val;
  310. */
  311. $userBookmarks = UserBookmarks::getInstance();
  312. $bookmarksJson = array();
  313. $bookmarks = $userBookmarks->getBookmarks();
  314. foreach ($bookmarks as $kZasobID => $vClass) {
  315. if (array_key_exists($kZasobID, $tbls)) {
  316. $bookmarksJson[] = (object)array('id'=>$kZasobID, 'name'=>$tbls[$kZasobID]->getName(), 'label'=>$tbls[$kZasobID]->getRawLabel(), 'opis'=>$tbls[$kZasobID]->getOpis(), 'type'=>'menu', 'class'=>$vClass);
  317. }
  318. else if (array_key_exists($kZasobID, $urls)) {
  319. $bookmarksJson[] = (object)array('id'=>$kZasobID, 'name'=>$urls[$kZasobID], 'type'=>'url', 'class'=>$vClass);
  320. }
  321. }
  322. $userGroupIdsCSV = User::getGroupsIds();
  323. $userGroupIdsCSV = implode(',', $userGroupIdsCSV);
  324. $typeSpecialUserId = null;
  325. if (User::isAdmin()) {
  326. $typeSpecialUserId = TypespecialVariable::getInstance(-1, '__USER_ID');
  327. }
  328. $typeSpecialZasob = TypespecialVariable::getInstance(-1, '__ZASOB');
  329. ?>
  330. <div id="SE-menu" class="navbar navbar-inverse" style="position: static;">
  331. <div class="navbar-inner">
  332. <div class="container">
  333. <div class="nav-collapse collapse navbar-inverse-collapse">
  334. <ul class="nav">
  335. <li class="dropdown<?php if ($active == 'menu') echo ' active'; ?>">
  336. <a href="#" class="dropdown-toggle" data-toggle="dropdown">Menu <b class="caret"></b></a>
  337. <ul class="dropdown-menu" id="SE-menu-tables">
  338. <?php foreach ($outMenus as $kZasobID => $vName) : ?>
  339. <li>
  340. <a href="index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=<?php echo $kZasobID; ?>">
  341. <i class="bookmark-item-add-<?php echo $kZasobID; ?> bookmark-item-add icon-star-empty" title="Add to favorites" data-zasobid="<?php echo $kZasobID; ?>"></i>
  342. <i class="bookmark-item-rem-<?php echo $kZasobID; ?> bookmark-item-rem icon-star" style="display:none" title="Remove from favorites" data-zasobid="<?php echo $kZasobID; ?>"></i>
  343. <?php echo $vName; ?>
  344. </a>
  345. </li>
  346. <?php endforeach; ?>
  347. </ul>
  348. </li>
  349. <li class="dropdown">
  350. <a href="#" class="dropdown-toggle" data-toggle="dropdown">Narzędzia <b class="caret"></b></a>
  351. <ul class="dropdown-menu">
  352. <?php foreach ($outUrls as $kZasobID => $vTitle) : ?>
  353. <li>
  354. <a href="index.php?FUNCTION_INIT=URL_INIT&ZASOB_ID=<?php echo $kZasobID; ?>" target="_blank" title="<?php echo $vTitle; ?>">
  355. <i class="bookmark-item-add-<?php echo $kZasobID; ?> bookmark-item-add icon-star-empty" title="Add to favorites" data-zasobid="<?php echo $kZasobID; ?>"></i>
  356. <i class="bookmark-item-rem-<?php echo $kZasobID; ?> bookmark-item-rem icon-star" style="display:none" title="Remove from favorites" data-zasobid="<?php echo $kZasobID; ?>"></i>
  357. <code><?php echo $kZasobID; ?></code>
  358. <?php echo (mb_strlen($vTitle, 'utf-8') > 100)? mb_substr($vTitle, 0, 100, 'utf-8') . '...' : $vTitle; ?>
  359. </a>
  360. </li>
  361. <?php endforeach; ?>
  362. </ul>
  363. </li>
  364. <li<?php if ($active == 'procesy') echo ' class="active"'; ?>><a href="procesy5.php?task=CRM_PROCES" title="Wyswietlenie procesow">Procesy</a></li>
  365. <li class="dropdown <?php if ($active == 'zasoby') echo "active"; ?>">
  366. <a id="ProcesMenuZasobDropdownLink" href="#" class="dropdown-toggle" data-toggle="dropdown">Zasoby <b class="caret"></b></a>
  367. <ul class="dropdown-menu">
  368. <li>
  369. <a href="procesy5.php?task=CRM_LISTA_ZASOBOW<?php echo "&filtr_id={$userGroupIdsCSV}&filtr_ids=%2B&filtr_ob=%2B&filtr_img=%2B"; ?>" title="Moje Zasoby">Moje Zasoby</a>
  370. </li>
  371. <?php if ('VIEWTABLE_AJAX' == V::get('MENU_INIT', '', $_REQUEST)) : ?>
  372. <li>
  373. <a href="procesy5.php?task=CRM_LISTA_ZASOBOW<?php if(!empty($_REQUEST['ZASOB_ID'])) echo "&filtr_id={$_REQUEST['ZASOB_ID']}&filtr_ids=%2B&filtr_ob=%2B"; ?>" title="Struktura aktualnie przeglądanej tabeli">Struktura aktualnie przeglądanej tabeli</a>
  374. </li>
  375. <?php endif; ?>
  376. <li>
  377. <a href="procesy5.php?task=CRM_LISTA_ZASOBOW&filtr_id=" title="Wyświetlenie drzewa zasobów">Wszystkie Zasoby</a>
  378. </li>
  379. <li class="divider"></li>
  380. <li class="nav-header"><nobr>Wyszukaj:</nobr></li>
  381. <?php if (!$typeSpecialZasob) : ?>
  382. <li>
  383. <div class="alert alert-error">Brak typespecial __ZASOB</div>
  384. </li>
  385. <?php else : ?>
  386. <li>
  387. <form id="ProcesMenuZasobFrm" action="procesy5.php" method="GET" style="padding:0 20px">
  388. <input type="hidden" name="task" value="CRM_LISTA_ZASOBOW">
  389. <?php
  390. $fldName = 'ProcesMenu__filtr_id';
  391. $fldParams = array();
  392. $fldParams['allowCreate'] = false;
  393. $fldParams['ajaxDataUrlBase'] = "index.php?FUNCTION_INIT=PROCES_MENU&HEADER_NOT_INIT=YES&_task=TYPESPECIAL&fld={$fldName}";
  394. $fldParams['placeholder'] = 'Szukaj...';
  395. $fldParams['formFieldName'] = 'filtr_id';
  396. //$fldParams['ajaxDataUrlBase'] .= "&DBG_TS=3";
  397. echo $typeSpecialZasob->showFormItem($tblID = -1, $fldName, $selValue = '', $fldParams);
  398. ?>
  399. <input class="btn btn-mini btn-primary" type="submit" value="Wybierz" />
  400. <input class="pull-right btn btn-mini btn-default" type="submit" id="ProcesMenuZasobFltrAdd" value="Dodaj do filtra" />
  401. <script>
  402. jQuery(document).ready(function() {
  403. if ('procesy5.php' === window.location.pathname.substr(-12)
  404. && window.location.search.search('task=CRM_LISTA_ZASOBOW') > 0
  405. && window.location.search.search('&filtr_id=') > 0
  406. ) {
  407. jQuery('#ProcesMenuZasobFltrAdd').on('click', function(e) {
  408. var frm = jQuery(this).get(0).form;
  409. var fldNode = frm['<?php echo $fldParams['formFieldName']; ?>'],
  410. fltrId = '';
  411. if (fldNode && '' != fldNode.value) {
  412. fltrId = fldNode.value;
  413. } else {
  414. return;
  415. }
  416. var pos = 0, fltrIds = '';
  417. if ('procesy5.php' === window.location.pathname.substr(-12)
  418. && window.location.search.search('task=CRM_LISTA_ZASOBOW') > 0
  419. && (pos = window.location.search.search('&filtr_id=')) > 0
  420. ) {
  421. pos += 10;
  422. fltrIds = window.location.search.substr(pos);
  423. if ((pos = fltrIds.search('&')) > 0) {
  424. fltrIds = fltrIds.substr(0, pos);
  425. }
  426. if (fltrIds) {
  427. fltrIds = decodeURIComponent(fltrIds);
  428. fltrIds += ',' + fltrId;
  429. if (fldNode.selectize) {
  430. fldNode.selectize.addOption({id: fltrIds, name: fltrIds});
  431. fldNode.selectize.setValue(fltrIds, true);
  432. }
  433. }
  434. }
  435. });
  436. } else {
  437. jQuery('#ProcesMenuZasobFltrAdd').hide();
  438. }
  439. jQuery('#ProcesMenuZasobFrm').on('submit', function(e) {
  440. var frm = jQuery(this).get(0),
  441. fldNode = frm['<?php echo $fldParams['formFieldName']; ?>'];
  442. if (fldNode && '' != fldNode.value) {
  443. return true;
  444. } else {
  445. return false;
  446. }
  447. });
  448. jQuery('#ProcesMenuZasobDropdownLink').on('click', function(e) {
  449. setTimeout(function(){
  450. jQuery('#ts-<?php echo $fldName; ?>')
  451. .next('.selectize-control')
  452. .find('input:first')
  453. .focus();
  454. }, 200);
  455. });
  456. });
  457. </script>
  458. </form>
  459. </li>
  460. <?php endif; ?>
  461. </ul>
  462. </li>
  463. <li<?php if ($active == 'obowiazki') echo ' class="active"'; ?>><a href="procesy5.php?task=CRM_WYSWIETL_OBOWIAZKI" title="Wyswietlenie OBOWIAZKOW">Obowiązki</a></li>
  464. <li<?php if ($active == 'testy') echo ' class="active"'; ?>><a href="procesy5.php?task=CRM_TESTY" title="Wyswietlenie testów">Testy</a></li>
  465. <li<?php if ($active == 'testy_moje') echo ' class="active"'; ?>><a href="index.php?FUNCTION_INIT=MENU_SELECT_PROCES&_action=showMyTests" title="<?php echo $MojeTestyTitle; ?>">Moje (<?php echo "{$testy_ok} z {$proces_cnt}: T {$testy_teoretyczne}, P {$testy_praktyczne}"; ?>)</a></li>
  466. <?php if (User::get('ADM_ADMIN_LEVEL') <= 2) : ?>
  467. <li<?php if ($active == 'testy_wyniki') echo ' class="active"'; ?>><a href="procesy5.php?task=CRM_TESTY_WYNIKI" title="Wyswietlenie wyników testów">Wyniki</a></li>
  468. <?php endif; ?>
  469. <li<?php if ($active == 'kontakty') echo ' class="active"'; ?>><a href="index.php?MENU_INIT=VIEWTABLE_KONTAKTY" title="Kontakty">Kontakty</a></li>
  470. <li<?php if ($active == 'przypomnij') echo ' class="active"'; ?>><a href="index.php?MENU_INIT=PRZYPOMNIJ&KTO=<?php echo User::getLogin(); ?>" title="Przypomnij">Przypomnij</a></li>
  471. </ul>
  472. <ul class="nav pull-right">
  473. <li<?php if ($active == 'search') echo ' class="active"'; ?>>
  474. <form action="procesy5.php?task=CRM_SEARCH" method="post" class="navbar-search">
  475. <input type="text" name="q" value="" class="q search-query span2">
  476. <input type="image" src="icon/search.png" class="s">
  477. </form>
  478. </li>
  479. <li class="divider-vertical"></li>
  480. <li style="padding:8px 0;"><?php S::show_session_timer(); ?></li>
  481. <li class="divider-vertical"></li>
  482. <li class="dropdown">
  483. <a href="#" class="dropdown-toggle" data-toggle="dropdown"><?php echo User::getName(); ?> <b class="caret"></b></a>
  484. <ul class="dropdown-menu">
  485. <?php if (file_exists('/Library/Server/Web/Data/Sites/Default/')) : ?>
  486. <li><a href="/webcal" target="_blank"><i class="icon-calendar"></i> Kalendarz</a></li>
  487. <?php if (file_exists('/Library/Server/Web/Data/Sites/Default/webmail/loginFromSE.php')) : ?>
  488. <li><a href="/webmail" target="_blank" onclick="jQuery(this).next('form').submit(); return false;"><i class="icon-envelope"></i> Poczta</a>
  489. <form action="https://<?php echo $_SERVER['SERVER_NAME']; ?>/webmail/loginFromSE.php" method="post" style="display:none;">
  490. <input type="hidden" name="_timezone" value="Europe/Berlin">
  491. <input type="hidden" name="_token" value="">
  492. <input type="hidden" name="_action" value="login">
  493. <input type="hidden" name="_task" value="login">
  494. <input type="hidden" name="_url" value="">
  495. <input type="hidden" name="_user" value="<?php echo User::getName(); ?>">
  496. <input type="hidden" name="_pass" value="<?php echo User::get('ADM_PASS_HASH'); ?>">
  497. <input type="hidden" name="EMAIL_IMAP_IMPORT_USERNAME" value="<?php echo V::get('EMAIL_IMAP_IMPORT_USERNAME', '', $_SESSION); ?>">
  498. <input type="hidden" name="EMAIL_IMAP_IMPORT_HOST" value="<?php echo V::get('EMAIL_IMAP_IMPORT_HOST', '', $_SESSION); ?>">
  499. <input type="hidden" name="EMAIL_IMAP_IMPORT_PASSWD_HASH" value="<?php echo V::get('EMAIL_IMAP_IMPORT_PASSWD_HASH', '', $_SESSION); ?>">
  500. <input type="hidden" name="loginFromSE" value="1">
  501. <input type="submit" class="btn" value="P" />
  502. </form>
  503. </li>
  504. <?php elseif (file_exists('/Library/Server/Web/Data/Sites/Default/webmail')) : ?>
  505. <li><a href="/webmail" target="_blank"><i class="icon-envelope"></i> Poczta</a></li>
  506. <?php endif; ?>
  507. <li><a href="https://<?php echo $_SERVER['SERVER_ADDR']; ?>/changepassword" target="_blank">Zmień hasło</a></li>
  508. <li><a href="/profilemanager" target="_blank"><i class="icon-user"></i> Apple Profile Manager</a></li>
  509. <li class="divider"></li>
  510. <?php else: ?>
  511. <li><a href="index.php?LOGIN=PASSEDIT">Zmień hasło</a></li>
  512. <?php endif; ?>
  513. <li><a href="procesy5.php?task=USER" title="<?php echo User::getName(); ?>"><i class="icon-user"></i> Profil</a></li>
  514. <li><a href="index.php?LOGIN=PERMS_RELOAD" title="Przeładuj uprawnienia"><i class="icon-refresh"></i> Przeładuj uprawnienia</a></li>
  515. <?php if (User::isAdmin()) : ?>
  516. <li class="divider"></li>
  517. <li class="nav-header"><nobr>Pokaż testy pracownika:</nobr></li>
  518. <?php if (!$typeSpecialUserId) : ?>
  519. <li>
  520. <div class="alert alert-error">Brak typespecial __USERS_ID</div>
  521. </li>
  522. <?php else : ?>
  523. <li>
  524. <form action="index.php" method="POST">
  525. <input type="hidden" name="FUNCTION_INIT" value="MENU_SELECT_PROCES">
  526. <input type="hidden" name="_action" value="showMyTests">
  527. <?php
  528. $fldName = '_user_id';
  529. $fldParams = array();
  530. $fldParams['allowCreate'] = false;
  531. $fldParams['ajaxDataUrlBase'] = "index.php?FUNCTION_INIT=PROCES_MENU&HEADER_NOT_INIT=YES&_task=TYPESPECIAL&fld={$fldName}";
  532. $fldParams['placeholder'] = 'Szukaj...';
  533. //$fldParams['ajaxDataUrlBase'] .= "&DBG_TS=3";
  534. echo $typeSpecialUserId->showFormItem($tblID = -1, $fldName, $selValue = '', $fldParams);
  535. ?>
  536. <input class="btn btn-mini btn-warning" type="submit" value="Wybierz" />
  537. </form>
  538. </li>
  539. <?php endif; ?>
  540. <?php endif; ?>
  541. <li class="divider"></li>
  542. <li><a href="index.php?LOGIN=LOGOUT"><i class="icon-off"></i> Wyloguj</a></li>
  543. </ul>
  544. </li>
  545. </ul>
  546. </div><!-- /.nav-collapse -->
  547. </div>
  548. </div><!-- /navbar-inner -->
  549. <?php if ($userAcl->getPermsProcesId()) : ?>
  550. <div id="SE-menu-sub">
  551. <a class="btn btn-mini btn-danger" href="index.php?FUNCTION_INIT=MENU_SELECT_PROCES&_action=setPermsAll" title="Wyłącz filtr uprawnień dla procesu <?php echo $userAcl->getPermsProcesId(); ?>">Wyłącz filtr uprawnień: <?php echo $userAcl->getPermsProcesId(); ?></a>
  552. <?php foreach ($outBtnsMenus as $kZasobID => $vName) : ?>
  553. <a class="btn btn-mini" href="index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=<?php echo $kZasobID; ?>" title="<?php echo $vName; ?>"><?php echo V::strShortUtf8($vName, 20); ?></a>
  554. <?php endforeach; ?>
  555. <?php foreach ($outUrls as $kZasobID => $vTitle) : ?>
  556. <a class="btn btn-mini" href="index.php?FUNCTION_INIT=URL_INIT&ZASOB_ID=<?php echo $kZasobID; ?>" target="_blank" title="<?php echo $vTitle; ?>"><?php echo V::strShortUtf8($vTitle, 20); ?></a>
  557. <?php endforeach; ?>
  558. </div>
  559. <?php else : ?>
  560. <div id="SE-menu-sub"></div>
  561. <script>
  562. (function ($, undefined) {
  563. var UserBookmarks = function() {
  564. var priv = {}; //private api
  565. var publ = {}; //public api
  566. priv.options = {};
  567. var defaults = {
  568. url: '', //webservice url
  569. urlInit: true, // try to load services on init
  570. preloadData: null,
  571. menuid: '',
  572. debug: false
  573. };
  574. var _cont; // container holding table
  575. var _menu; // container holding stars
  576. var _stateEdit = false;
  577. /*
  578. initialize the plugin.
  579. */
  580. priv.init = function() {
  581. _cont = $(priv.options.id);
  582. _menu = $(priv.options.menuid);
  583. _menu.find('.bookmark-item-add').click(function(e){
  584. e.preventDefault();
  585. e.stopPropagation();
  586. var zasobid = jQuery(this).data('zasobid');
  587. priv.update('add_bookmark', zasobid);
  588. var item = $('#bookmark-item-' + zasobid);
  589. if (item) {
  590. item.addClass('has_bookmark');
  591. }
  592. });
  593. _menu.find('.bookmark-item-rem').click(function(e){
  594. e.preventDefault();
  595. e.stopPropagation();
  596. var zasobid = jQuery(this).data('zasobid');
  597. priv.update('remove_bookmark', zasobid);
  598. });
  599. if (priv.options.urlInit) priv.update();
  600. if (priv.options.preloadData) priv.setData(priv.options.preloadData);
  601. };
  602. priv.setData = function(data) {
  603. _cont.empty();
  604. $.each(data, function(ind, item){
  605. if ('type' in item) {
  606. var l = $('<a></a>');
  607. l.data('id', item.id);
  608. l.addClass('btn');
  609. l.addClass('btn-mini');
  610. var label = item.name, title = '';
  611. if ('class' in item) {
  612. l.addClass(item.class);
  613. }
  614. if (item.type == 'menu') {
  615. l.attr('href', 'index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=' + item.id);
  616. if ('label' in item && item.label.length > 0) {
  617. label = item.label;
  618. title = item.label + ' (' + item.name + ')';
  619. }
  620. else if ('opis' in item && item.opis.length > 0) {
  621. label = item.opis;
  622. title = item.opis + ' (' + item.name + ')';
  623. }
  624. } else if (item.type == 'url') {
  625. l.attr('href', 'index.php?FUNCTION_INIT=URL_INIT&ZASOB_ID=' + item.id);
  626. l.attr('target', '_blank');
  627. }
  628. if (label.length > 20) {
  629. var pos = label.indexOf(' - ');
  630. if (pos > 20 || pos < 5) {
  631. pos = 20;
  632. l.text(label.substring(0, pos) + ' ...');
  633. } else {
  634. l.text(label.substring(0, pos));
  635. }
  636. } else {
  637. l.text(label);
  638. }
  639. if (title == '') title = label;
  640. l.attr('title', title);
  641. l.appendTo(_cont);
  642. if (_stateEdit) {
  643. priv.addEditBtns(l);
  644. }
  645. }
  646. // stars visibility
  647. $('.bookmark-item-rem-' + item.id).show();
  648. $('.bookmark-item-add-' + item.id).hide();
  649. });
  650. if (data.length > 0) {
  651. var editBtn = $('<button class="btn btn-mini btn-inverse" style="float:right" title="Edit Bookmarks"><i class="icon-cog icon-white"></i></button>')
  652. editBtn.on('click', priv.edit);
  653. editBtn.prependTo(_cont);
  654. }
  655. };
  656. priv.update = function(task, zasobID, argsAdd) {
  657. task = task || '';
  658. zasobID = zasobID || '';
  659. argsAdd = argsAdd || '';
  660. $.ajax({
  661. url: priv.options.url + '&_task=' + task + '&_zasobID=' + zasobID + argsAdd,
  662. type: 'GET',
  663. dataType: 'json',
  664. contentType: "application/json; charset=utf-8",
  665. data: null,
  666. async: true,
  667. success: function (data) {
  668. $('.bookmark-item-rem').hide();
  669. $('.bookmark-item-add').show();
  670. priv.setData(data);
  671. },
  672. error: function (err) {
  673. console.log('Error');
  674. console.log(err);
  675. }
  676. });
  677. };
  678. priv.changed = function(e) {
  679. if (priv.options.debug) console.log(e.data);
  680. if (priv.options.debug) console.log('id(' + e.data.id + ') cls(' + e.data.cls + ')');
  681. priv.update('change_bookmark', e.data.id, '&btnCls=' + e.data.cls);
  682. return false;
  683. };
  684. priv.removed = function(e) {
  685. if (priv.options.debug) console.log(e.data);
  686. if (priv.options.debug) console.log('id(' + e.data.id + ')');
  687. priv.update('remove_bookmark', e.data.id);
  688. return false;
  689. };
  690. priv.addEditBtns = function(el) {
  691. var next, btn;
  692. el.wrap('<div></div>');
  693. next = $('<span><em> Change color:</em> </span>');
  694. $.each(['btn-default', 'btn-primary', 'btn-info', 'btn-success', 'btn-warning', 'btn-danger'], function(btnInd, btnClass){
  695. btn = $('<button class="btn btn-mini ' + btnClass + '"> &nbsp; </button>');
  696. btn.on('click', {id: el.data('id'), cls: btnClass}, priv.changed);
  697. btn.appendTo(next);
  698. });
  699. btn = $('<button class="btn btn-mini"> remove </button>');
  700. btn.on('click', {id: el.data('id')}, priv.removed);
  701. btn.appendTo(next);
  702. next.insertAfter(el);
  703. };
  704. priv.edit = function(e) {
  705. _stateEdit = !_stateEdit;
  706. var el;
  707. _cont.find('a').each(function(ind, n){
  708. if (priv.options.debug) console.log(n);
  709. el = $(n);
  710. if (_stateEdit) {
  711. priv.addEditBtns(el);
  712. } else {
  713. el.next().remove();
  714. el.unwrap();
  715. }
  716. });
  717. }
  718. publ.init = function(options) {
  719. if (priv.options.debug) console.log('UserBookmarks initialization...');
  720. //merge supplied options with defaults
  721. $.extend(priv.options, defaults, options);
  722. priv.init();
  723. return publ;
  724. };
  725. return publ;
  726. };
  727. $.fn.UserBookmarks = function(options) {
  728. options = options || {};
  729. return this.each(function() {
  730. options.id = this;
  731. $(this).data('UserBookmarks', new UserBookmarks().init(options));
  732. });
  733. };
  734. })(jQuery);
  735. </script>
  736. <script>
  737. jQuery(document).ready(function(){
  738. jQuery('#SE-menu-sub').UserBookmarks({
  739. url: 'index-ajax.php?_cls=UserBookmarks',
  740. urlInit: false,
  741. preloadData: <?php echo json_encode($bookmarksJson); ?>,
  742. menuid: '#SE-menu',
  743. debug: false
  744. });
  745. });
  746. </script>
  747. <?php endif; ?>
  748. </div>
  749. <?php
  750. }
  751. /**
  752. * Generates wyniki
  753. */
  754. function _generate_wyniki_testow() {
  755. $this->_wynik_testu = array();// WYNIK_TESTU_PROCESU
  756. $this->_wynik_testu_unactual = array();
  757. $this_CRM_PROCES_USERA_WYKONANE_TESTY = $this->get_wykonane_testy();
  758. foreach ($this_CRM_PROCES_USERA_WYKONANE_TESTY as $v_test) {
  759. if (isset($this->_wynik_testu[$v_test->ID_PROCES_INIT][$v_test->TEST_TYPE])) {
  760. continue;// only first
  761. }
  762. $this->_wynik_testu[$v_test->ID_PROCES_INIT][$v_test->TEST_TYPE] = $v_test->OCENA;
  763. if (!empty($v_test->unactual)) {
  764. $x_test = new stdClass();
  765. $x_test->TEST_END = substr($v_test->TEST_END, 0, 10);
  766. $x_test->unactual = substr($v_test->unactual, 0, 10);
  767. $x_test->unactualId = $v_test->unactualId;
  768. $this->_wynik_testu_unactual[$v_test->ID_PROCES_INIT][$v_test->TEST_TYPE] = $x_test;
  769. }
  770. }
  771. }
  772. function get_ocena_testu($proces_id, $typ) {
  773. $ocena = $this->get_ocena_testu_value($proces_id, $typ);
  774. if (!$ocena) {
  775. return 'BRAK_TESTU';
  776. }
  777. else if ($ocena == -1) {
  778. return 'BRAK_PYTAN';
  779. }
  780. else if ($ocena == 3) {
  781. return 'IDEALNY';
  782. }
  783. else if ($ocena < 2) {
  784. return 'NIEDOSTATECZNY';
  785. }
  786. else if($ocena < 2.5) {
  787. return 'DOSTATECZNY';
  788. }
  789. else {
  790. return 'DOBRY';
  791. }
  792. }
  793. function get_ocena_testu_value($proces_id, $typ) {
  794. if (isset($this->_wynik_testu[$proces_id][$typ])) {
  795. return $this->_wynik_testu[$proces_id][$typ];
  796. }
  797. return null;
  798. }
  799. function isTestUnactual($proces_id, $typ) {
  800. if (isset($this->_wynik_testu_unactual[$proces_id][$typ])) {
  801. return $this->_wynik_testu_unactual[$proces_id][$typ];
  802. }
  803. return false;
  804. }
  805. function get_actual_tests_count($type = null) {
  806. $this_CRM_PROCES_USERA_WYKONANE_TESTY = $this->get_wykonane_testy();
  807. if ($type == 'TEORETYCZNY') {
  808. $testy_teoretyczne = 0;
  809. foreach ($this_CRM_PROCES_USERA_WYKONANE_TESTY as $int => $v_test) {
  810. if ($v_test->TEST_TYPE=='TEORETYCZNY') {
  811. if ($v_test->OCENA > 2.5) $testy_teoretyczne++;
  812. }
  813. }
  814. return $testy_teoretyczne;
  815. }
  816. else if ($type == 'PRAKTYCZNY') {
  817. $testy_praktyczne = 0;
  818. foreach ($this_CRM_PROCES_USERA_WYKONANE_TESTY as $int => $v_test) {
  819. if ($v_test->TEST_TYPE=='PRAKTYCZNY') {
  820. if ($v_test->OCENA > 2.5) $testy_praktyczne++;
  821. }
  822. }
  823. return $testy_praktyczne;
  824. }
  825. else if ($type == null) {
  826. return count($this_CRM_PROCES_USERA_WYKONANE_TESTY);
  827. }
  828. return 0;
  829. }
  830. function wylacz_filtr_uprawnien_dla_procesu() {// TODO: RMME => _action=setPermsAll
  831. unset($this->MENU_SELECT_PROCES_DATA['uruchom_filtr_uprawnien_dla_procesu']);// usun tryb jednego procesu
  832. $this->set_current_menu_data();// zapisz do sesji
  833. $this->set_perms_for_process();// domyslnie pusty włącza
  834. }
  835. function uruchom_filtr_uprawnien_dla_procesu() {// TODO: RMME => _action=setPermsByProces
  836. $proces_to_filter = V::get('ID_PROCES', '', $_REQUEST);
  837. $map = $this->_acl->getUsedProcesMap();
  838. if (!in_array($proces_to_filter, $map)) {// TODO: chyba array_key_exists ?
  839. $this->setError(" Nie ma takiego procesu dla usera aby ustawic dla niego filtry");
  840. }
  841. $this->ifError();// ? // TODO: RMME
  842. //szukam tabeli do ustalenia permow
  843. $this->unset_all_perms();
  844. $this->MENU_SELECT_PROCES_DATA['uruchom_filtr_uprawnien_dla_procesu'] = $proces_to_filter;
  845. $this->set_current_menu_data();
  846. $this->set_perms_for_process($proces_to_filter);
  847. $this->set_current_menu_data();
  848. //$this->set_current_menu('show_menu_with_process');
  849. //$this->show_menu_with_process();
  850. }
  851. function unset_all_perms() {
  852. $dbg_czysc_permy = true;// @from USERS_FIELDS_PROFILE_INIT()
  853. foreach ($_SESSION as $ses_col_name => $col_vars) {
  854. if (!is_array($col_vars) || empty($col_vars)) continue;
  855. if ('_COLUMN' != substr($ses_col_name, -1 * strlen('_COLUMN'))) {
  856. continue;
  857. }
  858. if (empty($col_vars['PERMEDIT'])) continue;
  859. if ($dbg_czysc_permy) {
  860. foreach ($col_vars['PERMEDIT'] as $col_perm_ind => $col_perm_value) {
  861. if ($col_perm_ind != 'ID') {
  862. $_SESSION[$ses_col_name]['PERMEDIT'][$col_perm_ind] = "";
  863. }
  864. }
  865. }
  866. }
  867. if (isset($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'])) {
  868. foreach ($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'] as $zasob => $val) {
  869. unset($this->MENU_SELECT_PROCES_DATA['MENU_COLUMN'][$zasob]);
  870. unset($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$zasob]);
  871. }
  872. }
  873. }
  874. function set_perms_for_process($proces_to_filter = null) {// => setPermsByProcesAction
  875. if ($proces_to_filter) {
  876. $map = $this->_acl->getUsedProcesMap();
  877. if (array_key_exists($proces_to_filter, $map)) {
  878. $CRM_PROCES_USERA_UZYTY = $map[$proces_to_filter];
  879. } else {
  880. $CRM_PROCES_USERA_UZYTY = array();
  881. }
  882. }
  883. else {
  884. $CRM_PROCES_USERA_UZYTY = $this->_acl->getUsedProcesIds();
  885. }
  886. if (!empty($CRM_PROCES_USERA_UZYTY)) {
  887. return;
  888. }
  889. // ! @2013-02-11 zerzniete z USERS_FIELDS_PROFILE_INIT !
  890. $CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE = array();
  891. $CRM_TREE_WSKAZNIK_NARZEDZIE = array();
  892. $TREE_CRM_WSKAZNIK_CONF = array();
  893. $TREE_CRM_WSKAZNIK_SORT_PRIO = array();
  894. $db = DB::getDB();
  895. //kopiuje tabele ze wskaznikow
  896. $sql = "select t1.`ID_PROCES`
  897. , t1.`ID_ZASOB`
  898. , replace(t2.`FORM_TREAT`, ',', '') as FORM_TREAT
  899. , t3.`DESC` as ZASOB_DESC
  900. , t3.`TYPE`
  901. , t4.`DESC` as PARENT_ZASOB_DESC
  902. , t4.`TYPE` as PARENT_TYPE
  903. , t3.`SORT_PRIO` as z__SORT_PRIO
  904. , t3.`OPIS` as ZASOB_OPIS , t1.`ID` as ID_WSKAZNIK
  905. from `CRM_WSKAZNIK` as t1
  906. left join `CRM_PRZYPADEK` as t2 on (t1.ID_PRZYPADEK=t2.ID)
  907. left join `CRM_LISTA_ZASOBOW` as t3 on (t3.ID=t1.ID_ZASOB)
  908. left join `CRM_LISTA_ZASOBOW` as t4 on (t4.ID=t3.PARENT_ID)
  909. where
  910. (
  911. ( t3.`TYPE`='KOMORKA' and t4.`TYPE`='TABELA' )
  912. or (t3.`TYPE`='NARZEDZIE') or (t3.`TYPE`='URL')
  913. )
  914. and t1.`A_STATUS` in('NORMAL', 'WAITING')
  915. and t1.`ID_PROCES` in(" . implode(",", $CRM_PROCES_USERA_UZYTY) . ")
  916. ";
  917. $res = $db->query($sql);
  918. if (!$res) {
  919. return;
  920. }
  921. while ($r = $db->fetch($res)) {
  922. if ($r->TYPE == 'NARZEDZIE') {
  923. if (isset($CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB])) {
  924. $CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB] .= $r->FORM_TREAT;
  925. }
  926. else {
  927. $CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB] = $r->FORM_TREAT;
  928. }
  929. $CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE[$r->ID_PROCES][] = $r->ID_WSKAZNIK;//ustawiam wskaznik od procesu, jak user wybierze proces do roboty, to ja poznam co moze mu sie pojawic
  930. }
  931. else if ($r->TYPE == 'URL') {
  932. $CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE[$r->ID_PROCES][] = $r->ID_WSKAZNIK;//ustawiam wskaznik od procesu, jak user wybierze proces do roboty, to ja poznam co moze mu sie pojawic
  933. $_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['TYPE'] = $r->TYPE;
  934. $_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['DESC'] = $r->ZASOB_DESC;
  935. $_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['OPIS'] = $r->ZASOB_OPIS;
  936. }
  937. else {
  938. if ($r->PARENT_TYPE == 'TABELA') {
  939. $CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE[$r->ID_PROCES][] = $r->ID_WSKAZNIK;//ustawiam wskaznik od procesu, jak user wybierze proces do roboty, to ja poznam co moze mu sie pojawic
  940. if (isset($r->FORM_TREAT)) {
  941. if (isset($TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC])) {
  942. $TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] .= $r->FORM_TREAT;
  943. }
  944. else {
  945. $TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] = $r->FORM_TREAT;
  946. }
  947. // echo "<br. . . Dodaje dla:".$r->PARENT_ZASOB_DESC." ".$r->ZASOB_DESC." = ".$r->FORM_TREAT;
  948. }
  949. $TREE_CRM_WSKAZNIK_SORT_PRIO[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] = $r->z__SORT_PRIO;
  950. //@2012-10-10 by SQIX : dodajemy opus kolumny z opisu zasobow
  951. if ($r->ZASOB_OPIS) {
  952. $_SESSION[$r->PARENT_ZASOB_DESC."_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC] = $r->ZASOB_OPIS;
  953. }
  954. else if (isset($_SESSION[$r->PARENT_ZASOB_DESC."_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC])
  955. && strlen($_SESSION[$r->PARENT_ZASOB_DESC."_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC]) > 1
  956. ) {
  957. echo "<BR> DODAJ opis dla zasobu ".$r->ID_ZASOB." w postaci <pre>".$_SESSION[$r->PARENT_ZASOB_DESC."_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC]."</pre>";
  958. }
  959. }
  960. }
  961. }
  962. // ! nizej uruchamiamy permy na podstawie wynikow co umozliwialy procesy
  963. foreach ($TREE_CRM_WSKAZNIK_CONF as $ses_column_name => $field_perms_arr) {
  964. foreach ($field_perms_arr as $k_name => $v_perm) {
  965. $v_perm = str_split($v_perm);
  966. $v_perm = array_unique($v_perm);
  967. $v_perm = implode("", $v_perm);
  968. //if(isset($_SESSION[$ses_column_name."_COLUMN"]['PERMEDIT'][$k_name]))
  969. $_SESSION[$ses_column_name."_COLUMN"]['PERMEDIT'][$k_name] = $v_perm;
  970. //else $_SESSION[$ses_column_name."_COLUMN"]['PERMEDIT'][$k_name] = $v_perm."RWX"; //dokladamy permy do istniejacych!!! @2012-10-21- najlepsze na okres przejsciowy do generowania procesow!
  971. $debug_perms[]="_SESSION['".$ses_column_name."_COLUMN']['PERMEDIT'][".$k_name."]']=".$v_perm;
  972. //jezeli jest w kolumnie ID==W , to znaczy, ze mozna dodawac nowy rekord
  973. if ($k_name == 'ID' && strstr($v_perm, 'W')) {
  974. $_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT']['NEW_RECORD'] = "RWXC";
  975. $_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT']['TABLE_INSERTDB'] = "RWXC";
  976. }
  977. //jezeli jest funkcja powiazana to uprawnienia dostajemy takie same jak z komorki do tej funkcji!
  978. if (isset($_SESSION[$ses_column_name."_COLUMN"]['TYPESPECIAL'][$k_name])) {
  979. $debug_perms[]="_SESSION['".$ses_column_name."_COLUMN']['FUNCPERMEDIT']['".$_SESSION[$ses_column_name."_COLUMN"]['TYPESPECIAL'][$k_name]."']=".$v_perm;
  980. $_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT'][$_SESSION[$ses_column_name."_COLUMN"]['TYPESPECIAL'][$k_name]] = $v_perm;
  981. }
  982. }
  983. {// sort DESC by ZASOB.SORT_PRIO
  984. $desc_to_sort = array();
  985. if (!isset($_SESSION[$ses_column_name."_COLUMN"]['DESC'])) {
  986. //echo "<br><font color=red>L2375 Brak definicji w systemie opisanej procesami tabeli <b>".$ses_column_name."</b></font>";
  987. }
  988. else
  989. foreach ($_SESSION[$ses_column_name."_COLUMN"]['DESC'] as $k_ind => $v_val) {
  990. $desc_to_sort[$v_val] = $k_ind;
  991. }
  992. $TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name];
  993. asort($TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name]);
  994. $new_desc = array();
  995. foreach ($TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name] as $k_name => $v_sort_prio) {
  996. if (!isset($desc_to_sort[$k_name])) {
  997. //echo "<br><font color=red>Brak spojnosci definicji dla kolumny : ".$ses_column_name."[<b>".$k_name."</b>] </font>";
  998. }
  999. else {
  1000. $new_desc[$desc_to_sort[$k_name]] = $k_name;
  1001. }
  1002. }
  1003. // add columns
  1004. foreach ($desc_to_sort as $k_name => $v_ind) {
  1005. $new_desc[$v_ind] = $k_name;
  1006. }
  1007. $_SESSION[$ses_column_name."_COLUMN"]['DESC'] = $new_desc;
  1008. }// sort DESC by ZASOB.SORT_PRIO
  1009. }
  1010. }
  1011. /**
  1012. * URL: _action=setPermsAll
  1013. */
  1014. function setPermsAllAction() {
  1015. $userAcl = User::getAcl();
  1016. $userAcl->fetchAllPerms(true);
  1017. $this->menuAction();
  1018. }
  1019. /**
  1020. * URL: _action=setPermsByProces
  1021. */
  1022. function setPermsByProcesAction() {
  1023. $procesID = V::get('id_proces', 0, $_GET, 'int');
  1024. if ($procesID <= 0) {
  1025. echo '<div class="alert alert-error">' . "Brak ID Procesu" . '</div>';
  1026. return;
  1027. }
  1028. $userAcl = User::getAcl();
  1029. if ($userAcl->getPermsProcesId() == $procesID) {
  1030. $this->menuAction();
  1031. echo '<div class="alert alert-info">' . "Uprawnienia dla ID Procesu {$procesID} już zostały ustawione" . '</div>';
  1032. return;
  1033. }
  1034. $db = DB::getDB();
  1035. $proces = $db->get_by_id('CRM_PROCES', $procesID);
  1036. if ($proces->TYPE != 'PROCES_INIT') {
  1037. $this->menuAction();
  1038. echo '<div class="alert alert-error">' . "Proces nie jest typu PROCES_INIT" . '</div>';
  1039. return;
  1040. }
  1041. $userAcl = User::getAcl();
  1042. $procesStepList = $userAcl->getUsedProcesIds($procesID);
  1043. if (empty($procesStepList)) {
  1044. $this->menuAction();
  1045. echo '<div class="alert alert-error">' . "Nie ma takiego procesu dla usera aby ustawic dla niego filtry" . '</div>';
  1046. return;
  1047. }
  1048. $userAcl->fetchProcesPerms($procesID, true);
  1049. $this->menuAction();
  1050. }
  1051. function show_url_menu() {// TODO: raneme; show all tables and actions by selected proces if in proces perm
  1052. if (isset($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'])) {
  1053. ?>
  1054. <div class="btn-group">
  1055. <a class="btn dropdown-toggle" data-toggle="dropdown" href="#">
  1056. Narzędzia <span class="caret"></span>
  1057. </a>
  1058. <ul class="dropdown-menu">
  1059. <?php foreach ($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'] as $id_zasob => $value_zasob) : ?>
  1060. <?php if ($value_zasob['TYPE'] == 'URL') : ?>
  1061. <li>
  1062. <a href="<?php echo $value_zasob['DESC']; ?>" target="_blank">
  1063. <?php echo '' . $value_zasob['OPIS'] . ' <em>(' . $value_zasob['DESC'] . ')</em>'; ?>
  1064. </a>
  1065. </li>
  1066. <?php endif; ?>
  1067. <?php endforeach; ?>
  1068. </ul>
  1069. </div>
  1070. <?php
  1071. }
  1072. }
  1073. function move_test_from_kandydat_to_pracownik($id_kanydata, $id_pracownika) {
  1074. //4673->4680
  1075. //$sql='update CRM_TESTY set A_RECORD_CREATE_AUTHOR='smagielm' where A_RECORD_CREATE_AUTHOR='Kandydat.4673';
  1076. //$sql='update CRM_TESTY set A_RECORD_UPDATE_AUTHOR='smagielm' where A_RECORD_UPDATE_AUTHOR='Kandydat.4673';
  1077. //$sql="update CRM_TESTY set ID_TESTER='4680' where ID_TESTER='4673'";
  1078. }
  1079. }