Posts by KALIBBAN • 262 points
10 posts
-
-1
votes0
answers14
viewsQ: Browse Array with foreach PHP Laravel
Hello I have the following array that is coming from a Collection of Laravel [ {"id":1,"providence_management_id":4,"email":"[email protected]"},…
-
-1
votes1
answer60
views -
0
votes1
answer38
viewsQ: How to search STRING inside JSON on Android
I have the following JSON Create_request.txt {"dados":[{ "Cod_Produto":"25", "Produto":"ARROZ", "Quantidade":"200KG", "Estoque":"300KG", "Valor":"1200", "Num_pedido":"41045"} ]} I created a button…
-
1
votes1
answer1188
viewsA: Formula to return the date only with working days
I arrived at the solution through function DIATRABALLO.INTL You pass the parameters to the function and it will bring you the date correctly =TEXTO(DIATRABALHO.INTL(DATA(2020;1;3);5;1);"dd/m/aaaa")…
-
0
votes1
answer272
viewsA: Connect Sql Server 2014 to Django 2.2
The problem is the compatibility between Django and python, when I used pyodbc with Python 3.4.4 and Django == 2.2.4 worked, and that’s what I did: -install Python 3.4.4 CMD Pip install virtualenv…
-
0
votes2
answers71
viewsA: I have the following query using PDO, but how do I switch to Eloquent Laravel?
foreach ($lista_cnae as $cnpj => $lista) { // $lista = "'" . implode("','", $lista) . "'"; Cnaes::where('cnpj', $cnpj) ->whereNull('data_remocao') ->whereNotIn('cnae',$lista)->update([…
-
-1
votes2
answers71
viewsQ: I have the following query using PDO, but how do I switch to Eloquent Laravel?
This serves for me to report through a timestamp in the column dating if my data has any modification. foreach ($lista_cnae as $cnpj => $lista) { $lista = "'" . implode("','", $lista) . "'";…
-
2
votes3
answers480
viewsQ: How do I know and count the number of rows in an SQL query with Laravel?
$teste = DB::table("cnaes") ->select("id") ->where("cnpj", $cnpj) ->where("cnae", $cnae); How can I know how many lines were affected by this query?…
-
1
votes1
answer176
viewsQ: How to do a regex to take from bar (/) to _, ie I just want the digits before _
/dir/user/Desktop/zip/1_0.zip /dir/user/Desktop/zip/2_0.zip I want to capture only the numbers in bold. I am doing the following and sending to a foreach but it’s not capturing right:…
-
2
votes1
answer87
viewsQ: I’m trying to figure out the size of a downloadable file on an external server
I’m making public function remote_size() { $url = 'http://200.152.38.155/CNPJ/DADOS_ABERTOS_CNPJ_01.zip '; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch,…