X29P63dj

1Banco de dados
2-- Copiando estrutura para tabela bycelsoc_adv_082021.funcionarios
3CREATE TABLE IF NOT EXISTS `funcionarios` (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `nome` varchar(35) NOT NULL,
6  `cpf` varchar(20) NOT NULL,
7  `telefone` varchar(20) NOT NULL,
8  `email` varchar(20) NOT NULL,
9  `cargo` varchar(30) NOT NULL,
10  `status_fun` varchar(10) NOT NULL,
11  PRIMARY KEY (`id`)
12) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
13
14-- Copiando dados para a tabela bycelsoc_adv_082021.funcionarios: ~2 rows (aproximadamente)
15/*!40000 ALTER TABLE `funcionarios` DISABLE KEYS */;
16INSERT INTO `funcionarios` (`id`, `nome`, `cpf`, `telefone`, `email`, `cargo`, `status_fun`) VALUES
17	(20, 'Sergio Pedro Freitas 5', '777.777.777-77', 'wrtw', 'rtwertewrtewrt', 'Advogado', '1'),
18	(23, 'Jose da Cove', '87544557', '12874541', 'email@gg.com.br', 'Advogado', '1');
19/*!40000 ALTER TABLE `funcionarios` ENABLE KEYS */;
20
21/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
22/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
23/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
24/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
25////////////////////
26
27$(document).ready(function() {
28//var user_id, opcion;
29var opcion;
30opcion = 4;
31    
32tablaUsuarios = $('#tablaUsuarios').DataTable({  
33    "ajax": {
34        "url": "bd/grud.php",
35        "method": 'POST',
36        "data": {
37            opcion: opcion
38        }, //É ENVIADO A OPCAO 4 PARA FAZER O SELECT
39        "dataSrc": ""
40    },
41    "columns":[
42        {"data": "id"},
43        {"data": "nome"},
44        {"data": "cpf"},
45        {"data": "telefone"},
46        {"data": "email"},
47        {"data": "cargo"},
48        {"data": "status_fun"},
49        {"defaultContent": "<div class='text-center'><div class='btn-group'><button class='btn btn-primary btn-sm btnEditar'><i class='material-icons'>edit</i></button><button class='btn btn-danger btn-sm btnBorrar'><i class='material-icons'>delete</i></button></div></div>"}
50    ]
51});