Posts by thiagofred • 180 points
13 posts
-
1
votes0
answers42
viewsQ: Program does not return to the loop after executing function
I have a robot that accesses an online system and downloads the files. It works with a delay between one download and another, but is taking time. On this system, I can only close the open tab after…
-
0
votes3
answers101
viewsQ: Return value corresponding to date
I have a table with values and dates referring to the cost of a vehicle. However the table is filled in as follows: data_saida | custo_saida ------------------------- 2019-11-17 | 25 2019-11-18 | 20…
-
1
votes0
answers63
viewsQ: Catch the start and end of the journey record
I have the following situation: I have the following fiddle, with people’s license plates and registration marks. http://www.sqlfiddle.com/#! 15/1405c/20 I tried to make that second fiddle:…
-
2
votes1
answer94
viewsQ: First and Last record including night
I have the following problem I have the data that way: codigo data_hora nome_ajudante -------+----------------+-------------- 1000004 2018-08-22 11:11 Carlos Eduardo 1000004 2018-08-22 11:43 Carlos…
-
0
votes1
answer405
viewsQ: Grab the array id within the session
I have the session $_SESSION['linha_pedagio'][] so disposed: Array ( [0] => Array ( [0] => 2 [1] => CGO - RJA (via Magé) [2] => 96.30 [3] => 2 [4] => 9681 ) [2] => Array ( [0]…
phpasked thiagofred 180 -
0
votes0
answers90
viewsQ: Group weekend and holiday values for next business day
Guys, I have the following problem, I need to group all balance amounts that fall on Saturday, Sunday or holiday for the next working day. I have a table invoices with the values of saldo and the…
-
1
votes0
answers260
viewsQ: Run the webservice via CMD returns NULL
I have the code below that I need to run every hour. This script running by the browser returns the data correctly. Intended to run it via scheduled tasks, by CMD through execution lines:…
-
2
votes1
answer2871
viewsQ: Get values from within stdClass array stdClass
I have this class where I can query and return data from an external webservice: $params = array( 'usuario' => $usuario, 'senha' => $senha, 'quantidade' => 2 ); $wsdl =…
-
2
votes2
answers117
viewsQ: Return records that total desired value
I have a table in this format, with more N values and N suppliers, approximately 100 thousand records, and I need to do through a query or a plpgsql function a way to get all the release numbers num…
-
1
votes1
answer565
viewsQ: Open a modal window for authentication
I have in my code a conditional if that when false should open a window and request the authorization of a user, the password and the justification. If you do not meet the condition, I will add a…
-
1
votes2
answers3493
viewsQ: Pass and receive field id by parameter
I have this html code: <input type="radio" name="resultado" value="Y" onclick="habilitaCampo(this.value)">Aprovado <input type="radio" name="resultado" value="N"…
javascriptasked thiagofred 180 -
3
votes1
answer2356
viewsA: Phpexcel generates corrupted file . xslx
I usually mount header then mount $objWriter and still use ob_end_clean(); to clear any corruption error and after that I export the excel file. Would look like this... header('Content-Type:…
-
0
votes1
answer38
viewsQ: Mark lines where balance sum = 0
I have a table like this below, with the date, one, debit amount, credit value, and the balance sheet value (debit value + 0 - credit value) and I need that each time there is a debit and credit…
postgresqlasked thiagofred 180