eclass.unmer.ac.id

<div class="row wrapper border-bottom white-bg page-heading">
                
				<div class="col-lg-10">
                    <h2>Gerenciador</h2>
                    
                </div>
                <div class="col-lg-2">

</div>
	
            </div>

<div class="clients-list">
								<ul class="nav nav-tabs">
									
									<li class="active"><a data-toggle="tab" href="#tab-1"><i class="fa fa-cogs"></i> Gerenciador</a></li>
									
								</ul>
								<div class="tab-content">
									<div id="tab-1" class="tab-pane active">
										<div class="full-height-scroll">
                                        
                                        <div class="table-responsive">
							<table width="100%" class="footable table table-stripped" data-page-size="1000" data-filter=#filter>

<?php
											
											
												$query = "SELECT * FROM cw_user WHERE status_user=0 ORDER BY nome_user";
												$link   = DBConnect();
												$result = @mysqli_query($link, $query) or die(mysqli_error($link));

$data_atual   = date("Y-m-d");
											
										?>

<td width="5%"></td>
  
                      <th width="25%">Usuário</th>
                      
                      <th width="14%">Total</th>

<th width="14%">Em aberto</th>
                      
                      <th width="14%">A Vencer</th>
                                                                
                      <th width="14%">Vence Hoje</th>
                      
                      <th width="14%">Vencidos</th>
                                           
                    </tr>
                    </thead>
                    <tbody>
                     <?php while($res = mysqli_fetch_assoc($result)){ ?>
                      
                      <tr>
											
                        <td class="client-avatar"><?php if($res['img_user']==""){ ?><img alt="image" src="midia/img/profile_small.jpg"><?php }else{ ?><img alt="image" src="img-perfil/img/perfil/<?php echo $res['img_user']; ?>"><?php } ?> </td>
  											<td><?php echo $res['nome_user']; ?> <?php echo $res['sobrenome_user']; ?></td>
  											
                        <td>
                          <?php
                          $queryt  = "Select count(cw_flw.id_flw) as total from cw_flw, cw_relaciona_fw WHERE cw_relaciona_fw.fw_relaciona_fw=cw_flw.id_flw AND cw_relaciona_fw.user_relaciona_fw='$res[id_user]' AND cw_flw.responsavel_flw = '$res[id_user]'";
                          $resultt = DBExecute($queryt);
                          $rest    = mysqli_fetch_assoc($resultt);
                          $total   = $rest['total'];

echo "$total";
                          ?>
                        </td>
                        <td>
                        <a href="#" onclick="contador('webChat/gerenciador.php?idu=<?php echo $res['id_user']; ?>&ref=1')">
                          <?php
                          $queryab  = "Select count(cw_flw.id_flw) as total from cw_flw, cw_relaciona_fw WHERE cw_relaciona_fw.fw_relaciona_fw=cw_flw.id_flw AND cw_relaciona_fw.user_relaciona_fw='$res[id_user]' AND cw_flw.responsavel_flw = '$res[id_user]' AND cw_flw.status_flw=0 AND cw_relaciona_fw.status_relaciona_flw=0";
                          $resultab = DBExecute($queryab);
                          $resab    = mysqli_fetch_assoc($resultab);
                          $totalab  = $resab['total'];

echo "$totalab";
                          ?>
                        </a>
                        </td>
                        <td>
                        <a href="#" onclick="contador('webChat/gerenciador.php?idu=<?php echo $res['id_user']; ?>&ref=2')">
                          <?php
                          $querya = "Select count(cw_flw.id_flw) as total from cw_flw, cw_relaciona_fw WHERE cw_relaciona_fw.fw_relaciona_fw=cw_flw.id_flw AND cw_relaciona_fw.user_relaciona_fw='$res[id_user]' AND cw_flw.responsavel_flw = '$res[id_user]' AND cw_flw.status_flw=0 AND cw_relaciona_fw.status_relaciona_flw=0 AND cw_flw.prazo_flw > '$data_atual'";
                          $resulta = DBExecute($querya);
                          $resa    = mysqli_fetch_assoc($resulta);
                          $totala  = $resa['total'];

echo "$totala";
                          ?>
                        </a>  
                        </td>
                        <td>
                        <a href="#" onclick="contador('webChat/gerenciador.php?idu=<?php echo $res['id_user']; ?>&ref=3')">
                          <?php
                          $queryh  = "Select count(cw_flw.id_flw) as total from cw_flw, cw_relaciona_fw WHERE cw_relaciona_fw.fw_relaciona_fw=cw_flw.id_flw AND cw_relaciona_fw.user_relaciona_fw='$res[id_user]' AND cw_flw.responsavel_flw = '$res[id_user]' AND cw_flw.status_flw=0 AND cw_relaciona_fw.status_relaciona_flw=0 AND cw_flw.prazo_flw = '$data_atual' ";
                          $resulth = DBExecute($queryh);
                          $resh    = mysqli_fetch_assoc($resulth);
                          $totalh  = $resh['total'];

echo "$totalh";
                          ?>
                        </a>  
                        </td>
                        <td>
                        <a href="#" onclick="contador('webChat/gerenciador.php?idu=<?php echo $res['id_user']; ?>&ref=4')">
                        <?php
                          $queryv  = "Select count(cw_flw.id_flw) as total from cw_flw, cw_relaciona_fw WHERE cw_relaciona_fw.fw_relaciona_fw=cw_flw.id_flw AND cw_relaciona_fw.user_relaciona_fw='$res[id_user]' AND cw_flw.responsavel_flw = '$res[id_user]' AND cw_flw.status_flw=0 AND cw_relaciona_fw.status_relaciona_flw=0 AND cw_flw.prazo_flw < '$data_atual'";
                          $resultv = DBExecute($queryv);
                          $resv    = mysqli_fetch_assoc($resultv);
                          $totalv  = $resv['total'];

echo "$totalv";
                          ?>
                        </a>
                        </td>  
										  </tr>
                                        <?php } ?>
													
												</tbody>
												</table>
											</div>
											
										</div>
                                                                                
									</div>
									
								</div>

</div>
							</div>
						</div>
					</div>
					<div class="col-sm-5">
						<div class="ibox ">

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


<div class="modal signUpContent fade" id="ModalLogin" 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 USUÁRIOS </h3>
      </div>
	  
      <div class="modal-body">
      <form role="form" name="logar3" method="post" action="includes/cadUser.php">
          
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-6">
          	<label>Nome: </label>
            <input type="text" autofocus name="nome" class="form-control" placeholder="Digite o nome" required="">
          </div>
          <div class="col-lg-6">
          	<label>Sobrenome: </label>
            <input type="text" name="sobrenome" class="form-control" placeholder="Digite o sobrenome" required="">
          </div>          
        </div>
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-6">
          	<label>Login: </label>
            <input type="text" name="login" id="login" class="form-control" placeholder="Digite o login" required="">
            <div class="jacadastrado" style="padding:5px"></div>
          </div>
          <div class="col-lg-6">
          	<label>senha: </label>
            <input type="password" name="senha" class="form-control" placeholder="Digite a senha" required="">
          </div>          
        </div>
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-6">
          	<label>Celular: </label>
            <input type="text" name="celular" class="form-control cel" placeholder="Digite o celular" >
          </div>
          <div class="col-lg-6">
          	<label>Telefone: </label>
            <input type="text" name="telefone" class="form-control tel" placeholder="Digite o telefone" >
          </div>          
        </div>
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12">
          	<label>E-mail: </label>
            <input type="text" name="email" class="form-control" placeholder="Digite o e-mail" >
          </div>
          </div>          
        </div>
 
        <div>
          <div>
            <input name="submit" class="btn cadnewusera  btn-block btn-lg btn-primary" value="CADASTRAR" type="submit">
            <input name="submit" type="button" disabled="disabled" class="btn cadnewuserb  btn-block btn-lg btn-primary" value="CADASTRAR" />
          </div>
        </div>
         
      </form>  
      </div>
      
    </div>
     
    
  </div>