| @@ -138,9 +138,9 @@ | ||
| 138 | 138 | $page_id, |
| 139 | 139 | ) |
| 140 | 140 | ); |
| 141 | 141 | |
| 142 | - $project_page = $wpdb->get_results( $query, 'ARRAY_A' ); // phpcs:ignore WordPress.DB.PreparedSQL | |
| 142 | + $project_page = $wpdb->get_results( $query, 'ARRAY_A' ); // phpcs:ignore WordPress.DB.PreparedSQL, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 143 | 143 | if ( 0 === $wpdb->num_rows ) { |
| 144 | 144 | return; |
| 145 | 145 | } |
| 146 | 146 | |
| @@ -171,9 +171,9 @@ | ||
| 171 | 171 | foreach ( $parent_primary_key as $pk ) { |
| 172 | 172 | if ( isset( $relationships['table'] ) && null !== $relationships['table'] ) { |
| 173 | 173 | foreach ( $relationships['table'] as $column ) { |
| 174 | 174 | if ( $column->column_name === $pk ) { |
| 175 | - array_push( $parent_primary_key_data_type, WPDA::get_type( $column->data_type ) );//phpcs:ignore - 8.1 proof | |
| 175 | + array_push( $parent_primary_key_data_type, WPDA::get_type( $column->data_type ) ); // phpcs:ignore -- 8.1 proof | |
| 176 | 176 | break; |
| 177 | 177 | } |
| 178 | 178 | } |
| 179 | 179 | } |
| @@ -193,12 +193,12 @@ | ||
| 193 | 193 | } |
| 194 | 194 | |
| 195 | 195 | foreach ( $relationship->source_column_name as $source_column_name ) { |
| 196 | 196 | if ( ! in_array( $source_column_name, $parent_primary_key ) ) { |
| 197 | - array_push( $parent_primary_key, $source_column_name );//phpcs:ignore - 8.1 proof | |
| 197 | + array_push( $parent_primary_key, $source_column_name ); // phpcs:ignore -- 8.1 proof | |
| 198 | 198 | foreach ( $relationships['table'] as $column ) { |
| 199 | 199 | if ( $column->column_name === $source_column_name ) { |
| 200 | - array_push( $parent_primary_key_data_type, WPDA::get_type( $column->data_type ) );//phpcs:ignore - 8.1 proof | |
| 200 | + array_push( $parent_primary_key_data_type, WPDA::get_type( $column->data_type ) ); // phpcs:ignore -- 8.1 proof | |
| 201 | 201 | break; |
| 202 | 202 | } |
| 203 | 203 | } |
| 204 | 204 | } |
| @@ -206,9 +206,9 @@ | ||
| 206 | 206 | |
| 207 | 207 | foreach ( $relationship->target_column_name as $target_column_name ) { |
| 208 | 208 | foreach ( $relationships['table'] as $column ) { |
| 209 | 209 | if ( $column->column_name === $target_column_name ) { |
| 210 | - array_push( $child_key_data_type, WPDA::get_type( $column->data_type ) );//phpcs:ignore - 8.1 proof | |
| 210 | + array_push( $child_key_data_type, WPDA::get_type( $column->data_type ) ); // phpcs:ignore -- 8.1 proof | |
| 211 | 211 | break; |
| 212 | 212 | } |
| 213 | 213 | } |
| 214 | 214 | } |
| @@ -223,9 +223,9 @@ | ||
| 223 | 223 | 'child_key' => $relationship->target_column_name, |
| 224 | 224 | 'data_type' => $child_key_data_type, |
| 225 | 225 | ), |
| 226 | 226 | ); |
| 227 | - array_push( $children, $child );//phpcs:ignore - 8.1 proof | |
| 227 | + array_push( $children, $child ); // phpcs:ignore -- 8.1 proof | |
| 228 | 228 | } elseif ( 'nm' === $relationship->relation_type ) { |
| 229 | 229 | $nm_relationships = WPDP_Project_Design_Table_Model::get_column_options( $relationship->relation_table_name, 'relationships', $page_setname, $schema_name ); |
| 230 | 230 | |
| 231 | 231 | if ( isset( $nm_relationships['tableinfo'] ) && isset( $nm_relationships['tableinfo']->tab_label ) ) { |
| @@ -246,12 +246,12 @@ | ||
| 246 | 246 | if ( null !== $nm_relationship_found ) { |
| 247 | 247 | foreach ( $nm_relationship_found->source_column_name as $source_column_name ) { |
| 248 | 248 | foreach ( $nm_relationships['table'] as $column ) { |
| 249 | 249 | if ( $column->column_name === $source_column_name ) { |
| 250 | - array_push( $child_key_data_type, WPDA::get_type( $column->data_type ) );//phpcs:ignore - 8.1 proof | |
| 251 | - if ( ! in_array( $source_column_name, $parent_primary_key ) ) {//phpcs:ignore - 8.1 proof | |
| 252 | - array_push( $parent_primary_key, $source_column_name );//phpcs:ignore - 8.1 proof | |
| 253 | - array_push( $parent_primary_key_data_type, WPDA::get_type( $column->data_type ) );//phpcs:ignore - 8.1 proof | |
| 250 | + array_push( $child_key_data_type, WPDA::get_type( $column->data_type ) ); // phpcs:ignore -- 8.1 proof | |
| 251 | + if ( ! in_array( $source_column_name, $parent_primary_key ) ) { // phpcs:ignore -- 8.1 proof | |
| 252 | + array_push( $parent_primary_key, $source_column_name ); // phpcs:ignore -- 8.1 proof | |
| 253 | + array_push( $parent_primary_key_data_type, WPDA::get_type( $column->data_type ) ); // phpcs:ignore -- 8.1 proof | |
| 254 | 254 | } |
| 255 | 255 | break; |
| 256 | 256 | } |
| 257 | 257 | } |
| @@ -269,9 +269,9 @@ | ||
| 269 | 269 | 'child_table_where' => $relationship->target_column_name, |
| 270 | 270 | 'data_type' => $child_key_data_type, |
| 271 | 271 | ), |
| 272 | 272 | ); |
| 273 | - array_push( $children, $child );//phpcs:ignore - 8.1 proof | |
| 273 | + array_push( $children, $child ); // phpcs:ignore -- 8.1 proof | |
| 274 | 274 | } |
| 275 | 275 | } |
| 276 | 276 | } |
| 277 | 277 | } |
