• File: fornecedores-editar.php
  • Full Path: /home/u820075591/domains/livrariafabris.com.br/public_html/admin/modulos/fornecedores-editar.php
  • Date Modified: 07/18/2023 5:23 AM
  • File size: 15.32 KB
  • MIME-type: text/x-php
  • Charset: utf-8
<?
	// variávis que se trabalham nessa página
	$var_banco 	= "Fornecedores"; 
	$var_pagina = "fornecedores-editar";
	$var_pagina_anterior = "fornecedores";
	
	$idFornecedor = $_REQUEST[idFornecedor];
?>
<section class="content" >
      <!-- Info boxes -->
      <section class="content-header">
      <h1>
        Gerenciamento de Fornecedores
      </h1><br />

    
    <br />
      <!-- Default box -->
      <div class="box">
        <div class="box-header with-border">
          <h3 class="box-title">Editar Fornecedor</h3>

        </div>
        <div class="box-body" style="display: block;">
          
          	<? 
			//ATUALIZANDO DADOS
			if ($_REQUEST[alterou] == "sim"){
				
				
				$comando = "UPDATE ". $var_banco ."
							SET 
								Razao_social = '". ($_REQUEST[Razao_Social]) ."',
								CNPJ = '". $_REQUEST[CNPJ] ."',
								CPF = '". $_REQUEST[CPF] ."',
								Inscricao_estadual = '". $_REQUEST[Inscricao_Estadual] ."',
								Inscricao_Municipal = '". $_REQUEST[Inscricao_municipal] ."',
								Endereco = '". ($_REQUEST[Endereco]) ."',
								Numero = '". ($_REQUEST[Numero]) ."',
								Complemento = '". ($_REQUEST[Complemento]) ."',
								Bairro = '". ($_REQUEST[Bairro]) ."',
								Cidade = '". ($_REQUEST[Cidade]) ."',
								CEP = '". $_REQUEST[CEP] ."',
								UF = '". $_REQUEST[UF] ."',
								Info_Adicionais = '". ($_REQUEST[Info_Adicionais]) ."'
							WHERE idFornecedor=".$_REQUEST[idFornecedor];	//comando SQL
				$exec = mysql_query($comando);	//executa o comando no banco	
				
				echo "<div class=\"alert alert-success\">
							Fornecedor Atualizado com <strong>sucesso</strong>.
					  </div><br>";
			}

			$rs = $obj->query("SELECT * FROM ". $var_banco ." WHERE idFornecedor=".$idFornecedor);
			?>
            <div class="row" id="box_cadastro">
                <form class="form-horizontal " id="form1" name="form1" method="post" action="index2.php?secao=<?= $var_pagina?>" style="width:90%; margin:0px auto">
                 <fieldset>
                    <div class="control-group">
                        
                        <div class="row">
                          	<div class="col-md-12">
                            	<label class="control-label">Nome: </label>
        						<input type="text" class="form-control" id="Razao_Social" name="Razao_Social" value="<? echo (mysql_result($rs, '0', 'Razao_Social'));?>" required>
                            </div>
                        </div>
                        <div class="row">
                          	
        					<div class="col-md-3">
                            	<label class="control-label">CPF: </label>
                            	<input type="text" class="form-control"  id="CPF" name="CPF" value="<? echo mysql_result($rs, '0', 'CPF');?>" >
                          	</div>
                            <div class="col-md-3">
                            	<label class="control-label">CNPJ: </label>
                            	<input type="text" class="form-control"  id="CNPJ" name="CNPJ" value="<? echo mysql_result($rs, '0', 'CNPJ');?>" >
                          	</div>
                            <div class="col-md-3">
                            	<label class="control-label">Inscrição Estadual: </label>
                            	<input type="text" class="form-control"  title="Inscrição Estadual" id="Inscricao_Estadual" name="Inscricao_Estadual" value="<? echo mysql_result($rs, '0', 'Inscricao_estadual');?>">
                          	</div>
                            <div class="col-md-3">
                            	<label class="control-label">Inscrição Municipal: </label>
                            	<input type="text" class="form-control" id="Inscricao_municipal" name="Inscricao_municipal" value="<? echo mysql_result($rs, '0', 'Inscricao_Municipal');?>">
                          	</div>
                        </div>
                        
                        <div class="row">
                          	<div class="col-md-4">
                            	<label class="control-label">Endereço: </label>
                            	<input type="text" class="form-control" id="Endereco" name="Endereco" value="<? echo (mysql_result($rs, '0', 'Endereco'));?>" >
                          	</div>
                            <div class="col-md-4">
                            	<label class="control-label">Número: </label>
                            	<input type="text" class="form-control" id="Numero" name="Numero" value="<? echo mysql_result($rs, '0', 'Numero');?>" >
                        	</div>
                            <div class="col-md-4">
                            	<label class="control-label">Complemento: </label>
                            	<input type="text" class="form-control" id="Complemento" name="Complemento" value="<? echo mysql_result($rs, '0', 'Complemento');?>">
                        	</div>
                        </div>
                        
                        <div class="row">
                          	<div class="col-md-3">
                            	<label class="control-label">Bairro: </label>
                            	<input type="text" class="form-control" id="Bairro" name="Bairro" value="<? echo (mysql_result($rs, '0', 'Bairro'));?>" >
                          	</div>
                            <div class="col-md-3">
                            	<label class="control-label">Cidade: </label>
                            	<input type="text" class="form-control" id="Cidade" name="Cidade" value="<? echo (mysql_result($rs, '0', 'Cidade'));?>" >
                        	</div>
                            <div class="col-md-3">
                            	<label class="control-label">CEP: </label>
                            	<input type="text" class="form-control" id="CEP" name="CEP" value="<? echo mysql_result($rs, '0', 'CEP');?>" >
                        	</div>
                            <div class="col-md-3">
                            	<label class="control-label">UF: </label>
                            	<select name="UF" id="UF" class="form-control" >
                                    <option value="" selected="selected">UF</option>
                                    <option value="AC" <? if(mysql_result($rs, '0', 'UF') == "AC") echo " selected='selected' "?>>AC</option>
                                    <option value="AL" <? if(mysql_result($rs, '0', 'UF')  == "AL") echo " selected='selected' "?>>AL</option>
                                    <option value="AP" <? if(mysql_result($rs, '0', 'UF')  == "AP") echo " selected='selected' "?>>AP</option>
                                    <option value="AM" <? if(mysql_result($rs, '0', 'UF')  == "AM") echo " selected='selected' "?>>AM</option>
                                    <option value="BA" <? if(mysql_result($rs, '0', 'UF')  == "BA") echo " selected='selected' "?>>BA</option>
                                    <option value="CE" <? if(mysql_result($rs, '0', 'UF')  == "CE") echo " selected='selected' "?>>CE</option>
                                    <option value="DF" <? if(mysql_result($rs, '0', 'UF')  == "DF") echo " selected='selected' "?>>DF</option>
                                    <option value="ES" <? if(mysql_result($rs, '0', 'UF')  == "ES") echo " selected='selected' "?>>ES</option>
                                    <option value="GO" <? if(mysql_result($rs, '0', 'UF')  == "GO") echo " selected='selected' "?>>GO</option>
                                    <option value="MA" <? if(mysql_result($rs, '0', 'UF')  == "MA") echo " selected='selected' "?>>MA</option>
                                    <option value="MT" <? if(mysql_result($rs, '0', 'UF')  == "MT") echo " selected='selected' "?>>MT</option>
                                    <option value="MS" <? if(mysql_result($rs, '0', 'UF')  == "MS") echo " selected='selected' "?>>MS</option>
                                    <option value="MG" <? if(mysql_result($rs, '0', 'UF')  == "MG") echo " selected='selected' "?>>MG</option>
                                    <option value="PA" <? if(mysql_result($rs, '0', 'UF')  == "PA") echo " selected='selected' "?>>PA</option>
                                    <option value="PB" <? if(mysql_result($rs, '0', 'UF')  == "PA") echo " selected='selected' "?>>PA</option>
                                    <option value="PR" <? if(mysql_result($rs, '0', 'UF')  == "PR") echo " selected='selected' "?>>PR</option>
                                    <option value="PE" <? if(mysql_result($rs, '0', 'UF')  == "PE") echo " selected='selected' "?>>PE</option>
                                    <option value="PI" <? if(mysql_result($rs, '0', 'UF')  == "PI") echo " selected='selected' "?>>PI</option>
                                    <option value="RJ" <? if(mysql_result($rs, '0', 'UF')  == "RJ") echo " selected='selected' "?>>RJ</option>
                                    <option value="RN" <? if(mysql_result($rs, '0', 'UF')  == "RN") echo " selected='selected' "?>>RN</option>
                                    <option value="RS" <? if(mysql_result($rs, '0', 'UF')  == "RS") echo " selected='selected' "?>>RS</option>
                                    <option value="RO" <? if(mysql_result($rs, '0', 'UF')  == "RO") echo " selected='selected' "?>>RO</option>
                                    <option value="RR" <? if(mysql_result($rs, '0', 'UF')  == "RR") echo " selected='selected' "?>>RR</option>
                                    <option value="SC" <? if(mysql_result($rs, '0', 'UF')  == "SC") echo " selected='selected' "?>>SC</option>
                                    <option value="SP" <? if(mysql_result($rs, '0', 'UF')  == "SP") echo " selected='selected' "?>>SP</option>
                                    <option value="SE" <? if(mysql_result($rs, '0', 'UF')  == "SE") echo " selected='selected' "?>>SE</option>
                                    <option value="TO" <? if(mysql_result($rs, '0', 'UF')  == "TO") echo " selected='selected' "?>>TO</option>
                                </select>
                        	</div>
                        </div>
                        
                         <div class="row">
                          	<div class="col-md-4">
                            	<label class="control-label">Telefone: </label>
                            	<input type="text" class="form-control" placeholder="Telefone" id="telefone1" name="telefone1"  value="<? echo mysql_result($rs, '0', 'telefone1');?>" >
                          	</div>
                            <div class="col-md-4">
                            	<label class="control-label">Telefone: </label>
                            	<input type="text" class="form-control" placeholder="Telefone" id="telefone2" name="telefone2"  value="<? echo mysql_result($rs, '0', 'telefone2');?>" >
                        	</div>
                            <div class="col-md-4">
                            	<label class="control-label">E-mail: </label>
                            	<input type="text" class="form-control" placeholder="E-mail" id="email" name="email"  value="<? echo mysql_result($rs, '0', 'email');?>" >
                        	</div>
                        </div>
                      
                        <div class="row">
                          	<div class="col-md-12">
                            	<label class="control-label">Informações adicionais:</label>
                            	<textarea name="Info_Adicionais" class="form-control" id="Info_Adicionais" /><? echo mysql_result($rs, '0', 'Info_Adicionais')?></textarea>
                          	</div>
                        </div>
                        
                        
                    </div>
                    <br />
                    <div class="control-group">
                        <div class="controls">
                            <input type="hidden" name="alterou" value="sim">
                            <input type="hidden" name="idFornecedor" value="<? echo mysql_result($rs, '0', 'idFornecedor');?>">
                            <button type="submit" class="btn btn-primary">Atualizar</button>
                            <a href="?secao=fornecedores" class="btn btn-default">Voltar Menu Principal</a>
                            
                            
                        </div>
                    </div>
                 </fieldset>
                </form>      
       		 </div>
        <!-- /.box-body -->

        <!-- /.box-footer-->
      </div>
      <!-- /.box -->
      </div>
       <!-- CONTAS A PAGAR -->
      <div class="box collapsed-box box-danger">
        <div class="box-header with-border">
          <h3 class="box-title"><strong>CONTAS A PAGAR CADASTRADA PARA O FORNECEDOR</strong></h3>

          <div class="box-tools pull-right">
            <button type="button" class="btn btn-box-tool  bg-aqua" data-widget="collapse" data-toggle="tooltip" title="" data-original-title="Controle de Contas a Pagar">
              <i class="fa fa-plus"></i></button>
           
          </div>
        </div>
     
        <div class="box-body" style="display: none;">  
        	
          <div style="text-align:right">
        <a href="?secao=contas_pagar-cadastrar" class="btn btn-lg btn-success"><i class="fa fa-plus"></i> CADASTRAR CONTA A PAGAR</a>
      </div>
		
                 <!-- LISTA DE CONTAS A PAGAR  CADASTRADAS -->
           <? $comando = "SELECT * FROM contas_pagar WHERE status = 1 AND id_fornecedor=".mysql_result($rs, '0', 'idFornecedor')." ORDER BY data_vencimento DESC";
		   
			  $exec = mysql_query($comando);
			?>
					  <table class="table table-bordered">
						<tbody><tr>
						  <th>Situação</th>
						  <th>Vencimento</th>
                          <th>Pagamento</th>
                          <th>Descrição</th>
                          <th>Centro de Custo</th>
                          <th>Valor</th>
						  <th>&nbsp;</th>
						</tr>
						<? 	while ($linha = mysql_fetch_assoc($exec)) {	
							$rs_dados = $obj->query("SELECT * FROM centro_de_custo WHERE id=".$linha[id_centro_custo]);
							if( mysql_num_rows($rs_dados) > 0) { $centro_custo = mysql_result($rs_dados, '0', 'nome');}
						?>
							<tr class="
                    	<? 
							if($linha[situacao] == "PAGA"){
								echo " success ";
								$vencida = "nao";
							}
							if($linha[situacao] == "EM ABERTO"){
								echo " warning ";
								$vencida = "nao";
							}
							if(($linha[situacao] == "EM ABERTO") && (date('Ymd',strtotime($linha[data_vencimento])) < date('Ymd') ) ){ 
								echo " danger ";
								$vencida = "sim";
							}
						?>
                        ">
							  <td><?= $linha[situacao]?></td>
							  <td><?= data_para_mostrar($linha[data_vencimento])?></td>
                              <td><? if($linha[data_pagamento] <> "") {echo data_para_mostrar($linha[data_pagamento]);}?></td>
                              <td><?= $linha[observacao]?></td>
                              <td><?= $centro_custo?></td>
                              <td>R$ <?= $linha[valor]?></td>
							  <td align="right">
											 <a href="index2.php?secao=contas_pagar-editar&idConta=<?=$linha[id]?>" class="btn btn-default btn-xs" title="Editar/Atualizar">
							<span class="glyphicon glyphicon-refresh"></span>
                            </a>  
							  </td>
							</tr>
		
						<? }	//while	?>
					  </tbody></table>
                  <!-- CONTAS A PAGAR -->
        </div>       
      </div>
    <!-- /.box -->
      
      

    </section>            
</section>