Tiny File Manager | relatorio-custos.php

Back Back Up Advanced Editor

<?
	// variávis que se trabalham nessa página
	$var_banco 	= "contas_pagar"; 
	$var_pagina = "contas_pagar";
	
?>

<section class="content" >
  
  <section class="content-header">
  <h1>
    RELATÓRIO DE DESPESAS
  </h1>
    <br />
      
      
      <div class="box collapsed-box">
        <div class="box-body" style="display: inline;">  
		<form class="form-horizontal " id="form1" name="form1" method="post" action="custos.php" style="width:90%; margin:0px auto" target="_blank">
        <fieldset>
                    <div class="control-group">
                        <div class="controls">
                        <div class="row">
                          	
        					<div class="col-md-3">
                            	<label class="control-label">Situação: </label>
                            	 <select name="situacao" id="situacao" class="form-control">
                                			<option value="" selected="selected">TODAS</option>
                                            <option value="EM ABERTO">EM ABERTO</option>
                                            <option value="PAGA">PAGA</option>
                                </select>
                          	</div>
                            
                            <div class="col-md-3">
                            	<label class="control-label">Centro de Custo: </label>
                            	 <select name="id_centro_custo" id="id_centro_custo" class="form-control" onchange="mostra_outro(this)">
                                 <option value="">-- TODOS --</option>
                                	<?
                                    	$comando = "SELECT nome, id FROM centro_de_custo WHERE status = 1 ORDER BY nome";
									    $exec = mysql_query($comando);	
										
										while ($linha = mysql_fetch_assoc($exec)) {	
									?>
                                			<option value="<?= $linha[id]?>"><?= ($linha[nome])?></option>
                                    <?
										}
									?>
                                </select>
                          	</div>
                            <div class="col-md-3">
                            	<label class="control-label">Data Inicial: </label>
                            	 <input type="text" class="form-control"  id="periodo_inicial" name="periodo_inicial" required>
                          	</div>
                            
                            <div class="col-md-3">
                            	<label class="control-label">Data Final: </label>
                            	 <input type="text" class="form-control"  id="periodo_final" name="periodo_final">
                          	</div>
                       </div>
                      
                       
                        <div class="row">
                          	
        					<div class="col-md-12">
                            	<label class="control-label">Fornecedor: </label>
                            	 <select name="id_fornecedor" id="id_fornecedor" class="form-control">
                                <option value="">-- TODOS --</option>
                                	<?
                                    	$comando = "SELECT Razao_social, idFornecedor FROM Fornecedores WHERE status = 1 ORDER BY Razao_social";
									    $exec = mysql_query($comando);	
										
										while ($linha = mysql_fetch_assoc($exec)) {	
									?>
                                			<option value="<?= $linha[idFornecedor]?>"><?= ($linha[Razao_social])?></option>
                                    <?
										}
									?>
                                </select>
                          	</div>
                         </div>  
                          
                      
                    </div>
                    </div>
                    <br />
                    <div class="control-group">
                        <div class="controls">
                            <input type="hidden" name="pesquisou" value="sim">
                            <button type="submit" class="btn btn-primary">GERAR</button>        
                        </div>
                    </div>
                 </fieldset>
                 </form>
        </div>
        <div class="box-footer" style="display: none;">
            &nbsp;
        </div>
      </div>
    
    </section>          
</section>