· 9 years ago · Jan 17, 2017, 02:12 PM
1CREATE TABLE IF NOT EXISTS `locais` (
2 `CODIGOLOCAL` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
3 `EMPRESA` int(11) NOT NULL,
4 `DESCRICAO` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
5 `CODIGOASCEDENTE` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
6 `CODIGORESULT` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
7 `DATAATIVO` date NOT NULL,
8 `RESPONSAVEL` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
9 `DATADESATIVADO` date DEFAULT NULL,
10 `CODIGOTIPO` varchar(9) COLLATE utf8_unicode_ci DEFAULT NULL,
11 `TELEFONE` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
12 `CENTROCUSTO` int(5) DEFAULT NULL,
13 `EMAIL` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
14 `ENDERECO` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
15 `COMPLEMENTO` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
16 `BAIRRO` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
17 `CIDADE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
18) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
19
20CREATE TABLE IF NOT EXISTS `localsoriginal` (
21 `id` int(10) unsigned NOT NULL,
22 `codigolocal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
23 `descricaolocal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
24 `idempresa` int(10) unsigned NOT NULL,
25 `codigopai` int(10) unsigned NOT NULL,
26 `result` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
27 `dataativo` date NOT NULL,
28 `datadesativado` date NOT NULL,
29 `idresponsavel` int(10) unsigned NOT NULL,
30 `idtipolocal` int(10) unsigned NOT NULL,
31 `telefone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
32 `centrocusto` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
33 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
34 `endereco` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
35 `complemento` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
36 `birro` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
37 `cidade` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
38 `iduf` int(10) unsigned NOT NULL,
39 `created_at` timestamp NULL DEFAULT NULL,
40 `updated_at` timestamp NULL DEFAULT NULL
41) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
42
43ALTER TABLE `localsoriginal`
44 ADD PRIMARY KEY (`id`), ADD KEY `locals_idempresa_foreign` (`idempresa`), ADD KEY `locals_codigopai_foreign` (`codigopai`), ADD KEY `locals_idresponsavel_foreign` (`idresponsavel`), ADD KEY `locals_idtipolocal_foreign` (`idtipolocal`), ADD KEY `locals_iduf_foreign` (`iduf`);
45
46ALTER TABLE `localsoriginal`
47 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
48
49ALTER TABLE `localsoriginal`
50ADD CONSTRAINT `locals_codigopai_foreign` FOREIGN KEY (`codigopai`) REFERENCES `pais` (`id`),
51ADD CONSTRAINT `locals_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `empresas` (`id`),
52ADD CONSTRAINT `locals_idresponsavel_foreign` FOREIGN KEY (`idresponsavel`) REFERENCES `responsavels` (`id`),
53ADD CONSTRAINT `locals_idtipolocal_foreign` FOREIGN KEY (`idtipolocal`) REFERENCES `tipolocals` (`id`),
54ADD CONSTRAINT `locals_iduf_foreign` FOREIGN KEY (`iduf`) REFERENCES `ufs` (`id`);
55
56/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
57/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
58/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
59
60<?php
61
62require("../conexao.php");
63
64//carga local
65 $sql = "SELECT CODIGOLOCAL, EMPRESA, DESCRICAO, CODIGOASCEDENTE, CODIGORESULT, DATAATIVO, RESPONSAVEL, DATADESATIVADO, CODIGOTIPO, TELEFONE, CENTROCUSTO, EMAIL, ENDERECO, COMPLEMENTO, BAIRRO, CIDADE FROM locais";
66 echo $sql;
67 $res = mysqli_query($con, $sql);
68 while ($f = mysqli_fetch_array($res)) {
69 echo 'entrei aqui';
70 $codigolocal = $f['CODIGOLOCAL'];
71 $idempresa = 1;
72 $descricaolocal = $f['DESCRICAO'];
73 $codigopai = $f['CODIGOASCEDENTE'];
74 $result = $f['CODIGORESULT'];
75 $dataativo = $f['DATAATIVO'];
76 $datadesativado = $f['DATADESATIVADO'];
77 $idresponsavel = 1;
78 $idtipolocal = $f['CODIGOTIPO'];
79 $telefone = $f['TELEFONE'];
80 $centrocusto = $f['CENTROCUSTO'];
81 $email = $f['EMAIL'];
82 $endereco = $f['ENDERECO'];
83 $complemento = $f['COMPLEMENTO'];
84 $birro = $f['BAIRRO'];
85 $cidade = $f['CIDADE'];
86 $iduf = 1;
87 $created_at = '2017-01-16 22:05:17';
88 $updated_at = '2017-01-16 22:05:17';
89 echo $codigolocal;
90
91 $sqluplocal="INSERT INTO localsoriginal (codigolocal, idempresa, descricaolocal, codigopai, result, dataativo, idresponsavel, idtipolocal, telefone, centrocusto, email, endereco, complemento, birro, cidade, iduf, created_at, updated_at) VALUES ('$codigolocal', '$idempresa', '$descricao', '$codigopai', '$result', '$dataativo', '$idresponsavel', '$idtipolocal', '$telefone', '$centrocusto', '$email', '$endereco', '$complemento', '$birro', '$cidade',
92 '$iduf', '$created_at', '$updated_at)";
93 echo $sqluplocal;
94 $resuplocal = mysqli_query($con, $sqluplocal);
95 }
96//Fim carga local
97echo 'fim';
98?>
99
100CREATE TABLE IF NOT EXISTS `locais` (
101 `CODIGOLOCAL` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
102 `EMPRESA` int(11) NOT NULL,
103 `DESCRICAO` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
104 `CODIGOASCEDENTE` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
105 `CODIGORESULT` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
106 `DATAATIVO` date NOT NULL,
107 `RESPONSAVEL` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
108 `DATADESATIVADO` date DEFAULT NULL,
109 `CODIGOTIPO` varchar(9) COLLATE utf8_unicode_ci DEFAULT NULL,
110 `TELEFONE` varchar(14) COLLATE utf8_unicode_ci DEFAULT NULL,
111 `CENTROCUSTO` int(5) DEFAULT NULL,
112 `EMAIL` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
113 `ENDERECO` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
114 `COMPLEMENTO` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
115 `BAIRRO` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
116 `CIDADE` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL
117) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
118
119CREATE TABLE IF NOT EXISTS `localsoriginal` (
120 `id` int(10) unsigned NOT NULL,
121 `codigolocal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
122 `descricaolocal` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
123 `idempresa` int(10) unsigned NOT NULL,
124 `codigopai` int(10) unsigned NOT NULL,
125 `result` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
126 `dataativo` date NOT NULL,
127 `datadesativado` date NOT NULL,
128 `idresponsavel` int(10) unsigned NOT NULL,
129 `idtipolocal` int(10) unsigned NOT NULL,
130 `telefone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
131 `centrocusto` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
132 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
133 `endereco` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
134 `complemento` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
135 `birro` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
136 `cidade` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
137 `iduf` int(10) unsigned NOT NULL,
138 `created_at` timestamp NULL DEFAULT NULL,
139 `updated_at` timestamp NULL DEFAULT NULL
140) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
141
142ALTER TABLE `localsoriginal`
143 ADD PRIMARY KEY (`id`), ADD KEY `locals_idempresa_foreign` (`idempresa`), ADD KEY `locals_codigopai_foreign` (`codigopai`), ADD KEY `locals_idresponsavel_foreign` (`idresponsavel`), ADD KEY `locals_idtipolocal_foreign` (`idtipolocal`), ADD KEY `locals_iduf_foreign` (`iduf`);
144
145ALTER TABLE `localsoriginal`
146 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
147
148ALTER TABLE `localsoriginal`
149ADD CONSTRAINT `locals_codigopai_foreign` FOREIGN KEY (`codigopai`) REFERENCES `pais` (`id`),
150ADD CONSTRAINT `locals_idempresa_foreign` FOREIGN KEY (`idempresa`) REFERENCES `empresas` (`id`),
151ADD CONSTRAINT `locals_idresponsavel_foreign` FOREIGN KEY (`idresponsavel`) REFERENCES `responsavels` (`id`),
152ADD CONSTRAINT `locals_idtipolocal_foreign` FOREIGN KEY (`idtipolocal`) REFERENCES `tipolocals` (`id`),
153ADD CONSTRAINT `locals_iduf_foreign` FOREIGN KEY (`iduf`) REFERENCES `ufs` (`id`);
154
155/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
156/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
157/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
158
159<?php
160
161require("../conexao.php");
162
163//carga local
164 $sql = "SELECT CODIGOLOCAL, EMPRESA, DESCRICAO, CODIGOASCEDENTE, CODIGORESULT, DATAATIVO, RESPONSAVEL, DATADESATIVADO, CODIGOTIPO, TELEFONE, CENTROCUSTO, EMAIL, ENDERECO, COMPLEMENTO, BAIRRO, CIDADE FROM locais";
165 echo $sql;
166 $res = mysqli_query($con, $sql);
167 while ($f = mysqli_fetch_array($res)) {
168 echo 'entrei aqui';
169 $codigolocal = $f['CODIGOLOCAL'];
170 $idempresa = 1;
171 $descricaolocal = $f['DESCRICAO'];
172 $codigopai = $f['CODIGOASCEDENTE'];
173 $result = $f['CODIGORESULT'];
174 $dataativo = $f['DATAATIVO'];
175 $datadesativado = $f['DATADESATIVADO'];
176 $idresponsavel = 1;
177 $idtipolocal = $f['CODIGOTIPO'];
178 $telefone = $f['TELEFONE'];
179 $centrocusto = $f['CENTROCUSTO'];
180 $email = $f['EMAIL'];
181 $endereco = $f['ENDERECO'];
182 $complemento = $f['COMPLEMENTO'];
183 $birro = $f['BAIRRO'];
184 $cidade = $f['CIDADE'];
185 $iduf = 1;
186 $created_at = '2017-01-16 22:05:17';
187 $updated_at = '2017-01-16 22:05:17';
188 echo $codigolocal;
189
190 $sqluplocal="INSERT INTO localsoriginal (codigolocal, idempresa, descricaolocal, codigopai, result, dataativo, idresponsavel, idtipolocal, telefone, centrocusto, email, endereco, complemento, birro, cidade, iduf, created_at, updated_at) VALUES ('$codigolocal', '$idempresa', '$descricao', '$codigopai', '$result', '$dataativo', '$idresponsavel', '$idtipolocal', '$telefone', '$centrocusto', '$email', '$endereco', '$complemento', '$birro', '$cidade',
191 '$iduf', '$created_at', '$updated_at)";
192 echo $sqluplocal;
193 $resuplocal = mysqli_query($con, $sqluplocal);
194 }
195//Fim carga local
196echo 'fim';
197?>