ProcesMenu.php 44 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182
  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. && (pos = window.location.search.search('&filtr_id=')) > 0
  405. ) {
  406. jQuery('#ProcesMenuZasobFltrAdd').on('click', function(e) {
  407. var frm = jQuery(this).get(0).form;
  408. var fldNode = frm['<?php echo $fldParams['formFieldName']; ?>'],
  409. fltrId = '';
  410. if (fldNode && '' != fldNode.value) {
  411. fltrId = fldNode.value;
  412. } else {
  413. return;
  414. }
  415. if ('procesy5.php' === window.location.pathname.substr(-12)) {
  416. var pos = 0, fltrIds = '';
  417. if ((pos = window.location.search.search('&filtr_id=')) > 0) {
  418. pos += 10;
  419. console.log('pos:', pos);
  420. fltrIds = window.location.search.substr(pos);
  421. if ((pos = fltrIds.search('&')) > 0) {
  422. fltrIds = fltrIds.substr(0, pos);
  423. }
  424. if (fltrIds) {
  425. fltrIds = decodeURIComponent(fltrIds);
  426. fltrIds += ',' + fltrId;
  427. if (fldNode.selectize) {
  428. fldNode.selectize.addOption({id: fltrIds, name: fltrIds});
  429. fldNode.selectize.setValue(fltrIds, true);
  430. }
  431. }
  432. }
  433. }
  434. });
  435. } else {
  436. jQuery('#ProcesMenuZasobFltrAdd').hide();
  437. }
  438. jQuery('#ProcesMenuZasobFrm').on('submit', function(e) {
  439. var frm = jQuery(this).get(0),
  440. fldNode = frm['<?php echo $fldParams['formFieldName']; ?>'];
  441. if (fldNode && '' != fldNode.value) {
  442. return true;
  443. } else {
  444. return false;
  445. }
  446. });
  447. jQuery('#ProcesMenuZasobDropdownLink').on('click', function(e) {
  448. setTimeout(function(){
  449. jQuery('#ts-<?php echo $fldName; ?>')
  450. .next('.selectize-control')
  451. .find('input:first')
  452. .focus();
  453. }, 200);
  454. });
  455. });
  456. </script>
  457. </form>
  458. </li>
  459. <?php endif; ?>
  460. </ul>
  461. </li>
  462. <li<?php if ($active == 'obowiazki') echo ' class="active"'; ?>><a href="procesy5.php?task=CRM_WYSWIETL_OBOWIAZKI" title="Wyswietlenie OBOWIAZKOW">Obowiązki</a></li>
  463. <li<?php if ($active == 'testy') echo ' class="active"'; ?>><a href="procesy5.php?task=CRM_TESTY" title="Wyswietlenie testów">Testy</a></li>
  464. <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>
  465. <?php if (User::get('ADM_ADMIN_LEVEL') <= 2) : ?>
  466. <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>
  467. <?php endif; ?>
  468. <li<?php if ($active == 'kontakty') echo ' class="active"'; ?>><a href="index.php?MENU_INIT=VIEWTABLE_KONTAKTY" title="Kontakty">Kontakty</a></li>
  469. <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>
  470. </ul>
  471. <ul class="nav pull-right">
  472. <li<?php if ($active == 'search') echo ' class="active"'; ?>>
  473. <form action="procesy5.php?task=CRM_SEARCH" method="post" class="navbar-search">
  474. <input type="text" name="q" value="" class="q search-query span2">
  475. <input type="image" src="icon/search.png" class="s">
  476. </form>
  477. </li>
  478. <li class="divider-vertical"></li>
  479. <li style="padding:8px 0;"><?php S::show_session_timer(); ?></li>
  480. <li class="divider-vertical"></li>
  481. <li class="dropdown">
  482. <a href="#" class="dropdown-toggle" data-toggle="dropdown"><?php echo User::getName(); ?> <b class="caret"></b></a>
  483. <ul class="dropdown-menu">
  484. <?php if (file_exists('/Library/Server/Web/Data/Sites/Default/')) : ?>
  485. <li><a href="/webcal" target="_blank"><i class="icon-calendar"></i> Kalendarz</a></li>
  486. <?php if (file_exists('/Library/Server/Web/Data/Sites/Default/webmail/loginFromSE.php')) : ?>
  487. <li><a href="/webmail" target="_blank" onclick="jQuery(this).next('form').submit(); return false;"><i class="icon-envelope"></i> Poczta</a>
  488. <form action="https://<?php echo $_SERVER['SERVER_NAME']; ?>/webmail/loginFromSE.php" method="post" style="display:none;">
  489. <input type="hidden" name="_timezone" value="Europe/Berlin">
  490. <input type="hidden" name="_token" value="">
  491. <input type="hidden" name="_action" value="login">
  492. <input type="hidden" name="_task" value="login">
  493. <input type="hidden" name="_url" value="">
  494. <input type="hidden" name="_user" value="<?php echo User::getName(); ?>">
  495. <input type="hidden" name="_pass" value="<?php echo User::get('ADM_PASS_HASH'); ?>">
  496. <input type="hidden" name="EMAIL_IMAP_IMPORT_USERNAME" value="<?php echo V::get('EMAIL_IMAP_IMPORT_USERNAME', '', $_SESSION); ?>">
  497. <input type="hidden" name="EMAIL_IMAP_IMPORT_HOST" value="<?php echo V::get('EMAIL_IMAP_IMPORT_HOST', '', $_SESSION); ?>">
  498. <input type="hidden" name="EMAIL_IMAP_IMPORT_PASSWD_HASH" value="<?php echo V::get('EMAIL_IMAP_IMPORT_PASSWD_HASH', '', $_SESSION); ?>">
  499. <input type="hidden" name="loginFromSE" value="1">
  500. <input type="submit" class="btn" value="P" />
  501. </form>
  502. </li>
  503. <?php elseif (file_exists('/Library/Server/Web/Data/Sites/Default/webmail')) : ?>
  504. <li><a href="/webmail" target="_blank"><i class="icon-envelope"></i> Poczta</a></li>
  505. <?php endif; ?>
  506. <li><a href="https://<?php echo $_SERVER['SERVER_ADDR']; ?>/changepassword" target="_blank">Zmień hasło</a></li>
  507. <li><a href="/profilemanager" target="_blank"><i class="icon-user"></i> Apple Profile Manager</a></li>
  508. <li class="divider"></li>
  509. <?php else: ?>
  510. <li><a href="index.php?LOGIN=PASSEDIT">Zmień hasło</a></li>
  511. <?php endif; ?>
  512. <li><a href="procesy5.php?task=USER" title="<?php echo User::getName(); ?>"><i class="icon-user"></i> Profil</a></li>
  513. <li><a href="index.php?LOGIN=PERMS_RELOAD" title="Przeładuj uprawnienia"><i class="icon-refresh"></i> Przeładuj uprawnienia</a></li>
  514. <?php if (User::isAdmin()) : ?>
  515. <li class="divider"></li>
  516. <li class="nav-header"><nobr>Pokaż testy pracownika:</nobr></li>
  517. <?php if (!$typeSpecialUserId) : ?>
  518. <li>
  519. <div class="alert alert-error">Brak typespecial __USERS_ID</div>
  520. </li>
  521. <?php else : ?>
  522. <li>
  523. <form action="index.php" method="POST">
  524. <input type="hidden" name="FUNCTION_INIT" value="MENU_SELECT_PROCES">
  525. <input type="hidden" name="_action" value="showMyTests">
  526. <?php
  527. $fldName = '_user_id';
  528. $fldParams = array();
  529. $fldParams['allowCreate'] = false;
  530. $fldParams['ajaxDataUrlBase'] = "index.php?FUNCTION_INIT=PROCES_MENU&HEADER_NOT_INIT=YES&_task=TYPESPECIAL&fld={$fldName}";
  531. $fldParams['placeholder'] = 'Szukaj...';
  532. //$fldParams['ajaxDataUrlBase'] .= "&DBG_TS=3";
  533. echo $typeSpecialUserId->showFormItem($tblID = -1, $fldName, $selValue = '', $fldParams);
  534. ?>
  535. <input class="btn btn-mini btn-warning" type="submit" value="Wybierz" />
  536. </form>
  537. </li>
  538. <?php endif; ?>
  539. <?php endif; ?>
  540. <li class="divider"></li>
  541. <li><a href="index.php?LOGIN=LOGOUT"><i class="icon-off"></i> Wyloguj</a></li>
  542. </ul>
  543. </li>
  544. </ul>
  545. </div><!-- /.nav-collapse -->
  546. </div>
  547. </div><!-- /navbar-inner -->
  548. <?php if ($userAcl->getPermsProcesId()) : ?>
  549. <div id="SE-menu-sub">
  550. <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>
  551. <?php foreach ($outBtnsMenus as $kZasobID => $vName) : ?>
  552. <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>
  553. <?php endforeach; ?>
  554. <?php foreach ($outUrls as $kZasobID => $vTitle) : ?>
  555. <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>
  556. <?php endforeach; ?>
  557. </div>
  558. <?php else : ?>
  559. <div id="SE-menu-sub"></div>
  560. <script>
  561. (function ($, undefined) {
  562. var UserBookmarks = function() {
  563. var priv = {}; //private api
  564. var publ = {}; //public api
  565. priv.options = {};
  566. var defaults = {
  567. url: '', //webservice url
  568. urlInit: true, // try to load services on init
  569. preloadData: null,
  570. menuid: '',
  571. debug: false
  572. };
  573. var _cont; // container holding table
  574. var _menu; // container holding stars
  575. var _stateEdit = false;
  576. /*
  577. initialize the plugin.
  578. */
  579. priv.init = function() {
  580. _cont = $(priv.options.id);
  581. _menu = $(priv.options.menuid);
  582. _menu.find('.bookmark-item-add').click(function(e){
  583. e.preventDefault();
  584. e.stopPropagation();
  585. var zasobid = jQuery(this).data('zasobid');
  586. priv.update('add_bookmark', zasobid);
  587. var item = $('#bookmark-item-' + zasobid);
  588. if (item) {
  589. item.addClass('has_bookmark');
  590. }
  591. });
  592. _menu.find('.bookmark-item-rem').click(function(e){
  593. e.preventDefault();
  594. e.stopPropagation();
  595. var zasobid = jQuery(this).data('zasobid');
  596. priv.update('remove_bookmark', zasobid);
  597. });
  598. if (priv.options.urlInit) priv.update();
  599. if (priv.options.preloadData) priv.setData(priv.options.preloadData);
  600. };
  601. priv.setData = function(data) {
  602. _cont.empty();
  603. $.each(data, function(ind, item){
  604. if ('type' in item) {
  605. var l = $('<a></a>');
  606. l.data('id', item.id);
  607. l.addClass('btn');
  608. l.addClass('btn-mini');
  609. var label = item.name, title = '';
  610. if ('class' in item) {
  611. l.addClass(item.class);
  612. }
  613. if (item.type == 'menu') {
  614. l.attr('href', 'index.php?MENU_INIT=VIEWTABLE_AJAX&ZASOB_ID=' + item.id);
  615. if ('label' in item && item.label.length > 0) {
  616. label = item.label;
  617. title = item.label + ' (' + item.name + ')';
  618. }
  619. else if ('opis' in item && item.opis.length > 0) {
  620. label = item.opis;
  621. title = item.opis + ' (' + item.name + ')';
  622. }
  623. } else if (item.type == 'url') {
  624. l.attr('href', 'index.php?FUNCTION_INIT=URL_INIT&ZASOB_ID=' + item.id);
  625. l.attr('target', '_blank');
  626. }
  627. if (label.length > 20) {
  628. var pos = label.indexOf(' - ');
  629. if (pos > 20 || pos < 5) {
  630. pos = 20;
  631. l.text(label.substring(0, pos) + ' ...');
  632. } else {
  633. l.text(label.substring(0, pos));
  634. }
  635. } else {
  636. l.text(label);
  637. }
  638. if (title == '') title = label;
  639. l.attr('title', title);
  640. l.appendTo(_cont);
  641. if (_stateEdit) {
  642. priv.addEditBtns(l);
  643. }
  644. }
  645. // stars visibility
  646. $('.bookmark-item-rem-' + item.id).show();
  647. $('.bookmark-item-add-' + item.id).hide();
  648. });
  649. if (data.length > 0) {
  650. var editBtn = $('<button class="btn btn-mini btn-inverse" style="float:right" title="Edit Bookmarks"><i class="icon-cog icon-white"></i></button>')
  651. editBtn.on('click', priv.edit);
  652. editBtn.prependTo(_cont);
  653. }
  654. };
  655. priv.update = function(task, zasobID, argsAdd) {
  656. task = task || '';
  657. zasobID = zasobID || '';
  658. argsAdd = argsAdd || '';
  659. $.ajax({
  660. url: priv.options.url + '&_task=' + task + '&_zasobID=' + zasobID + argsAdd,
  661. type: 'GET',
  662. dataType: 'json',
  663. contentType: "application/json; charset=utf-8",
  664. data: null,
  665. async: true,
  666. success: function (data) {
  667. $('.bookmark-item-rem').hide();
  668. $('.bookmark-item-add').show();
  669. priv.setData(data);
  670. },
  671. error: function (err) {
  672. console.log('Error');
  673. console.log(err);
  674. }
  675. });
  676. };
  677. priv.changed = function(e) {
  678. if (priv.options.debug) console.log(e.data);
  679. if (priv.options.debug) console.log('id(' + e.data.id + ') cls(' + e.data.cls + ')');
  680. priv.update('change_bookmark', e.data.id, '&btnCls=' + e.data.cls);
  681. return false;
  682. };
  683. priv.removed = function(e) {
  684. if (priv.options.debug) console.log(e.data);
  685. if (priv.options.debug) console.log('id(' + e.data.id + ')');
  686. priv.update('remove_bookmark', e.data.id);
  687. return false;
  688. };
  689. priv.addEditBtns = function(el) {
  690. var next, btn;
  691. el.wrap('<div></div>');
  692. next = $('<span><em> Change color:</em> </span>');
  693. $.each(['btn-default', 'btn-primary', 'btn-info', 'btn-success', 'btn-warning', 'btn-danger'], function(btnInd, btnClass){
  694. btn = $('<button class="btn btn-mini ' + btnClass + '"> &nbsp; </button>');
  695. btn.on('click', {id: el.data('id'), cls: btnClass}, priv.changed);
  696. btn.appendTo(next);
  697. });
  698. btn = $('<button class="btn btn-mini"> remove </button>');
  699. btn.on('click', {id: el.data('id')}, priv.removed);
  700. btn.appendTo(next);
  701. next.insertAfter(el);
  702. };
  703. priv.edit = function(e) {
  704. _stateEdit = !_stateEdit;
  705. var el;
  706. _cont.find('a').each(function(ind, n){
  707. if (priv.options.debug) console.log(n);
  708. el = $(n);
  709. if (_stateEdit) {
  710. priv.addEditBtns(el);
  711. } else {
  712. el.next().remove();
  713. el.unwrap();
  714. }
  715. });
  716. }
  717. publ.init = function(options) {
  718. if (priv.options.debug) console.log('UserBookmarks initialization...');
  719. //merge supplied options with defaults
  720. $.extend(priv.options, defaults, options);
  721. priv.init();
  722. return publ;
  723. };
  724. return publ;
  725. };
  726. $.fn.UserBookmarks = function(options) {
  727. options = options || {};
  728. return this.each(function() {
  729. options.id = this;
  730. $(this).data('UserBookmarks', new UserBookmarks().init(options));
  731. });
  732. };
  733. })(jQuery);
  734. </script>
  735. <script>
  736. jQuery(document).ready(function(){
  737. jQuery('#SE-menu-sub').UserBookmarks({
  738. url: 'index-ajax.php?_cls=UserBookmarks',
  739. urlInit: false,
  740. preloadData: <?php echo json_encode($bookmarksJson); ?>,
  741. menuid: '#SE-menu',
  742. debug: false
  743. });
  744. });
  745. </script>
  746. <?php endif; ?>
  747. </div>
  748. <?php
  749. }
  750. /**
  751. * Generates wyniki
  752. */
  753. function _generate_wyniki_testow() {
  754. $this->_wynik_testu = array();// WYNIK_TESTU_PROCESU
  755. $this->_wynik_testu_unactual = array();
  756. $this_CRM_PROCES_USERA_WYKONANE_TESTY = $this->get_wykonane_testy();
  757. foreach ($this_CRM_PROCES_USERA_WYKONANE_TESTY as $v_test) {
  758. if (isset($this->_wynik_testu[$v_test->ID_PROCES_INIT][$v_test->TEST_TYPE])) {
  759. continue;// only first
  760. }
  761. $this->_wynik_testu[$v_test->ID_PROCES_INIT][$v_test->TEST_TYPE] = $v_test->OCENA;
  762. if (!empty($v_test->unactual)) {
  763. $x_test = new stdClass();
  764. $x_test->TEST_END = substr($v_test->TEST_END, 0, 10);
  765. $x_test->unactual = substr($v_test->unactual, 0, 10);
  766. $x_test->unactualId = $v_test->unactualId;
  767. $this->_wynik_testu_unactual[$v_test->ID_PROCES_INIT][$v_test->TEST_TYPE] = $x_test;
  768. }
  769. }
  770. }
  771. function get_ocena_testu($proces_id, $typ) {
  772. $ocena = $this->get_ocena_testu_value($proces_id, $typ);
  773. if (!$ocena) {
  774. return 'BRAK_TESTU';
  775. }
  776. else if ($ocena == -1) {
  777. return 'BRAK_PYTAN';
  778. }
  779. else if ($ocena == 3) {
  780. return 'IDEALNY';
  781. }
  782. else if ($ocena < 2) {
  783. return 'NIEDOSTATECZNY';
  784. }
  785. else if($ocena < 2.5) {
  786. return 'DOSTATECZNY';
  787. }
  788. else {
  789. return 'DOBRY';
  790. }
  791. }
  792. function get_ocena_testu_value($proces_id, $typ) {
  793. if (isset($this->_wynik_testu[$proces_id][$typ])) {
  794. return $this->_wynik_testu[$proces_id][$typ];
  795. }
  796. return null;
  797. }
  798. function isTestUnactual($proces_id, $typ) {
  799. if (isset($this->_wynik_testu_unactual[$proces_id][$typ])) {
  800. return $this->_wynik_testu_unactual[$proces_id][$typ];
  801. }
  802. return false;
  803. }
  804. function get_actual_tests_count($type = null) {
  805. $this_CRM_PROCES_USERA_WYKONANE_TESTY = $this->get_wykonane_testy();
  806. if ($type == 'TEORETYCZNY') {
  807. $testy_teoretyczne = 0;
  808. foreach ($this_CRM_PROCES_USERA_WYKONANE_TESTY as $int => $v_test) {
  809. if ($v_test->TEST_TYPE=='TEORETYCZNY') {
  810. if ($v_test->OCENA > 2.5) $testy_teoretyczne++;
  811. }
  812. }
  813. return $testy_teoretyczne;
  814. }
  815. else if ($type == 'PRAKTYCZNY') {
  816. $testy_praktyczne = 0;
  817. foreach ($this_CRM_PROCES_USERA_WYKONANE_TESTY as $int => $v_test) {
  818. if ($v_test->TEST_TYPE=='PRAKTYCZNY') {
  819. if ($v_test->OCENA > 2.5) $testy_praktyczne++;
  820. }
  821. }
  822. return $testy_praktyczne;
  823. }
  824. else if ($type == null) {
  825. return count($this_CRM_PROCES_USERA_WYKONANE_TESTY);
  826. }
  827. return 0;
  828. }
  829. function wylacz_filtr_uprawnien_dla_procesu() {// TODO: RMME => _action=setPermsAll
  830. unset($this->MENU_SELECT_PROCES_DATA['uruchom_filtr_uprawnien_dla_procesu']);// usun tryb jednego procesu
  831. $this->set_current_menu_data();// zapisz do sesji
  832. $this->set_perms_for_process();// domyslnie pusty włącza
  833. }
  834. function uruchom_filtr_uprawnien_dla_procesu() {// TODO: RMME => _action=setPermsByProces
  835. $proces_to_filter = V::get('ID_PROCES', '', $_REQUEST);
  836. $map = $this->_acl->getUsedProcesMap();
  837. if (!in_array($proces_to_filter, $map)) {// TODO: chyba array_key_exists ?
  838. $this->setError(" Nie ma takiego procesu dla usera aby ustawic dla niego filtry");
  839. }
  840. $this->ifError();// ? // TODO: RMME
  841. //szukam tabeli do ustalenia permow
  842. $this->unset_all_perms();
  843. $this->MENU_SELECT_PROCES_DATA['uruchom_filtr_uprawnien_dla_procesu'] = $proces_to_filter;
  844. $this->set_current_menu_data();
  845. $this->set_perms_for_process($proces_to_filter);
  846. $this->set_current_menu_data();
  847. //$this->set_current_menu('show_menu_with_process');
  848. //$this->show_menu_with_process();
  849. }
  850. function unset_all_perms() {
  851. $dbg_czysc_permy = true;// @from USERS_FIELDS_PROFILE_INIT()
  852. foreach ($_SESSION as $ses_col_name => $col_vars) {
  853. if (!is_array($col_vars) || empty($col_vars)) continue;
  854. if ('_COLUMN' != substr($ses_col_name, -1 * strlen('_COLUMN'))) {
  855. continue;
  856. }
  857. if (empty($col_vars['PERMEDIT'])) continue;
  858. if ($dbg_czysc_permy) {
  859. foreach ($col_vars['PERMEDIT'] as $col_perm_ind => $col_perm_value) {
  860. if ($col_perm_ind != 'ID') {
  861. $_SESSION[$ses_col_name]['PERMEDIT'][$col_perm_ind] = "";
  862. }
  863. }
  864. }
  865. }
  866. if (isset($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'])) {
  867. foreach ($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'] as $zasob => $val) {
  868. unset($this->MENU_SELECT_PROCES_DATA['MENU_COLUMN'][$zasob]);
  869. unset($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$zasob]);
  870. }
  871. }
  872. }
  873. function set_perms_for_process($proces_to_filter = null) {// => setPermsByProcesAction
  874. if ($proces_to_filter) {
  875. $map = $this->_acl->getUsedProcesMap();
  876. if (array_key_exists($proces_to_filter, $map)) {
  877. $CRM_PROCES_USERA_UZYTY = $map[$proces_to_filter];
  878. } else {
  879. $CRM_PROCES_USERA_UZYTY = array();
  880. }
  881. }
  882. else {
  883. $CRM_PROCES_USERA_UZYTY = $this->_acl->getUsedProcesIds();
  884. }
  885. if (!empty($CRM_PROCES_USERA_UZYTY)) {
  886. return;
  887. }
  888. // ! @2013-02-11 zerzniete z USERS_FIELDS_PROFILE_INIT !
  889. $CRM_WSKAZNIK_PROCES_WSKAZNIK_TREE = array();
  890. $CRM_TREE_WSKAZNIK_NARZEDZIE = array();
  891. $TREE_CRM_WSKAZNIK_CONF = array();
  892. $TREE_CRM_WSKAZNIK_SORT_PRIO = array();
  893. $db = DB::getDB();
  894. //kopiuje tabele ze wskaznikow
  895. $sql = "select t1.`ID_PROCES`
  896. , t1.`ID_ZASOB`
  897. , replace(t2.`FORM_TREAT`, ',', '') as FORM_TREAT
  898. , t3.`DESC` as ZASOB_DESC
  899. , t3.`TYPE`
  900. , t4.`DESC` as PARENT_ZASOB_DESC
  901. , t4.`TYPE` as PARENT_TYPE
  902. , t3.`SORT_PRIO` as z__SORT_PRIO
  903. , t3.`OPIS` as ZASOB_OPIS , t1.`ID` as ID_WSKAZNIK
  904. from `CRM_WSKAZNIK` as t1
  905. left join `CRM_PRZYPADEK` as t2 on (t1.ID_PRZYPADEK=t2.ID)
  906. left join `CRM_LISTA_ZASOBOW` as t3 on (t3.ID=t1.ID_ZASOB)
  907. left join `CRM_LISTA_ZASOBOW` as t4 on (t4.ID=t3.PARENT_ID)
  908. where
  909. (
  910. ( t3.`TYPE`='KOMORKA' and t4.`TYPE`='TABELA' )
  911. or (t3.`TYPE`='NARZEDZIE') or (t3.`TYPE`='URL')
  912. )
  913. and t1.`A_STATUS` in('NORMAL', 'WAITING')
  914. and t1.`ID_PROCES` in(" . implode(",", $CRM_PROCES_USERA_UZYTY) . ")
  915. ";
  916. $res = $db->query($sql);
  917. if (!$res) {
  918. return;
  919. }
  920. while ($r = $db->fetch($res)) {
  921. if ($r->TYPE == 'NARZEDZIE') {
  922. if (isset($CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB])) {
  923. $CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB] .= $r->FORM_TREAT;
  924. }
  925. else {
  926. $CRM_TREE_WSKAZNIK_NARZEDZIE[$r->ID_ZASOB] = $r->FORM_TREAT;
  927. }
  928. $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
  929. }
  930. else if ($r->TYPE == 'URL') {
  931. $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
  932. $_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['TYPE'] = $r->TYPE;
  933. $_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['DESC'] = $r->ZASOB_DESC;
  934. $_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'][$r->ID_ZASOB]['OPIS'] = $r->ZASOB_OPIS;
  935. }
  936. else {
  937. if ($r->PARENT_TYPE == 'TABELA') {
  938. $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
  939. if (isset($r->FORM_TREAT)) {
  940. if (isset($TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC])) {
  941. $TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] .= $r->FORM_TREAT;
  942. }
  943. else {
  944. $TREE_CRM_WSKAZNIK_CONF[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] = $r->FORM_TREAT;
  945. }
  946. // echo "<br. . . Dodaje dla:".$r->PARENT_ZASOB_DESC." ".$r->ZASOB_DESC." = ".$r->FORM_TREAT;
  947. }
  948. $TREE_CRM_WSKAZNIK_SORT_PRIO[$r->PARENT_ZASOB_DESC][$r->ZASOB_DESC] = $r->z__SORT_PRIO;
  949. //@2012-10-10 by SQIX : dodajemy opus kolumny z opisu zasobow
  950. if ($r->ZASOB_OPIS) {
  951. $_SESSION[$r->PARENT_ZASOB_DESC."_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC] = $r->ZASOB_OPIS;
  952. }
  953. else if (isset($_SESSION[$r->PARENT_ZASOB_DESC."_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC])
  954. && strlen($_SESSION[$r->PARENT_ZASOB_DESC."_COLUMN"]['DESC_TO_LANG'][$r->ZASOB_DESC]) > 1
  955. ) {
  956. 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>";
  957. }
  958. }
  959. }
  960. }
  961. // ! nizej uruchamiamy permy na podstawie wynikow co umozliwialy procesy
  962. foreach ($TREE_CRM_WSKAZNIK_CONF as $ses_column_name => $field_perms_arr) {
  963. foreach ($field_perms_arr as $k_name => $v_perm) {
  964. $v_perm = str_split($v_perm);
  965. $v_perm = array_unique($v_perm);
  966. $v_perm = implode("", $v_perm);
  967. //if(isset($_SESSION[$ses_column_name."_COLUMN"]['PERMEDIT'][$k_name]))
  968. $_SESSION[$ses_column_name."_COLUMN"]['PERMEDIT'][$k_name] = $v_perm;
  969. //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!
  970. $debug_perms[]="_SESSION['".$ses_column_name."_COLUMN']['PERMEDIT'][".$k_name."]']=".$v_perm;
  971. //jezeli jest w kolumnie ID==W , to znaczy, ze mozna dodawac nowy rekord
  972. if ($k_name == 'ID' && strstr($v_perm, 'W')) {
  973. $_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT']['NEW_RECORD'] = "RWXC";
  974. $_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT']['TABLE_INSERTDB'] = "RWXC";
  975. }
  976. //jezeli jest funkcja powiazana to uprawnienia dostajemy takie same jak z komorki do tej funkcji!
  977. if (isset($_SESSION[$ses_column_name."_COLUMN"]['TYPESPECIAL'][$k_name])) {
  978. $debug_perms[]="_SESSION['".$ses_column_name."_COLUMN']['FUNCPERMEDIT']['".$_SESSION[$ses_column_name."_COLUMN"]['TYPESPECIAL'][$k_name]."']=".$v_perm;
  979. $_SESSION[$ses_column_name."_COLUMN"]['FUNCPERMEDIT'][$_SESSION[$ses_column_name."_COLUMN"]['TYPESPECIAL'][$k_name]] = $v_perm;
  980. }
  981. }
  982. {// sort DESC by ZASOB.SORT_PRIO
  983. $desc_to_sort = array();
  984. if (!isset($_SESSION[$ses_column_name."_COLUMN"]['DESC'])) {
  985. //echo "<br><font color=red>L2375 Brak definicji w systemie opisanej procesami tabeli <b>".$ses_column_name."</b></font>";
  986. }
  987. else
  988. foreach ($_SESSION[$ses_column_name."_COLUMN"]['DESC'] as $k_ind => $v_val) {
  989. $desc_to_sort[$v_val] = $k_ind;
  990. }
  991. $TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name];
  992. asort($TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name]);
  993. $new_desc = array();
  994. foreach ($TREE_CRM_WSKAZNIK_SORT_PRIO[$ses_column_name] as $k_name => $v_sort_prio) {
  995. if (!isset($desc_to_sort[$k_name])) {
  996. //echo "<br><font color=red>Brak spojnosci definicji dla kolumny : ".$ses_column_name."[<b>".$k_name."</b>] </font>";
  997. }
  998. else {
  999. $new_desc[$desc_to_sort[$k_name]] = $k_name;
  1000. }
  1001. }
  1002. // add columns
  1003. foreach ($desc_to_sort as $k_name => $v_ind) {
  1004. $new_desc[$v_ind] = $k_name;
  1005. }
  1006. $_SESSION[$ses_column_name."_COLUMN"]['DESC'] = $new_desc;
  1007. }// sort DESC by ZASOB.SORT_PRIO
  1008. }
  1009. }
  1010. /**
  1011. * URL: _action=setPermsAll
  1012. */
  1013. function setPermsAllAction() {
  1014. $userAcl = User::getAcl();
  1015. $userAcl->fetchAllPerms(true);
  1016. $this->menuAction();
  1017. }
  1018. /**
  1019. * URL: _action=setPermsByProces
  1020. */
  1021. function setPermsByProcesAction() {
  1022. $procesID = V::get('id_proces', 0, $_GET, 'int');
  1023. if ($procesID <= 0) {
  1024. echo '<div class="alert alert-error">' . "Brak ID Procesu" . '</div>';
  1025. return;
  1026. }
  1027. $userAcl = User::getAcl();
  1028. if ($userAcl->getPermsProcesId() == $procesID) {
  1029. $this->menuAction();
  1030. echo '<div class="alert alert-info">' . "Uprawnienia dla ID Procesu {$procesID} już zostały ustawione" . '</div>';
  1031. return;
  1032. }
  1033. $db = DB::getDB();
  1034. $proces = $db->get_by_id('CRM_PROCES', $procesID);
  1035. if ($proces->TYPE != 'PROCES_INIT') {
  1036. $this->menuAction();
  1037. echo '<div class="alert alert-error">' . "Proces nie jest typu PROCES_INIT" . '</div>';
  1038. return;
  1039. }
  1040. $userAcl = User::getAcl();
  1041. $procesStepList = $userAcl->getUsedProcesIds($procesID);
  1042. if (empty($procesStepList)) {
  1043. $this->menuAction();
  1044. echo '<div class="alert alert-error">' . "Nie ma takiego procesu dla usera aby ustawic dla niego filtry" . '</div>';
  1045. return;
  1046. }
  1047. $userAcl->fetchProcesPerms($procesID, true);
  1048. $this->menuAction();
  1049. }
  1050. function show_url_menu() {// TODO: raneme; show all tables and actions by selected proces if in proces perm
  1051. if (isset($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'])) {
  1052. ?>
  1053. <div class="btn-group">
  1054. <a class="btn dropdown-toggle" data-toggle="dropdown" href="#">
  1055. Narzędzia <span class="caret"></span>
  1056. </a>
  1057. <ul class="dropdown-menu">
  1058. <?php foreach ($_SESSION['MENU_SELECT_PROCES_DATA']['MENU_COLUMN'] as $id_zasob => $value_zasob) : ?>
  1059. <?php if ($value_zasob['TYPE'] == 'URL') : ?>
  1060. <li>
  1061. <a href="<?php echo $value_zasob['DESC']; ?>" target="_blank">
  1062. <?php echo '' . $value_zasob['OPIS'] . ' <em>(' . $value_zasob['DESC'] . ')</em>'; ?>
  1063. </a>
  1064. </li>
  1065. <?php endif; ?>
  1066. <?php endforeach; ?>
  1067. </ul>
  1068. </div>
  1069. <?php
  1070. }
  1071. }
  1072. function move_test_from_kandydat_to_pracownik($id_kanydata, $id_pracownika) {
  1073. //4673->4680
  1074. //$sql='update CRM_TESTY set A_RECORD_CREATE_AUTHOR='smagielm' where A_RECORD_CREATE_AUTHOR='Kandydat.4673';
  1075. //$sql='update CRM_TESTY set A_RECORD_UPDATE_AUTHOR='smagielm' where A_RECORD_UPDATE_AUTHOR='Kandydat.4673';
  1076. //$sql="update CRM_TESTY set ID_TESTER='4680' where ID_TESTER='4673'";
  1077. }
  1078. }