Juan Pablo B's questions

I have a production system made in Laravel and Postgress and one of the migrations creates a view as follows:

 $statement = "CREATE VIEW property_view AS SELECT property.id as property_id, ";

 foreach($this->sections as $section) {
            $statement = array_reduce($section->getFillable(), function($statement, $field) 
 use ($section) {
                return $statement .= "{$section->getTable()}.{$field}, ";
            }, $statement);
        }

        return rtrim($statement, ", ");

This works very well, but now a new field has been added to one of the tables, so being in production I cannot modify the previous migration and create a new one and there I tried several ways to add this field but without success:

 DB::statement("ALTER VIEW property_view ADD COLUMN apn_number VARCHAR");

It is worth remembering that it is postgress

I have in laravel a model called cropGathering that has a hasMany relationship with cropGatheringTransaction. The latter has a tons attribute, so what I need is to fetch all the cropGatherings, where the sum of the tons of their transactions is greater than 0.

In the cropGathering model I have the relationship:

 public function cropGatheringTransactions()
    {
        return $this->hasMany(CropGatheringTransaction::class);
    }

What I tried and had no success was the following:

  public function all($perPage, $orderBy = 'id', $order = 'desc')
    {
        return CropGathering::whereHas('cropGatheringTransactions', function ($q) {
                $q->groupBy('crop_gathering_transaction.id')
                    ->havingRaw('SUM(crop_gathering_transaction.tons) > 0');
            })
            ->orderBy($orderBy, $order)
            ->paginate($perPage);
    }

I also tried the following, I defined in the cropGathering model an append:

protected $appends = ['tons'];

where I get the sum of their transactions:

 public function getTonsAttribute()
    {
        return $this->cropGatheringTransactions()->sum('tons');
    }

And when testing:

CropGathering::sum('tons', '>', 0)

tells me:

Undefined column: 7 ERROR: column \"tons\" does not exist

I have the following query

SELECT  users.name as Nombre, users.surname as Apellido, users.email, provinces.name as Provincia, contactInfos.contactType AS tipo, contactInfos.value as Numero
FROM clients 
INNER JOIN loans ON loans.client_id = clients.id
INNER JOIN loansTypes ON loansTypes.id = loans.loanType_id
INNER JOIN users ON users.id = clients.user_id
LEFT JOIN locations ON clients.location_id = locations.id
LEFT JOIN provinces ON provinces.id = locations.province_id
LEFT JOIN contactInfos ON contactInfos.id = clients.phone_id OR contactInfos.id = clients.cellPhone_id
WHERE loansTypes.display_name = "Sitio privado" 

Where the table that gives me problems is:

LEFT JOIN contactInfos ON contactInfos.id = clients.phone_id OR contactInfos.id = clients.cellPhone_id

Why do I get the following

| nombre | apellido | email | provincia | tipoContacto | numero|
|--------|----------|-------|-----------|--------------|-------|
|  A     |    B     |[email protected]|    C      |   TELEFONO   |  345  |
|------------------------------------------------------|-------|
|  A     |    B     |[email protected]|    C      |   CELULAR   |   654  |
----------------------------------------------------------------

where type of contact is telephone or cell phone and I would like to have EVERYTHING in a single record

Name, surname, email, province, cell phone and telephone

I have 2 hours to add up and store in a Long attribute called duration, so I do:

    String source1 = "05:15:30";
    String[] tokens1 = source1.split(":");
    int secondsToMs1 = Integer.parseInt(tokens1[2]) * 1000;
    int minutesToMs1 = Integer.parseInt(tokens1[1]) * 60000;
    int hoursToMs1 = Integer.parseInt(tokens1[0]) * 3600000;
    int total1 = secondsToMs1 + minutesToMs1 + hoursToMs1;

Then I add another hour:

    String source12 = "03:05:10";
    String[] tokens12 = source1.split(":");
    int secondsToMs12 = Integer.parseInt(tokens12[2]) * 1000;
    int minutesToMs12 = Integer.parseInt(tokens12[1]) * 60000;
    int hoursToMs12 = Integer.parseInt(tokens12[0]) * 3600000;
    int total12 = secondsToMs12 + minutesToMs12 + hoursToMs12;

and calculate the sum of both:

Long t = new Long(total1) + new Long(total12);

Now if I show the total again in hh:mm:ss format, the sum of both shows me:

String hms = String.format("%02d:%02d:%02d", TimeUnit.MILLISECONDS.toHours(t),
        TimeUnit.MILLISECONDS.toMinutes(t) % TimeUnit.HOURS.toMinutes(1),
        TimeUnit.MILLISECONDS.toSeconds(t) % TimeUnit.MINUTES.toSeconds(1)); 


System.out.print(hms);

10:31:00

but it would have to show me a total of:

08:20:40

I am using java and I have the following scenario.

The season entity one of the attributes is duration and a season can have many chapters, for each chapter that is added to a season, the duration of all the chapters is added and added to the season.

I am doing the following:

 res.getTemporada().setDuracion(res.getTemporada().getDuracion() +  res.getDuracion());

At the length of the season:

res.getTemporada().getDuracion()

I add the duration that I bring from the view of the new chapter, but the sum does not work in this conventional way

res.getDuracion()

Duration are of type Time

I have the following code which has the directive<count-characteres>

 <label class="control-label"><cr/>Género <count-characters c-name="genero"></count-characters></label>
        <div class="input-group">
           <input type="text" name="genero" class="form-control" name="genero" equired="" ng-model="produccionGeneroSel.genero" ng-maxlength="{{validations.genero.maxlength}}">
          <span class="input-group-addon"><i class="fa fa-font"></i></span>
        </div>

What I am trying to do is that when I start writing to it, it inputstarts a counter of remaining characters and when I exit inputit it disappears and I am not being able to call the directiva, passing the maxlengthand it knows what inputI am writing in. I tried $watchbut I couldn't get it to work

app.directive('countCharacters', ['$injector', function ($injector) {
        return{
            retric:'E',
            replace: true,
            scope:{
                cName: '=name'
            },
            template: function(){
                return '<span>caracteres restantes</span>';  },

            link: function($scope, element, $attrs){


            }
        };

    }]);

I plan to use it for the tag namein inputcase there are several in the same form.

I have a component that is a table and I have a search button with the following event.

datatables component:

<input type="text" class="form-control" @keyup="$emit('filterSearch')" v-model="search">

and in component B I import this component:

template>    
    <datatables  @filter-search="filterSearch()">
    </datatables>
</template>



<script>
    import datatables from '../tables/datatables';
    // import pagination from '../tables/pagination';

    export default {
        name: "userdraw",

        components: {
            datatables: datatables
        },
        methods: {
            filterSearch(){
                alert(1);
            },
        }
    }

</script>

The issue is that when I write in the search input some letter/word I want a method to be executed in the parent component, but I never get the filterSearch alert!

I have 2 PHP files.

The first is called data.php and has

<?php

$get = $_GET;

if (isset($get['getBoxes']) && $get['getBoxes'] == 'what-we-do') {
    $boxes = array(
        array(
            'title' => 'e-commerce',
            'color' => '#ff910f',
            'content' => 'As your E-Commerce partner we will identify your specific needs, build solutions that will make your operations stronger, and provide a powerful web presence.',
        ),
        array(
            'title' => 'mobile & social',
            'color' => '#ffd11a',
            'content' => 'Be it iOS, Android or Windows Phone, we can accommodate your specific needs for your ideal mobile application.',
        ),
        array(
            'title' => 'open source cms',
            'color' => '#39a91f',
            'content' => 'Every good open-source CMS system allows for great flexibility to be customized and extended. Let us help you build yours.',
        ),
        array(
            'title' => 'software development',
            'color' => '#17b5ff',
            'content' => 'Our development services help you address evolving business and technology challenges by building applications tailored to meet your business requirements.',
        ),
        array(
            'title' => 'interactive design and usability',
            'color' => '#6b6bff',
            'content' => 'We are a full-service user interface design firm offering information architecture, interaction design, and full visual design.',
        ),
    );

    echo json_encode($boxes);
    exit;
}

if (strpos($_SERVER['REQUEST_URI'], basename(__FILE__)) !== false) {
    header("HTTP/1.1 404 File Not Found", 404);
    exit;
}

And from a second PHP file called html.php I want to use the $boxes array but I don't know how to access it since it's inside $get.

I have the following table generated with Datatables:

Now, inside the Prize column, I want to create a regular table (without datatables), the way I do it is by calling a function called insertTablePositionDraw;

"columns": [                        
    {
        "data": "prize_money",
        "name": "draws.prize_money",
        "mRender": function (data, wea, row, meta) {
             return row.prize_money
                ? '$<strong>' + data + ' </strong>' +
                '<i class="fa fa-bar-chart create-prize-money" aria-hidden="true" data-toggle="modal" data-target="#modalCreatePrizeMoney"></i>' +
                  '<br/>' + (row.positions != "" ? insertTablePositionDraw(row.positions) : '')
                    : '';
              }
    },
 ]

The called function is the following:

function insertTablePositionDraw(data){

   return '<table class="table table-bordered">' +
           '<thead>'+
                '<tr>' +
                     '<th class="text-center">Posición</th>' +
                     '<th class="text-center">Premio</th>' +
                '</tr>' +
           '</thead>'+
           '<tbody>'+
                $.each(data, function(index, item){
                   `<tr>`+
                       `<td>`+
                           data.position;
                        `</td>`+
                        `<td>`+
                           data.pivot.dato;
                        `</td>`+
                   `</tr>`
                })
           '</tbody>'
      '</table>'
}

in this way it does not create the table correctly, it does not show me the data

I have 2 components inside /resources/assets/js/components, the first one has:

 <template>
    <div class="inline">
              <button @click="getDataCategory(category)" :class="is_active == category.id ? 'btn-primary' : 'btn-default' " v-for='category in categories' class='btn btn-space'>{{category.name}}</button>     
    </div>
</template>

<script>
    import BaseUrlMixin from '../mixins/baseUrl.js'; 

    export default { 
        mixins: [BaseUrlMixin],           
        data(){
            return{
               id_tournament:null,
               categories:[],
               data_category: false, 
               is_active: false, 
               show_data: "",
            }
        },
        methods: {             
          getDataCategory: function(category){
              this.is_active = category.id;
              this.show_data = {
                  'category':category.name
              };
              this.data_category = true;
          }
        }, 
    }
</script> 

The idea is that when you click on the button, call getDataCategory() and there set this.show_data as you see it, and so far it works, now I need to pass that this.show_data to another component that is the following. I want to use as seen in the form the if="show_data" has values ​​to show the form. (I understand that you can put this component inside the other, but due to the structure of the template I can't and I need this communication.

<template>
    <div>
        <form @submit.prevent="store()" :if="show_data">
          <label for="">Cantidad de fechas</label>  
          <input type="text" v-model="date" onkeypress='return event.charCode >= 48 && event.charCode <= 57' min="1" max="50" required="">
          <button class='btn btn-primary btn-sm' >
              <i class="fa fa-floppy-o" aria-hidden="true"></i>
              Guardar
          </button>
        </form>
    </div>
</template>

<script>

    export default {
       data(){
            return{
               id_tournament:null,
               date:'',
            }
        },
        methods: {
        },
        mounted() {     

            this.getIdTournament();
        } 
    }
</script> 

I have the following form:

 <form action="#" method="post" role="form" class='forms' id="frmDeleteRoundCategory">
         {{ csrf_field() }}
         <input type="hidden" name="id_round" id='id_round' />
         <input type="hidden" name="id_category" id='id_category' />

          <p class="alert alert-danger">
              ¿ Eliminar la ronda <strong class="round"></strong> de la categoría  <strong class="category"></strong>?
          </p>

          <div class="button-group modal-footer" >
               <button  type="button" data-dismiss="modal" aria-label="Close" class="btn btn-default">
                    <i class="fa fa-close" aria-hidden="true"></i> Cerrar
               </button>
               <button type="submit" class=" btn btn-danger">
                        <i class="fa fa-trash" aria-hidden="true"></i> Eliminar
               </button>
         </div>
</form>

The form data is sent by JS

  //DELETE
  $("#frmDeleteRoundCategory").submit(function (e) {
     e.preventDefault(); 

      axios.delete("/round_category/" + $("#frmDeleteRoundCategory #id_round").val(), $(this).serialize())
            .then(function (response) {                         
                toastr.success(response.data);
            });  
  });

I have the route defined as:

Route::resource('round_category', 'RoundCategoryController');

And I have the destroy method in the controller:

public function destroy(Request $r, $id_round) {            
        dd($r->all());       
}

When sending the data, the dd() shows me an empty array [].

I tried doing console.log($(this).serialize()); and it shows me the data well:

_token=kvvSzXwBABQFjami6EHXxYmtXQtxe7AgKYvpu24y&id_round=5&id_category=13

I have 5 other ABMs with the axios.delete method copied as is and they work perfectly. I only have a problem with this Delete, where axios is not sending the data or there is something that I am not seeing. Because following the steps I have everything defined:

1) I have the route defined Route:resource... 2) I capture the event with js and send the data with axios.delete 3) The call reaches the destroy method, but without the data.

Following the Laravel documentation, it says that it is unnecessary to keep versioned css and js in development which seems correct to me. So I did the following, I have in webpack.mix.js:

     mix.js('resources/assets/js/app.js', 'public/js')
        .js('resources/assets/js/mol.js', 'public/js')
        .sass('resources/assets/sass/app.scss', 'public/css')
        .sass('resources/assets/sass/mol.scss', 'public/css')
        .sass('resources/assets/sass/login.scss', 'public/css');

        if (mix.inProduction()) {
            mix.version();
        }

In the .env I have

APP_ENV=production

and to compile I do npm run production, but it doesn't work for me. This way you don't add the hash to the js and css.

Now if I add .version to the end of mix.js(...).version(); there if it works for me, but both in development mode and in production mode.

I have a login form and a registration form and the problem is with the email. If I do not add the email type in the validation rules:

'email' => 'required|unique:users,email',

and without wanting to register an email with spaces at the beginning or at the end, it registers it: for example: " [email protected] ", giving an error later when logging in.

Now, if I add the type email:

'email' => 'required|unique:users,email',

and I want to register and accidentally add a space, it tells me that the email entered is not valid.

In my opinion, shouldn't it be allowed to add with leading or trailing spaces, and then remove at check-in?

I have the following function:

 public function searchJoin(){
     $first = $this->getModel()   
                ->join('tarea_x_usuario', 'tarea_x_usuario.idTarea', '=', 'tarea.id')
                ->rightJoin('usuario', 'usuario.id', '=', 'tarea_x_usuario.idUsuario')
                ->join('role_x_usuario', 'role_x_usuario.idUsuario', '=', 'usuario.id')
                ->join('role', 'role.id', '=', 'role_x_usuario.idRole')                
                ->get();


        return $this->getModel()
                ->join('tarea_x_usuario', 'tarea_x_usuario.idTarea', '=', 'tarea.id')
                ->rightJoin('usuario', 'usuario.id', '=', 'tarea_x_usuario.idUsuario')
                ->join('role_x_usuario', 'role_x_usuario.idUsuario', '=', 'usuario.id')
                ->join('role', 'role.id', '=', 'role_x_usuario.idRole')
                ->where('role.role','=','ADMINISTRADORR')
                ->union($first)
                ->get();

    }

It throws me the following error:

BadMethodCallException in Macroable.php line 74: Method getBindings does not exist.

I also tried doing the following query:

public function searchJoin() {

$first = $this->getModel()
        ->join('tarea_x_usuario', 'tarea_x_usuario.idTarea', '=', 'tarea.id')
        ->rightJoin('usuario', 'usuario.id', '=', 'tarea_x_usuario.idUsuario')
        ->join('role_x_usuario', 'role_x_usuario.idUsuario', '=', 'usuario.id')
        ->join('role', 'role.id', '=', 'role_x_usuario.idRole')
        ->where('role.role', '=', 'ADMINISTRADORR')
        ->get();


$two = $this->getModel()
        ->join('tarea_x_usuario', 'tarea_x_usuario.idTarea', '=', 'tarea.id')
        ->rightJoin('usuario', 'usuario.id', '=', 'tarea_x_usuario.idUsuario')
        ->join('role_x_usuario', 'role_x_usuario.idUsuario', '=', 'usuario.id')
        ->join('role', 'role.id', '=', 'role_x_usuario.idRole')
        ->get();

dd($first->union($two)->get());

}

The two queries work, it throws an error in the union.

The sequence of errors are:

I have 3 tables: Draw, player and round, and in turn a common table for all three having as attributes: id, id_draw, id_player, id_round.

What I don't know is how to build this type of relationships and how to insert data. Since in a many-to-many relationship with two tables it would be: draw->player()->attach(...);

With this type of relationship of 3 tables, I don't know how to insert data and build the belongsToMany relationship.

Relations:

The ternary relationship is given by draw - PlayerATP - Round being the resulting table Matches

I have the following URL: domain.com/user/3/edit.

I would like to know if it is recommended that the user ID appears in the URL, or would a URL be better, such as: domain.com/user/edit.

If the last option is better, how could it be done? modifying Route Route::get to Route::post?

I have the following route:

Route::get('FinDraT/efectivoxpuesto/{id}/index','EfectivoxPuestoController@index');

and in the controller function I do:

 return redirect()->route('FinDraT/efectivoxpuesto/'. $id.'/index');

And it throws me the error that the route is not defined.

I have a web page made with laravel and mysql, and it has enough access to the database, and I would like to know how to measure how many simultaneous users making queries my page can hold.

I have a basic server in digital ocean with the following characteristics:

512MB (1 CPU) 20GB (SSD DISK) 1000GB (Transfer)

and it has many different servers and the highest one has the characteristics:

224GB (1 CPU) 500GB (SSD DISK) 10TB (Transfer)

Really a lot of difference, but beyond that, I don't know when to use one and when to scale to another, which would be scaling vertically. At the same time, I don't know when to scale horizontally, that is, to make replicas of the system, or to have a server that is only for the database.

I would really like to know these questions, before having future problems, even if there are few users.

I am working with Laravel 5.1 in an app that is already working, but I am changing from modules to the repository pattern.

"psr-4": {
    "app\\": "app/",
    "Cms\\": "app/cms"
}

The first is the default namespace and the second is what I am changing and passing to said folder. When I call a controller inside app/cms I get the following error:

Class app\Http\Controllers\CalendarioController does not exist

It's like it never looks in app\cms.

Route::group(['namespace' => 'Calendario'], function() {
       Route::resource('calendario', 'CalendarioController');
});

and the controller namespace as:

namespace Cms\Calendario;

Thanks for your help!

I am using windows 10 and vagrant. When I access vagrant ssh I want to create a folder inside Code which is where all my projects are.

Now, I want to create a folder inside Code and I get the error:

[ErrorException] mkdir(): permission denied.

I also gave it 777 permissions but still can't create the folder.