Conjunto 49ac6ee en sipes

Fecha y hora:

11/09/2018 11:17:15 (hace 6 años)

Autor:

jpuentes <jpuentes@…>

Branches:

stable

Children:

8deffe0

Parents:

cd814d6

Mensaje:

se agrego el update del campo a bolivar soberano

Fichero:

• 0.3-modules/proyectos_operativos/accion_especifica.install (modificado) (1 diferencia)

0.3-modules/proyectos_operativos/accion_especifica.install

@@ -3654 +3654 @@
   return $content;
 }
+
+/**
+ * update fields to soberano money.
+ */
+function accion_especifica_update_6001(&$sandbox) {
+   include_once('./'. drupal_get_path('module', 'content') .'/content.install');
+   drupal_load('module', 'content');
+
+  $fields_update = array(
+    'field_accion_total_financia' => 'field_accion_total_financia',
+    'field_accion_esp_transferencias' => 'field_accion_esp_transferencias',
+    'field_accion_esp_capitalrie' => 'field_accion_esp_capitalrie',
+    'field_accion_esp_creditosa' => 'field_accion_esp_creditosa',
+    'field_accion_esp_programacion' => 'field_accion_esp_programacion',
+    'field_proyectos_por_endeudamient' => 'field_proyectos_por_endeudamient',
+    'field_banca_comercial' => 'field_banca_comercial',
+    'field_fondo_bilateral' => 'field_fondo_bilateral',
+    'field_accion_esp_venta_act' => 'field_accion_esp_venta_act',
+    'field_accion_esp_activos' => 'field_accion_esp_activos',
+    'field_accion_esp_flujocaja' => 'field_accion_esp_flujocaja',
+    'field_accion_esp_ventapro' => 'field_accion_esp_ventapro',
+    'field_accion_esp_donaciones' => 'field_accion_esp_donaciones',
+    'field_accion_esp_gobernacion' => 'field_accion_esp_gobernacion',
+    'field_convenido_argentina' => 'field_convenido_argentina',
+    'field_convenio_belarus' => 'field_convenio_belarus',
+    'field_convenido_iran' => 'field_convenido_iran',
+    'field_convenido_uruguay' => 'field_convenido_uruguay',
+    'field_exedentes_tesoro_nacional' => 'field_exedentes_tesoro_nacional',
+    'field_accion_esp_fidetel' => 'field_accion_esp_fidetel',
+    'field_accion_esp_locti' => 'field_accion_esp_locti',
+    'field_accion_esp_bid_fona' => 'field_accion_esp_bid_fona',
+    'field_accion_esp_fonacit' => 'field_accion_esp_fonacit',
+    'field_fondo_aportaciones' => 'field_fondo_aportaciones',
+    'field_accion_esp_fonden' => 'field_accion_esp_fonden',
+    'field_eficiencia_socialista' => 'field_eficiencia_socialista',
+    'field_fondo_fen' => 'field_fondo_fen',
+    'field_ezequiel_zamora' => 'field_ezequiel_zamora',
+    'field_fondo_gran_volumen' => 'field_fondo_gran_volumen',
+    'field_accion_esp_fondoidi' => 'field_accion_esp_fondoidi',
+    'field_fondo_miranda' => 'field_fondo_miranda',
+    'field_fondo_fondespa' => 'field_fondo_fondespa',
+    'field_fondo_siembra_petrolera' => 'field_fondo_siembra_petrolera',
+    'field_fondo_simon_bolivar' => 'field_fondo_simon_bolivar',
+    'field_accion_esp_infocentro' => 'field_accion_esp_infocentro',
+    'field_accion_esp_misionc' => 'field_accion_esp_misionc',
+    'field_accion_esp_mcti' => 'field_accion_esp_mcti',
+    'field_accion_esp_monto_finan' => 'field_accion_esp_monto_finan',
+    'field_accion_esp_total_fuent' => 'field_accion_esp_total_fuent',
+    'field_accion_esp_total_meta' => 'field_accion_esp_total_meta',
+  );
+  $rate = 100000;
+  $ret = array();
+
+  $types_field = array(
+    'number_float' => 'number_float',
+    'number_decimal' => 'number_decimal',
+    'number_integer' => 'number_integer',
+    'cck_plan_fields_field' => 'cck_plan_fields_field',
+    'cck_plan_fields_simple_field' => 'cck_plan_fields_simple_field',
+    'cck_plan_fields_combine_term' => 'cck_plan_fields_combine_term',
+  );
+
+  // Get the latest cache values and schema.
+  content_clear_type_cache(TRUE, TRUE);
+  $types = content_types_install();
+
+  if (empty($types)) {
+    return $ret;
+  }
+
+  foreach ($types as $type_name => $fields) {
+    foreach ($fields as $field) {
+      if (array_key_exists($field['field_name'], $fields_update) && array_key_exists($field['type'], $types_field)) {
+        $values[] = $field;
+      }
+    }
+  }
+  $index = array();
+  for($i = 0; $i < 12; $i++) {
+    $index[] = $i === 0? 'value' : 'value_' . $i;
+  }
+
+  foreach ($values as $field) {
+    $db_info = content_database_info($field);
+    $table = $db_info['table'];
+    $columns = array();
+    foreach($index as $id) {
+      if (isset($db_info['columns'][$id])) {
+        $attributes = $db_info['columns'][$id];
+        $column = $attributes['column'];
+        $decimals = isset($field['scale']) && is_numeric($field['scale'])? $field['scale'] : 0;
+        $columns[] = $column  . ' = round(' . $column . '/' . $rate . ', ' . $decimals . ')';
+      }
+    }
+    //$sql = 'UPDATE {'. $db_info['table'] . '} AS tab SET '. $column . ' = round(' . $column . '/' . $rate . ', ' . $decimals . ') FROM {node} AS n WHERE n.nid = tab.nid AND n.vid = tab.vid';
+    $ret[] = update_sql('UPDATE {'. $db_info['table'] . '} AS tab SET '. implode(', ', $columns) . ' FROM {node} AS n WHERE n.nid = tab.nid AND n.vid = tab.vid');
+
+  }
+
+  $ret['#finished'] = 1;
+  return $ret;
+}