eclass.unmer.ac.id

<div class="row wrapper border-bottom white-bg page-heading">
                
				<div class="col-lg-10">
                    <h2>Contas</h2>
                    <ol class="breadcrumb">
                        <li>
                            <button data-toggle="modal" data-target="#ModalLogin" type="button" class="btn btn-primary btn-sm">Nova Conta</button>
                        </li>
                        
                    </ol>
                </div>
                <div class="col-lg-2">

</div>
	
            </div>

<div class="wrapper wrapper-content  animated fadeInRight">
				<div class="row">
					<div class="col-sm-12">
						<div class="ibox">
							<div class="ibox-content">
								
								<h2>Contas</h2>
								
								<div class="input-group col-lg-8">
									<input type="text" autofocus placeholder="Procurar conta" id="filter" class="input form-control">
									<span class="input-group-btn">
											<button type="button" class="btn btn btn-primary"> <i class="fa fa-search"></i> Procurar</button>
									</span>
								</div>
								<div class="clients-list">
								<ul class="nav nav-tabs">
									
									<li class="active"><a data-toggle="tab" href="#tab-2"><i class="fa fa-calculator"></i> Contas</a></li>		
								</ul>
								<div class="tab-content">
									<div id="tab-2" class="tab-pane active">
										<div class="full-height-scroll">
                                        
                                        <div class="table-responsive">
										<table class="footable table table-stripped" data-page-size="100" data-filter=#filter>
                                        
										<tbody>
										<?php
											$query = "SELECT * FROM cw_conta ORDER BY id_conta DESC";
											$link   = DBConnect();
											$result = @mysqli_query($link, $query) or die(mysqli_error($link));
										?> 
                                        <?php
			 								while($res = mysqli_fetch_assoc($result)){ 
											
											$querycre = "SELECT SUM(valor_itens_conta) as total FROM cw_itens_conta WHERE conta_itens_conta='$res[id_conta]' AND tipo_itens_conta='1'";
											$resultcre = DBExecute($querycre);
											$rescre = mysqli_fetch_assoc($resultcre);
											
											$querydeb = "SELECT SUM(valor_itens_conta) as total FROM cw_itens_conta WHERE conta_itens_conta='$res[id_conta]' AND tipo_itens_conta='2'";
											$resultdeb = DBExecute($querydeb);
											$resdeb = mysqli_fetch_assoc($resultdeb);
											
											$saldo = $rescre['total']-$resdeb['total'];	
										?>
                                        <tr>
                                            <td class="project-status">
                                                <?php if($res['status_conta']==0){ ?>
                                                <span class="label label-primary">Ativo</span>
                                                <?php }else{ ?>
                                                <span class="label label-default">Inativo</span>   
                                                <?php } ?>
                                            </td>
                                          <td>
                                          <?php
										  if($saldo!=0){$classe = "msgerro";}elseif($res['fluxo_conta']==1){$classe = "msgerro2";}else{$classe = "deletarconta";}
										  ?>
                                            <a href="#" title="Excluir" id="<?php echo $res['id_conta']; ?>" class="<?php echo $classe; ?>" ><i class="fa fa-trash"> </i></a>
                                          </td>	
                                          
                                                                
                                          <td><i class="fa fa-files-o" title="Tipo de conta"></i> <?php echo $res['tipo_conta']; ?></td>                                          
                                                                                    
                                          <td><i class="fa fa-calculator" title="Nome da Conta"></i> <a href="./?pag=conta-bancaria&id=<?php echo $res['id_conta']; ?>" class="client-link"><?php echo $res['nome_conta']; ?></a></td>
                                          <td>
                                          <i class="fa fa-money" title="Saldo da conta"></i> 
                                          <strong>
                                          R$ 
										  <?php echo formataValor2($saldo); ?>
                                           </strong>
                                          </td>
                                                                                   
                                          <td class="project-actions">
                                            <a href="./?pag=conta-bancaria&id=<?php echo $res['id_conta']; ?>" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Configurar </a>
                                          
                                          
                                        </tr>
                                        <?php } ?>
													
													</tbody>
												</table>
</div>
											
										</div>
									</div>
									
								</div>

</div>
							</div>
						</div>
					</div>
					
				</div>
			</div>
            


<div class="modal signUpContent fade" id="ModalLogin" tabindex="-1" role="dialog" >
							
                             
  <div class="modal-dialog">
    <div class="modal-content">
	
      <div class="modal-header">
        <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> &times; </button>
        <h3 class="modal-title-site text-center" > CADASTRO DE CONTAS </h3>
      </div>
	  
      <div class="modal-body">

<div class="col-lg-4">
           	   <label>Tipo de conta:</label>
    	       <input type="text" class="form-control"  name="tipoconta" required="">
	       </div>
           <div class="col-lg-8">
           <label>Nome da conta:</label>
    	       <input type="text" class="form-control" name="nomeconta" required="">
	       </div> 
            
         </div> 
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12">
          	<label>Observação geral: </label>
            <textarea class="form-control" id="descricao" name="descricao" rows="3"></textarea>
          </div>
                   
        </div>
                            
        </div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary" id="mandarcoisas3" value="CADASTRAR" type="submit">
          </div>
        </div>
         
      </form>  
      </div>
      
    </div>
     
    
  </div>