nilsteampassnet / TeamPass

api/Model/ItemModel.php

Spacing +17 added lines, -17 removed lines

@@ -51,19 +51,19 @@ 
         $rows = DB::query(
             'SELECT i.id, label, description, i.pw, i.url, i.id_tree, i.login, i.email, i.viewed_no, i.fa_icon, i.inactif, i.perso,
             t.title as folder_label, io.secret as otp_secret
-            FROM ' . prefixTable('items') . ' AS i
+            FROM ' . prefixTable('items').' AS i
             LEFT JOIN '.prefixTable('nested_tree').' as t ON (t.id = i.id_tree) 
             LEFT JOIN '.prefixTable('items_otp').' as io ON (io.item_id = i.id) '.
-            $sqlExtra . 
-            " ORDER BY i.id ASC" .
-            ($limit > 0 ? " LIMIT ". $limit : '')
+            $sqlExtra. 
+            " ORDER BY i.id ASC".
+            ($limit > 0 ? " LIMIT ".$limit : '')
         );
 
         $ret = [];
         foreach ($rows as $row) {
             $userKey = DB::queryfirstrow(
                 'SELECT share_key
-                FROM ' . prefixTable('sharekeys_items') . '
+                FROM ' . prefixTable('sharekeys_items').'
                 WHERE user_id = %i AND object_id = %i',
                 $userId,
                 $row['id']
@@ -100,7 +100,7 @@ 
                 if (empty($path) === true) {
                     $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
                 } else {
-                    $path .= '/' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
+                    $path .= '/'.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES);
                 }
             }
 
@@ -162,7 +162,7 @@ 
     ) : array
     {
         try {
-            include_once API_ROOT_PATH . '/../sources/main.functions.php';
+            include_once API_ROOT_PATH.'/../sources/main.functions.php';
 
             // Load config
             $configManager = new ConfigManager();
@@ -288,7 +288,7 @@ 
         }
 
         if (strlen($password) > $SETTINGS['pwd_maximum_length']) {
-            throw new Exception('Password is too long (max allowed is ' . $SETTINGS['pwd_maximum_length'] . ' characters)');
+            throw new Exception('Password is too long (max allowed is '.$SETTINGS['pwd_maximum_length'].' characters)');
         }
     }
 
@@ -301,7 +301,7 @@ 
     {
         $dataFolderSettings = DB::queryFirstRow(
             'SELECT bloquer_creation, bloquer_modification, personal_folder
-            FROM ' . prefixTable('nested_tree') . ' 
+            FROM ' . prefixTable('nested_tree').' 
             WHERE id = %i',
             $folderId
         );
@@ -324,7 +324,7 @@ 
     {
         $folderComplexity = DB::queryFirstRow(
             'SELECT valeur
-            FROM ' . prefixTable('misc') . '
+            FROM ' . prefixTable('misc').'
             WHERE type = %s AND intitule = %i',
             'complex',
             $itemInfos['folderId']
@@ -352,7 +352,7 @@ 
     private function checkForDuplicates(string $label, array $SETTINGS, array $itemInfos) : void
     {
         DB::queryFirstRow(
-            'SELECT * FROM ' . prefixTable('items') . '
+            'SELECT * FROM '.prefixTable('items').'
             WHERE label = %s AND inactif = %i',
             $label,
             0
@@ -390,7 +390,7 @@ 
      */
     private function insertNewItem(array $data, string $password, array $itemInfos) : int
     {
-        include_once API_ROOT_PATH . '/../sources/main.functions.php';
+        include_once API_ROOT_PATH.'/../sources/main.functions.php';
 
         DB::insert(
             prefixTable('items'),
@@ -556,7 +556,7 @@ 
     ): array
     {
         try {
-            include_once API_ROOT_PATH . '/../sources/main.functions.php';
+            include_once API_ROOT_PATH.'/../sources/main.functions.php';
 
             // Load config
             $configManager = new ConfigManager();
@@ -564,7 +564,7 @@ 
 
             // Load current item data
             $currentItem = DB::queryFirstRow(
-                'SELECT * FROM ' . prefixTable('items') . ' WHERE id = %i',
+                'SELECT * FROM '.prefixTable('items').' WHERE id = %i',
                 $itemId
             );
 
@@ -640,7 +640,7 @@ 
                 if (strlen($newPassword) > $SETTINGS['pwd_maximum_length']) {
                     return [
                         'error' => true,
-                        'error_message' => 'Password is too long (max allowed is ' . $SETTINGS['pwd_maximum_length'] . ' characters)',
+                        'error_message' => 'Password is too long (max allowed is '.$SETTINGS['pwd_maximum_length'].' characters)',
                         'error_header' => 'HTTP/1.1 400 Bad Request',
                     ];
                 }
@@ -763,7 +763,7 @@ 
     ): array
     {
         try {
-            include_once API_ROOT_PATH . '/../sources/main.functions.php';
+            include_once API_ROOT_PATH.'/../sources/main.functions.php';
 
             // Load config
             $configManager = new ConfigManager();
@@ -771,7 +771,7 @@ 
 
             // Load current item data
             $currentItem = DB::queryFirstRow(
-                'SELECT * FROM ' . prefixTable('items') . ' WHERE id = %i',
+                'SELECT * FROM '.prefixTable('items').' WHERE id = %i',
                 $itemId
             );
 

api/Controller/Api/ItemController.php

Spacing +24 added lines, -24 removed lines

@@ -40,11 +40,11 @@ 
      */
     private function getUserPrivateKey(array $userData): ?string
     {
-        include_once API_ROOT_PATH . '/inc/jwt_utils.php';
+        include_once API_ROOT_PATH.'/inc/jwt_utils.php';
 
         // Verify session_key exists in JWT payload
         if (!isset($userData['session_key']) || empty($userData['session_key'])) {
-            error_log('getUserPrivateKey: Missing session_key in JWT token for user ID ' . $userData['id']);
+            error_log('getUserPrivateKey: Missing session_key in JWT token for user ID '.$userData['id']);
             return null;
         }
 
@@ -88,7 +88,7 @@ 
             // SQL where clause with folders list
             if (isset($arrQueryStringParams['folders']) === true) {
                 // convert the folders to an array
-                $arrQueryStringParams['folders'] = explode(',', str_replace( array('[',']') , ''  , $arrQueryStringParams['folders']));
+                $arrQueryStringParams['folders'] = explode(',', str_replace(array('[', ']'), '', $arrQueryStringParams['folders']));
 
                 // ensure to only use the intersection
                 $foldersList = implode(',', array_intersect($arrQueryStringParams['folders'], $userData['folders_list']));
@@ -243,7 +243,7 @@ 
                             (string) $arrQueryStringParams['description'] ?? '',
                             (string) $arrQueryStringParams['login'],
                             (string) $arrQueryStringParams['email'] ?? '',
-                            (string) $arrQueryStringParams['url'] ?? '' ,
+                            (string) $arrQueryStringParams['url'] ?? '',
                             (string) $arrQueryStringParams['tags'] ?? '',
                             (int) $arrQueryStringParams['anyone_can_modify'] ?? 0,
                             (string) $arrQueryStringParams['icon'] ?? '',
@@ -257,7 +257,7 @@ 
                 } else {
                     // Gérer le cas où les paramètres ne sont pas un tableau
                     $strErrorDesc = 'Data not consistent';
-                    $strErrorHeader = 'Expected array, received ' . gettype($arrQueryStringParams);
+                    $strErrorHeader = 'Expected array, received '.gettype($arrQueryStringParams);
                 }
             }
         } else {
@@ -308,10 +308,10 @@ 
             // SQL where clause with item id
             if (isset($arrQueryStringParams['id']) === true) {
                 // build sql where clause by ID
-                $sqlExtra = ' WHERE i.id = '.$arrQueryStringParams['id'] . $sql_constraint;
+                $sqlExtra = ' WHERE i.id = '.$arrQueryStringParams['id'].$sql_constraint;
             } else if (isset($arrQueryStringParams['label']) === true) {
                 // build sql where clause by LABEL
-                $sqlExtra = ' WHERE i.label '.(isset($arrQueryStringParams['like']) === true && (int) $arrQueryStringParams['like'] === 1 ? ' LIKE '.$arrQueryStringParams['label'] : ' = '.$arrQueryStringParams['label']) . $sql_constraint;
+                $sqlExtra = ' WHERE i.label '.(isset($arrQueryStringParams['like']) === true && (int) $arrQueryStringParams['like'] === 1 ? ' LIKE '.$arrQueryStringParams['label'] : ' = '.$arrQueryStringParams['label']).$sql_constraint;
             } else if (isset($arrQueryStringParams['description']) === true) {
                 // build sql where clause by LABEL
                 $sqlExtra = ' WHERE i.description '.(isset($arrQueryStringParams['like']) === true && (int) $arrQueryStringParams['like'] === 1 ? ' LIKE '.$arrQueryStringParams['description'] : ' = '.$arrQueryStringParams['description']).$sql_constraint;
@@ -394,9 +394,9 @@ 
             }*/
 
             // Build SQL constraint for accessible folders
-            $sql_constraint = ' AND (i.id_tree IN (' . $userData['folders_list'] . ')';
+            $sql_constraint = ' AND (i.id_tree IN ('.$userData['folders_list'].')';
             if (!empty($userData['restricted_items_list'])) {
-                $sql_constraint .= ' OR i.id IN (' . $userData['restricted_items_list'] . ')';
+                $sql_constraint .= ' OR i.id IN ('.$userData['restricted_items_list'].')';
             }
             $sql_constraint .= ')';
 
@@ -414,9 +414,9 @@ 
                     $rows = DB::query(
                         "SELECT i.id, i.label, i.login, i.url, i.id_tree, 
                                 CASE WHEN o.enabled = 1 THEN 1 ELSE 0 END AS has_otp
-                        FROM " . prefixTable('items') . " AS i
-                        LEFT JOIN " . prefixTable('items_otp') . " AS o ON (o.item_id = i.id)
-                        WHERE i.url LIKE %s" . $sql_constraint . "
+                        FROM " . prefixTable('items')." AS i
+                        LEFT JOIN " . prefixTable('items_otp')." AS o ON (o.item_id = i.id)
+                        WHERE i.url LIKE %s" . $sql_constraint."
                             AND i.deleted_at IS NULL
                         ORDER BY i.label ASC",
                         "%".$searchUrl."%"
@@ -427,7 +427,7 @@ 
                         // Get user's sharekey for this item
                         $shareKey = DB::queryfirstrow(
                             'SELECT share_key
-                            FROM ' . prefixTable('sharekeys_items') . '
+                            FROM ' . prefixTable('sharekeys_items').'
                             WHERE user_id = %i AND object_id = %i',
                             $userData['id'],
                             $row['id']
@@ -460,7 +460,7 @@ 
                     }
                 }
             } catch (Error $e) {
-                $strErrorDesc = $e->getMessage() . '. Something went wrong! Please contact support.';
+                $strErrorDesc = $e->getMessage().'. Something went wrong! Please contact support.';
                 $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
             }
         } else {
@@ -520,7 +520,7 @@ 
 
                 // Load item basic info to check folder access
                 $itemInfo = DB::queryFirstRow(
-                    'SELECT id_tree FROM ' . prefixTable('items') . ' WHERE id = %i',
+                    'SELECT id_tree FROM '.prefixTable('items').' WHERE id = %i',
                     $itemId
                 );
 
@@ -544,7 +544,7 @@ 
                     } else {
                         // Load OTP data
                         $otpData = DB::queryFirstRow(
-                            'SELECT secret, enabled FROM ' . prefixTable('items_otp') . ' WHERE item_id = %i',
+                            'SELECT secret, enabled FROM '.prefixTable('items_otp').' WHERE item_id = %i',
                             $itemId
                         );
 
@@ -575,7 +575,7 @@ 
                                         'item_id' => $itemId
                                     ]);
                                 } catch (\RuntimeException $e) {
-                                    $strErrorDesc = 'Failed to generate OTP code: ' . $e->getMessage();
+                                    $strErrorDesc = 'Failed to generate OTP code: '.$e->getMessage();
                                     $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
                                 }
                             } else {
@@ -586,7 +586,7 @@ 
                     }
                 }
             } catch (\Error $e) {
-                $strErrorDesc = $e->getMessage() . '. Something went wrong! Please contact support.';
+                $strErrorDesc = $e->getMessage().'. Something went wrong! Please contact support.';
                 $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
             }
         } else {
@@ -651,7 +651,7 @@ 
                         try {
                             // Load item info to check access rights
                             $itemInfo = DB::queryFirstRow(
-                                'SELECT id, id_tree, label FROM ' . prefixTable('items') . ' WHERE id = %i',
+                                'SELECT id, id_tree, label FROM '.prefixTable('items').' WHERE id = %i',
                                 $itemId
                             );
 
@@ -712,13 +712,13 @@ 
                                 }
                             }
                         } catch (Error $e) {
-                            $strErrorDesc = $e->getMessage() . '. Something went wrong! Please contact support.';
+                            $strErrorDesc = $e->getMessage().'. Something went wrong! Please contact support.';
                             $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
                         }
                     }
                 } else {
                     $strErrorDesc = 'Data not consistent';
-                    $strErrorHeader = 'HTTP/1.1 400 Bad Request - Expected array, received ' . gettype($arrQueryStringParams);
+                    $strErrorHeader = 'HTTP/1.1 400 Bad Request - Expected array, received '.gettype($arrQueryStringParams);
                 }
             }
         } else {
@@ -776,7 +776,7 @@ 
                         try {
                             // Load item info to check access rights
                             $itemInfo = DB::queryFirstRow(
-                                'SELECT id, id_tree, label FROM ' . prefixTable('items') . ' WHERE id = %i',
+                                'SELECT id, id_tree, label FROM '.prefixTable('items').' WHERE id = %i',
                                 $itemId
                             );
 
@@ -814,13 +814,13 @@ 
                                 }
                             }
                         } catch (Error $e) {
-                            $strErrorDesc = $e->getMessage() . '. Something went wrong! Please contact support.';
+                            $strErrorDesc = $e->getMessage().'. Something went wrong! Please contact support.';
                             $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
                         }
                     }
                 } else {
                     $strErrorDesc = 'Data not consistent';
-                    $strErrorHeader = 'HTTP/1.1 400 Bad Request - Expected array, received ' . gettype($arrQueryStringParams);
+                    $strErrorHeader = 'HTTP/1.1 400 Bad Request - Expected array, received '.gettype($arrQueryStringParams);
                 }
             }
         } else {

api/Controller/Api/FolderController.php

Spacing +5 added lines, -5 removed lines

@@ -48,7 +48,7 @@ 
                     $arrFolders = $folderModel->getFoldersInfo(explode(",", $userData['folders_list']));
                     $responseData = json_encode($arrFolders);
                 } catch (Error $e) {
-                    $strErrorDesc = $e->getMessage() . ' Something went wrong! Please contact support.3';
+                    $strErrorDesc = $e->getMessage().' Something went wrong! Please contact support.3';
                     $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
                 }
             }
@@ -118,7 +118,7 @@ 
                         
                         $responseData = json_encode($arrFolder);
                     } catch (Error $e) {
-                        $strErrorDesc = $e->getMessage() . ' Something went wrong! Please contact support.1';
+                        $strErrorDesc = $e->getMessage().' Something went wrong! Please contact support.1';
                         $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
                     }
                 }
@@ -159,8 +159,8 @@ 
                 $userFolders = !empty($userData['folders_list']) ? explode(',', $userData['folders_list']) : [];
                 $rows = DB::query(
                     'SELECT nt.id AS folder_id, nt.title, nt.nlevel, nt.parent_id
-                    FROM ' . prefixTable('nested_tree') . ' AS nt
-                    LEFT JOIN ' . prefixTable('nested_tree') . ' AS personal 
+                    FROM ' . prefixTable('nested_tree').' AS nt
+                    LEFT JOIN ' . prefixTable('nested_tree').' AS personal 
                         ON personal.personal_folder = 1 
                         AND personal.title = %s
                     WHERE nt.id IN %li
@@ -194,7 +194,7 @@ 
                 $responseData = json_encode($writableFolders);
 
             } catch (Error $e) {
-                $strErrorDesc = $e->getMessage() . ' Something went wrong! Please contact support.';
+                $strErrorDesc = $e->getMessage().' Something went wrong! Please contact support.';
                 $strErrorHeader = 'HTTP/1.1 500 Internal Server Error';
             }
         } else {