GERARDO SELIM RAMIREZ SERRANO's questions

Hello, thank you all for your support.

The issue is that I have a Laravel API already mounted on a hosting, and when I make a post request from my Android application I receive some data that is int and it returns them as a string "333", at first I thought it was the logic of part of the application but when making the request with postman I realized that it was actually from the api, I would like to point out that the same API locally does return the correct data, below I share a fragment of the response:

{
"paginate": {
    "total": 9,
    "current_page": 1,
    "per_page": 15,
    "last_page": 1,
    "from": 1,
    "to": 1
},
"products": {
    "current_page": 1,
    "data": [
         {
            "id": 51,
            "name": "sfsdfsdf",
            "price": "123",
            "desc": "asdasdasd",
            "unit": "paquete",
            "img": "1606592605productoimage.png",
            "created_at": "2020-11-28T19:43:25.000000Z",
            "updated_at": "2020-11-28T19:43:25.000000Z",
            "sin_delantal": "0"
        },

WHAT MAKES ME CURIOUS IS THAT THE ID IS OF INT TYPE AND THIS DOES RETURN IT AS SUCH. The data that does not return correctly are: Price[int] and sin_delanta[tinyint], I would appreciate any help you could provide me.

I need to put the equivalent of an 'as' in a with subquery in an eloquent controller since I need to get properties from the same child table.

$userInfo = auth()->user()->id;
    $projects =  Project::withCount(['project_contents' => function($query){
        $query->where('complete', 1);
    }, 'project_images'])
    ->with(['project_images','project_contents'])
    ->where('user_id', $userInfo)->orderBy('id', 'DESC')-get();

As you can see in the previous code, I am doing two with since I need to obtain the complete properties of those child tables, and I am also doing two withCount to the same tables to obtain the number of columns that belong to the project, in the project_contents table I am doing making a query to get the project_contents that are completed, but I also need to get the project_contents that have another 'type' property that is equal to 'link'.

What I came up with was to do something like this in the same withCount:

withCount(['project_contents' => function($query){
        $query->where('complete', 1);
    }, 'project_contents'=> function ($query){
            $query->where('type', 'link');}, 'project_images'])
    

but when getting the data from count eloquent doesn't know which count to do since the two queries are directed to the same table and in vuejs it is called with the same name:

project.project_contens_count

emphasizing that in vuejs I made a v-for of projects and call the property project.project_contents_count