| private deleteCollections ( array $collectionIds ) | ||
| $collectionIds | array | |
private function deleteCollections($collectionIds)
{
// deletes by id but only if they dont' have any more related instances
DB::table('dvs_collection_sets')->join('dvs_collection_instances', 'dvs_collection_instances.collection_set_id', '=', 'dvs_collection_sets.id')->select('dvs_collection_sets.*', DB::raw('count(dvs_collection_instances.id) as related_count'))->whereIn('dvs_collection_sets.id', $collectionIds)->where('related_count', 0);
}