ProcesMenu.php 50 KB

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