Passed
Pull Request — master (#4377)
by Evertton
04:52
created
api/Model/Operation.php 2 patches
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -38,7 +38,7 @@
 block discarded – undo
38 38
                 "error" => '',
39 39
             );
40 40
     
41
-        }catch (Exception $e) {    
41
+        } catch (Exception $e) {    
42 42
             return false;
43 43
         }
44 44
     }
Please login to merge, or discard this patch.
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -40,7 +40,7 @@
 block discarded – undo
40 40
                 "error" => '',
41 41
             );
42 42
     
43
-        }catch (Exception $e) {    
43
+        } catch (Exception $e) {    
44 44
             return false;
45 45
         }
46 46
     }
Please login to merge, or discard this patch.
api/Model/FolderModel.php 2 patches
Indentation   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -34,7 +34,7 @@  discard block
 block discarded – undo
34 34
         $ret = [];
35 35
 
36 36
         foreach ($rows as $row) {
37
-			$isVisible = in_array((int) $row['id'], $foldersId);
37
+            $isVisible = in_array((int) $row['id'], $foldersId);
38 38
             $childrens = $this->getFoldersChildren($row['id'], $foldersId);
39 39
 
40 40
             if ($isVisible || count($childrens) > 0) {
@@ -43,7 +43,7 @@  discard block
 block discarded – undo
43 43
                     [
44 44
                         'id' => (int) $row['id'],
45 45
                         'title' => $row['title'],
46
-						'isVisible' => $isVisible,
46
+                        'isVisible' => $isVisible,
47 47
                         'childrens' => $childrens
48 48
                     ]
49 49
                 );
@@ -63,7 +63,7 @@  discard block
 block discarded – undo
63 63
 
64 64
         if ( count($childrens) > 0) {
65 65
             foreach ($childrens as $children) {
66
-				$isVisible = in_array((int) $children['id'], $foldersId);
66
+                $isVisible = in_array((int) $children['id'], $foldersId);
67 67
                 $childs = $this->getFoldersChildren($children['id'], $foldersId);
68 68
 
69 69
                 if (in_array((int) $children['id'], $foldersId) || count($childs) > 0) {
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
                         [
73 73
                             'id' => (int) $children['id'],
74 74
                             'title' => $children['title'],
75
-							'isVisible' => $isVisible,
75
+                            'isVisible' => $isVisible,
76 76
                             'childrens' => $childs
77 77
                         ]
78 78
                     );
Please login to merge, or discard this patch.
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -37,7 +37,7 @@  discard block
 block discarded – undo
37 37
         // Get folders
38 38
         $rows = DB::query(
39 39
             'SELECT id, title
40
-            FROM ' . prefixTable('nested_tree') . '
40
+            FROM ' . prefixTable('nested_tree').'
41 41
             WHERE nlevel = %i',
42 42
             1
43 43
         );
@@ -69,12 +69,12 @@  discard block
 block discarded – undo
69 69
         $ret = [];
70 70
         $childrens = DB::query(
71 71
             'SELECT id, title
72
-            FROM ' . prefixTable('nested_tree') . '
72
+            FROM ' . prefixTable('nested_tree').'
73 73
             WHERE parent_id = %i',
74 74
             $parentId
75 75
         );
76 76
 
77
-        if ( count($childrens) > 0) {
77
+        if (count($childrens) > 0) {
78 78
             foreach ($childrens as $children) {
79 79
 				$isVisible = in_array((int) $children['id'], $foldersId);
80 80
                 $childs = $this->getFoldersChildren($children['id'], $foldersId);
@@ -116,7 +116,7 @@  discard block
 block discarded – undo
116 116
     ): array
117 117
     {
118 118
         // Validate inputs
119
-        include_once API_ROOT_PATH . '/../sources/main.functions.php';
119
+        include_once API_ROOT_PATH.'/../sources/main.functions.php';
120 120
         $data = [
121 121
             'title' => $title,
122 122
             'parent_id' => $parent_id,
@@ -181,7 +181,7 @@  discard block
 block discarded – undo
181 181
                 'error' => true,
182 182
                 'error_header' => 'HTTP/1.1 422 Unprocessable Entity',
183 183
                 'error_message' => 'Invalid parameters'
184
-            ];}
184
+            ]; }
185 185
 
186 186
         // Create folder
187 187
         require_once TEAMPASS_ROOT_PATH.'/sources/folders.class.php';
Please login to merge, or discard this patch.
api/Controller/Api/ItemController.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -52,7 +52,7 @@  discard block
 block discarded – undo
52 52
             // SQL where clause with folders list
53 53
             if (isset($arrQueryStringParams['folders']) === true) {
54 54
                 // convert the folders to an array
55
-                $arrQueryStringParams['folders'] = explode(',', str_replace( array('[',']') , ''  , $arrQueryStringParams['folders']));
55
+                $arrQueryStringParams['folders'] = explode(',', str_replace(array('[', ']'), '', $arrQueryStringParams['folders']));
56 56
 
57 57
                 // ensure to only use the intersection
58 58
                 $foldersList = implode(',', array_intersect($arrQueryStringParams['folders'], $userData['folders_list']));
@@ -126,10 +126,10 @@  discard block
 block discarded – undo
126 126
             // SQL where clause with item id
127 127
             if (isset($arrQueryStringParams['id']) === true) {
128 128
                 // build sql where clause by ID
129
-                $sqlExtra = ' WHERE i.id = '.$arrQueryStringParams['id'] . $sql_constraint;
129
+                $sqlExtra = ' WHERE i.id = '.$arrQueryStringParams['id'].$sql_constraint;
130 130
             } else if (isset($arrQueryStringParams['label']) === true) {
131 131
                 // build sql where clause by LABEL
132
-                $sqlExtra = ' WHERE i.label '.(isset($arrQueryStringParams['like']) === true && (int) $arrQueryStringParams['like'] === 1 ? ' LIKE '.$arrQueryStringParams['label'] : ' = '.$arrQueryStringParams['label']) . $sql_constraint;
132
+                $sqlExtra = ' WHERE i.label '.(isset($arrQueryStringParams['like']) === true && (int) $arrQueryStringParams['like'] === 1 ? ' LIKE '.$arrQueryStringParams['label'] : ' = '.$arrQueryStringParams['label']).$sql_constraint;
133 133
             } else if (isset($arrQueryStringParams['description']) === true) {
134 134
                 // build sql where clause by LABEL
135 135
                 $sqlExtra = ' WHERE i.description '.(isset($arrQueryStringParams['like']) === true && (int) $arrQueryStringParams['like'] === 1 ? ' LIKE '.$arrQueryStringParams['description'] : ' = '.$arrQueryStringParams['description']).$sql_constraint;
Please login to merge, or discard this patch.
sources/users.queries.php 2 patches
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -2603,7 +2603,9 @@
 block discarded – undo
2603 2603
             }
2604 2604
             
2605 2605
             foreach ($results as $adUser) {
2606
-                if (isset($adUser[$SETTINGS['ldap_user_attribute']][0]) === false) continue;
2606
+                if (isset($adUser[$SETTINGS['ldap_user_attribute']][0]) === false) {
2607
+                    continue;
2608
+                }
2607 2609
                 // Build the list of all groups in AD
2608 2610
                 if (isset($adUser['memberof']) === true) {
2609 2611
                     foreach($adUser['memberof'] as $j => $adUserGroup) {
Please login to merge, or discard this patch.
Spacing   +116 added lines, -116 removed lines patch added patch discarded remove patch
@@ -73,7 +73,7 @@  discard block
 block discarded – undo
73 73
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('profile') === false) {
74 74
     // Not allowed page
75 75
     $session->set('system-error_code', ERR_NOT_ALLOWED);
76
-    include $SETTINGS['cpassman_dir'] . '/error.php';
76
+    include $SETTINGS['cpassman_dir'].'/error.php';
77 77
     exit;
78 78
 }
79 79
 
@@ -175,7 +175,7 @@  discard block
 block discarded – undo
175 175
             // Check if user already exists
176 176
             $data = DB::query(
177 177
                 'SELECT id, fonction_id, groupes_interdits, groupes_visibles
178
-                FROM ' . prefixTable('users') . '
178
+                FROM ' . prefixTable('users').'
179 179
                 WHERE login = %s
180 180
                 AND deleted_at IS NULL',
181 181
                 $login
@@ -412,7 +412,7 @@  discard block
 block discarded – undo
412 412
 
413 413
             // Get info about user to delete
414 414
             $data_user = DB::queryfirstrow(
415
-                'SELECT login, admin, isAdministratedByRole FROM ' . prefixTable('users') . '
415
+                'SELECT login, admin, isAdministratedByRole FROM '.prefixTable('users').'
416 416
                 WHERE id = %i',
417 417
                 $post_id
418 418
             );
@@ -446,7 +446,7 @@  discard block
 block discarded – undo
446 446
                 );
447 447
                 // delete personal folder and subfolders
448 448
                 $data = DB::queryfirstrow(
449
-                    'SELECT id FROM ' . prefixTable('nested_tree') . '
449
+                    'SELECT id FROM '.prefixTable('nested_tree').'
450 450
                     WHERE title = %s AND personal_folder = %i',
451 451
                     $post_id,
452 452
                     '1'
@@ -459,7 +459,7 @@  discard block
 block discarded – undo
459 459
                         DB::delete(prefixTable('nested_tree'), 'id = %i AND personal_folder = %i', $folder->id, '1');
460 460
                         // delete items & logs
461 461
                         $items = DB::query(
462
-                            'SELECT id FROM ' . prefixTable('items') . '
462
+                            'SELECT id FROM '.prefixTable('items').'
463 463
                             WHERE id_tree=%i AND perso = %i',
464 464
                             $folder->id,
465 465
                             '1'
@@ -483,7 +483,7 @@  discard block
 block discarded – undo
483 483
                 // Delete any process related to user
484 484
                 $processes = DB::query(
485 485
                     'SELECT increment_id
486
-                    FROM ' . prefixTable('background_tasks') . '
486
+                    FROM ' . prefixTable('background_tasks').'
487 487
                     WHERE JSON_EXTRACT(arguments, "$.new_user_id") = %i',
488 488
                     $post_id
489 489
                 );
@@ -543,7 +543,7 @@  discard block
 block discarded – undo
543 543
 
544 544
             // Get info about user to delete
545 545
             $data_user = DB::queryfirstrow(
546
-                'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
546
+                'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
547 547
                 WHERE id = %i',
548 548
                 $post_id
549 549
             );
@@ -585,7 +585,7 @@  discard block
 block discarded – undo
585 585
 
586 586
             // Get info about user to delete
587 587
             $data_user = DB::queryfirstrow(
588
-                'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
588
+                'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
589 589
                 WHERE id = %i',
590 590
                 $post_id
591 591
             );
@@ -628,7 +628,7 @@  discard block
 block discarded – undo
628 628
             // Get info about user to delete
629 629
             $data_user = DB::queryfirstrow(
630 630
                 'SELECT admin, isAdministratedByRole, can_manage_all_users, gestionnaire
631
-                FROM ' . prefixTable('users') . '
631
+                FROM ' . prefixTable('users').'
632 632
                 WHERE id = %i',
633 633
                 $post_id
634 634
             );
@@ -672,7 +672,7 @@  discard block
 block discarded – undo
672 672
 
673 673
             // Get info about user to delete
674 674
             $data_user = DB::queryfirstrow(
675
-                'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
675
+                'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
676 676
                 WHERE id = %i',
677 677
                 $post_id
678 678
             );
@@ -715,7 +715,7 @@  discard block
 block discarded – undo
715 715
             // Get info about user to delete
716 716
             $data_user = DB::queryfirstrow(
717 717
                 'SELECT admin, isAdministratedByRole, gestionnaire
718
-                FROM ' . prefixTable('users') . '
718
+                FROM ' . prefixTable('users').'
719 719
                 WHERE id = %i',
720 720
                 $post_id
721 721
             );
@@ -758,7 +758,7 @@  discard block
 block discarded – undo
758 758
             // Get info about user to delete
759 759
             $data_user = DB::queryfirstrow(
760 760
                 'SELECT admin, isAdministratedByRole, gestionnaire
761
-                FROM ' . prefixTable('users') . '
761
+                FROM ' . prefixTable('users').'
762 762
                 WHERE id = %i',
763 763
                 $post_id
764 764
             );
@@ -798,7 +798,7 @@  discard block
 block discarded – undo
798 798
             // Get info about user to delete
799 799
             $data_user = DB::queryfirstrow(
800 800
                 'SELECT admin, isAdministratedByRole, gestionnaire
801
-                FROM ' . prefixTable('users') . '
801
+                FROM ' . prefixTable('users').'
802 802
                 WHERE id = %i',
803 803
                 $post_id
804 804
             );
@@ -837,7 +837,7 @@  discard block
 block discarded – undo
837 837
             $return = array();
838 838
             // Check if folder exists
839 839
             $data = DB::query(
840
-                'SELECT * FROM ' . prefixTable('nested_tree') . '
840
+                'SELECT * FROM '.prefixTable('nested_tree').'
841 841
                 WHERE title = %s AND parent_id = %i',
842 842
                 filter_input(INPUT_POST, 'domain', FILTER_SANITIZE_FULL_SPECIAL_CHARS),
843 843
                 '0'
@@ -850,7 +850,7 @@  discard block
 block discarded – undo
850 850
             }
851 851
             // Check if role exists
852 852
             $data = DB::query(
853
-                'SELECT * FROM ' . prefixTable('roles_title') . '
853
+                'SELECT * FROM '.prefixTable('roles_title').'
854 854
                 WHERE title = %s',
855 855
                 filter_input(INPUT_POST, 'domain', FILTER_SANITIZE_FULL_SPECIAL_CHARS)
856 856
             );
@@ -870,7 +870,7 @@  discard block
 block discarded – undo
870 870
         case 'user_log_items':
871 871
             $nb_pages = 1;
872 872
             $logs = $sql_filter = '';
873
-            $pages = '<table style=\'border-top:1px solid #969696;\'><tr><td>' . $lang->get('pages') . '&nbsp;:&nbsp;</td>';
873
+            $pages = '<table style=\'border-top:1px solid #969696;\'><tr><td>'.$lang->get('pages').'&nbsp;:&nbsp;</td>';
874 874
 
875 875
             // Prepare POST variables
876 876
             $post_nb_items_by_page = filter_input(INPUT_POST, 'nb_items_by_page', FILTER_SANITIZE_NUMBER_INT);
@@ -882,14 +882,14 @@  discard block
 block discarded – undo
882 882
                     && !empty(filter_input(INPUT_POST, 'filter', FILTER_SANITIZE_FULL_SPECIAL_CHARS))
883 883
                     && filter_input(INPUT_POST, 'filter', FILTER_SANITIZE_FULL_SPECIAL_CHARS) !== 'all'
884 884
                 ) {
885
-                    $sql_filter = " AND l.action = '" . filter_input(INPUT_POST, 'filter', FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "'";
885
+                    $sql_filter = " AND l.action = '".filter_input(INPUT_POST, 'filter', FILTER_SANITIZE_FULL_SPECIAL_CHARS)."'";
886 886
                 }
887 887
                 // get number of pages
888 888
                 DB::query(
889 889
                     'SELECT *
890
-                    FROM ' . prefixTable('log_items') . ' as l
891
-                    INNER JOIN ' . prefixTable('items') . ' as i ON (l.id_item=i.id)
892
-                    INNER JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id)
890
+                    FROM ' . prefixTable('log_items').' as l
891
+                    INNER JOIN ' . prefixTable('items').' as i ON (l.id_item=i.id)
892
+                    INNER JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id)
893 893
                     WHERE l.id_user = %i ' . $sql_filter,
894 894
                     filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT)
895 895
                 );
@@ -907,19 +907,19 @@  discard block
 block discarded – undo
907 907
                 // launch query
908 908
                 $rows = DB::query(
909 909
                     'SELECT l.date as date, u.login as login, i.label as label, l.action as action
910
-                    FROM ' . prefixTable('log_items') . ' as l
911
-                    INNER JOIN ' . prefixTable('items') . ' as i ON (l.id_item=i.id)
912
-                    INNER JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id)
913
-                    WHERE l.id_user = %i ' . $sql_filter . '
910
+                    FROM ' . prefixTable('log_items').' as l
911
+                    INNER JOIN ' . prefixTable('items').' as i ON (l.id_item=i.id)
912
+                    INNER JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id)
913
+                    WHERE l.id_user = %i ' . $sql_filter.'
914 914
                     ORDER BY date DESC
915
-                    LIMIT ' . intval($start) . ',' . intval($post_nb_items_by_page),
915
+                    LIMIT ' . intval($start).','.intval($post_nb_items_by_page),
916 916
                     filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT)
917 917
                 );
918 918
             } else {
919 919
                 // get number of pages
920 920
                 DB::query(
921 921
                     'SELECT *
922
-                    FROM ' . prefixTable('log_system') . '
922
+                    FROM ' . prefixTable('log_system').'
923 923
                     WHERE type = %s AND field_1=%i',
924 924
                     'user_mngt',
925 925
                     filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT)
@@ -938,7 +938,7 @@  discard block
 block discarded – undo
938 938
                 // launch query
939 939
                 $rows = DB::query(
940 940
                     'SELECT *
941
-                    FROM ' . prefixTable('log_system') . '
941
+                    FROM ' . prefixTable('log_system').'
942 942
                     WHERE type = %s AND field_1 = %i
943 943
                     ORDER BY date DESC
944 944
                     LIMIT %i, %i',
@@ -952,7 +952,7 @@  discard block
 block discarded – undo
952 952
             if (isset($counter) && $counter != 0) {
953 953
                 $nb_pages = ceil($counter / intval($post_nb_items_by_page));
954 954
                 for ($i = 1; $i <= $nb_pages; ++$i) {
955
-                    $pages .= '<td onclick=\'displayLogs(' . $i . ',\"' . $post_scope . '\")\'><span style=\'cursor:pointer;' . (filter_input(INPUT_POST, 'page', FILTER_SANITIZE_NUMBER_INT) === $i ? 'font-weight:bold;font-size:18px;\'>' . $i : '\'>' . $i) . '</span></td>';
955
+                    $pages .= '<td onclick=\'displayLogs('.$i.',\"'.$post_scope.'\")\'><span style=\'cursor:pointer;'.(filter_input(INPUT_POST, 'page', FILTER_SANITIZE_NUMBER_INT) === $i ? 'font-weight:bold;font-size:18px;\'>'.$i : '\'>'.$i).'</span></td>';
956 956
                 }
957 957
             }
958 958
             $pages .= '</tr></table>';
@@ -961,7 +961,7 @@  discard block
 block discarded – undo
961 961
                     if ($post_scope === 'user_mngt') {
962 962
                         $user = DB::queryfirstrow(
963 963
                             'SELECT login
964
-                            from ' . prefixTable('users') . '
964
+                            from ' . prefixTable('users').'
965 965
                             WHERE id=%i',
966 966
                             $record['qui']
967 967
                         );
@@ -971,7 +971,7 @@  discard block
 block discarded – undo
971 971
                         if ($tmp[0] == 'at_user_initial_pwd_changed') {
972 972
                             $label = $lang->get('log_user_initial_pwd_changed');
973 973
                         } elseif ($tmp[0] == 'at_user_email_changed') {
974
-                            $label = $lang->get('log_user_email_changed') . $tmp[1];
974
+                            $label = $lang->get('log_user_email_changed').$tmp[1];
975 975
                         } elseif ($tmp[0] == 'at_user_added') {
976 976
                             $label = $lang->get('log_user_created');
977 977
                         } elseif ($tmp[0] == 'at_user_locked') {
@@ -982,14 +982,14 @@  discard block
 block discarded – undo
982 982
                             $label = $lang->get('log_user_pwd_changed');
983 983
                         }
984 984
                         // prepare log
985
-                        $logs .= '<tr><td>' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . '</td><td align=\"center\">' . $label . '</td><td align=\"center\">' . $user['login'] . '</td><td align=\"center\"></td></tr>';
985
+                        $logs .= '<tr><td>'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).'</td><td align=\"center\">'.$label.'</td><td align=\"center\">'.$user['login'].'</td><td align=\"center\"></td></tr>';
986 986
                     } else {
987
-                        $logs .= '<tr><td>' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . '</td><td align=\"center\">' . str_replace('"', '\"', $record['label']) . '</td><td align=\"center\">' . $record['login'] . '</td><td align=\"center\">' . $lang->get($record['action']) . '</td></tr>';
987
+                        $logs .= '<tr><td>'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).'</td><td align=\"center\">'.str_replace('"', '\"', $record['label']).'</td><td align=\"center\">'.$record['login'].'</td><td align=\"center\">'.$lang->get($record['action']).'</td></tr>';
988 988
                     }
989 989
                 }
990 990
             }
991 991
 
992
-            echo '[ { "table_logs": "' . ($logs) . '", "pages": "' . ($pages) . '", "error" : "no" } ]';
992
+            echo '[ { "table_logs": "'.($logs).'", "pages": "'.($pages).'", "error" : "no" } ]';
993 993
             break;
994 994
 
995 995
             /*
@@ -1012,7 +1012,7 @@  discard block
 block discarded – undo
1012 1012
             } else {
1013 1013
                 // Get folder id for Admin
1014 1014
                 $admin_folder = DB::queryFirstRow(
1015
-                    'SELECT id FROM ' . prefixTable('nested_tree') . '
1015
+                    'SELECT id FROM '.prefixTable('nested_tree').'
1016 1016
                     WHERE title = %i AND personal_folder = %i',
1017 1017
                     (int) $session->get('user-id'),
1018 1018
                     '1'
@@ -1023,15 +1023,15 @@  discard block
 block discarded – undo
1023 1023
                     // Get each Items in PF
1024 1024
                     $rows = DB::query(
1025 1025
                         'SELECT i.pw, i.label, l.id_user
1026
-                        FROM ' . prefixTable('items') . ' as i
1027
-                        LEFT JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item=i.id)
1026
+                        FROM ' . prefixTable('items').' as i
1027
+                        LEFT JOIN ' . prefixTable('log_items').' as l ON (l.id_item=i.id)
1028 1028
                         WHERE l.action = %s AND i.perso=%i AND i.id_tree=%i',
1029 1029
                         'at_creation',
1030 1030
                         '1',
1031 1031
                         intval($folder->id)
1032 1032
                     );
1033 1033
                     foreach ($rows as $record) {
1034
-                        echo $record['label'] . ' - ';
1034
+                        echo $record['label'].' - ';
1035 1035
                         // Change user
1036 1036
                         DB::update(
1037 1037
                             prefixTable('log_items'),
@@ -1066,7 +1066,7 @@  discard block
 block discarded – undo
1066 1066
             // Get info about user to delete
1067 1067
             $data_user = DB::queryfirstrow(
1068 1068
                 'SELECT admin, isAdministratedByRole, gestionnaire
1069
-                FROM ' . prefixTable('users') . '
1069
+                FROM ' . prefixTable('users').'
1070 1070
                 WHERE id = %i',
1071 1071
                 $post_user_id
1072 1072
             );
@@ -1103,7 +1103,7 @@  discard block
 block discarded – undo
1103 1103
 
1104 1104
             // Do
1105 1105
             $rows = DB::query(
1106
-                'SELECT id FROM ' . prefixTable('users') . '
1106
+                'SELECT id FROM '.prefixTable('users').'
1107 1107
                 WHERE timestamp != %s AND admin != %i',
1108 1108
                 '',
1109 1109
                 '1'
@@ -1112,7 +1112,7 @@  discard block
 block discarded – undo
1112 1112
                 // Get info about user to delete
1113 1113
                 $data_user = DB::queryfirstrow(
1114 1114
                     'SELECT admin, isAdministratedByRole, gestionnaire
1115
-                    FROM ' . prefixTable('users') . '
1115
+                    FROM ' . prefixTable('users').'
1116 1116
                     WHERE id = %i',
1117 1117
                     $record['id']
1118 1118
                 );
@@ -1173,7 +1173,7 @@  discard block
 block discarded – undo
1173 1173
             // Get info about user
1174 1174
             $rowUser = DB::queryfirstrow(
1175 1175
                 'SELECT *
1176
-                FROM ' . prefixTable('users') . '
1176
+                FROM ' . prefixTable('users').'
1177 1177
                 WHERE id = %i',
1178 1178
                 $post_id
1179 1179
             );
@@ -1200,7 +1200,7 @@  discard block
 block discarded – undo
1200 1200
                 // array of roles for actual user
1201 1201
                 //$my_functions = explode(';', $rowUser['fonction_id']);
1202 1202
 
1203
-                $rows = DB::query('SELECT id,title,creator_id FROM ' . prefixTable('roles_title'));
1203
+                $rows = DB::query('SELECT id,title,creator_id FROM '.prefixTable('roles_title'));
1204 1204
                 foreach ($rows as $record) {
1205 1205
                     if (
1206 1206
                         (int) $session->get('user-admin') === 1
@@ -1237,7 +1237,7 @@  discard block
 block discarded – undo
1237 1237
                 $rolesList = array();
1238 1238
                 $managedBy = array();
1239 1239
                 $selected = '';
1240
-                $rows = DB::query('SELECT id,title FROM ' . prefixTable('roles_title') . ' ORDER BY title ASC');
1240
+                $rows = DB::query('SELECT id,title FROM '.prefixTable('roles_title').' ORDER BY title ASC');
1241 1241
                 foreach ($rows as $reccord) {
1242 1242
                     $rolesList[$reccord['id']] = array('id' => $reccord['id'], 'title' => $reccord['title']);
1243 1243
                 }
@@ -1268,7 +1268,7 @@  discard block
 block discarded – undo
1268 1268
                         array_push(
1269 1269
                             $managedBy,
1270 1270
                             array(
1271
-                                'title' => $lang->get('managers_of') . ' ' . $fonction['title'],
1271
+                                'title' => $lang->get('managers_of').' '.$fonction['title'],
1272 1272
                                 'id' => $fonction['id'],
1273 1273
                                 'selected' => $selected,
1274 1274
                             )
@@ -1350,9 +1350,9 @@  discard block
 block discarded – undo
1350 1350
 
1351 1351
                 // get USER STATUS
1352 1352
                 if ($rowUser['disabled'] == 1) {
1353
-                    $arrData['info'] = $lang->get('user_info_locked') . '<br><input type="checkbox" value="unlock" name="1" class="chk">&nbsp;<label for="1">' . $lang->get('user_info_unlock_question') . '</label><br><input type="checkbox"  value="delete" id="account_delete" class="chk mr-2" name="2" onclick="confirmDeletion()">label for="2">' . $lang->get('user_info_delete_question') . '</label>';
1353
+                    $arrData['info'] = $lang->get('user_info_locked').'<br><input type="checkbox" value="unlock" name="1" class="chk">&nbsp;<label for="1">'.$lang->get('user_info_unlock_question').'</label><br><input type="checkbox"  value="delete" id="account_delete" class="chk mr-2" name="2" onclick="confirmDeletion()">label for="2">'.$lang->get('user_info_delete_question').'</label>';
1354 1354
                 } else {
1355
-                    $arrData['info'] = $lang->get('user_info_active') . '<br><input type="checkbox" value="lock" class="chk">&nbsp;' . $lang->get('user_info_lock_question');
1355
+                    $arrData['info'] = $lang->get('user_info_active').'<br><input type="checkbox" value="lock" class="chk">&nbsp;'.$lang->get('user_info_lock_question');
1356 1356
                 }
1357 1357
 
1358 1358
                 $arrData['error'] = false;
@@ -1449,7 +1449,7 @@  discard block
 block discarded – undo
1449 1449
                 // count number of admins
1450 1450
                 $users = DB::query(
1451 1451
                     'SELECT id
1452
-                    FROM ' . prefixTable('users') . '
1452
+                    FROM ' . prefixTable('users').'
1453 1453
                     WHERE admin = 1 AND email != "" AND pw != "" AND id != %i',
1454 1454
                     $post_id
1455 1455
                 );
@@ -1472,7 +1472,7 @@  discard block
 block discarded – undo
1472 1472
             // Exclude roles from AD - PR #3635
1473 1473
             $adRoles = DB::query(
1474 1474
                 'SELECT roles_from_ad_groups
1475
-                FROM ' . prefixTable('users') . '
1475
+                FROM ' . prefixTable('users').'
1476 1476
                 WHERE id = '. $dataReceived['user_id']
1477 1477
             )[0]['roles_from_ad_groups'];
1478 1478
             $fonctions = [];
@@ -1551,7 +1551,7 @@  discard block
 block discarded – undo
1551 1551
 
1552 1552
             // Get info about user to delete
1553 1553
             $data_user = DB::queryfirstrow(
1554
-                'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
1554
+                'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
1555 1555
                 WHERE id = %i',
1556 1556
                 $post_id
1557 1557
             );
@@ -1572,7 +1572,7 @@  discard block
 block discarded – undo
1572 1572
                     );
1573 1573
                     // delete personal folder and subfolders
1574 1574
                     $data = DB::queryfirstrow(
1575
-                        'SELECT id FROM ' . prefixTable('nested_tree') . '
1575
+                        'SELECT id FROM '.prefixTable('nested_tree').'
1576 1576
                         WHERE title = %s AND personal_folder = %i',
1577 1577
                         $post_id,
1578 1578
                         '1'
@@ -1585,7 +1585,7 @@  discard block
 block discarded – undo
1585 1585
                             DB::delete(prefixTable('nested_tree'), 'id = %i AND personal_folder = %i', $folder->id, '1');
1586 1586
                             // delete items & logs
1587 1587
                             $items = DB::query(
1588
-                                'SELECT id FROM ' . prefixTable('items') . '
1588
+                                'SELECT id FROM '.prefixTable('items').'
1589 1589
                                 WHERE id_tree=%i AND perso = %i',
1590 1590
                                 $folder->id,
1591 1591
                                 '1'
@@ -1606,7 +1606,7 @@  discard block
 block discarded – undo
1606 1606
                 } else {
1607 1607
                     // Get old data about user
1608 1608
                     $oldData = DB::queryfirstrow(
1609
-                        'SELECT * FROM ' . prefixTable('users') . '
1609
+                        'SELECT * FROM '.prefixTable('users').'
1610 1610
                         WHERE id = %i',
1611 1611
                         $post_id
1612 1612
                     );
@@ -1643,7 +1643,7 @@  discard block
 block discarded – undo
1643 1643
 
1644 1644
                     // update LOG
1645 1645
                     if ($oldData['email'] !== $post_email) {
1646
-                        logEvents($SETTINGS, 'user_mngt', 'at_user_email_changed:' . $oldData['email'], (string) $session->get('user-id'), $session->get('user-login'), $post_id);
1646
+                        logEvents($SETTINGS, 'user_mngt', 'at_user_email_changed:'.$oldData['email'], (string) $session->get('user-id'), $session->get('user-login'), $post_id);
1647 1647
                     }
1648 1648
                 }
1649 1649
                 echo prepareExchangedData(
@@ -1701,7 +1701,7 @@  discard block
 block discarded – undo
1701 1701
 
1702 1702
             // Get info about user to delete
1703 1703
             $data_user = DB::queryfirstrow(
1704
-                'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
1704
+                'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
1705 1705
                 WHERE id = %i',
1706 1706
                 $post_id
1707 1707
             );
@@ -1751,7 +1751,7 @@  discard block
 block discarded – undo
1751 1751
             }
1752 1752
 
1753 1753
             DB::queryfirstrow(
1754
-                'SELECT * FROM ' . prefixTable('users') . '
1754
+                'SELECT * FROM '.prefixTable('users').'
1755 1755
                 WHERE login = %s
1756 1756
                 AND deleted_at IS NULL',
1757 1757
                 filter_input(INPUT_POST, 'login', FILTER_SANITIZE_FULL_SPECIAL_CHARS)
@@ -1803,7 +1803,7 @@  discard block
 block discarded – undo
1803 1803
             // get User info
1804 1804
             $rowUser = DB::queryFirstRow(
1805 1805
                 'SELECT login, name, lastname, email, disabled, fonction_id, groupes_interdits, groupes_visibles, isAdministratedByRole, avatar_thumb, roles_from_ad_groups
1806
-                FROM ' . prefixTable('users') . '
1806
+                FROM ' . prefixTable('users').'
1807 1807
                 WHERE id = %i',
1808 1808
                 $post_id
1809 1809
             );
@@ -1813,7 +1813,7 @@  discard block
 block discarded – undo
1813 1813
             $html = '';
1814 1814
 
1815 1815
             if (isset($SETTINGS['ldap_mode']) === true && (int) $SETTINGS['ldap_mode'] === 1 && isset($SETTINGS['enable_ad_users_with_ad_groups']) === true && (int) $SETTINGS['enable_ad_users_with_ad_groups'] === 1) {
1816
-                $rowUser['fonction_id'] = empty($rowUser['fonction_id'])  === true ? $rowUser['roles_from_ad_groups'] : $rowUser['fonction_id']. ';' . $rowUser['roles_from_ad_groups'];
1816
+                $rowUser['fonction_id'] = empty($rowUser['fonction_id']) === true ? $rowUser['roles_from_ad_groups'] : $rowUser['fonction_id'].';'.$rowUser['roles_from_ad_groups'];
1817 1817
             }
1818 1818
             $arrData['functions'] = array_filter(explode(';', $rowUser['fonction_id']));
1819 1819
             $arrData['allowed_folders'] = array_filter(explode(';', $rowUser['groupes_visibles']));
@@ -1824,7 +1824,7 @@  discard block
 block discarded – undo
1824 1824
                 // refine folders based upon roles
1825 1825
                 $rows = DB::query(
1826 1826
                     'SELECT folder_id, type
1827
-                    FROM ' . prefixTable('roles_values') . '
1827
+                    FROM ' . prefixTable('roles_values').'
1828 1828
                     WHERE role_id IN %ls
1829 1829
                     ORDER BY folder_id ASC',
1830 1830
                     $arrData['functions']
@@ -1847,7 +1847,7 @@  discard block
 block discarded – undo
1847 1847
                 }
1848 1848
 
1849 1849
                 // add allowed folders
1850
-                foreach($arrData['allowed_folders'] as $Fld) {
1850
+                foreach ($arrData['allowed_folders'] as $Fld) {
1851 1851
                     array_push($arrFolders, array('id' => $Fld, 'type' => 'W', 'special' => true));
1852 1852
                 }
1853 1853
                 
@@ -1858,7 +1858,7 @@  discard block
 block discarded – undo
1858 1858
                             // get folder name
1859 1859
                             $row = DB::queryFirstRow(
1860 1860
                                 'SELECT title, nlevel, id
1861
-                                FROM ' . prefixTable('nested_tree') . '
1861
+                                FROM ' . prefixTable('nested_tree').'
1862 1862
                                 WHERE id = %i',
1863 1863
                                 $fld['id']
1864 1864
                             );
@@ -1871,38 +1871,38 @@  discard block
 block discarded – undo
1871 1871
 
1872 1872
                             // manage right icon
1873 1873
                             if ($fld['type'] == 'W') {
1874
-                                $label = '<i class="fas fa-indent infotip text-success mr-2" title="' . $lang->get('write') . '"></i>' .
1875
-                                    '<i class="fas fa-edit infotip text-success mr-2" title="' . $lang->get('edit') . '"></i>' .
1876
-                                    '<i class="fas fa-eraser infotip text-success" title="' . $lang->get('delete') . '"></i>';
1874
+                                $label = '<i class="fas fa-indent infotip text-success mr-2" title="'.$lang->get('write').'"></i>'.
1875
+                                    '<i class="fas fa-edit infotip text-success mr-2" title="'.$lang->get('edit').'"></i>'.
1876
+                                    '<i class="fas fa-eraser infotip text-success" title="'.$lang->get('delete').'"></i>';
1877 1877
                             } elseif ($fld['type'] == 'ND') {
1878
-                                $label = '<i class="fas fa-indent infotip text-warning mr-2" title="' . $lang->get('write') . '"></i>' .
1879
-                                    '<i class="fas fa-edit infotip text-success mr-2" title="' . $lang->get('edit') . '"></i>' .
1880
-                                    '<i class="fas fa-eraser infotip text-danger" title="' . $lang->get('no_delete') . '"></i>';
1878
+                                $label = '<i class="fas fa-indent infotip text-warning mr-2" title="'.$lang->get('write').'"></i>'.
1879
+                                    '<i class="fas fa-edit infotip text-success mr-2" title="'.$lang->get('edit').'"></i>'.
1880
+                                    '<i class="fas fa-eraser infotip text-danger" title="'.$lang->get('no_delete').'"></i>';
1881 1881
                             } elseif ($fld['type'] == 'NE') {
1882
-                                $label = '<i class="fas fa-indent infotip text-warning mr-2" title="' . $lang->get('write') . '"></i>' .
1883
-                                    '<i class="fas fa-edit infotip text-danger mr-2" title="' . $lang->get('no_edit') . '"></i>' .
1884
-                                    '<i class="fas fa-eraser infotip text-success" title="' . $lang->get('delete') . '"></i>';
1882
+                                $label = '<i class="fas fa-indent infotip text-warning mr-2" title="'.$lang->get('write').'"></i>'.
1883
+                                    '<i class="fas fa-edit infotip text-danger mr-2" title="'.$lang->get('no_edit').'"></i>'.
1884
+                                    '<i class="fas fa-eraser infotip text-success" title="'.$lang->get('delete').'"></i>';
1885 1885
                             } elseif ($fld['type'] == 'NDNE') {
1886
-                                $label = '<i class="fas fa-indent infotip text-warning mr-2" title="' . $lang->get('write') . '"></i>' .
1887
-                                    '<i class="fas fa-edit infotip text-danger mr-2" title="' . $lang->get('no_edit') . '"></i>' .
1888
-                                    '<i class="fas fa-eraser infotip text-danger" title="' . $lang->get('no_delete') . '"></i>';
1886
+                                $label = '<i class="fas fa-indent infotip text-warning mr-2" title="'.$lang->get('write').'"></i>'.
1887
+                                    '<i class="fas fa-edit infotip text-danger mr-2" title="'.$lang->get('no_edit').'"></i>'.
1888
+                                    '<i class="fas fa-eraser infotip text-danger" title="'.$lang->get('no_delete').'"></i>';
1889 1889
                             } elseif ($fld['type'] == '') {
1890
-                                $label = '<i class="fas fa-eye-slash infotip text-danger mr-2" title="' . $lang->get('no_access') . '"></i>';
1890
+                                $label = '<i class="fas fa-eye-slash infotip text-danger mr-2" title="'.$lang->get('no_access').'"></i>';
1891 1891
                             } else {
1892
-                                $label = '<i class="fas fa-eye infotip text-info mr-2" title="' . $lang->get('read') . '"></i>';
1892
+                                $label = '<i class="fas fa-eye infotip text-info mr-2" title="'.$lang->get('read').'"></i>';
1893 1893
                             }
1894 1894
 
1895
-                            $html .= '<tr><td>' . $ident . $row['title'] .
1896
-                                ' <small class="text-info">[' . $row['id'] . ']</small>'.
1897
-                                ($fld['special'] === true ? '<i class="fas fa-user-tag infotip text-primary ml-5" title="' . $lang->get('user_specific_right') . '"></i>' : '').
1898
-                                '</td><td>' . $label . '</td></tr>';
1895
+                            $html .= '<tr><td>'.$ident.$row['title'].
1896
+                                ' <small class="text-info">['.$row['id'].']</small>'.
1897
+                                ($fld['special'] === true ? '<i class="fas fa-user-tag infotip text-primary ml-5" title="'.$lang->get('user_specific_right').'"></i>' : '').
1898
+                                '</td><td>'.$label.'</td></tr>';
1899 1899
                             break;
1900 1900
                         }
1901 1901
                     }
1902 1902
                 }
1903 1903
 
1904
-                $html_full = '<table id="table-folders" class="table table-bordered table-striped dt-responsive nowrap" style="width:100%"><tbody>' .
1905
-                    $html . '</tbody></table>';
1904
+                $html_full = '<table id="table-folders" class="table table-bordered table-striped dt-responsive nowrap" style="width:100%"><tbody>'.
1905
+                    $html.'</tbody></table>';
1906 1906
             } else {
1907 1907
                 $html_full = '';
1908 1908
             }
@@ -1948,7 +1948,7 @@  discard block
 block discarded – undo
1948 1948
             if ((int) $session->get('user-admin') === 0 && (int) $session->get('user-can_manage_all_users') === 0) {
1949 1949
                 $rows = DB::query(
1950 1950
                     'SELECT *
1951
-                    FROM ' . prefixTable('users') . '
1951
+                    FROM ' . prefixTable('users').'
1952 1952
                     WHERE admin = %i AND isAdministratedByRole IN %ls',
1953 1953
                     '0',
1954 1954
                     array_filter($session->get('user-roles_array'))
@@ -1956,7 +1956,7 @@  discard block
 block discarded – undo
1956 1956
             } else {
1957 1957
                 $rows = DB::query(
1958 1958
                     'SELECT *
1959
-                    FROM ' . prefixTable('users') . '
1959
+                    FROM ' . prefixTable('users').'
1960 1960
                     WHERE admin = %i',
1961 1961
                     '0'
1962 1962
                 );
@@ -1968,7 +1968,7 @@  discard block
 block discarded – undo
1968 1968
                 $groupIds = [];
1969 1969
                 foreach (explode(';', $record['fonction_id']) as $group) {
1970 1970
                     $tmp = DB::queryfirstrow(
1971
-                        'SELECT id, title FROM ' . prefixTable('roles_title') . '
1971
+                        'SELECT id, title FROM '.prefixTable('roles_title').'
1972 1972
                         WHERE id = %i',
1973 1973
                         $group
1974 1974
                     );
@@ -1980,7 +1980,7 @@  discard block
 block discarded – undo
1980 1980
 
1981 1981
                 // Get managed_by
1982 1982
                 $managedBy = DB::queryfirstrow(
1983
-                    'SELECT id, title FROM ' . prefixTable('roles_title') . '
1983
+                    'SELECT id, title FROM '.prefixTable('roles_title').'
1984 1984
                     WHERE id = %i',
1985 1985
                     $record['isAdministratedByRole']
1986 1986
                 );
@@ -1990,7 +1990,7 @@  discard block
 block discarded – undo
1990 1990
                 $foldersAllowedIds = [];
1991 1991
                 foreach (explode(';', $record['groupes_visibles']) as $role) {
1992 1992
                     $tmp = DB::queryfirstrow(
1993
-                        'SELECT id, title FROM ' . prefixTable('nested_tree') . '
1993
+                        'SELECT id, title FROM '.prefixTable('nested_tree').'
1994 1994
                         WHERE id = %i',
1995 1995
                         $role
1996 1996
                     );
@@ -2003,7 +2003,7 @@  discard block
 block discarded – undo
2003 2003
                 $foldersForbiddenIds = [];
2004 2004
                 foreach (explode(';', $record['groupes_interdits']) as $role) {
2005 2005
                     $tmp = DB::queryfirstrow(
2006
-                        'SELECT id, title FROM ' . prefixTable('nested_tree') . '
2006
+                        'SELECT id, title FROM '.prefixTable('nested_tree').'
2007 2007
                         WHERE id = %i',
2008 2008
                         $role
2009 2009
                     );
@@ -2021,7 +2021,7 @@  discard block
 block discarded – undo
2021 2021
                         'login' => $record['login'],
2022 2022
                         'groups' => implode(', ', $groups),
2023 2023
                         'groupIds' => $groupIds,
2024
-                        'managedBy' => $managedBy=== null ? $lang->get('administrator') : $managedBy['title'],
2024
+                        'managedBy' => $managedBy === null ? $lang->get('administrator') : $managedBy['title'],
2025 2025
                         'managedById' => $managedBy === null ? 0 : $managedBy['id'],
2026 2026
                         'foldersAllowed' => implode(', ', $foldersAllowed),
2027 2027
                         'foldersAllowedIds' => $foldersAllowedIds,
@@ -2102,7 +2102,7 @@  discard block
 block discarded – undo
2102 2102
 
2103 2103
             // Get info about user
2104 2104
             $data_user = DB::queryfirstrow(
2105
-                'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
2105
+                'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
2106 2106
                 WHERE id = %i',
2107 2107
                 $post_source_id
2108 2108
             );
@@ -2308,14 +2308,14 @@  discard block
 block discarded – undo
2308 2308
             if (empty($post_context) === false && $post_context === 'add_one_role_to_user') {
2309 2309
                 $data_user = DB::queryfirstrow(
2310 2310
                     'SELECT fonction_id, public_key
2311
-                    FROM ' . prefixTable('users') . '
2311
+                    FROM ' . prefixTable('users').'
2312 2312
                     WHERE id = %i',
2313 2313
                     $post_user_id
2314 2314
                 );
2315 2315
 
2316 2316
                 if ($data_user) {
2317 2317
                     // Ensure array is unique
2318
-                    $post_new_value = str_replace(',', ';', $data_user['fonction_id']) . ';' . $post_new_value;
2318
+                    $post_new_value = str_replace(',', ';', $data_user['fonction_id']).';'.$post_new_value;
2319 2319
                     $post_new_value = implode(';', array_unique(explode(';', $post_new_value)));
2320 2320
                 } else {
2321 2321
                     // User not found
@@ -2331,14 +2331,14 @@  discard block
 block discarded – undo
2331 2331
             }
2332 2332
 
2333 2333
             // Manage specific case of api key
2334
-            if($post_field === 'user_api_key') {
2334
+            if ($post_field === 'user_api_key') {
2335 2335
                 $encrypted_key = encryptUserObjectKey(base64_encode($post_new_value), $session->get('user-public_key'));
2336 2336
                 $session->set('user-api_key', $post_new_value);
2337 2337
 
2338 2338
                 // test if user has an api key
2339 2339
                 $data_user = DB::queryfirstrow(
2340 2340
                     'SELECT value
2341
-                    FROM ' . prefixTable('api') . '
2341
+                    FROM ' . prefixTable('api').'
2342 2342
                     WHERE user_id = %i',
2343 2343
                     $post_user_id
2344 2344
                 );
@@ -2458,7 +2458,7 @@  discard block
 block discarded – undo
2458 2458
             } catch (\LdapRecord\Auth\BindException $e) {
2459 2459
                 $error = $e->getDetailedError();
2460 2460
                 if ($error) {
2461
-                    error_log('TEAMPASS Error - LDAP - '.$error->getErrorCode()." - ".$error->getErrorMessage(). " - ".$error->getDiagnosticMessage());
2461
+                    error_log('TEAMPASS Error - LDAP - '.$error->getErrorCode()." - ".$error->getErrorMessage()." - ".$error->getDiagnosticMessage());
2462 2462
                 } else {
2463 2463
                     error_log('TEAMPASS Error - LDAP - Code: '.$e->getCode().' - Message: '.$e->getMessage());
2464 2464
                 }
@@ -2490,7 +2490,7 @@  discard block
 block discarded – undo
2490 2490
             } catch (\LdapRecord\Auth\BindException $e) {
2491 2491
                 $error = $e->getDetailedError();
2492 2492
                 if ($error) {
2493
-                    error_log('TEAMPASS Error - LDAP - '.$error->getErrorCode()." - ".$error->getErrorMessage(). " - ".$error->getDiagnosticMessage());
2493
+                    error_log('TEAMPASS Error - LDAP - '.$error->getErrorCode()." - ".$error->getErrorMessage()." - ".$error->getDiagnosticMessage());
2494 2494
                 } else {
2495 2495
                     error_log('TEAMPASS Error - LDAP - Code: '.$e->getCode().' - Message: '.$e->getMessage());
2496 2496
                 }
@@ -2509,7 +2509,7 @@  discard block
 block discarded – undo
2509 2509
                 if (isset($adUser[$SETTINGS['ldap_user_attribute']][0]) === false) continue;
2510 2510
                 // Build the list of all groups in AD
2511 2511
                 if (isset($adUser['memberof']) === true) {
2512
-                    foreach($adUser['memberof'] as $j => $adUserGroup) {
2512
+                    foreach ($adUser['memberof'] as $j => $adUserGroup) {
2513 2513
                         if (empty($adUserGroup) === false && $j !== "count") {
2514 2514
                             $adGroup = substr($adUserGroup, 3, strpos($adUserGroup, ',') - 3);
2515 2515
                             if (in_array($adGroup, $adRoles) === false && empty($adGroup) === false) {
@@ -2525,7 +2525,7 @@  discard block
 block discarded – undo
2525 2525
                     // Get his ID
2526 2526
                     $userInfo = DB::queryfirstrow(
2527 2527
                         'SELECT id, login, fonction_id, auth_type
2528
-                        FROM ' . prefixTable('users') . '
2528
+                        FROM ' . prefixTable('users').'
2529 2529
                         WHERE login = %s',
2530 2530
                         $userLogin
2531 2531
                     );
@@ -2561,7 +2561,7 @@  discard block
 block discarded – undo
2561 2561
 
2562 2562
             // Get all groups in Teampass
2563 2563
             $teampassRoles = array();
2564
-            $rows = DB::query('SELECT id,title FROM ' . prefixTable('roles_title'));
2564
+            $rows = DB::query('SELECT id,title FROM '.prefixTable('roles_title'));
2565 2565
             foreach ($rows as $record) {
2566 2566
                 array_push(
2567 2567
                     $teampassRoles,
@@ -2631,7 +2631,7 @@  discard block
 block discarded – undo
2631 2631
             // Check if user already exists
2632 2632
             $data = DB::query(
2633 2633
                 'SELECT id, fonction_id, groupes_interdits, groupes_visibles
2634
-                FROM ' . prefixTable('users') . '
2634
+                FROM ' . prefixTable('users').'
2635 2635
                 WHERE login = %s',
2636 2636
                 $post_login
2637 2637
             );
@@ -2814,14 +2814,14 @@  discard block
 block discarded – undo
2814 2814
             // Send mail to user with new OTP
2815 2815
             $userInfo = DB::queryFirstRow(
2816 2816
                 'SELECT email
2817
-                FROM ' . prefixTable('users') . '
2817
+                FROM ' . prefixTable('users').'
2818 2818
                 WHERE id = %i',
2819 2819
                 $post_userId
2820 2820
             );
2821 2821
             $emailSettings = new EmailSettings($SETTINGS);
2822 2822
             $emailService = new EmailService();
2823 2823
             $emailService->sendMail(
2824
-                'TEAMPASS - ' . $lang->get('temporary_encryption_code'),
2824
+                'TEAMPASS - '.$lang->get('temporary_encryption_code'),
2825 2825
                 str_replace(
2826 2826
                     array('#enc_code#'),
2827 2827
                     array($post_otp),
@@ -2883,7 +2883,7 @@  discard block
 block discarded – undo
2883 2883
             // Check if user already exists
2884 2884
             DB::query(
2885 2885
                 'SELECT id
2886
-                FROM ' . prefixTable('users') . '
2886
+                FROM ' . prefixTable('users').'
2887 2887
                 WHERE id = %i',
2888 2888
                 $post_id
2889 2889
             );
@@ -2962,7 +2962,7 @@  discard block
 block discarded – undo
2962 2962
             // Check if user already exists
2963 2963
             $userInfo = DB::queryfirstrow(
2964 2964
                 'SELECT id, private_key, public_key
2965
-                FROM ' . prefixTable('users') . '
2965
+                FROM ' . prefixTable('users').'
2966 2966
                 WHERE id = %i',
2967 2967
                 $post_userid
2968 2968
             );
@@ -3009,7 +3009,7 @@  discard block
 block discarded – undo
3009 3009
             if (count($session->get('user-personal_folders')) > 0) {
3010 3010
                 DB::query(
3011 3011
                     'SELECT id
3012
-                    FROM ' . prefixTable('items') . '
3012
+                    FROM ' . prefixTable('items').'
3013 3013
                     WHERE id_tree IN %ls',
3014 3014
                     $session->get('user-personal_folders')
3015 3015
                 );
@@ -3090,7 +3090,7 @@  discard block
 block discarded – undo
3090 3090
             // Check if user already exists
3091 3091
             DB::query(
3092 3092
                 'SELECT id
3093
-                FROM ' . prefixTable('users') . '
3093
+                FROM ' . prefixTable('users').'
3094 3094
                 WHERE id = %i',
3095 3095
                 $post_id
3096 3096
             );
@@ -3168,10 +3168,10 @@  discard block
 block discarded – undo
3168 3168
                     'process_type' => 'create_user_keys',
3169 3169
                     'arguments' => json_encode([
3170 3170
                         'new_user_id' => (int) $post_user_id,
3171
-                        'new_user_pwd' => empty($post_user_pwd) === true ? '' : cryption($post_user_pwd, '','encrypt', $SETTINGS)['string'],
3172
-                        'new_user_code' => cryption($post_user_code, '','encrypt', $SETTINGS)['string'],
3171
+                        'new_user_pwd' => empty($post_user_pwd) === true ? '' : cryption($post_user_pwd, '', 'encrypt', $SETTINGS)['string'],
3172
+                        'new_user_code' => cryption($post_user_code, '', 'encrypt', $SETTINGS)['string'],
3173 3173
                         'owner_id' => (int) $session->get('user-id'),
3174
-                        'creator_pwd' => cryption($session->get('user-password'), '','encrypt', $SETTINGS)['string'],
3174
+                        'creator_pwd' => cryption($session->get('user-password'), '', 'encrypt', $SETTINGS)['string'],
3175 3175
                         'email_body' => $lang->get('email_body_user_config_5'),
3176 3176
                         'send_email' => 1,
3177 3177
                     ]),
@@ -3334,7 +3334,7 @@  discard block
 block discarded – undo
3334 3334
             // get user info
3335 3335
             $userInfo = DB::queryFirstRow(
3336 3336
                 'SELECT *
3337
-                FROM ' . prefixTable('users') . '
3337
+                FROM ' . prefixTable('users').'
3338 3338
                 WHERE id = %i',
3339 3339
                 $user_id
3340 3340
             );
@@ -3427,8 +3427,8 @@  discard block
 block discarded – undo
3427 3427
             // get user info
3428 3428
             $processesProgress = DB::query(
3429 3429
                 'SELECT u.ongoing_process_id, pt.task, pt.updated_at, pt.finished_at, pt.is_in_progress
3430
-                FROM ' . prefixTable('users') . ' AS u
3431
-                INNER JOIN ' . prefixTable('background_subtasks') . ' AS pt ON (pt.task_id = u.ongoing_process_id)
3430
+                FROM ' . prefixTable('users').' AS u
3431
+                INNER JOIN ' . prefixTable('background_subtasks').' AS pt ON (pt.task_id = u.ongoing_process_id)
3432 3432
                 WHERE u.id = %i',
3433 3433
                 $user_id
3434 3434
             );
@@ -3436,9 +3436,9 @@  discard block
 block discarded – undo
3436 3436
             //print_r($processesProgress);
3437 3437
             $finished_steps = 0;
3438 3438
             $nb_steps = count($processesProgress);
3439
-            foreach($processesProgress as $process) {
3439
+            foreach ($processesProgress as $process) {
3440 3440
                 if ((int) $process['is_in_progress'] === -1) {
3441
-                    $finished_steps ++;
3441
+                    $finished_steps++;
3442 3442
                 }
3443 3443
             }
3444 3444
 
@@ -3447,7 +3447,7 @@  discard block
 block discarded – undo
3447 3447
                     'error' => false,
3448 3448
                     'message' => '',
3449 3449
                     'user_id' => $user_id,
3450
-                    'status' => $finished_steps === $nb_steps ? 'finished' : number_format($finished_steps/$nb_steps*100, 0).'%',
3450
+                    'status' => $finished_steps === $nb_steps ? 'finished' : number_format($finished_steps / $nb_steps * 100, 0).'%',
3451 3451
                     'debug' => $finished_steps.",".$nb_steps,
3452 3452
                 ),
3453 3453
                 'encode'
@@ -3512,7 +3512,7 @@  discard block
 block discarded – undo
3512 3512
 
3513 3513
     // Get info about user
3514 3514
     $data_user = DB::queryfirstrow(
3515
-        'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
3515
+        'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
3516 3516
         WHERE id = %i',
3517 3517
         $value[1]
3518 3518
     );
@@ -3546,7 +3546,7 @@  discard block
 block discarded – undo
3546 3546
             logEvents(
3547 3547
                 $SETTINGS,
3548 3548
                 'user_mngt',
3549
-                'at_user_new_' . $value[0] . ':' . $value[1],
3549
+                'at_user_new_'.$value[0].':'.$value[1],
3550 3550
                 (string) $session->get('user-id'),
3551 3551
                 $session->get('user-login'),
3552 3552
                 filter_input(INPUT_POST, 'id', FILTER_SANITIZE_FULL_SPECIAL_CHARS)
@@ -3580,7 +3580,7 @@  discard block
 block discarded – undo
3580 3580
 
3581 3581
     // Get info about user
3582 3582
     $data_user = DB::queryfirstrow(
3583
-        'SELECT admin, isAdministratedByRole FROM ' . prefixTable('users') . '
3583
+        'SELECT admin, isAdministratedByRole FROM '.prefixTable('users').'
3584 3584
         WHERE id = %i',
3585 3585
         $value[1]
3586 3586
     );
Please login to merge, or discard this patch.
api/Controller/Api/AuthController.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -39,7 +39,7 @@  discard block
 block discarded – undo
39 39
         $arrQueryStringParams = $this->getQueryStringParams();
40 40
 
41 41
         if (strtoupper($requestMethod) === 'POST') {
42
-            require API_ROOT_PATH . "/Model/AuthModel.php";
42
+            require API_ROOT_PATH."/Model/AuthModel.php";
43 43
             try {
44 44
                 $authModel = new AuthModel();
45 45
                 $arrUser = $authModel->getUserAuth(
@@ -50,7 +50,7 @@  discard block
 block discarded – undo
50 50
                 if (array_key_exists("token", $arrUser)) {
51 51
                     $responseData = json_encode($arrUser);
52 52
                 } else {
53
-                    $strErrorDesc = $arrUser['error'] . " (" . $arrUser['info'] . ")";
53
+                    $strErrorDesc = $arrUser['error']." (".$arrUser['info'].")";
54 54
                     $strErrorHeader = 'HTTP/1.1 401 Unauthorized';
55 55
                 }
56 56
             } catch (Error $e) {
Please login to merge, or discard this patch.
pages/statistics.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -65,7 +65,7 @@
 block discarded – undo
65 65
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('statistics') === false) {
66 66
     // Not allowed page
67 67
     $session->set('system-error_code', ERR_NOT_ALLOWED);
68
-    include $SETTINGS['cpassman_dir'] . '/error.php';
68
+    include $SETTINGS['cpassman_dir'].'/error.php';
69 69
     exit;
70 70
 }
71 71
 
Please login to merge, or discard this patch.
pages/folders.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -66,7 +66,7 @@  discard block
 block discarded – undo
66 66
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('folders') === false) {
67 67
     // Not allowed page
68 68
     $session->set('system-error_code', ERR_NOT_ALLOWED);
69
-    include $SETTINGS['cpassman_dir'] . '/error.php';
69
+    include $SETTINGS['cpassman_dir'].'/error.php';
70 70
     exit;
71 71
 }
72 72
 
@@ -99,28 +99,28 @@  discard block
 block discarded – undo
99 99
 $complexityHtml = '<div id="hidden-select-complexity" class="hidden"><select id="select-complexity" class="form-control form-item-control save-me">';
100 100
 $complexitySelect = '';
101 101
 foreach (TP_PW_COMPLEXITY as $level) {
102
-    $complexitySelect .= '<option value="' . $level[0] . '">' . $level[1] . '</option>';
102
+    $complexitySelect .= '<option value="'.$level[0].'">'.$level[1].'</option>';
103 103
 }
104
-$complexityHtml .= $complexitySelect . '</select></div>';
104
+$complexityHtml .= $complexitySelect.'</select></div>';
105 105
 
106 106
 /* Get full tree structure */
107 107
 $tst = $tree->getDescendants();
108 108
 // prepare options list
109
-$droplist = '<option value="na">---' . $lang->get('select') . '---</option>';
109
+$droplist = '<option value="na">---'.$lang->get('select').'---</option>';
110 110
 if ((int) $session->get('user-admin') === 1 || (int) $session->get('user-manager') === 1 || (int) $session->get('user-can_create_root_folder') === 1) {
111
-    $droplist .= '<option value="0">' . $lang->get('root') . '</option>';
111
+    $droplist .= '<option value="0">'.$lang->get('root').'</option>';
112 112
 }
113 113
 foreach ($tst as $t) {
114 114
     if (
115 115
         in_array($t->id, $session->get('user-accessible_folders')) === true
116 116
         && in_array($t->id, $session->get('user-personal_visible_folders')) === false
117 117
     ) {
118
-        $droplist .= '<option value="' . $t->id . '">' . addslashes($t->title);
118
+        $droplist .= '<option value="'.$t->id.'">'.addslashes($t->title);
119 119
         $text = '';
120 120
         foreach ($tree->getPath($t->id, false) as $fld) {
121
-            $text .= empty($text) === true ? '     [' . $fld->title : ' > ' . $fld->title;
121
+            $text .= empty($text) === true ? '     ['.$fld->title : ' > '.$fld->title;
122 122
         }
123
-        $droplist .= (empty($text) === true ? '' : $text . '</i>]') . '</option>';
123
+        $droplist .= (empty($text) === true ? '' : $text.'</i>]').'</option>';
124 124
     }
125 125
 }
126 126
 
@@ -199,14 +199,14 @@  discard block
 block discarded – undo
199 199
                                     <label><?php echo $lang->get('icon'); ?></label>
200 200
                                     <input type="text" class="form-control form-folder-control purify" id="new-folder-add-icon" data-field="icon">
201 201
                                     <small class='form-text text-muted'>
202
-                                        <?php echo $lang->get('fontawesome_icon_tip'); ?><a href="<?php echo FONTAWESOME_URL;?>" target="_blank"><i class="fas fa-external-link-alt ml-1"></i></a>
202
+                                        <?php echo $lang->get('fontawesome_icon_tip'); ?><a href="<?php echo FONTAWESOME_URL; ?>" target="_blank"><i class="fas fa-external-link-alt ml-1"></i></a>
203 203
                                     </small>
204 204
                                 </div>
205 205
                                 <div class="form-group">
206 206
                                     <label><?php echo $lang->get('icon_on_selection'); ?></label>
207 207
                                     <input type="text" class="form-control form-folder-control purify" id="new-folder-add-icon-selected" data-field="iconSelected">
208 208
                                     <small class='form-text text-muted'>
209
-                                        <?php echo $lang->get('fontawesome_icon_tip'); ?><a href="<?php echo FONTAWESOME_URL;?>" target="_blank"><i class="fas fa-external-link-alt ml-1"></i></a>
209
+                                        <?php echo $lang->get('fontawesome_icon_tip'); ?><a href="<?php echo FONTAWESOME_URL; ?>" target="_blank"><i class="fas fa-external-link-alt ml-1"></i></a>
210 210
                                     </small>
211 211
                                 </div>
212 212
                                 <div class="form-group">
@@ -297,7 +297,7 @@  discard block
 block discarded – undo
297 297
                                 <th scope="col" min-width="200px"><?php echo $lang->get('group'); ?></th>
298 298
                                 <th scope="col" min-width="200px"><?php echo $lang->get('group_parent'); ?></th>
299 299
                                 <th scope="col" width="50px"><i class="fas fa-gavel fa-lg infotip" title="<?php echo $lang->get('password_strength'); ?>"></i></th>
300
-                                <th scope="col" width="50px"><i class="fas fa-recycle fa-lg infotip" title="<?php echo $lang->get('group_pw_duration') . ' ' . $lang->get('group_pw_duration_tip'); ?>"></i></th>
300
+                                <th scope="col" width="50px"><i class="fas fa-recycle fa-lg infotip" title="<?php echo $lang->get('group_pw_duration').' '.$lang->get('group_pw_duration_tip'); ?>"></i></th>
301 301
                                 <th scope="col" width="50px"><i class="fas fa-pen fa-lg infotip" title="<?php echo $lang->get('auth_creation_without_complexity'); ?>"></i></th>
302 302
                                 <th scope="col" width="50px"><i class="fas fa-edit fa-lg infotip" title="<?php echo $lang->get('auth_modification_without_complexity'); ?>"></i></th>
303 303
                                 <th scope="col" width="50px"><i class="fas fa-folder fa-lg infotip" title="<?php echo $lang->get('icon'); ?>"></i></th>
Please login to merge, or discard this patch.
pages/2fa.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -65,7 +65,7 @@  discard block
 block discarded – undo
65 65
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('mfa') === false) {
66 66
     // Not allowed page
67 67
     $session->set('system-error_code', ERR_NOT_ALLOWED);
68
-    include $SETTINGS['cpassman_dir'] . '/error.php';
68
+    include $SETTINGS['cpassman_dir'].'/error.php';
69 69
     exit;
70 70
 }
71 71
 
@@ -141,7 +141,7 @@  discard block
 block discarded – undo
141 141
                                     );
142 142
                                     foreach ($roles as $role) {
143 143
                                         echo '
144
-                                    <option value="' . $role['id'] . '"', in_array($role['id'], $arrRolesMFA) === true ? ' selected' : '', '>' . addslashes($role['title']) . '</option>';
144
+                                    <option value="' . $role['id'].'"', in_array($role['id'], $arrRolesMFA) === true ? ' selected' : '', '>'.addslashes($role['title']).'</option>';
145 145
                                     }
146 146
                                     ?>
147 147
                                 </select>
Please login to merge, or discard this patch.
pages/users.js.php 1 patch
Spacing   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -70,7 +70,7 @@  discard block
 block discarded – undo
70 70
 if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('users') === false) {
71 71
     // Not allowed page
72 72
     $session->set('system-error_code', ERR_NOT_ALLOWED);
73
-    include $SETTINGS['cpassman_dir'] . '/error.php';
73
+    include $SETTINGS['cpassman_dir'].'/error.php';
74 74
     exit;
75 75
 }
76 76
 ?>
@@ -302,8 +302,8 @@  discard block
 block discarded – undo
302 302
         if (store.get('teampassApplication').formUserAction === "add_new_user") {
303 303
             var data = {
304 304
                 'receipt': $('#form-email').val(),
305
-                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code');?>',
306
-                'body': '<?php echo $lang->get('email_body_new_user');?>',
305
+                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code'); ?>',
306
+                'body': '<?php echo $lang->get('email_body_new_user'); ?>',
307 307
                 'pre_replace' : {
308 308
                     '#code#' : store.get('teampassUser').admin_new_user_temporary_encryption_code,
309 309
                     '#login#' : store.get('teampassUser').admin_new_user_login,
@@ -313,8 +313,8 @@  discard block
 block discarded – undo
313 313
         } else {
314 314
             var data = {
315 315
                 'receipt': $('#form-email').val(),
316
-                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code');?>',
317
-                'body': '<?php echo $lang->get('email_body_temporary_encryption_code');?>',
316
+                'subject': 'TEAMPASS - <?php echo $lang->get('temporary_encryption_code'); ?>',
317
+                'body': '<?php echo $lang->get('email_body_temporary_encryption_code'); ?>',
318 318
                 'pre_replace' : {
319 319
                     '#enc_code#' : store.get('teampassUser').admin_new_user_temporary_encryption_code,
320 320
                 }
@@ -567,14 +567,14 @@  discard block
 block discarded – undo
567 567
             }
568 568
             // Inform user
569 569
             $("#warningModalBody").html('<b><?php echo $lang->get('encryption_keys'); ?> - ' +
570
-                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH;?>) + ']<span id="warningModalBody_extra">' + $nbItemsToConvert + '</span> ' +
570
+                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH; ?>) + ']<span id="warningModalBody_extra">' + $nbItemsToConvert + '</span> ' +
571 571
                 '... <?php echo $lang->get('please_wait'); ?><i class="fas fa-spinner fa-pulse ml-3 text-primary"></i>');
572 572
 
573 573
             // If expected, show the OPT to the admin
574 574
             if (constVisibleOTP === true) {
575 575
                 toastr.info(
576
-                    '<?php echo $lang->get('show_encryption_code_to_admin');?> <div><input class="form-control form-item-control flex-nowrap" value="' + userTemporaryCode + '" readonly></div>'
577
-                    + '<br /><button type="button" class="btn clear"><?php echo $lang->get('close');?></button>',
576
+                    '<?php echo $lang->get('show_encryption_code_to_admin'); ?> <div><input class="form-control form-item-control flex-nowrap" value="' + userTemporaryCode + '" readonly></div>'
577
+                    + '<br /><button type="button" class="btn clear"><?php echo $lang->get('close'); ?></button>',
578 578
                     '<?php echo $lang->get('information'); ?>',
579 579
                     {
580 580
                         extendedTimeOut: 0,
@@ -593,7 +593,7 @@  discard block
 block discarded – undo
593 593
             var data = {
594 594
                 action: step,
595 595
                 start: start,
596
-                length: <?php echo NUMBER_ITEMS_IN_BATCH;?>,
596
+                length: <?php echo NUMBER_ITEMS_IN_BATCH; ?>,
597 597
                 user_id: userId,
598 598
             }
599 599
             if (debugJavascript === true) {
@@ -1401,7 +1401,7 @@  discard block
 block discarded – undo
1401 1401
                         } else {
1402 1402
                             // Show icon or not
1403 1403
                             if ($('#user-disabled').prop('checked') === true) {
1404
-                                $('#user-login-'+userID).before('<i class="fas fa-user-slash infotip text-danger mr-2" title="<?php echo $lang->get('account_is_locked');?>" id="user-disable-'+userID+'"></i>');
1404
+                                $('#user-login-'+userID).before('<i class="fas fa-user-slash infotip text-danger mr-2" title="<?php echo $lang->get('account_is_locked'); ?>" id="user-disable-'+userID+'"></i>');
1405 1405
                             } else {
1406 1406
                                 $('#user-disable-'+userID).remove();
1407 1407
                             }
Please login to merge, or discard this patch.