· 9 years ago · Jan 14, 2017, 07:44 PM
1CREATE TABLE IF NOT EXISTS `nmcMVA` (
2 `ncm` varchar(4) DEFAULT NULL,
3 `rs` varchar(5) DEFAULT NULL,
4 `sc` varchar(5) DEFAULT NULL,
5 `sc_simples` varchar(5) DEFAULT NULL,
6 `rj` varchar(5) DEFAULT NULL,
7 `mg` varchar(5) DEFAULT NULL,
8 `mt` varchar(1) DEFAULT NULL,
9 `ap` varchar(5) DEFAULT NULL
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
11
12
13 INSERT INTO `nmcMVA` (`ncm`, `rs`, `sc`, `sc_simples`, `rj`, `mg`, `mt`, `ap`) VALUES
14 ('8508', '0.570', '0.551', '0.275', '0.652', '0.580', '0', '0.570'),
15 ('8424', '0.570', '', '', '', '', '', ''),
16 ('8504', '0.570', '', '', '', '', '', ''),
17 ('9032', '0.570', '', '', '', '', '', ''),
18 ('8414', '0.570', '', '', '', '', '', ''),
19 ('', '', '', '', '', '', '', ''),
20 ('', '', '', '', '', '', '', ''),
21 ('', '', '', '', '', '', '', ''),
22 ('', '', '', '', '', '', '', ''),
23 ('', '', '', '', '', '', '', ''),
24 ('', '', '', '', '', '', '', ''),
25 ('', '', '', '', '', '', '', ''),
26 ('', '', '', '', '', '', '', ''),
27 ('', '', '', '', '', '', '', ''),
28 ('', '', '', '', '', '', '', '');
29
30// Verifica se foi solicitado uma consulta para preencher campo mva
31 if($acao == 'consulta'):
32 $sql2 = "SELECT ncm, rs FROM nmcMVA ";
33 $sql2 .= "WHERE ncm LIKE ? LIMIT 1";
34
35 $stm = $conexao->prepare($sql2);
36 $stm->bindValue(1, $parametro.'%');
37 $stm->execute();
38 $dados = $stm->fetchAll(PDO::FETCH_OBJ);
39
40 $json = json_encode($dados);
41 echo $json;
42 endif;