(CollectiveAccess) Retrieve CSV of placements for a given screen, with labels

describeScreen.php

#!/usr/bin/env php
<?php

$screen = 35; // modify as required
$locale = 'en_AU';

$pdo = new PDO('mysql:host=wamcmisdb01-staging;dbname=cmis', 'cmis', 'uhkdv5Uwhkk7pmv');
$placements = $pdo->query('select * from ca_editor_ui_bundle_placements where screen_id = ' . $screen . ' order by rank asc')->fetchAll();
foreach ($placements as $placement) {
  $settings = unserialize(base64_decode($placement['settings']));
  $label = isset($settings['label']) && isset($settings['label'][$locale]) ? $settings['label'][$locale] : null;
  if (!$label && preg_match('/ca_attribute_/', $placement['bundle_name'])) {
    $code = preg_replace('/ca_attribute_/', '', $placement['bundle_name']);
    $elements = $pdo->query('select * from ca_metadata_elements where element_code = \'' . $code . '\'')->fetchAll(); // Yes yes, SQL injection, whatever
    if (sizeof($elements) > 0) {
      $elementLabels = $pdo->query('select * from ca_metadata_element_labels where element_id = ' . $elements[0]['element_id'])->fetchAll();
      if (sizeof($elementLabels) > 0) {
        $label = $elementLabels[0]['name'];
      }
    }
  }
  echo $placement['placement_id'] . ',' . $placement['placement_code'] . ',' . $placement['bundle_name'] . ',' . $label . ',' . $placement['rank'] . PHP_EOL;
}