PluginProbe
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards / 5.5.84
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards v5.5.84
5.5.84 5.5.83 5.5.82 5.5.81 5.5.80 5.5.79 5.5.77 5.5.76 5.5.75 5.5.73 5.5.72 5.5.22 5.5.23 5.5.29 5.5.3 5.5.31 5.5.32 5.5.34 5.5.35 5.5.36 5.5.37 5.5.4 5.5.40 5.5.41 5.5.42 All 160 releases
← All changes | WPDataAccess/Plugin_Table_Models/WPDA_App_Container_Model.php +103 -66 5.5.22 → 5.5.84 View file →
@@ -8,58 +8,50 @@
8 8
9 9 public static function select( $app_id, $cnt_seq_nr ) {
10 10 global $wpdb;
11 11 if ( 0 === $cnt_seq_nr ) {
12 - return $wpdb->get_results(
13 - $wpdb->prepare(
14 - 'SELECT * FROM `%1s` WHERE app_id = %d and cnt_seq_nr = 0 order by cnt_id',
15 - // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
16 - array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id)
17 - ),
12 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
13 + $dataset = $wpdb->get_results(
14 + $wpdb->prepare( 'SELECT * FROM `%1s` WHERE app_id = %d and cnt_seq_nr = 0 order by cnt_id', array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id) ),
18 15 // db call ok; no-cache ok.
19 16 'ARRAY_A'
20 17 );
21 - // phpcs:ignore Standard.Category.SniffName.ErrorCode
18 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
19 + return $dataset;
22 20 } else {
23 - return $wpdb->get_results(
24 - $wpdb->prepare(
25 - 'SELECT * FROM `%1s` WHERE app_id = %d and cnt_seq_nr > 0 order by cnt_seq_nr, cnt_id',
26 - // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
27 - array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id)
28 - ),
21 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
22 + $dataset = $wpdb->get_results(
23 + $wpdb->prepare( 'SELECT * FROM `%1s` WHERE app_id = %d and cnt_seq_nr > 0 order by cnt_seq_nr, cnt_id', array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id) ),
29 24 // db call ok; no-cache ok.
30 25 'ARRAY_A'
31 26 );
32 - // phpcs:ignore Standard.Category.SniffName.ErrorCode
27 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
28 + return $dataset;
33 29 }
34 30 }
35 31
36 32 public static function select_all( $app_id ) {
37 33 global $wpdb;
38 - return $wpdb->get_results(
39 - $wpdb->prepare(
40 - 'SELECT * FROM `%1s` WHERE app_id = %d order by cnt_seq_nr',
41 - // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
42 - array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id)
43 - ),
34 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
35 + $dataset = $wpdb->get_results(
36 + $wpdb->prepare( 'SELECT * FROM `%1s` WHERE app_id = %d order by cnt_seq_nr', array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id) ),
44 37 // db call ok; no-cache ok.
45 38 'ARRAY_A'
46 39 );
47 - // phpcs:ignore Standard.Category.SniffName.ErrorCode
40 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
41 + return $dataset;
48 42 }
49 43
50 - public static function get_container( $cnt_id ) {
44 + public static function get_container( $app_id, $cnt_id ) {
51 45 global $wpdb;
52 - return $wpdb->get_results(
53 - $wpdb->prepare(
54 - 'SELECT * FROM `%1s` WHERE cnt_id = %d',
55 - // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
56 - array(WPDA::remove_backticks( self::get_base_table_name() ), $cnt_id)
57 - ),
46 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
47 + $dataset = $wpdb->get_results(
48 + $wpdb->prepare( 'SELECT * FROM `%1s` WHERE app_id = %d AND cnt_id = %d', array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id, $cnt_id) ),
58 49 // db call ok; no-cache ok.
59 50 'ARRAY_A'
60 51 );
61 - // phpcs:ignore Standard.Category.SniffName.ErrorCode
52 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
53 + return $dataset;
62 54 }
63 55
64 56 public static function create(
65 57 $app_id,
@@ -73,23 +65,21 @@
73 65 $cnt_query = null
74 66 ) {
75 67 global $wpdb;
76 68 if ( 1 === $cnt_seq_nr ) {
69 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
77 70 $max_seq_nr = $wpdb->get_results(
78 - $wpdb->prepare(
79 - 'SELECT max(cnt_seq_nr) FROM `%1s` WHERE app_id = %d',
80 - // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
81 - array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id)
82 - ),
71 + $wpdb->prepare( 'SELECT max(cnt_seq_nr) FROM `%1s` WHERE app_id = %d', array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id) ),
83 72 // db call ok; no-cache ok.
84 73 'ARRAY_N'
85 74 );
86 - // phpcs:ignore Standard.Category.SniffName.ErrorCode
75 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
87 76 if ( isset( $max_seq_nr[0][0] ) ) {
88 77 $cnt_seq_nr = $max_seq_nr[0][0] + 1;
89 78 }
90 79 }
91 - if ( 1 === $wpdb->insert( static::get_base_table_name(), array(
80 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- plugin table
81 + $rows = $wpdb->insert( static::get_base_table_name(), array(
92 82 'cnt_dbs' => $app_dbs,
93 83 'cnt_tbl' => $app_tbl,
94 84 'cnt_cls' => $app_cls,
95 85 'cnt_title' => $cnt_title,
@@ -97,9 +87,11 @@
97 87 'cnt_seq_nr' => $cnt_seq_nr,
98 88 'cnt_table' => $cnt_table,
99 89 'cnt_relation' => $cnt_relation,
100 90 'cnt_query' => $cnt_query,
101 - ) ) ) {
91 + ) );
92 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery
93 + if ( 1 === $rows ) {
102 94 // Return new container
103 95 $cnt_id = $wpdb->insert_id;
104 96 return array(
105 97 'cnt_id' => $wpdb->insert_id,
@@ -122,8 +114,9 @@
122 114 $cnt_title,
123 115 $cnt_relation = null
124 116 ) {
125 117 global $wpdb;
118 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
126 119 $wpdb->update( static::get_base_table_name(), array(
127 120 'cnt_dbs' => $app_dbs,
128 121 'cnt_tbl' => $app_tbl,
129 122 'cnt_cls' => $app_cls,
@@ -132,23 +125,30 @@
132 125 ), array(
133 126 'app_id' => $app_id,
134 127 'cnt_id' => $app_cnt,
135 128 ) );
129 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
136 130 return $wpdb->last_error;
137 131 }
138 132
139 133 public static function delete( $app_id ) {
140 134 global $wpdb;
141 - return $wpdb->delete( static::get_base_table_name(), array(
135 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
136 + $delete = $wpdb->delete( static::get_base_table_name(), array(
142 137 'app_id' => $app_id,
143 138 ) );
139 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
140 + return $delete;
144 141 }
145 142
146 143 public static function delete_container( $cnt_id ) {
147 144 global $wpdb;
148 - return $wpdb->delete( static::get_base_table_name(), array(
145 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
146 + $delete = $wpdb->delete( static::get_base_table_name(), array(
149 147 'cnt_id' => $cnt_id,
150 148 ) );
149 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
150 + return $delete;
151 151 }
152 152
153 153 public static function update_master(
154 154 $app_id,
@@ -157,8 +157,9 @@
157 157 $app_cls,
158 158 $app_query
159 159 ) {
160 160 global $wpdb;
161 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
161 162 $wpdb->update( static::get_base_table_name(), array(
162 163 'cnt_dbs' => $app_dbs,
163 164 'cnt_tbl' => $app_tbl,
164 165 'cnt_cls' => $app_cls,
@@ -166,52 +167,85 @@
166 167 ), array(
167 168 'app_id' => $app_id,
168 169 'cnt_seq_nr' => 0,
169 170 ) );
171 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
170 172 return $wpdb->last_error;
171 173 }
172 174
173 175 public static function update_table_settings( $cnt_id, $cnt_table_settings ) {
174 176 global $wpdb;
177 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
175 178 $wpdb->update( static::get_base_table_name(), array(
176 179 'cnt_table' => $cnt_table_settings,
177 180 ), array(
178 181 'cnt_id' => $cnt_id,
179 182 ) );
183 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
180 184 return $wpdb->last_error;
181 185 }
182 186
183 187 public static function update_rform_settings( $cnt_id, $cnt_form_settings ) {
184 188 global $wpdb;
189 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
185 190 $wpdb->update( static::get_base_table_name(), array(
186 191 'cnt_rform' => $cnt_form_settings,
187 192 ), array(
188 193 'cnt_id' => $cnt_id,
189 194 ) );
195 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
190 196 return $wpdb->last_error;
191 197 }
192 198
193 199 public static function update_form_settings( $cnt_id, $cnt_form_settings ) {
194 200 global $wpdb;
201 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
195 202 $wpdb->update( static::get_base_table_name(), array(
196 203 'cnt_form' => $cnt_form_settings,
197 204 ), array(
198 205 'cnt_id' => $cnt_id,
199 206 ) );
207 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
200 208 return $wpdb->last_error;
201 209 }
202 210
203 211 public static function update_chart_settings( $cnt_id, $cnt_chart_settings ) {
204 212 global $wpdb;
213 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
205 214 $wpdb->update( static::get_base_table_name(), array(
206 215 'cnt_chart' => $cnt_chart_settings,
207 216 ), array(
208 217 'cnt_id' => $cnt_id,
209 218 ) );
219 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
210 220 return $wpdb->last_error;
211 221 }
212 222
213 - public static function container_move( $cnt_id_from, $cnt_id_to ) {
223 + public static function update_dashboard_settings( $cnt_id, $cnt_dashboard_settings ) {
224 + global $wpdb;
225 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
226 + $wpdb->update( static::get_base_table_name(), array(
227 + 'cnt_dashboard' => $cnt_dashboard_settings,
228 + ), array(
229 + 'cnt_id' => $cnt_id,
230 + ) );
231 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
232 + return $wpdb->last_error;
233 + }
234 +
235 + public static function update_map_settings( $cnt_id, $cnt_map_settings ) {
236 + global $wpdb;
237 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
238 + $wpdb->update( static::get_base_table_name(), array(
239 + 'cnt_map' => $cnt_map_settings,
240 + ), array(
241 + 'cnt_id' => $cnt_id,
242 + ) );
243 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
244 + return $wpdb->last_error;
245 + }
246 +
247 + public static function container_move( $app_id, $cnt_id_from, $cnt_id_to ) {
214 248 // This is a premium feature.
215 249 return '';
216 250 }
217 251
@@ -216,48 +250,51 @@
216 250 }
217 251
218 252 public static function copy( $app_id_old, $app_id_new ) {
219 253 global $wpdb;
254 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders -- plugin table
220 255 $containers = $wpdb->get_results(
221 - $wpdb->prepare(
222 - 'SELECT * FROM `%1s` WHERE app_id = %d order by cnt_seq_nr',
223 - // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
224 - array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id_old)
225 - ),
256 + $wpdb->prepare( 'SELECT * FROM `%1s` WHERE app_id = %d order by cnt_seq_nr', array(WPDA::remove_backticks( self::get_base_table_name() ), $app_id_old) ),
226 257 // db call ok; no-cache ok.
227 258 'ARRAY_A'
228 259 );
229 - // phpcs:ignore Standard.Category.SniffName.ErrorCode
260 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders
230 261 $cnt_id_conversion = array();
231 262 foreach ( $containers as $container ) {
232 263 $cnt_id = $container['cnt_id'];
233 264 $container['app_id'] = $app_id_new;
234 265 unset($container['cnt_id']);
266 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- plugin table
235 267 $wpdb->insert( static::get_base_table_name(), $container );
268 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery
236 269 $cnt_id_conversion[$cnt_id] = $wpdb->insert_id;
237 270 }
238 271 foreach ( $cnt_id_conversion as $cnt_id_old => $cnt_id_new ) {
239 - $container = self::get_container( $cnt_id_new );
240 - $relation = $container[0]['cnt_relation'];
241 - if ( null !== $relation && '' !== $relation ) {
242 - $json = json_decode( $relation, true );
243 - if ( isset( $json['cnt_id_master'] ) ) {
244 - $cnt_id_master_old = $json['cnt_id_master'];
245 - if ( isset( $cnt_id_conversion[$cnt_id_master_old] ) ) {
246 - // Update relationship master id
247 - $cnt_id_master_new = $cnt_id_conversion[$cnt_id_master_old];
248 - $json['cnt_id_master'] = strval( $cnt_id_master_new );
249 - $relation = json_encode( $json );
250 - } else {
251 - // Master no longer available
252 - $relation = null;
272 + $container = self::get_container( $app_id_new, $cnt_id_new );
273 + if ( isset( $container[0]['cnt_relation'] ) ) {
274 + $relation = $container[0]['cnt_relation'];
275 + if ( null !== $relation && '' !== $relation ) {
276 + $json = json_decode( $relation, true );
277 + if ( isset( $json['cnt_id_master'] ) ) {
278 + $cnt_id_master_old = $json['cnt_id_master'];
279 + if ( isset( $cnt_id_conversion[$cnt_id_master_old] ) ) {
280 + // Update relationship master id
281 + $cnt_id_master_new = $cnt_id_conversion[$cnt_id_master_old];
282 + $json['cnt_id_master'] = strval( $cnt_id_master_new );
283 + $relation = json_encode( $json );
284 + } else {
285 + // Master no longer available
286 + $relation = null;
287 + }
288 + // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table
289 + $wpdb->update( static::get_base_table_name(), array(
290 + 'cnt_relation' => $relation,
291 + ), array(
292 + 'app_id' => $app_id_new,
293 + 'cnt_id' => $cnt_id_new,
294 + ) );
295 + // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
253 296 }
254 - $wpdb->update( static::get_base_table_name(), array(
255 - 'cnt_relation' => $relation,
256 - ), array(
257 - 'app_id' => $app_id_new,
258 - 'cnt_id' => $cnt_id_new,
259 - ) );
260 297 }
261 298 }
262 299 }
263 300 }