eclass.unmer.ac.id

<?php
	session_start();
	$sessao = session_id();
	require 'conexao/funcao.inc.php';
	require 'conexao/config.php';
	require 'conexao/conn.php';
	require 'conexao/function.php';
	
	$essay_id 	= $_POST['EID'];
	
	$queryseg  	= "SELECT * FROM cw_lancamentos, cw_lancamento, cw_plano WHERE cw_lancamentos.chave_lancamentos=cw_lancamento.chave_lancamento AND cw_lancamento.pconta_lancamento=cw_plano.codigo_plano AND  id_lancamentos='$essay_id'";
	$resultseg 	= DBExecute($queryseg);
	$resseg    	= mysqli_fetch_assoc($resultseg);

?> 
<input type="hidden" name="idlancamento" value="<?php echo $resseg['id_lancamentos']; ?>" />
<input type="hidden" name="chlancamento" id="chlancamento" value="<?php echo $resseg['chave_lancamentos']; ?>" />
<input type="hidden" name="chavep_lancamentos" id="chavep_lancamentos" value="<?php echo $resseg['chavep_lancamentos']; ?>" />
<input type="hidden" name="tipolancamento" id="tipolancamento" value="<?php echo $resseg['tipo_lancamentos']; ?>" />

<div class="form-group login-username col-lg-12">
          <div class="col-lg-2">
          	<div class="radio radio-danger">
                <input type="radio" name="tipo"  checked="" >
                <?php if($resseg['tipo_lancamentos']=='1'){
					echo"<label>ÚNICO</label>";
					}else{
					echo"<label>RATEADO</label>";
					}
				?>
				
            </div>
            
          </div>
          <input type="hidden" name="idlancamento" value="<?php echo $resseg['id_lancamentos']; ?>" />
          <div class="col-lg-4">
	          	<div class="form-group" >
    			<label>Data do lançamento: </label>
                 <div class="input-group date">
                     <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input name="emissao" type="text" class="form-control" id="data_8" value="<?php echo dbDateToDate2($resseg['emissao_lancamentos']); ?>" readonly="readonly" />
                 </div>
                 </div>

</div>
		  <div class="col-lg-6">
			
			<?php if($resseg['tipo_lancamentos']=='1'){ ?>
            <div class="newConta">
			<label><a href="#" data-toggle="modal" data-target="#ModalConta"><i class="fa fa-plus-circle"></i> Conta:</a></label>
            <select name="conta" class="form-control chosen-select" id="conta" >
               
			   <option value="<?php echo $resseg['conta_lancamento']; ?>"><?php echo $resseg['conta_lancamento']; ?></option>
			   
			   <option value="">----------------------------</option>
			   
			   <?php
                    $query = "SELECT * FROM cw_contas order by nome_contas";
                    $link   = DBConnect();
                    $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                 while($ln = mysqli_fetch_assoc($result)){
                    echo '<option value="'.$ln['nome_contas'].'">'.$ln['nome_contas'].'</option>';
                 }
              ?>
               
            </select>
            </div>
			<?php }else{ ?>
			
          	<label>Conta:</label>
            <select name="" disabled="disabled"  class="form-control" >

</select>
			<?php } ?>
			
          </div>          
        
        </div>
        
		<?php if($resseg['tipo_lancamentos']=='2'){ ?>
        <div class="form-group login-username col-lg-12">
        <fieldset style="border:1px solid #CCC; border-radius:5px">
        <legend>Rateio</legend>
		
		<div class="table-responsive" id="tablerateio2">
		<table class="footable table table-stripped" data-page-size="400" data-filter=#filter>

<tbody id="config_lancamento">
        
		<?php
			$query = "SELECT * FROM cw_lancamento, cw_plano WHERE cw_lancamento.pconta_lancamento=cw_plano.codigo_plano AND  cw_lancamento.chave_lancamento = '$resseg[chave_lancamentos]'";
			$link   = DBConnect();
			$result = @mysqli_query($link, $query) or die(mysqli_error($link));
		?> 
		<?php
			while($res = mysqli_fetch_assoc($result)){ ?>
		<tr>
		  <td>
      <a href="#" title="Excluir" id="<?php echo $res['id_lancamento']; ?>" data-toggle="<?php echo $resseg['chave_lancamentos']; ?>" class="deletarLrateio2" ><i class="fa fa-trash"> </i></a>
      </td>										
		  <td><?php if($res['dc_lancamento']=='1'){echo"DEB";}else{echo"CRED";} ?></td>
		  <td><?php echo $res['conta_lancamento']; ?></td>
		  <td><?php echo $res['pconta_lancamento']; ?> - <?php echo $res['nome_plano']; ?></td>
		  <td><?php echo formataValor2($res['valor_lancamento']); ?></td>
      <td><?php echo $res['historico_lancamento']; ?></td>
      <td><a href="#myModal" data-toggle="modal" id="<?php echo $res['id_lancamento']; ?>" data-target="#edit-modalconfig-lancamento"><i class="fa fa-edit"></i></a></td>
		  
		</tr>
		<?php } ?>
					
		</tbody>
		</table>
		</div>
		
        </fieldset>
        </div>
        <?php } ?>
        
		<div class="form-group login-username col-lg-12">
          
		  <div class="col-lg-6">
		  
          	<?php if($resseg['tipo_lancamentos']=='1'){ ?>
            <div class="newPlanoConta">
			<label><a href="#" data-toggle="modal" data-target="#ModalPConta"><i class="fa fa-plus-circle"></i> Plano de conta:</a></label>
            <select name="plano_conta" class="form-control chosen-select" id="plano_conta" >
               
			   <option value="<?php echo $resseg['pconta_lancamento']; ?>"><?php echo $resseg['pconta_lancamento']; ?> - <?php echo $resseg['nome_plano']; ?></option>
			   
			   
			   <option value="">------------------------------------</option>
                <?php
                    $query = "SELECT * FROM cw_plano WHERE cabeca_plano='0' order by codigo_plano, numero_plano";
                    $link   = DBConnect();
                    $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                 while($ln = mysqli_fetch_assoc($result)){ ?>
                    <option value="<?php echo $ln['codigo_plano']; ?>"><?php echo $ln['codigo_plano']; ?> - <?php echo $ln['nome_plano']; ?></option>
                 <?php }
              ?>
             
            </select>
            </div>
			<?php }else{ ?>
			<label>Plano de conta:</label>
            <select class="form-control"  name="" disabled="disabled"  >
                
            </select>
			<?php } ?>
			
          </div>
		  
		  
          <div class="col-lg-3">
	          	<div class="form-group" >
    			<label>Vencimento: </label>
                 <div class="input-group date">
                     <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_9" name="vencimento" value="<?php echo dbDateToDate2($resseg['vencimento_lancamentos']); ?>"  required="">
                 </div>
                 </div>

</div>
          <div class="col-lg-3">
	          	<div class="form-group" >
    			<label>Previsão pgto: </label>
                 <div class="input-group date">
                     <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_10" name="previsao" value="<?php echo dbDateToDate2($resseg['previsao_lancamentos']); ?>"  required="">
                 </div>
                 </div>

</div>
        
        </div>
        
        <div class="form-group login-username col-lg-12">
          
          <div class="col-lg-2">
		  
			<?php if($resseg['tipo_lancamentos']=='1'){ ?>
            <div class="radio radio-danger">
                <input type="radio" name="cd" id="cd" value="1" <?php if($resseg['dc_lancamento']=='1'){echo"checked=''";} ?> >
                <label for="DEB">
                   DEB
                </label>
            </div>
            <div class="radio radio-danger">
               <input type="radio" name="cd" id="cd" value="2" <?php if($resseg['dc_lancamento']=='2'){echo"checked=''";} ?> >
               <label for="CRE">
                   CRE
               </label>
            </div>
			<?php }else{ ?>
            <div class="radio radio-danger">
                <input name="" type="radio" disabled="disabled" value="" />
                <label for="DEB">
                   DEB
                </label>
            </div>
            <div class="radio radio-danger">
               <input name="" type="radio" disabled="disabled" value="" />
               <label for="CRE">
                   CRE
               </label>
            </div>
			<?php } ?>
			
          </div>
          
          <div class="col-lg-4">
			
            <?php if($resseg['tipo_lancamentos']=='1'){ ?>
			<label>Valor: </label>
            <input type="text" id="valor" name="valor" value="<?php echo formataValor2($resseg['valor_lancamento']); ?>" class="form-control" placeholder="R$" />
      			<?php }else{ ?>
      			
            <script type="text/javascript">
              function atualizartotaiss() {
                 
                 var url="includes/somarateio2.php?sessao=<?php echo $resseg['chave_lancamentos']; ?>";
                jQuery(".somavalor").load(url);
              }
              setInterval("atualizartotaiss()", 5000);
            </script>

<div class="radio radio-danger">
                <input type="radio" checked="" >
                
                <?php if($resseg['periodo_lancamentos']=='1'){
          				echo"<label>Único</label>";
          				}elseif($resseg['periodo_lancamentos']=='2') {
          				echo"<label>Parcelado</label>";	
          				}else{
          				echo"<label>Periódico</label>";	
          				}
          			?>

</div>
            
          </div>
          
          <div class="col-lg-2">
          	<label>Lançamento: </label>
            <input name="" type="text"  class="form-control" value="<?php echo $resseg['numero_lancamentos']; ?>.<?php echo $resseg['parcelas_lancamentos']; ?>" readonly="readonly" />
          </div>
		  
		  <div class="col-lg-2">
          	<label>Parcela: </label>
            <input name="" type="text"  class="form-control" value="<?php echo $resseg['parcelas_lancamentos']; ?>/<?php echo $resseg['nparcelas_lancamentos']; ?>" readonly="readonly"  />
          </div>
        
        </div>
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-3">
          	<label><a href="#" data-toggle="modal" data-target="#ModalRdoc"><i class="fa fa-plus-circle"></i> Recebeu doc.? </a></label>
            <div id="newRdocumento">
            <select name="rdoc" class="form-control chosen-select" id="rdoc" >
                <option value="<?php echo $resseg['rnf_lancamentos']; ?>"><?php echo $resseg['rnf_lancamentos']; ?></option>
                <option value="">-------------------</option>
				<?php
                    $query = "SELECT * FROM cw_rdoc order by nome_rdoc";
                    $link   = DBConnect();
                    $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                 while($ln = mysqli_fetch_assoc($result)){
                    echo '<option value="'.$ln['nome_rdoc'].'">'.$ln['nome_rdoc'].'</option>';
                 }
              ?>
                
            </select>
            </div>
            
          </div>
          
          <div class="col-lg-3">
          	<label><a href="#" data-toggle="modal" data-target="#ModalFpgto"><i class="fa fa-plus-circle"></i> Forma de pgto: </a></label>
            <div id="newFdePagamento">
            <select name="forma_pagamento" class="form-control chosen-select" id="forma_pagamento" >
                <option value="<?php echo $resseg['formapgt_lancamentos']; ?>"><?php echo $resseg['formapgt_lancamentos']; ?></option>
                <option value="">-------------------------</option>
				<?php
                    $query = "SELECT * FROM cw_fpagamento order by nome_fpagamento";
                    $link   = DBConnect();
                    $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                 while($ln = mysqli_fetch_assoc($result)){
                    echo '<option value="'.$ln['nome_fpagamento'].'">'.$ln['nome_fpagamento'].'</option>';
                 }
              ?>
                
            </select>
            </div>
          </div>
                    
          <div class="col-lg-3">
	          	<div class="form-group" >
    			<label>Baixa: </label>
                 <div class="input-group date">
                     <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_11" name="baixa"  value="<?php if($resseg['baixa_lancamentos']!="0000-00-00"){echo dbDateToDate2($resseg['baixa_lancamentos']);} ?>" >
                 </div>
                 </div>

</div>
          
          <div class="col-lg-3">
          	
          	<label>Nota fiscal: </label>
            <input name="nf" value="<?php echo $resseg['nf_lancamentos']; ?>" type="text" id="nf" class="form-control" />
            
          </div>
                    
        </div>
        
        <div class="form-group login-username col-lg-12">
                    
          
                <div class="col-lg-2">
          	
                    <div class="checkbox checkbox-success">
                        <input id="tprojeto" name="tprojeto" type="checkbox" <?php if($resseg['tprojeto_lancamentos']=='1'){echo"checked='checked'";}  ?>  />
                        <label for="checkbox3">
                            Projeto
                        </label>
                    </div>
                    
                    <div class="checkbox checkbox-success">
                        <input id="tclifor" name="tclifor" type="checkbox" <?php if($resseg['tclifor_lancamentos']=='1'){echo"checked='checked'";} ?>  />
                        <label for="checkbox2">
                            Cli/Fornec
                        </label>
                    </div>
                    
                </div>
                <div class="col-lg-4">
                    
                    
                    <label><a href="#" data-toggle="modal" data-target="#ModalProjeto"><i class="fa fa-plus-circle"></i> Projeto:</a></label>
                    <select name="projeto" class="form-control chosen-select" id="projeto" >
                       
                       <option value="<?php echo $resseg['projeto_lancamentos']; ?>"><?php echo $resseg['projeto_lancamentos']; ?></option>
                       
                       <option value="">-----------------------------</option>
                        <?php
                            $query = "SELECT * FROM cw_projetos order by nome_projetos";
                            $link   = DBConnect();
                            $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                         while($ln = mysqli_fetch_assoc($result)){
                            echo '<option value="'.$ln['nome_projetos'].'">'.$ln['nome_projetos'].'</option>';
                         }
                      ?>
                        
                    </select>
                      
					
              	</div>

<div class="col-lg-6">
                	
                    <label>Cliente / Fornecedor:</label>
                    <select name="clifor" class="form-control chosen-select" id="clifor" >
                       <option value="<?php echo $resseg['clifor_lancamentos']; ?>"><?php echo $resseg['clifor_lancamentos']; ?></option>
                       <option value="">----------------------------------------</option>
                        <?php
                            $query = "SELECT id_cliente, razao_cliente FROM cw_cliente order by razao_cliente";
                            $link   = DBConnect();
                            $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                         	while($ln = mysqli_fetch_assoc($result)){
                            echo '<option value="'.$ln['razao_cliente'].'">'.$ln['razao_cliente'].'</option>';
                         }
                      	?>
                        <?php
                            $queryf  = "SELECT id_fornecedor, razao_fornecedor FROM cw_fornecedor order by razao_fornecedor";
                            $linkf   = DBConnect();
                            $resultf = @mysqli_query($linkf, $queryf) or die(mysqli_error($linkf));
                         	while($lnf = mysqli_fetch_assoc($resultf)){
                            echo '<option value="'.$lnf['razao_fornecedor'].'">'.$lnf['razao_fornecedor'].'</option>';
                         }
                      	?>
                    </select>    
                    
                </div> 
          
        </div>
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12">
          	<label>Histórico: </label>
            <textarea name="historico" cols="" id="historico" class="form-control" placeholder="Histórico" rows="3" ><?php echo $resseg['historico_lancamentos']; ?></textarea>
          </div>
                    
        </div>