'
', '#markup' => migrate_overview(), '#suffix' => '
', ); $header = array( array('data' => t('Status')), array('data' => t('Migration')), array('data' => t('Total rows')), array('data' => t('Imported')), array('data' => t('Unimported')), array('data' => t('Messages')), array('data' => t('Throughput')), array('data' => t('Last imported')), ); $migrations = migrate_migrations(); $rows = array(); foreach ($migrations as $migration) { $row = array(); $has_counts = TRUE; if (method_exists($migration, 'sourceCount')) { $total = $migration->sourceCount(); } else { $has_counts = FALSE; $total = t('N/A'); } if (method_exists($migration, 'importedCount')) { $imported = $migration->importedCount(); } else { $has_counts = FALSE; $imported = t('N/A'); } if ($has_counts) { $unimported = $total - $imported; } else { $unimported = t('N/A'); } $status = $migration->getStatus(); switch ($status) { case MigrationBase::STATUS_IDLE: $status = t('Idle'); break; case MigrationBase::STATUS_IMPORTING: $status = t('Importing'); break; case MigrationBase::STATUS_ROLLING_BACK: $status = t('Rolling back'); break; case MigrationBase::STATUS_STOPPING: $status = t('Stopping'); break; case MigrationBase::STATUS_DISABLED: $status = t('Disabled'); break; default: $status = t('Unknown'); break; } $row['status'] = $status; $machine_name = $migration->getMachineName(); $row['machinename'] = l($machine_name, 'admin/content/migrate/' . $machine_name); $row['importrows'] = $total; $row['imported'] = $imported; $row['unimported'] = $unimported; if (is_subclass_of($migration, 'Migration')) { $num_messages = $migration->messageCount(); $row['messages'] = $num_messages ? l($num_messages, 'admin/content/migrate/messages/' . $machine_name) : 0; } else { $row['messages'] = t('N/A'); } if (method_exists($migration, 'getLastThroughput')) { $rate = $migration->getLastThroughput(); if ($rate == '') { $row['lastthroughput'] = t('Unknown'); } elseif ($status == MigrationBase::STATUS_IDLE) { $row['lastthroughput'] = t('!rate/min', array('!rate' => $rate)); } else { if ($rate > 0) { $row['lastthroughput'] = t('!rate/min, !time remaining', array('!rate' => $rate, '!time' => format_interval((60*$unimported) / $rate))); } else { $row['lastthroughput'] = t('!rate/min, unknown time remaining', array('!rate' => $rate)); } } } else { $row['lastthroughput'] = t('N/A'); } $row['lastimported'] = $migration->getLastImported(); $rows[] = $row; } $build['dashboard'] = array( '#theme' => 'table', '#header' => $header, '#rows' => $rows, '#attached' => array( 'css' => array(drupal_get_path('module', 'migrate_ui') . '/migrate_ui.css'), ), '#empty' => t('No migrations'), ); return $build; } /** * Menu callback for messages page */ function migrate_ui_messages($migration) { $build = $rows = array(); $header = array(t('Source ID'), t('Level'), t('Message')); if (is_string($migration)) { $migration = migration_load($migration); } // TODO: need a general MigrateMap API $messages = db_select($migration->getMap()->getMessageTable(), 'msg') ->extend('PagerDefault') ->limit(500) ->fields('msg') ->execute(); foreach ($messages as $message) { $classes[] = $message->level <= MigrationBase::MESSAGE_WARNING ? 'migrate-error' : ''; $rows[] = array( array('data' => $message->sourceid1, 'class' => $classes), // TODO: deal with compound keys array('data' => $migration->getMessageLevelName($message->level), 'class' => $classes), array('data' => $message->message, 'class' => $classes), ); unset($classes); } $build['messages'] = array( '#theme' => 'table', '#header' => $header, '#rows' => $rows, '#empty' => t('No messages'), '#attached' => array( 'css' => array(drupal_get_path('module', 'migrate_ui') . '/migrate_ui.css'), ), ); $build['migrate_ui_pager'] = array('#theme' => 'pager'); return $build; } /** * Menu callback function for migration view page. */ function migrate_migration_info($form, $form_state, $migration) { if (is_string($migration)) { $migration = migration_load($migration); } $has_mappings = method_exists($migration, 'getFieldMappings'); $form = array(); if ($has_mappings) { $field_mappings = $migration->getFieldMappings(); // Identify what destination and source fields are mapped foreach ($field_mappings as $mapping) { $source_field = $mapping->getSourceField(); $destination_field = $mapping->getDestinationField(); $sourceFields[$source_field] = $source_field; $destinationFields[$destination_field] = $destination_field; } $form['detail'] = array( '#type' => 'vertical_tabs', '#attached' => array( 'js' => array(drupal_get_path('module', 'migrate_ui') . '/migrate_ui.js'), 'css' => array(drupal_get_path('module', 'migrate_ui') . '/migrate_ui.css'), ), ); } else { $form['detail'] = array( '#type' => 'fieldset', ); } $form['overview'] = array( '#type' => 'fieldset', '#title' => t('Overview'), '#group' => 'detail', ); $team = array(); foreach ($migration->getTeam() as $member) { $email_address = $member->getEmailAddress(); $team[$member->getGroup()][] = $member->getName() . ' <' . l($email_address, 'mailto:' .$email_address) . '>'; } foreach ($team as $group => $list) { $form['overview'][$group] = array( '#theme' => 'item_list', '#title' => $group, '#attributes' => array('id' => 'team'), '#items' => $list, ); } $dependencies = $migration->getHardDependencies(); if (count($dependencies) > 0) { $form['overview']['dependencies'] = array( '#prefix' => '
', '#markup' => '' . t('Dependencies: ') . '' . implode(', ', $dependencies), '#suffix' => '
', ); } $soft_dependencies = $migration->getSoftDependencies(); if (count($soft_dependencies) > 0) { $form['overview']['soft_dependencies'] = array( '#prefix' => '
', '#markup' => '' . t('Soft Dependencies: ') . '' . implode(', ', $soft_dependencies), '#suffix' => '
', ); } if ($has_mappings) { switch ($migration->getSystemOfRecord()) { case Migration::SOURCE: $system_of_record = t('Source data'); break; case Migration::DESTINATION: $system_of_record = t('Destination data'); break; default: $system_of_record = t('Unknown'); break; } $form['overview']['system_of_record'] = array( '#prefix' => '
', '#markup' => '' . t('System of record: ') . '' . $system_of_record, '#suffix' => '
', ); } $form['overview']['description'] = array( '#prefix' => '
', '#markup' => $migration->getDescription(), '#suffix' => '
', ); if ($has_mappings) { // Destination field information $form['destination'] = array( '#type' => 'fieldset', '#title' => t('Destination'), '#group' => 'detail', '#description' => t('

These are the fields available in the destination of this migration. The machine names listed here are those available to be used as the first parameter to $this->addFieldMapping() in your Migration class constructor. Unmapped fields are red.

'), ); $destination = $migration->getDestination(); $form['destination']['type'] = array( '#type' => 'item', '#title' => t('Type'), '#markup' => (string)$destination, ); $destKey = $destination->getKeySchema(); $header = array(t('Machine name'), t('Description')); $rows = array(); foreach ($destination->fields() as $machine_name => $description) { $classes = array(); if (isset($destKey[$machine_name])) { // Identify primary key $machine_name .= t(' (PK)'); } else { // Add class for mapped/unmapped. Used in summary. $classes[] = !isset($destinationFields[$machine_name]) ? 'migrate-error' : ''; } $rows[] = array(array('data' => $machine_name, 'class' => $classes), array('data' => $description, 'class' => $classes)); } $classes = array(); $form['destination']['fields'] = array( '#theme' => 'table', '#header' => $header, '#rows' => $rows, '#empty' => t('No fields'), ); // TODO: Get source_fields from arguments $form['source'] = array( '#type' => 'fieldset', '#title' => t('Source'), '#group' => 'detail', '#description' => t('

These are the fields available from the source of this migration. The machine names listed here are those available to be used as the second parameter to $this->addFieldMapping() in your Migration class constructor. Unmapped fields are red.

'), ); $source = $migration->getSource(); $form['source']['query'] = array( '#type' => 'item', '#title' => t('Query'), '#markup' => '
' . $source . '
', ); $sourceKey = $migration->getMap()->getSourceKey(); $header = array(t('Machine name'), t('Description')); $rows = array(); foreach ($source->fields() as $machine_name => $description) { if (isset($sourceKey[$machine_name])) { // Identify primary key $machine_name .= t(' (PK)'); } else { // Add class for mapped/unmapped. Used in summary. $classes = !isset($sourceFields[$machine_name]) ? 'migrate-error' : ''; } $rows[] = array(array('data' => $machine_name, 'class' => $classes), array('data' => $description, 'class' => $classes)); } $classes = array(); $form['source']['fields'] = array( '#theme' => 'table', '#header' => $header, '#rows' => $rows, '#empty' => t('No fields'), ); $header = array(t('Destination'), t('Source'), t('Default'), t('Description'), t('Priority')); // First group the mappings $descriptions = array(); $source_fields = $source->fields(); $destination_fields = $destination->fields(); foreach ($field_mappings as $mapping) { // Validate source and destination fields actually exist $source_field = $mapping->getSourceField(); $destination_field = $mapping->getDestinationField(); if (!is_null($source_field) && !isset($source_fields[$source_field])) { drupal_set_message(t('!source used as source field in mapping but not in list of source fields', array('!source' => $source_field)), 'warning'); } if (!is_null($destination_field) && !isset($destination_fields[$destination_field])) { drupal_set_message(t('!destination used as destination field in mapping but not in list of destination fields', array('!destination' => $destination_field)), 'warning'); } $descriptions[$mapping->getIssueGroup()][] = $mapping; } // Put out each group header $rows = array(); $count = 0; foreach ($descriptions as $group => $mappings) { $form[$group] = array( '#type' => 'fieldset', '#title' => t('Mapping: ') . $group, '#group' => 'detail', '#attributes' => array('class' => array('migrate-mapping')), ); $rows = array(); foreach ($mappings as $mapping) { $default = $mapping->getDefaultValue(); if (is_array($default)) { $default = implode(',', $default); } $issue_priority = $mapping->getIssuePriority(); if (!is_null($issue_priority)) { $classes[] = 'migrate-priority-' . $issue_priority; $priority = MigrateFieldMapping::$priorities[$issue_priority]; $issue_pattern = $migration->getIssuePattern(); $issue_number = $mapping->getIssueNumber(); if (!is_null($issue_pattern) && !is_null($issue_number)) { $priority .= ' (' . l('#' . $issue_number, str_replace(':id:', $issue_number, $issue_pattern)) . ')'; } if ($issue_priority != MigrateFieldMapping::ISSUE_PRIORITY_OK) { $classes[] = 'migrate-error'; } } else { $priority = t('OK'); $classes[] = 'migrate-priority-' . 1; } $row = array( array('data' => $mapping->getDestinationField(), 'class' => $classes), array('data' => $mapping->getSourceField(), 'class' => $classes), array('data' => $default, 'class' => $classes), array('data' => $mapping->getDescription(), 'class' => $classes), array('data' => $priority, 'class' => $classes), ); $rows[] = $row; $classes = array(); } $form[$group]['table'] = array( '#theme' => 'table', '#header' => $header, '#rows' => $rows, ); } } return $form; }