6NJURy5G

1class SQLiteContract {
2
3
4    companion object {
5        @JvmField
6        val DATABASE_NAME = "chronos_afv"
7        @JvmField
8        val DATABASE_VERSION: Int = 1
9    }
10
11    abstract class Cliente : BaseColumns {
12        companion object {
13
14            @JvmField
15            val TABLE_NAME = "cliente"
16
17
18            @JvmField
19            val COLUMN_NAME_ID = "id"
20            @JvmField
21            val COLUMN_NAME_NOME = "nome"
22            @JvmField
23            val COLUMN_NAME_ID_SITUACAO_FOR_CLI = "id_situacao_for_cli"
24            @JvmField
25            val COLUMN_NAME_ID_GERADO_RETAGUARDA = "id_gerado_retaguarda"
26            @JvmField
27            val COLUMN_NAME_FANTASIA = "fantasia"
28            @JvmField
29            val COLUMN_NAME_EMAIL = "email"
30            @JvmField
31            val COLUMN_NAME_FONE = "fone"
32            @JvmField
33            val COLUMN_NAME_CPF_CNPJ = "cpf_cnpj"
34            @JvmField
35            val COLUMN_NAME_RG_IE = "rg_ie"
36            @JvmField
37            val COLUMN_NAME_TIPO_PESSOA = "tipo_pessoa"
38            @JvmField
39            val COLUMN_NAME_LOGRADOURO = "logradouro"
40            @JvmField
41            val COLUMN_NAME_NUMERO = "numero"
42            @JvmField
43            val COLUMN_NAME_COMPLEMENTO = "complemento"
44            @JvmField
45            val COLUMN_NAME_BAIRRO = "bairro"
46            @JvmField
47            val COLUMN_NAME_CEP = "cep"
48            @JvmField
49            val COLUMN_NAME_CIDADE = "cidade"
50            @JvmField
51            val COLUMN_NAME_UF = "uf"
52            @JvmField
53            val COLUMN_NAME_CODIGO_IBGE_CIDADE = "codigo_ibge_cidade"
54            @JvmField
55            val COLUMN_NAME_CODIGO_IBGE_UF = "codigo_ibge_uf"
56            @JvmField
57            val COLUMN_NAME_LAST_SYNC = "last_sync"
58
59
60            @JvmField
61            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
62                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
63                    + COLUMN_NAME_ID_GERADO_RETAGUARDA + " INTEGER,"
64                    + COLUMN_NAME_ID_SITUACAO_FOR_CLI + " INTEGER,"
65                    + COLUMN_NAME_NOME + " TEXT,"
66                    + COLUMN_NAME_FANTASIA + " TEXT,"
67                    + COLUMN_NAME_CPF_CNPJ + " TEXT,"
68                    + COLUMN_NAME_RG_IE + " TEXT,"
69                    + COLUMN_NAME_TIPO_PESSOA + " TEXT,"
70                    + COLUMN_NAME_EMAIL + " TEXT,"
71                    + COLUMN_NAME_FONE + " TEXT,"
72                    + COLUMN_NAME_LOGRADOURO + " TEXT,"
73                    + COLUMN_NAME_NUMERO + " TEXT,"
74                    + COLUMN_NAME_BAIRRO + " TEXT,"
75                    + COLUMN_NAME_COMPLEMENTO + " TEXT,"
76                    + COLUMN_NAME_CEP + " TEXT,"
77                    + COLUMN_NAME_CIDADE + " TEXT,"
78                    + COLUMN_NAME_UF + " TEXT,"
79                    + COLUMN_NAME_CODIGO_IBGE_CIDADE + " INTEGER,"
80                    + COLUMN_NAME_CODIGO_IBGE_UF + " INTEGER,"
81                    + COLUMN_NAME_LAST_SYNC + " TEXT)")
82
83            @JvmField
84            val ON_DELETE = "DROP TABLE IF EXISTS ${Cliente.TABLE_NAME}"
85        }
86    }
87
88    abstract class Produto : BaseColumns {
89        companion object {
90
91            @JvmField
92            val TABLE_NAME = "produto"
93            @JvmField
94            val COLUMN_NAME_ID = "id"
95            @JvmField
96            val COLUMN_NAME_NOME = "nome"
97            @JvmField
98            val COLUMN_NAME_DESCRICAO_PDV = "descricao_pdv"
99            @JvmField
100            val COLUMN_NAME_UN = "un"
101            @JvmField
102            val COLUMN_NAME_MARCA = "marca"
103            @JvmField
104            val COLUMN_NAME_GRUPO = "grupo"
105            @JvmField
106            val COLUMN_NAME_SUB_GRUPO = "sub_grupo"
107            @JvmField
108            val COLUMN_NAME_VALOR_VENDA = "valor_venda"
109            @JvmField
110            val COLUMN_NAME_QUANTIDADE_ESTOQUE = "quantidade_estoque"
111            @JvmField
112            val COLUMN_NAME_ESTOQUE_VERIFICADO = "estoque_verificado"
113            @JvmField
114            val COLUMN_NAME_FOTO_PRODUTO = "foto_produto"
115            @JvmField
116            val COLUMN_NAME_LAST_SYNC = "last_sync"
117            @JvmField
118            val COLUMN_NAME_INATIVO = "inativo"
119
120            @JvmField
121            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
122                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
123                    + COLUMN_NAME_NOME + " TEXT, "
124                    + COLUMN_NAME_DESCRICAO_PDV + " TEXT, "
125                    + COLUMN_NAME_UN + " TEXT, "
126                    + COLUMN_NAME_MARCA + " TEXT, "
127                    + COLUMN_NAME_GRUPO + " TEXT, "
128                    + COLUMN_NAME_SUB_GRUPO + " TEXT, "
129                    + COLUMN_NAME_VALOR_VENDA + " REAL, "
130                    + COLUMN_NAME_QUANTIDADE_ESTOQUE + " REAL, "
131                    + COLUMN_NAME_ESTOQUE_VERIFICADO + " REAL, "
132                    + COLUMN_NAME_FOTO_PRODUTO + " TEXT, "
133                    + COLUMN_NAME_INATIVO + " TEXT"
134                    + ")")
135            @JvmField
136            val ON_DELETE = "DROP TABLE IF EXISTS $TABLE_NAME"
137        }
138    }
139
140    abstract class Municipio : BaseColumns {
141        companion object {
142            @JvmField
143            val TABLE_NAME = "municipio"
144            @JvmField
145            val COLUMN_NAME_ID = "id"
146            @JvmField
147            val COLUMN_NAME_NOME = "nome"
148            @JvmField
149            val COLUMN_NAME_CODIGO_IBGE_CIDADE = "codigo_ibge"
150            @JvmField
151            val COLUMN_NAME_UF = "uf"
152
153            @JvmField
154            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
155                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
156                    + COLUMN_NAME_NOME + " TEXT, "
157                    + COLUMN_NAME_UF + " TEXT, "
158                    + COLUMN_NAME_CODIGO_IBGE_CIDADE + " INTEGER)")
159
160            @JvmField
161            val ON_DELETE = "DROP TABLE IF EXISTS ${TABLE_NAME}"
162        }
163
164
165    }
166
167    abstract class TabelaPreco : BaseColumns {
168        companion object {
169            @JvmField
170            val TABLE_NAME = "tabela_preco"
171            @JvmField
172            val COLUMN_NAME_ID = "id"
173            @JvmField
174            val COLUMN_NAME_NOME = "nome"
175
176            @JvmField
177            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
178                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
179                    + COLUMN_NAME_NOME+ " TEXT )")
180
181            @JvmField
182            val ON_DELETE = "DROP TABLE IF EXISTS ${TABLE_NAME}"
183
184
185        }
186
187    }
188
189
190    abstract class TabelaPrecoDetalhe : BaseColumns {
191        companion object {
192            @JvmField
193            val TABLE_NAME = "tabela_preco_detalhe"
194            @JvmField
195            val COLUMN_NAME_ID = "id"
196            @JvmField
197            val COLUMN_NAME_ID_TABELA_PRECO = "id_tabela_preco"
198            @JvmField
199            val COLUMN_NAME_ID_PRODUTO = "id_produto"
200            @JvmField
201            val COLUMN_NAME_VALOR = "valor"
202
203            @JvmField
204            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
205                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
206                    + COLUMN_NAME_ID_TABELA_PRECO+ " INTEGER NO NULL,"
207                    + COLUMN_NAME_ID_PRODUTO+ " INTEGER NO NULL,"
208                    + COLUMN_NAME_VALOR + " REAL,"
209                    + "FOREIGN KEY(${COLUMN_NAME_ID_TABELA_PRECO}) REFERENCES ${TabelaPreco.TABLE_NAME} (${TabelaPreco.COLUMN_NAME_ID}),"
210                    + "FOREIGN KEY(${COLUMN_NAME_ID_PRODUTO}) REFERENCES ${Produto.TABLE_NAME} (${Produto.COLUMN_NAME_ID}))"
211                    )
212
213            @JvmField
214            val ON_DELETE = "DROP TABLE IF EXISTS ${TABLE_NAME}"
215
216        }
217
218    }
219
220    abstract class CondicaoPagamento : BaseColumns {
221
222        companion object {
223            @JvmField
224            val TABLE_NAME = "condicao_pagamento"
225            @JvmField
226            val COLUMN_NAME_ID = "id"
227            @JvmField
228            val COLUMN_NAME_NOME = "nome"
229
230            @JvmField
231            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
232                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
233                    + COLUMN_NAME_NOME+ " TEXT )")
234
235            @JvmField
236            val ON_DELETE = "DROP TABLE IF EXISTS ${TABLE_NAME}"
237
238        }
239
240    }
241
242
243    abstract class CondicaoPagamentoDetalhe : BaseColumns {
244
245        companion object {
246            @JvmField
247            val TABLE_NAME = "condicao_pagamento_detalhe"
248            @JvmField
249            val COLUMN_NAME_ID = "id"
250            @JvmField
251            val COLUMN_NAME_ID_CONDICAO_PAGAMENTO = "id_condicao_pagamento"
252            @JvmField
253            val COLUMN_NAME_PARCELA = "parcela"
254
255            @JvmField
256            val COLUMN_NAME_DIAS = "dias"
257
258            @JvmField
259            val COLUMN_NAME_TAXA = "taxa"
260
261            @JvmField
262            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
263                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
264                    + COLUMN_NAME_ID_CONDICAO_PAGAMENTO+ " INTEGER NO NULL,"
265                    + COLUMN_NAME_PARCELA + " INTEGER,"
266                    + COLUMN_NAME_DIAS + " INTEGER,"
267                    + COLUMN_NAME_TAXA + " REAL,"
268                    + "FOREIGN KEY(${COLUMN_NAME_ID_CONDICAO_PAGAMENTO}) REFERENCES ${Orcamento.TABLE_NAME} (${Orcamento.COLUMN_NAME_ID}))"
269                    )
270
271
272            @JvmField
273            val ON_DELETE = "DROP TABLE IF EXISTS ${TABLE_NAME}"
274        }
275
276
277
278
279    }
280
281
282    abstract class Orcamento : BaseColumns {
283
284        companion object {
285            @JvmField
286            val TABLE_NAME = "orcamento"
287            @JvmField
288            val COLUMN_NAME_ID = "id"
289            @JvmField
290            val COLUMN_NAME_ID_EMPRESA = "id_empresa"
291            @JvmField
292            val COLUMN_NAME_ID_CONDICAO_PAGAMENTO = "id_condicoes_pagamento"
293            @JvmField
294            val COLUMN_NAME_ID_VENDEDOR = "id_vendedor"
295            @JvmField
296            val COLUMN_NAME_ID_CLIENTE = "id_cliente"
297            @JvmField
298            val COLUMN_NAME_TIPO = "tipo"
299            @JvmField
300            val COLUMN_NAME_CODIGO = "codigo"
301            @JvmField
302            val COLUMN_NAME_DATA_CADASTRO = "data_cadastro"
303            @JvmField
304            val COLUMN_NAME_TIPO_FRETE = "tipo_frete"
305            @JvmField
306            val COLUMN_NAME_VALOR_SUBTOTAL = "valor_subtotal"
307            @JvmField
308            val COLUMN_NAME_VALOR_FRETE = "valor_frete"
309            @JvmField
310            val COLUMN_NAME_TAXA_COMISSAO = "taxa_comissao"
311            @JvmField
312            val COLUMN_NAME_VALOR_COMISSAO = "valor_comissao"
313            @JvmField
314            val COLUMN_NAME_TAXA_DESCONTO = "taxa_desconto"
315            @JvmField
316            val COLUMN_NAME_VALOR_DESCONTO = "valor_desconto"
317            @JvmField
318            val COLUMN_NAME_VALOR_TOTAL = "valor_total"
319            @JvmField
320            val COLUMN_NAME_SITUACAO = "situacao"
321
322            @JvmField
323            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
324                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
325                    + COLUMN_NAME_ID_EMPRESA + " INTEGER NOT NULL,"
326                    + COLUMN_NAME_ID_CONDICAO_PAGAMENTO + " INTEGER NOT NULL,"
327                    + COLUMN_NAME_ID_VENDEDOR + " INTEGER NOT NULL,"
328                    + COLUMN_NAME_ID_CLIENTE + " INTEGER NOT NULL,"
329                    + COLUMN_NAME_TIPO + " TEXT NOT NULL,"
330                    + COLUMN_NAME_CODIGO + " TEXT,"
331                    + COLUMN_NAME_DATA_CADASTRO + " TEXT,"
332                    + COLUMN_NAME_TIPO_FRETE + " TEXT,"
333                    + COLUMN_NAME_VALOR_SUBTOTAL + " REAL,"
334                    + COLUMN_NAME_VALOR_FRETE + " REAL,"
335                    + COLUMN_NAME_VALOR_FRETE + " REAL,"
336                    + COLUMN_NAME_TAXA_COMISSAO + " REAL,"
337                    + COLUMN_NAME_VALOR_COMISSAO + " REAL,"
338                    + COLUMN_NAME_TAXA_DESCONTO + " REAL,"
339                    + COLUMN_NAME_VALOR_DESCONTO + " REAL,"
340                    + COLUMN_NAME_VALOR_TOTAL + " REAL,"
341                    + COLUMN_NAME_SITUACAO + " TEXT,"
342                    + "FOREIGN KEY(${COLUMN_NAME_ID_CLIENTE}) REFERENCES ${Cliente.TABLE_NAME} (${Cliente.COLUMN_NAME_ID}),"
343                    )
344
345            @JvmField
346            val ON_DELETE = "DROP TABLE IF EXISTS ${TABLE_NAME}"
347        }
348
349
350    }
351
352    abstract class OrcamentoDetalhe : BaseColumns {
353        companion object {
354            @JvmField
355            val TABLE_NAME = "orcamento_detalhe"
356            @JvmField
357            val COLUMN_NAME_ID = "id"
358            @JvmField
359            val COLUMN_NAME_ID_ORCAMENTO = "id_orcamento"
360            @JvmField
361            val COLUMN_NAME_ID_PRODUTO = "id_produto"
362            @JvmField
363            val COLUMN_NAME_UN = "un"
364            @JvmField
365            val COLUMN_NAME_VALOR_UNITARIO = "valor_unitario"
366            @JvmField
367            val COLUMN_NAME_VALOR_SUBTOTAL = "valor_subtotal"
368            @JvmField
369            val COLUMN_NAME_TAXA_DESCONTO = "taxa_desconto"
370            @JvmField
371            val COLUMN_NAME_VALOR_DESCONTO = "valor_desconto"
372            @JvmField
373            val COLUMN_NAME_VALOR_TOTAL = "valor_total"
374
375            @JvmField
376            val ON_CREATE = ("CREATE TABLE " + TABLE_NAME + " ("
377                    + COLUMN_NAME_ID + " INTEGER PRIMARY KEY, "
378                    + COLUMN_NAME_ID_ORCAMENTO + " INTEGER NO NULL,"
379                    + COLUMN_NAME_ID_PRODUTO + " INTEGER NO NULL,"
380                    + COLUMN_NAME_UN + " TEXT,"
381                    + COLUMN_NAME_VALOR_UNITARIO + " REAL,"
382                    + COLUMN_NAME_VALOR_SUBTOTAL + " REAL,"
383                    + COLUMN_NAME_TAXA_DESCONTO + " REAL,"
384                    + COLUMN_NAME_VALOR_DESCONTO + " REAL,"
385                    + COLUMN_NAME_VALOR_TOTAL + " REAL,"
386                    + "FOREIGN KEY(${COLUMN_NAME_ID_ORCAMENTO}) REFERENCES ${Orcamento.TABLE_NAME} (${Orcamento.COLUMN_NAME_ID})"
387                    + ")"
388
389                    )
390
391
392            @JvmField
393            val ON_DELETE = "DROP TABLE IF EXISTS ${TABLE_NAME}"
394        }
395
396
397    }
398
399}