erDiagram
EMPRESA ||--o{ PRODUTO :tem
EMPRESA ||--o{ USUARIO :tem
EMPRESA ||--o{ PEDIDO :tem
PEDIDO ||--o{ PEDIDO_ITEM :tem
PRODUTO ||--o{ ESTOQUE :tem
EMPRESA {
integer id PK "Id da Empresa"
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
<script src="https://cdn.jsdelivr.net/npm/svg-pan-zoom@3.5.0/dist/svg-pan-zoom.min.js"></script> | |
// window.addEventListener("load", event => { | |
// const tags = document.querySelectorAll('*[id^="mermaid"]') | |
// console.log('tags', tags) | |
// for (var i = 0; i < tags.length; i++) { | |
// console.log('******', tags[i].id) | |
// const pan = svgPanZoom(tags.item(i), { | |
// zoomEnabled: true, | |
// controlIconsEnabled: true, | |
// fit: true, |
This is a sample script for selecting files in Google Drive using HTML select box for Google Apps Script.
Feature of this sample.
- It is a simple and space saving.
- When the folder is selected, the files in the folder are shown.
- When the file is selected, the ID of file is retrieved. Users can use this ID at GAS.
- When a folder is opened, all files in the folder are cached. By this, the second access of the folder is faster.
- It doesn't retrieve all files in Google Drive at once, so the read of files from Google Drive becomes the minimum necessary.
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
{ | |
"list": [ | |
{"codigo":"1000", "descricao": "ENTRADAS OU AQUISIÇÕES DE SERVIÇOS DO ESTADO"}, | |
{"codigo":"1100", "descricao": "COMPRAS PARA INDUSTRIALIZAÇÃO, COMERCIALIZAÇÃO OU PRESTAÇÃO DE SERVIÇOS"}, | |
{"codigo":"1101", "descricao": "Compra para industrialização ou produção rural"}, | |
{"codigo":"1102", "descricao": "Compra para comercialização"}, | |
{"codigo":"1111", "descricao": "Compra para industrialização de mercadoria recebida anteriormente em consignação industrial"}, | |
{"codigo":"1113", "descricao": "Compra para comercialização, de mercadoria recebida anteriormente em consignação mercantil"}, | |
{"codigo":"1116", "descricao": "Compra para industrialização ou produção rural originada de encomenda para recebimento futuro"}, | |
{"codigo":"1117", "descricao": "Compra para comercialização originada de encomenda para recebimento futuro"}, |
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
unit IntegerHelper; | |
interface | |
type | |
TIntegerHelper = record helper for integer | |
function toRomans: String; | |
end; |
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
unit VariantsHelper; | |
interface | |
type | |
TVariantsHelper = record helper for variants | |
function ValueInRange(const ARange: array of Variant): Boolean; | |
end; | |
implementation |
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
function MonthName(n: Integer): String; | |
const | |
aMeses :array[0..11] of String = ( 'Janeiro', 'Fevereiro', 'Mar�o', 'Abril', 'Maio', 'Junho', | |
'Julho', 'Agosto', 'Setembro', 'Outubro', 'Novembro', 'Dezembro' ); | |
begin | |
Result := aMeses[n-1]; | |
end; |
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
unit BitmapHelper; | |
interface | |
uses FMX.Graphics; | |
type | |
TBitmapHelper = class helper for TBitmap | |
function ToBase64 :String; | |
end; |
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
unit FormHelper; | |
interface | |
uses Forms; | |
type | |
TFormHelper = class helper for TForm |
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
unit JsonObjectHelper; | |
interface | |
uses DBXJSON, Character; | |
type TJsonObjectHelper = class helper for TJsonObject | |
public | |
//Helper to find a JSON pair based on the pair string part | |
function Get(const PairName: UnicodeString): TJSONPair; overload; |
NewerOlder