Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.68 KB | None | 0 0
  1. <?php
  2. session_start();
  3. require_once "control.php";
  4. include 'header.php';
  5. ?>
  6.  
  7. <?php
  8. $nev = $_SESSION['nev'];
  9. $sql = "SELECT * FROM jelenleti WHERE nev = '$nev' ORDER BY erkezes DESC LIMIT 1";
  10. $eredmeny = @mysqli_query($dbc, $sql);
  11. //var_dump($eredmeny->fetch_array(MYSQLI_ASSOC));
  12. $eredmeny = $eredmeny->fetch_array(MYSQLI_ASSOC);
  13. //var_dump($eredmeny)
  14. ?>
  15. <body>
  16. <?php include 'nav.php'; ?>
  17. <div id="right-panel" class="right-panel">
  18. <?php include 'statusbar.php'; ?>
  19. <div class="breadcrumbs">
  20. <div class="col-sm-4">
  21. <div class="page-header float-left">
  22. <div class="page-title">
  23. <h1>Jelenléti ív</h1>
  24. </div>
  25. </div>
  26. </div>
  27. <div class="col-sm-8">
  28. <div class="page-header float-right">
  29. <div class="page-title">
  30. <ol class="breadcrumb text-right">
  31. <li class="active">Jelenléti ív</li>
  32. </ol>
  33. </div>
  34. </div>
  35. </div>
  36. </div>
  37. <div class="animated fadeIn">
  38. <div class="row">
  39. <div class="col-xs-12 col-sm-12">
  40. <?php
  41. // Üzenet megjelefsdfsdnítése
  42. if (isset($uzenet)) {
  43. ?>
  44. <div class="alert alert-success">
  45. <p class="text-danger text-center" style="position: relative;top: 0.5em;">
  46. <?php print $uzenet; ?>
  47. </p>
  48. </div>
  49. <?php
  50. }
  51. ?>
  52.  
  53. <div class="alert alert-danger" role="alert">
  54. Eddigi dolgozott órám ma: 1
  55. </div>
  56. </div>
  57. <div class="col-xs-6 col-sm-6">
  58. <form action="" method="post">
  59. <div class="card">
  60. <div class="card-header">
  61. <strong>Munka kezdete</strong>
  62.  
  63. <small name="erkezes" id="erkezes"></small>
  64.  
  65. </div>
  66. <div class="card-body card-block">
  67. <input type="hidden" name="event" id="event" value="érkezés">
  68. <input type="hidden" name="aktiv_gomb" value="1">
  69. <button type="submit" class="btn btn-primary btn-lg btn-block" <?php echo $eredmeny['tavozas']? "" : 'disabled' ?>>Munka kezdete</button>
  70. </div>
  71.  
  72. </div>
  73. </form>
  74. </div>
  75. <div class="col-xs-6 col-sm-6">
  76. <form action="" method="post">
  77. <div class="card">
  78. <div class="card-header">
  79. <strong>Munka vége</strong>
  80. <small> 2019.05.31 12:00:00</small>
  81. </div>
  82. <div class="card-body card-block">
  83. <input type="hidden" name="event" id="event" value="távozás">
  84. <button type="submit" class="btn btn-warning btn-lg btn-block" <?php echo $eredmeny['tavozas']? 'disabled' : "" ?>>Munka befejezése</button>
  85. </div>
  86. </div>
  87. </form>
  88. </div>
  89. <div class="col-xs-12 col-sm-12">
  90. <div class="card">
  91. <div class="card-header">
  92. <strong>Saját jelenléti ív (havi)</strong>
  93. <small>2019.05</small>
  94. </div>
  95. <div class="card-body card-block">
  96. <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
  97. <thead>
  98. <tr>
  99. <th>Név</th>
  100. <th>Munka kezdete</th>
  101. <th>Munka vége</th>
  102. <th>Dolgozott óra</th>
  103. </tr>
  104. </thead>
  105. <tbody>
  106. <?php
  107.  
  108. $record = $dbc->query("SELECT * FROM jelenleti") or die($dbc->error);
  109.  
  110. while ($row = $record->fetch_assoc()) {
  111.  
  112. $strStart = $row['erkezes'];
  113. $strEnd = $row['tavozas'];
  114.  
  115. $dteStart = new DateTime($strStart);
  116. $dteEnd = new DateTime($strEnd);
  117.  
  118. $dteDiff = $dteStart->diff($dteEnd);
  119.  
  120. //print $dteDiff->format("%H:%I:%S");
  121.  
  122. ?>
  123. <tr>
  124. <td>
  125. <?= $row['nev'] ?>
  126. </td>
  127. <td>
  128. <?= $row['erkezes']; ?>
  129. </td>
  130.  
  131. <td>
  132. <?= $row['tavozas']; ?>
  133. </td>
  134. <td>
  135. <?= print $dteDiff->format("%H:%I:%S"); ?>
  136. </td>
  137. </tr>
  138. <?php
  139. }
  140. ?>
  141. </tbody>
  142. </table>
  143. </div>
  144. </div>
  145. </div>
  146. </div>
  147. </div>
  148. </div>
  149. <?php include 'footer.php'; ?>
  150.  
  151. </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement