eclass.unmer.ac.id

<div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-sm-12">
                    <h2>Lista de pendências</h2>
                    
                <div class="col-lg-2">
	          	<div class="form-group" >
    			
                <form action="?pag=pendencias" method="get">
                <label>De: </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_1" name="prazo" value="" required="">
                 </div>
                 </div>
          	    </div> 
                
                
                <div class="col-lg-2">
	          	<div class="form-group" >
    			<label>Até: </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_2" name="prazo" value="" required="">
                 </div>
                 </div>
          	    </div> 
                
                
                <div class="col-lg-2">
	          	<div class="form-group" >
    			<label>&nbsp;</label>
                <div class="input-group date">
                       <button type="button" class="btn btn btn-primary btn-filtrar"> <i class="fa fa-search"></i> Procurar</button>
                 </div>
                 </div>
          	    </div>

</form>    
                    
                    
                    
                </div>
            </div>
        
		<div id="filtro_pendencias">	
		
		
		
		<div class="row">
            <div class="col-lg-12">
                <div class="wrapper wrapper-content animated fadeInUp">

<div class="ibox">
                        
                        
                        <div class="tabs-container">
                        <ul class="nav nav-tabs">
                            <li class="active"><a data-toggle="tab" href="#tab-2"> Ocorrências</a></li>
                            <li class=""><a data-toggle="tab" href="#tab-1"> Solicitações</a></li>
                            <li class=""><a data-toggle="tab" href="#tab-3"> Solicitações externas</a></li>
                        </ul>
                        <div class="tab-content">
						
						
						
                            <div id="tab-1" class="tab-pane">
                                <div class="panel-body">
								
                                    <div class="ibox-content">
                            <div class="row m-b-sm m-t-sm">
                                <div class="col-md-1">
                                    <button type="button" id="loading-example-btn" class="btn btn-white btn-sm" ><i class="fa fa-refresh"></i> Refresh</button>
                                </div>
                                <div class="col-md-11">
                                    
                                </div>
                            </div>

<div class="project-list">
							<?php
							
								$query = "SELECT cw_flw.prazo_flw, cw_flw.hora_flw, cw_flw.data_flw, cw_flw.assunto_flw, cw_flw.id_flw, cw_cliente.razao_cliente  FROM cw_flw, cw_cliente WHERE cw_flw.cliente_flw=cw_cliente.id_cliente 
								AND user_flw='$_SESSION[IDCLI]' 
								AND prazo_flw < NOW() 
								AND status_flw='0' 
								ORDER BY cw_flw.prazo_flw";
								$link   = DBConnect();
								$result = @mysqli_query($link, $query) or die(mysqli_error($link));
							
							?> 
                                <table class="footable table table-stripped" data-page-size="30" data-filter=#filter>
                                    <tbody>
                                    <?php
			 								while($res = mysqli_fetch_assoc($result)){ 
											
											 ?>        
                                    <tr>
                                        <td class="project-status">
                                            
                                            <span class="label label-danger">Pendente</span>
                                            
                                        </td>

<td class="project-completion">
                                                <small>Vencimento</small>
                                                <div>
                                                    <strong><?php echo dbDateToDate2($res['prazo_flw']); ?></strong>
                                                </div>
                                        </td>
                                        
                                        <td class="project-title">
                                            <a href="./?pag=flw_detail&id=<?php echo $res['id_flw']; ?>"><?php echo $res['assunto_flw']; ?></a>
                                            <br/>
                                            <small>Criado em <?php echo dbDateToDate2($res['data_flw']); ?> às <?php echo $res['hora_flw']; ?></small>
                                        </td>
                                        
                                        <td class="project-people">
                                            <?php echo $res['razao_cliente']; ?>
                                        </td>
                                        <td class="project-actions">
                                            <a href="./?pag=flw_detail&id=<?php echo $res['id_flw']; ?>" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Visualizar </a>
                                            
                                        </td>
                                    </tr>
                                    <?php  }  ?>
                                    
                                    </tbody>
                                </table>
                            </div>
                        </div>
                                </div>
                            </div>
							
							
							
							
                            <div id="tab-2" class="tab-pane active">
                                <div class="panel-body">
                                    
                                    
                                    
                                    
                                    <div class="ibox-content">
                            <div class="row m-b-sm m-t-sm">
                                <div class="col-md-1">
                                    <button type="button" id="loading-example-btn" class="btn btn-white btn-sm" ><i class="fa fa-refresh"></i> Refresh</button>
                                </div>
                                <div class="col-md-11">
                                    
                                </div>
                            </div>

<div class="project-list">
							<?php
								$query = "SELECT * FROM cw_ocorrencia WHERE de_ocorrencia='$_SESSION[IDCLI]' 
								AND CONCAT(termino_ocorrencia, ' ', horaco_ocorrencia) < NOW() 
								AND status_ocorrencia='0' 
								OR para_ocorrencia='$_SESSION[IDCLI]' 
								AND CONCAT(termino_ocorrencia, ' ', horaco_ocorrencia) < NOW() 
								AND status_ocorrencia='0' 
								ORDER BY termino_ocorrencia";
								
								$link   = DBConnect();
								$result = @mysqli_query($link, $query) or die(mysqli_error($link));
								
								
	
							?> 
                                <table class="footable table table-stripped" data-page-size="30" data-filter=#filter>
                                    <tbody>
                                    <?php
			 								while($res = mysqli_fetch_assoc($result)){ 
											
											$queryflw  = "SELECT cw_flw.id_flw, cw_cliente.razao_cliente  FROM cw_flw, cw_cliente WHERE cw_flw.chave_flw='$res[chave_ocorrencia]' AND cw_flw.cliente_flw=cw_cliente.id_cliente";
											$resultflw 		= DBExecute($queryflw);
											$resflw    		= mysqli_fetch_assoc($resultflw);
											$idflw 	   		= $resflw['id_flw'];
											$razaocliente 	= $resflw['razao_cliente'];
											
											 ?>        
                                    <tr>
                                        <td class="project-status" width="5%">
                                            
                                            <span class="label label-danger">Pendente</span>
                                            
                                        </td>

<td class="project-completion" width="5%">
                                                <small>Vencimento</small>
                                                <div>
                                                    <strong><?php echo dbDateToDate2($res['termino_ocorrencia']); ?></strong>
                                                </div>
                                                <small>às <?php echo $res['horaco_ocorrencia']; ?></small>
                                        </td>
                                        
                                        <td class="project-title" width="60%" align="justify">
                                            <a href="./?pag=flw_detail&id=<?php echo $idflw; ?>#<?php echo $res['id_ocorrencia']; ?>"><?php echo $res['descricao_ocorrencia']; ?></a>
                                            <small>Criado em <?php echo dbDateToDate2($res['criacao_ocorrencia']); ?> às <?php echo $res['horac_ocorrencia']; ?></small>
                                        </td>
                                        
                                        <td class="project-people" width="25%">
                                            <?php echo $razaocliente; ?>
                                        </td>
                                        <td class="project-actions" width="5%">
                                            <a href="./?pag=flw_detail&id=<?php echo $idflw; ?>#<?php echo $res['id_ocorrencia']; ?>" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Visualizar </a>
                                            
                                        </td>
                                    </tr>
                                    <?php  }  ?>
                                    
                                    </tbody>
                                </table>
                            </div>
                        </div>
                                    
                                    
                                    
                                    
                                </div>
                            </div>
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            
                            <div id="tab-3" class="tab-pane">
                                <div class="panel-body">
                                    
                                    
                                    
                                    
                                    <div class="ibox-content">
                            <div class="row m-b-sm m-t-sm">
                                <div class="col-md-1">
                                    <button type="button" id="loading-example-btn" class="btn btn-white btn-sm" ><i class="fa fa-refresh"></i> Refresh</button>
                                </div>
                                <div class="col-md-11">
                                    
                                </div>
                            </div>

<div class="project-list">
							<?php
								$query = "SELECT * FROM cw_flw_temp WHERE user_flw_temp='$_SESSION[IDCLI]' ORDER BY id_flw_temp DESC";
								$link   = DBConnect();
								$result = @mysqli_query($link, $query) or die(mysqli_error($link));
	
							?> 
                                <table class="footable table table-stripped" data-page-size="30" data-filter=#filter>
                                    <tbody>
                                    <?php
			 								while($res = mysqli_fetch_assoc($result)){ 
											
											
											
											
											
											
											?>
                                         
                                    <tr>
                                        
                                            
                                        <td class="project-status">
                                            
                                            <span class="label label-danger">Pendente</span>
                                            
                                        </td>
                                        
                                        <td>
                                        <?php echo $res['id_flw_temp']; ?>
                                        </td>
                                        
                                        <td class="project-title">
                                            <a href="./?pag=flw_detail2&id=<?php echo $res['id_flw_temp']; ?>"><?php echo $res['assunto_flw_temp']; ?></a>
                                            <br/>
                                            <small>Criado em <?php echo dbDateToDate2($res['data_flw_temp']); ?> às <?php echo $res['hora_flw_temp']; ?></small>
                                        </td>
                                        <td class="project-completion">
                                                
                                        </td>
                                        <td class="project-people">
                                            <?php echo $res['nome_flw_temp']; ?>
                                        </td>
                                        
                                        <td class="project-people">
                                            <?php echo $res['empresa_flw_temp']; ?>
                                        </td>
                                        
                                        <td class="project-actions">
                                            <a href="./?pag=flw_detail2&id=<?php echo $res['id_flw_temp']; ?>" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Visualizar </a>
                                            
                                        </td>
                                    </tr>
                                    <?php  }  ?>
                                    
                                    </tbody>
                                </table>
                            </div>
                        </div>
                                    
                                    
                                    
                                    
                                </div>
                            </div>
                            
                            
                            
							
							
							
							
							
                        </div>

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

</div>