PageRenderTime 26ms CodeModel.GetById 19ms RepoModel.GetById 0ms app.codeStats 0ms

/application/modules/schedule_group_movement/views/print_view_excel.php

https://bitbucket.org/bo_hmb/bo_hmb
PHP | 238 lines | 210 code | 25 blank | 3 comment | 0 complexity | a072d371764b53c1330f13f182daa3b1 MD5 | raw file
Possible License(s): Apache-2.0, MIT, LGPL-2.1, MPL-2.0-no-copyleft-exception, GPL-2.0 
    

  1. <?php
    2. 

  2. 

  3. header("Content-type: application/vnd-ms-excel");
    4. 

  4.  
    5. 

  5. // Mendefinisikan nama file ekspor "hasil-export.xls"
    6. 

  6. header("Content-Disposition: attachment; filename=Group_Movement.xls");
    7. 

  7. ?>
    8. 

  8. <!DOCTYPE html>
    9. 

  9. <html>
    10. 

  10. <head>
    11. 

  11. <link rel="shortcut icon" href="<?php echo base_url() ?>assets/img/logo.png" /> 
    12. 

  12.   
    13. 

  13. <title>GROUP MOVEMENT</title>
    14. 

  14.   
    15. 

  15.     <style>
    16. 

  16.       
    17. 

  17.         table{
    18. 

  18.               
    19. 

  19.         border-collapse: collapse;
    20. 

  20.               
    21. 

  21.         /*width: 100%;*/
    22. 

  22.               
    23. 

  23.         /*margin: 0 auto;*/
    24. 

  24.           
    25. 

  25.         }
    26. 

  26.           
    27. 

  27.         table th{
    28. 

  28.               
    29. 

  29.         border:1px solid #000;
    30. 

  30.               
    31. 

  31.         font-weight: bold;
    32. 

  32.               
    33. 

  33.         text-align: center;
    34. 

  34.         font-size: 12px;
    35. 

  35.           
    36. 

  36.         }
    37. 

  37.           
    38. 

  38.         table td{
    39. 

  39.               
    40. 

  40.         border:0px solid #000;
    41. 

  41.               
    42. 

  42.         padding: 3px;
    43. 

  43.         font-size: 13px;
    44. 

  44.               
    45. 

  45.         vertical-align: top;
    46. 

  46.           
    47. 

  47.         }
    48. 

  48.     </style>
    49. 

  49. </head>
    50. 

  50. <body>
    51. 

  51. <!-- kop -->
    52. 

  52. <table>    
    53. 

  53.     <tr>           
    54. 

  54.         <th style="border:0px solid #000;"><img src="<?php echo base_url() ?>assets/img/logokop.png" class="img-responsive" alt="" height="50" width="50"></th>
    55. 

  55.         <th style="border:0px solid #000; width: 300PX"></th>
    56. 

  56.         <th style="border:0px solid #000; width: 500PX"> 
    57. 

  57.             <h1 style="text-align: center; font-weight: bold;">GROUP MOVEMENT</h1>
    58. 

  58.         </th>
    59. 

  59.     </tr>
    60. 

  60. </table>
    61. 

  61. <br>
    62. 

  62. <table>
    63. 

  63.     <tr>
    64. 

  64.        <td >
    65. 

  65.         <table>
    66. 

  66.             <tr>
    67. 

  67.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    68. 

  68.                     <h5>Tour Code</h5>
    69. 

  69.                 </td>
    70. 

  70.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    71. 

  71.                     <h5>:</h5>
    72. 

  72.                 </td>
    73. 

  73.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    74. 

  74.                     <h5><?php echo $master->tour_code;?></h5>
    75. 

  75.                 </td>
    76. 

  76.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"></td>
    77. 

  77.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    78. 

  78.                     <h5>Hotel Makkah</h5>
    79. 

  79.                 </td>
    80. 

  80.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    81. 

  81.                     <h5>:</h5>
    82. 

  82.                 </td>
    83. 

  83.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    84. 

  84.                     <h5><?php echo $hotel_makkah->hotel;?></h5>
    85. 

  85.                 </td>
    86. 

  86.             </tr>
    87. 

  87.             <tr>
    88. 

  88.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    89. 

  89.                     <h5>Arrival Date</h5>
    90. 

  90.                 </td>
    91. 

  91.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    92. 

  92.                     <h5>:</h5>
    93. 

  93.                 </td>
    94. 

  94.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    95. 

  95.                     <h5><?php echo date('d-m-Y  H:m:d', strtotime($master->arrival_date));?></h5>
    96. 

  96.                 </td>
    97. 

  97.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"></td>
    98. 

  98.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    99. 

  99.                     <h5>Hotel Madinah</h5>
    100. 

  100.                 </td>
    101. 

  101.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    102. 

  102.                     <h5>:</h5>
    103. 

  103.                 </td>
    104. 

  104.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    105. 

  105.                     <h5><?php echo $hotel_madinah->hotel;;?></h5>
    106. 

  106.                 </td>
    107. 

  107.                 
    108. 

  108.             </tr>
    109. 

  109.             <tr>
    110. 

  110.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    111. 

  111.                     <h5>Derpature Date</h5>
    112. 

  112.                 </td>
    113. 

  113.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    114. 

  114.                     <h5>:</h5>
    115. 

  115.                 </td>
    116. 

  116.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    117. 

  117.                     <h5><?php echo $master->departure_date;?></h5>
    118. 

  118.                 </td>
    119. 

  119.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"></td>
    120. 

  120.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    121. 

  121.                     <h5>Land Transport</h5>
    122. 

  122.                 </td>
    123. 

  123.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    124. 

  124.                     <h5>:</h5>
    125. 

  125.                 </td>
    126. 

  126.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    127. 

  127.                     <h5><?php echo $master->land_transport;?></h5>
    128. 

  128.                 </td>
    129. 

  129.             </tr>
    130. 

  130.             <tr>
    131. 

  131.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    132. 

  132.                     <h5>Carrier</h5>
    133. 

  133.                 </td>
    134. 

  134.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    135. 

  135.                     <h5>:</h5>
    136. 

  136.                 </td>
    137. 

  137.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    138. 

  138.                     <h5><?php echo $master->carrier;?></h5>
    139. 

  139.                 </td>
    140. 

  140.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"></td>
    141. 

  141.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    142. 

  142.                     <h5>Total Passengger</h5>
    143. 

  143.                 </td>
    144. 

  144.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    145. 

  145.                     <h5>:</h5>
    146. 

  146.                 </td>
    147. 

  147.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    148. 

  148.                     <h5><?php echo $master->total_passengers;?></h5>
    149. 

  149.                 </td>
    150. 

  150.             </tr>
    151. 

  151.             <tr>
    152. 

  152.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    153. 

  153.                     <h5>Person In Charge</h5>
    154. 

  154.                 </td>
    155. 

  155.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    156. 

  156.                     <h5>:</h5>
    157. 

  157.                 </td>
    158. 

  158.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    159. 

  159.                     <h5><?php echo $master->person_in_charge;?></h5>
    160. 

  160.                 </td>
    161. 

  161.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"></td>
    162. 

  162.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    163. 

  163.                     <h5>Guide Request</h5>
    164. 

  164.                 </td>
    165. 

  165.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    166. 

  166.                     <h5>:</h5>
    167. 

  167.                 </td>
    168. 

  168.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    169. 

  169.                     <h5><?php echo $master->guide_request;?></h5>
    170. 

  170.                 </td>
    171. 

  171.             </tr>
    172. 

  172.             <tr>
    173. 

  173.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    174. 

  174.                     <h5>Contac No.</h5>
    175. 

  175.                 </td>
    176. 

  176.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    177. 

  177.                     <h5>:</h5>
    178. 

  178.                 </td>
    179. 

  179.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    180. 

  180.                     <h5><?php echo $master->contact_no;?></h5>
    181. 

  181.                 </td>
    182. 

  182.                 
    183. 

  183.             </tr>
    184. 

  184.             <tr>
    185. 

  185.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    186. 

  186.                     <h5>Email Address</h5>
    187. 

  187.                 </td>
    188. 

  188.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    189. 

  189.                     <h5>:</h5>
    190. 

  190.                 </td>
    191. 

  191.                 <td style="border:0px solid #000;width: 150px;font-size: 14px;"> 
    192. 

  192.                     <h5><?php echo $master->email_addres;?></h5>
    193. 

  193.                 </td>
    194. 

  194.                 
    195. 

  195.             </tr>
    196. 

  196.         </table>
    197. 

  197.       </th>
    198. 

  198.     </tr>
    199. 

  199. </table>
    200. 

  200. <!-- N Kop -->
    201. 

  201. <br>
    202. 

  202. <table>    
    203. 

  203.     <tr>           
    204. 

  204.         <th style="width: 20px;">No</th>
    205. 

  205.         <th style="width: 70px;">Date</th>
    206. 

  206.         <th style="width: 100px;">Route</th>
    207. 

  207.         <th style="width: 200px;">Program</th>
    208. 

  208.         <th style="width: 90px;">Time</th>
    209. 

  209.         <th style="width: 130px;">Transportation</th>
    210. 

  210.         <th style="width: 280px;">Hotel Name</th>
    211. 

  211.         <th style="width: 150px;">Check In</th>
    212. 

  212.         <th style="width: 150px;">Check Out</th>
    213. 

  213.         <th style="width: 150px;">Meals Program</th>
    214. 

  214.     </tr>
    215. 

  215. 

  216.     <?php $nomor=1; foreach($detail as $row) { 
    217. 

  217.         ?>
    218. 

  218. 

  219.         <tr>                                                
    220. 

  220.            <td style="border:1px solid #000;text-align: center;"><?php echo $nomor ?></td>
    221. 

  221.            <td style="border:1px solid #000;"><?php echo $row->dat ?></td>
    222. 

  222.            <td style="border:1px solid #000;"><?php echo $row->route ?></td>
    223. 

  223.            <td style="border:1px solid #000;"><?php echo $row->program ?></td>
    224. 

  224.            <td style="border:1px solid #000;"><?php echo $row->tim?></td>
    225. 

  225.            <td style="border:1px solid #000;"><?php echo $row->transportation ?></td>
    226. 

  226.            <?php $hotel = $this->M_schedule->hotel($row->id_hotel); ?>
    227. 

  227.            <td style="border:1px solid #000;"><?php echo $hotel->hotel ?></td>
    228. 

  228.            <td style="border:1px solid #000;"><?php echo $row->check_in ?></td>
    229. 

  229.            <td style="border:1px solid #000;"><?php echo $row->check_out ?></td>
    230. 

  230.            <td style="border:1px solid #000;"><?php echo $row->meals_program ?></td>  
    231. 

  231.            <!-- <td style="border:1px solid #000;"><?php echo date('d-m-Y', strtotime($row->exp_pasport))?></td> -->
    232. 

  232.            <!-- <td style="border:1px solid #000;"></td>       -->
    233. 

  233.         </tr>   
    234. 

  234.     <?php $nomor++;}?> 
    235. 

  235. </table>
    236. 

  236. 

  237. </body>
    238. 

  238. </html>
    239.