API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 23rd, 2017
64
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.63 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. include_once("../../conexao/conexao.php");
  4. include_once("../../seguranca.php");
  5. include_once("../../header.php");
  6. include_once("../../menu.php");
  7. seguranca_adm();
  8. ?>
  9.  
  10.  
  11. <?php
  12. //Verificar se está sendo passado na URL a página atual, senao é atribuido a pagina
  13. $pagina = (isset($_GET['pagina']))? $_GET['pagina'] : 1;
  14. if(!isset($_GET['pesquisar'])){
  15. header("Location: adinistrativo.php");
  16. }else{
  17. $valor_pesquisar = $_GET['pesquisar'];
  18. }
  19.  
  20.  
  21. //Selecionar todos os curriculos da tabela, tentei buscar por mais uma tabela tipo o OR tabela empresa mas não rola.
  22. $result_curriculos = "SELECT * FROM curriculos WHERE nome LIKE '%$valor_pesquisar%' OR empresa LIKE '%$valor_pesquisar'";
  23.  
  24.  
  25. $resultado_curriculos = mysqli_query($conn, $result_curriculos);
  26.  
  27. //Contar o total de curriculos
  28. //Aqui gera um erro nessa linha - Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:wamp64wwwcurriculoadmadministrativopesquisarpesquisar.php on line 84
  29. $total_curriculos = mysqli_num_rows($resultado_curriculos);
  30.  
  31. //Seta a quantidade de curriculos por pagina
  32. $quantidade_pg = 6;
  33.  
  34. //calcular o número de pagina necessárias para apresentar os curriculos
  35. $num_pagina = ceil($total_curriculos/$quantidade_pg);
  36.  
  37. //Calcular o inicio da visualizacao
  38. $incio = ($quantidade_pg*$pagina)-$quantidade_pg;
  39.  
  40. //Selecionar os curriculos a serem apresentado na página - aqui também da o erro Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:wamp64wwwcurriculoadmadministrativopesquisarpesquisar.php on line 98
  41. $result_curriculos = "SELECT * FROM curriculos WHERE nome LIKE '%$valor_pesquisar%' OR empresa LIKE '%$valor_pesquisar' limit $incio, $quantidade_pg";
  42. $resultado_curriculos = mysqli_query($conn, $result_curriculos);
  43. $total_curriculos = mysqli_num_rows($resultado_curriculos);
  44. ?>
  45.  
  46. <div class="container theme-showcase" role="main">
  47. <div class="page-header">
  48. <div class="row">
  49. <div class="col-sm-6 col-md-12">
  50. <h1>Curriculos</h1>
  51. </div>
  52. </div>
  53.  
  54. <!-- INICIO PESQUISA -->
  55. <div class="col-sm-12 col-md-12" style="padding:0px;">
  56. <form class="form-inline" method="GET" style="padding:20px 0px 20px 0px" action="pesquisar.php">
  57. <div class="form-group" style="width:100%;">
  58. <div class="form-group" style="width: 205px;">
  59. <label class="col-sm-12 control-label">Nome do candidato</label>
  60. <div class="col-sm-10">
  61. <input type="text" name="pesquisar" class="form-control" style="width:200px;" id="exampleInputName2" placeholder="Nome do candidato...">
  62. </div></div>
  63.  
  64. <?php if(!empty($row_curriculos['empresa_id'])){
  65. $empresa_id = $row_curriculos['empresa_id'];
  66. }?>
  67. <div class="form-group" style="width:205px;">
  68. <label class="col-sm-12 control-label">Empresa</label>
  69. <div class="col-sm-10">
  70. <select class="form-control" name="select_empresa">
  71. <option value="">Selecione</option>
  72. <?php
  73. $result_empresa = "SELECT * FROM empresa";
  74. $result_empresa = mysqli_query($conn, $result_empresa);
  75. while($row_empresa = mysqli_fetch_assoc($result_empresa)){ ?>
  76. <option value="<?php echo $row_empresa['id']; ?>"<?php
  77. if(!empty($_SESSION['value_select_empresa'])){
  78. if($_SESSION['value_select_empresa'] == $row_empresa['id']){
  79. echo 'selected';
  80. unset($_SESSION['value_select_empresa']);
  81. }
  82. }
  83. if(!empty($row_curriculos['empresa_id'])){
  84. if($empresa_id == $row_empresa['id']){
  85. echo 'selected';
  86. }
  87. }
  88. ?> >
  89. <?php echo $row_empresa['empresa']; ?></option>
  90. <?php } ?>
  91. </select>
  92. </div>
  93. </div>
  94. <?php if(!empty($row_curriculos['area_id'])){
  95. $area_id = $row_curriculos['area_id'];
  96. }?>
  97. <div class="form-group" style="width:145px;">
  98. <label class="col-sm-12 control-label">Área de atuação</label>
  99. <div class="col-sm-10">
  100. <select class="form-control" name="select_area">
  101. <option value="">Selecione</option>
  102. <?php
  103. $result_area = "SELECT * FROM area";
  104. $result_area = mysqli_query($conn, $result_area);
  105. while($row_area = mysqli_fetch_assoc($result_area)){ ?>
  106. <option value="<?php echo $row_area['id']; ?>"<?php
  107. if(!empty($_SESSION['value_select_area'])){
  108. if($_SESSION['value_select_area'] == $row_area['id']){
  109. echo 'selected';
  110. unset($_SESSION['value_select_area']);
  111. }
  112. }
  113. if(!empty($row_curriculos['area_id'])){
  114. if($area_id == $row_area['id']){
  115. echo 'selected';
  116. }
  117. }
  118. ?> >
  119. <?php echo $row_area['area']; ?></option>
  120. <?php } ?>
  121. </select>
  122. </div>
  123. </div>
  124. <?php if(!empty($row_curriculos['cargo_id'])){
  125. $cargo_id = $row_curriculos['cargo_id'];
  126. }?>
  127. <div class="form-group" style="width:145px;">
  128. <label class="col-sm-12 control-label">Cargo</label>
  129. <div class="col-sm-10">
  130. <select class="form-control" name="select_cargo">
  131. <option value="">Selecione</option>
  132. <?php
  133. $result_cargo = "SELECT * FROM cargo";
  134. $result_cargo = mysqli_query($conn, $result_cargo);
  135. while($row_cargo = mysqli_fetch_assoc($result_cargo)){ ?>
  136. <option value="<?php echo $row_cargo['id']; ?>"<?php
  137. if(!empty($_SESSION['value_select_cargo'])){
  138. if($_SESSION['value_select_cargo'] == $row_cargo['id']){
  139. echo 'selected';
  140. unset($_SESSION['value_select_cargo']);
  141. }
  142. }
  143. if(!empty($row_curriculos['cargo_id'])){
  144. if($cargo_id == $row_cargo['id']){
  145. echo 'selected';
  146. }
  147. }
  148. ?> >
  149. <?php echo $row_cargo['cargo']; ?></option>
  150. <?php } ?>
  151. </select>
  152. </div>
  153. </div>
  154. <?php if(!empty($row_curriculos['situacao_id'])){
  155. $situacao_id = $row_curriculos['situacao_id'];
  156. }?>
  157. <div class="form-group" style="width:145px;">
  158. <label class="col-sm-12 control-label">Sit. do curriculo</label>
  159. <div class="col-sm-10">
  160. <select class="form-control" name="select_situacao_curriculo">
  161. <option value="">Selecione</option>
  162. <?php
  163. $result_situacao = "SELECT * FROM situacao_curriculo";
  164. $result_situacao = mysqli_query($conn, $result_situacao);
  165.  
  166. while($row_situacao_curriculo = mysqli_fetch_assoc($result_situacao)){ ?>
  167.  
  168. <option value="<?php echo $row_situacao_curriculo['id']; ?>"
  169. <?php
  170. if(!empty($_SESSION['value_select_situacao_curriculo'])){
  171. if($_SESSION['value_select_situacao_curriculo'] == $row_situacao['id']){
  172. echo 'selected';
  173. unset($_SESSION['value_select_situacao_curriculo']);
  174. }
  175. }
  176. if(!empty($row_curriculos['situacao_id'])){
  177. if($situacao_id == $row_situacao_curriculo['id']){
  178. echo 'selected';
  179. }
  180. }
  181. ?> >
  182. <?php echo $row_situacao_curriculo['nome']; ?></option>
  183. <?php } ?>
  184. </select>
  185. </div>
  186. </div>
  187.  
  188.  
  189. <button type="submit" style=" margin-left: 20px; margin-top: 19px;" class="btn btn-primary">Pesquisar</button>
  190.  
  191. </div>
  192.  
  193. </form>
  194. </div>
  195.  
  196. <!-- FIM DA PESQUISA -->
  197. <!-- FIM DA PESQUISA -->
  198. </div>
  199. <div class="row">
  200. <div class="col-md-12">
  201. <table class="table">
  202. <thead>
  203. <tr>
  204. <th class="text-center">ID</th>
  205. <th class="text-center">Data de cadastro</th>
  206. <th class="text-center">Nome</th>
  207. <th class="text-center">E-mail</th>
  208. <th class="text-center">Vaga de interesse</th>
  209. <th class="text-center">Empresa</th>
  210. <th class="text-center">Área de atuação</th>
  211. <th class="text-center">Cargo</th>
  212. <th class="text-center">Telefone</th>
  213. <th class="text-center">Obs. do candidato</th>
  214. <th class="text-center">Situação Curriculo</th>
  215. <th class="text-center">Observação do R.H.</th>
  216. </tr>
  217. </thead>
  218. <tbody>
  219. <!-- aqui gera outro erro Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in C:wamp64wwwcurriculoadmadministrativopesquisarpesquisar.php on line 274 -->
  220. <?php while($row_curriculos = mysqli_fetch_assoc($resultado_curriculos)){?>
  221. <tr>
  222. <td class="text-center"><?php echo $row_curriculos["id"]; ?></td>
  223. <td class="text-center"><?php echo date('d/m/Y H:i:s',strtotime($row_curriculos["created"])); ?></td>
  224. <td class="text-center"><?php echo $row_curriculos["nome"]; ?></td>
  225. <td class="text-center"><?php echo $row_curriculos["email"]; ?></td>
  226. <td class="text-center"><?php echo $row_curriculos["vaga"]; ?></td>
  227. <td class="text-center"><?php
  228. $situacao_atual = $row_curriculos['empresa_id'];
  229. $result_empresa = "SELECT * FROM empresa WHERE id = '$situacao_atual'";
  230. $result_empresa = mysqli_query($conn, $result_empresa);
  231. $row_empresa = mysqli_fetch_assoc($result_empresa);
  232. echo $row_empresa['empresa']; ?>
  233. </td>
  234. <td class="text-center"><?php
  235. $situacao_atual = $row_curriculos['area_id'];
  236. $result_area = "SELECT * FROM area WHERE id = '$situacao_atual'";
  237. $result_area = mysqli_query($conn, $result_area);
  238. $row_area = mysqli_fetch_assoc($result_area);
  239. echo $row_area['area']; ?>
  240. </td>
  241. <td class="text-center"><?php
  242. $situacao_atual = $row_curriculos['cargo_id'];
  243. $result_cargo = "SELECT * FROM cargo WHERE id = '$situacao_atual'";
  244. $result_cargo = mysqli_query($conn, $result_cargo);
  245. $row_cargo = mysqli_fetch_assoc($result_cargo);
  246. echo $row_cargo['cargo']; ?>
  247. </td>
  248. <td class="text-center"><?php echo $row_curriculos["telefone"]; ?></td>
  249. <td class="text-center"><?php echo $row_curriculos["mensagem"]; ?></td>
  250. <td class="text-center"><?php
  251. $situacao_atual = $row_curriculos['situacao_id'];
  252. $result_situacao = "SELECT * FROM situacao_curriculo WHERE id = '$situacao_atual'";
  253. $result_situacao = mysqli_query($conn, $result_situacao);
  254. $row_situacao_curriculo = mysqli_fetch_assoc($result_situacao);
  255. echo $row_situacao_curriculo['nome']; ?></td>
  256. <td class="text-center"><?php echo $row_curriculos["mensagem_rh"]; ?></td>
  257.  
  258.  
  259. <td class="text-center">
  260. <a href="administrativo.php?link=17&id=<?php echo $row_curriculos["id"]; ?>">
  261. <button type="button" class="btn btn-xs btn-primary">
  262. Visualizar
  263. </button>
  264. </a>
  265. <a href="administrativo.php?link=18&id=<?php echo $row_curriculos["id"]; ?>">
  266. <button type="button" class="btn btn-xs btn-warning">
  267. Editar
  268. </button>
  269. </a>
  270. <a href="administrativo/processa/adm_apagar_curriculo.php?id=<?php echo $row_curriculos["id"]; ?>">
  271. <button type="button" class="btn btn-xs btn-danger">
  272. Apagar
  273. </button>
  274. </a>
  275. </td>
  276. </tr>
  277. <?php } ?>
  278. </tbody>
  279. </table>
  280. </div>
  281. </div>
  282. <?php
  283. //Verificar a pagina anterior e posterior
  284. $pagina_anterior = $pagina - 1;
  285. $pagina_posterior = $pagina + 1;
  286. ?>
  287. <nav class="text-center">
  288. <ul class="pagination">
  289. <li>
  290. <?php
  291. if($pagina_anterior != 0){ ?>
  292. <a href="pesquisar.php?pagina=<?php echo $pagina_anterior; ?>&pesquisar=<?php echo $valor_pesquisar; ?>" aria-label="Previous">
  293. <span aria-hidden="true">&laquo;</span>
  294. </a>
  295. <?php }else{ ?>
  296. <span aria-hidden="true">&laquo;</span>
  297. <?php } ?>
  298. </li>
  299. <?php
  300. //Apresentar a paginacao
  301. for($i = 1; $i < $num_pagina + 1; $i++){ ?>
  302. <li><a href="pesquisar.php?pagina=<?php echo $i; ?>&pesquisar=<?php echo $valor_pesquisar; ?>"><?php echo $i; ?></a></li>
  303. <?php } ?>
  304. <li>
  305. <?php
  306. if($pagina_posterior <= $num_pagina){ ?>
  307. <a href="pesquisar.php?pagina=<?php echo $pagina_posterior; ?>&pesquisar=<?php echo $valor_pesquisar; ?>" aria-label="Previous">
  308. <span aria-hidden="true">&raquo;</span>
  309. </a>
  310. <?php }else{ ?>
  311. <span aria-hidden="true">&raquo;</span>
  312. <?php } ?>
  313. </li>
  314. </ul>
  315. </nav>
  316. </div>
  317. <!-- Bootstrap core JavaScript
  318. ================================================== -->
  319. <!-- Placed at the end of the document so the pages load faster -->
  320. <script>window.jQuery || document.write('<script src="../../assets/js/vendor/jquery.min.js"></script>')</script>
  321. <script src="../../js/bootstrap.min.js"></script>
  322. <script src="../../js/docs.min.js"></script>
  323. <!-- IE10 viewport hack for Surface/desktop Windows 8 bug -->
  324. <script src="../../js/ie10-viewport-bug-workaround.js"></script>
  325. </body>
  326. </html>
  327.  
  328. $result_curriculos = "SELECT * FROM curriculos WHERE nome LIKE '%$valor_pesquisar%' limit $incio, $quantidade_pg";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!