In Laravel 6, take out a list of specific directories that are not duplicated from a list of files
1. Records in the current table. as shown in Figure 1
Figure 1
2. The realization of the file list is as follows
$themeAssets = ThemeAsset::select('asset_key')->where('theme_id', '9994a913-4383-423c-993e-21acde47dbe3')->where('category', ThemeAsset::CATEGORY_MIGRATION)->get();
Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => Modules\ThemeStoreDb\Models\ThemeAsset Object
(
[forceDeleteVersion:protected] =>
[table:protected] => theme_asset2
[connection:protected] => mysql
[primaryKey:protected] => id
[keyType:protected] => int
[incrementing] => 1
[with:protected] => Array
(
)
[withCount:protected] => Array
(
)
[perPage:protected] => 15
[exists] => 1
[wasRecentlyCreated] =>
[attributes:protected] => Array
(
[asset_key] => migrations/migrate_cart.blade.php
)
[original:protected] => Array
(
[asset_key] => migrations/migrate_cart.blade.php
)
[changes:protected] => Array
(
)
[casts:protected] => Array
(
)
[dates:protected] => Array
(
)
[dateFormat:protected] =>
[appends:protected] => Array
(
[0] => created_at
[1] => updated_at
)
[dispatchesEvents:protected] => Array
(
)
[observables:protected] => Array
(
)
[relations:protected] => Array
(
)
[touches:protected] => Array
(
)
[timestamps] => 1
[hidden:protected] => Array
(
)
[visible:protected] => Array
(
)
[guarded:protected] => Array
(
[0] => *
)
)
[1] => Modules\ThemeStoreDb\Models\ThemeAsset Object
(
[forceDeleteVersion:protected] =>
[table:protected] => theme_asset2
[connection:protected] => mysql
[primaryKey:protected] => id
[keyType:protected] => int
[incrementing] => 1
[with:protected] => Array
(
)
[withCount:protected] => Array
(
)
[perPage:protected] => 15
[exists] => 1
[wasRecentlyCreated] =>
[attributes:protected] => Array
(
[asset_key] => migrations/migrate_collections.blade.php
)
[original:protected] => Array
(
[asset_key] => migrations/migrate_collections.blade.php
)
[changes:protected] => Array
(
)
[casts:protected] => Array
(
)
[dates:protected] => Array
(
)
[dateFormat:protected] =>
[appends:protected] => Array
(
[0] => created_at
[1] => updated_at
)
[dispatchesEvents:protected] => Array
(
)
[observables:protected] => Array
(
)
[relations:protected] => Array
(
)
[touches:protected] => Array
(
)
[timestamps] => 1
[hidden:protected] => Array
(
)
[visible:protected] => Array
(
)
[guarded:protected] => Array
(
[0] => *
)
)
)
)
3. Due to the need to take out the file: the v2.0.28 part in migrations/v2.0.28/migrate_settings_data.php. There are some files: migrations/migrate_cart.blade.php does not exist in the v2.0.28 part, so you need to filter them out first. The filter() and mapToGroups() methods of the collection are used successively.
$grouped = $themeAssets->filter(function ($value) {
return Str::startsWith(explode('/', $value->asset_key)[1], 'v2');
})->mapToGroups(function ($value) {
return [explode('/', $value->asset_key)[1] => $value->asset_key];
});
print_r($grouped);
exit;
4. The printing results are as follows, in line with expectations. as shown in Figure 2
Figure 2
Illuminate\Support\Collection Object
(
[items:protected] => Array
(
[v2.0.20] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.0.20/migrate_settings_data.php
)
)
[v2.0.21] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.0.21/migrate_settings_data.php
)
)
[v2.0.28] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.0.28/migrate_cart.php
[1] => migrations/v2.0.28/migrate_collections.php
[2] => migrations/v2.0.28/migrate_collectiontitem.php
[3] => migrations/v2.0.28/migrate_index.php
[4] => migrations/v2.0.28/migrate_product_detail.php
[5] => migrations/v2.0.28/migrate_search.php
[6] => migrations/v2.0.28/migrate_settings_data.php
)
)
[v2.1.1] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.1.1/migrate_index.php
)
)
[v2.1.2] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.1.2/migrate_settings_data.php
)
)
[v2.1.3] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.1.3/migrate_cart.php
[1] => migrations/v2.1.3/migrate_collections.php
[2] => migrations/v2.1.3/migrate_collectiontitem.php
[3] => migrations/v2.1.3/migrate_index.php
[4] => migrations/v2.1.3/migrate_product_detail.php
[5] => migrations/v2.1.3/migrate_search.php
)
)
[v2.1.30] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.1.30/migrate_settings_data.php
)
)
[v2.1.65] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.1.65/migrate_product_detail.php
[1] => migrations/v2.1.65/migrate_settings_data.php
)
)
[v2.1.70] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.1.70/migrate_settings_data.php
)
)
[v2.1.80] => Illuminate\Database\Eloquent\Collection Object
(
[items:protected] => Array
(
[0] => migrations/v2.1.80/migrate_product_detail.php
)
)
)
)
5. Only get the keys of the array in the collection. as shown in Figure 3
Figure 3
print_r(array_keys($grouped->all()));
exit;
Array
(
[0] => v2.0.20
[1] => v2.0.21
[2] => v2.0.28
[3] => v2.1.1
[4] => v2.1.2
[5] => v2.1.3
[6] => v2.1.30
[7] => v2.1.65
[8] => v2.1.70
[9] => v2.1.80
)
