'; echo "Jesteś zalogowany jako: ".User::get('ADM_NAME')." (".''.User::getName().''.")"; echo " " . App::link("Ocena pracownika", array('task'=>"USER_OCENA")); echo'

'; // Stanowiska powiazane z userem $stanowiska = User::getGroups(); if (empty($stanowiska)) { echo'

'."Nie jestes przypisany do żadnego stanowiska - pilnie skontaktuj się z przełożonym!".'

'; } else { echo '
'; echo '

'."Stanowisko: "; if (count($stanowiska) > 0) { echo App::link("obowiązki", array('task'=>'CRM_WYSWIETL_OBOWIAZKI', 'z'=>array_keys($stanowiska))); } echo '

'; echo ''; echo '
';// .box-blue } $db = DB::getDB(); Lib::loadClass('ProcesLogDao'); Lib::loadClass('ProcesLogSelectView'); $procesLogDao = new ProcesLogDao($db); $cnt = new ProcesLogSelectView(); $proces_log_list_count = $procesLogDao->get_user_log_list_count(User::getID(), User::getGroupsIds()); $cnt->set('title', "Moje procesy" . (($proces_log_list_count)? " (" . $proces_log_list_count . ")" : '')); $cnt->set('procesLogDao', $procesLogDao); $proces_log_list = $procesLogDao->get_user_log_list(User::getID(), User::getGroupsIds()); $cnt->set('proces_log_list_count', $proces_log_list_count); $cnt->set('proces_log_list', $proces_log_list); DEBUG_S(4, "All process log list", $proces_log_list, __FILE__, __FUNCTION__, __LINE__); echo $cnt->render(); } function task_USERS() { User_procesy5_check_access(); if (!User::logged()) { return; } // login session info: //$_SESSION['ADM_PASSWD']=$ADM_PASSWD; //$_SESSION['AUTHORIZE_USER']="$h->ADM_ACCOUNT"; //$_SESSION['ADM_ACCOUNT']="$h->ADM_ACCOUNT"; //$_SESSION['ADM_AREA']="$h->ADM_AREA"; //$_SESSION['ADM_NAME']="$h->ADM_NAME"; //$_SESSION['ADM_TECH_WORKER']="$h->ADM_TECH_WORKER"; //$_SESSION['ADM_COMPANY']="$h->ADM_COMPANY"; //$_SESSION['ADM_ADMIN_LEVEL']="$h->ADM_ADMIN_LEVEL"; //$_SESSION['ADM_PHONE']="$h->ADM_PHONE"; //$_SESSION['ADM_ADMIN_EXPIRE']="$h->ADM_ADMIN_EXPIRE"; //$_SESSION['ADM_ADMIN_DESC']="$h->ADM_ADMIN_DESC"; Lib::loadClass('UsersHelper'); // TODO: add filters $items = array(); $params = array();// sql params $page_nav = new stdClass(); $page_nav->total = 0; $page_nav->page_total = 0; $page_nav->base_link = "?task=USERS";// TODO: not used! $page_nav->page_limit = 20; $page_nav->page_nr = V::get('_p', 0, $_REQUEST, 'int'); if ($page_nav->page_nr > 0) { $page_nav->base_link .= "&_p=" . $page_nav->page_nr; } $params['p'] = V::get('_p', 0, $_REQUEST, 'int'); $params['group'] = V::get('_group', 0, $_REQUEST, 'int'); if ($params['group'] > 0) { $page_nav->base_link .= "&_group=" . $params['group']; } $page_nav->total = UsersHelper::get_users_total( $params ); $page_nav->last_page_nr = floor($page_nav->total / $page_nav->page_limit); $items = UsersHelper::get_users_list($params, $page_nav->page_limit, $page_nav->page_nr * $page_nav->page_limit, 'ID', 'DESC'); $page_nav->page_total = count($items); UsersHelper::add_groups_to_user_list( $items ); //if ($page_nav->total > 0) { task_USERS_show_items( $params, $page_nav, $items ); //} } function task_USERS_show_items( $params, &$page_nav, &$items ) { User_procesy5_check_access(); $page_nav->links = array(); $base_params = array('task'=>"USERS"); if (!empty($params['group'])) $base_params['_group'] = $params['group']; $page_nav->links []= App::link("|<<", $base_params, array('title'=>"Pierwsza strona")); if ($page_nav->page_nr > 0) { $page_nav->links []= App::link("<<", V::extend($base_params, array('_p'=>($page_nav->page_nr - 1))), array('title'=>"Poprzednia strona (-" . $page_nav->page_limit . ")")); } else { $page_nav->links []= " << "; } $page_nav->links []= ''.($page_nav->page_nr * $page_nav->page_limit).''; $page_nav->links []= 'total." rekordów".'">'."(".$page_nav->total.") ".''; if ($page_nav->last_page_nr > $page_nav->page_nr) { $page_nav->links []= App::link(">>", V::extend($base_params, array('_p'=>($page_nav->page_nr + 1))), array('title'=>"Nastepna strona (+" . $page_nav->page_limit . ")")); } else { $page_nav->links []= " >> "; } $page_nav->links []= App::link(">>|", V::extend($base_params, array('_p'=>$page_nav->last_page_nr)), array('title'=>"Ostatnia strona")); echo'
'; echo implode(" ", $page_nav->links); echo'
'; $tbl_filters_selected = false; if ($params['group'] > 0) { $tbl_filters_selected = true; } echo '
'; echo ''; echo ''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; $cls = ($params['group'] > 0)? ' class="selected"' : ''; echo''; $sel_group_options = array(); $groups = UsersHelper::get_group_list(); foreach ($groups as $k_group_id => $v_group) { $sel_group_options [$v_group->ID] = $v_group->DESC; }//end foreach echo''; echo ''; echo''; echo''; echo''; echo''; if (empty($items)) { echo''; } else { $t = 0; foreach ($items as $k_id => $r) { if(TableAcl::canReadRecord($r)) { //@2014-04-24 TODO jest blad przewijania ekranow, ale musialem zabezpieczyc pokazywanie! z reszta ekran przechodzi na domyslny interfejs soon? echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; echo''; } }//end foreach } echo''; echo'
'." ".''."ID".''."login".''."imie i nazwisko".''."telefon".''."email".''."stanowisko".''."status".''."lokalizacja".'
'; echo ''; echo App::link("x", array('task'=>App::get_task(), '_p'=>$page_nav->page_nr), array('title'=>"Wyczyść filtr", 'ico'=>'del.png')); echo ''."".''."".''."".''."".''."".''."".'
'; echo '' . "Brak danych" . ''; if ($tbl_filters_selected) { echo ' - wyczyść filtry ' . App::link("x", array('task'=>App::get_task(), '_p'=>$page_nav->page_nr), array('title'=>"Wyczyść filtr", 'ico'=>'del.png')); } else if ($page_nav->last_page_nr > 0 && $page_nav->page_nr > 0) { echo ' - wróć do ' . App::link("pierwszej strony", $base_params, array('title'=>"pierwsza strona")); } else echo '
'; if (0 == User::get('ADM_ADMIN_LEVEL')) { echo App::link("E", array('task'=>"USER_EDIT", '_user_id'=>$k_id, '_p'=>$page_nav->page_nr), array('ico'=>'edit.png', 'title'=>"Edit")); echo " "; } echo App::link("Ocena", array('task'=>"USER_OCENA", '_user_id'=>$k_id), array('ico'=>'print', 'title'=>"Ocena pracownika")); echo''; echo $k_id; echo''; echo $r->ADM_ACCOUNT; echo''; echo $r->ADM_NAME; echo''; echo $r->ADM_PHONE; echo''; //echo $r->ADM_EMAIL; $emails = trim($r->EMAIL); if (!empty($emails)) { $emails_arr = array(); $emails_tmp = explode(',', $emails); foreach ($emails_tmp as $v) { $v = trim($v); if (!empty($v)) { //$emails_arr []= '' . $v . ''; $emails_arr []= $v; } }//end foreach if (!empty($emails_arr)) { echo ''; echo reset($emails_arr); if (count($emails_arr) > 1) echo ' ...'; echo ''; } } echo''; if (!empty($r->groups)) { foreach ($r->groups as $k_zasob_id => $v_zasob_desc) { echo ' ' . $k_zasob_id . ''; }//end foreach } else { echo '' . "Brak!" . ''; } echo " (" . $r->ADM_ADMIN_DESC . ")"; echo''; echo $r->A_STATUS; echo''; echo $r->T_TELBOX_NEIGHBOUR_IN_ID_NAME; echo'
'; echo '
'; } function task_USER_EDIT() { User_procesy5_check_access(); if (User::get('ADM_ADMIN_LEVEL') != 0) { echo'

'."Brak dostepu!".'

'; return; } $user_id = V::get('_user_id', 0, $_REQUEST, 'int'); Lib::loadClass('UsersHelper'); $user_data = UsersHelper::get_user_by_id( $user_id ); if (!$user_data) { echo'

'."User nie istnieje.".'

'; return; } $groups = UsersHelper::get_group_list(); $get_localisation_list = UsersHelper::get_localisation_list(); $user_data->groups = UsersHelper::get_group_by_user( $user_data->ID, array('T_TELBOX_NAME'=>1) ); $user_cols = array(); $user_cols['ID'] = "ID"; $user_cols['A_STATUS'] = "status"; $user_cols['ADM_ACCOUNT'] = "login"; $user_cols['ADM_ADMIN_LEVEL'] = "admin level"; $user_cols['ADM_NAME'] = "imie i nazwisko"; $user_cols['ADM_PHONE'] = "numer telefonu"; $user_cols['EMAIL'] = "adres email"; $user_cols['ADM_PESEL'] = "pesel"; $user_cols['ADM_NIP'] = "nip"; $user_cols['ADM_ADMIN_DESC'] = "stanowisko"; $user_types = array(); $user_types['ID'] = ""; $user_types['A_STATUS'] = "enum('WAITING','NORMAL','MONITOR','WARNING','OFF_SOFT','OFF_HARD','DELETED')"; $user_types['ADM_ACCOUNT'] = ""; $user_types['ADM_ADMIN_LEVEL'] = "enum('0', '1', '2', '3', '4', '5', '6')"; $user_types['ADM_NAME'] = "varchar(100)"; $user_types['ADM_PHONE'] = "varchar(100)"; $user_types['EMAIL'] = "varchar(100)"; $user_types['ADM_PESEL'] = "varchar(30)"; $user_types['ADM_NIP'] = "varchar(100)"; $user_types['ADM_ADMIN_DESC'] = "varchar(100)"; $values = array(); foreach (get_object_vars($user_data) as $k_field => $v_value) { $values[$k_field] = V::get($k_field, $v_value, $_POST); }//end foreach if (1 == V::get('save', 0, $_POST, 'int')) { // TODO: use DB::UPDATE_OBJ $sql_arr = array(); $sql_arr_hist = array(); foreach (get_object_vars($user_data) as $k_field => $v_value) { if ($values[$k_field] != $v_value) { $sql_field = $k_field; // if ($k_field == 'EMAIL') $sql_field = "EMAIL"; $sql_arr []= "`".$sql_field."`='".$values[$k_field]."'"; $sql_arr_hist["`".$sql_field."`"] = "'".$values[$k_field]."'"; } }//end foreach if (!empty($sql_arr)) { $sql = "update `ADMIN_USERS` set ".implode(",", $sql_arr)." where `ID`='".$user_data->ID."' limit 1 "; DB::query( $sql ); $affected = DB::affected_rows(); if ($affected) { echo'

'."Zmieniono rekord".'

'; // add HIST data $sql_arr_hist["`ID_USERS2`"] = "'".$user_data->ID."'"; $sql_hist = "insert into `ADMIN_USERS_HIST` (".implode(",", array_keys($sql_arr_hist)).") values(".implode(",", array_values($sql_arr_hist)).");"; DB::query( $sql_hist ); $insert_id = DB::insert_id(); if ($insert_id) { echo'

'."Dodano dane historyczne".'

'; } else { echo'

'."Nie wprowadzono danych HIST".'

'; } } else { echo'

'."Nic nie zmieniono".'

'; } } else { echo'

'."Nie ma nic do zmiany".'

'; } // add stanowiska if ('' != ($add_group = V::get('add_group', '', $_POST))) { $add_localisation = V::get('add_localisation', '', $_POST); $ret_id = UsersHelper::add_group( $user_data->ID, $add_group, $add_localisation ); if ($ret_id <= 0) { echo'

' . "Blad podczas dodawania stanowiska" . '

'; } else { echo'

' . "Dodano stanowisko" . '

'; $user_data->groups[$add_group] = $groups[$add_group]; $user_data->groups[$add_group]->T_TELBOX_NAME = $get_localisation_list[$add_localisation]->T_TELBOX_NAME;// przypisanie do swiezo dodanego rekordu nazwy dodanej lokalizacji } } // remove stanowiska if ('' != ($del_group = V::get('del_group', '', $_POST))) { $ret_code = UsersHelper::remove_group( $user_data->ID, $del_group ); if ($ret_code <= 0) { echo'

' . "Blad podczas usuwania stanowiska ($ret_code)" . '

'; } else { echo'

' . "Usunieto stanowisko" . '

'; unset($user_data->groups[$del_group]); } } } echo'

'; echo App::link("Users", array('task'=>"USERS", '_p'=>V::get('_p', 0, $_GET, 'int'))); echo ' » ' . App::link("Edycja użytkownika [".$user_data->ID."]", array('task'=>'USER_EDIT', '_user_id'=>$user_data->ID)); echo'

'; echo'
'; echo'
'; echo''; foreach ($user_cols as $k_field => $v_label) { echo '' . ": "; if ($user_types[$k_field] == '') { echo $user_data->$k_field; } else { echo App::field($k_field, $user_types[$k_field], $values[$k_field]); } echo'
'; }//end foreach echo'
'; echo ''; if (empty($user_data->groups)) { echo''."Brak przypisanego stanowiska!".'
'; } else { foreach ($user_data->groups as $k_group_id => $v_group) { echo "[" . $v_group->ID . "] " . '' . $v_group->DESC . '' . " [" . $v_group->T_TELBOX_NAME . "] "; $js = "if(confirm('Czy jestes pewien ze chcesz usunac stanowisko: ".$v_group->DESC."?')){ this.form.del_group.value='".$v_group->ID."'; this.form.submit(); } return false;"; echo ' '; echo'
'; }//end foreach } $add_group_options = array(); foreach ($groups as $k_group_id => $v_group) { $add_group_options [$v_group->ID] = $v_group->DESC; }//end foreach $add_get_localisation_list = array(); foreach ($get_localisation_list as $k_group_id => $v_group) { $add_get_localisation_list [$v_group->ID] = $v_group->DESC." ".$v_group->T_TELBOX_NAME; }//end foreach echo''; echo " Dodaj nowe stanowisko: "; echo''; echo " Ustal lokalizacje: "; echo''; echo'
'; echo''; echo'
'; echo'
';// .box-blue } function fun_USER_OCENA_EXPORT() { $_user_id = V::get('_user_id', '', $_GET, 'int'); $user = new stdClass(); $user->ID = User::getID(); $user->ADM_NAME = User::get('ADM_NAME'); Lib::loadClass('UsersHelper'); if ($_user_id > 0) { $user = UsersHelper::get_user_by_id($_user_id); if (!$user) { echo '

' . "Brak użytkownika o ID = " . $_user_id . '

'; return; } } header('Content-Type: text/plain; charset=UTF-8'); // Stanowiska powiazane z userem $stanowiska = UsersHelper::get_group_by_user($user->ID,array('SHOW_IN_PERIOD_MARK'=>'YES')); if (empty($stanowiska)) { echo '

' . "Brak przypisanego stanowiska do pracownika " . $user->ADM_NAME . "" . '

'; return; } Lib::loadClass('ProcesHelper'); $procesy_list = ProcesHelper::get_procesy_by_stanowiska( array_keys($stanowiska) ); // update proces_list data foreach ($procesy_list as $k => $p) { $procesy_list[$k]->stanowisko = ''; if (array_key_exists($p->z__ID, $stanowiska)) { $procesy_list[$k]->stanowisko = $stanowiska[$p->z__ID]->DESC; } } echo "{$user->ADM_NAME};;;;;;;;;" . "data: " . date("Y-m-d") . ";;\n"; echo "id;nazwa;stanowisko;ocena pracownika;;ocena kierownika;;ocena specjalisty ds. jakości;;ocena prezesa;;" . "\n"; echo ";;;%;uwagi;%;uwagi;%;uwagi;%;uwagi;" . "\n"; foreach ($procesy_list as $p) { echo '"' . "{$p->ID}" . '";"' . "{$p->DESC}" . '";"'; echo "{$p->stanowisko}"; if (!empty($p->w__OPIS_ZASOB)) { echo " (" . str_replace(array("\n","\r"), ' ', $p->w__OPIS_ZASOB) . ")"; } echo '";" ";" ";" ";" ";" ";" ";" ";" ";' . "\n"; } exit; } function task_USER_OCENA() { User_procesy5_check_access(); $_print = ('1' == V::get('_print', '', $_GET)); $_user_id = V::get('_user_id', '', $_GET, 'int'); $user = new stdClass(); $user->ID = User::getID(); $user->ADM_NAME = User::get('ADM_NAME'); Lib::loadClass('UsersHelper'); if ($_user_id > 0) { $user = UsersHelper::get_user_by_id($_user_id); if (!$user) { echo '

' . "Brak użytkownika o ID = " . $_user_id . '

'; return; } } // Stanowiska powiazane z userem $stanowiska = UsersHelper::get_group_by_user($user->ID,array('SHOW_IN_PERIOD_MARK'=>'YES')); if (empty($stanowiska)) { echo '

' . "Brak przypisanego stanowiska do pracownika " . $user->ADM_NAME . "" . '

'; return; } Lib::loadClass('ProcesHelper'); $procesy_list = ProcesHelper::get_procesy_by_stanowiska( array_keys($stanowiska) ); // update proces_list data foreach ($procesy_list as $k => $p) { $procesy_list[$k]->stanowisko = ''; if (array_key_exists($p->z__ID, $stanowiska)) { $procesy_list[$k]->stanowisko = $stanowiska[$p->z__ID]->DESC; } } echo '

'; echo $user->ADM_NAME; echo '' . "data: " . date("Y-m-d") . ''; echo '

'; if (!$_print) { echo App::link("Drukuj", array('task'=>'USER_OCENA', '_user_id'=>$user->ID, '_print'=>1, 'HIDE_PANEL'=>1), array('ico_after_text'=>'print', 'target'=>'_blank')); echo ' | '; echo App::link("Export", array('function_init'=>'fun_USER_OCENA_EXPORT', '_user_id'=>$user->ID, 'HIDE_PANEL'=>1), array('ico_after_text'=>'excel.gif', 'target'=>'_blank')); echo ' | '; echo App::link("Ustal kolejność testów", array('task'=>'TEST_SORT'), array('target'=>'_blank')); echo ' | '; echo "ID} target=blank>Widok mapy"; } echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; foreach ($procesy_list as $p) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; } echo ''; echo '
' . "id" . '' . "nazwa" . '' . "stanowisko" . '' . "ocena pracownika" . '' . "ocena kierownika" . '' . "ocena specjalisty ds. jakości" . '' . "ocena prezesa" . '
' . "%" . '' . "uwagi" . '' . "%" . '' . "uwagi" . '' . "%" . '' . "uwagi" . '' . "%" . '' . "uwagi" . '
' . $p->ID . '' . $p->DESC . '' . $p->stanowisko; if (!empty($p->w__OPIS_ZASOB)) { echo '
' . '' . "(" . $p->w__OPIS_ZASOB . ")" . ''; } echo '		' . "" . '' . "" . '' . "" . '' . "" . '' . "" . '' . "" . '' . "" . '' . "" . '
'; }