PageRenderTime 44ms CodeModel.GetById 16ms RepoModel.GetById 1ms app.codeStats 0ms

/sales-breakdown.php

https://bitbucket.org/OverSite/capstone-demo
PHP | 176 lines | 131 code | 16 blank | 29 comment | 0 complexity | 00e2609581de16f6b6fbec06fac3fe87 MD5 | raw file
Possible License(s): MPL-2.0-no-copyleft-exception, MIT, LGPL-2.1, Apache-2.0 
    

  1. <?php
    2. 

  2. session_start();
    3. 

  3. 

  4. require 'databaseConnection.php';
    5. 

  5. 

  6. $dbConn = getConnection();
    7. 

  7. $sql = "SELECT * FROM commInfo";
    8. 

  8. $stmt = $dbConn->prepare($sql);
    9. 

  9. $stmt->execute();
    10. 

  10. $result = $stmt->fetchAll();
    11. 

  11. ?>
    12. 

  12. 

  13. <!DOCTYPE html>
    14. 

  14. <html>
    15. 

  15. 

  16. <head>
    17. 

  17.     <meta charset="utf-8">
    18. 

  18.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
    19. 

  19.     <title>RE/MAX Salinas | Sales Breakdown</title>
    20. 

  20. 

  21.     <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
    22. 

  22.     <!-- BEGIN TEMPLATE default-css.php INCLUDE -->
    23. 

  23.     <?php include "./templates-admin/default-css.php" ?>
    24. 

  24.     <!-- END TEMPLATE default-css.php INCLUDE -->
    25. 

  25.     <!-- PAGE-SPECIFIC CSS -->
    26. 

  26.     <link rel="stylesheet" href="dist/css/vendor/footable.bootstrap.min.css">
    27. 

  27. </head>
    28. 

  28. 

  29. <body class="hold-transition skin-black sidebar-mini">
    30. 

  30. <!-- Site Wrapper -->
    31. 

  31. <div class="wrapper">
    32. 

  32.     <!-- BEGIN TEMPLATE header.php INCLUDE -->
    33. 

  33.     <?php include "./templates-admin/header.php" ?>
    34. 

  34.     <!-- END TEMPLATE header.php INCLUDE -->
    35. 

  35. 

  36.     <!-- BEGIN TEMPLATE nav.php INCLUDE -->
    37. 

  37.     <?php include "./templates-admin/nav.php" ?>
    38. 

  38.     <!-- END TEMPLATE nav.php INCLUDE -->
    39. 

  39. 

  40.     <!-- Content Wrapper -->
    41. 

  41.     <div class="content-wrapper">
    42. 

  42.         <!-- Content Header (Page header) -->
    43. 

  43.         <section class="content-header">
    44. 

  44.             <h1>
    45. 

  45.                 Sales Breakdown
    46. 

  46.             </h1>
    47. 

  47.             <ol class="breadcrumb">
    48. 

  48.                 <li>Transactions</li>
    49. 

  49.                 <li class="active"><a href="#"><i class="fa fa-archive"></i> Sales Breakdown</a></li>
    50. 

  50.             </ol>
    51. 

  51.         </section>
    52. 

  52.         <!-- Main content -->
    53. 

  53.         <section class="content">
    54. 

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

  55.                 <div class="col-xs-12">
    56. 

  56.                     <div class="box">
    57. 

  57.                         <div class="box-body">
    58. 

  58.                             <table class="table table-bordered table-striped" data-filtering="true">
    59. 

  59.                                 <thead>
    60. 

  60.                                 <tr>
    61. 

  61.                                     <th>Date Settled</th>
    62. 

  62.                                     <th>Property Address</th>
    63. 

  63.                                     <th>Agent</th>
    64. 

  64.                                     <th>Total</th>
    65. 

  65.                                     <th data-breakpoints="all">Office</th>
    66. 

  66.                                     <th data-breakpoints="all">E&O <a href="#" data-toggle="tooltip"
    67. 

  67.                                                                       data-placement="top" title="Errors & Omissions"><i
    68. 

  68.                                                     class="fa fa-question-circle"></i></a></th>
    69. 

  69.                                     <th data-breakpoints="all">Tech Fee</th>
    70. 

  70.                                     <th data-breakpoints="all">Processing</th>
    71. 

  71.                                     <th data-breakpoints="all">RE/MAX FF</th>
    72. 

  72.                                     <th data-breakpoints="all">Misc</th>
    73. 

  73.                                     <th>Commission</th>
    74. 

  74.                                     <th data-breakpoints="all">Client</th>
    75. 

  75.                                     <th>Price</th>
    76. 

  76.                                     <th>Listing/Buyer</th>
    77. 

  77.                                     <th data-breakpoints="all">Notes</th>
    78. 

  78.                                     <th data-breakpoints="all">Commission Sheet</th>
    79. 

  79.                                 </tr>
    80. 

  80.                                 </thead>
    81. 

  81.                                 <tbody>
    82. 

  82.                                 <?php
    83. 

  83.                                 foreach ($result as $sales) {
    84. 

  84.                                     echo "<tr>";
    85. 

  85.                                     echo "<td>" . date("m-d-Y", strtotime($sales['settlementDate'])) . "</td>";
    86. 

  86.                                     echo "<td>" . $sales['address'] . "</td>";
    87. 

  87.                                     echo "<td>" . $sales['firstName'] . " " . $sales['lastName'] . "</td>";
    88. 

  88.                                     echo "<td>" . '$' . number_format($sales['InitialGross'], 0) . "</td>"; //Total
    89. 

  89.                                     echo "<td>" . '$' . number_format($sales['brokerFee'], 0) . "</td>"; //office
    90. 

  90.                                     echo "<td>" . '$99.00' . "</td>"; //eo
    91. 

  91.                                     echo "<td>" . '$50.00' . "</td>"; //tech
    92. 

  92.                                     echo "<td>" . '$200.00' . "</td>"; //processing
    93. 

  93.                                     echo "<td>" . '$' . number_format($sales['remaxFee'], 0) . "</td>"; //remax_ff
    94. 

  94.                                     echo "<td>" . '$' . number_format($sales['misc'], 0) . "</td>"; //misc
    95. 

  95.                                     echo "<td>" . '$' . number_format($sales['finalComm'], 0) . "</td>"; //commission
    96. 

  96.                                     echo "<td>" . $sales['clients'] . "</td>"; //client
    97. 

  97.                                     echo "<td>" . '$' . number_format($sales['finalHousePrice'], 0) . "</td>"; //price
    98. 

  98.                                     echo "<td>" . $sales['clients'] . "</td>"; //listing buyer
    99. 

  99.                                     echo "<td>" . $sales['notes'] . "</td>"; //notes
    100. 

  100.                                     echo '<td> <a href="viewCommissionSheet.php?comm=' . $sales['commId'] . '" target="_blank"> <button>View Commission Sheet</button> </a> </td>';
    101. 

  101.                                     echo "</tr>";
    102. 

  102.                                 }
    103. 

  103.                                 ?>
    104. 

  104. 

  105.                                 <?php
    106. 

  106.                                 //                                                $dbConn = getConnection();
    107. 

  107.                                 //
    108. 

  108.                                 //                                                $sql = "SELECT status, houseId, date(dateTimes) as dateTimes, address, city, state, zip, bedrooms, bathrooms, price
    109. 

  109.                                 //                                                            FROM HouseInfo
    110. 

  110.                                 //                                                            WHERE userId = :userId
    111. 

  111.                                 //                                                            ORDER BY dateTimes ASC";
    112. 

  112.                                 //
    113. 

  113.                                 //                                                //$namedParameters = array();
    114. 

  114.                                 //                                                //$namedParameters[':userId'] = $_SESSION['userId'];
    115. 

  115.                                 //                                                //$stmt = $dbConn -> prepare($sql);
    116. 

  116.                                 //                                                /*$stmt->execute($namedParameters);
    117. 

  117.                                 //                                                //$stmt->execute();
    118. 

  118.                                 //                                                $results = $stmt->fetchAll();
    119. 

  119.                                 //
    120. 

  120.                                 //                                                foreach($results as $result){
    121. 

  121.                                 //                                                    echo "<tr>";
    122. 

  122.                                 //                                                    echo "<td>" . $result['houseId'] . "</td>";
    123. 

  123.                                 //                                                    echo "<td>" . $result['address'] . "</td>";
    124. 

  124.                                 //                                                    echo "<td>King</td>";
    125. 

  125.                                 //                                                    echo "<td>Mali</td>";
    126. 

  126.                                 //                                                    echo "<td>4083488336</td>":
    127. 

  127.                                 //                                                    echo "<td>5/6/17</td>";
    128. 

  128.                                 //                                                    echo "<td>5/9/17</td>";
    129. 

  129.                                 //                                                    echo "<td>5/12/17</td>";
    130. 

  130.                                 //                                                    echo "<td>5/12/17</td>";
    131. 

  131.                                 //                                                    echo "<td>5/12/17</td>";
    132. 

  132.                                 //                                                    echo "<td>Notes</td>";
    133. 

  133.                                 //                                                    echo "</tr>";
    134. 

  134.                                 //                                                } //closes foreach*/
    135. 

  135.                                 ?>
    136. 

  136. 

  137.                                 </tbody>
    138. 

  138.                             </table>
    139. 

  139.                         </div>
    140. 

  140.                         <!-- /.box-body -->
    141. 

  141.                     </div>
    142. 

  142.                     <!-- /.box -->
    143. 

  143.                 </div>
    144. 

  144.                 <!-- /.col -->
    145. 

  145.             </div>
    146. 

  146.             <!-- /.row -->
    147. 

  147.         </section>
    148. 

  148.         <!-- /.content -->
    149. 

  149.     </div>
    150. 

  150.     <!-- /.content-wrapper -->
    151. 

  151. </div>
    152. 

  152. <!-- /.wrapper -->
    153. 

  153. 

  154. 

  155. <!-- BEGIN TEMPLATE default-footer.php INCLUDE -->
    156. 

  156. <?php include "./templates-admin/default-footer.php" ?>
    157. 

  157. <!-- END TEMPLATE default-footer.php INCLUDE -->
    158. 

  158. 

  159. <!-- Sidebar Background -->
    160. 

  160. <div class="control-sidebar-bg">
    161. 

  161. </div>
    162. 

  162. <!-- BEGIN TEMPLATE default-js.php INCLUDE -->
    163. 

  163. <?php include "./templates-admin/default-js.php" ?>
    164. 

  164. <!-- END TEMPLATE default-js.php INCLUDE -->
    165. 

  165. 

  166. <!-- PAGE-SPECIFIC JS -->
    167. 

  167. <script src="dist/js/vendor/footable.min.js"></script>
    168. 

  168. 

  169. <script>
    170. 

  170.     jQuery(function ($) {
    171. 

  171.         $('.table').footable();
    172. 

  172.     });
    173. 

  173. </script>
    174. 

  174. </body>
    175. 

  175. 

  176. </html>
    177. 

  177.