Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
admin
/
modulos
:
editoras-editar.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<? // variávis que se trabalham nessa página $var_banco = "editoras"; $var_pagina = "editoras-editar"; $var_pagina_anterior = "editoras"; $idEditora = $_REQUEST[idEditora]; ?> <section class="content" > <!-- Info boxes --> <section class="content-header"> <h1> Gerenciamento de Editoras </h1><br /> <br /> <!-- Default box --> <div class="box"> <div class="box-header with-border"> <h3 class="box-title">Editar Editora</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] ."', Endereco = '". ($_REQUEST[Endereco]) ."', Bairro = '". ($_REQUEST[Bairro]) ."', Cidade = '". ($_REQUEST[Cidade]) ."', pais = '". ($_REQUEST[pais]) ."', CEP = '". $_REQUEST[CEP] ."', telefone1 = '". $_REQUEST[telefone1] ."', telefone2 = '". $_REQUEST[telefone2] ."', editora = '". $_REQUEST[editora] ."', email = '". $_REQUEST[email] ."', site = '". $_REQUEST[site] ."', desconto = '". $_REQUEST[desconto] ."', UF = '". $_REQUEST[UF] ."', Info_Adicionais = '". ($_REQUEST[Info_Adicionais]) ."' WHERE idEditora=".$_REQUEST[idEditora]; //comando SQL $exec = mysql_query($comando); //executa o comando no banco echo "<div class=\"alert alert-success\"> Editora Atualizada com <strong>sucesso</strong>. </div><br>"; } $rs = $obj->query("SELECT * FROM ". $var_banco ." WHERE idEditora=".$idEditora); ?> <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-9"> <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 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> <div class="row"> <div class="col-md-6"> <label class="control-label">Desconto de: </label> <input type="text" class="form-control" id="desconto" name="desconto" placeholder="Desconto" value="<? echo mysql_result($rs, '0', 'desconto');?>" > % * Desconto para todos os livros desta editora e oferecido aos clientes autorizados </div> <div class="col-md-6"> <label class="control-label">Editora Fabris: </label> <select name="editora" id="editora" class="form-control" required> <option value="NAO" <? if(mysql_result($rs, '0', 'editora') == 'NAO') { echo "selected='selected'";}?>>NÃO</option> <option value="SIM" <? if(mysql_result($rs, '0', 'editora') == 'SIM') { echo "selected='selected'";}?>>SIM</option> </select> </div> </div> <div class="row"> <div class="col-md-12"> <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> <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-2"> <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-2"> <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 class="col-md-2"> <label class="control-label">País: </label> <input type="text" class="form-control" placeholder="País" id="pais" name="pais" value="<? echo mysql_result($rs, '0', 'pais');?>" > </div> </div> <div class="row"> <div class="col-md-2"> <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-2"> <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 class="col-md-4"> <label class="control-label">Site: </label> <input type="text" class="form-control" placeholder="Site" id="site" name="site" value="<? echo mysql_result($rs, '0', 'site');?>"> </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="idEditora" value="<? echo mysql_result($rs, '0', 'idEditora');?>"> <button type="submit" class="btn btn-primary">Atualizar</button> <a href="?secao=editoras" 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>LIVROS CADASTRADOS NESTA EDITORA</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="Livros cadastrados"> <i class="fa fa-plus"></i></button> </div> </div> <div class="box-body" style="display: none;"> <div style="text-align:right"> <a href="?secao=livros-cadastrar" class="btn btn-lg btn-success"><i class="fa fa-plus"></i> CADASTRAR NOVO LIVRO</a> </div> <!-- LISTA DE CONTAS A PAGAR CADASTRADAS --> <? $comando = "SELECT * FROM contas_pagar WHERE status = 1 AND id_fornecedor=".mysql_result($rs, '0', 'idEditora')." 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> </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>