Resolve #3524980 "Update field identifier value old table rows"

Closes #3524980

src/Controller/CarbonImpactEvaluatorController.php

@@ -24,15 +24,18 @@ final class CarbonImpactEvaluatorController extends ControllerBase {
     $table = \Drupal::database();
     $visit_table = $table->select('co2_info', 'co2_info')
                       ->condition('node_id', $nid)
-                      ->fields('co2_info',['first_visit', 'return_visit'])
+                      ->fields('co2_info',['first_visit', 'return_visit', 'total_number_visits'])
                       ->execute()
                       ->fetchAll();
     $field_visit_status = $visit_table[0]->$visitStatus;
     $status_count = $field_visit_status + 1;
+    $total_visits = $visit_table[0]->total_number_visits;
+    $total_visits_count = $total_visits + 1;
     $updated_table = $table->update('co2_info')
           ->condition('node_id', $nid)
           ->fields([
-            $visitStatus => $status_count
+            $visitStatus => $status_count,
+            'total_number_visits' => $total_visits_count
           ])
           ->execute();
     $new_table = $table->select('co2_info', 'co2_info')
@@ -75,6 +78,7 @@ final class CarbonImpactEvaluatorController extends ControllerBase {
                       ->select('co2_info', 'co2_info')
                       ->fields('co2_info',[
                         'field_identifier',
+                        'uuid',
                         'node_id',
                         'node_title',
                         'node_url',
@@ -91,6 +95,7 @@ final class CarbonImpactEvaluatorController extends ControllerBase {
     foreach($table_query as $k => $table_content) {
       $table_rows[] = [
         $table_content->field_identifier,
+        $table_content->uuid,
         $table_content->node_id,
         $table_content->node_title,
         $table_content->node_url,
@@ -104,6 +109,7 @@ final class CarbonImpactEvaluatorController extends ControllerBase {
     }
     $table_header = [
       'Entity type',
+      'UUID',
       'ID',
       'Title',
       'URL',
@@ -129,4 +135,6 @@ final class CarbonImpactEvaluatorController extends ControllerBase {
     );
     return $table;
   }
+
 }
+ 
\ No newline at end of file