jmrufo's questions

I request your help to perform the following query. I have 3 related tables (courses, course_user, users) with the following fields:

1. courses table : id, denomination, hours.
2. course_user table : id, course_id, user_id, inscription_type (this field can have two possible values ​​HOLDER or RESERVE.
3. Users table : id, nif, name, surname.

In the models I have created the corresponding relationship functions:

Course model :

public function courseUsers()
{
    return $this->belongsToMany(User::class)->withPivot('inscription_type')->withTimestamps();
}

User model :

public function userCourses()
{
    return $this->belongsToMany(Course::class)->withPivot('inscription_type')->withTimestamps();
}

What I need to obtain is the relationship of all the existing courses with the total enrollment per course, also adding two counter fields where I know the breakdown of the total enrollment obtained per course, indicating how many of those enrollments have the value HOLDER in the inscription_type field and another that indicates how many have the RESERVE value .

The result should be something like this:

I have created the following join:

$courses = DB::table('courses') ->leftJoin('course_user', 'courses.id', '=', 'course_user.course_id') ->select('courses.*', DB::raw('count(*) as TotalMatriculas')) ->groupBy('courses.id') ->get(); 

With this I get all the courses with the total number of enrollments that each one has, but I don't know how to obtain now the count of the enrollments that are of the OWNER type and those that are of the RESERVE type.

I appreciate your help.

All the best.

I import records using the Laravel/Excel library. Everything works fine but I would like to get the total number of records imported when the action is performed.

How can I get this data?

I currently have the following code:

Import class where I define the variable $numrows that is increased for each iteration in the import process and I create a getter method to obtain the data stored in it from the controller.

private $numrows = 0;

public function collection(Collection $rows)
{
    $cod_cliente = auth()->user()->client->id;

    foreach ($rows as $row) 
    {

        $this->$numrows++;

        /*Asignación de Cód Employee */
        $cod_employee = 'CNT-' . $cod_cliente . '-' . $row['cod_employee'];
       
        $sex = ucfirst($row['sex']);

        Employee::create(
            [
                'cod_employee'      => $cod_employee,
                'sex'               => $sex,
                'age'               => $row['age'],
                'birth_date'        => $row['birth_date'],
                'educational_level' => $row['educational_level'],
                'num_children'      => $row['num_children'],
                'client_id'         => $cod_cliente
            ]
        );
    }
}

public function getRowCount(): int
{
    return $this->numrows;
}

Controller that validates the existence of a file to import and obtains the number of imported records. But here it tells me that the variable $numrows is not defined.

public function importEmployees(Request $request)
{
    $validatedData = $request->validate(
        [
            'file' => 'required',
        ]
    );
    
    try {
        $import = new EmployeesImport();
        Excel::import($import, request()->file('file'));

        $totalreg = $import->getRowCount();

        Log::info(
            "¡¡Importación de registros!!. La importación de empleados se ha completado." 
        );

        return redirect()->back()->with(
            'success', 'Datos importados correctamente.'
        );
    } catch (\Throwable $th) {
        Log::error(
            "¡¡ERROR!!. Proceso de importación no completado. Error: "
            . $th->getMessage()
        );

        return redirect()->route('admin.employees.index')->with(
            'error', 'Error de importación. Contacte con el administador del sistema. '
            . $th->getMessage()
        );
    }   
}

All the best.

I expose this topic already treated in different threads that in my case generates an error that I cannot solve.

I have a many-to-many relationship with the Client and Factor models . What I want to do is store in the pivot table client_factor two extra fields, apart from the id of the two related tables ( factor_id, client_id ), which will be pointsfactor (points assigned) and gender (gender).

Client Model

public function clientsFactors()
{
return $this->belongsToMany(Factor::class, 'client_factor')->withPivot('pointsfactor', 'gender');
}

Model Factor

public function factorsClients()
{
return $this->belongsToMany(Client::class, 'client_factor')->withPivot('pointsfactor', 'gender');
}

Client_factor Pivot Table Migration

public function up()
{
 Schema::create(
  'client_factor', function (Blueprint $table) {
      $table->id();
      $table->foreignId('factor_id')->constrained('factors')->onDelete('cascade');
      $table->foreignId('client_id')->constrained('clients')->onDelete('cascade');
      $table->integer('pointsfactor')->default(0);
      $table->string('gender')->nullable();
      $table->timestamps();
     }
 );
}

I collect the data to insert in the pivot table from a form that returns 3 arrays ( factor_id[], pointsfactor[], gender[] ).

ArrayFactor_id

array:15 [▼
0 => "1"
1 => "2"
2 => "3"
3 => "4"
4 => "5"
5 => "6"
6 => "7"
7 => "8"
8 => "9"
9 => "10"
10 => "11"
11 => "12"
12 => "13"
13 => "14"
14 => "15"
]

Array Factor

array:15 [▼
0 => "5"
1 => "5"
2 => "15"
3 => "5"
4 => "25"
5 => "5"
6 => "5"
7 => "10"
8 => "5"
9 => "8"
10 => "5"
11 => "5"
12 => "5"
13 => "25"
14 => "5"
]

ArrayGender

array:15 [▼
0 => "NEUTRO"
1 => "NEUTRO"
2 => "FEMENINO"
3 => "MASCULINO"
4 => "MASCULINO"
5 => "NEUTRO"
6 => "NEUTRO"
7 => "MASCULINO"
8 => "NEUTRO"
9 => "FEMENINO"
10 => "FEMENINO"
11 => "FEMENINO"
12 => "NEUTRO"
13 => "NEUTRO"
14 => "NEUTRO"
]

To save the data in the pivot table, I pass the array with the id of the factors and the arrays with the data of the additional columns to the sync method.

$factores = $request->factor_id;
$puntos = $request->pointsfactor;
$genero = $request->gender;

$client->clientsFactors()->sync(
  [
     $factores => [
       'pointsfactor' => implode(",", $puntos),
       'gender' => implode(",", $genero)
     ]

  ]
);

But it generates the following error: Error message: Illegal offset type

What am I doing wrong? How should I insert the additional fields in the pivot table?

Thank you...

I am going to reformulate the question because I think I have not oriented it as I should.

Currently I have two tables in database TypeFactors , Factors with relation 1:N.

To obtain the data of these tables, I perform the following query:

$factors = DB::table('type_factors')
        ->join('factors', 'type_factors.id', '=', 'factors.typefactor_id')
        ->select('type_factors.typename', 'factors.typefactor_id', 'factors.factorname')
        ->get();

And I get a result of the type:

What I would like now is to be able to group the obtained data in a multidimensional array before passing it to the view; of the type :

Example:

[
  "Conocimiento y Aptitudes" => [
     // Aquí todos los resultados, con el mismo typename "Conocimiento y Aptitudes"
   ],
  "Responsabilidad" => [
     // Aquí todos los resultados, con el mismo typename "Responsabilidad"
  ],
  // ...
]

Thanks in advance.

All the best.

Good morning companions.

Currently, I perform the following queries to calculate the total number of potential clients ($clientsusersp) and loyal clients (clientsusersf). My query is the following: Can you unify these two queries into one to optimize the code?

$clientsusersp = DB::table('users')
                ->selectRaw('users.*, clients.user_id, count(*) as cuentap')
                ->join('clients', 'users.id', '=', 'clients.user_id')
                ->where('loyalcustomer', '=', 0)
                ->groupBy('users.id')
                ->get();

$clientsusersf = DB::table('users')
            ->selectRaw('users.*, clients.user_id, count(*) as cuentaf')
            ->join('clients', 'users.id', '=', 'clients.user_id')
            ->where('loyalcustomer', '=', 1)
            ->groupBy('users.id')
            ->get();

Thanks to everyone beforehand.

All the best.

Laravel 8 throws me the error array_merge(): Expected parameter 2 to be an array, int given when updating a record in the database. However, if you update the registry and I don't see where the problem is. I leave you the code to see if you can tell me what the problem is.

Controller:

try {
        $showclient = Client::findOrfail($id);
        
        $showclient->update(
            [
                'cif'  =>  $request->cif,
                'company'   =>  $request->company,
                'corporateaddress'  =>  $request->corporateaddress,
                'postalcode'    =>  $request->postalcode,
                'locality'  =>  $request->locality,
                'province'  =>  $request->province,
                'telephone' =>  $request->telephone,
                'mobile'    =>  $request->mobile,
                'type'  =>  $request->type,
                'contactname'   =>  $request->contactname,
                'telephonecontact'  =>  $request->telephonecontact,
                'mobilecontact' =>  $request->mobilecontact,
                'emailcontact'  =>  $request->emailcontact,
            ]
        );

        Log::info(
            '¡¡CLIENTE ACTUALIZADO!!. 
            Actualizados los datos del cliente con ID: '
            . $request->id
        );

        return view('admin.clients.show', $showclient->id)->with(
            'success', 
            'Los datos del cliente indicado han sido actualizados correctamente.'
        );
    } catch (\Throwable $th) {
        Log::error(
            '¡¡ERROR EN ACTUALIZACIÓN DE CLIENTE!!, Operación Cancelada. 
            Mensaje de error:' . $th->getMessage()
        );
        
        return redirect()->route('admin.clients.index')->with(
            'error', 'Error en el proceso de actualización. 
            Contacte con el administrador del sistema. Error: '
            . $th->getMessage()
        );
    }

Thanks in advance, regards.

I present a problem that arises and that is driving me crazy. I have an application developed in Laravel 8. In the list I implement a button to be able to delete records from it. Before deleting a record, confirmation is requested through a modal window that receives a series of data by jquery.

My problem is that for some reason everything works perfectly but only on the first 10 records of the list, that is, if I perform a search, expand the list of records or change the page, the delete button does not activate the modal window and therefore does not you can perform the deletion of the desired record.

This would be a listing model:

The code implemented in the delete button is as follows:

<button type="button" class="btn btn-danger btn-sm btnDelInfo" title="Eliminar registro" data-toogle="modal" data-modalreg="{{action('RoleController@destroy', $rol->id)}}" data-modalid="{{$rol->id}}" data-modalname="{{$rol->rolename}}"><i class="zmdi zmdi-hc-fw"></i></button>

When we press the delete button, it executes the following script:

    <script>
    $(document).ready(function() {
        $('.btnDelInfo').click(function(event) {
            event.preventDefault();
            var button = $(this);
            var modalreg = button.data('modalreg');
            var modalid = button.data('modalid');
            var modalname = button.data('modalname');

            $('#formModal').attr('action', modalreg);
            $('.modalid').html(modalid);
            $('.modalname').html(modalname);
            $('#defaultModal').modal('show');
        });
    });
</script>

Does anyone have an idea why it only works on the first ten records?

PS: The rest of the records correctly implement the button code but do not execute it.

A greeting and thanks in advance.

After performing validation on a radiobutton set I need the form focus to move to a form element.

I have created a function that works perfectly (validates the fields and activates div with an error message) but it does not move the focus to the indicated element.

Can someone point me to what I'm doing wrong?

Html code:

<div id="txtotronodo" style="display: none;">
<input type="text" id="reply6" name="txtotronodo" class="form-control col-sm-12" placeholder="Indique el nodo">
</div>

JQuery code:

$(document).ready(function() {
    function validaNodo() {
        var nodo = $("input[name=nodo]:radio:checked").length;
        if (nodo !== 1) {
            $("#nodo").css("display", "block");
            $(document).on('focus', 'reply6');
            $('reply6').focus();
            event.preventDefault();
        }
        else {
            $("#nodo").css("display", "none");
        }
    }
});

A greeting and thanks in advance.

I am working with Laravel 5.8 and I would like if it is possible that someone could help me with the following topic. I would like to store the contents of a collection in text format in a variable.

The query is as follows:

$dependentjobs = DB::table('users')->join('jobs', 'users.job_id', '=', 'jobs.id')
                            ->select('jobs.jobname')
                            ->where('users.topjob_id', '=', $userselected->job_id)
                            ->get();

Once I have obtained the query data, I convert it into an array

if ($dependentjobs->count() > 0) {
            $jobs = $dependentjobs->pluck('jobname');
        }

So far everything is correct. What I would like now is to be able to save the array values ​​as a string in a variable to pass to the view.

I've tried looping through $jobs with a foreach, but it gives me an error.

All the best.

Good afternoon everyone.

I am starting to work with Laravel 5.8 and I have created a user management using the authentication that Laravel mounts by default.

I have included a new field called state in the database to deactivate users and thus avoid having to delete them.

I know this topic has already been seen but I'm still a little green in the framework and structure that Laravel uses for files.

What I want is to be able to check if a user has the state field active (1) in addition to their username and password before giving access to the control panel.

Can someone guide me which class or classes I should modify and how?

Thanks for everything.

I am starting to work with Laravel 5.8. and although I am making good progress there are issues that I cannot control, so I ask you for help to see if someone can tell me what should be done.

I am developing a CRUD that, among many other relationships and tables, has a table of categories and another of subcategories with a 1:N relationship.

When I register a new subcategory in the corresponding form, I have a select in which I indicate the category to which it belongs, which stores the id corresponding to the selected category in the subcategories table.

My problem comes when I want to edit said record. How should I do so that when editing the record the select shows selected the category to which said subcategory belongs.

I hope I have explained clearly.

Greetings and thanks in advance to all.

Good afternoon mates.

I would like to save in a session variable the value of two fields that I pass through $_post from a form and that this session variable stores the data of said fields until I destroy it with the intention of being able to fill a table with the stored data in the same.

Can someone tell me how I should store the form data in a session array?

I am using Php. My code is the following but I get an error:

Array String conversion.

$art = $_POST["select-productos"];
$und = $_POST["und-productos"];

$productos = array("articulo" => $art, "cantidad" => $und);

if (empty($_SESSION["listadecompra"])) {
    $i = 0;
    $_SESSION["listadecompra"][$i] = $productos;
} else {
    $i = count($_SESSION["listadecompra"]);
    $i++;
    $_SESSION["listadecompra"][$i] = $productos;
}

/* Creamos tabla de contenido */
$listado = $_SESSION["listadecompra"];

foreach ($listado as $value) {
   echo "<tr><td>" . $value . "</td><td>" . $value . "</td></tr>";
}

//var_dump($_SESSION["listadecompra"]);
echo "Total de productos: " . $i . "<br>";

What I intend is to be able to increase the array that I store in the session with the data that I receive from the form and then display them in a table.

All the best.

I debut in this community with the following doubt that I do not finish seeing.

If I create a class in which I establish some properties and methods of type static, how can I later retrieve the value of those properties from another file?

Example:

final class website {

    public static $valor;

    private function __construct() {

    }

    public static function setValor($x) {
        self::$valor= $x;        
    }

    public static function getValor() {
        return self::$valor;
    }
}

If I try to do this from another .php file the result I get is null.

website::getValor();

Can someone give me an idea?

Thank you