Conjunto cd814d6 en sipes

Fecha y hora:

01/08/2018 15:05:01 (hace 6 años)

Autor:

jpuentes <jpuentes@…>

Branches:

stable

Children:

49ac6ee

Parents:

7218404

Mensaje:

se mejoro la importación de los archivos para que guarde los parents del termino

Fichero:

• 0.3-modules/ente_planificador_importar/ente_planificador_importar.module (modificado) (7 diferencias)

0.3-modules/ente_planificador_importar/ente_planificador_importar.module

@@ -124 +124 @@
   }
   if (user_access('import term')) {
-    $links['term'] = array(
+    $links['term1'] = array(
       'data' => l(t('Importar terminos'), 'ente_planificador_importar/terminos'),
       'class' => 'ente-planificador-importar-term', 
     );
-    $links['term'] = array(
+    $links['term2'] = array(
       'data' => l(t('Importar Campos de terminos'), 'ente_planificador_importar/terminos/fields'),
       'class' => 'ente-planificador-importar-term-fields', 
@@ -721 +721 @@
   );
   $options = array();
-  for($i = 0;$i < 11; $i++) {
+  for($i = 0;$i < 15; $i++) {
     if (!$i) {
       $options[$i] = t('N/A');
@@ -729 +729 @@
     }
   }
-  $form['nombre'] = array(
-    '#type' => 'select',
-    '#title' => t('Nombre'),
-    '#options' => $options,
-    '#description' => t("La fila donde se encuentra el nombre del termino."),
-    '#required' => TRUE,
-  );
+  for ($i=0; $i<=6; $i++) {
+    $form['fieldset_' . $i] = array(
+      '#type' => 'fieldset',
+      '#title' => t('Grupo ') . $i,
+    );
+    $form['fieldset_' . $i]['search_parent_' . $i] = array(
+      '#type' => 'select',
+      '#title' => t('Parent ') . $i,
+      '#options' => $options,
+      '#description' => t("La fila donde se encuentra el parent ") . $i,
+      '#required' => TRUE,
+    );
+    $form['fieldset_' . $i]['nombre_' . $i] = array(
+      '#type' => 'select',
+      '#title' => t('Nombre ') . $i,
+      '#options' => $options,
+      '#description' => t("La fila donde se encuentra el nombre del termino ") . $i,
+      '#required' => TRUE,
+    );
+    $form['fieldset_' . $i]['description_' . $i] = array(
+      '#type' => 'select',
+      '#title' => t('Description ') . $i,
+      '#options' => $options,
+      '#description' => t("La fila donde se encuentra el description del termino ") . $i,
+      '#required' => TRUE,
+    );
+  }
+  /*
   $ids = array(
     'code' => t('Código'),
@@ -745 +766 @@
       '#options' => $options,
     );
-  }
+  }*/
   $form['encabezado'] = array(
     '#title' => 'Primera columna como encabezado',
@@ -766 +787 @@
   $validators = array('file_validate_extensions' => array('csv'));
   // Check for a new uploaded file.
-  $file = file_save_upload('file_import_entes', $validators);
+  $file = file_save_upload('file_import_entes');
+
   if (isset($file)) {
     // File upload was attempted.
@@ -785 +807 @@
       );
       while (($data = fgetcsv($file)) !== FALSE) {
-        $term = array(
-          'vid' => $form_state['values']['vid'], // Voacabulary ID
-          'name' => check_plain($data[$form_state['values']['nombre'] - 1]), // Term Name
-          'fields' => array(
-            'unidad_codigo1' =>  array(
-              'value' => check_plain($data[$form_state['values']['code'] - 1]),
-            ),
-          ),
-        );
-        if (!($form_state['values']['encabezado'] && $i == 1)) {
-          $batch['operations'][] = array('_batch_ente_planificador_importar_term', array($term));
+        for ($j=0; $j<=6; $j++) {
+          if ($form_state['values']['nombre_' . $j] && $data[$form_state['values']['nombre_' . $j] - 1]) {
+            $term = array(
+              'vid' => $form_state['values']['vid'], // Voacabulary ID
+              'name' => check_plain($data[$form_state['values']['nombre_' . $j] - 1]), // Term Name
+              'description' => check_plain($data[$form_state['values']['description_' . $j] - 1]), // Term description
+              'search_parent' => FALSE,
+              /*'fields' => array(
+                'unidad_codigo1' =>  array(
+                  'value' => check_plain($data[$form_state['values']['code'] - 1]),
+                ),
+              ),*/
+            );
+            if ($form_state['values']['search_parent_' . $j] && $data[$form_state['values']['search_parent_' . $j] - 1]) {
+              $term['search_parent'] = check_plain($data[$form_state['values']['search_parent_' . $j] - 1]);
+            }
+            if (!($form_state['values']['encabezado'] && $i == 1)) {
+              $batch['operations'][] = array('_batch_ente_planificador_importar_term', array($term));
+            }
+          }
         }
         $i++;
@@ -866 +897 @@
  */
 function _batch_ente_planificador_importar_term($term, &$context) {
-  taxonomy_save_term($term);
+   //not create if exist
+  $db_result = db_query(db_rewrite_sql("SELECT t.tid, t.name FROM {term_data} t WHERE LOWER(t.name) = LOWER('%s') AND vid = %d", 't', 'tid'), $term['name'], $term['vid']);
+  $row = db_fetch_array($db_result);
+  if (!taxonomy_get_term($row['tid'])) {
+   $term['parent'] = array();
+   $term['search_parent'];
+   if ($term['search_parent']) {
+     $db_result = db_query(db_rewrite_sql("SELECT t.tid, t.name FROM {term_data} t WHERE LOWER(t.name) = LOWER('%s') AND vid = %d", 't', 'tid'), trim($term['search_parent']), $term['vid']);
+     $result = array();
+     $row = db_fetch_array($db_result);
+     if (!empty($row)) {
+       $parent = taxonomy_get_term($row['tid']);
+       if ($parent) {
+         $term['parent'][] = $parent->tid;
+        }
+      }
+    }
+    taxonomy_save_term($term);
+  }
+
   $context['message'] = t('Now processing ente: %submission', array('%submission' => $term->name));
   $context['results'][] = 'term importado: ' . $term->name . '</pre>';