Creates_Reports.php
1 year ago
Migration.php
1 year ago
Migration_10.php
2 years ago
Migration_11.php
2 years ago
Migration_12.php
1 year ago
Migration_13.php
2 years ago
Migration_14.php
2 years ago
Migration_15.php
2 years ago
Migration_16.php
2 years ago
Migration_17.php
1 year ago
Migration_18.php
2 years ago
Migration_19.php
2 years ago
Migration_1_0.php
2 years ago
Migration_1_6.php
2 years ago
Migration_1_8.php
2 years ago
Migration_1_9.php
2 years ago
Migration_2.php
2 years ago
Migration_20.php
2 years ago
Migration_21.php
2 years ago
Migration_22.php
2 years ago
Migration_23.php
1 year ago
Migration_24.php
2 years ago
Migration_25.php
2 years ago
Migration_26.php
2 years ago
Migration_27.php
2 years ago
Migration_28.php
2 years ago
Migration_29.php
2 years ago
Migration_3.php
2 years ago
Migration_30.php
2 years ago
Migration_31.php
2 years ago
Migration_32.php
2 years ago
Migration_33.php
2 years ago
Migration_34.php
1 year ago
Migration_35.php
1 year ago
Migration_36.php
1 year ago
Migration_37.php
1 year ago
Migration_38.php
1 year ago
Migration_39.php
1 year ago
Migration_4.php
2 years ago
Migration_40.php
1 year ago
Migration_41.php
1 year ago
Migration_42.php
1 year ago
Migration_43.php
1 year ago
Migration_44.php
9 months ago
Migration_45.php
8 months ago
Migration_46.php
8 months ago
Migration_47.php
8 months ago
Migration_48.php
8 months ago
Migration_49.php
8 months ago
Migration_5.php
2 years ago
Migration_50.php
9 months ago
Migration_51.php
8 months ago
Migration_52.php
8 months ago
Migration_6.php
2 years ago
Migration_7.php
1 year ago
Migration_8.php
2 years ago
Migration_9.php
2 years ago
Migration_Job.php
1 year ago
Migrations.php
8 months ago
Step_Migration.php
6 months ago
Creates_Reports.php
32 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP\Migrations; |
| 4 | |
| 5 | use IAWP\Tables; |
| 6 | /** @internal */ |
| 7 | trait Creates_Reports |
| 8 | { |
| 9 | public function build_report_insert_query(array $attributes) : string |
| 10 | { |
| 11 | global $wpdb; |
| 12 | if (\array_key_exists('columns', $attributes) && \is_array($attributes['columns'])) { |
| 13 | $attributes['columns'] = \json_encode($attributes['columns']); |
| 14 | } |
| 15 | if (\array_key_exists('filters', $attributes) && \is_array($attributes['filters'])) { |
| 16 | $attributes['filters'] = \json_encode($attributes['filters']); |
| 17 | } |
| 18 | $tables = Tables::class; |
| 19 | $columns = []; |
| 20 | $values_placeholders = []; |
| 21 | $values = []; |
| 22 | foreach ($attributes as $key => $value) { |
| 23 | $columns[] = $key; |
| 24 | $values_placeholders[] = "%s"; |
| 25 | $values[] = $value; |
| 26 | } |
| 27 | $columns = \implode(', ', $columns); |
| 28 | $values_placeholders = \implode(', ', $values_placeholders); |
| 29 | return $wpdb->prepare("\n INSERT INTO {$tables::reports()}\n ({$columns})\n VALUES\n ({$values_placeholders});\n ", ...$values); |
| 30 | } |
| 31 | } |
| 32 |