صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
benjamin.harris
/
modulos_internal
1
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: 0eaa5ab7cd
شاخه‌ها تگ‌ها
modulos_interna...
/
dashboard.php

dashboard.php 10 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164 
  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.         <script src="https://code.jquery.com/jquery-3.3.1.min.js" integrity="sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8=" crossorigin="anonymous"></script>
    31. 

  31.         <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
    32. 

  32.         <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
    33. 

  33.         <script type="text/javascript" src="https://use.fontawesome.com/1e2844bb90.js"></script>
    34. 

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

  35.         <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js" integrity="sha256-T0Vest3yCU7pafRw9r+settMBX6JkKN06dqBnpQ8d30=" crossorigin="anonymous"></script>
    36. 

  36. 

  37.         <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-throttle-debounce/1.1/jquery.ba-throttle-debounce.min.js" integrity="sha512-JZSo0h5TONFYmyLMqp8k4oPhuo6yNk9mHM+FY50aBjpypfofqtEWsAgRDQm94ImLCzSaHeqNvYuD9382CEn2zw==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
    38. 

  38. 

  39.     </head>
    40. 

  40.     <body>
    41. 

  41. 

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

  43.             <div class="container-fluid">
    44. 

  44.                 <a class="navbar-brand brown-light" href="#">
    45. 

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

  46.                     Modulos Design
    47. 

  47.                 </a>
    48. 

  48. 				<div class="ml-auto ms-auto">
    49. 

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

  50.     				<i class="bi bi-plus-circle"></i> Create enquiry
    51. 

  51.   					</a>
    52. 

  52. 				</div>
    53. 

  53.             </div>
    54. 

  54.         </nav>
    55. 

  55. 

  56. 

  57.         <div class="container-fluid">
    58. 

  58.             <div class="row">
    59. 

  59.                 <div class="col px-0">
    60. 

  60.                     <table class="table table-sm">
    61. 

  61.                         <thead class="align-top text-center">
    62. 

  62.                             <tr>
    63. 

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

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

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

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

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

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

  69. 

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

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

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

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

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

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

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

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

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

  79.                                 
    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.                             	<th scope="col" class="align-middle" ></th>
    86. 

  86.                             	<th scope="col" class="align-middle" ></th>
    87. 

  87.                             	<th scope="col" class="align-middle" ></th>
    88. 

  88.                             </tr>
    89. 

  89.                         </thead>
    90. 

  90.                         <tbody>
    91. 

  91.                             <?php
    92. 

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

  93.                             if (!$result) {
    94. 

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

  95.                                 exit();
    96. 

  96.                                 alert("error");
    97. 

  97.                             }
    98. 

  98. 

  99.                             while ($row = mysqli_fetch_array($result)) {
    100. 

  100. 

  101.                             	$drg = floatval($row['drg']);
    102. 

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

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

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

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

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

  107. 

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

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

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

  111. 

  112.                                 echo "<tr class='border-bottom border-dark'>";
    113. 

  113.                                 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>";
    114. 

  114.                                 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>";
    115. 

  115.                                 echo "<td>" . $row['build_type'] . "</td>";
    116. 

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

  117.                                 echo "<td>" . $row['property_id'] . "</td>";
    118. 

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

  119. 

  120.                             	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>";
    121. 

  121.                             	
    122. 

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

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

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

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

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

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

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

  129.                                 echo "<td class='text-center'></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 "<td class=''></td>";
    136. 

  136.                             	echo "<td class=''></td>";
    137. 

  137.                             	echo "<td class=''></td>";
    138. 

  138.                             	echo "<td class=''></td>";
    139. 

  139.                                 echo "</tr>";
    140. 

  140.                             }
    141. 

  141.                             ?>
    142. 

  142. 

  143.                         </tbody>
    144. 

  144.                     </table>
    145. 

  145.                 </div>
    146. 

  146.             </div>
    147. 

  147.         </div>
    148. 

  148. 

  149.         <script type="text/javascript">
    150. 

  150. 

  151.         </script>
    152. 

  152. 

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

  154. <!--
    155. 

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

  156. 

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

  158.         <script src="js/signature.js" ></script>
    159. 

  159. 

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

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

  162. -->
    163. 

  163.     </body>
    164. 

  164. </html>
    165.