Главная Обзор Помощь
Регистрация Вход
benjamin.harris
/
modulos_internal
1
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Дерево: 7840d0af7a
Ветки Метки
modulos_interna...
/
internal
/
dashboard.php

dashboard.php 9.5 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160 
  1. <?php
    2. 

  2. require_once 'connection.php';
    3. 

  3. 

  4. $enquiry_date = date("l dS M \'y");
    5. 

  5. 

  6. $drg = isset($_GET['drg']) ? $_GET['drg'] : '';
    7. 

  7. 

  8. if (!empty($_GET['drg'])) {
    9. 

  9.     include "table.php";
    10. 

  10. }
    11. 

  11. 

  12. $check = "<i class='h2 bi bi-check-circle-fill text-success'></i>";
    13. 

  13. $cross = "<i class='h2 bi bi-x-circle-fill brown-light'></i>";
    14. 

  14. $urgent = "<i class='h2 bi bi-exclamation-circle-fill text-warning'></i>";
    15. 

  15. $not_required = "<i class='h2 bi bi-dash-circle-fill'></i>";
    16. 

  16. 

  17. ?>
    18. 

  18. <!doctype html>
    19. 

  19. <html lang="en">
    20. 

  20.     <head>
    21. 

  21.         <meta charset="utf-8">
    22. 

  22.         <meta name="viewport" content="width=device-width, initial-scale=1">
    23. 

  23.         <title>Dashboard</title>
    24. 

  24.         <link rel="shortcut icon" href="images/blueprint.ico" type="image/x-icon">
    25. 

  25.         <link href="css/bootstrap.css" rel="stylesheet">
    26. 

  26.         <link href="css/blueprint.css" rel="stylesheet">
    27. 

  27.         <link href="css/print.css" rel="stylesheet" media="print">
    28. 

  28. 

  29. 

  30.         <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.13.1/font/bootstrap-icons.min.css">
    31. 

  31.         <script src="https://code.jquery.com/jquery-3.3.1.min.js" integrity="sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8=" crossorigin="anonymous"></script>
    32. 

  32. 

  33.     </head>
    34. 

  34.     <body>
    35. 

  35. 

  36.         <nav class="navbar bg-brown-dark brown-light border-bottom border-body d-print-none" data-bs-theme="dark">
    37. 

  37.             <div class="container-fluid">
    38. 

  38.                 <a class="navbar-brand brown-light" href="dashboard.php">
    39. 

  39.                     <img src="images/blueprint-logo-light.png" alt="Logo" width="30" height="24" class="d-inline-block align-text-top">
    40. 

  40.                     Modulos Design
    41. 

  41.                 </a>
    42. 

  42. 				<div class="ml-auto ms-auto d-flex gap-2">
    43. 

  43.   					<a href="../contracts/admin_dashboard.php" class="btn btn-sm btn-outline-light">
    44. 

  44.     				<i class="bi bi-file-earmark-text-fill"></i> Contracts
    45. 

  45.   					</a>
    46. 

  46.   					<a href="create_enquiry.php" class="btn btn-sm bg-brown-three brown-five">
    47. 

  47.     				<i class="bi bi-plus-circle"></i> Create enquiry
    48. 

  48.   					</a>
    49. 

  49. 				</div>
    50. 

  50.             </div>
    51. 

  51.         </nav>
    52. 

  52. 

  53. 

  54.         <div class="container-fluid">
    55. 

  55.             <div class="row">
    56. 

  56.                 <div class="col px-0">
    57. 

  57.                     <table class="table table-sm">
    58. 

  58.                         <thead class="align-top text-center">
    59. 

  59.                             <tr>
    60. 

  60.                                 <th scope="col" class="align-middle" style="width: 3%;">Drg</th>
    61. 

  61.                                 <th scope="col" class="align-middle" style="width: 15%;" >Client Name</th>
    62. 

  62.                                 <th scope="col" class="align-middle" style="width: 10%;">Build Type</th>
    63. 

  63.                             	<th scope="col" class="align-middle" style="width: 5%;">Site Visit</th>
    64. 

  64.                                 <th scope="col" class="align-middle" style="width: 5%;">PID</th>
    65. 

  65.                                 <th scope="col" class="align-middle" style="width: 5%;">Tite Detail</th>
    66. 

  66. 

  67. 								<th scope="col" class="align-middle" style="width: 5%;">Progress<br><span class="small fw-light">Admin</span></th>
    68. 

  68.                                 <th scope="col" class="align-middle" style="width: 5%;">Title<br><span class="small fw-light">Copy</span></th>
    69. 

  69.                                 <th scope="col" class="align-middle" style="width: 5%;">Original<br><span class="small fw-light">Plans</span></th>
    70. 

  70.                                 <th scope="col" class="align-middle" style="width: 5%;">LOA<br><span class="small fw-light">Signed</span></th>
    71. 

  71.                                 <th scope="col" class="align-middle" style="width: 5%;">DA<br><span class="small fw-light">Application</span></th>
    72. 

  72.                                 <th scope="col" class="align-middle" style="width: 5%;">BA<br><span class="small fw-light">Application</span></th>
    73. 

  73.                                 <th scope="col" class="align-middle" style="width: 5%;">Fire<br><span class="small fw-light">Report</span></th>
    74. 

  74.                                 <th scope="col" class="align-middle" style="width: 5%;">Energy<br><span class="small fw-light">Assesment</span></th>
    75. 

  75.                                 <th scope="col" class="align-middle" style="width: 5%;"></th>
    76. 

  76.                                 
    77. 

  77.                             	<th scope="col" class="align-middle" ></th>
    78. 

  78.                             	<th scope="col" class="align-middle" ></th>
    79. 

  79.                             	<th scope="col" class="align-middle" ></th>
    80. 

  80.                             	<th scope="col" class="align-middle" ></th>
    81. 

  81.                             	<th scope="col" class="align-middle" ></th>
    82. 

  82.                             	<th scope="col" class="align-middle" ></th>
    83. 

  83.                             	<th scope="col" class="align-middle" ></th>
    84. 

  84.                             	<th scope="col" class="align-middle" ></th>
    85. 

  85.                             </tr>
    86. 

  86.                         </thead>
    87. 

  87.                         <tbody>
    88. 

  88.                             <?php
    89. 

  89.                             $result = mysqli_query($con, " SELECT * FROM `details` JOIN `addresses` ON `details`.`drg` = `addresses`.`drg` ORDER BY `details`.`drg` DESC ");
    90. 

  90.                             if (!$result) {
    91. 

  91.                                 printf("Error: %s\n", mysqli_error($con));
    92. 

  92.                                 exit();
    93. 

  93.                             }
    94. 

  94. 

  95.                             while ($row = mysqli_fetch_array($result)) {
    96. 

  96. 

  97.                             	$drg = (int)$row['drg'];
    98. 

  98.                                 if ( $row['copy_title'] === '1') { $title = "$check"; } else { $title = "$cross"; }
    99. 

  99.                                 if ( $row['original_plans'] === '1') { $original_plans = "$check"; } else { $original_plans = "$cross"; }
    100. 

  100.                                 if ( $row['loa_signed'] === '1') { $loa_signed = "$check"; } else { $loa_signed = "$cross"; }
    101. 

  101.                                 if ( $row['da_application'] === '1') { $da_application = "$check"; } else { $da_application = "$cross"; }
    102. 

  102.                                 if ( $row['ba_application'] === '1') { $ba_application = "$check"; } else { $ba_application = "$cross"; }
    103. 

  103. 

  104.                                 if ( $row['fire_report'] === '1') { $fire_report = "$check"; } else { $fire_report = "$cross"; }
    105. 

  105.                                 if ( $row['energy_report'] === '1') { $energy_report = "$check"; } else { $energy_report = "$cross"; }
    106. 

  106.                             	if ( $row['site_visit'] === '1') { $site_visit = "$check"; } else { $site_visit = "$cross"; }
    107. 

  107. 

  108.                                 echo "<tr class='border-bottom border-dark'>";
    109. 

  109.                                 echo "<th scope='row' class='border-end text-center'><a class='brown-three text-decoration-none' href='client-brief.php?drg=$drg'>" . $drg . "</a></th>";
    110. 

  110.                                 echo "<td><span class='fw-bold'>" . $row['firstname'] . " " . $row['lastname'] . '</span><br><span class="small">' . $row['site_address_street'] . ', ' . $row['site_address_town'] . "</span></td>";
    111. 

  111.                                 echo "<td>" . $row['build_type'] . "</td>";
    112. 

  112.                             	echo "<td class='text-center'>" . $site_visit . "</td>";
    113. 

  113.                                 echo "<td>" . $row['property_id'] . "</td>";
    114. 

  114.                                 echo "<td class='border-end' >" . $row['title_id'] . "</td>";
    115. 

  115. 

  116.                             	echo "<td class='text-center'><a class='brown-three text-decoration-none' href='../contracts/edit_application.php?id=$drg'><i class='h2 bi bi-speedometer'></i></a></td>";
    117. 

  117.                             	
    118. 

  118.                                 echo "<td class='text-center'>" . $title . "</td>";
    119. 

  119.                                 echo "<td class='text-center'>" . $original_plans . "</td>";
    120. 

  120.                                 echo "<td class='text-center'>" . $loa_signed . "</td>";
    121. 

  121.                                 echo "<td class='text-center'>" . $da_application . "</td>";
    122. 

  122.                                 echo "<td class='text-center border-end'>" . $ba_application . "</td>";
    123. 

  123.                                 echo "<td class='text-center'>" . $fire_report . "</td>";
    124. 

  124.                                 echo "<td class='text-center'>" . $energy_report . "</td>";
    125. 

  125.                                 echo "<td class='text-center'></td>";
    126. 

  126.                                 echo "<td class=''></td>";
    127. 

  127.                             	echo "<td class=''></td>";
    128. 

  128.                             	echo "<td class=''></td>";
    129. 

  129.                             	echo "<td class=''></td>";
    130. 

  130.                             	echo "<td class=''></td>";
    131. 

  131.                             	echo "<td class=''></td>";
    132. 

  132.                             	echo "<td class=''></td>";
    133. 

  133.                             	echo "<td class=''></td>";
    134. 

  134.                             	echo "<td class=''></td>";
    135. 

  135.                                 echo "</tr>";
    136. 

  136.                             }
    137. 

  137.                             ?>
    138. 

  138. 

  139.                         </tbody>
    140. 

  140.                     </table>
    141. 

  141.                 </div>
    142. 

  142.             </div>
    143. 

  143.         </div>
    144. 

  144. 

  145.         <script type="text/javascript">
    146. 

  146. 

  147.         </script>
    148. 

  148. 

  149.         <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.1/dist/js/bootstrap.bundle.min.js" integrity="sha384-HwwvtgBNo3bZJJLYd8oVXjrBZt8cqVSpeBNS5n7C8IVInixGAoxmnlMuBnhbgrkm" crossorigin="anonymous"></script>
    150. 

  150. <!--
    151. 

  151.     	<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyB-QceOYrDe9otynMmQ9iNF3yEZzbpsanM&libraries=places&callback=initAutocomplete" async defer></script>
    152. 

  152. 

  153.         <script src="https://cdn.jsdelivr.net/npm/signature_pad@4.0.0/dist/signature_pad.umd.min.js"></script>
    154. 

  154.         <script src="js/signature.js" ></script>
    155. 

  155. 

  156.         <script async defer src="https://apis.google.com/js/api.js" onload="gapiLoaded()"></script>
    157. 

  157.         <script async defer src="https://accounts.google.com/gsi/client" onload="gisLoaded()"></script>
    158. 

  158. -->
    159. 

  159.     </body>
    160. 

  160. </html>
    161.