Darinel Cigarroa's questions

Hi everyone, thank you very much in advance.

I am trying to compare two arrays of objects, what I want to achieve is that if the id property coincides in both objects, add a new element "selected" with the property true to my first array of objects, I already have something set up and it works more, however it does not I feel that it is the best way since when performing a console.log in the forEach iteration I see that the elements are iterated more times than they should be.

I share my code to make myself understand better:

My first array:

optionsSelect = [
  { id:14, isActive:true, name:"rfc", value:"rfc" },
  { id:15, isActive:true, name:"nombre completo", value:"full_name" },
  { id:16, isActive:true, name:"curp", value:"curp" }
];

My second array:

templateSettings = [ 
  { id:14, isActive:true, name:"rfc", value:"rfc"},
  { id:15, isActive:true, name:"nombre completo", value:"full_name"}
];

My solution:

optionsSelect = [
  { id:14, isActive:true, name:"rfc", value:"rfc" },
  { id:15, isActive:true, name:"nombre completo", value:"full_name" },
  { id:16, isActive:true, name:"curp", value:"curp" }
];

templateSettings = [ 
  { id:14, isActive:true, name:"rfc", value:"rfc"},
  { id:15, isActive:true, name:"nombre completo", value:"full_name"}
];

optionsSelect.forEach(element => {
    templateSettings.forEach(item => {
    //console.log("--------------")
    //console.log(item)
    //console.log("--------------")
        if(element.id === item.id) {
            element.selected = true
        }  
    })
})

console.log('resultado optionSelect', optionsSelect)

If you uncomment the console.log, you will see what I mean, any way to optimize the code?

Thank you in advance for your answers and comments.

I want to achieve the following I have two arrays with key and value, the first is an array with several values ​​and the second an array of arrays with several values, what I am trying to achieve is to keep the keys and value of my first array whose keys match the key "value" of my second array. Enter code to make me understand better:

$array1 = [
    "id" => 13,
    "name" => "MAURO",
    "code" => "2903",
    "lastname" => "GARCIA",
    "email" => "[email protected]",
    "second_lastname" => "VARELA",
    "rfc" => "GAVM540516",
    "curp" => "GAVM540516HJCRRR02",
    "nss" => "70707070707",
];
$array2 =
[
    [
       "id" => 14,
        "name" => "rfc",
        "isActive" => true,
        "value" => "rfc",
    ],  
    [
    "id" => 15,
    "name" => "numero de empleado",
    "isActive" => true,
    "value" => "code",
    ],
];

From array1 I want to keep the values ​​whose key matches the value of the key value of my second array, that is, a result like this:

$resultado = [
 "rfc" => "GAVM540516",
 "code" => "2903"
];

I had achieved something similar to this in the scenario that my array2 is a simple array I share code:

$array1 = [
    "id" => 13,
    "name" => "MAURO",
    "code" => "2903",
    "lastname" => "GARCIA",
    "email" => "[email protected]",
    "second_lastname" => "VARELA",
    "rfc" => "GAVM540516",
    "curp" => "GAVM540516HJCRRR02",
    "nss" => "70707070707",
];
$array2= ["rfc","code"];

var_dump(array_intersect_key($array1, array_flip($array2)));

This works the problem I have now is that my dos array is now an array of arrays. Thanks again for your answers.

Hello everyone in advance, thank you very much for your answers and comments. I want to achieve the following I have a date which I get from the database with the following format this date is a string and I store it in the date variable:

date := "2015-02-01T00:00:00Z"

I want to transform said date to the date data type to extract the year with the YEAR() function, which gives me something like the following:

date := "2015-02-01"

I am trying as follows:

    newDate, error := time.Parse("2022-02-01", date)
    if error != nil {
        fmt.Println(error)
    }
    println("año", date.Year())

However, this returns a 1 and should return 2015, printing the parse returns this:

parsing time "2022-02-01T00:00:00Z" as "2022-02-01": cannot parse "-02-01T00:00:00Z" as "2"

If I print the date variable after parsing, I see that it returns this:

0001-01-01 00:00:00 +0000 UTC

I think what is generating the error are the seconds, minutes and hours in my string but I don't know how to solve it.

I share link to Go Playground: Go playground

Hello everyone in advance, thanks for your answers and comments, my question is simple, I'm learning GO and I don't know how to do this, I want to get the elapsed years from a given date in Golang ie I have the following date saved in a variable:

date :=  "2020-08-16"

I want to get the years that have elapsed to the current date (2022).

Hello everyone in advance, thank you very much for your answers and comments, I want to achieve the following, I am trying to search for a record according to two fields in my database, the structure of my table named "incident_days" is as follows:

---+----------------------------+---------------+-------------------+
|id|cat_employee_incident_type_id|first_year_rank| second_year_rank |
---+-----------------------------+---------------+------------------+
| 1|           2                 |        1      |        5         |
_________________________________+_______________+__________________+

In my controller I have the function validateIncidentDates in it I have a variable called $antiquity, with it I want to filter the records between the fields first_year_rank and second_year_rank, I am trying as follows:

public function validateIncidentDates (Request $request) {
    try {
        $antiquity = 3;

        $days_granted  = DB::table('incident_days')->where('cat_employee_incident_type_id', $request->incident_id)
        ->where($antiquity)->between('first_year_rank', 'and', 'second_year_rank')->first();

        return response()->json([
            'success' => true,
        ]);
    } catch (\Exception $e) {
        return response()->json([
            'success' => false,
            'message' => 'Error'
        ]);
    }
}

That is, I want to find the records where antiquity is between first_year_rank and second_yaear_rank, the table has more records, I have placed only one to make the question easier.

Hello, I am doing a query in which it returns 3 numeric fields, these fields are:

• total_perceptions
• total_deductions
• total_pantry_vouchers

I want to add these fields and then return only what is different from 0, I am trying the following way in Laravel.

`$payrolls = ProcessedPayroll::where('payroll_id', $id)->sum('total_perceptions' + 'total_deductions')->get()`;

Also, try this way but no results

 $payrolls = ProcessedPayroll::where('payroll_id', $id)->sum('total_perceptions + total_deductions')->get();

Any idea or example you can give me?

The results I'm looking for are like this.

| id | total_perceptions| total_deductions|total_pantry_vouchers|Total
+----+------------------+------------------+------------------+--------
|  1 |     5                  5            |      0            |10             +                       |
+----+------------------+-------------------+------------------+-------

I have the following JSON (I will show a dd of the $data_concepts variable):

array:3 [
  0 => {#2408
    +"total": "1300"
    +"concepto": "AHORRO SOLIDARIO 1 B"
    +"alias": "2AS"
    +"tipo": 2
    +"code": "2AS"
  }
  1 => {#2377
    +"total": "700"
    +"concepto": "AHORRO SOLIDARIO 1 M"
    +"alias": "2AS"
    +"tipo": 2
    +"code": "2AS.0"
  }
  2 => {#2391
    +"total": "9815.670000000002"
    +"concepto": "AHORRO SOLIDARIO 2 B"
    +"alias": "24S"
    +"tipo": 2
    +"code": "24S."
  }
]

I am trying to group the data by alias, that is, if the alias field is repeated, get another JSON with a single alias and the sum of the total field of all of them.

That is, something like this:

array:2 [
      0 => {#2408
        +"total": "2000"
        +"concepto": "AHORRO SOLIDARIO 1 B"
        +"alias": "2AS"
        +"tipo": 2
        +"code": "2AS"
      }
      1 => {#2391
        +"total": "9815.670000000002"
        +"concepto": "AHORRO SOLIDARIO 2 B"
        +"alias": "24S"
        +"tipo": 2
        +"code": "24S."
      }
    ]

I am trying this way:

$conceptss= [];
  foreach ($data_concepts as $clave => $conceptss) {
                if (!empty($conceptss->alias)) {
                    if(!empty($concepts)) {
                        if (in_array($conceptss->alias, $concepts[$clave])) {
                            continue;
                        } else {
                            array_push($concepts, $conceptss);
                            // dd($concepts);
                        }
                    } else {
                        array_push($concepts, $conceptss);
                    }
                }
            }

But this throws an error, any ideas or tips? Any help is helpful and much appreciated, thanks.

I get the data from a query to my database, the query is as follows:

  $data_concepts = DB::table('processed_payroll_concepts')
                ->select(DB::raw('sum(processed_payroll_concepts.amount) as Total, processed_payroll_concepts.name as Concepto,  processed_payroll_concepts.alias as Alias,  processed_payroll_concepts.cat_concept_type_id as Tipo,  processed_payroll_concepts.code as Code'))
                ->leftJoin('processed_payrolls', 'processed_payrolls.id', '=', 'processed_payroll_concepts.processed_payroll_id')
                ->where('processed_payrolls.payroll_id', $id)
                // ->whereNotNull('alias')
                ->groupBy('processed_payroll_concepts.name')
                ->groupBy('processed_payroll_concepts.alias')
                ->groupBy('processed_payroll_concepts.cat_concept_type_id')
                ->groupBy('processed_payroll_concepts.code')
                ->get();

Hello everyone, thank you very much in advance for your answers and comments, I am trying the following:

I have an array of Objects in which I want to add a new key and value to all the objects, I have the following object:

const pension = [
  {cat_bank_id: 91,cat_discount: 1,clabe: "901",curp: "ASDA",name: "asda",percentage: "12"},
  {cat_bank_id: 92,cat_discount: 1,clabe: "902",curp: "ASDB",name: "asdb",percentage: "12"}
];

I want to achieve the following:

const pension = [
  {cat_bank_id: 91,cat_discount: 1,clabe: "901",curp: "ASDA",name: "asda",percentage: "12", employee_id: 212},
  {cat_bank_id: 92,cat_discount: 1,clabe: "902",curp: "ASDB",name: "asdb",percentage: "12", employee_id: 212}
];

I am trying as follows:

const pension = [
  {cat_bank_id: 91,cat_discount: 1,clabe: "901",curp: "ASDA",name: "asda",percentage: "12"},
  {cat_bank_id: 92,cat_discount: 1,clabe: "902",curp: "ASDB",name: "asdb",percentage: "12"}
];
const employee_id = 212;

const test = pension.map(pension => {
    return pension.key3 = employee_id;
});
console.log(test)

Hello everyone, I have the following array of objects in their integer values ​​properties, I am trying to transform those integers to strings:

const pension = [{
  cat_bank_id: 91,
  cat_discount: 1,
  clabe: "901",
  curp: "ASDA",
  name: "asda",
  percentage: "12"
}]

The keys that contain the integer are cat_bank_id and cat_discount, how can I achieve this? Thank you very much in advance for your answers and comments.

I am trying the following way, I manage to convert the integer to a string but I don't know how to generate a new object array with the transformed values.

const pension = [{
  cat_bank_id: 91,
  cat_discount: 1,
  clabe: "901",
  curp: "ASDA",
  name: "asda",
  percentage: "12"
}];

console.log(pension)

pension.forEach(pension => {
  console.log('sin transformar', typeof pension.cat_bank_id)
  const string = String(pension.cat_bank_id)
  console.log('transformado', typeof string)
})

Hello, thanks for your answers and comments. I come to you for the following, I have the following array of objects:

const customCatalogs = [
  customTableValues = [
    {id: 2, puestos: "Recursos Humanos", visible: "puesto dos"},
    {id: 1, puestos: "Dearrollador", visible: "puesto uno"}
  ],
  customEmployeeValue = null
];

I want to add to customEmployeeValue the following object:

{ 
  id: 1,
  puestos: "Dearrollador",
  visible: "puesto uno"
}

But I am trying to add this object inside a key named value, I want to achieve this:

   const customCatalogs = [
      customTableValues = [
        {id: 2, puestos: "Recursos Humanos", visible: "puesto dos"},
        {id: 1, puestos: "Dearrollador", visible: "puesto uno"}
      ],
      customEmployeeValue = {
        value: {
          id: 1,
          puestos: "Dearrollador",
          visible: "puesto uno"
      }
      }
    ];

Where the object I want to add has the key value .

I am trying as follows:

   
const payload = {
          id: 1,
          puestos: "Dearrollador",
          visible: "puesto uno"
      };

const customCatalogs = [
      customTableValues = [
        {id: 2, puestos: "Recursos Humanos", visible: "puesto dos"},
        {id: 1, puestos: "Dearrollador", visible: "puesto uno"}
      ],
      customEmployeeValue = null
    ];

customCatalogs.customEmployeeValue = payload;

console.log(customCatalogs)

Thank you all for your answers and comments.

Hello everyone, thank you very much in advance for your answers and comments. The question is the following. I want to add another key and value to the object that returns a query. I have the following query using Laravel's Query Builder.

$query = DB::table($table)->get()->toArray();

This query returns the following object:

   1: {id: 1, genero: "femenino", visible: "femenino"}
   2: {id: 2, genero: "masculino", visible: "masculino"}

Now I want to add to the object that you have returned a new key and value, remaining as follows:

   1: {id: 1, genero: "femenino", visible: "femenino", table: 'genero' }
   2: {id: 2, genero: "masculino", visible: "masculino", table: 'genero' }

I have the name of the table that I want to add stored in a variable $table in the following way:

$table = 'genero';
$query = DB::table($table)->get()->toArray();

How can I add the name of the table the records come from?

I appreciate your responses and comments by the way I can not use eloquent to generate the query.

Hello everyone, this time I come to you for this problem that I have encountered and I have not been able to solve, I have the following code, which generates queries to various tables in my database, the names of the tables, I store them in a variable for later with a forEach loop generate the data as follows:

 public function getCustomData($id)
    {
        try {
            $tables = CatAdministrator::where('cat_modules_id', $id)->pluck('table_name');
            // Tables contiene ['tabla1','tabla2'];
            $data = null;
            foreach($tables as $table) {             
                $data .= DB::table($table)->get();
            }
     
            return response()->json([
                'success' => true,
                'data' => $data
            ]);
        }catch (\Exception $e) {
            return response()->json([
                'success' => false,
                'message' => $e->getMessage()
            ]);
        }
    }

The problem is that this generates the following structure in $data

$data = [
          {"id":1,"genero":"Masculino"},
          {"id":2,"genero":"Femenino"},
          {"id":3,"genero":"Indefinido"}
        ][
           {"id":1,"puestos":"Desarrollador Full Stack Developer"}
         ];

How can I remove the brackets from the second table so that I have a structure like the following?

$data = [
           {"id":1,"genero":"Masculino"},
           {"id":2,"genero":"Femenino"},
           {"id":3,"genero":"Indefinido"},
           {"id":1,"puestos":"Desarrollador Full Stack Developer"}
         ];

I thank you in advance for your answers and comments, and if anyone knows of a better way than mine to query multiple tables from an array with Laravel's QueryBuilder and return a better data structure, I'm open to receiving opinions. Without further ado, I thank you for your support.

Hello everyone, first of all good day and thanks for your answers and opinions, I have the following problem I want to find in an array that contains other arrays the element that has been modified for it I have done the following I save the elements that I receive in two different variables in one of them I make the modifications and with the other array the idea is to compare it to know which element has been modified and to obtain it I have the following structure. I save the data that comes from the server in Data and modifiableData. I save the data that comes from the server in Data and modifiableData

data = [
      [1, 'Darinel', 'Cigarroa'],
      [2, 'Isis', 'Oriana'],
      [3, 'Manuel', 'Arcos']
    ];

modifiableData = [
      [1, 'Darinel', 'Cigarroa'],
      [2, 'Isis', 'Oriana'],
      [3, 'Manuel', 'Arcos']
    ];

Suppose that in modifiableData I have changed the first name to Daro, it would be as follows:

  modifiableData = [
          [1, 'Daro', 'Cigarroa'],
          [2, 'Isis', 'Oriana'],
          [3, 'Manuel', 'Arcos']
        ];

I want to find that modified array and fetch only that array to have this result:

[1, 'Daro', 'Cigarroa'],

It is worth mentioning that I am receiving the data that I am modifying following our 'Daro' example, so I suppose that there must be more than one solution. I was solving it by searching for its id, which would be the first value of the arrays, but this can also be modified and my solution fails now i am trying as follows but no success.

  data = [
          [1, 'Darinel', 'Cigarroa'],
          [2, 'Isis', 'Oriana'],
          [3, 'Manuel', 'Arcos']
        ];

modifiableData = [
          [1, 'Daro', 'Cigarroa'],
          [2, 'Isis', 'Oriana'],
          [3, 'Manuel', 'Arcos']
        ];

const result = modifiableData.filter((element) => element === 'Daro' );
console.log(result);

Hello everyone first of all thanks for your answers and comments, I want to achieve the following in each iteration of a forEach loop I want to store the result in a variable so that at the end of the loop my variable must have all the results of the foreach loop I write the caught that I have done to explain myself better.

<?php

$request = [1,"darinel cigarroa","24","2021-12-16 00:00:00","2021-12-16 00:00:00"];
$consulta = null;
$colums = ["id","nombre","edad","created_at","updated_at"];

foreach ($colums as $campo)
    {
        foreach($request as $rows){
           $consulta = $campo . '=' . $rows;
        }
    }

var_dump($consulta);

The result of this cycle is the following:

"updated_at=2021-12-16 00:00:00"

And what I want to generate is something like the following:

id=1, nombre='darinel cigarroa', edad='24', created_at='16/12/21', updated_at='16/12/21'

How can I do a push type of each iteration in each loop to get to the result? I thank you in advance for your answers and comments, any kind of help is useful and appreciated. The following code is Rodrigo's response, it achieves the purpose of the question, however, it repeats the field for each column, this is the code:

$request = [1,"darinel cigarroa","24","2021-12-16 00:00:00","2021-12-16 00:00:00"];
$consulta = "";
$colums = ["id","nombre","edad","created_at","updated_at"];

foreach ($colums as $campo)
    {
        foreach($request as $rows){
           $consulta .= $campo . '=' . $rows . ", ";
        }
    }
# El ultimo elemento temrinara en ", "
# Lo eliminaremos usando preg_replace
$consulta = preg_replace("/\s*\,\s*$/", "", $consulta);

print($consulta);

The result is as follows:

id=1, id=darinel cigarroa, id=24, id=2021-12-16 00:00:00, id=2021-12-16 00:00:00, nombre=1, nombre=darinel cigarroa, nombre=24, nombre=2021-12-16 00:00:00, nombre=2021-12-16 00:00:00, edad=1, edad=darinel cigarroa, edad=24, edad=2021-12-16 00:00:00, edad=2021-12-16 00:00:00, created_at=1, created_at=darinel cigarroa, created_at=24, created_at=2021-12-16 00:00:00, created_at=2021-12-16 00:00:00, updated_at=1, updated_at=darinel cigarroa, updated_at=24, updated_at=2021-12-16 00:00:00, updated_at=2021-12-16 00:00:00

This is already clearer to me if I can solve it right away I share the answer, thank you very much for contributing to my problem.

I want to get an element of an array of arays that matches a data, in this case the first data of my array, which refers to the id of each array.

var data = 
     [
        [1, 'darinel', 24, '9a3853'],
        [2, 'oscar', 19, 'ecf03c'],
        [3, 'Alexander', 15, 'aab418']
     ];

I receive a data, in this case the id, through a form; I have the following data:

var data = 
     [
        [1, 'darinel', 24, '9a3853'],
        [2, 'oscar', 19, 'ecf03c'],
        [3, 'Alexander', 15, 'aab418']
     ];

var id = 1;

var people = data.filter((element) => element === id);

console.log(people);

But this returns me empty; I am thinking of going through a FOR although I am not sure how to do it. I forgot to mention that the array of arrays can vary and can have different dimensions.

I have the following public function in my controller, in this public function I have written another function that converts the $request that I receive in lowercase and add snake case, my question is, is it good practice to have this function inside my public function?

public function store(Request $request)
{
  
        function convertSnake($data) {             
            
            $snake_case = str_replace(" ", "_", strtolower($data));
            
            return $snake_case;        
        }

     ............ Más código ...........   
}

Hello, I am declaring my next computed function and Slint marks me an error in syntax that I cannot understand, my computed method is the following and I immediately attach the error that this throws at me. Computed property:

  columns() {
          return this.columnNamesFromCsv.map((columnName) => {
            return {
              name: columnName,
              label: columnName,
              align: 'center',
              sortable: true,
              field: (row) => row[columnName]
            };
          });
        }

Mistake:

 error    Unexpected block statement surrounding arrow body; parenthesize the returned value and move it immediately after the `=>`

Thank you in advance for your responses and opinions.

Hello, what I am trying to do is bring all the records of my table but the field that I want to bring is only "table_name", I have made the following query using Eloquent, my question would really be what is the best way since I have read that some queries can be more optimized than others. And how can I know this? This is my query with Eloquent:

CatAdministrator::all()->pluck('table_name');

Hello, first of all, thanks for reading my question. I have made a query to my database relating 2 tables. I have done this using JOIN and I was wondering how the same query could be made with Eloquent. The main table is cat_tabulator_histories and this table is related to cat_contract_types and cat_sub_contract_type, I want to get the records from cat_tabulator_histories bringing with it the records that are related.

I share my query in JOIN so that it is better understood:

 $tabulatorsHistory = DB::table('cat_tabulator_histories')
            ->where('cat_tabulator_id', $id)
            ->join('cat_contract_types', 'cat_contract_types.id', '=', 'cat_tabulator_histories.cat_contract_type_id')
            ->join('cat_sub_contract_types', 'cat_sub_contract_types.id', '=', 'cat_tabulator_histories.sub_contract_type_id')
            ->select('cat_tabulator_histories.id as id', 'cat_tabulator_histories.name as name', 'cat_tabulator_histories.base_salary_cents as salary_cents', 'cat_tabulator_histories.compensation_cents as compensation_cents', 'cat_tabulator_histories.is_active as active', 'cat_tabulator_histories.created_at as created_at','cat_tabulator_histories.start_date as start_date','cat_tabulator_histories.end_date as end_date', 'cat_tabulator_histories.date_active as date_active', 'cat_contract_types.name as type_contract', 'cat_sub_contract_types.name as type_subcontract')
            ->orderBy('cat_tabulator_histories.start_date', 'DESC')
            ->get();

Thank you for your answers. It should be noted that my tables are already related at the model level. Again, thank you very much. Any opinion on where I can start would be very helpful.

I have managed to do the query with eloquent in this way:

$tabulatorsHistory = CatTabulatorHistory::where('cat_tabulator_id', $tabulatorOriginal->id)
                ->with('contract','subContract')
                ->get();

Now the problem I am facing is that it brings me all the related table like this:

 {
            "id": 3,
            "name": "PRUEBA1.0",
            "base_salary_cents": 2000000,
            "daily_salary_cents": 0,
            "compensation_cents": 1000000,
            "start_date": "2021-12-15",
            "end_date": "2021-12-30",
            "is_active": false,
            "budget_code": null,
            "gross_allocation": 0,
            "concepts": null,
            "cat_contract_type_id": 1,
            "cat_tabulator_id": 72,
            "sub_contract_type_id": 1,
            "date_active": "2021-12-02 10:36:27",
            "created_at": "2021-12-02T16:35:25.000000Z",
            "updated_at": "2021-12-02T16:35:25.000000Z",
            "contract": {
                "id": 1,
                "name": "BASE/ESTRUCTURA/OPERATIVO CONF",
                "christmas_bonus_days": 90,
                "gratification_days": null,
                "holidays": 20,
                "isActive": true,
                "is_unionized": false,
                "cat_vacations_type_id": 1,
                "cat_sat_contract_type_id": null,
                "cat_sat_work_day_type_id": null,
                "cat_sat_employee_regime_id": null,
                "schedules_id": null,
                "created_at": "2021-10-29T21:35:08.000000Z",
                "updated_at": "2021-10-29T21:35:08.000000Z"
            },
            "sub_contract": {
                "id": 1,
                "name": "BASE",
                "cat_contract_type_id": 1,
                "created_at": "2021-10-29T21:35:12.000000Z",
                "updated_at": "2021-10-29T21:35:12.000000Z"
            }
        },

I want only the name of each relationship.

I have the following array of objects I want to add the ages of all the people:

let personas = [
    {id: 1, name:'Darinel', edad: 24, lastName:'Cigarroa', ciudad: 'CDMX'},
    {id: 2, name:'Darwin', edad: 24, lastName:'De jesus', ciudad: 'CDMX'},
    {id: 3, name:'Vera', edad: 24, lastName:'Dominguez', ciudad: 'CDMX'},
    {id: 4, name:'Emiliano', edad: 24, lastName:'Silva', ciudad: 'CDMX'},
    {id: 5, name:'Derky', edad: 24, lastName:'Wilner', ciudad: 'CDMX'},
    {id: 6, name:'Juan', edad: 24, lastName:'De La Cruz', ciudad: 'CDMX'},
];

I am trying this way but without any result:

let reduce = personas.reduce((acumulador, actual) => acumulador.edad + actual.edad);
console.log(reduce)