Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql_select = 'SELECT * FROM empresas ORDER BY id DESC LIMIT '.$empresas.','.$maximo;
- try{
- $query_select = $conecta->prepare($sql_select);
- $query_select->execute();
- $resultado_query = $query_select->fetchAll(PDO::FETCH_ASSOC);
- }catch (PDOexception $error_select){
- echo 'Erro ao selecionar: '.$error_select->getMessage();
- }
- foreach($resultado_query as $res){
- $id = $res['id'];
- $razao_social = $res['razao_social'];
- $cnpj = $res['cnpj'];
- $email = $res['email'];
- $celular = $res['celular'];
- $fixo = $res['fixo'];
- $situacao = $res['situacao'];
- $ultima_nfe = $res['ultima_nfe'];
- ?>
- <tr>
- <td style="width:350px"><?php echo $razao_social;?></td>
- <td><?php echo $cnpj;?><input class="id-emp" type="text" hidden value="<?php echo $id;?>" /></td>
- <td><?php echo $email;?></td>
- <td><?php echo $celular ? $celular : $fixo;?></td>
- <td><input class="ultima-nfe" onchange="ultimaNFe(event)" type="text" value="<?php echo $ultima_nfe; ?>"/></td>
- <?php if($situacao == '1'){?>
- <td><a href="actions/desativar-empresa.php?id=<?php echo $id ;?>">Desativar</a></td>
- <?php }else{ ?>
- <td><a href="actions/ativar-empresa.php?id=<?php echo $id ;?>">Ativar</a></td>
- <?php } ?>
- <td style="width:50px"><a href="editar-empresa.php?id=<?php echo $id ;?>"><span class="glyphicon glyphicon-edit"></span></a></td>
- </tr>
- <?php } ?>
- <script>
- function ultimaNFe(event) {
- event = event || window.event;
- var target = event.target || event.srcElement;
- /* pegamos a referência o elemento em comum, no caso, dois nodes acima (a linha da tabela) */
- var trNode = target.parentNode.parentNode;
- /* procuramos os elementos dentro do tr com o método .querySelector */
- var id_emp = trNode.querySelector('.id-emp').value;
- var ultima_nfe = trNode.querySelector('.ultima-nfe').value;
- console.debug(ultima_nfe);
- funcao(id_emp,ultima_nfe);
- }
- function funcao(id_emp, ultima_nfe) {
- novo_valor = ultima_nfe;
- if (novo_valor != ultima_nfe) {
- console.debug(ultima_nfe);
- $.ajax({
- method : 'POST',
- //url : 'http://bwdagenciadigital.com/multiinjet/src/nfephp/application/actions/NFe/make-nfe.php',
- url : 'actions/edicao-rapida.php',
- dataType: 'json',
- data : {novo_valor: ultima_nfe, _cnpj: cnpj_},//
- headers : {'Content-Type': 'application/x-www-form-urlencoded'},
- success: function(data) {
- console.debug(data);
- //alert(data.cnpj);
- }
- })
- }
- }
- </script>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement