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

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

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158 
  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="#">
    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">
    43. 

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

  44.     				<i class="bi bi-plus-circle"></i> Create enquiry
    45. 

  45.   					</a>
    46. 

  46. 				</div>
    47. 

  47.             </div>
    48. 

  48.         </nav>
    49. 

  49. 

  50. 

  51.         <div class="container-fluid">
    52. 

  52.             <div class="row">
    53. 

  53.                 <div class="col px-0">
    54. 

  54.                     <table class="table table-sm">
    55. 

  55.                         <thead class="align-top text-center">
    56. 

  56.                             <tr>
    57. 

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

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

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

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

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

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

  63. 

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

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

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

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

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

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

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

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

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

  73.                                 
    74. 

  74.                             	<th scope="col" class="align-middle" ></th>
    75. 

  75.                             	<th scope="col" class="align-middle" ></th>
    76. 

  76.                             	<th scope="col" class="align-middle" ></th>
    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.                             </tr>
    83. 

  83.                         </thead>
    84. 

  84.                         <tbody>
    85. 

  85.                             <?php
    86. 

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

  87.                             if (!$result) {
    88. 

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

  89.                                 exit();
    90. 

  90.                                 alert("error");
    91. 

  91.                             }
    92. 

  92. 

  93.                             while ($row = mysqli_fetch_array($result)) {
    94. 

  94. 

  95.                             	$drg = floatval($row['drg']);
    96. 

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

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

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

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

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

  101. 

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

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

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

  105. 

  106.                                 echo "<tr class='border-bottom border-dark'>";
    107. 

  107.                                 echo "<th scope='row' class='border-end text-center'><a class='brown-three text-decoration-none' href='https://modulosdesign.com.au/internal/client-brief.php?drg=$drg'>" . $drg . "</a></th>";
    108. 

  108.                                 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>";
    109. 

  109.                                 echo "<td>" . $row['build_type'] . "</td>";
    110. 

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

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

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

  113. 

  114.                             	echo "<td class='text-center'><a class='brown-three text-decoration-none' href='https://modulosdesign.com.au/contracts/edit_application.php?id=$drg'><i class='h2 bi bi-speedometer'></i></a></td>";
    115. 

  115.                             	
    116. 

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

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

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

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

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

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

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

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

  124.                                 echo "<td class=''></td>";
    125. 

  125.                             	echo "<td class=''></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 "</tr>";
    134. 

  134.                             }
    135. 

  135.                             ?>
    136. 

  136. 

  137.                         </tbody>
    138. 

  138.                     </table>
    139. 

  139.                 </div>
    140. 

  140.             </div>
    141. 

  141.         </div>
    142. 

  142. 

  143.         <script type="text/javascript">
    144. 

  144. 

  145.         </script>
    146. 

  146. 

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

  148. <!--
    149. 

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

  150. 

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

  152.         <script src="js/signature.js" ></script>
    153. 

  153. 

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

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

  156. -->
    157. 

  157.     </body>
    158. 

  158. </html>
    159.