This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
FROM php:8.2-fpm-alpine AS build-base | |
# Install build packages | |
RUN apk update && apk add --no-cache --virtual \ | |
build-essentials \ | |
linux-headers \ | |
curl \ | |
git \ | |
grep \ | |
build-base \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
'PDUPREC' AS "TABELA", | |
PDUPREC.MLK_IDREFINT, | |
VDUPREC.EMPRESA, | |
VDUPREC.CLIENTE AS NUMEROCM, | |
CONTAMOV.NOME AS CONTAMOV_NOME, | |
NULL AS CONTAMOVLAN_TIPO, | |
NULL AS CONTAMOVLAN_SEQCM, | |
VDUPREC.DUPREC, | |
VDUPREC.HISTORICO, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
'PDUPREC' AS "TABELA", | |
PDUPREC.MLK_IDREFINT, | |
VDUPREC.EMPRESA, | |
VDUPREC.CLIENTE AS NUMEROCM, | |
CONTAMOV.NOME AS CONTAMOV_NOME, | |
NULL AS CONTAMOVLAN_TIPO, | |
NULL AS CONTAMOVLAN_SEQCM, | |
VDUPREC.DUPREC, | |
VDUPREC.HISTORICO, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
if (!function_exists('value')) { | |
/** | |
* Return the default value of the given value. | |
* | |
* @param mixed $value | |
* @return mixed | |
*/ | |
function value($value) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Dropa a trigger antiga | |
DROP TRIGGER itinerario_total_km_data_hora ON coleta.itinerario; | |
-- Altera o tipo do campo | |
ALTER TABLE coleta.itinerario ALTER COLUMN data_hora_total TYPE interval(6) USING data_hora_total::interval; | |
-- Cria a nova função | |
CREATE OR REPLACE FUNCTION coleta.itinerario_atualiza_km_duracao() | |
RETURNS trigger | |
LANGUAGE plpgsql |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[ | |
{ | |
"type": "quality", | |
"collectionInField": "2020-03-16", | |
"service": "providers", | |
"samples": [ | |
{ | |
"type": "valid", | |
"identifier": "424584559", | |
"analyzed": "2020-03-20T00:00:00", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
$batch = $firestore->batch(); | |
$ref = $firestore->collection('teste')->document($collect); | |
$batch->update($ref, [ | |
['path' => 'nome_usuario_coleta', 'value' => 'Teste de Atualização em Batch'] | |
]); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$request->validate([ | |
'id_coleta' => 'required|uuid', | |
'alizarol' => 'required|string', | |
'codigo_produtor' => 'required|numeric', | |
'data' => 'required|date_format:Y-m-d H:i:s', | |
'hora_chegada' => 'required|date_format:H:i', | |
'hora_saida' => 'required|date_format:H:i', | |
'id_equipamento' => 'required|uuid', | |
'id_itinerario' => 'required|uuid', | |
'id_laticinio' => 'required|uuid', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Financeiro: | |
Contas a receber: | |
- Geração | |
- Quitação | |
- Edição | |
- Reparcelamento | |
- Recebimento com cheque | |
- Recebimento com dinheiro | |
- Recebimento com cartão |