Inserir item em consulta!
Olá pessoal
Desenvolvo um sistema em PHP e tenho um sistema de consulta de NFe... porem as notas possuem vários itens e gostaria que na consulta aparecesse um + para exibir estes itens!
Não tenho ideia de como fazer isso..
Segue código e imagem para demostração!
$s = "SELECT DISTINCT A.COD_EMPRESA, C.CNPJ AS CNPJ_SAIDA, C.xNome AS Nome1, B.CNPJ AS CNPJ_ENTRADA, B.xNome AS Nome2, D.CFOP AS CFOP, 'E' AS ES, DEPARA.CFOP_PARA FROM (TBL_EMPRESA AS A INNER JOIN TBL_NFE_dest B ON A.CNPJ=B.CNPJ INNER JOIN TBL_NFE_ide AS Z ON B.infNFe = Z.infNFe INNER JOIN TBL_NFE_emit AS C ON C.infNFe = B.infNFe INNER JOIN TBL_NFE_prod AS D ON D.infNFe = B.infNFe) LEFT JOIN TBL_NFE_CFOP_DEPARA AS DEPARA ON DEPARA.CNPJ_DE = C.CNPJ AND DEPARA.CFOP_DE=D.CFOP AND DEPARA.CNPJ_PARA=B.CNPJ WHERE A.CNPJ = B.CNPJ AND B.CNPJ = '".$EMP."' AND Z.tpNF = '1' AND B.infNFe = Z.infNFe AND B.infNFe = C.infNFe AND B.infNFe = D.infNFe ORDER BY Nome1,CNPJ_SAIDA,CFOP";
$consul = $query->consulta($s);
$total_campos = $query->conta($consul);
$cont=0;
echo '<table cellpadding="0" cellspacing="0" border="0" class="table">';
echo '<tr>';
echo '<td width="50px"></td>';
echo '<td width="00px"><img src="http://ohmsapoio.com.br/2.0/sistema/img/topo_bt/cadastro_cfop.png" style="position:relative; top:0px; left:-25px"/><p><p></td>';
echo '</tr>';
echo '</table>';
echo '<table id="tb1" cellpadding="0" cellspacing="0" border="0" class="table">';
echo '<tr class="header">';
echo '<th width="50px">NUMERO NF. <br> <h8>Para exibir mais itens, clique em +!</h8></th >';
echo '<th width="50px">ITENS.</th >';
echo '<th width="50px">CHAVE</th >';
echo '<th width="50px">CNPJ</th >';
echo '<th width="100px">NOME</th >';
echo '<th width="50px">CFOP</th>';
echo '<th>CFOP ENT</th >';
echo "</tr>";
echo '<form name="FormDepara" id="FormDepara" method="post" action="../controle/gravar_config.php"';
while ($l = $query->busca($consul))
{
$cont = $cont+1;
$nomes = $l['Nome1'];
echo '<tr>';
echo '<td width="50px"><input style="background:#b7dcff;" type="text" name="cnpj_saida_'.$cont.'" id="cnpj_saida_'.$cont.'" readonly="true" size="41" maxlength="41" value='.$l['CNPJ_SAIDA'].'></input></td >';
echo '<td width="50px"><input style="background:#b7dcff;" type="text" name="cnpj_saida_'.$cont.'" id="cnpj_saida_'.$cont.'" readonly="true" size="2" maxlength="2" value='.$l['ITENS'].'></input></td >';
echo '<td width="50px"><input style="background:#b7dcff;" type="text" name="cnpj_saida_'.$cont.'" id="cnpj_saida_'.$cont.'" readonly="true" size="9" maxlength="9" value='.$l['CNPJ_SAIDA'].'></input></td >';
echo '<td width="50px"><input style="background:#b7dcff;" type="text" name="cnpj_saida_'.$cont.'" id="cnpj_saida_'.$cont.'" readonly="true" size="15" maxlength="15" value='.$l['CNPJ_SAIDA'].'></input></td >';
echo '<td width="100px"><input style="background:#b7dcff;" type=text name="nome1'.$cont.'" id="nome1'.$cont.'" size="60" readonly="true" maxlength="100" value="'.$nomes.'"></input></td >';
echo '<td width="50px"><input style="background:#b7dcff;" type="text" name="cfop_'.$cont.'" id="cfop_'.$cont.'" size="5" readonly="true" maxlength="5" value='.$l['CFOP'].'></input></td >';
echo '<td><input type="text" style="background:#FFFFFF;" name="cfop_para_'.$cont.'" id="cfop_para_'.$cont.'" size="5" maxlength="4" value='.$l['CFOP_PARA'].'></input></td >';
echo '</tr>';
}
echo '</table>';
// <img src="http://ohmsapoio.com.br/2.0/sistema/img/topo_bt/cadastro_cfop.png" style="position:relative; top:0px; left:-25px">
echo '<input type="hidden" name="cont" id="cont" size="5" maxlength="4" value='.$cont.'></input>';
echo '<input type="hidden" name="cnpj_pesquisa" id="cnpj_pesquisa" value='.$EMP.'></input>';
echo '<input type="image" src="http://ohmsapoio.com.br/2.0/sistema/img/topo_bt/gravar.png" style="position: relative; left: 410px; top: 91px; border: 0px;" value="Gravar" name="Gravar"></input>';
echo '<input type="hidden" name="paginacao" id="paginacao" value="'.$total_campos.'" />' ;
echo '</form>';
?>
<div id="green" style="margin: auto">/applications/core/interface/imageproxy/imageproxy.php?img=http://ohmsapoio.com.br/2.0/item.jpg&key=1293960fa1660bce7ff637609b64d5977f9338a66d3c6a75e27d0031a15bcdf8" alt="item.jpg" />
Obrigadooo!
Discussão (10)
Carregando comentários...