function webform2pdf_update_7400 in Webform2PDF 7.4

The data field added to webform2pdf table and remove old fields.

File

./webform2pdf.install, line 259

Webform2pdf module install/schema hooks.

Code

function webform2pdf_update_7400() {
  db_add_field('webform2pdf', 'data', array(
    'type' => 'blob',
    'size' => 'big',
    'serialize' => TRUE,
    'description' => 'Serialized data containing the webform2pdf properties.',
  ));
  $w2pdf_settings = db_select('webform2pdf', 'w2p')
    ->fields('w2p')
    ->execute()
    ->fetchAllAssoc('nid');
  foreach ($w2pdf_settings as $setting) {
    $nid = $setting->nid;
    unset($setting->nid);
    unset($setting->enabled);
    $setting = (array) $setting;
    $setting['no_send_email_addr'] = unserialize($setting['no_send_email_addr']);
    $p_body['value'] = $setting['p_body'];
    $p_body['format'] = $setting['format'];
    $setting['p_body'] = $p_body;
    $setting = serialize($setting);
    db_update('webform2pdf')
      ->fields(array(
      'data' => $setting,
    ))
      ->condition('nid', $nid, '=')
      ->execute();
  }
  db_drop_field('webform2pdf', 'download');
  db_drop_field('webform2pdf', 'pdf_send_email');
  db_drop_field('webform2pdf', 'no_send_email_addr');
  db_drop_field('webform2pdf', 'page_format');
  db_drop_field('webform2pdf', 'page_orientation');
  db_drop_field('webform2pdf', 'h_left_logo');
  db_drop_field('webform2pdf', 'h_right_logo');
  db_drop_field('webform2pdf', 'f_left_logo');
  db_drop_field('webform2pdf', 'f_right_logo');
  db_drop_field('webform2pdf', 'h_font_size');
  db_drop_field('webform2pdf', 'p_font_size');
  db_drop_field('webform2pdf', 'f_font_size');
  db_drop_field('webform2pdf', 'h_txt_align');
  db_drop_field('webform2pdf', 'h_font_family');
  db_drop_field('webform2pdf', 'p_txt_align');
  db_drop_field('webform2pdf', 'p_font_family');
  db_drop_field('webform2pdf', 'f_txt_align');
  db_drop_field('webform2pdf', 'f_font_family');
  db_drop_field('webform2pdf', 'h_txt');
  db_drop_field('webform2pdf', 'f_txt');
  db_drop_field('webform2pdf', 'p_body');
  db_drop_field('webform2pdf', 'format');
  db_drop_field('webform2pdf', 'p_background');
  $w2pdf_default = variable_get('webform2pdf_default', array());
  $p_body['value'] = $w2pdf_default['p_body'];
  $p_body['format'] = $w2pdf_default['format'];
  $w2pdf_default['p_body'] = $p_body;

  //  [submission:values]
  variable_set('webform2pdf_default', $w2pdf_default);
  return t('The data field added to webform2pdf table and remove old fields.');
}