Posts by douglas pjuizfora • 162 points
13 posts
-
1
votes3
answers99
viewsQ: Sum of groups in an SQL
I need to do the TOTAL sum per office of a field of hours that is in decimal format, in addition, perform the conversion of it. I can do the sum of the employees, but I can’t add up to "groups" of…
-
2
votes1
answer133
viewsQ: Wherein problem using array
I have a system where I need to list some employees. This listing will depend on the supervisor’s department code. Ex: If the supervisor is from department 206, he can access all data from the…
-
-1
votes2
answers54
viewsQ: for/if PHP omitting element
I have a big problem. I have a PHP/LARAVEL system that issues PDF reports. The system it is omitting an element when placing it in an array. I believe it’s time to assemble the loop and make the…
-
2
votes2
answers6936
viewsQ: Average C using vectors
I started my journey on C two days ago. I went to try to develop a function that averaged certain numbers of a vector. The function has some problem since it was to return the value of 4,5 and is…
-
0
votes1
answer166
viewsA: SUM operation doubling query value - Laravel
SOLUTION: I actually had to rethink the strategy. Instead of doing a single query I made several querys because the error was in the leftjoin where I used the COALESCE(SUM()) So I separated the…
-
0
votes1
answer166
viewsQ: SUM operation doubling query value - Laravel
I am with a query that is with some problem in which I cannot identify. I need to bring up the additional sum and journey. The problem is that when I add in the bank the value of the journey and no…
-
0
votes4
answers440
viewsA: How to Fill in the field when the field is empty in PHP?
Try this below: $examesEquipamentos = []; $limite_superior = ""; foreach ($csv as $linha) { if(trim($linha['LIMITE_SUPERIOR']) == null){ $limite_superior = 0; }else{ $limite_superior =…
-
1
votes1
answer236
viewsQ: Count returning null value with Query Builder Laravel
I have a problem, I have a query that searches the employee data plus the sum of vacation days and absences that an employee has. The query is working if the employee has some day registered in the…
-
0
votes1
answer87
viewsA: Laravel Mysql - display the amount of records in a Join query
Try to do something like this: $empresas = DB::table('empresas') ->join('departamentos', 'empresas.id', '=', 'departamentos.empresas_id') ->join('eventos', 'eventos.departamentos_empresas_id',…
-
3
votes2
answers299
viewsA: Select Laravel Entering Next Record Alone
The interesting thing would be to post your entire controller. To be able to analyze how it is working. <div class="form-group col-md-8"> <label>Exercicio</label> <select…
-
0
votes1
answer131
viewsQ: Create tag select by checking Jquery Checkbox
I don’t know if what I’m thinking is viable. I have a form that dynamically creates several checkboxes with the dates of the month. However, I need when the user checks one of these dates to create…
-
-1
votes1
answer23
viewsQ: Loop(For) doubt with information coming from the database
E ae personal blz ? I’m having a big problem executing a code of my own. I have a web application made in Windows, which is running locally. In this application I need to generate a report that is…
-
3
votes2
answers1254
viewsQ: Assign value to a specific input
Good morning person, I’m having trouble coming up with a code. I have several inputs that are created dynamically. I need to take the ID of the specific element to change its value. EX: I have the…