eclass.unmer.ac.id

<div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-sm-4">
                    <h2>Lista de solicitações</h2>
                    <ol class="breadcrumb">
                        <li>
                            <div class="ibox-tools">
                                <a href="#" data-toggle="modal" data-target="#ModalLogin" class="btn btn-primary btn-sm">Nova solicitação</a>
                            </div>
                        </li>
                        
                    </ol>
                </div>
            </div>
        <div class="row">
            <div class="col-lg-12">
                <div class="wrapper wrapper-content animated fadeInUp">

<div class="ibox">
                        
                        <div class="tab-content">
                        
                        <div class="tabs-container">
                        <ul class="nav nav-tabs">
                            <li class="active"><a data-toggle="tab" href="#tab-1"> Solicitações</a></li>
                            <li class=""><a data-toggle="tab" href="#tab-2"> Solicitações de clientes</a></li>
                        </ul>
                        						
						
						
                            <div id="tab-1" 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 class="input-group"><input type="text" autofocus placeholder="Pesquisar" class="input-sm form-control" id="filter"> <span class="input-group-btn">
                                        <button type="button" class="btn btn-sm btn-primary"> <i class="fa fa-search"></i></button> </span></div>
                                </div>
                            </div>

<div class="project-list">
							<?php
								$query = "SELECT cw_flw.id_flw, cw_flw.user_flw, cw_flw.status_flw, cw_flw.chave_flw, cw_flw.assunto_flw, cw_flw.data_flw, cw_flw.hora_flw, cw_flw.cliente_flw, cw_cliente.razao_cliente  FROM cw_flw, cw_cliente WHERE cw_flw.cliente_flw=cw_cliente.id_cliente AND cw_flw.status_flw=0 ORDER BY cw_flw.id_flw 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)){ 
											
											$queryflw 	= "SELECT id_ocorrencia FROM cw_ocorrencia WHERE chave_ocorrencia='$res[chave_flw]' AND status_ocorrencia='0' OR chave_ocorrencia='$res[chave_flw]' AND status_ocorrencia='1'";
											$linkflw   	= DBConnect();
											$resultflw 	= @mysqli_query($linkflw, $queryflw) or die(mysqli_error($linkflw));
											$rowflw 	=  mysqli_num_rows($resultflw);
											
											$queryflw2 	= "SELECT id_ocorrencia FROM cw_ocorrencia WHERE chave_ocorrencia='$res[chave_flw]' AND status_ocorrencia='1'";
											$linkflw2   	= DBConnect();
											$resultflw2 	= @mysqli_query($linkflw2, $queryflw2) or die(mysqli_error($linkflw2));
											$rowflw2	 	=  mysqli_num_rows($resultflw2);
											
											if($rowflw>0){
											$statisticas = 	(100-(($rowflw-$rowflw2)*100)/$rowflw);
											}else{
											$statisticas = 0;
											}
											
											/*$querys 	= "SELECT id_ocorrencia FROM cw_ocorrencia WHERE chave_ocorrencia='$res[chave_flw]' AND de_ocorrencia='$_SESSION[IDCLI]' OR chave_ocorrencia='$res[chave_flw]' AND para_ocorrencia='$_SESSION[IDCLI]' OR chave_ocorrencia='$res[chave_flw]' AND cautor_ocorrencia='$_SESSION[IDCLI]' ";
											$links   	= DBConnect();
											$results 	= @mysqli_query($links, $querys) or die(mysqli_error($links));
											$rows	 	=  mysqli_num_rows($results);*/
											
											
											?>
                                    <?php // if(($res['user_flw']==$_SESSION['IDCLI']) || ($rows>0)){ ?>        
                                    <tr>
                                        <td class="project-status">
                                            <?php if($res['status_flw']==0){ ?>
                                            <span class="label label-primary">Ativo</span>
                                            <?php }else{ ?>
                                            <span class="label label-default">Encerrado</span>   
                                            <?php } ?>
                                        </td>

<td>
                                        <?php echo $res['id_flw']; ?>
                                        </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-completion">
                                                <small>Completo em: <?php echo formataValor2($statisticas); ?>%</small>
                                                <div class="progress progress-mini">
                                                    <div style="width: <?php echo $statisticas; ?>%" class="progress-bar"></div>
                                                </div>
                                        </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 /* }else{} */ }  ?>
                                    
                                    </tbody>
                                </table>
                            </div>
                        </div>
                                </div>
                            </div>
							
							
							
							
                            <div id="tab-2" 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 class="input-group"><input type="text" placeholder="Pesquisar" class="input-sm form-control" id="filter"> <span class="input-group-btn">
                                        <button type="button" class="btn btn-sm btn-primary"> <i class="fa fa-search"></i></button> </span></div>
                                </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 class="modal signUpContent fade" id="ModalLogin" tabindex="-1" role="dialog" >
							
							<script type="text/javascript">
							function atualizarnumanexos() {
							   
							   var url="includes/numanexos.php";
								jQuery("#numanexos").load(url);
							}
							setInterval("atualizarnumanexos()", 2000);
							</script>
                             
  <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 SOLICITAÇÕES </h3>
      </div>
	  
      <div class="modal-body">
      <div class="form-group login-username col-lg-12">
      	
        <div class="col-lg-12">
        	<div id="corpotodo2"></div>
        </div>
            
      </div>
      <form role="form" name="logar3" method="post" action="includes/cadFlw.php">
          
              
        <div class="form-group login-username col-lg-12">
          
          <div class="col-lg-4">
          <a href="#" onclick="window.open('upload/', 'uploadanexo', 'STATUS=NO, TOOLBAR=NO, LOCATION=NO, DIRECTORIES=NO, RESISABLE=NO, SCROLLBARS=NO, TOP=120, LEFT=350, WIDTH=630, HEIGHT=500'); " class="btn btn-xs btn-primary"><i class="fa fa-shekel"></i> Anexar Arquivos </a>
          <p style="margin-top:10px"><span id="numanexos"></span> <small>arquivos</small></p>
          </div>
          
          <div class="col-lg-3">
          	
            <div class="radio radio-danger">
                <input type="radio" name="tipo" id="radio3" value="1" checked="" >
                <label for="Privado">
                   Privado
                </label>
            </div>
            <div class="radio radio-danger">
               <input type="radio" name="tipo" id="radio3" value="0" >
               <label for="Público">
                   Público
               </label>
            </div>
            
          </div>
           <div class="col-lg-5">
	          	<div class="form-group" >
    			<label>Prazo: </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> 
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12">
          
          	<label>Empresa: </label>
            <select name="estado" class="form-control chosen-select" id="empresa" >
               <option value="0">Escolha uma empresa</option>
                <?php
                    $query = "SELECT * 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['id_cliente'].'">'.$ln['razao_cliente'].'</option>';
                 }
              ?>
                
            </select>

</div>          
        </div>
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12" id="cidade">
          	
          </div>          
        </div>
        
        <div class="form-group login-username col-lg-12">
          
          <div class="col-lg-4">
          <label>Responsável: </label>
            <select name="responsa" class="form-control chosen-select" id="responsa" >
               <option value="0">Escolha um responsável</option>
                <?php
                    $query = "SELECT id_user, nome_user, sobrenome_user FROM cw_user ORDER BY nome_user";
                    $link   = DBConnect();
                    $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                 while($ln = mysqli_fetch_assoc($result)){?>
                <option value="<?php echo $ln['id_user']; ?>"><?php echo $ln['nome_user']; ?> <?php echo $ln['sobrenome_user']; ?></option>
                 <?php } ?>
                
            </select>
          </div>
          
          <div class="col-lg-8">
          	<label>Participantes WebChat: </label>
            <?php
			$query = "SELECT id_user, nome_user, sobrenome_user FROM cw_user WHERE id_user!='$_SESSION[IDCLI]' ORDER BY nome_user";
			$link   = DBConnect();
			$result = @mysqli_query($link, $query) or die(mysqli_error($link));
		    ?>
          	
            <select data-placeholder="Selecione o usuário" name="para[]" class="chosen-select3 form-control" multiple  tabindex="2">
                
                
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['id_user']; ?>"><?php echo $res['nome_user']; ?> <?php echo $res['sobrenome_user']; ?></option>
                 <?php } ?>
            
            
            </select>
          </div>
                    
        </div>
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12">
          	<label>Assunto: </label>
            <input type="text" name="assunto" class="form-control" id="assunto" placeholder="Digite o assunto" 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" required=""></textarea>
          </div>
                   
        </div>
                            
        </div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary" id="mandarcoisas3" value="CADASTRAR" type="submit">
            <input name="button" type="submit" disabled="disabled" class="btn btn-block btn-lg btn-primary" id="mandarcoisas4" value="CADASTRAR" />
          </div>
        </div>
         
      </form>  
      </div>
      
    </div>
     
    
  </div>

<div class="modal signUpContent fade" id="ModalAnexo" 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" > ANEXAR ARQUIVOS </h3>
      </div>
	  
      <div class="modal-body">
        <form action="../upload/upload.php" class="dropzone">
		
		</form>
      </div>
      
    </div>
     
    
  </div>