API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 11th, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 115.93 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. session_start();
  3. require 'config.php';
  4. require '../classes/usuarios.class.php';
  5. require '../classes/historico.class.php';
  6. $log = new Historico();
  7. $log->registrar("usuario logou no sistema", "");
  8.  
  9. if(!isset($_SESSION['logado'])) {
  10. header("Location: login.php");
  11. exit;
  12. }
  13.  
  14. if(isset($_SESSION['success']) && !empty($_SESSION['success'])){
  15. echo $_SESSION['success'];
  16. unset($_SESSION['success']);
  17. }
  18.  
  19. if(isset($_SESSION['error']) && !empty($_SESSION['error'])){
  20. echo $_SESSION['error'];
  21. usnet($_SESSION['error']);
  22.  
  23. }
  24.  
  25. $usuarios = new Usuarios($pdo);
  26. $usuarios->setUsuario($_SESSION['logado']);
  27.  
  28. $Usuarios = new Usuarios($pdo);
  29. $lista = $Usuarios->getUsuarios();
  30. ?>
  31. <?php
  32. if ($_SESSION['logado'] == "opadmin@gmail.com") {
  33. echo '<a href="tabelarelatorio.php" class="btn btn-primary btn-xs" target="_blank" style="margin-left:185px">GerarPdf</a> ';
  34. }
  35. ?>
  36.  
  37. <div class="container" id="" >
  38. <a href="../sair.php" class='btn btn-primary btn-xs'>Sair</a>
  39.  
  40. <table border="1" width="250px" style ="margin-left:35px;margin-top:-18px">
  41. <tr>
  42. <th style="text-align:center">
  43. <?php
  44. $email = $_SESSION['logado'] ;
  45. $sql ="SELECT email FROM usuarios ";
  46. $sql = $pdo->query($sql); if ($sql->rowCount() > 0) {
  47. $sql = $sql->fetch();
  48. echo ''.$_SESSION['logado'].' ';
  49. }
  50. ?>
  51. <?php
  52. $sql ="SELECT * FROM titulos";
  53. $sql = $pdo->query($sql);
  54. if ($sql->rowCount()>0) {
  55. foreach($sql->fetchAll() as $titulos){
  56.  
  57.  
  58. }
  59. }
  60.  
  61.  
  62. function ajustar_data($data){
  63. if(count(explode("/",$data)) > 1){
  64. return implode("-",array_reverse(explode("/",$data)));
  65. }elseif(count(explode("-",$data)) > 1){
  66. return implode("/",array_reverse(explode("-",$data)));
  67. }
  68. }
  69.  
  70. ?>
  71. </th>
  72.  
  73. </table>
  74. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  75. <link rel="stylesheet" href="css/style.css">
  76. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  77. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  78.  
  79. <body >
  80. <table border="1" width="100%">
  81. <tr>
  82. <th style="background-color:blue;text-align:center"> <?php echo "<a href='editar_faseOp.php?id={$titulos['id']}' class='btn btn-primary btn-xs' >edt</a>-".$titulos['fase'].' ' ?></th>
  83. </tr>
  84. <tr>
  85.  
  86. <th style="background-color:#DDD;text-align:center"> <?php echo "<a href='editar_titulo.php?id={$titulos['id']}' class='btn btn-primary btn-xs'>edt</a>-".$titulos['titulo'].' Inicio '.ajustar_data($titulos['data_inicio']).' até '.ajustar_data($titulos['data_fim']).' ' ?></th>
  87. </tr>
  88. <tr>
  89. <th style="background-color:Yellow;text-align:center">2.LOGÍSTICA</th>
  90. </tr>
  91. <tr>
  92. <th></th>
  93. </tr>
  94.  
  95. </table>
  96. <table border="1" width="100%">
  97.  
  98. <?php
  99.  
  100.  
  101.  
  102. if($_SESSION['logado'] == "opadmin@gmail.com"){
  103.  
  104. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classei";
  105. $sql1= "SELECT SUM(op1) AS 'op1', SUM(op2) AS 'op2' FROM classei";
  106.  
  107. $sql = $pdo->query($sql);
  108. $sql1 = $pdo->query($sql1);
  109.  
  110. foreach ($sql1 as $key) {
  111.  
  112. }
  113.  
  114. if ($sql->rowCount()>0) {
  115. echo '<table border="1" width="100%" class="table">';
  116. echo '<tr>';
  117. echo'<th style="background-color:lime;text-align:center">'.'CLI'.'</th>';
  118. echo '</tr>';
  119. echo '</table>';
  120. echo '<table border="1" width="100%" class="table">';
  121.  
  122. echo '<tr>';
  123. echo'<th>'.'Itens'.'</th>';
  124. echo'<th>'.'op1'.'</th>';
  125. echo'<th>'.'op2'.'</th>';
  126. echo'<th>'.'op3'.'</th>';
  127. echo'<th>'.'op4'.'</th>';
  128. echo'<th>'.'op5'.'</th>';
  129. echo'<th>'.'op6'.'</th>';
  130. echo'<th>'.'op7'.'</th>';
  131. echo'<th>'.'op8'.'</th>';
  132. echo'<th>'.'op9'.'</th>';
  133. echo'<th>'.'op10'.'</th>';
  134. echo'<th>'.'op11'.'</th>';
  135. echo'<th>'.'op12'.'</th>';
  136. echo'<th>'.'total'.'</th>';
  137. echo'<th>'.'Ações'.'</th>';
  138. echo '</tr>';
  139. foreach($sql->fetchAll() as $classei){
  140.  
  141.  
  142. echo '<tr>';
  143. echo'<td>'.$classei ['item'].'</td>';
  144. echo'<td>'.$classei ['op1'].'</td>';
  145. echo'<td>'.$classei ['op2'].'</td>';
  146. echo'<td>'.$classei ['op3'].'</td>';
  147. echo'<td>'.$classei ['op4'].'</td>';
  148. echo'<td>'.$classei ['op5'].'</td>';
  149. echo'<td>'.$classei ['op6'].'</td>';
  150. echo'<td>'.$classei ['op7'].'</td>';
  151. echo'<td>'.$classei ['op8'].'</td>';
  152. echo'<td>'.$classei ['op9'].'</td>';
  153. echo'<td>'.$classei ['op10'].'</td>';
  154. echo'<td>'.$classei ['op11'].'</td>';
  155. echo'<td>'.$classei ['op12'].'</td>';
  156. echo'<td>'.$classei ['total'].'</td>';
  157. echo "<td><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classei['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  158. echo '</tr>';
  159.  
  160. }
  161.  
  162. echo '<tr>';
  163. echo'<td>'.'total'.'</td>';
  164. echo'<td>'.$key['op1'].'</td>';
  165. echo'<td>'.$key['op2'].'</td>';
  166. echo'<td>'.''.'</td>';
  167. echo'<td>'.''.'</td>';
  168. echo'<td>'.''.'</td>';
  169. echo'<td>'.''.'</td>';
  170. echo'<td>'.''.'</td>';
  171. echo'<td>'.''.'</td>';
  172. echo'<td>'.''.'</td>';
  173. echo'<td>'.''.'</td>';
  174. echo'<td>'.''.'</td>';
  175. echo'<td>'.''.'</td>';
  176. echo'<td>'.''.'</td>';
  177. echo'<td>'.''.'</td>';
  178. echo '</tr>';
  179. }
  180.  
  181. ?>
  182. </table>
  183.  
  184. <?php
  185. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_ii";
  186. $sql = $pdo->query($sql);
  187. if ($sql->rowCount()>0) {
  188. echo '<table border="1" width="100%" class="table">';
  189. echo '<tr>';
  190. echo'<th style="background-color:lime;text-align:center">'.'CLII'.'</th>';
  191. echo '</tr>';
  192. echo '</table>';
  193. echo '<table border="1" width="100%" class="table">';
  194.  
  195. echo '<tr>';
  196. echo'<th>'.'Itens'.'</th>';
  197. echo'<th>'.'op1'.'</th>';
  198. echo'<th>'.'op2'.'</th>';
  199. echo'<th>'.'op3'.'</th>';
  200. echo'<th>'.'op4'.'</th>';
  201. echo'<th>'.'op5'.'</th>';
  202. echo'<th>'.'op6'.'</th>';
  203. echo'<th>'.'op7'.'</th>';
  204. echo'<th>'.'op8'.'</th>';
  205. echo'<th>'.'op9'.'</th>';
  206. echo'<th>'.'op10'.'</th>';
  207. echo'<th>'.'op11'.'</th>';
  208. echo'<th>'.'op12'.'</th>';
  209. echo'<th>'.'total'.'</th>';
  210. echo'<th>'.'Ações'.'</th>';
  211. echo '</tr>';
  212. foreach($sql->fetchAll() as $classe_ii){
  213. echo '<tr>';
  214. echo'<td>'.$classe_ii ['item'].'</td>';
  215. echo'<td>'.$classe_ii ['op1'].'</td>';
  216. echo'<td>'.$classe_ii ['op2'].'</td>';
  217. echo'<td>'.$classe_ii ['op3'].'</td>';
  218. echo'<td>'.$classe_ii ['op4'].'</td>';
  219. echo'<td>'.$classe_ii ['op5'].'</td>';
  220. echo'<td>'.$classe_ii ['op6'].'</td>';
  221. echo'<td>'.$classe_ii ['op7'].'</td>';
  222. echo'<td>'.$classe_ii ['op8'].'</td>';
  223. echo'<td>'.$classe_ii ['op9'].'</td>';
  224. echo'<td>'.$classe_ii ['op10'].'</td>';
  225. echo'<td>'.$classe_ii ['op11'].'</td>';
  226. echo'<td>'.$classe_ii ['op12'].'</td>';
  227. echo'<td>'.$classe_ii ['total'].'</td>';
  228. echo "<td><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classei['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  229. echo '</tr>';
  230.  
  231. }
  232. }
  233.  
  234. ?>
  235.  
  236. </table>
  237.  
  238. <?php
  239. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_iii";
  240. $sql = $pdo->query($sql);
  241. if ($sql->rowCount()>0) {
  242. echo '<table border="1" width="100%" class="table">';
  243. echo '<tr>';
  244. echo'<th style="background-color:lime;text-align:center">'.'CLIII'.'</th>';
  245. echo '</tr>';
  246. echo '</table>';
  247. echo '<table border="1" width="100%" class="table">';
  248.  
  249. echo '<tr>';
  250. echo'<th>'.'Itens'.'</th>';
  251. echo'<th>'.'op1'.'</th>';
  252. echo'<th>'.'op2'.'</th>';
  253. echo'<th>'.'op3'.'</th>';
  254. echo'<th>'.'op4'.'</th>';
  255. echo'<th>'.'op5'.'</th>';
  256. echo'<th>'.'op6'.'</th>';
  257. echo'<th>'.'op7'.'</th>';
  258. echo'<th>'.'op8'.'</th>';
  259. echo'<th>'.'op9'.'</th>';
  260. echo'<th>'.'op10'.'</th>';
  261. echo'<th>'.'op11'.'</th>';
  262. echo'<th>'.'op12'.'</th>';
  263. echo'<th>'.'total'.'</th>';
  264. echo'<th>'.'Ações'.'</th>';
  265. echo '</tr>';
  266. foreach($sql->fetchAll() as $classe_iii){
  267. echo '<tr>';
  268. echo'<td>'.$classe_iii ['item'].'</td>';
  269. echo'<td>'.$classe_iii ['op1'].'</td>';
  270. echo'<td>'.$classe_iii ['op2'].'</td>';
  271. echo'<td>'.$classe_iii ['op3'].'</td>';
  272. echo'<td>'.$classe_iii ['op4'].'</td>';
  273. echo'<td>'.$classe_iii ['op5'].'</td>';
  274. echo'<td>'.$classe_iii ['op6'].'</td>';
  275. echo'<td>'.$classe_iii ['op7'].'</td>';
  276. echo'<td>'.$classe_iii ['op8'].'</td>';
  277. echo'<td>'.$classe_iii ['op9'].'</td>';
  278. echo'<td>'.$classe_iii ['op10'].'</td>';
  279. echo'<td>'.$classe_iii ['op11'].'</td>';
  280. echo'<td>'.$classe_iii ['op12'].'</td>';
  281. echo'<td>'.$classe_iii ['total'].'</td>';
  282. echo "<td><a href='Editar_valor.php?id={$classei['id']}&tabela=classe_iii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_iii['id']}&tabela=classe_iii' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classe_iii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  283. echo '</tr>';
  284. }
  285. }
  286.  
  287. ?>
  288.  
  289. </table>
  290.  
  291. <?php
  292. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_va";
  293. $sql = $pdo->query($sql);
  294. if ($sql->rowCount()>0) {
  295. echo '<table border="1" width="100%" class="table">';
  296. echo '<tr>';
  297. echo'<th style="background-color:lime;text-align:center">'.'CLV-A'.'</th>';
  298. echo '</tr>';
  299. echo '</table>';
  300. echo '<table border="1" width="100%" class="table">';
  301.  
  302. echo '<tr>';
  303. echo'<th>'.'Itens'.'</th>';
  304. echo'<th>'.'op1'.'</th>';
  305. echo'<th>'.'op2'.'</th>';
  306. echo'<th>'.'op3'.'</th>';
  307. echo'<th>'.'op4'.'</th>';
  308. echo'<th>'.'op5'.'</th>';
  309. echo'<th>'.'op6'.'</th>';
  310. echo'<th>'.'op7'.'</th>';
  311. echo'<th>'.'op8'.'</th>';
  312. echo'<th>'.'op9'.'</th>';
  313. echo'<th>'.'op10'.'</th>';
  314. echo'<th>'.'op11'.'</th>';
  315. echo'<th>'.'op12'.'</th>';
  316. echo'<th>'.'total'.'</th>';
  317. echo'<th>'.'Ações'.'</th>';
  318. echo '</tr>';
  319. foreach($sql->fetchAll() as $classe_va){
  320. echo '<tr>';
  321. echo'<td>'.$classe_va ['item'].'</td>';
  322. echo'<td>'.$classe_va ['op1'].'</td>';
  323. echo'<td>'.$classe_va ['op2'].'</td>';
  324. echo'<td>'.$classe_va ['op3'].'</td>';
  325. echo'<td>'.$classe_va ['op4'].'</td>';
  326. echo'<td>'.$classe_va ['op5'].'</td>';
  327. echo'<td>'.$classe_va ['op6'].'</td>';
  328. echo'<td>'.$classe_va ['op7'].'</td>';
  329. echo'<td>'.$classe_va ['op8'].'</td>';
  330. echo'<td>'.$classe_va ['op9'].'</td>';
  331. echo'<td>'.$classe_va ['op10'].'</td>';
  332. echo'<td>'.$classe_va ['op11'].'</td>';
  333. echo'<td>'.$classe_va ['op12'].'</td>';
  334. echo'<td>'.$classe_va ['total'].'</td>';
  335. echo "<td><a href='Editar_valor.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classe_va['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  336. echo '</tr>';
  337. }
  338. }
  339.  
  340. ?>
  341.  
  342. </table>
  343.  
  344. <?php
  345. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_vm";
  346. $sql = $pdo->query($sql);
  347. if ($sql->rowCount()>0) {
  348. echo '<table border="1" width="100%" class="table">';
  349. echo '<tr>';
  350. echo'<th style="background-color:lime;text-align:center">'.'CL V-M'.'</th>';
  351. echo '</tr>';
  352. echo '</table>';
  353. echo '<table border="1" width="100%" class="table">';
  354.  
  355. echo '<tr>';
  356. echo'<th>'.'Itens'.'</th>';
  357. echo'<th>'.'op1'.'</th>';
  358. echo'<th>'.'op2'.'</th>';
  359. echo'<th>'.'op3'.'</th>';
  360. echo'<th>'.'op4'.'</th>';
  361. echo'<th>'.'op5'.'</th>';
  362. echo'<th>'.'op6'.'</th>';
  363. echo'<th>'.'op7'.'</th>';
  364. echo'<th>'.'op8'.'</th>';
  365. echo'<th>'.'op9'.'</th>';
  366. echo'<th>'.'op10'.'</th>';
  367. echo'<th>'.'op11'.'</th>';
  368. echo'<th>'.'op12'.'</th>';
  369. echo'<th>'.'total'.'</th>';
  370. echo'<th>'.'Ações'.'</th>';
  371. echo '</tr>';
  372. foreach($sql->fetchAll() as $classe_vm){
  373. echo '<tr>';
  374. echo'<td>'.$classe_vm ['item'].'</td>';
  375. echo'<td>'.$classe_vm ['op1'].'</td>';
  376. echo'<td>'.$classe_vm ['op2'].'</td>';
  377. echo'<td>'.$classe_vm ['op3'].'</td>';
  378. echo'<td>'.$classe_vm ['op4'].'</td>';
  379. echo'<td>'.$classe_vm ['op5'].'</td>';
  380. echo'<td>'.$classe_vm ['op6'].'</td>';
  381. echo'<td>'.$classe_vm ['op7'].'</td>';
  382. echo'<td>'.$classe_vm ['op8'].'</td>';
  383. echo'<td>'.$classe_vm ['op9'].'</td>';
  384. echo'<td>'.$classe_vm ['op10'].'</td>';
  385. echo'<td>'.$classe_vm ['op11'].'</td>';
  386. echo'<td>'.$classe_vm ['op12'].'</td>';
  387. echo'<td>'.$classe_vm ['total'].'</td>';
  388. echo "<td><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classe_vm['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  389. echo '</tr>';
  390.  
  391. }
  392. }
  393.  
  394. ?>
  395.  
  396. </table>
  397.  
  398.  
  399. <?php
  400. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_vml";
  401. $sql = $pdo->query($sql);
  402. if ($sql->rowCount()>0) {
  403. echo '<table border="1" width="100%" class="table">';
  404. echo '<tr>';
  405. echo'<th style="background-color:lime;text-align:center">'.'CL V-ML'.'</th>';
  406. echo '</tr>';
  407. echo '</table>';
  408. echo '<table border="1" width="100%" class="table">';
  409.  
  410. echo '<tr>';
  411. echo'<th>'.'Itens'.'</th>';
  412. echo'<th>'.'op1'.'</th>';
  413. echo'<th>'.'op2'.'</th>';
  414. echo'<th>'.'op3'.'</th>';
  415. echo'<th>'.'op4'.'</th>';
  416. echo'<th>'.'op5'.'</th>';
  417. echo'<th>'.'op6'.'</th>';
  418. echo'<th>'.'op7'.'</th>';
  419. echo'<th>'.'op8'.'</th>';
  420. echo'<th>'.'op9'.'</th>';
  421. echo'<th>'.'op10'.'</th>';
  422. echo'<th>'.'op11'.'</th>';
  423. echo'<th>'.'op12'.'</th>';
  424. echo'<th>'.'total'.'</th>';
  425. echo'<th>'.'Ações'.'</th>';
  426. echo '</tr>';
  427. foreach($sql->fetchAll() as $classe_vml){
  428. echo '<tr>';
  429. echo'<td>'.$classe_vml ['item'].'</td>';
  430. echo'<td>'.$classe_vml ['op1'].'</td>';
  431. echo'<td>'.$classe_vml ['op2'].'</td>';
  432. echo'<td>'.$classe_vml ['op3'].'</td>';
  433. echo'<td>'.$classe_vml ['op4'].'</td>';
  434. echo'<td>'.$classe_vml ['op5'].'</td>';
  435. echo'<td>'.$classe_vml ['op6'].'</td>';
  436. echo'<td>'.$classe_vml ['op7'].'</td>';
  437. echo'<td>'.$classe_vml ['op8'].'</td>';
  438. echo'<td>'.$classe_vml ['op9'].'</td>';
  439. echo'<td>'.$classe_vml ['op10'].'</td>';
  440. echo'<td>'.$classe_vml ['op11'].'</td>';
  441. echo'<td>'.$classe_vml ['op12'].'</td>';
  442. echo'<td>'.$classe_vml ['total'].'</td>';
  443. echo "<td><a href='Editar_valor.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classe_vml['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  444. echo '</tr>';
  445.  
  446.  
  447. }
  448. }
  449. ?>
  450. </table>
  451.  
  452.  
  453. <?php
  454. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_vi";
  455. $sql = $pdo->query($sql);
  456. if ($sql->rowCount()>0) {
  457. echo '<table border="1" width="100%" class="table">';
  458. echo '<tr>';
  459. echo'<th style="background-color:lime;text-align:center">'.'CL VI'.'</th>';
  460. echo '</tr>';
  461. echo '</table>';
  462. echo '<table border="1" width="100%" class="table">';
  463.  
  464. echo '<tr>';
  465. echo'<th>'.'Itens'.'</th>';
  466. echo'<th>'.'op1'.'</th>';
  467. echo'<th>'.'op2'.'</th>';
  468. echo'<th>'.'op3'.'</th>';
  469. echo'<th>'.'op4'.'</th>';
  470. echo'<th>'.'op5'.'</th>';
  471. echo'<th>'.'op6'.'</th>';
  472. echo'<th>'.'op7'.'</th>';
  473. echo'<th>'.'op8'.'</th>';
  474. echo'<th>'.'op9'.'</th>';
  475. echo'<th>'.'op10'.'</th>';
  476. echo'<th>'.'op11'.'</th>';
  477. echo'<th>'.'op12'.'</th>';
  478. echo'<th>'.'total'.'</th>';
  479. echo'<th>'.'Ações'.'</th>';
  480. echo '</tr>';
  481. foreach($sql->fetchAll() as $classe_vi){
  482. echo '<tr>';
  483. echo'<td>'.$classe_vi ['item'].'</td>';
  484. echo'<td>'.$classe_vi ['op1'].'</td>';
  485. echo'<td>'.$classe_vi ['op2'].'</td>';
  486. echo'<td>'.$classe_vi ['op3'].'</td>';
  487. echo'<td>'.$classe_vi ['op4'].'</td>';
  488. echo'<td>'.$classe_vi ['op5'].'</td>';
  489. echo'<td>'.$classe_vi ['op6'].'</td>';
  490. echo'<td>'.$classe_vi ['op7'].'</td>';
  491. echo'<td>'.$classe_vi ['op8'].'</td>';
  492. echo'<td>'.$classe_vi ['op9'].'</td>';
  493. echo'<td>'.$classe_vi ['op10'].'</td>';
  494. echo'<td>'.$classe_vi ['op11'].'</td>';
  495. echo'<td>'.$classe_vi ['op12'].'</td>';
  496. echo'<td>'.$classe_vi ['total'].'</td>';
  497. echo "<td><a href='Editar_valor.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classe_vi['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  498. echo '</tr>';
  499.  
  500.  
  501. }
  502. }
  503. ?>
  504. </table>
  505.  
  506.  
  507. <?php
  508. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_vii";
  509. $sql = $pdo->query($sql);
  510. if ($sql->rowCount()>0) {
  511. echo '<table border="1" width="100%" class="table">';
  512. echo '<tr>';
  513. echo'<th style="background-color:lime;text-align:center">'.'CL VII'.'</th>';
  514. echo '</tr>';
  515. echo '</table>';
  516. echo '<table border="1" width="100%" class="table">';
  517.  
  518. echo '<tr>';
  519. echo'<th>'.'Itens'.'</th>';
  520. echo'<th>'.'op1'.'</th>';
  521. echo'<th>'.'op2'.'</th>';
  522. echo'<th>'.'op3'.'</th>';
  523. echo'<th>'.'op4'.'</th>';
  524. echo'<th>'.'op5'.'</th>';
  525. echo'<th>'.'op6'.'</th>';
  526. echo'<th>'.'op7'.'</th>';
  527. echo'<th>'.'op8'.'</th>';
  528. echo'<th>'.'op9'.'</th>';
  529. echo'<th>'.'op10'.'</th>';
  530. echo'<th>'.'op11'.'</th>';
  531. echo'<th>'.'op12'.'</th>';
  532. echo'<th>'.'total'.'</th>';
  533. echo'<th>'.'Ações'.'</th>';
  534. echo '</tr>';
  535. foreach($sql->fetchAll() as $classe_vii){
  536. echo '<tr>';
  537. echo'<td>'.$classe_vii ['item'].'</td>';
  538. echo'<td>'.$classe_vii ['op1'].'</td>';
  539. echo'<td>'.$classe_vii ['op2'].'</td>';
  540. echo'<td>'.$classe_vii ['op3'].'</td>';
  541. echo'<td>'.$classe_vii ['op4'].'</td>';
  542. echo'<td>'.$classe_vii ['op5'].'</td>';
  543. echo'<td>'.$classe_vii ['op6'].'</td>';
  544. echo'<td>'.$classe_vii ['op7'].'</td>';
  545. echo'<td>'.$classe_vii ['op8'].'</td>';
  546. echo'<td>'.$classe_vii ['op9'].'</td>';
  547. echo'<td>'.$classe_vii ['op10'].'</td>';
  548. echo'<td>'.$classe_vii ['op11'].'</td>';
  549. echo'<td>'.$classe_vii ['op12'].'</td>';
  550. echo'<td>'.$classe_vii ['total'].'</td>';
  551. echo "<td><a href='Editar_valor.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classe_vii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  552. echo '</tr>';
  553.  
  554.  
  555. }
  556. }
  557.  
  558. ?>
  559.  
  560. </table>
  561.  
  562. <?php
  563. $sql ="SELECT *, (op1+op2+op3+op4+op5+op6+op7+op8+op9+op10+op11+op12) as total FROM classe_ix";
  564. $sql = $pdo->query($sql);
  565. if ($sql->rowCount()>0) {
  566. echo '<table border="1" width="100%" class="table">';
  567. echo '<tr>';
  568. echo'<th style="background-color:lime;text-align:center">'.'CL IX'.'</th>';
  569. echo '</tr>';
  570. echo '</table>';
  571. echo '<table border="1" width="100%" class="table">';
  572.  
  573. echo '<tr>';
  574. echo'<th>'.'Itens'.'</th>';
  575. echo'<th>'.'op1'.'</th>';
  576. echo'<th>'.'op2'.'</th>';
  577. echo'<th>'.'op3'.'</th>';
  578. echo'<th>'.'op4'.'</th>';
  579. echo'<th>'.'op5'.'</th>';
  580. echo'<th>'.'op6'.'</th>';
  581. echo'<th>'.'op7'.'</th>';
  582. echo'<th>'.'op8'.'</th>';
  583. echo'<th>'.'op9'.'</th>';
  584. echo'<th>'.'op10'.'</th>';
  585. echo'<th>'.'op11'.'</th>';
  586. echo'<th>'.'op12'.'</th>';
  587. echo'<th>'.'total'.'</th>';
  588. echo'<th>'.'Ações'.'</th>';
  589. echo '</tr>';
  590. foreach($sql->fetchAll() as $classe_ix){
  591. echo '<tr>';
  592. echo'<td>'.$classe_ix ['item'].'</td>';
  593. echo'<td>'.$classe_ix ['op1'].'</td>';
  594. echo'<td>'.$classe_ix ['op2'].'</td>';
  595. echo'<td>'.$classe_ix ['op3'].'</td>';
  596. echo'<td>'.$classe_ix ['op4'].'</td>';
  597. echo'<td>'.$classe_ix ['op5'].'</td>';
  598. echo'<td>'.$classe_ix ['op6'].'</td>';
  599. echo'<td>'.$classe_ix ['op7'].'</td>';
  600. echo'<td>'.$classe_ix ['op8'].'</td>';
  601. echo'<td>'.$classe_ix ['op9'].'</td>';
  602. echo'<td>'.$classe_ix ['op10'].'</td>';
  603. echo'<td>'.$classe_ix ['op11'].'</td>';
  604. echo'<td>'.$classe_ix ['op12'].'</td>';
  605. echo'<td>'.$classe_ix ['total'].'</td>';
  606. echo "<td><a href='Editar_valor.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>adicionar</a>-<a href='excluir-item.php?id={$classe_ix['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  607. echo '</tr>';
  608.  
  609.  
  610. }
  611. }
  612.  
  613. ?>
  614. <?php
  615.  
  616. } elseif($_SESSION['logado'] == "op1@gmail.com"){
  617.  
  618. $sql ="SELECT *, (op1) as total FROM classei";
  619. $sql = $pdo->query($sql);
  620. ?>
  621. <div style="background-color:lime;text-align:center; height:40px; ">
  622. <h4 style="line-height:40px;">CLI</h4>
  623. </div>
  624. <?php
  625.  
  626. if ($sql->rowCount()>0) {
  627. echo '<table border="1" width="100%" class="table">';
  628.  
  629.  
  630. echo '<tr style="text-align:center">';
  631. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  632. echo'<th style="text-align:center">'.'op1'.'</th>';
  633. echo'<th style="text-align:center">'.'total'.'</th>';
  634. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  635.  
  636. echo '</tr>';
  637.  
  638. foreach($sql->fetchAll() as $classei){
  639.  
  640. echo '<tr>';
  641. echo'<td style="text-align:center">'.$classei ['item'].'</td>';
  642. echo'<td style="text-align:center">'.$classei ['op1'].'</td>';
  643. echo'<td style="text-align:center">'.$classei ['total'].'</td>';
  644. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir-item.php?id={$classei['id']}' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  645. echo '</tr>';
  646. }
  647.  
  648. echo "</table>";
  649.  
  650. }else{
  651.  
  652. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  653. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  654. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  655. echo "<a href='adicionar.php?tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>";
  656. echo '</div>';
  657. }
  658.  
  659.  
  660. ?>
  661. </table>
  662.  
  663. <?php
  664. $sql ="SELECT *, (op1) as total FROM classe_ii";
  665. $sql = $pdo->query($sql);
  666. //se >0 tem dado, senao nao tem. como vamos repetir a table, nao precisa escrecver 2x.
  667. //basta ela estar fora do if, pos apenas o indice da tabela, sem dados dinamicos
  668. //aqui pro titulo poderia ser uma div :D sem necessidade do table
  669. ?>
  670. <div style="background-color:lime;text-align:center; height:40px; ">
  671. <h4 style="line-height:40px;">CLII</h4>
  672. </div>
  673. <?php
  674. if ($sql->rowCount()>0) {
  675.  
  676. //agora so mostra a tabela se existir dado:
  677.  
  678. echo '<table border="1" width="100%" class="table" >';
  679.  
  680. echo '<tr>';
  681. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  682. echo'<th style="text-align:center">'.'op1'.'</th>';
  683. echo'<th style="text-align:center">'.'total'.'</th>';
  684. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  685. echo '</tr >';
  686.  
  687. foreach($sql->fetchAll() as $classe_ii){
  688. echo '<tr>';
  689. echo'<td style="text-align:center">'.$classe_ii ['item'].'</td>';
  690. echo'<td style="text-align:center">'.$classe_ii ['op1'].'</td>';
  691. echo'<td style="text-align:center">'.$classe_ii ['total'].'</td>';
  692. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  693. echo '</tr>';
  694. }
  695.  
  696. echo "</table>";
  697.  
  698. }else{
  699.  
  700. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  701. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  702. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  703. echo "<a href='adicionar.php?tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>";
  704. echo '</div>';
  705. }
  706.  
  707. ?>
  708.  
  709.  
  710.  
  711. <?php
  712. $sql ="SELECT *, (op1) as total FROM classe_III";
  713. $sql = $pdo->query($sql);
  714. ?>
  715. <div style="background-color:lime;text-align:center; height:40px; ">
  716. <h4 style="line-height:40px;">CLII</h4>
  717. </div>
  718. <?php
  719. if ($sql->rowCount()>0) {
  720. echo '<table border="1" width="100%" class="table">';
  721.  
  722. echo '<tr>';
  723. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  724. echo'<th style="text-align:center">'.'op1'.'</th>';
  725. echo'<th style="text-align:center">'.'total'.'</th>';
  726. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  727.  
  728. echo '</tr>';
  729. foreach($sql->fetchAll() as $classe_III){
  730. echo '<tr>';
  731. echo'<td style="text-align:center">'.$classe_III ['item'].'</td>';
  732. echo'<td style="text-align:center">'.$classe_III ['op1'].'</td>';
  733. echo'<td style="text-align:center">'.$classe_III ['total'].'</td>';
  734. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  735. echo '</tr>';
  736. }
  737.  
  738. echo "</table>";
  739.  
  740. }else{
  741.  
  742. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  743. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  744. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  745. echo "<a href='adicionar.php?tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>";
  746. echo '</div>';
  747. }
  748.  
  749. ?>
  750.  
  751.  
  752. <?php
  753. $sql ="SELECT *, (op1) as total FROM classe_va";
  754. $sql = $pdo->query($sql);
  755. ?>
  756. <div style="background-color:lime;text-align:center; height:40px; ">
  757. <h4 style="line-height:40px;">CLV-A</h4>
  758. </div>
  759. <?php
  760. if ($sql->rowCount()>0) {
  761. echo '<table border="1" width="100%" class="table">';
  762.  
  763. echo '<tr>';
  764. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  765. echo'<th style="text-align:center">'.'op1'.'</th>';
  766. echo'<th style="text-align:center">'.'total'.'</th>';
  767. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  768.  
  769. echo '</tr>';
  770. foreach($sql->fetchAll() as $classe_va){
  771. echo '<tr>';
  772. echo'<td style="text-align:center">'.$classe_va ['item'].'</td>';
  773. echo'<td style="text-align:center">'.$classe_va ['op1'].'</td>';
  774. echo'<td style="text-align:center">'.$classe_va ['total'].'</td>';
  775. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  776. echo '</tr>';
  777. }
  778.  
  779. echo "</table>";
  780.  
  781. }else{
  782.  
  783. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  784. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  785. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  786. echo "<a href='adicionar.php?tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>";
  787. echo '</div>';
  788. }
  789. ?>
  790.  
  791.  
  792. <?php
  793. $sql ="SELECT *, (op1) as total FROM classe_vm";
  794. $sql = $pdo->query($sql);
  795. ?>
  796. <div style="background-color:lime;text-align:center; height:40px; ">
  797. <h4 style="line-height:40px;">CLV-M</h4>
  798. </div>
  799. <?php
  800. if ($sql->rowCount()>0) {
  801. echo '<table border="1" width="100%" class="table">';
  802.  
  803. echo '<tr>';
  804. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  805. echo'<th style="text-align:center">'.'op1'.'</th>';
  806. echo'<th style="text-align:center">'.'total'.'</th>';
  807. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  808. echo '</tr>';
  809.  
  810. foreach($sql->fetchAll() as $classe_vm){
  811. echo '<tr>';
  812. echo'<td style="text-align:center">'.$classe_vm ['item'].'</td>';
  813. echo'<td style="text-align:center">'.$classe_vm ['op1'].'</td>';
  814. echo'<td style="text-align:center">'.$classe_vm ['total'].'</td>';
  815. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_vm' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  816. echo '</tr>';
  817. }
  818.  
  819. echo "</table>";
  820.  
  821. }else{
  822.  
  823. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  824. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  825. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  826. echo "<a href='adicionar.php?tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>";
  827. echo '</div>';
  828. }
  829.  
  830. ?>
  831.  
  832. <?php
  833. $sql ="SELECT *, (op1) as total FROM classe_vml";
  834. $sql = $pdo->query($sql);
  835. ?>
  836. <div style="background-color:lime;text-align:center; height:40px; ">
  837. <h4 style="line-height:40px;">CLV-ML</h4>
  838. </div>
  839. <?php
  840. if ($sql->rowCount()>0) {
  841. echo '<table border="1" width="100%" class="table">';
  842.  
  843. echo '<tr>';
  844. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  845. echo'<th style="text-align:center">'.'op1'.'</th>';
  846. echo'<th style="text-align:center">'.'total'.'</th>';
  847. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  848. echo '</tr>';
  849.  
  850. foreach($sql->fetchAll() as $classe_vml){
  851. echo '<tr>';
  852. echo'<td style="text-align:center">'.$classe_vml ['item'].'</td>';
  853. echo'<td style="text-align:center">'.$classe_vml ['op1'].'</td>';
  854. echo'<td style="text-align:center">'.$classe_vml ['total'].'</td>';
  855. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  856. echo '</tr>';
  857.  
  858. }
  859.  
  860. echo "</table>";
  861.  
  862. }else{
  863.  
  864. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  865. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  866. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  867. echo "<a href='adicionar.php?tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>";
  868. echo '</div>';
  869. }
  870.  
  871.  
  872.  
  873.  
  874. ?>
  875. </table>
  876.  
  877. <?php
  878. $sql ="SELECT *, (op1) as total FROM classe_vi";
  879. $sql = $pdo->query($sql);
  880. ?>
  881. <div style="background-color:lime;text-align:center; height:40px; ">
  882. <h4 style="line-height:40px;">CLVI</h4>
  883. </div>
  884. <?php
  885. if ($sql->rowCount()>0) {
  886. echo '<table border="1" width="100%" class="table">';
  887.  
  888. echo '<tr>';
  889. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  890. echo'<th style="text-align:center">'.'op1'.'</th>';
  891. echo'<th style="text-align:center">'.'total'.'</th>';
  892. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  893. echo '</tr>';
  894.  
  895. foreach($sql->fetchAll() as $classe_vi){
  896. echo '<tr>';
  897. echo'<td style="text-align:center">'.$classe_vi ['item'].'</td>';
  898. echo'<td style="text-align:center">'.$classe_vi ['op1'].'</td>';
  899. echo'<td style="text-align:center">'.$classe_vi ['total'].'</td>';
  900. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vi['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vi['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  901. echo '</tr>';
  902. }
  903.  
  904. echo "</table>";
  905.  
  906. }else{
  907.  
  908. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  909. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  910. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  911. echo "<a href='adicionar.php?tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>";
  912. echo '</div>';
  913. }
  914.  
  915.  
  916. ?>
  917. </table>
  918.  
  919. <?php
  920. $sql ="SELECT *, (op1) as total FROM classe_vii";
  921. $sql = $pdo->query($sql);
  922. ?>
  923. <div style="background-color:lime;text-align:center; height:40px; ">
  924. <h4 style="line-height:40px;">CLVII</h4>
  925. </div>
  926. <?php
  927. if ($sql->rowCount()>0) {
  928. echo '<table border="1" width="100%" class="table">';
  929.  
  930. echo '<tr>';
  931. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  932. echo'<th style="text-align:center">'.'op1'.'</th>';
  933. echo'<th style="text-align:center">'.'total'.'</th>';
  934. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  935. echo '</tr>';
  936. foreach($sql->fetchAll() as $classe_vii){
  937. echo '<tr>';
  938. echo'<td style="text-align:center">'.$classe_vii ['item'].'</td>';
  939. echo'<td style="text-align:center">'.$classe_vii ['op1'].'</td>';
  940. echo'<td style="text-align:center">'.$classe_vii ['total'].'</td>';
  941. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  942. echo '</tr>';
  943.  
  944. }
  945.  
  946. echo "</table>";
  947.  
  948. }else{
  949.  
  950. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  951. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  952. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  953. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  954. echo '</div>';
  955. }
  956.  
  957. ?>
  958. </table>
  959.  
  960. <?php
  961. $sql ="SELECT *, (op1) as total FROM classe_ix";
  962. $sql = $pdo->query($sql);
  963. ?>
  964. <div style="background-color:lime;text-align:center; height:40px; ">
  965. <h4 style="line-height:40px;">CL IX</h4>
  966. </div>
  967. <?php
  968. if ($sql->rowCount()>0) {
  969. echo '<table border="1" width="100%" class="table">';
  970.  
  971. echo '<tr>';
  972. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  973. echo'<th style="text-align:center">'.'op1'.'</th>';
  974. echo'<th style="text-align:center">'.'total'.'</th>';
  975. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  976. echo '</tr>';
  977.  
  978. foreach($sql->fetchAll() as $classe_ix){
  979. echo '<tr>';
  980. echo'<td style="text-align:center">'.$classe_ix ['item'].'</td>';
  981. echo'<td style="text-align:center">'.$classe_ix ['op1'].'</td>';
  982. echo'<td style="text-align:center">'.$classe_ix ['total'].'</td>';
  983. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ix['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  984. echo '</tr>';
  985. }
  986.  
  987. echo "</table>";
  988.  
  989. }else{
  990.  
  991. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  992. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  993. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  994. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  995. echo '</div>';
  996. }
  997.  
  998. } elseif($_SESSION['logado'] == "op2@gmail.com"){
  999.  
  1000. $sql ="SELECT *, (op2) as total FROM classei";
  1001. $sql = $pdo->query($sql);
  1002. ?>
  1003. <div style="background-color:lime;text-align:center; height:40px; ">
  1004. <h4 style="line-height:40px;">CLI</h4>
  1005. </div>
  1006. <?php
  1007.  
  1008. if ($sql->rowCount()>0) {
  1009. echo '<table border="1" width="100%" class="table">';
  1010.  
  1011.  
  1012. echo '<tr style="text-align:center">';
  1013. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1014. echo'<th style="text-align:center">'.'op2'.'</th>';
  1015. echo'<th style="text-align:center">'.'total'.'</th>';
  1016. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1017.  
  1018. echo '</tr>';
  1019.  
  1020. foreach($sql->fetchAll() as $classei){
  1021.  
  1022. echo '<tr>';
  1023. echo'<td style="text-align:center">'.$classei ['item'].'</td>';
  1024. echo'<td style="text-align:center">'.$classei ['op2'].'</td>';
  1025. echo'<td style="text-align:center">'.$classei ['total'].'</td>';
  1026. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir-item.php?id={$classei['id']}' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1027. echo '</tr>';
  1028. }
  1029.  
  1030. echo "</table>";
  1031.  
  1032. }else{
  1033.  
  1034. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1035. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1036. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1037. echo "<a href='adicionar.php?tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>";
  1038. echo '</div>';
  1039. }
  1040.  
  1041.  
  1042. ?>
  1043. </table>
  1044.  
  1045. <?php
  1046. $sql ="SELECT *, (op2) as total FROM classe_ii";
  1047. $sql = $pdo->query($sql);
  1048. //se >0 tem dado, senao nao tem. como vamos repetir a table, nao precisa escrecver 2x.
  1049. //basta ela estar fora do if, pos apenas o indice da tabela, sem dados dinamicos
  1050. //aqui pro titulo poderia ser uma div :D sem necessidade do table
  1051. ?>
  1052. <div style="background-color:lime;text-align:center; height:40px; ">
  1053. <h4 style="line-height:40px;">CLII</h4>
  1054. </div>
  1055. <?php
  1056. if ($sql->rowCount()>0) {
  1057.  
  1058. //agora so mostra a tabela se existir dado:
  1059.  
  1060. echo '<table border="1" width="100%" class="table" >';
  1061.  
  1062. echo '<tr>';
  1063. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1064. echo'<th style="text-align:center">'.'op2'.'</th>';
  1065. echo'<th style="text-align:center">'.'total'.'</th>';
  1066. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1067. echo '</tr >';
  1068.  
  1069. foreach($sql->fetchAll() as $classe_ii){
  1070. echo '<tr>';
  1071. echo'<td style="text-align:center">'.$classe_ii ['item'].'</td>';
  1072. echo'<td style="text-align:center">'.$classe_ii ['op2'].'</td>';
  1073. echo'<td style="text-align:center">'.$classe_ii ['total'].'</td>';
  1074. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1075. echo '</tr>';
  1076. }
  1077.  
  1078. echo "</table>";
  1079.  
  1080. }else{
  1081.  
  1082. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1083. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1084. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1085. echo "<a href='adicionar.php?tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>";
  1086. echo '</div>';
  1087. }
  1088.  
  1089. ?>
  1090.  
  1091.  
  1092.  
  1093. <?php
  1094. $sql ="SELECT *, (op2) as total FROM classe_III";
  1095. $sql = $pdo->query($sql);
  1096. ?>
  1097. <div style="background-color:lime;text-align:center; height:40px; ">
  1098. <h4 style="line-height:40px;">CLII</h4>
  1099. </div>
  1100. <?php
  1101. if ($sql->rowCount()>0) {
  1102. echo '<table border="1" width="100%" class="table">';
  1103.  
  1104. echo '<tr>';
  1105. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1106. echo'<th style="text-align:center">'.'op2'.'</th>';
  1107. echo'<th style="text-align:center">'.'total'.'</th>';
  1108. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1109.  
  1110. echo '</tr>';
  1111. foreach($sql->fetchAll() as $classe_III){
  1112. echo '<tr>';
  1113. echo'<td style="text-align:center">'.$classe_III ['item'].'</td>';
  1114. echo'<td style="text-align:center">'.$classe_III ['op2'].'</td>';
  1115. echo'<td style="text-align:center">'.$classe_III ['total'].'</td>';
  1116. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1117. echo '</tr>';
  1118. }
  1119.  
  1120. echo "</table>";
  1121.  
  1122. }else{
  1123.  
  1124. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1125. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1126. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1127. echo "<a href='adicionar.php?tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>";
  1128. echo '</div>';
  1129. }
  1130.  
  1131. ?>
  1132.  
  1133.  
  1134. <?php
  1135. $sql ="SELECT *, (op2) as total FROM classe_va";
  1136. $sql = $pdo->query($sql);
  1137. ?>
  1138. <div style="background-color:lime;text-align:center; height:40px; ">
  1139. <h4 style="line-height:40px;">CLV-A</h4>
  1140. </div>
  1141. <?php
  1142. if ($sql->rowCount()>0) {
  1143. echo '<table border="1" width="100%" class="table">';
  1144.  
  1145. echo '<tr>';
  1146. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1147. echo'<th style="text-align:center">'.'op2'.'</th>';
  1148. echo'<th style="text-align:center">'.'total'.'</th>';
  1149. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1150.  
  1151. echo '</tr>';
  1152. foreach($sql->fetchAll() as $classe_va){
  1153. echo '<tr>';
  1154. echo'<td style="text-align:center">'.$classe_va ['item'].'</td>';
  1155. echo'<td style="text-align:center">'.$classe_va ['op2'].'</td>';
  1156. echo'<td style="text-align:center">'.$classe_va ['total'].'</td>';
  1157. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1158. echo '</tr>';
  1159. }
  1160.  
  1161. echo "</table>";
  1162.  
  1163. }else{
  1164.  
  1165. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1166. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1167. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1168. echo "<a href='adicionar.php?tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>";
  1169. echo '</div>';
  1170. }
  1171. ?>
  1172.  
  1173.  
  1174. <?php
  1175. $sql ="SELECT *, (op2) as total FROM classe_vm";
  1176. $sql = $pdo->query($sql);
  1177. ?>
  1178. <div style="background-color:lime;text-align:center; height:40px; ">
  1179. <h4 style="line-height:40px;">CLV-M</h4>
  1180. </div>
  1181. <?php
  1182. if ($sql->rowCount()>0) {
  1183. echo '<table border="1" width="100%" class="table">';
  1184.  
  1185. echo '<tr>';
  1186. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1187. echo'<th style="text-align:center">'.'op2'.'</th>';
  1188. echo'<th style="text-align:center">'.'total'.'</th>';
  1189. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1190. echo '</tr>';
  1191.  
  1192. foreach($sql->fetchAll() as $classe_vm){
  1193. echo '<tr>';
  1194. echo'<td style="text-align:center">'.$classe_vm ['item'].'</td>';
  1195. echo'<td style="text-align:center">'.$classe_vm ['op2'].'</td>';
  1196. echo'<td style="text-align:center">'.$classe_vm ['total'].'</td>';
  1197. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_vm' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1198. echo '</tr>';
  1199. }
  1200.  
  1201. echo "</table>";
  1202.  
  1203. }else{
  1204.  
  1205. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1206. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1207. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1208. echo "<a href='adicionar.php?tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>";
  1209. echo '</div>';
  1210. }
  1211.  
  1212. ?>
  1213.  
  1214. <?php
  1215. $sql ="SELECT *, (op2) as total FROM classe_vml";
  1216. $sql = $pdo->query($sql);
  1217. ?>
  1218. <div style="background-color:lime;text-align:center; height:40px; ">
  1219. <h4 style="line-height:40px;">CLV-ML</h4>
  1220. </div>
  1221. <?php
  1222. if ($sql->rowCount()>0) {
  1223. echo '<table border="1" width="100%" class="table">';
  1224.  
  1225. echo '<tr>';
  1226. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1227. echo'<th style="text-align:center">'.'op2'.'</th>';
  1228. echo'<th style="text-align:center">'.'total'.'</th>';
  1229. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1230. echo '</tr>';
  1231.  
  1232. foreach($sql->fetchAll() as $classe_vml){
  1233. echo '<tr>';
  1234. echo'<td style="text-align:center">'.$classe_vml ['item'].'</td>';
  1235. echo'<td style="text-align:center">'.$classe_vml ['op2'].'</td>';
  1236. echo'<td style="text-align:center">'.$classe_vml ['total'].'</td>';
  1237. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1238. echo '</tr>';
  1239.  
  1240. }
  1241.  
  1242. echo "</table>";
  1243.  
  1244. }else{
  1245.  
  1246. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1247. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1248. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1249. echo "<a href='adicionar.php?tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>";
  1250. echo '</div>';
  1251. }
  1252.  
  1253.  
  1254.  
  1255.  
  1256. ?>
  1257. </table>
  1258.  
  1259. <?php
  1260. $sql ="SELECT *, (op2) as total FROM classe_vi";
  1261. $sql = $pdo->query($sql);
  1262. ?>
  1263. <div style="background-color:lime;text-align:center; height:40px; ">
  1264. <h4 style="line-height:40px;">CLVI</h4>
  1265. </div>
  1266. <?php
  1267. if ($sql->rowCount()>0) {
  1268. echo '<table border="1" width="100%" class="table">';
  1269.  
  1270. echo '<tr>';
  1271. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1272. echo'<th style="text-align:center">'.'op2'.'</th>';
  1273. echo'<th style="text-align:center">'.'total'.'</th>';
  1274. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1275. echo '</tr>';
  1276.  
  1277. foreach($sql->fetchAll() as $classe_vi){
  1278. echo '<tr>';
  1279. echo'<td style="text-align:center">'.$classe_vi ['item'].'</td>';
  1280. echo'<td style="text-align:center">'.$classe_vi ['op2'].'</td>';
  1281. echo'<td style="text-align:center">'.$classe_vi ['total'].'</td>';
  1282. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vi['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vi['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1283. echo '</tr>';
  1284. }
  1285.  
  1286. echo "</table>";
  1287.  
  1288. }else{
  1289.  
  1290. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1291. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1292. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1293. echo "<a href='adicionar.php?tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>";
  1294. echo '</div>';
  1295. }
  1296.  
  1297.  
  1298. ?>
  1299. </table>
  1300.  
  1301. <?php
  1302. $sql ="SELECT *, (op2) as total FROM classe_vii";
  1303. $sql = $pdo->query($sql);
  1304. ?>
  1305. <div style="background-color:lime;text-align:center; height:40px; ">
  1306. <h4 style="line-height:40px;">CLVII</h4>
  1307. </div>
  1308. <?php
  1309. if ($sql->rowCount()>0) {
  1310. echo '<table border="1" width="100%" class="table">';
  1311.  
  1312. echo '<tr>';
  1313. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1314. echo'<th style="text-align:center">'.'op2'.'</th>';
  1315. echo'<th style="text-align:center">'.'total'.'</th>';
  1316. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1317. echo '</tr>';
  1318. foreach($sql->fetchAll() as $classe_vii){
  1319. echo '<tr>';
  1320. echo'<td style="text-align:center">'.$classe_vii ['item'].'</td>';
  1321. echo'<td style="text-align:center">'.$classe_vii ['op2'].'</td>';
  1322. echo'<td style="text-align:center">'.$classe_vii ['total'].'</td>';
  1323. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1324. echo '</tr>';
  1325.  
  1326. }
  1327.  
  1328. echo "</table>";
  1329.  
  1330. }else{
  1331.  
  1332. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1333. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1334. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1335. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  1336. echo '</div>';
  1337. }
  1338.  
  1339. ?>
  1340. </table>
  1341.  
  1342. <?php
  1343. $sql ="SELECT *, (op2) as total FROM classe_ix";
  1344. $sql = $pdo->query($sql);
  1345. ?>
  1346. <div style="background-color:lime;text-align:center; height:40px; ">
  1347. <h4 style="line-height:40px;">CL IX</h4>
  1348. </div>
  1349. <?php
  1350. if ($sql->rowCount()>0) {
  1351. echo '<table border="1" width="100%" class="table">';
  1352.  
  1353. echo '<tr>';
  1354. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1355. echo'<th style="text-align:center">'.'op2'.'</th>';
  1356. echo'<th style="text-align:center">'.'total'.'</th>';
  1357. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1358. echo '</tr>';
  1359.  
  1360. foreach($sql->fetchAll() as $classe_ix){
  1361. echo '<tr>';
  1362. echo'<td style="text-align:center">'.$classe_ix ['item'].'</td>';
  1363. echo'<td style="text-align:center">'.$classe_ix ['op2'].'</td>';
  1364. echo'<td style="text-align:center">'.$classe_ix ['total'].'</td>';
  1365. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ix['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1366. echo '</tr>';
  1367. }
  1368.  
  1369. echo "</table>";
  1370.  
  1371. }else{
  1372.  
  1373. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1374. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1375. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1376. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  1377. echo '</div>';
  1378. }
  1379. ?>
  1380. <?php
  1381.  
  1382.  
  1383.  
  1384. } elseif($_SESSION['logado'] == "op3@gmail.com"){
  1385.  
  1386. $sql ="SELECT *, (op3) as total FROM classei";
  1387. $sql = $pdo->query($sql);
  1388. ?>
  1389. <div style="background-color:lime;text-align:center; height:40px; ">
  1390. <h4 style="line-height:40px;">CLI</h4>
  1391. </div>
  1392. <?php
  1393.  
  1394. if ($sql->rowCount()>0) {
  1395. echo '<table border="1" width="100%" class="table">';
  1396.  
  1397.  
  1398. echo '<tr style="text-align:center">';
  1399. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1400. echo'<th style="text-align:center">'.'op3'.'</th>';
  1401. echo'<th style="text-align:center">'.'total'.'</th>';
  1402. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1403.  
  1404. echo '</tr>';
  1405.  
  1406. foreach($sql->fetchAll() as $classei){
  1407.  
  1408. echo '<tr>';
  1409. echo'<td style="text-align:center">'.$classei ['item'].'</td>';
  1410. echo'<td style="text-align:center">'.$classei ['op3'].'</td>';
  1411. echo'<td style="text-align:center">'.$classei ['total'].'</td>';
  1412. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir-item.php?id={$classei['id']}' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1413. echo '</tr>';
  1414. }
  1415.  
  1416. echo "</table>";
  1417.  
  1418. }else{
  1419.  
  1420. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1421. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1422. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1423. echo "<a href='adicionar.php?tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>";
  1424. echo '</div>';
  1425. }
  1426.  
  1427.  
  1428. ?>
  1429. </table>
  1430.  
  1431. <?php
  1432. $sql ="SELECT *, (op3) as total FROM classe_ii";
  1433. $sql = $pdo->query($sql);
  1434. //se >0 tem dado, senao nao tem. como vamos repetir a table, nao precisa escrecver 2x.
  1435. //basta ela estar fora do if, pos apenas o indice da tabela, sem dados dinamicos
  1436. //aqui pro titulo poderia ser uma div :D sem necessidade do table
  1437. ?>
  1438. <div style="background-color:lime;text-align:center; height:40px; ">
  1439. <h4 style="line-height:40px;">CLII</h4>
  1440. </div>
  1441. <?php
  1442. if ($sql->rowCount()>0) {
  1443.  
  1444. //agora so mostra a tabela se existir dado:
  1445.  
  1446. echo '<table border="1" width="100%" class="table" >';
  1447.  
  1448. echo '<tr>';
  1449. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1450. echo'<th style="text-align:center">'.'op3'.'</th>';
  1451. echo'<th style="text-align:center">'.'total'.'</th>';
  1452. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1453. echo '</tr >';
  1454.  
  1455. foreach($sql->fetchAll() as $classe_ii){
  1456. echo '<tr>';
  1457. echo'<td style="text-align:center">'.$classe_ii ['item'].'</td>';
  1458. echo'<td style="text-align:center">'.$classe_ii ['op3'].'</td>';
  1459. echo'<td style="text-align:center">'.$classe_ii ['total'].'</td>';
  1460. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1461. echo '</tr>';
  1462. }
  1463.  
  1464. echo "</table>";
  1465.  
  1466. }else{
  1467.  
  1468. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1469. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1470. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1471. echo "<a href='adicionar.php?tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>";
  1472. echo '</div>';
  1473. }
  1474.  
  1475. ?>
  1476.  
  1477.  
  1478.  
  1479. <?php
  1480. $sql ="SELECT *, (op3) as total FROM classe_III";
  1481. $sql = $pdo->query($sql);
  1482. ?>
  1483. <div style="background-color:lime;text-align:center; height:40px; ">
  1484. <h4 style="line-height:40px;">CLIII</h4>
  1485. </div>
  1486. <?php
  1487. if ($sql->rowCount()>0) {
  1488. echo '<table border="1" width="100%" class="table">';
  1489.  
  1490. echo '<tr>';
  1491. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1492. echo'<th style="text-align:center">'.'op3'.'</th>';
  1493. echo'<th style="text-align:center">'.'total'.'</th>';
  1494. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1495.  
  1496. echo '</tr>';
  1497. foreach($sql->fetchAll() as $classe_III){
  1498. echo '<tr>';
  1499. echo'<td style="text-align:center">'.$classe_III ['item'].'</td>';
  1500. echo'<td style="text-align:center">'.$classe_III ['op3'].'</td>';
  1501. echo'<td style="text-align:center">'.$classe_III ['total'].'</td>';
  1502. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1503. echo '</tr>';
  1504. }
  1505.  
  1506. echo "</table>";
  1507.  
  1508. }else{
  1509.  
  1510. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1511. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1512. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1513. echo "<a href='adicionar.php?tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>";
  1514. echo '</div>';
  1515. }
  1516.  
  1517. ?>
  1518.  
  1519.  
  1520. <?php
  1521. $sql ="SELECT *, (op3) as total FROM classe_va";
  1522. $sql = $pdo->query($sql);
  1523. ?>
  1524. <div style="background-color:lime;text-align:center; height:40px; ">
  1525. <h4 style="line-height:40px;">CLV-A</h4>
  1526. </div>
  1527. <?php
  1528. if ($sql->rowCount()>0) {
  1529. echo '<table border="1" width="100%" class="table">';
  1530.  
  1531. echo '<tr>';
  1532. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1533. echo'<th style="text-align:center">'.'op3'.'</th>';
  1534. echo'<th style="text-align:center">'.'total'.'</th>';
  1535. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1536.  
  1537. echo '</tr>';
  1538. foreach($sql->fetchAll() as $classe_va){
  1539. echo '<tr>';
  1540. echo'<td style="text-align:center">'.$classe_va ['item'].'</td>';
  1541. echo'<td style="text-align:center">'.$classe_va ['op3'].'</td>';
  1542. echo'<td style="text-align:center">'.$classe_va ['total'].'</td>';
  1543. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1544. echo '</tr>';
  1545. }
  1546.  
  1547. echo "</table>";
  1548.  
  1549. }else{
  1550.  
  1551. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1552. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1553. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1554. echo "<a href='adicionar.php?tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>";
  1555. echo '</div>';
  1556. }
  1557. ?>
  1558.  
  1559.  
  1560. <?php
  1561. $sql ="SELECT *, (op3) as total FROM classe_vm";
  1562. $sql = $pdo->query($sql);
  1563. ?>
  1564. <div style="background-color:lime;text-align:center; height:40px; ">
  1565. <h4 style="line-height:40px;">CLV-M</h4>
  1566. </div>
  1567. <?php
  1568. if ($sql->rowCount()>0) {
  1569. echo '<table border="1" width="100%" class="table">';
  1570.  
  1571. echo '<tr>';
  1572. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1573. echo'<th style="text-align:center">'.'op3'.'</th>';
  1574. echo'<th style="text-align:center">'.'total'.'</th>';
  1575. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1576. echo '</tr>';
  1577.  
  1578. foreach($sql->fetchAll() as $classe_vm){
  1579. echo '<tr>';
  1580. echo'<td style="text-align:center">'.$classe_vm ['item'].'</td>';
  1581. echo'<td style="text-align:center">'.$classe_vm ['op3'].'</td>';
  1582. echo'<td style="text-align:center">'.$classe_vm ['total'].'</td>';
  1583. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_vm' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1584. echo '</tr>';
  1585. }
  1586.  
  1587. echo "</table>";
  1588.  
  1589. }else{
  1590.  
  1591. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1592. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1593. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1594. echo "<a href='adicionar.php?tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>";
  1595. echo '</div>';
  1596. }
  1597.  
  1598. ?>
  1599.  
  1600. <?php
  1601. $sql ="SELECT *, (op3) as total FROM classe_vml";
  1602. $sql = $pdo->query($sql);
  1603. ?>
  1604. <div style="background-color:lime;text-align:center; height:40px; ">
  1605. <h4 style="line-height:40px;">CLV-ML</h4>
  1606. </div>
  1607. <?php
  1608. if ($sql->rowCount()>0) {
  1609. echo '<table border="1" width="100%" class="table">';
  1610.  
  1611. echo '<tr>';
  1612. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1613. echo'<th style="text-align:center">'.'op3'.'</th>';
  1614. echo'<th style="text-align:center">'.'total'.'</th>';
  1615. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1616. echo '</tr>';
  1617.  
  1618. foreach($sql->fetchAll() as $classe_vml){
  1619. echo '<tr>';
  1620. echo'<td style="text-align:center">'.$classe_vml ['item'].'</td>';
  1621. echo'<td style="text-align:center">'.$classe_vml ['op3'].'</td>';
  1622. echo'<td style="text-align:center">'.$classe_vml ['total'].'</td>';
  1623. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1624. echo '</tr>';
  1625.  
  1626. }
  1627.  
  1628. echo "</table>";
  1629.  
  1630. }else{
  1631.  
  1632. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1633. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1634. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1635. echo "<a href='adicionar.php?tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>";
  1636. echo '</div>';
  1637. }
  1638.  
  1639.  
  1640.  
  1641.  
  1642. ?>
  1643. </table>
  1644.  
  1645. <?php
  1646. $sql ="SELECT *, (op3) as total FROM classe_vi";
  1647. $sql = $pdo->query($sql);
  1648. ?>
  1649. <div style="background-color:lime;text-align:center; height:40px; ">
  1650. <h4 style="line-height:40px;">CLVI</h4>
  1651. </div>
  1652. <?php
  1653. if ($sql->rowCount()>0) {
  1654. echo '<table border="1" width="100%" class="table">';
  1655.  
  1656. echo '<tr>';
  1657. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1658. echo'<th style="text-align:center">'.'op3'.'</th>';
  1659. echo'<th style="text-align:center">'.'total'.'</th>';
  1660. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1661. echo '</tr>';
  1662.  
  1663. foreach($sql->fetchAll() as $classe_vi){
  1664. echo '<tr>';
  1665. echo'<td style="text-align:center">'.$classe_vi ['item'].'</td>';
  1666. echo'<td style="text-align:center">'.$classe_vi ['op3'].'</td>';
  1667. echo'<td style="text-align:center">'.$classe_vi ['total'].'</td>';
  1668. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vi['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vi['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1669. echo '</tr>';
  1670. }
  1671.  
  1672. echo "</table>";
  1673.  
  1674. }else{
  1675.  
  1676. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1677. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1678. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1679. echo "<a href='adicionar.php?tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>";
  1680. echo '</div>';
  1681. }
  1682.  
  1683.  
  1684. ?>
  1685. </table>
  1686.  
  1687. <?php
  1688. $sql ="SELECT *, (op3) as total FROM classe_vii";
  1689. $sql = $pdo->query($sql);
  1690. ?>
  1691. <div style="background-color:lime;text-align:center; height:40px; ">
  1692. <h4 style="line-height:40px;">CLVII</h4>
  1693. </div>
  1694. <?php
  1695. if ($sql->rowCount()>0) {
  1696. echo '<table border="1" width="100%" class="table">';
  1697.  
  1698. echo '<tr>';
  1699. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1700. echo'<th style="text-align:center">'.'op3'.'</th>';
  1701. echo'<th style="text-align:center">'.'total'.'</th>';
  1702. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1703. echo '</tr>';
  1704. foreach($sql->fetchAll() as $classe_vii){
  1705. echo '<tr>';
  1706. echo'<td style="text-align:center">'.$classe_vii ['item'].'</td>';
  1707. echo'<td style="text-align:center">'.$classe_vii ['op3'].'</td>';
  1708. echo'<td style="text-align:center">'.$classe_vii ['total'].'</td>';
  1709. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1710. echo '</tr>';
  1711.  
  1712. }
  1713.  
  1714. echo "</table>";
  1715.  
  1716. }else{
  1717.  
  1718. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1719. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1720. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1721. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  1722. echo '</div>';
  1723. }
  1724.  
  1725. ?>
  1726. </table>
  1727.  
  1728. <?php
  1729. $sql ="SELECT *, (op3) as total FROM classe_ix";
  1730. $sql = $pdo->query($sql);
  1731. ?>
  1732. <div style="background-color:lime;text-align:center; height:40px; ">
  1733. <h4 style="line-height:40px;">CL IX</h4>
  1734. </div>
  1735. <?php
  1736. if ($sql->rowCount()>0) {
  1737. echo '<table border="1" width="100%" class="table">';
  1738.  
  1739. echo '<tr>';
  1740. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1741. echo'<th style="text-align:center">'.'op3'.'</th>';
  1742. echo'<th style="text-align:center">'.'total'.'</th>';
  1743. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1744. echo '</tr>';
  1745.  
  1746. foreach($sql->fetchAll() as $classe_ix){
  1747. echo '<tr>';
  1748. echo'<td style="text-align:center">'.$classe_ix ['item'].'</td>';
  1749. echo'<td style="text-align:center">'.$classe_ix ['op3'].'</td>';
  1750. echo'<td style="text-align:center">'.$classe_ix ['total'].'</td>';
  1751. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ix['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  1752. echo '</tr>';
  1753. }
  1754.  
  1755. echo "</table>";
  1756.  
  1757. }else{
  1758.  
  1759. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1760. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1761. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1762. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  1763. echo '</div>';
  1764. }
  1765.  
  1766.  
  1767. } elseif($_SESSION['logado'] == "op4@gmail.com"){
  1768.  
  1769. $sql ="SELECT *, (op4) as total FROM classei";
  1770. $sql = $pdo->query($sql);
  1771. ?>
  1772. <div style="background-color:lime;text-align:center; height:40px; ">
  1773. <h4 style="line-height:40px;">CLI</h4>
  1774. </div>
  1775. <?php
  1776.  
  1777. if ($sql->rowCount()>0) {
  1778. echo '<table border="1" width="100%" class="table">';
  1779.  
  1780.  
  1781. echo '<tr style="text-align:center">';
  1782. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1783. echo'<th style="text-align:center">'.'op4'.'</th>';
  1784. echo'<th style="text-align:center">'.'total'.'</th>';
  1785. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1786.  
  1787. echo '</tr>';
  1788.  
  1789. foreach($sql->fetchAll() as $classei){
  1790.  
  1791. echo '<tr>';
  1792. echo'<td style="text-align:center">'.$classei ['item'].'</td>';
  1793. echo'<td style="text-align:center">'.$classei ['op4'].'</td>';
  1794. echo'<td style="text-align:center">'.$classei ['total'].'</td>';
  1795. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classei['id']}' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1796. echo '</tr>';
  1797. }
  1798.  
  1799. echo "</table>";
  1800.  
  1801. }else{
  1802.  
  1803. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1804. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1805. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1806. echo "<a href='adicionar.php?tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>";
  1807. echo '</div>';
  1808. }
  1809.  
  1810.  
  1811. ?>
  1812. </table>
  1813.  
  1814. <?php
  1815. $sql ="SELECT *, (op4) as total FROM classe_ii";
  1816. $sql = $pdo->query($sql);
  1817. //se >0 tem dado, senao nao tem. como vamos repetir a table, nao precisa escrecver 2x.
  1818. //basta ela estar fora do if, pos apenas o indice da tabela, sem dados dinamicos
  1819. //aqui pro titulo poderia ser uma div :D sem necessidade do table
  1820. ?>
  1821. <div style="background-color:lime;text-align:center; height:40px; ">
  1822. <h4 style="line-height:40px;">CLII</h4>
  1823. </div>
  1824. <?php
  1825. if ($sql->rowCount()>0) {
  1826.  
  1827. //agora so mostra a tabela se existir dado:
  1828.  
  1829. echo '<table border="1" width="100%" class="table" >';
  1830.  
  1831. echo '<tr>';
  1832. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1833. echo'<th style="text-align:center">'.'op4'.'</th>';
  1834. echo'<th style="text-align:center">'.'total'.'</th>';
  1835. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1836. echo '</tr >';
  1837.  
  1838. foreach($sql->fetchAll() as $classe_ii){
  1839. echo '<tr>';
  1840. echo'<td style="text-align:center">'.$classe_ii ['item'].'</td>';
  1841. echo'<td style="text-align:center">'.$classe_ii ['op4'].'</td>';
  1842. echo'<td style="text-align:center">'.$classe_ii ['total'].'</td>';
  1843. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1844. echo '</tr>';
  1845. }
  1846.  
  1847. echo "</table>";
  1848.  
  1849. }else{
  1850.  
  1851. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1852. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1853. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1854. echo "<a href='adicionar.php?tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>";
  1855. echo '</div>';
  1856. }
  1857.  
  1858. ?>
  1859.  
  1860.  
  1861.  
  1862. <?php
  1863. $sql ="SELECT *, (op4) as total FROM classe_III";
  1864. $sql = $pdo->query($sql);
  1865. ?>
  1866. <div style="background-color:lime;text-align:center; height:40px; ">
  1867. <h4 style="line-height:40px;">CLIII</h4>
  1868. </div>
  1869. <?php
  1870. if ($sql->rowCount()>0) {
  1871. echo '<table border="1" width="100%" class="table">';
  1872.  
  1873. echo '<tr>';
  1874. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1875. echo'<th style="text-align:center">'.'op4'.'</th>';
  1876. echo'<th style="text-align:center">'.'total'.'</th>';
  1877. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1878.  
  1879. echo '</tr>';
  1880. foreach($sql->fetchAll() as $classe_III){
  1881. echo '<tr>';
  1882. echo'<td style="text-align:center">'.$classe_III ['item'].'</td>';
  1883. echo'<td style="text-align:center">'.$classe_III ['op4'].'</td>';
  1884. echo'<td style="text-align:center">'.$classe_III ['total'].'</td>';
  1885. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick=' return myfunction()'href='excluir.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1886. echo '</tr>';
  1887. }
  1888.  
  1889. echo "</table>";
  1890.  
  1891. }else{
  1892.  
  1893. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1894. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1895. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1896. echo "<a href='adicionar.php?tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>";
  1897. echo '</div>';
  1898. }
  1899.  
  1900. ?>
  1901.  
  1902.  
  1903. <?php
  1904. $sql ="SELECT *, (op4) as total FROM classe_va";
  1905. $sql = $pdo->query($sql);
  1906. ?>
  1907. <div style="background-color:lime;text-align:center; height:40px; ">
  1908. <h4 style="line-height:40px;">CLV-A</h4>
  1909. </div>
  1910. <?php
  1911. if ($sql->rowCount()>0) {
  1912. echo '<table border="1" width="100%" class="table">';
  1913.  
  1914. echo '<tr>';
  1915. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1916. echo'<th style="text-align:center">'.'op4'.'</th>';
  1917. echo'<th style="text-align:center">'.'total'.'</th>';
  1918. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1919.  
  1920. echo '</tr>';
  1921. foreach($sql->fetchAll() as $classe_va){
  1922. echo '<tr>';
  1923. echo'<td style="text-align:center">'.$classe_va ['item'].'</td>';
  1924. echo'<td style="text-align:center">'.$classe_va ['op4'].'</td>';
  1925. echo'<td style="text-align:center">'.$classe_va ['total'].'</td>';
  1926. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1927. echo '</tr>';
  1928. }
  1929.  
  1930. echo "</table>";
  1931.  
  1932. }else{
  1933.  
  1934. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1935. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1936. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1937. echo "<a href='adicionar.php?tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>";
  1938. echo '</div>';
  1939. }
  1940. ?>
  1941.  
  1942.  
  1943. <?php
  1944. $sql ="SELECT *, (op4) as total FROM classe_vm";
  1945. $sql = $pdo->query($sql);
  1946. ?>
  1947. <div style="background-color:lime;text-align:center; height:40px; ">
  1948. <h4 style="line-height:40px;">CLV-M</h4>
  1949. </div>
  1950. <?php
  1951. if ($sql->rowCount()>0) {
  1952. echo '<table border="1" width="100%" class="table">';
  1953.  
  1954. echo '<tr>';
  1955. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1956. echo'<th style="text-align:center">'.'op4'.'</th>';
  1957. echo'<th style="text-align:center">'.'total'.'</th>';
  1958. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1959. echo '</tr>';
  1960.  
  1961. foreach($sql->fetchAll() as $classe_vm){
  1962. echo '<tr>';
  1963. echo'<td style="text-align:center">'.$classe_vm ['item'].'</td>';
  1964. echo'<td style="text-align:center">'.$classe_vm ['op4'].'</td>';
  1965. echo'<td style="text-align:center">'.$classe_vm ['total'].'</td>';
  1966. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_vm' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  1967. echo '</tr>';
  1968. }
  1969.  
  1970. echo "</table>";
  1971.  
  1972. }else{
  1973.  
  1974. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  1975. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  1976. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  1977. echo "<a href='adicionar.php?tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>";
  1978. echo '</div>';
  1979. }
  1980.  
  1981. ?>
  1982.  
  1983. <?php
  1984. $sql ="SELECT *, (op4) as total FROM classe_vml";
  1985. $sql = $pdo->query($sql);
  1986. ?>
  1987. <div style="background-color:lime;text-align:center; height:40px; ">
  1988. <h4 style="line-height:40px;">CLV-ML</h4>
  1989. </div>
  1990. <?php
  1991. if ($sql->rowCount()>0) {
  1992. echo '<table border="1" width="100%" class="table">';
  1993.  
  1994. echo '<tr>';
  1995. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  1996. echo'<th style="text-align:center">'.'op4'.'</th>';
  1997. echo'<th style="text-align:center">'.'total'.'</th>';
  1998. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  1999. echo '</tr>';
  2000.  
  2001. foreach($sql->fetchAll() as $classe_vml){
  2002. echo '<tr>';
  2003. echo'<td style="text-align:center">'.$classe_vml ['item'].'</td>';
  2004. echo'<td style="text-align:center">'.$classe_vml ['op4'].'</td>';
  2005. echo'<td style="text-align:center">'.$classe_vml ['total'].'</td>';
  2006. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2007. echo '</tr>';
  2008.  
  2009. }
  2010.  
  2011. echo "</table>";
  2012.  
  2013. }else{
  2014.  
  2015. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2016. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2017. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2018. echo "<a href='adicionar.php?tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>";
  2019. echo '</div>';
  2020. }
  2021.  
  2022.  
  2023.  
  2024.  
  2025. ?>
  2026. </table>
  2027.  
  2028. <?php
  2029. $sql ="SELECT *, (op4) as total FROM classe_vi";
  2030. $sql = $pdo->query($sql);
  2031. ?>
  2032. <div style="background-color:lime;text-align:center; height:40px; ">
  2033. <h4 style="line-height:40px;">CLVI</h4>
  2034. </div>
  2035. <?php
  2036. if ($sql->rowCount()>0) {
  2037. echo '<table border="1" width="100%" class="table">';
  2038.  
  2039. echo '<tr>';
  2040. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2041. echo'<th style="text-align:center">'.'op4'.'</th>';
  2042. echo'<th style="text-align:center">'.'total'.'</th>';
  2043. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2044. echo '</tr>';
  2045.  
  2046. foreach($sql->fetchAll() as $classe_vi){
  2047. echo '<tr>';
  2048. echo'<td style="text-align:center">'.$classe_vi ['item'].'</td>';
  2049. echo'<td style="text-align:center">'.$classe_vi ['op4'].'</td>';
  2050. echo'<td style="text-align:center">'.$classe_vi ['total'].'</td>';
  2051. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vi['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vi['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2052. echo '</tr>';
  2053. }
  2054.  
  2055. echo "</table>";
  2056.  
  2057. }else{
  2058.  
  2059. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2060. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2061. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2062. echo "<a href='adicionar.php?tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>";
  2063. echo '</div>';
  2064. }
  2065.  
  2066.  
  2067. ?>
  2068. </table>
  2069.  
  2070. <?php
  2071. $sql ="SELECT *, (op4) as total FROM classe_vii";
  2072. $sql = $pdo->query($sql);
  2073. ?>
  2074. <div style="background-color:lime;text-align:center; height:40px; ">
  2075. <h4 style="line-height:40px;">CLVII</h4>
  2076. </div>
  2077. <?php
  2078. if ($sql->rowCount()>0) {
  2079. echo '<table border="1" width="100%" class="table">';
  2080.  
  2081. echo '<tr>';
  2082. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2083. echo'<th style="text-align:center">'.'op4'.'</th>';
  2084. echo'<th style="text-align:center">'.'total'.'</th>';
  2085. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2086. echo '</tr>';
  2087. foreach($sql->fetchAll() as $classe_vii){
  2088. echo '<tr>';
  2089. echo'<td style="text-align:center">'.$classe_vii ['item'].'</td>';
  2090. echo'<td style="text-align:center">'.$classe_vii ['op4'].'</td>';
  2091. echo'<td style="text-align:center">'.$classe_vii ['total'].'</td>';
  2092. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2093. echo '</tr>';
  2094.  
  2095. }
  2096.  
  2097. echo "</table>";
  2098.  
  2099. }else{
  2100.  
  2101. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2102. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2103. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2104. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  2105. echo '</div>';
  2106. }
  2107.  
  2108. ?>
  2109. </table>
  2110.  
  2111. <?php
  2112. $sql ="SELECT *, (op4) as total FROM classe_ix";
  2113. $sql = $pdo->query($sql);
  2114. ?>
  2115. <div style="background-color:lime;text-align:center; height:40px; ">
  2116. <h4 style="line-height:40px;">CL IX</h4>
  2117. </div>
  2118. <?php
  2119. if ($sql->rowCount()>0) {
  2120. echo '<table border="1" width="100%" class="table">';
  2121.  
  2122. echo '<tr>';
  2123. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2124. echo'<th style="text-align:center">'.'op4'.'</th>';
  2125. echo'<th style="text-align:center">'.'total'.'</th>';
  2126. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2127. echo '</tr>';
  2128.  
  2129. foreach($sql->fetchAll() as $classe_ix){
  2130. echo '<tr>';
  2131. echo'<td style="text-align:center">'.$classe_ix ['item'].'</td>';
  2132. echo'<td style="text-align:center">'.$classe_ix ['op4'].'</td>';
  2133. echo'<td style="text-align:center">'.$classe_ix ['total'].'</td>';
  2134. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ix['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2135. echo '</tr>';
  2136. }
  2137.  
  2138. echo "</table>";
  2139.  
  2140. }else{
  2141.  
  2142. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2143. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2144. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2145. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  2146. echo '</div>';
  2147.  
  2148. }
  2149. } elseif($_SESSION['logado'] == "op5@gmail.com"){
  2150.  
  2151. $sql ="SELECT *, (op5) as total FROM classei";
  2152. $sql = $pdo->query($sql);
  2153. ?>
  2154. <div style="background-color:lime;text-align:center; height:40px; ">
  2155. <h4 style="line-height:40px;">CLI</h4>
  2156. </div>
  2157. <?php
  2158.  
  2159. if ($sql->rowCount()>0) {
  2160. echo '<table border="1" width="100%" class="table">';
  2161.  
  2162.  
  2163. echo '<tr style="text-align:center">';
  2164. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2165. echo'<th style="text-align:center">'.'op5'.'</th>';
  2166. echo'<th style="text-align:center">'.'total'.'</th>';
  2167. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2168.  
  2169. echo '</tr>';
  2170.  
  2171. foreach($sql->fetchAll() as $classei){
  2172.  
  2173. echo '<tr>';
  2174. echo'<td style="text-align:center">'.$classei ['item'].'</td>';
  2175. echo'<td style="text-align:center">'.$classei ['op5'].'</td>';
  2176. echo'<td style="text-align:center">'.$classei ['total'].'</td>';
  2177. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classei['id']}' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2178. echo '</tr>';
  2179. }
  2180.  
  2181. echo "</table>";
  2182.  
  2183. }else{
  2184.  
  2185. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2186. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2187. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2188. echo "<a href='adicionar.php?tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>";
  2189. echo '</div>';
  2190. }
  2191.  
  2192.  
  2193. ?>
  2194. </table>
  2195.  
  2196. <?php
  2197. $sql ="SELECT *, (op5) as total FROM classe_ii";
  2198. $sql = $pdo->query($sql);
  2199. //se >0 tem dado, senao nao tem. como vamos repetir a table, nao precisa escrecver 2x.
  2200. //basta ela estar fora do if, pos apenas o indice da tabela, sem dados dinamicos
  2201. //aqui pro titulo poderia ser uma div :D sem necessidade do table
  2202. ?>
  2203. <div style="background-color:lime;text-align:center; height:40px; ">
  2204. <h4 style="line-height:40px;">CLII</h4>
  2205. </div>
  2206. <?php
  2207. if ($sql->rowCount()>0) {
  2208.  
  2209. //agora so mostra a tabela se existir dado:
  2210.  
  2211. echo '<table border="1" width="100%" class="table" >';
  2212.  
  2213. echo '<tr>';
  2214. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2215. echo'<th style="text-align:center">'.'op5'.'</th>';
  2216. echo'<th style="text-align:center">'.'total'.'</th>';
  2217. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2218. echo '</tr >';
  2219.  
  2220. foreach($sql->fetchAll() as $classe_ii){
  2221. echo '<tr>';
  2222. echo'<td style="text-align:center">'.$classe_ii ['item'].'</td>';
  2223. echo'<td style="text-align:center">'.$classe_ii ['op5'].'</td>';
  2224. echo'<td style="text-align:center">'.$classe_ii ['total'].'</td>';
  2225. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2226. echo '</tr>';
  2227. }
  2228.  
  2229. echo "</table>";
  2230.  
  2231. }else{
  2232.  
  2233. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2234. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2235. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2236. echo "<a href='adicionar.php?tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>";
  2237. echo '</div>';
  2238. }
  2239.  
  2240. ?>
  2241.  
  2242.  
  2243.  
  2244. <?php
  2245. $sql ="SELECT *, (op5) as total FROM classe_III";
  2246. $sql = $pdo->query($sql);
  2247. ?>
  2248. <div style="background-color:lime;text-align:center; height:40px; ">
  2249. <h4 style="line-height:40px;">CLIII</h4>
  2250. </div>
  2251. <?php
  2252. if ($sql->rowCount()>0) {
  2253. echo '<table border="1" width="100%" class="table">';
  2254.  
  2255. echo '<tr>';
  2256. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2257. echo'<th style="text-align:center">'.'op5'.'</th>';
  2258. echo'<th style="text-align:center">'.'total'.'</th>';
  2259. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2260.  
  2261. echo '</tr>';
  2262. foreach($sql->fetchAll() as $classe_III){
  2263. echo '<tr>';
  2264. echo'<td style="text-align:center">'.$classe_III ['item'].'</td>';
  2265. echo'<td style="text-align:center">'.$classe_III ['op5'].'</td>';
  2266. echo'<td style="text-align:center">'.$classe_III ['total'].'</td>';
  2267. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick=' return myfunction()'href='excluir.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2268. echo '</tr>';
  2269. }
  2270.  
  2271. echo "</table>";
  2272.  
  2273. }else{
  2274.  
  2275. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2276. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2277. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2278. echo "<a href='adicionar.php?tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>";
  2279. echo '</div>';
  2280. }
  2281.  
  2282. ?>
  2283.  
  2284.  
  2285. <?php
  2286. $sql ="SELECT *, (op5) as total FROM classe_va";
  2287. $sql = $pdo->query($sql);
  2288. ?>
  2289. <div style="background-color:lime;text-align:center; height:40px; ">
  2290. <h4 style="line-height:40px;">CLV-A</h4>
  2291. </div>
  2292. <?php
  2293. if ($sql->rowCount()>0) {
  2294. echo '<table border="1" width="100%" class="table">';
  2295.  
  2296. echo '<tr>';
  2297. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2298. echo'<th style="text-align:center">'.'op5'.'</th>';
  2299. echo'<th style="text-align:center">'.'total'.'</th>';
  2300. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2301.  
  2302. echo '</tr>';
  2303. foreach($sql->fetchAll() as $classe_va){
  2304. echo '<tr>';
  2305. echo'<td style="text-align:center">'.$classe_va ['item'].'</td>';
  2306. echo'<td style="text-align:center">'.$classe_va ['op5'].'</td>';
  2307. echo'<td style="text-align:center">'.$classe_va ['total'].'</td>';
  2308. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2309. echo '</tr>';
  2310. }
  2311.  
  2312. echo "</table>";
  2313.  
  2314. }else{
  2315.  
  2316. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2317. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2318. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2319. echo "<a href='adicionar.php?tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>";
  2320. echo '</div>';
  2321. }
  2322. ?>
  2323.  
  2324.  
  2325. <?php
  2326. $sql ="SELECT *, (op5) as total FROM classe_vm";
  2327. $sql = $pdo->query($sql);
  2328. ?>
  2329. <div style="background-color:lime;text-align:center; height:40px; ">
  2330. <h4 style="line-height:40px;">CLV-M</h4>
  2331. </div>
  2332. <?php
  2333. if ($sql->rowCount()>0) {
  2334. echo '<table border="1" width="100%" class="table">';
  2335.  
  2336. echo '<tr>';
  2337. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2338. echo'<th style="text-align:center">'.'op5'.'</th>';
  2339. echo'<th style="text-align:center">'.'total'.'</th>';
  2340. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2341. echo '</tr>';
  2342.  
  2343. foreach($sql->fetchAll() as $classe_vm){
  2344. echo '<tr>';
  2345. echo'<td style="text-align:center">'.$classe_vm ['item'].'</td>';
  2346. echo'<td style="text-align:center">'.$classe_vm ['op5'].'</td>';
  2347. echo'<td style="text-align:center">'.$classe_vm ['total'].'</td>';
  2348. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_vm' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2349. echo '</tr>';
  2350. }
  2351.  
  2352. echo "</table>";
  2353.  
  2354. }else{
  2355.  
  2356. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2357. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2358. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2359. echo "<a href='adicionar.php?tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>";
  2360. echo '</div>';
  2361. }
  2362.  
  2363. ?>
  2364.  
  2365. <?php
  2366. $sql ="SELECT *, (op5) as total FROM classe_vml";
  2367. $sql = $pdo->query($sql);
  2368. ?>
  2369. <div style="background-color:lime;text-align:center; height:40px; ">
  2370. <h4 style="line-height:40px;">CLV-ML</h4>
  2371. </div>
  2372. <?php
  2373. if ($sql->rowCount()>0) {
  2374. echo '<table border="1" width="100%" class="table">';
  2375.  
  2376. echo '<tr>';
  2377. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2378. echo'<th style="text-align:center">'.'op5'.'</th>';
  2379. echo'<th style="text-align:center">'.'total'.'</th>';
  2380. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2381. echo '</tr>';
  2382.  
  2383. foreach($sql->fetchAll() as $classe_vml){
  2384. echo '<tr>';
  2385. echo'<td style="text-align:center">'.$classe_vml ['item'].'</td>';
  2386. echo'<td style="text-align:center">'.$classe_vml ['op5'].'</td>';
  2387. echo'<td style="text-align:center">'.$classe_vml ['total'].'</td>';
  2388. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_vm' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2389. echo '</tr>';
  2390.  
  2391. }
  2392.  
  2393. echo "</table>";
  2394.  
  2395. }else{
  2396.  
  2397. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2398. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2399. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2400. echo "<a href='adicionar.php?tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>";
  2401. echo '</div>';
  2402. }
  2403.  
  2404.  
  2405. ?>
  2406. </table>
  2407.  
  2408. <?php
  2409. $sql ="SELECT *, (op5) as total FROM classe_vi";
  2410. $sql = $pdo->query($sql);
  2411. ?>
  2412. <div style="background-color:lime;text-align:center; height:40px; ">
  2413. <h4 style="line-height:40px;">CLVI</h4>
  2414. </div>
  2415. <?php
  2416. if ($sql->rowCount()>0) {
  2417. echo '<table border="1" width="100%" class="table">';
  2418.  
  2419. echo '<tr>';
  2420. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2421. echo'<th style="text-align:center">'.'op5'.'</th>';
  2422. echo'<th style="text-align:center">'.'total'.'</th>';
  2423. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2424. echo '</tr>';
  2425.  
  2426. foreach($sql->fetchAll() as $classe_vi){
  2427. echo '<tr>';
  2428. echo'<td style="text-align:center">'.$classe_vi ['item'].'</td>';
  2429. echo'<td style="text-align:center">'.$classe_vi ['op5'].'</td>';
  2430. echo'<td style="text-align:center">'.$classe_vi ['total'].'</td>';
  2431. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vi['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2432. echo '</tr>';
  2433. }
  2434.  
  2435. echo "</table>";
  2436.  
  2437. }else{
  2438.  
  2439. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2440. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2441. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2442. echo "<a href='adicionar.php?tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>";
  2443. echo '</div>';
  2444. }
  2445.  
  2446.  
  2447. ?>
  2448. </table>
  2449.  
  2450. <?php
  2451. $sql ="SELECT *, (op5) as total FROM classe_vii";
  2452. $sql = $pdo->query($sql);
  2453. ?>
  2454. <div style="background-color:lime;text-align:center; height:40px; ">
  2455. <h4 style="line-height:40px;">CLVII</h4>
  2456. </div>
  2457. <?php
  2458. if ($sql->rowCount()>0) {
  2459. echo '<table border="1" width="100%" class="table">';
  2460.  
  2461. echo '<tr>';
  2462. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2463. echo'<th style="text-align:center">'.'op5'.'</th>';
  2464. echo'<th style="text-align:center">'.'total'.'</th>';
  2465. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2466. echo '</tr>';
  2467. foreach($sql->fetchAll() as $classe_vii){
  2468. echo '<tr>';
  2469. echo'<td style="text-align:center">'.$classe_vii ['item'].'</td>';
  2470. echo'<td style="text-align:center">'.$classe_vii ['op5'].'</td>';
  2471. echo'<td style="text-align:center">'.$classe_vii ['total'].'</td>';
  2472. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2473. echo '</tr>';
  2474.  
  2475. }
  2476.  
  2477. echo "</table>";
  2478.  
  2479. }else{
  2480.  
  2481. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2482. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2483. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2484. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  2485. echo '</div>';
  2486. }
  2487.  
  2488. ?>
  2489. </table>
  2490.  
  2491. <?php
  2492. $sql ="SELECT *, (op5) as total FROM classe_ix";
  2493. $sql = $pdo->query($sql);
  2494. ?>
  2495. <div style="background-color:lime;text-align:center; height:40px; ">
  2496. <h4 style="line-height:40px;">CL IX</h4>
  2497. </div>
  2498. <?php
  2499. if ($sql->rowCount()>0) {
  2500. echo '<table border="1" width="100%" class="table">';
  2501.  
  2502. echo '<tr>';
  2503. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2504. echo'<th style="text-align:center">'.'op5'.'</th>';
  2505. echo'<th style="text-align:center">'.'total'.'</th>';
  2506. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2507. echo '</tr>';
  2508.  
  2509. foreach($sql->fetchAll() as $classe_ix){
  2510. echo '<tr>';
  2511. echo'<td style="text-align:center">'.$classe_ix ['item'].'</td>';
  2512. echo'<td style="text-align:center">'.$classe_ix ['op5'].'</td>';
  2513. echo'<td style="text-align:center">'.$classe_ix ['total'].'</td>';
  2514. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ix['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2515. echo '</tr>';
  2516. }
  2517.  
  2518. echo "</table>";
  2519.  
  2520. }else{
  2521.  
  2522. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2523. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2524. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2525. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  2526. echo '</div>';
  2527. }
  2528. } elseif($_SESSION['logado'] == "op6@gmail.com"){
  2529.  
  2530. $sql ="SELECT *, (op6) as total FROM classei";
  2531. $sql = $pdo->query($sql);
  2532. ?>
  2533. <div style="background-color:lime;text-align:center; height:40px; ">
  2534. <h4 style="line-height:40px;">CLI</h4>
  2535. </div>
  2536. <?php
  2537.  
  2538. if ($sql->rowCount()>0) {
  2539. echo '<table border="1" width="100%" class="table">';
  2540.  
  2541.  
  2542. echo '<tr style="text-align:center">';
  2543. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2544. echo'<th style="text-align:center">'.'op6'.'</th>';
  2545. echo'<th style="text-align:center">'.'total'.'</th>';
  2546. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2547.  
  2548. echo '</tr>';
  2549.  
  2550. foreach($sql->fetchAll() as $classei){
  2551.  
  2552. echo '<tr>';
  2553. echo'<td style="text-align:center">'.$classei['item'].'</td>';
  2554. echo'<td style="text-align:center">'.$classei['op6'].'</td>';
  2555. echo'<td style="text-align:center">'.$classei['total'].'</td>';
  2556. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classei['id']}' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2557. echo '</tr>';
  2558. }
  2559.  
  2560. echo "</table>";
  2561.  
  2562. }else{
  2563.  
  2564. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2565. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2566. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2567. echo "<a href='adicionar.php?tabela=classei' class='btn btn-primary btn-xs'>adicionar</a>";
  2568. echo '</div>';
  2569. }
  2570.  
  2571.  
  2572. ?>
  2573. </table>
  2574.  
  2575. <?php
  2576. $sql ="SELECT *, (op6) as total FROM classe_ii";
  2577. $sql = $pdo->query($sql);
  2578. //se >0 tem dado, senao nao tem. como vamos repetir a table, nao precisa escrecver 2x.
  2579. //basta ela estar fora do if, pos apenas o indice da tabela, sem dados dinamicos
  2580. //aqui pro titulo poderia ser uma div :D sem necessidade do table
  2581. ?>
  2582. <div style="background-color:lime;text-align:center; height:40px; ">
  2583. <h4 style="line-height:40px;">CLII</h4>
  2584. </div>
  2585. <?php
  2586. if ($sql->rowCount()>0) {
  2587.  
  2588. //agora so mostra a tabela se existir dado:
  2589.  
  2590. echo '<table border="1" width="100%" class="table" >';
  2591.  
  2592. echo '<tr>';
  2593. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2594. echo'<th style="text-align:center">'.'op6'.'</th>';
  2595. echo'<th style="text-align:center">'.'total'.'</th>';
  2596. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2597. echo '</tr >';
  2598.  
  2599. foreach($sql->fetchAll() as $classe_ii){
  2600. echo '<tr>';
  2601. echo'<td style="text-align:center">'.$classe_ii ['item'].'</td>';
  2602. echo'<td style="text-align:center">'.$classe_ii ['op6'].'</td>';
  2603. echo'<td style="text-align:center">'.$classe_ii ['total'].'</td>';
  2604. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_ii['id']}&tabela=classe_ii' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2605. echo '</tr>';
  2606. }
  2607.  
  2608. echo "</table>";
  2609.  
  2610. }else{
  2611.  
  2612. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2613. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2614. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2615. echo "<a href='adicionar.php?tabela=classe_ii' class='btn btn-primary btn-xs'>adicionar</a>";
  2616. echo '</div>';
  2617. }
  2618.  
  2619. ?>
  2620.  
  2621.  
  2622.  
  2623. <?php
  2624. $sql ="SELECT *, (op6) as total FROM classe_III";
  2625. $sql = $pdo->query($sql);
  2626. ?>
  2627. <div style="background-color:lime;text-align:center; height:40px; ">
  2628. <h4 style="line-height:40px;">CLIII</h4>
  2629. </div>
  2630. <?php
  2631. if ($sql->rowCount()>0) {
  2632. echo '<table border="1" width="100%" class="table">';
  2633.  
  2634. echo '<tr>';
  2635. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2636. echo'<th style="text-align:center">'.'op6'.'</th>';
  2637. echo'<th style="text-align:center">'.'total'.'</th>';
  2638. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2639.  
  2640. echo '</tr>';
  2641. foreach($sql->fetchAll() as $classe_III){
  2642. echo '<tr>';
  2643. echo'<td style="text-align:center">'.$classe_III ['item'].'</td>';
  2644. echo'<td style="text-align:center">'.$classe_III ['op6'].'</td>';
  2645. echo'<td style="text-align:center">'.$classe_III ['total'].'</td>';
  2646. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick=' return myfunction()'href='excluir.php?id={$classe_III['id']}&tabela=classe_III' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2647. echo '</tr>';
  2648. }
  2649.  
  2650. echo "</table>";
  2651.  
  2652. }else{
  2653.  
  2654. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2655. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2656. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2657. echo "<a href='adicionar.php?tabela=classe_III' class='btn btn-primary btn-xs'>adicionar</a>";
  2658. echo '</div>';
  2659. }
  2660.  
  2661. ?>
  2662.  
  2663.  
  2664. <?php
  2665. $sql ="SELECT *, (op6) as total FROM classe_va";
  2666. $sql = $pdo->query($sql);
  2667. ?>
  2668. <div style="background-color:lime;text-align:center; height:40px; ">
  2669. <h4 style="line-height:40px;">CLV-A</h4>
  2670. </div>
  2671. <?php
  2672. if ($sql->rowCount()>0) {
  2673. echo '<table border="1" width="100%" class="table">';
  2674.  
  2675. echo '<tr>';
  2676. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2677. echo'<th style="text-align:center">'.'op6'.'</th>';
  2678. echo'<th style="text-align:center">'.'total'.'</th>';
  2679. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2680.  
  2681. echo '</tr>';
  2682. foreach($sql->fetchAll() as $classe_va){
  2683. echo '<tr>';
  2684. echo'<td style="text-align:center">'.$classe_va ['item'].'</td>';
  2685. echo'<td style="text-align:center">'.$classe_va ['op6'].'</td>';
  2686. echo'<td style="text-align:center">'.$classe_va ['total'].'</td>';
  2687. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_va' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2688. echo '</tr>';
  2689. }
  2690.  
  2691. echo "</table>";
  2692.  
  2693. }else{
  2694.  
  2695. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2696. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2697. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2698. echo "<a href='adicionar.php?tabela=classe_va' class='btn btn-primary btn-xs'>adicionar</a>";
  2699. echo '</div>';
  2700. }
  2701. ?>
  2702.  
  2703.  
  2704. <?php
  2705. $sql ="SELECT *, (op6) as total FROM classe_vm";
  2706. $sql = $pdo->query($sql);
  2707. ?>
  2708. <div style="background-color:lime;text-align:center; height:40px; ">
  2709. <h4 style="line-height:40px;">CLV-M</h4>
  2710. </div>
  2711. <?php
  2712. if ($sql->rowCount()>0) {
  2713. echo '<table border="1" width="100%" class="table">';
  2714.  
  2715. echo '<tr>';
  2716. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2717. echo'<th style="text-align:center">'.'op6'.'</th>';
  2718. echo'<th style="text-align:center">'.'total'.'</th>';
  2719. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2720. echo '</tr>';
  2721.  
  2722. foreach($sql->fetchAll() as $classe_vm){
  2723. echo '<tr>';
  2724. echo'<td style="text-align:center">'.$classe_vm ['item'].'</td>';
  2725. echo'<td style="text-align:center">'.$classe_vm ['op6'].'</td>';
  2726. echo'<td style="text-align:center">'.$classe_vm ['total'].'</td>';
  2727. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vm['id']}&tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()'href='excluir.php?id={$classe_va['id']}&tabela=classe_vm' class='btn btn-sm btn-danger btn-xs' >excluir</a></td>";
  2728. echo '</tr>';
  2729. }
  2730.  
  2731. echo "</table>";
  2732.  
  2733. }else{
  2734.  
  2735. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2736. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2737. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2738. echo "<a href='adicionar.php?tabela=classe_vm' class='btn btn-primary btn-xs'>adicionar</a>";
  2739. echo '</div>';
  2740. }
  2741.  
  2742. ?>
  2743.  
  2744. <?php
  2745. $sql ="SELECT *, (op6) as total FROM classe_vml";
  2746. $sql = $pdo->query($sql);
  2747. ?>
  2748. <div style="background-color:lime;text-align:center; height:40px; ">
  2749. <h4 style="line-height:40px;">CLV-ML</h4>
  2750. </div>
  2751. <?php
  2752. if ($sql->rowCount()>0) {
  2753. echo '<table border="1" width="100%" class="table">';
  2754.  
  2755. echo '<tr>';
  2756. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2757. echo'<th style="text-align:center">'.'op6'.'</th>';
  2758. echo'<th style="text-align:center">'.'total'.'</th>';
  2759. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2760. echo '</tr>';
  2761.  
  2762. foreach($sql->fetchAll() as $classe_vml){
  2763. echo '<tr>';
  2764. echo'<td style="text-align:center">'.$classe_vml ['item'].'</td>';
  2765. echo'<td style="text-align:center">'.$classe_vml ['op6'].'</td>';
  2766. echo'<td style="text-align:center">'.$classe_vml ['total'].'</td>';
  2767. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vml['id']}&tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2768. echo '</tr>';
  2769.  
  2770. }
  2771.  
  2772. echo "</table>";
  2773.  
  2774. }else{
  2775.  
  2776. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2777. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2778. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2779. echo "<a href='adicionar.php?tabela=classe_vml' class='btn btn-primary btn-xs'>adicionar</a>";
  2780. echo '</div>';
  2781. }
  2782.  
  2783.  
  2784.  
  2785.  
  2786. ?>
  2787. </table>
  2788.  
  2789. <?php
  2790. $sql ="SELECT *, (op6) as total FROM classe_vi";
  2791. $sql = $pdo->query($sql);
  2792. ?>
  2793. <div style="background-color:lime;text-align:center; height:40px; ">
  2794. <h4 style="line-height:40px;">CLVI</h4>
  2795. </div>
  2796. <?php
  2797. if ($sql->rowCount()>0) {
  2798. echo '<table border="1" width="100%" class="table">';
  2799.  
  2800. echo '<tr>';
  2801. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2802. echo'<th style="text-align:center">'.'op6'.'</th>';
  2803. echo'<th style="text-align:center">'.'total'.'</th>';
  2804. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2805. echo '</tr>';
  2806.  
  2807. foreach($sql->fetchAll() as $classe_vi){
  2808. echo '<tr>';
  2809. echo'<td style="text-align:center">'.$classe_vi ['item'].'</td>';
  2810. echo'<td style="text-align:center">'.$classe_vi ['op6'].'</td>';
  2811. echo'<td style="text-align:center">'.$classe_vi ['total'].'</td>';
  2812. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vi['id']}&tabela=classei' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vi['id']}&tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vi['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2813. echo '</tr>';
  2814. }
  2815.  
  2816. echo "</table>";
  2817.  
  2818. }else{
  2819.  
  2820. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2821. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2822. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2823. echo "<a href='adicionar.php?tabela=classe_vi' class='btn btn-primary btn-xs'>adicionar</a>";
  2824. echo '</div>';
  2825. }
  2826.  
  2827.  
  2828. ?>
  2829. </table>
  2830.  
  2831. <?php
  2832. $sql ="SELECT *, (op6) as total FROM classe_vii";
  2833. $sql = $pdo->query($sql);
  2834. ?>
  2835. <div style="background-color:lime;text-align:center; height:40px; ">
  2836. <h4 style="line-height:40px;">CLVII</h4>
  2837. </div>
  2838. <?php
  2839. if ($sql->rowCount()>0) {
  2840. echo '<table border="1" width="100%" class="table">';
  2841.  
  2842. echo '<tr>';
  2843. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2844. echo'<th style="text-align:center">'.'op6'.'</th>';
  2845. echo'<th style="text-align:center">'.'total'.'</th>';
  2846. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2847. echo '</tr>';
  2848. foreach($sql->fetchAll() as $classe_vii){
  2849. echo '<tr>';
  2850. echo'<td style="text-align:center">'.$classe_vii ['item'].'</td>';
  2851. echo'<td style="text-align:center">'.$classe_vii ['op6'].'</td>';
  2852. echo'<td style="text-align:center">'.$classe_vii ['total'].'</td>';
  2853. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classe_vii['id']}&tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_vii['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2854. echo '</tr>';
  2855.  
  2856. }
  2857.  
  2858. echo "</table>";
  2859.  
  2860. }else{
  2861.  
  2862. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2863. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2864. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2865. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  2866. echo '</div>';
  2867. }
  2868.  
  2869. ?>
  2870. </table>
  2871.  
  2872. <?php
  2873. $sql ="SELECT *, (op6) as total FROM classe_ix";
  2874. $sql = $pdo->query($sql);
  2875. ?>
  2876. <div style="background-color:lime;text-align:center; height:40px; ">
  2877. <h4 style="line-height:40px;">CL IX</h4>
  2878. </div>
  2879. <?php
  2880. if ($sql->rowCount()>0) {
  2881. echo '<table border="1" width="100%" class="table">';
  2882.  
  2883. echo '<tr>';
  2884. echo'<th style="text-align:center">'.'OMDS->'.'</th>';
  2885. echo'<th style="text-align:center">'.'op6'.'</th>';
  2886. echo'<th style="text-align:center">'.'total'.'</th>';
  2887. echo'<th style="text-align:center">'.'Açoes'.'</th>';
  2888. echo '</tr>';
  2889.  
  2890. foreach($sql->fetchAll() as $classe_ix){
  2891. echo '<tr>';
  2892. echo'<td style="text-align:center">'.$classe_ix ['item'].'</td>';
  2893. echo'<td style="text-align:center">'.$classe_ix ['op6'].'</td>';
  2894. echo'<td style="text-align:center">'.$classe_ix ['total'].'</td>';
  2895. echo "<td style='text-align:center'><a href='Editar_valor.php?id={$classe_ix['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>editar</a>-<a href='adicionar.php?id={$classei['id']}&tabela=classe_ix' class='btn btn-primary btn-xs'>adicionar</a>-<a onclick='return myfunction()' href='excluir-item.php?id={$classe_ix['id']}' class='btn btn-primary btn-xs'>excluir</a></td>";
  2896. echo '</tr>';
  2897. }
  2898.  
  2899. echo "</table>";
  2900.  
  2901. }else{
  2902.  
  2903. //percebe o erro? nao tem dados, entao nao tenho id :), pois nao tenho linha, o id no adicionar nao
  2904. //importa, pois seta adicionada uma nova linha e o id na tabela auto incrementada
  2905. echo "<div style='text-align:center; margin-bottom:20px; padding-top:20px;'>";
  2906. echo "<a href='adicionar.php?tabela=classe_vii' class='btn btn-primary btn-xs'>adicionar</a>";
  2907. echo '</div>';
  2908. }
  2909. }
  2910.  
  2911.  
  2912. ?>
  2913. </table>
  2914. </div>
  2915. <script>
  2916. $(".btn-delete").click(function(e){
  2917. e.preventDefault();
  2918.  
  2919. var id = $(this).data("id");
  2920.  
  2921. $("#myModal").modal("show");
  2922. $("#myModal").find("#id_usuario").val(id);
  2923. });
  2924. </script>
  2925. <div class="modal fade" id="myModal" role="dialog">
  2926. <div class="modal-dialog xs">
  2927.  
  2928. <!-- Modal content-->
  2929. <div class="modal-content">
  2930. <div class="modal-header">
  2931. <button type="button" class="close" data-dismiss="modal">&times;</button>
  2932. <h4 class="modal-title">Confirmar exclusão?</h4>
  2933. </div>
  2934. <div class="modal-body">
  2935. <p>Deseja realmente excluir este item?</p>
  2936. </div>
  2937. <div class="modal-footer">
  2938. <form method="POST" action="index.php">
  2939. <input type="hidden" name="id" id="id_usuario" value="">
  2940. <button id="confirm" type="submit" class="btn btn-primary" data-js="deletar">Sim</button>
  2941. <button id="cancel" class="btn btn-default" data-dismiss="modal">N&atilde;o</button>
  2942. </form>
  2943.  
  2944. </div>
  2945. </div>
  2946.  
  2947. </div>
  2948. </div>
  2949.  
  2950. </div>
  2951. <script src="js/main.js"></script>
  2952. </body>
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!