eclass.unmer.ac.id

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

<li>
                            <button data-toggle="modal" data-target="#ModalRelatorioGeral" type="button" class="btn btn-info btn-sm"><i class="fa fa-check-square-o"></i> Relatórios Geral</button>
                        </li>

</ol>
                </div>
                <div class="col-lg-2">

</div>
	
            </div>

<div class="ibox">
                        
                        
                        <div class="tabs-container">
                        <ul class="nav nav-tabs">
                            
                            <li class="active"><a data-toggle="tab" href="#tab-2"><i class="fa fa-briefcase"></i> Clientes</a></li>
                        </ul>
                        <div class="tab-content">
            
              
              
                    <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">
                                    <i class="fa fa-refresh refresh" style="font-size: 21px; cursor: pointer;"></i>
                                </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">
              
                          <table class="footable table table-stripped" data-page-size="40000" data-filter=#filter>
                              
                              <tbody>
                              <?php
                                $query = "SELECT * FROM cw_cliente ORDER BY razao_cliente ";
                                $link   = DBConnect();
                                $result = @mysqli_query($link, $query) or die(mysqli_error($link));
                                $row    =  mysqli_num_rows($result);
                              
                                while($res = mysqli_fetch_assoc($result)){ ?>
                                        
                                  <tr lang='<?php echo $res['id_cliente']; ?>'>
                                    <td>
                                      <a href="#" title="Excluir" id="<?php echo $res['id_cliente']; ?>" class="deletarcliente" ><i class="fa fa-trash"> </i></a>
                                    </td> 
                                    
                                                                             
                                    <td><a href="./?pag=cliente&id=<?php echo $res['id_cliente']; ?>" class="client-link"><?php echo $res['codigo_cliente']; ?></a></td>
                                                                              
                                    <td><a href="./?pag=cliente&id=<?php echo $res['id_cliente']; ?>" class="client-link"><?php echo $res['razao_cliente']; ?></a></td>
                                    
                                    <td width="15%"><?php echo $res['cnpj_cliente']; ?></td>
                                    
                                    <td width="15%"><i class="fa fa-phone-square"> </i> <?php echo $res['telefone_cliente']; ?></td>
                                    
                                    <td width="2%" class="client-status">
                                      <?php if($res['status_cliente']==0){ ?>

<a href="#" title="Alterar Status" id="<?php echo $res['id_cliente']; ?>" class="desativarcli">
                                      <span class="label label-primary">Ativo</span>
                                      </a>
                                      
                                      <?php }else{ ?>
                                      <a href="#" title="Alterar Status" id="<?php echo $res['id_cliente']; ?>" class="ativarcli">
                                      <span class="label label-danger">Desativada</span>
                                      </a>
                                      
                                      <?php } ?>
                                    </td>
                                    
                                    <td class="project-actions">
                                      <a href="./?pag=cliente&id=<?php echo $res['id_cliente']; ?>" 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" >
  <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 CLIENTE </h3>
      </div>
	  
      <div class="modal-body">
      <form role="form" name="logar3" method="post" action="includes/cadCliente.php">
          
        <div class="form-group login-username col-lg-12">
          
          <div class="col-lg-3 tipoDoc">

</div>
          
          <div class="col-lg-4">
          	<label>CNPJ / CPF: </label>
                <div style="display:block" id="div_cnpj">  
        
                <input type="text" id="verificacnpj" class="form-control cnpj verificacnpj" name="cnpj"  />
                <div class="jacadastradocnpj" style="padding:5px"></div>  
        
                </div>  
        
                <div style="display:none" id="div_cpf">  
        
                <input type="text" id="verificacpf" class="form-control cpf verificacpf" name="cpf" />
                <div class="jacadastradocnpj" style="padding:5px"></div>  
        
                </div>  
          </div>
          
          <div class="col-lg-5">
          <label>Código: </label>
          	<input name="codigocliente" type="number" class="form-control" id="codigocliente" placeholder="Digite o código" />
            <div class="jacadastradocodigo" style="padding:5px"></div>
          </div> 
                
        </div>
        
        
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12">
          	<label>Razão Social: </label>
            <input type="text" name="razao" class="form-control" placeholder="Digite a razão social" required="">
          </div>          
        </div>
        
        
        
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-7">
          	<label>E-mail: </label>
            <input type="e-mail" name="site" id="site" class="form-control" placeholder="Digite o e-mail">
          </div>
          <div class="col-lg-5">
            <label>Responsavél: </label>
            <input type="text" name="responsavel" id="responsavel" class="form-control" placeholder="Digite o responsavél">
          </div>
        </div>  
       
        
        
        
        
                            
        </div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary cadnewcli" value="CADASTRAR" type="submit">
            <input name="submit" type="button" disabled="disabled" class="btn cadnewclib  btn-block btn-lg btn-primary" value="CADASTRAR" />
          </div>
        </div>
         
      </form>  
      </div>
      
    </div>
     
    
  </div>

<div class="modal signUpContent fade" id="ModalTipo_" 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 TIPO </h3>
      </div>
	  
      <div class="modal-body">
      <form role="form" name="logar3" method="post" action="includes/cadCliente.php">
          
        <div class="form-group login-username col-lg-12">
          <div class="col-lg-12">
          	<label>Razão Social: </label>
            <input type="text" name="razao" class="form-control" placeholder="Digite a razão social" required="">
          </div>          
        </div>
                    
        </div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary" value="CADASTRAR" type="submit">
          </div>
        </div>
        
         
      </form>  
      </div>
      
    </div>
     
    
  </div>

<div class="modal signUpContent fade" id="ModalRelatorio" 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" > RELATÓRIOS </h3>
      </div>
    
      <div class="modal-body">

<form role="form" name="contasreceber" method="post" action="views/relatorio_clientes.php?tp=0" target="_blank">
          
                  
        <div class="form-group login-username col-lg-4">
          <p><strong>Relatório por</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="senhas" value="1" name="relatorio" onClick="alternarLancamento('UNICO')"  checked="" />
                <label for="senhas"> Senhas</label>
            </div>
            
            <div class="radio radio-inline">
                <input type="radio" id="clientes" value="3" name="relatorio" onClick="alternarLancamento('UNICO')" />
                <label for="clientes"> Clientes </label>
            </div>
            
        </div>

<div class="form-group login-username col-lg-6">
          <p><strong>Pesquisa por Hashtag</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="ou" value="1" name="peshas" checked="" />
                <label for="ou"> OU</label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="e" value="2" name="peshas"  />
                <label for="e"> E </label>
            </div>
        </div>

<div class="form-group login-username col-lg-12">
          
          <div class="col-lg-4">
            <label>Clientes: </label>
            <?php
              $query = "SELECT * FROM cw_cliente ORDER BY razao_cliente";
              $link   = DBConnect();
              $result = @mysqli_query($link, $query) or die(mysqli_error($link));
            ?>
            
            <select data-placeholder="TODAS" name="cliente[]" class="chosen-select3 form-control" multiple  tabindex="2">
                
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['id_cliente']; ?>"><?php echo $res['razao_cliente']; ?></option>
                 <?php } ?>
            
            
            </select>

</div>
          
          <div class="col-lg-4">
            <label>Hastags: </label>
            <?php
              $query = "SELECT * FROM cw_hashtags ORDER BY nome_hashtags";
              $link   = DBConnect();
              $result = @mysqli_query($link, $query) or die(mysqli_error($link));
            ?>
            
            <select data-placeholder="TODOS" name="hashtag[]" class="chosen-select3 form-control" multiple  tabindex="2">
                
                <option value="">TODAS</option>
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['nome_hashtags']; ?>"><?php echo $res['nome_hashtags']; ?></option>
                 <?php } ?>
            
            
            </select>

</div>
          
          <div class="col-lg-4">
            <label>Senhas: </label>
            <?php
		      $query = "SELECT * FROM cw_vrnome  ORDER BY nome_vrnome";
		      $link   = DBConnect();
		      $result = @mysqli_query($link, $query) or die(mysqli_error($link));
		        ?>
            
            <select data-placeholder="TODOS" name="senha[]" class="chosen-select3 form-control" multiple  tabindex="2">
                
                
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['nome_vrnome']; ?>"><?php echo $res['nome_vrnome']; ?></option>
                 <?php } ?>
            
            
            </select>
          </div>
                    
        </div>

<div class="form-group login-username col-lg-7">
          <p><strong>Ordenar por</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="ordem" value="1" name="ordem"  checked="">
                <label for="ordem"> Código Cliente</label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="ordem2" value="2" name="ordem"  >
                <label for="ordem2"> Razão Social </label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="ordem3" value="3" name="ordem" >
                <label for="ordem3"> Cidade </label>
            </div>
        </div>
        
        <div class="form-group login-username col-lg-5">
          <p><strong>Filtrar por</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="filtro" value="2" name="filtro" checked="" />
                <label for="filtro"> Ativos </label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="filtro2" value="3" name="filtro" />
                <label for="filtro2"> Desativada </label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="filtro3" value="1" name="filtro" />
                <label for="filtro3"> Todos </label>
            </div>
        </div>

</div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary" value="EMITIR" type="submit">
          </div>
        </div>

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

<div class="modal signUpContent fade" id="ModalRelatorioGeral" 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" > RELATÓRIO GERAL </h3>
      </div>
    
      <div class="modal-body">

<form role="form" name="contasreceber" method="post" action="views/relatorio_clientes.php" target="_blank">
          
                  
        <div class="form-group login-username col-lg-8">
          <p><strong>Buscar por</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="na" value="1" name="por" onClick="alternarRelatorio('NA')"  checked="" />
                <label for="na"> N/A</label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="hashtag" value="3" name="por" onClick="alternarRelatorio('HAS')" />
                <label for="hashtag"> Hashtag </label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="senha" value="3" name="por" onClick="alternarRelatorio('SENHA')" />
                <label for="senha"> Senhas </label>
            </div>
        </div>

<div class="form-group login-username col-lg-12">
          
          <div class="col-lg-8">
            <label>Clientes: </label>
            <?php
              $query = "SELECT * FROM cw_cliente ORDER BY razao_cliente";
              $link   = DBConnect();
              $result = @mysqli_query($link, $query) or die(mysqli_error($link));
            ?>
            
            <select data-placeholder="TODAS" name="cliente[]" class="chosen-select3 form-control" multiple  tabindex="2">
                
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['id_cliente']; ?>"><?php echo $res['razao_cliente']; ?></option>
                 <?php } ?>
            
            
            </select>

</div>
          
        <div style="display:none" id="div_has">
          <div class="col-lg-4">
            <label>Hastags: </label>
            <?php
              $query = "SELECT * FROM cw_hashtags ORDER BY nome_hashtags";
              $link   = DBConnect();
              $result = @mysqli_query($link, $query) or die(mysqli_error($link));
            ?>
            
            <select data-placeholder="TODOS" name="hashtag[]" class="chosen-select777 form-control" multiple  tabindex="2">
                
                <option value="">TODAS</option>
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['nome_hashtags']; ?>"><?php echo $res['nome_hashtags']; ?></option>
                 <?php } ?>
            
            
            </select>

</div>
        </div>

<div style="display:none" id="div_senha">  
          <div class="col-lg-4">
            <label>Senhas: </label>
            <?php
          $query = "SELECT * FROM cw_vrnome  ORDER BY nome_vrnome";
          $link   = DBConnect();
          $result = @mysqli_query($link, $query) or die(mysqli_error($link));
            ?>
            
            <select data-placeholder="TODOS" name="senha[]" class="chosen-select777 form-control" multiple  tabindex="2">
                
                
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['nome_vrnome']; ?>"><?php echo $res['nome_vrnome']; ?></option>
                 <?php } ?>
            
            
            </select>
          </div>
        </div>
                    
        </div>

<div class="checkbox checkbox-success">
              <input type="checkbox" name="codigo" value="1" >
              <label for="inlineCheckbox2"> Código </label>
          </div>

<div class="checkbox checkbox-success">
              <input type="checkbox" name="rsozial" value="1" >
              <label for="inlineCheckbox2"> Razão Social </label>
          </div>

<div class="checkbox checkbox-success">
              <input type="checkbox" name="endereco" value="1" >
              <label for="inlineCheckbox2"> Endereço </label>
          </div>

</div>

</div>

<div class="checkbox checkbox-success">
              <input type="checkbox" name="obs" value="1" >
              <label for="inlineCheckbox2"> Observação </label>
          </div>

<div class="checkbox checkbox-success">
              <input type="checkbox" name="status" value="1" >
              <label for="inlineCheckbox2"> Status </label>
          </div>

</div>
        
        <div id="divprincipal" class="newprojeto" style="display:none">
          <div class="form-group login-username col-lg-10">
          <div class="col-lg-5">
            <div class="form-group" >
            <label>DE: </label>
             <div class="input-group date">
                 <span class="input-group-addon"><i class="fa fa-calendar" title="Competência incial"></i></span><input type="text" class="form-control" id="data_1" name="de">
             </div>
             </div>

</div>
         
          <div class="col-lg-5">
              <div class="form-group" >
              <label>ATÉ: </label>
               <div class="input-group date">
                   <span class="input-group-addon"><i class="fa fa-calendar-o" title="Competência final"></i></span><input type="text" class="form-control"  id="data_2" name="ate">
               </div>
               </div>

</div>
          </div>

</div>

<div class="form-group login-username col-lg-5">
          <p><strong>Filtrar por</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="filtro" value="2" name="filtro" checked="" />
                <label for="filtro"> Ativos </label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="filtro2" value="3" name="filtro" />
                <label for="filtro2"> Desativada </label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="filtro3" value="1" name="filtro" />
                <label for="filtro3"> Todos </label>
            </div>
        </div>

</div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary" value="EMITIR" type="submit">
          </div>
        </div>

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

<div class="modal signUpContent fade" id="ModalListar" 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" > CRIAR LISTAGEM DE OBRIGAÇÕES </h3>
      </div>
    
      <div class="modal-body">

</div>

<div class="form-group login-username col-lg-4">
          <p><strong>Relatório por</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="clientes" value="3" name="relatorio" checked="" />
                <label for="clientes"> Clientes </label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="senhas" value="1" name="relatorio"  />
                <label for="senhas"> Senhas</label>
            </div>
                        
         </div>
         <div class="form-group login-username col-lg-8">
          <p><strong>Pesquisa por Hashtag</strong>:</p>
            
            <div class="radio radio-inline">
                <input type="radio" id="ou" value="1" name="peshas" checked="" />
                <label for="ou"> OU</label>
            </div>
            <div class="radio radio-inline">
                <input type="radio" id="e" value="2" name="peshas"  />
                <label for="e"> E </label>
            </div>
        </div>

</div>
          
          <div class="col-lg-4">
            <label>Hastags: </label>
            <?php
              $query = "SELECT * FROM cw_hashtags ORDER BY nome_hashtags";
              $link   = DBConnect();
              $result = @mysqli_query($link, $query) or die(mysqli_error($link));
            ?>
            
            <select data-placeholder="TODOS" name="hashtag[]" class="chosen-select3 form-control" multiple  tabindex="2">
                
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['nome_hashtags']; ?>"><?php echo $res['nome_hashtags']; ?></option>
                 <?php } ?>
            
            
            </select>

</div>

<div class="col-lg-4">
            <label>Senhas: </label>
            <?php
          $query = "SELECT * FROM cw_vrnome  ORDER BY nome_vrnome";
          $link   = DBConnect();
          $result = @mysqli_query($link, $query) or die(mysqli_error($link));
            ?>
            
            <select data-placeholder="TODOS" name="senha[]" class="chosen-select3 form-control" multiple  tabindex="2">
                
                
                <?php while($res = mysqli_fetch_assoc($result)){ ?>
                <option value="<?php echo $res['nome_vrnome']; ?>"><?php echo $res['nome_vrnome']; ?></option>
                 <?php } ?>
            
            
            </select>
          </div>
                    
        </div>

<div class="form-group login-username col-lg-12">
	        <div class="col-lg-12 text-center" style="margin-bottom:5px">
	          <a href="#" id="addc"><strong>ADICIONAR COLUNA <i class="fa fa-plus-square"> </i></strong></a>
	        </div>
    	</div>

</div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary" value="SALVAR" type="submit">
          </div>
        </div>

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

<div class="modal signUpContent fade" id="ModalListas" 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" > LISTAGEM DE OBRIGAÇÕES </h3>
      </div>
    
      <div class="modal-body">

<tbody>
                    <?php
                      $query = "SELECT * FROM cw_listagem ORDER BY nome_listagem";
                      $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_listagem']; ?>" class="deletarlistagem" ><i class="fa fa-trash"> </i></a>
                                          </td> 
                                          
                                                                                   
                                          <td><strong><?php echo $res['nome_listagem']; ?></strong></td>
                                                                                    
                                          
                                          
                                          <td class="project-actions">
                                            <a target="_blank" href="views/relatorio_clientes.php?id=<?php echo $res['id_listagem']; ?>&tp=1" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Emitir </a>
                                          </td>  
                                          
                                          
                                        </tr>
                                        <?php } ?>
                          
                          </tbody>
                        </table>
</div>
                      
                    </div>
          
        </div>

</div>
 
        <div>
          <div>
            <input name="submit" class="btn btn-block btn-lg btn-primary" value="" type="button">
          </div>
        </div>

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